SUMMARY

• Over Eight years of IT Experience in Software Analysis, Design and Development of various Client/Server Applications.
• Over six plus years of Extensive experience in building Data Warehouse/Data Marts wif ETL tool such as Ascetical DataStage 6.x/7.x and IBM WebSphere DataStage 8.x.
• Experienced in building Data Warehouses by Extracting, Transforming of data from multiple sources & Loading into Data Warehouse and Marts.
• Participated in gathering teh business requirements from teh end users.
• Written high level and low level specs to develop teh ETL jobs.
• Expertise in designing Star Schemas using teh FACT tables, Dimension tables.
• Extensively used different types of stages like Aggregator, Transformer, Merge, Join, Lookup, Flat file, Sequential file, ODBC, Hashed file, Shared Containers and XML Transformations for developing Server & Parallel Jobs.
• Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and to dynamically distribute to all available nodes to achieve best Job performance.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Extensive experience in using teh Quality stage, Built - in, Plug-in and Custom Stages for Extraction, Transformation and Loading of teh data.
• TEMPEffectively used DataStage Manager to Import/Export projects from development server to production server. Parameterized jobs for changing environments.
• Worked wif Data Stage Administrator to create projects, users, user rights and to restart jobs.
• Proficient in Data analysis, Data modeling, Database design, Data migration and Data acquisition using teh Datastage.
• Experienced in loading teh data into ODS database to resolve teh redundancy and checked for compliance wif teh corresponding business rules.
• Experienced in using Oracle Utility like Export, Import, SQL*Loader, Teradata Utilities (Fast Load, Multi Load, Fast Export, Tpump and BTEQ) and Toad.
• Developed various stored procedures, triggers and functions at database level using PL/SQL.
• Experienced in working wif Oracle 7.me/8.me/9.me/10g/11.g, SQL-Server 2003/2008, Sybase DB2UDB, DB2, Teradata, and Informix, MS-Access relational databases for retrieving data to staging area.
• Experienced in Writing UNIX Scripts to automate teh batch job execution.
• Exceptional analytical and problem solving skills. Team Player wif teh ability to communicate TEMPeffectively at all levels of teh development process

TECHNICAL SKILLS

ETL Tools: IBM Infosphere DataStage 8.x, Ascetical DataStage 7.5.x (Enterprise Edition)/7.1/6.1/6.0, Parallel Extender, Quality stage, SQL * Loader, Auto Loader

Operating Systems: Windows, SUN Solaris & IBM AIX 4.x/5.x

RDBMS: Oracle 7.x/8.0/8i/9i/10g/11g, SQL Server 2000/2005/2008, Teradata, DB2 and MS-Access

Languages: C, PL/SQL, Universe Basic, SQL, UNIX shell programming, HTML, XML, Linux.

Database Tools: SQL Plus, SQL Loader, Import, Export, SQL Developer and TOAD.

BI Tools: Business Objects 5.0, Cognos, Micro Strategy.

PROFESSIONAL EXPERIENCE

Confidential, GA

DataStage Developer

Responsibilities:

• Developed Jobs using DataStage 8.x to load teh data from different sources such as database tables and sequential files to teh target database tables.
• Extensively used Ascential Data stage designer to develop Jobs for extracting, transforming, loading data into data warehouse tables, and also for Importing and exporting teh jobs.
• Developed Jobs to load teh data from Warehouse to different dimensional tables and fact tables based on teh business requirements.
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, Remove Duplicates, Transformer, Merge, Join, Lookup, Filter, Sort, Dynamic RDBMS, Pivot, Copy, Funnel and Containers (Server, Parallel) for developing job.
• Developed Parallel extender jobs using XML input and XML output stages for extracting data from XML files into SQL database.
• Implemented performance tuning steps to provide maximum efficiency and performance.
• Created teh structured Data extraction jobs which load into staging.
• Created teh Data quality jobs dealt wif field validations vs teh data validations.
• Created teh most critical Data transformation CDC logic for creating teh final load ready files.
• Experience in Fine Tuning, Trouble shooting, bug fixing, defect analysis And Enhancing teh Data Stage Jobs
• Used stages like standardize, match frequency, Investigate in Quality Stage for cleansing of customer data based on address, state, zip.
• Developed user defined Routines and Transformations by using Universe Basic Implementation of Surrogate key by using Key Management functionality for newly inserted rows in Data warehouse
• Involved in testing of Stored Procedures and Functions, Unit and integration Testing of DataStage Jobs, Batches, fixing invalid Mappings.
• Written shell scripts to schedule teh job sequences on teh DataStage server.

Environment: IBM WebSphere DataStage and QualityStage 8.x, SQL, PL/SQL, Shell Scripts, IBM-AIX, SQL Server 2008R2, Windows XP.

Confidential, GA

DataStage Developer

Responsibilities:

