SUMMARY:

• Total 10 years of experience in SAP HANA, SAP BW, SAP BI, SAP DS and SLT with a breakdown of
• 10 Years in SAP - SAP ABAP, SAP BW from 3.5 to 7.4 and BW on HANA.
• Close to 4 years in SAP HANA, BW- IP.
• 3 years in SAP BI and Data Services.
• Worked in 3 SAP BW/ BI Full Life cycle implementations and 2 SAP HANA implementations.
• Functional areas of expertise in SD- SCM, PP, FI, CRM, SRM, IP.
• Highly proficient experience in SAP Business Intelligence, HANA, BODS and Business Objects, this includes good exposure to Implementation, Development and Support.
• Strong knowledge on SAP BI Modeling, Extraction and reporting which includes BEx suite and BO Reporting Tools.
• Expert in building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Strong work experience on integrating HANA Enterprise, SAP BW on HANA and BOBI tools.
• Proficient in loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console.
• Expertise in BW- IP- design and development of real time cubes, aggregation levels, filters, planning functions, planning sequences, input ready queries and variables.
• Expertise with Hana SQL Scripts, fox scripts, and abap exits to support IP planning applications, and design the in- memory hana planning models, and very strong understanding of ABAP planning applications kit.
• Excellent knowledge in gathering business requirements, analyzing the business process, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Go-live and Post-go-live support.
• Leading offshore HANA team at client location which is responsible for providing HANA Solutions globally.
• Have experience in preparing project related documents like Detailed Design, High Level Design, Business Requirement Specification and Test Cases Document.
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, DSO, Info Package, Data Source, Info Objects, Transformations (dealing with routines) and Process Chains.
• Work experience on SAP BO Web Intelligence, Analysis Office and Crystal reports and using both HAN Enterprise and BW as source system.
• Expert in SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA - This includes the configuration in SLT, administration and trouble shooting.
• Well versed with SQL Script, ABAP, JavaScript, PL/SQL, SQL.

TECHNICAL SKILLS:

ERP Packages: Net Weaver 7.x, Net Weaver 2004s, SAP R/3 - 4.7 / 4.6C.

Data Warehouse/ Design tools: SAP BI 7.x and SAP BW 3.x, HANA Enterprise, BW on HANA

Reporting Tools: BEx Explorer, Business Objects 4.x/ XI 3.1, WAD, Design Studio 1.2/1.6

Functional Modules: SD, PP, QM, MM, FI, SRM, CRM

Languages: ABAP/4, SQL, JAVA, Jscript

Database: Oracle 9i, 10 g, SQL Server 2008, HANA

PROFESSIONAL EXPERIENCE:

Confidential - Montvale, NJ/ Los Angeles, CA

SAP BW- HANA Architect

Responsibilities:

• Performed End -to-End data modeling and data provisioning tasks for HANA projects.
• Architected and implemented roadmap and strategy for the self-service BI model for BOBJ across enterprise.
• Collaborating with cross functional teams to define and convert business requirements, processes and designs into robust and scalable BI Solutions and Developed technical architectures, patterns and guidelines within the BI 4.1 and BW on HANA, and Enterprise HANA- Mixed modeling Scenarios.
• Involved in designing and implementing BW/BO security for all reporting users.
• Configured and setup the real time data Replication in SLT for SAP and Non-Sap data real time into Hana. Data replication enhancements created for custom fields when required (during replication).
• Developed Data Provisioning processes to load data through SLT and SAP Data Services.
• Developed HANA Attribute View, Analytic View, Calculation View, and Analytic Privileges to present financial data.
• Designed and developed calculation views using graphic interface, calculation engine, and SQL scripts.
• Developed SQL script to transform and harmonize data from SAP ECC, Hadoop, and MySQL DB to calculate the KPIs.
• Involved in suggesting BW-HANA Blend scenario solutions for specific requirements where high volume of detailed data reporting is required in real time.
• Involved in HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
• Designed and implemented end to end integrated planning solution for Confidential advisory business- sales/ engagement planning, profit and loss planning.
• Designed and developed backend/ front end architecture for the sales planning- Actual Cube, Planned cube (real- time), Multi provider, real time dtp to load data from actual to plan cube, input ready plan query, WAD, Analyzer worksheets.
• Designed and developed custom planning functions (SQL Script), developed fox scripts, planning models and utilized PAK/ ABAP- PAK to execute the planning models using in memory HANA.
• Planning automation through process chains and providing end user .
• Designed and developed data models in BW- Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA Error's like data type mismatch, numeric overflow, etc.
• Utilized BO- Data Services data provisioning to extract data from SAP, Non SAP- HANA, SQL server data bases and transformed the co-pa data to be provisioned to the downstream SAP Vendavo pricing system.
• Utilized SQL scripts to transform/cleanse the data, and developed and scheduled BODS jobs using Webservices.
• Developed web intelligence reports & published it using HANA, BW, SQL database (non-SAP) as sources.
• Extensively worked on Business Objects WEBI, Crystal, and Analysis Office reporting on BW, and HANA with different features
• Designed/developed and scheduled Operational and Ad hoc reports Using Crystal and Web intelligence reporting Tools in BI 4.1.
• Involved in defect management during UT, SIT, UAT testing phases.
• Provided to BI 4.1 - BI Business Users, team members and created end-user material and documentation.

