SUMMARY:

• Around 15years experience in SAP BW/BI implementation, SAP HANA,SAP ABAP,SAP Business Objects (BO),SAP BPC which includes 9 full Life Cycle Implementationsand Production support following ASAP methodologies in various domains like Retail,Travel,healthcare,Oil&Gas,Chemical, Telecom and Manufacturing. Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in - depth business process knowledge.
• 14Years’ Experience in SAP BW/BI with ABAP with 9 Full life Cycle Implementations.
• 4Years’ Experience on SAP HANA with 4full life cycle Implementations.
• 6 Years in SAP Business Objects (SAP BO 3.1, 4.0).
• 6 Years in SAP BPC
• 3 Year Experience in SAP BODS 4.0, 4.1.

TECHNICAL SKILLS:

ERP Packages: SAP ECC 6.0, R/3 4.6

Expertise: Programming, problem solving, Design patterns, Research and development, Mentoring/, Testing

SAP Modules: BW, HANA, BO, BI-ABAP,BODS Data Services, SQL (For HANA)

Modules: HR,SD,FI,CO,PP,MM,SRM,CRM,IM,WM

Platforms: Windows, SUSE Linux (Only HANA DB relevant activities)

Databases: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access,DB2,Teradata

Skills: SAP BI-BW - 3.5, 7.0, 7.3,7.4 (on HANA)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr SAP BI/BOBJ/HANA Architect

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.4, SAP BO 4.0,SAP BPC 10.0

Responsibilities:

• Working very closely with internal client team as well as with the implementation team.
• Will be walking into the very early stages of the project and will be responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
• Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
• Experience in Understanding the Business requirements & convert them into Blueprint
• Experience in Defining the Design Documents for the HANA Models
• Experience inEssential Configurations for SAP ECC Accelerations using SAP HANA
• Experience in Translating Functional Specifications into Technical Specifications
• Experience in Translating the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Created complexJobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data usingData Qualitytransforms.
• Proficiency in data warehousing techniques forSlowly Changing Dimensionphenomenon, surrogate key assignment andChange Data Capture.
• Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts includingStar-schema modeling, Snowflakes modeling, fact and dimension tables.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.
• Experience of working on HANA projects related to Business Suite on HANA - ECC,CRM,SCM and APO
• Worked as Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
• Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
• Experience includes end to end Implementations, support, and upgrade, roll up projects as well as solution Architecture and Pre Sales.
• Authoring Presenting Business Cases, Investment Areas, and Architectural Views to demonstrate value of technology/initiatives.
• Building SAP HANA Strategy& Managing a team of Architects and developing a go-to market strategy for SAP HANA including demand generation, marketing propositions.
• Pre-sales Specialist with knowledge on strategic SAP HANA/BW implementations.
• Propose unique strategy on adopting HANA, more specific to customer Business case
• Ability to Re-Architect the current BI solution with SAP HANA as Database, BW as EDW layer & BO BI as Analytics solution.
• Having expertise in delivering HANA projects like BW on HANA Implementations,
• Adopt and follow SAP’s roadmap on various products like Design Studio, Predictive Analytics & SAP Lumira.

Confidential, Houston, TX

Senior SAP BI/BOBJ/HANA Architect

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3,SAP BO 4.0

Responsibilities:

• Data Provisioning using FLAT FILES
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
• Data Provisioning using BODS 4.0
• Building Data Flows in Designer (to Load the Data to SAP HANA)
• Data Modeling
• Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
• SAP HANA SQL
• HANA, Reporting Layer
• WEBi 4.0 on HANA
• Migration of BW to HANA.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Migration from BW to BW-HANA.
• Done the migration with PCA - Post Copy Automation Tool which is an automated solution for delta queue cloning and synchronization on the production systems for BW on HANA migrations based on a BW system copy.
• Rapid database migration of BW on RDBMS to BW on HANA
• BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system
• Carving out a part of large BW and moving only relevant content (like for a business unit or region)
• HANA as real time, high value agile/custom data mart and later migrating BW to BW on HANA
• New projects, initiatives on new BW on HANA installations.
• Performs activities required after the initial system copy of a SAPNetWeaver BW system reliable.
• Done with post migration activities.
• Created Functional Designs and Technical Design documents based on real-time report
• Requirements to be implemented on HANA enterprise along-with requirements of accelerated BW based reports.
• Worked on data provisioning from Teradata systems using Data Services and from SAP ECC using SLT servers.
• Worked on creating Attribute views, Analytical views & Calculation views based on requirements and data-warehousing standards.
• Worked on SQL based authorizations and CE functions.
• Worked on row level authorizations & hierarchies.
• Created trend reports by combining imported SAP BW data models (InfoCubes) with historical data and real-time data from HANA models.
• Consumed HANA models into Explorer, Advanced analysis, Crystal and Webi reports.

Confidential, Houston,TX

SAP BI/BOBJ/HANA Architect

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0

Responsibilities:

• Worked on the SAP HANA POC project.
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
• Developed complex SQL scripts in Calculation views.
• Worked on Schemas, table definitions, Attributes, Measures & Hierarchies in HANA.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Creating Attribute Views, Analytical Views, and Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
• Migration of Oracle 11.2, IBM DB2 LUW 9.7 to HANA.
• Done with Unicode conversion.
• BW on HANA fresh installation and moving only the required, data models& content, in the process optimize and cleanup the BW system.
• Performs activities required after the initial system copy of a SAPNetWeaver BW system reliable.
• Done with post migration activities.
• Utilized new BI 7.3, Dataflows, transformations and DTPs for all new developments.
• Developed numerous custom datasources using database views and custom function modules.
• Implemented new BI 7.3 security authorization objects.
• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
• Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3.
• Involved in creating many complex OLAP variables, DTP routines.
• Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
• Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billingsby extractingStandard DataSources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.

Confidential, CINCINATI, OH

Sr.SAP BW/BI/BOBJArchitect

Environment: SAP BI 7.0, SAP ECC 6.0, FI, SD, MM, HR, BEx, Business Objects 4.0

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Cost Center Accounting (CO-CCA), Purchasing and customized them as per the client requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multiproviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 with proper transfer rules and update rules.
• Extracted Master and Transaction Data from Flat files and loading into Info Objects, DSOs and Info Cubes.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Migrated Data Sources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Extracted Master and Transaction Data from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Worked on FI - GL, FI-AR, FI- AP, FI- AA, COPA data sources for extraction and loading of data from FI to BW.
• Creating queries for the cluster using Query Designer involving Calculated and Restricted KFs, different Variables, Conditions, Exceptions, Filters etc.
• Created custom InfoCubes for company wide Sales, Delivery, Billing and Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
• Created and Maintained DTP and InfoPackage for Loading. Created, Maintained and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.

Confidential, Franklin Lakes, NJ

Sr.SAP BW/BI/BOBJ Lead

Environment: SAP Net weaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer.

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions.
• Master and Transaction Data extraction from Flat files and loading into Info Objects, DSOs and Info Cubes.
• Performed analysis, design, development and implementation of standard/customized Info Cubes and DSO Objects for SD, FI and SCM modules.
• Created intermediate write optimized DSO Structures and APD’s in BI7.0 to improve performance while loading AP data.

Confidential, New York, NY

SAP BW Consultant

Environment: BW 3.5/7.0, R3 4.6C, BEx, FI, SD, MM, PP.

Responsibilities:

• Involved in the project from User requirements gathering, Business Blueprint, Realization and Testing Phases.
• Participated in teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.
• Interfaced the business users to develop an understanding of the business processes and user requirements at a depth sufficient to recommend and implement an appropriate BI solution to meet business needs and address the enterprise BI vision within the company.
• Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Extensively involved in the scheduling and monitoring using process chains in Administrative Workbench.
• Provided complete solution in BW in the following metrics analytics Sales and Distribution, Account Receivable, Account Payable, and Profit Center Accounting.
• Managed, and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Ensured BW data quality, reconciliation and validation with R/3 and external Source Systems, governance, and master/transactional data alignment/realignment.
• Created queries with variables, filters, exceptions, conditions and developed different reports in SD, AR, AP and PCA functional areas using BEx analyzer.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Extensively used BEx analyzer, created queries with variables, filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.

Confidential, Minneapolis, MN

SAP BW/ BI Consultant

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, MM, IM, FI.

Responsibilities:

• Actively involved in the requirement analysis, data modeling and technical implementation.
• Responsible for Design the FDD's and TDD are based on business requirements.
• Taking care of production support activities like loading the data, monitoring and improve the System Performance.
• Worked on Data modeling Considerations.
• Updating the Marketing attributes from BW to CRM Using APD Interface.
• Worked on Customer 360 view to increase the effectiveness of employees who are interacting with Customers.
• Designed and developed the multiple Infocubes and Multiprovider to analyze the Opportunities, Activities, Quotes, and Contracts.
• Developed the Sales order, Delivery, Backlogs, and Billing info cubes based on the client reporting requirements.
• Worked on reports (Billings, Bookings and Backlogs) using Bex.
• Worked on Campaigns (Saves and MSF).
• Worked on reports (Order process, Saves, Student services, Coaching, Retentions, and Inside sales) using BEx published the reports into the roles.
• Created the process Chains and automated the load process based on the business needs.
• Worked with SAP on CRM Extractor Delta Issues and suggested the Basis Team to Apply the OSS Notes in the system.
• Resolved many issues that came in Production support
• Environment: SAP BW 3.0B, Oracle, CRM 3.1, R/3 4.0, Java Script, and Non SAP systems.
• Worked extensively in the finance modules like FI-AR (Accounts Receivable), FI-AP (Accounts Payable) and FI-GL (General Ledger).
• Installed Business content for FI-GL, FI-AR and FI-AP business content cubes according to the business requirement.
• Extracted Data from Purchasing and Inventory Management.
• Extracted data from MM module and uploaded the data into the procurement cubes.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.

Confidential, San Ramon, CA

SAP BW/BI Consultant Duration:

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, MM, HR, FI, CO

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live and production support.
• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI in SD, MM and FI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content.
• Analyzed business reporting requirements that could be satisfied and activated/modified corresponding Business content InfoCube Sales
• Extracted Data from Purchasing and Inventory Management.
• Extracted data from MM module and uploaded the data into the procurement cubes.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.

• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Infocubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data targets in the system.
• Monitoring the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data targets.
• Maintaining the logs for each manual load.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates, indexing of Infocubes.

Confidential, Glendale, CA

SAP ABAP Consultant

Environment: SAP R/3 4.6C, SD, MM, IM, FI.

Responsibilities:

• Understanding the requirements and getting clarifications for the change requests and Enhancements,
• Documentation process for production related issues.
• Preparing TSD, QG4, QG5, Approval related documents.
• Preparing Test Plan Specifications and conduct Unit Testing.
• Coordinating the reviews and Code Walk Through with Internal Quality Assurance, External Quality Assurance and Final Inspection.
• Shipping the deliverables to the clients directly.
• Developed a report to check current moving average standard price and purchasing frequency of purchased material and to revise the ordering frequency of materials.
• Developed a report to display the stock status of the materials including the stock on order.
• Developed a Shipping performance report.
• Developed a report for displaying sales order details using ALV.
• Developed a Vendor expenses summary Report.
• Developed Print program to Print BAR Code for Production Order.
• Developed an interactive ALV Report, which displays customer's numbersALV grid, and customer orders and items displayed in interactive lists.