SUMMARY

• Over 15+ years of experience in the field of Information Technology and specializing in Data Warehousing Technologies and ETL . Experience in managing multiple projects and end - to-end project activities right from People Management, Program Management, Team development, Requirements Gathering upto UAT and Production Support.
• Expertise in Financing, Banking, Telecom and Retail.
• Expertise in Design, Development, and Support and Administration activities in Informatica
• Led multiple on-prem Application migrations to AWS Cloud.
• Lead overall ETL processes ( architecture, performed build, tested and deployed activities
• Analyze different process flows that are present and establish a project plan for successful lift and shift implementation.
• Established reputation as thought leader delivering mission-critical projects and programs within budget in deadline-driven environments.
• Working on AWS services like EMR ( Elastic Map Reduce), EC2 instances,
• Extensively worked on Redshift/Oracle Database Performance tuning on Queries, Copy and Unload commands
• Worked with code commit in AWS, GIT repository/Bit Bucket
• Expertise in Performance Tuning (Informatica and SQL Queries)
• Developed the scripts to deploy the code in EMR (Elastic Map Reduce) system.
• Extensively involved in designing objects, creating Reports, creating Database objects, Data transformation and data loading.
• Interacting with product owner and business to understand the project requirements
• Varied experience in leading teams across different projects has helped in being; an initiative to new solutions, committed to deadlines that eventually resulted with maximum benefits to the clients.
• Received Customer Appreciation Certification for successfully delivering the projects without any defects within scheduled time.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping. Done Error Handling for dimension tables at Informatica Power Center
• Created the Various complex mapping at Informatica
• Successful track record in implementing and scheduling workflows and tasks using Informatica Power Center Workflow Manager and Workflow Monitor
• Extensively worked with Informatica objects using Push down Optimization.
• Provided hands-on technical and functional input to design, maintenance, build, integration and testing of complex software components according to functional and technical design specifications. Reviewed and provided feedback and suggests solutions including operability perspective. Performed code review and participates in test reviews.
• Conduct Project Reviews, Team Meetings / Scrum Meetings, Defect Analysis and Prevention Meetings and interfacing with upper management
• Effective people manager with demonstrated success in building and sustaining high performance teams
• Establishes the scope, plan and direction for Long Team, self-directed and projects integrating multiple technical functions.
• Being an excellent team player have performed manager/lead role and has always served to be the interface point to the technical team to convert solutions into the exact needs of the customer.
• Executing Annual Performance reviews for team members and making recommendations for promotions, demotions, pay increases, leave/vacation etc

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.4/10.2/9.6/9.1/9.0.1/8. x/7.x, SSIS

Databases: Oracle 12c/11g/9i, Netezza, MS SQL Server 2008/2012, DB2, Teradata

Database Utilities: Toad for Oracle10g, SQL*Loader, SQL Navigator

Shell Script: UNIX

Scheduling Tools: Autosys, Tivoli, Control M

Reporting Tools: Business Objects 6.5

Data Modeling Tools: ER Studio 8, ERWIN 4.0, MS Visio

QA Test Tools: Informatica Data Analyst, HP Quality Center 9.2

Bug Tracking Tools: HP Quality Center, Jira, Enterprise Tester

Languages: SQL, PL/SQL, Shell Scripts, SQL *Plus

Helpdesk Tools: Remedy, CCAT,ISQ

Operating Systems: UNIX, LINUX, OS/390, Windows 2000/98/NT/95/XP/Serve, DOS, Sun Solaris 2.6/2.8, Confidential AIX-UNIX

Deployment Tools: Bit Bucket

PROFESSIONAL EXPERIENCE:

Confidential

Lead AWS/ETL Developer

Responsibilities:

• Interacted with business for requirement clarifications and translating it to detailed technical requirements to the team
• Manage user expectations, issues and requests based on technical specifications, scope and requirements.
• Working on AWS services like EMR ( Elastic Map Reduce), EC2 instances,S3, Lambda.
• Delivered and deployed on-prem DW/DVH and RAD applications to AWS Cloud
• Worked with multiple teams to address cloud related issues and delivered application in-time.
• Involved in creating Informatica mappings, mapplets, worklets and workflows
• Reviewing mapping, workflows and output data and verifying the data loaded into targets as per the Business Logic
• Estimate the effort based on the Functional requirements
• Assures quality of design and implementation of projects
• Support the production processes, and provide immediate solution in case of any failure in processes.
• Identify performance issues at both databases and Informatica, and provide solution to address it.
• Involved in Analysis, Design, Coding, Testing and Implementation
• Provide leadership and guidance to coach, motivate, and lead team members
• Ensure the completeness of project deliverables within estimated time and quality
• Manage the relationship with the client and all stakeholders
• Conduct annual performance appraisals of team members (Hexaware) and take appropriate action (firing if needed) depending on the performance of team members.
• Hire the software engineers with required skills (Hexaware)

Environment: s: Informatica PowerCenter 10.4/10.2, Linux, Oracle 12

Confidential

Lead ETL Developer

Responsibilities:

• Ensures and reviews that the business/technical requirements are understood and translated to system requirements consistent with framework/standards in order to meet requirements definition.
• Working on AWS services like EMR ( Elastic Map Reduce), EC2 instances,S3, Lambda.
• Delivered and deployed on-prem Liability application to AWS Cloud
• Worked with multiple teams to address cloud related issues and delivered application in-time.
• Copied the data between RedShift and S3 locations.
• Worked on Unload scripts to copy the data from Redshift to S3.
• Involved in creating the SQL Queries in Redshift database
• Developed the Python and Unix Scripts.
• Involved in creating Informatica mappings, mapplets, worklets and workflows
• Reviewing mapping, workflows and output data and verifying the data loaded into targets as per the Business Logic
• Evaluate and review coding standards and guidelines, code review & work product delivery checklist for standardization
• Manage user expectations, issues and requests based on technical specifications, scope and requirements.
• Provide leadership and guidance to coach, motivate, and lead team members
• Interacted with business for requirement clarifications and translating it to detailed technical requirements to the team
• Evolve the existing software system applications and architecture in various areas as needed.
• Participate and Conduct Project Reviews, Senior Management Reviews, Team Meetings, Defect Analysis and Prevention Meetings and interfacing with upper management
• Reviews and validates the target metrics of the project from technology perspective like tools usage, re-usable frame works and feasibility in order to assist in achieving the target.
• Work with various technical group to make sure the workflow is maintained without any data loss

Environment: s: Informatica PowerCenter 10.4/10.2.0/10.1.1 , Linux, Oracle 11g, IDQ

Confidential

Project Lead

Responsibilities:

• Prepared Low Level designs document that is used to develop Informatica mappings.
• Reviewing mapping, workflows and output data and verifying the data loaded into targets as per the Business Logic
• Provided Tech solution on performance related issue and ETL related issues to the team
• Preparing the documentation of each process
• Involved in promoting the code into production and provided support for the same.
• Involved in Design, Coding, Testing and Implementation
• Involved in creating Informatica mappings, mapplets, worklets and workflows
• Involved in the Project Planning, Execution, Monitoring and control
• Participate and Conduct Project Reviews, Senior Management Reviews, Team Meetings, Defect Analysis and Prevention Meetings and interfacing with upper management
• Manage user expectations, issues and requests based on technical specifications, scope and requirements
• Evolve the existing software system applications and architecture in various areas as needed
• Provide leadership and guidance to team members to their optimum performance levels and career development
• Constant collaboration with the data architecture and the delivery teams for any clarifications / approvals
• Maintained a log of requirements and tracked the progress on a daily basis
• Conducts investigations of considerable complexity pertaining to the development of new designs, methods, materials or processes, and investigates possible applications of the results
• Ensure high customer service, satisfaction and repeat business
• Advise customers to meet governance, architecture, process, best practices and strategic goals by involving the relevant groups
• Identify and manage resource requirements, required skill sets, training plans required for project execution
• Hire the software engineers with required skills
• Conduct annual performance appraisals of team members

Environment: s: Informatica PowerCenter 9.6.1, Linux, Oracle 11.2, Erwin

Confidential

Technical Lead

Responsibilities:

• Provided Tech solution on performance related issue and ETL related issues to the team
• Prepared Low Level designs document that is used to develop Informatica mappings.
• Reviewing mapping, workflows and output data and verifying the data loaded into targets as per the Business Logic
• Preparing the documentation of each process
• Involved in Design, Coding, Testing and Implementation
• Involved in creating Informatica mappings, mapplets, worklets and workflows
• Involved in promoting the code into production and provided support for the same.
• End to end project management from preparation of proposals, project estimates, resource management, Project Reviews
• Managed a team of developers, testers and technical architect
• Conduct Project Reviews, Team Meetings, Defect Analysis and interfacing with management
• Conducted the workshops and joint sessions with Business Users
• Interacting with Business Analyst and business to understand the project requirements
• Analyzed the reports generated and studied the process involved
• Developed Business Requirements Document, UAT Test cases
• Provided walkthrough of business requirement document (BRD) to various stakeholders such as Technical Architect, Developers
• Constant collaboration with the data architecture and the delivery teams for any clarifications / approvals
• Performed the role of an Onsite coordinator and Technical Lead with tasks including knowledge sharing on requirements, work allocation to the offshore team members and review the deliverables of the team

Environment: s: Informatica PowerCenter 9.5.1, Teradata 14, Oracle 11.2, Unix

Confidential

Technical Lead

Responsibilities:

• Perform requirement analysis to collate the reporting requirements from the end users.
• Design datamarts which can accommodate data from transactional systems of Deka Bank. This demands high understanding of the existing structure of the DDP warehouse, databases as well as the business representation of the data.
• Performed the role of an Onsite coordinator and Technical Lead with tasks including Knowledge transfer on requirements, Work allocation to the offshore team members and review the deliverables of the team.
• Estimate the effort based on the Functional requirements
• Prepared the Low Level Design document based on the function understanding
• Schedule meetings with the customer to understand the business needs of a Service Request.
• Schedule meetings with the offshore team to communicate the requirements, and provide technical guidance for the team to implement the solution for the requirements.
• Assures quality of design and implementation of projects
• Support the production processes, and provide immediate solution in case of any failure in processes.
• Identify performance issues at both databases and Informatica, and provide solution to address it.
• Involved in Analysis, Design, Coding, Testing and Implementation
• Provided production support and worked on developing enhancements
• Knowledge Transfer sessions to team members on application functionality

Environment: s: Informatica PowerCenter 9.1.0/9.0.1 , DB2 v9.0, Oracle10g, Confidential Optim, Confidential Rational Synergy 7.1, UNIX, Confidential Tivoli

Confidential

Technical Lead

Responsibilities:

• Designed the extraction, transaction and transformation (ETL) Architecture for Finance Data Warehouse (FDW) and implementing Architectural concepts in FDW
• Provided Tech solution on performance related issue and ETL related issues to the team
• Involved in building the Conceptual, Logical and Physical data model
• Prepared and Published ETL Design and Strategy documents
• Prepared Low Level designs document that is used to develop Informatica mappings.
• Attended meetings with Architectural Team and provide detailed status to the team.
• Involved in creating Informatica mappings, mapplets, worklets and workflows
• Reviewing mapping, workflows and output data and verifying the data loaded into targets as per the Business Logic
• Preparing the documentation of each process
• Involved in promoting the code into production and provided support for the same.
• Involved in Design, Coding, Testing and Implementation
• Provided production support and worked on developing enhancements
• Knowledge Transfer sessions to team members on application functionality

Environment: s: Informatica PowerCenter 8.6.1, DB2 v9.0, PeopleSoft 9.0/8.8, HP QualityCenter, UNIX, Control-M

Confidential

ETL Developer

Responsibilities:

• Extraction order, Source to Target Mapping.
• Preparing Quality Review Checklists Document.
• HLD and LLD creation of ETL mappings.
• Unit Test case preparation
• Coding of ETLs and Unit Testing.
• Quality check for code and Test Results.
• Involved in UNIX Scripting.
• Involved in Universe changes like Adding classes, Objects, Joins and Context.
• Generated reports using Business Objects tools querying database.
• Produced reports and exported to excel based on the user requirements.

Environment: s: Informatica PowerCenter 7.1.4, UNIX, Oracle 9i, Business Objects 6.5

Confidential

Project Engineer

Responsibilities:

• Quality check for code and Test Results.
• Testing loop checking
• Commissioning
• Design detailed engineering, ereection, calibration and instattion