| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESR FINANCIAL REPORTING ANALYST / SR PROGRAMMER ANALYST~ APPLICATION / REPORT DESIGN ~ QA ~ PROJECT LEADERSHIPAccomplished 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 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 knowledgeEnd User Training System DocumentationCoding/Implementations Change ManagementReport conversion Business ObjectsCrystal Report/SSRSPROFESSIONAL EXPERIENCEINSTALLED BUILDING PRODUCT, LLC MAY, 2014 NOVEMBER 2023COLUMBUS, OHSENIOR REPORTING ANALYSTDesign 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 application; 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.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 SISS 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.IFORCE SERVICES, LLC FEB 2007 - JUNE 2008COLUMBUS, OHSQL DBA TEMPWORKSResponsible 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.SHAKLEE CORPORATION AUG 2000 - OCT 2005GROVEPORT, OHSENIOR PROGRAMMER ANALYST IIResponsible 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.INTERACTIVE TELESERVICES NOV 1999 - AUG 2000COLUMBUS, OHPROJECT LEADResponsibilities included managing 10 application programmers, designing applications per client specifications to retrieve call center data and return in the client format. Maintained existing Visual Foxpro applications and documentation. Demonstrated skills in interviewing clients to define their business and data requirements. Authored detailed deployment plans, schedules and continuously exceeded client expectations.Notable Projects Include:Cost Analysis Software Designed and implemented cost analysis software for the process of client billing.Plug-in Play Application Designed/coded and implemented a plug and play application which would standardize the way the client applications were developed.QA Verification QA all customer files before sending to client to ensure accuracy.SUN TELEVISION AND APPLIANCES JULY 1994 NOV 1999GROVEPORT, OHSTORE SYSTEMS MANAGERDesign and implementation of the JDA/SUN POS (WINDSS) system using Clarion 1.51 to interface with the JDA MMS on the AS400 in a client/server environment. Resolve data integrity issues between DSS/MMS sides of the application. Responsible for store system support, management of the helpdesk, implementation of new software, and store system rollout for 52 branches across numerous states. Responsible for POS project scheduling including all POS hardware setup and testing. Correct all unresolved issues within the DSS system using Clarion and SQL. Performed in-store training to all store personnel upon new system rollout. Interviewed senior management to define the business processes for the development of DSS system.Notable Projects include:End User Training Manuals Developed end-user training manuals for all store personnel including cashier, Backoffice, receiving and service.Testing Lab/QA Process Developed and implemented a testing lab for all new store system hardware and software for 52 stores.Change Control Process - Designed a change control process and directory structure for all the DSS modifications. Reviewed and processed all changes/additions to the DSS system.Automated Software Deployment Implemented an automated software deployment process and procedure to update the DSS system software in all 52 stores.Check Authorization Developed and implemented the interface for the check authorization process at the registers in DSS.EDUCATION & CREDENTIALSAssociates Degree in Business Data Processing - Westmoreland County Community College, Youngwood, PAContinuing Studies for Bachelor of Science - Penn State University - PAAdvanced JCL -Kelly Services, Pittsburgh, PAAlpha Micro Certification - Denver, CO |
