Craig Reginald Langley
B I Analyst
Cape town
Summary
Experienced with data analysis and intelligence gathering, delivering comprehensive insights for operational strategies. Utilizes advanced analytical techniques to identify and assess relevant information. Track record of enhancing operational efficiency through effective communication and problem-solving.
Professional in intelligence and data analysis, prepared for high-stakes environments. Adept at synthesizing complex information and providing clear, actionable recommendations. Collaborative team player focused on achieving results and adapting to evolving challenges. Skilled in data interpretation and strategic planning.
Overview
21
21
years of professional experience
2003
2003
years of post-secondary education
1
1
Certification
1
1
Language
Work History
Business Intelligence Assistant
Rialto A Division Of Libstar Operations PTY LTD
02.2019 - Current
- Assisted in extracting, analyzing, and interpreting data from ERP system Called Syspro, version &, very familiar in AP, AR, and inventory modules to generate actionable insights for decision-making
- Collaborated with the accounting team to reconcile financial data, ensuring accuracy in reporting
- Applied strong accounting knowledge to understand and interpret financial data, aiding in the identification of trends and anomalies
- Collaborated with Department Heads to refine reporting formats and optimize data presentation for better clarity
- Conducted data validation and performed quality checks to ensure data accuracy and consistency, upholding high standards for reporting precision
- Assisted in data cleansing efforts (Masterdata Reviews), contributing to improved data integrity across systems
- Addressed discrepancies in financial data, ensuring accurate reporting and compliance with auditing standards
- Collaborated effectively with colleagues from different departments to gather requirements and understand business needs for BI projects
- Communicated findings and insights in a clear and concise manner to both technical and non-technical internal clients
- Proactively identified areas for process improvement within the BI workflow, leading to enhanced data accuracy and efficiency
- Developed queries to extract key financial metrics and performance indicators for various departments in conjunction with Qlikview system
- Investigated data-related issues and anomalies, applying critical thinking skills to diagnose problems and propose effective solutions
- Addressed discrepancies in financial data, ensuring accurate reporting and compliance with auditing standards
- Independently sourced data from databases and transformed it into refreshable data tables, optimizing data accessibility and analysis efficiency
- Utilized Excel skills in creating dynamic Standard to very Complex pivot tables, advanced formulas, and data visualization tools
- Proficient in utilizing advanced Excel functions, including SUMIFS and VLOOKUPS, to perform comprehensive financial analysis
- Skilled in leveraging SUMIFS, VLOOKUP and XLOOKUP formulas to aggregate and analyze complex financial data based on multiple criteria
- Capable of extracting valuable insights from datasets, enhancing decision-making processes for informed business strategies
- Efficiently managed and resolved support tickets within the Zoho ticketing system, consistently demonstrating a high level of speed and accuracy in addressing customer inquiries and technical issues
- Streamlined support processes and minimized resolution times, contributing to enhanced internal customer satisfaction
- Exhibited exceptional teaching aptitude by effectively training teams in the proficient utilization of SharePoint and OneDrive platforms
- Communicated complex technical concepts in an understandable manner, empowering colleagues to navigate, collaborate, and maximize efficiency within these tools
- Champion in Quantum Architecture for seamless and efficient data uploads in the Syspro environment
- Leveraged advanced data processing techniques to optimize data migration and integration, enhancing data accuracy and operational efficiency within the organization
- Recognized for adept troubleshooting abilities, proficiently resolving issues related to SSRS reporting, SQL Profiler analysis, and password resets
- Consistently provided timely and effective solutions, ensuring uninterrupted system functionality and user access
- Developed and executed organization-wide alerts to prompt timely logouts from Syspro during critical balance functions
- Implemented effective communication mechanisms to enhance operational integrity and prevent potential data inconsistencies
- Facilitated successful skills transfer initiatives to empower team members with essential knowledge and competencies
- Collaborated closely with colleagues to deliver comprehensive training, enabling seamless knowledge sharing and fostering a culture of continuous learning
- QlikView Toggling and Navigation: Skilled in designing interactive QlikView dashboards with seamless toggling and intuitive navigation
- Created user-friendly interfaces to enable dynamic exploration and analysis of complex datasets
- Adept with Power BI functionality, Dashboard toggling and Data Selection for Forecasting, Very proficient in identifying and curating relevant datasets for accurate forecasting
- Utilized advanced analytical techniques to ensure data integrity and support informed predictive modeling
- Rebate and Customer Allowance Calculation: Well-versed in the methodologies and processes involved in calculating rebate and customer allowance rates
- Applied financial acumen to ensure accurate determination of incentives, supporting effective customer relationship management
Fund Product Accountant
Maitland Fund Services
03.2016 - 10.2016
Offshore Reconciliations/Corporate Actions Administrator
Sanlam Private Wealth
11.2014 - 02.2016
Trustee - Cash & Asset Reconciliations Specialist Unit Trust Funds
Standard Bank Corporate & Investment Banking
12.2008 - 10.2014
Business Banking Analyst
Absa Bank Claremont Suite
01.2008 - 11.2008
Product Leader - Securities
Absa Bank Business Banking Services (Small Business)
07.2007 - 12.2007
Entry Level Product Analyst /Subject Matter Clerk
Absa bank SBU Champs (strategic business unit champion)
12.2006 - 06.2007
Officer: Securities Product Capturing
Absa bank Student Bureau
12.2005 - 12.2006
Department 2IC (acting Team Leader) Workflow Official
Absa Bank (CT foreshore)
11.2004 - 11.2005
Filing Clerk
First National Bank
04.2004 - 10.2004
Education
Matric Grade 12 - English, Afrikaans, Geography, Biology, Mathematics, History and Biblical studies
Steenberg High school
Skills
Power BI
Skills Abilities Competencies
- Highly advanced in MS Excel, adept in Power BI.
- Sound Knowledge of SYSPRO
- Extremely Computer literate in MS Word, Explorer, outlook, power BI, Ability to record Macros and basic coding verbally fluent, reading and writing
- Trained on telephonic etiquette, ability to tolerate irate clients
- Customer service driven
- Excellent communication skills
- Extrovert & Self-initiative
- Ability to Liaise and question from base principles
- Analytical and excellent at problem solving and obtaining solutions
- High concentration level and Excellent at working under pressure and multitasking
- Team player and ability to lead (prior experienced team leader)
- Attention to detail is a personal self paramount
- Highly focused
Systems Worked On
- Intellimatch (SunGard)
- Accurate
- Oracle
- InvestOne
- Hiportfolio old versions and V3/5 Thomson Reuters (Datascope)
- CMS
- Finswitch
- Flexcube
- EMX
- AIM
- Infoslips
- Business integrator
- Business online (old&new)
- Workbench
- Bank of New York mellon
- Portia
- Bloomberg
- SAP
- Citrix
- ZohoONE
- SYSPRO
Courses Completed
- Power BI
- Udemy – Advanced Excel
- Udemy SQL
- Udemy Power BI
- Money Laundering Awareness
- Personal Mastery in the economic workplace
- Occupational health and safety
- The code of banking practice
- FICA and FIAS Compliance
Extra Achievements
- Occupational Health and safety representative
- Absa BEE council member
- Outstanding performance award
- Acting team leader Absa asset processing
Own Transport
Yes
Personal Information
- ID Number: 841129 5140 082
- Dependents: 2
- Health Status: Excellent
- Date of Birth: 11/29/84
- Gender: Male
- Nationality: South African
- Driving License: Yes (code B)
- Marital Status: Single
Certification
POWER BI
Timeline
Business Intelligence Assistant
Rialto A Division Of Libstar Operations PTY LTD
02.2019 - Current
Fund Product Accountant
Maitland Fund Services
03.2016 - 10.2016
Offshore Reconciliations/Corporate Actions Administrator
Sanlam Private Wealth
11.2014 - 02.2016
Trustee - Cash & Asset Reconciliations Specialist Unit Trust Funds
Standard Bank Corporate & Investment Banking
12.2008 - 10.2014
Business Banking Analyst
Absa Bank Claremont Suite
01.2008 - 11.2008
Product Leader - Securities
Absa Bank Business Banking Services (Small Business)
07.2007 - 12.2007
Entry Level Product Analyst /Subject Matter Clerk
Absa bank SBU Champs (strategic business unit champion)
12.2006 - 06.2007
Officer: Securities Product Capturing
Absa bank Student Bureau
12.2005 - 12.2006
Department 2IC (acting Team Leader) Workflow Official
Absa Bank (CT foreshore)
11.2004 - 11.2005
Filing Clerk
First National Bank
04.2004 - 10.2004
POWER BI
Matric Grade 12 - English, Afrikaans, Geography, Biology, Mathematics, History and Biblical studies
Steenberg High school
Similar Profiles
Patience Phumzile MkhabelaPatience Phumzile Mkhabela
Creditors Clerk at Ambassador Foods, A Division Of LibstarCreditors Clerk at Ambassador Foods, A Division Of Libstar
JOHN A. MORALESJOHN A. MORALES
Assistant Legal Attaché (Supervisory Special Agent) at Federal Bureau of Investigation, International Operations DivisionAssistant Legal Attaché (Supervisory Special Agent) at Federal Bureau of Investigation, International Operations Division
Randy BullardRandy Bullard
Parole Agent 1 at CDCR Division Of Adult Parole OperationsParole Agent 1 at CDCR Division Of Adult Parole Operations