SUMMARY

• Total 8+ years of experience in Information Technology and around 5 years of experience in System Analysis, design, development and implementation of Data Warehousing Systems using DataStage, application development and Production Support.
• Experienced in designing ‘Parallel Jobs’ and ‘Server Jobs’ using DataStage 8.5/8.1/7.5/7.0/6.0/5.0 (DataStage Enterprise Edition and Server Edition)
• Skilled in Database programming for Data Warehouses (Schemas), Experienced in Star Schema modeling, and Snowflake modeling, proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (Change Data Capture).
• Extensive knowledge and experience in various Server Stages (Sort, Merge, Aggregator and Transformer), Parallel Stages (Aggregator, Funnel, Filter, Look - Up, Surrogate Key, Remove Duplicate, Transformer, Column/Row Generator and Peek) and Mainframe Stages (Aggregator, Business Rule, Join, Look-Up, Fixed Width Flat File, DB2 Load Ready and Relational).
• Experienced in SQL, PL/SQL and also in Stored Procedures and Triggers. Performed Debugging, Troubleshooting and Performance tuning.
• Experienced in developing and testing of ETL Jobs and Server Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Extensive working knowledge in DataStage Administrator, Designer, Manager, Director.
• Extensive experience in using sequential files, data sets, ODBC, DB2,SQL SERVER, Oracle stage in DataStage designing.
• Worked on UNIX scripts for scheduling sessions, pre sessions and post sessions.
• Worked on different scheduling tools like AutoSys, Control-M and Zena.
• Expert in working on various Operating Systems like UNIX, AIX 5.2/5.1, Sun Solaris v8.0 and Windows and Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Excellent skills in Teradata v2R4/v2R3, Oracle 10g/9i/8i/7, IBM UDBDB2 and SQL Server and in writing Shell Scripts for multiple tasks to be performed.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Excellent communication skills and analytical skills and ability to perform as part of the team.

TECHNICAL SKILLS

ETL Tools: IBM Information InfoSphere 8.5/8.1 (DataStage, Information Analyzer, Quality Stage, MetaStage), Ascential DataStage Enterprise Edition and DataStage 7.5.2/7.0/6.0 (Administrator, Designer, Manager and Director), Oracle Designer, MS Access, AutoSys, Control-M, Xena.

DataModeling Tools: ERwin 4.x/3.5, TOAD

BI Tools: Business Objects XI R2/R4, Cognos, Essbase 7.1

Operating systems: Windows XP/2003/2000(Professional/Server), Windows NT/9x, UNIX/Sun Solaris 8, AIX 5.2

Databases: Oracle 7i/8i/9i/10G, Teradata, DB2, SQL Server 2005/2008

Languages: PL/SQL, SQL, C, C++, UNIX shell, XML

Scheduling Tools: Autosys, control M, Crontab

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr.ETL Developer

Responsibilities:

• Created Detail Design Documents and Mapping documents based on High Level Design and specifications given by business.
• Designed and developed Enterprise Edition DataStage jobs based on requirement specifications given by Business.
• Designed and developed DataStage routines to simplify the design and improve the performance.
• Developed Shared Containers for reusability.
• Developed PL/SQL stored procedures to do complex joins.
• Tuned PL/SQL procedure to improve the performance of ETL process.
• Developed jobs to read data from Flat Files received from external vendors.
• Developed jil scripts to create Autosys jobs and eventually to schedule the jobs.
• Extensively used Dataset, Aggregator, Sort, Join, Funnel, Lookup, Merge, Filter and other parallel stages in developing the solution.
• Extensively used Enterprise/ODBC stages to read data from Oracle, DB2 and SQL Server databases.
• Developed DataStage jobs using Lookup stage for Range Lookup.
• Created Job parameter sets for reusing the parameters.
• Extensively used Resource Estimation feature of DataStage to implement ETL solutions with good performance.
• Implemented restart ability in all DataStage sequencers
• Understood and updated existing DataStage jobs to accommodate changes requested by users.
• Worked closely with Business Analyst in providing efficient solution with good turn around time.
• Created Unit test plans and updated the documents based on the testing.
• Supported Quality Analysts during System/Integration testing phase.
• Supported business users during User Acceptance Test (UAT) and Post Implementation Phase.

