OLASUNBO MORAKINYO

Data Analyst / BI Developer

Owings Mills, MD 240-***-**** adysrd@r.postjobfree.com PROFILE

Dynamic technology professional with more than six (6) years of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing. Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management. Keen researcher with robust resolution pedigree; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal. PROFESSSIONAL SKILLS

• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).

• Excellent knowledge in Data Visualization.

• Experience with Data Analysis and Reporting.

• Excellent knowledge and usage of reporting tools such as Tableau, SQL, Snowflake, AWS, SAS, and Power BI.

• Performed Data Modeling, Data Migration, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using Erwin.

• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).

• Frequent update and exposure to new technologies and new business lines.

• Good knowledge of portfolio analysis, wealth management, customer segmentation, HIPAA regulations, and Healthcare terminologies.

• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.

• Exceptional organizational and time management skills and the ability to work independently.

• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments. TECHNICAL SKILLS

Operating Systems Win XP, Microsoft Windows Server 2003, 2008, 2010(X32, X64) Databases MS SQL Server, Teradata, MySQL, Oracle, Snowflake ETL/Other Tools SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, R. Cloud Migration Tools Snowflake, Microsoft Azure, AWS Querying Tools SQL Management Studio, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata PL/SQL

Querying language SQL, PL/SQL, TSQL, PYTHON, SAS

Business Intelligence

Tools

Tableau, Power BI, SSIS, Excel, Power Point and Power Pivot, SSRS, PROFESSIONAL EXPERIENCE

Navy Federal Credit Union – Vienna, VA May 2021 – Present Data Analyst/ BI Developer

Worked with end users, business, and IT users to understand, elicit, and analyze reporting requirements.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau and Power BI.

Wrote complex SQL queries using advanced SQL concepts like Aggregate functions

Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.

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

Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.

Developed queries to retrieve and analyze data from various sources for projects, program, or reports. Work with vendors for evaluation of data reporting enhancement.

Developed, validated, published, and maintained LOGICAL and PHYSICAL data models using Erwin Data Modeler.

Utilizing tableau and Power BI for visual analytics and dashboard developments.

Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)

Home Depot - Frederick, MD Oct 2019 – April 2021

Data Analyst / BI Developer

Prepare high level analysis reports with Excel, SQL, Tableau Desktop and Power BI

Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.

Used Tableau server as a front-end BI tool and MS SQL Server as a back-end database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.

Working with team of developers, designed and implemented a BI solution for Sales, Product and Customer KPIs.

Create compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights.

Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.

Performed numerous data extraction requests involving SQL scripts.

Involved in analyzing the source data coming from different Data Sources.

Performed in depth analysis of data & prepared weekly, biweekly, monthly reports using MS Excel, SQL, Tableau and Power BI.

Performed Data Analysis, created GAP Analysis Document, and performed Data Quality Checking.

Compiles detailed reports using data tools such as but not limited to: SQL and SSIS

Supports business organizational teams by creating flow charts, process and prioritize goals and develop KPI’s and other management reporting

Create an action plan for future automated statistics available by dashboard using Tableau and Power BI. PROFESSIONAL EXPERIENCE

Cardinal Health Dublin, OH March 2016 – Sept 2019

Data Analyst/Tableau Developer

Supports the company’s healthcare software functions, implementation, and training.

Collects data from all clients and made recommendations for improvement.

Ad-hoc data extraction through queries in SQL Server, Excel, SAS, Tableau report.

Data analysis, reporting using Tableau and SAS.

Creates rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

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

Connects to Tableau server to publish dashboard to a central location for portal integration.

Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.

Performing daily integration and ETL(SSIS) tasks by extracting, transforming, and loading data to and from different SQL Server databases

Provides feedback on the quality of data including identification of billing patterns and outliers

Analyze and assess invalid and missing data in the All-Payer Claims Data

Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts

Carrying out data extraction and data manipulation using SQL as per business requirements

Handle Strong healthcare material including experience with transaction standards e.g., HIPAA EDUCATION

11/2021 Primavera P6 professional Fundamentals Completed PMO Link

(A REGISTERED ORACLE PATNER)

06/2021

07/2020

Project Management Professional Certified

management Institute

CompTIA A+ Attained

02/2022 Certified Information System Auditor (CISA) In-view 12/2008 Bachelor of Science: Computer Engineering

Ladoke Akintola University of Technology Oyo

B. Tech

Tableau Public Link: https://public.tableau.com/app/profile/olasunbo.morakinyo

Contact this candidate