EXPERIENCE SUMMARY:

• Over 14 years of IT experience in Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server, Object Oriented Programming and Legacy applications using Data Modeling, Data Analysis, ETL (Extraction, Transformation, Loading), and Data Integration through Big Data/Hadoop Architecture and Data Visualization using Tableau
• 12+ years of extensive experience in System Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP), Data marts and Business Intelligence applications using ETL Tool DataStage 11.3/9.1/8.7/8.5 /8.1/8.0.1 /7.5/7.1 R1/7.0/6.0XE/5.2
• Over 8 and half years of experience in the new version of ETL Data warehousing tool, IBM InfoSphere/WebSphere DataStage 11.3/9.1/8.7/8.5 /8.1/8.0.1
• Over 4 years of experience in QualityStage 9.1/8.7/8.5/8.1/8.0.1/7.5 for Data Standardization, Verification and Data Cleansing.
• Over 2 years of experience in Information Analyzer 8.7/8.5 for Data Profiling, Column Analysis, Primary Key/Foreign Key Analysis, Base line reports and Cross Domain Analysis
• Over 1 and half years of experience on Big Data Architecture to integrate humongous volume of data using Cloudera Hadoop and IBM Big Data File Stage.
• Over 2 and half years of experience on Data Visualization tool Tableau 9.1/8.3/8.1.5 to create and present reports more intuitively in the form of Bar charts, Pictures, Gantt charts and Histograms instead of reading numbers in rows and columns
• Over 14 years of exceptional background in Design, Development, Testing and Maintaining applications in Database/Data warehousing/Client/Server and Legacy Systems for Manufacturing/Chemical Distribution, Health Insurance, Financial, Entertainment (Movie theatres), Health - Care Provider/Hospital and Telecom Services provider industries
• Good knowledge in Star, Snowflake schemas, Multi-Dimensional modeling and Fact/Dimension tables design used to build Data warehouse, Data marts and Operational Data Store (ODS).
• Experience in IBM InfoSphere ETL jobs migration/conversion projects from Windows operating system to UNIX/LINUX operating system
• Strong knowledge in Data Extraction, Cleansing, Transformation, Integration and Loading (ETL methodology) processes in corporate wide Data warehouse using IBM DataStage/QualityStage and UNIX Shell Scripting.
• Experience with IBM InfoSphere DataStage Parallel Extender for parallel processing to improve job performance while working with bulk data sources and data loads.
• Extensive experience in the integration of various Relational Database systems like Oracle, MS SQL Server, DB2 UDB, Netezza, Teradata, Sybase, Siebel and MS Access; and other Data Sources like XML files, CSV files, Flat files and Complex flat files into Staging area/Data warehouse/Data marts using several stages in IBM InfoSphere DataStage.
• Experience in Data extraction from several Legacy systems like SAP R/3, Mainframe Systems, WebService (Microsoft BizTalk), Netezza Enterprise/Netezza Performance Server (NPS) and Siebel CRM Systems.
• Worked on the migration of DataStage Projects and Jobs from DataStage version 7.5 to 8.0.1; 8.0.1 to 8.1; 8.1 to 8.5; 8.5 to 8.7; 8.7 to 9.1 and 9.1 to 11.3
• Proficient in Data warehousing techniques for Data cleansing, Slowly Changing Dimension (Type I, II, III, and IV) process, Surrogate Key assignment and Change Data Capture phenomenon.
• Expertise in working highly scalable parallel processing infrastructure using InfoSphere DataStage Parallel Extender (alias DataStage - PX).
• Experience in generating the Pattern report and Token report to identify Data Patterns and Inconsistencies in Source data using QualityStage.
• Effectively worked on building Customized rule sets for Standardizing Source data using QualityStage.
• Implemented a flow to integrate the DataStage and QualityStage jobs to ensure that they run in batches by using Sequencer Job and UNIX Shell scripting.
• Expertise on creating Information Analyzer Projects and Data rules at command line interface.
• Extensively worked on Data rule exception reports to identify Data and Format anomalies using Information Analyzer.
• Highly proficient in Data analysis, Data warehousing, Data Integration and Data Migration.
• Exceptional experience in Debugging, Troubleshooting, Monitoring, Optimization, Performance Tuning and Backup/Recovery process of the ETL processes using InfoSphere DataStage.
• Excellent Software Engineering background, well verse with SDLC, worked with various traditional to agile software development methodologies.
• Expertise on all phases of Data warehousing development life cycle from Gathering Business requirements to Designing, Coding, Unit testing, Implementing, Migrating and Production support.
• Experience in scheduling ETL jobs and UNIX shell scripts using scheduler tools like Automic, UC4, Appworx, Control-M and Autosys.
• Prepared Unit test case documents to ensure thorough testing while developing ETL jobs in Development environment/instance.
• Programming experience using SQL, Core Java and UNIX Shell programming/scripting.
• Excellent communication, interpersonal, analytical and problem solving skills. Strong ability to perform as part of a team and independently. Flexibility and passion to learn new technologies towards company’s success.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere DataStage and QualityStage/Information Analyzer 11.3/9.1/8.7/8.5 IBM WebSphere DataStage 8.1/8.0.1, Ascential DataStage 7.5/7.1r1/7.0/6.0XE/5.2 QualityStage 9.1/8.7/8.5/8.1/8.0.1/7.5

