Senior Developer09/2006 to CurrentSolutions & Architecture
Advanced Programmer Analyst09/2005 to 10/2006Wilis Group
Designed and developed Global Compliance Portal using ASP.NET and C# to allow the compliance department to select policies and perform a review to make sure all work was done as expected - Data is stored in a SQL Server database.
C# reporting service application runs to generate reports requested from within the portal and emails them to the requesting user as XML spreadsheets.
Designed and developed Revenue Recognition Portal using ASP.NET and C# to allow the accounting department to monitor commissions expected versus actual commission paid for specific offices within the organization.
Policies with variances can be identified and the office can be notified so they can work with the Carriers to get the money received - Data stored in SQL Server database.
Weekly input file containing new policies per office is uploaded into the application via a C# service application.
Accounting users generate a commission schedule via the portal which commissions will be applied to monthly.
Monthly input file containing commission payments per office is uploaded into the application via a C# service application and applied to the generated schedules by policy.
Designed and developed cross reference Portal using ASP.NET and C# to allow users to map client id values from an in house written application to the client id used in a vendor application - Data stored in SQL Server database.
The cross reference was used by several different portal applications to associate the clients across many different systems.
Worked on a large conversion project to consolidate many in house and bought applications into a new vendor supplied solution application in order to decommission and leave one central data source.
This project took over 4 years to complete.
Developed ETL applications using C# to cleanse and migrate data to the new vendor application.
Developed ETL applications using C# to migrate documents from several document management sources.
Designed and developed Migration Utility Portal using ASP.NET and C# to allow the migration team assigned to the monitor what was migrated and what will migrate as a way to validate data without having to research the old system against the new.
Developed several C# applications to extract data and attachments from the new vendor application for divestitures that have occurred after the conversion project was completed.
Designed and developed Document Portal using ASP.NET and C# to allow the users to retrieve documents from document management sources that were not migrated to the new vendor application.
This will allow the company to decommission these document management sources and save in per user licensing fees - Data is stored in SQL Server database Developed C# application to consume WCF service provided by the vendor application company to update client and policy information.
Data to update is retrieved from a SQL Server database and processed nightly.
Ingram Book Group NET(C#) web service that provided customers with real time stock information to assist them in placing book orders - Web method received and transmitted data via XML document - Data was retrieved from SQL Server database.
Created client applications in .NET and Java that were sent to smaller customers to allow them to consume specific web services they needed for their daily operations.
NET(C#) application to receive customer orders from FTP server for those customers that did not utilize the existing web services available.
Orders were processed into messages placed into a queue for legacy mainframe application to process.
Created C# console applications that were scheduled to automate tasks that the users were performing manually on a weekly and monthly basis.
Programmer Analyst II06/1995 to 09/2005CNA Life Insurance Company
Developed several in house Visual Basic applications to interface with the administration system to improve overall user efficiency.
Application to allow business managers to input daily production numbers for upper management reporting on a daily/weekly basis - Data stored in an Oracle database using Crystal Reports for report generation.
Application to allow business users to enter name and address change information and distribute those changes across 75 different server based systems - Data stored in Btrieve data files.
Application to allow business users to request agency background checks from outside vendor General Information Services (GIS) - Data stored in an Oracle database with daily file transfer with GIS via FTP.
Application to calculate agency bonus payments on a monthly and Quarterly basis.
Payment amount and information was sent to PeopleSoft for check generation and direct mailing.
Developed Java applications for reporting and automated processing Application to automate extraction of premium and commission data from the administration system for reporting purposes - Data stored in Oracle database.
Web application to provide ad hoc reporting for marketing department to monitor sales of Long Term Care agencies - Data retrieved from Oracle database - Ran on UNIX utilizing Tomcat.
Application to automate weekly extraction of commission data formatted using an insurance standard formatted layout and sent to top producing agencies - Output files were encrypted using PGP encryption and delivered to each agency via FTP.
B.S: Business Administration - Finance1995University Of TennesseeKnoxville, TNBusiness Administration - Finance