Mike Smith Email & Phone Number

Glenview, Il

Highland Park, Il

Hines, Il

• Helped develop and deploy the new blood bank system, to over 150 sites nationwide.• Maintain the VBECS data model, data dictionary, and database change log.• Created SQL patches and patch test scripts for numerous updates to VBECS.• Created and maintained patch installation guides.• Database maintenance.• Converted 25 reports originally developed in Crystal Report 9.0 to SQL Server Reporting Services 2008(SSRS).• SQL 2000 and 2005 performance testing.• Incorporated SSRS into VBECS.• Integrated database development into source safe.• Restructured report stored procedures to remove dynamic SQL.• Implemented a change control process for database changes.• Working in an FDA compliant environment.• Developed, maintained, and executed work instructions test scripts.• Supported production installation in a clustered environment.• Involved in server consolidation through virtualization and active/active clustering.• Documentation reviews.• Installed MS SQL Server 2008 R2 and MS SQL 2008 R2 reporting services.Technology: Visual Studio.NET, MS SQL Server 2005, SQL Server Reporting Services 2005, MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2

Oakbrook Terrace, Il

• Part of a team that developed a new inventory system to track circuit, port, and device information. This system was integrated into an existing ASP.NET application.• Installed SQL 2000 Reporting Services on the production intranet and internet server.• Created new reports and integrated the reports into an internal ASP.NET application. • Rewrote the order entry screen to improve performance and maintainability.• Maintenance and support of the current ASP.NET system.• Customized Microsoft CRM application and installed it on the production server.• Created new Business Partner reports and integrated them into an external ASP.NET application.Technology: Visual Studio.NET, MS SQL Server 2005, MS SQL Server 2000, SQL Server Reporting Services 2005, MS CRM

Hines, Il

• Conducted performance tuning and backup strategy to the Blood Bank system.• Created indexes for the database • Reviewed and changed backup and maintenance plans for consistency.• Compared reference data on development and QA databases and documented differences.• Reviewed stored procedures for performance and compliance to standards.Technology: SQL Server 2000

Schaumburg, Il

• Created VB.NET custom controls for a Winforms application. • Developed stored procedures for numerous Crystal reports.Technology: Visual Studio.NET, MS SQL Server 2000, Crystal Reports

Woodstock, Il

• Created four new SQL reporting services reports consisting of one main report with a sub-report and two drill through reports.Technology: SQL 2000 Reporting Services

Lisle, Il

• Sarbanes Oxley initiative• Installed SQL reporting services and created new reports to show unauthorized users to financial systems and production database changes.• Developed a new application to review and track production database changes.• Developed a new application to view report information. • Created a new process that eliminates the need for Gentran. This process imports orders directly from the production order management system to the inventory management system. • Performed project maintenance and enhancements to a Windows DNA multi-tier system built using Visual Basic 6 COM components.

Lisle, Il

• Redesigned an Access 97 reporting process that produced and emailed reports. -- Reduced processing time from 4.5 hours to a 15 minute automated process. -- Moved data stored in Access 97 to a SQL Server 2000 database and utilized Access as the front-end to the SQL database. -- Added 11 new tables and 30 new stored procedures, as well as developed maintenance screens for the new tables.• Created a system to track product distribution, which entailed developing maintenance screens to monitor account, product and store information. -- Developed a process to create an SAP import text file. -- Added 8 new tables and 35 new stored procedures. -- Created on-request user reports and product reference spreadsheets for each account.• Developed a system to track customers with a bad payment history. -- Developed screens to maintain account, payer, and sold to, and report distribution information. -- Built an automated process to load SAP into the system. -- Created reports to track sales and payment information for the customers in the system, which are automatically sent out to the report recipients using Outlook.• Wrote user, as well as technical documentation for the three systems.

Lisle, Il

• Developed an import process that reads an outlook mailbox of Microsoft Excel spreadsheets containing customer order information, reformats and converts the data into XML, and imports this data into a SQL Server 2000 database.• Created a new process to calculate delivery charges to clients and delivery costs from vendors based on standard revenue and expense matrices. This process consisted of creating new COM components, new input screens to collect revenue and expense matrix information, connecting the information to clients or vendors, and calculating the cost charged to the client and expense paid to the vendor for each order. • Performed project maintenance and enhancements to a Windows DNA multi-tier system built using Visual Basic 6 COM components. • Wrote functional and technical specifications. • Created new crystal reports to show invoice information, billing information, and order counts.

Hines, Il

