Qualifications

I am a highly motivated self-starter who is eager to learn and assume increasingly greater responsibility. I am capable of performing multiple tasks while maintaining my focus on meeting deadlines and quality of work standards. I have proven software experience in administrating and using Adobe, over 15 years experience utilizing Microsoft Office Suite, Microsoft Windows XP, SQL Server 2000/2005/2008, MS Access, MS Excel, ASP, VBA, ADO, DAO, ODBC, Crystal Reports XI, DTS, SSIS, JavaScript, and HTML. I am confident in my problem solving skills when working in teams and on solo projects. My oral, written, and listening skills are exceptional.

Education

Expect to obtain degree in Computer Information Systems
Technical Writing Certification

Selected Employment

MS Access Developer/ Data Analyst, Confidential, (1/11 - Present)

• Designed and developed a mail merge application using MS Access, VBA, ADO, and SQL.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Designed and developed an Employee Tracking System using MS Access, VBA, DAO, ADO, and SQL.
• Designed, and developed technical specification for data migration
• Performed data migration from MS Access to SQL using DTS, VBA, and ADO
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Monitored database systems to ensure data integrity
• Created, extracted, and maintained queries and reports using Crystal Reports

Programmer/Data Analyst, Confidential, (02/07- 08/10)

• Designed, developed, documented and implemented a Claims Tracking application using MS Access, VBA, ADO, DAO, and SQL.
• Created/ Modified documents such as Dec Pages, Endorsements, Billing Notices, and Cancellation Notice using Crystal Reports and SQL
• Performed all support functions associated with the collection, quality checking, and trending of data that is used for measuring the effectiveness of the IT department
• Responsible for creating daily/weekly/monthly reports and metrics that measure success/failure ratio of production reports as well as monitoring databasebackups using Crystal Reports
• Administered, organized, modified as well as troubleshoot reports using Crystal Reports XI
• Maintained accurate daily and monthly metrics for the Data Services department, including production uptimes, server/disk utilization, inventory, and help desk calls
• Used software applications, such as Access, Excel and PowerPoint to assemble, manipulate, and format data for the creation of databasesand reports
• Verified data integrity by executing stored procedures in SQL to authenticate statistics

Programmer Analyst, Confidential, (8/06 - 11/06)

• Designed, developed, documented and implemented an invoice tracking system to upload invoice information from clients to track if an invoice item was paid, open, completed or cancelled using MS Access, VBA, ADO, and Oracle.
• Developed specs for an Online User Request System (OURS) for users to submit system requests, ad-hoc reports etc... via the web using ASP, Javascript, VBscript, AJAX, and Oracle.

• Designed, developed, documented, and implemented an Accounting General Ledger system to calculate complex algorithms for data migration using MS Access, SQL, ADO, DAO, and VBA.
• Developed a Check Request System to for the Claims Department using VBScript; ASP; Visual InterDev; JavaScript; MTS; COM; SQL; ADO; and Visual Basic which allows the data to migrate to the General Ledger system for check processing.
• Built a front-end positive pay interface for extracting check stock information from the General Ledger system to upload to appropriate financial institution using MS Access; VBA; ADO; and SQL.
• Developed, designed, documented, and implemented Work Tracking System using MS Access and SQL Server to track new business, renewals, and policy change transactions.
• Analyzed, coded and maintained legacy system applications.
• Handle departmental requests for system changes, including reporting, applications, and troubleshooting.
• Created front-end interface to extract data from SQL to Pervasive SQL (Platinum GL System)
• Provided deliverables in the form of database designs, information models data migration plans, and/or data warehouses using Visio and MS Project
• Collaborated with Management/Project Manager and development team to document how to create/enhance/modify data load scripts to accommodate changes in production
• Communicated with management to obtain proper information for data migration process
• Collaborated with internal customers for data cleansing and enhancement

• Provide 1st level support for 6,000 end-users on Windows 95, 98 and Windows NT 4.0 workstations connecting to Windows NT server via LAN and RAS.
• Troubleshoot and configured dialup networking, MS Outlook/Exchange and modem configuration.
• Provide support on all MS Office products.
• Primary support for MS Access 97 to 2000 migration, troubleshoot and resolved database issues.
• Developed and maintain front-end interface in MS Access to streamline the incoming call process. Database was developed to extract data from case management system and populate information into Clarify.
• Performed network account administration with combined NT and Netware authentication.

References available upon request.