SUMMARY:

• SAP BI/HANA Technical Consultant with over 7 years of experience in modules of Logistics (MM, SD), FI - CO, AP, AR, HR systems and strong emphasis on SAP Business Warehouse, SAP Business Objects Enterprise, BODS, Tableau and SAP HANA.
• Total IT experience of 7 years with 6+ years in SAP BW/BI environments including 6 years in SAP Business Objects XIR2/3.1/3.2/4.0/4.1/4.2 and 3+ year in SAP HANA Modelling SP6/SP8 and Tableau 10.2.
• Successfully completed two full life cycle FLC projects along with two upgrade projects in SAP BI.
• Experience in Migration process from BW 3.5 to BI 7.0/7.3 and upgrading Business Objects XI3.1/XI3.2 to Business Objects BI 4.0/4.2.
• Proficient with ASAP Methodologies and Gap Analysis in the Implementation of Project phases like Requirement Gathering, Business Blueprint, Development & Realization, Go-Live, Production Support and End User Documentation.
• Expertise in Data Modeling and Re-Modeling of Info Cubes, DSOs (Standard, Direct update and Write optimized), Info Objects, Info Areas, Info Sets, Info Providers. Sound Knowledge of Multi Providers, Data Marts, Open Hub Services and Portals using SAP BW 3.5/7.1/7.3/7.4.
• 6+ Years of hands on Experience with new SAP Business Objects Enterprise 4.0/4.2 products of IDT, Universe Designer, Web Intelligence, SDK, Desktop Intelligence, Live Office, Xcelsius Dashboard, Crystal Reports, Infoview, Launchpad, Design Studio and QAAWS and new BICS,OLAP & ODBC connections.
• Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models).
• Expertise in using different databases of relational, OLAP, OLTP, multidimensional databases involving SAP HANA, SAP S/4HANA, SAP ECC, Oracle10g/9i/8.x, MS SQL Server, Sybase, BaaN, MS Access,
• Strong knowledge in implementing the Business Objects Security such as the row-level and object-level/Table level.
• Extensively worked in INFOVIEW and BI Launch Pad to create Web Intelligence Reports over the Universe. Extensively worked in Combination Queries, designed Drill Specific Reports.
• Excellent knowledge on: BW on HANA: BW/HANA Optimized Info Cubes, HANA Optimized DSO's, Advanced DSO,Transient, Composite, Hybrid Providers, Open ODS Views, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .
• Worked on Data Modeling, Data Provisioning, Reporting, SLT replication including SDA Smart Data access and Business Objects Data Services, Security and Authorization aspects of SAP HANA 1.0
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator in integrating BODS with SAP modules and Non-SAP datasources
• Skilled in Tableau Desktop for data visualizations - Dashboards and Stories, Reporting and Analysis; Cross tabs, Scatter Plots, Geographic Maps-geo spatial lines polygons, linear geometries, Sets, Sorting, grouping, filters, trend and reference lines, charts, Page Trails, LOD calculations etc.
• Deep understanding of SAP Native Hana modelling, SAP Hana SLT replication. Configured LTRC settings in ECC to enable replication to HANA and did reporting using BI 4 tools.
• Expertise in data extractions from Back-end Business Warehouse Component Extractors like LO-Cockpit, CO-PA, FI and Generic Extractors including Flat File Extraction, BI Content Data Sources and extraction models including Full and Delta updates.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques. Also used BI Accelerator BWA to improve the query or reporting performance on high end info cubes.
• Experience in using Report Conversion Tool, Publishing wizard, CMS, CCM, CMC, creation and installation of servers in Business Objects BOE.
• Performance tuning in SQL optimization, Caching methods, parallel data loading, etc.
• Experience of SQL development with any major RDBMS databases, like DB2, Oracle, SQL Server, etc
• Deep working knowledge in SAP ERP (FI/CO/COPA/Treasury/PP/MM/SD/AP/AR), SAP BW-BPS, SAP HANA, SAP SRM, SAP Solution Manager, Design Studio and Qlikview.
• Production Support skills: load monitoring, enhancements and change requests.
• Possess a very strong technical foundation with distinctive analytical abilities. Experience in managing offshore and on site resources. Excellent communication skills. Well organized.

TECHNICAL EXPERTISE:

Data Base/Warehouse: SAP BW4/HANA, SAP HANA SP7+, BI 7.0/7.3/7.4, Oracle 9I/12C, MsSQL 2008/2003

Operating Systems: Windows Server 2003/2008/2012

Programming: C, Java, SQL, J2ME, SAP ABAP/4, PL/SQL

ERP’s: SAP S/4HANA,ECC 6.0, 5.0, R/3 4.7, SAP SCM, SCM 5.0(APO), BAAN C4,C5, JDedwards

SAP Modules: SD, MM, FI, CO, HR, APO, COPA, BPC - Reporting

