SUMMARY:

• IT professional with around 10.6 years of experience, primarily worked in the domain of financial services, Telecom, Accounting & Reconciliation, Risk Analytics and Employee Self Services performing various roles and responsibilities. Experience has been focused in development and implementation of various data warehouse Business intelligence projects with strong Technical skills, Analytical ability and Functional skills. Expertise lies with most aspects of SDLC including requirements analysis, documentation, design, development, Testing, implementation and deployment. Led data warehouse projects End to End by providing business Intelligence, data integration and reporting solutions.
• Experience includes Analysis, Architect/Design, Develop, Deploy, Test and Support of Data Warehousing using Informatica Power Centre.
• 10.6 years of experience in using Informatica Power Centre 9.6.1/9.5.1, 8.x/7.x in end to end ETL implementations.
• Stupendous experience in Informatica Power Centre, Informatica Power Exchange and Metadata Manager.
• Extensive experience & proficient in the development of ETL processes with a good understanding of source to target data mapping, ability to define, capture Business rules in data extraction, transformation and loading data using Informatica Power Centre tool.
• Expertise in working with cross functional teams, technical teams and senior business & stakeholders in enterprise data warehousing implementations.
• Good experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from non - relational sources like flat files, XML Files and excel sheets.
• Implemented best practices and using trained employees in the Informatica Power Centre.
• Hands on Experience in UNIX Shell scripting in automating the ETL process.
• Experience in debugging mappings. Identified bugs in existing mappings by analysing the data flow and evaluating transformations and emphasized on Performance of mapping Optimizations.
• 8 years of experience on Business Objects.
• Good working knowledge in OLAP Tools Business Objects 6, BOXI R2, BOXI R3 for building Enterprise reports.
• 3 years of experience in OFSAAI Data Entry Forms and Queries, Excel upload, Metadata Restore Archive Utility and Datamodel creation and upload process.
• Informatica Certified Developer from Informatica Corporation USA.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experienced in preparing design documents, mapping process documents, Unit Test Plans for Data Warehousing projects ensuring the data meets the business requirement and for better maintenance.
• Strong technical background, and possess excellent analytical & Communication skills, creativity, leadership qualities, team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.
• Enthusiastic about learning new concepts & Emerging technologies.
• Responsible for Planning, Scheduling, Task Distribution and Tracking.
• Compliance of SDLC in Project life cycle.
• Coordination/leading on different project activities across systems.
• Integrated business area's in single platform which was previously distributed across SAS, SQL Server, and Desktop application.
• Lead team to create best practices and automation across multiple process improvements
• Estimation and budgeting.
• Effort and Cost variance analysis.
• Team coordination including mix of Business, Senior Management, IT Team (BA, Development, and Testing Teams) resides across different locations/countries.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Centre 9.6.1/9.5.1 /8.1.X/7.1.X, Informatica Power Exchange, Metadata Manger, Informatica IDQ

OLAP/BI Tools: Business Objects XI/6, Reveleus OFSAAI(Oracle Financial Services Analytical Applications)

Operating System: Windows XP, Windows 2000, Windows Vista and UNIX, LINUX

Databases: Oracle11g/10g/9i/8i, Teradata, MS-SQL server 2008, MS-SQL server 2012

Scripting: UNIX Shell Scripting

Languages: SQL, PL/SQL

Tools: CA7 Scheduling, Autosys, Harvest, Endevor, TOAD, Erwin, HP ALM, Service Now, Udeploy

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Informatica Technical Lead

Responsibilities:

• Interacted with business users for requirement analysis of new development applications and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Conducted business and technical analysis to gather functional requirements, identified business rules and transformation associated with relevant data domains, designed a Data Integration Hub to facilitate data movement across all environments.
• Designed and developed Informatica ETL process to integrate data from over 80 sources into IHC Enterprise Data Warehouse, composed of the OFSAA and Moody’s Analytics Data Mart. The covered Data Domains includes General Ledger, Loans, Security, Derivatives and Referential. Source data was a mix of Oracle database, flat and XML files.
• Performed Data cleansing, Data Quality checks, and Business validations to improve decision-making capabilities and support transactional systems and master data processes.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Developed Unix Framework Architecture to facilitate pre and post ETL processing requirements and provide logging mechanism for ETL processes scheduled using Autosys job scheduling tool.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Developed, executed, documented Unit test plans, Integration test plans and validating the results with Business Analyst.
• Performed SIT and end to end Integration testing, troubleshot and resolved issues.
• Responsible for deliverables with reviews conducted, creation of code documentation and responsible for uploading the Test results into ALM.
• Scheduled and created dependency to execute ETL workflow using Autosys scheduler.
• Managed a team of offshore for both development and testing to deliver projects.

