|
|
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
|
|
|
|
Engineer - RCA Engineering - Cotiviti Healthcare, Conshohocken, PA (Oct '12 - Present)
|
|
Support Recovery Auditing efforts through Access and SQL Server development, Powershell scripting, and Excel VBA 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
|
|
|
|
|
|
  |
|
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
|
|
|
|
SqlServerExecutionPlans.pdf
|
|
|
|
Mastering-PowerShell.pdf
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|