SUMMARY

• SAP HANA Consultant working 2+ years in SAP full life - cycle HANA implementation with extensive SAP HANA Data Modeling, Data Provisioning, HANA Administration and Reports developments.
• Overall 11+ years IT experience this includes SAP BW/BOBJ/ABAP Business Intelligence/Data warehousing experience with multiple end to end implementation experience.
• Excellent ability to understand and transform complex business requirements into functional design document for solution development, delivered on time, to specification, scalable, performance optimized and maintainable.
• Ability to interact with end-Users to understand various business requirements.
• SAP HANA business requirements architecture on SAP & non-SAP source systems including SAP BW on HANA, SAP BOBJ in large and complex environments..
• Modeling of SAP HANA objects and developed Attribute Views, Analytic Views with various join conditions and calculation views using both Graphical and SQL script based methods.
• SAP HANAprogramming including SQL, SQL Script, and CEScript.
• Proficient in creating Calculated Columns, Restricted Columns, Filters, Hierarchy, etc
• Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), SAP Data Services, for replication/ extraction of data from SAP/ non-SAP source systems and on HANA integration tools.
• Expertise in SAP ECC table data model and analysis and good experience with non-SAP source systems.
• Proficient in SAP HANA Administration including managing schemas,data model objects,import/export content.
• Proficient in SAP HANA Live & Rapid Deployment Solutions.
• Good exposure to smart data access.
• System Development Life Cycle experience: Project Planning, Scoping, Requirement Gathering, Analysis, Design, Development, Testing, Deployment, Post Production Support, Documentation and User .
• Extensively worked on SAP BW/BW on HANA backend components like HANA Optimized InfoCubes, HANA Optimized DSO’s, Composite providers, Virtual Info providers,SPO,Multi-Providers, Info Source, Master data infoobjects,openhubs, APD’s,Transformations,various routines, Process chains and Performance tuning.
• Expert in installing business content and connecting BW to various SAP and Non-SAP source systems.
• Expertise in Data Extractions for Logistics Applications SD,MM,PP,QM, financial applications (AP,AR,GL,AA), CO-PA,, HR,PS,SRM,CRM&B,Generic data extraction and flat file extraction.
• Expertise on ABAP coding during transformation in Start Routine, End Routine, Infopack routines, field routines, Datasource enhancements and customer exits.
• Expertise on Business Explorer Suite tools. BEx Query Designer, BEx Analyzer and WAD.
• Expertise in building queries using Reusable structures, Conditions, Exceptions, filters, Restricted Key Figures, Calculated Key Figures, Variables and RRI’s.
• Excellent cross-functional knowledge of SD,MM,SRM, HR,CRM and finance applications AP, AR, GL and controlling.
• Experienced on SEM BPS (Planning, Budgeting and Forecasting), Integrated Planning.
• Good working knowledge on BODS for data transformations.
• Developed various reports using SAP BO Tools such as IDT (Information Design Tool), Web Intelligence, SAP Lumira, BO Explorer, crystal reports and developed dashboards using the Dashboard Designer.
• Configured and maintained single and multisource universes in Information Design Tool (IDT) as Business semantic layer to consume HANA Info models/Non SAP applications using BI reporting clients.

TECHNICAL SKILLS

Data Warehousing: SAP HANA 1.0 SP 05/06/07/08,HANA studio

ERP: SAP ECC 6.0/ 7.0; SAP Netweaver BI/BW 7.3/7.4

Functional Modules: SD,MM,PP,QM,FI - AP,AR,GL,CO-PA,HR,PS,AFS,CRM,SRM,SCM

Reporting Tools: SAP BO Tools WEBi, IDT, UDT, Crystal Reports on Enterprise, SAP Lumira, Business Explorer

Dashboards: Dashboard Designer, Xcelcius

SAP BW Tools: Business Explorer (BEx), Bex Analyzer,WAD

