AMY GIRARD

• Extract data from legacy system in many different formats to make data compatible with new system
• Make data information more accessible and user friendly
• Decide specifications needed to transfer data from source structure to current system requirements
• Evaluate conversion process to ensure that data is corruption-free and supply resolutions to any errors or issues that may arise
• Write script for converting data in mass
• Track changes in anticipation of dual maintenance
• Review results with client using reports, test environments and obtain customer acceptance of results
• Import data into scrub test environment
• Migrate data into production database
• Convert business data from client legacy system to ASCENDER systems
• Coordinate completion of post-conversion maintenance potentially including error resolution, system or data changes, and balancing adjustments
• Work service tickets using Jira, Confluence, and Ascender Resources to resolve issues or escalate for software fixes or enhancements.

ACCOMPLISHMENTS:

• Converted new district business data: Human Resources (demographic, leave, service records, job history, certifications) Payroll (current and past year pay and W2 data), Finance (accounts receivable, payables, inventory, general ledger, purchasing, warehouse current and past years)
  • Converted 18 business clients from legacy system to new system.
  • Collaborated with team to convert 15 Career Portal clients.
  • Collaborated with team to address issues with Document Storage Portal.
  • Working both business and student ASCENDER service desk tickets using Jira.

• Design, create, change, and support dashboards and monthly metrics for supply chain, electronic billing, fleet, and material management
• Design, create, change, and support ad hoc reports and queries
• Design, create, change, and support open record requests
• Work with team and/or work as project manager for internal operations for supported departments
• Create and change processes to achieve better results and efficiency
• Create, change, and support standard operating procedure documentation.

Accomplishments:
• Implemented reporting metrics for spend data.
• Implemented reporting metrics, tools, and cost savings/cost avoidance metrics for diverse and local spend and awards.
• Implemented new reporting tools, dashboards, and metrics for new management team.
• Recommended changes to processes to make more efficient and on track for corporate goals of awarding to diverse and local companies.
• Created, changed, supported, and answered questions about the Purchasing requisition workload database.
• Built graphs and visual aids in Tableau for management overview and Senior Leadership dashboards.
• Participant in the inventory optimization team FPAP project to reduce waste, cost and improve inventory overhead.
• Create, change, and support Crystal reports.
• Invited and respected all member input and ideas. Fostered and invited a questioning attitude constructively and do not let colleagues fail. Always looking to improve results in a more efficient and effective way.

• Process PO's for requested purchases using buying best practices, vendor approved suppliers and policies
• Process POs for requisitions for 3rd party machine shop rework and repairs
• Follow up and billing resolutions
• Timekeeper and handle HR issues: run reports weekly, and EOM reporting
• Pull and process cycle counts, aid with reconciliation
• Attend management meetings and keep opportunity and commitment logs
• Update boards
• Process new hires, safety orientation courses, badges, lockers, T&E.
• Identified opportunities for process improvements, leading to more streamlined operations within department.
• Assisted in managing office space utilization effectively to accommodate growing workforce without compromising on functionality or comfort.
• Fostered strong relationships with vendors by establishing clear communication lines, enabling prompt resolution of any issues or disputes that arose during transactions.

• Gather documentation (W2, I9, benefits, deductions, hours) for each employee
• Calculate correct amount of overtime, deductions, bonuses etc.
• Using ADP software
• Prepare and execute payroll and distributed paychecks
• Administer statements of payment to personnel either electronically or on paper
• Process taxes and payment of employee benefits
• Keep track of hour rates, wages, compensation benefit rates, new hire information
• Address issues and questions about payroll from employees and superiors
• Prepare reports for management.
• Streamlined operations and prioritized tasks, allowing senior staff to increase revenue by 25%
• Assisted employees with inquiries regarding their paychecks, deductions, and other related issues, providing clear and concise communication.
• Provided customer service to employees regarding payroll inquiries and issues.
• Performed calculations in overtime, vacation, and sick hours to provide accurate data to payroll processing database.

• Performed all office related tasks: billing, payroll, personnel, banking, customer service, job costing, service orders, requisitions
• File IRS forms 941-quarterly and 940 annually
• Supervision and training office personnel
• Analyzing system and user needs for business offices including Payroll, Personnel, Purchasing, Finance, Accounting, Accounts Payable, Fixed Assets
• Create and support training and safety documentation
• Reviewed business procedures to resolve inefficiencies and automate manual processes
• Create queries and reports using MS Office, Crystal reports and QuickBooks.
• Handled sensitive information with discretion, maintaining confidentiality of company documents and personnel records.
• Provided exceptional customer service when addressing client inquiries or concerns via phone calls or email correspondence.
• Maintained computer and physical filing systems.
• Updated reports, managed accounts, and generated reports for company database.
• Maintained accurate financial records by reconciling accounts payable/receivable transactions regularly to ensure balanced budgets.

• Analyzing system and user needs for multiple managers of business offices
• Reviewed business procedures and user needs to resolve inefficiencies and automate manual processes
• Project leader responsibilities include database application and end-user support, gathering requirements, selection of project team members, scheduling meetings, arranging travel, organizing, testing, training, developing, and implementing new and upgraded business office systems
• Wrote and supported ad hoc reports
• Supervised three employees including performance evaluations, work schedules, assignment of duties, leave reporting and monitoring duties
• Reviewed and modified budget for technology business services.

Accomplishments:
• Implemented mandated federal, state, and local fingerprinting requirements for 8,000 employees.
• Reduced manual labor and increased accuracy and efficiency by implementing an automated W2 and 1099 process using Visual Basic programs to perform nightly download to populate insurance and payroll.
• Project Leader for upgrading the Sub finder system and implementation of Leave Accounting interface for posting leave and paying substitutes automatically for over 8,000 employees.
• Insurance Committee Project Leader: Designed, wrote, and supported the online benefit enrollment system for 10,000 employees using SQL/VBA/JAVA.
• Project leader and technical expert for reviewing, organizing, evaluating, and implementing the automation of many manual tasks for business offices resulting in large monetary and labor-intensive savings.
• Team expert in evaluating and implementing purchases for Technology.
• Wrote RFP’s and organized demos for users. Collaborated heavily with vendors and bid proposals.
• Wrote program using SQL to create timesheets for biweekly employees.
• Conversion of all business data queries and requested reports to Cognos Reports from legacy system.

• Utilized change management techniques to provide smooth transitions during new hardware and software introductions.
• Led successful system migrations, ensuring minimal disruption to business operations during transitions.
• Defined and documented scope of projects for distribution to team.
• Performed system analysis, documentation, testing, implementation, and user support for platform transitions.