Jillian Boardman Email & Phone Number

Littleton, CO, US

Highlands Ranch, Colorado

• Develop and maintain T-SQL queries, stored procedures and views for various Business Units, external clients and investors
• Interpret, analyze and appropriately update T-SQL queries for reporting purposes and bug fixes
• Developer of Business Intelligence solutions utilizing SQL Server, SSRS and SSIS from requirements gathering to deployment and acceptance
• Develop Ad-Hoc reports in T-SQL for various Business Units
• Develop multiple SSRS reports and configured data driven subscriptions
• Provide production support for SSRS packages, stored procedures and queries

Cordova, Illinois

• Management of internal staff and consultants including but not limited to overseeing proper customer response, employee issues and coordination of services
• On site and phone/email support of clients with technical, purchased services and billing inquires
• Responsible for all financial aspects, including but not limited to accounts payable and receivable, customer and vendor account billing, bank reconciliation and quarterly taxes
• Coding, design and maintenance of internally used customer and billing database
• Design and development of various customer websites
• Documentation of FAQs for on line help

Chicago, Illinois

• Code and migration of the company's equipment inventory database from CICS and VSAM to a Visual Basic front end with an Access database.
• Responsible for the automation, maintenance and support of the corporate telephone cost allocation/chargeback system.
• Responsible for all upgrades and maintenance of CNAs telecommunications audit database including monthly general ledger feeds and reconciliation.
• Provide business analysis and ad-hoc reporting to IT Finance Department.
• Coded and implemented all Y2K fixes to currently supported telecommunication systems.
• Participated in developing an automated process to facilitate the installation of MS Mail and MS Schedule+