PROFESSIONAL SUMMARY:

• Senior HANA/BI/BOBJ Developer with 7 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 a result of working in a wide range of developmental requirements originating from broad varieties of business needs
• Received accolades from clients in 4 SAP implementation projects in great work ethic, strong technical expertise and in being a extraordinary team player.
• 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 AutoSys.
• 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 detailed 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 .
• 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: 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

EMPLOYMENT HISTORY:

Confidential

SAP HANA Senior Consultant

Activities Performed:

• Acted as a Technical Liaison contact between the business team, functional team and BW technical development team
• Guided SAP BW team in translating functional requirements into technical specifications in identifying the source-systems, technical tables, fields, extractors, and the logic required
• Worked as part of HANA development team 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 HANA solutions to normalize and wrinkle out data issues from various source systems
• 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
• Native HANA tables
• HANA SQL stored procedures
• Calculation Views
• Functions
• Developed Microsoft Analysis reports using the above views to present business data per statutory and other government agencies requirements

Confidential

SAP HANA Senior Consultant

Responsibilities:

• Implementing a full life cycle Analytics solution, which includes Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
• Configured components related to sales orders like sales document types, item categories, schedule line categories etc.
• Worked on Business Content SD and MM Extractors and enhanced data sources 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 info providers (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.
• 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.

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

Confidential

SAP BW HANA/BO Consultant

Responsibilities:

• User Requirement analysis and development for COPA and FIGL reports and created LSA ++ dataflow. 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 a 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 Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) 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, and PROD Environments.
• Involved in Coordinating with Upstream & Downstream teams for the data load activities.

ENVIRONMENT: SAP HANA 1.0, SAP BW 7.4, SAP BO 4.0, SAP ABAP, SAP BODS 4.0, SAP ECC 6.0