Data Analyst with Secret Clearance)
Resume:
VICTOR OJO
**********@*****.***
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
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.
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).
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. Prestige Healthcare MD
TABLUEA DEVELOPER / DATA ANALYST
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. Military Experience
Worked with different branches of the military and leading missions with positive results Watched over Marines and ensured their safety
Use tactical training and understanding to perform various rigorous duties Entrusted with military gear worth thousands of dollars EDUCATION
PRINCE GEORGE’S COMMUNITY COLLEGE
INFORMATION TECHNOLOGY
Towson university
Information Technology
Contact this candidate