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, referenced 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 WEBi

Database Utilities: TOAD 7.3, PL/SQL, SQL*Plus, SQL*Reports, SQL*Loader

Operating 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, NJ

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.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements

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:

• Assisted the CEO/Directors by creating complex reports stating revenue generation per year using cascading and user objects like measure objects by using aggregate aware function to create the summarized reports
• Assisted in carrying the architectural works in data warehouses
• Responsible for engaging and executing the training 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.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements

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 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
• 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 training 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.