Ankesh Jain

Designed and implemented end-to-end data architecture integrating SQL Server, S3, and Excel with Azure Data Factory and Databricks, supporting ~100 GB of data across 20+ ETL/ELT pipelines. Reduced processing time from 2-3 days to 45-60 minutes and enabled ~30 Power BI reports and 70 Tableau dashboards for ~500 users.

Developed 5 Power BI reports and 50 Tableau dashboards for analytical and business reporting. Automated and migrated ~30 analytical workflows using Python and SQL, improving processing speed by ~60% and reducing a week-long manual workflow to half a day.

Developed 5 Power BI reports and 10 Alteryx workflows for ETL and data preparation, and built 20 Tableau dashboards used by ~50 stakeholders. Gathered requirements and translated business needs into reporting solutions.

Developed ETL packages and T-SQL solutions for data integration and reporting. Built Power BI and Google Charts dashboards and application queries based on design documents.

Developed ETL and T-SQL solutions for BI projects for US clients using SSIS and .NET. Worked on Power BI dashboards, BI development, data preparation, and deployment.

Developed Power BI dashboards and supported Power BI Gateway configuration. Performed SQL-based data transformation/ETL and developed stored procedures for upstream data preparation.

Bachelor of Engineering in Computer Science and Engineering from Jai Narain College of Technology, Bhopal, from September 2011 to June 2015.

Completed the Microsoft DAT207x course on Analyzing and Visualizing Data with Power BI.

Completed the Harvard CS50x course on Introduction to Computer Science.

Completed a course on Data Warehouse from the University of Colorado.

Completed a course on Querying Microsoft SQL Server 2012/2014.