Sap Bw Solution Architect

Venkat P Cell#: 651-***-****

SAP BW/HANA *.*/Datasphere/PBI *************.***@*****.***

Professional Summary:

• Having around 17+ years of IT experience in SAP BW, BI, Enterprise HANA 1.0/2.0, BW/4HANA, BODS/SAC/SDI/SDA/Power BI, S4HANA and more.

• Involved in end-to-end system upgrades from NetWeaver BW 7.3 to 7.4 & BW 7.4 to 7.5 BW/4HANA.

• Involved in end-to-end Database Migration from Oracle DB to HANA.

• 8+ Years of hands-on experience in Native HANA, 3+ years in SLT / SDA / SDI.

• Played a key client-facing role as BW/HANA Techno Functional Architect for 4+ years.

• Involved in Project Estimation by gathering RFP directly from Business Users.

• Managed & Co-ordinated Hypercare support after go-live.

• Worked on SAP HANA SDA (Smart Data Access) / SDI (Smart Data Integration).

• Involved in creating a comprehensive architecture / design consisting of SAP BW, SAP HANA, SAP ETL and Non-SAP (Oracle, MS SQL, OS390, AS400, JD Edwards ERP etc).

Work History Summary

Employer/Client Job Title Start Date End Date

NEA - QVC HANA Solution Architect Mar’2022 Feb’2024 NEA - Fresenius Medical Care HANA Solution Architect Apr’2020 Feb’2022 NEA – Zimmer Biomet Solution Architect Mar’2019 Mar’2020 NEA - Kimberlyclark Solution Architect Dec'2018 Feb’2019 Accenture - 3M CORPORATION Team Lead (BW-HANA) Dec'2012 Nov'2018 Accenture - Electrolux Compass BW Team Lead Aug'2011 Nov’2012 Accenture - Henkel SAM Senior Software Engineer Aug’2010 Jul'2011 HP GDIC - SAIL DSP & BSP Software Engineer Mar'2010 Aug'2010 IBM - Suncor Energy BI/BW Developer Dec'2005 Nov'2008 TCS - Kaiser Permanente BI/BW Developer May'2005 Dec'2005 Educational Qualification

Degree University Institute/College

BE Bharathiar University,

Coimbatore, TamilNadu

GCT - Govt, College of Technology. Coimbatore,

TamilNadu. India

Venkat P Cell#: 651-***-****

SAP BW/HANA 2.0/Datasphere/PBI *************.***@*****.*** Skills:

• SAP B4HANA 7.5 • SAP BW on HANA 7.4

• SAP S/4 HANA • SAP Native HANA 1.0 & HANA 2.0 WebIDE

• SAP BODS • SAP SLT

• SAP SAC • Power BI Desktop

• SAP Datasphere • MS Azure

Datawarehouse: SAP BW3.X, BW 7.x, B4HANA 7.5

• Experience in SAP BW 3.x to till SAP BW 7.5

• SAP BW on HANA: Migrated SAP BW 7.0 to BW 7.5.

• Database Migration from Oracle DB to HANA.

• Extracted the Supply Chain and Finance data from various Non-SAP to SAP system.

• Expertise in report generation in BW, worked extensively on BEx Analyzer, Query designer, Variables, condition, and exceptions

• Designed, Developed and implemented and utilizing Analysis process Design (APD) using complex queries and cubes.

• Good experience in Performance tuning and structural fix for the repeated issue.

• Solid experience in data reconciliation and system stability

• Excellent experience in creating and working with HANA Composite Provider, Data source, ADSO, Multiprovider, Infoset, Transformation, DTP, APD, Openhub, Update rules, Transfer rules, Aggregate, Roll-up, Enterprise Portal, BEx, RRI, APD, Broadcaster, BI content objects etc.

• Extensive knowledge in Currency conversion, Transpose in HANA views.

• I played the key role as BI / BW / Native HANA Lead and worked on varied tools like BODS, SLT.

Venkat P Cell#: 651-***-****

SAP BW/HANA 2.0/Datasphere/PBI *************.***@*****.*** Native HANA: SAP HANA 1.0/2.0 (Web IDE)

• Worked extensively in WebIDE Git Push / Fetch / Merge and Native HANA modeling.

• Implemented / Designed HANA 2.0 WebIDE modeling concepts using Calculation View, Restricted & Calculated Columns, Filter Operations, Variables, SAP HANA SQL, SAP HANA XSA, HANA XS Odata.

• Designed and developed complex HANA views, Aggregations, Joins, Unions and Projections in Eclipse/HANA Studio.

• End-to-End experience in HANA Objects transport management for Delivery Units.

• Extensive expertise in Native HANA Administration console/Modeler like Data Provisioning, Import, Export, Object Validation / Activation, adding systems, System / Job monitoring, and troubleshooting data loads.

• Created Composite Providers in BW Modelling based on HANA Views; also created Hybrid Calculation views in Native HANA using Inner / Left / Full Outer and Star join. ETL: SAP SDA/SDI & SAP BODS (Migration)

• Created multiple Data Service jobs for extracting & harmonizing the data from Non-SAP to HANA DB.

• Created Custom Table in HANA DB and Loaded the data form HANA views.

• Worked in SAP HANA SDA (Smart Data Access) / SDI (Smart Data Integration).

• Add custom column to the SLT enabled tables to update the timestamp.

• Have Hands-on experience in Performance Tuning and Data Provisioning Tools such as SLT, SDA, SDI and BODS.

• Worked on various data migration from Non-SAP to SAP BW and HANA.

• Extracted the data from SQL Server and loaded into HANA DB using BODS Venkat P Cell#: 651-***-****

SAP BW/HANA 2.0/Datasphere/PBI *************.***@*****.*** Reporting/Visualization: BOBJ, SAC, Microsoft AO & Power BI

• Worked in Analysis for Office (AO) to replace the BEx Workbooks.

• Designed and built Universes using Designer, created and modified Web I, Crystal reports from the underlying Oracle and SQL server databases for different business modules

• Created reports on top of HANA with Power BI / DAX Reports.

• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Line Charts, Area Charts and etc in Power BI.

Functional: ECC, S/4 HANA (Migration)

• Have worked extensively on S/4 HANA and ECC, Supply Chain (SD, PO, Prod, Inventory) FI-CO, and other core functional modules like SD-Returns, MM, PM etc.

• Developed Ageing report (Sales Order, Vendor Payment etc)

• Activated DS in S/4HANA 0FI_ACDOCA_10 and 0FI_ACDOCA_20 and enabled the Data flow in BW/4HANA.

• Deployed FI reconciliation data model and SAC visualization reports using ACDOCA DS and MATDOC tables.

• Developed RAR - Revenue analysis and other reports.

• Customized the SAP Standard CDS views as per the customer requirements.

• Coordinated and performed HP ALMQC testing and met all the requirements through varied stages of test cycles (TUT, FUT, PIT and UAT).

• Experience in Business Process, Documentation, Estimation, SDLC methodologies.

• Solid knowledge and experience in Overall SAP Net Weaver BW Architecture, Process Modeling, Synchronization, EDW Modeling, Requirement Analysis, Estimation, Gap Analysis, Technical Design etc.

• Wide Experience in HP ALMQC, Agile, JIRA and SCRUM Concepts.

Contact this candidate