Summary

Twenty years experience in database applications development, database systems analysis and management, and business process automation.

Skills

• Applications:
• SQL Server, SSAS, SSIS, SSRS, Visual Studio.NET, MS-Office, Access, Excel, PowerPoint, Publisher, Word, Foxpro, MySQL, Oracle, dBase, Clipper, Act , Crystal Reports, GlobalWare, Maximizer CRM, OTRS, Internet Information Services, Apache, PCAnywhere, InstallShield, AutoCAD, Visio, Adobe Photoshop, Acrobat, HIPAA, CMS, ICD-9.
• Languages:
• SQL, T-SQL, Transact-SQL, VB.NET, C .NET, ADO.NET, 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.
• Projects:
• Insurance claims processing and quality assurance, hospital workflow and billing finance, marketing, and sales force process and reporting automation order entry and fulfillment inventory management call center processing credit card processing travel industry retail sales data extraction, transformation, and analysis general office productivity tools engineering and drafting process automation 3D modeling graphic file processing and PC systems management.

Experience Highlights

Confidential

Database Systems Programmer/Analyst

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 , Linq, VSTO, MS-Access, MS-Excel and VBA.

Confidential Application Developer

Application development for a product sales promotion analysis and planning tool using MS-Excel, VBA, ADO, and SQL Server.

Confidential Database Systems Programmer/Analyst

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 education initiatives. Used MS-Access. Performed ad-hoc data analysis. Extensive use of ICD-9 codes. Worked in a HIPAA environment.

Confidential Database Systems Programmer/Analyst

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. Developed and maintained web applications using PHP and ASP.NET.

Confidential Application Systems Analyst

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 Application Systems Analyst

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/BCP, MS-Access and Excel VBA, VBScript, PowerShell, Perl, XML, and Unix KSH shell scripting.

Confidential Systems Designer

Maintenance, troubleshooting, and enhancement for eleven legacy MS-Access/VBA applications used by Massachusetts General Hospital clinical departments to manage patient care workload and billing 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 Database Systems Programmer/Analyst

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

Confidential Database Systems Programmer/Analyst

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 Applications Developer

Development for a data visualization / graphing application using Excel, VBA, and Macromedia Flash.

Confidential Database Systems Programmer/Analyst

Development for DTS documentation automation application using SQL Server, Access, and VBA.

Confidential Database Systems Programmer/Analyst

Development for drafting process automation application using Access, ADO, VBA, VB, and AutoCAD.

Confidential Applications Developer

Development for direct mail process automation application using SQL Server and VB.

Confidential Database Systems Programmer/Analyst

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 Database Systems Programmer/Analyst

Web application maintenance and enhancement using Access, VB, ASP, VBScript, and JavaScript.

Confidential Database Systems Programmer/Analyst

Development for office process automation application using Access, ADO, and VBA.

Confidential Applications Developer

Development for drafting process automation application using AutoCAD, AutoLisp, Access, ADO, and VBA.

Confidential Programmer/Analyst

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 Applications Developer

Design and coding for a 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, other ActiveX servers, and MS-Windows API libraries.

Confidential Database Systems Programmer/Analyst

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.

- denotes contract position