Summary

Detail orientated computer professional with extensive database and programming experience. Currently attending SDSU in their MIS Program, It is my goal to continue to work in small to midsize organizations maintaining and creating enterprise level software solutions. I greatly enjoy the challenge of developing creative solutions for a team and endeavor to instill cooperation, transparency and efficiency in the applications that I work on.

Manager of Application Development

CEM Corp
 – Present Greater San Diego Area

Created Application that tracks contracts for a Navy Contractor. This application performs the following functions:
• Tracks Job Costing
• Handles contractual reporting.
• Manages files related to project (all formats).
• Utilizes bio-metric time clock for payroll.
• Creates and tracks purchase orders.
• Is integrated with QuickBooks (AR, AP, HR, Payroll, Vendor Lists, Customer Lists).
• Is integrated with outlook to store emails as they relate to Navy contracts.

Senior Marketing Analyst

National Pen
   (5 years 2 months)

• Created complex reports and stored procedures in SQL Server, SQL Server Reporting Services. Reports are automated with little or no maintenance required. 
• Created complex stored procedures to manipulate data behind reports. Set up scheduled tasks to run stored procedures on regular basis.
• Created SSIS packages to import data from external data sources including oracle, access and excel spreadsheets. 
• Created user interfaces to update data stored in the data warehouse. 
• Developed customer matrices that track customer health, buying patterns.
• Created predictive models using Model Max to forecast customer revenue, likelihood to go bad debt, likelihood to respond to telemarketing campaigns.
• Created software that updates hundreds of excel spreadsheets on a nightly basis. 
• Created software to import data from thousands of xml documents into SQL Server database. 

Technologies used: VBA, VB.NET, Access, Excel, HTML, XML, SQL Server, SSRS

Payroll Accountant / IT Assistant

Job Options Inc. / Behavioral Management Services
   (10 months)

• Created biometric time clock (fingerprint) and supporting software to track hours and communicate with corporate office. 
• Reformatted user interface for the HR / Payroll database. This significantly reduced errors and processing time. 
• Developed system to invoice customers. This system communicates data with accounting software, posts invoice information automatically and generates invoice document. 
• Assisted accounting and human resources departments with accessing data stored in an Access database and SQL Server.
• Created custom reports as needed in Microsoft Access. Modified reports in report writer (Microsoft Great Plains). 
• Created reports that eliminated the need for numerous time consuming spreadsheets.
• Streamlined processes in payroll and human resources allowing for the elimination of 2 positions.
Technologies used: VBA, VB.NET, Access, Excel, SQL Server, Microsoft Great Plains

Database Consultant / Human Resources Administrator / Bookkeeper

Controls Engineering Maintenance Corp. (CEM Corp)
   (3 years 6 months)

• Integrated accounting system with production database allowing real time view of job status in project accounting. 
• Created system for writing, tracking and invoicing purchase orders.

Guest Service Manager / Guest Service Supervisor / Night Auditor

Sunstone Hotels
   (2 years)

Education

San Diego State University-California State University

Bachelor of Business Administration (BBA), Management Information Systems,General
 (expected)

San Diego Mesa College

Associate of Arts (A.A.) Liberal Arts, Associate of Science (A.S.) Computer Information Science