SUMMARY:

• IBM Certified WebSphere DataStage Professional
• Over 11 years of experience in the field of Information Technology, with extensive experience in designing, developing and implementing Data Warehouses and DataMart for Retail and Financial Industries.
• Extensive experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using ETL Tools DataStage EE (Manager, Designer, Director, Administrator), Parallel Extender, Teradata, Informatica, Modeling Tool Erwin, ETL, OLAP and OLTP
• Experienced in Database design using Teradata, Oracle 9i, SQL Server 2000, with knowledge of ER - Diagrams, Entities, Granularity, Cardinality, Entity and Associations.
• Highly motivated, result oriented professional with a short learning curve and excellent communication skills.

TECHNICAL SKILLS:

ETL: IBM DataStage 11.3/9.1/8.7/8.5/8.1/8.0/7.5/7.0/6.0/5.2 (Manager, Administrator, Designer, Director, Parallel Extender, Business Glossary), IBM Pack for SAP BW 4.0.1 and Ascential Pack for SAP R/3 5.0,Informatica, Data Warehousing, Metadata, DataMart, OLAP, OLTP, SQL*Plus

Reporting: Oracle SQL, PL/SQL, Teradata, SAP Business Objects

Databases: Oracle 10g/9i/8i/8.0.3/7.3, Teradata v12.0, SQL Server 2000, DB2, MS Access

Data Modeling: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

Others: Visual SourceSafe, Clear Case, Korn Shell, Control-M and AutoSys

Programming: UNIX Shell Scripting, SQL, PL/SQL, C, C++, CGI/PERL, Java

Environment: Win 3.x/95/98/2000, UNIX, MS-DOS, and Red Hat Linux.

PROFESSIONAL EXPERIENCE:

Confidential, TX

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Worked on multiple projects to accommodate specific data delivery needs
• Implemented solution architecture for wealth management scorecard and financial advice groups
• Performed data discovery, analysis to provide support to business users on current state situation
• Designed reusable artifacts for data processing
• Supported business users on different business objects reports data drills and associated issues
• Supported UAT environment for verification of data loaded for major high priority fixes
• Involved in planning and effort estimates for different tasks
• Worked on data validations and reconciliations efforts
• Worked on scheduling ETL jobs through control-m for overall integration
• Worked on Hadoop to archive source data and core tables

Environment: IBM InfoSphere Information Server V 9.1/11.3 DataStage, Oracle, IBM Netezza, LINUX, SAP Business Objects,Hadoop, IBM BigInsights and Control-M

Confidential, NJ

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Worked on data delivery of different replication efforts
• Assisted in Setting up application specific UAT environments
• Designed ETL framework for DR solution copy the production data to backup database
• Supported QA and UAT environments for different data needs
• Worked on Involved in planning and effort estimates for different tasks
• Assisted in infrastructure setups required for environment setups
• Worked on data validations and reconciliations efforts
• Worked on scheduling ETL jobs through autosys for overall integration
• Involved in production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, Oracle, Green Plum, UNIX and Autosys

Confidential, Outdoors, TX

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning and effort estimates for different tasks
• Gathered requirements for both data and reporting layers
• Assisted in infrastructure setups required for data extraction
• Worked as a data modeler for the datawarehouse build
• Created Mapping document to build the datawarehouse
• Designed ETL framework for to load data from different source systems
• Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 8.5 DataStage, DB2, IBM Netezza, Red Hat Linux

Confidential, NY

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning and effort estimates for different tasks
• Designed ETL solution for HR Workday integration
• Analyzed workday extracts to gather requirements
• Created design and mapping documents for different efforts on multiple tasks
• Worked as SME for different key Subject areas
• Worked extensively with XML stage to parse the Workday source data
• Designed data integration pattern for extracting Workday data which includes public API, Custom reports extract from HR Workday to HR Data Warehouse using XML integration with Datastage Web service method.
• Developed and tested the Workday Web service job using SOAP UI and optimized the Workday data extract performance using Webservice Client stage
• Coded and unit tested the complex components to meet the business specific requirements
• Validated the data loaded through datastage programs using sql
• Interacted with business users and OBIEE reporting team on validation issues for bug fixes
• Worked on Performance tuning of datastage designs for faster availability of critical data for reporting
• Proactively interacted with infrastructure team to address capacity management issues
• Worked with team on different phases to ensure application data quality and in-time delivery of the data
• Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, SQL Developer, ORACLE 11i/10g, OBIEE, XML, Workday, Red Hat Linux

