Neeraj Sharma

Client: Medibank, Australia

Role: Sr. Data Engineer - Technical Team Lead

Business Domain: Medical Insurance & Health Solutions

Project Landscape: Migration for Transfer certificates & ASOB Applications from Legacy Enterprise DWH(Teradata) to strategic AWS Cloud platform

Roles & Responsibilities:

• Data-lake building by Data Ingestion framework from various sources like AWS S3 (CSV & JSON), SQL Server, Azure DB, and various other RDBMS sources for batch, real-time, and near-real-time ingestion strategies
• Building of Data-Marts, feature stores and extracts in multiple business areas with complex transformations from mapping designs using Hive/Spark-SQL, Glue on ELT/ETL framework
• SQL optimizations for long running/memory intensive jobs and for bulk data processing
• Performed Data masking as per customer/governance requirements, Data Profiling and Data Quality framework development
• CI/CD & versioning through Stash, Git & Jenkins
• Developed and implemented bug fixes and patch sets for existing applications

Client: Medibank, Australia

Role: Data Engineer - Technical Team Lead

Projects: - Enhancements on APRA & MMM Applications

- Migration of various DWH applications

- MS SQL Server and Teradata to AWS Cloud

- Loyalty Programs

Roles & Responsibilities:

• Requirement analysis, designing, developing, implementing, testing and executing project as needed by business
• Understanding and analyzing High and Low-Level Design.
• Data Ingestion using python from AWS S3
• Experience with various AWS services during integration for ETL framework like EC2, EMR, RDS, S3, Redshift, Glue, Athena, and Dynamo DB etc.
• CI/CD & versioning through Stash, Git & Jenkins
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
• Built databases and table structures for DWH applications

Client : Medibank, Australia

Role : Information Management - Technical QA Team Lead

Project Landscape: PHI Reforms Product Changes on AHM and Medibank and AHM ambulance Levy changes

- MS-SQL Server upgrade

Roles & Responsibilities:

• Automation Test Lead / UAT Coordinator
  • Experience in complete end to end co-ordination with stakeholders for the Business requirements, UAT and deliverables
  • Extensively used ETL methodology for performing Data Profiling, Extraction, Transformation and Loading using designed data conversions from wide variety of source systems including Oracle, DB2, SQL server, non-relational sources like flat files, XML and Mainframe Files
  • Advanced knowledge in QA Methodologies, QA Test Strategy, QA Testing Project Plan, QA Effort Estimates and Resource Planning, Software Testing Life Cycle, Software Development Life Cycle (SDLC) and Bug (Defect) Life Cycle
  • Extensive experience in Test Management, Test Coordination, Test planning, Resource Management, Risk Management, Vendor Management and Conflict Resolution, Statement of Work for multiple projects on multiple platforms
  • Expertise on ETL Testing and various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
• Completed automation of functional and regression testing

Skills: Quality Assurance Testing · Jira · Integration Testing · ETL Tools · Analytical Skills · Manual Testing · Data Warehousing · Quality Assurance · AWS Glue · Amazon Redshift · Amazon Web Services (AWS) · Health Insurance · Extract, Transform, Load (ETL)

Client : Western Union, US

Role : PLSQL Developer - A Technical Lead

Business Domain : Medical Insurance & Health Solutions

Project Landscape:

- GDPR - General Data Protection Regulation – Development
- Automation of CDD, Manual Opt-outs Business requests and various enhancements
- Banking: Consumer Database Application Developer

Roles & Responsibilities:

• Primary objectives of the GDPR is to give control back to citizens and residents over their personal data and to simplify the regulatory environment for international business by unifying the regulation within the EU
• Requirement analysis, designing, developing, implementing, testing and executing a project as needed by business
• Understanding and analyzing the High and Low-Level Design
• PL/SQL Developer, Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Cursors, Functions, Packages, Database triggers etc
• Analyzing the source data to know the quality of data by using Talend Data Quality
• Developed Oracle PL/SQL, DDLs and Stored Procedures and worked on performance and fine Tuning of SQL
• Developed the Talend Jobs as per the Business requirements
• Coordinating during Quality Assurance and User acceptance testing
• Prepared the unit test plan and unit test cases
• Coordinating the process of promotion of programs, jobs and scripts to test and production environment
• Project: Automation of CDD, Manual Opt-outs Business requests and various enhancements