PROFILE SUMMARY:

• BI Leader with 15 years of experience in Managing SAP BI/BW and 8 years in Business Objects Projects.
• Expert in Delivering, Implementing large complex Projects with innovative solutions within Budget and timelines.
• Extensive experience in Managing development and leading of BI solutions from BW 1.2 to 7.5 and implemented several full life cycle BI projects involving FI, CO - PA, SD, MM, HR areas.
• Involved in complete life cycle implementation of BI/ BO/Hana integration & complete life cycle implementation of BI/BPC.
• Expert in Managing Budgets for highly complex BW/BO Implementations, Very strong in Team building globally(Onshore & Offshore)
• Expert in developing BI Strategy, Roadmaps and setting up BI COE
• Conducted workshops and presentations to validate business requirements and solutions with the end user community,
• Conducted training sessions for users in BEx/Webi/Dashboards/Design Studio and also for creating queries for power users.
• Experienced in use of ASAP Methodology for BW project plans. Excellent analytical, Problem Solving and Management skills.
• Sound experience in gathering business requirements, gap analysis and finalizing functional/ technical specifications and blueprint design/realization.
• Quick learning capacity and positive attitude towards new challenges.

TECHNICAL EXPERIENCE:

Management: Project management. Program Management, Vendor Management, Resource Management, Business Management, Change Management, Risk Management

Data Warehouse: SAP BI 7.3, SAP BW 3.5 (SD, MM, HR, PP, FICO, COPA),Business Objects, BI 4.2

Database: Oracle 10i, Microsoft SQL Server, Access, HANA

Tools: BI 7.3,BW,Dashboard 4.1,, Live office, Explorer, Data Services, EP 4.0, Design Studio 1.2, Lumira, Visual Intelligence, WebI, Analysis Office, Dashboards, Microsoft Office (Excel, Word, Power Point, Vizio)SAP HANA 1.0 SP12,Tableau

Operating System: Windows, Unix/Linux

Project Methodologies: Agile, Waterfall

Languages: C, C++, HTML,XML,PL/SQL, ABAP

Data Science: Data Modelling, Predictive Analysis, Data Acquisition, Data Mining, Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential

Analytics Manager

Responsibilities:

• Responsible for overall successful implementation of BI Program. Promote BI Value and use across all Business Units and Functional areas
• Responsible for hiring, assigning and Managing all BI developers for each Functional area
• Lead Business and Transformation Programs to deliver true business value to Customers/users.
• Worked with External Vendors to select Bi tools to accomplish Business Goals
• Supported and Mentored offshore teams when they run into issues with Data Loads or resolving any Analytics Incidents
• Manage Scope of the Project, Technical Design Documents and release of Deliverables
• Managed all the Confidential Post Production Activities (HANA, BW, Confidential ) which includes DLM activities, SPU's and also coordinating with offshore teams to resolve any open tickets
• Ownership of change management to make any changes to BI Systems.
• Setting up status calls with off shore teams to review the Status/Progress on SPU activities & DLM activities & Analytics Tickets
• Provide Technical expertise resolve issues across Development & Implementation and act as a single point of contact for all deliverables
• Suggested design changes for complex Logistics Process chain to improve the latency of data loads
• Suggested performance improvement changes for WebI reports using SAP best practices on both Back end & From End.
• Assigning & validating the work to offshore based on the complexity and availability of the resources
• Performance optimization for Queries(WebI, Analysis Office, Dashboards) using SAP Best Practices
• Working with SAP to resolve issues with AO & HANA and prioritizing the tickets with SAP

Confidential

BW/ Confidential Delivery Manager

Responsibilities:

• Managed a BI team both Internally & externally to meet SLAs
• Designed Reporting Strategy for Global Implementation of Finance/Management reporting
• Assisting the client for best tool selection
• Recommending best practices for BW & Confidential implementation
• Designing the architecture for BW & Confidential
• Managed Mobile Application team to deploy Dashboards on to Mobile applications for Executives and Leadership team
• Driving the reporting needs from Business users
• Managed the development & testing activities
• Project Management using Microsoft projects & At Task to manage development activities and resource management
• Trained the users in using Design Studio 1.2 & WebI reports in FI, Sales & COPA
• Worked with SAP Tickets to resolve Design Studio issues and drive solution for work around in passing parameters from Cross tab to Webi report for RRI
• Involved in Sizing and Architecture for BW server, Data and reporting analysis and Modeling for BW Extended Star Schema
• Coordinating with Basis Team on Landscape activities. Making sure all the patches have been updated on ECC and BW to align with Confidential Service pack updates
• Managing DLM team after Monthly Go live activities and making sure all the reports are working as expected in the new service pack updates.
• Managing onshore and coordinating with offshore teams on monitoring on Data loads Supporting Business Post - GO live with Month end, Quarter End and Year End. Worked on Agile Releases and Managed Contractors for Monthly releases

Confidential

BW/ Confidential Implementation Lead

Responsibilities:

• Designing the reporting strategy for SAP PBF Implementation
• Designing the architecture for BW & Confidential
• Working with end users & functional team to gather reporting requirements
• Recommending best practices for BW & Confidential implementation
• Assisting the client for best tool selection
• Managing both on shore & off shore developers
• Assisting the client in BI 4.0 Installation, Integration, Roles, Security & Authorizations
• Testing the Data Loads for Master Data(Attributes, Texts & Hierarchies)
• Testing the Data Loads for Transactional Data
• Developed the Blue Print, Functional Specifications
• Worked with the Business, Stake Holders on GAP Analysis
• Identified the reports needed for PBF implementation
• Identified the Sources needed for reporting
• Assisting the client in preparing reports to communicate project progress and status.
• Identifies problems and escalates to management
• Designing the reporting strategy for FI & HR.
• Define & design reporting plan from scratch, ensuring all reports are intuitive, accurate and fast
• Working with end users & functional team to gather reporting requirements
• Managed a team of 15 developers on shore & off shore.
• Implementation of Confidential 4.1, Dashboards 6.0.5.0 & BI Launch Pad 14.0.5
• Performance tuning of BW Backend & BW Front end
• Mentors staff to overcome limitations and achieve maximum potential.
• Assigns/distributes resources for perpetual task and specific project needs
• Reviews status reports of team members across projects and addresses issues as appropriate
• Works with Director on budget forecasts and preparation
• Worked with client leads on HANA POC for Budgeting & Finance reporting
• Designed and Developed Attribute, Analytical & Calculation views for Funds & FI data
• Designed and developed BW Transient Info provider on top of HANA Views.
• Implemented HANA security by developing Analytical Privileges on Calculation views
• Tested Hierarchy loads for Attribute views
• Supported Confidential Business after Go Live, Monitoring Data loads and validating the Service Packs. Working with SAP in fixing Confidential issues by applying Service Packs

Confidential, NY

BI/ Confidential Solution Architect

Responsibilities:

• Designed the data flow and the architecture for Spend Analytics.
• Proposed Reporting Strategy for Spend Analytics reporting
• Analyzing the current Architecture and proposed changes for Reporting and resolved performance issues
• Developed & tested the required DSO's, Cube's & Multi-providers.
• Extracted data by using DB connect to get data from external databases.
• Extracted data from oracle views using DB Connect.
• The purpose is to create Federal & State reports which will be sent to Federal & State governments respectively.
• Designed and validated Generic Extractors in ECC.
• Worked on User Exits and populated values for appended fields in the custom extractors.
• Worked on Start, End & Expert Routines for transformation Logic and for reading the data within BI
• Created process chains for automation of data loading.
• Designed complex BEx queries using Variables, Replacement path
• Designed universes, WEBI & Crystal reports on top of BEx queries.
• Worked with BI 7.0 and EP 4.0
• Implemented Business Objects 4.0, from Patch 2.1 to Patch 2.6.
• Responsible for Creating/Enhancing Confidential Universes using BW BEx Queries, retrieving data from Universes and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client's requirements using, Web Intelligence (WEBI).
• Worked with SAP in fixing the issues with BICS connectivity
• Performance tuning of reports(Web I, Crystal)

