SOLOMON SSERWANGA

437-***-**** ad396c@r.postjobfree.com Toronto, Canada Website

PROFESSIONAL SUMMARY

Solutions-driven analyst with over 9 years’ experience in analysis, presentation and collection of technical, statistical and financial data that helps in the attainment of business goals. AREAS OF PROVEN PERFORMANCE

• SQL databases and querying languages

• Financial and Data Modelling

• Dashboards and Reporting

• Strong attention to detail

• Project/initiative coordination

• KPI Monitoring

• Strong communication skills

• Creative problem-solving skills

• Strategy and business planning

TECHNOLOGY SKILLS:

Databases: MySQL, PostgreSQL, MS SQL, Mondo DB, Azure Data Bricks, AWS, GCP, Big Query Presentation: Power BI, Tableau, PowerPoint

Data Cleaning and Modelling: Python, R Studio, Excel, SAS, Snowflake AI and ML: PyTorch, TensorFlow

EXPERIENCE & ACCOMPLISHMENTS

PRGX CANADA GROUP (US Data Analytics Company) Mississauga, Ontario Audit - Data Analyst May 2023 – Feb 2024

• Audited financial supplier contracts with retailer that generated over two million dollars in savings.

• Identifies variances and/or errors in the procurement and payment processes to recover revenue.

• Review contracts, agreements, paperwork and electronic documents looking for possible missed opportunities in vendor funding.

• Spearheaded sales analytic projects focused on maximizing point-of-sale revenue, points of distribution and product visibility.

• Received, cleaned and prepped data from client using Python, SQL and Excel to help data scientists build marketing mix models

WORKPLACE SAFETY AND INSURANCE BOARD (Canada’s Biggest Compensation Board) Toronto, Canada Data Analyst June 2019 – Apr 2023

• Developed new data warehouse using SQL server that helped Ontario North West team to improve claim processing time from 12 days to 7 days.

• Monitored nation-wide/territory sales reporting with established quarterly targets of over 50 million dollars set against KPIs.

• Co-developed data analysis frameworks that support frequent operational reporting and executive dashboards.

• Collaborated with Business Intelligence to facilitate reporting needs of Sales Teams and automation within the Tableau environment.

• Provided commentary with insights on key trends pointing out outliers e.g., performance of categories/SKUs

• Worked with data engineers and senior management to develop customized sales reporting tools. For example, utilized Python to merge reports and generate a final report showing all required sales information and important ratios. FEDEX TRADE NETWORKS (Fortune 500 Transportation Company) Mississauga, Ontario Data Associate Nov 2018-June 2019

• Responsible for transcribing all relevant information from cargo control documents into the AS400 mainframe to produce required import files.

• Screened cargo control documents for shippers with an assigned customs broker.

• Outbound calls to clients to acquire brokerage information and billing requests in a courteous and professional for further information when required.

• Resolved discrepancies on documentation for time sensitive shipments to avoid clearance delays. NATIONAL SOCIAL SECURITY FUND (East Africa’s Biggest Pension Fund) Kampala, Uganda Performance Analyst Sept 2012 - Oct 2018

• Provided senior management with data envelopment analysis that measures efficiency of staff and branches which led to 7% increased efficiency from restructuring and company reorganization.

• Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins in the fiscal year.

• Used advanced excel forecasting models to produce performance prediction models for the organization and departments.

• Worked with investment and risk department to create new risk matrix for financial products.

• Conducted internal and external company research that identifies trends and correlation that enables the organization to better adopt and improve operations and services. This research led to improvement in turnaround time for benefits payment form 62 days to 7 days.

• Ran python data cleaning models to help improve the operations data quality index from 45% to 89% in two years. EDUCATION/ CERTIFICATIONS

York University

Certificate in Big Data Analytics Jan 2023 to Dec 2023 CFA Institute USA

Chartered Financial Analyst Level II June 2016 to June 2018 Association of Chartered Certified Accountants UK

Advanced Diploma in Accounting and Business Dec 2013 - Dec 2016 Makerere University Kampala

Bachelor of Science in Statistics and Mathematics August 2008 - January 2012

Contact this candidate