SUMMARY

• Architect/Data Modeler with 11 years of professional experience in designing and developing ETL / Data warehouse solutions.
• Responsible for analysis, requirement gathering, ETL design & development of Commercial Data warehouse and provide Reporting solutions, End to End integration solution & testing, UAT test scenario preparations and controlled production deployment
• Successfully delivered many projects and enhancements by directly working with business stakeholder, multiple vendors within a project and identify the issues before they arise and keep management posted with proper mitigation plan.
• Responsible for managing 15 member offshore development & testing team and keep tasks rolling on time, on budget without issues.
• Managed 16 member 24/7 Application Support and Maintenance team and successfully handled many critical tasks with changing priorities and followed ITIL methodologies for Incident/Problem/Change management process.
• 6+ years of Data modeling experience using ERwin data modeler and created Dimensional, Star, Snowflake models based on business needs.
• 9+ years of ETL development experience using Informatica PowerCenter 7x/8x/9x/10x.
• 8+ years of experience in using Oralce database and developed SQL, PL/SQL, Dynamic PL/SQL, Stored procedures, Packages, Functions and used SQLLoader for data loads.
• 4+ years of experience in using Teradata database and developed SQL, Stored procedures, BTEQ Scripts and used FastLoad, MultiLoad utilities for data loads.
• 8+ years of experience in writing Shell Scripting, Perl commands(FlatFile handling commands), Informatica Repository commands(pmrep, pmcmd) and FTP commands
• 1 year of SAP BODS Development and Support experience
• Periodically analyze the application performance and identify the ETL/DB bottle necks and apply appropriate performance tuning techniques.
• Expertise in working with different data sources/targets like SAP, XML, CSV, Flat files and Relational tables.
• Extensive experience in working with various Infrastructure admin teams for application deployment, server migration/upgrade and disaster recovery.
• Strong team leadership skills and ability to perform individually.

TECHNICAL SKILLS

Data Modelling Tool: ERWin DM r9.8

ETL Tools: Informatica Powercenter 10x/9x/8x/7x Informatica Metadata Manager 9x, SAP BODS 4.0

Reporting/BI Tools: SAP - Business Objects 4, Tableau 2019.2

Data Quality Tools: Informatica Data Quality 8x(IDQ), Informatica Analyst 9x

Database: Oracle 12c, Teradata 16.2, SQL Server 2018

Testing Tools: HP Quality Center, JIRA

Operating System: Windows, Linux

Scheduling Tool: Autosys, UC4

Microsoft Tools: Project, Access, Visio

Domain: Finance, Industry & Equipment, Life Sciences

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse Architect

Responsibilities:

• Interacting with the business representatives to understand the requirements
• Prepare Effort & Estimate, Project plan & Resource plan
• Interact with Source team and get the source data model and understand the data granularity
• Perform impact/gap analysis between Source and Target system
• Document Requirement Specification and prepare reporting wireframes and get the sign-off from the Business.
• Prepare/Update data model (Start/Snowflake) and create ETL Technical design documents for the given requirements and get the signoff from Solution Engineers(client).
• Coordinate development & testing team and keep tasks rolling on time, on budget without issues
• Identify issues before they arise and keep management posted with proper mitigation plan
• Created many custom Star/Snowflake schemas in DW for delivering business needs.
• Developed flexible & parametrized ETL solutions to address ad-hoc reporting/business requirement
• Used Teradata external loading utilities like FastLoad & MultiLoad effectively
• Do extensive performance tuning of workflows before promoting to Test environment
• Designed many reusable mapplets to reduce development time and deliver tasks faster
• Providing SQL solutions to Dashboard and Mobile app reporting teams
• Used Java Transformation, Normalization, Transaction control transformations
• Do peer-review and ensure the code standards are followed and the requirements are fulfilled
• Knowledge Transfer to QA team and review the Test plans and Scripts
• Co-ordinate E2E/UAT testing with UAT users
• Prepare/Review deployment instruction documents and validate the deployment and perform post production checkout testing
• Provide statistics to business stakeholders during hyper-care period
• Provide Knowledge Transfer to Application Support team and help them in root cause analysis and resolving support issues

Confidential

ETL Tech Lead / Sr. Developer - Development

Responsibilities:

• Understand the data granularity of the upstream systems and the existing application
• Redefined Product-SKU Integration rules, enhanced the ETL architecture and created/modified ~45 ETL mappings and finally improved the Product-SKU % hierarchy match from 32% to 86%
• Provided automated data standardization solutions for the data elements-Brand, Dosage Form, Market and minimized 80% of manual standardization effort
• Prepared mock-up screens for the better CHIPP portal design and get it reviewed by business stakeholders and communicate the same to offshore .Net developers
• Developed 15 new PL/SQL Packages for the new functionality added in the .Net
• Optimized existing 8 PL/SQL packages and achieved 40% performance improvement
• Led the development with 2 ETL developers and 2 .Net developers
• Overall the CHIPP usage got increased and the end user count increased from 140 to 380 within 3 months
• Got appreciation from Business Sponsors, Directors(Consumer Health, Client) and Accenture leadership for the successful delivery of this optimization project

Confidential

ETL Tech Lead / Sr. Developer - Development

Responsibilities:

• Had direct connect/relationship with Client Managers to discuss about operational activities
• Led the Application Support & Maintenance with 16 member offshore team
• Successfully handled many critical tasks with changing priorities and followed ITIL methodologies for Incident/Problem/Change management process.
• Provided ETL solution for integrating new sources and provided automation solution for 40 manual reports
• Developed 4 custom data marts using Start/Snowflake model
• Applied performance tuning techniques and eliminated bottle necks in both ETL and PLSQL procedure level
• Led the Continuous Improvement activities and saved lot of application support manual efforts
• Prepared Informatica upgrade test plans and scripts using Informatica Repository queries
• Implemented automated application performance monitoring solution using Informatica Repository queries and applied performance tuning techniques to improve the SLA time

Confidential

Sr. Developer

Responsibilities:

• Understating business requirements by directly connect with SMEs
• Prepared the BODS STM(Source to Target Matrix) based on Global Templates(SAP)
• Used SAP, flat file, relational tables as both source and target
• Run Data Quality checks using IDQ
• Implemented conversion rules given by business and load the legacy data into SAP systems using Informatica DMI Prepare transformation (for LSMW) and IDOC Prepare transformation (for IDOC)
• Validate the data in the SAP ECC system and send the error records back to SME
• Involved in 5 roll-out projects for different countries

Confidential

Developer

Responsibilities:

• Involved in all phases of SDLC
• Prepared LLD, Test Scripts and Deployment instruction documents
• Used XML, flat file, relational tables as both Source and Target
• Implemented slowly changing dimension methodology to keep track of historical data.
• Developed Exception Management System(EMS) which captures the exceptions that raised in disclosure process by using XML data transfer between ETL and Web UI
• Used Team Based Development and Deployment Groups
• Developed Shell scripts, Autosys-JIL jobs
• Prepared Run book for production support