Environment: IBM InfoSphere Information Server 8.5 (DataStage, Information Analyzer, MetaStage, Quality Stage), SQL, PL/SQL, Teradata, JDE Pegasus, Business Objects XI R2/R4, Oracle 10g, Sun Solaris, Unix, Windows XP, IBM DB2, AutoSys.

Confidential - Providence, Rhode Island

DataStage Developer

Responsibilities:

• Involved in implementing the Phase - 1 at Citizen’s. As per the business requirements, Phase -1 involves in migrating the retail data from RDR (DB2 UDB 8.X) to BDI (SQL SERVER 2000/5).
• Involved in implementing the Phase - 2 at Citizen’s. As per the business requirements, Phase - 2 involves in migrating the wholesale data from CDB (SQL SERVER 2000/5 ) to BDI (SQL SERVER 2000/5)
• Involved in analyzing the data in RDR which is on DB2 UDB8.X/7.X.
• Worked on clear understanding about the DataModel at Citizen’s.
• Created mapping document with business transformation rules from source to target by coordinating with the business analyst.
• Extracted the data from the source system which is resided on DB2 (RDR), transformed and loaded on to BDI database (sql server 2000/5).
• Data is extracted, transformed and loaded using the ETL tool DataStage 7.5.2.
• Designed the jobs and followed the standards as per the ETL standards available at Citizen’s bank.
• Created complex sql queries for testing the data.
• Created Job sequences to in corporate the flow of jobs and restart ability with robust error handling design.
• Worked on UNIX for deleting the datasets and also for creating the custom directories for loading the files.
• Worked on Unit testing the data as per the internal template available at Citizen’s.
• Coordinated with the team and resolved some of the performance issues.
• Also worked on Aqua Data Studio, third party tool for DB2 Database.

Environment: IBM INFOSPHERE DataStage 8.0, DB2 UDB 8.X/7.X, SQL Server 2000/5, IBM AIX 5, Aqua Studio 4.5.2.

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Datastage Designer.
• Extensively worked with Facts and Dimension tables to produce source - target mappings based upon business specs.
• Used DataStage Manager to implement the Import and Export Interfaces.
• Developed many Datastage application jobs for data processing, loading and jobs are scheduled using Datastage Director.
• Designed several DataStage parallel jobs using Sequential File, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Dataset, Pivot stages, Aggregator, Transformer, Modify, and Compare.
• Automated Job Control using Batch logic to execute and Schedule various DataStage jobs.
• Migrated data from Oracle, SQL Server, DB2 and other flat files data sources using DataStage.
• Analyzed and tuned the database application for performance improvement.
• Extensively used DataStage Designer components to design various Parallel jobs in accordance with business specs.
• Developed the ETL Jobs for handling the SCD Type-II Surrogate Key generation.
• Used Before and After Stage subroutines to further enhance performance of the system.
• Developed the Data Quality jobs, performed the Unit testing of all the jobs through the Job Sequences and documented the test case results as per the standards.

Environment: Ascential DataStage 7.1, DB2, Teradata, Oracle 9i, SQL, PL/SQL, Shell Scripts, Erwin, UNIX, Windows NT 4.0.

Confidential, Chicago, IL

DataStage Consultant

Responsibilities:

• Business requirements gathering -Lease Management.
• Converted functional requirements to detailed ETL technical design specs.
• Created standard templates for efforts estimations, unit / system / integration / UAT / production testing docs and delivery process reviews/checklists.
• Data modeling and creation of Star Schema data marts using ERWIN tool.
• Designed ETL jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
• Customized the DataStage jobs par with current business enhancements.
• Wrote UNIX scripts for running and validating the job.
• Scheduled staging, dimension (common, global and local) and fact jobs both on onetime / daily and on on-demand basis across all the EMP mart financial modules.
• Followed up deployment process of DataStage code migration on different environments (development, test and production) with admin team.
• Co-coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.

Environment: IBM WebSphere DataStage Enterprise Edition 7.5.1, EPM 8.1, SQL SERVER 2005, Clarity, Microstrategy8i.

Confidential 

Programmer

Responsibilities:

• Creation of tables, indexes, views
• Creation of PL/SQL procedures, functions, cursors, packages
• Used JDBC to connect to the database
• Developed Graphical User Interface

Environment: Oracle 6.0/7.x, Forms 3.0/4.5, Reports 2.5, Report writer 1.1 and PL/SQL, Java.