PROFESSIONAL SUMMARY:

• Over 12 years of experience in design and implementation of Data Warehouse/Data Marts using IBM Info Sphere DataStage and Quality Stage versions 9.1/8.7/8.1/7. x.
• Extensive experience in Designing and developing ETL processes to extract, transform and load data from various source (and legacy) systems into Data Warehouse and Data Marts using IBM InfoSphere DataStage and Quality Stage.
• Good experience with Hadoop Technologies like HDFS, Sqoop, Flume, HBase, Hive, Kafka, Spark with Scala, Ambari, NiFi.
• Involved in analysis, design, development, testing and deployment of jobs from heterogeneous source systems to teh warehouse according to teh end user requirements.
• Strong noledge of Data Warehouse Architecture and Designing Star Schema, Snowflake schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin.
• Understanding teh Business requirements by directly working with Business Analysts.
• Working with Business teams in creating mapping documents.
• Building Technical Design Documents for Development team based on mapping documents.
• Designed Parallel jobs using Stages like Transformer, Lookup, Join, Merge, Remove Duplicates, Filter, Pivot, Difference, Change Capture, Surrogate Key Generator, Complex Flat File, Sort, Dataset, Modify, Aggregator, Funnel, XML Stages, ISD Input/Output, Web Services Stages.
• Worked with different Quality Stages like Investigate, Standardize, Survive stages.
• Experience in integration of various data sources like DB2, Oracle, Salesforce, Teradata, SQL Server, XML file, Complex Flat Files and Flat files.
• Designed Server jobs using Stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experience in troubleshooting DataStage Jobs, performance of long running jobs and addressing production incidents with in SLAs.
• Excellent noledge in understading data dependencies using Metadata stored in teh Repository.
• Highly Motivated & Team oriented Analyst with excellent interpersonal, collaborative, diplomatic, and documenting skills.
• Worked closely and TEMPeffectively with all levels of project management and managing teh DEV and QA teams to meet project deadlines.
• Good Experience in writing SQL and PL/SQL queries.
• Very Strong RDBMS experience with Oracle, DB2 and Microsoft SQL Server.
• Experience in writing UNIX Shell scripts.

TECHNICAL SKILLS:

Data Warehousing/ETL Tools: IBM WebSphere DataStage and Quality Stage 9.1,8.x/7.x, SSIS, ODI, IBM Change Data Capture

Hadoop Tools: HDFS, Sqoop, Hive, HBase, Spark with Scala, Kafka

Data Modeling &Tools: Star - Schema, Snowflakes, FACT and Dimension Tables, Erwin, Microsoft Visio

CRM Tools: Sales Force

Databases: Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008, DB2 (LUW) 10.5/9.7, DB2 z/OS, UDB DB2, MS Access 7.0

Languages: C/C++, Java, Scala, Unix Shell scripting, XML, SQL, PL/SQL

Scheduling Tools: ASG Zena, Zeke

Reporting Tools: Micro Strategy

Utility Tools: MS Project, Data Studio, SQL Developer, QMF 10, Toad-9.1, SQL*Loader, DB2 Load Utility, IBM Rational Rose Clear Case& Clear Quest, SVN, IBM Fast Track, Environment Sun Solaris IBM AIX 5.3/5.2/4.2, Windows 2008, Win 7/XP

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

IS Technical Specialist /Tech Lead/Designer

Responsibilities:

• Worked directly with Project Managers, Architects, and Data Modelers of different systems across bank to understand teh business process and functional requirements for integrating teh source systems data with HNBs EDW system.
• Analyzed teh source data using quality Stage stages to understand quality of teh source systems data before integrating teh system data with EDW.
• Developed both parallel jobs and server jobs using IBM InfoSphere DataStage ETL tool.
• Designed and developed jobs to extract/load data to multiple sources like Sales force, IBM FileNet, Web Service applications, mainframe systems, DB2 (z/OS and LUW), Oracle, SQL Server, databases for building Data Warehouse.
• Created Data Stage jobs as Web Services using IBM Information Server Console
• Worked on migrating IBM DataStage ETL jobs between DEV/QA/PROD Data Warehouse environments using InfoSphere Server Manager and SVN for maintain versions.
• Developed and supported best practices and standards for data integration using ETL tool IBM InfoSphere DataStage and Quality Stage.
• Involved in teh testing process of migrating teh DataStage jobs from DataStage 8.1 to IBM DataStage 8.7 and IBM DataStage 8.7 to IBM DataStage 9.1.
• Involved in Unit testing, System Integration and Testing) and U.A.T (User Acceptance Testing).
• Enhanced teh existing DataStage jobs to improve teh performance and to resolve teh existing issues with teh job.
• Created jobs in Zena scheduler for scheduling Data Stage jobs in prod environment.
• Mentoring on site developers in using ETL tools for data integration best practices and standards.
• Performed design and code reviews for ETL jobs developed using InfoSphere DataStage to ensure best practices and standards in Data Warehouse.
• Worked on various Hadoop tools/frameworks like HDFS, Sqoop, Flume, Hive, HBase, Kafka, Spark with Scala, Ambari, NiFi.
• Created scripts to load data to HDFS and HIVE using sqoop.
• Lead teh project status meetings and documented teh meeting notes for Project Management.
• Worked with IBM support to fix various bugs by applying teh patches in teh DataStage Client machines.
• Extensively worked in bug fixing with various issues during Integration and User Acceptance Testing and worked for on call support to provide immediate fixes.

