SUMMARY

• Over 8 years of experience in Information Technology with special emphasis on Design, Development, documentation and implementation of Data Warehousing / Client - Server in various industries such as Financial, Banking, HealthCare and Insurance.
• Worked extensively in analysis, design and development of various applications using DataStage,Oracle,DB2,Teradata, SQL Server, VB, Windows NT\2000\XP and UNIX environments
• Strong analytical, presentation, problem solving and excellent inter-personal communication skills with flexibility to learn new technologies in the IT industry
• Team Player with the ability to communicate effectively at all levels of the development process
• Over 7 years of experience in Database programming, creating data warehouses using IBM InfoSphere DataStage, IBM WebSphere DataStage and Ascential DataStage versions 11.3/9.5/8.5/8. x/7.x Using components like Administrator, Manager, Designer and Director.
• Extensively worked with Parallel Extender for Parallel Processing to improve job performance
• Used several load programs using DB2/UDB and SQL Loader
• Developed Custom Routines for implementing complex Business logic
• Designed Server jobs, Job Sequencers, Batch Jobs and Parallel jobs
• Designed Parallel jobs using various stages like Oracle Enterprise, SQL Server enterprise, Transformer, Join, Merge, Remove Duplicates, Aggregator, Sort, Filter, Dataset, Sequential file, Shared Containers, Lookup, Funnel stage, Column Generator, Peek stages, Change Data Capture, Column Export, XML Input stage, Wait for file Activity, Hierarchical Input, MQ stage.
• Written UNIX Shell Scripts for performing file validations and Job scheduling on various flavors of UNIX
• Written triggers, stored procedures, functions and packages using PL/SQL
• Expertise in Data Warehouse for the Extracting, Transforming of data from multiple sources & Loading data into a Data Warehouse
• Experience in Data Modeling and involved in creation of Star Schema and Snowflake dimensional data marts using Erwin tool
• Involved in identification of Facts, Measures and Dimensions
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Mining, Data Analysis, Decision Support System (DSS) and GUI applications.
• Working experience on Control M scheduling and Globalscape FTP.
• Proficient in Software Life Cycle Development Methodology (SDLC) and Operational Data Store (ODS).
• Responsible for QA activities. Worked as a defect tracking lead.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000 , DB2 9/9.7, MS Access, Teradata V2R6/V13.

Programming Language: SQL, PL/SQL, UNIX shell scripting, C.

ETL Tools: DataStage 11.3/9.5/8.7/8.5/8.1/8.0/7.5.2/7.5.1/7.5 , Parallel Extender

Data Modeling Tools: Erwin 6.0/5.5, MS Visio 2003/2007, ER/Studio 6.0

RDBMS Tools: TOAD 8.5/ 8.0, SQL*Loader (Oracle), SQL*Plus

Operating Systems: Windows NT (4.0), Windows XP, Windows 2000, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

Datastage Consultant

Responsibilities:

• Worked in PAS (Policy Administration system) project, dealing with administering the Life Insurance policies and the benefits associated with.
• Participated in Design discussions to finalize the Interface design.
• Interacted with the Business users to build functional and mapping documents.
• Interacted with the Mainframe, Message Broker ESB and external vendors from Integration point of view.
• Worked with Datastage components like Designer, Director.
• Used various transformation stages like SQL Server enterprise, Transformer, Join, Merge, Remove Duplicates, Aggregator, Change Data Capture, Column Export, XML Input stage, Wait for file Activity, Hierarchical Input, MQ stage for Datamart load and XML processing.
• Developed Unzip and Archive process to consume, Unzip and Archive all the incoming files from external vendor and moving them to the corresponding locations.
• Worked extensively on consuming XML Input files from Message Broker and Mainframe and generating XML files using Hierarchical Input stage.
• Worked on modules extracting and processing data from CDC tables in SQL server 2008.
• Used appropriate partitioning techniques for enhancing performance of Datastage jobs extracting bulk loads from Datamarts.
• Build Load jobs for Datamarts for development and QA environments.
• Participated with the NETOPS team to schedule the Datastage jobs using Control M and setting up FTP accounts in Globalscape for Ftp’ing the files to external vendors.
• Performed Unit testing and worked closely with SIT and UAT teams.
• Was part of the Peer and Code review board to give a sign off on the code to be moved to QA.
• Responsible for building packages and deploying Datastage code in QA.
• Worked with QA teams to track the defects, fix the defects and closing the defects using ALM Quality center.
• Mentored newly hired junior developers.

Environment: Datastage 11.3/9.5, SQL server 2008, FileZilla, Control M, Globalscape, UNIX, Citrix, PuTTy, HP ALM Quality center 12.01

