John is available for hire
Hire JohnJohn Colman
Verified Expert in Engineering
Software Developer
Location
Waterlooville, United Kingdom
Toptal Member Since
June 18, 2020
John is a freelance business intelligence, reporting, and data analysis specialist. His many years of experience span a number of platforms in a variety of industries, with a focus on SQL and Oracle-based technologies. John enjoys taking on challenging assignments and performs well under pressure.
Portfolio
Colman Analytics, Ltd.
Visual Basic for Applications (VBA), Microsoft 365, Git, Microsoft Power BI...
PwC
Microsoft Excel, Visual Basic for Applications (VBA), Python
Tech Mahindra
Oracle
Experience
Availability
Part-time
Preferred Environment
PostgreSQL, Oracle, Microsoft SQL Server
The most amazing...
...project I've worked on is a total reporting suite for a database with over a million new rows per day.
Work Experience
Freelance Entrepreneur
2015 - PRESENT
Colman Analytics, Ltd.
- Designed, developed, and implemented ad-hoc projects for various clients worldwide.
- Deployed Google Cloud, AWS, and Azure.
- Designed, developed, and deployed a SQL Server database solution for a small-scale short-term lender.
- Created a series of KPI dashboards in PowerBI for a telco reseller.
- Wrote a collection of SQL job interview test questions.
Technologies: Visual Basic for Applications (VBA), Microsoft 365, Git, Microsoft Power BI, MySQL, PostgreSQL, Microsoft SQL Server
Data Wrangler
2020 - 2020
PwC
- Designed, developed, and implemented solutions to transform data from multiple file formats using Python (Pandas, Camelot, Tesseract).
- Assigned tasks to the team to balance complexity with ability.
- Produced regular reports detailing project progress, initially designed in Tableau.
- Supported colleagues with development of Python solutions.
- Implemented version control of solutions.
Technologies: Microsoft Excel, Visual Basic for Applications (VBA), Python
Technical Specialist
2019 - 2019
Tech Mahindra
- Gathered and defined requirements for a data warehouse solution on a large digital transformation project.
- Designed and implemented an ETL solution from normalized data to data warehouse for reporting in Microstrategy.
- Informed decisions around data integrity and data governance in the data warehouse.
- Supported development teams with complex SQL queries.
Technologies: Oracle
Report Developer
2016 - 2019
Neural Technologies, Ltd.
- Designed and produced SSRS reports based on large Oracle datasets as well as XML and JSON sources.
- Developed and supported Oracle procedures and packages (PL/SQL) to underpin report development, including ETL and data warehousing solutions.
- Provided ongoing maintenance and improvement of existing reporting solutions for telecoms data (in billions of rows per month).
- Designed and documented new and existing reporting solutions for telecoms data.
- Managed release processes for reports and database solutions as part of the full software lifecycle.
- Maintained version control via Git and Mercurial.
- Managed and oversaw offshore development teams.
- Analyzed the complete product to ensure GDPR compliance.
- Bespoke report design and implementation for clients to enable better data analysis and data discovery.
Technologies: Oracle, Microsoft SQL Server
Technical MI Analyst
2015 - 2016
Southampton City Council
- Provided tactical analysis and datasets to all stakeholders.
- Coordinated reporting and analysis solutions from a team of five direct reports.
- Developed and implemented enduring reporting and data provision solutions in Oracle, MS SQL, and SAP Crystal Reports via SAP Business Objects.
- Designed MI reports for use by senior council members and councilors.
- Led discussions around strategic use of data in a social work environment as part of a regional board.
- Defined requirements for software development teams to ensure reporting needs are met.
- Wrote best practice guidance for data accuracy and statutory requirements in a social work environment.
- Developed the full automation of annual, monthly, weekly, and daily reports.
- Produced annual statutory returns for multiple government departments based on technical requirements drafted by HM government (Dept. of Education).
Technologies: SAP BusinessObjects (BO), Crystal Reports, Oracle
Decision Support Developer
2014 - 2015
SSE
- Used SQL Server, MS Excel, and MS Access for reports and metrics for management consumption.
- Analyzed smart meter data to identify trends and create forecasts.
- Validate the data for reports created by other members of the team.
- Developed data models to determine field resource requirements.
- Developed and supported scheduled imports of data via SSIS.
- Prepared specification documents for upcoming solutions.
- Implemented a work tracking solution in MS Access via SQL and VBA.
Technologies: Microsoft Excel, Microsoft Access, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server
Data Analyst
2014 - 2014
Feefo
- Designed and delivered the database for The Times Travel Survey.
- Used MySQL, CRM, and MS Access to produce monthly and ad-hoc reports for all departments.
- Used MS Access and Excel (VBA) to produce custom reporting solutions for clients.
- Analyzed data to identify falsified and fraudulent reviews.
- Worked alongside the systems operation teams to optimize MySQL performance.
- Worked with the development teams to validate data quality following software releases.
- Worked as part of a project team to migrate data to MongoDB.
Technologies: MongoDB, MySQL
Billing Analyst
2011 - 2014
Broadsoft
- Completed customer data migration to a new billing system.
- Automated the monthly billing process through SQL Server procedures.
- Designed and created monthly KPI reports in SSRS.
- Created underlying views for a customer reporting solution in SQL Server.
Technologies: Oracle, Microsoft SQL Server
1st/2nd Line Support
2010 - 2011
SSE
- Provided first-line support for network users.
- Supported in-house software built on Oracle.
Technologies: Oracle, Citrix, Windows
Billing Analyst
2007 - 2009
Thus/Cable&Wireless
- Supported the billing system.
- Created reports using MS access, MS Excel, and Crystal Reports.
- Migrated customer data from AS400 to Oracle as part of an acquisition.
Technologies: Microsoft Access, Crystal Reports, AS400
Experience
Bank Statement Converter
https://gitlab.com/JohnSQL/publicfriendlyportfolio/-/blob/master/bank_statement_PDF_to_CSV.pyA Python script that reads a folder of PDF-formatted bank statements and imports the data to CSV format.
Skills
Libraries/APIs
Pandas, NumPy
Tools
Crystal Reports, Microsoft Access, Microsoft Excel, Microsoft Power BI, Git, Mercurial
Languages
T-SQL (Transact-SQL), SQL, Visual Basic for Applications (VBA), HTML, XML, Python 3, Python
Platforms
Oracle, Windows, Citrix
Paradigms
Database Design, Database Development, Agile, ETL Implementation & Design
Storage
PostgreSQL, MySQL, PL/SQL Developer, SQL Server Reporting Services (SSRS), Oracle PL/SQL, PL/SQL, Microsoft SQL Server, MongoDB, SQL Server Integration Services (SSIS), SQL Server DBA
Frameworks
Flask
Other
SSRS Reports, AS400, Microsoft 365, SAP BusinessObjects (BO), SOAP, Data Warehouse Design, Tesseract
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