Stephen Tripi Email and Phone Number

Day to day contact on account and liaison between external clients and internal technology teams. Interface with client to gather requirements for new functionality and changes to existing functionality, including the planning, execution and delivery of change requests and maintenance of related documentation, including Business Requirements, Process Flows, and Status Reports. Management of ongoing support services. Monitor customer database health. Ensure customer satisfaction by proactively providing advice to client and internal account director. Guide clients on database industry best practices for their solution. Provide high level quality assurance for data issues and change request and guide client through user acceptance testing. Create and execute SQL queries to answer business questions. Deliver necessary updates and weekly status on projects and production status. Serve as SME on client database

Manage all aspects of integration projects, including interfacing with clients and internal technical resources.Point of contact for existing integrations including production support and enhancement requests.Interact with client legal teams to negotiate appropriate legal documents for secure data exchanges. Setup and maintain automated and manual FTP/SFTP processes related to TPS (Third Party Substantiation) processing.Created processes to transform incoming data into formats compatible with Alegeus systems.Created automated processes to streamline tasks associated with customer account creation and re-associationMaintenance of EDI and Web Services documentation.

Work with client service leads to translate business requirements gathered during discovery sessions in to technical requirements.Manage small sized projects from inception to completion.Work with project manager to implement large sized projects.Act as liaison between technical departments within e-Dialog and external clients and vendors.

Work with department heads and end users to gather requirements for enhancements to systems that support daily operations.Support end users of production systems including investigation and resolution of production issues.Ensure systems are compliant with state and federal healthcare reform initiatives, working with stakeholders to implement enhancements necessary for regulatory compliance.Follow projects through system design life cycle, including assisting in user acceptance testing as necessary.

Gathered requirements for systems used to ensure that all transactions fall within legal and prospectus guidelines for Fidelity funds.Designed and wrote system specifications, ensuring that system meets all complex user needs while remaining as user friendly as possible.Performed quality assurance testing of newly developed system.Worked with end users to perform acceptance testing.Provided troubleshooting of compliance software installations.Was in charge of compatibility testing to ensure compliance software functions on all Fidelity computer system builds.

Gathered requirements for, created and modified specs in order to add or change functionality to processes associated with client database.Monitored and provides QC of daily data feeds entering client database.Ran Unix scripts to test data from new feeds and vendors prior to implementation.Provided client support for tools necessary to access database, including access administration and troubleshooting of tools as well as general training and assistance.Provided backup to systems administrator, including monitoring of scheduled processes and troubleshooting of failed processes. Wrote and modified Unica campaigns to administrate customer rebate programs.

Entered purchase orders into SAP and perform any research necessary to enter incomplete purchase orders to enable shipment of product and ensure proper recognition of revenue.Performed adjustments to orders that need alteration or have been entered incorrectly.Supported customers and sales staff, including resolving customer satisfaction issues, by providing appropriate information available through SAP or taking other action, such as expediting order requests when necessary and escalating issues when appropriate.

Developed and streamlined process to create electronic copies of and index contracts and legal documents.Gathered end user requirements in order to design forms for the collection indexing information.Performed training for and end user support of PaperVision system.Performed troubleshooting and used Microsoft Access to perform analysis of PaperVision database to determine the cause of missing documents.

Created e-mail marketing campaigns through use of Responsys system.Devised time-saving techniques for data cleanup through the creation and execution of macros in Microsoft Access and Microsoft Excel.Used SQL in order to mine data necessary for finding people in various demographic groups in order to effectively market directly to customers.

Provided customer support to users of RSA Online system through phone and e-mail communication.Provided end user support of data mining tool Diver, including creation of documentation, Diver reports and Diver e-mail broadcasts as well as Diver access administration.Maintained, developed and supported corporate Intranet and Internet websites and tools such as polling software. Gathered system requirements for, researched, tested, debugged and aided in final implementation of new software and systems.Measured employee productivity by mining data from Oracle database through use of BI-Query database reporting software.Logged and monitored end-user support tickets including computer configurations, software installations, troubleshooting, back-end configuration and system access administration through Clarify. Administered system access administration through ACE Server and ClearTrust.

Designed Access database to process and analyze statistical information relating to research consultations.Created forms and methods for data collection.Mined required data through query construction and execution.

Developed code through Allaire Homesite and made use of ActivEdit software in order to convert 500+ page library web site from HTML to dynamic database driven protocol.Maintained integrity of site and resolved issues through troubleshooting.Nominated for Babson employee of the year award.