Fairfield University Database Analyst
Resume:
William F. Vollkommer
Chatham Township, N.J., 07928
Telephone: 973-***-****
Mobile (Primary): 973-***-****
E-mail: ***********@*******.***
Summary
Operations and associate Project Management professional with strong data communications and project management experience linking operational systems to the strategic initiative of the business. Demonstrated ability to improve systems and organizational effectiveness by identifying and resolving large customer data communications billing and software deficiency issues related to software vendor releases through skilled systems analysis and testing, problem-solving, and root-cause analysis skills. An effective communicator and team player with a successful record of identifying root-cause solutions for corporate data communication clients. Successful software implementation, systems integration, and associate project management experience.
Education: Fairfield University, Fairfield, Connecticut
Bachelor’s degree: 1977
Major Course Work: Management Information Systems, Business, Calculus, Business Law, Economics, Business Ethics, Statistics.
Computer Skills: MS-Windows, MS-Excel, MS-Word, MS-PowerPoint
Database packages: Paradox
MCI School of Telecommunications, Internal courses include:
Global Messaging Electronic Data Circuit Switching Systems: T DAX (Digital Cross-Connect) Training, March, 2002. Phillips DS-714 Telex, Plantronics Eltex V Omega, CSX Router for Direct Distance Dial Access, NSG Concentrator Packet Node, IMPACS X.75 Packet Data Node.
Professional Experience:
April, 2018 – December, 2018: Kelly Services- Manpower, Inc. client:
C.R. Bard/ Becton Dickinson, Murray Hill, New Jersey, a global medical technology company.
Title: Business Data Analyst: Updated excel spreadsheets for a manual matching process of customer addresses for hospitals, urgent care, and assisted living facilities for uploading into the company’s MDM (Master Database Management) system. Successfully analyzed and matched on an excel spreadsheet containing 55,000 call records.
July, 2017- August 2017: Updated Excel 2016 Intermediate and Advanced P.C. skills at Zip Computer Training & Resources, Chester, New Jersey.
August, 2015: Actively Seeking Employment.
June 2004 – July, 2006: Verizon Business/MCI International Data Services, Piscataway, New Jersey.
Title: Senior Database Analyst, Global Technical Services (GTS) Business & Engineering Support.
Duties: Prepare International customer address and Customer Premise Equipment (CPE) detail information to be used in the International maintenance process supporting all ROW managed services devices. Utilized MS-Excel spreadsheets to notify overseas field maintenance of hardware and software configurations for ongoing CPE maintenance contract support.
April, 1991-June, 2004: MCI International Data Services, Piscataway, New Jersey.
Title: Manager II – Systems & Service Analysis Department within Operations and Technology Division. * Promotion to Manager II, 1991
Duties: Managed the International Messaging Switching Systems connecting over 120 International Administrations. Provided detailed systems analysis support for all messaging platforms, fault code analysis, billing/settlement variance analysis with least cost routing carriers and other IRC carriers. Worked with Systems Engineering to identify system software deficiencies and recommend solutions. Validated and verified call record analysis for the successful implementation of weekly system software release updates for the global messaging systems and platforms.
Managed a team of six systems analysts with responsibility for the operation and performance of real-time and store-and forward global messaging systems and platforms for data circuit switching systems and their circuit call completion rate efficiencies for instantaneous global communications. Managed interconnections and circuit switching signaling protocols interfacing with over 120 overseas countries’ Postal, Telephone and Telegraph administrations.
Maintained budget authority for the Systems Analysis department of approximately $300K. Consistently managed group budget with a budget surplus for 10 consecutive years.
Developed Store-and-Forward to Real-Time message delivery methodology with Systems Engineering to modify and enhance the retry algorithms to minimize repetitive calls to resolve excessive settlement payouts to overseas administrations, resulting in significant financial savings. Developed a SAFE System algorithm enhancement to match on the first four numeric characters, matching expected answerback versus received answerback. Realized company financial savings of $34,000 dollars per month or $408,000 dollars annualized savings in settlement payouts.
Developed a new Store-and- Forward (SAFE) algorithm answerback mismatch checking logic test for four (4) alpha characters matching after a pre-message answerback mismatch. Realized estimated savings of $4, 400 dollars per month or $52,800 dollars annually.
Oversaw the Customer and Financial Integration Subcommittee of legacy TRT Telecommunications Ft. Lauderdale Messaging subscribers onto the MCI International Data Services Network. Completed a two-three year systems integration project in (9) months through a team-oriented approach.
Supported Systems Engineering with the consolidation of the Global Telex Network, including the cutover to the replacement P.C. based equipment from the legacy Cablegram/Telegram switches. Monitored and identified software anomalies with the new modified vendor provided software to handle the new replacement billing process.
Directed the development of Traffic Reporting specifications for new NSG X.75 based Impacs packet switching reports to monitor the migration from CSX DDD access nodes to NSG DDD access nodes. Identified unknown DNICs (Destination network identifier codes) that were previously unrated and unbilled. Recommended software modifications which resulted in extra monthly ratings and billings
May, 1985 – April, 1991: MCI International Data Services. Piscataway, New Jersey and Ft. Lee, New Jersey.
* Promotion to Manager I, 1988
* Promotion to Supervisor III, 1987
Title: Manager I – Systems & Service Analysis Department.
Duties: Managed the Integration of MCI International and RCA Global Communications Messaging systems acquired in 1998. Supported System Engineering projects to consolidate the Telex network. Developed specifications for management traffic reporting tools, including databases, maintenance tables and download file transfers.
Managed the MCI International Data Services Management Traffic Reporting System for the main revenue-generating real-time messaging and store-and-forward messaging systems. Provided detailed root cause systems analysis for Electronic Switching Data Systems and Platforms to detect software deficiencies and recommend solutions.
Provided analysis of settlement minute variances with International Record Carriers and Least Cost Routing providers to identify the root cause of billing discrepancies related to electronic switching systems. Worked with Finance and Systems Engineering to resolve rejected settlement records from the billing process.
Tested all new telex switch software releases with I/T call record analysis to ensure no adverse impact occurred to our global customers’ communication data networks nor to their billing invoice records. Resolved all billing discrepancies related to customer’s unique vendor provided software interfacing with the MCI International Data network.
June, 1982- May, 1985: MCI International, Ryebrook, New York.
Title: Supervisor II
Duties: Maintain Management Traffic Reporting System and Switching System Analysis for MCI International’s Telex Switching Systems.
Improved service analysis tools to provide outstanding circuit quality for all messaging platforms by working with I/T Application Development to develop reports based on billing call record format linked to the circuit the call was routed via.
Feb. 1979 – June, 1982: Western Union International, Inc. New York City, N.Y.
Title: Telex Traffic Analyst
Duties: Maintain circuit efficiencies and network performance for Western Union International’s global Telex network.
Awards and Accomplishments:
MCI International Excellence in Service Award – 1993.
Presented in recognition for outstanding service and dedication provided in the integration of the MCI International Systems Integration Project. (Integration of the MCI International and RCA Global Communications legacy Messaging Data Switching Systems.)
Contact this candidate