Professional summary

• Over 11 Years of experience in SAP, which includes 6 Years of functional and technical experience in customization and implementation of Data Services and 8 years of SAP BO experience.
• Implemented 2 complete Lifecycle Data Services projects including requirement gathering, data modeling, extractions, data staging, data cleansing, data quality and transformations and reporting.
• Analyzed business processes and recommended SAP best practices provided conceptual / detailed designs and provided functional / configuration knowledge in designing SAP solutions in the SD, SCM & FI modules of SAP to meets business requirements.
• Expert in Data Services Data Quality (DQM) like address cleansing and data cleansing process.
• Extensive experience and proficient in Designing and Developing ETL routines using Business Objects Data Services Data Migration with All In One (AIO) best practices methods and Pl/SQL.
• Experience in Data Migration techniques like migration with AIO and data quality transformations, receiving and sending Idoc’s and integration with SAP ABAP to Data Services.
• Experience in Integration SAP suite of BI products with Business Objects including Business Objects Data Services (Rapid marts), Business Objects XI 3.1, Crystal Reports and SAP Integration Kit.
• Compare and contrast SAP Rapid marts/SQL server architectures to created enterprise data warehouse.
• Expertise in writing, testing, debugging, documenting and implementing complex Batch jobs and Real time jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations.
• Good experience in ABAP/4 Reports, BAPI, and IDOC’s integrated with Data Services.
• Good knowledge of different phases of Data Warehousing projects and Conversant with Quality procedures while executing the projects.
• Experience in Performance tuning of BODI Mappings at sources, mappings and target level and tuning the SQL queries.
• Extensively involved in data profiling like source column data, detail data profiling and used validation, address cleansing transformation by using data quality in BODI 12.2.
• Experience in Creating, Designing and developing Business objects Universes and BOBJ Reports from different data providers like Stored Procedures, Free hand SQL and others.
• Experienced in supporting end-user reporting needs using Business Objects.
• Extensively worked on transporting all kinds of Data Services objects from Development system to Testing system and Production systems.
• Maintained the test scripts, documentation, and testing procedures during the functional lifecycle of the system, after initial implementation, based on input from the user community.
• Strong analytical skills, enabling to quickly understand the drivers of a business process.

Education

• M.Tech in Thermal Sciences

Key Skills

ERP : SAP ECC 6.0, R/3 4.7 4.6C/ 4.6B/ 4.5B.
ETL : Data Services XI 3.2, Rapid marts, DSBPMD with AIO best practices. 
Data Warehouse : SAP BI 7.0, SAP BW 3.5.
Business Objects : BO XI 3.1,Universe Design, Crystal reports, 
Webi, Business Objects Explorer, Xcelsius. 
BO with SAP : SAP Integration Kit 
Languages : ABAP/4, C, C++ and VB.
Operating Systems : Windows 2007/XP and Windows/NT.
RDBMS : MS SQL Server 2008 and ORACLE 10g and 8i.

Experience

Confidential– Mason, MI Jan’ 12 to Till date
Sr. SAP Data Services Best Practices Data Migration (BPDM) All in One (AIO) Lead Consultant. 
Responsibilities:

• Interacted with the end users get the requirements and implement & Install the Data Services Best Practices procedures according to Client’s need.
• Installed the All in One (AIO) Best Practices Projects, Data flows, Work flows and transformations and Data Quality (DQM) like address cleansing and data cleansing process.
• Installed the SQL Server 2008 R2 and created the Databases for Data Services and Repositories.
• Loaded the Look up files Initialization and delta work flows to populate the formats, lengths of the source systems like ECC 6.0 and SCM 5.0.
• Extracted the IDOC’s and Functions from the source system to update the fields and formats to the Data Services.
• Enhanced the Standard Best Practices Data Flows based on the Clients need.
• Validate and Enriched the Data flows and resolved the issues based on the validation from source system fields, formats and lookups to target system.
• Migrated master data like Cost Center, Material master, Customer master, Vendor master, BOM etc from Legacy systems to ECC 6.0.
• Migrated transaction data like Purchase Orders, Sales Orders and Inventory etc from Legacy systems to ECC 6.0 and BI 7.0.
• Executed Reconciliation flows and steps to validate the migrated master and transactional data from the target systems.
• Resolved very critical issues while Installation and executing the SAP delivered Best Practices flows and loading data from Legacy systems to Target systems.
• Installed the Integration kit (imported the cofiles & data transports into SAP) for BO XI products integration with SAP R/3 and BI.
• Created the Transformation, custom routines, DTP, DSO and InfoCubes for the Purchasing and Inventory data.
• Designed Purchase, Inventory and SPD universes on BI InfoCubes and queries for analysis in Business Objects by using Web Intelligence
• Design and Develop Crystal and Webi Reports for purchasing and Inventory modules.
• Designed Universes using advance features like aggregates, contexts, time slices to allow ad-hoc analysis.
• Created Inventory valuation by closing period, Listing PR's PO's and RFQ's by invoice
• R/3 reports in Crystal.

Environment: Data Services 4.0, MS SQL Server 2008, SAP BI 7.0, ECC 6.0, BO 4.0.

Confidential– Princeton, NJ June’ 11 to Jan’ 12Sr. SAP Data Services data migration Lead Consultant involved in DS migration with AIO’s. 
Responsibilities:

• Implemented the full life cycle Project of Integration the functional are SD with Data Services and BI, Responsible for Interacted with end users and project business sponsors to gathered business requirements, Performed GAP analysis, Prepared the Technical spec, Design of data models, comparing the model with delivered contents and Implementing the business logic with delivered contents along with modifications, Extracting the data to Data Services and Transport the BI objects and resolving the issues on variance analysis and BO reporting.
• Migrated the Legacy data to SAP ECC 6.0 by using the Data Services Best Practices AIO methods by using IDOC methods.
• Extracted the data from the SAP ECC 6.0, SAP BI 7.0 and Flat files to Data Services system and build the custom ETL data flows, work flows and calculated key measures.
• Data cleansing the by filtering the incorrect records and send the good data into the custom build warehouse by creating the Fact and Dimensional tables in Data Services.
• Created the Repositories, SAP data stores, read and modified the custom ABAP transformations, calling RFC’s BAPI’s, reading the SAP functions to Data Services.
• Involved in Migrating/Exporting the Data Services code from DEV to Quality and Production systems and import and export the System configuration and Substitution Parameters from DEV to QA and PROD systems.
• Created the Global and Local Variable and customs SQL queries and implementing the Data Services based on client’s requirements.
• Load the data from Data Services and put into the SAP BI 7.0 InfoCubes and DSO’s for the Business Objects reporting.
• Created the Universes on top of SAP BI InfoCubes and build the Multiproviders with existing COPA InfoCubes with the SPIN, POS data for Siebel Reconciliation reporting.
• Created the Business Objects Webi reports on top of the Universe for the SPIN, POS & Siebel Reconciliation reports.

Environment: Data Services 12.2, ECC 6.0, BO XI 3.1, MS SQL Server 2008.

Confidential— Indianapolis, IN, June’ 10 to May’11Sr. SAP Data Services and BO Consultant involved in Implementation Projects in HR & SCM Module.
Responsibilities:

• Worked with the project team and multiple end-users to gathering the requirements and architect the design and implemented full life cycle in HR module and provided the solution for Employee information, Payroll, Personnel Administration, Organizational Management, Time Management and Employee Interaction Center data.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects
• Extract, Transform and Load source data into respective target tables to build the required data marts
• Created Repository Users and Groups. Analyze and import the Source definitions and created target definitions, logical and physical designing of target tables.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations
• Stage the source data from flat files, SQL server, DB2 sources into stage tables
• Built Lookup tables to identify correlation between facilities defined by different administrative departments
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations
• Extensively used Row Generation, History Preserving, Key Generation, Query, SQL, Merge, Case, Validation transforms to transform the data for loading into the warehouse tables.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and Data profiling process
• Captured changes in data using slowly changing dimension logic.
• As a part of optimization used MAP operations to route update and insert records in the warehouse. Created the necessary indexes and Implemented incremental load process
• As a part of QA testing, worked with the report developers and the Data modeler to test the ETL process to populate the dashboard successfully.
• Batch jobs configuration and set repository schedules using Data Integrator Management console/Job Scheduling Console
• Designed the Universes using Business Objects Designer Module and created number of standard reports and queries based on the existing classes/objects.

