SUMMARY:

• SAP BW, HANA Techno - functional Consultant with more than 10 years’ experience in SAP BW/BO & HANA in Pharmaceutical, Energy, Manufacturing, Telecommunications, Electronics, and Service industries. Including BPC, BCS, IP/BPS, ABAP, BI security, HANA etc.
• Hands on experience on SAP Native HANA, Modeling Attribute view, Analytic view and Calculation view using SAP HANA, Data provisioning using SLT, DXC, BODS; Reporting using BW and BO.
• Hands on experience on BW on HANA, migration from BW to BW on HANA, Creating HANA optimized infoproviders, reporting on HANA views, etc.
• SAP BW development- having experience with Three Full Life Cycle implementations using ASAP methodology that includes gathering business requirements analyzing the business process, identifying & analyzing the gaps, designing, implementation, customization, configuration, Go-Live and Post Go-Live support
• Good experience in Extraction from SAP R/3 to SAP BW, Modeling InfoObjects and Reporting using BEx Query Designer, Analyzer, Web Application Designer, Visual Composer. Experience with Portal, Broadcaster, Precalculation Server, BI Security and Authorizations
• Strong hands-on experience in upgrade projects from BW 3.5 to 7.4 versions.
• Well versed in SAP BO with experience in 4.0 version, Web Intelligence, Desktop Intelligence, Xcelsius, Universe Designer, Info View, CMC and CMS etc.
• BPC Infoprovider data modeling, data extraction and retraction. Data extraction using BW/Data Manager and retraction using BEx query/APD and Flat files.
• Thorough understanding of business content objects of SAP and relationship between various SAP modules (FI/CO, BCS, SD, HR, PS, PP, MM, QM, APO, CRM, SCM-BPS, PS) and their overall business processes. Experience in documenting functional, technical specifications and test cases

TECHNICAL SKILLS:

Technical Lead and Project Management experience: Planning, Costing, Budgeting, Staffing, Estimating, Organizing and working on multiple projects.

Stakeholder Management: Understanding the needs and challenges, negotiating for resolutions with stakeholders involved in projects.

Project delivery: Understanding project methodologies and life cycles, major milestones and dependencies about deliverables, preparing project documentations. Successfully delivered projects with large multinational companies.Excellent Leadership and Communication skills, supporting and encouraging positive working behavior with others.

Risk Management: Understanding and assessing project risks and its consequences, prioritizing them as per the customer and project needs.

PROFESSIONAL EXPERIENCE:

Lead SAP HANA Consultant

Confidential, Houston

• Working as Lead SAP HANA Consultant. Leading the full life cycle Native HANA (SPS12) implementation project. Involved in Architectural design, requirement gathering, and Converting Functional specs to Technical specs, Entity relationship, Development, testing, Cutover and Go-live activities.
• Modeling- Created complex graphical/scripted calculation views for domain- Simple Finance (S/4 HANA), Sales, PPM, Purchasing and Manufacturing. Created Stored procedures, Table functions and Custom tables. Strong experience in using Joins, Unions, Rank and Aggregation nodes. Creating Calculated/Restricted columns, Input parameters/Variables.
• SLT Replication- Used SLT replication cockpit and Data provisioning for replicating tables from SAP in real-time. Adding filters and transformation rules to tables using SLT cockpit. Analyzing data load statistics.
• Performance Tuning- Analyzing Calculation view performance using Visualization plan, Explain plan, SQL Plan, SQL Tracing and take decisions based on the statistics, optimizing HANA views for better performance.
• Change Manager/ALM- Using Change Manager/ALM tool to create/maintain Change Id’s.
• ChaRM- Working as a ChaRM lead for HANA object migration, creating Change documents, maintaining HANA Change id’s using ALM tool and HANA studio. Migrating objects to QA and Production.

Lead SAP HANA Consultant

Confidential, San Francisco

