Anthony Ly Email & Phone Number

Toronto, Ontario, Canada

• Implemented forecasting models utilizing Python, Pyspark, NumPy to achieve precise and efficient financial predictions.• Converted Pyspark calculations to Pandas within proxy which reduced proxy run time by 75%• Automated permissions management with Django and Python, streamlining workflow and reducing manual workload for permissions assignment tasks• Refactored legacy SAS code to seamlessly integrate with existing Python infrastructure, ensuring smooth transition and enhancing overall system efficiency.

Toronto, Ontario, Canada

• Collaborated with the Project Manager to efficiently manage sprints and conduct daily scrums.• Meticulously documented data flow and usage across all files, ensuring compliance and security standards were upheld.• Crafted comprehensive business requirements for forthcoming releases, ensuring alignment with business objectives and clear understanding for developers.

Toronto, Ontario, Canada

• Automated updates for the COVID-19 heatmap, reducing the weekly runtime from 4 hours to 65 seconds through the optimization of over 300 steps, resulting in significant time savings and increased efficiency.• Developed scripts to automate report preparation, freeing up team capacity and enabling focus on higher-value tasks.• Updated reports, eliminating reliance on Tableau and ensuring a smooth transition for future employees, enhancing accessibility and reducing dependency on specific tools.• Conducted data extractions and generated reports using SAS, AQT, and SQL, facilitating comprehensive analysis and decision-making processes.

• Maintained database integrity by swiftly identifying and rectifying discrepancies in S/4 Hana or SAPGUI through meticulous entry comparisons in Excel.• Enhanced efficiency by over 30% through the implementation of a dashboard aiding in S/4 user access requests and generating weekly access management reports.• Spearheaded and supervised a comprehensive data entry project for S/4 Hana, overseeing updates for more than 6,000 profit and cost centers.• Conducted daily SQL queries in Hadoop to generate reports on entry variances, ensuring data accuracy and consistency.

• Conducted thorough research, interpretation, and analysis of data to produce client reports, proposals, and analytics, ensuring accurate and insightful deliverables.• Developed job listings with precision and attention to detail, aligning closely with clients' specifications and requirements.• Achieved a 25% reduction in data input and validation time by introducing new Excel worksheets featuring Pivot Tables, VLOOKUP, and Slicers for enhanced efficiency.• Updated and crafted client profiles using HTML, employing a meticulous approach to ensure high-quality deliverables consistently meet excellent standards.