Data Analyst

Personal summary

Professional Highlights MSc. Information Technology. Data Analyst with 3+ years of technical/ functional proficiency in analytics, data warehousing and SAP data migration. Proficient in ETL methodologies, data profiling and master data governance using SAP BODS. Adept in statistical analysis and SAP HANA. Excellent understanding of business operations and analytics tools (SAP dashboard, Webi, Tableau). Also familiar with AWS live lab and experienced in pulling data from heterogenous sources such as SAP ECC 6, MS Excel and MS SQL. Skills • Very familiar and knowledgeable in Scrum (Agile) methodologies • Tools: SLT, SAP Business Object Data Services (BODS on SAP BOBI 4.2 SP05), LSMW, Tableau, Flat file Uploader, SAP BO reporting tools, MS Office 365, SharePoint, MS PowerPoint Education • M.Sc. Information Technology (IT) De Montfort University Leicester UK 2003 • Bachelor of Science in Chemistry University of Buea, Cameroon 1998 Professional Experience Sobeys, Calgary Data Analyst/SAP Specialist 2019 • Extracted data from non-SAP system, SAP ECC 6 and SAP R/3 systems using BODS into SAP HANA using both normal and ABAP data flow (about 400,000 sales records) • Provisioned data using SLT from ECC 6.0 system into SAP HANA • Reviewed over 50,000 records of promotional data (cleansing and migration from MS Excel to SAP) • Validated promotional deals received to meet expectations using business logic in SAP • Maintained promotion changes by merchandising teams in planning tool using SAP • Validated entries using available reports and tools (in MS Excel, SAP) • Reviewed forecast and budget issues with the cost report to confirm proper recognition of cost and revenue • Reviewed system reporting tools for issues in promotion setup and correction issues Shell, Calgary (IPT Project) BO Report Developer 2017 –2018 • Elicited, analyzed and assisted in creating business requirements, functional specifications and technical requirements for the IPT project • Worked in an Agile environment involving 23 stakeholders, 5,000 users and a budget of $3M • Worked with SAP BO 4.1 reporting tools including SAP Dashboard, WEBI and other BO tools • Designed universes from views, database tables using IDT and UDT for reporting (using Tableau, Webi, SAP Dashboard) • Improved the time for BODS provisioning transferring over 90,000 records of data from ECC 6.0 into SAP HANA using ABAP data flow • Acquired and transformed data from primary and/or secondary data sources to support ETL flow • Created technical ETL mapping specifications and reporting / Data Cube data specifications • Configured the local repository; administration of the central repository for BODS process in both multi and single user environments • Deployed BODS code across Dev, QA and Production environments using central repositories • Applied global SAP BI reporting architecture, focused primarily on leveraging the suite of SAP Business Objects tools (BO Universe development, WebI, BO Explorer, Dashboard) Hewlett Packard (HPE), Edmonton Database Analyst 2014 – 2017 • Worked closely with IT regarding system performance, maintenance and optimization • Performed analysis and troubleshooting of queries using RDBMS toolsets; provide performance improvement recommendations • Performed database administration activities such as storage management, backup, recovery, and performance tuning reducing the downtime for queries by 7% • Developed system documentation for all developed applications databases, processes, and jobs, including flowcharts and data models Teleperformance, Montreal Technical Support 2011 – 2014 • Provided support for Apple customers on the phone such as backup of IOS 5 for about 67000 users • Updated iPhone 3 and iPhone 4 from IOS 4 to IOS 5 OS • Analyzed users’ contents with iCloud, iPhone and computer using Windows OS or Mac OS • Restoration of iPhone and iPad backups on Mac and explaining procedure for technical support MTN Douala, Cameroon Business Analyst 2008 – 2011 • Supported product development for an Enterprise Resource Planning (ERP) system (SAP HR), with a service-oriented architecture (SOA) • Uploaded more than 60,000 employee records from flat files into SAP ECC 6.0 using LSMW • Supported end-users to execute UAT test plans • Ensured that test scripts were prepared as outlined in the test plan to meet requirements • Provided clarification regarding business requirement as related to issues/bug discovered during the software testing specifically on the usability and functionality of the application Professional Development • IT Project Management and Business Analysis SAIT, Calgary, April to May 2020 • Microsoft SQL Queries SAIT, Calgary, April to May 2020 • Microsoft Azure Fundamentals SAIT, Calgary, April to May 2020 • Excel to MYSQL: Analytics Techniques for Business Specialization Cousrera (In progress) • Microsoft Power BI Lynda.com (In progress) • ITIL® 2011 Foundation AXELOS 2018 • SAP BOBI (C_BOBIP_4.1) Certified Associate SAP 2017 • MCDBA (Microsoft Certified Database Administrator) Microsoft 2008 Education: Masters in Computer Sciences

Skills

System Admin8 Microsoft SQL8 MySQL8 Database administration8 Computer Network Technician8 Information system analyst8 SAP8 Data Science8 IT Consultant8 Agile / Scrum Master8