SUMMARY
11 years of IT Industry and SAP technologies experience with multiple Go-Lives, Re-Engineering and Production Support.

• SAP certifiedApplication Associate -SAPHANA1.0
• Sr SAP BW/BI consultant experience handling SAP BI/BW, SAP ECC & R/3, SAP ABAP/4, and Crystal Reports with the sound business process of CRM, SEM-BPS ,MDM & Enterprise Portal.
• Successfully implemented and involved in 7 full SDLC’s.
• Sound knowledge and experience working with SAP HANA areas such as
• Architecture
• Data Provisioning
• Modeling
• User Management Security and Authorizations
• Reporting
• Administration
• Around 3 years of experience working with Business Objects.
• Sound knowledge and experience of Business Objects 4.0/XI3 reporting tools.
• Experience working in multiple upgrades projects.
• Knowledge of Business Objects Data services for ETL Based data loads to HANA.
• SEM-BPS Transactional Cube design, Planning Area, Multi Planning Area, Planning Levels, Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, Data Slicing, ABAP,Fox Functions etc.
• Knowledge of SAP BPC and IP.
• Excellent knowledge and experience working with SAP modules such as MM (Procure-to-Pay),PM,SD(Order-to-Cash),FI-CO(AP,AR,GL,OM,CO-PA,EC-CCA,EC-PCA),QM,PLM,SRM and HR.
• Worked with CRM Sales & Marketing, Contracts modules etc
• Complete implementation and development of BW from Data Extraction through Web-Enabled Reports.
• Sound Knowledge of BW Architecture, Different data layers concepts, Data Flow Strategy with Non-SAP and SAP Source System.
• Extensively worked in application specific extractions like LIS, LO Cockpit, CO-PA and Generic Extractions.
• Worked on both - load performance tuning and reporting performance tuning by creating BW Statistics, Aggregated, Indexes and Partitioning.
• Experience working with Open-Hub service hub and spoke to send data from BW to different system across environment.
• Experience Working with BI Accelerator, WAD and Visual Composer.
• Extensively used BEx for building Queries and Workbooks.
• Involved in Data load Monitoring management & Scheduling Process Chains with supporting production issues and debugging Queries using Query Trace.Involved in Primary and secondary level production support.
• Expertise in Loads Failure handling, Special characters fix, Reloads, Missed deltas management.
• Extensive Experience working with ABAP Programming/SQL statements /FOX formulas etc.
• Involved in Migration in Post upgrade tests and validations.
• Experience conducting workshops and presentations to validate business requirements and solutions with the end user community. Developed business process documentation.
• Highly motivated team player with strong organizational, presentation and analytical skills.

Technical Skills:
SAP Skills: SAP HANA 1.0,BW 7.3/ 7.0/3.5/3.1C/3.0B, SEM-BPS, SAP ECC (6.0,5.0, 4.7, 4.6C), SAP EP,SD MM, PP, PM, QM, FI/CO, CRM and HR Modules
Reporting: BEx Explorer Analyzer, SAP WAD, Business Objects 4.0/XI3/6.0/5/0,Crystal Reports8.5
ETL: SAP BW, Informatica Power center/Powermart,
Programming: ABAP/4, C++, C, VB, SQL, PL/SQL, HTML, Java Script
RDBMS: Oracle 7.x/8.x, MSSQL 6.x/7.x, MS Access UML, Visio, DB2,
OS: Windows, Linux & UNIX, Solution Manager

Education:
Bachelors in Computer science and Engineering, INDIA
Diploma in Electronics and Communication Engineering, INDIA

PROFESSIONAL EXPERIENCE:

Lead SAP BW Consultant June 10 – Sep 12
Confidential,Oakland CA

ATLAS Project:

• Involved in Full life cycle of SAP BW implementation for International business operations.
• Worked with business users to gather requirements for Logistics and Finance modules.
• Worked with BW Functional and Technical Design Documents and coding standards for the Global roll-out and documenting these docs on SAP Solution Manager.
• Sole responsible for designing & development of OTC areas such as Sales, Deliveries and Billing.
• Designed Bex reports, Universes (Physical/Logical models) and dashboards in OBIEE.
• Sound knowledge and experience debugging queries by analyzing MDX statements.

IPlan Project (APO Implementation)

