SUMMARY

• SAP BW, HANA, BO Techno Functional consultant with over 11 years of experience in the design, development, implementation, and support of business systems;
• Strong experience in Native HANA and BW on HANA involving data modeling, data provisioning and reporting areas;
• Strong knowledge in integrating BW with SAP SCM, XI, EP and SAP ECC modules like HR, FI, SD & MM;
• Implemented SAP BW projects including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, UAT, Training Documentation and end user training;
• As a BW Architect, experience in BI 7.0, BW 7.3, BW 7.4 End to End implementation & production support projects involving ASAP Methodology and expertise in optimizing the design of LSA core layers and moving to LSA++ for BW on HANA landscapes;
• Experience in modeling BW on HANA objects like Advanced DSOs (ADSO), Open ODS View, Composite Providers and HANA Analysis Processes (HAP);
• Expertise in designing solutions involving SAP HANA models in BW & BW models in HANA and provided solutions for Mixed Scenarios reporting for EDW on HANA Implementation projects;
• SAP HANA Modeling of Attribute Views, Analytic Views, Calculation Views, Procedures, Decision Tables, Package & Schemas and Analytic Privileges;
• Sound techno - functional skills in SAP BW with regards to OTC and P2P modules
• Experience in SAP BW Data modeling of InfoCube,MultiProvider, Virtual Provider, Transient Provider, Composite Provider,DSO, InfoObjects, SPO, Datasource, Transformation & DTP, Process Chains, Open Hub Destination (OHD) and APD;
• Designed and developed queries for reporting using BEx Analyzer, Query Designer, and Web Application Designer and extensively worked in BEx Reporting of Selections, Formulas, RKF, CKF, Variables, Processing Types, Conditions, Exceptions, RRI & BEx Broadcasting;
• Experience in SAP ABAP customizations for SAP BW Standard Datasource enhancements, Function module based Generic Datasource and develop complex data extraction logic;
• Extensively involved in Data load & Report Performancetuning Techniques and handled daily data loads, data load failures, Performance issues, BIA issues, reporting issues, and resource bottleneck issues;
• Experience on replicating real-time data from different SAP sources to SAP HANA using Data Services, SAP LT replication server (SLT), Direct Extractor Connection (DXC) and Smart Data Access (SDA);
• Experience in native HANA EDW modeling including design, modeling, data provisioning and SQL Script development;
• Experience in building complex Scripting Calculation Views and using them within Graphical Calculation Views and vice versa;
• Experience in Implementing Planning scenarios using Integrated Planning (BW - IP);
• Expertise in designing solutions for reporting requirements through Business Objects Universe Designer Tool (UDT), Information Designer Tool (IDT), Web Intelligence, Crystal Reports, Explorer, Analysis for OLAP and administration of Business Objects system;
• Involved in extraction of planning data from APO-DP Planning Areas and APO-SNP Live Cache to BW and also providing master and transactional data required for APO-DP/SNP Optimizer process;
• Expertise in implementing SAP OSS notes;
• Knowledge on setting up communication paths between servers with the use of ALE settings, Ports, Partner Profiles and RFC configurations;
• Member of Project Support Group for HANA, BW and Business Objects;
• Good technical, functional and organizational expertise augmented by excellent analytical, communication, problem-solving and interpersonal skills
• Strong Lead skills for onshore and offshore model.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

HANA Database

