SUMMARY:

• SAP BI/HANA/Tableau Technical Consultant wif over 8 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, Tableau and SAP HANA.
• Total IT experience of 8+ years wif 7+ 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 4+ year in SAP HANA Modelling SP6/SP11 and Tableau 10.2.
• Expertise working on HANA 1.0 SP6/SP11 Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions and Analytical Privileges.
• Excellent experience 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, SDA replications, Security and Authorization aspects of SAP HANA 1.0
• Expertise in Data Modeling and HANA optimization of Info Cubes, DSOs (Standard, Direct update and Write optimized), Info Objects, Info Areas, Info Sets, Info Providers using SAP BW 3.5/7.1/7.3/7.4.
• Successfully completed two full life cycle FLC projects along wif two upgrade projects in SAP BI.
• Expertise in migration process from BW 3.5 to BI 7.0 and HANA optimized BW 7.4.
• Proficient wif 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 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.
• 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.
• 6+ Years of hands on experience wif SAP Business Objects Enterprise 4.0/4.2 products of IDT, Universe Designer, WebIntelligence, Desktop Intelligence, Live Office, Xcelsius Dashboard, Crystal Reports, Infoview, Launchpad, Design Studio.
• Extensively worked in INFOVIEW and BI Launch Pad to create Web Intelligence Reports over the Universes. Extensively worked in Combination Queries, designed Drill Specific Reports.
• Expertise in using BO Administration, upgrading, migration of reports, publishing wizard, CMS, CCM, and CMC and its user securities. Upgrading Business Objects XI3.1/XI3.2 to Business Objects BI 4.0/4.2
• Expertise in data modeling concepts (star schemas, snowflake schemas, highly normalized data models).
• Expertise in using different databases of relational, OLAP, OLTP, multidimensional databases involving Oracle 12c/10g/9i/8.x, MS SQL Server, Sybase, BaaN, MS Access, SAP BW and SAP HANA for reporting.
• Extensive experience in working wif Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 9.3-10.4
• 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, data blending, cross database joins etc.
• Expertise wif SQL development of queries, functions, procedures, performance tuning using Oracle PL/SQL Developer and MS SQL server databases.
• Production Support skills: load monitoring, enhancements and change requests.
• Possess a very strong technical foundation wif distinctive analytical abilities. Experience in managing offshore and on-site resources. Excellent communication skills. Well organized.

TECHNICAL EXPERTISE:

Data Warehouse: SAP HANA SP11, BW 7.0/7.3/7.4, SAP BW on HANA, BW4HANA, SAP BODS 4.0

Programming: SQL, J2ME, SAP ABAP/4, PL/SQL, MS SQL

ERP’s: SAP ECC 6.0, 5.0, R/3 4.7, SAP SCM, SCM 5.0(APO), BAAN C4, JDEdwards

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

Web: HTML, XML, Dreamweaver, Flash, JavaScript

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

Databases Oracle: 7.x/8.x/9.x/10g/12c, MS SQL 2000-2012, MS

Access: 2003/2007, DB2, SAP HANA

Dashboards: SAP Lumira, Designer/Design Studio, Xcelsius 2008/2011, Dashboards 4.2, MSTR, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, CA

SAP BI Consultant/SAP HANA Modeling/Tableau

Responsibilities:

• Delta Dental as an insurance company TEMPhas an agreement wif New York state’s Medicaid and Medicare program to facilitate the administrative services through Delta owned MetaVance system.
• MetaVance is an enterprise system for Delta to support health insurance operations. It supports operations of Claim processing, member eligibility and healthcare provider management.
• Worked on New York CDPHP Medicaid project for development of reports and dashboards.
• Worked on gathering requirement from the Multi-Stake holders and providing the Data Segregation for the Business Objects Reports and Tableau Dashboards.
• Created 20+ Standard, Cross-tab, Sub reports and TAT Webi reports for New York Federal department’s Medicaid team.
• Designing & Developing of Webi/Crystal reports along wif Tableau dashboards. For different groups of organizational KPIs, wif Geo-maps, drill down functionality, summary and detail analysis and ad-hoc analysis capabilities.
• Designed and developed complex universes in both IDT and UDT and assigned row level securities.
• Worked on creating complex reports wif multiple data providers. Created custom SQL and Free Hand SQL Webi reports based on the Requirements.
• Major report development was based on relation databases Oracle/MS SQL Server.
• Data validation and major SQL development was done using PL/SQL developer and MS SQL server development studio.
• Design & Development of Tableau reports/dashboards was based on MS SQL Server Tables & Views & Oracle Tables & Views.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters, animations and combined sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.

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 me.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 wif 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 wif 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 wif connections of OLAP and relational connections ODBC wif 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 wif 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.3 and then did the reporting using connections of BICS and OLAP.
• Involved in creation of various new data flows, 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.
• 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 data sources, 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

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.
• dis 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 wif 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 many 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 wif 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 wif 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 wif 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 HANA POC 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 a system, creating schemas and content models, attributes and measures, hierarchies.
• 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.

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 wif 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 wif 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.
• TEMPHas 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 Info Objects 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 wif 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 wif 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 wif 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 90+ 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 wif 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 wif 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. Wifout 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 wif Dropdown lists etc.
• Expertise in using functions like @aggregate aware, @prompt, @select and creating custom hierarchies.
• Worked wif 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 .