SUMMARY

• Over 7 years of experience in IT industry especially in building data warehouses and Decision support Systems (DSS) analysis, design, development, Testing, Production, Integration and implementation.
• Strong experience in loading and maintaining Data Warehouses and Data Marts using DataStage ETL processes.
• To Standardize and cleansing the data using QualityStage.
• Extensive exposure to Star, Snowflake Schema and Multidimensional Data Models.
• Experience in Extraction, cleansing, integration, loading of data from/to disparate data sources.
• Strong noledge of Extraction Transformation and Loading (ETL) processes using DataStage, UNIX shell scripting and SQL Loader.
• Experience in IBM Clearcase and developing datastage jobs according to cobol program.
• Experience in extracting data from Mainframe systems using CFF stage wif changes in Copybook.
• Experience in Using IBM WebSphere MQ (MQ Series) and SAP PACKS.
• Experience in Using XML and Web services Packages in Data stage Integration.
• Experience in IBM Fast Track and Metadata Workbench, Business Glossary for data mapping and data lineage purpose.
• Expertise in working wif various operational sources like DB2, UDBDB2, SQLServer, Oracle, Teradata V2R6/V2R5, Flat Files into a staging area.
• Experience in Teradata utilities in like Fast Load, MultiLoad and Fast Export, query tools BTEQ and SQL Assistant, Teradata SQL, Explain Plan, bulk loaders and un - loaders.
• Excellent experience in extracting data from Teradata, DB2, and Oracle and loading into an EDW.
• Worked closely wif multiple business channels and agile teams in attending SCRUM meeting and delivering the tasks as scheduled.
• Experience in Evolving Strategies and developing Architecture for building a Data warehouse by using data modeling tool Erwin.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Involved in Requirements gathering, Logical design model & physical design model meetings to understand the data flow, frequency of data loads into EDW and create S2T Mapping documents and visio diagrams.
• Extensive experience in loading high volume data, and performance tuning.
• Involved in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Good interpersonal skills, experience in handling communication and interactions between different teams.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere DataStage 8.5, IBM Infosphere DataStage 8.0.1, IBM Websphere Information Server 8.0 (Designer, Director, Administrator), Ascential DataStage 7.5 (Designer, Director, Administrator, Manager).

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

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

Tools: SQl Assistant, SQL Plus, SQL*Loader, TOAD, DB visualizer, Oracle Developer.

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

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

BI Reporting Tools: Business Objects, Cognos and Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Senior DataStage Developer

Responsibilities:

• Involved in design, development, testing and documenting.
• Helped business analyst to refine and enhance initial requirements.
• Develop code, configuration files, build scripts, schemas or other artifacts associated by the features, QC and UC tickets, as assigned by team or tech lead.
• Maintain code and all related artifacts in source control.
• Perform code merges and resolve conflicts as defined by development process, update documentation and automated tests.
• Responsible for documentation and audit artifacts as defined in SDLC and published standards.
• Expertise in designing and implementing Data stage Architecture in data warehousing and Data Mart Applications.
• Worked wif Functional team and Data Modelers/Architects to identify and understand the data from different source systems.
• Involved in the Analysis of the functional side of the project by interacting wif functional experts to design and write technical specifications.
• Data base design & data model - Logical & Physical design wif hands on experience on DDL and DML SQL operations.
• 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 System Integration testing.
• Extracted data from sources like Oracle and Flat Files.
• Working in a team wif other associate product & componentdevelopers.
• Involved in Quality Assurance; Unit Testing and Integration Testing to test jobs and also the system process flow.
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Merge, Sort, Remove Duplicate, Copy, Funnel, CDC, Change Apply and Filter and other stages.
• Provide documentation as appropriate to the Component Business Owner.
• Develop Unit; Functional and System Integration (SIT) test plans.
• DevelopDataStagejobs to transform data and build data warehouse.
• Created source to target mapping and designed functional design documents.
• Developed various data marts for various purposes.
• Write UNIX shell scripts to read replicate data between databases.

Environment: IBM InfoSphere Data Stage 8.X, DB2, Oracle 11g, UNIX, MICROSOFT VISIO, control-M, SQL plus, WinCVS

Confidential, Houston, TX

Sr. DataStageDeveloper

Responsibilities:

• Excellent Experience in Designing, Developing, Documenting, Testing ofETLjobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Proficient in writing, implementation and testing of triggers, procedures and functions in Oracle.
• Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioned and Link Collector.
• Excellent noledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Coordinate wif team members and administer all onsite work packages.
• Schedule and plan all data stage tasks.

Environment: IBM Info Sphere Data Stage 11.3 Quality stage, Oracle 11g, FTP, Windows 2007, XML, SQLdeveloper.

Confidential, Milwaukee, WI

DataStage Developer

Responsibilities:

• Extensively usedDataStagefor extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Collaborated wif EDW team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• 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 usedDataStageChange Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.
• 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.
• Collaborated wif BI and BO teams to find how reports are effected by a change to the corporate data model.
• Utilized Parallelism through different partition methods to optimize performance in a large database environment.
• 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 dat it meets the requirements.
• Developed UNIX shell scripts to automate file manipulation and data loading procedures.
• Scheduled the jobs using AutoSys.
• Responsible for daily verification dat all scripts, downloads, and file copies were executed as planned, troubleshooting any steps dat failed, and providing both immediate and long-term problem resolution.
• Provided technical assistance and support to IT analysts and business community.

Environment: IBM WebSphereDataStageand QulalityStage 8.0.1a (Administrator, Designer, Director), Microsoft SQL 2005/2008, IBM DB2 9.1, AIX6.0, Microsoft SQL 2008, Oracle 11g, Toad 9.5, MS Access, SAP MDM, shell scripts, PUTTY, WinSCP, ERWIN 4.0, HP Quality Center, AutoSys.

Confidential, Vienna, VA

DataStage Developer

Responsibilities:

• Worked extensively on different types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Merge and Sort for developing jobs.
• UsedDataStageManager to define Table definitions, Custom Routines and Custom Transformations.
• UsedDataStageDirector to run, schedule, monitor, debug and test the application on development and to obtain the performance statistics.
• Extensively used Joins stage (inner, outer and full), Lookup stage, Change Capture stage, Copy stage.
• Extensively used AscentialDataStageas an ETL to extract data from sources like SQL Server, Flat files and loaded to target Oracle.
• Created shared containers to use in multiple jobs.
• Extensively worked onDataStageJob sequencer to schedule jobs to run jobs in sequence.
• Create control tables recording all jobs profiles.

Environment: DataStage7.5/7.0, Oracle 9i, SQL Server 2005, Unix Shell scripts.

Confidential

Oracle Developer

Responsibilities:

• Involved in development activities including installation and configuration, database design and SQL scripting.
• Creation of users and assigning roles & permissions to the users.
• Implemented backups/restore strategies for point in time recovery purposes.
• Refreshing the Databases as per the Development requirements.
• Developed several reports using SQL server Reporting services (SSRS).
• Developed SSIS Packages to migrate data from excel spreadsheet to SQL Server.
• Creating, suggesting and maintenance of indexes.
• Taking care of problems faced by users related to slow execution of queries etc.

Environment: MS SQL Server 2008, Windows 7, Visual Studio.