• Worked as Lead SAP HANA Consultant.
• Involved in Requirement gathering, Functional and Technical specification design, Development and Testing
• SAP HANA implementation- Created complex Calculation views, Analytic and attribute views. SQL scripting & stored procedures using HANA.
• Created Graphical Calculation Views for OPEN ORDERS, ADJUSTED DEMANDS, and Traffic for SAS Reporting
• Created Scripted Calculation views for This Year/Last Year logic for Tableau Reporting requirements for Customer Scorecard, Prebook Orders and Shipment Tracker Dashboards.
• Used Star Schema modeling approach for View Optimizations.
• Created Composite provider on top different Billing, Order and Delivery DSOs and Flat File DSO’s.
• Used SQL and Analysis Office to analyze and test the Data of HANA Models and BW Data providers.
• Currency Conversion of KPI's in Calculation view
• Used Star Schema modeling approach for View Optimizations.
• Used SQL and Analysis Office to test the Data of HANA Models and BW Data providers.
• Data provisioning using SLT, DXC and BODS.
• SAP BW on HANA data modeling- Created Composite provider and utilized generated views of Composite provider to create Calculation views. Created Advanced DSO.

Lead SAP BW HANA Consultant

Confidential, Irvine, CA

• Working as Project lead for client Confidential (world leader in the design and manufacture of highly engineered connector solutions).
• Managing a team of 10 developers for SAP BW and HANA development and migration project. Primary point of contact for the project to interface customer with project team, Communicating status updates, leading meetings, managing project deliverables, etc.
• Interacting with business users for understanding requirements, requirement gathering, Preparing functional and technical specifications, etc.
• BW-HANA migration- Includes migration infoproviders from SAP BW to HANA. Converting BW to HANA optimized infoproviders, Building reports based on HANA views. Utilizing SAP BW 7.4 functionality for new infoproviders. Creating Attribute, Analytic and Calculation views. SQL scripting & stored procedures using HANA. Data provisioning using SLT, DXC and BODS.
• SAP BW, BO for Management reporting- Developed Finance, Sales, Production planning and Inventory reports using BEx query designer and WebI.
• SAP BW data modeling- Created infocubes, Multiprovider, DSO’s, enhanced data sources, and created transformation routines to meet custom requirements.

Sr. SAP BW HANA Consultant

Confidential, Cincinnati, OH

• Worked as an SAP BW HANA migration core team member and Application Manager for client Confidential & Gamble. Managed a team of 7.
• Performing SAP BW to HANA migration activities- Analysis, design, pre-migration and post-migration activities and testing. Converting BW infoproviders into HANA optimized infoproviers. Creating Attribute, Analytic and Calculation views. Integrating SAP HANA with SAP ECC, BW, BOBJ reporting tools using SAP SLT, Data services, DXC, etc. Creating Analytic privileges.
• The role focuses on SAP BW Application Management- SAP BW- GL, AP, AR and Supplier portal. Complete application responsibility Technical & functional.
• Interacting with users and functional consultants, understanding requirements, requirement gathering, converting functional documents to technical documents
• Developing new BW reports such as Payment services reports, Capital and Fixed asset reports, Project systems reports, Actuals/Budget/Forecast variance reports, Sales reports etc.
• The major tasks include Data Modeling, Datasource enhancements, Extraction and Reporting for Financial and logistics data.
• Extracting data from SAP and legacy systems standard and generic extractors
• Data transformation using ABAP code at extractor and transformation level to create useful data for reporting. Created transformation routines, infoobject routines, also used BADI etc for data transformation.
• Created Open hub services to export BW data to 3rd party systems.
• Utilizing new features in BW 7.3 modeling such as Hybrid providers, Partitioning, etc.

Lead SAP BW/BO Integration Lead

Confidential

• Worked as an SAP BW/BO Integration Lead for customer Merck & Co. for Asia-pacific region.
• Integrated non-SAP and SAP systems in to SAP BW system.
• SAP BW back end development: extractor enhancement, function module development, data modeling, transformation routines, user exists.
• Enhanced standard SAP extractors, developed generic extractors for Flat file, SAP, DB source systems to extract data from legacy systems in to SAP BW. Used ABAP code to transform and migrate legacy data in to SAP BW. Developed transformation routines, function modules, infoobject routines.
• BEx report development: Created reports in in Sales: Billing document, Backorder, Open delivery status, Daily Sales reports, Stock on Hand report, etc. Project Systems: Project status report, Currency variance report, Monthly/Quarterly/Yearly reports, Project System Master data report (WBS element) etc.
• BO 4.0 WebI report developments and dashboard designing, BO 3.x WebI report and Universe developments.
• Also working as an Advisory consultant for the customer on BW-on - HANA, Spotfire on HANA and BW technology for strategic planning.
• Every Angle Operations Management BI and Spotfire dashboards support and development

