Customer Service Sql Server

JOHN NICODEMUS

***** *******

Houston, TX *****

(281) 732 - 6642

**********@*****.***

SUMMARY

Accomplished IT professional with 10 years of development experience. Outstanding problem-solving and

analytical skills with proven ability to translate business needs into solutions. Well developed

communication skills leveraged in working with decisions makers, senior management, customers and

team members. Productive in both team-based and self-directed projects. Leads by example.

PROFESSIONAL EXPERIENCE

FISERV (FORMERLY CHECKFREE CORPORATION - FORMERLY APHELION) - Houston, TX 2002-2009

Database Analyst(2007-2009)

Provided database programming support and troubleshooting to multiple departments. Helped resolve

application problems as they pertained to the data. Performed business analyst tasks for the Product

Management team. Proactively communicated and collaborated with external and internal customers to

analyze information needs and functional requirements and produced appropriate document artifacts.

Developed T-SQL scripts to change data en masse resulting in dramatically reduced work load

for billing specialists.

Saved countless hours of management’s time by writing custom T-SQL queries and reports

enhancing management’s ability to make accurate and timely decisions.

Interfaced directly with high profile customers to produce custom T-SQL queries reports resulting

in increased customer satisfaction.

Performed key role as technical support to the customer service group. Resolved critical issues

that Software Development was unable to immediately address, greatly reducing response time

to customers.

Identified and resolved discrepancies among data output resulting in increased customer

confidence.

rd

Implemented ETL solution to interface with 3 party auto dialer replacing slower and out dated

internal system.

Manager, Software Development(2005-2007)

Managed team of 8 developers that designed, developed, troubleshot and debugged Client-Server and

Web based software programs for the Health & Fitness industry. Aligned development strategy and

resources with business goals.

Improved developer efficiency by establishing programming standards, architecture and

framework.

Managed team of developers during critical phase of Checkfree acquisition of Aphelion.

Integrated development teams and collaborated with teams across matrix organization to create a

new software suite within aggressive time frame under new standards, architecture, RUP

processes, and infrastructure. Successful transition and speed of release was critical to customer

confidence and positive perception of acquisition.

Ensured projects met deadlines and quality standards to achieve Six Sigma goals.

Identified and evaluated industry trends and made recommendations to maintain pace with

technological progress and business needs.

JOHN NICODEMUS PAGE TWO

PROFESSIONAL EXPERIENCE(continued)

Programmer Analyst(2002-2005)

Elicited, analyzed and documented business requirements and processes.

Designed and developed web based scheduling and workout tracking solutions

rd

(VB.NET/JavaScript/Infragistics 3 Party controls/SQL Server) for the Health & Fitness industry.

Designed and developed a Winform document scanning solution (VB.NET/Web Services/SQL

Server) for the Health & Fitness industry.

Interfaced directly with the customer and the Customer Support team to resolve deployment

issues and bugs.

COVERCRAFT INDUSTRIES, INC. - Pauls Valley, OK 1998-2002

Programmer Analyst/Systems Administrator(1998-2002)

Managed IT staff to ensure project requirements and deadlines were satisfied.

Developed ETL solution (VB/SQL Server) to integrate sales data from manufacturing system into

Sage Acuity financial system, significantly reducing work load on accounting staff.

Integrated UPS World Ship program into company’s manufacturing system resulting in access to

real-time shipping data.

Maintained and Administered Servers (NT/2000, SQL, Exchange, Terminal, IIS and Proxy).

RHI CONSULTING - Oklahoma City, OK 1998-1998

Programmer Analyst (1998-1998)

Designed and developed an inmate parole tracking solution (VB/Crystal/SQL Server) for

Oklahoma’s Pardon and Parole Board, replacing eight separate DBase systems, and allowing for

quick access to meaningful data during parole board reviews.

INFOTECH SOLUTIONS GROUP, INC. - Houston, TX 1995-1998

Consultant – Programmer Analyst(1995-1998)

Managed the development process for several projects within the framework of Lyondell’s chosen

methodology.

Designed and developed an employee training and certification tracking solution (VB/SQL Server)

to replace Access version. Developed ETL solution to import employee data from Mainframe.

Collaborated with other developers to recommend standards and process improvements.

APPLE COMPUTER, INC. - Houston, TX 1994-1994

Apple Student Representative

Served as liaison between Apple Account Executive and campus faculty, staff and students.

Organized and promoted on-campus Apple events.

LOCKHEED ENGINEERING AND SCIENCES COMPANY - Houston, TX 1989-1993

Systems Administrator(1989-1993)

Managed 100+ Macintoshes in heterogeneous computing environment.

Contributed to Total Quality Management (TQM) initiatives for hardware/software inventory

control.

EDUCATION

BA, Computer Information Systems, University of Houston – Clear Lake

PROFESSIONAL TRAINING

Six Sigma Operational Excellence

Six Sigma Statistical Excellence

Contact this candidate