JOSEPH M. CONTRERAS
2 Forest Drive [Send email to request phone number] 34-3097
Johnston, RI 02919 jscontreras@cox.net
Summary of Qualifications
Dedicated Software professional with more than 16 years experience in business
and IT development.
• PROGRAMMING EXPERIENCE: Proficient with (D) HTML, C, Oracle, Visual Basic
v3-7, Visual Interdev, ASP, ActiveX, Unix Korn Shell, MS-Access, VBA, SQL, Excel,
Stored Procedures, P/L SQL, MS Transact-SQL, XML, XSL (T), CSS - Style sheet,
VBScript, JavaScript, Perl, ASP.NET/VB.NET, knowledge of C#,JAVA (J2EE), Cold
Fusion, Paint Shop Pro, Crystal Reports, SQR, Flash, Web-Services, SHAREPOINT
(Includes Windows SHAREPOINT Services and Portal Server 2003), MULTI+ ERP System;
SQL Server 2000 Reporting Services
• DATABASE EXPERIENCE: Oracle 7/8i/9i, SQL-Server 7/2000, MS-Access
• PROGRAMMING IDEs: Proficient with Developer 2000 tools, SQR, MS-OFFICE,
SPSSPC+, NCSS, SAS, PROCOMM+, Lotus Notes, Oracle Packages, SQL Server Stored
procedures, Photoshop, Business Objects reports, TOAD, IIS, ER-Win, Power
Designer, Live link Document Management
• OS EXPERIENCE: Proficient with UNIX; Windows 2000; Windows NT; Netware; NT
Authentication; VMS
• HARDWARE EXPERIENCE: Proficient in PCs, local area networks (LAN), HP-Term,
Sun- Sparc workstations
• OTHER EXPERIENCE: Proficient with TCP/IP, Telnet, and FTP, Business Objects,
COM/COM+, Design Patterns, UML, IIS, Visual SourceSafe (VSS), Fluent in Spanish,
Knowledge of SAP SDK
Professional Experience
5/2007 – Present Tuition Management Systems (TMS), Warwick, RI
Software Consultant
Technologies utilized
ASP.NET (C#), SQL SERVER 2000, VBScript, JavaScript, OOP development, SQL Server
2000; Transact- SQL; Design Patterns; Infragistics components 5.3, 6.1; Exposure
to Cognos
Designing a Financial Web Reporting Portal System in ASP.NET(C#) that will
improve Finance daily transaction processes. The core business objects designed
for this system will act as a baseline for a planned operational data stored
(ODS). Will act as a technical lead for the ODS team.
• This project utilizes the standard SDLC methodologies
1/2005 – 5/2007 ROLLS-ROYCE NAVAL MARINE, Walpole, MA
Software Consultant
Technologies utilized
ASP.NET (VB.NET, C#), SQL SERVER 2000, VBScript, JavaScript, Crystal Reports,
OOP development, Oracle8i, PL/SQL, Transact- SQL, Data warehousing; Share point,
Multi+ ERP System; SQL SERVER 2000 Reporting Services
Designed an ERP data warehouse Web Reporting System in ASP.NET. The database
engines were SQL Server 2000 and Oracle 9i. The result of building this web
reporting system is to allow the finance department; procurement department and
other departments to effectively analyze data inputs from the Multi+ ERP system
• Currently building an Intranet Project Budget Planning and Forecasting web
system in C#/VB.NET. The system will track a program from proposal to award
status and measure EAC (Estimate at Complete) base on ETC (Estimate to Complete).
Building a reporting system as a companion to the PBPF system. This will allow
the users to further analyze the relationship between ERP data inputs and
forecasting data inputs. This project utilizes the SDLC methodologies
• Lead the implementation and integration of SHAREPOINT
12/2004 – 2/2005 CITIZENS BANK, Cranston, RI
Software Consultant
Technologies utilized
ASP, SQL SERVER 2000, VBScript, JavaScript
Recreated a sales reporting in ASP with a SQL Server backend. The application
enabled the sales force to track sales activity through out the year.
11/2004 – 12/2004 PFIZER, Groton, RI
Software Consultant
Technologies utilized
ASP.NET (VB.NET) SQL SERVER 2000;VB COM Objects; Crystal 9.0; Access, ERWIN;
IIS; ASP
Part of a team that is maintaining and developing Intranet .NET and ASP Web –
based applications.
Responsibilities included:
• Built a data parser framework using base class objects and local class object
that support all Intranet web based applications
• Built a data retriever program that evaluates existing data and stores new
data into the Oracle 9i backend
12/2002 – 11/2004 FMGLOBAL, Johnston, RI
Software Consultant
Technologies utilized
ASP.NET (VB.NET, C#); SQL SERVER 2000; VB COM Objects; Crystal 9.0; Access,
ERWIN; IIS; ASP
FMCONNECT Extranet application
Part of a team migrating existing Extranet Insurance application to VB.NET
utilizing new MVC framework and software methodology call “Agile Software
Development.
Responsibilities included:
• Built base Class Objects and local Class Objects for the new framework that is
based on the Design Pattern MVC (Model/Viewer/Controller)
• Backend (SQL Server) database development and support. Building
new DTS packages and Stored Procedures. Maintaining existing DTS
packages and Stored Procedures
• Re-Built VB6 Com Objects that migrate data from existing database to new SQL
Server 2000 db
• Built an ASP issue tracker that tracks production bugs for the Extranet
Application
• Built AD Com Object that facilitates Windows Server password changes and
username changes
• Reversed Engineer existing application and extracted business rules for the
new .NET application
• Reversed Engineer and gathered Business Requirements for the Extranet Web
Based application
• Creating an MVC framework (written in C#). This framework allows the creation
of supporting Extranet applications (written in VB.NET) to be more efficient
• Migrated databases from SQL Server 7 to SQL Server 2000
12/2002 – 3/2003 Capitol Region RSVP, Providence, RI
Software Consultant
Technologies utilized
SQL; ASP, ASP.NET(C#(Sharp)); SQL Server 2000; ASP Classes; Com. Objects; HTML,
DHTML; Javascript; Vbscript; VB; Access; Crystal Reports v. 8.5; data modeling –
Power Designer,ER-Win; IIS
RSVP Tracker Web application
Migrated an MS-Access application to ASP.NET web application for a non-profit
organization. This
application is a community web portal for RSVP senior volunteers. In addition
the web application
contains a volunteer tracking system allowing the RSVP director to track
volunteer hours, volunteer
information, station information, and volunteer opportunities.
Additional responsibilities:
• Provided business analysis for creation of Volunteer Tracker
• Created business requirements documentation
• Advised client on best business process practices
12/98 – 12/2002 AQUENT Consulting Corporation (formerly Renaissance)
Software Consultant
Technologies utilized
SQL; ASP;Oracle8i; ASP Classes; Com. Objects; Oracle Triggers; Oracle Packages;
HTML, DHTML; Javascript; Vbscript; VB; Access; XML/XSL (T); Business Objects
Reports; Power-Designer; IIS; MTS; Crystal Reports; B2B;.NET (C#,VB.NET);ORACLE
7-8i;SQL SERVER 7- 2000,Livelink
Vertex Pharmaceuticals, Cambridge, MA
HR and IS Project Tracking Web application
• Developed web application tracking HR critical data. Also continued
development of an IS project tracking system. This information allowed business
management the ability to track and scope the importance of a given project.
Provided data Migration between SQL Server 7 to Oracle 9i. Created Oracle
Packages/Triggers.
Pfizer Pharmaceuticals, Groton, CT
Pfizer Project Catalog (PPC) Web application
• Worked as part of a team that created a web application capturing project
information. This project information allowed business management the ability to
track and scope the importance of a given project. The application also provided
reporting and analysis capabilities. Wrote a resource allocation web applet to
provide business users the ability to assign monetary and human resources for
specified projects. Met with Business stakeholders and provided business
analysis for new and existing web based applications. Part of a team that wrote
business requirements and process analysis documents.
Compaq, Shrewsbury, MA
MDF Web application
• The application allowed the marketing group to track invoice spending for six
geographies. As a direct result spending has been tracked more efficiently and
the marketing programs can be better measured to determined success.
Proposal Web Application
• Built a XML prototype application that created unsolicited proposals for the
sales force
• Acted as a technical lead for the Product-Marketing group advising group in
technical/business issues and developed a B2B solution that allowed communication
between the proposal application and Compaq’s Internet pricing configurator
Customer Endorsements Web Application
• Developed a web base application that allows Compaq’s sales force to track
sales wins and developed a reporting module that allows the Compaq community to
view Sale’s wins based on specify parameters
PIT (Product Information Tool) Web Application
• Part of a development team that built a document depository application that
allows Product Managers and Library Contributors the ability to upload/modify
documents
Pfizer, Groton, CT
Employee Resources (ER) Reporting Application
The reporting application allowed users to view their customized report based on
their criteria selection. The application enhanced productivity by tracking any
or all personnel information based on all or specific requisition(s),
department(s) and recruiter(s).
CVS Corporate Headquarters, Woonsocket, RI
Access/Excel Y2K Compliance
• Assisted business in Y2K remediation of Excel files and Access applications
through technical support; provide process procedures to become Y2K compliant.
ARC Auditor
This application enabled the Network Techs to review CVS audited data and track
both recognized and unrecognized applications. This VB tool increased the Tech's
process to track down the applications within the CVS NT environment.
Y2K Web Application
• Part of a web development team that built the Y2K Web site that allowed the
user community to remediate Excel/Access files through the corporate Intranet
6/98 – 12/98 Massachusetts Financial Services, Boston, MA
Senior Access/VB Consultant
Technologies utilized
SQL; Native MS-Access Objects and controls; ActiveX (Com) objects; VB v. 5.0;
SQL; ASP
Analyzed, designed, and developed several Fixed Income Access applications that
enabled portfolio managers to effectively track and measure a portfolio’s trend
cycle. Re-engineered two tracking systems assisting the Fixed Income team in
tracking a project’s life cycle. Established application documentation
standards. Set up Access applications to be Y2K compliant.
6/97 – 6/98 Digital Equipment Corp., Marlboro, MA
Business Systems Consultant/Software Consultant
Technologies utilized
VB v. 5.0; Oracle 7i; Oracle Stored Procedures; SQL
Implemented the Sales Tracking Omega system for Latin American countries,
provided baseline analysis for existing sales measurement and compensation plans
throughout Asia, Europe, and the United States
2/94 – 6/97 Tailored Computer Applications (TCA)
EDI/Oracle Consultant
Technologies utilized
SQL; Oracle 7i; Oracle Stored Procedures; Developer 2000; Pro*C; Excel VBA;
PL/SQL; Korn Shell, JCL, Perl, Gentran Mentor 1.3, X12 EDI Standards transactions
between 810-867
Catalink Direct, Inc., Norwood, MA
Developed a client-server invoicing reconciliation system. The system provided
a 100% accuracy rate for invoice reconciliation. This tracking system was
integrated into Oracle Financials. Also developed a sales measurement tracking
system that resulted in accurate crediting and compensation reports for
Catalink’s sales teams.
Little, Brown And Company Pubishing, Inc., Waltham, MA
Reengineered financial voucher system eliminating double entry of vouchers.
The new voucher system Increased productivity through streamline design of new
data entry modules in Alpha4 and increased data validity by redefining business
rules.
Catalink Direct, Inc., Norwood, MA
Part of a consultant team that analyzed, designed, and implemented an EDI
infrastructure at Catalink Direct using C and Korn Shell as the baseline
programming tools. As a direct result of implementing the new EDI system,
Catalink reported substantial administrative cost savings, accurate reporting and
an increase in vendor sales.
1/92 – 4/94 Bolt, Beranek And Newman, Inc., Cambridge, MA
Senior Database Administrator
Technologies utilized
SQL; Oracle 6-7; Oracle Stored Procedures; VB v. 4.0; MS-Access 1.0; Developer
forms 2, EDI
Designed, implemented, and maintained sales lead tracking system for the BBN
sales force. The tracking system provided qualified leads, sales revenue
information, sales force accountability, and ad hoc reporting. The system was
designed, and maintained with the following tools. Sales increased 10 – 15% per
quarter as a direct result of implementing the sales tracking system.
1989 –1992 Plan International, East Greenwich, RI
Research Statistical Analyst
Technologies utilized
SQL; SPSS+; SAS; NCSS, CLIPPER, FOXPRO, DBASEXX
Provided data analysis for baseline research surveys utilized by field offices
in developing countries.
The results of the baseline studies provided field offices with vital
information for planning, monitoring, and evaluation of programs in the areas of
health, economics, education, and housing.
1987 – 1989 PC Week, Boston, MA
Research Assistant
Technologies utilized
SPSS+; SAS; WordPerfect
Implemented and assisted in coordinating survey activities for “Corporate
Satisfaction Poll”. The information gathered, allowed PC managers to make
decision in all areas of micro computing.
EDUCATION
Rhode Island College - Providence, RI
B.S. Marketing/Finance
|