SAP BW BO Architect

Confidential, San Diego, CA

• Worked as a SAP BW BO Architect. Single point of contact for any issues related to BI system. Managed a team of ten.
• Gathering requirements from end users for Finance, Project systems data. Solving BEx reporting issues.
• Involved in Information Broadcaster implementation. Configuring & troubleshooting Precal server. Broadcasting BEx queries and workbooks to set of User groups.
• Developed Ad-hoc BEx queries, workbooks to satisfy User’s requirement. Worked on BEx query Designer, Analyzer, Portal etc.
• Worked actively on creating/maintaining Infcoubes, DSO, Multiproviders, Master data objects etc.
• Creating User roles and profiles. Data Loading- Past year data loading, historical data loading using Delta and Full loads. Support pack upgrades on SAP BI 7.0 system. Successfully delivered the project.

Sr. SAP BI BO Consultant

Confidential, Philadelphia, PA

• Worked as a Sr. SAP BW Consultant in Full life cycle implementation environment. Managed a team of six.
• Involved in Full Life Cycle implementation of Finance (FI) and Project Systems (PS) modules. Involved in Requirement gathering, Technical specifications design and approvals, Development, Integration Testing, Cutover activities, Go-Live and support.
• Developed following Reports for Finance: Order to Cash Report, Balancesheet report, P&L Report, Local currency report by Cost Centers, % Aging report etc.
• Project systems: Project Financial Report, Project System Status Report, Capital Currency variance Report, Project Master Data Report, Capital Pricing Approval CPA Report, Capital Project Appropriation report.
• Developed FI-GL, AR, AP datasources, Infocubes and DSO’s. Developed Project systems datasources and data targets for Actual, Budget, and Commitment values.
• Created BEx queries and SAP Business objects reports based WebI (Web Intelligence designer).
• Converted BEx queries to WebI queries, created Universes based on FI Infocubes and created Dashboards using Xcelsius. Used ABAP coding to create User exit variables and transformation routines.
• Integration of external systems to SAP BI using Open Hub destinations.
• Understanding the User requirement converting user requirement to Technical design specifications. Unit and Integration testing, creating Test scripts in HP Quality center.
• Performance tuning of the report and data loads.

Sr. SAP BI/BO Consultant

Confidential

