EXPERIENCE SUMMARY:

• 30 years experience as a computer programmer with over 10 years as a contracted consultant.
• 2 years experience as a technical recruiter of Engineering and IT talent.
• Over 10 years working in the automotive design and development environment
• Understands the hiring process as an employer, as well as the consultant
• Familiar with different visa types for foreign workers.
• Comfortable working directly with upper management, business managers, system users, and technical team members with diverse backgrounds.
• Self - motivated professional, who is a dedicated team player with a strong work ethic and customer service orientation

SKILLS SUMMARY:

Languages: ASP.Net, ASP, MVC2, Visual Basic 6/.Net, C#, MS Access (ADP/VBA), VBScriptJavaScript, AJAX, JQuery, LINQ, HTML, DHTML, CSS, SQL, XML, XSLT, WSDL, PHP, Perl, Crystal Reports 10/20, Net-Tiers, COBOL II, JCL

Software Tools: MS Visual Studio 2010/08/05/03 , SQL Reporting Services 2008/2005, SQL Integration Services Packages 2008/2005, DTS Packages, IIS 5/6/7, MS Office 2010/07/03/00 , Visio. MS Project, CodeSmith, T4 Templates

Databases: MS SQL Server 2008/2005/2000/7.0/6.0 , MS-Access 2010/07/, Oracle 8i, DB2, MySQL, IDMS, IMS

Operating Systems: Windows 7/XP/2000, Server 2008/2005, Windows NT 4.0, MAC OS X-10, UNIX, MVS/TSO

PROFESSIONAL EXPERIENCE:

Confidential

Account Manager / Technical Recruiter

Responsibilities:

• Recruiting Engineers and IT professionals for Siemens, Volkswagen, Oakland County, and State of Michigan.
• Developed recruiting division from the ground up. Created form letters, naming standards, tracking functions, and automated custom email processes.
• Researched the most highly ranked schools for Engineering and Computer Science. Established relationships with universities near client job sites.
• Posted jobs on student/alumni websites, and other sites where Engineers and IT professionals gather.
• Placed a student from Temple into an internship with Siemens. She had her contract extended then hired.
• Created recruiting database to import job postings and resumes.
• Modified company website to show current jobs and accept user resumes online.
• Created social media sites for recruiting and posted all new jobs there.
• Analyzed customer database to define unique jobs and skills used at each location.
• Searched for resumes fitting those jobs, skills, and location.
• Reviewed and ranked all resumes according to the requirements of each job.
• Prescreen candidates and confirming s before submitting to client.
• Push hiring managers to review resumes and coordinated interview schedules.
• Reviewed and processed all pre-employment documents.
• Scheduled and coordinated drug testing of potential candidates.
• Conducted background checks of potential candidates.
• Created and published all press releases for the company

