Data Analyst

Irving, TX

Cell: 267-***-****

www.linkedin.com/in/gaurang-makadia

*******.********@*****.***

GAURANG MAKADIA

SUMMARY

Power BI /Data Analyst with 5 + years of data analysis experience in Automobile, retail, finance, and Transportation. Proven track record of analyzing huge volume of data to business insights using SQL server, and multiple RDBMS like Oracle, SQL Server, Teradata, Vertica etc.

SKILLS

Experience wide variety of projects and skilled in analysis, design, development, testing and implementation in Data warehouses environment.

4+ Experience as report developer using multiple reporting tools like Power BI and Tableau visualization tool for data analysis and reporting.

2 years of strong experience in Power BI designed, developed, and published multiple advanced visualization report and dashboard in on premises /Azure cloud environment.

Experience in working with customers to determine their needs, gather, analyze, and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/MS excel.

Hands on Experience in performance tuning and query optimization in different databases like using SQL SERVER 2014/2016, Oracle 10g/11g.

Experience in working with ETL team on Data Migration using SQL, SSIS, SQL Azure, Azure storage, and Azure Data Factory

Proficient in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text, and date functions.

Heavily used DAX table functions including filter, all, values, distinct and related table.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Hands on experience with MSBI (SSIS) to extract, transform and load data into database.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.

Ability to deal with people with conflicting needs, prioritize and schedule multiple tasks and work under pressure and a great problem solver and team player.

WORK HISTORY

DATA ANALYST, IBM – AT&T, IRVING, TX

06/20 – Present

Environment: Power BI Desktop 26, Power BI Service, Power BI Gateway, Power BI Report Server, Teradata SQL, Vertica SQL, SSAS, Advance Excel, SQL, Big data

Coordinated with business user at various levels and call meetings during the different phase of projects to deliver successfully.

Interacted with Business Analyst, and team Members within the organization to understand business processes, implement the logic.

Analyzed large data set by running hive queries.

Developed hive queries to process the data and generate data cubes for visualizing.

Created Reporting Design Document from business requirements document (BRD).

Created source to target mapping sheet for report.

Read data from multiple sources like CSV, Teradata, Vertica through Power BI for creating Dashboards/ Reports.

Implemented context filters and data source filters for handling large volume of data.

Created multiple data model with Power BI and used as a common data source for generating multiple reports.

Worked with different types visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the reports.

Used Power Pivot to create powerful data model and created power view for dynamic reports.

Utilized DAX functions which includes Aggregation, Counting, Logical, information, Text, and date functions.

Have refreshed/republish reports and data set manually.

Created various views using Power BI (Tree maps, Scatter plot).

Created calculated tables, Dimensions, calculated columns, and measures.

Developed Microsoft Analysis Services cubes (Tabular) for performance improvement.

Wrote SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Created report test cases using different scenarios to verify each KPI; also involved in UAT.

BI ANALYST – PENSKE CORPORATION – KROGER/STARBUCKS, IRVING, TX

12/18 – 05/20

Environment: Power BI Desktop, Power BI service, Tableau Desktop 9.0, Tableau Server, MS Office Suite, Oracle 10g, SQL Server 2014

Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.

Performed data analysis using SQL query and tableau to understand the trends and pattern in the operation and improve process time, resulting in saving $100K.

Generated context filters and data source filters while handling large volume of data.

Utilizing functions which include Aggregation, Counting, Logical, information, Text and date functions in source data.

Developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.

Created Row level security so based on role, the end user can view the data.

Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.

Conducted root cause analysis of product received data sets, queried approx.1M records to propose solution to improve the process, which triggered in $350K cost savings.

Developed metrics used to determine inefficiency and areas of improvement. Provide support to users within specific tool to ensure the quality of data.

Forecasted the trends for future months using time series analysis using tableau and excel.

SUPPLY CHAIN ANALYST – DHL SUPPLY CHAIN – CARRIER- SAN ANTONIO, TX

11/15 - 11/18

Environment: SQL server, Advance Excel, Power Point, Tableau Server

Collected, cleaned, and provided modeling and analyses to structed and unstructured data used for major business initiative.

Developed data visualization using SQL and excel for operation team to decrease process cycle time to action, it helped identify to reduce bottle neck from the process, improved $200K in labor costs.

Analyzed operation, HR and finance data and created correlation dashboard in tableau using multiple data sources.

Automation of the key report using excel VBA macros, reduced operation manager time by 20% and increased accuracy by 90%.

Proactively communicated and collaborate with finance team to manage revenue and other cost that drive forecasting and strategic planning for the DHL program.

Conduct analysis on product shipping methods with help of SQL and excel using business best practices introduced automatic entry of indirect time, reducing processing time by 10% and saving of $100K.

INDUSTRIAL ENGINEER – HONDA LOCK OF AMERICA – ALTANTA, TX

08/14 - 10/15

Environment: SQL server, Advance Excel, Power Point, MS access

Provided accurate, timely and informative outputs and insights to sales and operation teams to meet their business needs.

Collaborated with department manager by performing data analysis on various supply chain process and sharing result in power point, triggering in $1.2 M in cost savings.

Worked with IT manager in collecting, cleaning, organizing and interpreting production data to set business goals.

Ran SQL query to extract 500K records and perform analysis on product scrap, change in first off process, which result in improving scrap approx. 20%.

Analyzed monthly results of production by product, compare actual versus forecast in power point story.

EDUCATION & CERTIFICATION

MASTER OF SCIENCE IN INDUSTRIAL ENGINEERING, UNIVERSITY OF PITTSBURGH, PITTSBURGH, 2014

BACHELOR OF SCIENCE IN MECHANICAL ENGINEERING, TEMPLE UNIVERSITY, PHILADELPHIA, 2010

LEAN SIX SIGMA BLACK BELT CERTIFIED WITH PROJECT, UNIVERSITY OF PITTSBURGH, 2014

LEAN SIX SIGMA GREEN BELT CERTIFIED WITH PROJECT, UNIVERSITY OF PITTSBURGH, 2012

Contact this candidate