David R. Legere 11414 Powder Mill Trail Home: 512-363-5960 Austin, TX 78750-1037 Cell: 512-299-7621 e-mail: dlegere53@yahoo.com website: http://www.geocities.com/dlegere53/ SUMMARY of QUALIFICATIONS Twenty-plus years of Information Systems experience, specializing in project management, systems analysis, database architecture, and applications development. Hands-on team leader with full life-cycle expertise: requirements analysis; solutions design; development; quality assurance; technical documentation & training; roll-out; end-user documentation training, support. Significant Project Roles: Consultant, Project Lead, Business Analyst, Systems Analyst, Database Architect, Programmer/Analyst, Payroll Specialist, Customer Representative. Industry Experience: TX Comptroller, TX Div. Human Services, U.S. Dept. of Defense; Banking, accounting, pharmaceutical, health care, education, manufacturing,. Technical Skills and Platforms * Database Platforms: Sybase, SQL Server, MS Access; NOMAD. * Languages: SQL, Sybase, VBA, VB, C++; REXX, EXEC2, Mainframe SQL and DB2; BASIC, CADOL; RPG II, RPG III; COBOL, DIBOL; FORTRAN, Assemblers, JCL. * Development & Mapping Tools: PowerBuilder, Erwin, Visio. * Reporting Tools: MS Office (Word, Excel, PowerPoint); Perl, Korn Shell Scripting; Lotus Notes, Lotus 1-2-3; * Operating Systems: Windows XP, 2000, ME, 98, 95, NT; VM/CMS, VM/MVS; DOS, OS/2. * Network Environments: PC/NT; UNIX. * Additional Familiarity: Oracle; HTML, XHTML, CSS, JavaScript; Rational Tool Suite, Rational Unified Process, Rational Rose; LINUX (Red Hat). Education: BS, Computer Science – Loyola University, New Orleans, LA Volunteer Activities * Knowbility / AIR-Austin: non-profit website development team * TWC Transitions Technologies Lab: developed “Skills Matrix” database * Royal Rangers (boys scouting program): Peninsular Florida District staff; Austin Section staff (North Texas District). * Eagle Scout PROFESSIONAL EXPERIENCE CONSULTING Adea Solutions, LLC Austin, TX Systems Analyst Extended Wireless Computing Solution – TX Comptroller (TxCPA) * Designed, developed and implemented Help Desk System for gathering and tracking incident support data and periodic reporting to management. * Supervised co-worker in development of functionality. Developed, executed and documented acceptance test plan. * Produced requirements documentation, design specification, data model and user guide. Business Analyst Data Migration Proposal – TX Department of Human Services (TDHS) * Developed proposal for migration of Case Management System database from mainframe COBOL to WebSphere/Oracle. * Analyzed statement of work and software requirements; developed initial project plan. * Used MS Project to provide analysis support for proposal. Senior Systems Analyst Central Data Repository – TX Department of Human Services * Provided analysis of demographic data and regulatory compliance data for QRS website; developed and implemented processes for gathering, filtering and posting data to data warehouse; identified and analyzed customer requirements and business rules. * Coordinated data cleansing with responsible departments. Developed and executed monthly data validation and loading processes. * Increased the level of process automation. Recommended follow-up actions based on analysis. Developed data dictionary for a related data entry application. PsiNet Consulting Solutions, Inc. Austin, TX Senior Consultant Valued Partner rebate system (3MVP) – 3M Co., Electrical Products Division (ELPD) * Upgraded and supported application package which produced customer statements, performed sales tracking and rebate calculations, and generated periodic check runs averaging $15 million per year. Provided reports to management and comptrollers. * Successfully corrected system defects from previous developer to close program year in progress; automated additional processes. * Completed annual upgrades based on business requirements changes. Senior Consultant Y2K Readiness – 3M Co., IT Division, Software Development Services * Received customer letter of commendation and employer certificate of achievement. * Conducted program and data analysis of VM/CMS NOMAD and MVS NOMAD applications for Y2K compliance. * Performed additional program support and development for Electronic Products Division (EPD) and Electronic Handling and Protection Division (EHPD) Aonix, Inc. Schaumburg, Il Consultant Serious Adverse Global Events (SAGE) – Abbot Laboratories * Rendered project management assistance in SAGE Support Group. * Performed Quality Assurance, standards development and system documentation. * Provided program development and support for tracking system. Project Team Lead Clinical Trial Management System (CTMS) – Abbot Laboratories, (PPD) * Managed six full-time plus two part-time developers; trained five developers. Assigned support requests, tracked status and performed validation change control. * Served as primary application development liaison for department of 100+ users; led weekly staff meetings, monitored follow-up and oversaw special projects. * Designed and developed automated data loading package for loading data provided by clinical research organizations around the world. * Developed programming tools and program generators to automate and streamline routine support tasks. Performed database and data dictionary maintenance. Mastech Corporation Consultant Service Bureau to Big 3 Auto Makers in Detroit – Visual Services, Inc. * Developed online and batch procedures to run against large databases (4-5 million rows). * Completed performance tuning and achieved reductions in run-time. Reduced one process from nine minutes to 15 seconds. * Coached other programmers. ADDITIONAL EXPERIENCE Senior Programmer Lockheed Missiles & Space Co * Senior member of five-person team that completed 10,000 man-hour project in 2600 actual man-hours. * Reduced physical inventory timeline from one week to one day by developing barcode inventory control packages for Material & Handling Department and for Calibration Lab. * Produced TQL team documentation; benchmarked project management software. Systems Analyst Central Bible College * Trained and supervised junior programmer/analyst. * Reduced total Registration effort by 67%. Developed fully integrated Admissions system including course scheduling, advisor counseling, billing interface, and class rosters. * Reduced scholarship awards process by approx. 50%. Developed automated qualification matching process to streamline committee meeting time. Payroll / W-2 Specialist Remacs, Inc. (Realty Mart, Inc.) * Provided user training and customer support in Louisiana and Oregon. * Developed custom payroll package for Realtors’ business management system. Systems Representative Data Management Systems, Inc. * Supported ten customers in Louisiana and Mississippi. * Developed and maintained general business / manufacturing / accounting applications: GL, AP, AR, PR and Inventory Control. David R. Legere Page 1 of 3