MS Access Database Developer (NEW YORK, New York)
Start Date 01-18-2010 End Date 12-31-2010 Rate: 38/hr on C2C The Specialist EL will be responsible for performing the following tasks: Develop a database to track over 230 SAIC consultants planned, actual and remaining hours to facilitate the monthly invoice processing and quarterly-end budget reconciliations. Design and develop a system that provides an audit trail of all paid deliverables from purchase requests to vendors paid invoices to Citys Financial Management System (FMS). Develop and automate a database to reconcile the FMS EFT charges to the CityTime paid deliverables and invoices, and the FMS EFT deposits to the CityTime CP Request/Expense funds. Develop a system to integrate SAIC Access Database of invoice payments with the CityTime Deliverable Payment Schedule (DPS). Redesign and automate a database to track over 30 Spherion consultants planned, actual and remaining hours to facilitate the monthly invoice processing and monthly budget reconciliations. Design the Deliverable Payment Schedule database to track payments to CityTime prime contractor. Design a reporting system using VBA in MS Access for the CityTime project. Develop VBA to reorient the CityTime Spherion Funding Balance Sheet and automate a monthly collection of data from key contractors. Enhance an existing reporting system using VBA in MS Access to include other applications such as Deliverable Status Access Database, Funding Requests, Capital and Expenditure Budget Log Access, and integration between the inventory systems. Create and update queries for reviewing, testing, and validating data across systems to ensure compliance. Review and test workflow designs and implementations to ensure compliance with CityTime specifications. Assist in developing an automated system to track the distribution of the Data Collection Devices (DCDs) and the installation cost. Develop a reporting system that generates monthly status reports and/or ad hoc reports for all capital assets using Visio and PowerPoint produced documentation and design diagrams. Design and develop a system to audit CityTime warranty/maintenance contracts. MANDATORY SKILLS/EXPERIENCE Note: candidates who do not have the mandatory skills will not be considered. 18 months of experience with writing application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions. Excellent communication and interpersonal skills. Able to concurrently coordinate with multiple technical resources in a well-organized manner. Excellent team player, Detail oriented, self-directed, strong work ethic. DESIRABLE SKILLS/EXPERIENCE Knowledge of Microsoft Office Suite, MS Project, Crystal Reports, Adobe Illustrator, Photoshop Databases: Access 2003/2007 Scripts: VBA and C++ Design: Microsoft Visio, PowerPoint Reports: Crystal Reports and Access Reports 2007 Knowledge of Remedy Asset Management and Clear Quest is a plus OPA shall conduct criminal background inquiries for Consultant(s) prior to assignment. The Contractor shall supply the Date of Birth (DOB) of the proposed consultant prior to assignment. The Consultant shall be required to comply with the physical and LAN security policies of the agency and sign a Confidentiality/Non-Disclosure Agreement upon assignment. Jameel Ahmed Accounts Manager Techgene Solutions LLC (A Minority Certified Company) Phone : 972-580-0247 Ext 221 Alt : 214-257-0837 Ext 33 Fax : 972-692-5824 Mail : <mailto:[email protected]> [email protected] URL : <http://www.techgene.com> www.techgene.com ---------------------------------------------------
