Application Software Delivery Advisor Resume
Hartford, CT
SUMMARY
- A challenging senior technical position to employ client/server or component - based technologies in order to make a positive contribution to meet the objectives of my employer.
- The position will provide me the opportunity to furnish technical expertise in a mentoring role, empower me to investigate emerging technologies to better position my employer in its marketplace, contain project lead responsibilities and allow me to be a technical department champion.
- The position will have career growth opportunities that will eventually lead to a technical lead position.
TECHNICAL SKILLS
Languages: VB. Net, Visual BASIC 6.0, VBA, VB Script.
Machines: PC and compatibles
Operating Systems: Windows 7, Windows XP
Programs: MS Word, MS Excel
Databases: MS SQL Server 2000/2005/2008 , MS Access, Oracle, DB2 UDB, Sybase
PROFESSIONAL EXPERIENCE
Confidential, Hartford, CT
Application Software Delivery Advisor
Responsibilities:
- Staff developer on desktop applications that support the evaluation of all medical plans across all medical product lines. Lead developer on technology upgrades from Windows XP to Windows 7, Visual Studio 2005 to Visual Studio 2010 and Office product files from .
- Conversion of applications written in Excel VBA to VB.Net. Created Stored Procedures to enhance performance of application interaction the SQL Server database. Also involved in the construction, unit testing and deployment phases of business enhancements to existing code assets.
- Staff developer on a desktop application used by Real Estate services. Allows the user to update information store on an Oracle database and to produces reports via OLE automation to Excel. Involved with technology upgrade, construction, unit testing and deployment phases. Technologies: VB6, Oracle, Excel.
- Sole developer on an MS Access/MS SQL Server application used by the financial area to perform SG&A expense allocations that provides a feed to the Executive Management Information System. Involved with technology upgrade, construction, unit testing and deployment phases. Technologies: MS Access, MS SQL Server, VBA, MS Excel.
- Lead developer on an ETL system executed by ZEKE jobs that run VB Scripts to process member and financial data for Financial Analysts who view the data in Cognos. Involved with technology upgrade, construction, unit testing and deployment phases. Technologies: VBScript, MS SQL Server with Stored Procedures.
- Staff developer on a web-based application that provides selected Word and Excel documents for new business and merges prospect information into them. Involved with technology upgrade, construction, unit testing and deployment phases. Technologies: VB6, ASP, MS SQL Server, MS Excel, MS Word, IIS, COM+.
- Staff developer on a web-based application that provides ad-hoc and predefined network or geography based, product specific, time period filtered, measure requested data reports via OLE automation to Excel. The business owner uses a client/server-based suite of applications as an ETL tool to collect, import, translate and store the data used by the application. Involved with capacity planning, analysis, design, construction, unit testing, implementation and deployment phases.
Technologies: VB6, ASP, MS SQL Server, DB2 UDB, MS Access, MS Excel, IIS, COM+.
Confidential
Business Systems Delivery Specialist
Responsibilities:
- Lead developer on a client/server application used by medical underwriters to track potential customers whose request for insurance meets the guidelines for follow up by a medical underwriter. The application creates data merged Word based letters. Involved with technology upgrade, capacity planning, analysis, design, construction, unit testing, implementation and deployment phases. Mentored 3 developers. Created technical specifications. Created letter subsystem in MS Word a report subsystem in Crystal Reports. Provided on going technical support. Responsible for application remediation for Y2K compliance. Technologies: VB6, Sybase, MS Access, MS Word, Crystal Reports.
- Lead developer on a client/server application used as both a stand-alone census capture system and as a front end other internal applications. The application also imports files for populating its database. Create a data load tool used by the Actuarial Systems department to load lookup network, product and geographical information used by the application. Involved with technology upgrade, capacity planning, analysis, design, construction, unit testing, implementation and deployment phases. Mentored 4 developers. Technologies: VB6, Sybase, MS Access, MS Excel.
- Lead developer on a desktop application used to perform experienced and non-experienced based claims projections for non-HMO products tailored by benefit selections. Excel spreadsheets provide information for the contributing factors to the claim cost projections. Involved with technology upgrade, analysis, design, construction, unit testing, implementation and deployment phases. Created technical specifications. Upgraded system from VB3 16-bit to VB5 32-bit. Responsible for application remediation for Y2K compliance. Converted application from DAO to ADO and DDE to OLE technologies. Performed code redundancy analysis and elimination. Provided on going technical support. Created external system interface to create new claim projections. Mentored 4 developers.
Technologies: VB6, MS Access, MS Excel.
Confidential, Hartford, CT
Senior Consultant
Responsibilities:
- Provided expertise, leadership mentoring in Microsoft Visual Basic 3.0 (VB) programming. Defined VB coding standards for the department.
- Part of a team responsible for development of batch cycle input and processing in VB and enhancing and debugging the user interface in VB for an insurance proposal system. Responsible for making enhancements to the WordBasic code found in Word 6.0 template files. Responsible for fixing bugs in C DLLs. Responsible for production support problem resolution.
Technologies: VB6, MS Access.
Confidential, Farmington, CT
Data Processing Consultant
Responsibilities:
- Part of a team responsible for designing the user interface in VB and Access for a disability income insurance pricing system. Technologies: VB6, MS Access.
- Part of a team responsible for creating disability income insurance underwriting software application in VB and MS SQL Server. Wrote functional specifications and technical documentation for a disability income insurance underwriting system. Technologies: VB6, MS SQL Server.
- Responsible for upgrading a PC-based Medicare Part A and B claims entry systems running under DOS using C-Worthy and Borland Turbo C. Enhanced and tested new data communication requirements for both Medicare systems. Tested and refined the phone data communication scripts for PROCOMM. Improved the on-line help system. Performed telephone support to handle Medicare software and PC hardware problems and questions. Made recommendations to provide more efficient support. Provided support for batch cycle test area. Upgraded UNIX-based claims batch processing and reporting system.
Technologies: Borland C, C-Worthy, telephone communications.