Business Systems Manager

• Mar 2020 - Present

As Business Systems Manager for Great Lakes Wine & Spirits I am responsible for business analysis, implementing reporting environments, maintaining applications, and managing personnel. Responsibilities include: • Maintaining SQL Servers and PBI Reporting environments • Creating and updating IT related policies and procedures • Updating SQL Server, SSIS packages and SSRS reports to latest version • Creating and altering SQL stored procedures, views, T-SQL, cursors and other SQL database objects that assist in the implementation of business logic and data flows • Monitoring and troubleshooting SQL jobs, scheduled tasks, and integration services • Creating and updating SSRS and PBI reports • Managing IT personnel • Maintaining databases, backups and restores Show less

IT Director

• Jun 2018 - Mar 2020

IT Manager

• Jun 2011 - May 2018

• Directing day to day activities and managing IT department employees• Identifying company needs and allocating resources to ensure effective operating results and cost management• Managing relationships with technical vendors including data center, circuit, phone, security, and applications• Overseeing operation of all company systems including Active Directory, exchange, SharePoint, phone, document management, and department specific Collections, Accounting, and Credit applications • Identifying ineffective practices and implementing process improvements • Maintaining onsite servers by ensuring all recommended hardware upgrades are installed and warranties are kept up to date and critical data is backed up• Developing and monitoring workflows to ensure set up of new employees with equipment and IT resources, and the appropriate and timely decommissioning of permissions and equipment from exiting employees• Overseeing helpdesk including desktop and laptop maintenance as well as Windows update rollouts and anti-virus policy creation and updates Show less

Project Manager

• May 2009 - Jun 2011

o Developed Project Estimates o Developed and maintain Project Charters, Project Plans, and Business Relationship Diagrams o Coordinated with customer groups for all project deliverables o Executed team status and project reviews o Tracked issues and scope change requests o Ensured development and execution of integration test plans o Ensured required project checkpoints were performed at appropriate stage of development o Verified production releases met technical and business expectations Show less

Business Analyst / Systems Analyst / Programmer / Project Manager

• Feb 1997 - Apr 2009

• Led IT teams world-wide to manage the translation of business requirements into technical design and specifications • Launched billing system on locations throughout Asia Pacific, Europe, South and North America • Coordinated system and user acceptance testing and implemented project launches to client satisfaction • Represented Ford at client site workshops around the world • Acted as liaison between technical, business development and accounting teams • Coordinated changes with all impacted systems including General Ledger, Accounts Receivable, Tax, and Invoicing • Provided training sessions to both IT and business • Assisted customers with post-launch concerns • Acted as primary vendor liaison for Ford Motor Company • Coordinated all requests for new system functionality with the Ford finance business unit and IT vendor teams • Definition, development and implementation of security and controls • Updated system documentation and conducted training sessions for new users and business customers • Provided demos to both IT and business workers • Developed Application Control Review documents and participated in system audits • Assisted in gathering documentation and evidence for Sarbanes-Oxley audit. Show less

Programmer

• 1999 - 2001

• Worked with business analysts and customers to determine requirements. • Created specifications and test plans. • Analyzed and coded COBOL/IMS/DB2 programs and subroutines to convert all accounting processes to Peoplesoft standards. • Implemented system and user acceptance tests • Performed data conversions and implemented system changes successfully • Coordinated system and user acceptance testing and implemented project launches to client satisfaction • Assisted in deploying MICS system globally • Met with customers on regular basis to discuss issues and gather requirements • Analyzed and corrected production problems. Show less