PROFESSIONAL SUMMARY:

• I have around Ten years of experience in the following areas: Consistently achieve high customer satisfaction scores and improve identified areas of improvement within operations.
• Have Expertise of Ten years in Data Warehousing ETL (IBM WebSphere Data Stage Enterprise/Server Edition).
• Have experience in Insurance and Banking, Retail management, Pharmaceuticals.
• Successfully manages and leads project which involves various technologies and domains. Have expertise in Waterfall Model and work experience in Agile methodology.
• Skilled at strategic planning and estimation, Leadership, Mentoring, Team building, Problem solving and decision making skill.
• Experienced in architecture and design of the ETL environment using Datastage.
• Experience in creating Technical Design & Implementing ETL solutions for Data Warehouse and understand its impacts.
• Experienced in Data Architecture including knowledge of Data modeling techniques, Entity relationship diagrams and Performance Tuning. Have expertise to handle and own multiple assignments concurrently.
• Have expertise to Develop a Data Warehouse solutions integrating data from across multiple source systems. Received recognition for Best Architect design from Confidential Corporation.
• Extensive experience in all phases of Software Life Cycle such as Requirement Phase, Analysis, Design, Development, Various Testing Phases, Documentation and Maintenance support like developing ETL design documents, technical specification documents and guiding/mentoring team starting from development phases to implementation phase.
• Trained in Big Data and Hadoop technologies (MapReduce, Yarn, Pig, Hive, HBase, Oozie, Flume and Sqoop).
• Actively involved in preparation and maintenance of Quality documents for the project and involved during audit process.
• Participates in business meetings with IT, business management, staffing and end users.
• Certified on IBM WebSphere DataStage 8.0.
• Have expertise with various source systems like DB2, Oracle, SQL Server, AS400, and Teradata database, XML, Netezza and MQ.
• Undergone in IBM on WebSphere Information Analyzer, WebSphere Business Glossary and Quality Stage.
• Have knowledge on BO Reporting tool and Tableau. Have knowledge on Informatica.

TECHNICAL SKILLS:

Advanced Technologies: ETL, IBM WebSphere Data Stage, InformaticaTableau, BO Reporting tool. Big Data and Hadoop (MapReduce, Yarn, Pig, Hive, HBase, Oozie, Flume and Sqoop)

Programming language known: ASP.net, JAVA

Operating System: Windows 9x/2000/XP, UNIX, AIX

Database: Oracle, DB2, SQL Server 2000, Teradata, Netezza, MQ

Office Automation: MS Office

Hardware: IBM PCs, Data General

WORK EXPERIENCE:

Confidential

Technologies: Data Stage EE 8.5, Informatica, DB2, Oracle, AS400, Sql Server, AIX 5.1, UNIX, MQ, Netezza.

ETL Data stage Lead Designer and Senior Developer

Responsibilities:

• Have taken ownership to analyze functional/nonfunctional requirements. Define timeline estimates based on the requirements, complexity and in - house capability. Provide inputs on technical feasibility of requirements. Identify gaps in requirements. Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc. Review plan and provide feedback on gaps, timeline and execution feasibility etc as required in project.
• Designed and developed Data warehouse ETL applications as per requirement specification and Break down the base lines requirements into business and functional requirements. Actively involved in preparation of technical specification document and review the same for some other projects prepared by offshore team.
• Have taken complete ownership for all SDLC phases starting from Requirement phase to implementation phase. Taken ownership of multiple assignments concurrently and completed development activities before deadline as development lead role.
• Have actively taken ownership for reviewing of code and design artifacts for some of assignments. Maintain versions of the code or consolidate version maintained by team. Provide support as required to the Administrators during configuration, code backups, deployment etc.
• Investigate critical defects and establish need for fixing. Report defect status as per project standard process within agreed timelines. Performs root cause analysis when ETL issues arise and proposed solutions effectively.
• Developing the data stage jobs including all activities as addressed above. Have shown expertise in performance tuning of ETL jobs as per IBM Standard.

Confidential

Technologies Used: Data Stage EE 8.5, DB2, Teradata, AIX 5.1, UNIX, MQ

Data Stage Lead Designer and Developer

Responsibilities:

• Have taken ownership to analyze functional/nonfunctional requirements. Define timeline estimates based on the requirements, complexity and in-house capability. Provide inputs on technical feasibility of requirements. Identify gaps in requirements.Designed and developed Data warehouse ETL applications and guide team in preparation of technical specification and review the same. Break down the base lines requirements into business and functional requirements.
• Handle multiple assignments concurrently and owned the complete development activities as development lead role. Have taken complete ownership for all SDLC phases starting from estimation to implementation. Guide team in coding as per design. Follow coding standards and best practices to check code quality. Guide offshore in identifying, preparing and conducting unit test cases and fixing defects based on results.
• Develop unit test case for each module. Conduct unit and integration testing and fix defects. Review/ approve code to be moved to testing environment. Provide support to the QA team and coordinate for various phases of testing. Address queries raised by QA within defined timelines.
• Maintain versions of the code or consolidate version maintained by the Developers. Provide support as required to the Administrators during configuration, code backups, deployment etc.
• Investigate critical defects and establish need for fixing. Report defect status as per project standard process within agreed timelines. Performs root cause analysis when ETL issues arise and proposed solutions effectively.
• Shown up my skill to coordinate/keep good relationship with onshore - offshore synch up process to deliver task on time for which received recognition from client for CCM.
• Have taken complete ownership of implementation phase and post-deployment support in case of any defects or issues as part of warranty support period.

