Hana Architect/hana Modeler (hana, Bw, Bi) Resume
Alpharetta, GA
SUMMARY
- More than 12 years of SAP BW experience.
- More than 5 years of experience of HANA 1.0 as HANA Modeler/Architect, Native HANA, SLT
- About 7 years of experience on BODS
- More than 15 years of experience in Data warehousing and SAP R/3 Enterprise.
- More than 5 years of Business Objects experience
- Proficient with planning, analysis, design implementation (LSA++), trouble shooting and performance testing support of SAP BW/HANA.
- Involved in implementation of BW development based on SD, MM, FI, CO,PM and HR modules
- Involved in Design and implementation of SAP BW using ASAP Methodology
- Extensively worked with ABAP on User Exits, Update Rules and Transfer Rules
- Developed Bex Reports.
- Worked on BO 4.1/3.X (Web Intelligence, Xcelsius/Dashboard and Universe Designer, Analysis for Office),
- Excellent planning, analytical, written Communication and Interpersonal skills.
- Knowledge of Predictive Analytics, R Language
- Knowledge of Big Data tools: HDFS, SPARK, HBASE, PYTHON, SPLUNK
PROFESSIONAL EXPERIENCE
Confidential, Alpharetta GA
HANA Architect/HANA Modeler (HANA, BW, BI)
Environment: BOBJ 4.0 SP4, SAP BW 7.5 SP5, HANA 1.0 SP12, SAP ECC, HANA 1.0, HANA Studio, SLT, BODS 4.2, Control M, Service Now, IDT, Webi, Microsoft SSIS, CRM, C4C (0217), CLM
Responsibilities:
- Involved in design and development, testing and successfull implementation of BW on HANA and Native HANA applications for Confidential
- Involved in BW HANA migration using DMO from BW on SQL server
- Design and development of Finance real time reporting using HANA models
- Worked on data provisioning technology including SAP LT Replication Server
- Involved in Data flows conversions to HANA optimized infoproviders after BW on HANA Migration
- Designed and developed Attribute views, Calculation views.
- Worked on Smart Data Access to Access data from Microsoft SQL Databases
- Interacted with Key Business Managers for gathering the requirements prepared Technical Specifications based on the Functional Specifications
- Created Analytic priveleges for business users
- Worked on performance testing of HANA models
- Managed triage of Incidents/break fixes related to SAP BW and Business Objects área in addition to development
Confidential, Newark, NJ
HANA Architect/Lead Developer
Environment: BOBJ 4.0 SP4, SAP BW 7.3, Native HANA 1.0(SP7), SAP ECC, HANA 1.0, HANA Studio, SLT, BODS 4.2, Maximo, IDT, Webi, Dashboard, Design Studio 1.2
Responsibilities:
- Designed and developed the HANA views for reporting requirements
- Design and Development of Universes using IDT needed for the reports
- Involved in guiding the future strategy like HANA/Big Data
- Worked on performance testing of HANA models
- User Interaction for data validation and approvals of the Webi reports
- Design and development of Dashboards using universes
- Trained Business users on the reporting usage
- Interacted with Key Business Managers for gathering the requirements, prepared Technical Specifications based on the Functional Specifications
- Designed and developed Attribute views, Analytic Views and Calculation views
- Worked on SQL Scripting to derive the complex Calculation view
- Designed and developed the native HANA applications (HANA Modeling, Trouble shooting, Debugging)
- Extracted data from ECC system into HANA Database using SLT for Finance Applications
- Extracted data in to HANA from Oracle databases using BODS
- Created Analytic Priveleges (HANA Security)
- Worked on performance testing of HANA models
- Trained Business users on the reporting usage
Confidential
BW HANA Architect/Lead Developer
Environment: BOBJ 4.0 SP4, SAP BW 7.3, SAP BW 7.3 on HANA 1.0(SP9), SAP ECC,ABAP/4 HANA 1.0, HANA Studio, Jira, Remedy,HP Quality Center, Mulesoft, JDA Supply Planning, Life Cycle Manager
Responsibilities:
- Designed and developed Attribute views, Analytic Views and Calculation views. Worked on SQL Script to deliver the data from HANA to the Unix Server database.
- Worked on Smart Data Access
- Interacted with Key Business Managers for gathering the requirements, prepared Technical Specifications based on the Functional Specifications
- Designing the BW data extractors, DSOs and later on building Analytic Views on DSOs, creating Calculation view.
- Exported the Developed views to TEST and Production Systems using Application Life Cycle Manager
- Created Analytic priveleges and SQL Procedures
- Worked on performance testing of HANA models
- Established the systems and procedures for the HANA Environment for the first time.
- Established the naming conventions, development land scape for HANA environment.
- Hershey had Standard BW system on Oracle and also BW on HANA (Sidecar concept). Involved in development of critical applications in BW on HANA.
- Developed the generic data sources based on Function Module, Views, Tables needed for the Project. Completed the BW development to load the data in to BW on HANA.
- Worked with models related to Supply Chain Management Area
- Developed Shipper Reporting Application and Packaging Datamart Application
Confidential
Lead Application Consultant
Environment: BOBJ 4.0 SP4, SAP BW 7.3 SP8, SAP ECC,ABAP/4, Microsoft SQL Server, Oracle Databases, Information Design Tool, Web Rich Client, Web Intelligence, Dash Board Designer, Solution Manager, BWA, HANA 1.0, BODS 4.2, CMC, BI Launch Pad, Design Studio
Responsibilities:
- Worked on Plant Alanytics applications extensively (Supply Chain Management, MM,PP,SD).
- Part of Technical upgrade of BW 7.0 to BW 7.3
- Involved in HANA Migration with DMO OS/DB provided by SAP
- Worked on HANA 1.0 Data Provisioning involving the areas SLT, BODS
- Worked on HANA 1.0 Data Modeling involving Attribute Views, Analytic Views, Calculation Views, SQL Script
- Worked on conversion of Infocubes, Standard DSOs to HANA Optimization in BW on HANA landscape.
- Worked on SAP Business Content related to HANA like Time Data
- Built Transient Infoproviders, Composite Infoproviders using BW HANA optimized Infoproviders along with HANA Views
- Involved in the design, development and implementation of Valve Test Results application project, source data from Oracle databased of Valve tests information (Allan Bradely Testers).
- Designed and developed Pitch Chart application to display plan, actual production on the dashboard, source data from SQL Server databases (Vorne Machines Interfaces).
Confidential
SAP BW Team Lead Consultant
Environment: BI 7.0, SAP ECC, Oracle 8, Unix, NT,ABAP/4, BODI XI, Oracle Warehouse Builder, Toad, Business Objects (4.0/3.x), Universe Designer, Web Intelligence, Xcelsius, Solution Manager, Tivoli (IBM), BI Docu Performer, BWA, SD,PM,FICO
Responsibilities:
- Gather and document the detailed reporting requirements and recommend BI Solution Architecture that best satisfies the business need
- Conducted workshops to gather functional requirements from business users and management
- Involved in BW 3.0 Migration to BI 7.0
- Design and Development in BI 7.0
- Created several Web Intelligence queries with cross tabs, grouping of data, context operators, YTD calculations etc.
- Created Dash Boards making connection using Query as a Webservice.
- Dash Boards designed making use of maps, guages, pie charts, alertscharts, selectors.
- Involved in implementing BW development using SAP Solution Manager 4.0
- Involved in the design, development and implementation of Regional Controlling Reporting System in Business Warehouse.
- Involved in design, development and implementation of EDW Migration to SAP BW Migration in totality involving Sales and Distribution, Inventory Management, Supply Chain Management, Production Planning.
- Design and Development of InfoObjects, DSOs and InfoCubes, Data Extraction from SAP R/3 and legacy systems.
- BW Support to take care of data load issues, hyper care, performance tuning, root cause analysis
