SUMMARY:

• 10 years Administration of Linux, XP & NT machines, during which I have done Tuning, Updates. Patching, Backups, Recoveries & System Configuration in hardware and software.
• Setup and maintained samba Networks. Installed and configured Windows and Linux operating systems.
• Upgraded HD, CPU and memory components. Setup & configured a LAMP server w/ Xamp (Apache MySQL PHP) Continuous project to designed & developed code to move paper documents to multi page PDF documents.
• Process will autocratically orient and enhance contrast for OCR processing using Leptonica, Tesseract API and Haru library to developing routines to make Searchable PDFs.
• Used ImageMagic & Magic++ API to develop routines to auto crop and resize check images for electronic submission.
• Usage of PDFTK to split PDF multi page files to image and to collect processed images back to 1 multi page PDF; Usage of PDF to manage TAX documents, transmission as encrypted PDF OCR to PDF archive of my wife’s favorite cook book Developed application to schedule doctor’s appointment.
• Application maintains DB of all tables need to provide scheduling services.
• Application uses VB, MYSQL, SSL connections and anti - injection routines to protect the DB.

WORK EXPERIENCE:

Confidential, NJ

Responsibilities:

• Collected data files and extracted data for lookup table
• Used LOOKUP tables to find and load records
• Used Filters to select active records
• Used Access to compare tables and find updated records
• Used MATCH to set up filter column to extract needed records
• Wrote VBA routines for data formatting and cleaning
• Used Avaya Verint to create data employee listing report

Confidential, Plainsboro, NJ

DBA EXCEL\ACESS\VBA\SQL ETL Programmer

Responsibilities:

• Maintained sales transaction DB
• Managed Loading of monthly data feeds for 56 distributors
• Reconciled data in sales tracking ACCESS DB with 2nd transaction management DB
• Resolved errors in data processing, recoded solution in VBA and resubmitting to complete load
• Added new code(VBA), queries and tables for new distributor feeds
• Worked with joins and embedded queries to extract and collect data
• Provide temporary DB to extract transaction for commission payment
• Reworked code to clean up incoming EXCEL table feeds
• Used VLOOKUP to MATCH data for validation and processing
• Used VBA EXCEL to search, evaluate and manipulate data
• Produced PDF reports of rebate summations
• Resolved PDF printing errors

Confidential

QA testing

Responsibilities:

• Testing on EPIC patient management software for client login and correct report generation
• Ensured reports sent to correct printer

Confidential, New Brunswick, NJ

Marketing support

Responsibilities:

• Collected product description and pricing info
• Presented and photographed product
• Listed product on Confidential ’s List, and Confidential
• Designed utility to created product catalog via VBA and EXCEL
• Set up workstation
• Collected and installed supporting application GIMP

Confidential, Freehold, NJ

Responsibilities:

• Document preparation for scanning
• Scanned 18000+ documents per 8hr shift
• Using Kodak Ngenuity scanners
• Used EXCEL to maintain ops log for project

Confidential, Township, NJ

Break down set up PC move technician

Responsibilities:

• Installation of docking station and supporting peripherals
• Direct customer support to resolve issues after installation
• Inventory management using EXCEL to document S/N

Confidential, St. Hightstown, NJ

Customer phone support

Responsibilities:

• Customer phone support scheduling patient appointments collecting entering updating patient demographic data identifying and scheduling patient with the correct doctor to meet patients’ needs
• EHR data maintenance
• HIPPA regulation
• EXCEL data lookup of data for scheduling

Confidential, East Windsor, NJ

Sales Associate/Cashier

Responsibilities:

• Maintained display order and appearance.
• Assisted customers with product information and check out procedures.

Confidential, New Brunswick, NJ

Responsibilities:

• Developed and maintained the product sales database ACCESS
• Loaded 150+ product images & descriptions to sales database..
• Developed method to create mailing lists form contact ACCESS DB to outlook
• Developed VBA report to create product catalog.
• Setup MYSQL server and connection string to Access DB.
• Developed EXCEL temples to manage sales transactions

Confidential, Bristol, PA

People Soft 7.5 & 8.0 Excel & Access 2007 EDI Analyst

Responsibilities:

• Monitored daily the error logs for files that could not be loaded into People.
• Affected corrections to allow above file to load correctly.
• Reduced error rate from average of 5 to 1 per day with clear & concise reporting of methods.
• Preformed loading test to make sure 855, 865 & 810 raw EDI files would be translated and loaded correctly into PeopleSoft.
• Documented daily monitor process, load testing for 855,856 & 810 processes.
• Developed utility in (ACCESS VBA) to filter outbound 855 files for records that must not be over written.
• Used GENTRAN to search for and extract raw EDI files for confirmation of material sent.
• Researched regular expressions in VBA to find Purchase order data in outbound and inbound EDI repositories.
• Developed testing documentation to facilitate on boarding of new EDI feeds

Confidential, Princeton, NJ

DBA Access 2007

Responsibilities:

• Redesigned ACCESS DB to collect and publish compensation data for Confidential employees.
• Used WORD & EXCEL 2007 to facilitate data collection and validation.
• Used PEOPLESOFT to co - validate payroll information.

Confidential, Lansdale, PA

Access\Excel\Oracle & Access SQL Business Analyst

Responsibilities:

• Analyzed VBA & SQL routines in EXCEL & ACCESS.
• Provided verbal and written explanations of business utilities and procedures.
• Provided functional evaluations and suggestions to improve processing.
• Identified potential problems in code and methods.

Confidential, St. Hightstown, NJ

EXCEL\Access\VBA\SQL ETL Programmer

Responsibilities:

• Developed product sales forecasting ACCESS database to collect data and present forecasting models bases on extracted data stored in 9 separate EXCEL spreadsheets.
• Utility uses embedded EXCEL routines to graph trend data
• The Process had to validate, correct and load data to internal ACCESS DB for processing.
• Designed a flexible interface to allow user easy configuration of model parameters.
• Utility was designed with understanding of clients need to make changes in the code to accommodate additional graph requests.
• Provided documentation and training for utility.

Confidential, Princeton, NJ

Access\Excel\Outlook\VBA\SQL Programmer

Responsibilities:

• Reworked ACCESS Forms, Queries & Reports for an Employee activities & time tracking application.
• Developed labor tracking ACCESS database to monitor production output of manufacturing floor.
• Developed special SQL queries to enhance data collection from EXCEL sheets.
• Worked in FDA approved requirements for documenting exception reports and software development documentation.
• Worked with SQL SERVER back-end to facilitate testing and rework of TEAM database.
• Used Vlookup to find and validate date in QA process.
• Developed ACCESS DB to track marketing loses (analysis of sales transaction that were lost due to various conditions in the market).This DB facilitated the collection of data and used EXCEL pivot reports to provide clear description of marketing data for 72 sales regions.

Confidential, West Trenton, NJ

Excel/VBA Developer

Responsibilities:

• Developed EXCEL macros to manage processing of state compliance reporting.
• These macros facilitated the collection of data, the setting up of reports and redefining of data values to be charted.
• Developed DOS bat routine to rename PDF files to match column heading within compliance reports to facilitate data entry.
• Used EXCEL to create script by editing columns of cells, creating a 200+ line script in less than 10 minutes.
• Evaluated software for new project to parse large data source.
• Trained new office assistant on usage of data processing system.