PROFESSIONAL SUMMARY:

• 10+ years of work experience in Development and Implementations of Data Warehousing solutions.
• 9+years of experience in SAP BODS Development as well as Administration.
• Dealing with WEBI and CR reports. Rectifying all the issues related with scheduling, connection and database connectivity problems.
• Setting rights and privileges on objects, folders, connections depending upon the requirement. Creating and maintaining different user groups as per the business need.
• Installation experience of Business Objects Data Services 4x.
• Implementation of Open Database Connectivity (ODBC) and query development for flexible information exchange between organization’s proprietary Unix based application and end user desktop applications such as Excel and Access.
• Involved in BODS Upgrade activities.
• Worked on ETL tool SAP Business Objects Data Services 4x/3x and on all transforms of Data Services (Data Integrator, Platform & Data Quality transforms).
• Managed BODS objects like Installation of BODS, Creation of new Repository, Schedule of Batch Jobs, Data stores, Addition of repositories to Designer, Setting Job server, Flat file formats and Excel/Xml file formats.
• Used in - built functions of BODS, Custom functions, Conditional workflows, BODS scripting language, debugger to debug the BODS Job in debug mode.
• Exposure on BODS Management Console.
• Involved in production support activities.
• Exposure on Remedy tool.
• Experience in designing, implementing, maintaining, and documenting complex database applications.
• Created triggers, stored procedures, triggers, cursors, tables, user functions, views, indexes, Sql queries, and relational database models on Databases like Teradata, Oracle.
• Exposure on Production support role.
• Prepared support projects documentations.
• Hands-on experience in SDLC entailing activities related to requirements gathering, including planning, design, development, implementation, documentation, prototyping, development, testing, implementation and user .
• Involved in source code repositoriesactivities. ed multiple performance s like ‘Team Spot’, DW Client Manager Appreciation and ‘Technical Appreciation ’ for typical work performed for few of the clients as part of my organization activities within Capgemini.
• Received customer Excellence .
• Received client appreciation s from the Confidential ’s client Confidential .
• Received on spot in Confidential gems for the contribution in the Confidential project.
• Analysis, Design and Implementation of Software features using Business Intelligence tools SAP Business Objects Data services 4.x ETL Tool.
• Designed and developed an inventory control system for the company using VB 5.0using RDO, ODBC and OLE technologies in window NTInterface with the Business Analysis team, Quality Assurance team and Project Management team and resolve issues related to Requirements, scope, testing and schedule.
• Analyze and fix defects raised by Quality Assurance team.
• Have done scaling, sizing in procuring SAP Data services and have done end to end installation of SAP Data services 4.x using Information Platform services (IPS) on a Standalone machine.
• Skills: SAP Data services 4.x ETL Tool, SAP Business Objects XI & 4.0 versions
• Has experience in Manufacturing, Retail, Insurance l Domains.
• Key Responsibilities as a Technical Lead
• Working with Onsite counterpart, Database Architect and also with client in preparing Data Model and preparing ETL Mapping Document
• Having internal review meeting with team to understand the Requirement, ETL mapping document and with architect to resolve modeling issues where ever it is required.
• Lead team in implementing code on new requirements by providing ETL mapping document and helping them to resolve technical related issues.
• Manage deployment and support offshore team ensuring that periodic tasks are completed by each team member.
• Assign and prepare schedule plan, coordinate with staff to ensure efficiency and productivity
• Create business processes, best practices, standards, templates and operating procedures to optimize IT project development.
• Maintaining all the project artifacts under a common shared folder in Capgemini Connect as to everyone can update their activities on time
• Maintaining Risk register and updating upon the discussion on issues persist over the weekly call.
• Status update to manager about the initiative by updating the schedule plan

TECHNICAL SKILLS:

Operating System: Unix and Windows

Designer Tools: BODS Designer

ETL Tools: SAP BODS

Database Tools: Teradata, Oracle, SQL Server, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential

Team Member & ETL Developer

Responsibilities:

• Implemented Load Balancing technique at BODS and SAP ECC level.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Used Push-Down, Bulk Loader in BODS to transform the data from CSV File to Staging area and Staging to EDW tables.
• Used various transformations like Query, SQL, Case, Map Operation, Table Comparison, Pivot, Merge, etc.
• Used BODS Script and Global Variables.
• Preparation of the Unit Test documents and capturing the results in UTP.
• Involved in BODS Jobs and database code tuning
• Created batch jobs using SAP BODS to transfer data from SAP ECC,SAP BW, SQL Server DB and Flat files to SAP HANA.
• Data migration from different data source to different target database.

Confidential - Chicago

Team Lead/BODS Developer

Responsibilities:

• Implemented Load Balancing technique at BODS and SAP ECC level.
• Involved in production support activities.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Used Push-Down, Bulk Loader in BODS to transform the data from CSV File to Staging area and Staging to EDW tables.
• Used various transformations like Query, SQL, Case, Map Operation, Table Comparison, Pivot, Merge, etc.
• Used BODS Script and Global Variables.
• Preparation of the Unit Test documents and capturing the results in UTP.
• Involved in BODS Jobs and database code tuning
• Created batch jobs using SAP BODS to transfer data from SAP ECC,SAP BW, SQL Server DB and Flat files to SAP HANA.
• Data migration from different data source to different target database.

Confidential

Team Lead/L3 Support Engineer

Responsibilities:

• Implemented Load Balancing technique at BODS and SAP ECC level.
• Involved in production support activities.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources
• Used Push-Down, Bulk Loader in BODS to transform the data from CSV File to Staging area and Staging to EDW tables.
• Used various transformations like Query, SQL, Case, Map Operation, Table Comparison, Pivot, Merge, etc.
• Used BODS Script and Global Variables.
• Preparation of the Unit Test documents and capturing the results in UTP.
• Working as a L3 Support Engineer.
• Involved in BODS Jobs and database code tuning
• Hands on experience with Third party schedule tool Tivoli to manage the jobs as per dependency.
• Setting rights and privileges on Repositories. Creating and maintaining different User groups as per the business need.
• Created batch jobs using SAP BODS to transfer data from SAP ECC,SAP BW,Oracle,DB2,Oracle,SQL Server DB,XML and Flat files to Teradata
• Data migration from different data source to different target database.
• Support and maintenance of existing jobs.

Confidential

ETL Object Developer

Responsibilities:

• Developer from ETL Development side.
• Interacting with the client for the enhancements requirements gathering.
• Developing design strategy for loading the data mart tables as per the request received from the client.
• Development of Workflows, dataflows, r/3 flows (pulling data from SAP, sequential files, oracle etc.)And sequencing them into the existing jobs as per requirement for loading the data into the data warehouse as per the specified design.
• Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources
• Reviewing of the jobs created by others
• Maintaining the existing application by monitoring the loads, resolving the production issues in very quick turnaround time and also resolving the queries asked by the different users who use the data.
• Schedule the jobs as per the request received from the client
• Prepared mapping documents according to the specifications.
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in Data Profiling and Cleansing
• Maintaining standards (naming convention) and Quality.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Created different transformations for loading the data into oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• ALE, BAPI and I Docs inbound and outbound interfaces creation, maintenance and testing
• Hands-on experience with Enhancements, Modifications, BAdIs class methods and User Exits
• Custom application development with ABAP Dictionary objects, Maintenance Dialog programming.
• Involved Date Migration Activates using LSMW (Legacy System Migration Workbench).