PROFESSIONAL SUMMARY:

• 9+ years of experience in system analysis, design, development and implementation of Relational Database and Data Warehousing systems using IBM Data Stage 8.5, 8.1/7.x/6.x/5.x (Information Server, Web Sphere, Accentual Data Stage).
• Experienced in designing, developing, documenting, and testing of ETL jobs 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.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experienced in integration of various data sources (DB2 - UDB, SQL Server, Sybase, Oracle, Teradata, XML and MS-Access) into data staging area.
• Expert in working with Data Stage Manager, Designer, Administrator, and Director.
• Experienced with Microsoft DTS packages.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Experienced in handling facets in Health care systems.
• Involved in system transaction training on Claims, Utilization Management, Benefit Plans, Billing, Commissions, Capitation, Customer Service, and Security.
• Possessed detailed knowledge of Quality Stage stages to develop an effective application
• Expert in working on various operating systems like UNIX AIX 5.2/5.1, Sun Solaris V8.0 and Windows.
• Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL.
• Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling).
• Experienced in Data Modeling as well as reverse engineering using tools Erwin, Oracle Designer MS .
• Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Worked on different Scheduling tools like AutoSys for automating jobs run.

TECHNICAL SKILLS:

IBM Information InfoSphere 8.5(Datastage, Information Analyzer, Business Glossary),IBM Information InfoSphere 8.1, Ascential DataStage Enterprise Edition and DataStage 7.5.2/7.0/6.0 (Administrator, Designer, Manager and Director), Informatica Power center 9.0,Infosphere Data Architect 7.5.2,Teradata SQL Assistant, Oracle Designer, Erwin, ER/Studio, TOAD, C, C++, Visual Basic, SQL, PL/SQL, Oracle 11i/10g/9i/8i/7.x, SQL Server 2000/2005/2008 , MS Access, Teradata, DB2, Unix, Linux, IBM AIX 5.2/5.1,7.1,9.1, Sun Solaris V8.0, HP-UX V11.0, Windows XP/NT/2000/98, DataStage Version Control.

PROFESSIONAL EXPERIENCE:

Confidential, CT

Datastage Developer

Responsibilities:

• Involved in technical leadership in the analysis, decision-making, design, and support phases of implementation of computer applications and network hardware and infrastructure, operating systems, databases and enterprise-wide business applications.
• Involved in development phase meetings for Business Analysis, Requirements Gathering and managed offshore team to get Expected results.
• Extensively used DataStage Manager, Designer, Administrator and Director for creating and implementing jobs.
• Extensively worked on error handling, cleansing of data, creating lookup files and performing lookups for faster access of data.
• Used DataStage Manager to import the Metadata from sources and targets.
• Involved in creating technical documentation for source to Confidential mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the DataStage coding.
• Used the DataStage Director for scheduling and monitoring the jobs
• Used DataStage debugger to troubleshoot the designed jobs.
• Tuned DataStage transformations and jobs to enhance their performance.
• Developed DataStage jobs based on business requirements using various stages like lookup file, lookup stage, join stage, merge stage and sort stage.
• Used Shared Containers for code reuse and implementing complex business logic.
• Involved in creating designing and mapping documents for DataStage jobs.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Scheduled job runs using Autosys and used DataStage director for debugging and testing.
• Created JIL files for Autosys On Monthly and Daily Basis
• Tuned DataStage jobs to enhance their performance

Tools: IBM Info sphere Information server 8.5 (Data stage, Quality Stage, Information Analyzer, Business Glossary), Oracle 11g, AutoSys, TOAD 9.6, Erwin, UNIX, HP quality center

Confidential, Cleveland, OH

