SUMMARY

• Highly Motivated, Solutions Driven with over 7+ years of Data Warehousing experience with dedicated work towards Data stage tool, which covers about 5+ years of experience on the tool in the areas of ETL design and Development.
• Involved in complete Software Development life - cycle (SDLC) of various projects, including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance.
• Excellent Interpersonal and communication skills with an ability to remain highly focused and self-assured in fast-paced and high-pressure environments
• Extensive ETL tool experience using IBM Infosphere/Websphere Datastage, Ascential Data Stage. Worked on Datastage client tools like Datastage Designer, Datastage Director and Datastage Administrator.
• Good Knowledge about the principles of DW like Data marts, OLTP, OLAP, Dimensions. Excellent in using highly scalable parallel processing infrastructure using parallel jobs with multi-node configuration files.
• Experienced in scheduling sequence, parallel and server jobs using DataStage Director, UNIX scripts and scheduling tools.
• Designed and developed parallel jobs, server and sequence jobs using Datastage Designer.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements
• Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Worked with various databases like Oracle 10g/9i/8i, DB2, SQL Server, Teradata.
• Experience or working knowledge of MS servers and batch file scripting.
• Experience with ftp, sftp, eftp and ssl transfer protocols.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere DataStage 8.7, IBM Infosphere DataStage 8.5, IBM WebSphere DataStage 8.0.1, (Designer, Director, Administrator), Ascential DataStage 7.5.2 Enterprise Edition (Designer, Director, Administrator, Manager).

Operating Systems: IBM AIX 5.2/4.x, Linux, Windows 2000/2003/XP.

Languages: SQL, PL/SQL, Unix Shell Scripting, PERL Java, HTML, DHTML

Database: Oracle 10g/9i/8i, IBM DB2/UDB, Teradata, SQL Server 2003/2005/2008.

Data Modeling: Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions, Physical and Logical Data Modeling using Erwin.

Tools: SQL Plus, SQL*Loader, TOAD, Aginity workbench for Netezza, Autosys Scheduling tool,IBM Rational Requisite pro

BI Reporting Tools: Business Objects, Cognos and Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Sr. Data Stage Developer

Responsibilities:

• Involved in the Analysis of the functional side of the project by interacting with functional experts to design and write technical specifications.
• Data base design &data model - Logical & Physical design.
• Worked on the Architecture of ETL process.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, scheduled the same using Data Stage Sequencer for SI testing.
• Extracted data from sources like Oracle and Flat Files.
• Experienced in using SQL *Loader and import utility in TOAD to populate tables in the data warehouse.
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Debug, test and fix the transformation logic applied in the parallel jobs
• Preparing development timing plans & reporting to senior management about the supplier progress system & ensuring their engineering support for onsite integration & production launch.
• Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms by architecting Data Warehouses and Marts.
• Worked on Data Stage 8.x parallel Version.
• Designed and developed parallel jobs, server and sequence jobs using Datastage Designer.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, and Sort, Remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Developed various bulk load and update procedures and processes using SQL * Loader and PL/SQL.
• Troubleshooting performance issues with SQL tuning.
• Working in a team with other associate product & component developers.
• Involved in Unit testing and Integration testing to test jobs and also the flow.
• Worked on changed requests as per clients and projects technical specification needs.
• Awareness about the functional/business aspects for the components.
• Automated process of job monitoring, which helped in minimizing the manual intervention & documenting them perfectly.
• Experience in QA testing of ETL processes
• Provide support for monthly/weekly batches in production run.
• Involved in the Documentation of the ETL phase of the project.
• Developed the reusable components, best practices that were later on used in other Data warehouse.
• Documenting business process, lesson learned & best practices for the project.

Environment: Infosphere DataStage 8.7 and 8.5 (Designer, Manager, Director and Administrator), Teradata v2r6, v2r12, Autosys Scheduling tool, IBM Rational Requisite pro, Oracle 11g/10g/9i, Aqua Data Studio, Toad, Shell Scripts, AIX 5.1.

Confidential, Washington, DC

Sr. Data Stage Developer

Responsibilities:

• Designed the ETL jobs using Infosphere DataStage Server 8.5 to Extract, Transform and load the data into Staging and then into Oracle Database.
• Extensively used the designer to develop various parallel jobs to extract, transform, integrate and load the data into Corporate Data warehouse (CDW).
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Handled Performance Tuning of Jobs to ensure faster Data Loads.
• Extensively worked with Shared Containers for Re-using the Business functionality.
• Created Job Parameters and Environment variables to run the same job for different schemas.
• Used to do code reviews for all the jobs before moving to production.
• Used ETL Job Control to run the jobs.
• Used Director to monitoring jobs, run and validating its components.
• Involved in the Performance Tuning of the DataStage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or databases.
• Used QualityStage stages such as investigate, standardize, match and survive for data quality and data profiling issues during the designing.
• Migrated projects from development to QA to Production environments
• Performed the Integration and System testing on the ETL application.
• Taking the regular backups of the jobs using Data Stage Manager Export/Import utility.
• Working with BI team to apply the business rules for OLAP, designing the Frame Work models.
• Assisted operation support team for transactional data loads in developing SQL & Unix scripts
• Participated in Unit testing and Integration testing of DataStage jobs.

Environment: Infosphere DataStage 8.7 and 8.5 (Designer, Manager, Director and Administrator), Teradata v2r6, v2r12, Autosys Scheduling tool, Oracle 10g/9i, Aqua Data Studio, Toad, Shell Scripts, AIX 5.1.

Confidential, Hartford, CT

ETL Datastage Developer

Responsibilities:

• Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle,DB2 and Flat files.
• Collaborated with EDW team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Collaborated with EDW team in, Low Level design document for mapping the files from source to target and implementing business logic.
• Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Tuned transformations and jobs for Performance Enhancement.
• Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.
• Created Batches (DS job controls) and Sequences to control set of jobs.
• Extensively used DataStage Change Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.
• Executed Pre and Post session commands on Source and Target database using Shell scripting.
• Collaborated in design testing using HP Quality Center.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Collaborated in Extraction of OLAP data from SSAS using SSIS.
• Extensively usedSAP R/3 and SAP BW packs
• Collaborated with BI and BO teams to find how reports are affected by a change to the corporate data model.
• Collaborated with BO teams in designing dashboards and scorecards for Analysis and Tracking of key business metrics and goals.
• Utilized Parallelism through different partition methods to optimize performance in a large database environment.
• Designed and developed parallel jobs, server and sequence jobs using Data stage designer.
• Developed DS jobs to populate the data into staging and Data Mart.
• Executed jobs through sequencer for better performance and easy maintenance.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.
• Developed UNIX shell scripts to automate file manipulation and data loading procedures.
• Scheduled the jobs using Autosys, Tivoli and Corntab.
• Collaborated in developing Java Custom Objects to derive the data using Java API.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Provided technical assistance and support to IT analysts and business community.

Environment: IBM WebSphere DataStage 8.0.1 (Designer, Director and Administrator), IBM AIX UNIX, Oracle 10g, SQL Server, DB2, Flat files, Job control.

Confidential, Detroit, MI

Data stage developer

Responsibilities:

• Involved in the Analysis of the functional side of the project by interacting with functional experts to design and write technical specifications.
• Data base design & data model - Logical & Physical design.
• Worked on the Architecture of ETL process.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, scheduled the same using Data Stage Sequencer for SI testing.
• Obtaining productive gains during vehicle life to meet aggressive cost reduction target.
• Extracted data from sources like Oracle and Flat Files.
• Preparing development timing plans & reporting to senior management about the supplier progress system & ensuring their engineering support for onsite integration & production launch.
• Working in a team with other associate product & component developers.
• Involved in Unit Testing and Integration Testing to test jobs and also the flow.
• Worked on changed requests as per clients and projects technical specification needs.
• Awareness about the functional/business aspects for the components.
• Automated process of job monitoring, which helped in minimizing the manual intervention & documenting them perfectly.
• Provide support for monthly/weekly batches in production run.
• Involved in the Documentation of the ETL phase of the project.
• Developed the reusable components, best practices that were later on used in other Data warehouse.
• Documenting business process, lesson learnt & best practices for the project.

Environment: IBM WebSphere DataStage 8.0.1 (Designer, Director, Administrator), Ascential Datastage 7.5.2 (Director, Designer, Manager, Administrator), DB2, Teradata, SQL Server, Oracle 9i, Clear Case.

Confidential, Atlanta, GA

ETL Data Stage developer

Responsibilities:

• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using Server and Parallel jobs.
• Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL and Oracle
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Implemented parallel extender jobs for better performance using stages like Join, Merge, Sort and Lookup, transformer with different source files complex flat files, XML files.
• Optimized job performance by carrying out Performance Tuning.
• Created Stored Procedures to confirm to the Business rules.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, scheduled the same using Data Stage Sequencer for SI testing
• Involved in creating UNIX shell scriptsfordatabase connectivity and executing queries in parallel job execution.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Environment: IBM WebSphere Data Stage 8.1 (Designer, Director, Administrator), DB2, Teradata, SQL Server, Oracle 9i, IBM AIX UNIX, VSS.

Confidential

DW/ETL Tester

Responsibilities:

• Designed and created various Test Plans, Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Used Mercury Quality Center 9.0 to state requirements, business components, test cases, test runs for every iterations, defects. Also link defects with requirements
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Worked with other members of the QA and Development teams and offshore team (INDIA) in improving the processes, tools, methods, effectiveness and efficiency
• Used TOAD Software for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Involved in Unit, Functional, Regression and System testing.
• Documented and reported various bugs during Manual Testing.
• Stored data in the Data Warehouse about Customers, Accounts. The loads were scheduled (Daily and weekly) depending on the frequency of source data.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects
• Performed Installation testing and Performance testing manually.

Environment: ETL (Data stage), UNIX, Test Director, DB2, Oracle, Autosys, Windows XP, Toad .