Confidential, Gaithersburg, MD

Sr. DataStage Developer

Responsibilities:

• Analyzing the requirement and understanding the current system and preparing the mapping specification.
• Responsible for converting the data from the current legacy system into the replacement (eCams).
• Responsible for designing and implementing robust Extract Transform and Load applications and processes to load data.
• Responsible for the ongoing operational stability of the ETL processes ensuring they are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery.
• Working closely with Data Conversion manager, Application team to understand requirements.
• Developing ETL processes in support of the requirements validate that they meet business and technical specifications.
• Hands on knowledge in creating stored procedures, packages for Authorization module.
• Responsible for creating minus queries for Quantitative and Quality testing.
• Helped HCA in building complex queries for analysis.
• Wrote SQL queries for generating Exception reports.
• Appropriate backups are taken to protect the data integrity.
• Design, build and maintenance of transform rules and processes to derive the correct data from the extracted data and to transform it into the required format.
• Developing and execution of ETL test plans.
• Extensively worked on Parallel Jobs using various stages like Join, Lookup, Filter, Funnel, Copy, Column Generator, Sequential File, Oracle connector, Merge, and Transformer.
• Performed Job tuning which helps in reducing the production time for the daily job runs.
• Writing SQL queries as needed per the business requirements to generate applicable reports.
• Performed System testing.

Environment: WebSphere DataStage 8.7 / 8.5, SQL developer, TOAD, Oracle 11g, Unix, WinCvs, WinScp, PuTTy 0.63, Clearcase.

Confidential, Deerfield, IL

Sr. DataStage Consultant

Responsibilities:

• Involved in status meetings and interacted with the technical team and business analyst to get the business rules and understand the process.
• Extensively worked on Parallel JobsWebSphere DataStage and Quality Stage 8.5/8.0.1.
• Imported/Exported table definitions, Repositories and attributes for the designing process.
• Worked intensively to build the 850 mail integration system.
• Built ETL jobs to populate dimension tables (Type1, Type2), FACT tables, and LOOKUP tables.
• Built ETL jobs for migration of data from Source to Target and extensively worked on the Performance issues to enhance the performance.
• Scheduled Job Sequencers to populate data into the dimension tables at specific times.
• Used DataStage to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts and DataWarehouse.
• Also worked on Data Migration for a new Release (6.0) independently, worked on mapping logic and performed various transformations.
• Designed Parallel jobs using various stages like Oracle Enterprise, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages, CDC stage, Lookup fileset
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Ran Jobs, Job monitoring using UNIX command line.
• Edited text files, moved and copied files using UNIX scripts.
• Modified existing shell and UNIX scripts to suit the present functional requirements.
• Wrote shell scripts for automation, job run, file processing, initial load, batch loads, cleanup, job scheduling and reports.
• Used DataStage Director effectively to read through the logs and rectify the issues causing warnings and errors.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary
• Involved in the migration of DataStage jobs from development to production environment
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs

Environment: WebSphere DataStage and Quality Stage 8.5/8.1, SQL developer, Oracle 10g/11g, Unix,Microsoft Visio 2007, SQL Assistant, DB2 9.7, XML, WinCvs, WinScp, PuTTy 0.61.

Confidential, Pittsburgh, PA

Sr. DataStage Consultant

Responsibilities:

• Involved in status meetings and interacted with the technical team and business analyst to get the business rules and understand the process.
• Extensively worked on Parallel JobsAscential DataStage 8.1.
• Imported/Exported table definitions, Repositories and attributes for the designing process.
• Used DataStage to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Created data quality jobs to check the authenticity of input data by performing checks like file size, duplicates on natural key and checking headers.
• Designed Parallel jobs using various stages like Oracle Enterprise, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages, CDC stage
• Created multi level sequences which call the jobs and external scripts.
• Used Oracle11g PL/SQL Developer for data analysis of data and tables between source and target..
• Ran Jobs, Job monitoring using UNIX command line.
• Edited text files, moved and copied files using UNIX scripts.
• Modified existing shell and UNIX scripts to suit the present functional requirements.
• Helped in migrating data from real time systems to Oracle 10g.
• Developed ETL extraction routines to extract data from databases using DataStage XML input Stage.
• Performed Unit testing on designs developed to get rid and recognize any abnormalities or errors to meet the desired business rule.
• Created and modified tables in personal schema and replicated/generated data for testing purpose, with a view to be creative and recognize any loop hole in the design.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Involved in the migration of DataStage jobs from development to production environment
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs

Environment: IBM InfoSphere Information Server DataStage 8.1, PL/SQL developer, Oracle 10g/11g, Unix,Microsoft Visio 2007, Erwin 6, SQL Assistant, DB2 9.7, Informix IDS 9.4, XML, TeraDataV 13.

Confidential, Deerfield, IL

DataStage Developer

Responsibilities:

• Analyzed, Designed and Developed High-Level Design documents and Technical Specifications based on the given user requirements.
• Used the DataStage Designer to develop jobs for extracting loading and transforming data into data warehouse.
• Used CDC stage to create type-1 and type-2 data
• Extensively used Merge stage, Lookup stage, Transformer stage, Join stage, Change capture stage, Aggregator stage during ETL development.
• Used DB2 bulk load stage and ODBC stages for better performance
• Involved in identifyingthe changes in a front end application through which users input the data.
• Interacted with business team in order to track the changes to be made to the business applications.
• Involved in scheduling and maintaining the Nightly batch jobs using Crontab job scheduling tool.
• Involved in uploading the data from backend to the business applications and unit tested the changes made to the user specific functionalities.
• Migrated oracle database with new implementation scripts to the user acceptance testing environment.
• Provided support/maintenance to the implemented changes.
• Written UNIX shell scripts for various database activities like space cleanup, snapshot refresh, file transfer.
• Creation of database objects like tables, views, stored Procedures, functions, packages, DB triggers, Indexes and Collections.
• Replicated the materialized views, procedures and functions.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Involved in Unit testing, System testing of each module.
• Provided Test Data to QA team to validate front end application.
• Involved to prepare user level maintenance documentation.

Environment: Oracle 10g/9i, PL/SQL, Ascential DataStage 8.0/7.5.1, DB2 UDB V9, Teradata V2R6, TOAD 8.5, Win 2000, Red Hat LINUX, Erwin 5.5.

Confidential, Arlington, VA

DataStage ETL Developer

Responsibilities:

• Reviewed documentation, work flows; use cases and business requirements of CAS project.
• Write descriptive functional and technical design documents.
• Used DataStage Designer to design Matching, Aggregation and Prioritization jobs.
• Used DataStage Director to validate and troubleshoot the jobs.
• Used QualityStage to standardize the input files sent by the failed financial institutions.
• Created various DataStage Jobs using with Web Analytics.
• Developed PX jobs in using different stages like Aggregator, Join, Merge, Lookup, Source Dataset, External Filter, Row generator, Change Capture, Peak stages and Column generator.
• Reviewed all Matching and Aggregation ETL jobs.
• Modified and re-designed existing Matching jobs.
• Worked on design document for Aggregation Customer Data module.
• Designed Sequencer for DataStage jobs to implement Prioritization, Data Refresh, Prioritization and Matching Jobs.
• Completed data testing on Prioritization, Data refresh Prioritization and Matching jobs.
• Designed new DataStage jobs for Data Refreshment Prioritization Jobs.
• Used slowly changed dimensions stage to maintain history.
• Reviewed column level analysis, foreign key analysis.

Environment: DataStage7.5.2, Oracle 9i, Toad 8.0, UNIX Sun Operating system 5.10, WinSCP(FTP), Windows NT, Visio2003.

Confidential, CA

DataStage Developer

Responsibilities:

• Involved in the development phase for business analysis and requirements gathering.
• Coordinated with the team members to translate business requirements into DataMart design.
• Designed logical and physical models using Erwin data modeling tool.
• Coordinated with the team members to translate business requirements into DataMart design.
• Created and loaded Data Warehouse tables such as dimensional, fact and aggregate tables using Ascential DataStage.
• Designed Parallel jobs using various stages like Oracle Enterprise, ODBC, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages, Sequential File, Aggregator.
• Involved in data mapping from source to target as per business requirements
• Created DataStage jobs, batches and job sequences and tuned them for better performance.
• Designed and developed ETL processes using Ascential DataStage.
• Ran Jobs, Job monitoring using UNIX command line.
• Edited text files, moved and copied files using UNIX scripts.
• Modified existing shell and UNIX scripts to suit the present functional requirements.
• Wrote shell scripts for automation, job run, file processing, initial load, batch loads, cleanup, job scheduling and reports.
• Scheduled jobs using UNIX crontab and ZEKE Scheduler
• Worked with DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Designed the jobs between sources (Oracle database) to Data Warehouse/ DataMarts (MS SQL Server)

Environment: Ascential DataStage PX 7.5.1 (Designer, director, manager, and administrator), Oracle 9i, MS SQL Server 2000, DB2, PL/SQL, SQL Loader, Windows 2000, UNIX, and shell scripting.