SUMMARY:

• Over 11+ years of experience in IT industry having extensively involved in analysis and design, testing, implementation, maintenance, production support and knowledge transfer.
• Over 8+ years of emphasis on Data warehousing/MDM using ETL tool Informatica Power Center9.x/8.x and Datastage 8.x/7.x, Business Objects XI3/4 WEBI, PL/SQL, MSSQL
• Involved in Administering and development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
• Experienced in Datastage Administering, UAT, Production Environment
• Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse
• Used the DataStage Director to schedule running the solutions
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
• Experience in following domains: Health Care, Supply Chain, Investment/Banking, Infrastructure Support.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica 9.x/8.x and Datastage 8.x/7.x
• Expertise in Data modeling techniques - Star/Snowflake modeling, FACT/ Dimensional Tables, Physical and Logical Data Modeling using ERWIN
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console. involved in using the OLAP tool Business Objects XI 3/4 including Deployment, Administration of both Full-Client Modules Business Objects Reporting Tool, Designer, Supervisor and Server-Side Modules Web Intelligence and Broadcast Agent
• Strong experience with Oracle (SQL & PL/SQL), in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, d cursors.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/, SQL SERVER 20xx, MYSQL and MS Access.

Data Warehousing: Informatica Powercenter 9.x/8.x, DataStage 8.x/7.x, Business Objects XI3/4 WEBiDatabase Utilities TOAD 7.3, PL/SQL, SQL*Plus, SQL*Reports, SQL*LoaderOperating System Windows XP/NT/2000, AS 400, Sun solaris

Languages: Basic, C/C++. Java, Shell Script, PHP, ASP, HTML and DHTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, N.J

Datastage Administrator Developer

Responsibilities:

• Collect the specified data, analyze the specifications and data structure for integration
• Extract, Cleanse, Transform and Load the data into Target Oracle database using DataStage Source, mapping, target designer with transformations-Connected-Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
• Carried out R and D for improving reporting and analytics by using the right technology in a mixed Oracle and Business Objects BI DW environment.
• Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.

Environment: Oracle 11g/10g/9i, SQL SERVER 20XX, Informatica Power Center 9/8.6, Business Objects XI 3/4, Windows XP/2000, Erwin, Toad

Confidential, NY

Datastage Administrator Developer

Responsibilities:

• Responsible for engaging and executing the programs for the fresher BO hires.
• Extract, Cleanse, Transform and Load the data into Target Oracle database using Datastage Source, mapping, target designer with transformations-Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
• Oracle and Business Objects BI DW environment.
• Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.

Environment: Oracle 11g/10g/9i, Informatica Power Center 9/8.6, Business Objects XI 3/4, Windows XP/2000, Erwin, Toad

Confidential, NY

Datastage Administrator Developer

Responsibilities:

• Used DataStage Designer to develop jobs for extracting, transforming, integrating and loading data to targets.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
• Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
• Designed the mappings between sources (external files & databases) to operational staging targets, designed Star & Snow Flake schemas
• Set Up ODBC Connections, Import Relational Metadata, Extract And Load Relational Data

Environment: Oracle 11g/10g/9i, Windows XP/2000, AS 400, DataStage 8.x/7.x Parallel Extender / Server, Director, Manger, Administrator, Erwin, Toad.

Confidential, NY

ETL Datastage Administrator Developer

Responsibilities:

• Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment.
• Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.

  Involved in Administering and development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.

• Experienced in Datastage Administering, UAT, Production Environment
• Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse
• Used the DataStage Director to schedule running the solutions
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc. Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performanceDesigned the mappings between sources (external files & databases) to operational staging targets, designed Star & Snow Flake schemas. Set Up ODBC Connections, Import Relational Metadata, Extract And Load Relational Data
• Collect the specified data, analyze the specifications and data structure for integration
• Extract, Cleanse, Transform and Load the data into Target Oracle database using Informatica Source, mapping, target designer with transformations-Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
• Use Datstage Server manager/monitor to create sessions, batches to run jobs.
• Build the new Business Object universes as per the user requirements • Create complex reports stating revenue generation per year using cascading and user objects like measure object using @aggregate.
• Involved in creation of Oracle Tables using storage parameters and clusters.
• Involved in writing PL/SQL Database procedures, Functions, Packages and Database Triggers.
• Conducted sessions to end-users.
• Involved in System Analysis, Design, Coding, Testing, Development and Implementation.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Written many Stored procedures, Stored functions, Packages and used in many Forms and Reports.

Environment: Oracle 11g/10g/9i, MS SQL 20XX, Windows XP/2000, AS 400, DataStage 8.x/7.x Parallel Extender / Server, Director, Manger, Administrator, Erwin, Toad.