SUMMARY:

• Over 8 years of IT Experience in Analysis, Design and Development in various business applications as an ETL developer with major contribution in Informatica B2B Data Transformation (DT) studio, Informatica Power Center 9.x/8.x, Informatica B2B Data Exchange (DX).
• Experienced in analyzing Business and Functional requirements, studying the Source Systems, thoroughly designing the target by going through the Functional Specification Document and one - to-one interaction.
• Extensively worked on Streamer, Parser, Mapper, Serializer concepts and intake of several input formats varying from Banking Industry layouts, Healthcare Industry layouts.
• Extensively worked on Informatica Designer Components- Source Analyzer, Designer, Transformation Developer, Mapplet and Mapping Designers.
• Extensively worked on Informatica B2B Data Exchange Setup from Endpoint creation, Scheduler, Partner setup, Profile setup, Event attributes creation, Event status creation, etc.
• Extensive usage of Reusable and Non reusable Transformations-Expression, Aggregator, Filter, Router, Normalizer, Sorter, Lookup, XML transformations, Update strategy, Sequence generator, Stored Procedure, Joiner.
• Extensive use of Informatica Debugging in mapping and used Session Log File to trace the errors while loading into targets.
• Experience in different project methodologies such as Agile and Waterfall.
• Experience in SQL, PL/SQL.
• Experience with diverse source and target systems like CSV/Flat Files, and XML Files etc.
• Worked closely with Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled.
• Experience in scheduling meetings with Business Users and Coordinating with offshore team.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS:

ETL Tools: Informatica DT-Studio, DX, Power Center

Databases: PL/SQL, Oracle.

Operating Systems: Windows, Unix, Macintosh

Others: webMethods, Volante, WTX,MS Office, HTML

Version Control Systems: SVN Tortoise, CVS

PROFESSIONAL EXPERIENCE:

Confidential

Informatica B2B Tech Lead

Responsibilities:

• Worked on Flexible mapping concept using Informatica DT to intake any format layout driven through the Excel. Switch codes dynamically based on layout of file.
• Developed several Informatica mappings for Extraction/Transformation.
• Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, Connected/Unconnected Lookup, and filter.
• Creation of B2B DX partners, profiles, workflows, endpoints for onboarding clients.
• Worked on Split process, Merge process of multi- client files using Informatica B2B Data transformation and Informatica B2B Data Exchange.
• Played role as being SME (Subject matter expert) for Informatica B2B DT & DX.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Providing technical insight and support to the System Analysts - Reviewing and analyzing existing system structure to provide solutions for enhancing and improving systems.
• Providing effort estimates - To be able to analyze the scope of work and providing Work Hour Estimation to business.
• Participating in technical collaboration meetings and providing project management teams with periodical reviews on implementation status as well as providing weekly reports on task plans for custom software implementation.
• Worked as Senior System Analyst and Tech LEAD to Onshore/offshore team and coordinated with onsite management and supported as a primary point of contact.
• Working on Proof of Concepts to come up with possibilities of implementing Informatica B2B DT studio.
• Worked closely with the production support team to help resolve issues and defects encountered.
• Taking trainings to new project teams on the Agile Methodology by explaining on Sprint Planning, Sprint execution, Retrospective, etc.

Environment:: Informatica B2B Data Transformation 9.6.1, Informatica Power center 9.6.1, Informatica B2B Data Exchange, TOAD.

Delivery Module Lead/Technical Analyst

Responsibilities:

• Analyzed the existing business rules and understood the client’s new reporting requirements by interacting with the users in the LOB (Line of Business).
• Worked with Business Analysis team in gathering the requirements and created Functional and specification documents.
• Developed several Informatica mappings for Extraction/Transformation.
• Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, Connected/Unconnected Lookup, and filter.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Used debugger in Informatica Designer to resolve the issues regarding data thus reducing project delay.
• Providing technical insight and support to the System Analysts - Reviewing and analyzing existing system structure to provide solutions for enhancing and improving systems.
• Providing effort estimates - To be able to analyze the scope of work and providing Work Hour Estimation to business.
• Managed Change control implementation.
• Participating in technical collaboration meetings and providing project management teams with periodical reviews on implementation status as well as providing weekly reports on task plans for custom software implementation.
• Worked as System Analyst and as a LEAD to offshore team and coordinated with onsite management and supported as a primary point of contact.
• Working on POC's to come up with possibilities on building code as part of migration from WebMethods to Informatica DT.
• Worked closely with the production support team to help resolve issues and defects encountered.
• As part of technology upgrade involved in extensive training in Volante mapping tool and developed complex use case to ensure capability of the tool.

Environment:: Informatica B2B Data Transformation 9.5.1, webMethods, Volante, PL/SQL and UNIX.

Project Lead

Responsibilities:

• Closely worked with Business Analysis team and Technical Analysis.
• Created various Business related documents i.e. Business Design Document (BSD), Technical Design Document (TSD), Unit test cases and System test cases documents.
• Identify/understand detailed business requirements, developing specifications for data sources, and providing subject matter expertise.
• Designed various mappings using transformations.
• Involved in configuring and running Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Created different tasks (sessions, worklets and workflows) in the workflow manager to test the mapping during development.
• Designed, developed upgraded and tuned new & existing workflows/session/mappings.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Developed several re-usable Mapplets/Transformations for data conversions, handling null values, convert etc.
• Created documents which clearly specify the purpose and transformation logic of each mapping, following applicable standards and conventions.
• Involved in various support activities i.e. SIT, UAT and Prod environments.
• Performed unit testing and documented the unit test plan and its results.
• Attending regular status meeting to update the project on daily basis with onsite.
• Lead several PID’s with enough resource and gave on time deliveries without any escalations.
• Responsible for proper utilization and billing of resource.
• Played Defect Coordinator role to ensure defect free deliverables.
• Scheduled/led Weekly calls with Project specific PMO's to address risks in the project if any.
• Prepared weekly status report and sharing with client.

Environment: Informatica Power Center 8.6.1, Informatica Data Transformation 9.0.1, Informatica Data Exchange 9.0.1, Oracle, Windows XP/7 and UNIX.

Project Lead.

Responsibilities:

• Involved with the clients to understand the business needs and coordinated with the team to achieve the needs of the business.
• Understanding the business requirements and enhancing the existing design based on requirement.
• Creating requirement traceability matrix.
• Used Informatica Designer to Create, Load, Update mappings using different transformations.
• Responsible for estimation preparation, offshore billing.
• Submitting monthly project metrics and make sure project status remains in green.
• Successfully loaded data into different targets from various source systems like Oracle data base, Flat Flies, SQL Server etc into Target Database.
• Performed the development and testing of Extraction and transformation mappings using DT-studio.
• Creating mappers, parsers & Serializer in Data transformation.
• Involved in discussing Requirement Clarifications with multiple technical teams.
• Conducting meetings with SMEs for solution document, workorder walkthrough.
• Creating Change management reports before project implementation.
• Involved in Unit and Integrating testing of Informatica Sessions.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production Environment.
• Coordinating with offshore and onshore manila team and making sure business is not interrupted.
• Monitoring Informatica power center workflows and expedite in case of failures.
• Prepared and used test data cases to verify accuracy and completeness of ETL process.

Environment: Informatica Data Transformation 9.0.1, Informatica Data Exchange 9.0.1,Windows XP.

Project Lead

Responsibilities:

• Closely worked with Business Analysis team and Technical Analysis.
• Created various Business related documents i.e. Business Design Document (BSD), Technical Design Document (TSD), Unit test cases and System test cases documents.
• Identify/understand detailed business requirements, developing specifications for data sources, and providing subject matter expertise.
• Designed various mappings using transformations.
• Involved in configuring and running Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Created different tasks (sessions, worklets and workflows) in the workflow manager to test the mapping during development.
• Designed, developed upgraded and tuned new & existing workflows/session/mappings.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Developed several re-usable Mapplets/Transformations for data conversions, handling null values, convert etc.
• Created documents which clearly specify the purpose and transformation logic of each mapping, following applicable standards and conventions.
• Involved in various support activities i.e. SIT, UAT and Prod environments.
• Performed unit testing and documented the unit test plan and its results.
• Attending regular status meeting to update the project on daily basis with onsite.
• Lead several PID’s with enough resource and gave on time deliveries without any escalations.
• Responsible for proper utilization and billing of resource.
• Played Defect Coordinator role to ensure defect free deliverables.
• Scheduled/led Weekly calls with Project specific PMO's to address risks in the project if any.
• Prepared weekly status report and sharing with client.

Environment: Informatica Power Center 8.6.1, Informatica Data Transformation 9.0.1, Informatica Data Exchange 9.0.1, Oracle, Windows XP/7 and UNIX.

WTX Developer

Responsibilities:

• Worked on rules extraction from the WTX Mercator Maps and documenting.
• Reviewed documentation created by the new joiners.
• Worked with Clients to understand their needs.
• Attended technical document and code walkthrough
• Coordinated with the on shore team and communicate project status and issues.

Environment: s: WTX, Windows XP.

WTX Developer.

Responsibilities:

• Collaborated with Business analysts for requirements gathering and analysis.
• Coding involving policy rule coding, sequence flow, status flow, and dictionary entries.
• Involved in Unit Testing.
• Providing deployment and post deployment support.

Environment: WTX, PL/SQL, Windows XP.

Research and Development.

Responsibilities:

• Involved in Requirement Analysis.
• Learning Weka Technology & transferring knowledge across team.
• Creation of Algorithms for identifying fraudulent claims.

Environment: Net Beans, Windows XP.

Programmer Analyst Trainee.

Responsibilities:

• Undergoing extensive software development training, banking and healthcare domain training and dovetail exam.