SUMMARY

• Around 8 years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) /Enterprise Data warehouse (EDW) analysis, design, development, Testing and implementation.
• 6 years of experience in populating and maintaining Data warehouses and Datamarts using IBM Information Server v8.7, Ascential DataStage v7.5.x/6.x (Administrator, Director, Manager, Designer) - Server Edition, Enterprise Edition (Parallel Extender).
• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Worked with offshore team as co-coordinator with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.
• Expertise in Relational Database Modeling and Dimensional Modeling-Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio.
• Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement.
• Optimized DataStage jobs utilizing parallelism, partitioning and pipelining features of Parallel Extender.
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Experience in migrating ETL code to upgraded version.
• Experience in programming using SQL, PL/SQL, and UNIX Shell Scripting.
• Extensive experience in Microsoft SQL Server 2005/2000, IBM DB2 UDB 8.0/7.0, Informix, Teradata, Oracle 10g/9i/8i., XML files and Message Queues.
• Strong Experience in Unit testing and System testing of the DataStage jobs.
• Experience in Scheduling the DataStage jobs using Control-M, Autosys.
• Knowledge on designing and developing reports using BI/OLAP tools like Business Objects and Cognos.
• Involved in Documentation of ETL process following the standard naming conventions used in DataStage.
• Excellent communication and interpersonal skills, teamwork, problem solving skills, flexible, self-direct and energetic person.
• Extensively worked co-coordinating with offshore team distributing the work, keep tracking development status and monitor day-to-day activities.
• Installation, configuration, setup and Administration of DataStage Server.
• Experience in DataStage Administrator to create/modify/delete projects, add DSN entries and cleanup projects and Implemented security among DataStage users and projects.

TECHNICAL SKILLS

Operating Systems: HP-UX v11.x/10.x, IBM AIX 5.x, Windows 2000/NT 4.0/98/95.

Languages: PL/SQL, SQL*PLUS, UNIX Shell Scripting, C, JAVA, JDBC.

GUI Tools: Oracle Forms 4.5, Oracle Reports 2.5, Visual Basic 6.0

Data Modeling: Star Schema modeling, Snowflakes Modeling, FACT and Dimension tables, Aggregation tables, ERWIN.

ETL: IBM IIS Suite (DataStage, Information Analyzer, Fast Track) 8.x, Ascential DataStage 7.x/Databases Teradata v2r6, Teradata v2r12, Oracle 10g, 9i/8i/8.0/7.x, MS SQL Server 7.0/2000, DB2 UDB v9.7/9/.1/7.1, Informix 2.1/5.0, MSAccess 97/2000.

PROFESSIONAL EXPERIENCE

Confidential, Freeport, ME

Sr. DataStage Developer

Responsibilities:

• Designed and developed DataStage jobs for data extraction from different data feeds into Enterprise Data warehouse.
• Involved in functional and technical meetings and responsible for creating ETL Source - to - Target maps.
• Co-ordinate with Business users to understand the business needs, metric and reports in Retail Industry.
• Extensively worked on bringing store, location, distribution center, SKU Flow planning, merchandise planning data into EDW.
• Worked on Slowly Changing Dimension (SCD) stage.
• Designed and developed DataStage jobs to process inbound XML feed into DB2.
• Extensively worked on XML Plug-In to process real time files and to reach out web services (RTI).
• Worked on processing Sales data into EDW and aggregating sales data to TD (Transaction Day) and PD (Post Date).
• Extensively worked on SAP Extract PACK (SAP R3 Plug-in), which enables DataStage to communicate with SAP source systems.
• Worked on SAP Intermediate Docs (IDoc), ABAP and BAPI stages.
• Developed jobs which involve IDOC Load and IDOC Extract.
• Involved with SAP BASIS and Security teams to troubleshoot DataStage connectivity/Security issues
• Better understanding of SAP concepts, SAP 3-tier architecture, SAP tables and ABAP language and SAP Transaction Codes.
• Worked on building UNIX Shell scripts to handle and validate the inbound files.
• Involved in migration process from DEV to Test and then to PRD.
• Created and used template jobs sequence to generate Header and Footer for each and every interface file across the enterprise.
• Generated offsetting record for each batch using stage variables to support IDOC format.
• Responsible for creation and maintenance of Technical Specs based on Functional Specs.
• Responsible for analyzing and preparing dependencies, sequence in which processes should be scheduled in Control-M scheduler.
• Updated Parameter value files using Datastage jobs.
• Extensively worked on the latest features of Datastage 8.7 like Transformer looping, xml plugins
• Effectively used sort and partition techniques.
• Worked on shared containers and local containers. worked on complex flat file stage using copy books generated by the mainframes team
• Developed parallel jobs using various stages like join, lookup, merge, pivot, row generator, column generator, peak, transformer, funnel, Modify, Aggregator, Change data capture, filter, remove duplicate Stages.
• Used schema files for table definition of sequential file.
• Extensively worked on XML stage on parser, composer, regroup, join, H-pivot, aggregator. Also worked on validating the XSD’s
• Used MQ stage to receive XML queue data and parsed them using XML parser.
• Used IBM Datastage server manager to create packages for migration to required environments.
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Involved in Design, development, unit testing, functional testing and Integration testing Phases
• Identifying the defects using HPQC and resolving those as per the requirements
• Created Unix scripts for running the datastage jobs
• Created shared table definitions for Sequential Files so that we have lineage on IBM Metadata workbench.
• Used clear case for version controlling of scripts.
• Created code reviews using code collaborator.

Environment: IBM WebSphere Information Server v8.7, DB2 V8, SAPR/3/ABAP, UNIX AIX 6,PUTTY,TOAD. TWS, MQ

Confidential, Iselin, NJ

Sr. DataStage Developer

Responsibilities:

• Involved in functional and technical meetings and responsible for creating ETL Source - to - Target maps.
• Using Multi Client Manager worked on IBM Infosphere 8.0 and IBM InfoSphere 8.1.
• Worked with offshore team as co-coordinator with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.
• Worked on building UNIX Shell scripts to check and update the Teradata/Oracle tables and appending multiple CSV’S to a single CSV and used them in Datastage jobs.
• Involved in migration process from DEV to Test and then to PRD.
• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Responsible for analyzing and preparing dependencies and sequence in which processes should be scheduled in Autosys.
• Responsible to provide daily support of data movement processes by using analytical skills to determine the cause and resolution of any data and software issues.
• Responsible to track, log all support issues to significantly reduce the amount of time needed for support issues.
• Extensively worked on designing and developing parallel ETL jobs using Datastage Designer.
• Extensively worked on develop Parallel jobs using stages like Transformer, Funnel stage, Sequential File, data set, Look up, Join, Filter stages.
• Used DataStage director to run, schedule, monitor, debug and view and clear the job logs etc.
• Worked on preparing the test cases and testing ETL jobs and data validation.
• Worked on change management system on code migrations from Dev to QA to Prod environments.
• Attended Corporate Information Architecture (CIA) committee meetings for getting approvals for ETL specifications and designs
• Worked on preparing the inventory of rules developed over the past 3 years, which halped a lot in preparing the Data Quality Dashboard.
• Also Worked on Sending an email notification if the rule on Data Quality Dashboard reach threshold limit.
• Worked with the QA team to resolve the false positive issues for the Data Quality Rules.
• Worked on writing Stored Procedures for Dropping the Partitions used dis stored procedure in Data stage plsql block in order to drop the partitions dynamically by passing the job parameters.

Environment: IBM WebSphere Information Server v8.0.1 (DataStage Designer), Oracle 10g/11g, Autosys, Unix, Borland Star Team, Teradata SQL Assistant Version 14, Windows XP

Confidential, Tampa, FL

Sr. DataStage Developer

Responsibilities:

