Development Manager Data Warehouse
Resume:
Prabhakar Dukka
*********.*****@*****.***
Professional Summary
Self-motivated, result oriented, team player with extensive experience working and demonstrated End-to-End Data projects applying Agile method of delivery. Proficient in the areas of Enterprise Data Warehouse, Data Integration & Analytics, Data Migration, Data Management, Data Quality, ETL Architect, Data Governance & Application Support. Looking for a challenging opportunity within an organization that allows professional & personal growth.
Summary:
Extensive Data Integration experience using tools Informatica, SAS Data loader, Oracle as Developer and Tech Lead positions.
Experience in performing ETL design, architect, development, support activities and define load strategy for clients across Insurance, Finance, Telecommunication, Retail, Health Care, Manufacturing domains within Enterprise Data Warehouse (EDW) environment.
Experienced on preparing and putting documentation together for implementation plans for the projects and provided analysis and production support documents to other team for smooth transitions, Conversion of BRD’s to Technical documents like HLD, LLD and TDD for Developers to start work.
Strong experience in performance optimization of code with Informatica and Oracle using/implementing industry best practices, also involved in data profiling related activities.
Good working knowledge of Informatica, SAS, Oracle, SQL server databases and having experience of writing SQL and PL/SQL blocks including stored procedures, functions, packages, triggers etc.
Involved in Informatica / DB migration project deliveries.
Extensive experience in creating test plans, test scenarios, test cases and other documentation for project testing requirements and execution.
Proficient in all phases of Software Development Life Cycle (SDLC) and Software Testing Life cycle (STLC) using Agile and Waterfall.
Experience in Data Analysis, Validation, Cleansing & Verification of data and identifying data mismatches.
Ability to perform root cause analysis and document them as required and recognized and analyze trends in errors.
Expertise in validation of report/dashboard functionality developed using Tableau, Business Objects, by writing complex SQLs.
Experienced in Agile-KANBAN/Waterfall & ITIL model to deal with the development and change managements.
Skilled on scheduling tools like Control-M, Tidal.
Expertise in data modeling, analytical, reasoning, problem-solving and communications skills.
Demonstrate leadership’s skills by successfully leading high, medium scale projects and teams.
Experience
Intact Financial Corporation (Finance) (Apr 2023 – Till Date)
Lead Data Integration Specialist (Data & Analytics)
Migration of Intact applications (Entire Data pipelines) to Cloud platform (Technologies using Amazon, Snowflake, IICS)
• Data Analysis: Analyze the existing data in the legacy applications, understand its structure, quality, and relationships and help in designing an appropriate migration strategy;
• Data Mapping and Transformation: map the data elements from the legacy application to the new. Handle necessary data transformations, ensuring compatibility and consistency between the legacy data and the target system;
• Data Extraction: Extract the required data from the existing legacy applications, develop and implement extraction processes. Sources used Guidewire claims / policy systems, databases, files, APIs, XML parsing etc.
• Data Cleansing and Validation: Cleanse and validate the extracted data to ensure its accuracy, completeness, and consistency. Help with identifying and resolving data quality issues, performing deduplication, and applying business rules to ensure the integrity of the migrated data;
• Data Migration Strategy and Execution: review the present migration strategy that outlines the overall approach, sequence, and timeline for migrating the data from the legacy application to daily load approach; execute the migration plan efficiently, managing data transfers and ensuring minimal disruption to ongoing operations;
• Data Testing : Conduct thorough testing to verify the accuracy and integrity of the migrated data; define test cases, perform data reconciliation, and address any issues or discrepancies that arise during the testing phase; develop KPIs to report on the quality of the data migration effort;
• Documentation: document the entire data migration process, including data mapping rules, transformation logic, migration scripts, and any specific configurations;
• Production Support: Responsible for any high priority production issues to resolve, provide post-migration support, analyze and address data-related issues or questions; help optimize data management processes in the new environment
• Other duties as assigned like on call support for month end activities and help prod support team.
Technology Used: IICS – Data Integration, PowerCenter 10.4, Oracle 12c, Snowflake, SAS EG, Amazon cloud (S3, Lambda), Control M, UNIX, Github (Jenkins).
Manitoba Public Insurance (Nova project). (Finance - Insurance) (Oct 2021 –Mar 2023)
Data Migration Consultant
• Involved Analysis, Design, Development, Testing phases of Legacy Data Migration activities.
• Design and Implemented ETL and DB solution for Nova project Delivery.
• Working closely with Business team, Analysts, Architects, and other Developers within NOVA project
to manage the deliver expectations.
• Implemented and maintained development best practices developing ETL routines using Informatica in
for large data migration environment.
• Coordinated with customer to gather requirements and manage expectations converting into HDD and
LDD documents.
• Mentor, coordinated other team on development status, code review etc.
• Involved in creating complex mappings in Informatica using transformations also experience in
debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly
developed ETL components.
• Responsible for ETL design and architect, Code optimization, performance tuning Experience in
Designing Data warehouse components and ETL Scripts.
• Collaborate with development/Architect/Admin team to plan project sprints and develop status
reports for the projects.
Technology Used - Informatica 10.4.0, SQL Developer Management Studio 18.12.1
Hyundai Capital Canada Inc. (Finance - Capital Market) (May 2018 – Sep 2021)
Manager-Systems Develeopment (Data & Analytics)
• Oversee multiple projects across all phases of development, implementation, and Support
• Design and Implemented Enterprise Data Warehouse & reporting solution for Hyundai Capital Canada end to end solution.
• Working closely with different departments within Hyundai Canada and different vendors on data
exchange setup.
• Implemented and maintained development best practices developing ETL routines using Informatica in
a data warehousing environment and large data/tool migration.
• Coordinated with customer to gather requirements and manage expectations converting into HDD and
LDD documents.
• Collaborate with development/support team to plan project sprints and develop status reports for the projects.
• Mentor, coordinate offshore/onsite team on status development, code review etc.
• Involved in creating complex mappings in Informatica using transformations also experience in
debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly
developed ETL components.
• Responsible for ETL design and architect, Code optimization, performance tuning Experience in
Designing Data warehouse components and ETL Scripts.
Technology Used - Informatica 10.2, Oracle 12c, SQL Server, Tableau (Intermediate), UNIX, SAS Data Loader (Intermediate), JIRA, Salesforce Data loader (Intermediate), Python (Intermediate), AWS services (S3, Lambda, Athena, Glue Jobs, RedShift, Parquet, Steps) (Intermediate)
Intact Financial Corporation (Finance - Insurance) (Mar 2015 – Mar 2018,
Team Lead & Sr. Informatica Developer
Oversee multiple projects across all the phases of development.
Implement and maintain development best practices.
Supported development team to ensure the optimal progress and product stability for end users.
Coordinated with business/customers to gather requirements and manage expectations.
Responsible for loading data to Data Warehouse (EDW), Data Marts through intermediate staging tables reading source data from Guidewire claims / policy system in the form of XML messages, Halcion, Classic claim source systems, Intersystem DB for telephony data, flat files etc. and generate external feeds for business (Finance, Marketing, Risk) & fraud detection vendors like CANATICS, NET-REVEAL etc.
Loading Claims, Customer and Telephony related data to EDW by implementing business rules using Informatica transformations.
Responsible for preparing design and support documents to help smooth transition to other teams. And Conversion of BRD’s to Technical documents like HLD, LLD and TDD for Developers to start work.
Part of Data Analysis team to analyze the business requirements, system requirements, and data mapping requirement specifications (dimensions and facts) to provide industry standard solutions to client and documented the Functional test plan.
Transcribed ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS. Also responsible for System and Integration testing.
Developed UNIX scripts to automate the load process, restart from failure points, UNIX workflow scripts to be called from Control M scheduler and move, archive source/ target files.
Troubleshooting, debugging, resolving and escalating data related issues and validating data to improve data quality.
Working on delivery Process improvement by peer review and involved in performance tuning of existing & new ETL objects.
Trained and mentored team members on development process
Ownership of code promotion in lower environments and responsible for providing data to QA person by running daily and monthly end to end data load cycles for each release.
Technology: Informatica PowerCenter 9.6.1, Oracle 12c, SQL Server (SQL PL/SQL), Control M, UNIX, HPSM, ALM, MS Visual Source Safe.
Allstreeam (Telecommunications) (Aug 2014 – Dec 2014)
Team Lead & Sr. Informatica Developer
Core part of Data Analysis and Data model team to analyze the business requirements, system requirements, data mapping requirement specifications (dimensions and facts) to provide industry standard solutions to client.
Interacting with business to gather requirements and to propose the effective and efficient ETL design and solution.
Developed extracts for Vendors based on the Building master, Billing, Customer data.
Created simple/complex Informatica mappings to load dimension and fact tables.
Created/enhanced project templates for the technical requirements and design and testing documents.
Actively involved in the code review for ETL code and to give sign off.
Developed scheduling using Tidal and Informatica for informatica workflows.
Assist and support team members in performance tuning activities in Informatica and DB.
Responsible for end to end software testing life cycle for selected projects like Functional, Regression, System Integration Testing, User acceptance testing.
Providing data to billing system by using ETL process.
Technology: Informatica PowerCenter 9.5.1, Oracle 11g, DB2, SQL Server 2005, Cognos 11, Tidal, UNIX.
CGI Group Inc. (Consulting) (Jun 2012 - Aug 2014)
Technical Lead & Sr. Informatica Developer
Developed Data warehouse for a leading Health Care/Insurance Provider and Oil and Gas Manufacturer using Informatica as ETL tool.
Lead a team of 5 Informatica team and was responsible for near shore deliverables.
Interacted with Client and business to gather requirements and actively involved in the design phase of the projects.
Implemented CDC using Informatica Power Exchange
Developed extracts for Vendors based on the Enterprise data and sourcing data from web-based UI more real time data process source system.
Provide efficient suggestion and solutions to client on delivery. Developed many complex mappings and also involved in performance tuning of mappings and Database objects. Suggested proper new ETL for all data warehouse operations with proper analysis and selection.
Created/enhanced project templates for the technical requirements and design and testing documents.
Created standards and best practices for Informatica Coding.
Used WINCVS as Version control tool.
Actively involved in the code review for ETL code and to give sign off.
Developed scheduling using TIDAL for informatica workflows.
Created Informatica mapping to load fact and dimension tables.
Assist and support team members in performance tuning activities in informatica.
Deployment admin for deploying the ETL and DB code to QA, UAT environments for Tufts Client.
Technology: Informatica Power Center 9.5.1, Informatica Power Exchange CDC, Oracle 10-11g, Tidal, UNIX, Cognos 11 (Report/Query/Analysis studio).
KPIT Cummins Infosystems Ltd. (Consulting) (Apr 2007 - May 2012)
Techincal Project Manager.
Developed Data warehouse for a leading Retail, manufacturing clients using Informatica and Data stage as ETL tool.
Lead a team of 8 members and was responsible for onshore- offshore deliverables, coordination etc.
Involved in annual evaluation process for the team members and also conducted appraisal meetings.
Responsible for conducting weekly review meetings with client managers and presenting the status of deliverables.
Using PRISM/ITIL process to prioritize the production tickets.
Created a supply chain management application for a manufacturing client by creating a data mart.
Deployment admin for deploying the code to QA, UAT and Production environments.
Handled independent Modules for on-time delivery with minimal defects and involved in data modeling.
Created standards and best practices for Informatica Coding.
Actively involved in the code review for ETL code and to give sign off.
Created Informatica mapping to load fact and dimension tables.
Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.
Received appreciation awards from Client for on time Delivery of the project.
Created POC using Datastage and Informatica as data quality tool for a Telecommunication and Health care client.
Technology: Informatica 8.6.1, Datastage 8.1 Quality Stage Oracle 10g, Quality Center 9.2, UNIX, Business Object, CONTROL+M, Jira.
MindTree Consulting Ltd (Consulting) (Apr 2006 – Mar 2007)
Consultant / Sr. Informatica Developer
Developed Data warehouse for a leading Insurance clients in US.
Team Member for various data warehousing projects and successfully implemented the DW concepts.
Designed and automated Rejection Handling System for the Project which receives source files and bad records are sent back to business automatically.
Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.
Handled independent Modules for on-time delivery with minimal defects and involved in data modeling.
Received appreciation awards from Client for on time Delivery of the project.
Technology: Informatica 7.1, Erwin, ORACLE-9i, UNIX, Tidal, Flat files, Siebel
Tecnovate eSolution Pvt.Ltd (IT Consulting) (Aug 2005 – Mar 2006)
Technical Consultant / Informatica Developer
Developed Data warehouse for a leading Travel and Insurance clients in UK and Europe
Team Member for various data warehousing projects and successfully implemented the DW concepts.
Designed and automated Rejection Handling System for the Project which receives source files and bad records are sent back to business automatically.
Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.
Handled independent Modules for on-time delivery with minimal defects and involved in data modeling.
Received appreciation awards from Client for on time Delivery of the project.
Technology: Informatica 6.2, Erwin, SQL Server, SSIS, UNIX, Control M.
FORE (Software Development Center) (Education & Research) (Jan 2001 – Jul 2005)
System Analyst cum Programmer
Developed In-house projects on different modules (HR, Accounts, Admin etc.).
Technology: Oracle, Visual Basic.
Education
Master’s in computer application from Maharishi Dayanand University.
Bachelor of Science from Sambalpur University.
Training Courses
5 Days Full time corporate PMP (PMBOK) Workshop
5 Days Full time corporate SAP BI (SAP Net viewer) Workshop.
4 weeks of part time training on BIGDATA methodologies and tools (HIVE, Map-reduce, PIG)
Masters in cloud technologies program (AWS) by Edureka.
Areas of Knowledge
Industries
Finance - Insurance, Capital Market, Health Care, Telecommunications, Retail, Education & Research
Integration/Data Tools:
Informatica PowerCenter, Informatica IICS, SAS Enterprise edition, Salesforce Data loader, AWS services (S3, Lambda, Athena, Glue, Parquet, Steps, Python)
Analytics:
Tableau (Visualization) / Business Objects
Databases
Oracle, SQL Server, Snowflake
Scheduling Tools
Tidal, Control-M
Modelling Tool
ERWIN
Languages
C, C++, SQL, PL/SQL, Visual Basic-6.0
Testing Tool
HPQC-ALM
Others
HPSM (Service, Incident Management), JIRA – Ticketing, Servicing Change Request system. ITIL,
ADO(Azure Dev Ops)
Contact this candidate