SUMMARY

• 13 years of experience in development, testing, implementation, post implementation support, and Project Management in order to meet teh deadlines for successful completion of tasks/projects
• Experience in using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, processing tasks using Informatica Designer/ Workflow Manager
• Experienced in using ETL tools like Informatica (PowerCenter) Designer, Repository Manager, Administration console
• Experienced in performance tuning of Informatica (sources, mappings, targets and sessions)
• Experienced in scheduling Informatica jobs using scheduling tools like Tidal, AutoSys
• Developed TEMPeffective working relationships wif client team to understand support requirements
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data Warehouse development from requirements gathering for teh data warehouse to develop teh code, Unit Testing, and documentation
• Certified Informatica Developer

TECHNICAL SKILLS

• Informatica
• Tidal
• Mercury Quality Centre
• Unix
• WinSCP
• Business Objects
• Autosys
• Toad
• Teradata
• Oracle
• SVN
• Micro Strategy
• Production Support
• Putty
• Onsite Offshore coordination
• Release Management
• Project Lead
• HP QC ALM

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Informatica Developer/ Lead

Responsibilities:

• Manage and distribute work to offshore team and lead for timely and defect free deliverables
• Handle 8 offshore resources and individual task allocation
• Involved in requirement gathering on new requirements /enhancements. And responsible for preparing and getting sign off from client on requirement understanding document, design document and Unit test case scenarios
• Experienced as single point of contact to client for enhancement and support related activities
• Support for code deployment in QA and PROD environment and also responsible for code validation
• Responsible for Production support activities like Jobs monitoring, log teh load statistics, analysis and resolve incase of any production issues, coordinate wif business to fix any source file issues, coordinate wif DBA to resolve any table space or file system related issues. And also responsible for deliverables out of daily/weekly/monthly jobs
• Responsible for resolving teh tickets raised by end users and adhoc requests from client. dis includes teh data analysis, manipulating teh production data to fix teh issues (wif client approval) and Close teh ticket wif resolution
• Analysis existing code/process and apply performance techniques
• Coordinate wif other application teams, in order to avoid production job conflicts due to dependency
• Responsible for status report to management on weekly basis

Skills Used: Informatica 9.1, Oracle 11g, UNIX, TOAD, Putty, WinSCP, Tidal Enterprise Scheduler, Team management

Confidential,West Chester, PA

Informatica Developer/ Lead

Responsibilities:

• Analyze teh requirements and arrange for clarification sessions wif Business to complete teh requirement analysis
• Identify teh requirement gap to analysis and get a clear understanding before teh start of teh coding design and also an exercise to minimize teh requirement defects
• Responsible for Requirement Traceability Matrix
• Review & finalizing teh coding and deliverables
• Design and create Autosys jobs to perform various tasks like file watcher jobs, executing informatica workflow etc. (creation of JIL)
• Involved in implementation of ETL performance tuning techniques like Session Partitioning, Incremental Aggregation, Indexing lookup condition columns, optimizing SQL query, etc
• Point of contact for project audits. Teh audit includes teh study of teh issues and risk to teh project. Based on teh monthly project audit, teh project health score will be calculated. Also as part of audit, teh codes will be verified, in order to check, whether all teh industry coding standards TEMPhas been adhered.
• Prepare QA/PROD implementation plan and support on QA/PROD code deployment
• Responsible for code validation after post deployment.
• Study existing Informatica, Oracle codes and suggest teh best practice / enhancements to team
• Responsible for Level 2 production support, which includes analysis and resolution wifin specified SLA
• Responsible to update production job run books and inform Level 1 production support, in case of any job impact due to teh new requirement / enhancements
• Responsible for task allocation and Project management
• Carryout teh project quality assurance demonstration to project stakeholders
• Involve in project core team meeting to streamline teh requirement and process
• Involved in Interview process to recruit technical resource for DWBI practice group
• Responsible for status report to management on weekly basis

Skills Used: Informatica 8.6, Oracle 10g, UNIX, TOAD, WinSCP, Autosys Scheduler, Tortoise SVN, Business Objects, Project Management

Confidential, Chennai, TN

Informatica Developer/ Lead

Responsibilities:

• Developed mappings, sessions, and workflows in Informatica PowerCenter
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter
• Identified performance issues in existing sources, targets and mappings by analyzing teh data flow, evaluating transformations and tuned accordingly for better performance
• Modified theshell scripts as per teh business requirements
• Involved inUnit testing, Iterative testingto check whether teh data loads into target are accurate, which was extracted from different source systems as per teh user requirements
• Prepared and usedtest data/casesto verify accuracy and completeness of ETL process

Skills Used: Informatica PowerCenter 7.1, Oracle SQL/ PL/SQL, TOAD, MicroStrategy, UNIX, Team management

Confidential

Development Lead

Responsibilities:

• Created Informatica mappings, sessions, workflows for loading fact and dimension tables for data mart presentation layer
• Used reusability components like parameter file, mapping variable, mapplet
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Involved in task allocation and team management
• Handled team size of 20 members

Skills Used: Informatica 8.6, Informatica Versioning, Oracle (SQL, PL/SQL), UNIX, TOAD, Putty, Tortoise SVN, Team management

Confidential

Analyst

Responsibilities:

• Involved in development, testing, and operations as well as performance tuning
• Reduced teh manual operational steps by identifying teh areas that could be automated and tan did automation hence cutting teh manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted wif teh creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented teh change control requests (CCR) on a need basis from client side
• Delivered teh reports to teh business owners on weekly/ monthly basis

Skills Used: Informatica 7.2, Oracle (SQL, PL/SQL), Unix, Business Objects, Team management

Confidential

Analyst

Responsibilities:

• Involved in development, testing, and operations as well as performance tuning
• Reduced teh manual operational steps by identifying teh areas that could be automated and tan did automation hence cutting teh manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted wif teh creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented teh change control requests (CCR) on a need basis from client side
• Delivered teh reports to teh business owners on weekly/ monthly basis

Skills Used: Informatica 7.2, Oracle, Unix, Business Objects, Team management

Confidential

Analyst

Responsibilities:

• Involved in development, testing, and operations as well as performance tuning
• Reduced teh manual operational steps by identifying teh areas that could be automated and tan did automation hence cutting teh manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted wif teh creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented teh change control requests (CCR) on a need basis from client side
• Delivered teh reports to teh business owners on weekly/ monthly basis

Skills Used: Informatica, Oracle, Unix