Summary

Over 20 years of proven ability to work independently or as part of a project team, proven leadership and ability to interact with personnel at all levels within an organization. Specializing in Managed Care, Annuity and Financial Accounting Systems.

Hardware / Software / Environments

VB3, VB4, VB5, VB6, MS SQL Server 6.5, 7.0, 2000, 2005, JD Edwards database, Business Intelligence Rapid Decision / Business Object Data Integrator, SQL Server 2005 data mart design, Oracle DBM, PL/SQL, Sybase 10 11, Crystal Reports / Graphs, Extensive ODBC and ADO, HTML, MS-ACCESS all versions , , WIN95, WIN98, NT 4.0, OS/2, VS COBOL II, DB2 Distributed Data Facility, Btrieve 6.X, VSAM expert , CICS expert , EDI, C, PL/1, DDF Builder, Excelerator, Erwin/ERX, CASE Tool methodologies.

Work experience

Confidential

Architect, implement, JD Edwards's databases into Star Schema data marts. Including, Confidential Inventory, Sales, Purchase Order, Work order and AR databases. Facilitate SQL server 2000 and 2005 replication from source JDE databases into Central Repository and de-normalized data marts for reporting purposes. Typically onsite client mentoring of Data integrator work flows. Establish database indecencies to help facilitate reporting via Business Objects and Crystal Reporting.

Future Systems Design

Confidential

Ongoing maintenance, design and support for company owned STARS application and company owned invoice and billing landscaping application for S S Landscaping. Standard client/server applications in Visual Basic 6.0 with extensive reporting using both Crystal Reports and Access Reports. Database repository is Access and SQL Server.

Confidential

Design, construct and implement Crystal Reports 9.x. Create supporting Oracle 9 Stored Procedures when required, meet with end users to determine data requirements, and participate in countrywide teleconferences in order to coordinate nation wide distribution of financial reports on behalf of Multiple Sclerosis Society.

Future Systems Design, Confidential .

Two plus years designing and constructing, documenting for publication, a student and school administration system, called STARS Student Tracking Administration Reporting System advertised in Educational Leadership. The application encompasses everything from student eligibility, parent information, medical, emergency, attendance, grades, classes, report card processing, all kinds of reports, transfer to/from schools, staff and teacher administration, internal email, letter writing, and virtually anything that would become part of any school administration facility. All under one umbrella providing synergy and extreme ease of use for teachers, secretaries and administrators. Database s Access X version, SQL Server 7.0, Crystal Reports, Access X reports.

Confidential Data warehouse / SQL Server database administration and development including building tables, manage the volume of data stored within the database by designing various table purge stored procedures, assist end-users with problem resolution for data disparities. Design management reports using VB6, and Access, run, monitor and resolve all back end production Stored Procedures, design, code and execute new data Stored Procedures. Build processes and document all work.

Confidential

Provide production support for SQL Server 7.0 databases. Responsibilities include: Build and execute DTS Packages from Oracle databases into SQL Server, build tables, problem resolution for data disparities, design management reports using VB6, Access, and Crystal, run, monitor and resolve all back end production Stored Procedures, design, code and execute new data Stored Procedures. Build processes and document all work.

Confidential

Design database maintenance application. VB6 / ADO SQL Server 7.0, Access 97, various third party grid controls. Design stored procedures to capture Meta data to add, update, and delete data in large relational SQL Server database. Extremely strong analysis and design skills, and ability to work independently.

Confidential

As consultant Design Crystal Reports with Oracle 7.3 backend. Code PL/SQL Views under SQL Navigator 3. Document table and reporting relationships.

Confidential

Provide technical leadership in the analysis, design, development, of complex DB/TP SQL Server 7.0 database systems, including data mark data warehouse and reporting using Crystal OLAP and direct reporting, VB6 with ADO connection into dB's . Database design, implementation, and administration. Hot/Cold Back-ups, database performance tuning including creating tables, indexes, stored procedures, triggers, database replication. Establish a team-oriented work environment.

Confidential

Design various utility applications VB6 / ADO used in the migration and conversion of data from any database and format into SQL server, Oracle or Sybase databases. Teach/mentor staff and document methods for Crystal reporting and light HTML reporting of conversion results.

