Data Analysis and Reporting:● Lead in data reporting transformation to Power Bi & SSRS platform.● Develop machine learning models in Python to forecast important KPIs.● Collect and maintain multiple sources of data and perform ETL process in Power Bi and translate them into powerful and meaningful reports.● Develop, update and maintain Tribunal data and reporting systems, including dashboards and regular reports.● Identify data requirements and organize relevant data to produce statistical products and reports.● Provide operational data and conduct analysis for branch/business clients.● Partner with colleagues to deliver production and caseload information reports.● Develop and improve legacy SQL queries for data extraction and reporting.Business Analysis:● Partner with senior management team in identifying clients' business requirements for application and reports development.● Collaborate with ITS Infrastructure colleagues with business analytics initiatives and services.● Provide technical support for business data analytics and information management projects.● Develop key performance indicators for assessing the effectiveness of business analytics projects.● Conduct daily case data cleaning to maintain database integrity.● Provide feedback and suggestions for improving workflows and applications.Data Systems and Application Support:● Provide guidance and support during system development projects to ensure data feasibility and compatibility.● Develop, debug, and test complex applications for database management functions.● Communicate with system users and managers to ensure proper utilization of case management applications and accurate data recording.● Offer solutions and on-site expertise to end users encountering data-related issues.Training:● Customize training materials for user groups regarding case management information and reporting tools.● Deliver training sessions on in-house Case Management and related systems.

- Engaged in a collaborative effort with the Management Team, departmental supervisors, and general users to analyze the company's workflow, leading to the design of a new database schema. Subsequently, obtained approval to develop the highly successful in-house ERP system known as WEBIS.- Implemented the comprehensive functionalities of WEBIS across all departments, streamlining day-to-day tasks, including CRM, Employees Management, Quotations, Orders, Invoices, Payments, Purchase Orders, Inventory, Costs Tracking, Sales, Reports, Shipping, and Receiving.- Worked closely with the Accounting Manager to analyze accounting data in QuickBooks and seamlessly migrated it to the WEBIS platform.- Devised efficient procedures for transferring transactions from WEBIS to MoneyWorks (Account Payable software).- Conducted training sessions for Accounts Receivable and Accounts Payable users, imparting essential skills in sorting, analyzing, and reconciling data using FileMaker and Excel, thereby facilitating reporting and data transferring processes.- Collaborated with the Management Team and departmental supervisors to develop robust data reporting mechanisms.- Held responsibilities for administering the database server, ensuring stringent security measures, and implementing regular backup procedures.- Skillfully managed software, licensing, upgrades, and installation processes to ensure smooth system operations.

- Implemented automated processes to significantly improve the efficiency of placing newspaper ads.Developed a powerful Visual Basic Studio program capable of processing hundreds of ad artworks within minutes.- Successfully executed database enhancements, migration, and upgrades to the latest FileMaker version.Devised a layout map that facilitated seamless coordination between the Ads Design and Layout Design groups for articles and ads.- Created a comprehensive database system to manage daily tasks, encompassing orders, billing, payments, reports, sales, classifieds, and seamless integration with the online website.- Collaborated closely with all departments to develop robust data reporting mechanisms.- Assumed responsibility for administering the Database server and meticulously managing security and backup procedures.- Provided extensive support and training to users for efficient database management and associated applications.- Efficiently handled software, licensing, upgrades, and installation processes to ensure optimal system performance.