Business Process Analyst

Kimberly Hicks

**** *** *********** **** *************, OH 43148 740-***-**** ********.****@*****.***

SR FINANCIAL REPORTING ANALYST / SR PROGRAMMER ANALYST

~ APPLICATION / REPORT DESIGN ~ QA ~ PROJECT LEADERSHIP

Accomplished Sr. Financial Reporting Analyst / Senior Programmer Analyst / Project Manager / Store Systems Manager with a track record of managing complex IT projects, exceeding customer reporting expectations. Practiced in gathering business requirements, performing analysis between goals and existing procedures/skill sets, design business process and analysis, scripting SQL, system improvements to increase productivity and reduce costs. Extensive experience in development of customer forward facing documents for acquisitions, relational databases, indexes / foreign keys, triggers, functions and management reports using SQL/SSRS software. Maintain Data Warehouse systems and support. Creation of company forecasting reports. Management of Store System operations (responsible for 15 individuals and 52 stores throughout the Midwest), developed new POS system partnered with JDA/WINDSS. Strong interpersonal skills, recognized project management skills, consistently delivered projects on time and within budget. Extreme ability to apply skills to any user environment and communicating effectively.

Additional areas of expertise include:

Gather Business Requirements Extensive SQL knowledge

End User Training System Documentation

Coding/Implementations Change Management / Gitlab / Sourcesafe

Report conversion Business Objects / Financial Reporting

Crystal Report/SSRS Microsoft Office

Kronos SSIS / SSAS / ETL / SSMS

Powershell, JCL Data Mapping

VB .Net Access / Visual Foxpro

Dynamics NAV HighJump / Clippership

Cartonization E911 CAD systems / EMS

Data Warehouse Point of Sale Systems

PROFESSIONAL EXPERIENCE

INSTALLED BUILDING PRODUCT, LLC MAY, 2014 – NOVEMBER 2023

COLUMBUS, OH

SENIOR REPORTING ANALYST

Design and implement all financial reports for OHD Indianapolis and Cincinnati installation of Microsoft Dynamics 2013R2. Responsible for developing 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 to reports that can be modified in real-time. This allowed the support group to change the layout and objects contained within the report on the live environment. Ultimately, allowing implementation to setup reporting for new implementations and modify current forward-facing reports without incurring the development time. Document all reports currently used within the Enterprise. 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. Developed all reports for 253 branches across the USA using SSRS 2019 with SQL Server. Development of Job costing and forecasting reports. 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. Extensive knowledge of SQL query writing / stored procedures / triggers / functions and report subscriptions and PowerShell.

Notable Projects include:

Developed application using SSRS to replace the FRx application on the MAS database system to adhoc queries for the financial departments of IBP, its sister companies and subsidiaries.

Upgraded all Crystal Reports to SSRS.

Designed and built a report interface application to generate all the forward-facing reports to customer branches, cutting company costs to 1/4th of previous development cost.

Responsible for all customer forward facing forms, support group financial, cost analysis, accounting statements reports and design.

Designed a report guide application for the customers of all report calculations and availability, saving company 25% of previous helpdesk requests.

Creation of process and reports for all legal documents.

Worked with the SSIS packages to create jobs to populate and keep up to date the reporting data in the data warehouse.

Successful completion of required updates to all reports for software upgrades.

KAH CONSULTING SEPT. 2012 – MAY 2014

PLEASANTVILLE, OH

OWNER

Designed and wrote consulting project for a firm of rehabilitation specialists for the Bureau of Workman’s 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.

SCOTT ANTIQUE MARKET MARCH 2010 – SEPT. 2012

BREMEN, OH

IT SUPPORT TECHNICATION

Created database to hold all vendor information for antique shows, record 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, Graphic images in Adobe Photoshop for marketing and setup advertising

IFORCE SERVICES, LLC FEB 2007 - JUNE 2008

COLUMBUS, OH

SQL DBA TEMPWORKS

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 on the system. Design of new reports using SQL Reporting Services and Crystal Reports for all management reports.

UNITED STATES TROTTING ASSOCIATION NOV. 2005 – JAN. 2007

COLUMBUS, OH

SENIOR PROGRAMMER ANALYST

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. Race secretary system was written in Visual Basic and developed all report documents.

SHAKLEE CORPORATION AUG. 2000 – OCT. 2005

GROVEPORT, OH

SENIOR PROGRAMMER ANALYST II

Responsible for improving business processes for HighJump Warehouse Distribution software that integrated with the Clippership Logistics software. Designed new cartonization application that integrated with HighJump 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 application for the drug recall process according to the FDA guidelines to retrieve customer information and return to home office within a 2-hour period of time. 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 Logisitics software. Performed all QA to verify 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 where 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/programmed application to retrieve data from the HighJump software process the data as need to determine the appropriate cartonization for the order and return the data back to the HighJump 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.

Prior Experience upon request.

EDUCATION & CREDENTIALS

Associates Degree in Business Data Processing - Westmoreland County Community College, Youngwood, PA

Continuing Studies for Bachelor of Science - Penn State University - PA

Advanced JCL -Kelly Services, Pittsburgh, PA

Alpha Micro Certification - Denver, CO

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate