Joseph Alogwu

• Coordinated statistical data analysis, design and information flow.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Participated in requirements meetings and data mapping sessions to understand business needs.

worked as a member of the data analytics team on a process improvement project. My role as a data analyst is to report and uncover meaningful insights on the activities of the various providers.

Create and run queries as necessary for project deliverables using SQL
Work closely with the Risk, Team Leads, and Stakeholder to come up with a plan to effectively find the correlation of at-risk enrollment behaviors.
Evaluate data pulled for accuracy and relation to data requests
Support leadership team in explaining and disseminating information to appropriate stakeholders
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
I Develop innovative analytical approaches and predictive modeling techniques for reactive or proactive data analysis, sampling, and study design
Develop trend reports to identify potential program or systematic vulnerabilities
Provide expertise and guidance to unit and corporate staff as required
Represents and participates in group or committee discussion
Involve in designing and creating Tables, Views, Complex Stored Procedures and Indexes using T-SQL
Improve query performance
Data Profiling for accurate and better reporting and analysis

• Identified and documented detailed business rules and use cases based on requirements analysis

Extracted, complied and tracked data, and analyzed data to generate reports
Participated with troubleshooting, and problem resolution efforts
Performed daily data manipulation using SQL and prepared reports on 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
Perform data manipulation operations like import/export data from various external file formats using SQL/SSIS
Generated variety of business reports from SQL server using excel with pivot table and pivot chart
Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical and quality
Checked for invalid/out of range data
Develop and implement database, 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