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.
• Working knowledge in SLT- both table and application based replication.
• 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

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

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 in corporate the business logic as much as possible within HANA to prepare KPIs and business-measures
• 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