SUMMARY

• Over 15 years of comprehensive and in - depth experience in IT industry with over 13 years of experience in ETL development and worked with tools like IBM DataStage, SAP Business Objects Data Services (BODS), SSIS and Informatica PowerCenter
• In - depth understanding of Snowflake cloud technology.
• Experience in data warehousing architecture, data marts, data integration, and data modelling.
• Experience in Requirement Analysis, Software Development, Enhancement, Testing, Implementation and Production support activities across projects.
• Strong experience in Development and Implementation of various Data Warehouses & Data marts with ETL Tools Like DataStage, SAP BODS, SSIS and Informatica
• Experience working with Big Data eco-system including tools such as Hadoop File System (HDFS), Yarn, Hive, Spark and performed Importing and exporting data into HDFS and Hive using DataStage BigIntegrate
• Good experience on Onsite and offshore model and Handling big ETL teams.
• Experienced in executing projects in Waterfall and Agile software development methodologies.
• Involved in Installation, Configuration, Tuning and Administration of IBM Datastage, SAP Data Services and SAP Information Steward Applications.
• Experience in designing Star Schema, Snow flake Schema, Fact and Dimensional Tables, Physical and Logical Data Modelling using E Rwin Data Modeler.
• Experience on OLAP like SAP Business Objects 4.0/XI 3.1, Crystal Reports 2008.
• Experience working with different databases such as Oracle, SQL Server, DB2 UDB, Teradata, Netezza, Informix, Greenplum and MS Access.
• Experience working on multiple platforms such as Windows, UNIX, LINUX and VMware.
• Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team and high compliance to new environment and tools.

TECHNICAL SKILLS

Cloud Technology: Snowflake

Technology : Data Warehousing, ETL, Data Integration, Data Processing

Big Data Ecosystem: Hadoop, HDFS, Hive

ETL Tools: IBM Data Stage 11.5/9.1/8.X/7.X, IBM Quality Stage, Informatica PowerCenter, SAP Data Services XI 4.2/3.2/3.1, SSIS

Data Profiling: SAP Information Steward 4.2, SAP BO Data Insight XI 3.0

Data Modelling: ERwin 7/4.5/4.0/3.5/3.0

Reporting Tools: SAP Business Objects 4.0/XI 3.1, Crystal Reports 2008

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2012/2008, UDB DB2 9.1/8.1, MS Access, Teradata, Pivotal Greenplum 4.2, Netezza and Informix

Operating Systems: Windows Server, UNIX, LINUX

Programming: C, C++, JAVA, UNIX Shell Scripting, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Senior Datastage Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Analyze requirements, identify data sources, business rules, and transformation logic.
• Preparing technical design documents, unit test cases translates business requirements into application architecture & participates in SDLC (Software Development Life Cycle)
• Preparing the source to target data mapping for the ETL process
• Work closely with project Business Analyst, Data Modeler and Tech Lead to ensure that the end to end designs meet the business and data requirements
• Involved in the design & code reviews of ETL’s and implemented best practices in Datastage jobs.
• Design and develop ETLs for extracting, cleansing, transforming, integrating, and loading data into target
• Responsible for the development, implementation and maintenance of highly efficient and scalable ETL processes
• Responsible for assisting and resolving design issues and defects
• Designed and developed DataStage jobs, job sequences to implement the business requirements and design specifications.
• Provided technical assistance and support to IT analysts and business community.

Environment: IBM Data Stage 11.5, Netezza, Oracle 11g, DB2, UNIX, JIRA, BMC Control-M

Confidential, NJ

Senior Datastage Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Analyzed the quality of data ingested into Data Lake and other authoritative data sources.
• Responsible for loading data from multiple sources directly into HDFS.
• Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way
• Responsible for the development, implementation and maintenance of highly efficient and scalable ETL processes
• Responsible for assisting and resolving design issues and defects
• Designed and developed DataStage jobs, job sequences and Shared Containers to implement the business requirements and design specifications.
• Designed and developed ETLs for extracting, cleansing, transforming, integrating, and loading data into target.
• Provided technical assistance and support to IT analysts and business community.

Environment: IBM Data Stage 11.5, Apache Hadoop (Horton works), HDFS, Hive, Kafka, Spark, Salesforce, Oracle 11g, UNIX

Confidential, Houston, TX

Senior Datastage Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Involved in the design of EDW architecture, code reviews of Datastage jobs and implemented best practices in Datastage jobs
• Designed and developed Datastage jobs, job sequences and Shared Containers to implement the business requirements and design specifications.
• Designed and developed ETLs for extracting, cleansing, transforming, integrating, and loading data into target.
• Involved in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Involved in testing the migrated code.
• Provided technical assistance and support to IT analysts and business community.
• Co-ordinated and lead the offshore team for ETL development works.

Environment: IBM Data Stage 11.5/8.7, Informatica, Erwin r7.1, Teradata, PL/SQL, Oracle 11g, MS SQL Server 2012, MS Access 2013, Control-M, Windows Server 2012, UNIX (AIX 6.3)

Confidential, Edison, NJ

Senior Data warehouse Analyst

Responsibilities:

• Involved in the design of EDW architecture, code reviews of Datastage jobs and implemented best practices in Datastage jobs
• Designed and developed Datastage jobs, job sequences and Shared Containers to implement the business requirements and design specifications.
• Prepared the Technical Design Documents and Lower level Design documents for the technical specs.
• Involved in Business Process Reengineering in Health Care Sector with prime focus on Membership, claims adjudication, migration, provider and eligibility for Medicaid and Medicare programs.
• Designed and developed ETLs for extracting, cleansing, transforming, integrating, and loading data into target.
• Provided technical assistance and support to IT analysts and business community.

Environment: IBM Data Stage 9.1, SSIS 2010, Erwin r7.1, Greenplum, Gemfire XD, PL/SQL, Oracle 11g, MS SQL Server 2012/2010, Facets, Windows Server 2012/2010, UNIX (AIX 6.3)