Sally A. Madeira
76 Hamilton Avenue
Southington, CT 06489
Home: [Send email to request phone number] 76-9158 Cell: [Send email to request phone number] 19-5109
OVERVIEW
Senior Technical Consultant with more than 20 years experience in the technical
field including the Banking and Insurance Industries.
TECHNICAL EXPERIENCE
Languages:
Visual Basic 4.0/5.0/6.0 Enterprise, VB.Net, ASP.Net, Microsoft Access, PL/SQL,
SQL, Transact SQL, SQLPlus, Java – J2SE, Microsoft Access, VBA, JavaScript,
VBScript Win32 API/VB API, FoxPro, Visual C/C++, Visual J++, Lotus 123 Macro
Development, Paradox 4.0, HTML, XML (some), PHP, IIS, ADO
RDBMS:
ORACLE V8-8i/V9i/V10g, SQL Server V6.5/7.0, Pervasive SQL 2000
Development Tools:
Embarcadero RapidSQL, Toad, Embarcadero DBArtisan, Stylus Studio 2006, Eclipse
3.1, JDeveloper, Visual Studio 6.0, Frontpage, DreamWeaver UltraDev, Embarcadero
Erwin, DataJunction, DataIntegrator, DJ Engine, RAD, ClearCase,
Crystal Reports V7/V8/V10
Operating Systems:
Windows 3.1/95/98/XP/NT/2000, MS DOS, Novell, UNIX, Banyon Vines
References:
Available Upon Request
PROFESSIONAL EXPERIENCE
Senior Technical Consultant, VP
Bank of America
Glastonbury, CT
Employee 7/2001 to Present
Primary Developer for the Stucky Data Consolidation System (SDC). The SDC
Client is developed using Visual Basic 6.0. Responsibilities on this project
include development for the conversion mapping of Btrieve Data into Oracle using
DataJunction Data Transformation tool and SQL*Loader. Main Development tools
consist of Oracle RDBMS 8i, 10g, PL/SQL, SQLPlus, Crystal Reports. Currently in
the development phase of redeploying the SDC Client Front End using J2SE
Technology, Jface, SWT, XML. Currently mentoring other Associates as the Lead
Developer. Other responsibilities include Database Development for the Bank of
America Client Website.
Madeira Consulting
Client: Arbors
Manchester, CT
Glastonbury, CT
Consultant 2002 to Present
Primary developer for the Residential Information System (RIS). The system was
developed using Microsoft Access 2000, Microsoft Word 11.0 Object Library, ADO,
MSO. RIS is a system design to enter new Residents who are admitted to the
Arbors Rehab Facilities. The system tracks new and existing residents and prints
out all the necessary admission documents. The system also tracks insurance
information, length of stay quotas and room and board costs. Currently
redesigning the system using Visual Studio 2005, VB.net, ASP.net with an Access
backend.
Software Sensibility, Inc.
Client: Fleet Capital Corporation (FCC)
Glastonbury, CT
Consultant, 10/97 to 7/2001
Provide consulting services and systems development for Fleet Capital’s
Marketing and Systems Department. Major responsibilities include designing,
developing and implementing in-house applications.
• Developed Data Warehouse for FCC’s Stucky Asset Based Lending Financial
system. Data from 8 remote sites consolidated using Visual Basic 6.0,
DataJunction, SQLPlus, SQLLoader and PL/SQL Procedures and Packages into an
Oracle 8i database. System was reengineered from a Paradox 4.0 system.
Developed over 180 reports using Crystal Reports 7.0 to report on consolidated
data.
• Lead developer for FCC’s Intranet web site. The site was hosted on a
Linux/Apache platform. Developed the site using Dreamweaver Ultradev and
Net-It-Central. The business plans for Intranet based applications are currently
being reviewed with plans to use Oracle, PHP and Perl technology.
• Designed, developed and implemented Custom/Executive Reporting System in
Access 97 to replace Lotus Notes reporting for client information.
• Designed, developed and implemented T&E Custom Reporting Application for EDP’s
e-Expense System to track expense information for FCC Employees. Developed in
Access 97 with WIN32 API.
• Designed, developed and implemented FCC’s General Ledger Interface for EDP’s
e-Expense System. Developed using Visual Basic 6.0/ADO.
• Designed, developed and implemented the Deal Information System (DIS). DIS
was designed to provide a single resource that captures information from FCC’s
Lotus Notes Client Database. Developed in Access 97 with WIN32 API.
Software Sensibility, Inc.
Client: Business Lenders, LLC
Hartford, CT
Consultant, 10/98 to 6/2000
Designed, developed and implemented Marketing Information System (MKIS) to track
referral sources, prospects and borrowers so employees can share information in a
centralized location. MKIS was developed using Access 97, Visual Basic for
Applications and Replication Technology. The system was implemented at ten
remote sites throughout the country. The MKIS project was initially designed as
an Intranet based application using IIS4.0 and ASP but because of the size of the
company and network the decision was made to use Microsoft Access 97.
Software Sensibility, Inc.
Client: ReaLinx.com
New Britain, CT
Consultant, 02/00 to 2001
Designed, developed and implemented ReaLinx.com Internet Web Site, a bid
notification service for property professionals and commercial contractors.
Currently still in development, ReaLinx was designed using Dreamweaver 2.0, Adobe
Photoshop and Perl.
Software Sensibility, Inc.
Client: ConnectiCare
Farmington, CT
Consultant, 4/97 to 7/98
Consultant/Applications Developer for ConnectiCare’s Small Group Department.
Responsibilities include design and development of Small Group Front End, Renewal
System and Small Group Quoting System. System environment and components consist
of Visual Basic 5.0 Enterprise Edition, SQL Server 6.5, Interdev 1.0, Crystal
Report Design and Development and DCOM. Responsible for maintaining SQL Server
tables, triggers and Stored Procedures.
Software Sensibility, Inc.
Client: USA Soccer School of Excellence, Inc.
New Britain, CT
Consultant, 6/96 to 6/97
Lead Developer for Soccer Made Easy 1.5. Soccer Made Easy 1.5 is a CD-ROM based
educational soccer program geared towards players as well as coaches. Soccer
Made Easy was designed and developed using Visual Basic 5.0 Enterprise Edition,
ActiveX, Crystal Reports 5.0, Director and Corel Photo Paint 7.0. Responsible
for Installation Setup using InstallShield2 with compatibility on both Windows 95
and Windows NT 3.5/4.0. Product was submitted to VeriTest Logo Laboratory for
the “Designed for Windows NT and Windows 95 Logo Program” to help end users
identify products that are designed for the Microsoft Windows Family of 32-Bit
Operating Systems. An overview of Soccer Made Easy can be found on
www.soccerclinics.com.
Software Sensibility, Inc.
Client: CIGNA Corporation
Consultant, 8/95 to 4/97
Consultant/Applications Developer for the Sales Workbench/Benefit Summary New
World Team. The Sales Workbench was developed for the sales force to enable the
sales team to rate small cases, make high quality proposals to clients and reduce
the underwriters’ workload. Also responsible for the design and development of
the Census Demographics and Census Import functions within the Sales Workbench.
The Sales Workbench application was developed using Visual Basic 4.0, Access 2.0
Database, Visual Basic Win16 API, various Visual Basic Third Party Controls
(ActiveX) and Complex Lotus 123 Macros.
Shawmut National Corporation
Hartford, CT
Senior Programmer Analyst, 4/94 - 8/95
Access 2.0 development for the Prospect EIS System to track customers’ nation
wide. Developed an automated process to send prospect information back to the
business lines using DDE Functionality of Beyond Mail and Word 6.0 Mail Merge.
Developed an exception and change process to track customer information in Visual
Basic 2.0/VBSQL. The Prospect Database was a Client/Server application, the
first such application developed for Shawmut. Other Development included Excel
Macro Development, Windows NT Support for Prospect EIS System, VBA Development
including Excel, PowerPoint, and Word for Windows.
First NH Bank
Manchester, NH
Senior Systems Support Analyst/Programmer, 11/93 - 4/94
Development, testing and maintenance of the First NH Commercial Loans
Application (CML), a tracking system that tracks calling activity and business
development activity for the banks commercial loans department. CML was
developed in Paradox Application Language version 4.5 for DOS as well as R&R
Report Writer. Other duties included Novell Network Administration and LAN
Support.
Electronic Data Systems Corporation
Concord, NH
Systems Engineer in Development (SED), 12/92 - 11/93
Designed, Developed, implemented and managed the Third Party liability (TPL)
Subsystem, Health Insurance Premium Payment System (HIPP) and the Accident/Trauma
database within TPL using Paradox 4.0 Application Language (PAL). Maintained the
TPL Billing System that was developed in Borland C++, Paradox 3.5, Paradox Engine
and Object Windows Language (OWL). Coordinated the setup of the TPL Subsystem in
Novell 2.01 Environment. Other duties included maintenance of the SCPPR
Subsystem that was designed and developed in Clipper and DBASE IV.
Presely and Associates
Hudson, NH
Programmer/Actuary in Training, 3/90 - 12/92
Consolidation of Physician data for the Joint Underwriting Association of
Massachusetts (JUA) for
Yearly filings through the use of Qbasic, C, and Lotus 123 Macro Development.
OTHER CONSULTING EXPERIENCE
Database Administrator, Bull-Honeywell (HN), 9/89 - 12/89
Financial Analyst IV, Digital Equipment Corporation, 2/89 - 9/89
QA, Lotus Corporation, 9/88 - 2/89
Marketing Administrative Support, Digital Equipment Corporation, 2/87 - 11/88
EDUCATION
BS - Boston College School Of Management
Business/Management Information Systems
|
