Data scientist

Timothy OJO

336-***-****) ***************@*****.***

AUTHORIZED TO WORK IN THE USA FOR ANY EMPLOYER

PROFILE

An IT Data management professional with over four (4) + year experience in various domains such as Finance, sales, Insurance, Retail and Healthcare. A passionate individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Savvy with business requirements; translate them into clear and concise specifications; as well as extract and manipulate data from RDBMS to make cutting-edge and prudent decisions to improve the outlook of the organization.

PROJECTS

Experienced and Certified Data Reporting/Visualization Analyst with 4 years plus experience in SQL Server Database, Data Reporting/Visualization and for Various Domains such as finance, sales, Insurance and Social Services.

Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.

Familiarity with data governance and ethics topics, familiarity with HIPAA with graduate courses like data analytics in healthcare, healthcare informatics and web analytics, data security and privacy

Proficient in Tableau visualizations and dashboards creation using Tableau Desktop

Experience in implementing data analysis with various analytic tools like Excel & SAS

Proficient in MS Office suite, Visual Basic, MS Access, Microsoft Query and SQL Server Database.

Proficient in all Microsoft applications, Word and PowerPoint, with advanced Excel skills (Pivot Tables, VLOOKUP, Macros)

Hands on experience in SAS programming for extracting data from Excel spreadsheets and other data sources.

Strong ability to write SQL queries using PROC SQL.

Solid background in Table/query design, report design, and automation

Experience in understanding industry level databases and writing complex SQL queries for optimized reports

Experience in Data Analysis and manipulation of complex data set for business need

Experience in writing SQL to generate queries in Database for exporting purpose

Proven experience in writing complex and high-performance SQL queries, experience in data analysis involving data cleaning, data visualization and statistical analysis, analyzing results and effectively communicate findings to the stakeholders.

Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.

TECHNICAL SKILLS:

Languages: SQL

Programming language: Python, SAS

Databases: MS-Access 2.0/97/2000/XP/2002/2003/2007, SQL Server 7.0, SQL Server 2000

Tools: MS (Access, Excel, Word PowerPoint), Microsoft SQL Server 2012, SQL Queries Optimization, Microsoft Office Suit.

BI Tools: Tableau, Power BI

Other skills: VLOOKUP, Pivot table, Macros

EDUCATION

Appalachian State University, Boone. North Carolina.

Master of Science: Applied Data Analytics (Interdisciplinary concentration)

Graduate Certificate: Business Analytics

Bowen University, Nigeria

Master of Science: Economics

EXPERIENCE

E*trade Financials Charlotte, NC

Data/Database Visualization Analyst Feb’19- June ‘20

Automated Company’s weekly reports with Python

Worked on predictive analytics use-cases using Python language.

Data migration and Data validation/Testing between MS Access (SQL Database) and MS Excel

Performed Exploratory Data Analysis, trying to find trends and clusters.

Used Python to preprocess data and attempt to find insight

Analyzing various logs that are been generating and predicting/forecasting next occurrence of event with various Python libraries.

Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas

Supported logical data designs/models by reviewing with Business stewards.

Developed Tableau visualizations and dashboards from extracted reports using Tableau Desktop

Created BI reports in pivot charts, graph and other visualization format to Analyze trends

Automated transferring of data between spreadsheets and workbooks

Communicated and presented default customers profiles along with reports using Python and Tableau

Developed scripts in Python to automate the customer query addressable system using python which decreased the time for solving the query of the customer by 45%

Extensively used SQL queries for data retrieval jobs.

Documented weekly meetings with internal and external Stakeholders

Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions

Worked with the Business users to understand what reports were critical, non-critical and not needed.

Created Dynamic Charts/Graphs in MS Excel and Access for biweekly/Monthly reporting purpose

Created Dynamic Charts/Graphs in Python using matplotlib library

Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas

Assisted Business Analysts in gathering requirements for Development purpose

Importing of data to Access and SQL Server from flat files and Excel spread sheets

Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions

Maintained Access database for the purpose of extracting report

Environment: MS Excel, SQL Server Management Studio, Access, Tableau, T-SQL, Python

SEIU Inc. New York, NY

Data Visualization Analyst Dec’17- Jan 2019

Automated Importing of data to Access and SQL Server from flat files and Excel spread sheets

Developed Tableau visualizations and dashboards from extracted reports using Tableau Desktop

Performed Data Enrichment jobs to deal missing value, to normalize data, and to select features.

Created BI reports in pivot charts, graph and other visualization format to Analyze trends

Wrote complex SQL queries using various joins, unions and functions for report purpose

Automated transferring of data between spreadsheets and workbooks

Wrote the data validation SAS codes with the help of Univariate, Frequency procedures.

Interacted with Business Analyst, SMEs, and other Data Architects to understand Business needs and functionality for various project solutions

Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).

Worked closely with visual design team to select the appropriate visualizations for BI deliverables.

Developed strategy and road maps including tactics, project plans, milestones and KPIs.

Helped with the migration from the old server to Jira database (Matching Fields) with Python scripts for transferring and verifying the information.

Environment: MS Excel, SAS, SQL Server Management Studio, Access, Tableau, T-SQL

EcoBank Lagos, Nigeria

Data Reporting Analyst Jan‘14- July’ 17

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Created Graphs for Spread Sheets and MS Access Reports.

Data migration and Data validation

Owned the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc., to drive key business decisions and communicate key concepts to readers.

Automated transferring of data between spreadsheets and workbooks

Automated Importing of data to Access and SQL Server from flat files and Excel spread sheets

Created BI reports in pivot charts, graph and other visualization format to Analyze trends

Wrote complex SQL queries using various joins, unions and functions for report purpose

Created Excel BI Analysis and reports using VLOOKUP, Pivot tables and complex formulas

Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas

Created Power BI Dashboards to present critical company data in a single report

Created Pivot Tables to view summarized Spread Sheet Data

Imported data from pre-existing text files and excel spreadsheets

Generated the necessary BI reports and information to litigate tax appeals for properties.

Documented weekly meetings with internal and external Stakeholders

Processed property’s annual Income and expense statement requests from Municipals across the country.

Environment: MS Access (VBA), MS Excel (VBA), SQL Server, Visual Basic

Contact this candidate