SUMMARY

• I'm an ETL professional with 10+ years of experience on Data warehouse, Informatica Power Center/TDM, Oracle, SQL Server, UNIX and leading distributed Development and Testing teams among others.
• I’m strong in exhibiting interpersonal skills and I am an enthusiastic learner with an ability to work hard.
• I’m currently an ETL Team lead developer at TDM to support Confidential and CSS with data analysis, DB modeling, data transformation, data validation processes, data sub setting, XML messages creation and supporting data load proof of concepts for AWS.
• I have vast experience working closely with each of the project teams - Business Stakeholders, Program/Project Manager, Business Analysts, Data/ETL Architects, various development and production support teams in implementing the BI solutions.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Experience in Leading teams across geographies
• 7+ years managing transformation efforts on waterfall and agile methodologies.
• 10+ years of experience on developing ETL processes and analyzing existing ETL processes on Informatica Power Center, Oracle, SQL
• Worked closely with each of the project teams - Business Stakeholders, Program/Project Manager, Business Analysts, Data/ETL Architects, various development and production support teams in implementing the BI solutions.
• Hands on experience in Tuning Mappings, Identifying and resolving Performance bottlenecks in various levels like sources, targets, mappings, and sessions.

TECHNICAL SKILLS

• Informatica PowerCenter
• UNIX Shell Scripting
• Trained:
• Informatica TDM
• XML Core Standards (XML/Schemas)
• Big data
• ETL analysis, modeling and development
• Banking Fundamentals
• AWS EC2, S3, Redshift
• Oracle SQL Developer
• Testing for Agile
• Phyton
• Data Mapping & Transformation
• HP Quality Center
• Microsoft BI Stack
• MS SQL Server
• Data Analytics
• Test Environment Management
• Batch Scheduler Autosys / Control M
• Functional Test Planning
• Agile Methods (ADM for Distributed Agile Scrum XP)
• Testing Strategy and Planning
• Data Validation & Cleansing
• Informatica Data Quality
• TOAD - Oracle

PROFESSIONAL EXPERIENCE

Confidential

Test Data Management Team Lead

Responsibilities:

• Analyze data needs, design and create ETL processes and XML views to generate the messages needed to feed the client systems.
• Develop Sub setting routines on Informatica TDM to reduce Production DB dependencies.
• Create automation routines to merge sub setting end to end tasks.
• Gather and analyze client requests, define and build DB structures based on schema files.
• Create XML source code to pull data from the DB and generate XML files needed by the users.
• Monitor the team’s daily task status and make sure all the user stories complete with in the sprint
• Work with business analyst and product owner to understand the business need of a feature, defining it into user stories based on the requirements and making the team to work on the tasks.
• Act as liaison between business, project management, application team, and developers to gather and understand the requirements to develop data processes and messages creation.
• Coordinate with my manager to plan and allocate the work across the team, provide support and KT's to share best practices and expand the team capabilities to offer better solutions to our client.
• Organize periodic KT session to spread the knowledge obtained from different applications across all Atlanta team.
• Manage and allocate the work of my team, give trainings and develop new skills to provide a better service to the client.
• Build automated processes to transform data into XML messages to feed FNM applications.
• Analyze XSD files to define the required DB design to be used for each development.
• Perform maintenance, enhancements and/or development work for existing ETL processes.
• Lead the efforts of data transformation and XML messages creation delivered to the client

Tools: Informatica Power Center, TDM, XML/XSD(XML Spy), UNIX, Oracle SQL Developer -Toad, among others

Confidential

QA Team Lead

Responsibilities:

• Manage work allocation of 6+ professional resources.
• Monitor the team’s daily task status and make sure all the user stories complete with in the sprint.
• Plan the activities to be performed on each sprint and delegate the work accordingly.
• Participate on annual performance sessions with upper levels to make recommendations for raises and promotions.
• Support the delivery center on creating job descriptions, interviewing candidates and provide feedback in order to hire employees.
• Manage the efforts for setting up the Migration environments, extract and load production and test data and generate difference reports for users.
• QA point of contact for tickets and changes related to ETL/back end testing or other DB validations.
• Creation of best practices for environment setup and batch failures resolution.
• Coordinate, monitor and fix any failure found on QA batch.
• Coach and advice testers on topics related to MIG, batch execution, fix job failures, back-end tickets.
• Functional testing support.
• Test Environment Setup.
• Drive back end efforts like plan work schedule, setup and test environment, test execution.

Tools: UNIX, Autosys, SQL/DB2, Quality Center, SQL/DB2, among others