SENIOR DATA ANALYST
Zortech Solutions
11.2020 - Current
Chigozie Mercy Ajonu
Saskatoon,SK
Timeline
FINANCIAL DATA ANALYST
Quarry Consulting
09.2018 - 10.2020
Human Resources/Payroll Coordinator
Fair Haven Recruitment
09.2014 - 01.2016
Payroll Compliance Professional
National Payroll Institute
Bachelor of Science - Accounting
University of Port Harcourt
Summary
Detail-focused data analyst with knowledge in data warehousing, process validation and business needs analysis with over 5 years' experience. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Proficient in database management systems like SQL. Skilled in data visualization and reporting tools such as POWER BI.
Excellent communication and leadership skills, with a track record of successful projects.
Skills
- SQL and Database Management
- Microsoft Power BI
- Statistical modeling
- Advanced Excel
- Accounting Principles
- Financial Data Analysis
- Customer Communication
- Data Cleaning and Preparation
- Team Collaboration
Work History
SENIOR DATA ANALYST
Zortech Solutions
11.2020 - Current
- Developed SQL queries and scripts to extract, transform and load (ETL) data from various sources into a centralized data warehouse.
- Utilized advanced query optimization techniques to enhance database performance by 15% and reduce latency issues during high-traffic periods.
- Conducted statistical analysis on large data sets to identify customer behavior patterns and improve targeting for marketing campaigns, resulting in 20% increase in conversion rates
- Create interactive dashboards using Power BI, resulting in improvement in data accessibility and decision making speed for stakeholders
- Provided technical support for troubleshooting analytics and reporting issues.
- Developed and maintained data warehouses and data marts to support business operations
- Coached less experienced analysts, and mentored 2 interns annually in sophisticated modelling
- Developed data mining algorithms to identify and classify patterns in data.
- Identified patterns and trends in large data sets and provided actionable insights.
- Optimized data access and storage to improve performance of analytics systems.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Demonstrated strong organizational and time management skills while managing multiple projects.
- Establishing culture of continuous improvement by fostering open communication channels and encouraging feedback on data analysis methodologies.
- Utilized data visualization techniques to present and explain complex data sets.
FINANCIAL DATA ANALYST
Quarry Consulting
09.2018 - 10.2020
- Improved financial reporting accuracy by 20% through advanced data analysis techniques and tools.
- Developed financial projections and forecasts to guide investment decisions resulting in 25% increase in revenues
- Monitored market trends and news to identify emerging opportunities.
- Participated in client meetings to discuss financial analysis and investment strategies.
- Championed use of innovative data analysis tools and methodologies to stay ahead of industry trends and maintain competitive edge market.
- Created visually appealing and informative reports and dashboards using tools like Power BI, reducing report creation time by 40%
- Paid attention to detail while completing assignments.
- Gained extensive knowledge in data entry, analysis and reporting.
- Demonstrated strong organizational and time management skills while managing multiple projects.
Human Resources/Payroll Coordinator
Fair Haven Recruitment
09.2014 - 01.2016
- Hired, managed, developed and trained staff, established and monitored goals, conducted performance reviews and administered salaries for staff.
- Improved customer satisfaction scores through application of superior conflict resolution and problem-solving skills.
- Documented and processed all garnishments for bankruptcies, student loans, and child support orders.
- Confirmed compliance with all applicable federal, state and local payroll laws and regulations.
- Performed calculations in overtime, vacation, and sick hours to provide accurate data to payroll processing database.
- Completed bi-weekly payroll for 5000 employees.
- Created new hire and termination documents for payroll.
Education
Payroll Compliance Professional
National Payroll Institute
ONTARIO09.2022
Bachelor of Science - Accounting
University of Port Harcourt
NIGERIA01.2012
Personal Information
Title: PAYROLL administrator/Customer service administrator
Overview
10
10
years of professional experience
Similar Profiles
Ridaa WilsonRidaa Wilson
Payroll Bookkeeper/ Onboarding Specialist at ZORTECH SOLUTIONS INC.Payroll Bookkeeper/ Onboarding Specialist at ZORTECH SOLUTIONS INC.
BIJON DASBIJON DAS
Director of Delivery & Operations at Zortech Solutions IncDirector of Delivery & Operations at Zortech Solutions Inc
Monaliza GatchalianMonaliza Gatchalian
Senior Programmer Analyst at Telus International at Zortech Solutions Inc.Senior Programmer Analyst at Telus International at Zortech Solutions Inc.
Mackenzie RudolphMackenzie Rudolph
Continuing Care Assistant at Saskatchewan Health AuthorityContinuing Care Assistant at Saskatchewan Health Authority
Ali QasmiAli Qasmi
Brand Ambassador at CaptiveBrand Ambassador at Captive