Badges
Certifications
Work Experience
Data Engineering Senior Analyst
accenture•  March 2018 - Present
I have been working primarily as an Data Engineering Senior Analyst in Counterparty Credit Risk domain and leading the offshore QA and Analytics team. 1. BAU work involves Data Analysis, Business requirement analysis and ETL Testing of new requirements or enhancements to the existing functionalities from the Business Stakeholders. 2. Analyzing the overall Risk Weighted Asset (RWA) Number and Data on bank’s exposures by framing SQLs with complex JOINS and presenting the analysis/data story to the stake holders as an Excel report or Tableau report/dashboard. 3. Validating huge volume of datasets involving Data Transformation, Data Quality, Data Accuracy, Data Completeness Testing and Source to Target Mapping testing. 4. Having hands on experience in deploying AWS EC2, S3, RDS and VPC cloud applications as part of Accenture Cloud Elevate Program. 5. Representing the offshore team in Daily Scrum. 1. Data Analysis and Reporting • Performed initial analysis on the enterprise data to convert the business requirements to technical terms. • Proactively analyzed and provided the detailed analysis on the variance in overall RWA numbers among the datasets in final consolidated table by framing complex SQLs. • Developed the interactive Dashboard using Tableau, which provides insights on the RWA numbers for each Basel Product Types, thus helped stake holders in making data driven decisions. • Performed Root cause/Drilldown analysis on the factors contributing to the data differences at each layer of ETL and reported the key factors causing data gaps and amount differences. • Presented the final outcome/analysis based upon the KPIs and insights in Microsoft Excel/PowerPoint to the stake holders and helped them in making data driven decision. 2. ETL, Functional, Regression, Automation and System Integration Testing • Attended the Sprint Planning, Story Grooming and performed requirements analysis given by Business Stakeholders. • Developed SQL and Python test scripts/reports as per the requirements • Effectively carried out the new functionality’s validation, assuring the valid Data Transformation. • Highly experienced in performing ETL Testing such as Source to Target Mapping, Data Transformation validation and Data Integrity checks. • Effectively conducted the defect root cause Analysis by debugging Informatica Monitor and Python logs, capturing data gaps at each layer of ETL. • Performed thorough analysis on any data differences or RWA number differences as part of regression testing • Developed the automated VBA tool to compare the aggregated columns among the datasets at all the layers of ETL using VBA Macros. • Performed File Data validation at ETL server using UNIX commands/Shell Scripting. • Validated the rare case test scenarios by producing the mocked-up data in SANDBOX schema. 3. Testing Support for Informatica to Python Migration Project • Successfully analyzed and identified Informatica Source to Target Mappings, Process Workflows and identified all the tables and files of ETL processes • Supported and carried out complete validation of over 700 tables and files within the given timeline.
Education
Visveswaraya Technological University Belagavi
Electronics and Communication Engineering, BE•  August 2013 - July 2017
Links
Skills
harishgurav1 has not updated skills details yet.