Environment: BW 7.3/7.4/ 7.5, HANA SPS 10, SLT 2.0, ODP, BODS 4.2, ECC 6.0, CRM 7.0, BEx, BOBJ 4.1, Design Studio 1.6, Rev Trac

Confidential - Philadelphia, PA/ Midland, MI

SAP BW/BO/ HANA Architect

Responsibilities:

• Gathered and analyzed the requirements to replicate the ECC content in HANA using SLT real time data provisioning.
• Worked with the stake holders and functional team to deliver the technical design and documentation.
• Extensive experience data modeling and developed information views- analytical views, attribute views for the master data, and calculation views using graphical interface and SQL Scripts.
• Developed ad hoc reports using Analysis for office based on HANA information views for the field sellers in the Dow Agro business to view open orders/shipped but not invoiced/ invoiced data for past 3 months, and to show newly created/ changed customers in the past 2 weeks using HANA web based development work bench.
• Migrated data models for sales, deliveries, and cost based COPA applications to BW on HANA optimized content.
• Support the effort of Global Roll out of SAP Implementation for Latin America, Asia Pacific, Europe, and North American Regions.
• Focal point for Dow agro sciences/ Dow Advanced Materials businesses and support the business warehouse implementation, pricing analytics, OTC metrics applications, PP- Repetitive manufacturing and SRM applications.
• Subject areas: OTC- Sales, Deliveries, PP- Capacity planning/ Utilization, Quality maintenance notifications, Production Process Orders, Material resource planning, SRM- E- Procurement, Shopping Cart, Contract Management, and Spend Analysis.
• Worked with the Subject matter experts in gathering reporting requirements from business partners, developed design specifications, Technical Specifications, Mapping Documents, and Unit test script documents.
• Designed and developed a strategic IP integrated planning tool for APO/ SNP to provide ability to the planner to adjust CTM proposals from SNP for Supply inventory planning
• Developed BW architecture for the planning scenario- real time infocube, planning function, input ready plan query, process chains, planning sequence.
• Enhanced Standard logistics extractors using custom enhancements User-Exits/ BADI implementation- and developed custom extractors based on table views and function modules.
• Designed and developed back end architecture and all BW elements to host the data from multiple ERP implementations/ SRM Implementation.
• Designed/ Developed EDW/ LSA layer and extracted- OTC- Sales, Billing, PP- Component/ Material/ Work Center, Material resource planning, SRM- E- Procurement, Shopping Cart, Spend Analysis data to support the aggregated data mart layer for SRM/ OTC reporting.
• Performed unit testing of the OTC/ PP/ SRM reporting functionality, and supported functional/ regression/ and User acceptance testing and resolve the gaps to support the project implementation and meet deadlines.
• Managed project promotion activities- transports, user acceptance testing, initial data loads.
• Design and develop Process chains to load master data, and transactional data and schedule the daily jobs in the production environment.
• Managed the weekly BWA index rebuild activities of cubes supporting various applications.
• Lead the effort in implementing the BW security architecture based on Company code and Value Center authorizations.
• Working with SAP Security team to resolve any security issues raised by the users in accessing custom business content.
• Created user documentation and provided end user in the custom BI applications developed.
• Designed and developed custom queries and applied the security based on the custom restrictions developed using user exits.
• Supported pre-upgrade, system readiness checks and follow up activities of BI 7.01 to BW 7.3 to BW 7.4 upgrade.
• Provided L4 support for the applications to meet SLA’s.
• Designed and developed universes in Information Designer tool from multiple BW, HANA sources.
• Used the standard BICS connection to connect to the BW server to access BW and HANA models.
• Designed and developed OTC metrics dashboards and used live office to feed data into Xcelsius from source WEBI reports.
• Developed crystal reports using crystal reports 2011 to support sales planning based on existing bex queries.
• Published and scheduled the crystal reports to be utilized by the sales planning team, and worked with the users to resolve the authorization issues.
• Designed and developed SRM- Procurement Overview, and Spend Analysis dashboards.
• Designed and developed PP- MRP, Capacity Planning/Utilization/ Production Downtime dashboard.
• Designed and developed Design Studio applications to migrate existing Production Planning- Material Resource planning, Capacity Utilization/ Idle time- WAD applications to Design Studio Applications as a part of BW on HANA upgrade.
• Used Design Studio Script to customize the web applications and published the applications to BI Launchpad.
• Provided end user and documentation and resolved authorization issues.
• Designed and developed corporate score cards for Pricing analytics application using WEBi to track various price points- Gross Sales, Adjusted Gross Sales, COGS, Freight Costs, Freight Revenue, etc., by month, quarter against benchmarks.
• Created universes on HANA views- Hybrid, and analytical and migrated and developed WEBi and Dashboards.

