Amit Prasad Email & Phone Number

Greater Atlanta Area

• Designed, built, and maintained ETL/ELT using Azure Data Factory/Synapse to collect data from disparate data sources and loaded them into Azure SQL databases/Azure ADLS Gen2/Azure blob, reducing data ingestion time by 50%. Azure Logic Apps is used within the jobs to send out success or failure email notifications of the pipelines.• Reading and Writing Data from and to Various Azure Analytics Services and File Formats using Databricks. Executed data transformation and aggregation using PySpark and Scala thus enabling big data processing capability in the analytics department.• Developed five expansive and several other automated reports in Power BI to go from raw data to deeper insights with over $5M in annual revenue. It made the key KPIs available in almost real-time to the relevant teams.• Developed and executed complex SQL queries for extracting business insights and transforming the data using aggregation, attribute construction and integration to make it suitable for BI visualization, increasing decision-making efficiency by 30%.• Architected robust data models that supported business intelligence insights, driving a 25% lift in data-driven decision-making.• Led the design and development of a scalable Azure-based analytics platform, improving data processing speed by 40%.• Implemented advanced analytics such as life cycle analysis, cohort analysis to information growth strategies that brought in over $3M of revenue.• Maintain a petabyte of data spread across 5 clients in SSMS. Troubleshoot and fix problems in case of failures in automated jobs.• Expertise in creating views, materialized views and stored procedures in SQL and Python Data Frames for analytics projects.

Bangalore Urban, Karnataka, India

• Worked on two ML projects to calculate duration of a cab ride and housing prices. Performed exploratory analysis, data preprocessing, data processing then explored several other modeling techniques. Used k- means clustering, lasso, ridge regression, principal component regression, and random forest. the random forest model outperformed the others.

Bengaluru Area, India

• Pioneered the introduction of data analytics practices that informed business decisions and identified a new revenue stream annually.• Integrated SQL with Power BI to automate data extraction processes, saving 15 hours of manual work per week• Custom-built Power BI dashboards that improved the client’s effectiveness in finding fraud pattern by 45%.• Facilitated Power BI training sessions for internal teams, leading to a 30% increase in team productivity from enhanced data visualization skills• Conducted data validation and cleansing using SQL, ensuring a high level of data quality for analytics purposes.• Assisted in the development of BI solutions tailored for financial clients, which increased reporting accuracy and improved client satisfaction scores by 9%.• Analyzed client data to identify trends using SQL, contributing to the development of targeted business strategies that resulted in a client retention rate improvement of 5%.

Bengaluru Area, India

Client: United HealthCare Group• Developed a few VBA macros, such as Project Matrices Validation, Table Validation and auto formatting of DB field values for the testing team that led to a reduction of manual effort by 80%.

Master'S Degree, Analytics, 3.53

Ms In Analytics, Analytics, 3.50