Customer Service Software Engineer

Hershel Cohen

216-***-**** home

216-***-**** cell

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

CAREER SUMMARY:

Computer Software Engineer with more than 11 years experience developing

and maintaining SQL databases, with a strong track record of accuracy and

reliability. Demonstrated expertise and experience in:

. SQL Server

. Transact SQL (T-SQL)

. SQL Query Analyzer and Enterprise Manager

. Analyzing query performance and index tuning

. Writing SQL stored procedures

. Bringing SQL data into Microsoft Excel

. Creating T-SQL procedures that execute at set times automatically

. Creating Views and Triggers

. Nested sub-queries

. Writing Cursors in Transact SQL

. Creating user friendly interfaces using VB 6.0 and VB for Access/Excel

. Writing Active X objects and Class Modules in VB 6.0

. VB for Microsoft Office, including VB modules in Access and Excel

EXPERIENCE:

Senior Systems Analyst

TRX / Travel Analytics, corporate travel technology and consulting

Cleveland, Ohio. (Virtual Office) 2000 to August 2009

Travel Analytics was founded in 1999 and quickly became the travel

industry's leading independent consultancy, based on its innovative

analytical solutions and superior customer service. It was acquired in

2006 by TRX, a travel technology firm best known for developing and

hosting Expedia's travel operations software.

Key Accomplishments:

New Product Development

. Collaborated closely with Travel Analytics' CEO to create ingenious

solutions to a wide variety of travel procurement problems in the

airline category

. Was the lead developer for the company's key SQL and VB-based

applications and played a key role in the company's growth and success

. Key member of a small team that developed an innovative and patent-

pending tool for analyzing hotel data

. Contributed to an award-winning tool for measuring airline CO2

emissions

Core Product Enhancements

. Responded to the application users to modify and improve the core

production applications including business logic and user interfaces

. Managed the process of applying new code to meet frequent industry

changes and client-critical deadlines

. Made improvements to existing applications to yield faster and more

sophisticated analyses, which resulted in significant new revenue and

enhanced client loyalties

. Always took pride in delivering very accurate and high quality work

Database Analyst / Pricing Analyst

Permanent General Assurance Corporation aka "The General" (non-standard

auto insurer)

Cleveland, Ohio. 1995 to 2000

Key Accomplishments:

Database Analyst (1999-2000)

. Took the initiative to build analytical tools to help management better

understand the data used for decision-making. For example, combined

premium and loss data with marketing data, so that management could set

rates to maximize profits and sales.

. Built custom query tools and managed database server for users in Ohio,

Tennessee, and California. Conducted training in use of custom built

tool.

. Built application to help management monitor advertising expenditures.

. Collaborated with an IT consulting firm to build a comprehensive data

warehousing system which allowed data users to see premium and loss

data by rating variable.

Pricing Analyst (1995-1999)

. Developed a unique program that analyzed the competitiveness of the

product against other companies' products across all rating variables.

. Developed logic to price auto insurance so that it could be sold both

competitively and profitably

. Worked with sales agents to help market the product and understand the

pricing strategy

. Worked with customer service agents to properly implement underwriting

standards

EDUCATION:

--BA degree in Economics from Oberlin College, 1991

--Private Pilot's license earned in 1990

Contact this candidate