Data Analyst Power Bi

Pravina Prajapati Data Analyst

********************@*****.*** +1-647-***-**** Toronto, ON LinkedIn GitHub Summary

Data Analyst with over 5 years of experience in leveraging advanced data analytical techniques and tools to drive business growth and operational efficiency. Strong experience in extracting actionable insights from complex datasets, utilizing a wide range of programming languages, databases, and reporting tools. Experience in collaborating with cross-functional teams to identify key performance indicators, develop predictive models, and implement data-driven strategies that deliver measurable results.

Skills

Programming Languages

SQL, R, Python, Java

Methodologies

SDLC, Agile/Scrum, Waterfall

Relevant Skills

Data Visualization, Statistical Analysis,

Data Cleanup & Preprocessing,

Transformation, Mining, and Modeling,

Build KPIs for data quality

measurement

Platforms

Google Cloud Platform (GCP), Microsoft

Azure, AWS (EC2, S3, RDS) and Google

Analytics

Database

MySQL, PostgreSQL, MSSQL, Oracle

Reporting Tools

MS Excel, MS Project, MS Office, MS

SharePoint, MS Visio, Spreadsheet

Analysis

Cost/benefit analysis, GAP analysis,

Risk Analysis, Impact Analysis, SWOT

Analysis, Regression Analysis, Time

Series, Decision Making, Predictive

Analysis

Visualization Tools

Tableau, Power BI, Excel

Other Tools

SAP, CRM, JIRA, Slack, ETL/ELT, SSIS,

Talend Open Studio

Professional Experience

Data Analyst, Deloitte Feb 2024 – Present

•Built and maintained a data pipeline to automate data extraction, transformation, and loading (ETL) processes using Python, SQL, SSIS, and Talend Open Studio, reducing data processing time by 30%.

•Managed and optimized databases including MySQL, Microsoft SQL Server, and Oracle, with expertise in data warehousing and data pipeline development.

•Applied Python and SQL for extracting, cleaning, and transforming large datasets from diverse sources, enabling 20% better data quality for downstream analytics.

•Conducted in-depth analysis of sales data to identify key trends and opportunities, utilizing statistical analysis techniques and developing Power BI reports and dashboards for actionable visualizations.

•Implemented Agile/Scrum methodology in collaboration with cross-functional teams, enhancing project efficiency.

•Led the yearly database cleaning, worked with the CRM Administrator to ensure high-quality data, supervised best practices for CRM data management.

Data Analyst, Rishabh Software Jul 2019 – Dec 2023

•Developed predictive data models and KPIs using Python and SQL to measure data quality and forecast business trends, resulting in a 25% improvement in operational decision-making accuracy.

•Performed comprehensive analyses including Cost/Benefit, Risk, Impact, SWOT, Regression, Time Series, and GAP to support strategic decision-making.

•Built and deployed a real-time customer analytics dashboard using Tableau, providing actionable insights to stakeholders, enhancing decision-making speed by 50%.

•Utilized MS Office Suite, including MS Excel and MS Visio, along with SSRS and SSAS, for comprehensive data analysis and reporting.

•Applied digital marketing strategies and data analysis to optimize campaigns and drive business results.

•Leveraged AWS S3 for scalable object storage, and AWS Glue for data integration and ETL processes. Education

Canada Post-Graduate in Business Insights and Analytics, Humber College Jan 2023 – Aug 2024 Bachelor of Technology in Computer Engineering,

Gujarat Technological University

Jul 2015 – Aug 2019

Contact this candidate