Data Analyst Analysis

Mythri B

Data Analyst/ Engineer

Phone: +1-469-***-**** Email: **********@*****.*** LinkedIn

PROFESSIONAL SUMMARY:

* ***** ** ************ ********** as a Data Analyst, proficient in understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, data extraction, manipulation, visualization, validation techniques, and Data Modeling.

Demonstrated ability to conduct in-depth data analysis to identify trends, patterns, and insights, leading to data-driven decision-making and strategic planning.

Proficient in SQL, Python (including Pandas and NumPy), C, R, and Bash, with advanced skills in SQL.

Skilled in Microsoft Office Suite including Word, Excel, PowerPoint, Visio, and Project for documentation, analysis, and presentation.

Experience managing multiple data projects simultaneously, ensuring timely delivery and alignment with business objectives.

Developed SQL and Alteryx-based programming logic to validate business rules, supporting data reconciliation and reporting.

Experienced with various database technologies including PL/SQL, MS SQL Server, DB2, MySQL, Mongo DB, No SQL.

Proven capability to present complex data insights to non-technical stakeholders through clear and concise

Visualizations and reports.

Proficient in Excel for data analysis, and skilled in using Talend for data integration. Experience with NumPy, Pandas, NLTK, and A/B Testing methodologies.

SKILLS:

Languages

SQL, Python, Advanced SQL, C, Hadoop, R, Bash.

Tools

Tableau Desktop, Python (Pandas, NumPy), Datorama, PowerBI, Matplotlib, Seaborn, Power Query, Pivot Tables, PowerPivot.

MS-office package

Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

Database Technologies

JIRA, T-SQL, PL/SQL, Teradata, MS SQL Server, DB2, SQL Server, MySQL, NOSQL.

Big Data

Azure Data Studio, Access, Map Reduce, Pig, Hive, AWS, EMR, AWS S3.

Tools/Library

Excel, Talend, NumPy, Pandas, MSVisio.

Methodologies

SDLC, Agile, Waterfall, Scrum.

Operating Systems:

Windows, UNIX, Linux, Mac

EXPERIENCE:

Molina Healthcare, USA Sep2023–Present

Data Analyst/ Engineer

Identified healthcare trends by leveraging SQL and advanced techniques in Teradata, MS SQL Server, and Netezza, enhancing data accuracy and decision-making.

Developed advanced SQL queries for data extraction, transformation, and loading (ETL) from large relational databases (Oracle, MySQL, PostgreSQL), optimizing query performance and reducing data retrieval times by 20%.

Built predictive models using Python (Pandas, NumPy) and R for customer/Patient segmentation and forecasting, contributing to a 15% improvement in business outcomes.

Implemented data quality checks and automated cleaning, validation, and reporting workflows using Python, reducing manual data processing time by 40% and decreasing reporting errors by 20%, ensuring high accuracy and reliability in healthcare data reporting.

Created dynamic, interactive dashboards using Power BI and Tableau to visualize complex datasets, enabling stakeholders to monitor real-time performance metrics and KPIs.

Leveraged advanced Excel functionalities (Pivot Tables, VLOOKUP, INDEX/MATCH, Macros) to manipulate large datasets and generate detailed reports.

Led cross-functional teams in collaborative efforts to align data solutions with business objectives, emphasizing clear communication and commitment to regulatory compliance.

Analyzed complex healthcare data sets using SQL and Python to identify trends, patterns, and actionable insights, driving informed business decisions and enhancing patient care.

Designed and maintained ETL pipelines using SQL, Python, SSIS, and Talend, ensuring efficient data transfer from multiple sources into centralized data warehouses, enabling seamless integration and analytics for healthcare data, including pattern recognition in patient outcomes.

Conducted statistical analysis using R to perform A/B testing, hypothesis testing, and regression analysis, driving data-driven business decisions.

Documented data processes and findings with Microsoft Office Suite, engaging stakeholders with clear presentations and engaging storytelling.

Amazon Development Center, INDIA Aug2019–July 2022

Data Analyst/ Engineer

Orchestrated truck planning and scheduling across fulfilment centers in North America and Europe, collaborating with internal stakeholders in Retail, Finance, shipping decisions, Software Support & fulfilment centres.

Led the development of a software program, enhancing operational efficiency by 30% through the analysis of over 1.5 million data points, pinpointing inefficiencies, and implementing data-driven process improvements.

Led end-to-end ETL processes using SQL, Python, and Alteryx, ensuring data accuracy and integrity, and reducing manual workload by automating routine tasks.

Designed and built interactive dashboards using Power BI and Tableau, providing real-time insights for key stakeholders to drive data-informed decisions in transportation and logistics.

Automated data extraction, transformation, and reporting with SQL and Python, improving processing speed and increasing productivity by 25%.

Built machine learning models in Python to personalize customer experiences, contributing to a 15% increase in product adoption and enhancing customer satisfaction.

Conducted in-depth analysis of large datasets to identify inefficiencies, implementing data-driven improvements that boosted operational efficiency by 30%.

Optimized transportation and supply chain operations by analysing key metrics and patterns, ensuring a more streamlined and effective workflow.

Improved data quality and reporting accuracy by auditing, cleansing, and normalizing datasets, ensuring reliable and actionable insights for stakeholders.

Collaborated cross-functionally with IT, business analysts, and stakeholders to define requirements, develop data-driven solutions, and implement process improvements in transportation operations.

Developed and maintained customized reports using SAS, Excel, and SQL, improving predictive accuracy of customer behavior and optimizing sales and marketing strategies.

Led training and mentoring initiatives for new hires and cross-skilled teams, improving team performance in quality and productivity while reducing turnaround times by 35%.

PROJECT:

Technologies: Internet of Things Mission: Innovative Automatic Street Lighting System

Leveraged Artificial intelligence for light intensity control and SQL for robust data management. Using advanced

Technology to Integrate Street lighting, this solution optimizes energy consumption and maintenance

EDUCATION:

Missouri State University, Springfield, MO, USA

Master of Science: Information Technology

GITAM University, India

Bachelor of Technology: Computer Science Engineering

PROFESSIONAL CERTIFICATIONS:

Certified in Data Analysis by Microsoft

Certified in Artificial Intelligence (AI) and Business Strategy

Certified in Data Engineering Foundations

Contact this candidate