Data Analyst Executive Assistant

Olatunde Olawale

******************@*****.*** 401-***-**** LinkedIn

PROFESSIONAL SUMMARY

Highly motivated professional who excels in team-oriented environments and possesses exceptional personal and communication skills. With expertise in Power BI, Alteryx, and Oracle SQL Database, I am passionate about leveraging business intelligence and data engineering to drive success. Skilled in developing workflow processes, building data pipelines, and executing seamless data migrations, I have established myself as a competent BI analyst and Data Engineer. My in-depth understanding of data and business intelligence analysis, coupled with my proficiency in cloud computing and SQL optimization modeling, enable me to excel in complex, data-driven environments. TECHNICAL SKILLS

Python Tableau Power BI Alteryx Snowflake DAX Language SQL NoSQL HTML & CSS Jupyter Notebook RStudio Microsoft office Watson Studio Oracle Database MySQL NumPy SciPy Matplotlib Pandas Scikit-learn AWS. EXPERIENCE PROJECTS

KPMG, Data Engineer/ Data Analyst January 2022 - Present

• Developed workflow process and built pipeline for data reporting purposes with internal and external stakeholders, resulting in an improved model.

• Oversaw data migration of financial reports worth over $98 billion.

• Analyzed and created reports using Oracle SQL Database and Power Bi, resulting in a 16% increase in operations.

• Used Azure Dev Ops to create a detailed timeline sprint for members, improving work efficiency by 78%.

• Applied SQL queries to extract historical data, comparing to the latest data to avoid data errors when transforming the data for business insights.

• Developed reports using Power BI for data insights to meet client needs and mitigate risks and data errors by 87%. TROY UNIVERSITY, Phonaton April 2018 – August 2020

• Maintained accurate records of more than 158,000+ alumni on Troy University’s Databases.

• Utilized communication skills to keep alumni profiles up-to-date and relevant, ensuring accuracy in the database.

• Proactively worked to improve the university’s relationship with its alumni by maintaining accurate records and facilitating effective communication.

OUTFITS PUBLISHERS, Executive Assistant. December 2010 – June 2017

• Cultivated positive relationships with more than 450 Clients to promote company products and services, also using Microsoft Excel and Spreadsheet to accurately update client records as needed.

• Responded to Client requests for products promptly and ensured satisfaction with offerings.

• Delivered clients balances after each transaction to maintain transparency.

• Contributed to a remarkable 128% increase in company revenue through attention to detail and dedication to the role. Projects:

Explored a Dataset to get a Location for a Business. June 2021 - August 2021

• Researched a list of 365+ Neighborhoods on Wikipedia to extract a location for the business (New York City) and generated the Geographical coordinates of the dataset using Foursquare API (also with Folium libraries to visualize the map).

• Reviewed a food dataset from Wikipedia and introduced beautiful soup for web scrapping and parsing.

• Finally, analyzed each Neighborhood with libraries such as NumPy, pandas, Mat plot libraries and Sci Kit learn, using K-Means for segmenting and clustering to find the untapped locations that would make the business a profitable one. Analyzed an Airline Data April 2021 - May 2021

• Retrieved a dataset consisting of almost 1500+ Flights Performance varying by year and created a visualization for the drop-down containing the ‘performance report’ and the ‘yearly average flight delay statistics’ from year 2005 to 2020.

• Constructed a layout of 15 graphs and 20 charts to make the data easily accessible and understood, then assembled a tree map to figure out when the flight delays were at the peak.

Tech: Watson Studio, Python, Jupyter Notebook.

Troy University Hackathon Organizer, Troy University’s first Hackathon

• Successfully planned a 4-day program and secured sponsorships from notable companies like Amazon, CGI, Shipt, Linode, among others, resulting in over 300 students attending the event. CERTIFICATIONS

• IBM Data Science by IBM. -- Certificate April 2021 - August 2021 EDUCATION

Bachelor of Science in Computer Science (GPA 3.4) Graduated: December 2021 Troy University, Troy, AL

• International Honors Scholarship, Provost list, Chancellor’s list. ACTIVITIES

National Society of Black Engineers N.S.B.E. January 2020 - present Head of Public Relations, Troy African Students Association T.A.S.A. August 2017 – May 2021 International Students Cultural Organizations I.S.C.O. November 2017 - January 2020

Contact this candidate