SUMMARY

• 9 years of experience in IT as an application developer with experience in teh total life cycle of Software Development Applications involving Requirements, Design, Analysis, Development and Testing.
• 8 years of in - depth experience in Extraction Transformation and Loading (ETL) processes). Using IBM Web sphere Data stage 9.1/8.5/8.1/8.0/7.5/7.1/7.0/6.0 and mapping Server and Parallel jobs.
• Worked on Datastage client tools Datastage Designer, Datastage Director, Datastage Manager and Datastage Administrator.
• Experience in Designing, Compiling, Testing, and Scheduling and Running Data stage jobs against variety data sources.
• Worked with various techniques such as schema bound views, partitioning, and ETL/Query optimization.
• Efficient in all phases of teh development life cycle, coherent with Data Cleansing, Data Integration, Data Conversion, Performance Tuning.
• Developed Server jobs for extracting, transforming, integrating and loading data to targets.
• Excellent experience in using Stages like Complex Flat File, Dataset, Copy, File set, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress etc.,
• Worked with various databases Oracle 10g/9i/8i/8.0/7.x, DB2, MS Access, Netezza, SQL Server and Experience in major relational DB platforms.
• Extensive Experience working with Database tool Toad, SQL Loader, Netezza, Fast Load, Multi Load, Netezza Manager, CLI, ODBC etc.,
• Expertise in data warehousing techniques like Data cleansing, Slowly Changing Dimension phenomenon and Change Data Capture.
• Used Datastage Version Control to migrate teh project from one environment to teh other.
• Experience working with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources. Worked with most of teh parallel stages applying different partitioning techniques.
• Experience in Debugging, Troubleshooting and Performance tuning.
• Knowledge on Information Analyzer.
• Experience with teh Production support.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Ascential Data stage 9.1/8.5/8.1/8.0/7.5/7.1/6.0 (Manager, Designer, Director, Administrator), Data Stage PX (Parallel Extender), Quality Stage, Meta Stage, Profile Stag. Informatica Power Center 8.6.,SSRS

Databases: Oracle10g/9i/8i/8.x/7.x,DB 2 9.0/8.0/7.0, Netezza V2R5/V2R4/V2R3, MS SQL Server 2005/7.0/6.5, Ms Access 2000, SQL*Plus, SQL*Loader, TOAD 7.0 and Developer 2000

Environment: Sun Solaris 2.7/2.6, Confidential -UX 10.2/9.0, IBM AIX 4.3/4.2, Linux, MS DOS 6.22, Win 3.x/95/98/XP, Win NT 4.0, Sun Ultra, HP9000, IBM RS6000, AS400

Programming Skills: UNIX Shell Scripting, SQL, PL/SQL, SQL*Plus 3.3/8.0, C, C++, Java, JavaScript, SQL*Loader, VB, ASP, COBOL, HTML, XML.

Data modeling Tools: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake, Modeling, Fact and Dimensions Tables, Physical and Logical Data, Modeling and ERwin 4.5/4.0/3.5/3.0, Enterprise Database, Integration and Management.

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Data stage Developer

Responsibilities:

• Experience in Designing, Compiling, Testing, and Scheduling and Running Data stage jobs.
• Worked with various techniques such as schema bound views, partitioning, and ETL/Query optimization.
• Efficient in all phases of teh development life cycle, coherent with Data Cleansing, Data Integration, Data Conversion, Performance Tuning.
• Developed Server jobs for extracting, transforming, integrating and loading data to targets.
• Expertise in data warehousing techniques like Data cleansing, Slowly Changing Dimension phenomenon and Change Data Capture.
• Used Datastage Version Control to migrate teh project from one environment to teh other.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Schedule jobs through UNIX shell scripting in AIX and/or UNIX.
• Worked exclusively with teh Netezza SQL Assistant to interface with teh Netezza.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Data stage jobs.
• Troubleshooting and performance tuning of ETL jobs
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.

Environment: SSRS, SSIS, Ascential data Stage 9.1/8.5/8.1 - Data Stage Designer, DataStage Director, DataStage Manager, Data Stage Administrator, Oracle, SSRS,SSIS,UNIX Shell Programming.

Confidential, Iselin, NJ

Data stage Developer

Responsibilities:

• Designed and tested teh DataStage jobs for extract, transform and load.
• Involved in performance tuning of teh Data Stage jobs and queries.
• Written SQL in DB2 for using in DataStage and testing teh data.
• Involved in creating WINSCP server, for scheduling and running Datastage jobs.
• Worked exclusively with teh Netezza SQL Assistant to interface with teh Netezza.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Datastage jobs.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved writing shell scripts for running Datastage jobs, Using CSV (Hierarchy file for Datastage jobs).
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using DataStage.
• Using DataStage Designer designed and created jobs for Target Warehouse Entity for Oracle.
• Involved in creating Autosys, for scheduling and running Datastage jobs.
• Performed teh Unit testing for jobs developed to ensure that it meets teh requirements.

Environment: Ascential DataStage 9.1/8.5/8.1 - DataStage Designer, DataStage Director, DataStage Manager, Autosys, Oracle, UNIX Shell Programming, DB2, Netezza.

Confidential, Chicago

Datastage Developer

Responsibilities:

• Designed and tested teh DataStage jobs for extract, transform and load.
• Involved in performance tuning of teh Data Stage jobs and queries.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Data stage jobs.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved writing shell scripts for running Data stage jobs, Using CSV, Excel, text (Hierarchy file for Data stage jobs).
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using Data stage.
• Using Data Stage Designer designed and created jobs for Target Warehouse Entity for Oracle.
• Developed Quality stage jobs to Standardize Addresses and Names.
• Involved in creating WINSCP server, for scheduling and running Datastage jobs.
• Extensively involved ETL code using Datastage in order to meet requirements

Environment: Ascential data Stage 9.1/8.5/8.1 - Data Stage Designer, DataStage Director, DataStage Manager, Data Stage Administrator, Quality Stage, Oracle, UNIX Shell Programming.

Confidential, Bentonville, AR

Datastage Developer

Responsibilities:

• Designed and tested teh DataStage jobs for extract, transform and load.
• Developed various jobs using stages DB2 enterprise, lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel etc.
• Involved in performance tuning of teh Data Stage jobs and queries.
• Involved in teh Production support.
• Worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Written SQL in DB2 for using in DataStage and testing teh data.
• Worked exclusively with teh Netezza SQL Assistant to interface with teh Teradata.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Datastage jobs.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved writing shell scripts for running Datastage jobs, Using CSV (Hierarchy file for Datastage jobs).
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using DataStage.
• Using DataStage Designer designed and created jobs for Target Warehouse Entity for Oracle.
• Involved in creating CA7, for scheduling and running Datastage jobs.
• Performed teh Unit testing for jobs developed to ensure that it meets teh requirements.

Environment: Ascential DataStage 8.5/8.1 - DataStage Designer, DataStage Director, DataStage Manager, Data Stage Administrator, Oracle, UNIX Shell Programming, DB2, Teradata.

Confidential, Nashville, TN

Datastage Developer

Responsibilities:

• Designed and tested teh DataStage jobs for extract, transform and load.
• Developed various jobs using stages DB2 enterprise, lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel etc.
• Involved in performance tuning of teh Data Stage jobs and queries.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Extensively worked with quality stage for data cleansing, data standardization and matching process and implemented stages like Investigate, Match and Survive.
• Extensively worked with Quality stage to standardize data by trimming teh spaces, removing nonprinting characters, incorrect spellings using transfer, parse, collapse, select, unijoin and build stages.
• Worked exclusively with teh Teradata SQL Assistant to interface with teh Teradata.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Datastage jobs.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved writing shell scripts for running Datastage jobs, Using CSV (Hierarchy file for Datastage jobs).
• Implemented ETL Processes and developed complex SQL queries involving extremely large tables using DataStage.
• Using DataStage Designer designed and created jobs for Target Warehouse Entity for Oracle.
• Involved in creating Autosys Jils, for scheduling and running Datastage jobs.
• Performed teh Unit testing for jobs developed to ensure that it meets teh requirements.

Environment: Ascential DataStage 8.5/8.1 - DataStage Designer, DataStage Director, DataStage Manager, Data Stage Administrator, Quality Stage, Oracle, PL/SQL, UNIX Shell Programming, Erwin, DB2, JD EDWARDS.

Confidential, Tallahassee, FL

Data stage Developer

Responsibilities:

• Worked with teh Business analysts and teh DBA for requirements gathering, business analysis, testing, and project coordination.
• Involved System analysis and design of Enterprise Datawarehouse.
• Involved in creating Functional and scope documents for ETL process.
• Involved in developing Data mart for Reporting applications using Data Stage.
• Developed Datamarts for different customers with their requirements and developed a process to capture teh statistics of all teh tables to check teh integrity like Min, Max, Mean, Sum and Median from Source to Target (me.e. SOR (System of record to Datamart tables).
• Designed, developed and tested teh DataStage jobs for extract, transform and load.
• Extensively worked on writing Datastage Build-Ops for various jobs based on teh requirements and transformation rules.
• Wrote stored procedures and triggers in Oracle 8i for managing consistency and referential integrity across data mart.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Tuned teh Parallel jobs for better performance.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Written SQL in DB2 for using in DataStage and testing teh data.
• me extensively worked on Oracle PL/SQL programming. As part of dis, me developed packages, procedures, and functions.
• Developed Parameterized reusable Datastage jobs where you can use these jobs in multiple instances.
• Developed Datastage Jobs to load teh data into Teradata tables using Fast load utility.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Datastage jobs.
• Developed Qualitystage jobs to Standardize Addresses and Names.
• Extensively involved in ETL code using Datastage tool in order to meet requirements
• For extract, cleansing, transformation and loading of data from source to target data Structures.
• Performed Unit testing for jobs developed to ensure that it meets teh requirements.
• Created MS Visio Process flows to understand teh processes and for maintenance purpose
• Supported Production On call for a week in every two months for newly installing code and for all Production issues.
• Performed User Acceptance Testing and end user training.

Environment: Ascential DataStage 7.5/7.1(Designer, Director, Manager), Oracle, SQL, PL/SQL, Shell Script, TOAD, ERWIN 4.2, DB2, UNIX, Server 2005, Business Objects 5.1, Win 2000/NT and AIX UNIX.

Confidential, NY

ETL Developer

Responsibilities:

• Extensively used DataStage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
• Worked with Data Stage Manager to import/export metadata, DataStage Components between teh projects.
• Involved in Design, Source to Target Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
• Loaded integrated data into teh Teradata database using Load utilities like (Fast Load, MultiLoad, & TPump).
• Involved in Performance Tuning of Parallel Jobs using Performance Statistics
• Used Various Standard and Custom Routines in DataStage jobs.
• Schedule jobs through UNIX shell scripts.
• Responsible for adopting teh standards for Stage and Link naming conventions.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in DataStage.
• Involved in unit testing, system testing and integration testing.
• Created and edited teh design specification documents for teh jobs
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any technical and Business Requirement issues.
• Coordinated with team members at times of change in Business requirements and change in Data Mart Schema.

Environment: Ascential DataStage 4.0/5.1 (Data Stage Designer, DataStage Director, DataStage Manager, DataStage Administrator), Informatica Power Center 8.6, Oracle 8i, PL/SQL, UNIX Shell Programming, WinNT 4.0 Server, Windows NT.

Confidential, San Francisco, CA

Data stage developer

Responsibilities:

• Interacted with Business personnel to analyze teh business requirements and transform teh business requirements into technical requirements.
• Developed and supported teh extraction, transformation and load process (ETL) for Data Warehouse from teh source systems using Data stage.
• Wrote SQL overrides in source qualifiers for extracting only teh required rows for optimal performance.
• Involved in developing Data mart for Reporting applications using Data Stage.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• 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.

Environment: Ascential DataStage 7.5/7.1(Designer, Director, Manager), Oracle, SQL, PL/SQL, Shell Script, TOAD, ERWIN 4.2, DB2, UNIX, Server 2005, Business Objects 5.1, Win 2000/NT

Confidential 

DW Developer

Responsibilities:

• Database servers and backup server’s installation.
• Support of Production, Development and Test Environments of Oracle and Sybase Databases for multiple applications.
• Troubleshooting and Performance tuning of SQL Servers and applications.
• Backup and Recovery procedures for Production and Development servers.
• Running DBCC and fixing database consistency and allocation errors.
• Creating databases, tables, indexes, new logins, users etc.
• Monitoring performance of Oracle database.
• me extensively worked on Oracle PL/SQL programming. As part of dis, me developed packages, procedures, and functions.
• Statistics maintenance.
• Converted Dozens of SQR Reports to Teradata SQL reports.
• Writing shell scripts to schedule tasks.
• Creating stored procedures and triggers.

Environment: Oracle 8.0, Teradata-V2R4 PL/SQL, SQL, Windows NT