SUMMARY

• 10 years of experience in IT Industry involving in full life cycle development including requirement gathering, Business analysis, design, development, testing, implementation, maintenance and documentation of Data warehousing models using ETL tools in Insurance and Investment industries.
• Learning AWS Architect for enhancing Technical skills.
• 10 years of hands - on experience on Informatica PowerCenter and ETL tools, Data Mapping, Transformation and Loading in complex and high-volume of data processing applications.
• Good hands on MDM and SFDC implementation.
• Tool migration from Sagent to Informatica.
• Working on Agile Methodologies and have experience of Scrum Master role.
• PowerCenter Upgrade Testing from 9.6 to 10.1
• Having extensive programming and debugging skills in ETL Tools like Informatica PowerCenter, and IDS, databases like Oracle, Greenplum, Microsoft SQL server, Sybase.
• Extensive experience in data virtualization tool like Informatica Data Services (IDS).
• Have good experience of Win batch Scripting, decent knowledge of UNIX shell scripting.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Involved in tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Performed Team Lead activities both at Onsite and Offshore and mentoring of team mates.
• Excellent understanding of the System Development Life Cycle (SDLC). Involved in analysis, design, development, testing, implementation, and maintenance of various applications
• Worked extensively on SQLs and SQL optimization techniques.
• Developed Complex Informatica mappings to integrate data from Oracle, DB2, Excel, flat files.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design
• Ability to work in a geographically distributed virtual team environment and to build relationships with internal and external stake holders.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6 and 9.1, Greenplum, IDS, Sagent, SFDC

Scheduling tools: Control M and Maestro

RDBMS: Oracle 11g, SQL Server, Sybase

DB Tools: TOAD

Languages: SQL, PL / SQL, XML, Win batch and Shell Scripting

Modeling Tools: MS Visio, MS Word

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

ETL Developer/Team Lead/ETL Business Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Working on Agile Methodologies for end to end work.
• Played role of Scrum Master in team.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Participate in reviews with build teams as well as client business teams and technical architects
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Learnt and used Data Virtualization tool Informatica Data Services.
• Created and developed mappings in IDS.
• Performed Pushdown Optimization in IDS and helped improving the proficiency and run times for IDS mappings.
• Support client in User Acceptance Testing and quick turn-around on defects

Business Analyst

Confidential

Responsibilities:

• Identifying areas for business improvement.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions, especially the incorporation of data warehousing techniques in system.
• Guided new members on the project on resources and material available and the goals for future.
• Analyzed and documented Business requirements and detail design of the software for full understanding of the business .
• Developed questionnaires and organized meetings emphasizing the scope of the project in order to provide key initiatives in working with users in defining project and system requirements.
• Developing maps and flowcharts of current and future business processes.
• Reporting on the likely impact of process modifications.
• Flagging up potential problems at an early stage.
• Developing a clear understanding of existing business functions and processes.
• To document the business process by identifying the requirements and preparing excellent documentation on business requirements.
• Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Acted as single point of contact between Project Management and appropriate IT groups
• Experience in co-coordinating with business and IT across all phases of software development life cycle.
• Independently handled offshore team members in order to track the progress for the assigned task, helped them in overcoming the code issues, understanding the client requirements, improvise the business process and standards, handled the critical issues, raise any risk/issue on time to avoid any delay in the delivery of their modules.
• Developed and supported in extraction, transformation and load process (ETL) for a Data Warehouse from legacy systems (Sagent) using Informatica and provided technical support.
• Interpret transformation rules for all target data objects from Sagent to Informatica to support the transformation.
• Involved in understanding the project requirements, Design and code review discussions with the client team.
• Involved in coordination with the offshore team and providing the daily updates for the required projects.

Confidential, Hopkinton, MA

Sr. Informatica Developer/Support Analyst

Responsibilities:

• Developed ETL mappings using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Prepared Hyperion reports and queries using Hyperion Reporting tool.
• Build the new universe as per the client's requirements by identifying the required tables from Data mart and by defining the universe connections.
• Prepared many reports by using cross-tabs, Sub Reports and drill mode as per the requirement of the Business.

Tools: Used: Informatica 8.6.1 , SQL Server, Hyperion, Toad, Control M, Kalido, Quality Center