SUMMARY

• Senior HANA/BI/BOBJ Consultant with 8 years of experience in SAP with expertise in BI/BW, HANA, Business Objects.
• 15 years of rich experience in developing and delivering IT solutions in multitudes of platforms ranging from SAP, Open Systems to Mainframes.
• Rich technical experience as result of working in wide range of developmental requirements originating from broad varieties of business needs.
• Received accolades from clients in Four SAP implementation projects in great work ethic, strong technical expertise and in being an extraordinary team player.
• SAP Supply Chain Architecture, development, implementation, enhancements & rollouts.
• Extensively worked on SAP HANA Modeler (HANA Design Studio): Designing and developing the end - to-end HANA solutions comprising development of Calculation Views, SQL Stored Procedures, Analytical and Attribute Views, using various CE Functions.
• Experience in Data-Provisioning techniques using SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Experience in SAP BW which includes Data-Modeling (Star-Schema), Data Extraction, Data Loading (Full / Delta Up-Load), including Business Explorer Query Analytics and Reporting Design, and importing SAP BW Models in SAP HANA
• Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality. Automated data loadings using process chains and other tools like Auto-Sys.
• Extensively worked on SAP R/3 LO-Cockpit CO-PA, Generic Extraction and different modules like SD, MM and FI.
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.
• Strong techno-functional experience in Implementation, Upgrade and Support in SAP BW and SAP HANA.
• Proficient in translating reporting key requirements as well as design and build the necessary data modeling, BW structures and reports, workbooks using Excel/macros.
• Good track record with proven success in conducting CRPs, requirement gathering, design, project build, configuration, setup, system test and implementation, user support and training.
• Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
• Exceptional Technical, Communication, Interpersonal and Client Interfacing Skills.
• Exemplary analytical, self-learning abilities and able to prioritize and complete multiple tasks.

TECHNICAL SKILLS

ERP: SAP R/3 version 4.7, ECC 6.0

Data Warehouse: HANA 2.3, SAP BW 7.5, BOBJ, CMC

Reporting Tools: SAP BEx Analyser, BEx Browser, Crystal Reports, Cognos Impromptu

Databases: Oracle 9i, SQL server 2000/2005, MS Access

Database related products: Platinum, QMF and SPUFI

GUI Tools: Developer 2000, Visual Basic 8.0, Visual Source Safe, TOAD

Languages: C, SQL, PL/SQL, COBOL, JCL

Scripting Languages: VB Script, HTML

Operating Systems: Windows 95/98/2000/XP, Windows NT, UNIX, IBM OS/390

EDI Specific: Gentran Integration Suite

PROFESSIONAL EXPERIENCE

Confidential

Senior HANA Modeling Consultant - E2E

Responsibilities:

• Business Requirements and refinements, approval process.
• Integrating Solution design, Design Review Board approval process.
• Native HANA Development.
• Agile/Sprint based solution delivery.
• Validate Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data.
• Calculations views of type graphical and SQL are developed according to the requirements, which used projections, joins, aggregations, unions and ranks.
• Written multiple Stored Procedures and Table Functions to feed MDM data to IBP system, error-handling techniques were performed during the load.
• Carried out raw data validation, unit and integration testing of BW and HANA models, worked alongside business users helping them with UAT.
• Working with business to identify opportunities in enriching the business process, procedure, new features & enhancements.
• Working with multiple teams to enhance Supply Chain data extractions for Analytics.
• Rollouts to multiple regions including NA, EMEA, APAC, & LATAM.

Confidential

Senior HANA Modeling Consultant - BDV

Responsibilities:

• Acted as a Technical Liaison contact between business team, functional team and BW technical development team.
• Translated functional requirements in to technical specifications identifying the source-systems, technical tables, fields, extractors, and the logic required.
• Built BW data models to extract data into ADSO layer and make it available for HANA.
• Designed and developed HANA models to bring in the data from 5 BW systems into HANA.
• Worked with MDM team to harmonize the master data in HANA per business requirements.
• Designed and Developed HANA solutions involving the following to incorporate the business logic as much as possible within HANA to prepare KPIs and business-measures
• ADSO objects from BW
• Native HANA tables
• HANA SQL stored procedures
• Calculation Views
• Star Views
• Functions
• Built complex calculations, unit of measure conversions, currency conversions and formula derivations in above HANA models.
• Built complex SQL stored procedures taking in the data from HANA tables, Calculation Views and process the business logic inside SQL and store the results in HANA tables for further consumption of Calculation Views for reporting.
• Go-live and hyper care support.
• Developed Microsoft Analysis reports using above views to present business data per statutory and other government agencies requirements.
• Developed BOBJ webi reports using above HANA views.
• Datasets worked with:
• Inventory Movements
• Inventory Balances
• Sales Invoices
• Hyperion GL Balances
• Unit of Measure harmonization
• Company Master Data harmonization
• Vendor Master Data harmonization
• Material Master Data Harmonization
• Material Plant Harmonization
• MRP Valuation Area Harmonization
• Purchase Document Type
• Billing Document Type
• Other business entities like Market, Segment, Brand master data harmonization
• Complex Manufacturing Standard Cost harmonization
• Performed peer review of HANA models, BW development, and coding.
• Coordinate with the test team to prepare test scripts, validate them, and provide necessary inputs for successful execution of testing through various phases of project.

Environment: SAP BW 7.5 SP3, HANA 2.3, BOAO

Confidential

SAP BW/HANA Sr Consultant

Responsibilities:

• Implementing a full life cycle Analytics solution, which includes Requirements gathering, Development, and Testing, Reporting, Go-live and Post Go-live support.
• Designed and implemented SAP HANA 1.0 SP9 data modeling using Attribute view for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Expertise in migrating standard Infocubes, standard DSO’s to HANA optimized Infocubes, DSO’s and importing BW Models into HANA using HANA Studio.
• Monitoring and troubleshooting data loads.
• Worked on Business Content SD and MM Extractors and enhanced datasources for 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL AND 2LIS 03 BF.
• Created SD reports for Backorders, On-time deliveries, Daily Sales, Sales Growth, Sales monthly Trend.
• Worked on Purchasing datasource - 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL.
• Implemented end to end Purchasing dataflow using HANA optimized infoproviders (ADSO O PUR11, ADSO D PUR11).
• Developed trended versions of Revenue reports by Region, Product and Service.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business 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 activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Activation of the Business Content for Plant Maintenance (PM), Purchasing (MM), Quality maintenance(QM), CO-PA and customizing them as per the client requirement.
• Maintained Process Chains to automate and schedule the data loads.
• Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
• Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Loading data into table definitions, suspending data loads, resuming data loads.

Environment: SAP HANA1.0 SPS 09, BW NW 7.5, SAP BO 4.1, SAP ECC 6.0

Confidential

BW/HANA Consultant

Responsibilities:

• Responsible for analyzing the requirements and identifying the gaps.
• Responsible for reviewing Technical Design specifications.
• 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 ETL Based replication to provision the data from ECC to HANA system through BODS.
• Involved in providing solutions to the complex requirements using BW 7.3 Info-providers (Transient Info-provider, Virtual Master Data Info-Objects, Composite Providers, Multi-providers) for HANA Models and resolved HANA Error’s like data type mismatch, numeric overflow, etc.
• Involved in identifying the area to improve the performance by utilization of HANA In-Memory Computing feature, Column Store, Calc Engine features.
• Involved in directing solutions to push the calculations to the HANA DB engine.
• Involved in Optimizing the Design of the data flows in BW, HANA for the requirements.
• Involved in Planning of data load activities, run book preparation.
• Hands on Experience in writing SQL, SQL Script, CE Functions.
• Involved in coordinating with offshore for the daily deliverables throughout the ASAP phases.
• Involved in explaining the end user requirements to the Onshore/Offshore & filling the gaps.
• Meeting SLA for all the developments and continuously tracking for the updates to move the project in a smooth way to the target state.
• Involved in providing the solutions in HANA-BO reporting using Input Parameters, Variables & Hierarchies.
• Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
• Created Process Chains which deletes the PSA Data based on the retention periods.
• Extensively worked with Data Flows.
• Extracted data from MM modules and uploaded the data into the Procurement Cubes.
• Created query Variants, Free Characteristics and exceptions using Query Designer.
• Extensively used Calculated and Restricted Key Figures, Restricted Characteristics, structures, Variables and conditions for the queries.
• Created Info-Packages and scheduling nightly jobs to run using the BW scheduler and handling Process Chains.
• Involved in defect management during SIT, UAT testing phases.
• Involved in Management of Transportation activities across the DEV, QA, PROD Environments.
• Involved in Coordinating with Upstream & Downstream teams for the data load activities.

