Data Analyst Real Estate

Opeyemi Komolafe

Email: *********@*****.*** Address: College Park, Md 20740

Phone: 240-***-****

Professional Summary

Experience working in the Healthcare, and Real Estate domains.

7+ years of Sales/Marketing and Real Estate Management.

4+ years of Data Analyst experience.

Experience working in Scrum and Agile environments.

Experience using MS Excel, SQL, and other applications to perform various types of analysis.

Skilled in Microsoft Access, PowerPoint, SQL Server, and various RDBMS.

Experience with BI tools such as Tableau and PowerBI.

Proficient in Data Analysis, Business Requirements Gathering, and Data Warehousing concepts.

Experience with collaborative tools such as JIRA.

Knowledge of Power BI and Tableau to import and analyze data from various sources such as SQL Server.

A good team player will have great presentation and analytical skills.

Skilled in understanding Business Requirements and executing as required.

Create various filters and parameters for reports using Tableau desktop.

Skilled in Microsoft Excel (formulas, pivot tables, graphing, Vloookup, Xlookup).

Experience in data migration tasks using PL/SQL, and SQL Loader.

Experienced in Data Migration, Data Transformation, Data Conversion, and Data loading.

Proficient in communication and can deliver prompts on assigned duties.

Data Analyst

Adventist Healthcare,

Rockville, MD June 2019 to Present

As a data analyst currently supporting the analytics service team on a continuous task of provider/member attribution. My focus is to ensure the provider and member attribution reports are prepared bi-weekly and ensure the report's accuracy. Part of the quality assurance check (QA) is ensuring members are attributed to providers appropriately based on their zip codes and identifying providers with assigned members. I also pull claims reports, enrollment, and disenrollment reports which are based on business requirements. I also use Excel functions to generate spreadsheets and pivot tables, skilled in Microsoft Excel (formulas, pivot tables, graphing, Vloookup, Xlookup).

Skills: Healthcare · Presentations · Data Visualization · Dashboards · Analytical Skills · Microsoft Power BI · Statistical Data Analysis · Customer Relationship Management (CRM) · Data Warehousing · Automation · PostgreSQL · Managed Care · Provider data · Provider attribution · Agile Methodologies · Communication · Presentation Skills · Microsoft PowerPoint · SQL · Tableau · Microsoft Excel · Requirements Gathering · Healthcare Analytics

Create the providers-members attribution monthly.

Work on claims report identifying submitted claims as against the clean claims.

Create and run queries as necessary for project deliverables using SQL.

Evaluate data pulled for accuracy and relation to data requests.

Support the leadership team in explaining and disseminating information to appropriate stakeholders.

Experience in writing queries to pull claims and do root-cause analysis.

Develop statistical methods to evaluate and analyze numerical data using computer software, including MS Access, MS Excel, Oracle, SQL, and/or other applications, for assigned projects.

Develop innovative analytical approaches and predictive modeling techniques for reactive or proactive data analysis, sampling, and study design.

Work with the team in data collection to be used for Tableau visuals.

Develop trend reports to identify potential programs or systematic vulnerabilities.

Represents and participates in group or committee discussions.

Involve in designing and creating Tables, Views, complex Stored Procedures, and Indexes using T-SQL.

Data Profiling for accurate and better reporting and analysis.

Data Analyst

Apple Federal Credit Union,

Falls Church, VA Jan 2019 to June 2019

I worked with the risk management team on a credit classification project. My main task as a data analyst was to work with the recovery unit to help in the reclassification of current risk assets to identify standard, substandard, and loss credits.

Extracted, compiled, and tracked data, and analyzed data to generate reports.

Performed daily data manipulation using SQL and prepared reports on a weekly, monthly, and quarterly basis.

Used Excel functions to generate spreadsheets and pivot tables.

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

Cleansing and blending multiple data sources to allow for different views on application data in a single dashboard.

Aided team in data collection to be used for PowerBI visuals.

Perform data manipulation operations like import/export data from various external file formats using SQL.

Generated a variety of business reports from SQL server using Excel with pivot table and pivot chart.

Perform data manipulation operations like import/export data from various external file formats

using SSIS.

Develop, update, and maintain current SQL programs.

Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.

Acquire data from primary or secondary data sources and maintain databases/ data systems

Project Manager/Scrum Master

Landmark Corporate Realty Limited

Lagos, Nigeria July 2012 to Dec 2018

Administer overall day-to-day operations including supporting Agile and Scrum ceremonies consisting of iteration planning, grooming, daily stand-up, iteration retrospective, and iteration review. Accredit to track and report progress to key stakeholders via scrum metrics such as Visual Studio, velocity target updates, and release/iteration Burndown.

Engaged with investors and technical teams to proactively identify and document project requirements and process flows. Assist team members in mitigating roadblocks, impediments, risks, and backlog grooming, ensuring smooth operational flow. Oversaw various daily operations, including providing timely resources, information, and practical advice to ensure the team's regular delivery of working software.

Ensured on-time tracking and reporting of team velocity and sprint/release progress while overcoming delays.

Credited for identifying and removing impediments with a focus on completing the sprint goal as well as assisting teams in making appropriate commitments.

Efficiently supported product Owner while prioritizing the product backlog to maximize value as well as executed creative techniques to improve user stories for the upcoming 1-2 Sprints.

Directed and deployed Agile training to development teams mainly through end-to-end coaching.

Identified areas of improvement, mitigated risks, resolved issues, and implemented corrective actions.

Conducted successful pre-grooming sessions with the product owner to prioritize the product backlog and a populated backlog efficiently.

Plan and Develop Real Estate project ideas.

Every project starts as an idea and is executed with teamwork.

Create Leads and actively work on delivering as requested by Investors/Stakeholders.

Monitor Project Progress and work with Deadlines.

Ensure Stakeholder Satisfaction

Evaluate Project Performance

Education

Masters in data Analytics (In progress)

University of Maryland Global Campus, United States.

Graduate Certificate in Business Analytics

University of Maryland Global Campus, United States.

Bachelor in Pure Mathematics

Olabisi Onabanjo University, Nigeria

Certified SQL Data Analyst Certified Scrum Master

Applications

T-SQL, Microsoft Word, Microsoft Excel, Microsoft Access, Tableau, PowerBI, Python, JIRA.

Contact this candidate