Richard Sisto Email & Phone Number

Sidney, New York

Seneca Falls

Senior Systems Analyst, Master Data Management / Analytics 2017 to 2018Functioned in role of database administrator (DBA) while company changed from multi-platform to single SAP instance. Developed strategy to manage configuration, design, security, and patch management of new platform. Extracted data from multiple systems and transformed to desired format for importation / maintenance in central repository. Used MDM tool, Profisee, to aid in data transformation and cleansing.• Created single SAP data instance for industrial process (IP) by combining customer, vendor, and material / parts records from 2 SAP instances and Legacy system.• Reduced customer and vendor master-file redundancy 30% by devising golden records to sustain data consistency and integrity.• Decreased man-hours significantly with real-time enterprise resource planning (ERP) integration and workflow, establishing process to handle existing master data and future data input / maintenance.• Collaborated with business intelligence (BI) team to de-duplicate vendor file with both English and Chinese characters from new business unit, providing clean file that could be imported into QlickView tool for reporting to corporate executive team.• Handled patch management for Windows servers, housing GETPAID, GAIN, and HYPERION applications.

Seneca Falls, New York

Collaborated with The Financial Shared Services teams in Seneca Falls and the UK, translating their needs into high quality IT systems. Planned and directed the analysis of complex business problems to be solved with automated systems. Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost-effective and met user requirements. Developed test plans for Unit, System and QA stages. • Developed and Managed Interface process with domestic and foreign banks and ITT business units.• Automated the Lockbox process using the iSeries Robot Scheduler. Saving 10-20 man hours weekly. • Researched and resolved all assigned call tickets escalated from the Tier l/ll support team using Service Now. • Coordinated efforts with functional/quality assurance testing leads to make sure all forms were tested successfully and signed off before implementation.• Implemented IT system controls to comply with internal Security audit and new SOX legislation. • Analyzed impact of financial applications on the Legacy System vs. new applications. Resulting in interfacing legacy files into Web based and Windows Server hosted, financial applications.• Provided Documentation Management ensuring all testing and test results were maintained on an online system for use by developers, process stakeholders and upper management for status reporting.

Solvay, N.Y.

Programmer / Systems AnalystMet with department heads to determine project needs, developed and implemented specs, and collaborated with cross-functional team to explain responsibilities and assign target dates. Developed Gantt chart and led project team meetings to achieve cost target and set launch date. Developed and introduced test scripts and final-system implementation plan. Conducted troubleshooting, debugging, testing, and documentation.• Maintained and enhanced legacy systems using RPG, RPG/ILE, and COBOL on AS/400.• Navigated $25K annual savings in paper, printing, and distribution costs by developing and managing archiving-system, using RJS software to store documents from multiple databases.• Improved month-end processing flow, reducing time 25%, that allowed users to access system sooner.• Introduced and sustained nightly backup-tape database using Access.• Increased cash flow 18% by revamping and fully automating invoicing and billing processes.

Syracuse, New York Area

* Designed and managed Y2K project plan. * Converted data areas, files, programs, procedures and scripts to be Y2K date compliant.* Programmed in RPG, RPG IV and RPG/ILE on an IBM AS/400 iSeries.* Converted company's fiscal year from a July-June system to a January-December system. * Troubleshoot and solve various company-wide user problems on a daily basis. * Trained newly hired programmers.

B.S., Information Technology

College Prep - Regents Diploma, College/University Preparatory And Advanced High School/Secondary Diploma Program

Coursework Towards Mba