Banner Image

Skills

  • Microsoft
  • Microsoft Access
  • Microsoft Excel
  • Microsoft SQL Server
  • Server Administration
  • Software Development
  • SQL

Services

  • MS Access, MS Excel Developer SQL Server

    $40/hr Starting at $100 Ongoing

    Dedicated Resource

    Edward Neyrus Developed FTP Agent program which transfers files between different servers utilizing FTP protocol. - Pro

    MicrosoftMicrosoft AccessMicrosoft ExcelMicrosoft SQL ServerServer Administration

About

18 years in the Microsoft Programming

11/2004 - Present Senior Programmer Analyst Medco Health
Franklin Lakes /NJ

Worked on healthcare industry applications such as Client Profile Management System, Business Process Automation System (BPA) , Medicare D Requirements System, TG2, ACP, Tracklog, and PPO Tracklog. These programs were designed with MS Access 2002 front end and SQL Server 2000 backend. They were then upgraded to MS Access 2007 front end and SQL Server 2005 on the backend. Also worked on various MS Excel projects for management using MS Excel 2003 and MS Excel 2007 and MS Excel 2013 such as Client Management Tool and more.
- Worked with ADP Project Files with connection to SQL Server 2007 as well as MDB Files.
- Worked with ADP Project Files with connection to SQL Server 2005 as well as MDB Files.
- Wrote complicated Stored Procedures, User Defined Functions, and Triggers in SQL Server 2000.
- Wrote complicated Stored Procedures, User Defined Functions, and Triggers in SQL Server 2005
- Created Reports in MS Access 2002 based on SQL Server 2000 stored procedures.
- Created Reports in MS Access 2007 based on SQL Server 2013 stored procedures.
- Build Forms, Wrote Modules, Created Queries, Build Reports, Build Macros in MS Access 2002 and 2007 and 2013.
- Have very strong skills in Programming VBA programming language, as well as ADO and DAO (data access technology), in MS Access 2002 and 2007 and 2013.
- Normalized Data for various applications in SQL Server 2000 and 2005 and SQL Server 2013.
- Scheduled Jobs in SQL Server 2000 and 2005 and SQL Server 2013.
- Wrote complicated DTS packages in SQL Server 2000.
- Wrote SSIS Packages in SQL Server 2005 and SQL Server 2007 and SQL Server 2013 Programmed MS Excel VBA in MS Excel 2003 and MS Excel 2007 and MS Excel 2013

12/2003 - 7/2004 Senior Programmer Analyst Part Search
New York/NY

Developed Data Group Console Application for loading Part ,Model, and Part Model Data into Production Database. Also developed Vendor Import

Work Terms

must work at home. prefer to be payed by check