SUMMARY

• Over 14 years of IT experiences with 13 plus years of SAP experience with an exclusive 13 years of experience in SAP Business Warehouse (SAP BW) and 8 plus years in Business Intelligence (SAP BObj).
• 3 plus years of experience in SAP BW on HANA and SAP HANA modeling.
• Experienced in developing dashboards using Tableau (on top of SAP BW and HANA).
• Strong experience in End - to-End Design, Development, Enhancements, Testing, Performance Tuning, Documentation, and Production Support for Reporting and Analytical Solutions.
• Worked closely with business users and business subject matter experts (SMEs) to understand business processes and reporting requirements.
• Strong experience in developing data models inSAP HANA platform and Creation of Native HANA Views. Delivered reporting solutions using SAP HANA models for FI, SD, MM, PM.
• Experienced in data provisioning in HANA usingSDS, SLT (Real Time replication), SDA for remote data sources.
• Well versed in usingSQL script in HANA for development of both script based calculation views and stored procedures.
• Experience in creating SAP HANA information models with skillful usage of Analytical, Attribute, and Calculation Views.
• 13+ years asSAP BWconsultant with experience in developing custom data models using SAP BW object forLogistics, FI-CO, FI-AR/AP/GL, PSfunctional areas. Experience with activating and extendingSAP Business Content.Excellent experience in BW customizing.
• Extensively worked in creation of InfoObjects, DSO’s, InfoCubes, MultiProvider, InfoSets, DataSources, InfoPackages, Transformations, Transfer Rules, Update Rules, Routines, and Data Transfer Process.
• Experienced inGap Analysis,User Interaction, Requirements Gatheringand deliveringSolutions.Strong experience in setting up BW best practices,Performance Tuningto optimize overall user experience.
• Strong understanding ofSAP Configuration and Functional Knowledgeto understand user requirements. Experience in converting business requirements to functional and technical requirements and design and implement. Experienced in creating Functional Specs, Technical Specs, Test Plans, user documentation and user training documents.
• Good experience in creating Advanced DSO’s, CompositeProviders, Query in HANA Studio BW modeling tools (BWMT) and Exposed BW Objects as HANA views.
• Well versed with LO Cockpit Extractors, Generic Extractors, and FI/CO extraction methods.
• Extensively worked on Real Time replication using SAP LT (SLT) Data Provisioning method.
• Good knowledge with MM, SD, FI/CO, PP, PM, QM, CS, HR, APO-DP, and AFS solutions.
• Good experience in ABAP/4 with User Exit, Start, and End Routines.
• Experience in Open Hub (Info Spoke) to download data from InfoProviders to flat files.
• Good experience in creating APDs (Analysis Process Designer).
• Very good experience in Data Modeling, Extractions, Data Staging, Loadings, Transformations, and Reporting for Non-SAP systems data.
• Well versed with BEx components - Query Designer, Analyzer, Workbooks.
• Experience in creating Variables, Calculated Key figures, Restricted Key Figures, Filters, Structures, Selections, Cell Definitions, Exception, and Condition.
• Extensively worked on performance tuning using Indexing, Compression, Aggregates, and Partitioning.
• Extensively worked on migrating 3.x dataflows into 7.x dataflows.
• Good experience in creating Process chains to automate the loading process.
• Worked on Transports Management System and fixed if any transport issue.
• Involved in production support activities like to monitor data loads, correct data-load errors, re-run loads, research end-user issues, communicating to affected business users, and assisting with root-cause analyses for continuous improvement.
• Very good knowledge of managing Hot/Warm/Cold data in SAP BW on HANA using SAP IQ database as an Near-Line Storage (NLS) solution. experience in creating Reports, Dashboards, and Applications in Business Objects Tool suites (Dashboard Designer, Lumira (Designer and Discovery), Web Intelligence, Analysis for Office, Xcelsius (Dashboard), Crystal reports)
• Proficient in using Central Management Console. Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles
• Experience in working with BObj 4.2, 4.1, BO Enterprise, BO Edge and BO 6.5 servers.
• Experience in defining queries, generating drill-down report in Crystal Report.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Expertise in developing reports using Crystal Reports on top of SAP Cubes, Queries, DSO, Tables and Universes
• Grouping, Sectioning, Summarizing, Filtering and Slicing and Dicing were carried out efficiently in the reports developed using CR.
• Various data connection were used in Xcelsius to bring in data (QaaWS, SAP Netweaver BI connection, Webservice, XML, flash variables, Live Office and static data (excel)).

PROFESSIONAL EXPERIENCE

Confidential, Savannah, GA

HANA BI Lead Consultant

Environment: HANA (cloud), BObj 4.2 (webi, Lumira 2)

Responsibilities:

• Data modeled in HANA, developed Calculation view on core tables and used as source for Webi reports.
• Replicated tables from S4 using SLT.
• Efficiently designed model by developing many reusable calculation views and incorporated in meta views. Significantly reducing future development work.
• Model included efficient usage of Functions, Column Views, and Stored Procedures.
• 20 Financial reports were developed on Webi and on top of HANA views.
• Few standard ones like Balance Sheet (balancing Assets and Liabilities), P&L, Cash Flow, GM (by Profit Center and Cost Center)…
• Used SAP HANA View connection in webi to connect to the respective HANA view to build the report on top of it.
• Scenarios involved using two different views as source for webi reports and merged them in the report.
• Various webi functionality was used to calculate values at runtime, dynamic visibility (hide and show) on objects were employed, coupled with linking of objects.
• Groups, Sections, Breaks, and Filters were used to make a complex formatted but pleasant looking reports.
• Drill in and drill out capabilities was used where needed
• Designed and developed 2 Sales Dashboards using Lumira Designer on top of the calculation views
• Migrated HANA view and reports across the landscape.
• Trained users on webi reports with clear documentation on Technical spec and user guides for the reports.

Confidential, Faribault, MI

BW/BI Lead Consultant

Environment: SAP BW on HANA, HANA, BObj 4.2

Responsibilities:

• Worked on reporting solution implementation project using SAP HANA /BW hybrid solution. SAP BW/HANA is used to Model SD (Order to Cash), Purchasing, Production, PM, WM, COPA, and Finance modules.
• Used ODP data source to extract data from BW and eliminated the Infopackages and PSA staging.
• Created and used Generic DS (for planning data), COPA DS (for budgeting data), and Vistex DS (Billback data (/IRM/LIS RM IPBBHDR and /IRM/LIS RM IPBBITM)) along with standard DS.
• Defined and developed reports to do Sales Analysis (Daily, Monthly, YTD), Sales Revenue and Margin Analysis, Open Order Analysis (determining revenue backlog, Fulfillment), Sale Activity…
• Modeled BW for Discrete Manufacturing and consumed the data in reports thru BEx query.
• Complete modeling used HANA optimized object (Advance DSO, Composite Provider)
• Modeled and maintained Hierarchies for Material and Product.
• Replicated SAP data using ODP-SLT, and ODP-BW into BW system.
• Used SAP SLT to deliver data from ECC to HANA using SLT trigger mechanism for delta loads.
• Replicated SQL (JDE) data into HANA and modeled to pull master data non-HANA tables and eventually used in attribute views and further used in Calculation Views.
• Used composite provider as the primary source for the queries.
• Used SAP Hana connection to leverage the hana views in Webi.
• Pulled in Historical transaction data from legacy system (JDE), thru SQL where data was transformed, into BW using DB Connect.
• Created information views (Analytical, Attribute, and Calculation Views) on Native HANA and the same were used in BW to get feeds out of openhub for certain scenarios.
• Established connection to old BW system to pull in Historical Transaction data.
• Merged the history (from JDE and old SAP BW) with the current data (from ECC) and harmonized in BW as a single source for reporting needs.
• Calculated measures and restricted measures/columns were created and used on scenario basis in Analytical Views
• More insight was obtained using Calculation view by combining Sales (revenue) and Finance date.
• Usage of complex expressions (If conditions, Counter, filters, union, and Rank) were implemented to achieve the needs. Reused Analytical, Attribute and also a Calculation view in Calculation views.
• Combined facts from multiple tables in Calculation Views.
• Developed Sales, Purchasing, Production, and COPA reports using BI reporting suite of tools (Analysis, Webi, Lumira, Design Studio) to Match existing reports from IQ4Biz and also developed newer and better reports.
• Calculation Views were used as source for Design Studio for 2 Dashboard applications.
• Efficiently linked object in the dashboard application in Design studio by passing the values between chart and filters.
• Lumira Stories were created to supply overview of Sales and Production to managerial personals with necessary filtering (objects) supplied for quicker analysis.
• As a pilot designed and developed an application in Lumira Designer of Lumira 2.0 (just then it was released )
• Reports were directly built on top of the BEx queries and Calculation Views.
• Developed and wisely used Restricted Keyfigures (RKF), Calculated Keyfigures (CKF), and Variables (User exit) in the queries.
• Managed offshore team of 2 for built by delegating and getting deliveries on time.
• Worked on very stringent time schedule.
• BW implementation was carried out successfully and in parallel with ECC implementation.
• Requirement gathering, designing, developing and delivery were done very professionally and in a smooth process by coordinating meetings and presentation with the respective business and functional teams.

