Olamide Adejumo

admzkf@r.postjobfree.com

571-***-****

PROFILE

An IT professional with over five (5) years’ experience in various domains such as Telecommunication and Healthcare domain. Very experienced in Data Analysis, Data Extraction, Data Manipulation, Research and Reporting in different Visualization formats and from various sources. Able to perform multiple duties in business analysis, project or program management, and functional leadership. A great team player who can relate and work efficiently with diverse groups. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work.

SKILLS SUMMARY

Strong ability to write complex SQL queries.

Experience in Data Analysis and ETL techniques for loading enormous amounts of data.

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

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

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

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

Experience with data mining.

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

Self-motivated individual with strong communication skills, great attention to details and the ability to execute under aggressive deadlines.

Ability to work individually as well as a team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

Strong troubleshooting and problem-solving skills

Excellent knowledge and usage of reporting tools such as Excel, Tableau and Power BI.

Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, 2008(X32, X64)

Querying language: SQL, PL/SQL, TSQL

Databases: MS SQL Server 2012-2016, Teradata, Oracle 9i, 10g, 11g

ETL/Other Tools: SSIS, Visual Studio, Erwin Data Modeler, SAS Base 9.x, SAS Enterprise Guide

Business Intelligence Tools: Tableau 10.1,10.4, 2019.1, 2019.4, 2020.2, Excel, Power BI, SSRS

Querying Tools: SQL Management Studio 2012-2016, Teradata SQL Assistant, Teradata-BTEQ,

WORK EXPERIENCE

Sprint Corporation, Reston, VA

Data analyst / Tableau Developer April 2018 - Present

Roles & Responsibilities:

Gathering Business Requirement and Designed Fact and dimensional Table to initialize a star schema used in creating physical KPI store database with MS SQL Server using the Erwin Data Modeling tool.

Develop complex ETL (extraction, transformation, and loading) SQL scripts to gather data from various source systems like CSV files, Excel, and SQL Server.

Creating dashboard by leveraging techniques such as parameters, filters, sets, groups, and table calculations for a granular and drill-down perspective of the reports.

Created drill through reports and variance dashboard using tableau to assist the UAT for data validation.

Generated KPI’s for customer satisfaction survey results and practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Developing KPI reports based on business requirements, creating intuitive dashboards using tableau for quick reviews to be presented to Business and IT users for enhanced business decision making.

Made business recommendations based on data collected to improve business efficiency.

Executed data queries across multiple data sources in support of business intelligence reporting needs

Extensive experience in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

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

Experience in creating various views on Tableau (Tree maps, Heat Maps, Scatter plot)

Conduct JAD sessions with CMS and other stakeholders to identify, document and communicate business and system requirements

Managed dashboard view by initializing row-level security to restrict access for different level of business units.

Experience in creating Filters, quick filters, table calculations, calculated measures and parameters

Worked with QA analysts to perform routine testing of imported data and result sets.

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

Ensure that the deliverables meet organization and performance requirements.

Alteon Health, Germantown, MD

Data Analyst July 2015 - March 2018

Roles & Responsibilities:

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

Writing complex SQL queries and optimized queries, views for performance tuning to extract data from database to perform data analysis with Tableau.

Developed ETL framework for processing and monitoring import of flat files in SSIS for key client

Supported the company’s healthcare software functions, implementation, and training

Developed and maintained SQL queries that support data warehousing, joining data from disparate systems, healthcare analytics, and semantic and business logic application, using Tableau.

Created visualization for logistics calculation and department spending analysis using tableau.

Maintain test log and test evaluation summary reports.

Developed Database Triggers and Views, Stored Procedures and Functions.

Delivered ad-hoc reports, writing SQL Scripts and formatted with Excel using advanced excel functions: pivot tables, v-lookups, etc.

Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom

Wrote complex queries to extract data from different tables, using JOINs, Sub-queries, Correlated sub-queries and derived tables on Microsoft SQL server.

Performed data integration and configuration using SSIS.

Using MS SQL Server, I developed stored procedures, Furthermore, I executed test cases and defect management for ETL and BI systems, which culminated in improved risk management results.

Performed planning responsibilities of SDLC and monitored defect tracking system using JIRA to prioritize defect and devise a plan for future enhancements and delivered the artifacts in timely basis.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Collaborated with client and team members to understand and clarify visualization requirements using JIRA, Google drive document.

Use data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their data.

EDUCATION

Caritas University Enugu BSc. Mass Communication

Fairfax University of America MBA. Human Resources Management

Contact this candidate