Janson O.
BI | Data Engineer | Data Analyst | SQL | Excel | Actuarial
Does your business have data, business intelligence, automation or actuarial needs? I am here to help you tackle these problems with analysis, creativity, logic, and actionable insights to achieve your goals. Streamlined simplified data-driven decision-making should be the foundation of your business, not an afterthought. I have a proven track record with 13+ years of experience in consulting, actuarial, data science, IT, management, and education. ✅"This was my first time using Upwork; unfortunately for other freelancers Janson has set the benchmark so high that I don't think anyone else will ever be able to do what he did." ✅"Janson was quick to respond, I sent him a sample of what I wanted, he was quick to send proof that he could do it, and he had the job completed in 45 minutes. Client thinks I am an Excel genius." ✅ "Janson is new to Upwork, grab while he is building his resume, he's gonna be so busy in a few months he wont have time for your job." ✅"His patience and skill were evident throughout the process. I would highly recommend him for any tasks involving data." ✅"Janson was great to work with. Turned the job around immensely quickly and will work with him on future projects for sure! ✅"Janson was awesome to work with! Fast work, great communication and exception end product." I tailor each analysis to the specific business goal: 1) For analyzing data, this begins with understanding the scope of each project and asking all necessary questions upfront to maximize productivity. With a keen eye for detail, I excel at dissecting complex data sets to uncover trends, patterns, and outliers. Whether through the use of SQL, Excel, R, Access, VBA, or another application. 2) For BI, it's not just about the numbers but the storytelling. I craft interactive dashboards in a user-friendly manner whether it's Tableau, Power BI, or another visualization tool. I ensure the data is structured correctly and speaks clearly and effectively. 3) For process optimization, in today's fast-paced business environment - efficiency is key. I specialize in streamlining data-collection, storage, and processing workflows. By implementing automation and best practices, I help you minimize manual tasks, reduce errors, and ensure data integrity. 4) For actuarial science, whether it's helping develop a loss pick for a book of business, complex pricing formulas, or proformas - credible data is of upmost importance. From there, I use mathematical and statistical techniques to assess and manage the risks. Ultimately, my goal is to empower your business to grow through data-driven insights. Together, we can turn data challenges into opportunities. Education: TCU Class of 2014 Magna Cum Laude with Bachelor in Mathematics (Actuarial Concentration) and Minor in Economics Work History: 11 Years of Analytical and Mathematics Expertise -- 7 Years as Vice President BMS in Actuarial and Catastrophe Analytics ------------Responsible for providing strategic leadership in analyzing and managing risks associated with natural and man-made catastrophes. Lead a team of experts in catastrophe modeling, data analysis, and risk assessment. -- 4 Years at United Health in Actuarial and Data Warehouse roles ------------Oversaw the design, development, implementation, and maintenance of the organizations data warehouse infrastructure. Lead a team of data engineers and analysts to ensure efficient data extractions, transformation, and reporting processes. In both roles, have become proficient in the use of SQL Server, Microsoft Access, Microsoft Excel, VBA, Tableau, RShiny. Have optimized and created over 250+ unique processes throughout career. Major Projects: -- United Actuarial Analyst - automated (SQL) production of monthly actuarial data report, from 10 days to 12 hours, used for pricing -- United Data Warehouse Manager - AS400 front end data streamlined to cloud based SQL data Snowflake warehouse to provide KPI's/other reporting through Tableau to key executives -- BMS Catastrophe Analytics - automated 200+ tab Excel workbook to populate monthly claims reserving data for purposes of developing a loss pick by line of business -- BMS Catastrophe Analytics - streamlined creation of Monte Carlo Simulation in Excel VBA/Access and reinsurance contract pricing tools in R for analysts -- BMS Catastrophe Analytics - streamlined reporting by integrating end user SQL Catastrophe results into a single SQL Database to output over 20 reports for up to 50+ clients with a few clicks of a button
Earnings and projects
An estimate from an earlier read
Billed in all: $4,616$4.6k
$0 in the last 6 months
Across 24 contracts
Earnings, last 30 days
No data since Nov 5, 2026.