Post Job Free
Sign in

Sql Server Programmer

Location:
United States
Posted:
April 21, 2014

Contact this candidate

Resume:

**** ********* ***** 619-***-****

Christopher Perez Apt #518, ***********@***.***

San Diego CA 92108

To secure a responsible position where my computer programming skills will be maximized to

OBJECTIVE:

contribute to the efficiency of the company

Over 17 years as a VBA Developer with expertise in application development, support, business analysis and

reporting enhancing databases to align with cutting technologies utilizing VBA, Excel, Access, Oracle, SQL Server,

SQL and VB.Net Framework. Have expertise in creating Ad-hoc reports, migrating and upgrading existing Access

databases, customization and modification. Have knowledge of IT, financial and healthcare industries and excellent

interpersonal, analytical and creative skills.

SYNOPSIS: VB.NET/SQL programmer

Software: Eclipse, Crystal Reports 2008 v12, MS Access 2007/2003/2010, SQL 2008/2005/2000/7, Oracle

8/9/11g, SQL Server 2005/2008 Management Studio, MS Word, Excel, PowerPoint, Outlook,

Visio

Operating Systems: Windows 7/XP/2000, Linux, UNIX

Programming .NET, DLL, ActiveX, DAO, ADO, ODBC, HTML, ASP, JavaScript, AJAX, VB script,

Languages: VB/VBA, VB.NET, PHPEd, SQLYog, MySQL, SQL, T-SQL IBM DB2, (Cursors, inserting and

updating, while loops, multiple level sub-queries, using views, stored procedures, scalar and table

functions), SAS, C# and ASP.NET

Other: Team Foundation Server 2012, Code Collaborator, Code Compare, Internet Explorer, Mozilla Firefox, Visual

Sourcesafe, GitHub, UI Front-End Development.

Employment History

Benetrac/Paychex, San Diego, CA December 2013 – April 2014

Senior Developer

• Performed basic analysis and design for PNG (Paychex Next Generation) program changes

• Provided time estimates for development tasks to aid in scheduling.

• Enhanced and modified front-end GUI data entry and report applications.

• Completed more complex program changes to translate specifications and/or requirements into code.

• Applied application specific technical skills to independently produce deliverables by converting/modifying VB6

and ASP code into VB.NET.

• Acquired and utilized basic business knowledge to support the applications.

• Recognized code inefficiencies and made suggestions for improvement.

• Provided documentation to support program changes.

• Supported programming changes during quality assurance, user acceptance testing, and post implementation to

ensure integrity of application.

• Complied with and contributed to standards and protocols to ensure development consistency.

Blue Shield of CA, El Dorado Hills, CA July 2013 – Dec 2013

Senior Software Application Programmer/Analyst

• Designed and developed automated applications in Access, Excel and VB.NET

• Maintained several Access and Excel applications like Summary of Benefits and Claims, Benefit Type Code and

Documentum crosswalk.

• Designed and developed applications to upload/download files into FTP server from VBA and VB.NET

• Designed and developed Shell scripts for automation using VBScript

• Trained users and other developers regarding applications developed.

Sutter Health Services, Sacramento, CA September 2012 – March 2013

Senior Data Analyst/VB.NET Programmer-Crystal Reports Developer

• Provided custom reports like ZBA (zero balance accounts) trend analysis and AR valuation reports.

• Designed Crystal Reports including features like subreports and dynamic cascading prompts with data derived

from SQL and DB2 tables, views and stored procedures.

• Migrated SQL server databases.

• Modified VB.NET and C#.NET programs.

• Designed and developed Shell scripts for automation using VBScript

• Modified and maintained ABC(Automated Billing Concepts) web program written in C# and ASP.NET.

State Compensation Insurance Fund, Vacaville, CA February 2012 – August 2012

Senior VB Programmer

• Responsible for new development and enhancement of existing software using VB6.

• Created SQL tables, views and stored procedures from Oracle and DB2 databases

• Provided morning, evening and weekend on-call support for existing batch programs and for overtime work.

Responsible for training on existing programs and procedures.

Blue Shield of CA, El Dorado Hills, CA October 2007 – January 2012

Senior VB.Net Programmer/Business Systems Analyst (Crystal Reports)

• Responsible for the development and maintenance of at least 25 applications which were being used by 120-180

users each. These applications written in VB.NET would automate manual process in AS/400 reducing each

transaction from 3 minutes to 25 seconds.

• Provided a web based system of downloading these applications based on the user’s privileges. This also tracked

