VICTOR OJO

ady4bf@r.postjobfree.com

240-***-****

ACTIVE SECRET CLEARANCE

PROFILE

As a dynamic IT professional with a proven track record of success, I bring over three years of experience across diverse industries such as healthcare and finance. I am an expert in data visualization, data analysis, data cleansing, data manipulation, and data extraction, with a strong focus on solving complex problems. Whether it is reporting or researching, I possess the ability to work with various formats and sources. Additionally, I have a keen eye for detail and can learn and utilize in-house databases and systems to maintain the strategic vision of an organization. My expertise extends beyond technical proficiency, and I can perform multiple duties in business analysis, project or program management, and functional leadership. I thrive in collaborative environments and excel as a team player, effectively working with diverse groups to achieve shared objectives.

SKILLS/ EXPERTISE

Data analysis and exploration.

Statistical knowledge.

Creating data visualizations.

Creating dashboards and reports.

Writing and communication.

Domain knowledge.

Problem solving.

Fraud Monitoring

Quality Assurance

TECHNICAL SKILLS

Business Intelligence tools

Tableau Desktop, Power BI, Excel and PowerPivot, MicroStrategy, SSRS

Querying language

SQL, PL/SQL, TSQL, PYTHON, SAS

Querying tools

SQL Management Studio, SQL Plus, SQL Developer, PL/SQL

ETL/Other Tools

SSIS, Tableau Prep, SAS Base, SAS Enterprise Guide, SSIS (Visual Studio), Jira, Erwin Data Modeler, ER Assistant

Databases

MS SQL Server, Teradata, MySQL, Oracle, DB2

Cloud Computing Tools

Snowflake, AWS, MS Azure, Tableau Server

PROFESSIONAL EXPERIENCE

CIGNA HEALTHCARE WILMINGTON, DE (REMOTE)

DATA ANALYST

FEBRUARY 2022 – MAY 2023

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

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

Analyze duplicated data or errors in data to provide appropriate inter-departmental communication and monthly reports.

Develop and deploy reports to provide operational and analytical information to administration, interpret data, analyze results, and construct ongoing reports by leveraging SQL.

Using data integration skills to gather data from different sources and analyze

Develop queries to retrieve and analyze data from various sources for projects or reports.

Develop, validate, publish, and maintain LOGICAL and PHYSICAL data models using Erwin Data Modeler.

Involved in project management in different areas.

Use SAS for data mining and help with visualization.

Evaluate existing data models and physical databases for variances and discrepancies.

Develop several operational reports using Tableau.

Write standard SQL Queries to perform data validation and document summary reports on excel (Pivot tables and Charts).

Create Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.

Ensure that data warehousing design was scalable and maintainable.

Use SAS to facilitate analysis and also report.

Utilize tableau for visual analytics and dashboard developments.

HOWARD BANK BALTIMORE, MD

TABLUEA DEVELOPER / DATA ANALYST

APRIL 2020 – JANUARY 2022

Executed extensive data validation by writing several complex SQL queries and involved in backend testing to address data quality issues.

Use SAS for unified data management.

Helping in project management and negotiation

Wrote complex SQL queries using advanced SQL concepts like Aggregate functions.

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

Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server.

Developed Data mapping, Data dictionaries between sources to target data models.

Provide accurate data set using data integration skills and also combine to create a unified set.

Analyzed reporting requirements and developed various Dashboards.

Extracted, transformed, and loaded data directly from different source systems like flat files, Excel, Oracle, and SQL Server.

Use SAS to optimize reporting procedures.

Help to make effective decisions with use of SAS.

Created various views in Tableau (Tree maps, Heat Maps, Scatter plot).

Created filters, LOD, calculated fields and parameters in Tableau.

Leveraged statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.

EDUCATION

PRINCE GEORGE’S COMMUNITY COLLEGE

INFORMATION TECHNOLOGY

Contact this candidate