Travis Collicott Email & Phone Number

CMiC Development - Workflows, Jasper Reports, Dashboards

Lisle, Illinois

DEVELOPER• Create and customize Oracle Workflows within CMiC Application• Build and modify CMiC Jasper Reports and MIP Documents• Develop CMiC Dashboards using Dashboard Builder and Catalog Builder and custom SQL Views and Tables

Barrington, Illinois

SENIOR PROGRAMMER ANALYST• Serve as point of escalation for technical issues that may arise within projects or applications• Work with report consumers to determine report effectiveness, usage, and potential for enhancements• Develop and enhance reports using Jaspersoft iReports and Domo• Build and improve SQL data sets via Views, Functions, Procedures, and Tables using Oracle SQL Developer and Microsoft SQL Server• Assist internal clients with CMiC support and troubleshootingPROGRAMMER ANALYST• Develop and enhance reports using Jaspersoft iReports and Domo• Build and improve SQL data sets via Views, Functions, Procedures, and Tables using Oracle SQL Developer and Microsoft SQL Server• Assist internal clients with CMiC support and troubleshooting

Northbrook, Illinois

INFORMATION ANALYST• Interact with clients to gather business requirements and estimate resources for upcoming work• Craft reports using tools such as SAP Business Objects, Oracle SQL Developer, and Service Now• Lead reporting improvement project to add new database view to SAP Business Object’s environment while delivering on time and under budgetBUSINESS ANALYST - RELEASE MANAGER• Construct and maintain MS SharePoint 2010 site for Sales and Marketing's Release Management team• Create operational reports that address customer’s needs and drive improvement within different organizations• Train project delivery teams on the release standards and ensure delivery dates were aligned to the release calendar

Rolling Meadows, Illinois

• Organize proof of concepts, project plans, and test plans as part of the project lifecycle• Provide financial reports to different business units hosted on an AS/400 server and DB2 database• Implement change in reporting process to increase performance on DB2 server and ensure accurate delivery of reports

Lake Forest, Illinois

IS SYSTEMS ANALYST• Provide data integrity and application support by generating ad-hoc SQL queries• Scrub and integrate acquisition data with the use of SQL, MS Excel, and MS Access• Investigate, analyse, and document newly discovered application issues in production environmentENVIRONMENTAL CONFIGURATION ASSOCIATE• VMware administration consisting of building, maintaining, and configuring 200+ virtual servers• Database administration, including but not limited to, configuring linked servers, jobs, & stored procedures in MS SQL• Troubleshoot and deploy proprietary software in development and testing stages to ensure deadlines were met for the development and testing teams, while at the same time focusing on accuracy and qualityUSER SUPPORT ASSOCIATE• Build relationships with customers to analyse problems and determine solutions that satisfy their needs• Install, configure, and repair network equipment, including laptops, desktops, phones, and printers• Document solutions for recurring issues and distribute them to teams for future use