SUMMARY:

• Over 8 years of IT industry experience in maintaining DataStage applications and involved in production support activities.
• Focused on ETL development, DataStage Job Design and Automation and Source Data Assessment
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.0/7), designing, developing and debugging jobs using DataStage Designer, DataStage Manager and DataStage Director.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Excellent in using highly scalable parallel processing Infrastructure using DataStage Parallel Extender.
• Efficient in incorporation of various data sources such as Oracle, DB2 and Sybase, XML and Flat files into the staging area.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.
• Proven track record in addressing production issues like performance tuning and enhancement.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Involved in various phases of SDLC like Design, Development & testing.
• Experience in Scheduling tool Autosys for automating and scheduling jobs for daily/Monthly data loads.
• Efficiently migrated ETL projects with more than 200 medium/complex jobs to new Datastage 8.5 versions while fixing various compatibility issues.
• Having good communication and interpersonal skills.
• Team player, self - motivated and adaptive to new technologies
• Played the role of primary support for data warehousing application at client location.
• Developed an ETL and reporting application using open source tools like kettle to support production support monitoring activities.
• Experience in production support

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere DataStage 8.5.x/8.1.x/7.5.x EE, Informatica Power Center 8.6.x/7.1.x., Talend Open Studio 6.0 for Data Integration.

Databases: Teradata, Oracle, DB2 UDB, VSAM, Microsoft SQL Server 2005

Development Languages: C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting.

Tools/Utilities: SVN, Tivoli Work load scheduler(TWS), Teradata SQL Assistant, Teradata View Point, Putty, Components Lists& Migration(CLM), TSO/ISPF, SDSF, Expediter, Endevor, File-AID, File-DB2, QMF, SPUFI, DCLGEN, DB2 Interactive, INSYNC, CONTROL-M, CA-7, JHS, NDM, SUPERC, SYNCSORT, INSYNC, DFSORT, STROBE, VIASOFT, DB2A, DUMP-MASTER

Process Models: CMM/CMMI, PMP, Business Analysis and Documentation

Service Request Management Tools: HP Service Center, CSC, REMEDY, HP Service Manager

Operating Systems: Windows 98/XP/Server 2K, IBM AIX 6.1/5.3, HP UX 11i/10i, SUN Solaris 2.7/2.6.

PROFESSIONAL EXPERIENCE:

Senior ETL DataStage Developer

Responsibilities:

• Worked on Data profiling on various source systems to identify and accommodate the required data from these various source systems into the NDW.
• Worked with subject matter experts for Data Requirement Documents(DRD)
• Created a data dictionary to map the business requirements to attributes to design logical data model implementing star schema.
• Designed Translate values (common generalization of attributes) to maintain uniformity across the NDW.
• Involved in creating technical Design documents and unit and integration test plans for development and testing activities.
• Prepared deployment packages and also deployed code into various environments by following the best practices.
• Worked on post-production issues, enhancements, change requests and resolving the production defects.
• Automated the entire ETL flow using Autosys and TWS scheduling tools.
• Developed a very complex data validation and error handling jobs.
• Created Jobs to classify the data into subject areas as source jobs.
• Created Jobs to load the data into NDW from various subject areas as Target jobs.
• Used Various Standard and created custom routines to use in DataStage jobs.
• Extensively worked with DataStage Shared Containers for Re-using the Business functionality.
• Extensively wrote user-defined SQL coding for overriding for auto generated SQL query in DataStage.
• Written batch Job Controls for automation of execution of DataStage Jobs.
• Defined Stage variables for data validations and data filtering process.
• Worked on performance tuning to address very critical and challenging issues.
• Coordinated with SIT and UAT team to fix and test problem reports.
• Mentor other team members to implement testing mechanism that suits ETL methodologies.

Environment: IBM InfoSphere DataStage and Quality Stage 8.5/8.1, AIX, Linux, Oracle 9i/10g, IBM DB2, PL/SQL, 9.5, Vertica, Autosys, TWS 8.4, Cognos 10, Rational Tools, WinScp

Senior ETL DataStage Developer

Responsibilities:

• Extensively involved with business team for analyzing the source systems data and building the design documents
• Extensively worked with architects and proposed solutions in building common design approach for building the Job control and error recording tables.
• Completely prepared Naming Standards Document and Low Level Design Documents which was used across the Projects.
• Defined the job parameter sets and user defined common environment variables in DataStage Administrator, also responsible for taking the export/import backups and deploying the project in various environments
• Extensively used the advanced DataStage Data warehousing capabilities of almost all Processing stages like Change capture stage, Lookup/Join/Filter/Funnel/Surrogate Key Stages
• Prepared ETL job run dependency list by discussing with scheduling team and java extracts team and by considering the load and availability of various systems.
• Prepared mapping documents, technical design document and process flow documents using Visio.
• Prepared integration test case plans and test scenarios along with testing.
• Developed Sequence Jobs Using DataStage Sequencer, dependency analysis (which indicates weather Job to run sequentially or in Parallel.
• Involved in performance tuning by minimizing the redundancy of usage of stages and reducing the load on database side.
• Responsible for metadata management, creating shared containers for reusability.
• Participating in weekly status meetings, process presentations, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.
• Actively worked during go-live and post production.
• Actively worked during go-live and post production.
• Handled production support activities during the warranty period.

Environment: Datastage PX 8.5.x/7.5.2, Oracle 11g, PL/SQL, Shell scripts and Autosys.

Senior DataStage Developer

Responsibilities:

• Monitoring the upstream file arrival and converting them to Hiperformance format through ETL and laod them to EDW(Enterprise Data Warehouse)
• Monitoring the upstream file arrival from MCH,PNA and GE and incase of any delays checking with upstream for any ETA
• Closely monitoring ETL jobs, if there are any jobs that are running more than the usual time or for any failures
• Extensively used advanced parallel DataStage stages for building the Data warehouse with optimal performance and also involved in writing Shell scripting
• Used several DataStage Sequence stages like Job Activity, Execute command, Sequencer, Exception Handler, Wait for a file activity, Terminator activity, Notification activity.
• ETL enhancements and Issue analysis
• Active participation in HiPerformance upgrade of version 15.8
• Proactive monitoring and issue escalations at right time
• Performance analysis on core cycle
• Participate in production deployment activities.

Environment: DataStage PX 7.5, SYBASE, DSTi Hiperformance and Autosys.

DataStage Developer

Responsibilities:

• Analyze the requirements and prepare design documents.
• Designed and developed jobs to extract data from files, load them to staging tables and then to target tables.
• Developed Sequence Jobs Using DataStage Sequencer, dependency analysis (which indicates weather Job to run sequentially or in Parallel.
• Involved in performance tuning by minimizing the redundancy of usage of stages and reducing the load on database side.
• Responsible for metadata management, creating shared containers for reusability.
• Participating in weekly status meetings, process presentations, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.
• Actively worked during go-live and post production.
• Developed DataStage jobs and Job sequencers and testing them in DEV and UAT before deploying them to PROD.
• Prepared test cases and unit test plans for the jobs.
• Ensuring successful production support and coordinate with onsite team

Environment: IBM Infosphere DataStage V8.5 (Designer, Director, Information Server Manager &Administrator), Oracle and Autosys.