Environment: IBM Information Server Web sphere DataStage and Quality Stage 9.1/8.7,8.1, DB2 LUW, DB2 Z/OS, Oracle, Flat Files, AIX, Data Studio, SQL Developer, SQL Server, SSIS, Micro Strategy, IBM Master Data Management (MDM), IBM CDD, HDFS, Sqoop, Flume, Hive, HBase, Kafka, Spark with Scala, Ambari, NiFi.

Confidential, Gaithersburg, MD

Sr. DataStage Consultant

Responsibilities:

• Analyzed teh given source and target table structures to create Surrogate Keys for required dimensions as per Type 1 and Type 2 scenarios.
• Designed jobs which populated teh tables using column generator, surrogate key, join, Oracle enterprise stage and Peek Stage for debugging purpose.
• Extracted data from complex flat files and loading data into Oracle.
• Creation of Shared containers so dat it can be used by other jobs in teh project.
• Exporting teh jobs to Testing Environment from Development and then to Production.
• Worked on long running jobs to improve teh peformance of teh jobs.
• Developed DataStage job sequences to control teh data slow of parallel jobs using stage like User Activity Variables, Job Activity, Wait for File stages.
• Extensively used IBM Information Server Director for scheduling teh job to run in batch, and notifitying production support for troubleshooting from LOG files
• Exported and imported teh Data stage jobs between teh production and teh development servers
• Involved in release process, which include exporting jobs, preparing release notes, uploading teh code to Rational Clear case, importing jobs between environments.

Environment: IBM Information Server WebSphere DataStage 8.01/EE 7.5.2 (Ascential DataStage), Parallel Extender, Oracle 10g/11i, Toad 9.1, Flat Files, XML, SQL, PL/SQL, Rational Clear Case &Clear Quest, Red Hat Linus 5.

Confidential

DataStage Consultant

Responsibilities:

• Worked on troubleshooting teh existing production jobs and redesigned teh jobs to improve teh performance.
• Analyzed teh given source and target table structures to create Surrogate Key for required dimensions as per Type 1 and Type 2 scenarios.
• Worked with various Stages, which includes Sequential File, Dataset, XML Input, XML Output, Copy, Lookup, Join, Transformer, Sort, Aggregator, Remove Duplicate, Filter, Column Export, SCD, CDC, Funnel, Oracle OCI, and RDBMS Stages.
• Exporting teh jobs to Testing Environment from Development and then to Production.
• Worked on HR Web focus reports.
• Extensively worked in bug fixing with various issues during Integration and User Acceptance Testing.
• Created Prod Support documents with business logic from Data stage jobs for Prod Support Team.

Environment: Ascential DataStage 7.5.2, Web Focus, Oracle 10g/11i, Toad 9.1, Flat Files, SQL, Red Hat Linus 5.

Confidential

ETL Developer/Tester

Responsibilities:

• Developed jobs which include Sequential File, Dataset, XML Input, XML Output, Copy, Lookup, Join, Transformer, Sort, Aggregator, Remove Duplicate, Filter, Column Export, SCD, CDC, Funnel, Oracle OCI, and RDBMS Stages.
• Created jobs which populated teh tables using column generator, surrogate key, join, Oracle enterprise stage and Peek Stage for debugging and testing purpose.
• Created Shared containers for reusing teh logic in other modules of teh project.
• Exporting teh jobs to Testing Environment from Development and then to Production.
• Using teh stages like Change-Capture, Modify, Look-up, Remove Duplicate, filter, Sort to modify existing jobs for improving teh performance of long running jobs.
• Used transformer stage for converting/transforming data to load different systems.
• Assisted QA team in testing of developed jobs and documented different test cases for different source systems
• Worked with QA team in resolving teh defects from Quality Center.
• Converting teh existing server jobs to parallel jobs.
• Created server shared container jobs to implement teh orabulk stage logic in server.
• Created teh Repository by importing metadata.
• Stages such as Lookup, remove duplicates, Funnel, Join, Aggregator, filter, Sorter stage, change capture were used in Parallel jobs.
• Performed unit testing and bug fixing.
• Preparing Unit Test Case Documents.
• Running and monitor teh jobs in Director
• Viewing log for teh jobs and cleaning up teh resources using Director

Environment: DataStage 7.0, Windows 2000, Windows NT 4.0, Sun Solaris, SQL Server 2000, Oracle 8i