Environment: HANA 1.0, BW 7.4, BO 4.0, ABAP, SAP BODS 4.0, SAPECC 6.0

Confidential

BW Consultant

Responsibilities:

• Involved in the meetings with BP team to gather requirements for the enhancements.
• Helping the team in understanding the requirements and deploy the requirements within the timelines.
• Defined work packages and technical specifications for design, development and testing.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries using BEX reporting features like variables, exceptions and conditions.
• Perform unit testing and integration testing before moving the objects into quality system for UAT.
• Monitoring Data Loads and Trouble shooting. Worked on the fixes for the frequently occurring issues. Worked on back end development in order to meet the new reporting requirements.
• Worked on continuous improvements such as tuning the performances of the data sources, PSA and Change log cleanup activities.
• In depth knowledge of project management principles and full life cycle development with commitment to high quality work during the different stages of the project (Blueprint, Realization and Test).
• Complete knowledge of BW transports and hands-on diagnosis experience of transport issues/problems.
• Diagnose and recommend query and data loading performance improvements using aggregate and indexes.
• Communicate to SAP via OSS for problem solving and provide production support when necessary.
• Implement and enhance standard BW business content. Design and develop data sources (generic, enhanced and custom) for extracting and staging data from SAP and non-SAP source systems to BW.
• Extensive Knowledge of BW Extractors from SAP R/3 4.6 and SAP ECC 6.0, as well as R/3 object dependencies, underlying tables and processes structures in functional modules. Ability to debug and fix extraction problems in BW.

Environment: SAP BI 7.0, SAP ECC 6.0.

Confidential, New York

BW Consultant

Responsibilities:

• Focused on EDW system based on FI-CA (FS-CD) was developed which serves as reporting platform across the enterprise. BW reports from this solution will replace every other financial report in the organization.
• Responsibilities included identifying the different sources and their integration with BW.
• Developed a BI strategy for the client that involves BW integration with R/3 and developing all technical parts the solution.
• Designed & Developed Info-Cubes, ODS’s, and Multi-Providers.
• Created Technical Specs, Functional Specs for reports, cubes. Worked with offshore teams in helping them build ODS’s, Cubes according to the specs.
• Created process chains, new process types, developed job scheduling plans, involved in coming up with a plan for BW Security strategy.
• Worked very closely with Autosys team to develop autosys jobs for various process chains in the right sequence.
• Created test scripts, managed user testing. Developed the user training documentation and imparted training to super users.
• Data Load Performance: Performed data loads and came up with the most-optimum configuration parameters for the fast loading of data. Worked very closely with Basis team, DBA team in optimizing the Basis, BW and DB parameters for fastest possible Master Data and Transaction Data loads.
• Created Aggregates, Maintained RSRT and other BW configuration settings. This includes in determining to use pre-calculated web templates, or to fill up the cache, tweaking RSRT parameters/multi-cube sequential read-parallel read, reading RSRTRACE results and propose changes accordingly.
• Created reports using CKF, RKF, Conditions, Exceptions, Formulas, Structures, virtual-key figures and all other normal components of Query Designer including Cell Editor.
• Created virtual key figures and developed the related code.
• Created RRIs for queries to jump to another queries and also to jump to R/3 transactions
• Created workbooks and used templates with report specific formatting options.

Environment: SAP ECC 4.6, SAP BW 3.5, DB2.