Pay Rate: $50
Location: Chicago IL
Job Type: Contract

Company Name: Healthcare Services Company 

Location: North Chicago suburbs

Position (consulting): Financial Reporting / Data Migration and Validation Consultant

Start Date: 06/15/2020 (Monday)

Project Length (initial): 8 weeks (extensions possible)

Scope of Responsibilities:

  • Migrate and validate 4 years of historical financial information from legacy system (Oracle) to new system (Business Central)
    • Chart of Accounts in Business Central (BC) has already been created and mapped from Oracle to BC
  • Validation will include monthly financial information (comparing new reports to legacy reports run directly from Oracle)
    • Differences to be researched and corrected including updating account mapping, updating report configuration and other issues identified
  • Create financial reports in Jet Reporting (new financial reporting software – Excel based) leveraging reports in Hyperion Essbase (legacy reporting system)
    • To the extent possible, new financial reports should look exactly like legacy reports so that clinics (customers) have seamless transition while Lifeline Vascular becomes an independent standalone company
  • After 4-year migration of historical financial information, perform go forward parallel testing from legacy systems to new systems

Skills / Experience:

  • Financial Reporting (includes creation of traditional and ad-hoc reports)
  • Data Migration (includes importing financial information from Excel into new financial software)
  • Data Validation (includes reconciling monthly financial reports in legacy software to new software)
  • Accounting (includes chart of accounts review, mapping confirmation from legacy accounts to new accounts, creation of GL accounts in new software’s chart of accounts and mapping legacy accounts to new accounts)
  • Problem solver
  • Works well with internal cross-functional teams (Accounting, Finance, IT)
  • Requires minimal oversight
  • Oracle (preferred not required)
  • Hyperion Essbase (preferred not required)
  • Business Central (preferred not required)
    • New Microsoft Dynamics software (loosely can be considered the new Great Plains)
  • Jet Reporting (ideal but not required)
  • CPA (preferred not required)
  • Excel (advanced skills required including working with large Excel files and database information

For immediate consideration, please email your resume in Word format to Cameron Wall at cwall@ifgpr.com.