PROFESSIONAL SUMMARY:

• 15+ years of experience in development, testing, implementation, post implementation support, and Project Management in order to meet the 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, Control M
• Developed effective working relationships with 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 the data warehouse to develop the code, Unit Testing, and documentation
• Certified Informatica Developer
• Excellent interpersonal and communication skills, and experienced in working with senior level managers, business users, and developers across multiple disciplines
• Experience in handling project in both Waterfall and Agile methodology
• Effectively managed globally dispersed teams of up-to 20 members

TECHNICAL SKILLS:

• Informatica
• Tidal
• Mercury Quality Centre
• Unix
• WinSCP
• Business Objects
• Oracle
• Toad
• Teradata
• Control-M
• SVN
• Micro Strategy
• Onsite Offshore coordination
• Putty
• Power Exchange
• Production Support
• Release Management
• Project Lead
• HP QC ALM
• TFS uDeploy

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, IA

Informatica lead Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed mappings by using transformations like Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, etc., to implement logics while coding a mapping.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from source systems like Oracle, XML and Flat files and loaded into Oracle.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager. wrote Unix shell scripts for file transfer, data manipulation, executing workflows, etc
• Create/modify Control M jobs to schedule workflows
• Involved in Unit testing, Iterative testing, by generating SQL queries to check whether the data loads into target are accurate, which was extracted from different source systems as per the user requirements.
• Involved in code review as per ETL/Informatica standards and best practices
• Prepared technical design/specifications for data Extraction, Transformation and Loading. Support for code deployment in QA and PROD environment and also responsible for code validation
• Responsible for resolving the tickets raised by end users and adhoc requests from client. This includes the data analysis, manipulating the production data to fix the issues (with client approval) and Close the ticket with resolution

Skills Used: Informatica 9.1, Oracle 11g, SQL Developer, UNIX, Putty, WinSCP, Control-M Scheduler, Team Foundation Server (TFS), BizTalk

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 the load statistics, analysis and resolve incase of any production issues, coordinate with business to fix any source file issues, coordinate with 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 the tickets raised by end users and adhoc requests from client. This includes the data analysis, manipulating the production data to fix the issues (with client approval) and Close the ticket with resolution
• Analysis existing code/process and apply performance techniques
• Coordinate with 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 the requirements and arrange for clarification sessions with Business to complete the requirement analysis
• Identify the requirement gap to analysis and get a clear understanding before the start of the coding design and also an exercise to minimize the requirement defects
• Responsible for Requirement Traceability Matrix
• Review & finalizing the 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. The audit includes the study of the issues and risk to the project. Based on the monthly project audit, the project health score will be calculated. Also as part of audit, the codes will be verified, in order to check, whether all the industry coding standards has 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 the best practice / enhancements to team
• Responsible for Level 2 production support, which includes analysis and resolution within specified SLA
• Responsible to update production job run books and inform Level 1 production support, in case of any job impact due to the new requirement / enhancements
• Responsible for task allocation and Project management
• Carryout the project quality assurance demonstration to project stakeholders
• Involve in project core team meeting to streamline the 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

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 the data flow, evaluating transformations and tuned accordingly for better performance
• Modified the shell scripts as per the business requirements
• Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems as per the user requirements
• Prepared and used test data/cases to 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 the manual operational steps by identifying the areas that could be automated and then did automation hence cutting the manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted with the creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented the change control requests (CCR) on a need basis from client side
• Delivered the reports to the 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 the manual operational steps by identifying the areas that could be automated and then did automation hence cutting the manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted with the creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented the change control requests (CCR) on a need basis from client side
• Delivered the reports to the 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 the manual operational steps by identifying the areas that could be automated and then did automation hence cutting the manual steps by 50%
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, and Prompts
• Assisted with the creation of schema objects, facts, attributes and set relationship
• Prepared Software Engineering Quality Process related documents
• Implemented the change control requests (CCR) on a need basis from client side
• Delivered the reports to the business owners on weekly/ monthly basis

Skills Used: Informatica, Oracle, Unix

Confidential

Database Programmer

Responsibilities:

• The objective of this project was the automation and centralization of various departments in the Educational Institutions .
• I designed and developed the database application, designed the database structure for an application, estimated storage requirements for an application and established an applications security measures during development.