Data Provisioning: SAP Landscape Transformation (SLT); SAP BODS; Direct Extractor Connection (DXC);MSExcel flat file

Databases: HANA 1.0 SP 6/7/8; Oracle 11g, Sybase, DB2, SQL Server

ETL tools: SAP BODS 4.1/4.0/3.2,BODI,Data Federator, Rapid Marts

Job Scheduling Tools: Autosys,Redwood, Tivoli

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SAP HANA/BW Solution Architect

Responsibilities:

• SAP HANA business requirements for technical and functional rollout for SAP and non-SAP source systems to include in the reporting tools.
• Translated the business KPIs into HANA and defined the reporting Layouts. Designed and developed SAP HANA data Modeling architecture.
• HANA Phase II: Included creation of Financial Close models fromSAPand non-SAPdata to create BOBJreports using Webi and Analysis for office. There was Real Time Data Provisioning via SLT from ECC to HANA and from ORACLE to HANA. Another component was to send GLsummary data from HANA models to an external CPM system via Data Services . This was to achieve a 360 degree reporting.
• HANA Phase III: Included creation of CRM and Logistics(SD,Purchasing ) and Project system HANA models from SAP CRM and ECC with real time data Provisioning via SLT.
• Designed and developed for HANA Phase II and Phase III Implementations.
• Data provisioning using SAP Landscape Transformation (SLT) for replication and loading.
• Identified the Purchasing HANA live content related VDMs for Purchasing reports and installed VDMs(Virtual Data Models) related HANA views (PurchaseOrderHeader, PurchaseOrderItem, Purchase Document Schedule line) in the HANA and customized these views as per business requirment and latter BOBJ reports are developed on these views.
• Created SAP HANA modeling scenarios and activities such as adding systems, creating schemas and content models.
• Modeling and developing of SAP HANA objects packages, Attribute Views, Analytic Views with various join conditions.
• Developed complex Calculation views using graphical,SQLscript, CE functions and stored procedures which carries maximum calculations in HANA minimizing the level of effort for BOBJ reports
• Evaluate impact of different implementation options such as table joins, aggregation, Projections or filters. Understanding of performance implications of the various reporting tools and connection
• As per business requirements developed various Calculated Columns, Restricted Columns, Filters, Hierarchy, variables and input parameters.
• STL transformations were used to pre populate the tables with additional fields
• Designed SAP ECC table data model and analysis. Developed various HANA views in the CO-PA,financial reporting, and in the SCM reporting.
• Additional responsibilities included coordination during Integration testing, Key user, resolving defects during integration.
• Developed Balance Sheet Period-wise Comparison Reports, Income Statement Period-wise Comparison Reports, Trial Balance Period Comparison etc
• Developed CRM Reports to view the Sales orders, Opportunities and Quotes for all the Regions, which includes view by Product Base on Product groups ( Divisions)
• As per business requirement developed the CRM&B related reports like OpportunityPlan,Activities by Category,Activity Details.
• Involved in business requirement gathering, gap analysis and designed the technical specifications, development,testing and implementation. and involved in the functional specifications.
• Working directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions . Involved in the functional specifications.
• Designing, mapping, and creating HANA Optimized InfoCubes, HANA Optimized DSO’s, Virtual providers, Composite providers, SPO, Multi providers, Master Data Info Objects, Openhubs, APD’s and Process chains.
• Integrated planning,design,implementation and support ofSAP HANAbased solutions including BW on HANA and SAP BI/BOBJ in complex environments.
• Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and in user Exits where needed.
• Integrated various functional applications with BW for reporting purpose and developed various reports in financial areas AP, AR, Controlling, and Invoice verification, and SRM.
• Provided and managed project schedules to meet project deliverable timelines.
• Managed daily calls and issues tracking/resolution and change requests.
• Performed Unit testing, integration testing and coordinated UAT with business stakeholders and involved in go live activities.
• Developed open hubs and APD’s to generate flat files and distributed data from a BI system to non-SAP systems (OBIEE), analytical applications.
• Created formula variables, exceptions, customer exit variables, Calculated, Restricted key figures and structures for developing complex custom reports.
• Have worked on the upgrade Project - SAP BW 7.31 to SAP BW 7.4.
• Involved in HANA pre & post HANA activities such as maintaining the issue log report, Info Cube’s conversion, identified & implemented SAP Notes etc.
• Developed complex web intelligence reports by combining multiple queries and Formatting reports, generation of graphs etc as per user requested format.
• Configured and maintained single and multisource Universes in Information Design Tool (IDT) as Business semantic layer to consume HANA Info models using BI reporting clients such as Webi, Business Explorer.
• Developed project dashboard and various dashboards as per business needs.

