PAUL McMillan
Email: *********@********.***
Address: **** ****** ******
City: Union City
State: GA
Zip: 30291
Country: USA
Phone: 760-***-****
Skill Level: Experienced
Salary Range: $80,000
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
Background
Proficient in C#/VB.NET. Advanced in ASP.NET. Thirty plus years of turning business concepts, needs, and/or problems into software solutions. Can take a concept from nothing to a solution. Some solutions were developed from scratch as an individual contributor. Gathered the requirements, designed, wrote the program code, tested, implemented, trained, supported, and wrote the documentation (user and technical). Extensive experience in the various activities of the Software Development Lifecycle. Solved complex problems and created innovative solutions. Strongest skill is writing code. Developed solutions for Fortune 500, medium-sized, and small companies. Worked on large, medium-sized, and small development teams.
Experience Summary
* Languages
o C#/ASP.NET: 2 years
o VB.NET/ASP.NET: 2 years
o C#/Windows: 3 years
o VB.NET/Windows: 7 years
o VB6/VBA: 12 years
* SQL
o T-SQL: 14 years
o PL/SQL: 2 years
o MS Access: 12 years
o SQL/400: 2 years
* Databases
o SQL Server: 12 years
o Oracle: 5 years
o Sybase: 2 years
o DB2: 2 years
o MySQL: 2 years
o MS Access: 12 years
* Tools/Technologies
o ADO.NET: 7 years
o SSIS: 3 years
o SSRS: 2 years
o SSAS: 1 year
Employment History
Sharp Community Medical Group, San Diego, CA 1/10 to Present
Senior Database Developer/Senior Software Engineer
* Developed data conversion routines in Visual C# 2008 (.NET Framework 3.5/4.0) and SQL Server 2008 to convert legacy clinical data from GE Centricity to Allscripts EHR.
* Maintained an ASP.NET issue tracking and CRM website using Visual Web Developer 2010, Visual Basic 2010 (.NET Framework 4.0), and SQL Server 2008.
* Converted data from GE Centricity EHR (Oracle) application to Allscripts EHR (SQL Server 2005/2008) application using SQL Server Integration Services 2005/2008, Visual C# 2008/2010, MS Access 2003/2007/2010, Visual FoxPro, ConnectR, Allscripts AIE, SQL Server 2005/2008.
* Developed an HL7 engine (parser) using SQL Server Functions to parse incoming HL7 result, patient demographics, and patient registration messages.
* Troubleshot HL7 billing message errors that occurred during the interface transfer of messages from Allscripts EHR to Allscripts Practice Management system.
* Developed and maintained programs in Visual C# (Winforms, .NET Framework 3.5/4.0) to read Allscripts inbound stored procedure interfaces to produce lists of parameters to match to incoming HL7 messages.
Cincinnati Financial (TEKSystems), Cincinnati, OH 9/08 to 12/09
Senior Software Engineer
* Maintained and enhanced a personal lines insurance policy application system in Visual C# 2005 and 2008, VB 2005 and 2008, SQL Server 2005 and 2008, and VB6.
Simpliance, Cincinnati, OH 5/08 to 9/08
Senior Software Engineer
* Modified an online forms web application using JavaScript, HTML, Visual C# 2005, XML, and SQL Server 2005.
Toyota Motor Corporation (Indecon), Cincinnati, OH 4/08 to 7/08
Senior Software Engineer
* Developed a program that generates graphs for the Warranty Administration Department using Access 2003, VBA, and Excel 2003.
National City Commercial Capital (KForce), Cincinnati, OH 8/07 to 3/08
Senior Software Engineer
* Created VB.NET and VB 2005 support applications using Visual Studio .NET, Oracle OEM, T-SQL, and Oracle PL/SQL, and SQL Server Enterprise Manager.
Luxottica Retail (CBS Engineering & IT), Cincinnati, OH 11/06 to 7/07
Senior Software Engineer
* Developed claims auditing and LASIK billing systems in VBA, Access 2000, 2003, and Excel 2000.
McFarland & Associates, Cincinnati, OH 5/06 to 11/06
Insurance Agent/Senior Software Engineer
Maintained a Customer Relationship Management system in VB 2005 and SQL Server 2005.
Prudential Financial, Cincinnati, OH 6/04 to 3/06
Insurance Agent/Senior Software Engineer
Developed a Customer Relationship Management system in VB 2005 and SQL Server 2005.
S & S Healthcare Strategies, Cincinnati, OH 8/03 to 5/04
Lead Software Engineer
Lead programming efforts in creating TPA applications using Access 2003, VB 6, and SQL 2000.
Los Angeles County Office of Education, Los Angeles, CA 2/01 to 8/03
University Radiology Associates, Cincinnati, OH
Senior Software Engineer
Developed a student transcript record keeping system in Access 2000 and 2003.
Migrated an Access 97 physician medical billing system to SQL Server 2000.
Software Engineering positions from 7/79 to 2/01 - Details upon request
Education: High School Diploma - Western Hills High School, Cincinnati, Ohio (1981) (GPA: 3.72)
Member of National Honor Society