Roles & Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Reporting, Testing, Go-live and Post Go-live support.
• Understanding client’s business requirements. Mapping these requirements with AAES processes and implementing them into SAP and providing periodic metrics reports to senior management.
• Co-ordinate with offshore team to get action items, prioritize and update the current status of ongoing developments.
• Lead the technical team to complete the objects as per timeline. Support the team in defining the Test Scenarios and test scripts for the integration testing
• Extensively worked on SAP ECC as a source systems.
• Report development on integration experience with FICO and PM.
• Understanding the business challenges and translating them into requirements and developed Analytics Reporting according to Business Requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Time dependent master data, ADSO, ODS View, Composite Providers and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Activation of the Business Content objects and customizing them as per the client requirement.
• Created many complex and customized BEx reports for specific business requirements
• Balance Sheet Account Analysis
• WBS Element/Internal Order Capital Report Unallocated
• Income Statement Account Analysis Allocated
• Income Statement Account Analysis unallocated
• Affiliate Report
• Regulatory Report PM
• Scheduling Aggregation Report
• Scheduling Baseline report
• Click to BW interface report
• Supervisor non-field time
• Actual hours/ task or property unit
• Wrench time Report
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers and Open Hub.
• Written ABAP code for Data source enhancement, Start Routine, End Routine, Field level Routine and user exits.
• Created Technical specifications and standard modeling documents for HANA.
• Creation of the HANA expert scripts for BW data flow with HANA execution DTP
• Created Attribute, Analytical and Calculated views as per the requirement needs in HANA Modular in HANA studio
• Attribute Views for
• WBS (Work Breakdown Structure) Element Master Data
• G/L Account Master (Chart of Accounts)
• G/L Account Master Record (Chart of Accounts: Description)
• Cost Elements (Data Dependent on Chart of Accounts)
• Fiscal Year Variants
• Analytical View for
• Accounting Document Segment
• Accounting Document Header
• General Ledger: Actual Line Items
• CO Object: Line Items (by Period)
• CO Object: Cost Totals for External Postings
• CO Object: Cost Totals for Internal Postings
• Paths per account, sender and receiver
• Documents per sender and account
• Calculation View
• GL Line Item and Balance
• Cost Unallocated Data
• Scheduling Aggregation Report
• Scheduling Baseline report
• Created procedures in HANA Database.
• Worked with the IT team to bring in the data required into Business Objects Universe (OLAP and Relational) so as to make available for super users to create Adhoc reports
• Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements. Complex Webi reports include Slice and Dice, Drill down, Cross Tab, Master Detail and Formulae’s etc.
• Webi /Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Involved in Performance Tuning of reports by eliminating the unwanted variables/formulas from report, SQL tuning, Universe Design Tuning, Using Hyperlinks / Open Docs, and /or by using Multiple Data Providers etc as needed based on detailed analysis.
• Built Webi reports against multiple data sources which include Relational /OLAP Universe and also BICS Connection.
• Involved in Support and Monitoring activities after go-live.
• Involved in BO Webi Report testing and supported the users to understanding the report functionality.

Confidential

Responsibilities:

• BI/IP Lead the Solution for Change requests and Support
• Creation of Business blue prints, Functional Specification and Technical Specifications
• Involved in 2 full life cycle implementation, which includes Analysis, Requirements gathering, Development, Reporting, Testing, Go-live and Post Go-live support.
• Extensively worked on SAP ECC as a source systems
• Report development on integration experience with FICO, SD, HR, SRM, MM and Revenue flow (Aggregation Engine).
• Ownership of maintenance plan and support for a cross-function component SAP BI/BW.
• Participate in creating IT development roadmap in close cooperation with SAP Architect
• Provide expertise in SAP BI/BW areas in daily maintenance and support operations for FICO, HR, SRM SD and, MM/Procurement.
• Proactively propose and drive areas for operational improvements to better fit to current user needs in different business areas.
• Support vendor and Delivery Service Managers in incident resolution in unplanned service breaks and resulting Problem Management by providing technical expertise.
• Support Delivery Service Managers and Business Relationship Managers/ Business Consultants in correct stakeholder communication.
• Participate as area expert in meetings with users and suppliers, where needed.
• Ensure that area deliveries are included in Service Transition and Operation processes.
• Understand the BO solution in place and support the solution.
• Travelled to Sweden and Finland at Client place to gather new requirements and project deployments
• Experience on MM Purchasing Data sources 2LIS 02 ITM, 2LIS 02 SGR, 2LIS 02 CGR, 2LIS 02 SCN, 2LIS 03 BF,2LIS 03 BX,2LIS 03 UM
• Trained in HANA and submitted proof of concept to the client.
• Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.
• Supported Forecast and Budget cycles
• Created and Supported Head count, Revue, COPEX and Cost report layouts
• Written ABAP code for Data source enhancement, Start Routine, End Routine, Field level Routine and user exits.
• Created and supported very complex and medium BEx Reports for FICO, SD and SRM Modules.
• Created Wbi Reports for Monthly and Daily Headcount, Holiday Report, Travel and Expenses, Internal Mobility and Number of Management positions
• Involved in Performance Tuning of reports by eliminating the unwanted variables/formulas from report, SQL tuning, Universe Design Tuning, Using Hyperlinks / Open Docs, and /or by using Multiple Data Providers etc as needed based on detailed analysis.
• Good experience in BWA.
• Lead and involved for Data volume Management project and BW system upgrade from 7.0 to 7.3
• Involved in ECC EHP6 upgrade project.

