Samuel Okunola

Queens, NY *****

Phone: 347-***-**** Email: adlp56@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/samuel-okunola-9567b96b/ GitHub: https://github.com/samuelokunola326

SUMMARY

A quantitative analyst with experience working with multi-layer applications and a track record of solving problems through data-driven and quantitative reasoning. Highly skilled in translating technical findings to non-technical audiences and understanding client’s needs.

SKILLS

Programming Languages: Python, R, SQL, NoSQL, VBA, JavaScript

Programming Libraries & Technology: AWS S3, AWS RDS, PySpark, Pandas, Matplotlib, SciPy, NumPy, Scikit-Learn, Selenium, Citipy, Json, Request, Gmaps, Beautiful Soup, Chrome Driver, Flask, SQLAlchemy, PyMongo, Psychopg2, SQLite, PostgreSQL, pgAdmin, SQL, MYSQL, NoSQL, ggplot 2, Knitr, Jupyter Notebook, Tableau, MongoDB, Microsoft Excel, Microsoft Access, D3.js, Plotly, Ajax, GitHub, Git Lab, Git Bash Terminal, Jira, Heroku

Technical Skills: Object-Oriented Programming, Data Visualization, Statistical Data Analysis, Data Modeling, Data Engineering, Time Series Analysis, Predictive Data Analysis, Web scraping/API, Algorithm Design/Analysis, Test-Driven Development, Repository Management, Project Management, Documenting Business Requirements, User Acceptance Testing, Project Management

PROJECTS

Citi bike Analysis January 2021

Project Link: https://github.com/samuelokunola326/Citibike_Analysis

This project analyzed 12 months of data from Citi bike’s website to build 2 interactive dashboards that show the relationship between the top 10 most active stations and the different subscriber types. As well as the ridership demographics by gender and age group to reveal possible new target audiences.

●Pull 12 months of ridership data from the Citi bike website and aggregate it into a master file using a VBA script to automate.

●Perform data cleansing and optimization on master file with over 300k records in preparation to load to Tableau for analysis.

●Summarize dashboards in a Tableau story to present findings and provide actionable insights to the group.

Primary Tools: Tableau, Microsoft Excel, VBA, GitHub

SQL DB Migration October 2020

Project Link: https://github.com/samuelokunola326/SQL-DB-Migration.git

In this end-to-end database project stakeholder input was used to translate business questions into actionable queries where legacy files were reviewed and migrated to a Postgre SQL database. A connection was then created to expand access to other Python-based apps for further analysis.

●Review legacy files for possible relationships and planning of schema design as well as constraints needed to maintain data integrity and normalize data as well where needed.

●Create a script to execute the design of table schema and necessary relationships as well as constraints.

●Use Quick DBD Web Tool to visualize table schema for presentation purposes to better convey database structure to a non-technical audience.

Primary Tools: Postgre SQL, Microsoft Excel, Quick DBD Web Tool, Python, SQLAlchemy (Python Library), Pandas (Python Library), GitHub

Tumor Drug Analysis October 2020

Project Link: https://github.com/samuelokunola326/Tumor_Drug_Analysis.git

Used python to analyze the test results of 10 different drug efficacy rates against tumors in rats across 9 different time intervals. The results were then visualized using Matplotlib to convey findings.

●Imported, cleaned, and reshaped data where necessary in preparation for analysis using Pandas and NumPy libraries.

●Used SciPy library to produce descriptive statistics to analyze results and identify the most effective drug and discover the most highly correlated variables and visualize with Matplotlib library to present findings.

Primary Tools: Python, Matplotlib (Python Library), SciPy (Python Library), NumPy (Python Library), Pandas (Python Library), GitHub

EXPERIENCE

GNY Insurance New York, NY October 2018 – Present

HR Analytics & Compensation Analyst

●Produce quarterly statistical comparisons of salaries for over 200 positions to private and public salary datasets available, and present findings to VP of HR, CFO, and CEO.

●Maintain employee backup database and flow of information from HRIS system.

●Maintain people analytics and compensation dashboards and compensation system, as well as the connecting API to HRIS system.

1stdibs New York, NY July 2017 – May 2018

Compensation Associate

●Execute yearly trend analysis on executive compensation using in-house data, as well as participate in external benchmarking surveys for executive compensation.

●Lead reporting with performance review data, attrition statistics, recruiting analytics, and new hire/diversity metrics.

●Use Microsoft Access database to manage employee incentive plan data and provide ad hoc monthly and quarterly reporting using basic SQL and ETL processes to set up power BI dashboards to analyze KPI metrics.

Namely New York, NY October 2015 – June 2017

Senior Analyst

●Partner with the engineering team acting as the liaison for managing projects using Jira Dashboards, for projects related to EDI pipelines connecting client sites and external sites.

●Create client bugs/site usage reports for the Product Manager to help prioritize features on the product road map.

●Provide monthly, weekly, and quarterly reporting for clients, internal consultants, and the engineering team on both east and west coast.

EDUCATION

Columbia University School of Engineering New York, NY February 2021

Data Analytics Certificate of Completion

A 24-week intensive program focused on gaining technical programming skills in Excel, VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, and Machine Learning.

Penn State University University Park, PA

Bachelor of Science in Industrial-Organizational Psychology

Contact this candidate