OBJECTIVE

Dedicated and experienced SAP HANA/BOBJ-BI – Modeler, Admin, Solution Architect with 11+ years of proven success in implementing 13+ end to end solutions covering data validation, data migration, physical-logical data modeling, data analytics & development of BI reports. My ultimate objective is to “Empower users and Machines by unleashing the power of data”. Seeking an opportunity where I can utilize my skills to feed the future with data.

TECHNICAL SKILLS

SAP: HANA 1.0, 2.0, HEC/AWS/Azure, ChaRM with Solman 7.2, Transport (HALM/Delivery Unit), HANA/BOBJ/BODS -Administration and Security, BODS 4.2, SLT, SDI, SDA, DXC. Oracle, DB2, SQlL Server, Analytic/Calc. View, SAP BOBJ-BI – Web Intelligence, Analysis for office, Lumira, Analysis for OLAP, SAP Crystal reports. Data Analytics, Change Management

Non-SAP: Analytical capabilities, motivated by deadlines, accepts constructive criticism and mentoring new resource.

PROFESSIONAL EXPERIENCE

HANA/BI/BODS Admin, Modeler, Solution Architect Nov - 2018 to Present

Client: Deloitte/SAP

Gathered business requirements for C4HANA, performed system analysis, planned processes to extract data from various source systems such as Oracle, SQL server, flat file formats, delivered proof of concept and full life cycle implementation in an agile environment.

Installed and built SAP HANA/BODS PoC, DEV, QA, PROD environments on AWS, configured SDI in HANA, BODS, BI tools, webdispatcher, created RFC’s in BODS, devised data-stores, scheduled jobs planned cutover and outages in alignment with business.

Developed SQL scripts to load data from Oracle to HANA using SDI-Smart Data Integration.

Migrated high volume data (over 1.5 billion records) in an hour for various Go-Live

Administrated and monitored CPU/Memory health in HANA during data load and Post migration. Performance tuning in HANA.

Single point of contact for SAP HANA/BOBJ/BODS Security & User management.

HANA/BI/BODS Admin, Modeler, Solution Architect July - 2017 to Oct - 2018

Client: Tata Consultancy Services/Nutrien

Gathered business requirements, planned processes, proof of concept, full life cycle implementation in an agile environment.

Installed, configured and built SAP HANA DEV, QA, PROD environments, setup alerts, SDI, SDA, SLT, BODS, BI tools, webdispatcher, created RFC’s in BODS, devised data-stores, scheduled jobs prepared cutover and outages in alignment with business.

Upgraded HANA to 2.0 SP03 on Azure.

Administrated and monitored CPU/Memory health in HANA during data load and Post migration. Performance tuning in HANA.

Single point of contact for SAP HANA/BOBJ/BODS Security & User management.

Architected and assigned repository roles, system privileges, package permissions.

Architected and developed multi-dimensional data models for SALES, HR, COST, Finance, SAFETY and reporting – Analysis for MS Office, crystal reports, web intelligence reports, publication, used SQL scripts, stored procedures, OLAP conn.

Transported objects from DEV to QA to PRODUCTION- HALM, Delivery Unit, Promotion management.

Provided weekly status reports that include risks, activity and progress.

Documented the installation procedures.

Diagnosed and resolved technical issues with the platforms and environments.

Oversaw mapping of data sources, data movement, data capacity planning & facilitated data discovery sessions involving business subject matter experts.

Setup KIOSK to troubleshoot end user issues, spearheaded developers meeting.

Proposed Change management, Release management and implemented.

SAP HANA/BI/BODS Modeler NOV - 2016 to JUNE – 2017 Client: CM Global Solutions

Assessed pain areas, identified the data sources, focused on business priorities.

Created SAP HANA use-case to extract information from patient docs & perform text analysis on unstructured data from various file formats txt, csv, pdf, doc, ppt, xls etc.

Created users, repository roles (HANA/BOBJ/BODS-CMC). Monitored CPU/Memory, webdispatcher, implemented best practices, solutions and strategies.

Assigning privileges & roles. Implemented customized audit policies, system alerts (SMTP), schema access.

