SAP BI Consultant

Silvia Savitha George

** ****** ******,

RICHMOND HILL,

ON L4E4N1.

MOBILE +1-647-***-****

E - MAIL ******.*******@*****.***

Summary

13+ years of experience in building analytics solutions using SAP BI, SAP Analytics Cloud, Cognos, Business Objects (WEBI, Analysis for Office), Tableau and PowerBI. Strong data modeling and architecture skills and an in-depth experience and knowledge in all phases of an analytics project using different tools and technologies. Strong commitment to exploring and understanding new technologies and building great usable BI solutions. Core competencies include:

SAP BW modelling, transformations, custom extractors, reporting • In-depth knowledge on Layered and Scalable Architecture (LSA) • BEx Query Designer • BEx Web Application Designer • BEx Analyzer • Business Objects (BO) Web Intelligence (Webi), Analysis for Office • ABAP • VBA • Cognos Report Studio and Query Studio• SAP HANA modelling • SAP Analytics Cloud

Professional Experience

SAP BI Consultant, Adacel, Montreal, Canada Nov 2018 – May 2018

Responsible for the analysis, design and development of reporting solutions in the Sap Analytics Cloud based on SAP Business by Design as the backend

Worked closely with the business to deliver corporate reports such as the Profit Margin Analysis, Cost Center Expenses and others

Worked on the design and development of dashboards in SAC for Cost Center, Project Expenses and tracking these expenses against the budget

SAP BI Consultant, Chemtrade Logistics, Toronto, Canada Sept 2018 – Dec 2018

Managing two different Production BI systems based on BI 7.0 and 7.31 versions. Responsible for all maintenance and support related tasks for both of these systems.

Supporting the SAP Analytics Cloud dashboards solution for the Marketing group and involved in setting up new connections to pull data from existing ERP and BI systems.

SAP BI Manager, Chemtrade Logistics, Toronto, Canada June 2017 – Aug 2018

Managing two different Production BI systems based on BI 7.0 and 7.31 versions. Responsible for all maintenance and support related tasks for both of these systems.

Delivered reports based on BI frontend tools PowerBI and Tableau by integrating them with SAP BW.

Designed and delivered the backend data flow for BPC related reports within Chemtrade while working closely with the BPC consultant.

Delivered dashboards based on SAP Analytics Cloud allowing users to segment based on various dimensions like ShipTos, Plants and other data points. Involved in end-to-end analysis, design and build of the solution on SAC which involved, geocoding plants and customers in order to visualize shipments, freight costs etc.

oDue to version compatibility issues with existing SAP BI systems, the model was built in SAC using Import data connection rather than a live connection.

oWorked closely with SAP to provide feedback on improvements to SAC based on the issues faced during the model and stories build.

Delivered an integration project with the support of a single BI resource in a duration of 3 months. The project involved the integration of data from 2 different ECC systems by keeping the reporting consistent for historical as well as future reporting needs.

Migrated existing BEX Web reports into BO Webi based reports as well as Analysis for Office workbooks.

Responsible for building the roadmap of the Reporting Architecture based on S4 HANA and other data sources based on the current business.

SAP BI Lead, BMO Financial Group, Toronto, Canada Jan 2014 – June 2017

Managing a team of 6 to 8 developers (FTEs + Contractors) from a BW development, architecture and design perspective.

Managed the implementation of various BW projects like upgrade from BW 7.31 to 7.5, Near Line Storage solution, BPC system migration to HANA, Liquidity & Funding initiatives, Structured Mark Risk project and other regulatory reporting projects like E2 OSFI reporting within BMO.

Strong expertise in effort estimation and sizing of BW projects of various magnitudes.

Providing technical expertise to a team of developers and consultants on the SAP BW product as and when required.

Coordinating the development efforts with the off-shore and on-shore teams and making sure they deliver as per requirements.

Evaluating solutions delivered from various vendors to make sure they are aligned with the overall banks’ future architectural needs.

Providing support to the production support team by recommending OSS notes based on production issues and providing recommendations to tune the production environment where needed.

Evaluation of front end tools and other SAP BW integration products as and when required.

Working towards strategies to mitigate the production DB growth issues.

Senior Business Intelligence Developer, Home Trust Company, Toronto, Canada Jan 2013 – Jan 2014

Gained expertise in the SAP CML, CMS and Deposits module of SAP while working on BW related data models in those areas.

Contributed towards the Data warehouse redesign project that was based on Kimball methodology best practices. Role involved creation of custom extractors, enhancing standard and custom extractors and creation of BW data models based on the best practices.

Played an integral part in the development of the SDL and DLL layers in the SAP Bank Analyzer implementation project. Also, underwent formal training on Bank Analyzer TBZ251 course.

Delivered SAP BW training sessions for team members on a weekly basis. Provided support and guidance on technical topics as and when required by other team members.

Worked on tools that would proactively identify potential failures in production before they could occur.

Facilitated in the testing of Banking Services upgrade project by providing technical support to test extractors as and when required.

Senior Business Analyst(BI), Hyundai Auto Canada Corp., Toronto, Canada May 2012 – Dec 2012

Creating, reviewing and maintaining Project Management and Business Analysis standards and best practices, including processes and supporting documentation.

Conducting fit and gap analysis on SAP functionality aimed at supporting related business requirements.

