SUMMARY:

• 7 years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) /Enterprise Data warehouse (EDW) analysis, design, development, Testing and implementation.
• 6 years of experience in populating and maintaining Data warehouses and Datamarts using IBM Information Server 9.1/8.5/8.1, Ascential DataStage v7.5.x (Administrator, Director, Manager, Designer) - Server Edition, Enterprise Edition Px (Parallel Extender), and Quality Stage.
• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Worked with offshore team as co-coordinator with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.
• Expertise in Relational Database Modeling and Dimensional Modeling-Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio.
• Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement.
• Optimized DataStage jobs utilizing parallelism, partitioning and pipelining features of Parallel Extender.
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Experience in migrating ETL code to upgraded version.
• Experience in programming using SQL, PL/SQL, and UNIX Shell Scripting.
• Extensive experience in Microsoft SQL Server 2005/2000, IBM DB2 UDB 8.0/7.0, Informix, Teradata, Oracle 10g/9i/8i., XML files and Message Queues.
• Strong Experience in Unit testing and System testing of the DataStage jobs.
• Experience in Scheduling the DataStage jobs using Control-M, Autosys.
• Knowledge on designing and developing reports using BI/OLAP tools like Business Objects and Cognos.
• Extensively worked on ABAP Extract Stage, IDoc Stages to extract SAP data
• Involved in Documentation of ETL process following the standard naming conventions used in DataStage.
• Excellent communication and interpersonal skills, teamwork, problem solving skills, flexible, self-direct and energetic person.
• Extensively worked co-coordinating with offshore team distributing the work, keep tracking development status and monitor day-to-day activities.
• Installation, configuration, setup and Administration of DataStage Server.
• Experience in DataStage Administrator to create/modify/delete projects, add DSN entries and cleanup projects and Implemented security among DataStage users and projects.

TECHNICAL SKILLS:

ETL: IBM IIS Suite (DataStage, QualityStage, Information Analyzer, Fast Track) 9.1/8.5/8/1/8.0, Ascential DataStage 7.5

Operating Systems: HP-UX v11.x/10.x, IBM AIX 5.x, Windows 2000/XP/7

Languages: PL/SQL, SQL*PLUS, UNIX Shell Scripting, C, JAVA, JDBC.

GUI Tools: Oracle Forms, Visual Basic 6.0Data Modeling: Star Schema modeling, Snowflakes Modeling, FACT and Dimension tables, Aggregation tables, ERWIN.

Databases: Teradata v2r12, Oracle 11g, 10g, 9i, MS SQL Server 2008/2000, DB2 UDB v9.7/9/.1, Informix 2.1/5.0, MSAccess.

PROFESSIONAL EXPERIENCE:

Confidential, Murray Hill, NJ

Sr. DataStage Developer

Responsibilities:

• Work closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Involved in business meeting to understand the retail and institutional customer information and stocks, bonds, mutual funds data.
• Responsible to create Source to Target (STT) mappings.
• Responsible to design, develop and built DataStage parallel jobs using DataStage designer.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load the target tables using the DataStage Designer
• Designed developed job sequencer to run multiple jobs with dependency and email notifications
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed the Routines and Job Sequence for the ETL jobs
• Prepared Technical Specification Documents for DataStage Jobs.
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Deployed different partitioning methods like Hash by field, Entire and Range for bulk data loading and for performance boost.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Extensively worked on Oracle Enterprise Stage, Oracle OCI Stage to extract, transform and load data.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Involved in Performance tuning of complex queries.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Environment: IBM Infosphere Server Suite 9.1/8.7 (Designer, Director, IIS Manager and Administrator), IBM FastTrack, Test Director, Control M, Oracle 11g, AIX, SQL Server, Toad for Oracle, Windows 7, Visio, ERwin.

Confidential, Chicago, IL

Sr. DataStage Developer

Responsibilities:

• Work closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Involved in business meeting to understand the retail business needs and come up with technical design.
• Responsible to create Source to Target (STT) mappings.
• Responsible to design, develop and build DataStage parallel jobs using DataStage designer.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed DataStage Parallel jobs to extract, cleanse, transform and load Enterprise Data Warehouse (EDW).
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Responsible to develop job sequences to run multiple jobs with correct dependency and notifications activities.
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Extensively worked on ABAP Extract Stage, IDoc Stages to extract SAP data.
• Proficient with SAP architecture and SAP Transaction Codes (T-Codes).
• Designed and developed the Routines and Job Sequence for the ETL jobs
• Hands on experience using various partitioning methods like Hash by field, Entire and Range for bulk data loading and for performance boost.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages Aggregator, CDC, Merge, Funnel, Filter, Remove Duplicate Stage and Sort.
• Extensively used Reject Link, Job Parameters, and Stage Variables in PX jobs
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Involved in Unit testing and integration testing.
• Prepared Technical Specification Documents for DataStage Jobs.

Environment: IBM Infosphere Server Suite 8.5/8.7 (Designer, Director and Administrator), Ascential DataStage (Designer, Director, Manager and Administrator), SAP ECC, DataStage PACK for SAP, Test Director, Control M, Oracle 10g, IBM DB2, AIX 5.3, SQL Server, Toad for Oracle, Windows XP, Visio, ERwin.

Confidential, St. Louis, MO

DataStage developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Performed data conversion from Mainframe files, DB2, Oracle and Flat Files.
• Provide the staging solutions for Data Validation and Cleansing with Datastage ETL jobs.
• Used Parallelism concepts for distributing load among different processors by implementing Pipeline and partitioning of data.
• Developed variousUNIXshell scripts to meet all the project requirements.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Used various Parallel Extender partitioning and collecting methods.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Datastage Parallel jobs.
• Defined Stage variables for data validations and data filtering process.
• Review and updates to the ETL High Level Design.
• Extensively written shell scripts in different scenarios.
• Implemented Debugging Methodologies with Break Point Options.
• Designed and implemented slowly changing dimensions methodologies.
• Transfer data from various systems through FTP Protocols.
• Written batch Job Controls for automation of Execution of data Stage Jobs.

Environment: IBM DataStage and QualityStage 8.5, Windows XP, Oracle 10g, AIX 5.1, Autosys, Toad for Oracle

Confidential, Quincy, MA

DataStage Developer

Responsibilities:

• Developed ETL specifications for ETL designing and development
• Source to Target mapping document creation
• Attended Corporate Information Architecture (CIA) committee meetings for getting approvals for ETL specifications and designs
• Loading tables from Operational Data Source (ODS) to CIRS data warehouse environment
• Worked with DataStage EE 7.0 to create the parallel jobs
• Designed and Developed jobs using Server jobs. Used Parallel Extender for splitting bulk Data into subsets and to dynamically distribute to all available Nodes to achieve best job performance
• Performed testing of these Parallel jobs using Row Generator and Column Generator stages
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Developed jobs for transforming the data and stages like Join, Merge, Lookup, Funnel, Transformer, Pivot and Aggregator
• Used Row Generator and Column Generator stages to create the test data for performing Testing operations
• Created database procedures, functions and triggers using PL/SQL
• Created and used Oracle Stored Procedures in the DataStage jobs to increase the performance of the jobs
• Worked with TOAD to interact with Oracle and Used SQL Trace and Explain Plan to improve the performance of the PL/SQL programs
• Loading protected category tables from ODS to CIRS
• Creating Protected Category hash files using CIRS table as source in CCDB and CIRS formats
• Validating the Inbound file from care management providers according to Business rules

Environment: IBM DataStage and QualityStage 8.1 (Designer, Director, Administrator), HP-UX11.11, Oracle9.2, Teradatav2r12, CCCHarvest 4.2, RemedyASR8.2, Autosys, PL/SQL Developer, Flat files, Windows 2000

Confidential, Denver, CO

ETL Developer

Responsibilities:

• Designed and developed Data Stage jobs for data extraction from different data feeds into EPM.
• Involved in functional and technical meetings and responsible for creating ETL Source - to - Target maps.
• Developed various jobs using Dynamic RDBM, Universe, Hashed file, Aggregator, Sequential file stages.
• Used Data Stage Manager for importing metadata from repositories, new job categories, import and export .dsx files, routines and shared containers.
• Implemented profile stage for source data profiling analysis.
• Extensively worked on PeopleSoft POSITION and LINE ITEM budgeting and STRS areas.
• Worked on Change Requests (CRs) from Budgeting domain according to changing business rules.
• Customized PeopleSoft delivered ETLs to in corporate additional functionality as per client requirement.
• Implemented quality stage for data cleansing & data standardization process.
• Defined Standardized jobs for standardized files and standardized results.
• Responsible for creating jobs in Regulatory (FCC & PUC) reporting area.
• Responsible for creating/modifying MASTER Sequencers for different subject areas/domains, to run/schedule all the jobs related to that particular subject area/domain.
• Involved in pulling the data from various PeopleSoft applications like CRM, HRMS, and FMS into EPM.
• Developed ETL maps to pull data from Flat Files, 3rd party Data base tables/views.
• Developed UNIX Shell scripts to handle and validate the incoming source files.
• Extensively used PeopleSoft Application Designer to create new tables/views/fields and to modify delivered objects.
• Involved in migration process from DEV to Test and then to PRD.
• Used shared containers for multiple jobs, which have the same business logic.
• Responsible for creating ETLs to pull the data from both PeopleSoft and non-PeopleSoft source system.
• Responsible for developing ETLs to load the data into EPM incrementally or destructively based on the requirement.
• Involved in documentation, customization tracking and in maintaining PeopleSoft standards across all the teams in EPM.

Environment: Ascential DataStage 7.5 EE, Ascential ProfileStage 7.5, PeopleSoft EPM 8.9, PeopleSoft ERP Applications, nVision, PeopleTools 8.46/8.45, Oracle 9i, Informix 7.3x, Erwin 3.5.2, Test Director, HP-UNIX 11.11

Confidential

Oracle SQL Developer

Responsibilities:

• Participated in the requirement specification study and communication with the different user departments.
• Involved in the design of tables, forms and reports.
• Followed the Software Development Life Cycle (SDLC) process in the development of the application.
• Developed various triggers, functions and stored procedures in PL/SQL.
• Designed screens layouts for the report generation modules.
• Coded many shell scripts for efficient job scheduling.
• Writing control file scripts for loading the data into tables using SQL* Loader.
• Writing PL/SQL procedures, functions and packages to perform numerous calculations.
• Interacted with both Oracle and SQL Server RDMS’s