• Developed Jobs using DataStage 8.x to load teh data from different sources such as database tables and sequential files to teh target database tables.
• Developed Jobs to load teh data from Warehouse to different dimensional tables and fact tables based on teh business requirements.
• Used Parallel Extender for parallel processing for improving performance when extracting teh data from teh sources.
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, ORA Bulk, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing job.
• Created jobs to handle type-1 & type-2 dimensions.
• Developed Parallel extender jobs using XML input and XML output stages for extracting data. From XML files into Oracle database.
• Processed flat files wif different format from PBS to load into ODS for reporting needs.
• Created teh structured Data extraction jobs which load into staging.
• Created teh Data quality jobs dealt wif field validations vs teh data validations.
• Created teh most critical Data transformation CDC logic for creating teh final load ready files
• Used DataStage Designer for Exporting and importing teh jobs between development, testing and teh production servers.
• Experience in Fine Tuning, Trouble shooting, bug fixing, defect analysis And Enhancing teh Data Stage Jobs
• Used stages like standardize, match frequency, Investigate in Quality Stage for cleansing of customer data based on address, state, zip.
• Developed user defined Routines and Transformations by using Universe Basic Implementation of Surrogate key by using Key Management functionality for newly inserted rows in Data warehouse
• Involved in testing of Stored Procedures and Functions, Unit and integration Testing of DataStage Jobs, Batches, fixing invalid Mappings.
• Written shell scripts to schedule teh job sequences on teh DataStage server.

Environment: IBM WebSphere DataStage and QualityStage 8.x, Oracle 10g/11g, SQL, PL/SQL, Shell Scripts, Erwin, Cognos, IBM-AIX, Windows XP.

Confidential, Detroit, MI

Data Stage Developer

Responsibilities:

• Involved in a process of developing Data warehouse and different data marts for teh user reporting requirements.
• Interacted wif end-users and functional analysts to identify and develop business requirements and transform it into technical requirements.
• Involved in designing teh procedures for getting teh data from all systems to Data Warehousing system.
• Prepared different specifications for data loads and aggregations for teh fact loads.
• Used Parallel Extender for loading teh data, utilizing all available processors to achieve maximum job performance.
• Used teh DataStage Designer to develop processes for extraction, cleansing, and transforming, integrating and loading data into data warehouse database.
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
• Participated in teh development of many Data stage application jobs for data processing and discussions wif DBA’s and halped in database tuning.
• Generating Unix Scripts for Data warehouse applications and maintaining batch processing.
• Conducted Functionality and Interface, Integration, testing during teh various phases of teh project.
• Responsible for writing and designing Quality Assurance standard documents for testing of teh product and build analysis reports.
• Wrote test plans and test cases.
• Extensively wrote user-defined SQL coding for overriding Auto generated SQL query in DataStage.
• Coordinated wif team members at times of change in Business requirements and change in Data Mart Schema.

Environment: Ascential DataStage Enterprise Edition 7.5.1/8.1 (Designer, Director and Administrator), Oracle 9i/10g, AS400, Teradata SQL, Teradata V2R5, PL/SQL, Shell Script, Erwin 4.0, TOAD, AIX UNIX.

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Used teh DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into database.
• Involved in all planning, preparation, and review of ETL design documents against design standards, and business requirements.
• Involved in implementing DataStage Components to set up teh repository using DataStage Manager, Utilizing teh Manager tools to import teh source and target database schemas.
• Worked extensively on different types of Stages like Join, Lookup, Sort, Aggregator, Transformer, DB2 Load Ready Flat File, Relational, Complex Flat File and Multi-Format Flat Files for developing Jobs.
• Created and tested ETL processes composed of multiple DataStage jobs using DataStage Job Sequencer.
• Developed Shell scripts to automate teh processes. Developed Shared Containers and re-used in multiple jobs.
• Created database tables and partitioned teh tables to optimize teh data retrieval.
• Developed aggregate fact tables for different users in Data marts
• Used FTP to transfer teh files between teh UNIX and Windows.

Environment: DataStage 7.x/6.x, Oracle 8i, UDB DB2 v7.0, SAP v4.6c, Oracle Financials v10.7, SQL, PL/SQL, SQL*Loader, Shell Scripts, Erwin 4.0, Business Objects, HP-UNIX, Windows XP.

Confidential, St Louis, MO

Data warehouse developer

Responsibilities:

• Extensively involved in gathering business requirements, design specifications, metadata, new schemas, and enhancing existing designs.
• Extensively used pre built-in DataStage transforms, functions and routines for conditioning, conversions, validation and loading, and also developed if required.
• Used teh DataStage Administrator to assign privileges to users or user groups (to control which DataStage client application or jobs they see or run), move, rename or delete projects and manage or publish jobs from development to production status.
• Converting teh Server Jobs to Shared Container and using them in Parallel jobs.
• Replaced manual extraction wif automatic process using DataStage tool
• Extensively wrote user SQL coding for overriding for generated SQL query in DataStage.
• Responsible for Importing and Exporting of Projects from development on Unix environment, as well as into production using DataStage Manager
• Wrote Shell scripts to automate teh Data extraction process, from FTP process to loading of teh data to teh staging area and teh data mart.
• Coordinated wif offshore team to develop and support teh application.

Environment: DataStage 6.x, Oracle 8i, UDB DB2 v7.0, PeopleSoft 7.x, SQL, PL/SQL, SQL*Loader, Shell Scripts, Erwin, Business Objects, HP-UNIX.

Confidential

SQL Developer

Responsibilities:

• Coded Stored Procedures and procedural functions to support teh 3-tier business application.
• Used Views and joins extensively.
• Used Erwin for DDL generations
• Used SQL Loader to automate teh load of data from Text files to SQL database tables.
• Involved in performance tuning of PL/SQL.
• Created Packages to automate transactions from teh Developer 2000 Applications.
• Experience wif SQL Programming for querying database.
• Created various test scripts for UAT and System testing.
• Responsible for creating code/design documentation.

Environment: SQL server 2000, VB.net, XML, PL/SQL, Windows NT.