Confidential, Lake Forest, IL

BW/BI Lead Consultant

Environment: SAP BW 7x & 3x, HANA

Responsibilities:

• Handled BW-ProCo and BW-Pricing development projects from Analysis, Requirement Gathering, Development, Implementation, Reporting and Maintenance.
• Acting as point of contact for business and also coordinating the offshore team by delegating and getting the tasks completed successfully.
• Detail analysis on the impact in BW due to the addition of new company “ProCo” was carried out and captured the BW objects which need modification so that the impacts are eliminated.
• The above was achieved by capturing the requirement with business and other technology (Teradata) group which had dependencies with BW. Identified the impacting objects, listed out their usage both at backend and at query level.
• Removed the impacts by applying necessary modifications to the queries. Modifications were mainly on the filters, restricted key figures, formulas, variable selection.
• At the BW backend, did identified where the lookups were done on the impacting new ProCo objects and revised those rules. The area mainly involved was the master data lookup in the transformations.
• Documented the work done and trained the user on the modification carried over, and on the usage of the queries and reports.
• Gathered detailed information on the extract that is to be provided from BW, eventually feeding to the ODM engine that is been developed for the determination of Pricing by pricing rules.
• Had the extract generated in two phases, Release 1 (pilot) and Release 2.
• As a pilot used query and APD objects in generating the extracts. Final extracts, containing 12 month, 6 month (with simplify and save, and w/o simplify and save), 3 months, last month, and Month to Date bucketing aggregated by Customer, Track Code, and Subtrack code was designed and agreed upon.
• For the Release 2, took all the calculation and conditions to the backend by designing a data model involving DSOs, Infocubes, MultiProvider, and Openhubs because of the humongous volume of data involved.
• Developed APO to determine stock at hand after combining the invoices and in process quantity. The end records were staged to DSO.
• Effectively used the Data from the existing DSO and loaded to the DSO as staging and moved the data to first level of Infocubes (12 month, 6 month, 3 and last month) further to aggregation cube which was connected to Multiprovider and obtained the necessary view of the extract. Openhubs were developed to generate the extract from the Multiprovider.
• Complete automation and flexibility were introduced in the data model from Process chain and abap routines on Selective deletion, full DTP selections and Transformations.
• The Process chain executions are maintained by Cronacle for efficient run as to avoid overlapping of dependencies.
• The generated files in the application server was configured to be picked up and fed into ODM by unix scripting.
• Three Lumira dashboards were built on top of the infoproviders thru BEx queries.
• As a pilot, developed Calculation Views (graphical and sql scripting) in HANA for Financial reports (Balance Sheet, Cash Flow).
• Reports were developed directly on Hana views, using “SAP HANA” connection in Tableau.
• Complete documentation on end to end implementation was done for easy and future reference.