Confidential, San Francisco, CA

BI Solution Architect

Responsibilities:

• Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
• Worked on Data Modeling, Data Extraction, Data transformation, Data Loading, Scheduling jobs, Monitoring data loads and Reporting.
• Handled performance tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
• Involved in transportation of objects to target systems and handled transport related issues
• Worked with BI 7.3 and BI 4.0 for publishing BI Dashboards
• Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions
• Tested the BEx Queries, Universes, dash boards using unit testing and integration testing
• Designed and developed the architecture for Cost Center Accounting Module.

Confidential, Chicago, IL

BI Lead Architect

Responsibilities:

• Designed and developed the architecture for Cost Center Accounting Module.
• Proposed the BI Roadmap & strategy for BW/ Confidential reporting.
• Worked on FI-GL, FI-AP, FI-AR.
• Created multiple data store configurations (Dev, QA, and Prod) on every source data store so that the work flow isn't affected when loading the batch job in different environments.
• Worked on Gathering functional requirements for FI & COPA from the Business.
• Created FI Dashboards and published in to enterprise portal 4.0
• Created Generic Data Source for COPA - Account Based, based on the functional requirement.
• Created DSOs and other Info Providers for COPA Data.
• Enhanced 0FI Gl 4 extractor and built custom DSOs for Balance sheet & P&L.
• Built reports on COPA, Balance sheet & Profit Statement.
• Created a Multi Provider on COPA & FI Info Providers.
• Extracted data from Material Classification Data Sources.
• Transported Objects to QA, loaded data and validated. Moved to Production System and validated the Data.
• Created Process Chains for scheduling FI & COPA data loading.
• Responsible for the validation of workflow.
• Tested the BEx Queries, Universes, dash boards using unit testing and integration testing.
• Involved in design & development of dashboards using Xcelsius, Universe Designer,QaaWS & WebI with BW as Data Source

Confidential, Long Island, NY

BI Solution Architect

Responsibilities:

• Involved in all phases of BI BPC integration.
• Involved in Gathering Functional and Technical requirements for SAP BI BPC Implementation.
• Gathered Functional requirements and developed business blueprint for BI BO Implementation.
• Worked on SD, MM, FI Modules.
• Extraction of data from 0FI GL 12, 0FI GL 10 into BI and exporting the data to BPC using Process Chains and Function Modules.
• Extracted FI Master data into BI and exported to BPC.
• Mapping of Info Objects from BI to Dimensions in BPC using transformations.
• Created Process Chains for Automation of Master Data & Transactional Data loading into BPC.
• Created Inventory reserve report by using a generic data source on MBEW as per the business requirements.
• Worked on setup of LO Cockpit for sales data and extraction to BI.
• Involved in extracting FICO and COPA data from SAP R/3 to SAP BI
• Worked extensively on change requests (CR).
• Interacted with the client & involved in enhancements and cut-over.
• Extensively worked on designing process chains for scheduling data loads.
• Created queries on FI, SD, MM data using BEx.

Confidential, Lynchburg, VA

BI/BO Architect/ Lead

Responsibilities:

• Involved in all the phases of Confidential implementation and SAP BI/BO Integration.
• Guided the Installation and configuration of Server/Client components of BO Enterprise tools (BO Enterprise XI 3.1), and SAP BI/ Confidential integration kit.
• Created, designed and implemented Universes, WebI, Crystal Reports, and Xcelcius Dashboards.
• Gathered and analyzed business requirements and translated them to functional requirements
• Designed and created ad hoc reports for business users using WebI.
• Interacted and collaborated with business users in design of high level dashboards using Xcelcius.
• Extensively worked on designing process chains.
• Interacted with the client & involved in enhancements and cut-over.
• Enhanced the existing master and transaction data extractors in SAP R/3.
• Involved extracting master data to 0COSTCENTER, 0MATERIAL, 0PLANT, 0COSTELMENT, 0CUSTOMER, and 0CUST SALES etc.
• Involved in extracting FICO and COPA data from SAP R/3 to SAP BI.
• Written ABAP code at user exits in SAP R/3.
• Created Multi providers and enhance reporting flexibilities.
• Extracted and enhanced data sources from various SAP modules: GL, AP, CO-PA. Data Sources 0FI GL 4, 0FI GL 6, 0FI AP 4, 0CO OM CCA 9 and etc..,
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in production Outage and Cutover periods.
• Design and configure BW queries and workbooks utilizing BEx functionality.
• Created reports in BEx Query Designer.
• Supported data load monitoring team.
• Provided End user support and guidance to use reports.
• Involved in handling TT's raised in Remedy during the failure of process chains in BWP system

Confidential, Philadelphia, PA

Sr. BI Consultant

Responsibilities:

• Analyzed the SAP BIW Business Content required, activated the business content components
• Created Generic Data Sources using database Views on Tables.
• Worked with Logistic and FI data sources 0FI AR 04 and 0FI AP 04, developed generic data sources, and worked with tables and function modules for these data sources.
• Managed and monitored several data loads with millions of records.
• Optimized load performance by adjusting the packet sizes and resolved the errors and inconsistencies during the data loads.
• Developed ABAP user exits in SAP R/3 for appended fields in the extract structure.
• Using Visual Composer created iView's and assigning them in portal.
• Transporting the objects from DEV to QA and DEV to Production using transport organizer.
• Worked extensively on Trouble Tickets.

Confidential, Chilcott - NY

Sr. BI Consultant

Responsibilities:

• Activation of Business Content data sources for 0FI Gl 04, 0FI GL 06, 0FI GL 07.
• Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Extensive work done on Process Chains as well as performance enhancing Aggregate tables and system settings and parameters to speed up loading as well as reading of data.
• Involved in consistency check in aggregates and Attribute Change run.
• Extended business content data sources and worked with user exit coding.
• Involved in the design of the Process. Development of required backend development such as Info Providers (Cubes, DSO, and Master Data Objects), Transformations, DTPs, Open Hub.
• Installed Info Objects, Data Sources, Info Sources, Data Targets, Info Packages and Info Providers to load master and Transactional data from SAP R/3 System into BW System as per the client requirements.
• Created and maintained Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi Providers, Info Sources, Data Sources, and Info Packages.
• Extensively involved in setting up of procedures for extracting data from SAP R/3by using Generic Extraction and customizing LO Cockpit by using enhancements.
• Extracted transaction data for sales from R/3 on a daily basis and master data for customers and vendors on a weekly basis used delta initializations and delta loads.
• Extracted data from SAP R/3 using Generic extraction techniques and LO cockpit and loaded into Sales Order Info Cube using Data Sources.
• Developed and maintained the Info Cubes, ODS objects, Info Sets and Multi-providers.
• Created ABAP routines in transfer rules and update rules.
• Created Multi cubes for Customer and Vendor Cycle Core Returns, Sales Order Item Quantity, Sales Order Header for Fill rates.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global Views.
• Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down/summarized way to give detailed levels of information.
• Gathered reporting requirement and Designed Data flow from SAP R/3 to BW for specific Functional areas like Material Management and Sales Distribution.
• Developed various Sales and Distribution reports as Sales overview, orders, deliveries, service level orders and purchase orders.
• Created technical analysis deliverables, test plans and other technical specification deliverables within the standard project lifecycle.
• Created Aggregates, Compressions, Partitions and Indexes to improved query performance
• Scheduled jobs for loading data into Info Cubes, ODS objects from SAP R/3, non-SAP systems and flat files and monitored Process Chains to run periodic loads.

Confidential, St.Louis, MO

