SUMMARY:

• Having 12 years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) and involved in analysis, design, development, implementation and Testing.
• Over 10 years of ETL/Datastage tool experience using IBM Web sphere/ Ascential DataStage (Ver 11.5, 8.7, 8.5, 8.1), Designing and developing jobs using Designer, DataStage Manager, DataStage Director and DataStage Administrator and DataStage Parallel Extender .
• Performed administration tasks like connectivity, configuration of projects, configuring DSN entries, user - defined environment variables.
• Experience in Data Modeling, development of conceptual, logical, and physical data models, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables.
• Developed the Source- Confidential Mapping for the Dimensions and Fact Tables.
• Extensively used Parallel Extender to load data into data warehouse with different techniques like Pipeline and Partition in MPP environment.
• Used Data stage Enterprise Edition/Parallel Extender stages like Datasets, Sort, Lookup, Change Capture, Funnel, Row Generator, Join, Merge, Lookup, XML, Web Services stages in accomplishing the ETL Coding.
• Involved in migration of DataStage projects and jobs from earlier versions to IBM Infosphere 8.0.1 version.
• Used QualityStage stages Standardization, Matching and Survivorship rules to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing application.
• Experience in implementing DB2, DB2/UDB, Oracle, SQL Server, PL/SQL, SQL*Plus database applications.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems.
• Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance testing.
• Experience in analysis Coding using SQL and PL/SQL, Developing, Writing Unix Shell Scripts and code/script testing.
• Expertise in Data warehousing and Data migration.
• Extensive experience in loading high volumes of data.

TECHNICAL SKILLS:

ETL Tools: DataStage Enterprise Edition 8.7/8.5/8.1/7.5 (Parallel Extender), SSIS, Informatica

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop

Data Modeling Tools: Visio 2010

Databases: Oracle, SQL Server, DB2 UDB, My SQL, Netezza, Teradata, NoSQL

Tools: SQL*Plus, Version Control, Hue

Operating Systems: IBM AIX 5.2/4.x, Linux

Programming: C#.Net, SQL, PL/SQL, Unix Shell Scripting

CM Tools: Star Team, CA SCM WorkBench, ChangeMan DS

WORK EXPERIENCE:

Confidential, PHEONIX, AZ

Technology: UNIX, DataStage 8.7 & 11.5, Oracle Exadata 12c, Teradata, Hue client

Sr. Developer

Responsibilities:

• Understanding business processes, gathering requirements, identifying potential usability issues and ensuring that an appropriate level of application quality was maintained at all times.
• Defined and implemented ETL development standards and procedures.
• Developed Data Stage parallel jobs and sequences using data stage designer.
• Prepares the Technical design document and Participated in source to Confidential mapping design document.
• Involved in Data Stage Admin tasks setting project wide defaults, Creating Environment Variables and Monitor project disk space, configuring DSN entries.
• Prepares the Unit test Case document.
• Responsible for designing and maintaining ETL jobs that includes extracting the data from teradata base and transforming the data according to business requirements and then loading to Oracle Exa database.
• Moved 70TB(7years) of data from Teradata to Oracle Exadata base.
• Resolved technical challenges loading large data volume efficiently.
• Scheduled various ETL Batch processes using Control M

Confidential, Houston, TX

Technology: UNIX, DataStage 8.7, Oracle

Sr. DataStage Developer

Responsibilities:

• Developed Data Stage parallel jobs and sequences using data stage designer.
• Prepares the Technical design document and Participated in source to Confidential mapping design document.
• Prepares the Unit test Case document.
• Generate the complex xml format in Data Stage which contains the Policy transactions information.
• Responsible for designing and maintaining ETL jobs that includes extracting the data from Oracle transforming the data to XML format according to business requirements and then loading xml data with other columns into Oracle database.
• Scheduled various ETL Batch processes using AutoSys.

Confidential, Houston, TX

Technology: UNIX, DataStage 8.7, Oracle, SQL Server

Sr. DataStage Developer

Responsibilities:

• Defined and implemented ETL development standards and procedures.
• Developed Data Stage parallel jobs and sequences using data stage designer.
• Prepares the design document and Participated in source to Confidential mapping design document.
• Used QualityStage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
• Used QualityStage stages such as investigate, standardize, match and survive for data quality and data profiling issues.
• Prepares the Unit test Case document.
• Responsible for designing and maintaining ETL jobs that includes extracting the data from SAPBW/Oracle transforming the data according to business requirements and then loading the data into SQLServer database.

Confidential, Long Beach, CA

Technology: UNIX, SQL Server, SSIS

Sr. ETL Developer

Responsibilities:

• Performed as active, leading role in shaping and enhancing overall ETL architecture.
• Identified, recommend and implemented ETL process and architecture improvements.
• Involved in Data Requirement Analysis, Designed Star schema data mart to convert OLTP to OLAP model, development and of the conceptual data models and physical data models of the Medicaid
• Loading Members related data for various applications into the Enterprise Data Warehouse and MS SQL server is the goal of the project. This involved, pulling in data from various source systems like Flat Files, Oracle, DB2 and Sybase and loading the Confidential to EDW data warehouse.
• Created SSIS packages to extract, transform and load data.
• Worked with Provider, Claims, Membership, Member Risk, Products, Audit and Capitation modules under the HIPAA.
• Involved in the technical development delivery strategy packages that include technical design, development and testing phase.
• Scheduled various ETL Batch processes using Control M

Confidential, Seattle, WA

Technology: UNIX, DataStage 8.5, Oracle, Sybase

Sr. DataStage Developer

Responsibilities:

• Developed ETL architecture in accordance with business requirements.
• Provided proper resolutions for ETL related issues.
• Designed ETL process and prepare associate document
• Understand the requirement specifications, design parallel jobs and sequences using data stage designer.
• Parse the complex xml files in Data Stage which contains the member information.
• Prepare the discrepancy report using the reconciliation process.
• Developed Job Sequences, job activities, execute commands, user variable activity and implemented logics for job sequence loops, recovery and restart.
• Identified performance bottlenecks and suggested improvements.
• Prepares the Unit Test Case document and Operational document.
• Fixed the defects raised during the testing phase.

Confidential, San Antonio, TX

Technology: UNIX, DataStage 8.1, DB2, Oracle

Database & DataStage Architect

Responsibilities:

• Performed technical analysis and prepared recommended ETL design approach
• Develop ETL jobs using the Data Stage 8.1 as per the functional and technical specs provided by the client.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Extensively worked with Shared Containers for Re-using the Business functionality.
• Created Job Parameters and Environment variables to run the same job for different schemas.
• Involved in doing code reviews for all the jobs before moving to production.
• Used Director to monitor jobs, run and validate its components.
• Ensured faster data loads involved in the Performance Tuning of parallel jobs using Performance Statistics.

Confidential, NY

Technology: UNIX, DataStage 8.5, Netezza

Team Lead & ETL Developer

Responsibilities:

• Prepare reports and maintain records of work accomplishments and communication of work-related information to the supervisor.
• Report to the supervisor periodically on team and individual work accomplishments, problems, progress in tasks and work processes.
• Worked closely with data modeler and database administrator to understand the business process and participated in gathering of business requirements to build the data warehouse model
• Used partition key in Parallel Extender job for bulk loading of data and to get better performance
• Extensively used Korn Shell Scripts to trigger the DS jobs through a Master Sequencer
• Optimized Query Performance, Session Performance and Reliability.

Confidential, NY

Technology: UNIX, DataStage 7.5 / 8.1, Netezza

Team Lead & ETL Developer

Responsibilities:

• Migrating ETL jobs from Data Stage 7.5 to DataStage8.1 as per the functional and technical specs provided by the client.
• Worked with Data Stage Manager for importing metadata from repository, new job Categories & creating new data elements
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
• Create new projects in DataStage through Administrator, assigning proper and permissions to DataStage users, setting up the Environment variables to help with performance tuning.

Confidential, Dallas, TX

Technology: UNIX, Datastage 7.5

ETL Developer

Responsibilities:

• Actively participated in business meetings with the business users in order to gather the business requirements.
• Responsible for designing and maintaining ETL jobs that includes extracting the data from sequential files transforming the data according to business requirements and then loading the data into oracle database
• Worked on SQL complex queries for extracting data using tuning queries for better performance.
• Migrated jobs from development to QA to Production environments through Version Control Tool
• Created process flow diagrams using Microsoft VISIO.
• Developed job sequence and implemented restart ability using various checkpoints.
• Written Unix Shell Script for scheduling DataStage jobs, to handle Error Management and Audit Management.

Confidential, AZ

ETL Developer

Responsibilities:

• Extracting data from relational tables, flat file sources and loading to the staging area.
• Created jobs and analyzed scope of application, defining relationship within & between groups of data, star schema and more.
• Identified suitable dimensions and facts table for schema.
• Used Job Control routines and Transform functions in the process of designing the job.
• Scheduled the jobs via the Autosys.

Confidential, AZ

Technology: UNIX, Datastage 7.5, Putty, PL/SQL developerRole: ETL Developer

Responsibilities:

• Created Stage Variables and Constraints in Transformer to filter source data.
• Extensively used DataStage client tools - DataStage Designer, DataStage Director, DataStage Manager, and DataStage Administrator.
• Involved in Unit and System Testing
• Involved in the design and development of Data Warehouse.
• Worked closely with data modeler and database administrator to understand the business process of the data warehouse model.