Datastage Developer/Quality Stage Developer/ Data Modeler

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Designed the Data Models using Erwin 7.5.
• Created Physical and Logical models using Erwin.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Involved in creating entity relational and dimensional relational data models using Erwin tool.
• Generated snowflake, models through dimension modeling.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created Surrogate Key Tables.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
• Developed and reviewed the Standardization, Scrubbing, Matching and Survivorship rules in order to get best of the breed record
• Worked extensively on forward and reverse engineering processes using Erwin.
• Worked on third normalization form for the databases.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the data marts
• Extracted the source data from Oracle tables, MS SQL Server, sequential files and excel sheets.
• Designed and developed parallel jobs using DataStage Designer.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Extensively used Data Stage Tools like DataStage Designer, DataStage Director for developing jobs and to view log files for execution errors.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the DataStage coding.
• Used the DataStage Director for scheduling and monitoring the jobs.
• Imported tables, files definitions in to the datastage repository.
• Implemented local containers for same job and shared containers for multiple jobs which have the same business logic.
• Written functions, transforms, before job routine and after job routines using DataStage basic.
• Written UNIX scripts, DOS scripts.
• Expert in developing the test cases for various scenarios
• Involved in performance tuning of the jobs.
• Used DataStage debugger for troubleshooting and validating the jobs.
• Solved the Service Requests (Tickets) of 15 to 20 Requests in a week.
• Generated PDF’s for the models and maintained the Records in the Share Point.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues.

Tools: IBM info sphere Data Stage 8.5 (Designer, Director, Manager, and Parallel Extender), Oracle 11i, Teradata, PL/SQL, MS SQL, Server 2008, DB2, Flat files, Sequential files, AIX UNIX, Erwin 7.5, and Autosys.

Confidential, New York City, NY

Datastage Developer/Quality Stage Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Involved in appropriate and quality of data for data integration initiatives.
• Involved in Facets of integrated health care management system designed to handle the complex requirements of managed care programs
• Involved in system transaction training on Claims, Utilization Management, Benefit Plans, Billing, Commissions, Capitation, Customer Service, and Security.
• Involved in detailed knowledge of Quality Stage stages to develop an effective application..
• Used appropriate tool to fulfill data quality and business requirements.
• Provided metadata to create functional and technical specifications for data integration/cleansing applications.
• Monitored resolution of data quality issues.
• Involved in understanding logical and physical models for the subject area of the Customer Information Management.
• Involved in Documentation Planning and Implementation.
• Experienced with data modeling tools such as MS Visio and/or Erwin
• Worked with Data stage Administrator for creating projects, defining the hierarchy of users and their access.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for pivoting the mainframe file data into fixed width file.
• Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the Oracle server database.
• Imported table/file definitions into the Datastage repository.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign DataStage jobs for loading the data into Data marts.
• Created a Fixed Width file of 3000 bytes using ETL process from various mainframe files.
• Created Batch Processes for running the jobs in parallel.
• Extensively used DataStage Tools like InfoSphere DataStage Designer, InfoSphere DataStage Director for developing jobs and to view log files for execution errors.
• Controlled jobs execution using sequencer, used notification activity to send email alerts..
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Scheduled job runs using Autosys and used DataStage director for debugging and testing.
• Created JIL files for Autosys On Monthly and Daily Basis
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Performed right and left justified for Null handling functions.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Tools: IBM Info sphere Information server 8.5 (Data stage, Quality Stage, Information Analyzer, Business Glossary), Oracle 11g, Flat files, Autosys, TOAD 9.6, Erwin, UNIX, hp quality center.

Confidential, Chicago, IL

Datastage Developer/Quality Stage Developer

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Developed and executed IBM QualityStage data quality tools.
• Supported and generated Enterprise Data Governance quality assurance metrics.
• Created critical field reporting tools for Enterprise Data Management customer segments..
• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the Confidential Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of Data Stage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Control-M job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.
• Verified the Essbase Report by extracting data from the Staging Database using PL/SQL queries.
• Wrote Configuration files for Performance in production environment.

Tools: IBM InfoSphere Information server 8.5 (Datastage, Quality Stage, Information Analyzer, Business Glossary), Oracle 10g,SQL Server 2008, DB2 UDB, Teradata, Flat files, Sequential files, Control-M, AIX UNIX.

Confidential, Greensboro, NC

