Profile

• Data warehousing ETL Developer with 4 years of experience in application design, development and maintenance in client/server environmentencompassing highly efficient skill set, variety of roles and proficiency in technical knowledge
• Excellent team leader and able to involve people to execute the project successfully.

Skills Summary

• Solid understanding of the Data warehouse development life cycle.
• Extensively worked on DataStage V8x Enterprise Edition & designed solutions using power of parallel processing for Data extraction, Data integration and Loading processes
• Quality experience in Requirement gathering, effort estimation for ETL developments, source data analysis, Impact analysis, designing, development, defect analysis, implementation & documentation of data warehousing and business intelligence solutions.
• Implemented Data warehousing concepts and dimension modeling, Star/Snow Flake schemas, Inmon and Kimball methodology, Experienced with ETL and Mapping,
• Involved in the Performance Tuning of the Data Stage Parallel Jobs
• Worked on testing of Datastage jobs in integration, system and User acceptance testing phases.
• Worked on DB2 database administration basic tasks.
• Handled DataStage V8.0 administration tasks such as unlocking of the Job/Project, Import/Export of the Jobs/Project across the environments, stop/start of Datastage server, cleaning of job log/resources & user creation.
• Developed UNIX shell Scripts (AIX- ksh) which performed automation & scheduling of the DataStage jobs.
• Hands on knowledge on DWBI Technologies s like SAS DI, SSRS, SSAS, Cognos, QualityStage and Informatica.
• Professional Communication and Presentation skills

Certification

• IBM Certified Solution Developer : InfoSphere DataStage v8.0
• IBM Cognos 8 BI Author

Professional Experience

August 08 - Till date Senior System Engineer IBM, Pune

Project 1

Jan-Oct 2009 Associate System Engineer Project: Confidential

• Handled Multiple roles and responsibilities: Designer, Developer, feasibility team member, Quality representative in the MIS(Management Information system) team of TFL project, to deliver a data warehousing solution for traffic congestion control on the streets of London.
• Designer: Have designed efficient RCP (Run-time Column Propagation) solution for implementing SCD (Slowly Changing dimensions) type-2 warehouse.
• Developer: implemented and deployed the solution effectively in production environment.
• Saved 50% efforts in job development by creating 200, almost ready to be used, datastage jobs using scripting and exported datastage job.
• Individually developed UNIX shell scripts to schedule the Datastage jobs through external scheduler co-coordinating two teams without minimal supervision.
• Worked on system, user acceptance testing for both Datastage as well as UNIX scripts.
• Environment: ETL tool-Datastage 8.01, DB2, UNIX AIX, ClearCase.

Achievements:
Received a Special Thanks Award from Onsite team for designing and developing a customized efficient solution as per TFL business needs. Received another Thanks award from Team lead for working as a SPOC for Unix script development for two teams. I was recommended for the next project by PAL (Practice Area Lead), Public sector considering the work done in TFL project.

Project 2

Nov 2009-May 2010 System Engineer Project: Confidential

• This was IBM COE (Center of Excellence) Healthcare project responsible for building an asset.
• Key project implementations as team member
• I was involved in developing high performance, optimum and efficient asset.
• I have worked on Performance Tuning and code enhancements to achieve performance target.
• Developed UNIX shell scripts to schedule and run the Datastage jobs and its logging process.
• Environment: Datastage 8.01-ETL tool, DB2, Teradata, UNIX.

Project 3

Nov 2009-Till Date SSE & Team Lead Project: Confidential

• Handled multiple roles and responsibilities: Developer, Analysis team member, Unix shell scripting developer as well as the application support resource for TFL AMS project, to support and enhance the data warehousing solution developed in Project 1.
• Developer: - Implemented and deployed solutions for the new requirements effectively in production environment.
• Incident Analyst: root cause analysis for problems in the Production environment, resolution of the issues and their fixes.
• Change Analyst: includes feasibility study, code change/development, testing and implementation along with support in the production environment.
• SPOC for Datastage as well as Unix Shell scripting support and development activities.
• Team lead my responsibility includes Effort estimation & Resource management for all new ETL developments for the account.
• Datastage administration tasks such as unlocking of the Job/Project, Import/Export of the Jobs/Project across the environments, stop/start of Datastage server, cleaning of job log/resources & user creation.
• Environment: ETL tool-Datastage 8.01, Maximo, DB2, UNIX AIX, ClearCase.

Achievements:
Received Thanks Awards & appreciation from Onsite & Offshore managers for developing & deploying new enhancements within a stipulated deadlines, providing 24*7 application support, resolved critical issues within the SLA time frames & SPOC for UNIX development and support.

Project 4

March 2011-Till Date SSE & Team Lead Project: Confidential

• As ETL team lead my responsibility includes Effort estimation for all new ETL developments for the account
• Designing the solution and creating the Micro design documents
• Getting the solution developed, tested and documented
• Consulted Test team in Noida about the entire ETL solution which resulted in bringing down the defect rate down by 60%
• Getting the solution released in different environments and UAT support
• Handing over to AMS support teams

Projects handled as ETL Team Lead:

• Evidential Data Integrity Platform: (EDIP)

The requirement for EDIP was to consolidate data between 2 main transactional systems, CoreIt (transactional database) and SAP (interface for all transactions). The client TFL does various reporting on both these systems and for those reports to match, TFL expects them to be in sync. The requirement for EDIP project was to identify and report discrepancies between these two systems.

• CoreIt ETL projects:

CoreIt, transactional system has certain entities which needs bulk data upload. These jobs would also require creating audit and exception reports. These solutions are provided by ETL Datastage.

Achievements:
Receivedappreciation from IBM Business Partner for my involvement in a key data sensitivity project and successfully leading the team to become the first completely Offshore-driven team in the Project.

• Bachelor of Engineering (Computer Science) : 2004 - 2008
• Higher Secondary Certificate (Science) : 2002-2004
• Secondary School Certificate : 2001-2002

Software Proficiency

ETL Tools: IBM InfoSphere DataStage8.x, Informatica, Quality Stage, SSIS, SAS DI
Reporting Tools: Basics of Cognos 8.x , Introduction to SSRS
RDBMS: DB2-UDB 9.1, Oracle 9i, PL/SQL, Teradata
Languages: UNIX Shell Scripting, PERL scripting, C, C++, PL/SQL
WEB Technology: HTML
Operating systems: UNIX, MS-DOS, Windows 98/2k/XP
Other Tools: ClearCase, ClearQuest, Maximo

Personal Details

Date of Birth : 19th January, 1987
Place of Birth : Kalyan, Maharashtra
Gender : Male
Nationality : Indian
Languages : English, Hindi, Marathi
Hobbies : Painting, Music, Cricket