Philip Seimenis, Developer in Johannesburg, Gauteng, South Africa
Philip is available for hire
Hire Philip

Philip Seimenis

Verified Expert  in Engineering

Business Intelligence Developer

Johannesburg, Gauteng, South Africa

Toptal member since March 1, 2022

Expertise
Data AnalysisData WarehouseDashboardData EngineeringSQLBusiness Intelligence DevelopmentPythonData ScienceSSISETLNumPy
Bio

Philip is proficient in aligning business strategy and objectives with established business intelligence and data management paradigms to achieve maximum operational impacts with minimum resource expenditures. With demonstrated experience in the technology, advertising, and financial industry, he is driven to find business value using data, analytics, and efficient processes. Philip is professional with client relationship management, stakeholder engagement, and process optimization expertise.

Portfolio

Freelance
Kivy, Python 3, Microsoft Power Apps, Microsoft Power BI, ETL, Python...
VATIT
Data Engineering, Data Warehousing, Microsoft Power BI, ETL, Star Schema, Jira...
AstuteTech
Microsoft Power BI, SQL, SQL Server Integration Services (SSIS), Excel 365

Experience

  • SQL - 11 years
  • Data Warehousing - 11 years
  • Business Intelligence (BI) - 11 years
  • SQL Server Integration Services (SSIS) - 10 years
  • Data Engineering - 5 years
  • Microsoft Power BI - 5 years
  • Python - 3 years
  • Jupyter Notebook - 2 years

Availability

Part-time

Preferred Environment

Microsoft Power BI, SQL, Python 3, SQL Server Integration Services (SSIS), SSAS Tabular, Microsoft Power Apps, Jupyter Notebook, Data Engineering

The most amazing...

...thing I've created and managed is a data and business intelligence team in charge of data and reporting across a multinational organization.

Work Experience

Freelance BI Developer

2022 - PRESENT
Freelance
  • Developed a Kivy app that converted the scanned PDF images to text documents. The app then used regular expressions to populate predefined templates for a law firm.
  • Built a Kivy app that converted the bulk PDF documents in a folder to Word documents.
  • Developed a front-end side of the power portal app that enables doctors and patients seeking medical aid to register.
Technologies: Kivy, Python 3, Microsoft Power Apps, Microsoft Power BI, ETL, Python, Data Engineering, Jupyter Notebook

Head of Business Intelligence

2018 - 2021
VATIT
  • Developed a set of management reports automated to refresh daily. Initially, the company took weeks to understand the data, and management combined sources in Excel, which was labor-intensive and prone to errors.
  • Led the team that built the data warehouse in SQL server using a star schema. Integrated with a proprietary system, Salesforce, SAGE, and manual sources.
  • Created a solution for data that did not reside in a source system using Power Apps.
Technologies: Data Engineering, Data Warehousing, Microsoft Power BI, ETL, Star Schema, Jira, Salesforce

Freelance

2017 - 2017
AstuteTech
  • Worked as a contractor on a migration project. The project tracked the selling of a domestic bank and followed all touchpoints and delivery.
  • Created reports to track program progress in Power BI.
  • Worked on the analysis to create a reporting module for an HR company.
Technologies: Microsoft Power BI, SQL, SQL Server Integration Services (SSIS), Excel 365

Business Intelligence Data Warehouse Support Manager

2015 - 2016
STANLIB
  • Developed a dashboard to monitor storage and performance of the databases, teams' efficiency and performance, and query performance.
  • Led the team supporting the data warehouse. Implemented a ticketing system and prioritization of enhancements.
  • Implemented the business intelligence analysts' process flows and tool sets.
  • Required to analyze a migration project moving from an in-house asset management system to external vendors.
Technologies: Business Intelligence (BI), SQL, Microsoft Power BI, Data Warehousing, Dashboards, SSRS Reports, QlikView, SQL Server Integration Services (SSIS)

Business Intelligence Analyst

2010 - 2015
STANLIB
  • Worked with the team that created a matching tool in MDM that matched stock securities info from an external vendor to an internal system and enhanced the metadata of the internal system.
  • Created reports using SSRS used to report collective investment schemes to regulatory bodies. Business rules were stringent and data had to be completely accurate and valid, or there were financial penalties.
  • Piloted multiple projects that saved hours of manual intervention. Solutions meant finding the best data sources from businesses and integrating them into existing data warehouse schemas.
Technologies: SQL, Data Analysis, Microsoft Power BI, QlikView, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MDM

Experience

Data Warehouse

I led a team to build a data warehouse using a star schema for a multinational company. The warehouse was built in SQL Server and had several sources of information, such as the Java app with SQL back end, Salesforce, Sage, and manual data. Data needed to be designed and stored.

Management Dashboards for Exco

I built the management reports for a multinational company. The CEO and exco used these to understand the business and make informed decisions. I defined key metrics to track data across the organization, created reports, and broke them down for more detail. Reports were broken into sales, service/retention, operations, stock, and financials.

Operations Report for Multinational

Used SSRS and Power BI to build dashboards and reports for businesses to measure workflows, production, and outputs. Ingested data from internal system and manual sources to provide extensive reports for managing operations.

OCR and Template Population

The law firm has a collection of documents, and an associate reviews the documentation and populates another document based on the information.

The tool I've built automates this process by converting scanned PDFs to text, parsing the text by creating a dictionary, and populating an Excel template.

Bulk PDF Converter

A user wanted a solution to convert bulk PDFs to DOCX files on a Mac. Although there are online tools, they limit the number of files. In this use case, the user had to convert 200 at a time.

The created app opened a file explorer to select the folder, and then the app converted all PDF files in that folder to DOCX.

Certifications

MARCH 2019 - MARCH 2022

Data Management Fundamentals

DAMA International

JULY 2015 - PRESENT

Lean Six Sigma Black Belt

Training Leadership Consulting

Skills

Libraries/APIs

NumPy, Pandas, Kivy, Scikit-learn

Tools

Microsoft Power BI, Microsoft Power Apps, Jira

Languages

SQL, Python, Python 3

Paradigms

Business Intelligence (BI), ETL

Platforms

Jupyter Notebook, Salesforce, QlikView

Storage

SQL Server Integration Services (SSIS), SSAS Tabular, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Industry Expertise

Lean Six Sigma

Other

Data Warehousing, Data Engineering, Dashboards, Data Analysis, Excel 365, Data Analytics, Data Science, Data Management, Star Schema, SSRS Reports, MDM

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring