SUMMARY:

• Having 14 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, 11.3, 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-Target 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.
• TEMPHas a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server
• Good noledge on IBM Unified Data Model for Health Care.
• 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 11.5/11.3/8.7/8.5/8.1/7.5 (Parallel Extender), SSIS, Informatica, Information Governance Catalog, Info Sphere Metadata Asset Manager, Information Analyzer

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

Data Modeling Tools: Erwin

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

Tools: SQL*Plus, Version Control

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, TFS, Git Hub

Reporting: OBIEE, POWER BI

WORK EXPERIENCE:

Confidential

Lead Developer

Responsibilities:

• Responsible for monitoring Datastage job development (included code reviews, concept discussions, error handling issues, etc ), analyzing datastage source conversion/bottleneck issues, and creating overall data flow process. Made several improvements to old standards and halped resolve many performance issues within both Datastage and the Databases used to extract and load data.
• Defined and implemented ETL development standards and procedures.
• Architect and design the whole ETL process from end to end.
• Jobs used all major components within datastage including transformer stages, lookup stages, join stages, modify stages, sequential files, datasets, CDC stages (change data capture) etc
• Prepares the Technical design document and Participated in source to target mapping design document.
• Performed Unit testing, Integration testing and User Acceptance testing for every code change and enhancements in development, QA, Preproduction and Production.
• Optimized the existing jobs for better performance
• Used SQL for data querying and database administration with Oracle database
• Mentor developers on proper usage of DataStage and best practices and standards.
• Scheduled various ETL Batch processes using Tivoli.
• Extensively worked co-coordinating with offshore team distributing the work, keep tracking development status and monitor day-to-day activities.
• Excellent teamwork, problem solving skills, flexible, self-direct person

Confidential, Louisville, KY

Lead Developer

Responsibilities:

• Understand the business processes, gather requirements and design parallel and sequence jobs using data stage designer.
• Understanding Data Modeling, relational and dimensional Modeling (Star and Snowflake dimensional data models).
• Jobs used all major components within data stage including transformer stages, lookup stages, join stages, modify stages, sequential files, datasets, CDC stages (change data capture) etc
• Prepares the Technical design document and Participated in source to target mapping design document.
• Monitor data stage jobs, run and validate its components using Data stage Director and provide production support.
• Scheduled various ETL Batch processes using $Universe.
• Design and develop ETL workflows and datasets in Alteryx for the BI reporting tool.
• Proficient in Alteryx ETL and analytical platform using either pre-existing modules or customizing applications to the current task and business rules.
• Translate business logic from one system (Excel, SQL, etc) into Alteryx in an accurate manner
• Used Alteryx to extract data from external sources and modify data to certain format as required in Excel, and created Alteryx packages to load csv files from source systems to database.
• Alteryx designer to develop data analysis prototype and used Map to visualize analytical reports
• Create Information Analyzer projects, adding data sources to projects, importing the metadata of the tables to the IA Projects and Involve in profiling source data.
• Import Metadata Assets such as HDFS Bridge, ODBC Connector and Oracle Connector to Staging area in Info Sphere Metadata Asset Manager. Analyze, Preview and Publish assets to metadata repository to be available in Information Governance Catalog.
• Perform lineage analysis to understand where data comes from or goes to by using shared table information, job design information, or operational metadata from job runs in Information Governance Catalog.

Confidential, Phoenix, AZ

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 target 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 tan 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 ESP.
• Analyzed reporting requirement and developed Dashboards and reports in OBIEE.
• Configured and created repository usingOBIEE Administration Tool.
• Involved in installation and configuration of MapReduce, HIVE and the HDFS
• Importing data fromdatabase toHiveQL
• Develop, validate and maintainHiveQLqueries

Confidential, Houston, TX

Data Stage Architect

Responsibilities:

• Developed Data Stage parallel jobs and sequences using data stage designer.
• Prepares the Technical design document and Participated in source to target 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 tan loading xml data with other columns into Oracle database.
• Scheduled various ETL Batch processes using AutoSys.

Confidential, Houston, TX

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 target 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 tan loading the data into SQLServer database.

Confidential, Long Beach, CA

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. dis involved, pulling in data from various source systems like Flat Files, Oracle, DB2 and Sybase and loading the target to EDW data warehouse.
• Introduced to IBM Unified Data Model for Health Care.
• Involved in BI/DW implementation using IBM UDMH.
• Worked with Provider, Claims,, 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.

Confidential, Seattle, WA

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

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

Team Lead & ETL Developer

Responsibilities:

• Prepare reports and maintain records of work s and communication of work-related information to the supervisor.
• Report to the supervisor periodically on team and individual work s, 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

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 halp with performance tuning.

Confidential, Dallas, TX

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 tan 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

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.

Confidential, AZ

ETL Developer

Responsibilities:

• Responsible for finding the data type mismatch between the source and the target.
• Created Shared Containers for reusability.
• Suggested various changes in the physical model to support the business requirements
• Performed Unit Testing to check the validity of the data at each stage.
• Used DataStage Director to debug the jobs and to view the error log to check for errors.
• Implemented best practices in the development environment (code standards, code migration)

Confidential, CA

Application Developer

Responsibilities:

• Conducted user interviews and requirements analysis and documented use cases
• Developed Winforms using C#.NET
• Responsible for the design and the development of the exception framework in the application
• Responsible for creation of CLR User Defined Functions in SQL Server 2005.
• Writing Cryptographic functions
• Responsible for creation of stored procedures and views in SQL Server used in the data access layer of the application
• Developed reports using Crystal Reports.