Web: HTML, XML, Dreamweaver, Flash, JavaScript

Reporting Tools: BEx Reporting, SAP Business Objects (XI 3.1-BI 4.2), Xcelsius 2008/2011, Dashboards 4.2, Crystal reports XI 2008/2011/2013, Live office, Advanced Analysis, Qlikview, SAP HANA Studio SP7, Lumira & Predictive Analysis, Design Studio, Tableau 10.X.

Database Oracle 7.x/8.x/9.x/10g/12c, MS SQL 2000-2008,MS: Access 2003/2007, SAP BW, DB2

Other Tools: Unix Shell Scripting, MS Project, MS Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential - Boca Raton, FL

SAP BI Consultant/Administrator

Responsibilities:

• Tyco International is a Security Systems Company and consisting of two major business segments viz., Products & Installation Services.
• Strategic business units (SBUs) offered by Tyco involved Tyco Fire Protection Products (TFPP), Tyco Retail Solutions (TRS), Life Safety Products (LSP), Tyco Security Products (TSP), Logistics & Distribution (L&D), Tyco Integrated security (TIS) and Simplex Grinnell.
• SAP BI was used by Tyco business users to keep a track of their on-going business revenues, to perform planning, forecast & budgeting, assess credit risk, provide service & Installation etc., by generating reports based upon market trends and other key performance Indicators calculated periodically i.e. weekly, monthly, quarterly or yearly.
• Tyco used SAP business objects as their main reporting tool across globe involving Americas, EMEA and Asia Pacific regions along with Microstrategy and Tableau.
• Worked as the SAP BI team lead/admin handling a team of 3 from production support to new development projects.
• Created technical and functional specifications involving the general overview of SAP BI, all the platforms, instances, interfaces, connections, customizations, etc for Tyco.
• Worked with Central Management Console (CMC) including creation of Business Objects folders, documents, reports, user groups, profiles, schedules, publications, and security rights.
• Involved in migration of Universes and reports from Business Objects XI 3.1 to Business Objects BI 4.0/4.2.
• Setup and maintenance of BO Enterprise environments, creating and managing user profiles, creating access levels and managing Services, securities and LCM.
• Supported for SAP BO XI R2 for North America and SAP BO 3.1/4.0/4.1/4.2 versions for EMEA regions.
• Development involved various source systems including SAP ECC, BW, BaaN CIV, JDE, and Microsoft SQL with connections of OLAP and relational connections ODBC with DB2, Oracle, SQL server 2008, 2003 & SAP.
• Support tools included Crystal reports XI, 2008, & 2011, 2013, 2016, Infoview, BI launch Pad, CMC, Universe designer, Information design tool, Dashboards and Tableau.
• Implemented row and table level security on top of universe and its tables, including managing restrictions to universe and webi reports.
• Migrated Corporate Reports & Self-service Reports from US BO to EMEA BO using upgrade management tool and import wizard respectively.
• Co-ordinate with onshore/offshore team to deliver the requests/enhancements on-time. Involved in major enhancements at Reporting and on Universes.
• Had created various queries using Bex query designer on SAP BW 7.4 and then did the reporting using connections of BICS and OLAP.
• Involved in creation of various new data flow, DSO’s, Infocubes in SAP BW and reporting on Webi.
• Enabled Auditing and developed new audit reports in both BO 4.0 and BOXI R2/3.1.
• Majorly involved in development of new objects using Universes, Webi reports, Crystal reports, Tableau and Bex reports through enhancements on multiple source systems.
• Supported the qlikview dashboards which were directly connected to SAP ECC and manual text files.
• Developed models/objects on HANA 1.0 SP6/SP10 Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges, Procedures, Decision tables, scalar and tabular functions, role and user etc.
• Created Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau 10.2 Desktop
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Used Tableau to extract, manage metadata, connecting to various datasources,Interactive filters, parameters, tooltips, sets, reference lines, forecasting data, designed various dashboards involving maps, actions and stories.

Confidential - Stamford, C

SAP BI/BW/4HANA Consultant

Responsibilities:

• As a SAP BO consultant was handling two applications as a developer and as a production support role. The two applications involved were Global General Ledgers for financial reporting and Travel and Expense financial reporting.
• This project combined over 50 general ledger systems into a common Global General Ledger GGL . Confidential was using a combination of in-house developed systems and SAP. It used SAP as part of its financial controlling process as well as for Financial Operations and reporting.
• Supported business units of Global Investment Bank/Wealth management where SAP BI 7.0/7.3 is implemented. Along with SAP BI, SAP SEM/BPS module is used for cost allocation and Tax calculator.
• Involved in support of daily and month end activities of Group Cost Transparency GCT which was a suite of applications including SAP R3, BW, JAVA and other legacy applications. The purpose of GCT was to capture IT Costs (Hardware and Manpower) and shred these costs across the different business groups which use the IT.
• Supported BPS which was used as skeleton to run the ABAP Routines for Cost Allocation and Tax Calculation purpose in GCT.
• Was involved in handling different number of applications for reporting which included Meridian reporting for regional and regulatory reporting purposes, Management reporting for general summary financial reporting, FDD for financial reporting and Group IT Cost Transparency reporting.
• Involved in creating and dropping of Synonyms built on Infoset queries for financial detail database reporting where reports were reading the data through Infoset Queries where there are a large number of attributes.
• Involved in installation of Business Objects BI 4.0 and service packs including migration from SAP BOXI 3.1 to SAP BI 4.0 BOBJ 4.0 .
• Developed Web Intelligence reports using Universe Designer UDT and Information Design Tool IDT over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting.
• Involved in identifying and solving process chains and manual job failures, Real Time Data Acquisition (RDA) failures which were used in loading adjustments posted in real time, Daemon jobs needed instant identification and correction and other housekeeping performance activities.
• Involved in all kind of data loads, data load failures, error handling, performance optimization, reconciliations, manual and process chain upload of hierarchies, flat files, refresh and re-sync activities, transfer and loading of exchange rates etc.
• As a developer was involved in full life cycle implementation for the Travel and Expense project and have done rigorous UAT testing along with Business interactions.
• Performed required ABAP/SQL programming for enhancing/modifying/debugging reports for already existing and newly created objects.
• Performed data validation of BI info providers with respect to source systems using ABAP/ reconciliation programs. Improving the load and query performance by setting indexes, creating aggregates and ensuring the availability of the updated data in the reports on time.
• Extracting and modelling of new data flow including info cubes, DSO, Multi providers, Hybrid providers and semantically partitioned objects for new reports published on web portals for Travel and Expense project.
• Designed, modified, debugged, and tested transformations, queries and other BI components using BW 7.3 and BO 4.0.
• BOBJ 4.0 was integrated with SAP ECC, Oracle 10 and SAP BI 7.3 to build Universes and further direct connection BICS for ASIA region reporting.
• Used Autosys tool for automated jobs of BW/BO loads to hold and release the jobs for daily, weekly and monthly loads and activities.
• Was involved in SAP Native HANA development for Confidential which involved gathering the requirements, collecting sample data, created models (Attribute views/Analytic views/ Calculation view) using SAP HANA Studio, created universes using IDT, create reports using SAP BO Tools - Webi, Business Explorer, Predictive Analysis, SAP design Studio and Lumira.
• Created HANA modelling scenarios and activities such as adding systems, creating schemas and content models, attributes and measures, hierarchies.
• Configured SLT and replicated required tables from ECC to SAP HANA and did further reporting using SAP BO tools.
• Worked on traditional SAP BW and SAP BW on HANA features among others, standard and custom SAP BW Extractors, complex transformations, advanced DSOs, composite providers, Open ODS views exposing BW models as HANA views, mixed scenarios, HANA Analysis process in BW and LSA ++ best practice and performance optimization concepts.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based).
• Data Provisioning, Security and authorization, Replication, loading and testing was done through SLT and BODS connected to ECC and SAP BW systems.
• Created complex Jobs, workflows, Data flows and scripts using various transforms integrator, quality and platform to successfully load data from multiple sources into desired data targets.

Confidential . - San Diego, CA

SAP BW/BI Consultant

Responsibilities:

• As a Production Support consultant involved in debugging and monitoring load failures, solving the high priority tickets from BMC Remedy, Delta loads, planning ECC Outage for filling up of setup tables for Logistics (LO) extractors, Minimizing the Init load and setting v3 jobs, Selective deletions and loading etc.
• Constant interaction with the Business users in gathering their requirements and problems related to current reports and fixing them.
• Support included for different Functional areas involved in SAP BW/BPC were APO - Demand Planning and Commitment Planning.
• SAP R/3 - Sales, Purchasing, and Finance - Accounts Receivables, Controlling & Profitability Analysis, Product Cost Accounting, Human Resources, Inventory Management and Plant maintenance.
• Legacy Interfaces included - Point of Sales (CDW) Informatica, Budgets, Logistics, MPI, GPS/PSI and Roots.
• Facilitated sessions with business user to define requirements and document those requirements.
• Created new required Technical and Functional documents depending on the changes we did as enhancement projects for client.
• Has modeled the Wizard based data flow modeling and generation of all related data flow objects including new Hybrid providers, Composite providers and Semantically Partitioned Objects and InfoObjects as needed using Netweaver 7.3.
• New data store objects created under Netweaver 7.3 were used to Support the database partitioning by time characteristics which enabled faster access of the data.
• Worked closely in managing the dataflow between R3 and BW systems. The functional areas from SOAR-R3 (RPA) system on which BW Reports were based like Inventory, FI, Sales Order, Deliveries, Billing/Invoicing, COPA, Logistics (Stock Adjustments) and Purchase Orders etc.
• Extracted Z tables data for Point of Sales (POS) which is loaded from mainframes into BW using Generic data sources.
• Customized Data source and Info source ‘ZIS RESTATE COPA’ and ‘1 CO PA151SON1’ were used in pulling data to DSO’s with delta mode on daily basis for CO-PA.
• Created and resolved the critical and high Incidents and Tickets created by the business users using the BMC Remedy tool which was integrated with SAP Solution Manager.
• Extracted data using Generic, Costing-based Profitability Analysis (COPA), CO Product costing and Logistic (LO) extraction for custom and pre-defined data sources.
• Created Customer exit and User exit for the variables created in the query designer and written the ABAP code successfully as enhancement projects.
• Maintaining and monitoring the automated process chains and force completing the process chains for master and transaction data load depending on the failure.
• Access to different Data sources was made via Adaptors like SAPI, SAPICRT and SAPIDIRECT, DBEEXTRACT for SAP Source Systems. Data sources included for SAP Source System, DB connect, File, UD connect, Webservices PUSH via SOAP .
• Used CONTROL-M to FORCE-OK the manual jobs which are used to support activities of BW loads to hold and release the jobs for daily, weekly and monthly loads.
• Used ABAP extensively for Start routines, End routines, User Exits and look up’s while enhancing the data sources and transformations.
• Created adhoc reports using BEx query designer and Analyzer on Mutliproviders, Infocubes and Infosets depending on the user requirements.
• Created various Restricted Key Figures, Variables, Structures, Selections and Formulae at the query level during my tenure.
• Performance techniques like compression, aggregates, deleting Indices, roll ups, remodeling and reconstruction have been implemented on the Info cubes to increase the performance of the reports.
• Regular activities included business interaction, Master and transactional data deletion and load, process chain monitoring offshore, client meetings and enhancements.
• Regular activities also included flat file extraction of data from third party tools legacy systems like Informatica and Oracle to BW using Toad and then loading the data from BW to further systems like Budget, Cognos systems to Application server using Open Hub Services.
• Created universes, classes, objects, and predefined conditions in Designer and IDT in Business Objects BI 4.0.
• Involved in planning and three implementation stages of Analyzing of business problem and planning the universe solution, designing a schema, Building the universe, distributing the universe to users.
• Created Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries using BICS connections
• Created Joins, aliases and Contexts. Resolved loops by creating Aliases and Context.
• Row level security was implemented with different connections for different user groups. Experienced in managing CMC, CCM.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports CR 2011 . Developed Webi and crystal reports on top of OLAP Universes, and created dashboards using Xcelsius.
• Resolved join problems such as loops, chasm traps, and fan traps, which occurred in the structure by using aliases or contexts.
• Tuning the SQL to improve the performance of the reports.

Confidential – San Diego, CA

SAP BI/BO Consultant

Responsibilities:

• Worked as a BI consultant for an In-house project for SoftHq involving End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Experience in Business Objects migration from to BOXI 3.1 to XI 4.0 BI 4.0 and using Upgrade Management tool.
• Created multiple Secured Connections to build the OLAP Universes using the Source as BEx Queries and relational database in the BOBJ Universe Designer.
• Developed 200+ complex Web Intelligence financial and daily sales reports using BO 4.0 Web Intelligence tool based on the BICS connection and SAP Bex queries as the data source
• Worked with all the new tools in BI 4.0 including BI Launch Pad, IDT, LCM, CMC, Report conversion tool, Crystal 2011, Xelcisus 2011, Universe designer, etc.
• Responsible for Designing the universes by creating the Business Objects data model selecting and joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Developed various full client and thin client reports using Business Objects and Web Intelligence.
• Wide usage of Drill mode, Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Worked extensively on Designer, Web Intelligence (webi), Desktop Intelligence (Deski), Crystal reports 2008 and Central Management Console (CMC).
• Developed Complex Reports (Used multiple data providers, Union, Master/Detail, cross tab, Charts and Formulae’s).
• Build Xcelsius Dashboards using SAP Web services created from SAP Net weaver. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.
• Imposed several Joins, Filters, and Alerter to restrict the unwanted data and highlight the required data.
• Created various Dynamic LOV’s and New parameter classes using SQL for Crystal Reports using Business View Manager as semantic layer.
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Expertise in using functions like @aggregate aware, @prompt, @select and creating custom hierarchies.
• Worked with complex scheduling features in CMC including calendars and event based scheduling.
• Strong experience in SAP Business Objects Administration/ CMC to create and manage the Users and Groups, applications, Security and rights to the Users.
• The source systems included SAP BW Queries, Info providers including Info Cubes and Oracle using Informatics Toad .