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 teh 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 teh Business Objects Security such as teh row-level and object-level/Table level.
• Extensively worked in INFOVIEW and BI Launch Pad to create Web Intelligence Reports over teh 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 Integration 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 teh 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

Environment: SAP HANA/SAP BI 7.4/BO R3/4.0/4.2/Qlikview/Crystal reports 2013/Tableau 10

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 teh SAP BI team lead/admin handling a team of 3 from production support to new development projects.
• Created technical and functional specifications involving teh general overview of SAP BI, all teh 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 teh 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 teh 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 using IDT and dashboards on Lumira.
• 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 teh qlikview dashboards which were directly connected to SAP ECC and manual text files.
• Developed models/objects on HANA 1.0 SP6/SP11 Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges, Procedures, Decision tables, scalar and tabular functions, created 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, CT

SAP BI/BW/4HANA Consultant

Environment: BI 7.3/SAP HANA/ECC 6.0/BO XI 3.2/4.1, BEx/AP, FI & HR, HANA Studio/BODS

Responsibilities:

• As a SAP BO consultant was handling two applications as a developer and as a production support role. Teh 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. Teh purpose of GCT was to capture IT Costs (Hardware and Manpower) and shred these costs across teh different business groups which use teh IT.
• Supported BPS which was used as skeleton to run teh 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 teh 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 teh 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 teh load and query performance by setting indexes, creating aggregates and ensuring teh availability of teh updated data in teh 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 teh jobs for daily, weekly and monthly loads and activities.
• Was involved in SAP Native HANA development for Confidential which involved gathering teh 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

Environment: BI 7.0/7.3/ECC 6.0/BPC/BO XI 3.1, BI 4.0/BEx/BIA/ APO, SD, MM, FI, CO-PA

Responsibilities:

• As a Production Support consultant involved in debugging and monitoring load failures, solving teh high priority tickets from BMC Remedy, Delta loads, planning ECC Outage for filling up of setup tables for Logistics (LO) extractors, Minimizing teh Init load and setting v3 jobs, Selective deletions and loading etc.
• Constant interaction with teh 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 teh changes we did as enhancement projects for client.
• Has modeled teh 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 teh database partitioning by time characteristics which enabled faster access of teh data.
• Worked closely in managing teh dataflow between R3 and BW systems. Teh 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 teh critical and high Incidents and Tickets created by teh business users using teh 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 teh variables created in teh query designer and written teh ABAP code successfully as enhancement projects.
• Maintaining and monitoring teh automated process chains and force completing teh process chains for master and transaction data load depending on teh 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 teh manual jobs which are used to support activities of BW loads to hold and release teh jobs for daily, weekly and monthly loads.
• Used ABAP extensively for Start routines, End routines, User Exits and look up’s while enhancing teh data sources and transformations.
• Created adhoc reports using BEx query designer and Analyzer on Mutliproviders, Infocubes and Infosets depending on teh user requirements.
• Created various Restricted Key Figures, Variables, Structures, Selections and Formulae at teh query level during my tenure.
• Performance techniques like compression, aggregates, deleting Indices, roll ups, remodeling and reconstruction have been implemented on teh Info cubes to increase teh performance of teh 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 teh 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 teh universe solution, designing a schema, Building teh universe, distributing teh 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 teh 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 teh structure by using aliases or contexts.
• Tuning teh SQL to improve teh performance of teh reports.

Confidential – San Diego, CA

SAP BI/BO Consultant

Environment: BI 7.0,7.3/ECC 6.0/BO XI 3.1, BI 4.0/BEx

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 teh OLAP Universes using teh Source as BEx Queries and relational database in teh BOBJ Universe Designer.
• Developed 200+ complex Web Intelligence financial and daily sales reports using BO 4.0 Web Intelligence tool based on teh BICS connection and SAP Bex queries as teh data source
• Worked with all teh 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 teh universes by creating teh Business Objects data model selecting and joining tables, indicating cardinalities, creating aliases to resolve teh loops, subdividing into contexts and creating teh 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 teh reports in accordance with teh 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 teh need of any BOBJ Platform to import data into excel sheet to serve as teh input for teh dashboard.
• Imposed several Joins, Filters, and Alerter to restrict teh unwanted data and highlight teh required data.
• Created various Dynamic LOV’s and New parameter classes using SQL for Crystal Reports using Business View Manager as semantic layer.
• Created teh 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 teh Users and Groups, applications, Security and rights to teh Users.
• Teh source systems included SAP BW Queries, Info providers including Info Cubes and Oracle using Informatics Toad .