• Involved in Full life cycle implementation of Demand Planning and Supply Network Planning.
• Worked in upstream and downstream for sending data from BW to APO and APO to BW.
• Designed and developed interfaces for sending Actual data to APO for planning.
• Designed and developed Datasources to pull forecast data from APO to BW for reporting.

BW upgrade from 3.5 to 7.0

• Involved in Migration of BW system from 3.5 to 7.0.
• Validated data objects and reports after migration.
• Developed corporate memory data store objects as per LSA guidelines.
• Designed and developed data models and planning objects as part of hybrid approach.

Environment: SAP BW 7.0/3.5, Bex, OBIEE Answers.

Sr SAP BW / BPS / BO Consultant June 09 – April 10
Confidential,Benton Harbor, MI

Responsibilities:

SAP BPS:

• Worked on full Life cycle Implementation of Cost Center Accounting Budget Input Application and Admin Tool.
• Sole responsible for the design, develop and test for initial phase of delivery.
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Cost Center Accounting for budget input and Admin tool.
• Involved in design and development of Transactional InfoCubes, Planning Area, Multi Planning Area, Planning Levels, and Planning Packages, Planning folders, Manual Planning \\
• Function, User Defined and Predefined Planning Function, Data Slicing, ABAP, Fox ‘;’
• Functions etc.
• Developed Universe for Zero based budgeting Plan Vs Actual Comparision using Universe designer.
• Designed and Developed BO reports for Budget Input Application using Webi.
• Developed CCA reports such as Variance Report, Plan Vs Actual Comparison, etc
• Prepared KT and training documents for Business Users.

Environment: SAP BI 7.0, SAP ECC 6.0, SD, FI/CO, MM, BEx, BPS,BO Suite XIR3, WAD.

Sr SAP BI / BPS / BO Consultant Sep 08 – May 09
Confidential,Burbank, CA

Responsibilities:

SAP BPS/BW :

• Worked on Full Life cycle Implementation of Trailer Management Project and Enhancements to existing PLM Application to support Planners, Scheduling and DVD Production Business users.
• Involved in design and development of Transactional InfoCube, Planning Area, Multi Planning Area, Planning Levels, and Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, Data Slicing, ABAP, Fox Functions etc .
• Developed Web Interfaces using Web Application Builder and published in Enterprise Portal.
• Worked with Manual Planning Layouts and loaded profiles.
• Involved in Performance tuning of Queries by maintaining aggregates, indexes, statistics and compression on InfoCube. .
• Data Staging & Loading experience with proper data architecture best practices, info packages, delta functionality, flexible master data staging, and debugging loads using the Data Monitor
• Involved in BI -Business Objects integration to roll out new reports from Web Intelligence and Crystal reports.
• Experienced in development of Project Documentation, training materials, incorporating OSS notes and project management methodology.

Environment: SAP BI 7.0, SAP ECC 6.0, SD, FI/CO, MM, BEx, BPS, Business Objects XI R2, WAD, SRM, DMS, FICO, cProjects.

Sr SAP BI Consultant Feb 08 – July 08
Confidential,Los Angeles, CA

Responsibilities:

• Involved in Full life cycle implementation of CO-Internal Orders.
• Worked with Business users Business users, attended Workshops and analyzed business requirements for design and development of Reports and Backend Objects.
• Involved in design and development of according to the business process as part of Internal Orders Russia Development and Spend.
• Enhanced Purchasing and Controlling extractors to get custom fields .
• Developed BI 7.0 Backend Objects such as Multiproviders,Infocubes, DSO Transformations, Routines, Data Transfer Process(DTP) ,Infopackages,Process chains etc
• Modified existing reports to go additional new functionality to end users.
• Involved in Modifying the existing Data Availability Report to facilitate new 7.0 Objects.
• Took the pro-active approach to manage additional responsibilities to handle the SEM-BPS activities.
• Customized the flat file uploads for budgeting and planning process (forecasting & budgeting).
• Worked with Transactional InfoCube, Planning Area, Multi Planning Area, Planning Levels, and Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, Data Slicing, ABAP, Fox Functions etc .
• Developed Manual Planning layouts,Fox formulas and Global Planning Sequences.
• Involved in Post upgrade tests and validations.
• Worked on Web Application Designer and published reports on web.
• Modified existing WAD Templates to fit to requirements of User.
• Involved in customizing web templates to add multiple tabs.
• Query development using the BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
• Data Staging & Loading - experience with proper data architecture best practices, info packages, delta functionality, flexible master data staging, and debugging loads using the Data Monitor
• Involved in Workshops of BIA and Real time Data Acquisition (RDA) and contributed towards new projects.
• Experienced in development of Project Documentation, training materials, requirement gathering, incorporating OSS notes and project management methodology