• Provided extensive database design, database administration, and legacy data conversion during the initial phase of the project. The database used was SQL Server 2000.• Developed an automated process to convert the data in an existing MUMPS database to a new SQL 2000 database. This involved using DTS to FTP the legacy system conversion files from the existing MUMPS database to text files on the database server. Business logic was put into other DTS packages, based on analysis of the legacy data, to parse this data into the new database structure.• Developed a set of Microsoft SQL 2000 standards and guidelines.• Created stored procedures for the application. This included automating generic stored procedure creation, writing application specific stored procedures, and reviewing stored procedures that were written by other developers.• Resolved issues using C# in the application.• Worked extensively with developing and maintaining objects for each of the three tiers areas. For the business tier, he coded complex FDA business requirements using C# and object oriented methodology and design patterns. • Participated in the construction of the user interface, as he has coded numerous screens specified by workflows and UML diagrams. • Utilized many features of ADO.NET in developing data access layer components.• Presented several training sessions on how to use Microsoft SQL Server 2000 and crystal reports.

Hoffman Estates,Il

• Lead database developer for the store’s main systems. • Redesigned the existing production database to incorporate new requirements, referential integrity, and to provide consistent data types.• Wrote database development standards.• Participated in modification of the Rational Unified Process to adapt to the client’s needs. Enhanced a VB 6/SQL DMO application to administer database servers. Performed database modeling using Embarcadaro’s ER/Studio.• One of two DBAs responsible for the administration of 22 remote production database servers along with development, QA, and integration servers. Created databases and implemented replication on new remote servers. Also, established log shipped on the fail over server. Upgraded MS SQL Server 7 database to MS SQL Server 2000 and established log shipping to the home office production databases.• Wrote database change scripts for each new release of the VB 6 applications. Worked with production support to resolve MTS and data issues as they arose. Created jobs to produce excel spreadsheets and email the results to the business area.• Re-wrote, modified, and added stored procedures used to pull data from a DB2 into a SQL Server 2000 database. Improved the processing time of these jobs from 3 hours to 2 hours with a 50% increase in the amount data being retrieved nightly.• Provided mentoring and training to internal developers.

Arlington Heights

• One of a two member team that restructured the company site and SQL 7.0 tables into a new format that eliminated redundant data and enhanced the flexibility of the system. This involved repopulating the data in the new format, rewriting about 200 stored procedures, creating new COM components, and creating new screens to update 10 new tables.• Enhanced and tuned an Active Server Page (ASP) application to speed up performance and to eliminate timeout errors. Made enhancements and assisted conversion from proprietary data formats to XML based data formats on the customer import process.• Member of a team of developers that migrated a Windows DNA multi-tier system from Microsoft SQL Server 6.5 to Microsoft SQL Server 7.0. Performance tuned stored procedures and made modifications to Microsoft Message Queue based nightly processing to accommodate updates to the SQL 6.5 accounting database.• Performed project maintenance and enhancements to a Windows DNA multi-tier system built using Visual Basic 6 COM components, Microsoft Transaction Server and Microsoft Message Queue Server. One of the techniques developed for this application was featured as the cover article for the March 2000 issue of The Visual Basic Programmers Journal. The business functions of the system are order entry, inventory tracking, product installation, and logistics planning.• Wrote functional and technical specifications. Wrote test plans and performed Y2K testing. Technologies used were Visual Basic 6.0, HTML, and VBScript.• Developed a process that imported Access 97 data into a SQL 6.5 table, populated the main database with order information on a nightly basis, and fed this information to the accounting database. This involved upgrading from Access 95, Access 2.0, and a Paradox system to an Access 97 system.

Schaumburg,Illinois

• Project leader in the migration of the EIS system from a Client Server application using Access 97 to a Web application using Active Server Pages (ASP), SQL Server 6.5 and a component architecture.• Redesigned the Access 97 tables during the conversion to SQL Server 6.5. • Created 34 reports using Crystal Reports 7.0 which were delivered via Active Server Pages (ASP) and the Crystal Reports Server Component. • Responsible for maintenance and enhancements to the Executive Information System (EIS) and Premium Planning (PP) systems.• Creation of ad-hoc reports for the Head Office Administrative staff, data extracts from mainframe systems, and providing technical support for the field offices.• Assisted in the development of a premium planning system that tracks each field office's premium at a policy level. • Developed the Executive Information System (EIS) system in conjunction with another business division.• Developed extracts from mainframe systems, automated downloads, and automatic updates to Access tables on a daily basis. • Automated manual process of supplying system updates to field offices. • Part of the initial team responsible for eliminating DATACOM from the application systems and replacing it with DB2. • Part of the team responsible for reviewing every program to ensure standards were met, code reviews to ensure that code was technically sound and efficiently structured, and ensured SQL was coded with performance in mind.• Worked independently and as team leader in the underwriting support area on complex project assignments. Assisted staff members in the development of requirements, design alternatives, technical design, and code review. • Member of the team that analyzed, developed, and implemented a new Loss Control system. The system tracked visits to client locations, risk engineering recommendations, timing of follow-up visits, and the comments of the location's risk. Directed and guided less experienced staff.