SUMMARY

• Around 7 years of experience in building Data Warehouse using IBM DataStage 8.5/8.1/8.0.1/7.5.2 (Data stage Enterprise Edition).
• Proficient in Software Life Cycle Development Methodology (SDLC)
• Worked in migration project from Mainframes to ETL
• Participating in high level and detailed analysis and design efforts focusing on Extract, Transform and Loading of data.
• Extensively worked with SCD, CDC and Difference stages.
• Assisting the data Modeler/Data warehouse developer in reviewing staging, data warehouse and data mart modules for completeness and the ability to load.
• Experience working with Teradata, Oracle, SQL Server, PL/SQL and writing Stored Procedures and Triggers.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables and star schema modeling.
• Experience in working with large data warehouses, mapping and extracting data from legacy systems, Teradata/Oracle/Db2 UDB databases.
• Assisting the data modeler/data warehouse developer in reviewing staging, data warehouse and data mart models for completeness and the ability to load.
• Extensive experience in writing SQL scripts and UNIX scripts.
• Worked with XML input, XML output and XML transformer.
• Familiarity with Linux Scripting.
• Operational knowledge of Linux - based operating systems

TECHNICAL SKILLS

Data Warehousing Tool: DataStage8.5, 8.0, 8.1 and 7.x

Business Intelligence: Business objects 5.x, Micro Strategy, Crystal Reports

Databases: Teradata, Oracle 9i/10g, SQL server 2005 and Db2

Languages: SQL, PL/SQL, C, C++

Operating Systems: Windows NT & 2000, HP-UX, AIX and Linux

Data modeling tools: Erwin 4.1

Database Tools: SQL Plus, SQL Loader,Teradata SQL assistance

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Worked as Senior Datastage developer in WCC and ADV projects and responsible for migrating Mainframe jobs from ETL jobs and comparing Mainframe file to ETL file
• Worked in WCC migration project from Legacy Mainframes to ETL Dtastageholds customer data and created gold standard files, which will be used by downstream applications
• Worked ADV project compares Mainframe files to ETL Dtastage file,
• Implemented generic solution to compare any Mainframe files and any ETL files such as Datasets, Ascii and Ebcdic, and generated reports to users
• Involved in development phase meetings for Business Analysis and Requirements Gathering
• Used several stages like Sequential file, complex flat file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator (debugging stage), Peek, Remove Duplicates, Copy, Lookup and SCD during the development process of the Data Stage jobs
• Created Error files and Log Tables containing data with discrepancies to analyze and re-process data
• Created job sequences and generic reusable jobs to control the flow of jobs along the process.
• Extensively used orchadmin commands to analyze the data in data sets and validate them in the testing process and defect identifications
• Participated in daily status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams and documenting the proceedings.
• Created migration documents for job migration among the repositories and run books for data execution process
• Estimation, HLD and LLD design documentation

Environment: IBM DataStage8.5, DB2, SQL, Linux, Autosys and Clear Case.

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Worked in capacity of Technical/Data Analyst in ERISA project and responsible for the timely delivery of monthly and yearly reports.
• Troubleshooting and stabilizing the System by analyzing the data and the ETL Code, also minor enhancements/fixes.
• Provide on call support for the jobs that generate reports for ERISA.
• Have exposure to latest datastage version 8.7.
• Responsible for analyzing and understanding Metadata and Data.
• Worked closely with data Modelers and Business Users to develop ETL loads for various Type 1, and Type 2 Datamarts.
• Drop index and create index to improve performance of DataStage jobs.
• Transformations including aggregation and summation construction from operational data source to data warehouse.
• Debugged existing issues and provide prompt resolution.
• Review procedures in data base management system manuals for making changes to data base, such as defining, creating, revising, and controlling data base.
• Developed job sequencers and implemented restart ability using various checkpoints.
• Used DataStage Designer for developing various jobs to extract data from different sources and load data into temp tables for validation testing and production run.
• Used DataStage Director and runtime engine to schedule running the DataStage jobs, monitoring scheduling and validating its components.
• Extensively worked in improving performance of jobs by avoiding as many transformers.
• Worked in development of common error management to capture and handling error records.
• Worked in the unit testing, regression testing and integration testing for transition data.