• Worked as a Sr. SAP BI/BO Consultant in Development/production support environment
• Main responsibilities include User interaction, Requirement gathering, Analyzing issue, Prepare implementation related documents like Blueprint, Project charter, Effort estimation, Functional/Technical specifications, etc and also Development and enhancement in the existing data flow. The major supported SAP modules were SD, MM, FI, CRM, APO, HR
• Worked on FI modules GL, AP, AR, implemented FI data sources for GL account, Vendor and customer DataSources like 0FI GL 4, 0FI GL 8, 0FI AP 1, 0FI AP 4, 0FI AR 4 etc
• Worked on SD Datasources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDITM
• Worked with CRM data targets like 0MKTG C01 (CRM Leads), 0SAL DS01, 0CSAL C01 (CRM Activities), 0CRM C04 (CRM Opportunities)
• Worked on CRM reports like Top-n Won Leads, Top-n Lost Leads, Lead Analysis etc.
• Owned responsibilities for Queries and Broadcasting related issues. Created queries and workbooks using BEx Query Designer, BEx Analyzer, created interactive Web-templates using Web Application Designer WAD. Created user exit variables using ABAP to create QTD, YTD reports and for currency variance calculations.
• Worked on Business Objects (XI R3) with Desktop Intelligence, Web Intelligence, Universe Designer, Voyager, Xcelcius for creating different reports. Created reports using DeskI and WebI. Created interactive dashboards using Voyager and Xcelcius
• Involved in integration of SAP BI with Business Objects XIRel 3 with the integration kit
• Experience in Building Universes on SAP BI7.0 using BO XI REL 3 version, creating connection between BI and BO. Creating Datasources for SAP. Created Universes on SAP BI InfoCubes and other data providers to retrieve data to BO. Retrieving data using Universes, Personal data files, stored procedures and freehand SQL methods
• Worked on building and enhancing Universes, Retrieving data using Universes, Personal data files, stored procedures and freehand SQL methods
• Expertise in resolving loops by using Aliases and Contexts. Excellent knowledge in DW concepts and Architecture using fact Tables and Dimension tables. Experience in different OLTP and OLAP databases
• Involved in testing Universes and reports for correct mapping of the objects and data correctness
• Experience with Central Management Consol (CMC) and Central Management System (CMS)administration for maintaining User profiles for Authorizations, Publishing and Scheduling Reports to Users and Importing, handling security and routing request to other servers, Exporting Universes etc.
• Involved in implementing concept of Simulation of Account determination for Billing documents in R/3 and BW, involved in extractor logic creation in ABAP, data flow design in BW and data loading
• Creating Users, roles, profiles and authorization objects. Analyzing and solving Authorization related issues using RSECADMIN, RSSM, RSSMQ
• Implemented Precalculation server and Broadcaster in BW, creating Broadcaster settings and workbooks, publish it to user/portal
• Implemented successfully change of data flow for Remote cube for APO data, adding characteristics and key figures to existing data flow, changing transformation and uploading data in BW
• Batch Jobs, R/3 jobs monitoring, Monitoring Precalculation Server/Broadcaster Jobs, debugging aborted process chains, monitor logs regarding Precalculation and restart settings, etc. Starting/stopping Precal server and excel processes and BWProcess chain Monitoring.

Sr. SAP BI/BO Consultant

Confidential, San Diego, CA

• Involved in Integration of Business Objects XI R3 with SAP BI 7.0
• Created Universes on SAP FI, COPA, SDInfoCubes and other dataproviders. Created many reports and dashboards using Desktop designer, Web-Intelligence Designer Crystal Reports
• Created complex and Ad-hoc reports having features like slice and dice, Drill capabilities, complex freehand SQL queries, @Functions, Master Detail and Cross Tab tables with multiple breaks
• Published BO reports, dashboards to different users using CMC, CMC Administration, creating user profiles according to the user status, publishing and scheduling reports for daily broadcasting. Maintaining Import and Export of Universes
• Worked extensively in developing and implementing Crystal Reports/WebI on Business Objects Enterprise XI REL3, Crystal Enterprise 8.0
• Involved infull Implementation of BI for SD and FI modules.Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc
• Created Transformation mappings, DTPs, Infopackages for all above DSOs
• Enhanced following datasources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDITM, 2LIS 11 VASCL, 2LIS 01 S601, 2LIS 01 S602, 1CO PA YPH1 NEW (COPA). Created Transformation Routines, Start Routines, End Routines and Info object routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines. Creation of tables, creation of Generic datasources, Function modules in R/3 system (ECC6.0)
• Created Infopackages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side
• Created and maintained MultiProviders ZSD M01 for above Sales Distribution DSO. Maintained Characteristics and key figure assignments in the MultiProviders as per the reports requirement
• Created and maintained Master data objects. Created different Hierarchies. Created and maintained Process chains in RSPC to schedule daily loads
• Created Queries and Workbooks using BEx Designer and Analyzer for SD management like Sales Growth (MTD, QTD, YTD), Sales Products, Sale Distribution, Sales Hospitals, Sales Opportunity for Sales Representatives, Sales History, etc. Publishing queries to the Roles, Portals and broadcasting queries to Customers and Sales Representative by emails

SAP BI/BO Consultant

Confidential, St. Louis, MO

