SUMMARY

• Experience in software systems Development client/server Business systems with 7 years of strong Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using IBM Information server 8.1/Data Stage 7.5/7.1/6.0
• Expertise in Relational Database Modeling and Dimensional Modeling - Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio.
• Multitudinous experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage, designing and developing jobs using DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator.
• Distinguished proficiency at programming in SQL, PL/SQL, UNIX shell scripting, C, XML including performance tuning, query/code optimization
• Designed and Developed DataStage Server Jobs.
• Designed and developed jobs using DataStage Parallel Extender (also non as IBM Enterprise Edition) for splitting bulk data into subsets and to dynamically distribute data to all available nodes to achieve best job performance.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, and DB2, Teradata, XML and Flat files into teh staging area.
• Knowledge in designing and developing reports using BI/OLAP tools like Business Objects
• Extensive experience in writing Triggers, Packages, Stored procedures and Functions using PL/SQL and T-SQL.
• Hands on experience in Enterprise Scheduling tools like Control-M and Autosys.
• Worked on various operating systems of UNIX like AIX, Sun Solaris, Linux, HP and Windows NT/2000/9x.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with teh ability to grasp things quickly.

TECHNICAL SKILLS

ETL: II Ascential Data stage 7.5.2/7.1/6.0 EE client components (Designer, Director, Manager, Administrator), Profilestage, Websphere Information Server 8.0 (Datastage & Qualitystage) & Information Analyzer 8.1

BI Tools: C Business Objects XI, Cognos

Databases: O Oracle 10g/9i, DB2 9.x, MS SQL Server 2005, Teradata V2R12/V2R6

Languages: XML, SQL, T-SQL, PL/SQL, C, Shell Scripting

Environment: Windows 2003/2000NT 4.0, Sun Solaris 2.x/5.x, AIX 5.2/4.3

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Sr.Datastage Developer

Responsibilities:

• Work closely with Business analysts and Business users to understand teh requirements and to build teh technical specifications.
• Responsible to create Source to Target (STT) mappings.
• Prepared Technical Specification Documents and worked to design, develop and build datastage jobs.
• Designed and developed Server jobs, Parallel jobs to extract data, clean, transform, and to load teh target tables using teh DataStage Designer
• Designed and developed user defined SQL’s, Job Sequence to run multiple jobs
• Used DataStage Designer for importing teh source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• 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).
• Involved in Unit testing and integration testing.
• Extensively used Sybaseoc, dynamic rdbms, oracle enterprise, transformer stages as part of data extraction followed by transformation and loading
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used teh DataStage Director to run, schedule, monitor, and test teh application on development, and to obtain teh performance statistics.
• Developed Packages and customized functions and Triggers based upon teh business logics.
• Involved in Performance tuning of complex queries.
• Responsible for analyzing and preparing dependencies and sequence in which job/processes should be scheduled in Enterprise Scheduling tools like Control-M scheduler.

Environment: IBM Infosphere Server Suite 8.1.1 (Designer, Director and Administrator), Test Director, Control M, oracle 10g, SQL Server, WinSql, Windows XP, Visio

Confidential, Holland, MI

Data stage Developer

Responsibilities:

• Involved in detailed project implementation discussion and all other phases of SDLC of implementing data warehouse.
• Involved in getting teh detailed business requirements for teh process.
• Worked on creating teh technical design and source to target mapping document for different subject areas.
• Created teh ETL detailed design document for all teh process and co-ordinate with off shore team on day to day development activities.
• Worked with DS Admin on setting DB2 Enterprise stage for which can be used to load high volumes of data.
• Designed and Developed Server jobs.
• Extensively worked on active and passive stages like DB2 Enterprise stage, Oracle EE, ODBC stage, Pivot, Transformer, Change Capture, Remove duplicates, Lookup, Join, Merge, Modify, Complex Flat files(CFF), Filter etc.
• Involved in DataStage upgrade from 7.5.1 to Data Stage 8.0.1.
• Created SSIS packages for extracting teh data from SQL Server and load teh data into flat files or into DB2 database.
• Build datastage jobs to taking advantage of Datastage parallelism techniques.
• Worked on building DataStage Jobs to source data from heterogeneous systems and load into DB2.
• Developed Autosys jobs for scheduling and running teh DataStage jobs in Production Environment.
• Migrated DataStage jobs, UNIX scripts from DEV to QA to PROD.
• Involved in Production support.

Environment: IBM WebSphere DataStage and QualityStage 8.0.1, Ascential DataStage 7.5.1, DB28.9, Oracle 10g, SQL Server 2005 SSIS, AIX 5.3 UNIX, Autosys4.5

Confidential, Omaha, NE

Datastage Developer

Responsibilities:

• Using Data Stage Designer, designed and created jobs for Target Warehouse Entity for Oracle
• Responsible for creating and testing ETL jobs.
• Processed data from Sybase staging database to Oracle Enterprise Data Warehouse.
• Implemented data cleansing & data standardization rules on Sybase staging database.
• Created several general routines (Before-After, Transform function) used across teh Project.
• Developed various jobs using Oracle OCI, ODBC, Hashed file, Aggregator, Sequential file stages.
• Implemented Type Two Slowly changing Dimension with database sequence Generator.
• Imported Oracle schema in to DataStage with Manager for data mappings.
• Used shared containers for multiple jobs, which have teh same business logic.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Tuned DataStage jobs for better performance by creating DataStage Hash files for staging teh data and lookups.
• Used teh Manager to import, export jobs/routines.
• Created Oracle SQL scripts for data testing and data validations.
• Wrote PL/SQL Packages & stored procedures for data calculations.
• Implementation of Data warehousing models with Erwin.
• Performance tuning of SQL/PLSQL code to optimize query performance.

Environment: Ascential DataStage 7.5, SAP R/3, SAP BW, SAP Adapters & DataStage Pack for SAP, Sybase, XML plug in’s, QualityStage & Meta Stage, Audit Stage, Profile Stage, UC4, and Oracle 9i, PL/SQL, AIX, Windows NT, Business Objects-6i.

Confidential, Denver, CO

Datastage 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.
• Developed ETL maps to pull data from Flat Files, 3rd party Data base tables/views.
• Developed UNIX Shell scripts to handle and validate teh incoming source files.
• Developed UNIX Shell scripts to implement ARCHIVAL process.
• 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 teh same business logic.
• Responsible for creating ETLs to pull teh data from both PeopleSoft and non-PeopleSoft source system.
• Responsible for developing ETLs to load teh data into EPM incrementally or destructively based on teh requirement.
• Involved in documentation, customization tracking and in maintaining PeopleSoft standards across all teh teams in EPM.

Environment: Ascential DataStage 7.5 EE, Ascential Profile Stage 7.5, PeopleSoft EPM 8.9, PeopleSoft ERP Applications, nVision, People Tools 8.46/8.45, Oracle 9i, Informix 7.3x, HP-UNIX 11.11

Confidential, Connaught, PA

Datastage Developer

Responsibilities:

• Involved in teh design and implementation of MSLD Data Warehousing application using Ascential DataStage, Integrity Developed data acquisition modules for obtaining source data from flat files that would be eventually loaded into multi-terabyte data warehouse
• Also used Data stage Manager to maintain teh metadata
• Configured environment variable and setting up of projects using DataStage Administrator
• Involved in developing Data mart for Reporting applications using Data Stage
• Extensively used DataStage Manager for data loading and management
• Worked on DataStage Designer, DataStage Director, DataStage Manager, jobs and Transforms.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Using DataStage Designer designed and created jobs for Target Warehouse Entity for Oracle.
• Wrote DataStage Basic routines to perform common functions such as file backup, surrogate key generation, file clearing.
• Extensively used DataStage, Integrity and Orchestrate as Data Warehousing & Loading tools for various modules of teh MSLD Data Warehouse application.
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using Data Stage.
• Performed dimensional and relational data modeling using Allfusion Erwin Data Modeler 4.1 for teh initial design of OLTP and Data warehouse.
• Developed web based Reporting application using Business Objects
• Developed aggregation modules in Ascential (Torrents) Orchestrate ETL (Extract Transform and Load) tool to create aggregated data from detail tables and loading into dimensional and summary tables for reporting Long Distance Product/Plan/Promotion Data, Extract customer profile data from Warehouse and feed to win-back campaign Engine Application
• Java script XML data conversion.

Environment: Ascential Data Stage 7.0 (Designer, Director, Manager, Administrator), Oracle8i, PL/SQL, Crystal reports 8.x, UNIX Shell Programming, Erwin, WinNT 4.0 Server, DB2 UDB,MS SQL, UNIX, Windows NT, Business Objects 5.1