SUMMARY:

• Fifteen years of experience in database applications development, database systems analysis and management, and business process automation.

TECHNICAL SKILLS:

Applications: SQL Server, SSAS, SSIS, SSRS, Visual Studio.NET, Entity Framework, MS - Office, Access, Excel, PowerPoint, Publisher, Word, Visio, Foxpro, MySQL, Oracle, dBase, Clipper, Act, Crystal Reports, GlobalWare, Maximizer CRM, OTRS, Internet Information Services (IIS), Apache, InstallShield, AutoCAD, Adobe Photoshop, Acrobat, HIPAA, CMS, ICD-9.

Languages: SQL, T-SQL, Transact-SQL, VB.NET, C#.NET, ADO.NET, Linq. VSTO, Visual Basic, VBA, ADO, DAO, DTS, ODBC, XBase, HTML, XHTML, CSS, ASP.NET, ASP, VBScript, PowerShell, JavaScript, CGI, Perl, PHP, XML, HL7, COM, ActiveX, Windows API, AutoLisp / DCL, C.

Operating Systems: MS-Windows Server, Windows 7, Vista, XP, 2000, NT, 98, 95, V3.1, MS-DOS, Microsoft Networks, Novell, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Marlboro, MA

Programmer/Analyst

Responsibilities:

• Maintenance and development for the Outsourced Benefits Administration (OBA) application, comprising large, complex configuration file sets written in XML and Javascript. Main application coded in Java with Oracle backend. Environment included several ancillary, open source utilities for testing and version control.

Confidential, Lawrence, MA

Database Systems Programmer/Analyst

Responsibilities:

• ETL, development, and reporting for the hospital’s Ongoing Professional Practice Evaluation (OPPE) and Focused Professional Practice Evaluation (FPPE) process for Joint Commission regulatory reporting requirements. Used SQL Server, SSIS, C#.NET, Linq, Entity Framework, VSTO, MS-Access, MS-Excel and VBA.

Confidential, Gloucester, MA

Application Developer

Responsibilities:

• Application development for a product sales promotion analysis and planning tool; using MS-Excel, VBA, ADO, and SQL Server. Performed code and query analysis and optimization.

Confidential, Watertown, MA

Database Systems Programmer/Analyst

Responsibilities:

• Application and report design and development for the Medicare Preferred Risk Adjustment / Quality Assurance department. Applications included workflow automation for medical coding professionals, and report automation for management staff. Both supported Centers for Medicare & Medicaid Services (CMS) compliance mandates and primary care physician initiatives. Used MS-Access and VBA. Performed ad-hoc data analysis. Extensive use of ICD-9 codes. Worked in a HIPAA environment.

Confidential, Boston, MA

Database Systems Programmer/Analyst

Responsibilities:

• ETL and reporting for the Population Sciences and Research Computing departments. Worked in a MS-Windows environment using SQL Server, MySQL, Oracle, MS-Access, and VB.NET to process and report on research study and survey data. Maintained and developed web applications using PHP and ASP.NET.

Confidential, Waltham, MA

Application Systems Analyst

Responsibilities:

• Customization and enhancement of OTRS, a third-party, open-source application used for IT incident ticket reporting and management. Worked in a MS-Windows environment using Perl, MySQL, Apache, XML, JavaScript, and HTML.

Confidential, Portsmouth, NH

Application Systems Analyst

Responsibilities:

• Support, maintenance, troubleshooting, enhancement, and automated testing for third-party applications used for insurance claims processing. Worked closely with vendors. Worked in a mixed platform environment including MS-Windows, SQL Server/TSQL/SSRS, MS-Access and Excel VBA, VBScript, PowerShell, Perl, XML, and Unix KSH shell scripting.

Confidential, Boston, MA

Systems Designer

Responsibilities:

• Support, maintenance, troubleshooting, and enhancement for eleven legacy MS-Access/VBA applications used by Massachusetts General Hospital clinical departments to manage Confidential t care workload and billing and reporting activities. Performed direct user support and participated in the 24x7 on-call support rotation schedule. Worked in a HIPAA environment. Used HL7 for EDI.

Confidential, Cambridge, MA

Database Systems Programmer/Analyst

Responsibilities:

• Extract, transform and load (ETL) data from Excel, Access, Oracle, and delimited flat files into SQL Server tables using SQL Server Integration Services (SSIS), BCP, and Transact-SQL.

Confidential, Peabody, MA

Database Systems Programmer/Analyst

Responsibilities:

• Analysis and programming for a corporate travel agency using VB.NET, SQL Server, Reporting Services (SSRS), Integration Services (SSIS), MS-Access, DAO, Excel, VBA, GlobalWare, Maximizer CRM, Linux/Apache, MySQL, Perl, PHP. Applications included finance, marketing, and sales process and reporting automation; customer relations management; data extraction, transformation, loading (ETL), and analysis; and web application enhancement and maintenance. Extensive use of Transact-SQL, stored procedures, Reporting Services Web Service, and ADO.NET.

Confidential, Lexington, MA

Applications Developer

Responsibilities:

• Development for a pharmaceutical company’s data visualization / graphing application using Excel, VBA, Macromedia Flash, and ActiveX components.

Confidential, Boston, MA

Database Systems Programmer/Analyst

Responsibilities:

• Development for a civil engineering firm’s drafting process automation application using Access, ADO, VBA, VB, and AutoCAD. The application enabled bi-directional transfer of parts data between database and drawing.

Confidential, Billerica, MA

Database Systems Programmer/Analyst

Responsibilities:

• Design and analysis for a medical equipment manufacturer using Access, Excel, and VBA. Applications included daily and monthly sales and commission calculation and reporting automation. Extensive use of ADO/ADOX, DAO, and VBScript Regular Expressions.

Confidential, Holliston, MA

Programmer/Analyst

Responsibilities:

• Design and analysis for a large, direct media marketing company using Visual Basic, SQL Server, DTS, XML, RTF, and MS-Office. Applications included telemarketing/call center, order processing, and inventory management. Extensive use of Transact-SQL, stored procedures, and ActiveX Data Objects (ADO).

Confidential, Methuen, MA

Applications Developer

Responsibilities:

• Design and coding for a touch screen manufacturer’s set of engineering drawing process automation applications using MS-Visual Basic, MS-Access, ADO, MS-Excel, AutoCAD, AutoLisp, and Crystal Reports. Applications utilized three-tier client/server architecture to produce finished drawings and production line machine control files. Extensive work with MS-ActiveX Data Objects (ADO), other ActiveX servers, and MS-Windows API libraries.

Confidential, Southboro, MA

Database Systems Programmer/Analyst

Responsibilities:

• Design and coding for a high-volume, consumer products manufacturer/distributor using FoxPro for Windows, Visual Foxpro, MS-Office. Duties included maintenance and troubleshooting of company's legacy client/server applications and databases, data query and reporting per user requests, and generation of new custom programs. Applications included sales, marketing, customer service, order entry, credit card verification, and United Parcel Service shipment. Extensive use of SQL.