Philipa Kealotswe
Data Analyst
Johannesburg
Summary
I’m currently a detail-oriented Data Ops Analyst with 10+ years of experience in data extraction, cleansing, and reporting across SQL Server. I have recently been exposed to AWS, Python, and SSRS. Proven success in managing large, complex datasets and improving data quality for strategic business decision-making. Adept at supporting custom data warehouse solutions and fostering strong client relationships.
Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow, and production by uncovering trends affecting business success.
Overview
16
16
years of professional experience
Work History
Data Ops Analyst
ZEPZ
01.2024 - Current
- Developed and shared a Python automation script with the team that consolidated over 100 files into a single unified dataset, reducing manual processing time by 80% and improving reporting accuracy across business units. large-scale data sets from multiple suppliers
- Use Python and SQL to generate performance reports
- Establish AWS SQL connections to support relational data queries
- Contributed to database structuring using CTEs and temporary tables to streamline complex logic
- Delivered reconciled financial and operational reports via Power BI and Excel.
- Automated recurring SQL queries and streamlined ETL pipelines using existing SSIS packages reducing manual effort and improving reporting timelines
- Improved data validation processes, reducing error rates through enhanced logic checks and exception handling in T-SQL.
- Support business units with tailored data insights, enabling operational efficiency across finance and other domains.
- Logged and resolved data-related incidents via Jira, ensuring traceability and timely resolution within SLA targets.
- Demonstrated openness to acquire skill in SSIS ETL development and scheduling, currently exploring integration opportunities between front-end reporting tools and backend data services.
- Embodied company values through collaborative stakeholder engagement and alignment of data initiatives.
- Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Streamlined reporting procedures by creating user-friendly dashboards for easy access to key performance indicators.
Data Success Lead
BarnOwl/IDW
01.2019 - 01.2024
- Liaise with data suppliers to ensure that the monthly data is received and loaded to each data warehouse on time
- Gather, organize, and consolidate large datasets from multiple sources, ensuring data integrity and accuracy within the set KPI
- Assist with data quality control and mapping. Ensure the data passes all business rules and validations
- Implemented automated data quality checks, reducing manual validation time by 40% and improving data accuracy and completeness to over 98% through validation, null handling, and referential integrity enforcement.
- Analyze complex data sets to identify trends and patterns
- Checking the cube (Analysis server)
- Balance data to financial reports
- Data Analysis
- Generate error reports where required
- Maintain, improve and build client relationships through professional and clear communication with clients
- Facilitate a transfer of knowledge of the product to user
IT Operations
Smartcom
01.2016 - 01.2019
- Maintain systems currently in place and future systems being developed
- Perform daily, weekly, monthly checks and tasks - Highlight and fix issues
- Routine loading of bulk data into databases
- Run ad-hoc and scheduled reports and SSRS reporting
- Manage tickets created on internal logging system from internal users
- Data integrity within our various databases
- Create and run SQL queries to assist in automating tasks
- Assisting other teams via reporting, system and/or processes
- Empowered cross-functional teams by sharing Microsoft Excel techniques, including pivot tables, conditional formatting, and dynamic formulas — resulting in a 30% reduction in manual reporting time and improved data accuracy across departments
Junior Data Processing Executive
IPSOS
01.2015 - 01.2016
- Technical expertise regarding data models and data mining
- Daily use of reporting packages, databases (SQL), programming i.e JavaScript
- Data analyses using statistical packages for large datasets (Excel, SPSS, SAS, and Dimensions)
- SAS to extract, transform & load source data
- Executed targeted data processing and statistical analysis on over 2 million records, improving data accuracy by 98% and accelerating reporting turnaround by 40%
- Monitoring the automated loading processes
- Writing SQL scripts to manipulate data
Junior Data Analyst
C.A.S. Consultants
01.2010 - 01.2015
- Manipulating, cleansing & processing data using Excel
- Ensuring the efficient operation of the Linux and file server systems
- Analyzed raw operational and financial data , uncovering inefficiencies that led to a 25% reduction in reporting turnaround time and informed strategic recommendations
- Enhanced data accuracy by 35% through meticulous cleaning and organization of over 250,000 records, enabling more reliable analysis and reporting across business units.
Education
B.Sc. - Information Technology Management
PC Training And Business College
Johannesburg, South Africa01.2012
Skills
- SQL Server & AWS RDS
- Data warehousing & ETL processes
- SSRS reporting & dashboard creation
- Data mapping & validation
- Data quality assurance & cleansing
Team collaboration and leadership
Analytical thinking
Time management
Data processing
Attention to detail
SQL and databases
Timeline
Data Ops Analyst
ZEPZ
01.2024 - Current
Data Success Lead
BarnOwl/IDW
01.2019 - 01.2024
IT Operations
Smartcom
01.2016 - 01.2019
Junior Data Processing Executive
IPSOS
01.2015 - 01.2016
Junior Data Analyst
C.A.S. Consultants
01.2010 - 01.2015
B.Sc. - Information Technology Management
PC Training And Business College