Edwin Lim Email & Phone Number

Atlanta, Ga, Us

Atlanta, Ga, Us

• Pioneering the Day in the Life of (DILO) across cash management, trading room, middle office, and treasury accounting to enhance control and automation processes by 60%.• Leading the creation of RFP, mock scripts, vendor demo scorecards, and evaluation summaries to assess the effectiveness of the Reval SAAS tool for renewal.• Providing consultation and conducting market research for AI tools implementation to extract various data contracts for the risk management team. • Designing and revamping project trackers to meet target timeline yielding in 20% communication improvement with various stakeholders. • Coordinating and collaborating with Ops, IT, & PM for UPS Bank identification Code (BIC) account payment and statement migration.• Organizing and conducting training across global treasury teams for Google Looker Studio and Google Cloud Platform (GCP) utilization. • Conceptualizing and spearheading treasury balance data lake creation in GBQ using Reval API in Python to further improve data analysis by 35%.• Initiating, scoping, and constructing GL breakdown bot leveraging UI Path to cut down manual processing time from 65 to 35 minutes daily.

Atlanta, Georgia, Us

In addition to working as a Product Manager, Business Intelligence/Analytics Engineer, and CIM systems admin, I also did the following:• Altogether have coached/trained 4 new members during my time with CIM team.• Became a subject matter expert (SME) related to Carrier Invoice Management (CIM) and collaborated with other product teams (TMS, SAP, Middleware, DIP, Route Planner, EDI, Order Up, POM, COM).• Provided level 2 support when support team was unable to resolve carrier inquiries.My biggest impact in this role:1. Ideated, scoped, and addressed various initiatives and KTLO matters across CIM UI Apps, CIM React, and CIM User Rate to enhance user/customer experience (UI/UX), stability, performance, and security of carrier invoices for payments processing in SAP.2. Led product discovery and coordinated integration testing to capture missing retail cost over $150M+ from Order Up product system involving Rest API Postman & Swagger and collaborating with other product managers, engineers, DBAs, operation, and finance.3. Spearheaded TMS Facility Translation initiative in React to optimize validation accuracy and allocation finance bucket system flows by 60%.4. Mastered the internal product system efficiently & trained 2 new members within 7 months in the role.5. Constructed data modeling and simulation in BigQuery SQL and Python by implementing a new algorithm for current PO process to reduce misallocation on one-way invoices by 70% & reduce payment delays for carriers.6. Designed visualization dashboards metrics in Tableau to identify error code carrier received to reduce 25% of Zendesk Electronic Data Interchange (EDI) tickets & promote positive business relationship.7. Proposed, designed, and constructed invoice upload automation using VBA to expedite root cause discovery by 1.5 mins per row.

Atlanta, Georgia, Us

I wear a lot of hatsProduct Manager• Led the strategic development of Carrier Invoice Management using Agile/Scrum framework in collaboration with 8 engineers.• Collaborated with cross functional teams including Eng, Ops, Analytics, Finance, Supply Chain, & Support in matter relating to EDI, CIM, TMS, & SAP.• Initiated product discovery/user research, developed product roadmaps, constructed business cases and requirements, and managed prioritization of software features in Jira & Miro.• Oversaw usability testing and changes for TMS Facility Translation in React to enhance user experience by 65%.• Coordinated integration testing to capture missing retail cost over $150M+ from Order Up involving Rest API Postman & Swagger.• Reviewed user acceptance testing (UAT) prior to story deployment to ensure all requirements are met and enhance user experience (UI/UX).• Constructed SOPs and data modeling for CIM one-way, summary, dedicated, and delivery end-to-end/regression testing for engineering team.• Established strong relationship with carriers by handling Zendesk inquiries in a timely manner with 100% satisfaction rate.Analytics/Business Intelligence/Systems Engineer• Analyzed financial invoice trends utilizing Access, BigQuery SQL, & visualized SAP data in Tableau for supply chain transformation.• Reengineered current invoicing process to reduce 50% of manual task by creating data simulation in Python & BigQuery SQL.• Designed visualization dashboards metrics in Tableau to identify error code carrier received to reduce 25% of Zendesk Electronic Data Interchange (EDI) tickets & promote positive business relationship.• Constructed invoice file automation leveraging VBA to expedite root cause discovery by 1.5 minutes per row line.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: CIM (Carrier Invoice Management), TMS (Transportation Management System), EDI, Access, SQL, Python, Tableau, VBA, SAP, Jira, Miro, Confluence, Microsoft Office, Zendesk, Postman, Swagger

