Summary:

• Over 8 years of extensive experience in System Analysis, Design, Development and Implementation of Relational Database and Data Warehousing Systems using IBM InfoSphere Information Server 8.5/8.1 DataStage, QualityStage , IBM DataStage Enterprise and Ascential DataStage 7.5/7/6.x/5.x.
• Excellent knowledge of different RDBMS like Oracle 8i/9i/10g, MS SQL Server, DB2 and Teradata.
• Excellent experience in working with Server jobs, Parallel jobs, debugging, troubleshooting and performance tuning.
• Expert in Data Warehousing concepts like Data Cleansing, Slowly Changing Dimension phenomenon SCD , surrogate key assignment and CDC Change Data Capture .
• Extensive experience in UNIX shells scripting to pre-processing files and checking the integrity of files.
• Experienced in Multi-Terabyte environments, solid experience in coding using SQL, SQL plus, PL/SQL, T-SQL stored procedures/functions, triggers and packages.
• Strong understanding of Data Warehousing principles using Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling.
• Extensive knowledge of business process and functioning of Health Care, Educational and Health Insurance sectors.
• Proven ability to implement technology based solutions for business problems.
• Involved in developing and reviewing the Scrubbing, Matching, Survivorship rules and standardization using Quality Stage.
• Excellent experience in scheduling, monitoring and debugging the production jobs using Autosys.
• Experienced in Data analysis, Data migration, Data modeling concepts and design.
• Expert in unit testing, system integration testing, implementation and maintenance.
• Experienced in Data Warehousing assistance, Application Development and Production Support.
• Experienced in all the stages of Software Development Life Cycle SDLC including business requirement analysis and data mapping.
• Excellent aptitude for problem solving and logical analysis. Excellent coordination skills as a team member.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently.

Skillset: IBM InfoSphere Information Server 8.1 DataStage, QualityStage, Information Analyzer, Metadata Workbench, Business Glossary , IBM DataStage Enterprise and DataStage7.5/7/6.x/5.x/4 Designer, Manager, Director and Administrator , Oracle 8i/9i/10g, DB2/UDB 7.x/8.x, MS SQL Server 2000/2005/2008, TeradataV2R5.x/V2R6.x, Oracle Designer 2000, ERwin 7.x/4.x/3.5, SQL PLUS, SQL Loader, PL/SQL, SQL Navigator, Toad 8.0/9.0, Autosys, Rational Clear Quest, Clear Case, Cognos BI 8, Crystal Reports, SAP R/3, C/C , HTML and COBOL, Sun Solaris Unix, IBM AIX, Unix shell scripting, OS/390, MS Windows 95/98/NT/2000/2003/XP.

Projects Summary:

Confidential

Lead / Sr. Datastage Developer

Confidential affiliated as Emblem Health. Emblem Health is a provider of health coverage plans and provides health care services to its members. The project involved using Datastage ETL jobs for creating output files for vendors and BI team, analysis, debugging and code fix of production problems.

Responsibilities:

• Worked with Users, Business analysts and Subject matter Experts SME's to understand the requirements and created Source to Target mappings.
• Worked with Data Modelers to create tables, indexes, triggers, constrains, views, materialized views, synonyms and grants.
• Used Toad's functionalities like explain plan, session browser for performance analysis and tuning.
• Written SQL scripts extensively for computing, data analysis, finding data discrepancies, testing and validation of data.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data using various stages: CDC, Aggregator, Modify, Funnel, Lookup, Join, Merge, Sort, Filter, Surrogate Key generator, Remove duplicate, Copy, FTP stages for various functionalities
• Used Datastage Transformer stage's Stage variables, constraints and derivations to perform complex ETL transformations.
• Extracted data from Sequential .txt, .csv , Complex flat files COBOL copy books, .dat , and Oracle/ODBC stages.
• Used Development/Debugging stages during development, QA and production phases for debugging.
• Designed DataStage job sequences using stages like job activity, job sequencer, and routine activity, Execute command, start and end loop activity to automate the jobs.
• Used DataStage Director to run, monitor and view logs for jobs, and tuned the Datastage jobs for improving performance.
• Performed internal UAT and presented unit test cases to users and internal QA team for data validation.
• Analyze and develop DataStage production jobs to fix data discrepancies or add new functionalities based on requirements.
• Used UNIX commands for file transferring and written custom shell scripts to perform specific operations in Datastage.
• Wrote Autosys JIL scripts to automate the jobs in production.
• Involved in change control process for deployment and successful production implementation.
• Performed detailed analysis of process, data flow, structure and business rules to identify the root cause of production failures
• Participated in planning, analysis, estimation, prioritization and resource allocation for projects, production problems and service requests
• Part of on call support team for production failures.
• Used Visual Source Safe VSS for version control of datastage jobs and scripts.

Environment: IBM InfoSphere Information Server 8.1 DataStage, QualityStage , Oracle 11g/10g, UNIX, PL/SQL, Toad, Autosys.

Confidential

Sr. DataStage Developer

Confidential is a public University in the state of Confidential. The Project involves the DataStage developer to convert the Oracle and SQL server procedures to DataStage jobs. The project also involves development of new jobs for new upcoming applications. The responsibilities include development, testing, maintenance and standardization of new and existing jobs on the DataStage server.

Responsibilities:

• Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
• Worked with business functional lead to review and finalize requirements and data profiling analysis
• Involved in low level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines and functions
• Imported metadata from repository, created new job categories, routines and data elements.
• Designed and developed jobs using DataStage Designer as per the mapping specifications using appropriate stages.
• Used 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 troubleshooting, performance tuning, monitoring and enhancement of DataStage jobs.
• Converted T-SQL procedures to DataStage jobs.
• Written T-SQL and PL/SQL scripts to fetch data from SQL Server and Oracle databases respectively.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.
• Used Subversion SVN for version control of scripts, files and documents.
• Used Crystal Reports to write reports as per the end users requirements.
• Written windows batch files for automation of DataStage processes.

• Written custom server Routines in DataStage Designer for getting parameters or adding new functions for the transformer stages.

Environment: IBM InfoSphere Information Server 8.5 DataStage , Oracle 11g, PL/SQL, Toad, Microsoft SQL Server 2008, 2005, Microsoft SQL Server DTS Package, Crystal Reports.

Confidential

Datawarehousing Developer

Confidential affiliated as Confidential is a provider of health coverage plans and provides health care services to its members. The project involved extracting, integrating and merging the Early Retiree member and their claim information from Emblem Health databases and outside entities to generate detailed claims reports to provide costs to US department of Health and Human service's HHS Early Retiree Reinsurance Program ERRP .

Responsibilities:

• Worked with the users to translate business rules into technical specifications for development.
• Used PL/SQL explain plan in toad for performance tuning
• Performed data analysis to identify and analyze data discrepancies, patterns and inconsistencies in source/target data
• Created Server, Parallel and Sequencer jobs using Datastage Designer.
• Monitored and analyzed jobs performance and their run times using Datastage Director.
• Used Sequential/Complex files, Oracle/ODBC stages and Datasets to extract and load data
• Created custom server routines for auditing and to assign project level variables
• Migrated jobs from the development environment to testing and from testing to production
• Involved in UAT and validated the test cases by comparing the actual results with expected results.
• Wrote UNIX shell scripts to pre-process data and to automate the Datastage processes.
• Created Oracle procedures PL/SQL for adjustments claim amount, re-bates based on the number of claims filed by the members
• Used triggers to change premium amounts based on new claim numbers filed by members
• Created Indexes and partitions on tables to improve performance of tables
• Utilized oracle functions like rank/dense rank, connect by clause, pivot, case and decode for performing complex logical operations when extracting the data.
• Captured reject data into files and tables for re-processing and better auditing capabilities of the data.
• Used Autosys JIL files to automate the jobs in production.
• Responsible for monitoring the Autosys jobs in production.

Environment: IBM InfoSphere Information Server 8.1 DataStage, QualityStage , Oracle 11g/10g, UNIX, PL/SQL, Toad, Autosys.

Confidential

DataStage / QualityStage Developer

Confidential is a complete health care management organization which provides health care administrative services, management services and business development solutions. The project involved integration of patient information, physician information, health care providers information from different data sources like flat files, Oracle database, SQL server and loading it into a centralized data warehouse to perform data analysis and generate reports to help make better decisions. The task was to administrate the whole project and automation process of the ETL jobs.

Responsibilities:

• Worked with Business analysts and Subject Matter Experts to thoroughly understand the different business processes and data at various sources.
• Involved in creating functional and scope documentation for data cleansing, conversion, and integration processes.
• Performed through data profiling by using the Investigate stage of QualityStage and also by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
• Developed a detailed data profiling report.
• Used Information Analyzer for column analysis, primary key analysis and foreign key analysis.
• Worked with different Sources such as DB2, MS SQL Server and Excel, Flat files.
• Used DataStage Administrator to create Repository, User groups, Users and managed users by setting up their profiles and privileges.
• Developed and reviewed the Standardization, Scrubbing, Matching and Survivorship rules in order to get best of the breed record.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data using various stages like Aggregator, Funnel, Change Capture, Change Apply and copy.
• Worked with DataStage Director to schedule, monitor and analyze performance of individual stages and run DataStage jobs.
• Debugged the aborted jobs by looking into logs in DataStage Director.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Involved in documenting data statistics at various stages and presenting it to various stake holders.

Environment: IBM InfoSphere Information Server 8.1 DataStage, QualityStage , DB2, MS Access, MS Excel, Flat files, SQL Server 2005, UNIX.

Confidential

DataStage / QualityStage Developer

Confidential is a global provider of telecommunication services. It is currently the fourth-largest wireless carrier in the Confidential and seventh largest in carrier in the world providing cell phone services, wireless internet services and Wi-Fi hotspots. The project mainly involved extracting the information from the customer tables, locations tables to find the revenue when various promotions are available to the customers into a centralized warehouse to perform analysis for decision support.

Responsibilities:

• Worked with the Business analysts for requirements gathering, business analysis, testing, and project coordination.
• Involved in creating functional and scope documents for ETL processes.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse. Developed DataStage parallel jobs to load data from sequential files, flat files and Oracle
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator debugging stage , Peek, Remove Duplicates, Copy, Lookup and RDBMS during the development process of the DataStage jobs.
• Created parameter sets to group DataStage job parameters and store default values in files to make sequence jobs and shared containers faster and easier to build.
• Used multiple invocation ids to run multiple instances of jobs at the same time.
• Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the production support people better understand the job runs.
• Migrated jobs from the development instance to testing environment.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Used the DataStage Director and its run-time engine to schedule and run the parallel jobs, testing and debugging its components and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Involved in documenting Documents Inspection DI results to present to the BA.

Environment: IBM InfoSphere Information Server 8.1 DataStage, QualityStage , Oracle, Teradata, MS SQL Server 2005, MS Access, Flat files, UNIX, ERwin 7.1.