Confidential

Information Technology Services

Responsibilities:

• Involved in 3 full life cycle implementation, which includes Analysis, Requirements gathering, Development, Reporting, Testing, Go-live and Post Go-live support.
• Developed ZCRM O01 Co 100 Labor Costs ODS and ZCRM O05 SIMIS ODS
• Developed ZCRM C04C Opportunities and cost cube
• Created Generic Data source for Master Data at Source System and loaded Master data
• Extracted data from CRM sales Module like Opportunity header Data sources.
• Created 100M pipeline BEx and WAD Report: This report displays all $100M+ opportunities in the Pipeline with a RFP date and/or award date in the current calendar month through 18 months into the future. Total Value (in millions) is contained in the cell corresponding to the calendar month in which the award date falls. Corporate BD and Groups use this report to manage the high dollar opportunities and to plan for milestone dates.
• Created Top 15 opportunities BEx and WAD Report: This report displays the top 15 opportunities based on Total Value within the selected organization level. Various organizations use this report to manage their large revenue opportunities
• Designed and Developed Orphaned task order BEx and WAD Report: This report displays all lead opportunities that are Task Orders with a missing IDIQ Vehicle Number. Corporate and line organizations use this report to improve the quality of their data by ensuring that all Task Orders are associated with and existing IDIQ vehicle.
• Created Aging Pipeline BEx and WAD Report: The Aging Pipeline by Partner Function report allows users to display opportunities in the Pipeline Statuses (Qualification, Pursuit, Capture, Proposal, Submitted, FPR and In Protest). The users must indicate a numeric value in the Days in Current Status variable. This is used to calculate the date differential between today’s date and the number of days indicated. All opportunities with a Status since Date before the calculated date will be displayed.
• Created IDIQ Task Order BEx and WAD Report: The IDIQ Task Order report allows Contract Vehicle report allows users to display all CRM opportunities linked to one or more contract vehicles.
• Involved in Creation of Infoset for developing Competitor Report
• Developed Report - Report interface
• Provided authorizations and roles for the queries.
• To improve the new query performance of Dashboard Reports have created APD
• Created Direct Update DSO and Loaded DSO from Report
• Created Cube and Updated from DSO
• Created Process Chain for APD and Loaded Data to cube on daily Basis
• With Open Hub service the info cube and ODS data collected into Flat file and sent it to application directory(use data from the BW system for external tool)
• Enhanced different existing queries.
• Written Update routines, Transfer routines and Customer Exits.
• Created Web Templates (WAD) for the reports.
• Used Tables, Navigational blocks and Text Blocks.
• Written HTML and Java Script coding for Print Excel Functionality.
• Developed different charts like Bar, Pi, Cone etc.
• Created and Schedule the daily Transactional data Process chain, Master data Process chain, Monthly Text Process chain, Snapshot Period end process chain and BI Statistic Process chain
• Prepared Unit test documents, Regression test procedures and user manual Guides.
• Involved in the Upgrade project(From BW 3.X to BI 7)
• Resolved many critical issues in the upgrade stages.
• Have completed successfully all the tests carried out relevant to the Up gradation.
• Coordinated with Onsite BASIS team and resolved many issues.
• Implemented new BI statistics for SAP BI7 System
• Deployed two Projects and worked as a Configuration Manager (Quality)