Environment: Windows, UNIX, Informatica PowerCenter 9.6.1, Oracle, Service Now, Autosys Scheduling Tool, Jira, ALM

Confidential, Pittsburgh, PA

Informatica Lead

Responsibilities:

• Status call with Client - Involved in the daily status call discussion on requirements and change request. Gather all new requirements and understand the business logic for new change request from Subject Matter Experts (SME).
• Defect Triaging - Analysis of defects reported for identifying the root cause and validate the need for code or design changes.
• Impact Analysis - Studying the impact of code and/or design change.
• Modifying the Design for the required changes as per the change requests received.
• Informatica ETL High Level and Detailed Designing - Creating/Updating High level and low level design for the received new requirements.
• Design Review - Reviewing the Low level design as per the Design checklists for the changes as per the requirements.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Powercenter of Informatica/Power Exchange
• Involved in the developing of Developed various mappings, mapplets, Sessions and workflows.
• Extracted data from Flat files, Mainframe files, Oracle and SQL Server Database to build an Operation Data Source. Applied business logic to load the data into Application Data marts.
• Extensively worked on SQL Server Database (T-SQL, Query optimization etc.).
• Improve quality of data through standardized processes.
• Involved in writing UNIX shell scripts to automate the business process.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Responsible for deliverables with reviews conducted, creation of code documentation and responsible for uploading the Test results into ALM.
• Scheduled and created dependency to execute ETL workflow using CA7 scheduler and Endevor.

Environment: Windows, UNIX, Informatica PowerCenter 9.6.1, SQL Server Database, Service Now, Harvest, Udeploy, CA7 Scheduling Tool, ACORN 5G

Confidential, Pittsburgh, PA

Informatica Lead

Responsibilities:

• Analyzing on the Business requirements to understand the business specifications.
• Preparing the design documents for the requirements.
• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by users.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power centre of Informatica/Power Exchange
• Involved in the developing of various mappings, mapplets, Sessions and workflows.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client
• Migration of the code in to higher environments using the Harvest tool.
• Providing the demo to users on the requirements how those are developed and working.
• Participating in the Requirements walkthrough sessions with BA’s and providing suggestions from development team.
• Coordinating with testing team on the defects/Tasks.
• Involved in Migration of code in to Production environment

Environment: Windows, UNIX, Informatica PowerCenter 9.6.1, SQL Server Database, Service Now, Harvest, Udeploy, CA7 Scheduling Tool

Confidential, Pittsburgh, PA

Informatica Lead

Responsibilities:

• PNC migrating all the applications to a new data center (GFB), Green Field Bridge, STX application also needs to migrate to GFB environment.
• Before migrating in to GFB environment, it is required to fix all the nonstandard critical issues.
• Informatica admins identified all the nonstandard critical and non-critical issues.
• Fixed all the nonstandard critical and non-critical issues as per the PNC GFB environment which are identified by Informatica admin team.
• Modified the STX ETL Mappings/ Sessions/Workflows as per the GFB development standards.
• Once Informatica Admin team approved the Survey then started migrating the code in to GFB environment.
• Worked with Informatica Admin team to set up the Informatica environment for STX application in GFB in 9.6.1 version.
• Migrated the Informatica code and Linux code in to new GFB environment using Harvest and Udeploy.
• Worked on creation of CA7 scheduling for all ETL jobs, modifying the DOC05 and AGENTS updating with the new GFB environment related Servers/AGENTS.
• Migrated the code in to QA environment using Harvest and Udeploy.
• Migrated the Informatica code and Linux code in to production by using the Service now CR.
• Performed the sanity check and make sure all the required code migrated to Production environment.

Environment: Windows, UNIX, Informatica PowerCenter 9.5.1/9.6.1, PL/SQL, Oracle 11g, Toad. Service Now, Harvest, Udeploy, CA7 Scheduling Tool

Confidential, Pittsburgh, PA

Informatica Lead

Responsibilities:

• Analyzing on the Business requirements to understand the business specifications.
• Preparing the design documents for the requirements.
• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by users.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica/Power Exchange
• Involved in the developing of various mappings, mapplets, Sessions and workflows.
• Implemented the Audit balance controls (ABC) for all the ETL jobs which are currently in production.
• Implemented the Amount fields Reconciliation, Build a process to compare sum of balances between current day and prior day. Validate difference against Threshold limit and confirm there is not deviation, Generate email notification if there are any deviations.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client
• Migration of the code in to higher environments using the Harvest tool.