Assisting key business owners on business process design decision-making.

Development of WBS elements, BPML documents and networks for the projects.

Conducting quality reviews of all enhancement and defects as well as risk assessment and mitigation plans for the SAP project.

Contributing towards the SAP R/3 Implementation project by documenting the SAP SD, MM and Dealer Portal implementation at Hyundai Auto Canada Corp(HACC)

Created videos and training materials to train Hyundai Dealerships on the newly implemented Dealer Portal Solution.

Planned and executed SAP training sessions for users at different levels which included the CEO, Directors, National Managers and Business Users.

Analyze, Prioritize and Allocate work tasks to off-shore SAP resources(US and Korea).

Software Developer, SAP Labs Canada, Montreal, Canada Sept 2007 – June 2011

SAP AG’s research and development center outside Germany and a strategic hub for services and support.

Worked as part of the development level support for SAP’s Data Warehousing and Business Intelligence solution(SAP BW) and hence possess in-depth technical knowhow in data warehousing and business intelligence concepts.

As a part of the support team, directly worked on the customer OSS messages and provided suggestions on the backend data modeling as and when required. Hence aware of customer issues in the area of extraction and loading, related performance issues and ways to investigate and solve such issues.

Complete responsibility for the area of Data Transfer Process for BW 7.0 as a part of the BW Installed Base Maintenance and Support (IMS) team, which is the development level of customer support for SAP AG.

Handled complex customer issues related to the new feature Data Transfer Process. Strong concepts and experience in the area of data extraction, transformation and loading in SAP BW.

Strong ABAP skills since was responsible for correcting and enhancing the SAP BW product coding.

Was responsible for the mentoring and training of new colleagues joining the IMS team in SAP Labs Canada on the basic courses of BW310(Warehouse Management) and BW305(Reporting).

SAP BW Consultant, Bacardi, Geneva, Switzerland July 2006 – May 2007

Bacardi is the world's largest privately held, family-owned spirits company, with presence in more than 200 countries.

Involved in the design and implementation of the Data Warehousing solution for Bacardi(SAP BW/BI), right from the requirements gathering, drafting the functional specs, modeling and reporting.

Gathered requirements from the business users, documented the functional/technical specifications, implemented the project and trained the end users on the same.

Documenting the solution for the end users by creating the user manuals and technical manuals.

Assumed complete responsibility for handling critical production issues related to the Business Warehouse data and reporting.

Resolved complex issues related to frequently failing process chains and master data.

Complete responsibility for the design of various KPIs in the area of SD, APO, MD and FI.

Implementation of OSS notes in SAP BW and other OSS related tasks.

Responsible for setting up and configuring the extraction using LO cockpit in the areas of Sales, Purchasing and Billing and enhancement of those extractors when needed.

Development Specialist, SAP Labs India, Bangalore June 2003 – Dec 2005

SAP AG’s second largest research and development center outside Germany and a strategic hub for services and support in the Asian region.

Worked as part of the Development and Support team for SAP’s Data Warehousing and Business Intelligence solution(SAP BW).

Complete technical responsibility of the coding for the areas of Master Data, RSRV framework and the PSA for BW 30B and 3.5 as a part of the BW Installed Base Maintenance and Support (IMS) team, which is the last level of customer support for SAP AG.

Handled complex customer issues related to Master Data inconsistency, the upload, deletion and reorganization of master data. Strong concepts and experience in the area of data extraction and loading in SAP BW.

As a part of the support team, directly worked on the customer OSS messages. Hence aware of customer issues in the area of extraction and loading, related performance issues and ways to investigate such issues.

Involved in the fixing of critical issues related to the PSA (Persistence Storage Area) in SAP BW 30B and 3.5

Strong concepts and experience in the area of Data modeling and Reporting in SAP BW 30B and 3.5. Underwent extensive training in SAP Labs India in these areas and very confident working in these areas.

Was responsible for the mentoring and training of new colleagues joining the IMS team in SAP Labs India. Conducted the official BW 310 and BW 305 courses for colleagues in SAP Labs India.

QA Personnel, Talisma Corp, Bangalore Jan 2003 – May 2003

A leading provider of Service, Marketing, and Sales solutions that integrate the power of Email, chat, real-time collaboration, and telephony applications with a mature, robust, multi-channel CRM platform.

Responsible for the testing processes for the E-Marketing module of the CRM solution

Responsible for bug filing and tracking, smoke testing and regression testing for the Campaigns aspect of the E-Marketing module.

Developer, Prosperity Marketing Services, Mysore Jan 2002 – Dec 2002

Responsible for requirements gathering, detailed design, coding and testing for the Sales, HR and Marketing modules.

Responsible for implementing the Management Information System (MIS).

Worked on the following databases/technologies as part of the implementation project: SQL Server 2000, Visual Basic, HTML, JavaScript and ASP.

Education/Training

Secured 3rd Rank in the University of Mysore, Karnataka in MCA (Master of Computer Applications), July 2002

Secured 2nd Rank in the University of Mysore, Karnataka in BSc (Bachelor of Science), July 1999

In-depth & exhaustive on the job training in ABAP courses BC400, BC402, BC404, BC410, BC414 & BC430, as well as SAP Business Warehouse BW305, BW310, BW315, BW330 and BW350 from SAP Labs India.

References

Will be provided on request.

Contact this candidate