SUMMARY

• Over 8 years of experience as Informatica ETL Consultant in implementation, Customization, Upgrade and Maintenance
• Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development,Testing and Deployment.
• Redesigning the ETL Load strategy and created the Informatica mapping design documents
• Handling ETL tasks like developing mappings, running workflows and monitoring it.
• Extensively used ETL to load data from Teradata and Flat files to Data Warehouse.
• Used Transformations like Aggregator, Filter, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator for extraction, transformation and loading of data directly from different heterogeneous source systems like flat files and relational tables
• Expertise in Application Designer, Process Scheduler, PS - Query, Tree Manager, Integration Broker, Excel to CI, Web Services.
• Used the File Layout for Data Import and Export from the flat files and CSV files using Application Engine and People Code.
• Developing and managing all appropriate project management documents including project plan, resource, estimates, team roster and assignments, issue management, risk management, change control, and periodic status reports
• Attending project meetings to discuss the challenges and the way to solve them in fixed deadline
• Making transition of the requirement details to the various teams across the project.
• Closely working with the Testing team in creating test case preparation and promotion of Informatica ETL Objects from Development to QA folders
• Simplification of the existing logic to load the tables according to Business logic
• Engaged in Inter-company Knowledge Transfer.
• Responsible for getting various approvals to make the code run in Production region
• Creation of Application management team support documents, Knowledge sharing documents for handing over the project to Application Management team.
• Involved in creating various reporting and status related documents.
• Involved in Point In Time Refresh of the production Unix servers.
• Involved in various account level activities like interviewing candidates on behalf of client.
• Engaged in conducting Informatica related ILP programs for freshers.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Effective communication skills and record for coordination between different teams in the account and across different locations.
• Project delivery under stringent timelines and high pressure.
• Key strengths include Excellent analytical and problem solving skills, quick learning on the job, good communication skills, good interpersonal skills and a good team player.
• Successfully completed end-to-end PeopleSoft implementation and enhancement for different client systems.

TECHNICAL SKILLS

Data warehousing Tools: Informatica 8.x/9.x

Secondary Skill: PeopleSoft 8.8/8.9/9.0/9.1

PeopleSoft Financials (FIN) 9.0/8.4x: People Tools 8.x, Application Designer, XML Publisher, Application Engine, File Layout, Data Mover, Process Scheduler, Application Messaging, Component Interface, STAT and Control-M.

Database: DB2, Oracle7.x/8.x/9.x/10g/11g

Operating System: Unix, Windows NT, Windows2007, Windows XP.

Reporting Tools: PeopleSoft Query, SQR 4.x/6.x

Programming Languages: People Code, SQL, C++

Other: HPQC,Control-M and SDLC concepts

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Informatica Consultant

Responsibilities:

• Data Analysis of the in-scope systems for the clone.
• Analysis of various interfaces, in-bound data feeds, applications from end-to-end.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, work let designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially affected by proposed change(s).
• Participated in discussions with the client/end-client on Reporting Requirements.
• Planning and execution as per the guidelines from the customer.
• Migration of Unix components in various environments HPSA.
• Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios
• Interaction with the offshore team on a daily basis on the development activities.
• Prepared various metrics and dash boards for Project management purposes.
• Involved in preparation of various white papers on proposed technical solutions.
• Responsible for reporting of project status on regular intervals.

Environment: Informatica Power Center 9.1, Oracle 9i, MS-SQL Server,SQL Developer, Windows XP,MS Office and Delimited Flat files

Confidential, Atlanta, GA

Informatica Consultant

Responsibilities:

• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially affected by proposed change(s).
• Data Analysis.
• Discussions with the client/end-client on Reporting Requirements.
• Planning and execution.
• Migration of components in various environments using Informatica repository manager.
• Support to testing team in smooth execution of batch in CIT, SIT and PT phases.
• Support to the application in warranty phase.
• Creation of various support documents, Knowledge sharing documents for project to Application Management team.
• Involved in preparation of project management activities like weekly reports, dashboards, batch schedule tracker, incident management, etc.
• Involved in creating various reporting, project specific and status related documents with as per the client requirements.
• Developed and managed all appropriate project management documents, including project plan, resource estimates, project budget, project schedule, team roster and assignments, issue management, risk management, change control, and periodic status reports.
• Developed various PS Queries in order to help the client day-to-day activity.
• Involved in the Strategic planning for the Project back up’s and also responsible for migrating projects across multiple environments using STAT Tool.
• This involved running and analyzing audit and compare reports before migrating to different environments.
• Reviewed and implemented Technical design specifications based on Functional Documents.
• Maintained effective - dated trees within HRMS to make sure appropriate departments and companies were added.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Created queries according to user requests.

Environment: Informatica Power Center 9.1, Oracle, Windows 2000, SQL Server, Microsoft Excel, SQL, Application Engine, File Layout, SQR, PS Query.

Confidential