Environment: Windows, UNIX, Informatica PowerCenter 9.5.1, PL/SQL, Oracle 10g, Toad, Harvest, ALM

Confidential, Pittsburgh, PA

Informatica Lead

Responsibilities:

• Analyzing on the Business requirements to understand the business specifications.
• Preparing the design documents for the requirements.
• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by users.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Powercenter of Informatica/Power Exchange
• Involved in the developing of various mappings, mapplets, Sessions and workflows.
• Extracted data from Flat files, Mainframe files, Oracle and SQL Server Database to build an Operation Data Source. Applied business logic to load the data into Application Data marts.
• Involved in writing UNIX shell scripts to automate the business process.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Writing Unit and System Test Plan / Test Cases, Involved in Unit, Integration, System testing.
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Creation of Defi Screens and Excel Entity Mappings based on the user requirements using Oracle Reveleus Tool
• Working on the Data model and upload it to database using the Revelus Tool.
• Scheduled and created dependency to execute ETL workflow using CA7 scheduler and Endevor.

Environment: Windows, UNIX, Informatica Power Centre 9.5.1, Power Exchange, Metadata Manager, PL/SQL, Oracle 11g, Toad. OFSAAI Reveleus, Harvest, ALM, CA7 Scheduling Tool, Udeploy

Confidential

Informatica Lead

Responsibilities:

• Involving in production maintenance for the entire system.
• Identify the bugs in the system and fixed those bugs by enhance the mappings and the sessions.
• Handling enhancement request for the entire OneVIEW systems.
• Trouble shooting implementation / post implementation issues, handling trouble Service requests/concerns raised by users.
• Monitor the whole Reporting and Information Management System and ensure that the reports are distributed on time
• Frequent communication with the customers to ensure that the reports are distributed on time within SLA or intimate them if there is any delay
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Developing Business Objects reports based on various business user requirements.
• Scheduled the reports using CMC and Infoview.
• Maintenance of CMC and Infoview, scheduling reports, monitoring of reports in CMC.

Environment: Informatica PowerCenter 7.1.1, Business Objects 5.1.9 / Business Objects XI R3, Windows, Sun Solaris (UNIX), IPMS, BMC REMEDY, Oracle 9i, Toad, PL/SQL, EXCEL converter, PerlConverter, Compass and KINTANA

Confidential

Informatica Developer

Responsibilities:

• Actively participated in doing the Major / Small / Emergency projects which comes as an enhancements or project request
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Fixing various data and application issues using Informatica and business objects.
• Involving in production maintenance for the entire system.
• Trouble shooting implementation / post implementation issues.
• Monitor the whole Reporting and Data warehouse System and ensure that the data being loaded in to the system on time.
• Developed reports in Business Objects XIR3 as per the user requirement.

Environment: Informatica 9.1.1, Business Objects XI R3, Windows, Sun Solaris (UNIX), BMC REMEDY, Oracle 10g, Toad, PL/SQL

Confidential

Informatica Developer

Responsibilities:

• Involving in production maintenance for the entire system.
• Trouble shooting implementation / post implementation issues.
• Identifying existing bugs or any performance issues in the existing system
• Monitor the whole Reporting and Data warehouse System and ensure that the data being loaded in to the system on time.
• Analyzing or identifying Data Issues if any be it related to Brio /PL/SQL and fix the same.
• Creating the Brio Report as per the user requirement.
• Debugging the issues raised by business users.
• Actively participated in the monthly purging activity and the analyzing the large/small tables the database for the better performance.

Environment: WINDOWS NT/2000,PL/SQL, Brio reporting tool, Oracle 10g, TOAD, BMC Remedy, Informatica PowerCenter 7.1.1

Confidential

Informatica Developer

Responsibilities:

• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by user.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power centre of Informatica
• Involved in the developing of Developed various complex mappings, mapplets, Sessions and workflows
• Created Complex mappings for the systems like EOC, CAPS, LIFECOM, LIFE70, and ILCHAMP2000.
• Involving in production maintenance for the entire system. Trouble shooting implementation / post implementation issues. Handling trouble Service requests/concerns raised by users.
• Identify the bugs in the system and fixed those bugs by enhance the mappings and the sessions.
• Monitor the whole System and ensure that the data distributed on time to the Business.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client

Environment: Informatica PowerCenter 7.1.1, Windows, Sun Solaris (UNIX), Oracle 9i, Toad, PL/SQL