Data AnalystPower Bi

Apar Arun Panchal

DATA ANALYST

New Jersey, USA 347-***-**** aparpanchal09gmail.com Linkdin

EDUCATION

Masters in Business Administration

(MBA) in Business Analytics – Pace

University, New York, USA

Bachelors of Arts in Psychology- Wilson

College, Mumbai, India

SKILLS

Methodologies: SDLC, Agile, Scrum,

Waterfall

Language: Python, SQL, R

Packages: NumPy, Pandas, Matplotlib,

SciPy, Scikit-learn, TensorFlow,

Seaborn, caret, stringR, readR, dplyr

Visualization Tools: Tableau, Power BI,

Advanced Excel, Looker, Alteryx

IDEs: Visual Studio Code, PyCharm,

Jupyter Notebook

Database Management: MySQL,

PostgreSQL, SQL Server, T-SQL

Cloud Platforms: Microsoft Azure

Other Technical Skills: SISS, SSRS,

Machine Learning Algorithms,

Probability distributions, Google

Analytics, Confidence Intervals,

ANOVA, Hypothesis Testing, Regression

Analysis, Linear Algebra, Advance

Analytics, Data Mining, Data

Visualization, Data warehousing, Data

transformation, Data Storytelling,

Association rules, Clustering,

Classification, Regression, A/B Testing,

Forecasting & Modeling, Data Cleaning,

Data Wrangling, Jira, Git, Github

Soft Skills: Time Management,

Leadership, Strategy Planning,

Problem-Solving, Negotiation,

Decision-Making, Documentation and

Presentation, Verbal Communication

Operating System: Windows, Linux

SUMMARY

Data Analyst with 4+ years of experience in leveraging advanced analytics techniques and data visualization tools to drive business insights and optimize operations.

Skilled in utilizing cloud platforms such as Microsoft Azure and tools like Tableau, Power BI, and Advanced Excel for data visualization, analysis, and reporting.

Proficient in SQL, R, and Python for statistical analysis and machine learning, utilizing libraries such as NumPy, Pandas, SciPy, and scikit-learn to develop predictive models and perform regression analysis.

PROFESSIONAL EXPERIENCE

Data Analyst CVS Health, NJ Jan 2022 – Present

Designed and developed interactive Power BI reports and dashboards, facilitating a 20% increase in patient care efficiency and a 15% improvement in healthcare operations.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes

& Views using T-SQL in the Development and Production environment.

Created various dashboards on the Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.

Designed and developed stored procedures, queries, and views necessary to support the SSRS reports, reducing report generation time by 25%.

Developed and executed Python programs to perform regression analysis, analysis of variance (ANOVA), and other statistical modeling techniques.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Leveraged Python's scikit-learn library to develop and deploy machine learning models for predictive analytics, identifying patterns and trends in healthcare data to support informed decision-making.

Developed and implemented data analysis models to extract, transform, and load (ETL) financial data from various sources, ensuring data accuracy and consistency.

Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server.

Worked with Azure Synapse Analytics to perform large-scale data extractions and migrations with a focus on optimizing performance in a massively parallel processing

(MPP) environment.

Data Analyst Accenture, India Jan 2019 – Dec 2020

Utilized Python to derive actionable business insights, driving a 25% increase in sales by identifying and addressing key market trends, and effectively communicating strategies to senior stakeholders.

Crafted and executed advanced SQL queries to extract and interpret large datasets, discovering critical business insights to execute strategy changes resulting in a 20% decrease in customer churn rate.

Conducted sentiment analysis in R (RStudio) on 25K financial reviews to monitor and present client engagement trends describing key financial drivers for market research.

Enhanced financial data planning methodologies in Tableau and Power BI, analyzing 15- year S&P 500 trends and deriving 35 key insights for ROI research.

Proactively designed quality metrics in MS Excel implementing VLOOKUP for client engagement projects, boosting efficiency by 20% through innovative solutions

Implemented A/B testing strategies using Google Analytics insights, enhancing landing pages and achieving a 40% rise in conversion rates.

Partnered with cross-functional teams to deliver data-driven insights via Salesforce, improving client satisfaction by 30% through targeted KPI optimization and strategic recommendations.

Contact this candidate