Sr. BI Consultant

Responsibilities:

• Involved in extracting FICO and COPA data from SAP R/3 to SAP BI.
• Created Complex Queries using user exit variables.
• Created WAD reports using Web Application Designer and assigning into portal.
• Created process Chains and scheduled daily and monthly data loads.
• Transported objects from dev to pro using transporter tool in BI using Transport organizer
• Created iviews in WAD and assigned them in portal.
• Created User exit variables based on time period.
• Designed custom extractors in R/3 for extracting planned orders, Purchase requisitions and Demand planning data.
• Worked on the complex extraction logic for sales information integration with accounting information
• SD implementation: worked extensively on sales extractors 2LIS 11 VAHDR, 2LIS 11 VAITM & 2LIS 12 VCHDR, 2LIS 12 VCITM, 2LIS 13 VDHDR, 2LIS 13 Confidential & 2LIS 13 VDKON.
• Implemented 0FI GL 4 extractors based on BKPF and BSEG tables and to capture accounting document level details enhanced extractor by adding additional fields.
• Based on business requirement implemented SAP notes to run data load minute by minute.

Confidential, Boston, MA

Senior BI Consultant

Responsibilities:

• Involved in the Business meetings to understand the business & requirements.
• Coordinated with the functional team to prepare the specifications for the requirements.
• Closely associated with Data Modeling and data administration team. Conducted several meetings to discuss the issues with schema design.
• Involved in collecting data from Business owners, Business users. Analyze the data for DSS and report generation.
• Transported the Objects from Development to Quality to Production once the testing finished.
• Extensively involved in the loadings like Daily, Weekly and Monthly for Deltas.
• Actively involved in monitoring the Data Extraction from Source Systems into BW.
• Solved PSA Errors with in time to make available that data for reports.
• Worked on Custom Info cubes creation, defining Info cube Data Structures, assigning Characteristics to Dimensions, defining Update Rules for Info cubes, joining of Info cubes.

Confidential, El Centro, CA

Senior BI Consultant

Responsibilities:

• Created Functional Specifications & Technical Specifications for Data Modeling.
• Activation of business content in SAP-R/3 and BW.
• Created custom info Objects and Info Providers (ODS objects, info cubes and multi providers).
• Worked on Cost center accounting, general ledger and xRPM data sources.
• Created generic data sources in SAP-R/3 in HR time & Event management, & IS-Utility.
• Did user exit coding in SAP-R/3 to populate the values for the appended fields.
• Created Transfer rules and Update rules.
• Mapping tables to populate the values in info providers using Update rules.
• Data extraction from SAP-R/3.
• Flat file data extraction (transactional and master data).
• Developing queries, CKFs, RKFs, variables using Business Explorer.
• Collecting the transportable objects using transport connection tool in BW.
• Transported the objects from Dev system to Q/A system.

Confidential, Detroit, Michigan

Senior BI Consultant

Responsibilities:

• Billing - Extracted the Billing at Item level data (2LIS 13 Confidential ) into ODS and Info Cube.
• Manipulated the data in Update routines to match the custom requirements of the client.
• Sales - Extracted the data using 2LIS 11 VAITM (Sales at Item level) and created ODS and Info cube.
• Shipping - Created Info Cube and extracted to be delivered qty to restrict the size of the Info Cube, using data source 2LIS 12 VCITM.
• Designed MultiProviders on Billing, Warranty, and Objectives & Historical Data to produce Parts Statistical Reports, which are to be used extensively by the Field Account Executives replacing the Field laptop Application that was laborious and time consuming.
• Warranty - Using DB Connect extracted warranty information on weekly basis from the view created in Business Objects.
• Web Reporting - Designed the Web Template. Released multiple queries in single template and assigned them to the roles in PFCG.
• Authorizations - Involved in the creation of roles and authorizations and assigning to users.
• Extensively did the transport of Objects into Quality & Production using STMS.
• Conducted Training for the end Users at the depots.