Data Engineer

• May 2022 - Present

Project Lead Developer

• Sep 2019 - Sep 2021

Project is to ensure 'Data Erasure' to be compliant with GDPR and other regulatory data protection legislature. Identified and finalized NPPI data elements in ODS, Data Warehouse and DataMart. Implemented purge process via ETL and Unix Scripting. Project is to ensure 'Data Erasure' to be compliant with GDPR and other regulatory data protection legislature. Identified and finalized NPPI data elements in ODS, Data Warehouse and DataMart. Implemented purge process via ETL and Unix Scripting.

Data Architect

• Aug 2019 - Sep 2019

Senior Business Intelligence Analyst , Business Analyst, ETL Developer, Database Developer

• Oct 2015 - Dec 2018

Client Interaction and strategic discussion; Knowledge Management, Stakeholder & Team Management, Release activities, Implementation roadmaps. ; Conduct Internal and external project Audit. Managed and guided development, reporting & design team on assignments and review. Provided technical guidance to the team, Review logic, and Identify POC requirement to conduct the feasibility of the requirement. Managed team of 5+ design and 10+ development team at Offshore, India. Conducted meetings with the SMEs to streamline the management processes. Risk identification, Status and SLA metrics reporting. Business Requirement Understanding and Gap Analysis; created FDD, HLD & LLD documents for BI. Recommended the most suitable technical architecture and defined the solution at a high level. Good experience in AGILE method, Scrum meeting and Sprint. Formulated data migration strategy for the client and successfully managed the data migration from old source systems to the new platform. Carried out AS-IS data landscape assessment and Gap analysis with To-Be State. Assessed business implications for each project phase and monitored progress to meet deadlines, standards and cost targets. Designed & developed common business objects (CBO) Oracle views and visualizations. Designed & developed Informatica mappings and workflows to load data from source to Data Mart. Managed and Created Power BI Reports & Dashboards, Report requirement & layout designing, developing Oracle PL/SQL, performance tuning and UNIX shell scripts. Successfully planned and managed end-to-end implementation (from Discovery to Go-Live) of the Data Integration between systems & Business Intelligence reporting for decision making. Show less

senior software Analyst

• Jun 2011 - Jul 2015

Requirement Understanding and Analysis- Provide technical guidance to the team, Review logic, Identify POC requirement to conduct the feasibility of the requirement. Data Discovery & Profiling- Provide guidance, Design complex queries & provide critical business insights; Data Analytics and Reporting- Design & Integrate research instruments. Business Requirement Understanding and Gap Analysis. Problem definition, Data Explore and preparation, Data Modelling, Validation and verification. Performed data analysis on large volume of inbound / outbound feed files. Client Interaction and strategic discussion; Conduct Internal and external project Audit. Stakeholder Management- Interact with the client, resolve any issues; Coordinate with internal teams; Present analysis to the client. Knowledge Management - Create and update knowledge articles in the KM repository; Maintain KM database. Understand aspirations; Set goals and monitor performance; Conduct appraisal; Build training material, conduct trainings. Design - Design functional mapping documents, error handling, Define ETL. Created Informatica mapping, Cognos/Power BI reports, Oracle PL/SQL and UNIX shell scripts for data loading/reporting. Created AutoSys Scripts for scheduling Informatica workflows and Unix Scripts. Designed and Developed reusable error handling mapplets. Performance tuning, SQL optimization and handled Stewardship committee for data modelling. Stakeholder & Team Management, Release activities, Implementation road-maps. Research issues with the production data and determine a resolution. Show less