Confidential

Convert / upgrade VB3 USQA health application from VB3 to VB6 with Active-X object oriented class structures. Sybase, ADO, ODBC, VB6, Crystal 6.0. Separate R D effort to tie database into Active Server Pages via Visual InterDev. Design, and program complex Graphs using Crystal reports graphing tools. Assist in the design and development of SQL server and Access 97 stored procedures. Recommend optimal deployment strategies for client workstations using NT 4.0, Win95, and win98. All source code remaining in Visual Source Safe.

Confidential

SQL server 6.5 Systems DBA: Create devices, databases, logs, backup logs Transfer databases from / to servers Establish SQL server security Modify system stored procedures for backups Extend and expand databases and logs. Also create business application Stored Procedures, assist in the inter-operatively between SQL server and business applications designed using Visual Basic, MS Back Office, and Crystal reports Design databases and tables for business applications. Also, provide assistance in the design of Visual Basic and Crystal reports. Provide end-user support. Execute Platinum SQL releases. Establish production support and database migration standards. All work in support of Phoenix's financial investment operations.

Confidential

SQL 6.5 Application DBA / Extensive development designing / implementing very complex business Stored Procedures under SQL Server 6.5. Design and code corresponding Crystal Reports 6.0 interface, which invoked stored procedures. Re-design and maintain VB5 interface with Active X classes and ADO instantiation into Magic / Crystal / SQL Server 6.5. All in support of AP / GL / AR / OP accounting systems. All source code remaining in Visual Source Safe.

Confidential

Development and installation PHS Sales Application Eligibility and Reporting System. VB4, Access with eventual back end to Oracle. Also Maintenance of Multi-Processing Reporting Facility. VB4 16 bit VB5 32 bit , ActiveX Class processing. Oracle, Crystal 6.0 reports with stored procedures into Oracle, launched from variety of VB Active X applications. All source code remaining in Visual Source Safe.

Confidential

Develop Interactive In-Branch Demonstration Kiosk design to capture eligibility applications to process business banking and personal financial money management systems. VB5 32 bit , Access 7.0, NT4.0, MS-Internet Explorer interface, HTML interactive demonstration using Shockwave software.

Confidential

Responsible for maintenance and enhancements and distribution via the intranet, AIG's Executive Management Financial Information System Client / Server application providing senior level management in America, Canada, Europe and far East with D B confidential data and reporting. VB3, VB4, VB5, Install NT40 workstations, DB2 MDI Gateway interface, Access 7.0, Access 2.5, Crystal 5.0 reports, COBOL, CICS launched from variety of VB enterprise applications running under NT 4.0 and Win95.Software distributed via Web base intra and internet connections.

Confidential

Design develop variety of two and three tier and file server applications using VB 4.0 enterprise. Extensive use of ODBC interface into Sybase and Oracle DBMS. Design develop reports using Crystal Info Sentential Series. Applications are designed to ensure quality assurance checks in support of various existing financial Reuters applications distributed worldwide on several wide area networks. Also design, develop, and convert financial reports from PowerViewer into Crystal reports, mentor train Reuters staff to design VB 4.0 enterprise applications using variety of DBMS through the use of ODBC interface. All source code remaining in Visual Source Safe.

Confidential

Design, code and implement VB4 Enterprise distributed system. Features including distributed data replication between client lap top computers and home office central repository of both DB2 Btrieve files. VB4 16 32 bit , MS-ACCESS 2.5 7.0 , Sybase SQL Anywhere 5.0, Btrieve, Windows 3.1, Win 95, Crystal Reports, EXCEL 95, PowerPoint 95, OLE 2.0 processing. All source code remaining in Visual Source Safe.

Confidential

Project Manager, System Architect DBA. Conduct JAD sessions to re-engineer current Billing facility. Responsibilities include creation of Integrated Billing/Invoicing/Reporting/Data Warehousing Facility, Task Management System to track billing development progress. Application Software utilizes multiple MS ACCESS databases, and VB 3.0. All reports designed and coded using Crystal reports Prof. Reports OLE 2.0 document integration launched from each VB application distribution across LANs / WANs. Each system includes extensive built-in on-line application help and messaging menus with business specifications supporting ad-hoc reporting, tracking progress. Parallel effort-running applications using Visual Basic 4.0 enterprise accessing SQL Server.6.1 and MS ACCESS 2.0. All applications must meet FCC, SEC, and IRS government mandates and regulations.

