RESUME
Oluwafunmike Asimolowo
Owingsmill
MD. 21117
Telephone: 443-***-****
Email: *********@*****.***
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.