Abhishek Mishra

• Developed innovative strategies to address complex business challenges, resulting in increased profitability for clients.
• Delivered high-quality solutions for clients through comprehensive research and analysis of industry trends.

EDW is EY’s Enterprise Data Warehouse a.k.a. PDW as its getting built on Parallel Data warehouse appliance. It is the Hub for various EY systems to exchange data with each other. EDW is a single source of truth for the organization when making business decision.

As a Senior Data Engineer, I provide consulting for successful migration of EDW applications to PDW/Azure platform, create data integration and Customer hub structure EDW tools, building ETL frameworks, reports and develop applications which must be capable of automating and expediting the following functions at Ernst & Young (EY): around EDW/PDW/CDW applications by designing

• Work with the EY architect team to create data integration and Customer hub structure around EDW/PDW applications.
• Architected and implemented scalable Big Data solutions using Spark, which increased data processing capabilities by 75% and supported realtime analytics.
• Working with HCM domain clients to build E2E data (ETL/ELT) pipelines in Spark framework using PySpark for processing large terabytes of data in databricks.
• Optimized SQL queries and data models, leading to a 40% improvement in query performance and data retrieval times.
• Boosted data processing capabilities by 75% and enabled real-time analytics by architecting and implementing Spark based solution.
• I wrote long SQL queries, formatted and analyzed data from various sources, and designed visualizations from them.
• Perform ownership of data engineering workstreams, including data acquisition, data pipelining, data quality, data prep, and data warehousing.
• Led and mentored teams of 4-5 engineers.
• Suggest the best approaches for the better performance within time and cost constraints by utilizing the advanced specialized knowledge of ETL/reports/MDM (Master Data Management) and present to Client
• Prepare technical analysis, Prototype development (Create templates), Proofs-Of-concept, and provide Effective effort estimations for new business requirements.
• Design and build reusable user components using Microsoft API’s which reconcile, develop, and audit the results of the extraction/transformation or conversion of data from source systems to the target application
• SQL - Advanced querying (Window Functions, CTEs), data modeling, and performance tuning.
• Data Integration - Seamless transformation and migration of data across diverse systems
• Data Governance and Data Lineage

The customer (TRICARE) runs a health care program of the United States Department of Defence Military Health System. It provides civilian health benefits for military personnel, military retirees, and their dependents, including some members of the Reserve Component

WPS PROJECT is fully developed automatic application used for data transfer/reconciliation between the two organizations and has the excellent auditing, error handling mechanism and security.

Domain: Financial and Asset Management (BFSI)

Type: Development

• As a team lead, I built roadmaps focused on optimizing and streamlining operational and maintenance activities and ensuring fast and proactive solutions thus mitigating risks and addressing issues in a time-sensitive and accountable manner with minimum-to-zero customer impact.
• Developed and deployed advanced monitoring and alerting systems, providing real-time visibility into system health and performance. Implemented proactive alerting mechanisms of BI application; that reduced false positives by 35% and improved incident detection.
• I leveraged the use of Integrity Manager for report data and SQL comparisons during platform enhancement.
• Achieved a 99.99% uptime for critical financial systems by implementing robust monitoring, alerting, and incident response processes, significantly improving system reliability and reducing downtime.
• I triaged major incidents using ServiceNow by demonstrating subject matter expertise to solve complex problems using ITSM best practices including root cause analysis for problems, estimate efforts, and contribute to the development of long-term solutions.
• I identified, recommended, and championed the automation of routine tasks to drive efficiency and productivity of the team which includes developing mechanisms and automation for deployment.
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.

Client focuses on the financial services marketplace by providing state-of-the-art industry specific products, services and provides mission critical technologies that enable clients across the globe to strengthen relationships, improve productivity, drive new revenue, and reduce training and administrative costs. Client is located in United States.

BILLING AUTOMATION tool is fully developed automated application .The bank bills generated are in the different formats which are not compatible in financial management systems .This application fully automate the generation of the compatible files. Thereby reduces the cost since any manual intervention is then not required and saves time

• Evaluated the effectiveness of current reporting tools, recommending upgrades or replacements as needed to enhance team capabilities.
• Developed thorough documentation for all created reports, contributing to a comprehensive resource library for team reference and training purposes.
• Increased user satisfaction by providing prompt responses to ad hoc report requests, addressing specific needs in a timely manner.
• Implemented automated report generation processes for routine tasks, freeing up resources for more complex projects.

Client is a business services company that helps its customers maximize the power of their people, lower their costs and focus on what they do best. MIS is primarily to provide maintenance support for six applications like Plan view, Transactional Lifecycle Management (TLM), Price Point, and Pivotal. Client is located in United States

• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Documented analysis results and provided performance improvement feedback.
• Developed custom database objects, stored procedures and delivered application support.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.