Confidential, Iselin, NJ

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning and effort estimates for different tasks
• Translated Informatica ETL architecture into DataStage specific architecture
• Analyzed Informatica ETL programs to gather requirements
• Lead the team of datastage resources to layout the design foot print for complete application
• Created design and mapping documents for different efforts on multiple tasks
• Coded and unit tested the complex components to meet the business specific requirements
• Validated the data loaded through datastage programs
• Written UNIX shell scripts for pre/post processing and to populate parameter sets
• Worked on Performance tuning of datastage designs for faster availability of critical data for reporting
• Proactively interacted with infrastructure team to address capacity management issues
• Worked with team on different phases to ensure application data quality and in-time delivery of the data
• Acted as a point of contact and also supported multiple applications through production support

Environment: IBM InfoSphere Information Server V 8.1/8.5 DataStage, SQL Developer, ORACLE 11i/10g, Teradata, Informatica, Red Hat Linux, Autosys

Confidential, Mahwah, NJ

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning the entire effort to finalize the delivery time lines for each phase
• Translated Mainframe ETL architecture into DataStage specific architecture
• Extensively analyzed Mainframe Cobol ETL programs to gather requirements
• Lead the team of datastage resources to layout the design foot print for complete application
• Applied Modularization and concurrent execution practices to meet the performance requirements
• Established Datastage specific application framework to ensure best practices for optimal performance, reusability and restartability
• Created high level design and technical specs for both dimension and fact tables
• Worked on configuration of database connections and adding projects to the different environments
• Extensively worked on building delta process utilizing Slowly Changing dimension stage
• Worked with Business Glossary to create and manage the business vocabulary for technical team members
• Worked with scheduling team to establish the dependencies with both upstream and downstream applications/systems
• Worked with team members to Identify, track, and resolve issues as they arise
• Worked on Performance tuning of datastage designs for faster availability of critical data for reporting
• Proactively interacted with infrastructure team to address capacity management issues
• Worked with team on different phases to ensure application data quality and in-time delivery of the data
• Worked on production support of complete application and assisted team on monitoring other applications

Environment: IBM InfoSphere Information Server V 8.5/8.7 DataStage and Quality Stage, Business Glossary, SQL PAL, ORACLE 11i, Mainframe, Red Hat Linux

Confidential, Dayton, OH

DataStage Architect/Technical Lead/Sr DataStage Developer

Responsibilities:

• Interacted with other interface teams to gather ETL functional requirements
• Performed design and code reviews for projects and enhancements
• Performed Health Checks on the existing environment and implemented best practices for better code management and clear understanding of business logic
• Designed/wrote the tech specs (Source-Target mappings) for the ETL mappings along with the Unit Test scripts
• Extensively worked with IBM information server console for administration activities like adding users, providing access to specific projects, adding environmental variables at the project level, setup new ODBC connections, starting and stopping DataStage servers, increasing buffer for reference files and modified start-up script to overcome file size limitation on regular basis
• Worked on configuration of database connections and adding projects to the different environments
• Extensive hands on experience in installation and configuration of DataStage client and plug-ins
• Implemented Customer Master Data Management process to remove duplicates, standardize data and in corporate rules to eliminate incorrect data to create an authoritative source of master data
• Participated and planned environment changes required for better performance and resolve some outstanding issues
• Assisted in Planning real time High availability environment setup for better performance
• Worked with IBM resources on planning HA architecture for the current environment upgrade to V8.5
• Trained and assisted team members from the high level architecture to low level development activities
• Involved in production support activities as required

Environment: IBM InfoSphere Information Server V 8.0.1/8.1 DataStage and Quality Stage, TOAD, DB2, ORACLE 10g SQL/PLSQL, Sql Server 2000/2005, Siebel CRM, TERADATA, Red Hat Linux and NT

Confidential, Richmond, VA

DataStage Architect/Lead Developer/Teradata Conversion Lead

Responsibilities:

• Worked extensively for sales force automation to fulfill business needs
• Interacted with business users, stake holders and other interface teams to gather business/functional requirements
• Participated high level business requirement discussions to blue print the requirements
• Created data flow diagrams to understand different systems and their dependencies
• Involved and assisted in data model for the dataware house from the scratch.
• Designed/wrote the tech specs (Source-Target mappings) for the ETL mappings along with the Unit Test scripts
• Worked on upgrading the client to DataStage EE 7.5.1 from DataStage 7.0
• Performed administration activities like starting and stopping DataStage servers, increasing buffer for reference files and modified start-up script to overcome file size limitation on regular basis
• Worked on configuration of database connections and adding projects to the different environments
• Extensive hands on experience in installation and configuration of DataStage client and plug-ins
• Designed the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system
• Designed various jobs in PX, DataStage as per given specs
• Created solutions for error-handling the DataStage jobs
• Developed error reconciliation process for managers to get the detailed report for critical source and target issues
• Developed Parallel jobs using Parallel stages like: Dataset, Sequential file, Complex flat file, Funnel, Filter, Modify, Merge, Join, LookUp, Transformer (Parallel), Oracle Enterprise Stage
• Worked extensively with complex flat file stage to extract data from mainframe BMC files.
• Performed set up the projects, roles, users, privileges in different environments (DEV, QA, PROD)
• Worked on Optimization of the server performance to avoid or resolve any deadlocks
• Worked with XML data sources to extract data and bring that into datawarehouse
• Imported and exported DataStage jobs across various DataStage projects and servers
• Created parallel routine to meet the complex business validation of the records
• Worked extensively with SAP R/3 connector to extract data into DataStage
• Worked on SAP BW packs to both extract and load data from DataStage
• Worked with DataStage Administrator for SAP Packs to configure connections for both SAP BW and SAP R/3
• Used Remove Duplicates stage in PX (EE) to remove the duplicates in the data
• Used UNIX utilities AWK and SED in before and after job subroutines for better performance
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Performed testing of these Parallel jobs using Row Generator and Column Generator stages
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements
• Created DataStage jobs, job sequences and tuned them for better performance
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis)
• Worked on Master Data Management process to remove duplicates and standaridize data coming from different sources
• Worked with offshore team for development as well as production activities
• Extensively worked on production support of all DataStage Applications

Environment: IBM WebSphere DataStage 7.0, Ascential DataStage EE 7.5.1 (Designer, Manager, Director, Administrator), IBM Pack for SAP BW 4.0.1 and Ascential Pack for SAP R/3 5.0, TOAD, DB2,ORACLE 10g SQL/PLSQL, TERADATA,UNIX (AIX) and NT

Confidential, NY

Senior Data Warehouse Designer/Analyst

Responsibilities:

