RESUME

Oluwafunmike Asimolowo

**** **** **** ****,

Owingsmill

MD. 21117

Telephone: 443-***-****

Email: adtirk@r.postjobfree.com

PROFFESSIONAL PROFILE

Highly analytical, innovative, and process-oriented data analyst with expertise in database development, management and optimization. 4years experience in data analysis, data modelling, warehousing and a strong knowledge in Database applications, Oracle/SQL server, Schema, system administration as well as management with knowledge of database types, data capturing, curation, data manipulation and visualization. Skilled in identifying user requirements and ensuring accurate system modifications. Versatile and a proven fast learner with reliability on providing technical direction to yield efficient capacity planning, furnish insight, analytics and business intelligence that outstandingly meets user needs and requirements used in advance opportunity identification, process reengineering and corporate growth Data

PROFESSIONAL SUMMARY

•Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.

•Experience in DATA ANALYSIS, DATA MININIG, DATA MODELING, DATA MIGRATION, consolidate and harmonized data using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using ERWIN 3.x/4. x.

•Experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL.

•Strong ability to write SQL queries using PROC SQL and using ETL technique for loading enormous data

•Excellent knowledge and usage of reporting tools such as Tableau and PowerBi.

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

•Possess strong ability to adapt and learn new technologies and new business rapidly.

•Good knowledge of portfolio analysis, management and customer segmentation.

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

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

EDUCATION

UNIVERSITY OF ADOEKITI Bsc Banking and Finance

Ado Ekiti, Nigeria 2004.

CERTIFICATION Certified SAFE Scrum Master

TECHNICAL SKILLS

Operating Systems

Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases

MS SQL Server,Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools

Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

Test Tools

HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools

SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus.

Querying language

SQL, PL/SQL, TSQL

B/Intelligence Tools

Tableau, Cognos, Excel and PowerPivot, SSRS, PowerBi Agile, Scrum

Professional Experience

Standard Integrated

Data Analyst

January 2020 - Present

•Work with team members to obtain key data elements, updates and data improvements.

•Monitor and verify sufficiency of information for the database.

•Thoroughly review and support documentation to ensure accuracy in data input.

•Analyzes health related data, trends and events to support the strategic objectives, measures and intervention planning for the company

•Write complex SQL queries using advanced SQL concepts like aggregate functions and OLAP with SAS to import and export data from SQL data Server Table

•Planning, analyzing and designing using Universe SAP Business Objects as per the needs.

•Using Pivot tables to create reports, dicing and slicing functions on data, dimensional analysis and provides a 360 view of what is going on.

•Create Tableau and PowerBi Dashboard with quick/context/global filters, parameters and calculated fields on report with interactive views, trends and user level security.

•Create and develop Parameterized, Drill Down and AD Hoc Reports using SQL Server Reports Services (SSRS)

•Develop clear visualizations to convey complicated data in a straightforward fashion

CFG Community Bank

BI / Data Analyst

December 2018 – January 2020

• Used Excel functions to generate spreadsheets and pivot tables

• Identified, analyze, and interpret trends or patterns in complex data sets

• Cleaned and Blend multiple data sources to allow for different views on application data in a single dashboard and checked for invalid and out of range data

• Collected data, analyze and presentations using Tableau and PowerBI

• Generated variety of business reports from server using excel with pivot table/chart

• Fulfilled numerous data request for financial profiling

• Performed data manipulation from various external file formats using SQL and SSIS

• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool.

• Developed update and maintained SQL programs

• Wrote queries to gather data from different tables and derived table on SQL server platform

• Informed management of of issues and resolutions related to data collected

• Developed and implemented efficient databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

Contact this candidate