Gloria Woerheide

===========================================================================

Seasoned Software Consultant Seeks
 
  • Visual Baisc.Net, Ironspeed Designer or PowerBuilder contract.
  • Project Management
  • System Analysis and Design projects
  • Database Extract Transform and Load ( ETL )
  • Electronic Data Interface ( EDI )
  • Microsoft DTS
  • Database modeling
  • Business Process modeling
  • Language Conversion projects:  PowerBuilder to .net 
  • Data conversion projects including VAX or Mainframe to Oracle,  Sybase or SQL Server
  • Complete Design and Development, System Maintenance, Prototype Development
  • Offsite contract with travel to client site several times a month.  Or, onsite contact in southeastern or central Connecticut, or Providence, RI.
  • New development or maintenance.
  • Time and materials or fixed bid relationship.
PROGRAMMING, PROJECT MANAGEMENT, BUSINESS ANALYSIS, DESIGN/DEVELOPMENT,  SENIOR IT
Professional capable at various levels of contribution from project management and leadership to detail programming of complex business requirements.
 
Summary of Qualifications: Technically trained individual with extensive professional experience in:  design/development/ implementation of Information Technology systems, project management, methodologies, strategic & organizational planning, scheduling, business operations & administration of state-of-the-art mission critical applications and database design/ programming.  Possess a detailed understanding of the strategic use of information in the business environment.  Bottom line individual with a solid track record for increasing operational efficiency & generating cost savings.  As a manager:  highly successful in meeting aggressive timeframes & building cohesive, productive teams.  As a developer: heavily experienced in analyzing and repairing/updating existing applications and at converting specifications into operational software. As a business analyst:  heavily experienced at identifying business needs and converting them into achievable goals, analyzing and documenting business processes, conducting design sessions with users, and writing user and technical documentation.    Can communicate effectively at various organizational levels. Team player.
 
Expertise and knowledge in areas such as
Project management

Applications/Solutions

 Vendor Relations Software Design/Development
Programming Data Modeling Database Design Data Warehouse
Staff Development Technology Assessment Team Building

Strategic &Organizational Planning
Architecture/Infrastructure

Client/User Relations

 System Integration Training & Education
Website Development Software Applications Forecasting

Scheduling & Best Practices
 
Education: Washington Univ., St. Louis, Mo. BS in Computer Science.  De Paul University completed 85% of MBA. College of DuPage, chemistry, anatomy, & Russian in late 1980s.  C#, ASP.net & Biotechnology coursework in 2003-4.  Professional seminars including PowerBuilder, Java, & OO modeling.
 
Technical Background: PC: VisualBasic.net, PowerBuilder (Windows), C#.net, MS SQL Server/Sybase/SQL Anywhere, DTS, T-SQL, SQL Stored procedures, Oracle, WordBasic. Mainframe: OS/MVS, IDMS/ADSO, COBOL, SAS, & FORTRAN, Demarco/Yourdan Structured Methodology, Data Flow Diagrams, Object Oriented Design, Booch Object Orient Design, & relational database design.
 
Professional Experience:
X-Over-Y Systems 2000 to present  Software Consultant & Business Manager responsible for client projects, policy & ongoing operations.  Personal consulting engagements as project manager, project leader, programmer, database modeler and business analyst.   Managed staff that varied from 1 to 8. 
Developed EDI middleware application to interface with MBI health insurance management software. Worked with MBI  Maintained VB billing software and data warehouse, database modeling.   Ms SQL Server,  T-SQL, DTS, Visual Basic.net, ASP.net, Ironspeed Designer, Sybase PowerBuilder, Oracle 9, Visio
Designed web based data warehouse software to support inductive & deductive analytical research for the following business areas:  pharmaceutical, manufacturing, marketing survey research, litigation support, & eBay listing & sales performance.  Product to be developed with Ironspeed Designer, ASP.net & C#.net. Took training in C# & .Net technologies. 
Developed website, & wrote content for a tourism website, veterinarian's website and a lingerie website.
Developed & managed eBay retail business. Certified eBay trainer. Member eBay Developers program.
 
Analysis of operation problems, data cleansing,  and programming MS SQL Server  Transact SQL scripts & stored procedures for a Marketing firm.
 
3.5 years at Pfizer Inc.  Application manager, designer & developer in Bio Informatics area for MTV, which was the data warehouse for all Animal Health Discovery research (biological screen) data,, and  for VB-Reg Biologicals research application.  Included defining/developing reports, logical database design, software enhancements, brainstorming with scientists to define reporting objectives, release management, data cleansing, and data conversion from VAX to Oracle. PowerBuilder 6.5/8, Oracle 7/8  

Construction Management:  Managed 4 real estate renovation projects.
 
