SUMMARY

• Senior DWBI and ETL Developer with more than 15 years of experience primarily working in the areas of Information Management including Confidential InfoSphere platform experience, Data Warehousing and Business Intelligence, Confidential InfoSphere DataStage and QualityStage, Information Analyzer.
• Experience in shell scripting to automate the process and file validation.
• Strong RDBMS skills and extensively worked in databases like DB2, Oracle, SAP HANA and have strong knowledge of SQL and PL - SQL. Extensive ETL knowledge and worked in ETL tools like Confidential InfoSphere Datastage and QualityStage 11.5. Have extensive experience as ETL, DW & Confidential InfoSphere developer in various industry verticals primarily Manufacturing, Consumer Products, Banking, Financial Services & Insurance, Telecommunications, Computer Storage & Data Maintenance, Aerospace & Defence.
• Currently working with Confidential as DW & Confidential InfoSphere ETL developer and the primary job responsibilities include:
• Develop complex transformational engagements for various clients primarily working in areas of ETL, DW/BI & Confidential InfoSphere Product Suite.
• Acting as a DataStage developer in areas of Effort Estimations, Competency Development for ETL & Confidential InfoSphere Practice
• As a senior DataStage Developer handling the Complete End - To - End Engagement for multiple Implementations, Rollouts & Enhancement Support for Clients from several Industry Verticals

• DW & BI, ETL & Confidential InfoSphere - Expert Knowledge in Confidential InfoSphere Datastage and QualityStage 11.5, Confidential InfoSphere Information Analyser 11.5, Oracle 9i/10g/11g/12c, DB2, SQL, PL/SQL, SAP HANA
• Business Development & Competency Development - Complete Solutioning, Effort Estimations, Corporate Training for Practice Development in DW, ETL & Confidential InfoSphere suite
• Certification - WebSphere IIS DataStage Enterprise Edition V7.5, WebSphere IIS QualityStage v7.5 and 700 - DB2 UDB V8.1 Family Fundamentals

PROFESSIONAL EXPERIENCE

Confidential

DataStage Developer

Responsibilities:

• Analyzing, understanding the requirements and implementing the business functionalities.
• Extensively worked in design and development of jobs using DataStage to extract and load data from source databse to target. And involved in architecture design.
• Developing jobs using ODBC Enterprise, Data set, Transformer, Sequential File, Lookup,
• Used director to analyze data flowing in the stages to test and fix jobs
• Passed values by loading parameters through job properties
• Created sequences to maintain the dependencies between jobs and satisfying the business requirements.
• Developing shell scripts to run the data stage jobs through UNIX box.
• Create the ROBOT jobs to schedule the client processes.
• Preparing UT documents and technical specification documents.

Environment: IBM InfoServer 11.5/9.1 PX, DB2, AIX, Windows

Confidential

DataStage Developer

Responsibilities:

• Develop complex solution with Confidential InfoSphere DataStage 11.5 as per the business logic.
• Develop shell script to automate the process and validate the source files
• Develop SQL and PL/SQL as per the requirement.
• Create job Sequences to group all the parallel jobs according to their dependency.
• Deliver quality deliverables to the Client without any defect.
• Unit testing for parallel jobs, review works for other jobs in the team, participate in the system testing
• Involving in client discussions to understand business user’s requirements
• Understanding the Business requirements & convert them into Functional Specifications into Technical Specifications.
• Involving in the design, development and testing of different objects.
• Developing Data Quality rule using Confidential InfoSphere Information Analyzer
• Creating Webi Reports using Business Objects Universe Designer.
• Involved in closing Tickets Priority 3 and 4.
• Provide day-to-day user support

Environment: Confidential InfoSphere DataStage and QualityStage 11.5, Unix, Oracle 12c, SAP Hana Studio, SAP BO

Confidential

DataStage Developer

Responsibilities:

• Design and developed the NRT (Near Real Time) Concepts using Confidential InfoSphere DataStage which is extracting the data(XML) from source system via MQ and load it into the MDM. Once MDM rest call status success then loads the data into the BIG MATCH (generating the xml based on BM format and send via rest call).
• Design and developed the generic job for ODM (Data validation services), QAS (Address Validation), MDM Load Job and BM Load job, Common Audit job using Confidential InfoSphere DataStage.
• Preparing the micro design document, Low level Design and mapping.
• Improve the performance of DataStage jobs.
• Fix defect of SIT and FIT.

Environment: Confidential InfoSphere DataStage and QualityStage 11.5, Oracle 12c

Confidential

Optim Developer

Responsibilities:

• I have worked as Optim developer for Work Package 5. I have always given support to deliver project milestone on time with high quality and with minimal defect.
• I have developed code on Purging Payroll data on NHS complex and huge system with combination of Optim and Oracle solution.
• I have developed code in Optim to create sub set and obfuscated sensitive data items, written complex store procedure to generate look up tables to obfuscate sensitive data items.
• I have analyzed and fixed the defects raised by Test team.
• Gathered requirement with client and functional expert in EHS ESR system to create a subset of smaller data volume and identify sensitive data items and defined the policies.
• Data Sub setting and Data Obfuscation is very important and complex with respect to NHS ESR project, design, transformation and loading side. I have analyzed the ESR Oracle EBS and created Functional and Technical Specification for Data Obfuscation. I have also proposed Data Obfuscation policy and methodology.
• I have presented data analysis report, obfuscation policy to ACT (Authorized Central Team) and they always appreciated my work.
• I have created the Strategy document, Functional and Technical Specification.
• I always make sure the obfuscation policies are irreversible, legacy complaint, does not impact others application.
• I have also look after the Archive area to deliver good quality work on time.
• I have shared knowledge on Optim functionality to all resources in the project.
• I have completed environment set up, installed and configured required tools and software. I have coordinated with Infrastructure team, Environment Manager, NTT, ACT to quickly mitigate the issues and risks.
• Provided KT to other members & helping them for hands on activity.
• Helped team members to deliver quality codes and clarified them to understand Optim process, functionality, identify issue and resolve them.

Environment: Confidential InfoSphere Optim Test Data Management, Confidential Infosphere Optim Data Growth, Oracle EBS 12.1.3, RHEL 6.6

Confidential

DataStage Developer

Responsibilities:

• Developed End to End Migration Strategy & execution via RTL methodology & Confidential InfoSphere suite of products - Confidential Datastage and QualityStage 9.1, Confidential InfoSphere Data Architect 8.1 for complex SAP Order To Cash related master & transactional objects
• Design an integrated data model that shows the relationships within the sources and inter-dependencies among several legacy source systems
• Design and develop the ETL framework for the Selection & Exclusion module (the module is used to subset the data based on various business rules) which is considered one of the most complex modules in the project.
• Tune the areas of performance bottlenecks in Data Stage parallel jobs as well as complex SQL queries used in Selection and Transform modules.
• Error analysis encountered during SAP loading and preparation of error log.
• Create all Technical Architecture & Design Documentation as part of Blue Print & Realization phase
• Report into the Data Migration Lead from Confidential & the counterpart from SKF and manage all deliveries around data migration with high quality & in stringent timelines

Environment: Confidential InfoSphere DataStage and QualityStage 9.1, Information Analyzer 9.1, Data Architect 8.1, DB2

Confidential

DataStage Developer

Responsibilities:

• Handled the End to End Migration Strategy & execution via RTL methodology & Confidential InfoSphere suite of products - Confidential Datastage 9.1 for complex SAP Finance & Marketing related master & transactional objects
• Primarily handled the Data Conversion technical design and data quality & enrichment business rules implementation via Confidential Quality Stage and Information Analyser for master & transactional objects in SAP Pre Sales (Quotation & Order Management), Marketing & SAP FICO
• Design an integrated data model that shows the relationships within the sources and inter-dependencies among several legacy source systems
• Analyze the source data from different Legacy systems and identify the relationships among the sources
• Prepare, Analyze & understood the technical design document (TDD) to develop jobs using Data Stage.
• Testing ETL objects properly, Preparing Unit test case.
• Designing the Extracting jobs to extract data from source SAP system. Generating ABAP code through Data stage Job
• Data Loading into SAP R/3 system (ECC 6) using Data Stage Pack for IDOCs in SAP ECC and generating file for LSMW programming
• Error analysis encountered during SAP loading and preparation of error log
• Updating the mapping sheets and TDD’s based on requirement changes and upload the them into Fast track
• Created all Technical Architecture & Design Documentation as part of Blue Print & Realization phase

Environment: Confidential InfoSphere DataStage and QualityStage 9.1, Information Analyzer 9.1, Data Architect 8.1, DB2, Confidential InfoSphere Information Server Pack for SAP

Confidential

DataStage Developer

Responsibilities:

• Designed and developed work product using DataStage 8.5 and Netezza, developed DataStage jobs, routines, scritps, Netezza Scripts to produce work item and integrated the tasks as deliverables
• Primary SPOC for all complex technical solutions and handled the complex BI implementation, Interconnect revenue
• Responsible for build, cutover & testing Phases of Project

Environment: Confidential InfoSphere Data Stage 8.5 and Netezza

Confidential

Data Analyst

Responsibilities:

• Involved in data modeling to analyze the mainframe structure and convert into relation model.
• At the initial phase of the project gathered information about project by discussion with the senior team members and understood the business requirement.
• Create mapping of mainframe copy book to convert mainframe structure into tabular format using Classic Data Architect (CDA). I have always given support to map complex mainframe copybook at critical situation within short period of time to meet the client deliverables. I have resolved the mapping issues faced by others team members
• Extract the mainframe file to oracle table by creating scripts. Resolved issues while extracting complex mainframe file to oracle table.
• Analysed the sensitive field of oracle tables using Confidential Discovery tool.
• Mainly working to load back the data to mainframe format from oracle table after masking the sensitive data.
• Resolved issues to load data back to mainframe for complex scenarios like file containing hex data, files has millions of data, load through Optim Connect.
• Shared the work load among the team members to give a smooth delivery of project work.
• Always work proactively to meet the client’s time line by working on weekends and extra hours.
• Coordinate the task properly which are dependent on different phase of the project to avoid delay of the process and gave useful information on their doubt.
• Analyze on the issues of mapping, extract and load process of complex files faced by others team members and provided resolutions and fixes on time.
• Developed scripts in load process to load the files in batches.
• Unit tested all the files which are loaded by coordinate with the Mainframe team to give good quality work with defect free.
• Transferred knowledge of project of different phase to the new team members and guided them how to map, extract and load the mainframe file.

Environment: Classic Data Architect, Confidential Discovery, Optim, Classic Federation Server, Optim Connect, Oracle 11g

Confidential

Onsite DataStage Developer

Responsibilities:

• Develop parallel jobs, server routines based on functional specifications provided by the client using DataStage v8.1 as ETL Tool and Oracle as the Database.
• Create job Sequences to group all the parallel jobs according to their dependency.
• Delivered quality deliverables to the Client.
• Unit testing for parallel jobs, review works for other jobs in the Team, participate in the system Testing and Data validation (using TOAD).
• Participate in knowledge transfer and documentation.
• Translate functional requirements into technical specifications
• Co-ordinate with Testing and provide input in Integration Testing
• Analyze on the Tickets and provide resolution/fix to the Issues.
• Given support to fix the issues during the UAT phase.

Environment: Confidential Information Server 8.1, Oracle 11g

Confidential

DataStage Developer

Responsibilities:

• Develop parallel jobs based on functional specifications provided by the client using DataStage v8.0 as ETL Tool and Oracle as the Database.
• Using ETL handover documents from the on-site Team; create Master Sequences to group all the parallel jobs according to their dependency.
• Delivered quality deliverables to the Client.
• Unit testing for parallel jobs, review works for other jobs in the Team, participate in the system Testing and Data validation (using TOAD).
• Participate in knowledge transfer and documentation.
• Translate functional requirements into technical specifications
• Co-ordinate with QA and provide input in Integration Testing
• Analyze on the Tickets and provide resolution/fix to the data Issues.
• Enhance/modify parallel jobs to fix the data Issues
• Involved in performance tuning of datastage jobs to reduce execution time

Environment: Confidential Information Server 8.0.1, Oracle 10g, PUTTY.

Confidential

DataStage Developer

Responsibilities:

• Working as a DataStage Developer for Telstra Data Migration from Confidential India.
• Responsible for daily monitoring and governance, Project Management, Customer Billing, Time Sheet Tracking and Overall Delivery.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Effective communication between the project team and the Onsite to give them a sense of trust and enhance the offshore delivery capability. Provide day to day direction to the project team and regular project status to the customer.
• To Analyze Technical and Business requirement from Onsite and effectively communicate the issues from Offshore to the Client.
• Along with Technical Mentoring was responsible for developing and delivering the components from offshore.
• Handling issues related to the job development for offshore resource.
• On Time and Defect Free Deliverables from Offshore.
• Responsible for Quality Process in the Project.
• Work towards finalizing the way forward.
• Understanding the client requirement.
• Responsible for Final Delivery.
• Identifying, addressing and resolving technical problems related to the Data Stage.
• I have participated in knowledge sharing with the new team members and ensured the new team members are guided on Technical/Function aspects
• I have developed new code & Bug fixing at the ETL (DataStage) tool.
• I have reviewed the work developed by team members for each work item properly.
• Responsible to send weekly status report for all the work item in OSS Test, OSS Dev, BSS Test and BSS Dev team to onshore client.
• Maintained all quality related documents for my project to keep all quality standards of project within the organizational limit.
• Responsible to organize the Monthly Meeting where we can discuss issues, suggestions, project status, future plan.

Environment: DataStage, UNIX, Oracle

Confidential

DataStage Developer

Responsibilities:

• Extracted the data from DB2 Mainframe system into a .CSV file format which was used as the source flat file for Datastage jobs
• Worked on ProfileStage which is basically a profiling tool used for data profiling.
• Loading Bulk data in DB2 Staging Area.
• Developing Data Stage jobs
• Unit testing
• Handling issues related to job development
• Delivering complete code modules with associated documentation

Environment: DataStage, DB2 in AIX, SAP CR3 Sandbox

Confidential

DataStage Developer

Responsibilities:

• To develop jobs in DataStage 7.5.2 Enterprise Edition (Parallel Extender).
• Unit Testing of Jobs

Environment: Data Stage 7.5.2 Enterprise Edition (Parallel Extender), Oracle