SUMMARY:

• Over 13 years of professional experience in IT industry, of which 12 years in SAP with emphasis on SAP BI, BPC, ABAP, SAP CRM, ERP and Integrated Planning projects 
• 10 years of SAP BI experience .
• Over 6 years of SAP BI Lead Architect experience in managing cross - functional team of functional consultants, developers and testers in development and deployment of modeling and analytics product to facilitate organization integration of mergers and acquisitions.
• 3 years of experience in planning models - BPS and IP.
• Collaborated with Integration management team and Business Partners to implement analytical solutions.
• Developed and Maintained standards regarding methodologies, definitions, processes, tools and technologies required to implement BI.
• Delivered $9M global BI implementation program and developed roadmap for data and business intelligence program.
• Led transformation of financial close process using BPC and reduced time close to 30%.
• Recognized as an expert in defining ETL process and data management for Budgeting and Forecasting models.
• In-depth knowledge in implementing ECC and BW on HANA.
• SAP-BI upgrade experience on multiple projects which includes both Technical and Functional upgrade.
• Experience in conducting gap analysis between business requirements and software.
• Conducted programs for users and managed client expectations by communicating project status, resolving concerns and issues.
• Involved in requirements analysis and prepared High-Level design documents, data model diagrams, technical and functional specifications.

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL.

Sr. SAP-BI/BO/HANA Architect

Responsibilities:

• Performed Blueprint design workshop sessions with high level organization and created functional and technical specifications.
• Responsible for OTC and ICM end to end BI implementation (From data acquisition to Report deliverables).
• Led offshore team and functional consultants at onsite in delivering initial end to end SAP implementation and handed over to support team.
• Configured LSA Architecture and optimized BI process for better solution.
• Led BI database space reduction by adopting to relevant storage methods (Near line storage, …)
• Extensively worked on analyzing table relationships in ERP to design data modeling in HANA.
• Extensively worked on migrating data from Non-SAP and SAP systems to HANA system using Data Services 4.0.
• Proficient in writing SQL code for calculation views. Developed complex code to determine sales compensation, cross selling in sales activity, …
• Designed and Developed Data foundation and semantic layer in IDT.
• Worked on stabilizing of applications using SAP best practice optimization techniques.
• Upgraded the system to BW 7.3 version.
• Configured business rules for sales order processing and sales rep compensation.
• Involved in Business object upgrade 4.0.
• Involved in importing extractors into the database, identifying the type of

Confidential - Draper, UT.

SAP-BI Solution Architect

Responsibilities:

• Designed Data modeling and work flow for extracting data from CRM and SAP R/3.
• Design and Implemented Customer Surveys.
• Managed data storage standards and implemented best practices for the creation and delivery of required information to end user to enrich the business.
• Reviewed technical design by team members before it get implemented .
• Design and Implemented Sales Activities, Opportunities, Price Configuration and Asset Management.
• Prepared High-Level design document, Tech specification and Gap documents.
• Involved in Code review and User acceptance testing.
• Performed end-user s for multiple rollouts.
• SAP-BI/BO Lead Architect - Business Objects Implementation Project
• Created and modified Universes as per requirements.
• Extensively worked on Universes Optimization.
• Created various Web intelligence documents with queries.
• Developed schema with tables and joins.
• Extensively worked on creating and formatting reports.
• Created WEBI reports using multiple data sources.
• Project Lead - Forklift Project
• Design and Implemented Open Hub concepts to extract data from BI system to EDW system.
• Created Project Plan and assigned tasks to the team members.
• Prepared High level design documents and delivered the project on time.
• Designed file structure to fulfill EDW system requirements.
• Provided solutions for the development issues and guided file transfer process from SAP BI system to EDW system.
• Project Lead - SAP BI Production Support
• Maintained 24/7 on call rotation in the team.
• Performed system performance improvement including Re-modeling, Re-partitioning, Extractor enhancement, Events Handling and Process Chains.
• Maintained system health using Early watch report.
• Involved in Query Optimization.
• Extensively worked on overall data load reduction time.
• Performed enhancements to existing objects.
• Assigned tasks to team members and maintained work load across the team.
• SAP-BI Solution Architect - BI Upgrade Project
• Created project plan and worked closely with Basis team to perform the upgrade BI 7.0.
• Performed pre and post upgrade activities.
• Replaced transfer and update rules by Transformation.
• Involved in creating DTP, TRFC and data sources replication.
• Performance optimization by partitioning and Clustering.

Confidential, Santa Ana, CA.

Senior SAP BI-BPS Consultant

Responsibilities:

• Designed and Implemented BI-Inventory Management.
• Extensively worked onSAP-BPS Performance improvement.
• Created multiple Fox programs for planning functions.
• BEx Reporting - Created various reports in BI-Finance and BI-MM.
• Involved in BI and BPS Production Support.

Confidential

SAP BI-IP Solution Architect

Responsibilities:

