Data Analyst Business

Omoniyi Macaulay

*** ******* *****, ********* **. 37211

Phone: 202-***-**** Email: ********.*******@*****.*** LinkedIn: linkedin.com/in/niyi-macaulay

SUMMARY & OBJECTIVE

Skilled data analyst with experience in collecting, organizing, interpreting, and disseminating various types of statistical figures. Creative in finding solutions to problems and determining modifications for optimal use of organization data. Organized and timely in providing staff, department members, and management with reports on specific data findings and their impact on organizational growth and success. With the expansion of my technical skills, I hope to obtain a position as a Data Analyst, Business Analyst or Operational Analyst. SKILLS

ADMINISTRATIVE: Excellent communication, teamwork, detail oriented, self-motivated, well organized, time management, multi-tasking, mathematics, analytical skills. TECHNICAL: SQL (PostgreSQL, JOINS, Google Big Query, Microsoft SQL server management studio) Power BI Tableau Python Excel (Pivot Tables, VLOOKUP, XLOOKUP, Power Query, Index Match and Basic Functions), MS Office Power Automate Relational Databases Data Visualization.

.

EXPERIENCE

Specialty Dental Brands – Nashville, TN Dec. 2021 – April. 2022 Data Analyst

• Built an automated workflow leveraging power automate desktop to pulled raw data from practice management system helped reduce manual pulling of data by 30% and improved data collection, and data storage in the right file path.

• Queried multiple tables from the company’s data warehouse by leveraging SQL (Google Big Query and Microsoft SQL server management studio) systems to gather relevant information for the management to make decision that will helped in the company’s growth

• Utilized Power BI to Identify, analyze, create interactive dashboard, and interpret trends in complex data sets by visualizing with charts.

• Supported in data validation by leveraging excel to clean up and store data to maintain data integrity during data collection, data manipulation, and data processing.

• Created a comprehensive work sheet to store company’s practice management system credentials leveraging excel basic functions, pivot table to analyze matrix helped improved data organization and easy location of PMS credentials information in the Organization. Nashville Software School – Nashville, TN May. 2021 – Aug. 2021 Data Analyst

• Leveraged excel to create interactive dashboard for Nashville Rock and Roll marathon race data (2016

– 2019) for clear data reporting.

• Devised multiple tables from automated scripts used by developers in managing a project by leveraging SQL (PostgreSQL, JOINS) systems and improved performance by 20%.

• Utilize python to Identify, analyze, and interpret trends or patterns in complex data sets by finding correlations and visualizing with charts.

• Managed a team of 4 and led in cleaning up and backing up data to maintain data integrity during extraction, manipulation, and processing.

Front line source group – Dallas, Tx Oct. 2018 – Sept.2019 Inventory control Analyst

• Utilized Microsoft Excel to Record information, shortages, and discrepancies to keep records current and accurate.

• Achieved 15% reduction in delay time through on-time store operations and deliveries.

• Planned and lead physical inventory counts at storage facilities to meet the company objectives.

• Set up delivery of materials to arrive in time for production start date.

• Collected and evaluated data for trend forecasting.

• Verified receipt of returned materials to maintain accuracy of vendor credits. EDUCATION

Nashville Software School, Nashville, TN

Data Analytics Certification (Bootcamp)

Capstone: Population growth, Meat consumption and GDP per capital analysis of different countries. Publication Link: https://github.com/jejelomo007

University of Lagos – Lagos, Nigeria

B.S. Accounting - 3.60 GPA

Capstone: Internal Control Analysis

REFERENCES

Available Upon Request

Contact this candidate