DataMart

Migrate data from most external systems, Microsoft SQL Server, Oracle, Access, FoxPro, Excel, etc. Set up user access, security, develop custom forms, develop specialized integrations with AP and AR, develop specialty reports utilizing LX report tool. Set up Lucernex DataMart. Develop custom SQL report queries for Lease Admin and Lease Compliance.... Data transformations utilizing best practices resulting in cleaner data import. Bulk Data export and import into Lucernex. Extract data from the clients previous systems, convert data into a clean structure and then import the data into Lucernex. Custom Lucernex integrations ( reports with filters ) and DataMart reports to interface with a variety of accounting ( AP/AR ) and reporting systems. Develop procedures and processes to close month end expenses, produce payments file and import processed payments information. Design and write reports and procedures for Straight Line and accounting accruals. Manage complex account procedures, allocation, accruals, deferments and develop reports and integrations to support LX accounting functionality with your accounting system. Independent System Administrator satisfies security and separation of duties requirements.Read More