SQL
Andre Cedras
Manager: Financial Data Science
Johannesburg
Summary
Data Scientist familiar with gathering, cleaning and organizing data for use by technical and non-technical personnel. Advanced understanding of statistical, algebraic and other analytical techniques. Highly organized, motivated and diligent with significant background in process automation.
Overview
14
14
years of professional experience
6
6
years of post-secondary education
2
2
Languages
Work History
Data Science Lead
African Bank
Johannesburg
01.2020 - Current
- Worked with stakeholders to develop automated business performance monitoring reports in PowerBI to track key business KPI's.
- Built automated processes for the creation of Financial Statements like the Income statement and Balance Sheet of the African Bank group of companies.
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
- Applied statistical and algebraic techniques to interpret key points from gathered data and create automated email alerts for any deviations that are statistically significant.
- Assisting with the migration of databases and models to AWS cloud.
- Identified, measured and recommended improvement strategies for KPIs across business areas.
- Developed polished visualizations to share results of data analyses.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Compiled, cleaned and manipulated data for proper handling.
Data Scientist
African Bank
Johannesburg
01.2019 - 12.2019
- Successfully built a credit decision engine to replicate the bank's own system by only using credit policy documents in MATLAB.
- Using the credit decision engine rapid prototyping of new credit policies was made possible and its impact on lending performance could be assessed.
Data Science Intern
BCX
Cape Town
01.2018 - 12.2018
- Translated cost and benefits of machine learning technology for non-technical audiences.
- Created data visualization graphics, translating complex data sets into comprehensive visual representations.
- Participated in workshops to advance skills.
- Performed advanced data extraction and data manipulation.
- Developed and established strong business relationships with both internal personnel and external solution providers.
- Identified, analyzed and interpreted trends in complex data sets using supervised and unsupervised learning techniques.
- Used SAS and Python to manage and analyze large data sets.
- Pinpointed meaningful insights from large data and metadata sources.
- Helped develop database solutions using multiple SQL languages.
- Developed and coded software programs, algorithms and automated processes to cleanse and evaluate large datasets from multiple disparate sources.
Regional Sales Engineer
Spirax Sarco
Cape Town
08.2012 - 03.2014
- Prepared cost estimates and bid documents by studying customer RFPs and consulting with project managers.
- Managed technical integration, systems engineering program management, customer support and program management.
- Designed and delivered product training for clients.
- Developed and implemented pursuit plans for opportunities within assigned key accounts.
Maintenance Manager
RCL Foods
Cape Town
04.2011 - 07.2012
- Procured pricing information from various vendors to support cost-effective purchasing.
- Supervised employee performance, preventive maintenance, and safety.
- Delegated tasks to carefully selected employees in alignment with resource management goals.
- Completed partial or full dismantling of equipment to quickly repair or replace defective components and restore functionality.
- Achieved no loss-time injuries, all projects executed within budget and planned duration.
- Developed and implemented maintenance procedures for all equipment in the areas of responsibility entrusted to me.
Junior Process Engineer
BASF
Port Elizabeth
01.2009 - 03.2011
- Provided technical assistance to production team when issues arose during the production of catalytic converters.
- Conducted root cause analysis to identify, prioritize and eliminate process losses.
- Participated in project reviews to enable ongoing status tracking and reporting.
- Evaluated proposed project economics and identified alternative solutions and designs producing improved results.
- Developed documentation, diagrams, and specifications to meet project requirements and regulatory standards.
- Resolved technical and quality issues by collaborating with customer, manufacturing, quality assurance, vendors and supplier personnel.
- Swapped out materials and finishes in product line to alleviate performance issues and reduce waste generation.
- Coached newly hired employees and interns while observing progress and delegating tasks.
- Created process simulations to test operational outcomes without causing service disruptions.
Education
Bachelor of Engineering - Chemical Engineering
University of Stellenbosch
Stellenbosch, South Africa 01.2003 - 03.2008
Certificate of Completion - Data Science
Explore Data Science Academy
Cape Town 01.2018 - 12.2018
Skills
Teamwork and Collaboration
Statistical analysis
Intelligence gathering
Machine learning
Data Mining
Agile framework understanding
Excellent Communication
Dependable and Responsible
Accomplishments
- Achieved excellent stakeholder engagement and business impact by completing automation of business performance monitoring with accuracy and efficiency.
- Documented and resolved modelling and audit findings in Fair value measurement of business assets which led to a approval of new fair value models and clean audit findings.
- Collaborated with team of 10 in the development of management accounts automation project.
Software
PowerBI
MATLAB
Python
SAS
AWS
MS Office
Timeline
Data Science Lead
African Bank
01.2020 - Current
Data Scientist
African Bank
01.2019 - 12.2019
Data Science Intern
BCX
01.2018 - 12.2018
Certificate of Completion - Data Science
Explore Data Science Academy
01.2018 - 12.2018
Regional Sales Engineer
Spirax Sarco
08.2012 - 03.2014
Maintenance Manager
RCL Foods
04.2011 - 07.2012
Junior Process Engineer
BASF
01.2009 - 03.2011
Bachelor of Engineering - Chemical Engineering
University of Stellenbosch
01.2003 - 03.2008