Environment: Fieldglass, ZipRecruiter, Monster, Dice, Facebook, Twitter, LinkedIn, Craigslist, Google Groups, Visual Studio 2010 (ASP.Net, C#,) SQL Server 2008

Confidential

System Developer

Responsibilities:

• Designed and developed a parking management/accounting system for all lots managed by Olympia Entertainment.
• Forecasting staffing levels and generated work schedules based on various event calendars.
• Automatically generated reports after each event. Revenue split according to individual lot contracts. Ticket management and location tracking. reports, cash/ticket discrepancies
• Created secure user interfaces and reports for lot managers, accountants, and system administrators.
• Met with parking operations director and lot managers to define requirements.
• Designed database structure, developed all queries, and imported data from various sources.
• Provided budget estimates and project status to management
• Researched latest tools to support management desire to be on the leading edge
• Recommended development infrastructure (build,test,log, etc)
• Integrated MVC 2 code with Telerik controls, and researched compatibility issues.
• Designed and developed a system for tracking free meal tickets that were issued by various departments.
• Devised a ticket numbering scheme to identify issuing department, and purchasing batch
• Created a simple interface to scan tickets at each event. Captured event, department, batch, and ticket number into SQL Server database.
• Created online reports for departments to track usage, number outstanding, and event summaries.
• Designed business process and database structure. Mentored junior programmer’s development of screens. Tested system extensively before launch.
• Provided hands-on support during each event.

Environment: Visual Studio 2010 (ASP.Net, C#, MVC, JQuery, Telerik MVC, MOQ, nHibernate, ) SQL Server 2008

Confidential

Programmer Analyst

Responsibilities:

• Designed and developed a new school accreditation reporting system. Modified existing LINQ based system to correct database design and allow for more accurate reporting. Created SQL queries and jobs to categorize and summarize data into an Excel reporting format.
• Replaced an old PHP/MySQL based system that creates organizational contact lists, and data files for other systems and vendors to import school information. Report subscriptions were used to run the reports daily, and batch files moved the reports to the web server for viewing.
• Designed and developed a new system for tracking the of all company employees. New system allowed for any new programs to be created, and course materials to be reused by any other program. of employees at all schools are entered into the system, and custom reports were developed to track each school’s success. Exception reports were created to identify employees needing . An interface was created to retrieve data from People Soft databases and automatically include new employees in the system, as well as remove inactive employees. Executive summary reports were also created to rank all schools’ success across the entire corporate hierarchy.

Environment: Visual Studio 2008/5 (ASP.Net, C#, JavaScript, AJAX) SQL Server 2008/5, PHP, MySQL

Confidential

Programmer Analyst/Webmaster

Responsibilities:

• Sole developer for publisher of legal notices and foreclosures throughout the state of Michigan. Design, develop, and support custom business systems, commercial websites, and corporate intranet applications
• Designed and created new customer website that consolidated 10 separate newspapers into one site for the publishing company. Created custom content management system, and single sign-on to access individual papers based on customer subscriptions
• Created a web-based system for remote recording of foreclosure postings throughout the state of Michigan. System also printed the actual documents that were to be posted on the homes. System tracked the date/time of the actual posting, and imported photos of the documents posted on the home.
• Direct support of all customer calls regarding the website
• Designed and created custom websites to allow the largest law firms in metro Detroit to search and track the foreclosure notices they had published. Each firm had a secure site to display only their own data
• Designed and created all SQL Server database components. Stored procedures, triggers, views, table content and relationships. SSIS packages for importing and cleansing data for many sources. Security based on customer subscription status, which could change daily
• Created custom applications to capture web content as soon as it was created. Programs created meta-data according to industry standards so articles could be found by search engines and automated news services
• Personally responsible for extracting articles from Macintosh based editorial system and updating website content for daily and weekly newspapers.
• Converted raw statistical information from several county agencies into common formatted web pages, on a daily basis
• Enhanced and supported a custom tracking system for home foreclosures across the entire state of Michigan.
• Created a new automated process for users to import and modify newly published notices from a third-party data entry system.
• The new process had to ensure all required data was provided and was converted from a Macintosh MySQL database to SQL Server format for the new websites.
• Also, modified database structure to import data from 3 regional MS Access database copies into one corporate system

Environment: MS Access (ADP) 2003/7, VBA, Visual Basic 6.0, SQL Server 2000/5, 5% UNIX/Mac OS 10X, MySQL

Confidential

Lead Programmer Analyst

Responsibilities:

• Gathered requirements.
• Created detailed project estimates and work plans.
• Supervised the workload and development efforts of 2 programmers
• Designing, constructing, and implementing a wide variety of business systems.
• Supported many small business clients and made enhancements to their systems. Created custom reports.
• Designed and developed an ad-hoc Report Writer for an inventory management firm

Environment: Visual Studio 2003/5 (ASP.Net, VB.Net, JavaScript), Windows, VB 6, MS Access 2003, SQL Server 2000, Crystal Reports 10/20

Confidential

Lead Programmer Analyst

Responsibilities:

• Responsible for analyzing, designing, developing, and supporting a wide variety of business applications in a dynamic research environment with over 800 engineers. Part design management, cost management, purchasing, vehicle test scheduling, fleet management, plant adoption, part utilization, and design release applications
• Provided first-line help desk support to several mission critical systems used in the tracking and releasing of part design changes. Some engineering changes were for immediate release to resolve production problems on the manufacturing plant floor. Many were used for local builds for testing of new part designs
• Personally selected by the IT Director to participate in workgroups responsible for defining and implementing Confidential Revival Plan (NRP) to reduce cost for all North American operations. Provided IT perspective, and suggestions for process and system changes needed to track and report the estimated and actual cost savings
• Worked with all levels of the design engineering, purchasing, and manufacturing communities to develop a short-term and long-term plan for system development to accomplish the NRP goals.
• Designed and directed the team development of a secure intranet website to track the processing of cost saving proposals. Analyzed local and global business processes to identify and resolve conflicts. Primary design concern was for ease of use, so I conducted focus group sessions to find the best ways to help the engineers do their jobs. The North American launch was so successful, that it has been adopted as Nissan’s global cost tracking system. Created detailed tracking reports and executive summary reports for upper management.
• Designed and created a new web based system for releasing part design changes to the manufacturing plants and suppliers. Design allowed for field-level data security based on user’s job responsibilities. Integrated the proposal tracking and releasing systems, and allowed for data interchange between the systems to reduce redundant data entry
• Enhanced and supported mainframe applications used for tracking part design changes and a report scheduling system. Created ad-hoc reports for upper management, and supported approximately 300 standard reports that were used worldwide. Provided front-line help desk support of these mission critical systems
• Created detailed requirements, program specifications, database designs, class diagrams, and use cases to verify system functionality
• Created detailed project estimates and work plans
• Conducted design and code reviews with upper management and technical team members
• Prepared presentations for system concept approval and end user

Environment: Interdev (ASP, JavaScript, Windows, VB 6, MS Access 97/2000, MVS, SQL Server 6/7/2000, DB2), Manufacturing plant and test facility interfaces for purchasing and tracking part changes

Confidential

Programmer Analyst

Responsibilities:

• Conducted user interviews and analyzed existing IMS on-line and batch programs to determine the requirements for a transaction interface with a new Nuclear Procurement System at Enrico Fermi Nuclear Power Plant. Defined the transactions and field edits required to update the corporate material management and accounting systems with all requisitions and orders placed at the remote power plant
• Prepared test cases and test data to verify the requirements by processing the transactions into a simulation database. Interacted with users and developed a complete functional design of the interface
• Designed methods to communicate transaction processing status, invoice payments, order status and updated vendor information between the two systems
• Wrote several detailed program specifications and directed the work of two other programmers
• Wrote IMS batch programs to extract vital information from the corporate databases and transmit it to the remote system
• Provided resource estimates for task completion and helped the project leader prepare schedules using the Project Workbench tool
• Direct support of Edison’s Material Management System around the clock, including trouble shooting and resolving any issues with nightly batch processing. There was only a two-hour window before the system went back online for ordering missions critical supplies. I had to personally resolve any issues within that timeframe, and did so for two years without fail

Environment: IBM MVS/TSO, IMS