Installed, configured and built SAP HANA DEV, QA, PROD environments, setup alerts, SDI, SDA, SLT, BODS, BI, created RFC’s in BODS, devised data-stores, scheduled jobs.

Addressed data related problems in regards to compatibility & multi-platform.

Reviewed functional requirement and developed technical document for BI projects.

Modeled HANA calculation view based on SAP platform IoTMMS table, setup to receive sensor data, filtered, analyzed & acted on millions of streaming sensor events per second for continuous insight of the business with HANA + SAP HANA streams.

Developed SAP BI reporting solution in SAP FI, SAP CO, SAP SD, SAP MM.

Enforced data governance standards & policies including metadata, master data, transactional data & configurational data.

Transported objects from DEV to QA to PRODUCTION- HALM, Delivery Unit, Promotion management.

End user support, data architect, data validation & coordinated with n/work team.

SAP HANA/BI Lead Consultant Sept - 2015 to Sept – 2016 IDEMIA

Proof of concept, developed blueprint and fostered data governance standards.

Driven implementation of functional design into technical design & build deliverables.

Developed data replication framework to integrate SAP & non-SAP data into HANA.

Experienced in designing & implementing high performance architecture approach, advanced attribute views, Analytic views & unifying calculation views.

Created & executed complex model views for SD, finance and production modules, processed up-to 200+ millions record in few seconds using native HANA.

Configured JDBC/ODBC rel. connection (local/secure), business & data foundation layer. SAP HANA 1.0 SPS 9/10, SAP BODS 4.2 and SAP Lumira

Demonstrated in-depth analysis, devised KPI’s in web intelligence, universe from IDT, ad-hoc crystal reports, Lumira for inventory turn analysis & shrink reports.

COPA cost-based extraction/report: Created analytic & calculation views (COEP, COBK, COEPR, BKPF, BSEG, CE4V001 tables).

Mentored team, ensured HANA modeling/BI solutions techniques were understood and applied appropriately.

SAP HANA/BI Consultant Feb - 2014 to Sept – 2015 N.I.C

Devised & deployed plans under project manager guidance, conducted workshops with business primes, technical architecting & process designs.

Data standardization, de-duplication, cleansed, extracted, transformed, migrated & loaded data from ECC, BW, non-SAP systems to HANA (SLT, BODS, DXC, SDA, Flat files.

Executed HANA based solutions & knowledge transfer to end-users.

Provided roadmap for rollout based on business needs & root cause analysis.

Evolved data models to meet new & changing business requirements using star-schema, joins. SQL scripts, analytic privileges, procedure and functions.

Migrated HANA content (packages, information models) from development, testing environment to production system & performed schema mapping where needed.

Architected and developed the HANA native model, BOBJ universe and Webi reports

UAT sign-off, Go-Live & end-user support & focused on continuous improvements.

HANA/BI Modeler, Sol. Architect May - 2013 to Jan – 2014 ITSL LTD.

Accurately prepared project plans, conducted workshops to gather requirement, GAP analysis, determined procedures on new assignments with project manager guidance.

Data provisioning ETL, integration (cleansed, extracted, transformed, loaded data from ECC, BW & non-SAP systems (SQL server) via SLT, data services.

Accomplished transactions by creating universe in IDT for Web Intelligence, crystal reports, built SALES, finance and HR KPI’s in BI.

Coordinated with onsite/ offshore team for development efforts.

UAT signoff, Go-Live and end user support.

Programmer, Business Analyst Sept - 2008 to Apr – 2013 N.I.C

Implemented strategy planning, gap analysis, designed context data flow diagram, data cleansing, data migrations, master data readiness and performed data analytics.

Ensured data integrity, data quality with appropriate tools, applications, software & techniques by working with operations & technical teams.

Overhauled haphazard technical architecture, designed continuity plan and designed data.

Developed, implemented approved model solutions for e-Governance and mission critical projects, integrated digital signature with-in application.

Facilitated UAT signoff, Go-Live, Troubleshoot and end user support

EDUCATION

Post Graduate Diploma in Systems & DBA - 2008

Centre for development of Advance computing, India.

Bachelor in Information Technology - 2007

Kurukshetra University, India.

Contact this candidate