Freelance Data/Tender Analyst (Remote Part-time)
Local Partner Ltd
Total des années d'expérience :10 years, 6 Mois
• Gather technical and business requirements for data analysis, visualization, and automation.
• Provide creative alternatives and recommendations to reduce costs and improve financial performance.
• Enhance the Pricing Report by automating through Excel / VBA and Power BI (Power Query/Dax) and reduce the time preparation to 70% and increase efficiency.
• Investigate the anomalies and perform data quality in the Price Database and communicate and present to the internal stakeholders for actions.
• Identify the pricing discrepancies and address it to the suppliers.
• Gathered technical, functional, and systematic requirements from various internal and external stakeholders in support of the analytical projects.
• Performed financial (P&L) and non-financial reports in support of the CST in New York.
• Performed data quality or investigate on financial reports published on a regular basis, challenge figures and ensuring completeness, consistency and accuracy of the data including HR software PeopleSoft.
• Optimized the financial and non-financial reports by creating data models in Alteryx, MS Excel, and Power BI (DAX/Power Query).
• Developed ETL Loader in preparation for uploading data in Perseus using Alteryx.
• Assisted CST in New York in budget and forecast exercises.
• Provided direct support to the Assistant Executive Director/Head of Quality and department in the performance of a wide variety of data analysis and regulatory program projects.
• Analyzed and visualized local hospital data using MS Excel with the aid of Power Query and VBA.
• Performed clinical data quality validation as per the Joint Commission International (JCI) standards.
• Performed a hospital-wide data analysis in their admission, discharges, and rehabilitation programs.
• Provided training to the staff on how to use the monitoring tools developed in MS Excel and Life QI.
• Communicate and present to the staff the data anomalies related to their department data.
• Take lead on creating/maintaining databases for current/future projects.
• Making improvements reporting on the reporting process using MS Excel, MS Access and Visual Basic.
• Primary responsible on daily margin management and monitor the company’s sales or profit record.
• Lead person in providing regular reporting for KPIs, operational metrics, scorecards, dashboards and other efforts.
• Provides analysis of operational metrics define, refine and/or report on key operational metrics.
• Supports weekly, monthly and quarterly business reviews covering financial and nonfinancial metrics, including performance against stated objectives.
• Main person in providing reports that is tailored to the needs and requirements of the audience.
• Support ad hoc report and/or ad hoc strategic efforts/projects.
• Participates in efforts to maintain quality, coverage and relevance of reporting while streamlining and automating report creation process.
• Provided regular reporting for KPIs, operational metrics, scorecards, dashboards, and other efforts using google sheets and MS excel.
• Provided analysis of operational metrics define, refine and/or sales report on key operational metrics.
• Led in creating/maintaining databases.
• Performed a daily check on margin in the system and eliminated the erroneous pricing entered by some staff.
Bachelor of Science in Information Technology