Software Sql Server

Alan B. Collette Jr.

** **** **** *****: (***) **6- 9572

Bloomfield, CT 06002 Email: **************@*****.***

OBJECTIVE

Exceptional Information Technology professional with leadership experience

in the software development lifecycle including production maintenance and

support. Thrive and adapt in deadline driven, information intensive

environments with strong analytical and organizational skills. Seeking a

position in the field of information technology within a reputed

organization where my extensive knowledge and problem solving can be

utilized.

PROFESSIONAL EXPERIENCE

Daticon EED - eDiscovery Services Provider, Norwich, CT 2003 -

2009

Data Analyst

. Performed SQL server creation and maintenance on databases, tables,

stored procedures, as well as perform back ups and restorations.

. Analyzed optimization of database functionality and performance.

. Gathered requirements and produced routine and custom reports utilizing

simple and complex SQL queries.

. Troubleshot and debugged application database issues.

Technical Analyst

. Led the implementation of search technology into a new electronic data

discovery process.

. Oversaw the timely integration of new applications and software.

. Designed new means for processing customer data to meet unique needs of

each client.

. Configured databases to integrate business processes with new software

and turn from conceptualization to production.

. Maximized business process efficiency by working with software developers

to optimize and debug application software.

. Facilitated communications with vendors to optimize software product

configurations and administer daily data extraction and search procedures.

. Developed and documented specific operating guidelines for software

products to increase accuracy of data yield.

. Utilized team approach to coordinate activities of analysts working on

different phases of implementation.

. Coordinated quality assurance and performance improvement as well as

documentation for these areas.

. Developed and administered web demonstrations of concept and keyword

searching for e-discovery utilizing Autonomy Search Technology and

interfaces.

Operations Specialist

. Managed a team of 6 people and directed their actions to achieve client

goals for timely data discovery and processing.

. Developed technical specifications for system enhancements to improve

business processes.

. Maintained data in a high volume ASP document repository through

modifications within proprietary application as well as data manipulation

using MS Access and MS SQL Server.

. Trained and assisted team in data formatting and loading to ASP utilizing

tools such as MS Excel, MS Access, MS SQL Server, and text editors as well

as proprietary tools.

The Innovation Group - Insurance Solutions Provider, Danbury, CT

1995 - 2002

Technical Consultant

. Developed graphical interfaces of insurance software systems using

VisualAge for Java.

. Programmed web software application using VisualStudio and Visual Basic,

XML, and JavaScript.

. Implemented Java WebSphere web solutions for property/casualty insurance

systems utilizing JSP, HTML, and XML.

. Assisted in implementation of Java applet version of graphical interface

for software systems.

. Technical Lead of international project that implemented software

interface which included resolving functionality issues, debug code

problems; implemented framework changes; evaluated, analyzed and resolved

problems experienced within processes or software solution.

. Oversaw and trained teams of 5 to 30 developers in Object Oriented design

and programming practices as well as proprietary development procedures.

. Developed realistic timelines and presented to management.

. Condensed and organized requirements as supplied by business analysts.

. Provided onsite support to customers to customize processes and interface

designs to maximize product functionality.

Systems Engineer

. Worked in a demanding, high volume international software development

environment.

. Performed source code management including release deployments to

internal development and client production environments.

. Responsible for the set up and maintenance of COBOL/CICS/DB2 environments

in mainframe and client/server platforms.

. Supervised technical training of 3 engineers in source code management,

environment set up, and technical troubleshooting.

. Developed, maintained, and implemented delivery and installation systems.

. Performed client installations and provided support of software system at

client sites.

. Performed routine maintenance on PCs including software and network

interface card installations.

. Maintained LAN servers including creating, modifying, and deleting user

ids and email profiles.

TECHNICAL SKILLS

. Languages: SQL, Visual Basic, Java, ASP, JSP, JavaScript, HTML,

XML, PHP

. Operating Systems: Windows Server 2003, Windows XP, Windows NT,

OS/390

. Databases: SQL Server, DB2, MS Access

. Web Servers: Apache, WebSphere, IIS, Resin

. IDEs: VisualStudio, VisualAge for Java

. Search Engines: Autonomy, Concordance, BRS

EDUCATION

BS Computer Science Villanova University, Villanova, PA

Management courses Rensselaer at Hartford, Hartford, CT

PROFESSIONAL MEMBERSHIPS

. Association for Computing Machinery

. IEEE Society Affiliate

Contact this candidate