SUMMARY:

• Eleven years of experience in implementing business applications using SAP HANA, SAP BOBJ, SAP BI/BW, SAP ABAP, and SAP LUMIRA.
• Implemented six full life cycle implementations using ASAP methodology for different modules (FI/CO, SD, MM, PM, SRM, CLM, CRM) in SAP HANA and BW/BI in all phases.
• Partnered with various stakeholders in defining the requirements, evaluating risks and issues.
• Involved in Design and Architecture of Native HANA to meet customer specific model with existing Oracle model.
• Experience in SAP HANA integration with BW 7.4, designing, modeling including migrating standard SAP Models to In - memory optimized models and Performance testing.
• Extensive hands-on Experience and Technical Proficiency in Data Modeling - Info objects, DSO, Info Cube, Multi-Providers, APD’s, Data Loading and Delta Management.
• Proficient in Data Extraction from SAP ECC BW/BI using extraction structures such as LIS, LO Cockpit, FI and Generic Extractors.
• Excellent experience in activating & enhancing the standard Datasources with structural changes & User Exits. Extracted Data from Flat files & DB Connect source systems.
• Expertise in Process Chains and Meta Chains for automating data loads.
• Extensively Worked on Analysis Process Designer’s (APD) and Open Hub service in providing files/reports to end users in extracting data to and from BI in integration with Sales force, BPC.
• Extensive expertise with BEx tools on Queries, Workbooks, Calculated/Restricted Key Figures, Structures, Variables, Exceptions, Conditions and Ad-hoc Queries.
• Extensive experience in designing Webi, Analysis for OLAP, Analysis for MS Office, Crystal reports and Design Studio for global users by analyzing according to their requirements.
• Managed go-live, post go-live support and project closing activities including s.
• Demonstrated ability to develop business solutions that increase efficiency, productivity.
• Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
• Creative, innovative and results driven SAP HANA techno-functional consultant.

TECHNICAL SKILLS:

Tools: /Skills: HANA Studio, SAP BW on HANA SAP BO, WebI, Information Design Tool, Design Studio, Analysis for Office/OLAP, Crystal Reports, MS Access, Visual Composer, SAP Lumira SAP BW/BI, BIA, BEx, ABAP SAP R/3, ECC, SRM, CLM, Ariba, CRM Sales force, Dart, Web focus, Admarc, SAS, C4, Nexus

PROFESSIONAL EXPERIENCE:

Confidential, SSF, CA

SAP HANA/BO/BW Architect

Responsibilities:

• Extensively involved in various Global Implementation projects for Finance/Procurement streams.
• Involved in Design Architecture of HANA for specific customizing Contracts data model from procurement.
• Involved in implementation of certified reports for Finance, Sourcing, Contracts, Purchasing and Invoice-to-Payment.
• Worked closely with Finance and Contracting stakeholders to get requirements.
• Created functional specifications and design documents for the development teams.
• Extensively involved in technical design and development against functional specifications.
• Involved in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Involved in HANA Design studio to create various views in integration with CLM System.
• Lead SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views(both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Creating Schemas, Manage Schema Mapping, Design the Information Models for HANA.
• Designed the new BW based on HANA model to satisfy the old features as well as enhanced features and integrate with front end like CRM planner and Business objects as well as the source systems CRM, ECC, legacy BW and Flat files.
• Lead cut over activities including transports, Logistics, financial and CLM extractions.
• Involved in General Ledger (G/L) and Financial Reconciliation Reporting (FRR) and Audit/Compliance Reports.
• Created ad-hoc master and analytical reports using WebI & Analysis for Office/OLAP.
• Created Integration test scripts and conducted UATs with global Users.
• Lead the full architectural design and Implementation of existing Dashboards to Design Studio.
• Participated in weekly status meetings, documented minutes, tracked and updated action items and assisted the project management in updating the project plan as necessary.
• Designed and built Dashboards in Design Studio based on the KPIs to monitor and track process improvement.
• Developed documents for BO Tools like Webi, Design Studio, Analysis for OLAP/Office AND Crystal Reports.
• Worked extensively on various production support issues and administration of BI back-end operations to ensure data is successfully loaded and available for BO reporting.

Confidential, Hampton, NJ

SAP HANA/BO/BW Architect

Responsibilities:

• Involved in Global Implementation of SRM E-Procurement Operational Data Model, where in we had to develop and deploy Standard/Custom Reports for Purchasing teams and Portal Dash Boards for Executive Analysis, with the objective of Identifying cost savings opportunities and reducing enterprise-wide “Non-Managed” spend amount.
• Involved in Design Architecture of HANA for specific Service Orders data model from CRM and ECC.
• Worked with end users to finalize the requirements for Data model design and architecture to extract data from ECC and SRM for BI reporting and prepared Specs.
• Understood the business challenges and translated them into requirements and developed Analytics and Ad-hoc queries and Reports Cost Center Accounting details, profit review reporting summary, “Open PO’s, Blanket PO’s, Contract Analysis and invoice verification”.
• Involved in BW 7.3 DB migration to SAP BW 7.4 with HANA DB activities also.
• Involved in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Involved in security and technical upgrade to BI 7.3 during the implementation of BO 4.0 in Co - ordination with Basis team.
• Enhanced SD, Purchasing, Inventory extractors, CRM extractors by developing complex ABAP enhancements in ECC generic and standard extractions by implementing BADI‘s.
• Involved in cut over activities including transports (Dev, QA, Prod), Logistics extractions, SRM extractions, working with MDM team to replicate vendor and commodity hierarchies.
• Extensively involved in identifying the required data elements for the KPIs and metrics.
• Involved in Finance and Controlling (FICO), Sales and Distribution (SD), Inventory (MM), Purchasing (MM), Supplier Relationship Management (SRM), Accounts payable (AP), Accounts Receivable (AR) customizing reports as per the user’s requirements.
• Prepared Test cases for Unit, Integration and User Acceptance Testing by using quality tools.
• Co-ordinate with Development, Basis, Portal and Security teams to implement OSS Notes.
• Provided User on Strategic and Operational BI reporting.
• Lead the full architectural design and Implementation of enhancing the existing and new reports using BO WebI & Analysis for Office/OLAP.
• Extensively involved in production support BI back-end operations to ensure data is successfully extracted from source systems.

Confidential, New York, NY

SAP BW/BI/BO Lead

Responsibilities:

• Involved in Global BI Implementation project in for Media and Finance.
• Worked in requirements gathering for BI reporting and prepared User Requirement Specs.
• Implemented end-to-end integration with non-SAP legacy systems for reporting needs.
• Extensively involved in integrating BI with Sales Force to provide daily data/reports to sales teams.
• Involved in performing Inventory data refresh, i.e. Setup the initial stock balances, loads to ZCCINVTY Cube with 2LIS 03 BX Data source. Loading the historical movements.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and monitored data loads with full update and Delta mechanisms.
• Heavily used APD’s in generating files and reports for project Sustainability.
• Prepared several test cases, Data Confidential testing, unit testing and integration testing.
• Lead full implementation of Designing Media reports using Webi, Crystal reports on BW.
• Created queries for various dashboards and also assisted the technical team with Xcelsius.
• Developed BSTP dashboards using Visual Composer to create according to user’s requirements.

Confidential, Charlotte, NC

SAP BW/BI/BO Consultant

Responsibilities:

• Involved in full life cycle implementation which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Go-live and Post Go-live support.
• Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Initialized and Extracted deltas from the data sources 0FI AR 4, 0FI AR 6 and 0FI AR 10 and loading Finance line items and payment history details to 0FIAR O03, 0FIAR O06, 0FIAR O10.
• Developed workbooks, info set Queries, structures and used RRI jump queries to drill down from Summary to detail queries.
• Managed a team of developers for implementing BO integration with BW.

Confidential, Jefferson, MO

SAP BW/BI/BO Consultant

Responsibilities:

• Involved in analyzing and designing the data flow from ECC to BI and responsible for deployment.
• Responsible for design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO cockpit extraction methods.
• Created reports like confirmed quantity, item purchase orders as requested, complete purchase order quantities delivered and purchase order values.
• Worked with Security team to Test and Document the access of different Roles (Power user and End user) with Queries and Workbooks on the new Security Authorization in BI.
• Worked closely with power users on proof of concept using Xcelcius and Web-I for Sales Reports.

Confidential, East Hartford, CT

SAP BW/ABAP Consultant

Responsibilities:

• Actively involved in requirement gathering, gap analysis, Design and implementation.
• Installed the Business Content for Plant Maintenance, Customer Service, IS utilities, Accounts Payable, Cost Center Accounting (CO-CCA), and Customized as per Client Requirement.
• Created flat files for Hierarchies and Custom Hierarchies in R/3 and loaded them to BI.
• Extracted Maintenance and Service orders data, Purchasing Requisitions using LO-Cockpit.
• Created Number of Orders Closed, Past Due Rolling 12 - Month reports for Plant Maintenance.
• Created Exception Aggregations, Formula Variables, RKF’s and CKF’s are in the Queries.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom BOBJ reports.
• Identified root causes for production problems and solved these problems through effective program modification.

Confidential, Minneapolis, MN

SAP BW/ABAP Consultant

Responsibilities:

• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
• Designed, developed ETL and extracted BW Data to Non- SAP System using Open Hub service.
• Used the new functionality BEx Information Broadcasting available in SAP Net weaver 2004.
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and MM. Worked on Currency conversion as per user requirements.

Confidential, Atlanta, GA

SAP BW/ABAP Consultant

Responsibilities:

• Actively involved in requirement analysis, data modeling and technical implementation.
• Installed Business Content for Finance and Profit Center Accounting InfoCubes and customized the FI-GL, FI-AR, FI-AP and PCA business content cubes for meeting the business requirements.
• Extensively worked with G/L, AP data sources for extraction and loading of data from FI to BW.
• Responsible for loading Master data and Transaction data from R/3 Data Sources, Non - SAP systems and from Flat Files.
• Improved query and data load performance using aggregates, compression and partitioning
• Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing custom reports.

Confidential

SAP BW/ABAP Consultant

Responsibilities:

• Gathered user requirements and translated them into technical specifications.
• Created interactive reports in SD module extracting information on sales organization levels, delivery and invoice status, shipping details and partner function details.
• Developed reports by plants and shipment.
• Created reports to display the material master sales view and purchase views to cross verify with the legacy data to ensure data consistency.
• Created custom program to load data from excel spreadsheet to custom tables.

Confidential

SAP BW/ABAP Consultant

Responsibilities:

• Designed and Developed custom Info Objects, InfoCubes, ODS objects and Multi Providers.
• Customized user exits on R/3 as well as BW queries.
• Created Scheduling plans for data load to use process chains in order to load Master Data and Transactional Data from R/3 and flat files into BW.
• Extensively used BEx Analyzer to build queries and worksheets.
• Involved in Unit Testing, Data loading, Execute Workbooks, Integration Testing, and User Acceptance Test.