SUMMARY:

• Senior Consultant with over 20 years of overall IT experience, 10 + years in SAP BW, SAP BusinessObjects BI tools 7 years,4+ years of SAP HANA and 1+ year of SAP S/4HANA (1511,1610)
• Deep knowledge of SAP BW on HANA and BusinessObjects Architecture with the ability to design develop and implement Data Warehouse and Business Analytics solutions to support complex business requirements.
• Thorough understanding of the BusinessObjects Integration with SAP BW, SAP HANA, SAP S/4HANA ABAP CDS Views.
• Hands on experience working with SAP BusinessObjects BI tools and BI platform 4.x, WEBI, IDT, Analysis for office, Lumira, SAP Fiori.
• Hands on experience implementing SAP HANA Native Information Models, S/4HANA and HANA database architecture
• Hands on experience designing CDS Views using ABAP Scripting Editor used by S/4HANA Analytics & BOBJ BI tools
• Hands on experience designing Backend Data models in Embedded BW, ODP used by S/4 Analytics & BOBJ BI tools
• Hands on experience writing SQL, SQL Script for SAP HANA.
• Hands on experience working with SAP HANA XS (classic) and XSA (advanced).
• Hands on experience developing SAP HANA XS/XSA APIs(XSJS), OData, CDS views, extensive knowledge of the embedded http server configuration and server side java scripting methods.
• Hands on experience developing all SAP HANA information models (Attribute, Analytic, Calculation Views, Tables (Row & Column), Packages, Schemas, Stored Procedures, Views, Analytical Privileges etc. Involved in 5 SAP HANA native deployments
• Hands on experience, upgrade and migration to BW on HANA DB, involved in 3 lifecycles BW on HANA migrations projects
• Hands on experience working with SAP BW extractors, ADSOs, Composite Providers, HANA Views, Open ODS.
• Hands on experience with SAP BW modelling with respect to SAP HANA using composite providers, Advance DSOs, ODP, LSA ++ and using BW objects exposed as HANA views
• Involved in SAP NW BPC project in 2011 while working for SAP America. good understanding of SAP BPC integration with SAP NW BW for extracting data into SAP BPC and deep understanding of the SAP BPC concept and process.
• Proven ability to work with complex technical and logical concepts and able to adapt quickly
• Experience in handling global teams whether it be on - site or off-shore
• Experience implementing Project Implementation Methodologies, such as ASAP, Solution  Manager and the use of Best Practices
• Rich experience resolving project issues & sign-offs that involve end-user, project business & development teams and Best Practices scenarios
• Excellent requirement gathering skills and ability to work with business process and SME teams.
• Excellent client-facing skills and a strong team player with leadership qualities
• Strong analytical, problem solving and quantitative skills as well as excellent trouble-shooting skills.
• Heavy hands on work experience in the SAP HANA, thorough understanding of the HANA concept and its role in delivering solutions to business and in the SAP landscape.
• Expert in HANA modeling using the HANA Studio and HANA web IDE to create information models, Attribute, Analytical and Calculated Views, stored procedures, XSJS, ODATA CDS views.
• Hands on experience designing CDS Views using ABAP perspective in HANA studio and in the backend system (SAP S/4HANA) to create basic interface, composite and/or consumer views for Analytic Solutions.
• experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, Analytical Privileges
• experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - SAP BODS, SLT
• Experience in HANA XSJS APIs and HANA SQL scripting
• Experience in SAP HANA architecture, optimization techniques, delivery units (transports), CTS+, Hana Native transport, Hana security, SQL Scripting and administration.
• Team Player, excellent communication and interpersonal skills
• Self-driven, proven ability to work independently and strong Analytical skills
• Experience in providing advanced technology advisory services.
• Understanding of market and technology trends.
• Expert in creating schema, packages, tables, views, attribute, analytical & calculation views, analytical privileges, joins in SAP HANA
• Extensive knowledge and hands on using SAP Hana data provisioning tools:(SAP BO Data Services, SAP LT Replication Server (SLT), Hana Smart Data Access (SDA), Hana Smart Data Integration (SDI)
• Expert in backend configuration: BW 7.x & 3.x Data Sources, Transformations & Transfer and Update Rules, DTPs, InfoCubes, MultiProviders, DSOs, Real Time Cubes, InfoSources, Process Chains, generic DataSources and 7.x & 3.x ETL Design
• Expert in SAP BusinessObjects Web Intelligence on the BI 4.x platform including Information Design Tool (IDT) as well as the Universe Design Tool (UDT)
• Expert in development, Training super users/SMEs in the features and workings SAP BI tools such as IDT, UDT, Webi, Analysis for office/OLAP, Lumira.
• Hands on Experience with SQL Queries for RDBMS
• Hands on Experience in ABAP programming skills for Transformations and User Exits
• Hands on Experience in LSA++ methodology for BW on HANA architectural solutions
• Extensive knowledge of SAP ECC data dictionary and common SAP tables
• Hands on Experience working in various SAP ECC process areas including exposure to developing business intelligence solutions for FICO, MM, PP, SD, COPA etc.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

SAP HANA/BW/BI lead developer

• Worked with the Infosys SME and client SME business process teams and other IT teams to implement SAP HANA based procurement and Analytics solutions using SAP HANA DB as the backend and SAP HANA XS Application as the API layer.
• Worked on S/4HANA migration projects, finance & logistics,

Confidential, Burlington, Vermont.

Lead SAP HANA/BW/BI Architect/developer

• Worked hand in hand with business process teams and other IT teams to implement SAP BW on HANA, HANA sidecar, based BI and Analytics solutions using SAP ECC 6.0 as the backend ERP system.
• Worked closely with senior BI director to set overall enterprise BI strategy, Analyzing business goals, rules, and processes across various information systems tools and technologies.
• Develop functional and technical specifications from business requirements for the development of SAP BW objects such as extractors, infoobjects, infosources, infocubes, transformations, process chains etc.
• Recommended and implemented upgrade and migration solutions for SAP BW 7.3 to 7.4 on HANA, SAP BODS from 4.1 to 4.2 and SAP BO-BI from 4.0 to 4.1, SAP HANA SPS 9, SAP SLT SAP and HANA Live for operational analytics .
• Heavy hands on experience in the SAP BW on HANA pre and post migration activities using DMO tools
• Developed solutions using SAP BW/HANA/BO-BI, utilized standard content, enhanced existing standard objects, and created custom objects using the SAP BW toolset
• Developed SAP HANA Information models to deliver COPA solutions, FI AR&AP & MM - Purchasing solutions.
• Implemented SAP HANA Live to deliver multiple SAP LoB solutions to enable real time analytics.
• Architected solutions from a technical standpoint to make sure that we build the right reporting solutions for business needs
• Enforce and ensure reporting SLA's are being met on a consistent basis
• Review development objects in SAP BW / BO / HANA/HANA Live standards.
• Support integration between SAP Business Objects, HANA sidecar and SAP BW on HANA
• Develop and maintain documents detailing requirements, design, implementation, and maintenance of our information systems tools and technology
• Perform production support activities, including managing changes within the production environment, problem resolution, reporting modifications, and performance tuning

Confidential

Senior Consultant - Business Analytics

• Experience with HANA modeling using the HANA Studio to create Attribute, Analytical and Calculated Views
• Experience in Data Provisioning in HANA
• Experience with SQL Queries for RDBMS
• Proficient in ABAP programming skills for Transformations and User Exits
• Proficient with SAP BusinessObjects Data Services ETL tools
• Proficient with Crystal Reports and Xcelsius
• Experienced in LSA++ methodology for BW on HANA architectural solutions
• Excellent on SAP BW on HANA pre and post migration optimization activities
• Good knowledge on LSA++ modeling for BW on HANA
• In depth knowledge on SAP HANA Cloud Strategy Roadmap, HEC, Hybrid Solutions.
• Hands on experience working with SAP HANA on premise/on cloud solution using SAP HANA HCI.and SuccessFactors BizX suite
• Hands on experience using SAP HANA studio and SP HANA web IDE to design information models
• Hands on experience creating schema, packages, tables,views,attribute,analytical & calculative views, analytical privileges, joins in SAP HANA

Confidential

SAP BW/BI Consultant

• Created the technical specification documents from the functional specification documents.
• Worked extensively with the customer SME and SAP PM functional consultant to get a good understanding of the LAM process.
• Actively involved in all the back and front end development work for the LAM project, utilizing SAP BW/BI tools and SAP EP tools, significant amount of custom objects developed, ABAP routines for enhancing transformation and loading and variable formulas in the BEx.
• Developed BEx Queries/Web Templates/Roles for detailed Reporting.
• Created custom tables/views, enhanced transaction data extractors using SAP user exit RSAP001.
• Created Restricted (RKF) and Calculated Key Figures (CKF), Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Created query views/roles/ and the integration of BW BEx query views to the SAP Enterprise portal development environment for reporting solution.

Confidential

SAP HANA/BW/BI Consultant

• Actively involved in all the frontend development work for the PTP project, utilizing SAP BW BI tools and also in some backend work, some ABAP routines for enhancing transformation and loading and variable formulas in the BEx. Involved in the ASAP project methodology process.
• Actively involved in all the frontend development work for the PTP project, utilizing SAP BW BI tools and also involved in some backend work, ABAP routines for enhancing transformation and loading and variable formulas in the BEx Query Designer.
• Developed BEx Queries for detailed Reporting using replacement path variables.
• Created customer exit variable EXIT SAPLRRS0 001 in the Reports.
• Created Restricted (RKF) and Calculated Key Figures (CKF), Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Assisted with the integration and creation of SAP BW 7.3 and SAP BI 4.0 reporting solution environment, this includes but not limited to using IDT, OLAP connections, Web Intelligence, BI Launch pad to develop and troubleshoot issues.
• Involved in the SAP BW on HANA pre and post migration activities using DMO tools, development and configuration of SAP HANA Optimized infoproviders and migration of the SAP BW on HANA environment, developing data objects for SAP HANA native
• Actively Involved in the development of the hybrid SAP BW/HANA environment for SAP HANA enterprise and SAP BW on HANA

Confidential

SAP BW/BusinessObjects Consultant

• My role was to Review of customers BI Strategy, troubleshoot BI performances issues and make recommendations, best practices approach.
• Assisted customer in troubleshooting performance issues in the BW and BI 4 environments.
• Created solutions to optimize the performance of the BW InfoProviders and also optimize the BusinessObjects WEBI queries.

Confidential, Toledo, OH.

SAP BW/BusinessObjects Developer

• Scope of Work (Detail of duties and tasks) and environment (Reporting & Analytics) SAP NW BW 7.0 BEx, SAP BusinessObjects XI 3.1, SAP BusinessObjects Integration Kit 3.1, Infoview and WEBI 3.1
• Responsible for interacting with Business users for gathering reporting requirements and preparing technical specifications for several reports in, FI- AP,AR, COPA,INV,CCA.
• Worked with BEx Query Designer and OLAP Universe Designer, to create WEBI reports.
• Generated Xcelsius dashboards out of SAP BW data where the data is in the form of BEx Queries.
• Created OLAP Universes on BEx Queries and using them in Query As A Web Service (QAAWS) for data loading into Xcelsius.
• Worked with Query Designer to create various query elements such as Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables.
• Create and design documents (technical and functional) for BEx Queries, Universe, Webi & Xcelcius reports.
• Build and design BEx Queries, Universe, Webi & Xcelcius reports from technical designs.
• Responsible for Designing and building Universes over existing SAP BW systems.
• Created Documents for all design build activities.
• Conducts Testing - Unit, and participates in Functional, Integration, User Acceptance)
• Designing reporting templates with BEx Analyzer and Web Analyzer; Using key figures, features, hierarchies, variables, properties, exceptions. and conditions in the query definition; Integrating SAP BusinessObjects with SAP BW datasources
• Responsible for Universe Design with SAP BW Data Sources and BEX Queries
• Responsible for Creating WEBI query and documents
• Worked with power users to adapt WEBI features and functionalities to the over all global user community.

Environment: SAP NW 2004s, SAP EP. 6.0, SAP BusinessObjects 3.1, HP QC 10,

Confidential, Santa Clara, California

SAP BI Trainer

• I worked for AGU (Applied Global University) the internal training division responsible for learning and development for Applied Materials Inc employees globally. I worked as an instructor responsible for conducting SAP BI Intermediate and Advance training for users. This training is focused on the front-end tools for SAP BI (SAP BEx and SAP Portal
• The SAP BI Advanced class was for power users and SAP BI Intermediate class was for others.
• The training Classes conducted was focused on the following course objectives:
• Describe BI concepts and reporting tools.
• Understand the Data Flow concepts within BI
• Access the BI Portal and run reports using BEx Web Analyzer and BEx Analyzer using all functionality in these components
• Use the Query Designer to create Queries and Reports
• Configure and Implement the use of Characteristic Properties, Variables, and Hierarchies
• Configure and Implement the use of Key Figure Properties, Restricted Key Figures, Calculated Key Figures
• Understand the functionality of the Cell Editor and Exception Aggregation
• Configure the functionality of BI Exceptions and Conditions
• Configure and Implement the use of Documentation in a BI report
• Create the Report to Report Interface component of BI
• Understand the BEx Analyzer Workbook
• Configure the Functionality the BEx Analyzer Workbook

Environment: SAP NW 2004s, SAP EP. 6.0

Confidential, North Carolina, USA.

Senior SAP BW/BI Developer

• Infocubes: Customer 0SD C01, Delivery 0SD C02, Sales overview 0SD C03, Delivery Service 0SD C04, Quotations and orders 0SD C05,Custom Cubes, FI-AR Accounts Receivable, FI-AR Line Items, FI-AP Accounts Payable, FI-AP line items and Summary values,0FIGL VC1 (general ledger: financial statements),0FI GL 1 general ledger: transaction figures,0FI GL 2 transaction figures - cost of sales.
• ODS: 0FIGL O10: general ledger: transaction figures.
• Datasources:2LIS 11 VAITM,2LIS 11VAHDR,2LIS 11 V ITM,2LIS 12 VCITM,2LIS 12 VCHDR,2LIS 13 VDITM,2LIS 13 VDHDR
• Extractions: Extracted Logistics data from SD using both LIS and LO Cockpit. Extracted data for financial analysis.
• Customizations: Created InfoObjects and datasources to enable data extraction from legacy systems, modified sap BC to conform to the business requirement.
• Modeling: Created InfoCubes, InfoSources, DataSources and InfoObjects, Update, Transfer and Transformation rules to enable Data Loading (initial / Delta Up-load), Scheduling and Monitoring.
• Reporting (BEx):Worked Extensively in BEx Analyzer (Query Designer) in building Queries, saving it in Workbooks (Excel workbookCreated Standard/ Custom queries using Bex Query Designer and WAD, created Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• BO Client Tools-WEBI, DESKI, OLAP Universe, Infoview, universe designer, CMC.
• Web Reporting: Developed web reports using web items also designed graphs.
• Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization and also improved data load and query performance by doing InfoCube compression, aggregates.
• SAP BW Security: Developed and maintained authorization objects.
• Created and maintained security for all SAP BW authorizations, profiles and roles.
• Collaborated with other team members as necessary to translate business requirements into BW Security roles.

Environment: SAP Netweaver 2004 & 2004s, BOE XI 2, SAP ECC 6.0, AIX, DB2, MS SQL, ORACLE