Business Process And Systems Analyst
Us
My role here encompassed the design of business procedures and workflows, conducting comprehensive studies and audits of information and database systems to ensure compliance and efficiency. I provided application support for system security, and imparted training to staff on payroll, financial, and personnel management systems. This role also involved formulating well-informed recommendations for policy enhancements and procedures concerning information systems.Some noteworthy achievements and contributions include:• Created an Excel-based application to automate importing financial data from a division's software into the ERP.• Overhauled and revamped the process for reconciling a division's revenues by utilizing PowerShell and SQL, which allowed for on-demand reconciliation of the entire chart of accounts.• Eliminated hundreds of hours of work per quarter previously spent tracking, reporting, and reconciling a division's revenues, cash receipts, and KPIs by building applications and reports in PowerShell, Excel, and SQL.