Carol Marotta 	21 Ria Drive
[Send email using form at bottom]	
White Plains, NY  10605				
White Plains, NY  10605
 [Send email to request phone number] 61-2608 home
 [Send email to request phone number] 15-8649 cell

Profile 
Application developer experienced in every aspect of project development and
deployment of custom business solutions.  
Key Words 
C#, VB.Net, ASP.Net, Atlas, Ajax, ASP, Coldfusion, JavaScript, Visual Basic 6,
Crystal Reports, SQL Server, Oracle, Access, XML, VBA, Excel, PHP, Outlook
Redemption
Qualifications Overview 

•	Over 15 years of application development
•	Experienced in gap analysis and modifying existing systems
•	Work well as part of a team and independently
•	Understands business needs 

Professional Experience 
June 2004 – Present
Freelance Application Development
TMR Associates, Stamford, CT
Worked as part of a development team on several web based applications. 
Recently I worked on an existing Coldfusion project that needed enhancements and
bug fixes.  I was required to learn the architecture of the application, locate
and fix bugs and implement an “Excel-like” grid on a web page.
Technologies: Coldfusion, Ajax, JavaScript, SQL
I recently implemented an application for a marketing firm that allows users to
budget for and order point of sales marketing materials for their client. 
Developed pages that allowed users to specify quantities of products to order and
added the selections to a shopping cart.  The application uses Atlas web service
calls to validate user input as well as update the shopping cart.  Developed
pages to allow users with administrative privileges to retrieve open or partially
shipped orders, allowed users to sort and filter the result set by column using
ADO.Net DataViews on the original result.  The order changes are also saved
between browser sessions if the user doesn’t submit the changes before closing
the browser.
Technologies:	C# 2005, Atlas, Ajax, JavaScript, Web Services, Oracle, SQL,
Crystal Reports, Coldfusion
I was also brought in to assist with bug fixes on a C# 2003 web application. 
Also modified a series of views and stored procedures to optimize performance and
ease maintenance issues.  Fixed bugs with keyword searches to allow “and” and
“or” searches as the servers were not set up for use with Index Server.
Technologies:	C# 2003, Ajax, JavaScript, Web Services, Oracle
Sharphat, Inc., Englewood Cliffs, NJ (December 2004 – Present) 
Maintain, update and enhance a Visual Basic 6 application used to calculate
shipment rates for a transportation logistics company.  The application is a
series of DLLs and supports web and Visual Basic front ends, with output in
property strings or XML. The application performs rate search and calculation for
freight shipments over multiple carriers.  The rate data are submitted to us by
the carriers with instructions on how to extract rates, which I code and include
in the dlls.  I also integrated a .Net Com dll for use with the Dlls and is used
by a .Net 2005 web site.  I also support the various installations of the
application at customer sites and provide help desk assistance. In addition to
supporting this application, I provide help desk support for the various
customers that use it.