Confidential

Technologies Used: DSEE 8.5, DB2, Teradata, AIX 5.1

ETL Technical Lead

Responsibilities:

• Taken ownership of analyzing requirements and taken the technical decisions on ETL effectively for JDA-integration project in analysis and design phase.Designed ETL Application for JDA- Integration Project. Created different high level and low level technical artifacts related JDA-Integration ETL project.
• Have received recognition () for best ETL Technical Design.
• Have expertise in understanding Integration Requirements from customer and coordinating team in respective development and testing phases to deliver successfully on time.
• Designed and Developed Data Warehouse solutions from multiple source systems, Participate and contribute in business & technical requirement gathering meetings and design sessions.
• Shown up my skill to communicate effectively with onshore/offshore and proved me as good team player. Performed root cause analysis when ETL issues arise and proposes productive and effective solutions.

Confidential

Technologies Used: DataStage Enterprise Edition 7.5, DB2, AIX 5.1

Datastage Development Lead

Responsibilities:

• Worked as ETL Development Lead. Have taken complete ownership of various phases of the project life cycle starting from requirement analysis to deployment phase as addressed below and successfully delivered three big releases.Have shown up my strong analytical and problem solving skills to support production issues when it is in critical situation.
• Actively involved to understand and finalize the exact requirements as needed by the customers. Involved in Impact analysis, creation of Project Estimation and SRS document for different releases of CITRuS.
• Responsible for preparation of technical design documents and interface specification documents and code review.
• Responsible for coordinating team in development and different testing phases to deliver the project on time.
• Handle multiple assignments concurrently and Performed root cause analysis when ETL issues arise and proposed solutions effectively.
• Have been involved proactively to increase the performance of developed jobs.
• Actively involved in preparation and maintenance of Quality documents for the project and involved as active member during audit process along with manager.
• Have experience of ETL Resource staffing process in IBM.

Confidential

Technologies Used: DataStage Enterprise Edition 7.5, Oracle 10g, AIX 5.1

Senior ETL Developer

Responsibilities:

• Actively involved in the period of SIT at Onsite.Have the Onsite experience in Hong Kong during SIT / UAT period. During this period, managed to fix the bugs in jobs developed in development phase and implementation of new business logic changes proposed by the customers.
• Involved to understand and finalize the exact requirements as needed by the customers.
• Responsible for designing, development and testing of ETL Jobs at offshore.
• Involved in verification of ETL jobs and designs developed by peer team members to maintain Quality according to IBM Standard.
• Resolves complex problems with limited supervision.

Confidential

Technologies Used: Data Stage Enterprise Edition 8.0, ORACLE 9i, AIX 5.1

Senior ETL Developer

Responsibilities:

• Actively involved in design, development and Unit Testing of ETL Jobs.Analyzed the issues involved in migration Jobs and suggested the solution.
• Verification of ETL jobs and designs developed by peer team members.
• Have solved the various challenges came during development phases productively.
• Project Management is widely dependent on my review work to minimize the issues in ETL jobs.

Confidential

Technologies Used: DataStage Enterprise Edition 7.5.2, ORACLE 9i, UNIX

Senior ETL Developer

Responsibilities:

• Actively involved in design, development and Unit Testing of ETL Jobs.Analyzed the issues involved in migration Jobs and suggested the solution to others proactively.
• Verification of ETL jobs and designs, testing report developed by other team to hold up quality of IBM standard.
• Have played Key role in review of etl jobs before testing phases to overcome issues. Have received recognition from management for my extra ordinary work.
• Resolves complex problems with limited supervision
• Have been involved proactively to increase the performance of developed jobs.

Confidential

Technologies Used: DataStage Enterprise Edition 7.5, ORACLE 9i, AIX 5.1

ETL Developer

Responsibilities:

• Actively involved in design, development and Unit Testing of ETL Jobs to deliver it on time.Have participated in solving complex issues proactively and effectively.
• Successfully played key role in team during development phase.

Confidential

Technologies Used: Windows XP, ORACLE 9i, DataStage Server 7.5, AIX 5.1

ETL Developer

Responsibilities:

• Actively involved in design, development and Unit Testing of ETL Jobs to deliver it on time.Successfully played key role in team during development phase.

Confidential

Technologies Used: Windows XP, SQL Server 2000, ASP.Net, Java Script

Software Developer

Responsibilities:

• Actively involved in design, development and Unit Testing of Web Forms to deliver it on time.Have shown up my SQL/PL-SQL skills and created procedure, trigger, cursor for multiple admin forms.
• Successfully played key role in team during development and various testing phases.

Confidential

Technologies Used: Windows XP, Oracle 8i, J2EE, JSP, Java Script

Developer

Responsibilities:

• Admin module helps to manage the history of records. This module also helps the customer to know the status of revenue and total ticket booked / cancelled on a specific day.Client module helps end user to get the via online or by call. Also it helps the existing member to book the ticket for a specific movie, theatre, locations, class of ticket and etc. Cancellation of booked ticket also can be done via this module.