• Involved in development of Base Volume Planning, Promotional Planning, Price and Margin Planning.
• Created real time Info providers for sales forecasting which includes draft and published cubes.
• Developed various Planning layouts and Workbooks in BEx Analyzer.
• Initialized material and customer planning combinations.
• BEx Reporting - Created various sales forecasting reports including Moving Average Trend.
• Created multiple Fox programs for planning functions to calculate Standard Price, Standard Margin, Export Price, Account Bonus, Rebate and Commission.
• Involved in creation of Aggregation levels, Filters, Layouts, Character relationship, Planning functions and Planning Sequences.
• Created Extractors, DTP, Transformations, DSO, Info Cubes and Multiproviders in FI-COPA and SD modules.
• Developed Process Chains and multiple expert routines in Transformations.

Confidential, Fremont, CA.

SAP BI-IP Solution Architect

Responsibilities:

• Designed and Implemented FI-CCA, FI - PCA and HR modules.
• Created real time Info providers for Budget planning and forecasting.
• Extensively worked on Version Management for Planning.
• BEx Reporting - Created various planning budget and forecasting reports.
• Involved in creation of Aggregation levels, Filters, Layouts, Character relationship, Planning functions and Planning Sequences.
• Created Extractors, DTP, Transformations, DSO, Info Cubes and Multiproviders in -CCA, FI - PCA and HR modules.
• Created Retractors for primary cost and Internal Order planning.
• Created multiple Fox programs for planning functions.
• Developed BEx Analyzer workbooks for planning.
• Created User exist variables for BEx Reports.
• Involved in BI Transports, Security and Authorization.
• Enhanced Master and Transaction data Extractors.
• Developed Process Chains, start and end routines in Transformations.
• Created Flat File structure to upload Plan data and involved in writing routines to get desired format.
• Involved in power user, end user and troubleshooting of data quality issues.

Confidential, Federal Way, WA.

SAP BI Consultant

Responsibilities:

• Involved in Technical and Functional Upgrade
• Performed post upgrade activities.
• Created write optimized DSO and performed optimization for DSO.
• Replaced transfer and update rules by Transformation.
• Created DTP and modified Info packages.
• Involved in Remodeling Info providers.
• Performance optimization by partitioning and Clustering.

Confidential, Federal Way, WA

SAP BI Consultant

Responsibilities:

• Provided On call production support across all functional areas including PM, MM, FI-AP, COPA, FI-AR, PCA and CCA.
• Involved in enhancements to the Extractors, Info Sources, Info Objects, Transfer Rules and Update Rules, ODS and Info Cubes.
• Worked on Data Quality Management, Cube Statistics and NumberRange Buffering.
• Exposure to RSRV and RSRTRACE for BEx security trace.
• Scheduled the Process Chains by Tivoli.
• Query Optimization.
• Modified the ABAP Routines in Update rules and Transfer Rules to improve the load performance.
• Analyzed and corrected production problems as they occur in the SAP BW system.
• Extensively worked on improving load performance.
• Performed changes in the Hierarchies and Reports. Created user exits variables.

Confidential, Federal Way, WA.

SAP BW Consultant

Responsibilities:

• Extensively involved in creating Info Cubes, ODS and Multi provider in the areas of PM and MM.
• Designed and Implemented PM - Maintenance Order Headers, Cost and Allocations, Notifications and Operations.
• Designed and Implemented MM - Inventory, BOM and Purchasing.
• Business presentation to the client.
• Involved in BW 3.5 Upgrade.
• Had direct interaction with the clients and analyzed the business requirements.
• Created ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to update Key Figures in the Info Cubes.
• Developed Local specific Process Chains and Info Packages.
• Prepared High-Level design document and data model diagrams.
• Provided knowledge transfer during and end of the project.
• Performed Unit Testing and data validation between SAP R/3 and BW systems.
• Created custom extractors using function modules.
• Have worked on data selection via User Exits.
• BEx Reporting.
• Reviewed design documents to identify improvement opportunities.

Confidential, Federal Way, WA.

SAP BW Analyst

Responsibilities:

• Designed and Implemented FI-AP and FI-AR.
• Involved in data modeling for AP Line items, Spend Analysis and Supplier Diversity.
• Monitored data loads with full update and delta mechanisms for both master and transaction data.
• Written ABAP Program for BW to identify master data records that have attributes with no data on certain, specified master data attributes.
• Configured restricted key figures, variables, exceptions and calculated key figures in queries.
• Used SAP provided extractors.
• Provided knowledge transfer during and end of the project.
• Created and activated transfer rules and maintained communication structure.
• Written ABAP Program to identify all master data records that have no corresponding text records.
• Activated standard Business Content for Cubes, ODS, Info Sources, Data Sources and customized them to meet business requirements.
• Scheduled and monitored periodic data loads from SAP R/3 to BW.
• Used BEx query designer to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements.
• Developed Local specific Process Chains and Info Packages.
• Created variables for BW Queries.

Confidential

SAP BW Analyst

Responsibilities:

• Developed data modeling objects in FI-PCA and FI- CCA Modules.
• Involved in workshop and design session between business and project team.
• Extensively worked on ABAP Routines in Transfer rules and Update rules.
• Enhancements to Master data and Transaction data Extractors.
• BEx Reporting and Web Templates.
• Installed Business Content.

Confidential

SAP ABAP Consultant

Responsibilities:

• Developed BDC programs and smart scripts.
• Created several customized ABAP Programs and reports for Sales and Distribution.
• Involved in production support.