• Involved in analyzing the data base schema using Erwin
• Created DataStage jobs using Designer and extracted data from various sources, transformed data according to the requirement and loaded into data warehouse schema
• Compiled the jobs using designer to produce executables
• Created transforms and routines for handling special cases
• Used various stages like Sequential file, Transformer, OraOci9i stage, ODBC, Aggregator, Hash file, Link Partitioner
• Used Oracle external tables to load data from flat files in to DB
• Created Unix Shell scripts for validating the source files like file existence, move files from ftp, extract files, file counts and check sum verification, archiving files for disk space management
• Used DataStage Director validated, scheduled, executed and monitored the jobs
• Created batches and sequencers for running and controlling set of jobs
• Used SQL coding for overriding the generated SQL in DataStage and also tested the data loaded into the database
• Developed Parallel jobs using Parallel stages like: Merge, Join, LookUp, Transformer (Parallel), Oracle Enterprise Stage
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Performed testing of these Parallel jobs using Row Generator and Column Generator stages
• Extensively involved in production support for Contracts Data Warehouse
• Migrated UNIX scripts, Oracle SQL scripts, parameter files, control files and data files to the corresponding prod directories from the test area
• Created tables, normal view, materialized view, Triggers synonyms, analyze tables, and grant privileges
• Tuned the performance of SQL statements using HINTS and using TKPROF utility & Explain Plan Table
• Worked with Unix Scheduler Crontab to add new and modified existing ones
• Used Version control tools (CVS and VSS) for production migration process as part of new releases of Production support for Contracts DW
• Created Unix Shell script to automate the FTP process for receiving and sending the files from data vendors like IMS, WKH, VA, and Milliman
• Prepared IC Source files manifest and delivered to ZS on monthly basis
• Production support for SDM (specialty Data mart), which is completely implemented in Informatica
• Created Auto-sys jobs to schedule the jobs to be run the given time and completion of the dependent jobs

Environment: IBM WebSphere DataStage 7.5 (Designer, Manager, Director), Parallel Extender, CRONTAB Scheduler, Erwin 4.1, SQL, PL/SQL, Oracle 9i, Windows NT 4.0,HP-UX, Unix Shell Scripting, Microsoft Visio, Informatica Power center 7.1.1, AutoSys, Visual SourceSafe

Confidential, Wilmington, DE

DataStage Analyst

Responsibilities:

• Involved in development phase for Business Analysis and Requirements gathering
• Designed/wrote the tech specs (Source-Target mappings) for the ETL mappings along with the Unit Test scripts
• Designed the mappings between sources (external files and databases) to operational staging targets
• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data in Parallel Extender
• Used Operators like Look-up stages, File stage, Funnel Stage, Data Set stage and Merge Stage
• Created DataStage jobs, batches and job sequences and tuned them for better performance
• Used the DataStage Director and its run-time engine to schedule
• Extensively worked on Hash-file Stage for look-ups, DB2Bulk Load, ODBC, Hashed file, Aggregator, Sequential file, Link Partitioner and Link Collector stages
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Involved in tuning of Server jobs for performance using Hash-file Stage, OraBulk Stage and others
• Worked with Oracle Stored Procedures and packages to integrate new enhancements to the existing ones
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements
• Executed the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis)
• Worked with CVS to co-ordinate with other team members about global PL SQL packages, UNIX shell scripts and DS jobs

Environment: Ascential DataStage 6.0 and EE 7.5 (Designer, Director, Manager), Oracle 9i, PL/SQL, DB2, SQL Navigator, UNIX, Korn Shell Scripts, Win CVS

Confidential, St. Louis, MO

Designer/Senior DataStage Analyst

Responsibilities:

• Gap analysis for the system to build the Data Mart. Designed the Logical design of the DM in Erwin.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Designed/wrote the tech specs (Source-Target mappings) for the ETL mappings along with the Unit Test scripts
• Involved in designing various jobs in PX, DataStage as per given specs
• Created solutions for error-handling the DataStage jobs
• Developed Parallel jobs using Parallel stages like: Merge, Join, LookUp, Transformer (Parallel), Oracle Enterprise Stage
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Performed testing of these Parallel jobs using Row Generator and Column Generator stages
• Worked on programs for extracting the data using DataStage from DB2 to Oracle using SQL* Loader and PL/SQL
• Used Remove Duplicates stage in PX (EE) to remove the duplicates in the data
• Worked with DS Sever stages like Transformer, IPC, Aggregator, Sort, Link Partitioner, Link Collector and other stages
• Created UNIX shell script to FTP the flat file from remote third party server to our local server or also used FTP stage for this
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements
• Worked with XML stages for handling the XML data and used Folder Stage to read the XML data
• Created DataStage jobs, batches and job sequences and tuned them for better performance
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis)

Environment: Ascential DataStage EE 7.5.1 (Designer, Manager, Director), Oracle 9i, TOAD, Crystal Reports, SQL/PLSQL, UNIX (HP-UX) and NT, Shell Scripting