Data stage Developer/Data Modeler

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts to get specific user requirements.
• Involved in understanding logical and physical models for the subject area of the Customer Information Management.
• Involved in Documentation Planning and Implementation.
• Experienced with data modeling tools such as MS Visio and/or Erwin.
• Experienced in relational data models such as conceptual, logical and physical data models, dimensional data models, data dictionary, and metadata.
• Responsible for developing, validating, and communicating data modeling solutions, including both relational and dimensional models.
• Designed the mappings between sources (external files and databases) and Operational staging targets.
• Extensively used stages in Parallel Extender (PX) to design DataStage jobs for performing the required integration.
• Extensively used Sequential file and Complex Flat File stages to read SAS files.
• Involved in Project management from analysis and design to implementation and construction.
• Extensively used DataStage Tools like InfoSphere DataStage Designer, InfoSphere DataStage Director.
• Received the source data in the form of Oracle tables, Sequential files, flat files and Excel sheets, Mainframes, SQL Server.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
• Involved in job scheduling using Autosys.
• Created Job Sequencer to execute a set of jobs.
• Created error and exception handling procedures to identify record, report and fix errors.
• Validated the current production data, the existing data and programming logics involved.
• Ensured that the data integration design aligns with the established information standards.
• Developed jobs to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Scheduled, tested and debugged jobs. Worked on programs for scheduling data loading and transformations using DataStage from source systems to Oracle 11g using PL/SQL.
• Improved the performance of jobs by interpreting the performance statistics and enhanced the job designs.

Tools: IBM InfoSphere Information Server (DataStage and Quality Stage, Information Analyzer, Metadata Workbench) 8.1, IBM-AIX, SQL Server 2008, Oracle 11g, Unix Shell Scripts (ksh), PL/SQL,UNIX, Autosys, Erwin/MS Visio .

Confidential, Newark, NJ

Data Stage Developer

Responsibilities:

• Interacted with source system users and business users to get business requirements.
• Involved in designing of data models using Erwin.
• Created and maintained Erwin based Logical and Physical Data Models.
• Defined data requirements definition in conjunction with BA's, SME's, Developers.
• Reverse-engineered legacy databases to generate Physical Models.
• Analyzed legacy database and user interfaces to recommend conversion strategy and procedures.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions
• Created jobs in DataStage to extract from heterogeneous data sources like DB2, Access and Flat files to Teradata.
• Involved in Creating Datastage jobs using different stages like Transformer, Lookup stage, Joins and Funnel stages.
• Scheduled and monitored the jobs in DataStage Director to load data into Teradata database.
• Extensive hands on experience in scheduling job using Control-M.
• Wrote Extensive UNIX scripts for running the Data Stage jobs.
• Tuned DataStage jobs to enhance their performance
• Developed SQL Scripts to modify the existing database objects and packages.
• Created PL/SQL procedures, triggers and functions for processing portfolio management information.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis..
• Developed, automated and scheduled load processes using UNIX shell scripting.

Tools: IBM DataStage 8.1 (Designer, Director, Manager, Parallel Extender), Oracle 10g,SQL Server 2008, DB2 UDB, Flat files, Sequential files, Autosys, TOAD 9.6, SQL*Plus, AIX UNIX, IBM Cognos 8.0

Confidential, Minneapolis, MN

Lead ETL/ DataStage Developer

Responsibilities:

• Involved in technical leadership in the analysis, decision-making, design, and support phases of implementation of computer applications and network hardware and infrastructure, operating systems, databases and enterprise-wide business applications.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Extracted, rectified, cleansed and loaded data from flat files, using shell scripts and different stages into different databases.
• Migrated development mappings as well as hot fixes them in production environment.
• Performed an impact analysis on ETL jobs, before the jobs migrated in Data stage 7.5.3 version.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and to dynamically distribute to all available nodes to achieve best Job performance.
• Created Batch Processes for running the jobs in parallel.
• Involved in creating a Visioand work order for the offshore DPC team (Distribution Production Control Team).
• Involved in validation and verifying the ETL jobs, after the implementation from the DPC team.
• Involved in raising an incident, after the batch monitoring done by a offshore team.
• Involved in the migration of DataStage jobs from development to production environment.
• Received the Master data and populated the Dimension Tables, Time generation, Surrogate key generation.
• Handled several External Database extractions from Oracle, Sybase, SQL server, DB2, EXCEL file transformations.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Tuned Data Stage jobs to enhance their performance.

Tools: Data Stage 7.5 (Parallel Extender), Oracle 8i, DB2, Sybase, SQL Server, Control-M, Erwin 4.0, Windows Visio, UNIX, Windows-XP.