Michael Shakaid
Guilford, CT 06473
Cell: 925-***-****
Email: ********@*****.***
Technical Expertise
Relational Databases (developer tools):
FileMaker Pro 2.0,3.0,4.0,4.1, 5.0, 5.5, 6.0, 7.0, 8.0, 8.5 9,1 FileMaker
Pro Servers 3.0,4.1,5.0, 5.5(b) 6.0, 7.0, 7.0, 8.0, 9.0 .10.0 Advances 7.0,
8.0, 8.0 9.0, 10.0, 11,12 Advances (Win/Mac) New FileMaker Mobile..
[pic]
Additional Development tools:
Php, Lasso, Dreaweaver MX,MS SQL 2000, MySQL, MS Access 95/97/2000
Win batch 3.3
Operating Systems:
MS DOS 6.22,Windows (3.1, 3.11), 95, NT Workstation 4.0, NT (3.51, 4.0),
Window ME, Window XP, Windows 7 Win2000 Client/Server,Mac OS 8.0 10x, OS
10.6, OS10.7
Applications:
MS 2000, Office 97, Office 95, Office 2000, Office XP, Office 2010, Office
2011
Professional Experience
I am a professional with 24 years experience in custom application
development projects, management and team leadership. I have a proven track
record in providing innovative solutions in multiple application areas,
relational Database experience on various platforms, flexible, fast
learner, thrives on change. Focus is on customer service. Excellent
communication and inter personal skills. Strong analytical and problem-
solving skills. Experience in successfully managing multiple projects
concurrently. Meeting deadlines and delivering high quality results. I am
known for jumping into difficult situations and making them work.
Work History
AccuStandard Inc,
New Haven, CT 06513 4/15/2008 to 8/31/2012
FileMaker Pro Application Development/Manager
. Re-designed a system in production with 430 individual DB's from
legacy solutions.
. The system was redesign in FM 6.0 to correct corrupted data duplicated
data bases and restructures script and layouts to provide current and
correct data to user community
. Was able to consolidated the numbers of database from 430 to 145
. Automated data exchanged and print function, correct the inventory
database to calculate the correct and current inventory on of the most
critical database in the system with direct implication on Production,
QC, Accounting and Sales departments.
. The system tracks customers, sales, tax, charges, refunds; cancels
requests and updates automatically customer status, using elaborated
conditions and scripting.
Casablanca Express
Las Vegas, NV 89113 9/1/2007 to 3/15/2008
FileMaker Pro Database System Analyst/Developer
. Re-designed a relational telemarketing database system using FileMaker
Pro 6.0 and start 8.5 Casablanca Express.
. Automated data import for a 4th dimension database for remote LA
office.
. The system tracks customers, sales, tax, charges, refunds; cancels
requests and updates automatically customer status, using elaborated
conditions and scripting.
. The solution is tracking hotel appointments and room bookings.
. Designed and integrated custom plug-in to process credit cards and
refunds, with a direct interface to FileMaker solution using API
protocol
. The Plug-in charging module automatically calculates the amount needed
to be charged, submitting the charges request via API getaway to the
processor and records that transaction with "Auth Code", response
message, transaction _id etc.
. Designed and integrated custom plug-in to generate PDF doc's directly
from customer records in FileMaker solution
. Designed and integrated custom plug-in for mass marketing mail
directly from customer records in FileMaker solution.
. Integrated automated custom E-mail response based on the action taken
by TM or CSR rep of Casablanca Express
. Developed a Database Flowchart to describe and analyze the
functionality of the system.
. Developed a NT level login security system utilizing FileMaker Pro.
. Provided training and support for the system.
. Currently developing a user hand book
. system automatically responds to the client with an appropriate email
using a pre-defined email massage related to the action to be
processed by the BNL Rep.
. The system has an integrated charging module which automatically
calculates the amount in need to be charged, submitting the charges
requests via API getaway to the processor and records that transaction
with Auth Code, response message, transaction _id etc.
. The system uploads live transitions from the web using a SQL interface
directly to MySQL database server.
. The system can upload/update current inventory directly into My SQL
database inventory based on BNL requirements
. Developed a Database Flowchart to describe and analyze the
functionality of the database in conjunction with process flowchart.
PPDBS
(Boulder Nature Lab, Longmont, CO) 4/21/2006 to 8/30/2007
FileMaker Pro Database System Analyst/Developer
. Designed a relational E-Commerce system database system using
FileMaker Pro 6.0 and 8.5 for Boulder Nature Lab.
. The System tracks WEB order and ongoing charges for the future.
. The System tracks cost, sales tax, RMA requests, cancels requests, re-
ship requests, through an elaborated conditions and scripting.
. The System will allow issuing credit and refunds based on customer and
BNL rep request.
. The system tracks the status of each customer and recalculates the
next charged date and the product in need to be shipped based on the
number of orders the client completed
. The system automatically responds to the client with an appropriate
email using a pre-defined email massage related to the action to be
processed by the BNL rep.
. The system has an integrated charging module which automatically
calculates the amount in need to be charged, submitting the charges
request via API getaway to the processor, records that transaction
with Auth Code, and response massage, transaction _id etc...
. The system uploads live transitions from the web using a SQL interface
directly to MySQL database server.
. The system can upload/update current inventory directly into My SQL
database inventory based on BNL requirements
. Developed a Database Flowchart to describe and analyze the
functionality of the database in conjunction with process flowchart.
siRNA Therapeutics, Inc Boulder, CO 8/15/2005 to 3/15/2006
FileMaker Pro Database System Analyst/Developer
. Designed a relational siOrder database system using FileMaker Pro for
siRNA and their biotechnology to develop and order systems that will
allow a developing therapeutics based on RNA interference (RNAi)
technology, a promising field of biology and medicine, using its
proprietary nucleic acid technology and expertise to develop a new
class of RNAi-based therapeutics that targets human diseases and
conditions.
. Developed a NT level login security system utilizing FileMaker Pro.
. Developed required reports as well as the data required to produce
these reports.
. Responsible for maintenance of siOrder Pro developed in FileMaker Pro.
. Developed a process flowchart to describe and analyze the actual
production flow of data and the flow of processes in conjunction with
siRNA requirements.
. Developed a Database Flowchart to describe and analyze the
functionality of the database in conjunction with process flowchart.
Lockheed Martin (NASA)
AMES Research Center
Lockheed Martin Space Operations 6/1/03 to
8/1/2005
FileMaker Pro Database System Analyst/Developer
Developed Windows/Mac FileMaker Pro databases to Interface with: 4D
Database, People Soft application and DB2 Main Frame database.
. Worked with Lockheed Martin Space Operation to improve and
. expand the existing E*STAR Pro program.
. Designed the relational E*STAR Pro database system currently in use by
the Lockheed Martin Space Operation.
. Developed a NT level login security system utilizing FileMaker Pro to
comply with NASA security needs.
. Developed required reports as well as the data required to produce
these reports.
. Responsible for maintenance of E*STAR Pro developed in FileMaker Pro.
. Required to add new modules to the system to comply with
Lockheed financial needs for cost and time analysis.
. Developed a process flowchart to describe and analyze the actual
production flow of data and the flow of process in conjunction with
Lockheed Martin/NASA.
. Developed a Database Flowchart to describe and analyze the
functionality of the database in conjunction with process flowchart.
State of California
Department of Park and Recreation
Acquisition and Development Division 8/1/01 to 5/30/03
Database System Analyst/Developer
Developed Windows/Citrix based FileMaker Pro databases to Interface with
Access/MS SQL and DB2 Main Frame database.
. Worked with concession specialists to better understand the needs of
the concessions program.
. Designed the relational concessions database system currently in use
by the State of California Parks and Recreation.
. Developed required reports as well as the data required to produce
these reports.
. Implemented an electronic time sheet system for State of California
Parks and Recreation
. Responsible for maintenance of Parks project tracking system developed
in FileMaker Pro
. Required to add new modules to the system when new departments are
implemented in the Parks program
. Development required reports as well as the data required to
produce those reports.
Additional Work History:
Conference Planner 3/1/01 to
7/1/01
Database Consultant/Design
Careguide Global, Inc. 11/15/99 to
5/1/00 Database System Manager
Genentech, Inc. 7/1/99 to
11/15/99
Database Consultant/Design
Modis/Kaiser Permanente 5/1/97 to
6/30/99
Database Consultant/Design
Compucom/Cisco Systems 10/1/96 to
5/1/97
Project Lead
EnPointe Technologies 6/1995
to 10/1/96
Service Manager
EACS
(Engineering and Architectural CAD solutions), Principal 6/1990
to 5/1995
Education
University of Hayward California 1986 to 1989
BS in Computer Science/ Electrical
College of Alameda, Completed under graduate, upper division
courses
1984 to 1985
Tel Aviv University,
Computer Science/ Electrical Engineering 1983 to 1984
Army Technical University, Air Force Israel, graduated, specialized
in electronic computer warfare equipment 1979 to
1982
Holding a top security clearance form 3 /2007
LANGUAGES: Fluent in English and Hebrew, some Arabic