Sap Hana/bods Architect/consultant Resume
SUMMARY
- Last 10 years, experienced in SAP BODS, BO, BW, ECC, APO, SCM, CRM, TAR, SQL and HANA. Expertise in estimation, analysis, design, development, testing, trouble - shooting, deployment, upgrades, migrations, documentation and on time deliveries with match teh compliances of enterprise applications for multiple industries different business units.
- Experienced with SAP HANA integration to extract teh data through SAP Data Services(BODS) from Legacy Sites Flat files, Oracle Tables, Excel Files, XML Files, Essbase Flat files, SAP ECC Tables(through SLT Replication)
- Design & Creation of HANA Information Models with Attribute Views, Analytical Views & Calculation Views, Implementation of Dynamic Security using SQL Stored Procedures with extensive familiarity with SAP HANA Studio.
- Strong SQL Scripting, HANA Data Architecture with backend BODS ETL expertise along with familiarity with various source data replication mechanisms: SLT/ETL/Log/Trigger based.
- Have an Extensive experience in all stages of an enterprise-wide SAP implementation SDLC, ranging from project scoping, requirements definition, blueprint, design specification, development, performance tuning, testing, documentation, maintenance, training business users with Major/Minor Release Go-Live Support with various implementation partners.
- SAP Certified HANA Consultant with 98% Certification Score
- PMP Certified by PMO organization along with Master Degree in Computer Science.
- Functional Knowledge & Hands on experience in OLTP data extraction from Sales Distribution (SD), Supply Chain (SCM), Material Management (MM), Production Planning (PP), Finance & controlling (FI-CO), Human Resource (HR), and CRM systems using generic, LIS, LO Cockpit, CO-PA, maintain delta queues.
- I have an Extensive Expertise in leading multiple Offshore Models to execute various projects through preferred implementation partners by interpreting Functional Specifications into Technical Design for offshore folks along with expertise in Oracle, SQL Server, SAP, BW, HANA interfaces from ETL Stand Point.
- Experienced in SAP HANA Administration including managing schemas, data model objects, import/export content and SAP HANA Security including User Management, Roles, and Privileges along with Cron-tab Scheduling mechanisms
- Expertise in Full and Partial Push Down mechanisms for processing to be done on teh Database Servers, along with experience in Rapid Marts installation/maintenance on BODS Platform.
- Worked on Change Data Capture on both Source and Target level with SCDs (Slowly changing Dimensions) Type 1, Type 2 and Type 3 mechanisms along with Table Comparison, History Preservation & Key Generation Transforms.
- Good noledge in BW modeling mechanisms using Extractors, Open Hub Destinations, infoCubes, infoProviders, DSOs, Virtual Providers, MultiProviders, infoSets, infoAreas and well versed with related Data Provisioning practices into HANA to feed BOBJ frontend Reporting Tools, Universes, WEBIs, Dashboards..etc
TECHNICAL SKILLS
SAP Packages: SAPR3 4.6C/4.7, ECC 5.0/6.0, mySAP Business Suite, BW 3.5 and BI 7.x (NW 2004s), BODS, BO, HANA
SAP Modules: FI (AR, AP, GL) CO, SD (OTC, MTC) MM, PP, PS, HR, BI-BW, BPC, APO, SCM and CRM
Reporting Tools: BEx Analyzer/Query Designer, WAD, APD, Lumira, QlikView, Tableau, Cognos and Pentaho
Utility Tools: Custom Tcodes, nPrint, AutoSys, Espresso and Expressor, Version One
Web Technologies: HTML, XML, CSS, JavaScript, SharePoint and multiple web servers
Languages: ABAP, Java, VBA and SQL
RDBMS: Access, SQL Server, MySql, DB2, Oracle, Sybase and HANA
Other Tools: MS Project/Office, Visio, Remedy, Tivoli, Primavera, and Quality Center
Interfacing: Flat Files, XML Files (DTD & XSDs), Excel Workbooks, Batch Jobs, Web services, SAP HANA DB, Oracle 11g/10g, MS SQL Server