Environment: BI 7.0, BW 7.3, BWA 7.3, HANA 1.0 SPS8, ECC 6.0, R/3, SRM 7.0, Query Designer, BOBJ 4.0, Design Studio 1.6, Crystal Reports 2011, Solution Manager- CHarm.

Confidential - Hanover, NJ

SAP BW Lead Consultant

Responsibilities:

• Worked in the reporting requirements- A/R aging trial balance report, Division Report, Worst Receivables Report, G/L Balances report.
• Developed design specifications, Technical Specifications, Mapping documents, and Unit Test Script documents based on the reporting requirements.
• Worked on BW 7.3 dataflows, developed semantic partitioning objects, migrated data flows using the BW migration tool, and created hybrid providers for real time reporting.
• Custom enhancements of standard content data sources as per the business requirements using user exits.
• Created transformations, DTPs, info packages, and info providers for the master data, and transactional data- data flows.
• Worked in developing custom routines in the BW as per the business requirements.
• Worked in performance tuning methods- Info cube partitioning, datapackage sizing, PSA partitioning.
• Designed, and Created process chains for the Master data and Transactional data data flows.
• Extracted A/R Line items data using 0FI AR 4, and G/L totals data from the leading ledger using 0FI GL 10.
• Created custom reports using BEx Query Designer, Crystal Reports 2011 as per the business requirements.
• Implemented Xcelsius dashboards for Credit Management, Dispute Management, and Cash Management.
• Designed, and developed formatted reports using Crystal Reports for Accounts Receivable, and General Ledger reporting.
• Designed, developed, and optimized Universes using Universe Designer for ad-hoc reporting using Web Intelligence.
• Used the standard BICS connection to connect to the BW server to access BW objects and BEx queries.

Environment: BW 7.3, ECC 6.0, Query Designer, BEx Broadcaster, BOBJ 3.1, Solution Manager- CHarm.

Confidential - San Dimas, CA

SAP BW Technical Consultant

Responsibilities:

• Develop Software Design Specification documents, Technical Specifications, mapping, and Unit test script documents based on the new scope for cash management and garnishment services activities.
• Validated the consistency of data of existing data flows by reconciling the data from the direct access of Virtual Providers to the application data from the source system.
• Developed new data flows using delta enabled generic extraction to address the Cash Management, and Garnishment Services reporting activities. Delta logic is implemented using numeric pointer.
• Created transformations, DTPs, info packages, and info providers for the new data flows.
• Developed process chains and e mail notifications for the process variants to notify the failure and success messages of the process chain runs to the users.
• Enhancement of existing data flows- Garnishment Services, as per the business reporting requirements and remodeling of the existing info providers as per the requirement.
• Managed project promotion activities (Transports) across the N and N+1 landscapes using Rev- Trac.
• Developed Cash Management Forecast, Money Movement- Detailed, Summary level, Aging, Refund, Monthly Billing reports as per the user requirements using BEx Query Designer.
• Developed Crystal Reports based on the BEx queries for end users.

Environment: BI 7.0, R/3, ABAP/4, Query Designer, BEx Broadcaster, Business Objects 3.1, Crystal Reports 11, Rev- Trac.

Confidential . - Boston, MA

SAP BW Lead Consultant

Responsibilities:

• Work involved developing Key performance indicators for the new reporting requirements based on level of analysis, period of analysis, calculation method,, assumptions, and issues that provide measures on the supply chain management for Procurement activities.
• Responsible for the project work plan for the new scope, and worked with cross functional teams for requirement gatherings and documented technical specifications based on the requirement gatherings and the functional specifications.
• Extracted Procurement data using LO cock pit from data sources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 02 ACC, and enhanced the data sources to meet the business requirements.
• Activated available Business Content, Created/modified Info Objects, DSO, Info cubes, Multi Provider, Info sources, Info packages, DTPs, Transformations.
• Configured the jobs for delta collection and Delta Extraction in ECC and created Info packages for Init & Daily Delta Loads for both Master & Transaction Data for the extraction of data into BW and validated the data, and Created Process chains to automate the load schedule.
• Developed custom purchase order reports such as: PO- Delivery Variance report, Purchase Order Overview report, PO- Goods Receipt variance report.
• Used jump queries (RRI), filters, Conditions, Variables, Restricted Key figures, Calculated Key Figures, Exceptions, and Currency Conversions for the development of the custom queries in BEx Query designer.
• Published the reports as per the business needs in workbooks using BEx Analyzer, views in SAP Net Weaver Portal 7.0 using BEx Broadcaster, and used Web Application Designer to create web templates.
• Handled exceptions through SAP Mail, batch printing and alert monitor.

Environment: BI 7.0, ECC 6.0, Net Weaver 7.0, BEx Analyzer, Query Designer, BEx Broadcaster, WAD

Confidential

Responsibilities:

• Worked through all the phases of the project from Project Preparation, business blue print, Realization, gap analysis, Go-Live, Post Live Production support, and developed User documentations using SAP recommended practices.
• Responsible for editing, and updating the project documentation and worked as a team with data architect to develop the high level technical data model and detail level technical data Model using MS VISIO.
• Worked with the cross functional teams in the development of the functional specifications and technical specifications for the Finance module and documented them as per the needs.
• Worked extensively in developing and modeling Financial accounting line items, and Profit Center Accounting extraction- 0FI AP 4, 0FI AR 4, 0FI GL 4.
• Worked in developing, modeling and implementing HR payroll, posting documents info providers.
• Worked extensively in developing, modeling, and customizing the Financial & HR data providers, Financial & HR Info cubes, DSOs, and multi providers according to business needs in SAP BI.
• Sourced data from different sources including ECC using both standard business content and generic extraction & extracted data from legacy systems using DB Connect.
• Worked in designing and developing EDW Layer and worked with the data architect to optimize the DB size of EDW Layer for better performance of the system considering the granularity of data, reporting requirements, total DB size, load frequency, historical background etc., and was a part of the team to design the table partitions, semantic partitions, and archiving the historical data that is not needed for the reporting requirements.
• Designed and Developed Process Chains to automate data loading process, and monitored the data loads.
• Created request IDs, collected the BW objects, and transported them to the quality system using transport connections.
• Worked in performance tuning techniques such as creating Aggregates, Indexes, compression, redesigning queries.
• Developed custom financial accounting reports for the end users- such as Potential Late Collections, Potential Late Billings, and Aging Trial Balance Report as per the user requirements using BEx Query Designer, analyzed and published the reports to Net Weaver Portal 7.0 as views.
• Developed custom HR reports for the end users- such as Annual and Quarterly overview of Wage Types, Quarterly posting documents as per the user requirements.
• Used ABAP/4 extensively for custom developments/ enhancements, transformation of data, and for editing user exits.

Environment: BI 7.0, ECC 6.0, Net Weaver 7.0, BEx Analyzer, Query Designer, BEx Broadcaster, WAD

Confidential, - Los Angeles, CA

Responsibilities:

• Designed, developed and documented the Entity Relationship Model (ERM), Process Flow & Data Flow Diagrams (DFD), Multi Dimensional Model (MDM), Star Schema models.
• Worked extensively in Data Modeling, designed and created Info Objects, Info Cubes, DSOs, Multi Providers, Info Sources, Info sets, and worked in extraction of data from different Source systems.
• Used ABAP/4 to develop custom enhancements, editing functional modules, and developing start routines, end routines, conversion routines for data transformation.
• Developed the data flows and DSO architecture for SD- Deliveries-12, and Shipping- 08.
• Improved the load performance using aggregates, partitions, number range buffering, data selection, and data compression.
• Developed reports for SAP SD and MM such as outbound and inbound delivery monitoring reports, and Effective Tax Rate Reports.
• Installed the standard business content for the CRM Service Orders and developed reports as per the business requirements.
• Generated reports on Info Cubes, Info Sets, ODS and Multi Provider using BEx query Designer.
• Application of OLAP Processor core functionalities, slice and dice, drill up- drilldown, special aggregation, sorting, aggregation for analyzing and reporting the data.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as Views.
• Designing and developing Universes, WEBi, and Dashboard reports.
• Created WEBi, Xcelsius reports and deployed them through Info view with BW universe as source.
• Defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Involved in the migration and deployment of the universes and reports across multiple domains.