Confidential

Modify an existing product consisting of 40k of code and over 40 forms. Responsibilities included: Architect, and re-build various sections of BestWare's Human Resource Personnel System, re-alignment / normalization of ACCESS database configuration to support various Crystal report linking several tables with multiple reports using Crystal and launching them under VB, conversion of proprietary date format structure into standard Microsoft and Windows date format to support international date processing, overall tuning and fixing existing program code and flow of forms. Visual Basic, Crystal reports, Chart FX graphing, ACCESS database, and various Visual Basic support controls and running under Win 95.

Confidential

Design and build various Client Server applications utilizing Crystal Reports Pro 4.0 report graphics , provide instruction to employees on design, code and interface of Crystal reports with VB. Visual Basic, ACCESS databases. Parallel R D to run in NT 3.5 using SQL Server with VB as a front end. Document incompatibilities between Windows for work groups and NT 3.5.

Confidential

Design and build various Client Tracking Reports utilizing Crystal Reports Pro, Visual Basic, Btrieve database, and ACCESS databases. Distributed in both a LAN and WAN Novell network.

As Consultant / Project Manager Confidential

Re-engineer and design Tax compliance short term delivery systems for all non-qualified-annuity products annuity aggregation. Extensive use of Excelerator and Erwin/ERX CASE tools methodology, COBOL II, DB2/DDF, Microfocus COBOL CICS at the workstation.

As Consultant Vantage Computer Systems, Confidential

Convert Vantage UAL systems into Vantage One system for client companies. VSAM, CICS, COBOL II, Vantage database architecture.

Confidential Architect / develop multiple network interfaces to remote sites including transfer and translation of EDI data. Interfacing provided retrieval / update access to corporate databases for applications. Technology included CICS/APPC, Network Data Mover DM , DB2, COBOL II, VSAM, RJE NJE protocols, Asynch communications.

Confidential

Divisional Director / Technical Director Travelers Insurance,

Responsible for several departments spanning ten years. Including following major departments:

Divisional Director Health Maintenance Organization

Eligibility, membership, capitation, claim adjudication, benefits, invoice billing, COB processing, automated pharmacy update, process and payment processing to membership groups and provider networks, Health Link Swipe card systems. VS COBOL II, VSAM, CICS, DB2, Stratus XA 2000, BAL

Technical Director distributed PC systems

Architect and develop client server auto and home property casualty personal computer systems and Financial Services. Create, control, and distribute 350K diskettes annually to independent agents. TIC Packet communications, C, BASIC, COBOL, PC virus checking, extensive PC database library management facility.

Technical Director Corp. Finance Payroll processing

Re-engineer systems staff and end-user community to significantly improve and facilitate payroll, W2, W2P, develop AFP check printing, and 1099 processing. COBOL, VSAM, CICS, PC file transfer, distributed report writing.

Technical Director Micro / Software R D

Design Travelers e-mail and file transfer facility and integrated DISOSS link into 3270 PC architecture. CICS, C, VSAM, TIC Packet switching, CICS MRO processing.

Confidential

Technical Manager CIGNA MEDICOM Systems

Design, plan, and execute according to plan, Cigna's new claim adjudication system. Responsibilities included the implementation of all CICS and batch software, CICS capacity planning including Snapshot in Raleigh NC, architect CICS MRO and transaction routing across multiple CPU's, and general technical support for all BAL, CICS macro, and COBOL programs.

COBOL, BAL, Macro Command CICS, BDAM, CICS tuning

Confidential

Programmer / Analyst, State of Connecticut

Confidential maintenance payroll and all financial applications. Design program and implement EEO reporting system for University departments and job function according to Gov't reporting standards. Later implemented in all colleges and Universities throughout Connecticut and recognized by Governor Meskill as outstanding achievement for data processing department. COBOL, BAL, Macro Command CICS, IDMS-R, VSAM, SPF-II, PL/1,