Senior Sql Developer / Development Dba Resume
OhiO
SUMMARY:
- Over twenty years experience in data processing including development, project management, design, analysis, testing, production support, and database administration.
- Possess a diverse base of application experience in Health Care, Banking, Telephony, Utility, Manufacturing, Food, Retail and Transportation Industries.
- Has over ten years of web applications experience in Microsoft .Net (C#, MVC) and is a SQL Server Development DBA.
TECHNICAL SKILLS:
Software: MS - Visual Studio.Net 2005, 2008, 2010, 2012 & 2013. C#, MVC 5, ASP.Net 2.0 & 3.5, 4.0 & 4.5, ADO.Net, Web Services, MS-SQL Server 2000, 2005, 2008 R2 & 2012, SharePoint 2007 & 2010, LINQ, NUnit, WCF, SSIS, SSRS, AJAX, Reporting, JavaScript, XML, SQL, T-SQL, Oracle, Toad, Tealeaf, Classic ASP, DB2, DB2/Stored Procedures, DB2 Federated tables, Enterprise Manager, MS/DOS, UNIX, C Language, EDI, ftp, Assembler, SAS, CA Realia & Microfocus COBOL, COBOL MVS, CICS, Natural, PL/1, Easytrieve, ADABAS, IMS/DLI, IDMS, VSAM, CEDF, Xpediter, Intertest, SDF, OS/MVS/XA, DOS/VSE, ZEKE, OS/JCL, TSO, ISPF2, Roscoe Vollie, Panvalet, Telon, and DataArk.
PROFESSIONAL EXPERIENCE:
Confidential, Ohio
Senior SQL Developer / Development DBA
Responsibilities:
- Programmed Supplemental Diagnosis Codes data extract and XML file creation per Government Mandated Edge Server ESSFS file submissions and designed and created ASP.NET MVC 5 Web Application to manage all Supplemental Diagnosis Codes.
- Designed and created an ASP.NET MVC 5 Web Application to edit, standardize and convert Provider Addresses to USPS Address Standards.
- Designed and created an Oracle Database extract to process and send Text-4-Babies information to the State of Ohio per State requirements.
- Designed and created a ASP.NET(C#) File Watcher Service to move, archive, rename & process internal and external files. The service also created SQL Server task list table records, based on rules and regular expressions.
- Partnered with Line of Business to correct & close problem tickets.
- Designed and created CMS RAC Medicare/Medicaid Secondary Payer Claims file reformatting and conversion system. The System converted CMS RAC Version ‘J’ and Version ‘K’ Data from EBCDIC to ASCII and extract Claim Headers, Diagnosis, Procedures, Detail Lines, Condition Codes, Occurrence Codes, Value Codes and Error Codes by Claim Types (DME, HHA, Hospice, Inpatient, Outpatient, Professional and SNF ). The system mapped, scrubbed and loaded the newly formatted flat files into SQL Server CAS Staging tables.
- Maintained CMS RAC frontend legacy Medicare/Medicaid Claims file reformatting system. Converted CMS RAC Version ‘J’ logic to Version ‘K’. Changed division condition logic to separate into four state regions.
- Created and programmed software releases for the CGI Pricer and 3M Grouper Interface for client Confidential of Oklahoma and converted to ICD-10.
Environment: Agile, ASP.NET(C#) 4.0, MVC 5, SQL Server 2008 R2, 2012 SSIS and Visual Studio 2013 & 2010, TFS, JavaScript, jQuery, COBOL, CICS and Oracle
Confidential, Westlake, Ohio
Senior SQL Developer / Development DBA
Responsibilities:
- Converted coupon conversion data into new customer records.
- Designed reporting process to capture and insert coupon campaign conversion data and created contact history and campaign conversion reports.
- Reviewed and tuned SQL Server stored procedures, indexes, script, views and functions.
Environment: SQL Server 2008 R2, SSIS, SSRS and Visual Studio 2008
Confidential, Cleveland, Ohio
Senior Consultant
Responsibilities:
- Universal Case Management System - Created ListView web parts for Case Overview, Discover, Document Request, Calendar and Contact Pages to access SQL Server Case Management data. Created all SQL Server stored procedures and analyzed vendor database to identify incorrect data relationships and orphaned data records.
- Designed, created and implemented Corporate Travel website.
- Performed Visual Upgrade and Converted intranet portal websites from SharePoint 2007 to SharePoint 2010.
- Created new SharePoint portal websites, created active directory accounts and granted portal access.
- Designed and created new Change Control Web Application.
Environment: SharePoint 2007 & 2010, NET(C#) 3.5, SQL Server 2008 R2 and Visual Studio 2010
Confidential, Cleveland, Ohio
Senior Consultant
Responsibilities:
- Analyzed and implemented application upgrades for a new virtual server implementation project for Web Services. Performed a web application and database audit which identified obsolete databases, database upgrade impacts, application requirements and necessary Active Directory user group impacts. Implemented production application changes for all Web Services applications effected by the new virtual server database instance and SQL Server 2008 upgrade.
Environment: NET(C#) 3.5, SQL Server 2000, 2005 & 2008, SSIS and Visual Studio 2008
Confidential, Canton, Ohio
Senior Software Engineer
Responsibilities:
- Designed and created Check Payment Scenario for the COOP proprietary Shared Branch application.
Environment: NET(C#) 3.5, IFX, ATM and Visual Studio 2008
Confidential, Cleveland, Ohio
Senior Consultant
Responsibilities:
- Gathered functional requirements from the Product Managers and Converted ESign Mortgage Application from five separate applications into one integrated application and implemented the website into production for internal and external clients.
- Updated Gemstone Mortgage Registration Application to fulfill government mandated Truth in Lending requirements.
Environment: NET(C#) 3.5, Oracle, Web Services, JavaScript, Toad, Harvest and Visual Studio 2008
Confidential, Cleveland, Ohio
Senior Consultant
Responsibilities:
- Developed enhanced error messaging functionality for the Individual Online Application. Gathered functional requirements from the Product Managers for the creation of the functional specifications and statements of work, develop and loaded error message tables and expanded error message functionality.
- Updated Individual Online Application questions and sub questions to fulfill government mandated requirements.
- Designed and Development Individual Online Application business requirements and functional specifications for third party vendors. Manage third party relationship to ensure accurate pricing and proper page presentation per Confidential ’s Product Managers.
Environment: NET(C#) 3.5, SQL Server 2008, Web Services, LINQ, XML, NUnit, WCF, Tealeaf, SSIS, HTML and Visual Studio 2008
Confidential, Richfield OH
Senior Developer/Analyst/Project Manager
Responsibilities:
- Converted a 550 bed Hospital from Siemans Hospital Systems to Confidential ’s DataArk. Managed project and developed Patient Release of Information and Chart Locator for external client.
- Created Billing Modifiers for DataArk application.
- Designed and created Data Archive HR and Custom Financial reports.
- Created 837, UB04 and HCFA field mappings and Forms. Designed and created SQL Server Audit functionality to capture all updated and inserted financial transactions.
- Created functional specifications, SOW’s and documentation for above projects.
Environment: NET(C#) 2.0, SQL Server 2005, Web Services, AJAX, JavaScript, XML, SSIS, Reporting, HTML and Visual Studio 2005
Confidential, Cuyahoga Falls, OH
Architect/Senior Developer
Responsibilities:
- Architected and redeveloping an HME Billing System to manage Denials, AR, CME, Deposits, Daily Tasks and Reporting.
- The Web Application is currently implemented and supports over 75 users and is being marketed in the HME Industry.
Environment: .Net(VB.Net) 3.5, SQL Server 2008, Web Services, AJAX, JavaScript, XML, HTML and Visual Studio 2008
Confidential, Chagrin Falls, OH
Senior Developer/Analyst
Responsibilities:
- Developed functional requirements, designed and created a Provider Load Solution (.Net/C#) for Institutional and Profession Providers. The website allowed Third Party Administrators to load Providers and create Doctor/Dentist to Hospital/Medical Centers relationships with multiple locations.
- Analyzed, Enhanced and Upgraded the Institutional and Professional Claim load (.Net/C#). Upgraded the HFCA form creation to current industry standards. Upgraded the creation of the UB form from UB92 to UB04 to meet the current industry standards.
- Developed functional requirements, redesigned and rewrote the Third Party Administrator Invoicing and Payments Web Application (.Net/C#). Create the business module and algorithms to correctly apply adjustments and reversals throughout the financial system. The enhancements corrected both Invoice and Payment, transaction detail and master balances along with adjustments and reversals.
- Designed and created the Insurance Card Print process for Third Party Administrators (.Net/C#).
- Developed requirements and created the Multiple Volumes for Life Insurance enhancements. The Life Insurance Web Application needed the flexibility to allow for Life, AD&D and numerous supplemental Life Insurance types with volumes. Enhanced Life Insurance Web Application to allow for numerous Life Insurance Types and allowed them to be added and changed at the Group and Member level (.Net/C#)..
Environment: .Net(C#) 2.0, SQL Server 2005, JavaScript, XML, Reporting, HTML, Visual Studio 2005 and Enterprise Manager
Confidential, Fairlawn, OH
Senior Developer/Analyst
Responsibilities:
- Developed functional requirements, designed and created a .Net(C#) Asset Tracking System for Employee electronics, computer and telephony equipment. The Asset Tracking System tracked and integrated Electronic Assets with Employee, Vendor, Shipping, Address and Warrantee SQL Server database tables. The Website allows Desktop support to manage all company owned equipment and use the site’s filter system to search Assets by Price, Type, Current location, Date purchased, Warrantee dates, and model number.
- Created Functional Requirements with Reporting Manager, Designed and Developed a .Net(C#) Field Rep Call Report Validation Tool to correct illogical data value combinations on Call Report SQL Server tables. The Call Report Validation Tool enabled the Reporting Team to send accurate Call Reports to Numerous Customers and eliminated manual data corrections.
- Enhanced and provided on call support to numerous .Net websites and windows applications including: Call Reports; Employee Management; Retail Project Management; Service Plus and Confidential Data Management System
Environment: .Net(C#) 2.0, VB.Net 1.1, AJAX, XML, HTML, Visual Studio 2005, SQL Server 2005 and Enterprise Manager
Confidential, Cleveland, Ohio
Senior Programmer/Analyst
Responsibilities:
- Provide production support and Interface enhancements for AEXAdjustment Express. AEX is a Distributed Banking Items Processing vendor package that handles all Items Processing exceptions with minor manual intervention.
- Debugged and installed Customer email notification process and corrected weekly National Reports.
- Created AEX Interface in C# to convert Software Earnings XML files to AEX comma delimited files.
- Installed and configured DB2 Connect on AEX Disaster Recovery application server, corrected file system and debugged environment for successful DR test.
Environment: AEX, Microsoft Application Servers, C#, COBOL, JCL, SQL, DB2, TSO, Endevor, Service Center, Crystal Reports and ftp
Confidential Cleveland, Ohio
Solutions Provider IV
Responsibilities:
- Gathered technical and functional requirements from Helpdesk Manager and Redesigned and created a .Net(C#) Central Registration Application to accommodate creation and retrieval of usernames, passwords and security context for external web applications utilized by Antares Management Solutions helpdesk based on those requirements. Central Registration allows the Helpdesk Resources to verify and modify registration information for fourteen different external web applications using XML. The application also utilizes a Web Registration web service to register new users.
- Converted Connexion website from ASP.Net 1.1 to 2.0. Created .Net Master pages with content pages and changed CSS style sheets to Themes and Skins. Converted code-behind classes to partial classes.
- Created SQLServer tables and stored procedures for SuperMedNetwork (C# .Net) website and developed web application Registration management, claims and Hospital Network pages.
- Developed .Net(C#) Deductible and Out of Pocket web pages for ClaimsLink applications.
- Wrote .Net applications which dynamically built datagrids using Item Templates, Arrays and dataReaders.
- Created DB2 and SQLServer Stored Procedures, and .Net(C#) WebServices to provide secure data access to various internet claims applications which included Provider, Member, and Employer and Broker portals.
- Worked with Lead DBA to create and implement Federated tables using ADO.Net and stored procedures for company and client websites.
- Created .Net test scripts for unit testing utilizing ADO.Net.
- Designed Programmed and Implemented DB2 backup and purge process for all Claims portals.
- Designed, normalized, created and loaded DB2 databases for UPMC Internet Claims Systems based on requirements from line-of-business users.
- Managed Project involving Pended Claims Extract application to electronically transfer Membership Benefit Determination information to Customers.
Environment: MS-Visual Studio.Net 2005, C#, ASP.Net, ADO.Net, MS-Visual Studio.Net 2003, Web Services, EDI, COBOL, SQL, DB2, DB2/Store Procedures, DB2 Federated tables, SQL Server, Enterprise Manager, XML, Classic ASP, SAS, TSO, Interdev, CICS, and ftp
Confidential
Programmer
Responsibilities:
- Participated in the development and maintenance of a Planned Maintenance and Inventory Control Application, which maintains work orders and monitors inventory of standard and nonstandard stock items, equipment, and spare parts.
- Most online programs are CICS/COBOL and access ADABAS.
- Responsibilities included all production problems of the Inventory Control System for online and batch.
- Worked with Refining and Marketing systems, responsible for modifying and creating new PL/1 and NATURAL programs for A/R systems.
- Interfaced several systems with a new employee data system, changing user views, files and JCL for batch and online programs.
- Converted PL/1, COBOL, and MARK IV programs from TOTAL to ADABAS files using SQL.
Environment: IBM, OS/MVS/XA, ROSCOE, VSAM, INTERTEST, SDF, CICS, ADABAS, NATURAL, COBOL, PL1, SQL