Business Process Power Bi

KEVIN MATTHEW DALLY

Springfield, IL ***** • 217-***-**** • ************@*****.***

EDUCATION

University of Illinois, Springfield: Management Information Systems (MSc) Graduated: May 2025 Relevant Coursework:

System Analysis & Design, Business Process Management, Cybersecurity Management, Data Analytics, and Information Security. Designed and deployed a relational database using Oracle APEX for data-driven applications. Built dashboards and visualizations using Power BI to present trends and insights for real-world datasets. Analyzed and transformed structured/unstructured datasets using SQL and Python (pandas, matplotlib). Conducted data audits and statistical analysis as part of research-based academic projects. Business & Administrative Tools:

Microsoft Office Suite (Excel, Word, Outlook, PowerPoint), Google Workspace, Case Tracking Systems, E-Verify, ACT Calendar, Report Writing Operations & Process Support:

Business Process Documentation, Onboarding Coordination, Internal Audit Support, Active Directory Access Review Data & Analysis (Foundational Exposure):

Oracle APEX, SQL, Tableau, Power BI, KPI Development, Data Cleansing, Trend Analysis, SAS, Python (pandas, matplotlib) Security & Compliance:

CompTIA Security+ (Certified), NIST SP 800-53, ISO 27000 Standards Certification: ARIS Business Process Analysis, Web Programming using PHP, Microsoft SQL Server Database Administration, CompTIA Sec + WORK EXPERIENCE

Illinois Department of Innovation and Technology Springfield, Illinois IT Security & Compliance Feb 2024 - Present

• Developed and implemented an automated workflow integrating Excel and SailPoint, optimizing access validation and training staff

• Conducted quarterly review of Active Directory Accounts and Physical Facility Access, monitored identity and access management for appropriate permissions and authorization

• Assisted in monitoring state agencies’ adherence to IT security policies, standards, and regulatory frameworks (ISO 27000, NIST 800-53) and privacy regulations, and ensured adherence to security frameworks and regulatory compliance

• Developed statewide security control standards and conducted risk assessments for Illinois state government agencies

• Researching security enhancements and making recommendations to management Africa Education Watch Accra, Ghana

Research Associate Feb 2022 – May 2023

• Led Open Governance research and developed KPIs to evaluate education sector accountability and financial efficiency

• Joined cross-functional teams projects, applying data analysis techniques to create valuable insights for clients and internal stakeholders

• Develop a SWOT analysis of the sustainability strategies already implemented using data analytical charts in Microsoft Excel

• Assisted in IT infrastructure management, including network setup and system security, ensuring reliable performance Publications : 3rd Edition of The Open Governance Index Report on Education Sector Institutions in Ghana Ministry of Gender, Children and Social Protection, IT Division Accra, Ghana Quality Assurance Analyst/ Data Associate April 2020 – Dec 2021

• Researched rural areas, developed KPIs, and maintained metrics to guide fund disbursement and drive improvements

• Used data visualization tools like Excel and Tableau to present insights and progress reports

• Led the successful implementation of a document control system, improving the accuracy and accessibility of quality documentation by 20% Stanbic Bank Accra, Ghana

Business Solutions Associate Feb 2019 – Aug 2019

• Developed sales and marketing strategies to drive financial product sales through data-driven strategies and customer-focused policies

• Collaborated with diverse clients to deliver tailored IT and business solutions meeting their needs

• Drove a 25% sales increase, generating $20,000 in revenue by aligning strategies with market demands Council for Technical and Vocational Education (COTVET) Accra, Ghana Monitoring and Evaluation Intern Jul 2018 – Jan 2019

• Conducted data collection and analysis on beneficiaries of World Bank, African Development Bank, and DANIDA-funded skills development projects

• Analyzed data using tools like Excel and Power BI and generated reports to influence decision-making

• Designed KPIs, conducted field visits, and provided insights to enhance vocational training programs and project outcomes PROJECTS

Integrated Business Process Modeling and Optimization with ARIS for United Motor Group (UMG)

• Used SAP & ARIS Architect to model United Motor Group's core processes, improving BPM and optimization Predicting factors that Influence Customer Purchasing on Amazon

• Conducted exploration and predictive analysis on Amazon sales data in the USA using SAS Enterprise Miner & Tableau StratusAI – AI-Powered Cybersecurity Awareness Simulator

• Capstone pitch presented to the Dean’s Advisory Board at the University of Illinois Springfield (May 2025)

• Designed an adaptive training tool that simulates phishing threats and password hygiene using AI-generated scenarios

• Focused on real-time feedback, user behavior tracking, and gamified cybersecurity awareness

Contact this candidate