Environment: IBM DataStage8.1, 8.0.1, Teradata 13, SQL, Unix, Autosys and WinSCP.

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Participated in gathering of business requirements and carry out a suitable data model for Data Mart and Data Warehouse.
• Reviewed interactive design and technology project request describing data base user needs, and determine if project requires creating series of new programs or modifying existing programs that access data stored in databases.
• Used parallel extender for splitting and organizing the data into subsets and achieve better job performance.
• Responsible for analyzing and understanding Metadata and Data.
• Worked closely with data Modelers and Business Users to develop ETL loads for various Type 1, and Type 2 Datamarts.
• Drop index and create index to improve performance of DataStage jobs.
• Wrote documentation for detail transactions data for operational data store.
• Created of WebsphereDataStage Server jobs in order to feed the datawarehouse and datamarts to analyze sales.
• Transformations including aggregation and summation construction from operational data source to data warehouse.
• Debugged existing issues and provide prompt resolution.
• Review procedures in data base management system manuals for making changes to data base, such as defining, creating, revising, and controlling data base.
• Developed job sequencers and implemented restart ability using various checkpoints.
• Used DataStage Designer for developing various jobs to extract data from different sources and load data into temp tables for validation testing and production run.
• Used DataStage Director and runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Extensively worked in improving performance of jobs by avoiding as many transformers.
• Worked in development of common error management to capture and handling error records.
• Worked in the unit testing, regression testing and integration testing for transition data.
• Generated server side PL/SQL scripts for data manipulation, validating and materialized views for remote instance.
• Worked with data stage procedures, functions, cursors, joins and triggers using PL/SQL.
• Written PL/SQL stored procedures to facilitate coding.

Environment: IBM DataStage 8.0.1, Information Server (InfosphereDataStage) 8.0.1, Oracle 9i/10g, SQL server 2005, SQL, PL/SQL, Unix and Windows XP pro.

Confidential, Raleigh, NC

ETL Developer

Responsibilities:

• Analyzed business requirements by working closely with business users.
• Designed ETL process model for processing ETL jobs and AD-HOC reporting on DataStage servers.
• Used DataStage Designer to develop jobs for extraction, transformation and loading data into data warehouse database.
• Involved in design of jobs for extracting incremental load of data from source and loading into data mart.
• Used QualityStage plug-ins to call QualityStage jobs into DataStage
• Used parallel extender to run the jobs in parallel which improved for straight bulk loads.
• Solved production and critical problems in ETL applications.
• Developed rerun procedures to overcome fail-over conditions for ETL batch jobs.
• Created master controlling sequencer jobs using DataStage job sequence.
• Optimized SQL queries for better performance by using Partitioning, Indices and Views.
• Worked on synchronous and asynchronous process to assign messages to queue Managers.
• Wrote SQL scripts and UNIX shell scripts.
• Worked on process design documentation of the Data Warehousing dimensional upgrading.
• Implemented source key generator stage and slowly changing dimensions.
• Was responsible for DataStage Development and implementing Type 2 Datamarts and Type 3 Updates.
• Developed job sequencers for executing DataStage jobs.
• Implemented overall best practices, tips and techniques in design, development, testing and deployment of DataStage jobs to the target Oracle environments.

Environment: DataStage 8.0.1, DataStage 7.5.1, Oracle 9i/10g, Edit plus, SQL, PL/SQL, UNIX and Windows Server.

Confidential

DataStage developer

Responsibilities:

• Developed healthcare system making using Data Marts.
• Extracted the data stored in different databases and loaded into Oracle system.
• Involved in the creation of jobs using DataStage designer and used Director to validate, schedule, run and monitor the DataStage jobs.
• Involved in designing the procedures for getting the data from all system to Data Warehousing system.
• Information stored in table definition and is entered using DataStage manager.
• Extensively used ETL Tool to load data from DB2 to Oracle Database.
• Exporting the universe to the repository to make resources available to the users.
• Created the reports using the universes as the main Data providers and writing the complex queries including sub queries, unions, joins, intersects and aliases.
• Extensive use of slice and dice for generating master/detail and tabular reports.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.

Environment: AscentialDataStage 7.5.1, Oracle 8i/9i, SQL, PL/SQL, Windows NT, Unix