Environment: SAP BI 7.0, SAP ECC 6.0, SD, FI/CO, MM, BEx, BPS, WAD, Mercury Quality Center.

SAP BI Consultant Oct 07 – Feb 08
Confidential,Newtown Square, PA

Responsibilities:

• Interacted with CRM Sales and Marketing and Sales Business users, attended Workshops and analyzed business requirements for design and development of Pipeline reporting.
• Worked with SAP AG center of excellence team in implementation of BIA.
• Retrofitted Leads/Opportunities Pipeline reporting data warehouse (Infoprovider) is in process to meet AE Analysis report requirement.
• Involved in design and development of Pipeline reporting according to the business process as part of FKOM and Post FKOM.
• Improved Reporting performance for FKOM reports based on analyzing BI statistics as part of Performance tuning.
• Worked in Performance testing of Web templates with BIA and without BIA to calculate Performance increase.
• Worked on Performance Optimization of CRM reports based on the analysis after implementation of BI Accelerators.
• Modified existing reports to go additional new functionality to end users.
• Worked on development of Offline Portal for Users.
• Worked on Performance Optimization of Pipeline Coverage and Pipeline Visibility reports based on the analysis of BI statistics after implementation of BI Accelerators.
• Also implemented Pre-Calculation of queries using Information Broadcaster, where BI Accelerator doesn’t improve the performance.
• Created Iviews for Pipeline reports to Integrate with for Enterprise Portal to publish reports for users.
• Worked on Web Application Designer and published reports on web.
• Modified existing WAD Templates to fit to requirements of User.
• Involved in customizing web templates to add multiple tabs.
• Query development using the BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.

Environment: SAP BI 7.0 / 3.5, SAP BPS,SAP ECC 6.0, Business Objects 6.0,SD,CRM and FI/CO, HR,EP, BEx, WAD.

Sr SAP BI HCM Consultant Feb ‘07 – Oct 07
Confidential,Irvine, CA

Responsibilities:

• Involved in Requirements Gathering to Go-Live operations for current METRO SAP BI Global Implementation for reporting across Multiple sites.
• Involved in Complete Life cycle Implementation in the areas of SAP HCM..
• Interacted with Business users, attended Workshops and analyzed business requirements for design and retrofit according to new business process.
• Involved in Post upgrade tests and validations.
• Designed BW Functional and Technical Design Documents and coding standards for the Global roll-out and documented.
• Sole responsible for designing METRO Retrofit project requirements such as Staffing, Finance and accounting(F&A) etc
• Involved in Customized Master data such as 0EMPLOYEE and 0POSITION to meet end user requirements.
• Retrofitted Existing Staffing report to fit the new business process based on end user requirement.

Extensively worked on METRO front-end, which involved using BEx Analyzer, Report Designer, BEx Broadcaster, and Multiple queries in the workbooks, Exceptions, Conditions, Jump Targets (RRI), Customer Exit Variables, and Hierarchies.
Customized workbooks using VBA to meet end User requirement.
Worked Closely with Basis to Install BI Java Stack and ABAP Stack and tested post installation.
Worked on Web Application Designer for creating Custom Web Templates and customized templates for Print Settings etc.ing reports
Extensively involved in Cut-Over activities and transport of objects and validating in Production system.
Environment: SAP BI 7.0, SAP ECC 5.0, EP 6.0, FICO, HR ABAP/4, Windows, BEx, WAD.

Lead SAP BW/CRM Consultant Sep 05 –Jan 07
Confidential,Boston, MA
Responsibilities:

• SAP BW Consultant involved in Supply chain Requirements Gathering to Go-Live operations for current OP-238 SAP BI Global Implementation across the globe.
• Designing BW Functional and Technical Design Documents and coding standards for the Global roll-out and documenting these docs on SAP Solution Manager.
• Sole responsible for designing & developing Sales, Procurement , CRM ,Inventory Management ,FI New GL Info Providers and Inventory on Hand, Cycle Counts and Inventory Overview reports, APO Demand Planning and Supply Network planning etc
• Created complex ODS objects(staged 3 diff layers) and loaded data into ODS for data staging in BW
• Created and activated Communication Structure, Transfer Structure, Transfer Routine, Update Rules (both ODS and Info Cube level).
• Developed Start Routines, Update Routines and Transfer Routines using ABAP/4 and debugged the Update rules and Transfer rules.
• Actively involved in Data extraction from ECC DataSources and through Flat Files. Developed Generic extractors and developed specifications for custom extractors.
• Designed and build Custom InfoCubes and designed loading scenarios for Full load and delta loading.
• Worked with Open Hub service to send data to different systems.
• All Client reports are rolled out in Business Objects and Moduslink Internal reports in Bex/WAD
• Installed and configured Business Objects Enterprise suite 6.5.1/XI in Development Environment
• Designed Universes for Client Sales Orders, Inventory Summary etc.
• Created joins, indicating cardinalities, checked integrity of the universe.
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
• Conducting weekly status update from Off-shore teams located at Singapore and India.
• Created documentation on Business Explorer and Reporting for the End User.

Environment: SAP BW 3.5,SAP BPS, SAP ECC,SD,MM,PP,FICO,QM,APO,Business Objects 6.0, ABAP/4, Windows, MS SQL Server, Bex.

Sr SAP BW Consultant Oct 04 – Sep 05
Confidential,Columbus, OH

Responsibilities:

• Analyzed France-Secondary Sales requirements and translated them into Multi-Dimensional Data Models to Star Schema.
• Involved in the full life cycle Implementation using ASAP methodology.
• Activated Business Content Info Sources, InfoCubes, Roles, Queries, and InfoObjects and customized Business Content to meet business requirements.
• Created Custom sales Infocube for loading France secondary and primary sales data for high olap reporting to meet the end user query requirement.
• Created ODS for Billing data to load from 2lis_13_vditm Item level and 2lis13_vdhdr header data.
• Extensively worked in extractions, LO-Cockpit extraction using queue update.
• Worked extensively with Business Content for modified existing Sales and MM InfoCubes.
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support.
• Worked on Web Application Designer and published reports on web.

Environment: SAP BW 3.5/3.1C, SAP R/3 4.6C, SD, MM, HR and FI/CO, BEx, WAD.

SAP BW Consultant Jan 03 – Oct 04 Confidential,Boston, MA

Responsibilities:

• Analyzed business requirements and translated them into Multi-Dimensional Data Models to Star Schema
• Involved in the full life cycle Implementation using ASAP methodology.
• Activated Business Content InfoSources, InfoCubes, Roles, Queries, and InfoObjects and customized Business Content to meet business requirements.
• Worked on Business Content InfoCubes of FI/CO and enhanced with specific requirement to the client’s Business process.
• Extensively worked in extractions, LO-Cockpit extraction using V3 update.

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, MM and FI/CO, Crystal Reports 8.5

SAP BW/ABAP Consultant Feb’01 – Nov’02 Confidential,MI

Responsibilities:

• Gather business-reporting requirements and develop data modeling using Star schema methodology.
• Analyzed and configured InfoObjects, InfoCubes, InfoSources and Source Systems within the Administrator Workbench.
• Extensively worked with LIS Extractions.
• Created ODS and Cube for General Ledger, Accounts Payable and Receivable.
• Used update rules and made enhancements to transaction data using ABAP/4 routines.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate analysis in a drill down or summarized way to give detailed levels of information
• Involved in Full life cycle implementation of Demand Planning and Supply Network Planning.
• Worked in upstream and downstream for sending data from BW to APO and APO to BW.
• Designed and developed interfaces for sending Actual data to APO for planning.
• Designed and developed Datasources to pull forecast data from APO to BW for reporting.

Environment: SAP R/3 4.5B, ABAP/4 (SD, MM, FI/CO), Oracle 8i, Windows NT/2000.

Confidential,INDIA Mar 99 – Dec 99 Oracle Developer

Responsibilities:
The primary job is to keep track of all the telecom stations data in the database. A change in a particular station must reflect in all the stations Servers. The server must be configured systematically and daily backups should be maintained.
Environment: Oracle Forms 4.5, HTML, and Reports.