Christopher Bufalini Email & Phone Number

Clark, Nj, Us

- Designed, developed, and implemented tools to transform, validate, and import 15,000+ daily XML files from monitored FTP sites, replacing the manual process and saving 10 hours a week - Provided ability to view real-time delivery progress by querying and parsing driver’s scan data from API calls- Implemented the rapid development and deployment of a COVID symptom questionnaire, submitted by 1500+ drivers daily and visible to management- Coordinated and executed 140+ software releases across 16 internal tools to implement changes supporting the evolving business needs- Automated the creation and distributions of over 15 scheduled reports and graphs, providing critical up-to-date analytics to the executive team- Created automated customized reports and graphs to attract new business by providing previously unavailable data metrics

Burlington, Nj, Us

Senior member of the Business Reporting Group (BRG), whose responsibilities include providing the CEO, executive team, and all departments with various reports used as the primary tool to gauge business, along with developing and maintaining internal tools to facilitate in the order entry for all buyers globally- Designed, developed and maintained a tool to continually validate incoming buyer orders based on predefined criteria, and assign approved orders to the Order Entry team for processing based on their individual workload, mailbox assignments, and preset time limit- Designed, developed and maintained the POI Auto-Assign Control Panel, a tool that allows managers to change Order Entry staff assignments and priorities at runtime. Replaced the manual process, thereby eliminating 4 full-time positions while exceeding an unprecedented 1000 order entries per week. - Headed development and deployment of Magic, an Excel/VBA tool used by the Order Entry team to validate all incoming orders for accuracy before uploading to the data warehouse

Ch

Member of the IT PMO department which is responsible for tracking and reporting the progress of all IT projects corporate-wide, in an effort to optimize project deliverables through all stages- Lead Developer on the Milestone Tracker report, an automated Excel based Gantt chart used by senior management that visually represents the current SDLC stages of each project- Worked with the PMO Standards lead and teammates, program and project managers to develop and provide reports, maintain databases and configurations, and support ad hoc program and project support requests

Newark, New Jersey, Us

Member of the Human Resources Corporate Compensation team. The department oversees the annual compensation process and has responsibility for providing Global Market Intelligence analytical services/benchmarking in support of global compensation programs, customer-specific Market Intelligence and custom surveys.• Gathered requirements from the business for enhancements to annual compensation reports used by the chairman and his reports as the primary tool to gauge senior staff compensation for the upcoming year. Completed Change Control documentation as needed• Responsible for UX/UI design of a new process to identify and track top executives in violation of the required notification period of termination, which could impact the release of their Stock Options/Awards• Made enhancements to VBA code, tables, and queries as necessary to support the needs of the department. One improvement was to programmatically modify the annual statement process to generate individual PDF files per employee instead of a continues report, saving the department 70% in production time

New Brunswick, Nj, Us

The Procurement department manages the purchasing of all packaging and chemical raw materials for all of Johnson & Johnson Consumer products• Gathered business requirements from the international community for the global integration of Galaxy, a $3.5mm project used by procurement as an integral part of business planning, and as the primary tool to negotiate commodity pricing with suppliers• Responsible for all stages of the SDLC, including requirements gathering and VOC, data mapping with international business partners, UI design and workflow, SIT (System Integration Testing), devising UAT scripts based on business requirements, documentation, deployment into production, preparing training materials, and communicating milestones to upper management• Development lead for Galaxy, utilizing an MS Access front-end, VBA and SQL back-end. Helped manage other resources, and drive projects forward• Performed daily data mining/data scrubbing on incoming raw material attributes provided by the suppliers to ensure data consistency in the SQL database• Designed and developed an automated Excel template used to aggregate and validate external supplier data and import into a centralized SQL Server database, incorporating MS Query, SQL Views, SQL Triggers, audit tables, and automated e-mail functionality through VBA• Created several automated departmental reports that extract and export SQL data to formatted Excel spreadsheets, complete with graphs and Pivot Tables, utilizing MS Access, VBA and Active X controls

Gladstone, Nj, Us

Hobart Innovations is a entity of The Hobart Group that debuted in 2011 and provides a variety of services to a large pharmaceutical client base such as advertising and promotion, meetings, and database/market research• Devised a portable solution, to be sold to major pharmaceutical companies which would provide the ability to create fully customizable ad-hoc Excel metrics and graphs, based on secured data obtained through independently conducted surveys of medical professionals• Gathered and documented business requirements from the president• Responsible for the UX and UI design of the new tool

