Peter Mayers
5747 Glendale Dr.
Lockport, NY 14094
[Send email to request phone number] 83-0051, [Send email to request phone number] 33-7820
[Send email using form at bottom]
Education BS Computer Science (Programming/Applications)
State University of New York, Buffalo, New York, 1992
Technical Software
Skills All Windows OS / Server SUN Workstations / UNIX SUN OS / Solaris
SUN Workstatio Macintosh OS Telecommunication - Avaya Cisco Router / Bridge
CoCo Corel Off GMC PRINTNET SQL/SQL Server 2000, 2003 Postalsoft
FirstLogic
Visual FoxPro 6/7/8 MS Office Professional BCC MailManager2010
Visual Studio HTML / CSS JAVA/ JAVA Scripts
Visual C / C++ MS Access COBOL
Visual Basic Oracle Brio Query/Reporting
PHP Crystal Reports MySQL
Adobe InDesign Quark/ Quark Express Adobe Photoshop
Adobe Dreamweaver Microsoft Publisher Paint Shop Pro
Experience Continental (Motorola), Elma, New York
Software Engineer/Application Specialist, Oct. 2007-Present
Working with an Oracle9 database on a UNIX system. Using Brio for running
queries and doing reporting. Using EXCEED to access the UNIX system and for
running scripts. Working with the JASPER system. Handling the help desk
support.
Empire Liquidators, Buffalo, New York
Software Engineer/Application Specialist, PC Technician, July 2007-Oct. 2007
Design programs in MySQL, PHP, and CSS. MySQL is on a Linux server. Write
programs for E-commerce system using MySQL and PHP4. Coded, tested, and debugged
SQL scripts and stored procedures. Developed and optimized database structures,
stored procedures, views, triggers and user-defined functions. Troubleshoot
system issues, monitored scheduled jobs and set up maintenance plans for
proactively monitoring the performance of SQL Server databases. Data warehouse
analysis, design, construction, and deployment for diverse legacy systems
integration Responsible for business analysis, data analysis, business process
optimization, new systems designs, integration and project management for all
current mission critical applications. Modeling of Business Processes, Data Flow
architecture, Data Modeling, Data Definition, Database Schema, Data Integration,
XML Data Migration, Web Services and User interface design and development. PC
Technician. Tester. Telecommunication - Avaya. Phone System Installation.
Customer/Tech Support. Application Training
Niagara Concepts, Lockport, New York
Computer Consultant, Software Engineer/Application Specialist, Dec.
2005-Present
Telecommute with clients. Design programs in MS SQL, MySQL, Oracle, and FoxPro
for customers.
Implemented process and/or manage transfers of data between external data
structures (e.g. flat files, Excel files) and existing databases. Coded, tested,
and debugged SQL scripts and stored procedures. Converted page embedded SQL
queries to secure and optimized Stored Procedure. Successfully maintain peak
performance of all primary databases by providing advanced tuning methods,
customized scripts. Data warehouse analysis, design, construction, and deployment
for diverse legacy systems integration Decision support systems analysis, design
and construction Conceptual data modeling; logical and physical data modeling.
Lead Database Developer/Programmer 4 times directing 4-member team accountable
for data modeling. Responsibilities included defining data schema, data
migration, transformations, and quality control. SQL Reporting. Working with
GMC Printnet and BCC MailManager for direct mail companies. Manipulating
graphics in Adobe Photoshop and other graphic software. Sales. Customer/Tech
Support. Application Training. Data Entry
NCS, Sterling, Virginia
Software Engineer/Application Specialist, Sept. 2004-July 2007
Working with flat text files and databases using GMC Printnet for document
setup. Designed programs in SQL and FoxPro to use customer data files for
generating mass mailings. Maintained QC by creating reports and running queries
using SQL. Decision support systems analysis, design and construction Conceptual
data modeling; logical and physical data modeling. Implemented process and/or
manage transfers of data between external data structures (e.g. flat files, Excel
files) and existing databases. Coded, tested, and debugged SQL scripts. Lead
Database Developer/Programmer 4 times directing 4-member team accountable for
data modeling. Responsibilities included defining data schema, data migration,
transformations, and quality control. SQL Reporting. They have both SIEMENS
Continuous and XEROX printers. Working with GMC Printnet, BCC MailManager and
GROUP1. The XEROX printers are DT110, DT115, DT155. Manipulating graphics in
Adobe Photoshop and other graphic packages. Customer Support. Data Entry
Polaris Direct, Hooksett, New Hampshire
Sr. Database Programmer/ Sr. DP Specialist, Nov. 2003-Aug. 2004
Designed programs in SQL and FoxPro to use customer data files for generating
mass mailings. Maintained QC by creating reports and running queries using SQL.
I created reports using Crystal Reports. Ran queries in Access and SQL for
reports and data manipulation. Worked with GMC Printnet, BCC MailManager 2010
(CASS, Merge/Purge, Presort). Worked with databases containing over 10 million
records. Lead Database Developer/Programmer 6 times directing 3-member team
accountable for data modeling for Data Warehouse (DW) and programming.
Responsibilities included defining data schema, data migration, transformations,
quality and User Acceptance Testing (UAT). Data analyst and Systems Administrator
for the database conversion project. Responsibilities included managing projects
and teams in the implementation, conversion, migration, integration, and
enhancement. SQL Server Installation. Performed daily tasks including backup
and restore by using SQL Server 2000 and SQL Server 2003. Developed and optimized
database structures, stored procedures, views, triggers and user-defined
functions. Troubleshoot system issues, monitored scheduled jobs and set up
maintenance plans for proactively monitoring the performance of SQL Server
databases. SQL Reporting. Implemented process and/or manage transfers of data
between external data structures (e.g. flat files, Excel files) and existing
databases. Coded, tested, and debugged SQL scripts. Data warehouse analysis,
design, construction, and deployment for diverse legacy systems integration.
Decision support systems analysis, design and construction Conceptual data
modeling; logical and physical data modeling. Printers used were NIPSONS
Continuous Roll Paper. Manipulating graphics in Adobe Photoshop on the PC and
MAC. Worked on graphics in Quark for the MAC. Other graphic software packages.
Customer Support.
Achievements
Helped to setup Data Processing Department for new company
Designed programs to automated parts of the work flow for the department
Worked with data involving security issues surrounding banks.
NTS/Compu-Mail, Niagara Falls, New York
Software Engineer/ Programmer, Jan. 1998-Mar. 2003
Designed programs in COBOL and FoxPro to use customer data files for generating
mass mailings. Maintained QC by creating reports and running queries using SQL.
Decision support systems analysis, design and construction Conceptual data
modeling; logical and physical data modeling. Implemented process and/or manage
transfers of data between external data structures (e.g. flat files, Excel files)
and existing databases. Coded, tested, and debugged SQL scripts and stored
procedures. Converted page embedded SQL queries to secure and optimized Stored
Procedure. Worked with GMC Printnet, Postalsoft Firstlogic (ACE, Merge/Purge,
Presort), Peoplesmith (Personator, Stylist). Worked with large databases
containing millions of records. They had both SIEMENS and XEROX printers.
Customer Support. FTP
Achievements
Designed a counting program for quality control of the data called COUNTS in
FoxPro that is used by the company on a daily basis.
Helped design a process used for clustering records, especially in bank
information.
Set up applications that run automated operations.
Buffalo General Hospital, Buffalo, New York
System, Network, and Software Administrator, Sept. 1997-Jan. 1998
Maintained a Novell 4.11 server at two hospital sites, and a FoxPro database on
one Novell Server.
Achievements
Took the Novell server from each site and combined them into 1 master Novell
server.
Waste Stream Technology, Buffalo, New York
Computer Consultant, Apr. 1995-Oct. 1997
Designed a database using FoxPro to store all of their experimental data and
created the ability for their company to produce multiple reports using various
templates. Developed programs to collect, transform and manipulate data
displayed by a number of instruments used to assay environmental samples so that
the data could be read into FoxPro. Upgraded the software and redesigned the
program when they changed servers.
Roswell Park Cancer Institute, Buffalo, New York
System and Network Administrator, Computer Programmer, Sept. 1992-Mar. 1997
As the single IT resource person in a department of 75, I maintained a SUN
workstation server that was the principle pipeline for all computers and file
handling including 2 SUN workstations using NFS and all department PCs and
Macintoshes. I also maintained a Windows NT server, which provided additional
file and print sharing. I was responsible for designing graphics and slide
presentations for submission of grants, lectures, papers and publications using
graphics programs for both the Macintosh and PC. I adapted commercial software
with utility programs in C to facilitate transfer of data. I created and
designed almost 100 web pages that included information on personnel, tables,
graphical data, and links to other software applications for displaying data,
much of it connected to a genetic database for the Human Genome Project (see
publication). The database reads a flat file and allows the user of any of three
platforms, MAC, PC, SUN, to search for a genetic sequence and see the location of
the contig as displayed in a graphical image using postscript format.
Achievements
Maintained the SUN server, NFS server, E-mail server.
Created and maintained the WWW Page/Server for the Department of Human
Genetics.
Provided a graphical database for Chromosome 11 that I was able to
continuously up-grade with new or modified gene sequences and their position on a
gene map.
Set up a network at a remote site in Canada for a Chromosome 11 workshop that
was available to all scientists attending the weeklong meeting.
Publication Qin, S., Nowak, N.J., Zhang, J., Sait, S.N., Mayers, P.G., Higgins,
M.J., Cheng, Y., Li, L.,
Munroe, D., Gerhard, D.S., Weber, B.H., Bric, E., Housman, D.E., Evans, G.A.,
and Shows,
T.B. Complete Assembly of A Chromosme 11 YAC Library. Proceedings of the
National Academy of Sciences 93:3149-3154 (1996).
|