Woerheide and Associates  1976 to 2000  Software consultant & manager.  Various analysis, development, & project management projects in client-server & mainframe environments, including: requirements studies & needs analysis, design, programming, test plan development, testing & documentation.   Clients included:
 
Owens of Ill, Toledo, Ohio  1.5 years Project to Customize GEAC ERP (Payroll/Personnel) for retirement, salary & hourly payrolls.  Rewrote GEAC payroll register, backend process (T-SQL) to extract report data, & other reports. Developed user defined reports and payroll control system using GEAC SmartStream class libraries. PB 5, Sybase 11.
 
Deloitte and Touche for US DOE at Hanford Site.  3 month project to develop reporting system for Peoplesoft data warehousing project & to write Oracle stored procedures.  PB 6, Oracle 7.
 
Met Life Property and Casualty  Insurance 2 ½ year project to design & develop home & auto insurance quote system.  Mentor & programmer on multi-tier, OO laptop/internet project. Brainstormed with users to model home & auto quote processes & databases & to develop application prototype. Programmed OO objects.  System architecture was MVC pattern.  PowerBuilder5, Rational Rose, Erwin, Sybase stored procedures & custom framework.
 
Equal Employment Opportunity Commission of the U. S. Government - 5 years providing litigation support in over 10 cases in 3 different U. S. District Courts. Brainstormed with attorneys to develop the method of proof as related to supporting data. Designed & developed software to analyze payroll/personnel data.  Developed codification methods & supervised document coding. Testified in Federal court regarding results of analyses. Developed case tracking system & Computers in Litigation seminar. Managed staff of 10.  SAS & COBOL.
 
Prior to 1978: Projects for various private industry & labor union clients, Work involved programming in COBOL, FORTRAN, systems analysis & design, writing, & management, including 1.5 years at Honeywell Information Systems as a Systems Engineer. Taught programming part time.
 
Highlights by Business Area
Pharmaceutical & Medical: Designed & programmed software & database enhancements. Brainstormed with research chemists & biologists to define reporting requirements.  Responsible for on going operation of this major application.  Programmed a patient records system & medical office system.  Responsible for software in a Pathology Lab.
 
Human Resources: Personnel/Payroll: Installed M & D on-line HR+; conducted research abroad into the HR reporting requirements of U. S. multinational firms; reviewed payroll practices & procedures; developed software & procedures to analyze 13 defendant HR systems on behalf of the EEOC; analyzed feasibility of installing HR system for 100,000 employee work force; worked with MSA payroll system; customized GEAC ERP payroll system (SmartStream)
 
Financial: General Ledger: Designed a system; converted 30 CPA clients to automated G/L. A/P & A/R: Programmed 1 A/P & 2 A/R systems.  Financial Reporting: Designed an on-line real-time international reporting system. Banking: Lending (A/R, billing, sales management, loan accounting, & collateral management) Conducted business study of operations at 6 sites; presented results to CEO, division presidents, & other officers; mentor for team of 18 officers, managers, & professionals in system design. Programmed on-line portion of loan portfolio management reporting, Designed & developed reporting software for loan workout area.  Leasing: Designed & developed on-line system to maintain equipment leasing data. Conducted quality control review, requirements studies, & software development in lease management, equipment inventory, & financial areas
 
Sales & Marketing: Sales Analysis/Accounting:  Feasibility study on automating sales management requirements; Developed a theoretical model of direct marketing sales force management to identify decision areas.  Developed a computerized marketing simulation game for Grad Business School. Designed a system to display & market apparel for retail stores buyers. Developed & analyzed results of marketing research questionnaires. Designed & developed promotion fund management system.  Programmed an order entry system for a catalog based incentive sales organization.
 
Manufacturing, Inventory Control & Retail: Analyzed a manufacturing labor reporting & costing system. Developed drug & parts inventory systems. Maintained & converted equipment inventory software. Analyzed requirements for data entry system to capture diesel engine adjustable parameters. Modified software for another engine product to include these features. Developed software to convert data from one system to another. : Conducted requirements study for custom order portion of furniture business, involved EDI.
 
Education: Developed a student record system. Provided research support to a Graduate School of Business faculty. Taught college level programming & tutored business school graduate students in programming & research software use. Developed & taught seminar for labor law attorneys in the discovery, reliability, & use of computerized business records as evidence.
 
Government and Legal: Designed and programmed case docket systems for private client and St. Louis Circuit Court System.  Analyzed commercial finance usury law monitoring requirements; Provided litigation support for Federal attorneys (developed trial evidence and testified in Federal court.) Developed package to track development of city council ordinances. Participated in design and development of court docketing system.
 

Insurance: Developed EDI middleware for health insurance flexible spending payment accounts. Worked with Metavante MBI Employee Benefits debit card system.  Maintained claims system. Developed agent commission system. Maintained policy generation systems and claims disbursement system. Developed prototype and participated in design and development of Property and Casualty Quote System.