Environment: Data Services 12.2, ECC 6.0, BO XI 3.1, MS SQL Server 2008.

Confidential— Princeton, NJ Sept’ 07 to June’10SAP Data Integrator and BO Consultant involved in Implementation & Production support Project in SCM, FI Modules.
Responsibilities:

• Implemented the full life cycle Project of Integrating the functional area HR, SCM with BI, Responsible for Interacted with end users and project business sponsors to gathered business requirements, Performed GAP analysis, Prepared the Technical spec, Design of data models, comparing the model with delivered contents and Implementing the business logic with delivered contents along with modifications, Extracting the data, Transport the BI objects and resolving the issues on variance analysis and reporting.
• Experience with Data Services Standard Rapid Marts for purchasing & Inventory data extraction from ECC 6.0 to SQL Server 2008 database for PR-IA project and custom built ETL processes for Supply Network Collaboration (SNC) project.
• Resolve issues with prevailing with the Standard Rapid Marts like Inventory History, Inventory back-posting for PR & IA (Purchasing and Inventory), refresh gaps caused because of failures, refresh dependency of different rapid marts into Global Data Warehouse.
• Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
• Utilized several transformations in ETL jobs developed using Data Integrator including Date Generation, Effective Date, Table Comparison, History Preservation, SQL, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
• Extensively used lookup and lookup functions to perform database lookups.
• Involved in writing the High-level and Detail-level documentation of the project.
• Created standard and ad-hoc Webi reports for using BO Universe.
• Created varieties of reports like crosstab reports, master detail reports and charts.
• Customized few audit reports that provides information about the report usage and the user information.
• Tuned the performance at Universe, report and database level.
• Tested reports for performance, data correctness and layout when exported to excel.
• Participate in developing best practices data warehouse standards for production support environment

Environment: Data Services 12.2, ECC 6.0, BO XI 3.1, MS SQL Server 2008.

Confidential— North Brook, IL,Sept’ 05 to Sept’07 Sr. SAP BW ABAP Consultant involved in Implementation & Production support Project in FI, SD Modules.Responsibilities:

• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Developed basic cubes and Multi providers for Premium’s, Claim’s, and Sales data.
• Created datamodel for FI and CCA installing datasources and Infocubes in General Ledger New (GL) and Cost Center Accounting. Extracted transaction figures and line items.
• Developed Infospokes on Premium and Claims Cubes to extract the data so as to correct the data in production system.
• Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding InfoSources, ODS Objects and InfoCubes in BW.
• Extracted the Finance and Sales data (General Ledger, Special Ledgers, Consolidation, Cost Centres, Billing, Invoice, purchase, Damage, Shipment etc) of SAP R/3 into ODS and then transformed from ODS into InfoCubes after filtering the data at DSO.
• Enhanced standard extractors to fulfill the Business requirements.
• Programmed several Start routines in Transformations to meet the business requirements.
• Proficient in uploading master data and transactional data both from flat files and SAP R/3 Systems.
• Created process chains for daily data loads, Aggregates Roll up, etc. Created messages in the process chains for load failures using emails.
• Created reports like AR Aging report, G/L Balance, Actual cost Vs Budget, Trail balance, Income statement and Actual Vs Estimate report. Created multiple queries for customer overdue analysis and due date for net payment analysis.
• Worked with RRI (Report to Report interface) between ODS object and InfoCube.
• Extensively worked in transporting objects from Development to Quality and then moved to Production.

Environment: SAP BW 3.5, SAP R/3 4.7.

Confidential — USA,May’04 to Sept’05 SAP BW Consultant involved in Implementation Project in SD and MM modules.Responsibilities:

• Worked extensively on Administrative Workbench (RSA1) and customized different InfoCubes, Transfer rules, Update rules, Routines etc., according to the client requirements.
• Created Cubes, ODS and Multiproviders for the Sales and Distribution, Material Management Reporting.
• Installed and customized business content to pull information from the source system such as SAP R/3 into BW in Sales and Distribution & Material Management data.
• Involved in mapping of data source to worked with various options, which involves activating data in ODS, deleting data in change log and also updating the data in ODS to subsequent data targets.
• Developed ABAP routines at Info Package level for data manipulation and restriction.
• Developed Generic Extractors to extract virtually and R/3 data from Data base tables Views, SAP Queries.
• Prepared LIS extractor in Sales and Distribution by creating information structures and thus generating data source and configuring for Initial, Delta and Full updates.
• Customized Business Content extractors in LO customizing cockpit and also took necessary steps in converting LIS to LO data extraction.
• Extensively worked on Web Reporting, BEx Analyzer for designing the reports on Sales, Deliveries, Shipment, Purchasing, and Inventory using Conditions, Exceptions, and Variables & Structures.
• Used BEx Analyzer for enhanced the already created queries. I created Calculated Key Figures, Restricted Key Figures and Variables in the existing queries.
• Created a BW report on Sales Analysis Enquiries and a report on Daily Bookings and Shipments using company code.
• Created reports on general quotation information at sales area level, Material availability analytics back orders and Incoming orders per Calendar year and month.
• Created a new workbook to identify discrepancies between the material values as per the purchase order and the materials invoiced based on plant, vendor, and material for various periods.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.

Environment: SAP BW 3.0B, SAP R/3 4.5B

Confidential— USA,April’03 to April’04 SAP BW Consultant involved in Implementation Project in SD Module in SAP BWResponsibilities:

• Interacted with end users to gathered business requirements, at Client’s place.
• Analyzed business reporting requirements that could be satisfied by Business content InfoCubes of Sales and purchasing.
• Installed BW standard business content Sales InfoCubes and Technical Cubes. Created custom cubes on the sales overview, billing and transportion.
• Developed InfoSources and Written Routines in Update and Transfer Rules.
• Working extensively on standard and custom defined LIS and LO extractors.
• Logistics Cockpit configuration and customization for sales order overview.
• Designed Generic Extractors and Data Sources for loading transactional data into Infocube and ODS objects.
• Made enhancements according to the requirements and write ABAP routine in Transfer structure.
• Working extensively on BEX analyzer. Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Worked on creating Aggregates, Compressions, Indexes, Multi cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Used RRI to drilldown from InfoCube pre-query to detail ODS result set query.
• Involved in various tuning techniques in order to improve query performance.

Environment: SAP BW 2.1C & SAP R/3 3.1.

Confidential, April’02 to March’03 SAP ABAP Consultant involved in Implementation Project in MM Module in SAP R/3.Responsibilities:

• Missing Quantity List in MM Module, which gives the difference between Sent and Received Quantities during Stock Transfer.
• Created Report to get all the unrestricted stock of Finished Goods.
• Created a Classical Report to display a list of Purchase Requisitions with details like MRP Controller, Release Date, Unit Of Measure along with the Standard details.
• Developed an Interactive Report for Displaying Vendor Information. The Selection made in the Corresponding Vendor details, the line selected from basic list was visible and with Secondary List.
• Created different layout sets using Transaction Code SE71.Created Windows, Paragraphs, Page Windows and Company LOGOS are copied from tiff file while using the program RSTXLDMC.
• Using SAP SCRIPT Created and Modified Layout sets and the ABAP/4 Program for Sales Order Confirmation RVORDER01, Packing list RVDELNOTE AND Purchase Order MEDRUCK.
• Developed BAPI Program that Converts between Internal and External Data Format such as Currency and Amount by generating a Function Module.
• Analyzed Parameters and their names in the Function Module.

Environment: SAP R/3 3.1.

TrainingBusiness Objects Data Integrator XI 3.x : Core Concepts from SAP.
Business Objects Universe Designer XI 3.0 : Universe Design from SAP.
Business Objects Web Intelligence XI 3.0 : Report Design from SAP.