Kimberly Hicks

• Company Overview: Temporary, Short-Term Contract, Knowledge Base Data Analyst at Wells Fargo.
• Helped interpret the 'Audit and Post' current procedures and processes in place to be documented within a knowledge base application for new employees.
• SMEs need to gather the necessary information.
• Researched data and documented the flow through the Wells Fargo system, noting any changes in the data as it moved throughout the system.
• Documented all software packages and interfaces used in the process.
• Jira and Confluence.
• Temporary Short-Term Contract, Knowledge Base Data Analyst at Wells Fargo.
• Worked closely with management to prioritize business and information needs.
• Analyzed large datasets to address strategic and operational business questions.
• Assessed programs to identify risks or problems to determine appropriate responses.
• Maintained documentation of all the processes related to Data Analysis.

• Verified through logistics the arrival of all necessary hardware needed for installation of the servers into the Google Facility.
• Ensured staff was available upon arrival of equipment to accommodate the install.
• Received and unpacked server towers, hard drives, and all cables for install.
• Installation of the power supplies, hard drives into the server towers and then all cabling and ensured they were correctly configured for operation and properly working.

• Collaborate with the design team and implement all financial reports for OHD, Indianapolis, and Cincinnati installation of Microsoft Dynamics 2013 R2.
• Developed comprehensive finance reports as necessary for the legacy Navision 2.6 system.
• Write and develop all reports using SQL stored procedures and SSRS reporting services.
• Designed and implemented a reporting interface application to replace the custom, forward-facing reports used by the branches for reports that can be modified in real time.
• This allowed the support group to change the layout and objects contained within the report in the live environment.
• Ultimately, allowing implementation to set up reporting for new implementations and modify current forward-facing reports without incurring development time.
• This application ultimately saved the company $500K per year in development costs on acquisitions.
• Collaborate with stakeholders to enhance the ability to create operational and ad-hoc reports, scorecards, and dashboards that visualize business performance and trends to help them with their business decisions.
• Document all reports currently used within the enterprise, and update existing documentation to keep current with business unit changes.
• Work closely with the development team for the reporting needs generated by their modifications and business requirements.
• Developed a Reports Guide in VS to interact with the jobCORE application, thus reducing helpdesk calls.
• Developed all reports for 253 branches across the USA using SSRS 2019 with SQL Server.
• Development of job costing and forecasting reports.
• Designed an automated process to allow the payroll application to interface with the Kronos application, saving hours of manual payroll entry.
• Accomplished a complete rewrite of the Alpha Insulation and Fireproofing application using SQL and Azure.
• Extensive knowledge of the following applications: Bid and Leads, Inventory, Purchase Orders, Invoicing, General Ledger, Payroll, Cost Accounting, Inventory Forecasting, Proposal, Work Orders, Customer Information, Component Systems, Physical Inventory, Margin Reporting, Payroll, and Kronos.
• Extensive knowledge of SQL query writing, stored procedures, triggers, functions, and report subscriptions, and PowerShell.
• Automated 50+ reports save reporting time by 30% in daily processing.
• Completed a complete conversion of all 1,900 reports from Crystal Reports to SSRS.
• Power BI and Tableau are used within the inventory reporting.
• Reviewed costs, expenses and revenues associated with construction projects.
• Performed ad hoc analyses as requested by executive team members.
• Developed financial models to support decision-making processes.
• Coordinated with other departments within the organization regarding budgeting and forecasting activities.
• Prepared and reviewed variance analysis reports to identify trends in financial performance.
• Coordinated with external auditors to ensure timely completion of audits.
• Collaborated with senior management to develop strategic long-term planning initiatives aimed at improving profitability of the company.
• Researched best practices in terms of financial reporting processes and implemented changes accordingly.
• Provided support during external audit process by preparing requested schedules and documents.
• Analyzed accounts to produce financial reports and research variances for professionals.
• Created detailed technical reports highlighting findings to diverse stakeholders.
• Generated periodic reports summarizing operational results versus budget and forecast expectations.
• Managed inventory and supplies to ensure materials were available when needed.
• Utilized advanced technical skills and expertise to troubleshoot complex problems and implement solutions.
• Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
• Conducted testing of software and systems to ensure quality and reliability.
• Worked effectively in team environments to make the workplace more productive.

• Designed and implemented a robust database system to hold all vendor information for antique shows, record the number of items sold, tables assigned, and space arrangement.
• Entered and processed all vendor invoices, tax statements, and payroll.
• Supported the vinyl cutting applications, SQL Server, and graphic images in Adobe Photoshop for marketing and setup advertising.
• Installed, configured, and maintained computer systems, network equipment, operating systems, and applications.
• Provided technical assistance to end users on a variety of issues, including hardware and software related problems.
• Diagnosed hardware failures in servers, workstations, laptops, printers, scanners.
• Supported customers with online billing, access, and account issues.
• Participated in after-hours on-call rotation for critical support needs.

BWC

• Designed and wrote a consulting project for a firm of rehabilitation specialists for the Bureau of Workers' Compensation.
• Application written in Microsoft Access.
• This allowed the firm to effectively train companies to create positions in adherence to an individual’s limitations, set by their physician.
• This would allow the individuals to return to work and be released from workers' compensation.
• The application allowed the firm to supply both the Bureau of Workers' Compensation and the company with all necessary reporting to remain compliant.

Waterwise Utilities

• Streamlined the invoice process for the City of Hilliard water utility.
• Enabled for CMS data to be pulled into systems for customer correspondence.

Metropolitan Environmental

• Set up the company LAN to enable printing from multiple locations.
• Used excellent verbal skills to engage customers in conversation and effectively determine needs and requirements.

• Work with store systems and develop reporting needs defined by stakeholders pertaining at all specials, sales and inventory levels.
• Gathered all business requirements from enterprise managers and store back office employees to create necessary reports.
• Store systems support of all cash registers and scanning equipment.
• Created automated scripts to streamline routine tasks and reduce manual labor hours spent on processes.
• Designed, developed, tested, documented, and maintained new applications and software components.
• Developed, documented and revised system design procedures and quality standards.
• Provided support for end users in troubleshooting system issues.
• Deployed updates or patches to existing systems in order to maintain optimal operation levels across all environments.
• Troubleshot program and system malfunctions to restore normal functioning.
• Collaborated with stakeholders to ensure the successful implementation of systems projects.
• Provided training sessions for end users on how best utilize the company's systems.
• Conferred with clients regarding information processing or computation needs.
• Assisted staff and users with computer malfunctions and program problems.
• Trained staff and users to work with computer systems and programs.
• Conducted testing of software and systems to ensure quality and reliability.
• Recognized by management for providing exceptional customer service.

• Responsible for the support and maintenance of the SQL and TempWorks database systems.
• Maintain data integrity through SQL using ODBC to the front-end application (Tempworks), using Microsoft Access and VBA.
• Implement, design, and code new reporting utilities as requested by the end user.
• Setup of new server devices for the SQL database, and training of new end users in specific accounting tasks.
• Also responsible for the integrity of all system accounting reports, and the redesign of all legacy reports contained in the system.
• Design of new reports using SQL Reporting Services and Crystal Reports for all management reports.
• Responsible for producing all temporary employee tax reporting documents, completed within the deadline.
• Designed and implemented database systems to meet organizational needs.
• Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
• Oversaw the installation and maintenance of database software and updates.
• Devised reports and visualizations to present requested data in sleek format.
• Defined database design specifications based upon project requirements.
• Analyzed and resolved complex database and system issues promptly.

• Maintained the race secretary system for Northland Park and Scioto Downs.
• Created an automated pill bottle process for the order of the horses for the races.
• The race secretary system was written in Visual Basic and developed all report documents.
• Documented program development and subsequent revisions with comments for easy comprehension.
• Collaborated with project managers to define project scope and timeline requirements.
• Implemented and tested enhancement feature requests to improve product functionality and extend performance.
• Reviewed project documentation and made important changes to match updates to project scope.

• Responsible for improving business processes for HighJump Warehouse Distribution software, which integrated with the Clippership Logistics software.
• Designed a new cartonization application that integrated with High Jump software to better serve the customer, and save shipping costs.
• Maintained all existing applications and provided all end-user support.
• Supported SQL Server 2005 database, and compiled all data reports as requested.
• Developed an application for the drug recall process according to FDA guidelines to retrieve customer information and return to the home office within a 2-hour period.
• Demonstrated skills in interviewing business leaders to gather and clarify business requirements.
• Notable Projects include:
• Application Upgrades - Successfully completed several software application upgrades to both the HighJump Warehouse Distribution software and the Clippership Logistics software. Performed all QA to verify the accuracy of the system.
• End User Training - Developed and implemented end-user training for the pick-to-light system and RF guns.
• Corporate polling system – Developed a process and application to run on the servers to ensure that the orders were being received from corporate to the distribution center. This would automatically notify the needed support, and escalate as needed.
• System Documentation – Developed system documentation on error recognition and handling, along with current system processes and procedures.
• Cartonization Application – Designed and programmed an application to retrieve data from the High Jump software, process the data as needed to determine the appropriate cartonization for the order, and return the data back to the High Jump software to send to the pick-to-light system for processing.
• Archived Data Reporting Process – Created and designed a user interface in VB that retrieved archived data from the SQL database based on management entries.
• Import/Export Application System – Developed an application to monitor the import and export of data to and from the corporate office in California, to alert the IT staff when data has not been transferred for a period of time longer than 15 minutes.
• Performed unit testing on all modules prior to integration into larger applications and systems.
• Provided technical support for software application issues reported by users.
• Tested, debugged, and documented new or revised software programs.
• Designed code to help company develop necessary applications and websites.