Ingelheim Am Rhein, Rhineland-Palatinate, De

• Constructed an automated scan with VBA to reduce manual compilation by 60% and optimized load time by 3 seconds per file. • Ideated, scoped, and launched a digital software with IT Operations team that detected lab occupancy with 55% real-time data. • Executed a digital maturity assessment to define equipment list and scope to identify potential solutions to optimize OEE calculation.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: VBA, Jira, Confluence, React, Microsoft Office

Atlanta, Ga, Us

• Directed projects related to contracting, data collection, analysis, and price negotiation resulting in a 22% increase in savings.• Revamped audit process yields in 43% communication improvement and sustained business relationships with 396 vendors. • Optimized quality data trends with VBA Excel Macros, retrieved data with MS SQL, and visualized big data with Power BI.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: VBA, SQL Server, Power BI, Microsoft Office

Atlanta, Ga, Us

• Led a cross-functional team of 4 engineers and identified root cause of operating inefficiencies to enhance productivity rates by 81%.• Optimized fulfillment processes by implementing lean six sigma principles resulting in a 56.81% reduction in wasted space.• Constructed simulation model, KPI, cost analysis, and time study to revamp existing facility to increase space utilization by 10.15%.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: Arena, Visio, Python, Minitab, Adobe Illustrator, Microsoft Office, Sony Vegas, ProCreate

Ingelheim Am Rhein, Rhineland-Palatinate, De

• Conducted market research to discover a list of 100 potential suppliers capable of manufacturing sterile injectables.• Designed and constructed an automated entry database in VBA Excel Macros for 53 internal customers and organization. • Analyzed new purchasing trends to share with the organization and created visualizations in Visio for cross-functional teams.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: VBA, Microsoft Office, Cora, DocuSign, Visio

• Provided cost estimates up to $68,000 and materials take-off based on blueprints, specifications, and related documents.• Communicated with 161 clients and vendors thoroughly to insure all items were quoted accurately and timely. • Assisted with administrative duties such as maintaining files, data entry, and entering biddable projects. • Resolved discrepancies by collecting and analyzing information in the warehouse facility.• Received, stocked, and shipped warehouse product orders and kept customers informed.𝗧𝗘𝗖𝗛 𝗦𝗧𝗔𝗖𝗞: Microsoft Office, Adobe

Dallas, Tx, Us

• Gained insights and advice on business, leadership, technology and career from business executives and recognized experts.• Acquired business and technical acumen along with personal growth and professional development.

Kennesaw, Georgia, Us

• Conducted 117 in-person and 18 virtual sessions via MS Teams for students and devised lesson plans for each session.• Marketed 135 SI sessions to increase student attendance, collaborated with supervisors, and mentored new SI leaders. • Assisted students with the mastery of Chemistry course material for advanced courses.• Guided and supported students in gaining effective study skills to achieve their academic success.• Collaborated with supervisor and professor to develop new strategies to improve sessions.

Kennesaw, Georgia, Us

• Tutored individuals and groups in basic Algebra and Calculus.• Assisted students with understanding math assignments to be successful in the course.• Addressed students queries in a timely manner to deliver exceptional service. • Maintained records of each tutoring session to comprehend student performance. • Developed and effectively taught study skills in working with students.

Atlanta, Georgia, Us

• Greeted customers in a pleasant and courteous manner and assisted the company maintain an A grade in accordance with the FDA.• Made drink orders according to customer requests and delivered exceptional customer service. • Completed all cleaning, sanitizing, stocking, and organizing tasks in assigned area.• Conducted periodic inventories and followed all company operations policies and procedures.• Operated cash register and conducted successful cash audits at the end of each shift.

Bachelor Of Science - Bs, Industrial & Systems Engineering

Diploma