Ashwini Kumar Jaiswal

adb6yc@r.postjobfree.com +1-314-***-****

Summary

A highly accomplished BI Architect with 12 years of IT experience, certified in SAP HANA / BW Analytics and ITIL. Have extensive hands on experience in HANA native and BW on HANA domain covering over architectural design, solution development and large scale implementation.

Have worked as SAP HANA/BI/BW solution architect for range of industry domains such Consumer Goods, Energy & Utility, Securities, Telecom, managing people and technologies for both Fortune 500 companies and Start-ups and have delivered seamless analytic solution that are helping organizations to harness the potential of BI in transition to a whole new level of performance.

Expertise in mapping complex business requirements with IT solutions, sophisticated data modelling, data extraction and loading, data analysis and visualizations.

Proficient in SAP HANA Information modelling, Complex SQL scripting and Procedure development, HANA repository creation and maintenance, Deployments using HANA application life cycle management tool, SAP BW modelling using info cubes, classic and advance DSO, Custom Extractors, Multi and Composite providers. Design and development complex transformations, Business objects 4.X WEBI reporting and complex universe designing using IDT, ETL design using SLT and BODS, BEX query design and development in HANA studio version.

Advance knowledge on SAP Design Studio, Tableau, and Qlikview reporting tools.

Seasoned professional with experience in SAP functional area of CO-PA, Finance, Supply Chain and

Commercial.

Experience

SAP BW/HANA Architect at GE Lighting February 2018 – Till Date

As an architect, is responsible for SAP HANA BI / BW system architecture and application designing of the GE Lighting BI Landscape, transform the legacy system to more advance and robust Business Intelligent System. Build Business Intelligent Data modelling and Complex Information Models using SAP HANA and SAP BW technologies to optimize the existing data warehouse and Reporting System. Involved in Complex data modelling and transformations.

GE lighting BI system is built on SAP BW on HANA hybrid model designed to cater reporting services to Finance, Supply Chain, Inventories, Commercial SAP function/business. I have worked on requirement gathering, designed data models and transformation logics and built interactive and user friendly reports in BEX and WEBI like CO-PA, Account Receivable Walk, GL line items, Stock Overviews, Daily Sales, Material listings, Safety Stock and many other very highly consumed and complex reports. I have worked on innovative design of the BW and HANA objects starting from custom extractors, Data Store Objects both classic and advance, cubes, multi and composite providers, Complex Native HANA Views/information models, SQL scripts and DB procedures.

I was involved in functional and technical review of newly developed and enhanced design and development works of team member and participate in Peer Testing of the system. Establishing Business Intelligence Best

Practices in the organization and help to harness the capabilities of advance BI tools and systems. I have been working on agile environment with scrum based delivery model and was leading our team in successful delivery. I have prepare Technical and functional documents of the architecture, design and development work for future references and share it with team members as guide for any future enhancements and support. Review Change request management system for seamless deployments of developed /enhanced objects from development BI environment to UAT and Production environments.

SAP BW/HANA Architect at Anheuser & Busch Inbev August 2014 – February 2018

As a HANA/BW architect, have worked for multiple implementation covering an array of technological domains. The key responsibilities were to architect, develop and deliver technical solutions for different complex and critical business requirements over the SAP BI landscape.

End to end implementation of HANA/BI/BW solution starting from requirement gathering, extraction of data from multiple source and loading, data modelling to create Information models and cubes/ADSOs which further used in business intelligent report/dashboard developed via visualization tools. Have worked on creating complex transformation model based on Supply Chain / Logistics sources.

Have also worked on multiple Native HANA application development and enhancements in HANA development platform using HANA Information models, tables, procedures, XSJS and SAP UI.

Proficient with basic administration of SAP HANA environment, service monitoring, server jumps, log analysis, HANA configurations, User /Role management and Security Controls

SAP BW/HANA Lead at British Telecom May 2012 - July 2014

As BW/HANA Lead, was responsible for the implementation of Information Management System for a project under Government of Scotland. Activity ranging from requirement mapping, data analysis, data extraction and transformation from ECC and other OLTP system to SAP BW on HANA using BODS. Worked on Data modelling using the SAP BW objects and artefacts’, designing and developing Info cubes, Classic DSOs, ADSOs, Multi providers and composite Providers. Involved in Universe designing using Business Objects IRD and Report Development and distribution using BO WEBI.

Senior BI Consultant at State Streets July 2011 - May 2012

As a Senior BI Consultant, was responsible for Maintenance and enhancements of BI/BW applications developed for State Streets. Worked on BI /BW transformation, routines, DTP, Info packages, Cubes, DSOs. As an offshore lead was responsible for leading 12 member BI team with ownership of Delivery and quality.

Technical and Function reviewing, automation, version control and deployments was part of my key responsibilities.

BI Consultant at Royal Dutch Shell January 2010 - May 2011

As BI Consultant, was responsible for Business Objects Infrastructure Management. Worked on Complex WEBI report Development, Report Scheduling and Publishing.

Responsible for Content, USER and Server Maintenance. Migration using LCM and Import Wizard.

Incident, Change and Problem Management using the SM7 Tool.

BI Consultant at Royal Dutch Shell July 2008 - January 2010

Responsible for Designing and Analysing Business Critical Reports (KPIs and MIs). Excel VBA Coding and tool development.

Budget and Cost tracking domain reporting, Perform Data and Quality Analysis.

Design and management of PMO portal using on SharePoint using SharePoint out of box functionalities.

Education

Bachelor of Technology

Certifications

SAP HANA Certified Application Associate

ITIL Foundation

Contact this candidate