John E. Email & Phone Number

Haverhill, Ma, Us

• Provide IT solutions to meet internal and external business needs. Manage full project life cycle, including identification and documentation of functional specifications, evaluating development vs. commercially available solutions, full integration testing, production implementation, and support.• Created high-level IT Data Management roadmap outlining plan to build centralized database environment and improve efficiency, flexibility, and ease of maintenance of the reporting infrastructure.• Ensure consistent performance by working closely with the CTO and business managers to form and achieve strategic IT objectives, implement maintenance and improvements routines, design secure infrastructure, develop policies, and employ vulnerability & risk assessments procedures.• Design a business grade DBMS and reporting and processing solution by analyzing disparate data structures of current reporting architecture, identifying weaknesses, and forming innovative solutions.• Consistently expand the scope of responsibilities beyond the role’s definition to support the ever-changing business needs and take part in large-scale projects.

• Reduced time spent on monthly report production by 70% and on the daily settlement process by 33% by batch file scripting and re-prioritization of processing events. • Met end-user requirement to populate pre-existing Excel templates with mainframe report data using DocuAnalyzer, perl, MS Access, and batch scripts. • Eliminated manual data entry for daily payment processing using E-term (TN3270) application script, MS Access, and batch scripts.• Increased customer satisfaction & retention rates by working with cross-functional teams and taking part in IT solutions customization process, collecting, analyzing, and converting client & user feedback into features, as well as conducting competitor analysis and market research.• Continuously increased productivity by identifying inefficiencies in reporting processes, created a PowerShell script to automate IDP report processing, which resulted in significant time savings for the team. • Addressed business pain points by working cross-functionally and partnering with sales and customer service teams, analyzing, and relaying information to R&D and Product Management leaders.

• Delivered credit card products and services as defined by clients' business needs. • Wrote and executed project plans ensuring consistency with PMBOK methodology.• Provided timely written and verbal status updates as a means to manage the needs and expectations of internal and external stakeholders. • Performed technical systems functions as defined by project plans.

• Directed 5-member team that provides 24X7 network and PC support as well as data processing and graphic design services. • Generated annual gross revenues of $385,000 through data processing, telecommunications, and graphic design services. • Completed annual Payment Card Industry (PCI) security audits. • Collaborated with service departments to implement and cross-sell technology solutions that enhanced clients’ ability to monitor and provide service to business and consumer customers.

• Translated clients’ written and verbal business requirements into custom database queries using Oracle SQL. • Extracted and formatted monthly database reports using MS Excel. • Identified and acquired software used to perform automated data entry into mainframe environment. • Performed automated data entry in response to credit card data compromise events.

• Researched and fulfilled merchant credit card customer inquiries. • Mitigated risk and provided proactive service through outbound call campaigns. • Developed MS Access inventory database and recovered $12,000 in unreturned POS equipment. • Trained staff how to use database.