SUMMARY

• Technical expertise and Leadership qualities with over 20 years of overall experience in Information Technology.
• Involved in all phases of SDLC with recent emphasis on design, development and deployment of Data Integration (Traditional & Big Data) / Migration / DWH solutions to cater to Business reporting & Analytics. Successfully delivered complex Data Warehousing / Integration / Migration projects consistent with Corporate Information Factory model under aggressive schedules.
• Worked on design & development activities for Data Profiling, Quality, Transformation, Migration, Integration, Analytics and Information Governance with New & emerging technologies and Agile methodologies. Successfully lead geographically, culturally and linguistically diverse onsite, onshore & offshore teams from USA, Brazil, India, China, Philippines & Austria for development and deployment of many applications.

AREAS OF EXPERTISE:

• Data Integration, Migration & DWH using Datastage
• Big Data Integration (HDFS, Hive)
• Analytics (SPSS, Tableau)
• Agile Methodologies (Planning, Design, Development thru' Deployment)

TECHNICAL SKILLS

ETL: IBM Datastage (IIS) 8.5 - 11.5, SAP IDOC, Web Services & MQ

Analytics / Reporting: Tableau, SPSS Statistics, Brio

Databases: DB2 UDB, Oracle, Netezza, SQL Server, MySQL, Hadoop (HDFS / Hive)

Scripting: SQL, Unix shell Scripts

Database Clients: IBM Data Architect, Toad, SOL Developer, ERwin Data Modeler

Operating Systems: AIX, RHEL, Win NT (2003 - 2012), Windows Terminal Server

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Lead a team of 10 offshore ETL developers, and OA team consisting of 5 testers
• Coordinated with Data Architect, DBA & Cognos reporting team on Data Models
• Involved in Release/Iteration planning, Sizing activities during development thru' prod deployment
• Defects tracking & Team status reporting in Scrum & Weekly status calls
• Experience in SDLC for Integration, Migration/Conversion & DWH using IBM InfoSphere DataStage 11.x
• IBM Datastage specific configuration, packaging, version control, migration and deployment experience
• Pulling/uploading data via Web Services (REST/SOAP APIs), MO & XML
• Integrating HDFS, Hive, Sqoop using Datastage 11.x
• Good Analytical and problem solving skillsExcellent understanding of ETL processes, Best Practices & Change management processes
• Very good understanding of IT infrastructure and other technologies
• Strong communication & organizational skills and ability to deal with business users
• Proficiency in ANSI standard SOL statements, creating views, stored procedures
• Excellent skills in performance tuning of ETL jobs and SOLs
• Debugging and correcting historical and incremental ETL data loads and develop a good recovery procedure for exceptions.
• Excellent knowledge on Project management methodologies like Agile/SCRUM

Environment: IIS Datastage 8.5 - 11.5, DB2 UDB v10, Netezza, Tableau, SPSS Statistics, HDFS

Confidential

ETL Consultant

Responsibilities:

• Confidential America, LTD, a wholly owned subsidiary of Tokyo-based Confidential, LTD is a $650m company headquartered in White Plains, NY. Their major product lines are cast aluminum wheels and other automotive components, magnetic products and electronic materials. The Project 1110 is a transformational initiative whose initial foundation was the implementation of the SAP Express Solution for Fabric & Assembly. The transformation initiative has taken on a more traditional SAP implementation approach.
• Lead a team of 5 developers to migrate all Key Master & Transactional data from Hitachi's legacy systems into a brand new SAP system. Data from all the legacy sources were transformed and converged into SAP staging area and LSMW files created for SAP load using Infosphere Information Server (Datastage) v 8.5

Environment: SAP R/3, Datastage / Information Server 8.5, DB2 UDB 8, AIX, MS SOL Server

Confidential

Asst Manager (Systems)

Responsibilities:

• Migration of key operational data from IBM's Legacy & SAP systems into Confidential 's SAP system.
• Around 600 data sources related to the target business objects were in scope. Independently migrated Materials Master data from 2 SAP & 2 non SAP systems. Over 20 SAP tables & 20 Legacy files were migrated. Data from all 40 sources were transformed and converged into staging Canonical tables using Datastage EE 7.5.x. Data cleansing, standardization & Harmonization activities were performed on the canonical tables to produce unique output rows.
• Datastage EE 7.5.x & TX jobs were developed to generate and load IDOCs into target SAP system using SAP IDOC Load plug-in stage.

Environment: Datastage EE 7.5.2 (with SAP IDOC / ABAP Plugin), Datastage TX, SAP R/3, UDB 8, AIX 5.3

Confidential

Responsibilities:

• Integrated the TrueComp (Callidus product) with Enterprise Data Warehouse for near real time transaction processing using Datastage EE 7.5.2. Designed and developed multiple interfaces to feed data in both directions
• Requirements gathering, Sizing / Estimation for Data warehousing & BI initiatives. Lead a team of ETL developers for developing functional design, technical design, data mapping, data translation & transformation rules.
• Coordinated with DBA in physical Data Modeling. Designed Datastage EE 7.5.x jobs, test cases, test scripts, Unix shell scripts to integrate the various source databases and external data into Data Warehouse & Data marts. Identified ETL job issues, did RCA and performance tuning. Reduced the ETL processing time by 50% by introducing delta logic in all the existing ETL jobs to capture only the changed source data.

Environment: IBM DataStage 7.5.2 (Server & Parallel), IBM DB2/UDB, AIX

Confidential

Responsibilities:

• Engaged as an integration partner for design, development and implementation of interfaces between RMS (Retek product), legacy applications and Enterprise Data Warehouse. Analyzed the functional design and developed ETL technical design, test Cases, test scripts. Developed reusable Unix shell scripts and Datastage (EE 7.5.x) containers. Analyzed complex SOLs used in RMS and in the interfaces and did performance tuning of ETL (Datastage EE 7.5.x) jobs. Monitored ETL jobs, analyzed and resolved data/job issues. Migrated the jobs and related components into production environment using the version control and change management procedures.
• Developed Staffing model, Cost & Margin analysis during negotiation phase of this outsourcing Project. Contributed major share in project planning (cost, schedule & resources) and coordinated the entire transition effort. Developed onsite-offshore processes & procedures and ensured a smooth transition of support, development / enhancement work to offshore. Lead a team of consultants for performing a detailed HIPAA TCI technical analysis across four business units. Developed strategies and proposed technical solutions for HIPAA compliance.