SUMMARY

• Over twelve plus years of IT experience with nine years in SAP HANA/BW/BI/BO with multiple full life cycle implementations.
• Active participation in all phases of BW/BOBJ/Tableau projects including requirements gathering, Modeling, Development, Testing, Cutover, Training, and other Support activities.
• Primarily focused on SAP BW end - to-end implementation, consistently playing key roles such as team lead, developer and analyst in various projects.
• Strong team leading experience in various SAP BW 7x implementations over the past 5 years.
• Experience with SAP HANA data modeling using Attribute View, Analytical View and Calculation view.
• Worked on SAP HANA implementation project with SAP BW on HANA Landscapes.
• Extensive experience working on Global projects with teams spread all around the World.
• Experienced in designing/developing ADSO’s, Composite providers, Open ODS, InfoCubes, DSO Objects, InfoSources, InfoObjects, InfoPackages, Transformations, Aggregates and Monitoring.
• Created reports using Business Explorer (BEx), Business Web Analyzer with InfoProviders such as InfoCubes, DSO Objects, MultiProviders, InfoSets etc.
• Experienced in writing SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like Tracing, Using the SQL Script Debugger.
• To support the needs of external system, developed several APD’s and Open Hubs destinations
• Extensively worked on Process Chains, Daily/Weekly/Monthly background scheduling of Process Chains, Monitoring, in both BW and APO systems
• Very good understanding of APO BW concepts that are relevant to successful implementation of APO DP, SNP and GATP.
• Extensively worked with Business Objects Designer, WebI, and WebI Rich-Client (4.1).
• Helped end users with query development and assisted other Consultants with front end support.
• Excellent communication skills and ability to work effectively in fast paced environments.

TECHNICAL SKILLS

ERP: BI 7.0/7.1/7.4 Netwever 2004 S, BW 3.5, ECC 6.0/ 5.0, SAP HANA 1.0 SP12S/4 HANA 1511/1610, SAP BW/4 HANA, SAP Data Services, SAP BPC 10.1SRM 7.0, CRM 6.0

Reporting Tools: Business Explorer (BEx), Business Objects (4.2 SP 2), Information Design, SAP Design Studio 1.3, Lumira 1.31, Analysis for Office, Apache Hive

Languages: ABAP, C, C++, Python

Databases: Oracle, SAP HANA, MS-Access, SQL Server and Teradata, Hadoop/HDFS

Operating Systems: Windows 2000/NT/XP, MS-DOS, UNIX, Oracle 11x, My-SQLSQL server 2008, SQL server 2012

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

SR. SAP BW/HANA consultant

Responsibilities:

• Responsible for gathering requirements for Global KPI/Treasury/FSCM/Spend/PCA/SRM projects.
• Responsible for Modelling, Development and Production.
• Responsible for Application Support and minor enhancements/code fixes.
• Responsible for working/coordinating with different regional BW teams (NA, Brazil, Argentina, EMEA, Asia) to move necessary data to Global BW box.
• Creating the data modelling views based on business requirements.
• Using the SAP HANA studio created data modelling for analytical, attribute and calculation views, Stored Procedures.
• Created Components like ADSO, Composite provider, DSO Objects, Data Marts, MultiProviders, Start Routine, Transfer Rules and End Routines.
• Created Generic Extractors, Generic Data Sources and enhancements.
• Managing Global off-shore/on-site resources.
• Identifying performance issues and providing solutions by business areas.
• Preparing estimates and proposals for upcoming projects.
• Built PTP Dashboards using the BOBJ 4.2 SP2 Reporting Tools connected to Bex queries.
• Created Open Hub Destinations and APD’s using BEx queries as source.
• Involved in SAP BW upgrade from SAP BW 7.1 to SAP BW 7.4 HANA.
• Involved in Pre upgrade and Post upgrade activities.
• Involved in User Acceptance Testing UAT and documentation.
• Follow the company procedures to migrate objects from the development environment to QA quality assurance until the production server.
• Provide training to the final users about the correct use of the new business Intelligence elements.
• Support Tableau team for dashboard reporting.

Confidential, Dallas, TX

Sr.SAP HANA Reporting Analyst

Responsibilities:

• Responsible for gathering requirements with regards to Seller / Operational / Company Metrics Reporting and created the Functional & Technical Specification documents.
• Extensively worked on HANA modeling and HANA Application Development (Using Native XS & Database client interfaces)
• Involved in creating the External / Internal Users Workflow for the proposed C2 Seller / Aurora Seller driven Reports.
• Participated in hands-on modeling of Attribute, Analytic and Calculation Views using Projection / Aggregation / Join / Union approaches using the graphical model within SAP HANA Studio.
• Created Analytical Views to support multi-dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views), selected attributes and measures.
• Created calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE studio.
• Built the Loss Type and Vehicle Type Reports using the SAP Design Studio 1.2 and 1.3 / HANA XS Reporting Tools connected to SAP HANA Calculation Views.
• Extensively worked on the Microstrategy 9.4.1 Architect and the Microstrategy Web / Desktop Reporting tools to develop the Loss Type and Vehicle Type Reports using the Microstrategy 9.4.1 Reporting Tool connected to SAP HANA Calculation Views.
• Completed POC to confirm the connectivity from SAP Design Studio 1.2 / Microstrategy 9.4.1 to Sybase IQ demo database.
• Developed data flows and work flows using BODS.

Confidential, San Jose, CA

Senior BI-BO Consultant

Responsibilities:

• Responsible for gathering requirements along with the functional team and developing the Functional & Technical Specification documents.
• Worked on business content GAP Analysis to determine the need for developing custom extractors and custom models.
• Worked with SD, MM, HR and FI and Extracted data from APO System to SAP BW system. Worked on generic data extractors to extract customized data from tables and Functional Modules to suit the Business Warehouse model.
• Worked with LO cockpit extraction for extracting sales order and billing information to BW. Worked on setup tables to fill the data by creating variants based on document ranges.
• Worked with Start routines, End routines in the transformation and User exit code in CMOD.
• Uploaded master and transactional data from SAP ECC source system and Flat Files.
• Daily data load Monitoring of the BW jobs. Ensuring daily data uploads from SAP ECC to BW is successful and mail notification on status of upload.
• Involved in maintaining the performance issues with InfoCubes i.e., creating aggregates, indexes and rollup into aggregates and InfoCube compression.
• Developed BEx queries for reporting on InfoCubes, DSO and Multi Provider by defining calculated key figures (CKF), restricted key figures (RKF), structures, exceptions and conditions, variables.
• Worked on deployment of Webi reports.
• Developed and modified Universes using BO Universe Designer to get data from BW Info Cubes & Queries, and created reports using Webi.
• Extensively created and used alerts, rankings, sorts, and drill-down in reports.
• Worked closely with the end user to give the knowledge about the reports that were developed as per the requirements.

Confidential, Greensboro, NC

SAP BI Developer

Responsibilities:

• Solving level-3 tickets.
• Monthly Report Broadcasting to the entire hierarchy of Employees.
• Monitoring of data loads and analyzing the reasons for frequent failures of info packages. Reconstructing the data requests from PSA in case of data load failure. Monitored data loads with full update and delta mechanisms for both master data and transaction data.
• Tracking the loads of data targets from the different source system. Making sure that all the R/3 jobs are scheduled and are successful. Maintaining Documents like Load Tracking Sheets and Duty Manager Sheet.
• Handled changed Request at reporting level.
• Implemented Compression of cubes for better query Performance.

Confidential, Irving, TX

SAP BI Analyst

Responsibilities:

• Responsible for understanding the Business Process, Landscape and Architecture for BW system.
• Involved in Ad-hoc query development and data mining.
• Created and monitored Process Chains using RSPC transaction code.
• Developed reports using query designer, BEx analyzer and web application designer.
• Extensively worked in generating reports on Finance Invoices and MM Invoices. Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respective periods.
• Designed and developed process chains for master data loads and transaction data loads with the help of InfoPackages, the Process chains were scheduled for periodic loads.
• Worked on BI 7.0 testing, Involved in postproduction support activities in monitoring the daily data loads, fix report issues and reconciliation issues.
• Expertise in creation of BEx Queries, structures, variables, calculated key figures, restricted key figures and RRI reporting.
• Support and enhance NT and DOS based postal address lookup software systems. Enhancements included required changes to algorithms for annual USPS certification process (CASS).
• Improved the Sort Rate of UK Post/MERLIN by improving address block detection, text recognition, line formation.
• Coordinated with different teams to report/resolve issues quickly.
• Upgraded existing install shield project from install shield 5 to install shield 9.
• Responsible for developing new install shield projects in install shield 9 and maintained old ones.
• Responsible for analyzing, maintaining, coding, and testing programs