Technologies:  Access, Visual Basic, XML, SQL, ASP.Net, JavaScript
Developed a search tool to enable educators to search for lesson plans based
various search criteria.  The pages provide basic and advance search, dynamically
build, hide and display search criteria and display the results in a paged list.
Technologies:	Coldfusion, JavaScript, Oracle
Assisted in the final implementation and testing phase of a website.  Made
modifications to web pages, and developed code to send emails from the website. 
Tested and modified stored procedures that capture user and web page tracking
information.  Also developed console application that gathers email addresses and
sends automatic email reminders.
Technologies:	C#, ASP.Net, SQL
Developed forms, web pages and business objects and reports for a standalone
nursing home facility auditing application that records residents, physicians,
drugs, and administered medications.  The system also produced medication review
reports for the physicians and quarterly trend reports for the facilities.  Data
administration was performed on a central database through web pages launched
within the system. 
Technologies:  VB.Net, ASP.Net, MSDE, SQL, ADO.Net, Crystal Reports
Created a website for a company that allows distributors to log in and place
orders for products, search for a product, calculate total cost, and email a PDF
document to the supplier and the company.  I also created a backend tool to
manage the workflow of the orders from created and approving purchase orders to
printing invoices and reports.
Technologies:  ASP.Net, ADO.Net, VB.Net, Crystal Reports, MSDE, IIS
Developed an application to generate a report containing employee and benefit
information gathered from several sources into SQL in a 3 week timeframe.  I
wrote import routines using stored procedures and SQL functions to gather the
information from CSV files into SQL tables and normalize the data.  A big
challenge for this project was amortizing loan data.  I created a stored
procedure to amortize loan information based on loan termination date and number
of payments.  I then developed a report in Crystal displaying all options, loan
and deferred compensation data and calculating the financial status of executives
based on this data.  Users could select the data to show by department, location,
employee and quarter and year.
Technologies:  VB.Net, Crystal 10, MSDE
Interactive Media Bureau, New York, NY (July 2004 – Present)
Designed and developed a web site in C# 2005 that is used by companies that
publish on line information as well as companies that advertise on line. 
Publishers can use Excel or CSV files to upload advertising spec information such
as ad width and height, animations allowed, jpeg sizes and so forth for the
advertisers to view in column format and download in CSV.  Advertisers can also
sign up to receive emails if a publisher has updated their specs.  A requirement
for the application was to be able to scroll horizontally through the spec
information data while leaving the 2 leftmost columns frozen.  This was achieved
by using an Ajax to return 2 tables in HTML script side by side, the right-hand
one in a scrollable div.
Technologies:	C# 2005, Ajax, JavaScript, SQL
Prepare and launch website reporting past due accounts receivables and average
days sales outstanding.  I worked with a finance consulting firm to ensure
compliance certification status of the calculations.   Developed pages to allow
subscribers to upload accounts receivable data from an Excel sheet to a SQL
database, wrote views to perform report calculations based on month, quarter and
year.  Also worked with Verisign to process credit card subscriptions to the site
and developed pages to administer site.  
Technologies:  ASP, Ajax, SQL, HTML, JavaScript
Institute for Advanced Medical Education, Rye, NY (July 2004 – Present)
Developed an Access application that provides forms for entering course,
speaker, vendor and activity data.  The application also reads information from
an Act! Database and produces Word merge documents.    I also created a form that
uses VBA to update the calendar Outlook with reminders.  
In addition, I developed a Visual Basic program that creates prints barcode
information based on data entered into the system.  Users scan the printed
barcodes in place of typing data into forms.  
Technologies:  Visual Basic, Access, Word, VBA, Outlook
PS 196, New York, NY     
Developed an after school program registration web page where parents could
enroll their children in classes.   The web page required displaying dynamic
lists based on the children’s grades and days selected.  Upon submission, the
form authorizes the credit card and the form contents are emailed to the program
coordinator.   I worked with Authorize.net and GoDaddy to enable system to submit
and authorize credit cards, and coded the credit card processing routines.
Technologies:	HTML, DHTML, JavaScript, PHP 

Mastercard, Purchase, NY (August – September 2005) 
In this 6 week time period I worked the consulting group at Mastercard to
augment the development of project utilization reports.   I was able to
understand the data and determine the business rules to develop employee
utilization and customer revenue reports in Crystal and Access.  I also created
an application in Access that uses Excel to automate the process of gathering
weekly, month to date and year to date employee utilization and project pipeline
data to produce a summary spreadsheet.
Technologies: 	VBA, Excel, Access, Crystal Reports
Hudson Health Plan Tarrytown, NY	July 2001 – July 2004
Programmer/Analyst
I worked with staff and management to identify business needs and implement
automated solutions in this not-for-profit HMO.  Developed a system currently in
production that performs intake of applicant information for public medical
insurance coverage and outputs the information to the New York State required
insurance application that is then submitted to the state.  The system calculates
eligibility for public insurance taking into account family size, family member
ages and relationships, family income and resources, and expenses.  From this
information, the system determines the eligibility for each family member and
lists the documents required by the state to qualify.  As the lead developer of
this application, I have been involved in every aspect of the development life
cycle including heading up user meetings for requirements gathering, design,
implementation, testing, documentation and management of two other programmers
and a consultant.  The program recently received press in HealthCare IT News at
http://www.healthcareitnews.com/NewsArticleView.aspx?ContentID=1061&ContentTypeID=3&IssueID=8
and has won an Honorary Mention for the 2004 Health Plan Achievement Award from
the New York Health Plan Association (NYHPA). 
I have also managed the deployment of the system to a plan in Syracuse and a
plan in New York City.  To assist in supporting the remote sites, I developed a
utility that is executed when a user logs into the network that checks a folder
for updated programs and registers DLLs.  SQL commands that update the database
with changes to table structures, stored procedures, records, etc. are stored in
an XML file.  The utility checks the XML file for new structure changes and
executes the SQL commands on the database.  A table in the central database
stores data for each machine that is running this system, the install dates,
update dates and file versions so an administrator can check which systems have
run the updates.
Using Crystal Reports, SQL, Visual Basic, Word, VBA and Outlook, automated the
process by which patient rosters are created and distributed to health care
providers.  Codes such as County, Provider as well as a code indicating how the
roster should be formatted are passed to the Crystal reports as parameters. 
Crystal then queries SQL for the data, produces the report, and exports the
report as an RTF file.   A VBA module then opens the RTF files in Word and
reformats and saves them as Word documents.  The system emails the report to the
designated recipient.  The process also scans the Outlook inbox for requests for
rosters, generates the requested rosters and emails the rosters to the sender of
the request.
Technology:  Visual Basic, Crystal Reports, SQL 2000, MSDE, SQL DMO,
Installshield, XML, HTML, Access, ASP, ASP.Net, Word, VBA, Outlook
DataLan Corp. White Plains, NY 	June 1991 – June 2001 
Programmer/Analyst 
Developed custom application software for clients in various industries. 
Contributed expertise in design, implementation, quality assurance, as well as
user and technical documentation.  Experience includes: 
* Perrier – Byram, CT 
Created an extranet site to expedite the sharing of global sharing of
information to distributors by organizing and posting press releases, articles,
monthly reports, presentations and newsletters on a website installed on a web
server farm.  Site members can search, view and download documents, view and post
questions to a knowledge base and submit surveys.  Reporting, content and
data-driven site structure management is performed using web based administrative
tools. Implemented an n-tier application for both the extranet site and
administrative tools utilizing Visual Basic components deployed on MTS. 
Developed a VB component that enables dynamic content by reading and displaying
current documents posted to various locations on a content server.  Implemented a
document search feature that supports searching an Index Server catalog by
content, filename, location and date.  Linked an Index Server catalog to SQL
Server as a workaround to content not residing on IIS server and submitted search
queries to SQL.  Created website and virtual directories in IIS to maintain and
manage submitted documents.  Set up logging to track page hits.
Technologies:  Visual Basic, ASP, MTS, SQL 7, Index Server, ASPMailer, SAFileUp,
NT4, IIS 
* KPMG – Montvale, NJ 
Worked with a team to write an HR performance management system utilized by
65,000 employees worldwide. The system provides for the submission, tracking and
reporting of employee evaluations and include support for submitting forms
off-line.  Developed client side VBScript that manipulates evaluation data by
reading in and writing to an XML file using the DOM object.  Used OLE Automation
in the VBScript to create an Outlook form, populate it with data from the XML
file and automatically submit it to the appropriate supervisor.  Created a Visual
Basic EXE that runs as an NT Service that polls an Outlook mailbox for incoming
messages, and creates appropriate transaction records in SQL tables.  Implemented
self-regulating features in the EXE such as periodic checks for database
connections and periodic restarts.  Also developed a setup program in Visual
Basic that uses API calls to create registry entries used by the EXE.  
Technologies:  Visual Basic, XML, DOM, Outlook, OLE Automation, CDO, SQL 7, NT4

* Norelco – Stamford, CT
Contributed to development throughout the lifetime of the development of an
intranet site resource for customer service representatives.  Created a Visual
Basic program that used OLE Automation to open a Word mail merge document and run
a merge against data residing in a SQL database.   
Technologies:  VB, ASP, SQL, Word, OLE Automation  
* AMFAR – New York, NY 
Used Crystal to prepare print-ready reports based on data retrieved from a SQL
database to publish in a drug treatment and trial directory.  Developed a
web-based tool to facilitate database searching of treatments and trials for an
audience of doctors and patients.  Migrated search data from Access to SQL. 
Participated in the design, project management and implementation of search tool
for the Internet that included site monitoring whereby each page hit was recorded
by search criteria.  Developed an ActiveX control in Visual Basic that uses OLE
Automation to open a file in Word, convert it to HTML, and post to a web server. 
Supervised two programmers. 
Technologies:  Visual Basic, ASP, SQL, Crystal Reports, OLE Automation. Access 
* Hoenig – Rye, NY 
Implemented the accounts receivable and accounts payable features for a system
designed to create customized client statements.  Developed conversion routines
from Foxpro to Access tables, month and year-end closing functionality. 
Technology:  Visual Basic, Access
Education 
MS Computer Science, Pace University, 1990 
BFA Theater Arts Management, Ithaca College, 1986