New Brunswick, Nj, Us

The Payroll/Fulfillment team is responsible for recovering revenue from Johnson & Johnson employees as a result of salary overpayments, which are identified through a third-party vendor. This process includes tracking claims from inception to closure, initial and subsequent notifications, and processing of funds recovered• Lead Business Analyst and developer for the implementation of a new global payroll notification system that generates a series of progressive notifications to employees who have been overpaid, and tracks payments made against the claim amount. This replaces the manual process of individual Excel spreadsheets, and drastically improves data accuracy, while reducing effort. • Assumed responsibility for all stages of the SDLC for the new notification system, including gathering and documenting business requirements, UX/UI design, coordinating UAT, system roll-out, training and user guides, and support• Assisted the global payroll department in redefining their manual workflows, which was later used as the basis for automating their processes• Enhanced an internal MS Access application that was being used by J&J counterparts in Germany so that it would be compatible for their US practices, and added additional functionality as needed

New York, Ny, Us

• Designed, developed and implemented a Help Desk tracking and reporting system utilizing MS Access, and VBA which provided the ability to work in a remote environment by synchronizing data with a central data warehouse, and included an e-mail notification feature that automatically composed and distributed e-mails to callers based on the changing status of their tickets • Documented department SOP’s for various functions as needed• Automated the procedure for retrieving HR employee data from network sources for use in internal applications. This replaced the laborious manual process and eliminated the need for daily extracts

Gothenburg, Se

Maquet is an international company based in Germany with focus on equipment for surgical workplaces, anesthesia systems, workstations for intensive care and cardiovascular devices • Responsible for maintaining the CRM Product Catalogues for the Sales Configuration and Quoting tools: SmartCatalog and SalesMechanix. The product information is extracted from SAP and built into Configuration Trees for both SmartCatalog and SalesMechanix.• Create and maintain Technical/Functional Business requirements Documents as required• Responsible for programming and executing MacroExpress scripts on the SAP ERP system which enabled mass updating of identified data gaps

New York, Ny, Us

Global Finance engage and assist all LOB’s with their merger integration efforts in migrating to the target Domestic and International SAP architecture encompassing all Financial processing components, including General Ledger, MIS and Regulatory Reporting• Responsible for the maintenance and enhancements of the Interface Inventory system, the authoritative source for all interfaces coming in to Global Finance, utilizing Access, VBA, and SQL• Generate and distribute monthly progress reports to senior management, including the Managing Directors for each LOB and the Corporate Controller. The reports are exported and formatted in Excel and Power Point through the utilization of VBA and Active X Controls. • Identify data-quality issues in the data warehouse, compile follow-up items for the LOB’s and incorporate updates to the interface inventory

• Project lead on all internal system development and enhancements; Coordinated and proctored meetings with internal users and management; Acquired and transferred requirements to the Business Requirements Documents, utilizing Use Case narratives; Designed, developed, programmed, and implemented all departmental applications; Trained staff and provided technical support for departmental applications• Developed, administered and maintained internal database applications utilizing MS Access, VBA, and SQL; Significantly reduced data storage requirements for the applications by as much as 66% from previous versions by normalizing the data and improving data-integrity• Created, maintained, and scheduled batch files to handle routine operations such as database compacts, back-ups, and replications• Created and implemented automation to handle such tasks as the creation and ensuing reconciliation of invoices through AIG accounting, client subscription period renewals, generation of letters, and creation of dynamic calendars; The automation reduced man-hours by as much as 90% throughout the department while ensuring reliable data; Established links to various external systems to provide accurate information and improve data integrity

Served as an internal resource for a middle-market consulting firm developing an in-house Purchasing Database using MS Access and VBA. This system was used as the exclusive agent for all IT purchases, including a 6.5 million dollar Win NT migration, along with producing reports that served as the primary source for all budget and forecasting done by the controllerAssisted procurement manager with assignments and special projects while processing orders for all hardware and software requests for Buck worldwide

Us

Provided technical support for all software used to create the publicationCreated, maintained and updated all Lotus Notes ID and NotesMail account information to be used by the