Robert Simcoe Email & Phone Number

Kansas City, Mo, Us

Herndon, Va, Us

Assists budget managers who are responsible for $200 mil of revenue update their budget and forecast. Generated monthly reporting using Adaptive Insights, NetSuite, and Office Connect.Responsible for managing the headcount model on a daily basis within Adaptive Insights to ensure budget and forecast are always synced with the HRIS system.

Kansas City, Kansas, Us

Used Adaptive Insights to prepare the budget and quarterly forecast for a division of Granite generating over $140 mil + of revenue each year. This included 30 offices divided between four regions.Responsible for the distribution of daily/weekly/monthly financial reporting for the entirety of Layne Christensen. Used Power BI to build a financial model that helped Layne leadership make strategic decisions for purchasing new equipment and where that equipment should be located to maximize ROI.Assisted with the month end closing process by using excel to automate several accrual processes and generate the journal entries for uploading into JD. Edwards.Performed ad-hoc analysis as requested by company leadership using a variety of resources; Microsoft Dynamics, Adaptive Insights, JD. Edwards, and Excel.

Kansas City, Mo, Us

Collaborates with the global finance department to identify opportunities to improve processes, identify possible roadblocks, and vet technology from a usability standpoint. Leverages creative approaches and quantitative skills to answer business and strategy questions for key stakeholders. Partners with Water.org’s foreign offices to review and prepare their yearly budget, give monthly variance explanations, and update their monthly forecast using Adaptive Insights. ​Key Accomplishments: ● Partnered with our CFO to create a leadership dashboard using Power BI to track key metrics that are reviewed monthly by executive leadership. ● Provides key support for an organizational initiative to create a new fintech app. Support includes developing a business model, using Power BI for KPI tracking, legal compliance, accounting support, day-to-day support with a project manager/development team and managing our relationship/contract with our banking as a service provider. ● Uses Power BI to support the organization with various ad-hoc data analysis projects such as time sheet analytics, marketing reporting and COVID19 reporting.

Kansas City, Mo, Us

● Performed internal audits of the African and Latin American offices. Assessed office compliance with the policies and procedures laid out in Water.org’s internal foreign office accounting manual. ● Partnered with the African and Latin American region accountants to ensure that their monthly financials are processed in an accurate and timely manner. Reviewed accounting entries to ensure compliance with GAAP and donor restrictions. ● Evaluated and implemented expense reporting and time sheet reporting software in 7 countries while working remotely from Kansas City. This implementation replaced excel files and manual workflows by utilizing systems that integrated with QuickBooks Online, saving both our accountants and office staff time, allowing them to spend more time focusing on Water.org’s mission.

Boston, Massachusetts, Us

● Worked as an independent contributor supporting one of the insurance services departments most challenging clients. ● Managed the client mailbox, assigning client inquiries out to fund administrators and resolving client inquiries as needed. Client inquiries ranged from book yield, general ledger feeds, and Schedule D reporting. ● Worked on a special project dealing with collateralized loan obligations and how to correctly account for these securities following GAAP consolidation guidance.

Boston, Massachusetts, Us

Manages the client mailbox and works to resolve all ad-hoc client inquiries ranging from book yield questions, GL Feed issues/entries, and Schedule D reportingManages the monthly closing process ensuring all client deliverable deadlines are meet while providing accurate accounting data.Effectively facilitates weekly/monthly calls with the client and shared services.Works on various projects on a month-to-month basis relating. (Cash flow testing, yield analysis, reporting enhancements)

Boston, Massachusetts, Us

General Accounts ResponsibilitiesReview daily work completed by the fund accountants and ensures everything is accurate.Helps assist the Senior Associates in resolving ad hoc inquiries from the client, monitoring the client mailboxes, and working on various projects throughout the month.Completes new portfolio requests, process transfer, and performs high level processing for various clientsCompletes monthly general ledger reconciliations to ensure all activity for the month has been accounted for correctly. Researches any differences and resolves any issues.Separate Accounts ResponsibilitiesReviews daily pre-pricing and pricing from the fund accountants to ensure our clients daily net asset values are a correct representation of the day’s activity.Completes daily high level reviews of pricing files before sending the files to the client and closing the books for each day.Assists the fund accountants by answering questions and helping them resolve differences within the general ledger.

Boston, Massachusetts, Us

Reviews and validates all daily activity in an accurate and timely manner, and maintains all required controls to ensure overall accuracy. Calculates and processes fund activities. Works in conjunction with individuals on the team as well as other shared services, India and Client Operations to ensure seamless processing according to the fund’s policies.