Professional summary

• Over 11 Years of experience in SAP, which includes 10 Years of functional and technical experience in customization and implementation of SAP BI including 1 year of ABAP programming experience.
• Implemented 4 complete Lifecycle projects including requirement gathering, data modeling, extractions, data staging, loadings, 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 BI, SD, MM & FI modules of SAP to meets business requirements.
• Experience in Integration SAP suite of BI products with Business Objects including BI 7.0, Business Objects XI 4.0 & 3.1, Crystal Reports, Business Objects Data Services 4.0 (Rapid marts) and SAP Integration Kit.
• Activated the standard business content to meet the customer’s requirement in gathering the Event management data to BW.
• Compare and contrast SAP BW and SAP Rapid marts/SQL server architectures to created enterprise data warehouse.
• Experience in Building and enhancing BI objects that include InfoObjects, Data Sources, Transformations, DTP, DSO, InfoCubes,Multi-providers, Info set and Open Hub.
• Extracted data form HR Employee, Payroll, Personnel Administration, Organizational Management, Time Management and Employee Interaction Center (EIC) to BI by using standard/custom extractors.
• Extracted data from Logistics (SD, MM) using LIS and LO-Cockpit, Finance data using FI/CO standard extractors, CO-PA and Generic Data Sources and customized Extractor to include custom defined fields and populated those fields using customer exits before the setup.
• Experienced in Report Generation – Worked extensively in BEx Analyzer, Web Application Designer (WAD), Visual Composer, Business Objects Explorer, Web Intelligence, Xcelsius, and Crystal Reports.
• Acquainted with modeling and maintenance of Events and Process Chains. Created and executed process chains to load the data into the InfoCubes and DSO and monitored the process chains for daily, weekly and monthly schedule of loads.
• Improved the performance of Queries by maintaining Aggregates, Compression, and Partition, indexing of InfoCubes and use of Statistics for the same.
• Extensively worked on transporting all kinds of BI objects from Development system to Testing system and Production systems.
• Maintained security requirements, including creation of new roles and/or addition to existing for a given line of business.
• 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.
• Good experience in ABAP/4 Reports, BDC, Scripts, Smart forms, ALV Grid, IDOC and ALE.
• Strong analytical skills, enabling to quickly understand the drivers of a business process.

Education

• M.Tech in Thermal Sciences during 2000 -2002

Key Skills

ERP : SAP ECC 6.0, R/3 4.7 4.6C/ 4.6B/ 4.5B.
Data Warehouse : SAP BI 7.0, SAP BW 3.5, 3.1C, 3.0B and 2.1C.
Reporting Tools : BEx Reporting, WAD, Visual Composer, Enterprise Portal.
Business Objects : BO 4.0, XI 3.1,Universe Design, Data Services 4.0, 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, MI Jan’12 to Till date
Sr. SAP BI, BO & Data Services Lead Consultant involved in Implementation in MM module.
Responsibilities:

• Interacted with the end users and getting the requirements, preparing the technical specification and GAP analysis for Purchasing and Inventory data.
• Activated the standard business content BW Objects and extensively carried out LO extractors

and enhanced the same to extract data into BI.

• Created Generic Data Source using the database view for Purchasing and Inventory data which is not satisfies in the standard extractors for the business needs.
• Created the InfoObjects, DSO’s, InfoCubes, MultiProviders, InfoPackages, InfoSources, Openhubs for Purchasing and Inventory modules.
• Transformations/Update Rules, Aggregates, Process Chains and User Exits
• Extracted the SAP to BW by using the SAP Standard extractors and Non SAP Legacy data to BW

using Data Services and DB connect source 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 Start routine, End routine and Field routines for the Purchasing and Inventory data.
• Created the Process chain for transactional data and master data for daily, weekly and monthly loads for automate the loading process.
• Enhanced the standard extractors with user exists to add the fields and get into the BW.
• 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 Business Objects Webi and Crystal.
Environment: SAP BI 7.0, ECC 6.0, BO 4.0, Data Services 12.2, MS SQL Server 2008

Confidential, NJ June’ 11 to Jan’12

Sr. SAP BI, BO & Data Services Lead Consultant involved in Implementation in SD & SCM modules.
Responsibilities:

• Implemented the full life cycle Project of Integration the functional are SD, SCM with BW, 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.
• Extracted the data from the SAP ECC 6.0, to SAP BI 7.0 system and build the custom ETL data flows, work flows and calculated key measures.
• Involved in the designing and designing in the Procure to Pay and Forecast to Stock modules to fulfill the clients’ requirements.
• Extracting the SAP SD, SCM data into the SAP BI 7.0 by using the SAP delivered business content and standard extractors and created the custom ABAP code in the Start, End and Field routines.
• Activated the standard business content BW Objects and extensively carried out LO extractors and enhanced the same to extract data into BI.
• Designed the universes on BI InfoCubes and queries for analysis in Business Objects by using Web Intelligence and Crystal reports.
• Loaded the Point of Sales data into the Data Services and cleansing the applying the data quality techniques for the Business object reporting.
• 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.
• 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: SAP BI 7.0, ECC 6.0, BO XI 3.1, Data Services 12.2, MS SQL Server 2008.

