Home

Rashmi Jakkani - Data Analyst

[email protected]

Location: Mc Kinney, Texas, USA

Relocation: YES

Visa: OPT

RASHMI JAKKANI 571 595 3159 [email protected]| LinkedIn Rashmi Jakkani Summary: Highly skilled and results-driven Data Analyst with over 5 years of experience in analyzing complex datasets, generating actionable insights, and driving data-driven decision-making. Gathered data through Web Scraping and Data Cleansing by business requirements. Expert in creating multiple kinds of Power BI Reports, Dashboards, and Visualizations. Experienced in data modeling, data cleansing, data analysis, data visualization, data management, data architecture, data extraction, data warehousing, data governance, data structures, data definition language, algorithms, and statistical analysis. Extract and analyze data using Power Query, SharePoint, PivotTables, MS Office, Macros, and MS Excel. Expertise in utilizing various tools and technologies, including SQL, Python, Excel, Tableau, and Power BI, to extract, manipulate, and visualize data. Conducted closely with data modelers to analyze data requirements and create accurate data models, contributing to the development of robust database structures. Develop strategies for effective data analysis and reporting including Data Modelling and governance. Collaborative team player with a track record of effectively communicating findings and recommendations to diverse audiences, including executives and technical teams. Expertise in Using Microsoft SQL Server to model datasets into datasets for Business Intelligence software. Coordinated and managed Data Definition language deployments, ensuring seamless integration and alignment with project timelines. Worked with Data Engineering, Data Management, Data Science, Equity, and Data Governance Teams. Responsible for defining the scope and implementing business rules of the project gathering business requirements and documentation. Experience in SQL and PL/SQL for developing Procedures, Functions, Packages, and Triggers. Strong Problem-Solving skills and attention to detail, coupled with a results-oriented mindset to drive continuous improvement and achieve organizational goals. Effectively managed multiple projects simultaneously, maintaining attention to detail without losing sight of the broader objectives. Adaptable and quick to learn new technologies and methodologies, passionate about staying updated on industry trends and best practices in data analysis and business intelligence. TECHNICAL SKILLS Databases SQL Server 2014/2012/2008/2008R2/2005, Oracle 8i/9i/10g/11g,12c Database Languages MySQL, NoSQL, Postgres, Oracle SQL, DB2, MongoDB, SQL Server, PL/SQL Programming Languages Python, C++, Hive, HTML Tools Tableau, Microsoft Power BI, SAS, Rapid Miner, SPSS, Git, GitHub, AWS, JSON, XML Browsers Mozilla Firefox, Internet Explorer, Safari, Google Chrome, Opera Applications Microsoft Office, Excel, PowerPoint, Outlook, MS Visio, MS Office Suite, VBA Operating Systems Windows Server 2000/2003/2008/2012, Windows [ ], Unix, Linux, Ubuntu, Mac OS EDUCATION: M.S. in Data Science from University of North Texas, Denton, Texas, U.S - May 2023 B Tech in Electronics and Communications Engineering from JNTU, Hyderabad, India -May 2017 CERTIFICATIONS Google Data Analytics Certification Issued by Coursera Credential ID: G6ZFCA78KNV3 The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert Issued by Udemy - Credential ID: UC- 0f496019-3d67-435a-aa19-15a2e0618243. EXPERIENCE: Optum HealthCare, Remote Aug 2023 - Present Data Analyst Responsibilities: Identified, analysed, and interpreted trends or patterns in sophisticated data sets using statistical techniques and providing ongoing reports and dashboards and developed applications using Python, and SQL for data extraction, cleansing, and transformation. Worked on report conversion and Relational Databases, Designing Tables, Complex Joins, and Nested Queries. Assisted in collecting, cleaning, and organizing datasets for analysis, ensuring data accuracy and integrity. Organized and maintained SharePoint sites for efficient collaboration and document management, enhancing team productivity. Utilized technical programming skills in SQL and Python to write complex queries, perform data extraction, and generate insightful reports for data analysis. Applied SQL and Visualization skills to create reports that show the output of the analysis. Supported senior analysts in developing predictive models and statistical analyses to drive business growth and made Power BI dashboards available to Web clients and mobile apps. Worked with JSON and XML formats for data interchange and storage, enhancing data compatibility and integration capabilities. Developed and executed complex SQL queries for data extraction, transformation, and analysis across various database platforms, including SQL Server and Postgres. Facilitated large group meetings and documented outputs to ensure effective team communication and alignment with Cross-Functional, Cross-Cultural, and Cross-Disciplinary teams. Communicated complex data findings clearly and precisely to stakeholders through reports, presentations, and documentation, facilitating informed decision-making. Demonstrated ability in using Tableau for data mining, analytics, reporting, and visualization. Environment: Python, My SQL Server 2016, Postgres, MS Excel, Tableau, JSON, XML, Data modeling, Data structure, Data Modelling, Data visualization, SharePoint, MS Office Suite Amazon Development Centre India Pvt Ltd, Hyderabad, India Sep 2020 July 2021 Data Analyst Responsibilities: Responsible for managing and auditing delivery process systems in Amazon fulfillment centers using CRUD. operations. Prepared comprehensive documentation, presentations, charts, tables, and diagrams for project deliverables. Worked on SQL queries in dimensional data warehouses and relational data warehouses. Performed Data Analysis and Data Profiling using Complex SQL queries on various systems. Visualization techniques were used to provide insights into job performance using Power BI. Created and managed schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements. Developed and maintained comprehensive MS Office documentation, including reports, manuals, and project summaries, to support data modeling and analysis efforts. Created SQL Objects like Stored procedures, and user-defined functions using Oracle PL/SQL and SQL Server 2014. Utilized advanced features of the Microsoft Office Suite, including Excel macros and Visual Basic for Applications (VBA), to automate tasks and improve efficiency. Wrote complex Stored Procedures, coding, and triggers to capture updated and deleted data from OLTP systems. Conducted detailed comparisons between production databases and data models to ensure consistency and synchronization, identifying discrepancies and proposing solutions. Automated ETL query results across millions of rows of data, which reduced manual workload by 29% monthly. Demonstrated a strong work ethic by consistently meeting deadlines and exceeding performance expectations. Environment: Oracle-SQL, Python, Visual Studio, VBA, ETL, PL/SQL, MS Excel, Power BI, Windows 2000, Advance Server, MS Access, SharePoint, GIT Genesis Infocom, Bangalore, India June 2017 Sep 2020 Junior Data Analyst Responsibilities: Collaborated with business partners to gather the right information from various sources, that can support analysis of key initiatives. Extract, transform, and load (ETL) data from multiple federated data sources (relational database, etc.) with Data Frames developed. Managed code versions and collaborated with team members using GIT, ensuring efficient and organized development processes. Organized and maintained SharePoint sites to facilitate effective collaboration and document management across teams. Used breaks, calculations, sorts, filters, and sections to enhance report data presentation. Applied SQL and Visualization skills to create a reports dashboard for the analysis output. Analysed and improved scalability, efficiency, and stability of systems. Developed impactful reports using MS Excel, Pivot tables, and Tableau to solve business requirements. Actively involved in developing Complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs. Created packages in SQL Server Integration Services which import the data from share point to reporting server database using connection strings. Gained experience with NoSQL databases such as MongoDB, implementing solutions for unstructured data management. Worked closely with the Metrics team to ensure statistical techniques, trend analysis, and continuous improvement tools to be leveraged to gain analytical insights. Provided information to the business development team and collaborated on customer-facing materials. Demonstrated a strong work ethic by consistently meeting deadlines and exceeding performance expectations in fast-paced environments. Environment: NoSQL, PL/SQL, MS Office Suite, JSON, Tableau, VBA, SharePoint, Visualization, Data Analysis, Python, MS Excel, Windows XP, Windows Server ACADEMIC PROJECTS APPLE STORE PROJECT Technologies: Postgres, SQL, MS Excel, MS Office suite, Microsoft PowerPoint, GitHub A database that stores information about Apple products, registered user information, and transaction details. Created Entity relationship diagram and Data Dictionary. This database will let the user add, delete, select, and update the product details. Added insert statements, and updated statements for each table. Worked with large and complex datasets which include the ability to manipulate and clean data using SQL techniques. COVID-19 DATA ANALYSIS Technologies: Microsoft Power BI, EDA, NumPy, Pandas, Data Visualization, Data Cleaning Analysed COVID-19 data analysis which includes death count, confirmed cases, etc., and the dataset is collected from the Kaggle website with the ability to handle complex data. Performed EDA and using pandas and NumPy libraries and data visualization tools understood the characteristics of the dataset. Used Power BI tool to visualize data and used spreadsheets, CSV, XML, and JSON files to read databases and webpages. Visualized data using Pie Charts, Line charts, histograms, and Bar charts and reported the document. Keywords: cplusplus business intelligence golang microsoft procedural language Idaho