the amount of usage for each application downloaded per user.

• Converted existing VB6 applications into VB.NET. Most of the applications inherited were in VBA/VB6 and were

migrated to VB.NET for improved efficiency and security.

• Designed and developed Shell scripts for automation using VBScript

• Converted exiting MS Access databases into SQL Server 2005/2008 for improved speed, security and

compatibility to existing vendor requirements. Due to the increased bandwidth required for most applications which

used databases, the current MS Access setup was inadequate requiring the migration to SQL Server.

• Provided management reports based on business units demands and provided automation by generating alerts and

emails on a predetermined time. Alerts were issued when reports were successfully generated and when they failed.

Fail-safe mechanisms would fire when network or other issues arose.

• Integrated VB.NET with Crystal Reports using CrystalReportViewer control.

Aerojet Rancho Cordova, CA April 2007 – October 2007

Senior VBA Programmer

• Improved Excel billing worksheets by designing macros to automate tasks. Complex formulas in Excel were

converted into user-defined functions for simplicity and readability.

• Designed auto-running macros within Excel to reduce the learning curve and utilized measures to hide code

behind worksheets.

The GAP Inc., San Francisco, CA February 2007 – April 2007

Senior VB Programmer

• Performed data mining on SQL Server and converted the data into MS Access for local use. The converted Access

database was used to generate statistical reports for use by business analysts, supervisors and managers.

• Automated data gathering from FTP site and provided alerts for supervisors and managers. These alerts would

assure all business analysts that data was current.

• Converted complex Excel worksheets by improving readability using user-defined functions.

• Improved on the formulas which were broken and too complex.

Calpine Folsom, CA December 2006 – February 2007

Senior VB Programmer

• Converted existing VB6/Access applications into VB.NET 2003.

• Modified engineering workbench spreadsheet using Excel VBA.

• Created databases using Access and SQL.

• Provided ad hoc reports using Crystal Reports.

SEIU1000 Sacramento, CA October 2006 – December 2006

Senior VB Programmer

• Created applications using VB.NET 2003. Automated Excel spreadsheets using VBA and macros. Modified and

created existing Access databases.

• Designed additional tables, forms, queries and reports.

• Designed and developed scripts for automation using VBScript

Metro PCS, Folsom, CA April 2006 – October 2006

Senior VB Programmer

• Extracted, modified, and imported Sacramento database to align with the Dallas database using Access and SQL

2005.

• Automated Excel spreadsheets using VBA and macros.

• Designed additional tables, forms, queries and reports.

Dept of Corrections, Folsom, CA February 2006 – March 2007

VB Programmer (telecommute)

• Developed customized surveys on Excel spreadsheets using VBA and macros.

• Developed MS Access databases for Impact Analysis.

CALPINE, Folsom, CA May 2004 – February 2006

VB Programmer

• Designed custom Excel spreadsheets using VBA and macros.

• Designed program flowcharts using Visio and VBA.

• Developed web applications using PHP, JavaScript, VB script and MySQL. Developed and modified existing MS

Access and SQL 7/2000databases.

• Converted exiting Access programs into web-based applications.

• Created presentations for various clients using PowerPoint.

• Provided reports in Eclipse and Crystal Reports.

Verizon Wireless, Folsom, CA May 2004

VB Programmer

• Developed and modified existing MS Access databases.

Restoration Hardware, Corte Madera, CA April 2004 – May 2004

VB Programmer

• Developed and modified existing MS Access databases.

Nextel, Walnut Creek, CA September 2003 – January 2004

VB programmer

• Developed and modified MS Access databases for FAA applications.

• Developed databases for statistical and forecasting applications.

United Parcel Service, Sacramento, CA May 2003 – September 2003

VB programmer

• Developed and modified databases for various clients using Access XP, VB, and SQL 2002.

• Developed external ActiveX DLL routines for use in various applications.

• Expert in providing database solutions and automating tracking procedures.