Environment: BI 7.0, ECC 6.0, ABAP/4, BEx Analyzer, BEx Query designer, WAD, WEBI, XCelsius (XIR 3.1)

Confidential - Rochester, NY

Responsibilities:

• Performed migration of BW objects from SAP BW3.5 to SAP BI7.0.
• Worked in the Design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Performed migration of R/3 data sources.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow.
• Implemented Start and End routines within Transformations.
• Enhanced Info cube with remodeling concept to make changes, without having to reload data.
• Generated Queries using new BEx Query Designer, designed new applications using new Templates in BEx WAD, created work books using the new BEx Analyzer, and used BEx Information Broadcasting to distribute the information to the end users and business users.

Environment: R/3 4.7, BW 3.5, BI 7.0, Net Weaver 7.0, Net Weaver 2004, WAD, BEx Analyzer

Confidential - San Antonio, TX

Responsibilities:

• Worked in the production support team to handle problem records, change requests and service calls
• This involved RCA of issue, restoring failed delta loads, handling change requests for any modification in existing functionality, handling service calls for issues encountered in production system for reports, loads
• Resolved issue related to process chains, data loads, Admin workbench, number range problems, info-provider related problems etc
• As per client’s quality standards Documentation is done e.g. creation of functional specifications, Technical Specifications etc, and Scheduled daily/weekly/monthly data loads.
• Followed Client’s Change Management Process for moving any production change
• Monitoring of data loads and analyzing the reasons for frequent failures of info packages.
• Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.

Environment: SAP R/3 4.7, BW 3.5

Confidential - San Antonio, TX

Responsibilities:

• Worked in full life cycle implementation, using SDLC methodology and provided Post Go-live support.
• Participated in Requirement Gathering from users & conducted sessions for project preparation.
• Reviewed reporting functional specifications and developed technical specification for extraction, modeling and reporting.
• Designed of entire dataflow for conceptualization of solution.
• Extracted the IM data using LO cockpit extraction from the data sources 2LIS 03 BF (Material Movements), 2LIS 03 BX (Stock Initialization), and 2LIS 03 UM (Revaluations) and developed generic data extractors for extraction of R/3 data using Functional Modules.
• Extracted the data using extractor 2LIS 12 VCSCL (Schedule Line Delivery), 2LIS 11 VDHDR (Sales Order Header Data), 2LIS 11 VAITM (Sales order Item Data) to data targets.
• Set up extraction using LO (LBWE) Execution Cockpit & V-3 updates.
• Have worked with business content extractors, and enhancement of extract Structures EXIT SAPLRSAP 001 and EXIT SAPLRSAP 002 and added new fields.
• Worked on installation of standard business content for SD, and SCM, activating the data sources, modified transfer structures, and update rules.
• Extensively used BEx Query Designer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
• Worked on data loads and fixing the loading issues after the enhancements made and worked with production load issues (time stamp, invalid char, short dump, delta error requests).

Environment: SAP R/3 4.7, BW 3.5, Net Weaver 2004, BEx Query Designer, BEx Analyzer

Confidential

Responsibilities:

• Created report lists for the gross sales, credit returns, gross weight for the customer for the current year and comparing the same with that of the previous year for the same period. The data is selected from KNVV, BKPF, BSEG and MARA.
• Created commission report for the sales department sorted by sales representative based on VBAK, VBAP, KONV, and MARA tables
• Created an Interactive Report for displaying vendor information. Based on the selection made the corresponding Vendor Bank Details are listed such that the line selected in the basic list was visible along with the secondary list
• Designed and coded a BDC program for Sales Orders that updated records in the sales order screen or will create New sales orders depending on the source data file from external systems using VA01 and VA02 transactions.
• Created reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data was extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables.

Environment: SAP R/3 4.7, ABAP/4, BW 3.5, BEx Query Designer, BEx Analyzer