Confidential, IN

June’ 10 to May’11

Sr. SAP BI/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.
Implemented Employee Interaction Center (EIC) is the new implementation in the HR for Employee Call center application for Employee Activities, Employee participants, Survey information, Category allegation, Primary outcome, Priority levels and Resolution data in BI.
Extensively experience with the Employee all infotypes for personnel data, organizational data and employee salary information.
Created generic extractors to get all benefit interface programs to correctly process adds, drops and continuation of benefits coverage. Complete rewrite of multiple benefit interface changes to BI and created start routines, end routines to populating the employee group, employee subgroup, System Id and Global ID fields according to user requirements.
Created the reports on Global Head counts based on the future date, Employee Personnel Actions, Payroll information, General employee information in BI and Business Objects.
Experience with Data Services Standard Rapid Marts for purchasing data extraction from ECC 6.0 to SQL Server 2008 database for GBIP-SCM project and custom built ETL processes for Demand Planning and Supply Network planning projects.
Extracted the Employee personnel, basic and salary information data with Data Services HR Rapid Marts from ECC 6.0 to SQL Server for GBIP-HR project for Business objects reporting.
Created Crystal reports for HRDC Employee View report it is intended to be a one-page report per employee, it lists data required by an HR Data regarding an employee. It includes Employment information, Personal Information, Organizational Information and Compensation Information.
Created the Universes on Staffing assignments - Active Positions and Staffing assignments – Planned Positions in HR Organizational Management module for reporting in the Business Objects.
Created the Webi repots for the Employee tax income, package, allowances, split and base information from the MS Access and Oracle 10g databases through Universe by understanding the VBA code and convert to BO reports.
Created the Universe on the Top of BI Infocubes, Queries for Purchase order release dates calculation, Material movements daily snap shot and daily Inventory calc Webi reports in BO.
Created Business Objects Webi reports on Global Relocation Information Infoprovider will contain relocation information for the global employee population. This will be used audit the files transmitted from SAD to GMAC.
Created the Xcelsius dash board for the Employee information, Spend by vendor and Purchase order data accessing through Live Office, Crystal reports and SAP BI query.
Extensively worked on creating the Trouble tickets and CR in Remedy, maintaining the documentation in Solution Manager and releasing and approving the transports in Realtech Transport Management systems.
Worked closely with the SAP BASIS team, Scheduler Team, Security Team for the data transfer, cleansing, Business Logic implementation and loading into BI.

• Environment: SAP BI 7.0, ECC 6.0, BO XI 3.1, Data Services 12.2 and Crystal Reports 2008.

Confidential, NJ Sept’ 07 to June’10

Sept’ 07 to Till date

Sr. SAP BI/BO Consultant involved in Implementation & Production support Project in MM, FI Modules.
Responsibilities:

Implemented the full life cycle Project of Integrating the functional area HR, MM 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.
Estimated the required memory in the R/3 as well as in BI by Quick Seizer.
Activated the standard business content BW Objects and extensively carried out LO extractors and enhanced the same to extract data into BI.
Created Generic Data Source using the database view for Employee data which is not satisfies in the standard extractors for the business needs.
By using CO-PA data source extracted the FI data for the relevant Operating Concerns for Customer forecasting, accruals and rebate calculations in SPD (Special Products) project.
Installed the Integration kit (imported the cofiles & data transports into SAP) for BO XI products integration with SAP R/3 and BI.
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, Inventory and SNC 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 reports.
Done the POC on Business Objects Explorer for Purchasing & Inventory report analysis.
Designed and developed process chains for master data loads and transaction data loads, hierarchy loading and exporting data to flat file with InfoSpoke.
Created all custom reports with BEx, WAD (Web Application Designer), Visual Composer and exported all the reports into the Enterprise Portal.
In International subs project, successfully implemented request active mechanism in BCS Transactional cube within 50,000 records for user reporting.
Involved extensively to improve the Customer Profitability by including components volume, complexity and order fulfillment in Specialty Product Division (SPD) project.
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.

• Environment: SAP BI 7.0, ECC 6.0, SAP BI SAP BW 3.5, SAP R/3 4.7, BO XI 3.1, Data Services 12.2

Confidential — North Brook, IL

Sept’ 05 to Sept’07

Sr. SAP BW 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

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.
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 BW

Responsibilities:

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.
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 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.

Training

Business 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.