Post Job Free

Resume

Sign in

Data Analyst Senior

Location:
Memphis, TN
Posted:
April 02, 2024

Contact this candidate

Resume:

TECHNICAL PROFICIENCIES

Microsoft Excel Microsoft Word Microsoft PowerPoint Microsoft Access SAS Base 9 SQL Erwin Data Modeler ER Assistant Tableau PowerBI Python Jira Snowflake Oracle

EDUCATION

University of Lagos Nigeria BS in Petroleum and Gas Engineering August 2013- August 2018

Languages: English

Gained strong sense of leadership, discipline, strong work ethic while under pressure, and excellent time management skills.

EXPERIENCE

Senior Data Analyst Aug 2022 – Present

Employbridge Atlanta, GA

Experience leading and mentoring 3 junior analysts.

Utilize abundance of SQL functions (distinct, sum, avg, rank, like, row_number) to retrieve and systematize data sets and import into PowerBI or Excel.

Collaboration with cross functional team members to and users to synthesize solutions for complex business requirements leading to 6+ implementations.

Worked with PowerBI tools for data modeling, report creation, and statistical analysis for the Candidate Acquisition organization gotten from CRM

Influential in identifying, defining and reporting KPIs and critical success metric to business stakeholders.

Successfully implemented multiple strategies which improved recruiter productivity by over 50%.

Utilized SQL PowerBI and Excel for data analysis, Data verification and Data Modeling.

Analyzed and evaluated 25+ PowerBI graphs and table representation to document changes in budgeting.

Decision Science Analyst Jan 2022 – Aug 2022

USAA San Antonio, TX

Created rich dashboards using Tableau and prepared user stories to deliver actionable insights.

Created monthly PowerPoint reports for management on the different metrics in the company to enhance decision making.

Maintain test log, test evaluation and validation summary reports which ensured accuracy by 99%.

Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

Created complex SQL queries and scripts to extract data for multiple departments.

Maintains departmental metrics in accordance with goal plan, including scheduling of 6 project milestones.

Work with department management and staff members to identify potential issues and process inefficiencies within their functional areas, provides analysis of potentials resolutions and assists in the implementation.

Cleaned large financial datasets using Excel which helped increase the accuracy of the dataset by 25%-50%.

Business Analyst/Tableau Developer Dec 2019 - Dec 2021

Methodist North Hospital Memphis, TN

Developed and maintained Tableau visualizations, dashboards and workbooks from multiple data sources using Data Blending and published scheduled data refreshes using Tableau server.

Operated as lesion between stakeholders and safety data center to initiate and expedite data governance agenda.

Enabled client to align BI initiatives with business goals to facilitate productivity.

Used SAS to mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis.

Worked on special projects when requested by upper management to analyzed, assessed invalid and missing data which cut down rejected claims by 55%.

Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Aggregate functions, Cast, CTE’s and table expressions against SQL server database.

Data Analyst/Modeler Feb 2017- Dec 2019

Lakeview Insurance Chicago, IL

Created and populated Customer data using advanced SQL and PL/SQL queries and scripts.

Translated data into visual representation of information and easy to understand interface to ensure easy understanding using business intelligence tool like PowerBI and Tableau.

Worked on analysis of the parts claims processing application in order to gather requirements to comply with HIPAA 5010.

Conducted interviews with 30+ stakeholders to gather data on business proposal and user requirements.

Served as the business modeler / data analyst for data projects and initiatives, created conceptual and logical business models used to generate physical data models and database schema using the Erwin Data Modeler tool.

Used pivot tables for dimensional analysis and provide 360 views of what is going on. to provide operational and analytical information to administration, interpret data, analyze results, and construct ongoing reports by using SAS.

Strong ability to extract, manipulate, and calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Performed data migration between different environments and Third-Party Databases.

Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse.

Created data dictionaries and source to target mapping documents.



Contact this candidate