Senior Data Analyst, Applications and Report Developer
Glenn Gabianelli
16 Caitlin Circle
Naugatuck, CT 06770
Home#: [Send email to request phone number] 29-6930
Work#: 860-560-5719_
SUMMARY
I have a passion for cutting edge technologies like VB.Net and Crystal Reports
and working in a dynamic Team environment. Recently, I have been
specializing in Object Oriented (OOP)/ADO based programming written in
VB.Net,VB.ASP, Delphi 7, Oracle, Access, Crystal Reports and SQL Server based
application development systems. Business experience with Client demographics
finance, invoicing, billing, payroll, human resources and manufacturing.
However, my consistent expertise as been on the mainframe with Unix/Bim-
Epic/Cobol/Vsam/DB2 based Financial, Administrative and Manufacturing
applications.
PRIMARY FOCUS: VISUAL BASIC 8/LINQ,VISUAL STUDIOS, CRYSTAL REPORTS 11/12,
SQL SERVER 2000/2005, SQL-T, SQR, ORACLE 6i/8i/9i,
MICROFOCUS COBOL, MVS, JCL, TOAD, WINDOWS,
MS OFFICE, MS EXCEL, MS POWERPOINT AND UNIX.
SECONDARY SKILLS: VISUAL BASIC 6, HTML, VISUAL SAFE SOURCE,
DATA MODELING, MS-SQL SERVER, DATA MODELING,C,C++.
EDUCATION
Masters Degree - Computer Science - University of New Haven,
West Haven, CT - GPA 3.45 Graduated May 1999
AS - Computer Science - Naugatuck Valley Community Technical School,
Waterbury-GPA 3.75 Graduated- May 1987
BA - ECONOMICS - University of Connecticut, Storrs, CT
Graduated - May 1985
CERTIFICATIONS
C++ CERTIFICATE November 2001
SQR CERTIFICATE February 2000
ORACLE DEVELOPER 2000 CERTIFICATE October 1999
HEWLETT PACKARD UNIX CERTIFICATE August 1996
INFORMIX CERTIFICATE September 1997
PROGRESS CERTIFICATE June 1996
DB2/SQL CERTIFICATE January 1993
ORACLE DEVELOPER CERTIFICATE April 2001
COURSES
VB.Net Online training Course – Community Renewal Team
A++ Online training Course – Porter and Chester Scholl of Technology
Java Development, Enfield, CT - Asnuntuck Technical College
Manufacturing MRP Basics course, Chicago, CT - Oliver Wright.
Visual Basic.Net Online course - Accenture Technology
SAP Online Course - Accenture Technology
PROFESSIONAL EXPERIENCE
Subject:Applications Developer October, 2007 - Present
CRT-Community Renewal Team
Hartford, CT
In the dual roles as a data analyst and an application/report developer, I am
the most experience technical and analytical in-house IT resource for supporting
a variety of in-house and vendor Software systems. My primary responsibility is
to develop and document existing or proposed online systems based on in house
client requirements communicated from the directors of these systems. Systems
covered are the Universal Intake system called Captain for registering new
clients in which I developed a series of state mandated DSS-CT Department of
Social Services reports in Crystal Report XI including a new SQL Server 2005
Database, tables, procedures and DTS transfer jobs.
The other major systems that I support are a Behavioral Health system named
Sigmund, an in-house Facilities system (MS Access based) and an outside vendor
Finance system named American Fundware. In addition, I developed an online system
based in VB.Net for storing and reporting Agency and Services for CRT. This
information was used for CRT publications to be published on the intranet website
that I helped to write using the Joomla web generating software. I am currently
rewriting a new Nutrition system for the Meals on Wheel program. This VB.Net
application has been entirely written by myself as all mentioned or not
mentioned. This new Scheduling and Food ordering System consists of 10
menu-driven screens utilizing the latest window components like grid and lists
plus database binding source programming techniques. This new VB.net system’s
purpose is allow daily online meal lists while producing Driver routes, schedules
and a list of the total food preparation (breakfast, snacks and lunch)
ingredients for 39+ communities.
Senior Application Developer April, 2005 - October, 2007
Envipco
Naugatuck, CT
As a developer on the Deposit Accounting System (DAS), my primary
responsibility is to manage/support the current Mainframe CICS-Cobol
based software and develop new DAS (Deposit Account System) software.
Provided SQL-T, Delphi 7, Microfocus Cobol, CICS,VSAM, DB2, SQL*PLUS,JCL, and
Oracle skills and supporting end users. Designed the Delphi 7 Pickup Count and
Sample project specifications, menus, components as needed to add, change and
update data.
Created a MS Powerpoint training presentation with pictures and video graph
On a daily basis, I worked with internal clients on gathering analysis
in developing new recycling system invoice written in Crystal Reports
11 including Crystal reports having cross-tabs structures, command
objects, SQL expressions, and sub-reports. Developed SQL/Crystal Data
Diagrams, DTS packages and new sql procedures. Experienced in writing
ADO/OOP methodologies. Developed dozens of new JCL jobs which extracted
VSAM KSDS DB files and DAS SQL tables for data preparation Upload. I
wrote over 25 new Cobol programs.
Additional projects included maintaining and enhancing Access and
Visual Studio VB.Net and C++ programs used in the Billing System.
State of Connecticut Department of Revenue Services (Accenture)
Hartford, CT
Seniorr Analyst Programmer April,2003 - April, 2005
As an Senior analyst programmer on the ITAS DRS project for the State of
Connecticut Department of Revenue Services, my primary responsibility
is to customize Accenture’s ITAS Tax Revenue software. Provided expert SQL,
PL/SQL, Microfocus Cobol, SQL*PLUS, and Oracle/SQR skills and consulting to
management, developers, and end users.
Designed the project specifications, file types, record layouts, field
specs as needed to exchange electronic data compatible to both our and
the recipients data systems.
Created new Oracle 6i forms/SQR reports, procedures, Microfocus
Cobol programs with Unix Korn-shell scripts. These programs primarily
focused in corporate and sales tax returns. Authored and updated program
specification, file layouts, and test documentation using Microsoft
Excel and Powerpoint for publication on the Accenture website portal.
Analyzing and system testing the background procedures and
functions involved in processing. In general, this would involve
entering the data into a form and testing the data flow as it passes
through to the batch programs. I have tested numerous scripts with
hundreds of test conditions. A typical script will require the
insertion (utilizing Access) and filtration of tax demographic
conversion data from the existing revenue system database system called
MBDB to the ITAS Oracle 9i tables.
Production support and new report development using Oracle 6i
Reports. Created a variety of DRS notification reports where the data
was formulated using Oracle Reports data modeling. These reports called
upon background PL/SQL procedures which had to be modified and tested.
As a reward for delivering all my deliverables on time or
below budget and putting in over 300 overtime hours, Accenture
sponsored a banquet and a overnight stay in Boston in February 2004.
Connecticut Online Computer Center
Avon, CT
Oracle Data Analyst/Conversion Developer, April 2001 to August 2002.
INSIGHT application conversion development of Mortgage Loan System for
eight Northeast Savings and Loan Banks. In a team of two developed an online
parameter driven Mortgage Property Crystal and SQR reports as part of the Insight
Loan application.
Performed maintainance on several SQR Loan Master-detail report
utilizing control-level break logic, substitution variables, and other
efficient SQR processing techniques.Code saved in Visual Source Safe.
Responsibilities included:
Legacy data mapping and conversion
Business requirements validation and updates.
Quick learning curve of the Insight component framework
Oracle server and client side development of a separate function
within application.
Rapid and quality application development to meet customer need.
SQR training and support to internal programmers
During development process developed, deployed, debugged, and tested
data conversion procedures and functions. For PL/SQL stored procedures
and functions we have employed SQL navigator. SQL cursors with
performance tuning enhancements(outer joins, exists, unions) at times
were used to obtain maximum data processing efficiency. In order to
achieve near errorless data conversion levels a strict pre-mock
implementation test script was followed and applied.
SENIOR PROGRAMMER ANALYST , CT Community Colleges, West Hartford, CT
May 2001 to August 2002.
Main responsibilities included:
Analysis and validation of current SCT-Financial and Accounts
Receivable Business architecture, data model, tools and technologies on
a ORACLE-UNIX client server platform.
Tracked, resolved, and explained how the Banner financial systems
applies general ledger fund transfers as part of the finance customer
service team.
Lead analyst for the Data Archive application project team.
Documented and evaluated the proposed Banner system inventory
selection committee team .
Research and specification design for AR project concerned with
nighlty EDI data transaction file with the State of CT's Comptroller
office.
Solely responsible for communication to the Oracle 2000
application development team and SQR report maintenance.
In order to appropriately select the Inventory Financial Banner module
application we compiled, categorized, and prioritized requirements for
selection process. Developed a AR project for funds transfer -
redesigned forms with Oracle 2000 layout editor - to demonstrate the
outcome of using the proposed system. Object design envisioned list of
values, block-item triggers, and other OOP technologies.
SOFTWARE DEVELOPER, Quality Data Service Inc., Waterbury, CT.
June 2000 to May 2001
Main responsibilities included:
Maintained and enhanced a Payroll and Budget system for Municipal and
School system clients. Began converting Progress to Oracle 6i tables
and reports for the Utility system. Compiled an initial set of business
requirements on behalf of the client that ultimately helped the client to
understand the scope and capabilities of the application.
As the lead analyst provided initial application MS ACCESS
forms and tables for a proposed Personnel System.
Mentoring development team in Oracle 6i report builder and SQL
technologies for the Utility system. Modified a Visual Basic 6.0 Tax System with
SQL Server 7 and ADO controls utilizing the DB GRID software tool. Analyzed,
developed and modified assessor tables and queries utilizing SQL Server 7.0
Analyzer. Worked in transferring and designing Payroll and
Tax system application reports in Crystal Reports 9.0.
SENIOR SYSTEMS ANALYST, USCO LOGISTICS INC., Naugatuck, CT.
September, 1998 to May 1999
Main responsibilities included:
Maintained and enhanced the INFORMIX SUN inventory system on a UNIX
platform. Debugged for Quality Assurance the new inventory
tracking application forms.
Develop and maintain back-end components for a file interchange between the
Internet and client server application tables. Modified reports and forms based
on customer problems and requests utilizing a windows based tracking resource
software.
SENIOR SYSTEMS ANALYST, General Signal Networks, Shelton,CT
August 95 to August 1997
In a IT team of 4 that covered the entire company, we maintained the
complete QAD manufacturing and business applications for Electronic
Parts being manufactured. Performed the daily customer services for
the finance department including the lockbox transaction file and
maintaining the on-demand client-server to Excel spreadsheet MRP file.
Main responsibilities included:
Lead Progress GUI developer.
Create a client side component framework for all the application
functions.
Share experience with the rest of the team.
Developed with the company president a back-end Sales
Forecasting Internet report
DEMO Inventory Project . Developer and programmer for the online
system responsible for tracking demo-type parts to outside clients. As
part of a two man team, I developed the project specifications with
internal customers and was the project leader to the other programmer.
Extensively employed SQL performance tuning techniques. Other
responsibilities also included: code keeper , build (custom
development), packaging, and database maintenance of QAD product.
PROGRAMMER ANALYST, Sikorsky Aircraft, Stratford, CT
June 1989 to July 1995
As part of the Shop Floor manufacturing team, we maintain the complete
MACPAC manufacturing and labor applications for Helicopter Parts being
manufactured. Lead developer and programmer on the update date
conversion for the Aircraft Bill of Materials (BOM) scheduling kits.
Main responsibilities included:
Create a Oracle 6i client side component framework for the Tool
Inventory application functions. Share experience with the rest
of the team. Developed and maintained the Intermec bar code for the
timeclocks.
Awarded employee of the month twice and special award presented
by the president of the corporation
Shop Floor Project. As part of a four year massive project, I
helped develop new JCL batch processing scripts, CICS forms/Cobol
programs for sixty Shop Floor screens.
PROGRAMMER, Travelers. , Hartford, CT.
June 1987 to June 1989
Main responsibilities included:
Maintain and enhance Employee Benefits Systems
Division’s Galibs.
Billing and Commission on-line batch system.
Developed Dental reports and processed Dental Billing tapes when required.
Modified reports and forms based on customer problems and requests
utilizing a windows based tracking resource software.
RESEARCH PROJECTS, University of New Haven January 1996
Developed a 32-bit register employing Pascal and C programming
languages.
OUTSTANDING REFERENCES ON REQUEST
|
