Download PDF

Esha Mishra

Data Engineer

Summary

I have 8+ years of experience in Data warehousing and reporting. Experienced in building end to end reporting systems which supports large number of users

Skills

Databases

SQL Server, Oracle, AWS Redshift, MySQL, Hive

Reporting Tools

Microsoft SSRS, Visio, Python notebook, Power BI, OLAP Cubes

Programming

C#, PL/SQL, T-SQL, MDX, DAX, HQL, Shell Scripting, VBA,  MS Excel

ETL Tools

Microsoft SSIS, Informatica, Master Data Service

Work experience

Sep-2015Present

Data Engineer

WorldWide Finance, Microsoft
  • Working on building forecasts, budgeting and prediction models for Microsoft finance group
  • Created Finance reports which drives Product road-map
  • Creating KPI metrics and reports which are used by finance controllers
  • Gathering inputs from various controllers to create quarterly  forecast reports, yearly budgeting models and product wide allocation models.
  • Automated the report generation workflow
  • Tuning existing ETL and reporting models
  • Building prototype on various enhancements.
Nov-2014Sep-2015

BI Engineer

Finance Team, JP Morgan Chase
  • Capturing business requirements and identifying the issues of data sanctity and data cleansing
  • Responsible for data modeling, building data-marts and ETL process to load into SQL Server
  • Created dashboards on mortgage parameter health
  • Created new data-marts for reporting in Redshift
  • Analyzing years of existing mortgage data and doing mining information over millions of records
  • Responsible for reporting the financial metrics analysis and sending out the report to senior management
  • Build ad-hoc analysis platform for customers using Hive and data in Amazon S3
  • Did performance tuning and benchmarks on Redshift vs Hive
Jun-2008May-2014

Data Warehouse Specialist

Fixed income Ops Team, Bank of America
  • Designed and built data marts and cubes for financial reporting and analytics
  • Interacted with business analysts and marketing teams for requirement gathering and estimations
  • Created ETL workflows to load data into Data warehouse from Oracle databases
  • Optimized load of existing tables, improving run time of dashboard reports by >10%
  • Built an efficient system to identify eligible Dodd-frank trades which had multiple complex data sources
  •  Subject matter expert for Trading and Income operations
  • Built ETL workflows, data warehouse tables and dashboard reports from scratch for Fixed income securities and Trading security operations at Bank of America (data volume: 5+ TB)
  • Built end to end reporting solution for more than 5000 users
  • Designed a system to analyze the key distribution across products for Microsoft products
  • Brought about high revenue impact and earned customer appreciation for successful go live

Education

20042008

Bachelor of Technology

Kalinga Institute of Industrial Technology

GPA 8.7/10

Certifications

Redhat certified professional

Microsoft Certified Professional

All India 2nd rank in Talent Search Exam