Environment: SAP HANA 1.0, SP06,SP07,SP08,HANA Studio,HANA live browser, SAP BW 7.4, 7.3,7.0,SAP ECC 6.0, FI, AP, AR, GL, CO-PA, Controlling, Logistics SD, Purchasing,Inventory,Invoice verification, PP, SRM, Project systems, CRM&B, Business Objects 4.1, Launch Pad, Web Intelligence, IDT, Analysis, Dashboard Designer,Business explorer,Lumira.

Confidential, Atlanta, GA

SAP BW Architect

Responsibilities:

• Involved in business requirement gathering, gap analysis and designed the technical specifications and involved in the functional specifications.
• Working directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions.
• As per reports requirement designing, mapping, and creating SAP BW Master Data Tables, InfoCubes, DSO’s, Virtual providers, Data Sources, Multi providers, Info Objects, Openhubs,APD’s,Process chains and various Data source enhancements.
• Activating the CRM Quotations, Sales Orders and Opportunities Backends and its corresponding reports .
• Re Configuring the CRM Business contents Data providers and its reports as per business requirements.
• Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and datasource enhancements.
• Extensively carried out LO Data extraction involving maintaining and activating the data sources, filling the setup tables and executing the V3 jobs.
• Extensively worked on generic data extraction and created various generic data sources based on tables, views and function module.
• Wrote ABAP code with data source enhancements using User Exits to the Extract Structure.
• Developed custom hierarchy by utilizing ABAP program for region sales reports and also created managed-by hierarchy by using flat file for NRS COD Scorecard reports for which source system is Teradata.
• Created various RED score store reports, RED total score report, cases on display scorecard, cases on display detail report and trend analysis reports.
• Utilized generic data extraction and created various generic data sources based on tables, views and function module.
• Generated open hubs and APD’s to generate flat files.
• Created exception aggregates, formula variables, conditions, exceptions, customer exit variables, Calculated, Restricted key figures and structures for developing complex reports.
• Designed WebI reports using merging dimensions, variables, breaks, sections, conditional formatting, etc.
• Utilized Hyperlinks functionality in WebI for implementing RRI or Jump functionality from Summary reports to the Detailed reports.

Environment: SAP BI 7.3,CRM,SAP ECC 6.0, SD, MM, IM, FI (AP, AR, GL), Controlling CO-PA, BODS,Business Objects 4.0, Universe Designer Tool, Launch Pad, Web Intelligence, IDT, Dashboard Designer.

Confidential, Los Angeles, CA

Sr. SAP BW Consultant

Responsibilities:

• Responsible for the project design and build phase, designed prototype and global planning design based on their business needs.
• Created payment, return lot generic data sources based on views and ADP check extract based on function module and extracted data from SAP source system.
• Developed various reports such as BW aging report-Checks, Disbursement Statistics, Impound Statistics, and Business Partner Retention.
• Created formula variables, conditions, exceptions, customer exit variables, calculated, restricted key figures and structures for developing complex custom reports.
• Developed APD’s on queries to execute and download the data into the external folders.

Environment: SAP BI 7.0, SAP ECC 6.0, SD, FI (AP, AR, GL), HCM, Taxes, Finance.

Confidential, Atlanta, GA

Sr. SAP BW/BOBJ Consultant

Responsibilities:

• Customized extractors to add additional fields and populating the data for those fields via ABAP code using user exits, created generic data sources based of table/views and custom function modules.
• Performed data extraction from AR, AP, GL, asset accounting and cost center accounting.
• Created various transformations to do lookups from various DSO’s, to derive the key figures as per the requirement.
• Extensively carried out LO Data extraction involving maintaining and activating the data sources, filling the setup tables and executing the V3 jobs.
• Designed process chains for regular data loads, performing the initial data load, PSA table, change log table deletion based on retention period and advising the internal SAP team on the BW administration and data loads.
• Created various APD's on queries to execute and download the data into external folders in .CSV format and added new fields as per requirement.
• Developed common set of time dimensions in the reporting infoproviders for various SCM applications (Inventory Management, Inventory Controlling, Delivery Performance, Order Fulfillment Cycle Time)
• Created formula variables, conditions, exceptions, customer exit variables, Calculated, Restricted key figures and structures for developing complex custom reports.
• Developed Backlog /Overdue report, Symptom and action report, stock overview report, Customer Balances and costs, Inter Company Account Payable reports.
• Developed CRM Reports to view the Sales orders, Opportunities and Quotes for all the Regions, which includes view by Product Base on Product groups .
• Responsible for performance tuning of queries using aggregates, partitioning, indexes, OLAP cache, making structural changes of infocubes.
• Created various Webi reports from BW queries through Universe.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web Intelligence.

Environment: SAP BI 7.0, SAP ECC 6.0, SD, MM, IM, PP, QM, FI (AP, AR, GL), CRM, BO XI 3.1, Universe Designer, Web Intelligence, Xcelsius.

Confidential, Houston,TX

Sr. SAP BW Consultant

Responsibilities:

• Implemented code as per the design documents, testing as per the test scenarios and documenting the output results. Fixed the bugs in existing and new programs, creating Test Scenarios with expected and actual results.
• Created InfoObjects, DSO, InfoCubes and Multiproviders as per business requirement and extracted data from external sources.
• Designed process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads.
• Created Income statement reports, balance sheet report and P/L analysis report in BEx as per the user requirement.
• Experienced in the enterprise portal and published many reports in the portal.

Environment: SAP BI 7.0, SD, MM, PM, PP, IM, FI (AP, AR, GL, AA), CO-PA

Confidential, Sharon, PA

Sr. SAP BW Consultant

Responsibilities:

• Analyzed business requirements depending on existing business content, check feasibility, design best practice BI solution to meet client’s requirements that meet business logic and implement.
• Created Info Objects in Data modeling administrator work bench with all business hierarchies including master data and transaction data for GL a/c, profit centers and company codes.
• Extracted sales data from datasources like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASTI Shipping /Delivery data from 2LIS 12 VCHDR/2LIS 12 VCITM and Billing data from 2LIS 13 VDHDR, 2LIS 13 VDITM.
• Created Info Cubes, DSO’s by understanding the specification thoroughly and creating them that suits the business requirement by mapping those using transformations and loading data to data targets Extensively worked on ABAP and created Transformations, DTPs, Start routines and End Routines
• Utilized BEx Analyzer to generate Queries and embedded them into Workbooks.

Confidential, Beaverton, OR

Sr. SAP BW Consultant

Responsibilities:

• Developed the technical design specifications based on the functional design.
• Responsible for the SAP BI full life cycle implementation which included Gap Analysis, design, development, testing, implementation and support.
• Extracted data from the finance modules such as AR, AP and GL and enhanced the standard data sources to meet the client requirement.
• Created InfoObjects, DSO, InfoCubes and Multiproviders as per business requirement and extracted data from external sources.
• Developed Income statement reports, balance sheet report and P/L analysis report as per the userrequirement.
• Proficient in performance tuning techniques which involved the evaluation of statistical performance, data load improvisation and query performance using Compression, Aggregates, Indexes and partitioning techniques

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC 6.0, EP 6.0 FI (AP, AR, GL), CCA, SD, MM,AFS.

CareStream Health, Rochester, NY

Sr. SAP BI Consultant

Responsibilities:

• Solved incidents regarding extractions, Performance issues and also load failures like monitoring of Infopackages and analyzing the reasons for frequent failures of Info packages, Maintaining Work History for all the incidents until it is closed down.
• Responsible for Change Requests (Minor Releases) in the existing design of SAP BW in the areas of Sales, Orders management, Planning and Finance areas.
• Monitored all Administrator Workbench schedules, aggregate loads, realignment runs, DSO loads, and batch jobs.
• Handled year end process and monthly critical financial closing.
• Created BEx complex queries using variables, formulas, restricted key figures and conditions and workbooks with multiple queries.

Environment: SAP BI 7.0, SAP ECC 6.0, SAP BW3.5, SAP R/3 4.7, PP, SD, MM, FI

Confidential, Atlanta, GA

SAP BI/SEM BPS Consultant

Responsibilities:

• Responsible for installing business Content and testing NetWeaver BI 7.0.
• Utilized transformations, start routine, End routine and data flow processes to transfer data to BI 7.0 System.
• Executed Integrated Unit Testing after each phase of changes and also performed Business Acceptance testing.
• Created Direct Schedule Process Chains and used them to create respective Meta-Chains to trigger different loads .
• Developed various RRI / Jump Targets using RSBBS and using customer exits for unique requirements .
• Implemented and supported SAP BPS within the Global Planning System-GPS of Coca-Cola. GPS is an integrated system that uses SAP SEM BPS for Integrated Financial Planning. Maintenance of SAP BPS system and its design.
• Created Planning Areas, Multi-Planning Areas, Planning Levels, Planning packages, Manual Planning, user defined functions, Planning Profiles, Planning folders, Planning sequences, Data Slices, Characteristics relationship.

Environment: SAP BI 7.0, SAP ECC 6.0, SEM BW-BPS, FI, CO, SD, MM, TM

Confidential, Andover, MA

SAP BW Consultant

Responsibilities:

• Made enhancements and wrote User-Exit programs as per requirements,and installed business content.
• Solved incidents regarding extractions, performance issues and also loaded failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages, maintained work history for all the incidents until it is closed down.
• Monitored all Administrator Workbench, aggregate loads, realignment runs, ODS loads,batch jobs, approx. 700 Info packages loaded per day via process chains
• Responsible for performance tuning, which include Compression, Rollup, Indexes, Partitioning, Aggregates, Multiproviders and number range buffer.

Environment: SAP BW 3.5, SAP R/3 4.7, SD, MM, CS, PP, PM, FI

Confidential

SAP BW Consultant

Responsibilities:

• Collaborated closely with the process team to design Functional Specifications document and created Technical Specifications for the same.
• Designed and developed FI-GL, FI-AR, FI-AP data model in BW, responsible for modeling A/R cube, A/R aging Data Mart Cube and A/R Cash cube, A/P Vendor Analysis and GL Reports.
• Developed and implemented some of the most complex business rules by means of update rules/start routines.
• Customized, created and tested BEx Queries to suite as per requirements.

Confidential, Wilmington, DE

SAP BW Consultant

Responsibilities:

• Defined Key Performance Indicators (KPIs) and involved in design the data model and its components within SAP BW.
• Utilized Standard Datasources with LO Customizing Cockpit for extracting Sales, Billing, and Purchase applications.
• Developed some of the most complex business rules by means of update rules/start routines.
• Designed front-end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
• Created Web Templates to include various reports to make the users to get the reports in a very effective way.