Informatica Consultant

Responsibilities:

• Development and testing of complex Informatica mappings using transformations like Router, Lookup (connected and Unconnected) and Update strategy transformation for various data loads.
• Performed complex defect fixes in various environments like QA, UAT, etc to ensure the proper delivery of the developed jobs into the production environment.
• Troubleshooting of issues in the production environment and helped in resolving the same.
• Used debugging tools to debug the flow of data and found the exact issues where expected data was not populated correctly.
• Worked closely with the Business Analyst, Database and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work articles
• Creating and Scheduling Control-M Jobs.
• Involved in weekly status meeting and prepared weekly status reports.
• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Performance tuningby optimizing the sources targets mappings and sessions.
• Tested mappings and sessions using various test cases in the test plans.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL
• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially affected by proposed change.
• Created and administered CSRs (Change/Service Request) in STAT for each business processes and migrated the retrofitted objects from one PeopleSoft Instance to other using STAT.

Environment: Informatica Power Center 8.x, UNIX, Microsoft Excel, SQL, Application Engine, File Layout, PS Query

Confidential

Informatica Consultant

Responsibilities:

• Involved in documentation of different business requirement and estimation.
• Involved in weekly status meeting and prepared weekly status reports.
• Interaction with the business users in gathering requirements and sign offs for functional and technical specification.
• Designed, developed and done end-to-end testing of additional requirements
• Creation of test plan, test strategy and test approach.
• Created Test scripts, Traceability Matrix and mapped the requirements to the test cases.
• Done Peer review of test scripts and prepare the QA measurement forms.
• Attended the QA Audit meetings and test artifacts review.
• Participated in the Integration testing and Unit Testing along with the Development team.
• Conducted System, GUI, Smoke and Regression testing identified application errors and interacted with developers to resolve technical issues.
• Actively involved in Analysis, Specification Preparation, Coding and Testing of the application and reports.
• Created technical design, unit test plan and test case documents for the development
• Involved in development of inbound and outbound interface.
• Involved in creating and scheduling Jobs in Control-M.
• Done testing for the critical customized process for Confidential
• Involved in testing for customized Application engine such as Mass Event 457.
• Worked on Goldmansachs customized pages such as Leave, Termination and FWA pages.
• Created Test Script and Test data.
• Documented defects as part of SIT and UAT.
• Extensively used SQL scripts/queries for data verification at the backend.
• Executed SQL queries, stored procedures and performed data validation as a part of backend testing.
• Used SQL to test various reports and ETL Jobs load in development, testing and production
• Performed negative testing to test the application for invalid data, verified and validated for the error messages generated.
• Responsible for Generating Progress Reports and Updates to Project Lead Weekly including with test Scenarios Status, Concerns and Functionality outstanding.
• Involved in review and quality analysis of all deliverables and coordination with PS Admin team in migration of project from one instance to another instance.
• Maintained all the impacted objects and distribution of same across team members.
• Coordinated with the team member in completing the assigned tasks and conducted reviews for quality and standards.
• Remediation and testing of all inbound and outbound interfaces as part of upgrade.
• Involved in analysis of SQLs used in the interfaces and reports for performance tuning and coordination with performance testing team.
• Involved in supporting the Users and the Onsite team during the full UAT phase.
• Involved in status meeting, internal quality audits and project closure audits.
• Created and administered CSRs (Change/Service Request) in STAT for each business processes and migrate the retrofitted objects from one PeopleSoft Instance to other using STAT.
• Worked with Prompt tables, Dynamic prompt tables and also worked in SQL Views and Dynamic Views to optimize the Query performance and used views as search records.
• Created new online Objects like Run Control Pages along with validations to run the SQRs and Application Engines based on requirement.
• Provided support for critical production issues.
• Coordination with Onshore and Offshore teams.
• Involved in Year End activities.
• Creation of Test Summary report, traceability Matrix, Test Script Index.
• Monitor the testing project in Quality Center and ensuring defects are being entered, tested, and closed.
• Analyzed, documented and maintained Test Results and Test Logs.

Environment: Informatica 9.1, SQL, HPQC, Peoplesoft 8.4 and Control - M

Confidential

Informatica Consultant

Responsibilities:

• Worked as a Team member in requirement gathering of customer's needs, analysis, planning and estimation etc.
• Involved in gathering and analyzing the requirements and preparing business rules
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Designed and developed inbound and outbound interfaces by using Application Engine such as Virtual Edge Hire and Transfer process
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Implementing Control-M tool for Confidential to automate all interfaces and other process to monitor on a regular basis and to simplify user manual intervention
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Documented defects as part of SIT and UAT
• Documented CRs as part of enhancement
• Involved in Production cut-over activities
• Extensive involved in creating and tuning Unix batch scripts to archive and automate the batch process and critical process

Environment: Informatica 9.1, SQL server,SQL, PL/SQL, Toad 10.6, UnixFlat files and PS-Query