Client: Kaizen Collision
Tech Stack: Node.js, HTML, CSS, SOAP API
Challenge:
Retrieve information about employees assigned to tasks at various centers and generate a comprehensive paysheet, including employee details, team-based breakdowns, hourly deductions, and total pay calculations.
Solution:
Developed a Node.js script that utilized two sources of information—CCC One SOAP APIs and Paycom REST APIs—to retrieve data and generate detailed paysheets.
Outcome:
Successfully generated paysheets for employees, streamlining the payroll process.
Client: Accrual Equity Group
Tech Stack: Excel, PowerPoint, SharePoint
Challenge: Developed a comprehensive financial deck covering financial reporting for both current and prospective locations from 2024 to 2028. Managed large-scale datasets, conducted detailed financial analysis, and translated finalized insights into visually compelling PowerPoint presentations for executive review.
Outcome: While the project was successfully completed, the initial lack of a structured plan led to a somewhat disorganized approach, making project management challenging. As a result, additional hours were required to finalize the deliverables. However, this experience proved to be a valuable learning opportunity—highlighting the importance of upfront planning and task organization. These lessons significantly improved our efficiency in subsequent projects, particularly during the more effectively managed Accruals Financial Package engagement.
• Client: Kaizen
• Tech Stack: Excel, ERP System (Oracle NetSuite), MS Teams (for collaboration)
• Challenge:
Kaizen’s Accounts Payable ledger was overstated by nearly five times the actual liability due to thousands of duplicate invoice bookings and incorrect payment entries across hundreds of vendor accounts. This posed significant risks to accurate financial reporting and cash flow management.
• Solution:
I led the end-to-end reconciliation of the AP ledger, including:
– Identifying and removing duplicate transactions
– Reversing incorrect entries through accurate accounting adjustments
– Validating balances with vendors and internal teams
– Standardizing AP booking practices to prevent future errors
• Outcome:
– Successfully restored AP to its accurate level
– Prevented financial overstatements and enabled recovery of funds
– Saved the client millions of dollars through proper adjustments
– Received appreciation from both the client and internal leadership for precision and diligence
Quick Insights
• Most Challenging Project: Accounts Payable Reconciliation and Recovery – due to the volume of data, complexity of vendor relationships, and the high financial risk involved.
• Innovation Spotlight: Developed a streamlined method to identify and remove duplicate vendor entries using Excel and system-generated reports, significantly accelerating the reconciliation process and improving audit readiness.
Client: Kaizen Collision
Tech Stack: Node.js, HTML, CSS, SOAP API
Challenge:
Retrieve information about employees assigned to tasks at various centers and generate a comprehensive paysheet, including employee details, team-based breakdowns, hourly deductions, and total pay calculations.
Solution:
Developed a Node.js script that utilized two sources of information—CCC One SOAP APIs and Paycom REST APIs—to retrieve data and generate detailed paysheets.
Outcome:
Successfully generated paysheets for employees, streamlining the payroll process.
Client: Kaizen Collision
Tech Stack: Node.js, HTML, CSS, SOAP API
Challenge:
Retrieve information about employees assigned to tasks at various centers and generate a comprehensive paysheet, including employee details, team-based breakdowns, hourly deductions, and total pay calculations.
Solution:
Developed a Node.js script that utilized two sources of information—CCC One SOAP APIs and Paycom REST APIs—to retrieve data and generate detailed paysheets.
Outcome:
Successfully generated paysheets for employees, streamlining the payroll process. 
Client: Accrual Equity Group
Tech Stack: Excel, PowerPoint, SharePoint
Challenge: Developed a comprehensive financial deck covering financial reporting for both current and prospective locations from 2024 to 2028. Managed large-scale datasets, conducted detailed financial analysis, and translated finalized insights into visually compelling PowerPoint presentations for executive review.
Outcome: While the project was successfully completed, the initial lack of a structured plan led to a somewhat disorganized approach, making project management challenging. As a result, additional hours were required to finalize the deliverables. However, this experience proved to be a valuable learning opportunity—highlighting the importance of upfront planning and task organization. These lessons significantly improved our efficiency in subsequent projects, particularly during the more effectively managed Accruals Financial Package engagement. 
• Client: Kaizen
• Tech Stack: Excel, ERP System (Oracle NetSuite), MS Teams (for collaboration)
• Challenge:
Kaizen’s Accounts Payable ledger was overstated by nearly five times the actual liability due to thousands of duplicate invoice bookings and incorrect payment entries across hundreds of vendor accounts. This posed significant risks to accurate financial reporting and cash flow management.
• Solution:
I led the end-to-end reconciliation of the AP ledger, including:
– Identifying and removing duplicate transactions
– Reversing incorrect entries through accurate accounting adjustments
– Validating balances with vendors and internal teams
– Standardizing AP booking practices to prevent future errors
• Outcome:
– Successfully restored AP to its accurate level
– Prevented financial overstatements and enabled recovery of funds
– Saved the client millions of dollars through proper adjustments
– Received appreciation from both the client and internal leadership for precision and diligence
Quick Insights
• Most Challenging Project: Accounts Payable Reconciliation and Recovery – due to the volume of data, complexity of vendor relationships, and the high financial risk involved.
• Innovation Spotlight: Developed a streamlined method to identify and remove duplicate vendor entries using Excel and system-generated reports, significantly accelerating the reconciliation process and improving audit readiness.