Big Data Integration: Big Data and Hadoop Architecture, HIVE, PIG, MapReduce, Oozie, ZooKeeper.

Reporting Tools: Tableau 9.1/8.3/8.1, OBIEE 11G R1/10G R3, Business Objects Enterprise XI R2/6.5/5.1.4, Cognos 8.3, Siebel Analytics 7.8.3, SQL Server Reporting Services (SSRS) 2012/2008/2005.

Data Modeling: ER Studio Data Architect 9.0/8.5/8.0.2/7.1 and ERwin 7.2/7.1/4.1/3.5.

Languages: C/C++, SQL, Shell Scripting and Core Java.

Operating Systems: IBM AIX, HP-UX, LINUX, Windows NT/ 95/98/2000/2003/ XP/7, UNIX and MS DOS

Databases (RDBMS): DB 2 10.1/9.7/9.1/7.1/6.1 , Oracle 12c/11g/10g/9i/8i/7.0, Teradata 7.0/8.0/9.1/12/13.10 Netezza 6.0, SQL Server 2012/2008/2005/2000/7.0/6.5 , Sybase (Adaptive Server Enterprise) ASE 12.5.2, Siebel 7.7/7.8/8.1 and MS Access.

Database Tools: Aqua Data Studio 10.0/7.5, Microsoft SQL Server Management Studio, TOADSQL Developer, Developer 2000, SQL Loader, WINSQL and SQL Navigator.

Legacy Systems: SAP R/3, Mainframe Systems, Siebel CRM Systems, Oracle Siebel 8.1, Microsoft BizTalk-WebService, Netezza Enterprise 4.0.3

Others: Automic Scheduler, Control-M, UC4, TFS, Microsoft Visual Studio 2012/2010, AppworxAutosys, MS Visio 2010/2007, MS Office and Microsoft Visual Source Safe.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Experience in IBM InfoSphere ETL jobs migration/conversion projects from Windows operating system to UNIX/LINUX operating system
• Strong knowledge in Data Extraction, Cleansing, Transformation, Integration and Loading (ETL methodology) processes in corporate wide Data warehouse using IBM DataStage/QualityStage and UNIX Shell Scripting.
• Experience with IBM InfoSphere DataStage Parallel Extender for parallel processing to improve job performance while working with bulk data sources and data loads.
• Extensive experience in the integration of various Relational Database systems like Oracle, MS SQL Server, DB2 UDB, Netezza, Teradata, Sybase, Siebel and MS Access; and other Data Sources like XML files, CSV files, Flat files and Complex flat files into Staging area/Data warehouse/Data marts using several stages in IBM InfoSphere DataStage.
• Experience in Data extraction from several Legacy systems like SAP R/3, Mainframe Systems, WebService (Microsoft BizTalk), Netezza Enterprise/Netezza Performance Server (NPS) and Siebel CRM Systems.
• Worked on the migration of DataStage Projects and Jobs from DataStage version 7.5 to 8.0.1; 8.0.1 to 8.1; 8.1 to 8.5; 8.5 to 8.7; 8.7 to 9.1 and 9.1 to 11.3
• Proficient in Data warehousing techniques for Data cleansing, Slowly Changing Dimension (Type I, II, III, and IV) process, Surrogate Key assignment and Change Data Capture phenomenon.
• Expertise in working highly scalable parallel processing infrastructure using InfoSphere DataStage Parallel Extender (alias DataStage - PX).
• Experience in generating the Pattern report and Token report to identify Data Patterns and Inconsistencies in Source data using QualityStage.
• Effectively worked on building Customized rule sets for Standardizing Source data using QualityStage.
• Implemented a flow to integrate the DataStage and QualityStage jobs to ensure that they run in batches by using Sequencer Job and UNIX Shell scripting.
• Expertise on creating Information Analyzer Projects and Data rules at command line interface.
• Extensively worked on Data rule exception reports to identify Data and Format anomalies using Information Analyzer.
• Highly proficient in Data analysis, Data warehousing, Data Integration and Data Migration.
• Exceptional experience in Debugging, Troubleshooting, Monitoring, Optimization, Performance Tuning and Backup/Recovery process of the ETL processes using InfoSphere DataStage.
• Excellent Software Engineering background, well verse with SDLC, worked with various traditional to agile software development methodologies.
• Expertise on all phases of Data warehousing development life cycle from Gathering Business requirements to Designing, Coding, Unit testing, Implementing, Migrating and Production support.
• Experience in scheduling ETL jobs and UNIX shell scripts using scheduler tools like Automic, UC4, Appworx, Control-M and Autosys.
• Prepared Unit test case documents to ensure thorough testing while developing ETL jobs in Development environment/instance.
• Programming experience using SQL, Core Java and UNIX Shell programming/scripting.