Sql Server Data Analyst

Ayotunde T Awote

626-***-**** – ***************@*****.***)

EXPERIENCE SUMMARY

• Highly organized and result-oriented professional with 7+ years of experience in Data Reporting and Analysis

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

• Proven understanding of translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs.

• Knowledge of Relational databases

• Workforce Analysis

• Advanced knowledge of generating reports from SQL server in MS Excel connection

• 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.

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

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

• Self-aware, reflective and able to learn from mistakes, with an ability to learn quickly while on the job

• Experience assisting Business Analysts in gathering requirements for development purposes

• Proficient in Tableau visualizations and dashboards creation using Tableau Desktop TECHNICAL SKILLS:

• Tools: MS (Access, Excel, Word PowerPoint, power Query), Microsoft SQL Server 2012, SQL Queries Optimization,/ SQL Plus, Microsoft Office Suit.

• BI Tools: Tableau,

• Languages: SQL, SAS Studio

• Databases: SQL Server 7.0, SQL Server 2000

• Other skills: VLOOKUP, Pivot table, Macros

EXPERIENCE

LA Care Health Plan

Clinical Data Analyst II Los Angeles, CA Remote

Dec 2022- Till date

*Design, develop and maintain complex ongoing data projects.

*Design, develop, and generate ad hoc/production reports.

*Produce automatic, robust, timely and accurate results based on client specifications and as allowed by available resources.

* Produce complete documentation, QC reports and periodic results as scheduled. Identify and create work-around to generate valid results that meet the intent of the client's specifications. Investigate and document organizational data flow and sources.

*Provide thorough documentation regarding current 1) data sources 2) data flow 3) current process and procedures to code, group, QC, link and seed the data. Develop automatic, robust and sharable Statistical Analysis System (SAS) or Structured Query Language (SQL) procedures and programs towards building a comprehensive clinical data repository.

*Develop analytical programs, databases, routine procedures using SAS or SQL programming language. Create work tools that facilitate tasks by reducing paperwork and errors. Document assumptions, specification in a clear and sharable fashion.

*Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge.

*.Ensures that the facts and details are correct so that the project’s/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices.

* Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.

* Educate/Tutor clients/junior staff on maintenance/usage of database/solutions designed.

* Educate/Tutor junior staff on data/business knowledge and technical skills. Communicate with stakeholders/clients/collaborators regarding project details and plans. Perform other duties as assigned.

CDC Foundation for( Louisiana Department of Public health) Remote (Contract)

Data Analyst

Nov 2021- Nov 2022

* full life cycle of data analytics to include requirements and design, data cleaning, developing analysis and capabilities, linking databases and data sets

* Perform basic data management, data cleaning and statistical analysis using SAS, R or other statistical programming language on COVID-19 data to complete data extracts

* Produce and analyze reports for the purpose of monitoring disease trends and providing timely data in support of COVID-19 response and to the public

* Collaborate with agency and external groups providing public health surveillance support and data in regards to COVID-19

* workforce analytics, measuring and analyzing various business performances. Etc Houston Methodist Hospital Houston,Tx Remote

Data Analyst (Contract)

January 2021- Oct 2021

• Developed visualizations and dashboards from extracted reports using Tableau Desktop

• Gather raw data to generate different essential reports

• Document weekly meetings with internal and external Stakeholders

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

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

• Assist Business Analysts in gathering requirements for Development purpose

• Created Data Entry Forms

• Work force analysis

• Created Graphs for Spread Sheets and MS Access Reports.

• Imported data from pre-existing text files and excel spreadsheets Environment:MS Excel (Pivots) SQL Server, Visual Basics for Application QTC Managements Covina, CA

Data Analyst March2018-

Dec 2020

• Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs

• Facilitated meetings among providers and internal teams to ensure proper understanding and clarification of special projects

• Developed reports in Excel and Access from datasets as per business needs

• Data migration and Data validation/Testing through MS Access and MS Excel

• Imported data to Access and SQL Server from flat files and Excel spread sheets

• Performed gap analysis for dataset using Data Analysis Expressions

• Maintained Access database for the purpose of extracting reports

• Developed interactive Microsoft Excel dashboards for presentations purpose

• Worked with the Business users to understand what reports were critical, non-critical and not needed. Environment: MS Access (VBA), MS Excel (VBA), SQL Server, Visual Basics for Application, Tableau, T-SQL, SAS Studio

Contact this candidate