• Development and production support for SAP BI 7.0 for FI, BCS and HCM modules
• Queries - Created number of new queries in BEx Query Designer for Finance and BCS modules like Consolidated Balance sheet, Consolidated Income statement, Working capital Balance changes, Trade Account Payables, Trade Account Receivables, General Analytical tool for BCS, Selling and Administrative expenses, etc
• Worked on complex BEx Workbooks and reports using BEx Analyzer. Created interactive graphs/charts for Working capital balance changes and Days in AP and AR, etc
• Solved issues regarding Queries/workbooks. Worked with different BCS Hierarchy related issues. Extensively helped end users to get the exact query output/report to meet the management requirements. Worked several times on Query Performance Issues using Transaction code RSRT
• Created RRI Jump queries using RSBBS Tcode (Maintain Sender/Receiver Assignment) like to jump from a report to R/3 Tcode FAGLL03 (G/L Account Line Item display)
• Extensively worked on Data Validation from BI and BCS side. Used BCS Consolidation Workbench (Tcode- UCWB) for BCS data verification. Also done data validation with Third party ERP (HYPERION) with BI7.0 data
• Huge experience in Web Application Designer for creating web templates for FI, BCS, PP, QM modules.
• Frequently used Information Broadcaster for broadcasting Pre-calculated Queries/Web templates to Portal. Published FI, HCM, PP, QM, and SD Dashboards to portal. Created many I Views in EP6.0 to publish.
• Worked on General Ledger Balances Cubes (0FIGL C10), Planning Reporting cube (ZFP CRP1) Real time cube; General Ledger Transaction Figures (0FIGL O10), GL Key Figures (ZFIGL KF) with datasources 0FI GL 8 & 0FI GL 10 respectively
• Created BCSMultiproviders which contains Reporting cube and planning cubes
• SAP-HCM Migration Project: Migration of different HR cubes data flow from BW 3.5 to BI 7.0. The cube- 0PA C01 (Headcount and Personnel Actions), ZHR DLC01 (Labor Daily Costs) etc. Successfully migrated Update Rules (with Routines) and Datasources 0HR PA 0 (Employee) & 0HR PA 1 (Personnel Actions), etc
• Worked on Business Objects XI Release 2, to get data from HYPERION, BI and SAPECC

SAP BW-BPS Consultant

Confidential

• Involved in complete life cycle implementation of SAP BW 3.5 with BW-BPS
• Designed and implemented Integrated Planning, crate real-time InfoProvider for Planning
• Configuration of the BW-BPS environment which involved creating planning areas, multiplanning areas, planning levels, planning packages, planning layouts, parameter groups to support basic planning functions using fox formulas and user exits
• Defined and conducted data validation custom developed Planning folders
• Addressed several challenges inclusive of performance, data locking etc
• Creation of concept for BPS to enter PLAN data with Web Interface Builder (variable selector, dynamic data columns in layout in the web, tabs and filter, defaults for drop down list boxes)
• Gather requirements from the Core Team (users) for understanding the extraction/reporting
• Created variables for Currency Conversion Types and used variable offsets for comparing data between periods and for value ranges
• Activating the SEM-BPS related Business Content in SEM-BW, based on the requirements gathering and also the existing Cost Center Planning Reporting solution in BW
• Design BPS Planning Environment architecture with area, levels, and packages. Worked in the areas ofLabor Costs, Overheadsetc based on the requirements
• Design and Develop Fox functions for complex calculations within the layout
• Design and Develop Layouts, End User Interface (Planning Folders) and used WIB (Web Interface Builder) to build the web interface

S AP BW/ABAP Consultant

Confidential

• Full Life cycle Implementation of SAP BW 3.1C and production support.
• Understood the business process, organization structure and functional specifications after a series of requirement analysis sessions.
• Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW Loaded custom hierarchies, from flat files, to enable drill-down reporting.
• Created Master Data InfoSources for Attributes, Texts and Hierarchies.
• Managed ODS &InfoCubes objects. Worked on deleting requests, rollup of requests within ODS & Infocube.
• Populated the InfoObjects, ODS Objects and InfoCubes with Master data and Transactional data from SAP R/3 via Data Staging area (PSA).
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements