Experience

Meemic Insurance Company

• United States
• Insurance
• 200 - 300 Employee

• Web Developer

  • Dec 2016 - Present

  • Web Development on both internal and outward facing Websites. This includes creating new web pages, content management, and custom web controls for the user interface (UI/GUI) for the purposes of business operations, reporting, agent portals, Online Account Creation, and Event Registrations. Website content is managed using Kentico (CMS) with custom user controls and event processing written in C#, AJAX, Javascript, JQuery and Angular JS along with CSS styling. Angular JS calls Meemic RESTful Web Services directly. Websites utilize Microsoft SQL Server and IBM iSeries DB2 databases. • Database development using STAR and SNOWFLAKE designs. Architected relational databases using normalization with keys, indexes, and stored procedures to ensure integrity. Architected OLAP databases for reporting systems and for use with SQL Server Information Service (SSIS) for integrating data from multiple DBMS systems such as IBM DB2. • Web Service lead developer and designer on the project to create a RESTful Service for use by all the department applications and that functions as a central point for logging information including user activity such as profile updates, account registrations and grant applications as well as code-level information such as errors, warnings and debug entries. Information is stored in multiple repositories including a SQL Server Database and the Datalust Seq. The latter currently serves as a GUI front end. • Created high-impact email body content for Marketing Department campaigns that included custom graphics, hyperlinks, and HTM tracking codes used by Google Analytics. • Code reviews including planned meetings and one-offs. • Utilized the Atlassian stack including BitBucket for source code versioning and Jira for managing assigned tasks. • Worked closely with team members and managers to prioritize, coordinate, and meet deadlines on multiple projects as well as troubleshoot production problems. Show less



Franzem Technology LLC

• Grand Blanc, Michigan

• Software Developer

  • Jan 2016 - Present

  Client: Inovision Software Solutions, Inc. March - June 2016 • Developed financial applications for Invoicing, Expense Reports, and Time Cards (payroll) using Microsoft Visual Studio 2015, C# .NET 4.5, and MVC 5. • Developed database tables for Microsoft SQL Server using Star and Snowflake schemas. • Developed SQL queries, stored procedures, and functions that supply information to applications and scheduled jobs. • Developed interactive financial reports using C#/MVC5. • Personally met with my client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). Show less



DaGiovanni Photography LLC

• Grand Blanc, Michigan

• Photographer / Owner

  • Jan 2013 - Present

  www.DaGiovanniPhoto.com • Photograph Restoration • Real Estate • Portraits • Engagements • Sport Events • Car Shows • Vacation Destinations • Church Services www.DaGiovanniPhoto.com • Photograph Restoration • Real Estate • Portraits • Engagements • Sport Events • Car Shows • Vacation Destinations • Church Services



Hurley Medical Center

• United States
• Hospitals and Health Care
• 700 & Above Employee

• DBA / Database Developer / Software Engineer

  • Dec 2012 - Jul 2014

  Design and develop Web Applications, Desktop Applications, Database Queries, and Normalized Databases used throughout the enterprise. • Developed Web Applications and Web Sites using .NET4, C#, JQuery and AJAX. • Developed SQL queries and stored procedures for Microsoft SQL Server and Oracle using Star and Snowflake schemas. • Administered Microsoft SQL Server and Oracle databases. • Administered and developed financial and non-clinical applications (ERP). • Developed command scripts for Linux (RHES), AIX, and Windows VBS/CMD/BAT. • Developed and deployed Crystal Reports per customer specifications. • Developed courses, exams, and reports for HealthStream on-line learning system. • Administered the corporate intranet portal, hosted on PortalCOMPLETE (Processdata, Ltd). • Personally met with each client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). • Initiated defect resolution and change requests by opening tickets using POB-Point Of Business (Wendia, Inc.) and assigning to the appropriate engineer for resolution. • Created software release change documents, then posted and managed these documents on Microsoft SharePoint. Show less



Comerica Bank

• United States
• Banking
• 700 & Above Employee

• Senior Application Engineer / Developer

  • Jun 2003 - Nov 2012

  As a team leader, Design and develop Web Applications, Desktop Applications, Database Queries, and Normalized Databases used throughout the enterprise. Also assist project managers by developing project schedules and drive meetings. • Developed SQL queries and stored procedures for DB2. These were used for the purpose of providing data for marketing strategy. • Developed and deployed Crystal Reports per customer specifications regarding promotional interest rates and marketing needs assessment. • Designed and managed the build of infrastructure to support the corporate CRM applications used throughout the enterprise. • Developed scripts for Linux (SLES), AIX, and Windows. • Developed Web Applications and Web Sites used at all branches (over 400), including reporting application that delivered reports by directly interfacing with the corporate Business Objects Server. • Developed server based console applications to process paper and electronic form requests for bank account creation and maintenance. Also created many of the forms themselves. • Personally met with each client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). • Initiated defect resolution and change requests by opening tickets using CA Service Desk • Manager (Computer Associates, Inc.) and assigning to the appropriate engineer for resolution. • Developed materials and managed training sessions for application users. Show less



JPMorgan Chase & Co.

• United States
• Financial Services
• 700 & Above Employee

• Software Engineer / Database Developer

  • Jan 2003 - Apr 2003

  Project: Develop and implement a custom hardware resource tracking system for the enterprise. • Developed Web Applications and Web Sites using Microsoft Visual Studio. • Developed a normalized database for the application on Microsoft SQL Server using Star and Snowflake schemas. • Created and deployed Crystal Reports per client specifications. • Developed optimized SQL queries and stored procedures for applications and for consumption by Crystal Reports. • Personally met with each client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). Show less



Jabil

• United States
• Appliances, Electrical, and Electronics Manufacturing
• 700 & Above Employee

• Senior Software Engineer / Database Developer

  • Jun 1999 - Jun 2002

  Design and develop desktop applications and databases used throughout the enterprise. • Developed a normalized database for the application using Star and Snowflake schemas. • Developed and optimized SQL queries and stored procedures. • Developed real-time software applications used for the purpose of product quality control. • Developed desktop applications using Visual Studio, Visual SourceSafe, and deployed using WYSE InstallMaster. • Developed product labeling application (Barcodes, MAC addresses, Serial Numbers, etc.) that directly interfaced with the corporate Loftware server for centralized printing of all labels. • Developed Crystal Reports per customer specifications and deployed to Crystal Report Server. • Personally met with each client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). Show less



Microlinear Corporation

• Sterling Heights, Michigan

• Senior Software Engineer / Computer Engineer

  • Aug 1993 - Jun 1999

  This was a multi-faceted position encompassing the development of manufacturing software applications, hardware device driver development, hardware design, sales, and service. • Developed real-time software applications used for the purpose of product quality control. These applications interfaced with GE/Fanuc CNC robotic controllers to help maintain quality of product. • Developed desktop applications using Pascal and C++. The application GUI produced statistical summaries, charts, and graphs based on data stored in a database. • Developed Device Drivers using Assembler Language for the purpose of interfacing with the custom designed and manufactured Microlinear option cards for the IBM PC. • Developed Custom GUI interface to allow shop workers to use software without the use of a mouse or keyboard. • Met with potential customers to pitch for sales of Microlinear products resulting in successful sale of products and thus generating income for the company. • Personally met with each client to determine and review requirements as well as follow up on completed work (Business Analyst / “Face-Time”). Show less