David McElroy
                     
David McElroy - Resume
Download this resume as PDF
 
           SKILLS
          
     Project Management
     Inventory Control Management
     Production Planning / Scheduling
     Accounting & Bookkeeping functions
     Strong verbal and written communication skills
     Strong attention to detail
     Strong organization / innovation skills
     Proactive nature
     Great People skills; polite and personable disposition
    With Advanced Expertise in:
          Access Database / Query design
          Access GUI & Report design
          Access and Excel VBA Programming
          Excel Workbook design
          Active Directory
          Exchange Server
          Domain / Website Management
          ASP / HTML Web application design
            
           PROFESSIONAL EXPERIENCE
            
           Business Systems Analyst - Connolly Healthcare, Conshohocken, PA (Oct '12 - Present)
          
  • Support Recovery Auditing efforts through Access and SQL Server development.
  •             
               Inventory Manager / Programmer - Synergy Orthopedics, Inc., Plymouth Meeting, PA (Aug '09 - Oct '12)
              
  • Developed, designed, and programmed complete Order Entry / Inventory Management System.
       
  • Barcode scanning process, posting to Purchase Order
  • Email POs to vendors
  • Purchase / Usage history reporting
  • Developed Stock Scanning program for Inventory counting, interfacing with OE/IM System.
  • Maintain Inventory levels at 70 locations, reorder from POS transactions
  • Investigate new product lines and set up vendor accounts for acquisition
  • Provide Sales / Inventory Control reporting to upper management
  •           
  • Developed database programs for Inventory Control - Product Count Scanning, Usage Tracking, and Reordering
  •             
               Self-Employed Access Db Developer - AccessDbDevelopers.com , Southeastern, PA (Aug '06 - Present)
               Designed, developed and maintained custom client software applications in many areas, including:,
       
  • Inventory Control
  • Order Entry / Fulfillment
  • Sales / Commission Reporting & Tracking
  • Production Labeling / Bar Coding / USPS Sorting
  • Medical Claim Filing / Tracking
  • Text / Excel Importing and Parsing
  •             
               Programmer / Production Manager - Resource Data Products, Lititz, PA (Jan '08 - Mar '09)
              
  • Directed the operations of production, assembly, and shrink-wrap production line for high volume CD and DVD duplication and fulfillment.
  •           
  • Developed Quality Manual and procedures for ISO 9000 orientated Quality Assurance department.
  •           
  • Devised strategies and policies to ensure that production objectives were met.
  •           
  • Provided Technical Support via telephone and email for the HexaLock Data Encryption system: www.hexalock.com
  •           
  • Developed Access database software for:
       
  • serializing and barcoding Item, Bundle, Carton, Pallet for packaging & shipping
  • USPS mail tray sorting
  • manufacturing and maintenance reporting
  • customer service logging for supervision and billing
  •             
               Programmer / Office Assistant - Total Orthopedics Inc, Littleton, CO (Aug '06 - Oct '07)
              
  • Designed Database program for post-surgery pain management product fulfillment, patient information entry for filing insurance claims, with ICD-9 diagnosis code lookup, AOB aging, product usage and reimbursement, and Medicare reports.
  •           
  • Performed daily sales report generation, design and generated 'Cognos' (OLAP) Cube reports, and worked with the President to coordinate inbound report requirements from sales staff
  •           
  • Coordinated arthroplastic implant surgery POs from hospitals to facilitate billing.
  •           
  • Designed Internet Web Application for online surgery scheduling.
  •           
  • Designed websites for several associated companies
  •             
               Programmer/ Office Manager - Great Lakes Circulation, Evergreen, CO (Aug '03 - June '06)
              
  • Designed complimentary Order Entry, and Field Sales Commission database programs in MS Access, which interface with data in MS SQL Server and MS Excel, executes automated email processing through MS Outlook, accepts orders from internet connected data entry stations, and encrypts credit card numbers for security.
  •           
  • Managed daily operations of Sales Office / Order Entry Center - managing staff, inventory and ordering, receiving, Customer Service
  •           
  • Reconciled Bank Accounts to Checking in QuickBooks financial software
  •           
  • Performed printer installations and maintenance, Vodavi® digital phone system programming, maintained office inventory, supervised Customer service employees.
  •           
  • Wrote procedures for Quality Control, Customer Service, Inventory Management.
  •           
  • Maintained Traveling Sales Staff's Inventory and organized supply distribution.
  •             
               Database Programmer - CT Incorporated / Ware Unlimited, Salunga, PA (April '99 - March '03)
              
  • Programming: MS Access Database Design, MS SQL Server 6.5, 7.0, MS Visual Basic 6.0 , HTML with ASP data presentation, FTP importing and exporting for live "online" data access.
  •           
  • Internet Facilities Support: Registered and maintained Domains, installed Secure Certificates, created and maintained IIS and DNS records, FTP and Mail services, "Hit Count" statistics reports.
  •           
  • Technical Writing: Wrote detailed procedures for daily and periodic functions, created User Manuals.
  •           
  • Customer Support: Assisted customers with technical difficulties related to software supported by CT Inc./Ware Unlimited, aided in proactive problem identification and avoidance with client systems and operations, secured and suggested value added sales of both hardware and software.
  •             
               Sales Associate / Customer Service - Cyber Warehouse, Lancaster PA (moonlighting May '02 - June '04)
              
  • Computer and Peripheral Equipment Sales, Customer Assistance, Help Desk Support.
  •             
               Installation Technician - CS Electronic Systems Inc, Lititz PA (August '98 - April '99)
              
  • Installed and terminated Cat 3 (phone) and Cat 5 (data) wiring in commercial and residential settings.
  •           
  • Installed and terminated Fiber Optic Facility Links.
  •           
  • Installed and Programmed Vodavi ® Telephone Distribution Frame.
  •           
  • Installed Lightning Arrester systems.
  •             
               Production Supervisor, Production Control Scheduler, Quality Control Metallurgical Technician - Penncast Corporation, Marietta PA (June '94 - August '98)
              
  • Production Scheduler
  •           
  • 'Core Department' Supervisor.
  •           
  • Melting, Molding, and Pouring Operations Supervisor in a Teamsters Union Steel Foundry.
  •           
  • Supervised and Trained 30 employees, enforcing Quality and Safety rules in working environment and personal behavior.
  •           
  • Scheduled and Supervised overtime Grinding and Finishing Operations.
  •           
  • Recorded Production against Master Schedule.
  •           
  • Designed MS Excel VBA Programming to automate Scheduling Functions, Inventory/Reorder systems.
  •           
  • Was responsible for calculating Induction Melting Furnace additions to conform 100 varieties of Stainless, Carbon, Manganese Steels and Nickel/Monel alloys to ASTM Specifications.
  •           
  • Operated, calibrated, and maintained Optical Emission Spectrometer in Metallurgy Lab for Chemical Analysis.
  •           
  • Maintained, and programmed Lab Computer - importing Spectrometer results and calculating Furnace alloy additions in "MS QuickBasic".
  •           
  • Created Procedures and quality-related policies for employees to ISO 9000 qualifications.
  •           
  • Performed Mechanical and Chemical Testing, Microscopic Imaging and Certification.
  •             
               Journeyman Iron Molder / Journeyman Iron Melter - Lancaster Malleable Castings Co., Lancaster PA (April '84 - June '94)
              
  • Journeyman Iron Molder (Jolt/Squeeze Floor)
  • Journeyman Iron Melter (90 Ton Coal Air Furnace)
  • Air Furnace Repair Technician
  • Shell Core Maker.
  • Pattern Maintenance Assistant
  •            LMCC Iron Molder
                
               EDUCATION
              
    Rosemont College, Rosemont, PA             B. S. Business Administration, Summa Cum Laude
    Lancaster County Career & Technology Center             Certificate in Computer Hardware
    Applied Learning Institute             Certificate in Industrial Metallurgy
                
               ADDITIONAL SKILLS
               In addition to the skills and software systems described above, I have intermediate to advanced knowledge in the following applications:
              
          Microsoft Windows Vista, Server 2003, Server 2000, XP, ME, 2000, 3.1        
          Microsoft SharePoint 2007 MOSS, WSS        
          Microsoft Project 2007        
          Microsoft Word 2007, 2002, 2000, 97        
          Microsoft PowerPoint 2007, 2002        
          Microsoft Publisher 2007, 2002        
          Microsoft Outlook 2007, 2002, 2000        
          Microsoft Visual Studio 2008, 6        
          SAP Crystal Reports        
          Adobe Dreamweaver CS3        
          Adobe Photoshop 7, CS3        
          Rimage Disk Duplication System 8        
          Eclipse Disk Replication System 5        
          HexaLock Disc Encryption System 4.7        
          FTP        
                   
                   
                    Tim McElroy
                    Zelia Zigler McElroy VonTress
    SqlServerExecutionPlans.pdf
    Mastering-PowerShell.pdf