Java Script
LIONEL MUTESWA
Project Manager
Johannesburg
Summary
Lionel is currently enrolled in a Master's program in Artificial Intelligence Engineering at IBM. Academic qualifications include a Postgraduate Diploma in Business Intelligence and a Bachelor of Commerce degree. Lionel has over 15 years of experience in the IT industry, primarily in the financial services sector.
For the past 8 years, worked in the data and analytics field, serving as a Senior Business Intelligence Developer for over 5 years. In this role, Lionel was responsible for delivering large-scale data integration projects. Highly skilled in a wide range of tools and technologies, including ETL, spatial analysis, data analytics, IoT/sensors, big data, dash-boarding, data integration, T-SQL, SQL Server automation, SSIS, SSRS, SSAS, QlikView, Power BI, SAS, Tableau, Python, NumPy, Pandas, SciPy, Keras, and advanced Excel.
Currently, Lionel is the Project Manager for the ABSA Corporate Investment Bank Digital Platform. In this capacity, Lionel oversees data analysis, data warehousing, reporting, statistical modelling, and data mining within the Data Platforms Department for ABSA Trade and Working Capital. Lionel is also a MANCO member at ABSA. Additionally, Lionel has experience as a Data Modeller, utillizing tools like ER Studio and Power Design, as well as in machine learning using Python and R.
Lionel is a highly resourceful and adaptable individual who excels at planning, directing, and maintaining continuous operations across various departments. Lionel has a proven track record of delivering through a wide range of technologies and is skilled at identifying and solving problems, mentoring and empowering teams, and ensuring smooth project operations. Lionel will be valuable asset to any organization due expertise in software development, data management, accounting, budgeting, and financial management.
Overview
13
13
years of professional experience
5
5
years of post-secondary education
Work History
Project Manager
ABSA CIB
Johannesburg
8 2021 - Current
- Collaborates with stakeholders to document project scope, deliverables, goals, risks, blockers, success measures, and estimated resources needed
- Ensures that projects remain in-scope and meet budgetary, scheduling, and quality requirements
- Creates, manages, and distributes project communications artifacts like charters, schedules, and budgets
- Provides project status updates at predetermined time intervals to all stakeholders
- Communicates routinely to management, customers, project team members, and other stakeholders, actively soliciting and addressing customer and project team feedback
- Assists in business development efforts to create project proposals, RFPs, estimates, and schedules
- Sets and monitors project budgets and staffing requirements
- Ensures adherence to legally binding requirements
- Plan, schedule, monitor, and report on activities related to projects, including subcontractor monitoring
- Establishes key project criteria metrics
- Develop project control and reporting procedures and manage changes in operational plan
- Plans and leads status review meetings, which may include internal team members, vendors, and customers
- Responsible for training, managing, and motivating project team, as well as resolving team conflicts
- Resolves technical and operational issues as required.
- Planned, designed, and scheduled phases for large projects.
- Identified plans and resources required to meet project goals and objectives.
- Monitored project performance to identify areas of improvement and make adjustments.
- Met project deadlines without sacrificing build quality or workplace safety.
- Builds Effective Teams - forms, develops and leads individuals toward the
achievement of common team objective - Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organisational goals
- Planned, designed, and scheduled phases for large projects
- Identified plans and resources required to meet project goals and objectives
- Monitored project performance to identify areas of improvement and make adjustments
- Monitored progress against established goals, adjusting schedules and resources when needed to keep projects on track
- Meet project deadlines without sacrificing build quality or workplace safety
- Establish effective communication among team members for enhanced collaboration and successful project completion
- Coordinate with cross-functional teams to resolve project issues and mitigate risks
- Manage risk assessments and implemented mitigation strategies to minimize potential issues during project execution
- Develop comprehensive project plans with clear timelines, milestones, and budget requirements, ensuring timely delivery of high-quality results
- Achieve project deadlines by coordinating with contractors to manage performance
- Coordinate with cross-functional teams and resolved conflicts, ensuring positive work environment throughout project lifecycle
- Established effective communication among team members for enhanced collaboration and successful project completion
- Meet project deadlines without sacrificing build quality or workplace safety
- Coordinate with cross-functional teams to resolve project issues and mitigate risks
- Managed risk assessments and implement mitigation strategies to minimize potential issues during project execution
- Developed comprehensive project plans with clear timelines, milestones, and budget requirements, ensuring timely delivery of high-quality results
- Achieved project deadlines by coordinating with contractors to manage performance
- Coordinate cross-functional teams and resolved conflicts, ensuring positive work environment throughout the project lifecycle
- Develop and initiate projects, manage costs, and monitor performance
- Prepare detailed reports on project status for stakeholders, ensuring transparency and alignment with objectives
- Provided detailed project status updates to stakeholders and executive management
- Develop strong relationships with stakeholders through regular communication updates, fostering trust and confidence in the team's ability to deliver results
- Collaborate closely with senior management to align project objectives with strategic company initiatives, ensuring that efforts contributed to overall business growth
- Developed and implemented strategic project plans to meet business objectives
- Provided detailed technical and operational direction in project challenges, consistently meeting deliverables according to deadlines
- Prepare and submit project invoices for review and approval
- Enhance overall project success by conducting thorough post-project evaluations and incorporating lessons learned into future efforts
- Effectively manage scope creep by establishing clear boundaries on requested changes while keeping projects aligned with original objectives and budgets
- Mentor junior team members in project management best practices to enhance their skills and contribute to better overall performance
- Negotiated and managed third-party contracts related to project deliverables
- Foster a culture of innovation and creativity within the project team, leading to improved problem-solving capabilities and enhanced outcomes
- Draft project reports to identify successful outcomes, insights and future recommendations
- Negotiate contracts with vendors and suppliers, securing quality materials at competitive prices for efficient use of resources
- Streamline project processes by implementing Agile methodologies, resulting in increased efficiency and reduced costs
- Coordinate material procurement and required services for projects within budget requirements
- Deliver exceptional customer satisfaction by proactively addressing client concerns and meeting or exceeding expectations throughout the engagement process
- Implement continuous improvement initiatives to optimize project outcomes while maintaining cost effectiveness
- Managed projects from procurement to commission
- Facilitate change management processes within organizations by effectively communicating benefits of new systems or processes being introduced during projects
- Facilitate change management processes within organizations by effectively communicating benefits of new systems or processes being introduced during projects
- Ensure regulatory compliance by closely monitoring applicable laws and regulations within the industry sector throughout each stage of the project life cycle
- Create accurate budgets based on resource requirements, allowing for optimal allocation of funds across all aspects of the projects
- Monitor project progress, identify risks and corrective actions as needed
- Track projects and team member performance closely to quickly intervene in mistakes or delays
- Develop and implement project plans and budgets to ensure successful execution
- Analyze project performance data to identify areas of improvement
- Report regularly to Stakeholders on project budget, progress, and technical problems
- Schedule and facilitate meetings between project stakeholders to discuss deliverables, schedules and conflicts
- Maintain open communication by presenting regular updates on project status to stakeholders
- Verify quality of deliverables and conformance to specifications before submitting to clients
- Recruit and oversaw personnel to achieve performance and quality targets
- Source, vet and managed vendors needed to accomplish project goals
- Facilitate workshops to collect project requirements and user feedback
- Managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals
- Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
Senior Data Analyst
ABSA - CIB
Johannesburg
2 2021 - 7 2021
- Gather data from primary and secondary sources, ensuring upkeep of databases and data systems
- Detect, examine, and decode trends or patterns within intricate datasets
- Cleanse data and scrutinize computer-generated reports and outputs to identify and rectify coding errors
- Coordinate with management to align business and informational priorities
- Identify opportunities for process enhancements
- Employ statistical techniques to scrutinize data and produce actionable business insights
- Collaborate with management team to determine rank and requirements for different business units
- Develop data dashboards, charts, and visual aids to support decision-making across departments
- Convey insights through both reports and visual presentations
- Partner with engineering and product development teams to understand business requirements
- Engage with managers from various departments to specify data requirements for analysis projects tailored to their unique business processes.
- Reduce manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
- Optimized database performance, implementing indexing strategies and partitioning techniques to reduce query times.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Streamline data analysis workflows for increased efficiency and faster decision-making processes.
- Assess large datasets, drew valid inferences and prepared insights in narrative or visual forms.
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes
- Optimized database performance, implementing indexing strategies and partitioning techniques to reduce query times
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data
- Streamlined data analysis workflows for increased efficiency and faster decision-making processes
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms
- Improve data accuracy by implementing stringent data validation processes and quality control measures
- Use business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses
- Subject matter expert on various projects, sharing valuable insights derived from extensive industry experience
- Develop and implemented data collection systems and other strategies to optimize statistical efficiency and data quality
- Implementation of dashboard visualization tools, providing actionable insights for stakeholders and decision makers
- Reduce manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
Senior Data Insights and Business Intelligence Manager
Standard Bank Group
Johannesburg
2020.08 - 2021.01
- Manage analysts or developers who facilitate business intelligence processes and procedures development and implementation
- Responsible for leading strategic design and maintenance of business intelligence applications
- Identify, investigate, and resolve complex technical problems
- Ensures business intelligence applications enhances business decision making capabilities
- Ensures that project/department milestones/goals are met adhering to approved budgets
- Support banks objectives to improve their overall business
- Identify and take advantage of key business trends at macro and micro levels
- Use predictive analytics and financial modelling efforts to forecast impact of actions
- Use metrics with external insights like syndicated data and client information to meet objectives
- Responsible for BI team to deliver reporting and dashboard solutions
- Ability to provide estimates to support timelines and deliverables
- Design and build lists, cross tabs, graphs, scorecards, metrics, filters, prompts, standard reports and dashboards
- Follow and enhance BI standards and best practices across
- Collaborate and mentor team members on methodology, design and architecture
- Ensure optimal end user performance by establishing and consistently executing overall system performance assessment processes and associated action plans
- Operates with degree of creativity and latitude
- Ability to work on multiple projects at once
- Provide consultation on complex projects
- Established best practices for data governance policies, ensuring compliance with industry regulations and standards while maintaining data integrity across all systems.
- Championed data-driven culture within, promote analytics in strategic planning initiatives.
- Conducted comprehensive market research, enabling informed decision-making on new product launches and expansions.
- Managed vendor relationships to ensure timely delivery of services while adhering to budget constraints.
- Evaluated third-party BI tools, making recommendations for cost-effective solutions that aligned with company objectives.
- Identified trends and patterns within data sets, providing valuable insights for strategic planning and decision-making processes.
- Spearheaded process improvement initiatives by analyzing current workflows and identifying areas for optimization using BI insights.
- Performed ad-hoc analyses upon request from senior management or other departments requiring specialized support or insight into specific issues or challenges faced.
- Collaborated effectively with IT teams to maintain optimal system performance through regular maintenance activities, updates, and upgrades as needed.
- Streamlined reporting processes for increased efficiency and accuracy in data analysis.
- Developed custom dashboards and visualizations to provide actionable insights for key stakeholders.
- Implemented automation processes for routine data collection tasks, reducing manual effort and increasing efficiency.
- Managed BA analysts team, fostering professional development and continuous learning opportunities.
- Collaborated with cross-functional teams to identify key performance indicators and develop relevant metrics.
- Optimized data warehousing architecture, ensuring seamless integration of multiple data sources.
- Develop data visualization tools to effectively communicate complex information and drive meaningful business outcomes.
- Led successful migration projects from legacy systems to modern BI platforms, minimizing downtime during transition periods.
- Enhanced overall business strategy by implementation of predictive analytics techniques for better forecasting.
- Improved data-driven decision making by implementing advanced business intelligence tools and strategies.
- Provided training to end users, ensuring proper understanding and utilization of business intelligence reports and tools.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Collaborated with stakeholders to identify business needs and data sources.
- Created data models to support decision-making processes.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Developed data mining algorithms to identify and classify patterns in data.
- Developed and implemented data governance policies and procedures.
- Designed and developed data pipelines to acquire, clean and process data.
- Deployed predictive analytics models to forecast future trends.
- Optimized data access and storage to improve performance of analytics systems.
- Developed and maintained data warehouses and data marts to support business operations.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Implemented business intelligence solutions to increase operational efficiency.
- Generated standard and custom reports to provide insights into business performance.
- Provided technical support for troubleshooting analytics and reporting issues.
- Generated ad-hoc reports to evaluate specific business requirements.
- Identified patterns and trends in large data sets and provided actionable insights.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Utilized data visualization techniques to present and explain complex data sets.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Created dashboards to monitor and track key performance indicators.
Product Owner, Lead BA
Sebata Municipality Solutions
Johannesburg
2019.04 - 2019.10
- To perform impact analysis on strategic projects and write functional specs
- Developed Business Intelligence solutions using MS SQL Server 2005 tools, including Reporting Services, Analysis Services, and Integration Services
- Wrote stored procedures for reporting and ETL
- Identified areas for improvement and recommended corrective actions
- Monitored team's ticket queue for compliance and appropriate prioritization
- Reviewed in-progress and completed work for completeness, quality, and adherence to standards
- Perform process improvements on AS-IS processes
- Focus on requirement management for integration projects with 3rd party businesses
- Deliver change across all impacted systems
- Managed backlog prioritization, ensuring alignment with business goals and stakeholder expectations.
- Implemented Agile methodologies to increase team productivity and enhance overall project outcomes.
- Collaborated with cross-functional teams to develop high-quality products that met customer needs.
- Developed comprehensive roadmaps outlining product vision, goals, and milestones for successful execution.
- Collaborated with engineering teams on technical feasibility assessments, resulting in realistic scope definition for projects.
- Owned and prioritized product backlog.
- Enhanced product usability by conducting user research and incorporating feedback into development.
- Facilitated communication between development teams and stakeholders, ensuring clear understanding of requirements and expectations.
- Focused on building critical features up front in order to identify constraints and technical challenges.
- Managed implementation of new features by outlining plans and specifications such as how, where, and when each component would work.
- Cultivated strong relationships with key stakeholders by maintaining open lines of communication and addressing concerns promptly.
- Led product launches, collaborating with marketing teams to create successful go-to-market strategies.
- Optimized product performance by identifying areas for improvement and implementing necessary changes.
- Proactively identified risks associated with project timelines or deliverables, implementing mitigation strategies when necessary.
- Mentored junior team members in Agile methodologies and best practices for effective Product Owner role execution.
- Analyzed customer feedback to identify areas for improvement.
- Fostered culture of continuous improvement through regular retrospective meetings with team.
- Ensured regulatory compliance by working closely with legal teams during development process.
- Conducted data-driven analysis to measure product success metrics, informing future enhancements or adjustments.
- Oversaw entire product deployments from vision and creation to rollout and delivery.
- Coordinated with software developers to create custom applications and trackers to achieve client goals.
- Championed user-centric design principles throughout development process to ensure exceptional user experiences.
- Streamlined project management processes for improved efficiency and timely product delivery.
- Allocated and approved team resource usage.
- Collaborated with development team on services and tasks.
- Actively participated in industry events to stay informed about emerging trends relevant to products'' success.
- Reduced time-to-market by effectively coordinating resources, tasks, and timelines.
- Evaluated competitive landscape to inform strategic decisions on product positioning and pricing.
- Coordinated with design and media teams to develop high-quality creative assets.
- Established, initiated and optimized business development strategies based on company targets, product specifications, market data, and budget factors.
- Led team of marketing professionals, offering mentoring and coaching to build knowledge and skills.
- Secured long-term accounts by recommending strategies to promote brand effectiveness and highlight product benefits.
- Developed creative presentations, trend reports, kitted assets, and product data sheets.
- Devised content strategy to effectively engage target audiences.
- Mentored local personnel on best practices and protocols to maximize productivity.
- Wrote and distributed press releases to increase brand visibility.
- Analyzed and reported on KPIs to validate and demonstrate success of marketing campaigns.
- Conducted market research to identify new opportunities and target markets.
- Captured new customers by optimizing business strategies and launching products to diversify offerings.
- Generated sponsorships with related and partnering entities to enhance marketing objectives.
- Improved website visibility through development and implementation of SEO strategies.
- Continually maintained and improved company's reputation and positive image in markets served.
- Optimized email campaigns to increase open and click-through rates.
- Oversaw preparation of marketing copy, images, videos, emails, and other collateral.
- Launched successful digital marketing campaigns that achieved goals for increased website traffic.
- Managed budget allocation and resource utilization to maximize marketing ROI.
- Executed comprehensive marketing plans that consistently achieved targets for increased revenue.
- Created and managed social media campaigns to increase brand engagement.
Enterprise Management Expert/Senior Business Intelligence Analyst
Times 3 Technology
Johannesburg
2017.03 - 2018.03
- QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting seasonal trends on client products
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Creating databases and schema objects including tables, indexes, and applied constraints
- Connecting various applications to database and writing functions, stored procedures and triggers
- Extensively using SSIS transformations such as lookup, derived column, Data conversion, working on all activities related to development, implementation, administration and support
- Building and maintaining self-service BI applications using Power BI, Sage Intelligence, Sage Enterprise Intelligence, Excel that will inter-operate with data warehouses and other BI solutions
- Working collaboratively within and across development and project teams utilizing agile BI design
- Experience in working with packages for data extraction and generating reports for business users
- Ensuring architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance
- Participating in development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance
- Working with principal developers to design, develop and deliver application, i.e., interface, ETL, extract and BI application
- Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution
- Working on major projects with vendors
- Interacting with users and deliver requirements
- Extensively involved in resolving daily issues from production environment
- Creating member universe for purpose of Ad hoc reporting against data marts
- Helping users in understanding web services and run reports
- Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables
- Worked with finance team in financial management process automation with automate statutory, management and regulatory reports
- Worked closely with regional CFO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data Stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data Stage Director in running solution, testing, and debugging components and monitoring executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Made use of SSIS to create complex projects involving loading, transformation, and final output of data.
Group Systems Administrator
Alliance Media Africa
Johannesburg
2016.08 - 2017.02
- Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables
- Worked with finance team in financial management process automation with automate statutory, management and regulatory reports
- Worked closely with regional CFO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data stage Director in running solution, testing, and debugging components and monitoring executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Performed software installations and upgrades to Windows operating systems.
- Resolved escalated help desk tickets promptly, providing high-quality support to end users experiencing technical issues.
- Ensured optimal server uptime, monitoring system health and performing routine maintenance.
- Configured and tested Windows Server operating systems with roles features.
- Improved system performance by implementing server upgrades and hardware replacements.
- Integrated and updated software products to boost system compatibility.
- Conducted regular audits of user accounts and access permissions, maintaining compliance with regulatory standards and organizational policies.
- Implemented backup solutions, ensuring data integrity and availability for disaster or system failure.
- Streamlined network administration tasks for increased efficiency through automation scripts.
- Enhanced system security with regular patch updates and vulnerability assessments.
- Tested software remotely and onsite for server sets to maintain operational readiness.
- Delivered Tier 2 and Tier 3 support for problem identification, diagnosis and issue resolution.
- Mentored employees and offered constructive feedback for performance improvement.
- Detailed upcoming software upgrades and system sprints to team members.
- Created nightly jobs for database backups.
- Contributed to development, administration and testing of disaster recovery plans.
- Implemented internet and intranet applications on multiple platforms.
- Orchestrated integration and communication of software upgrades.
- Assisted onboarding process of new employees by setting up workstations, provisioning accounts, and providing initial IT training as necessary.
- Reduced downtime during migrations by conducting thorough planning and testing processes.
- Increased network stability by proactively analyzing performance metrics and addressing potential bottlenecks before impacted users'' experience.
- Researched and recommended new technologies and strategies for improving system performance.
- Implemented and maintained virtual private networks.
- Developed and documented network policies, procedures and standards.
Senior Sage X3/Business Intelligence Consultant
Parity Software
Johannesburg
2016.04 - 2016.07
- QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting seasonal trends on client products
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Creating databases and schema objects including tables, indexes, and applied constraints
- Connecting various applications to database and writing functions, stored procedures and triggers
- Extensively using SSIS transformations such as lookup, derived column, Data conversion, working on all activities related to development, implementation, administration and support
- Building and maintaining self-service BI applications using Power BI, Sage Intelligence, Sage Enterprise Intelligence, Excel that will inter-operate with data warehouses and other BI solutions
- Working collaboratively within and across development and project teams utilizing agile BI design
- Experience in working with packages for data extraction and generating reports for business users
- Ensuring architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance
- Participating in development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance
- Working with principal developers to design, develop and deliver application, i.e., interface, ETL, extract and BI application
- Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution
- Working on major projects with vendors
- Interacting with users and deliver results up to their requirements
- Extensively involved in resolving daily issues in daily doc production environment
- Creating member universe for purpose of Ad hoc reporting against data marts
- Helping users in understanding web services and run reports
- Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables
- Worked with finance team in financial management process automation with automate statutory, management and regulatory reports
- Worked closely with regional CFO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data Stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data Stage Director in running solution, testing, and debugging components and monitoring resulting executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Made use of SSIS to create complex projects involving loading, transformation, and final output of data.
Analyst (SAGE X3 Administrator)/Senior Business Intelligence Analyst
MIS, Chubb Fire, United Technology
Johannesburg
2015.05 - 2016.01
- Worked with finance team in financial management process automation with automate statutory, management and regulatory reports
- Worked closely with regional CEO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data Stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data Stage Director in running solution, testing, and debugging components and monitoring executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Made use of SSIS to create complex projects involving loading, transformation, and final output of data
- Worked closely with teams to gather, analyze, and document business cases, functional and technical requirements, and processed flow diagrams for new projects, enhancements to existing solutions and production issues reported by end users
- Participated in end-to-end implementation planning including project management, issue management, communication and change management
- Interpreted business needs and technical requirements into integrated solution, providing direction for system enhancements and defect fixes
- Managed UAT with end users including coordination and user acceptance sign-off
- Managed relationships with multiple teams for new solution features and technical support
- Created, delivered, and presented end-user training materials to users throughout organization
- Developed complex reports and dashboards and supported existing reports using SQL Server Reporting Services (SSRS) and Power BI based on end-user requirements
- Site Solution Provider (Operations Management)
Solution Architect
Simba Logistics
Dar Es Salaam
2014.10 - 2015.03
- QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting seasonal trends on client products
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Creating databases and schema objects including tables, indexes, and applied constraints
- Connecting various applications to database and writing functions, stored procedures and triggers
- Extensively using SSIS transformations such as lookup, derived column, Data conversion, working on all activities related to development, implementation, administration and support
- Building and maintaining self-service BI applications using Power BI, Sage Intelligence, Sage Enterprise Intelligence, Excel that will inter-operate with data warehouses and other BI solutions
- Working collaboratively within and across development and project teams in utilizing agile BI design
- Experience in working with packages for data extraction and generating reports for business users
- Ensuring architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance
- Participating in development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance
- Working with principal developers to design, develop and deliver application, i.e., interface, ETL, extract and
- BI application
- Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution
- Working on major projects with vendors
- Interacting with users and deliver results up to their requirements
- Extensively involved in resolving daily issues in daily doc production environment
- Creating member universe for purpose of Ad hoc reporting against data marts
- Helping users in understanding web services and run reports
- Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables
- Worked with finance team in financial management process automation with automate statutory, management and regulatory reports
- Worked closely with regional CEO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data Stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data Stage Director in running solution, testing, and debugging components and monitoring resulting executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Made use of SSIS to create complex projects involving loading, transformation, and final output of data.
- Improved solution efficiency by designing and implementing scalable architectures for enterprise clients.
- Conducted research to evaluate systems design and process efficiency.
- Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
- Facilitated seamless communication between technical teams and non-technical stakeholders by effectively translating complex concepts into understandable terms for all parties involved in projects.
- Optimized resource allocation across multiple projects by utilizing advanced project management tools and techniques for more efficient scheduling and task prioritization.
- Collaborated with developers on creating user-friendly interfaces that simplified complex workflows within custom-built solutions.
- Accelerated project delivery with effective management of cross-functional teams, adhering to agile methodologies and best practices.
- Managed end-to-end software development life-cycle, from initial requirements gathering to post-implementation support and maintenance.
- Communicated with partners and clients to update product and implementation status at technical or functional level.
- Managed project planning, resource allocation, scope, schedule, status and documentation.
- Delivered high-quality solutions on time and within budget through diligent adherence to project scope, timelines, and resource constraints.
- Presented roadmap and technology infrastructure to customers, demonstrating deep familiarity with APIs, platform infrastructure, security and integration capabilities.
- Managed project scope, schedule, status and documentation.
- Reduced system downtime through proactive monitoring, maintenance, and optimization of IT infrastructure.
- Spearheaded migration of legacy systems to modernized architecture, reducing operational expenses while increasing overall functionality.
- Conducted post-sale requirements gathering, analysis and documentation.
- Provided support during customer implementations and applied industry best practices.
- Mitigated risks associated with solution implementations by conducting thorough assessments of potential vulnerabilities prior to deployment.
- Established strong relationships with vendors to secure favorable pricing structures on hardware/software acquisitions, resulting in significant cost savings for clients.
- Executed application database upgrades, backups and restore duties.
- Maximized system performance by conducting thorough testing and troubleshooting to identify areas for improvement.
- Oversaw development and maintenance of organization computer systems and intranet.
- Managed use of various types of databases and configured, installed and upgraded new ones.
- Resolved issues related to operational components for LAN, WAN and voice systems.
ERP Implementation Consultant
Client 1st Technology
Cape Town
2013.06 - 2014.09
- QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting seasonal trends on client products
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Creating databases and schema objects including tables, indexes, and applied constraints
- Connecting various applications to database and writing functions, stored procedures and triggers
- Extensively using SSIS transformations such as lookup, derived column, Data conversion, working on all activities related to development, implementation, administration and support
- Building and maintaining self-service BI applications using Power BI, Sage Intelligence, Sage Enterprise Intelligence, Excel that will inter-operate with data warehouses and other BI solutions
- Working collaboratively within and across development and project teams in utilizing agile BI design
- Experience in working with packages for data extraction and generating reports for business users
- Ensuring architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance
- Participating in development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance
- Working with principal developers to design, develop and deliver entire application, i.e., interface, ETL, extract and BI application
- Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution
- Working on major projects with vendors
- Interacting with users and deliver results up to their requirements
- Extensively involved in resolving daily issues in daily doc production environment
- Creating member universe for purpose of Ad hoc reporting against data marts
- Helping users in understanding web services and run reports
- Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables
- Worked with finance team in financial management process automation with automate statutory,management and regulatory reports
- Worked closely with regional CEO to reduce business risk and improve efficiency in critical business reporting process
- Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle
- Extensively worked on Data Stage sever and parallel job controls and sequencers
- Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs
- Used complex SQL queries for data analysis, created store procedures and Unix scripts
- Worked with Data Stage Director in running solution, testing, and debugging components and monitoring resulting executables
- Task allocation to resources and ensure completeness of tasks in timely manner
- Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design
- Extensively worked in large scale data loading from text files
- Made use of SSIS to create complex projects involving loading, transformation, and final output of data.
Business Solutions Consultant
South African National Biodiversity Institute
Cape Town
2012.08 - 2013.05
- Creating detailed report technical designs that also included sample report layouts
- Creating ETL mapping sheets that included information regarding source and target tables and source to target join conditions as well as transformation rules
- Based on information in ETL mapping sheets, created detailed ETL technical designs
- All produced report and ETL designs were signed-off by client with minimal to no re-work
- Extracted data from flat files and from Oracle database over database links, applied business logic to load them in central Oracle database
- Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Sybase
- Implementing slowly changing dimensions to maintain current information and history information in dimension tables
- Working on different data sources such as Oracle, SQL server, flat files etc
- QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting seasonal trends on client products
- Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming data for loading into pre-designed data warehouses
- Execution of daily data publishing procedures from start to finish and creating new ETL procedures for data extraction and transformation
- Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008)
- Using ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Creating databases and schema objects including tables, indexes, and applied constraints
- Connecting various applications to database and writing functions, stored procedures and triggers
- Extensively using SSIS transformations such as lookup, derived column, Data conversion, working on all activities related to development, implementation, administration and support
- Building and maintaining self-service BI applications using Power BI, Sage Intelligence, Sage Enterprise Intelligence, Excel that will inter-operate with data warehouses and other BI solutions
- Working collaboratively within and across development and project teams in utilizing agile BI design.
- Performed proof of concept demonstrations, instructing potential customers on benefits.
- Recommended specific products to customers based on unique technical requirements of each.
- Drafted integration plans to ease assimilation of products into customers' business infrastructure.
- Collected customer satisfaction data via surveys and other measures.
- Developed post-sale technical processes for installation and technical support.
- Coordinated support responses to customer issues, verifying closure of concerns and correction of deficiencies.
- Developed and implemented strategic plans to drive growth and achieve organizational goals.
- Improved operational efficiency by identifying opportunities for automation and process improvement across organization.
- Liaison between technical teams and end-users, ensuring seamless communication throughout project life cycles.
Calculations Specialist
Old Mutual, Town
Cape Town
2011.04 - 2012.07
- Carries out technical actuarial work, often using complex systems and packages
- Checks, manipulates and analyses volumes of data and draws conclusions from analyses
- Ensures technical accuracy and implementation of work
- Translates actuarial concepts into client-friendly terminology
- Personal Effectiveness Accountable for service delivery through own efforts
- Individually accountable for managing own time, tasks and output quality for periods up to 3 months
- Makes increased contributions by broadening individual skills
- Collaborates effectively with others to achieve personal results
- Responsible for technical accuracy and implementation of work
- Works under supervision and executes tasks in accordance with instructions
- Using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases
- Modifying existing SSIS packages to meet changes specified by users
- Scheduling jobs for executing stored SSIS packages, which were developed to update database on daily basis using SQL server agent
- Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
- Scheduled report and exported in pdf format and excel format as desired by users
- Fine-tuned SQL queries for maximum efficiency and performance using SQL profiler and database engine tuning advisor
- Building dashboards and performing Ad hoc analyses with SSRS, Tableau and Power BI
- Designing and implementing stored procedures and triggers for automating tasks
- Working in setup logging environment to track status of events like error raise, task fail
Education
Masters Artificial Intelligence - Engineer
IBM Simplilearn
Purdue University 2024.05 - 2026.05
Enterprise Intelligence Partner Certification -
SAGE University
Johannesburg, Gauteng 2017.08 - 2017.05
Technical Consultant - Computer System Administration
SAGE University
Johannesburg, South Africa 2014.11 - 2015.05
Certificate in Business Accounting -
CIMA
Johannesburg, Gauteng 2016.03 - 2016.05
Advanced Business Intelligence Reporting -
SAGE University
Cape Town, Western Cape 2012.12 - 2013.05
Diploma - Enterprise Resource Planner
SAGE University
Cape Town, Western Cape 2008.06 - 2010.05
Bachelors - Economics and Statistics
University of Cape Town
Cape Town, Western Cape 2012.08 - 2012.05
Skills
Additional Information
- Willing to relocate: Anywhere
Accomplishments
- Completed the ABSA CIB Trade and Working Capital Project on time within under budget.
- The ABSA CIB Trade and Working Capital execution team has been recognized for a Global digital platform award
- The Digital Platform Improved customer satisfaction ratings by 50% by .
- Managed team of 35 members, made up Developers, Business Analysts, Testers
Software
Python
C++
SQL
Data structures and algorithms
Source control
Testing procedures
Debugging knowledge
Cloud platforms
Spreadsheet software
Golf, Basketball
Golf and basketball have long been two of my greatest passions in life. On the golf course, I find a sense of peace and focus that is unmatched. The methodical swing, the precision required to send that tiny white ball sailing gracefully through the air and dropping neatly into the distant cup, fills me with a profound sense of satisfaction. I love the strategy involved, carefully considering each shot, the wind, the terrain, and making split-second adjustments to my stance and grip. There's an almost meditative quality to walking the fairways, the gentle rhythm of my steps and the tranquil surroundings allowing my mind to quiet and my body to move with fluid, practiced motions. And when I do manage that perfect shot, that elusive hole-in-one, the surge of exhilaration is simply unparalleled.
Basketball, on the other hand, provides a thrilling contrast - the fast-paced, high-energy atmosphere of the court, the adrenaline rush of weaving through defenders and sinking a three-pointer at the buzzer. I relish the teamwork and camaraderie of the sport, working in sync with my teammates to outmaneuver the opposition. The physical intensity of sprinting up and down the court, leaping to block a shot or secure a rebound, pushes my body to its limits and fills me with a profound sense of accomplishment. There's an indescribable joy in the flow of the game, anticipating the next move, reading the court, and making that perfect pass or taking that perfect shot. Whether it's the roar of the crowd at a championship game or the quiet concentration of a pickup game among friends, basketball ignites a fire within me that nothing else can.
Both golf and basketball have become integral parts of my identity, shaping my character, honing my skills, and bringing me immense fulfillment. They are not just hobbies, but lifelong pursuits that continue to challenge, inspire, and enrich my life in countless ways.
Timeline
Masters Artificial Intelligence - Engineer
IBM Simplilearn
2024.05 - 2026.05
Senior Data Insights and Business Intelligence Manager
Standard Bank Group
2020.08 - 2021.01
Product Owner, Lead BA
Sebata Municipality Solutions
2019.04 - 2019.10
Enterprise Intelligence Partner Certification -
SAGE University
2017.08 - 2017.05
Enterprise Management Expert/Senior Business Intelligence Analyst
Times 3 Technology
2017.03 - 2018.03
Group Systems Administrator
Alliance Media Africa
2016.08 - 2017.02
Senior Sage X3/Business Intelligence Consultant
Parity Software
2016.04 - 2016.07
Certificate in Business Accounting -
CIMA
2016.03 - 2016.05
Analyst (SAGE X3 Administrator)/Senior Business Intelligence Analyst
MIS, Chubb Fire, United Technology
2015.05 - 2016.01
Technical Consultant - Computer System Administration
SAGE University
2014.11 - 2015.05
Solution Architect
Simba Logistics
2014.10 - 2015.03
ERP Implementation Consultant
Client 1st Technology
2013.06 - 2014.09
Advanced Business Intelligence Reporting -
SAGE University
2012.12 - 2013.05
Business Solutions Consultant
South African National Biodiversity Institute
2012.08 - 2013.05
Bachelors - Economics and Statistics
University of Cape Town
2012.08 - 2012.05
Calculations Specialist
Old Mutual, Town
2011.04 - 2012.07
Diploma - Enterprise Resource Planner
SAGE University
2008.06 - 2010.05
Project Manager
ABSA CIB
8 2021 - Current
Senior Data Analyst
ABSA - CIB
2 2021 - 7 2021
Similar Profiles
Themba MahlabaThemba Mahlaba
Regional Head, Commercial Property Finance at ABSA CIBRegional Head, Commercial Property Finance at ABSA CIB
Mandla Zenzele Brian MabasoMandla Zenzele Brian Mabaso
BUSINESS ANALYST & PROCESS CUSTODIAN at Absa CIBBUSINESS ANALYST & PROCESS CUSTODIAN at Absa CIB
Thebe MabiletsaThebe Mabiletsa
Director: Sector Head - Asset Managers, Pension Funds and Investment Holding Companies at Absa CIB Corporate BankingDirector: Sector Head - Asset Managers, Pension Funds and Investment Holding Companies at Absa CIB Corporate Banking