Technical Financial Analyst - Interview and hire ASAP!!!

We are an innovative firm looking for a financial analyst to join our team and help out with file reconciliation.  We are looking to interview and hire immediately for a 3 month+ contract.

Associate Financial Analyst

 Completes reporting and maintenance of reports; performs special project and analysis as assigned.Reconciling current CPD reports to PDF filesCompetent to work on the most complex accounting/analytical activities, including planning and forecasting.  Recommends changes to existing accounting systems.Limited external contact.  Internal contact primarily with associates within the region.

 

Project Highlights:

 

OCB Comprehensive Payroll Deduct File (CPD): This is the report of record.  This report is generated by Wired Commute and can be found on the Wired Commute Admin site; after generating it’s pulled into SAM.  This report details the total order placed by the participant as well as any adjustments processed for that ppt.  In a perfect world, the PDF should always be an exact copy of the CPD. 

 

Payroll Deduct File (PDF):  The PDF should reflect exactly what the CPD reports as well as any adjustments indicated on the OCB Adjustment Report.  This report generates out of SAM and is reported to FlexDirect.  The PDF can be generated in several different formats.  In this one, ppts are listed by their EEID.

 

OCB Adjustment Report:  The Adjustment Reports details any adjustments processed to ppt accounts during the last ordering period.  The report is created out of Wired Commute and posted to Flex in conjunction with the PDF.  Adjustments include rate changes (RC), funds refunded from merchant (FR), termination of service for employee or employer (TM), or credit card adjustment (CB).  The problem that we’re encountering is focused primarily on the RC adjustments, but we have seen them for FR adjustments as well.

 

The problem that we’re having is that when SAM creates the PDF, it’s doing some “behind the scenes” calculations based on the Adjustment Report and they’re reflecting incorrectly.  On the CPD (report of record) he shows $112.05 transit election, which includes the $9.45 found on the Adjustment Report.  The problem is that on the PDF he shows only a $102.16 deduction which is incorrect. 

 

To do the reconciliation, you need to match the PDF to the CPD.  Any discrepancies should be identified and listed as corrections.  The Adjustment Report can give some direction as to who may be affected, but I think a line-by-line comparison is the best way to go and may identify other issues we have yet to discover. 

 

One note on the PDF – As I mentioned above, these can be generated in many different formats and as full file or changes only.  In order to do the recon correctly, I suggest submitting a help desk ticket to have all PDF’s reviewed generated in a full file generic format.  Please keep in mind the timing of how the PDF’s are generated when submitting these requests.  For example, Chicago Mercantile Exchange is a 2 month model client so the CPD, PDF, & Adjustment Report created in March would actually be for the May benefit month.  When you submit the helpdesk ticket, please indicate the benefit month and not the month that the report was generated.