FOLAKE AKANBI

Surprise, AZ 623-***-**** adg9dh@r.postjobfree.com

Business Intelligence and data analytics professional with multiple years of experience in architecting and developing impactful solutions with cross-organizational return on investment. Highly motivated with strong SQL, data analytics, and reporting skills with a commitment to ensure strong operations and quality control SUMMARY

• Experience providing Business Intelligence and Database Development using SQL Server

• Expertise in data modeling, database design, SQL programming, data analysis, and business reporting

• Experience with business reporting and analytics using Excel, Power BI, and SPSS

• Years of experience using statistical methods to generate insights and visualizations from data TECHNICAL EXPERTISE

T-SQL

VBA

Microsoft Excel

DAX

Power BI

SPSS

MS ACCESS

STATA

PROFESSIONAL EXPERIENCE

Maricopa County Sheriff’s Office (MCSO) Phoenix, AZ 2018 - Present Analyst

• Created data analytic solutions using MS Access, SQL, Excel, and SPSS to provide comparative analysis of traffic stops and related operations; These solutions provided actionable insights into activity patterns by law enforcement agents.

• Extracted data from disparate sources (Traffic and Criminal Software and Computer Aided Dispatch applications); Transformed & cleansed data using Excel formulas; performed complex statistical analysis using SPSS / STATA; built interactive reports and dashboards in Excel for analytics and reporting purposes.

• Wrote complex SQL Statements to extract and transform data from transactional databases.

• Created standard and ad hoc reports using Excel and SQL for research and analytical purposes.

• Created multiple VBA scripts to automate transformations and report delivery of Excel based reports

• Built Interactive Power BI reports that displayed pertinent metrics like traffic stop length, types, reasons, and outcomes. These metrics are sliceable across multiple dimensions.

• Worked closely with business units to define and implement key performance indicators that are in alignment with departmental objectives to compare metrics against goals.

• Conducted outlier research pertaining to traffic stop operations; generated data-driven recommendations based on quantitative research.

• Performed data validation efforts in collaboration with the IT team members to identify and resolve any data anomalies. This involved writing queries against the data sources using SQL.

• Participated in strategic discussions and special project meetings with MCSO staff - the Monitor team - and contracted entities to identify reporting opportunities; performed data profiling and research analysis to facilitate better decision-making during meetings.

• Created data dictionary and data mapping documents documenting all data sources and transformations. PAGE 2

Arizona Department of Juvenile Corrections Phoenix, AZ 2007 - 2018 Corrections Officer

• Maintained safety and security in a secured facility; implemented behavior management techniques.

• Generated incident reports; maintained logs of daily activities.

• Maintained order and discipline within assigned areas in accordance with relevant rules and regulations.

• Performed a variety of technical activities involved in registering detainees, inventory management, and filling out required forms, reports, and logbooks.

• Supervised detainee activity, ensuring that safety and health needs are met, and behavior complies with established rules, regulations, and guidelines.

The Polytechnic Ibadan Ibadan, Nigeria 1994 - 2004 Lecturer (Statistics)

• Taught Biometrics, Operations Research, Demography and Social Statistics, Applied General Statistics, and Industrial Statistics.

• Supervised students’ project work and evaluated academic performance.

• Collected and analyzed data using SPSS; participated in various data science related conferences.

• Performed advisory role for students.

• Engaged in team research projects.

EDUCATION

MSc., Evaluation, Research & Measurement Capella University, MN 2015 - 2018 BSc., Statistics University of Ibadan, Nigeria 1988 - 1992

Contact this candidate