SUMMARY

• 12 Years of IT experience and technical proficiency in the field of Data Warehousing teamed with Data Architecture, Data Modeling, Data Analysis, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
• Strong experience in ETL Administration. Upgraded the ETL platform from 7.1.3 to 8.1 and Powercenter 8.6.1 Hotfix14 to Powercenter 9.1.3 Hotfix 2. Also upgraded the Informatica 9.1 HF6 to 9.5.1 HF2.
• Installation of hotfixes provided by vendor Informatica on Linux 4.0/5.0 and sun Solaris 10 environments.
• Extensive experience on Informatica HA/GRID setup.
• End to end setup of Informatica 9.6.1 HF3 BDE with Cloudera Cluster CDH 5.4.7.
• Code deployments to the QA and production environment using deployment groups and labels.
• Enabled versioning on Development, QA and Production environments.
• Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center 9.6.1/9.5/9.1/8.6/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor).
• Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup, and other transformations in Informatica and well versed in debugging an Informatica mapping using Debugger
• Extensive experience in Business Intelligence arena with BI Suite and Business Objects XI/6.5/3.1
• Experience in Designing and Developing Business Objects Universes BO Designer and Reports using BO Desktop Intelligence / Business Objects 6.5.
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD and SQL Plus.
• Experience in creating efficient and effective BRD (Business requirement document), TAD (Technical Architecture document), TDD (Technical design document) involving data mappings
• Extensive experience in writing Use Cases, Functional specifications, Scenarios, Business processes, Workflows, Process flows, Test cases and Test Plans.
• Experience in designing error and exception handling procedures to identify, record and report errors
• Experience in coordinating with the configuration and change management groups for Clear Case Version Control and Build Making Process
• Through experience in scripting using Unix Shell .
• Ability to work well both individually and in teams.
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.

TECHNICAL SKILLS

Database: Oracle 9i, Oracle 10G, Oracle 11G

GUI: Oracle Developer 2000 (Forms and Reports), SQL,PLSQL

Case Tools: TOAD 9.6.1, Autosys

Tools: and Utilities: Informatica 9.6.1 HF3 BDE, Informatica Power Center 7.1.1, Informatica Power Center 8.1.1, Informatica Power Center 8.6, Informatica 9.1, Informatica 9.5.0, Informatica 9.6.1 HF3,Metadata manager, Data Analyzer, Power exchange, IDQ

Domain: Data Warehousing, Unix Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Informatica Architect/Administrator

Environment: Informatica Powercenter 9.5/9.1/8.6.1 , Oracle 10G,HP - Unix

Responsibilities:

• Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
• Informatica server support and maintenance.
• Informatica upgrade activities from 8.6.1 to 9.1.
• Informatica installation and upgrade on VM.
• Coordination with the development team to resolve the infrastructure issues.
• Creating connections for Teradata,Netezza,oracle, SQL Server and Powerexchange .
• Autosys is used as a scheduling tool to schedule Informatica workflows.
• Worked with various sources like XML, Flat files,Teradata, Oracle, DB2 etc.
• Informatica upgrade from 9.1 HF5 to 9.6.1 HF3.

Confidential, Charlotte, NC

Informatica Architect

Environment: Informatica Powercenter 9.1/9.5/8.6.1 , Oracle 10G,LINUX, UNIX,AIX

Responsibilities:

• Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
• Informatica server support and maintenance.
• Coordination with the development team to resolve the infrastructure issues.
• Creating connections for Teradata,Netezza,oracle, SQL Server and Powerexchange .
• Extensively worked on HA and Grid setup.
• Autosys is used as a scheduling tool to schedule Informatica workflows.
• Troubleshooting data interrogation issues in development, test, and production environments.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.

Confidential - Phoenix, AZ

Informatica Administrator

Environment: Informatica Powercenter 9.1/8.6.1, Oracle 10G, Teradata12, UNIX (Sun OS-Solaris 10)

Responsibilities:

• Created new Informatica mappings.
• Documentation of Informatica mappings
• Maintaining the Informatica 8.6 Server built on Unix(Sun Solaris)
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Troubleshooting data interrogation issues in development, test, and production environments.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Monitored workflows and collected performance data to maximize the session performance.
• Created the repositories and user groups using Informatica Admin console.
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Developed mappings/sessions using Informatica Powercenter for data loading.
• Used aggregate, expression, lookup, update strategy, router, and rank transformation.
• Developed joiner transformation for extracting data from multiple sources.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
• Autosys is used as a scheduling tool to schedule Informatica workflows.
• Successfully upgraded To Informatica Powercenter 9.1 from version Powercenter 8.6.1.

Confidential, Denver CO

Team Lead

Environment: Oracle 10G

Responsibilities:

• To gather all the functional and technical requirements from the client.
• Analyzing the existing ETL process (SQL, PL/SQL).
• Created new PL/SQL procedures, Functions, Triggers etc.
• Provide the requirements to the offshore resource and validate the work completed by offshore resource.
• Extract the data from the ADP database and load the data in to e-Personality oracle database by doing required transformations.
• Creating and maintaining Triggers, Packages, Functions and Procedures.
• Design and Development of data validation, load processes, test cases using PL/SQL, SQL.

Confidential - Sunnyvale, CA

Informatica Administrator/ Production Support

Environment: Informatica 8.1.1, BOXI, Oracle 9i, UNIX (Sun OS-Solaris 10)

Responsibilities:

• Analyzing the existing ETL process (SQL, PL/SQL).
• Created new Informatica mappings.
• Documentation of Informatica mappings
• Maintaining the Informatica 8.1 Server built on Unix(Sun Solaris)
• Creating Business Objects Universe.
• Creating Business Objects Reports.
• Providing access to all Business Objects users through CMC.
• Maintaining the Business Objects Server built on UNIX (Sun Solaris).
• Up gradation of Informatica 7.1 to Informatica 8.1
• Worked on Informatica Power Center 8.1.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Developed source to target business specification documents based on stored procedures in Oracle.
• Troubleshooting data interrogation issues in development, test, and production environments.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Monitored workflows and collected performance data to maximize the session performance.
• Created the repositories and user groups using Informatica Repository Manager.
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Developed mappings/sessions using Informatica Power Center for data loading.
• Used aggregate, expression, lookup, update strategy, router, and rank transformation.
• Developed joiner transformation for extracting data from multiple sources.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
• Autosys is used as a scheduling tool to schedule Informatica workflows.

Confidential

Inforamtica Developer/Administrator

Environment: Informatica 7.1, Oracle 9i, Erwin

Responsibilities:

• Analyzing the existing ETL process (SQL, PL/SQL).
• Created new Informatica mappings for Sales data Mart.
• Documentation of Informatica mappings.
• Worked on Informatica Power Center 7.1. tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Troubleshooting data interrogation issues in development, test, and production environments.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Discussed the Data warehouse requirements and measured its need with the Technical Lead
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.