SUMMARY

• Over 9 years of IT experience in Analysis, Design, Development andImplementation with focus on Data Warehousing applications for Banking and Telecom domain on Informatica/Teradata/Oracle/UNIX/ControlM.
• Hands on experience across all stages of SDLC including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Worked on various kinds of BI Solution Projects which include Customization, Enhancement, Data Migration, Data Integration, Data Conversion and Data Mart Projects using Informatica PowerCenter.
• Experience in leading teams in delivering the code with perfection in terms of Accuracy, Reusability, Performance, Maintenance achieving maximum customer satisfaction.
• Excellent analytical and problem solving skill. Pro - active and easily adaptive to new environment. Ability to plan, prioritize and execute multiple requirements with a high degree of efficiency and accuracy.
• Excellent problem-solving, communication, analytical and interpersonal skills to execute tasks smoothly independently or as a part of a team.
• Experience in interacting with Clients, multiple teams and meeting tight schedules.
• Experience of working on Agile methodology and Agile techniques like: User Stories, Continuous Integration, Automated Testing, Agile Games.
• Knowledge about tasks, backlog tracking, burndown metrics, velocity, user stories etc.
• Participated in the PI Planning for project held in Dublin, June 2019. Actively contributed in planning of the new features, dates, dependencies among teams and stakeholders.

TECHNICAL SKILLS

• Informatica PowerCenter 8.6/9.6
• Oracle 10g/11g
• Teradata 12/13/15Unix (Sun Solaris) / Putty
• ControlM v8
• SQL Developer
• HP ALM
• WinSCP
• Tortoise SVN
• GIT Stash
• Atlassian JIRA
• Nexus
• Source Tree
• BitBucket
• Jenkins

PROFESSIONAL EXPERIENCE

Confidential

Application Development Team Lead / Scrum Lead

Responsibilities:

• Lead and coach scrum team.
• Responsible of facilitating daily scrum/stand-up meetings, sprint planning and retrospective meetings.
• Leading the project team to achieve specific project milestones and deliverables.
• Responsible of tracking and removing impediments.
• Involved in estimation and planning.
• Mentor the team members and ensure the correct use of scrum process and try to improve the efficiency of the development team.
• Responsible for on boarding new project team members and integrating them into the project/organization by providing them with a clear vision of the project.
• Managing and leading the team with compliance to their deliverables, timesheets and appraisals and responsible for their overall growth and development in project.
• Participated in the PI Planning for next quarter held in Dublin, June 2019. Actively contributed in planning of the new features, dates, dependencies among teams and stakeholders.

Confidential

Technical Lead and Sr. Informatica Developer

Responsibilities:

• Requirement Gathering, analysis, design & develop as per business requirement.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, lookup, expression, aggregator, joiner, filter, router transformations.
• Performance tuning of the ETL code and SQL queries for better performance of the ETL load.
• Working alongside management and solution designers to ensure strategic data plans.
• Managing and leading the team with compliance to their deliverables, timesheets and appraisals and responsible for their overall growth and development in project.

Confidential

Sr. Analyst and Informatica ETL Developer

Responsibilities:

• Developing various ETL components including analysis, design, build, testing and implementation.
• Hands on experience on code build and deployment using tools like JIRA, Maven, Nexus, GIT Stash and Jenkins.
• Worked in Agile under scrum team.

Confidential

Sr. Software Engineer and ETL Developer

Responsibilities:

• Developing new ETL components required for individual change requests and documenting the same.
• Involved in the performance tuning of the ETL objects and SQL queries and database objects for better performance of the ETL load.
• Analysis, estimation, and fixing of the high priority work queues within the time frame.

Sr. Software Engineer and ETL Developer

Confidential

Responsibilities:

• ETL design and development for populating newly built custom objects
• Creating Shell script for file handling, trigger workflow from UNIX and other similar tasks.
• Creating design documents (FSD), Release Checklist document for production migration.
• Responsible for end-to-end development and deliver error free code with proper documentation within timelines.
• Mentoring the new members of the team in providing Knowledge Transitions on the flow of work in the project based on Client Requests.
• Responsible for co-ordination with Onsite in task delivery in terms of timely query resolutions, follow-up.

ETL Developer

Confidential

Responsibilities:

• Analysis, design and developing using Informatica mappings for different data marts using SCD and CDC logic
• Creating UNIX Shell script for sending the notification email and other tasks.
• Involved in activities like ESP Scheduling document, design documents for upcoming Projects, peer code reviews and QA.
• Worked on Maintenance requests and fixing ETL code and making minor enhancements to existing ETL code of Production.
• Automation tasks like collection of data statistics on the existing production jobs.
• Mentor junior ETL Developer to come up to speed for the ETL execution.
• Being responsible for co-ordination with Onsite in task delivery in terms of timely query resolutions, follow-up.