• Work with end users to gather requirements.
• Involved in the Design review meetings, prepared High level design and source to target (STT) mappings.
• Extensively worked on designing and developing parallel and server ETL jobs using Datastage Designer.
• Extensively worked on develop Parallel and Server jobs using stages like Transformer, Funnel stage, Sequential File, data set, Look up, Join, Filter stages.
• Used DataStage director to run, schedule, monitor, debug and view and clear the job logs etc.
• Reformatted the source flat files using Perl scripts and Korn shell scripts.
• Worked on SQL*Loader and External Table methods of loading flat files to Oracle database.
• Developed various PLSQL packages and procedures for data transformations and ETL work flow.
• Worked on preparing the test cases and testing ETL jobs and data validation.
• Worked on change management system on code migrations from Dev to QA to Prod environments.
• Worked on performance pruning of the data warehouse by building materialized views to withstand call Detail level data querying by customers.
• Experience with Scheduling tool Autosys for automating the ETL process.
• Worked on documenting technical design documents and source to target (STT) documents.
• Involved in Unit Testing, Integration testing and UAT Performance Testing

Environment: IBM Websphere DataStage 8.0.1 (Designer, Director and Administrator), Oracle 9i/10g, Sun Solaris 5.3, SQL Developer, jdk 1.6, CM Synergy 6.5, Windows XP, Visio, Erwin, OBIEE 10.1.3, BMC Remedy 7.5

Confidential, Pontiac, MI

DataStage Developer

Responsibilities:

• Supported existing QIS2 system and develop the new EFMS system
• Production Support the existing QIS2 system
• Design and develop new Jobs if necessary for QIS2 system (for data cleansing)
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts
• Modifying the existing jobs and Hash files according to the changing business rules
• Loading the Historical data into the Warehouse
• Rerun the entire TIS (Techno line Information System) files through Mercator6.7 Maps and then through DataStage Jobs
• Dumped the Look-up data into Hash-files and accessed that data using Hash-file stage to drastically improve the performance of the jobs
• Rebuild the corrupted Hash files
• Used DataStage Manager for importing metadata from repository, new job categories, importing and exporting .dsx Jobs, routines, table definitions, shared containers within the projects and in PVCS (the version controlling tool used for the project) for moving the code from Development environment to Testing environment and then Production.
• Used MetaStage for maintaining the metadata across different projects.
• Modify and create new scripts to schedule the DataStage jobs at CRONTAB for QIS2
• Design and develop jobs for extracting, cleansing, transforming, and loading data into EFMS (Engineering Fleet Management System) System
• Worked with DataStage EE 7.0 to create the parallel jobs
• Worked with stages like Join, Merge, Lookup, Dataset stage to create the parallel jobs
• Used Peek stage to debug the jobs
• Hash Files are used for Lookup data to increase the performance of the system
• Performed the Integration and System testing on the ETL application
• Enforced good Developing and Documentation Principles through out the project.
• Automate the jobs execution by creating shells scripts and scheduling them in CRONTAB for EFMS

Environment: Ascential DataStage 6.0 (Designer, Director, Manager, Administrator), MetaStage 6.0, Oracle 8i, Flat files, Mercator 6.7, Windows 2000, TOAD, XML and Sun Solaris 8

Confidential

Oracle Developer

Responsibilities:

• Participated in the requirement specification study and communication with the different user departments.
• Involved in the design of tables, forms and reports.
• Followed the Software Development Life Cycle (SDLC) process in the development of the application.
• Developed various triggers, functions and stored procedures in PL/SQL.
• Designed screens layouts for the report generation modules.
• Coded many shell scripts for efficient job scheduling.
• Writing control file scripts for loading the data into tables using SQL* Loader.
• Writing PL/SQL procedures, functions and packages to perform numerous calculations.
• Interacted with both Oracle and SQL Server RDMS’s
• Designing and Developing of various screens for the user interfaces using Forms 4.5

Environment: Oracle 8i/7.x, PL/SQL, SQL*LOADER, SQL*Plus, Developer 2000 (Forms 4.5, Reports 2.5)