Bender Warehouse, Woodland, CA (telecommute July 2002 – August 2002

VB Programmer

• Developed and modified existing MS Access databases for inventory tracking.

Mountain People’s Warehouse, Auburn, CA September 2002 – May 2003

VB Programmer

• Designed and developed a statistical Access database to track down performance of various employees/pickers for

warehousing operations.

Bank of America, Rancho Cordova, CA April 2002 – September 2002

VB Programmer

• Analyzed, tested, redesigned and documented existing Access databases. Resolved problems with client/server

applications. Trained end-users in the use of customized application .

• Provided automation solutions for banking applications.

• Created specialized Excel spreadsheets using VBA and macros .

• Developed and modified existing databases Customer Real Estate division.

• Created ad-hoc management reports. Created complex Access Reports using data migrated from IBM AS/400, SQL

6.5/7.0 and Oracle 8.

Department of Justice, Berkeley, CA December 2000 – April 2002

VB Programmer

• Developed and modified databases on a continuous off-site tele-commute basis.

• Modified existing personnel and training database systems using Access 97/2000.

• Produced updated specialized reports for personnel requirements.

AT&T Wireless, Rancho Cordova, CA February 2001 – November 2001

VB Programmer

• Modified and maintained National Inventory Database using Access 97/2000, SQL 7/2000, Oracle 7/8, VB 6,

ActiveX, ODBC, OOP, DAO, and ADO in a client-server environment.

• Converted Access Reports into Excel spreadsheets and designed macros using Excel VBA.

• Migrated data constantly and automatically from Oracle and SQL databases. Configured and set-up tables using

established rules in data structures and data modeling.

• Provided Detail and Summary Reports to National Switch Administration and National Inventory Management.

Updated and Maintained National Web Page for surplus equipment.

• Trained end-users on the use of customized applications.

Newspaper Industry Comm Center, Sacramento, CA September 2000 – February 2001

VB/SQL Programmer

• Prepared specialized accounting and inventory reports in Access, Excel VBA and Crystal Reports.

• Designed and maintained professional report generation program using VB 6, Access 2000, ActiveX, ADO, MS

Query, OOP, ODBC, and SQL 7 in a client-server environment..

• Automated and interfaced MS Outlook with Excel and Access using Excel VBA.

• Trained employees on all levels in the use of customized software.

Orchard Supply/Sears Stores, San Jose, CA August 2000 – October 2000

VB Programmer

• Developed and modified existing databases using Access VBA, ActiveX DLL, Visio, ODBC, and MS Query.

Provided support for help desk/user status database.

• Interfaced Access 97 with Excel spreadsheets using VBA for accounting purposes and as attachments for email.

Designed, tested, documented and debugged existing and new accounting applications in Access and Excel VBA.

Sutter Health Biomed Research Center, Sacramento, CA April 2000 – August 2000

VB Programmer

• Modified existing Billing/Equipment Monitoring database using Access 97, VBA, DAO, and VB 6.

• Performed application conversions from Excel 97 to Excel 2000 using VBA.

• Performed program conversion between various languages using C++, VSAM, VB and DOS.

• Performed data conversion from Lawson Systems to MS Access.

Prison Industry Authority, Folsom, CA (on and off) May 1999 – October 1999

VB Programmer

• Developed and modified budget analysis programs using Access 97, Excel VBA, DAO, and VB 6.

City of Sacramento, Sacramento, CA October 1999 – December 1999

VB Programmer (telecommute)

• Developed and modified Box Office program for the City of Sacramento converting the database from dBase III to

MS Access 97.

Dept. of Alcohol and Drug, Sacramento, CA (onsite) October 1999 – December 1999

VB Programmer

• Converted existing Corel Office suites into MS Office Suites using WordPerfect, Quattro Pro, and Lotus 1-2-3, MS

Word, Excel, Access, VB and macros.

• Converted existing Lotus 1-2-3 macros into Excel using VBA.

• Provided support for Budget Analysis program using MS Access, VB, Excel, Lotus, DAO, ODBC, and ActiveX.

Cirrus Logic, Inc., Fremont, CA July 1994 – October 1999

VB programmer

• Developed programs in MS Access 2.0 and 97, Visual FoxPro 3 and Visual Basic 4 to streamline operations for the

credit department.

• Provided in house training and support in various computer software like Word, Excel, PowerPoint, Access, Paradox,

WinFax, Lotus Notes, 1-2-3, ODBC, MS Query and Laplink.

• Prepared specialized reports using Excel VBA and Crystal Reports 4.

• Responsible for developing the website for the department’s intranet.

• Responsible for the recommendation, installation and testing of various computer software packages like D & B

Dunslink, Graydon, B of A Bamtract Provided interface between AS/400 files, SAP/R3 and IBM Win95 files.

Education: Control Data Institute San Francisco, CA, 1985

Computer Programming and Operations

COBOL, FORTRAN, JCL and RPG II

FEATI University Manila, Philippines, 1975 - 1983

BS in Electronics and Communications Engineering

(Did not officially graduate yet)

Major courses in Computer Science



Contact this candidate