Confidential, Manchester, CT

BW/BO Senior Consultant

Environment: SAP BI 7.3, BEx Query Designer, BOBJ 4.0/4.1: Dashboard (Design studio)

Responsibilities:

• Gathered the scope from business to be gone into the dashboard and finalizing the number and KPIs to be analyzed thru it.
• Designed the wireframe of the dashboard with through discussions and approval of the business. analyzed the existing query used for conventional reporting, modified to fit the needs of the dashboard. intensively used cell definition in the queries to be stitched to the dashboard thru BIC.
• Analysed data which is to be used in dashboard for business using Analyser and BO Analysis.
• Took care of the performance by tunneling down the data inflow thru the query by filters and shifting the workload appropriately between the queries and at the manipulation of data at dashboard.
• Charts, graphs, selectors, containers were efficiently used and nicely placed for appealing looks and for ease-of-use.
• Used BIC to pull in data to dashboard from the queries which were built exclusively to serve the purpose.
• Took care of the minor request s and changes from the users as post developments perks.
• Did create usage guide documents for the users for their quick reference.

Confidential, Houston, TX

BW/BO Lead

Environment: SAP BI 7.3, BEx Query Designer, BObj 4.0/4.1: Webi

Responsibilities:

• Analyzed, Designed, and Developed Bex queries which suits better for the Webi reports stitched to them.
• Involved in the data modeling discussion and helping out the development team in building the infoproviders for better performance on the reporting front.
• Reports development were majorly on SD, FI, and COPA modules.
• Ingeniously created queries making use of RKF, CKF, Structures, finding the common ground as multiple reports were built on top of the query (super query)
• Aggressive analysis was done in the creation of BEx query filters, again to find the compatibility to all reports that are to be built on top of the query.
• Developed couple of customer exit variables for specific business scenario.
• Created 40 webi reports in various modules with BEx query as the source.
• Involved in the discussions with the business users for webi report wireframe and enhancements to the existing reports to meet the business needs.
• Made use of various report elements like vertical table, horizontal table, cross table and chats.
• Intensively used webi variables to manipulate the incoming data and various formulations were incorporated in them.
• Made use of the features like query striping, merging prompts, refresh on open, etc.
• Worked with business to set standards of the reports.
• Defects were efficiently handled and rectified which were captured during the UAT.
• Met all deadlines with effective planning and coordination among the team working offshore and onsite.
• Documentation were maintained for all phases of the project, from analysation, design, development, testing and user guide.
• Raised couple of notes to SAP in related to webi as we experienced issue in 4.1 versions.
• Step by step guides were developed and trained power users.

Confidential, Atlanta, GA

BI/BO Senior Consultant

Environment: SAP BI 7.3, BEx Query Designer, BObj 4.0: Webi

Responsibilities:

• As a part of Break Fix team, was mainly involved in handling daily incidents of various priority.
• Also took care of minor enhancements like adding new custom fields to the existing reports, involving enhancement of Datasources and programming to populate the new fields in ECC side till the query modification.
• Open Hub Services were developed to send out files to third party sys.
• Throughout the tenure, Involved in design and development of various objects as InfoObjects, DSO, Cubes, Multiproviders, Infoset, BEx query and its objects.
• Involved in maintenance of Webi report, which included modification and minor enhancement of the reports as a part of ticket handling.
• Daily Process chain monitoring
• As was handling tickets, interacted with business folks on daily basis.

Confidential, Kansas City, MO

BI/BO Architect

Environment: SAP BI 7.0, BEx Query Designer, Universe Designer, Xcelsius 2008 Enterprise.

Responsibilities:

• Involved in designing the data flow and bridged the gaps.
• Developed Functional Requirement Document and Technical Document for the objects that need to be developed in the BI side for both back-end and front-end.
• Leading the offshore team and coordinating with the business to make the ends meet.
• Developed new data flows from DS maintenance in the R3 side to the data modeling in BW side. Mainly involving COPA, Logistics (SD, MM, QM, PM, WM) and Vistex (Billback condition, Agreement condition and Claim condition related objects).
• Extracted information from CRM system for invoice reporting, consolidating vistex data to it for much more granular detail for the same.
• Scenarios included development of generic DS, enhancement of the existing ones and also activation and usage of the standard DS.
• Generated feeds on invoices using APO involving conditions, ABAP routines, consolidations.
• Developed queries in BEx designer fitting the business needs.
• Appropriate usage of RKF, CKF, Formulas, Selections, Conditions.
• Involved the usage of customer exit variables and extensive programming in CMOD to meet unique business requirements.
• Maintained Indexes and fine tuned the abap in CMOD on the existing queries to increase the performance.
• Developed 6 Xcelsius reports involving various charts, tables.
• Made use on Qaaws as the data connector to transfer the data onto Xcelsius.
• Universes were built on top of the queries, which were developed exclusively for dashboards.
• The web services were built on the defined universe.
• Took care of the security by grouping the imported users from BI and assigning appropriate authorization to the groups.
• Assignment of authorizations was carried out on both folder level and as well report levels.
• Migrations of the objects were carried out efficiently using BIAR file concept.
• Careful usage of formulas to manipulate the data on excel sheet was carried out, also taking care of the performance of the entire dashboard.
• Trained users on navigation and usage of the dashboards. Also created and provided How-To documentations for future references.

Confidential, Hermitage, TN

BI Lead

Environment: SAP BI 7.0, BPC 7.0, BEx Query Designer.

Responsibilities:

• Involved in designing the data flow and bridged the gaps.
• Developed Functional Requirement Document and Technical Document for the objects that need to be developed in the BI side for both back-end and front-end.
• Directly involved in discussion in designing the Interface file formats of the DTT Time & Expense Data received from the MF. The discussion also includes the setting the frequency of transmission, naming convention, etc.
• Developed customized InfoObjects, DSOs, Infocubes and MutiProviders.
• Transformation, DTP, Info package, Process Chains were developed for scheduling, loading and transforming the data.
• Created Flat File datasources for the Mapping data, Actual and Plan data. Also made use of standard datasources for the Master data text, attributes and hierarchies.
• Involved in the development of the start routines, field routines for the transformations and routines for accessing the files from the FTP folders in the infopackages.
• CKF were formulated as per the calculations mentioned b the functional team.
• Additional characteristics were provided in the queries as Free-Characteristics.
• Variables were used in characteristic restriction to narrow the data that is been flown to the report as per the user specifications.
• Involved in designing the templates for the reports using WAD which includes various web components.
• Actively involved in discussions with the Portal team in designing the portal pages for the reports.
• Worked closely with the Basis and the Security team to access authorization for list of members both for portal and the BI System (query components)
• Scheduled meetings with the functional team and other members to get the information for the development.
• Sticking to the designed project plan and met the respective deadlines.
• Presented demos on every mile stone for the members involved in the project, this includes the end user, QA team, etc.
• Training Users and documenting on the functionality and Navigations involved in the reports.

Confidential, Waukegan, IL

BO Xcelsius Lead Consultant

Environment: SAP BI 7.0, Xcelsius 2008 Enterprise.

Responsibilities:

• Involved in the requirement gathering, documentation and business discussions with the client.
• Historical data with current transactions were extracted to the APO BW from BW box and ECC for demand based reporting and the same is been used for dashboarding.
• Flexibility on drilling was provided on the reports at Material Group, Product Category, Product Line and Product Group levels as requested by business.
• Designed and developed the wire frames for the dashboard reports.
• Developed POC in Xcelsius for Sales, Production, Finance and HR dashboards with the output templates obtained from BEx analyzer.
• Dynamically pulled data from SAP BI through Web Services (WS).
• Enabled bi-directional data flow. The Xcelsius dashboards were input enabled and passed the selection to the BI queries through WS and the WS populated the resultant data onto the Excel embedded in Xcelsius.
• Refreshed the dashboard automatically by using trigger logics for various selection made by the user.
• Trained end users development team for the maintenance of the dashboard reports.
• Development and Training documents were prepared and furnished to the team.