Access Database Developer Resume
,
Objective
Database application development or web application development position.
o Access database development.
o Ten years database development experience
o Experience developing Excel applications and programming in VBA
o Experience data modeling, creating logic diagrams, charting business processes.
o Experience analyzing data and structure
o Report writing experience in Excel and Access
o Experience in all phases of software development cycle: gathering requirements, writing specifications, implementing, reviewing specifications, testing, production, deployment
o Experience writing T-SQL queries
o VBA programming experience
Work History
Court of Appeal, State of California, First Appellate District, Access Developer.
/-present.
Developed Mediation Program Access database. Developed reports based on SQL queries for Judge McGinnis,Presiding Judge. Superior Court. Tested during production, implemented database.
The Gap Inc, Old Navy Division, Marketing, www.oldnavy.com, Excel and Access Programmer, /-/.
Developed Excel application in VBA and modified Access database and SQL queries to automate business process. Store signs created in Indesign. Automating print jobs costing in excess of $K weekly. The Access database is called the Promo Tool, upgraded to Access . The Promo Tool database accesses the Lookbook Excel database a listing of products.
E.J. Gallo Winery, www.ejgallo.com, Modesto, /
Web Developer and Database Developer.
Upgrade of creative services task, time and project management system. desktop users and on-line users. Update PHP web pages from version to Version involving updating PHP error class. Configured Windows Virtual server.
Main, Inc. www.Main.com, San Francisco, /-//
Database Developer and Web Developer.
Develop database for data center, including sales and accounting modules. Developed Excel accounting reports to meet GAAP standards for Ernest and Young audit. Attended meeting with auditors including Partner level auditors. Straight Line Rent Detail and Summary Report, Security Deposit Summary, Average Term Report, Renewal Report, Commission Report, Commission Amortization Report, Estoppel Report, Rent Roll Summary, Rent Roll Detail. Developed invoice module and accounting module to act as a backup to enterprise accounting system.
Probitas Partners, www.probitaspartners.com, San Francisco, /-/
Database Developer.
Design networked, multi-user contact manager for financial services marketing company that tracks private equity funds raised for fund sponsors. Database compares investors interest in funds, past history of investment, funds raised by other placement agencies. Developed reporting tool displaying weekly investor contacts in Excel using XML output. Microsoft Access database converted to Filemaker database.
Gay and Lesbian Medical Association, www.glma.org, San Francisco,/-/, Web Developer and Database Developer.
Maintain web site medical referral database and membership directory, add merchant account to shopping cart, redirect donors to second account, Javascript programming to verify current membership for user login, PHP programming to send credit card authorization data to Filemaker database.
Probus Research, www.birthcertificate.com, San Francisco, /-/
Web Developer and Database Developer.
Programming in Javascript to verify required fields, add features to web forms, reformatting tables using cascading style sheets, on-line orders database.
Genentech, Corporate Information and Technology, South San Francisco, /, Database Developer.
Restore referential integrity to Physical Services Filemaker database to, cleaned records added match keys, import records into Oracle database.
Kosan Biosciences, Inc., www.kosan.com, Hayward, /,
Database Developer.
Repair referential integrity of plasmid clone research database. Restructure architecture and preserve data integrity of plasmid cloning database. Data migration from D database to FM Pro.
Providian Bancorp, Marketing Services Group, San Francisco, /-/,
Database Developer.
Designed a relational database system from user requirements with all necessary accounting, tracking and vendor reports. System tracks the ordering of marketing printed materials, from the stage of making quotes, to ordering from print vendors and repackaging and mailing to selected populations by lettershops. System also balances purchase orders with invoices. Developed following Excel reports for Vice-President: Final Job Cost Analysis, Jobs greater than $,,.
Wells Fargo, Private Client Services, San Francisco, /-/,
Database Developer.
Added module to integrate invoicing and project tracking databases; database tracks costs for marketing materials, design costs; enhanced database to track all department costs; automated Excel reports to compare General Ledger with invoices, networked Filemaker database to department management excel spreadsheets via ODBC.
MAAS Intek, San Francisco, /-/, Excel Developer.
Wrote VBA program and Excel form application to enter data into an accounting and inventory enterprise database.
Education
B.A., Life Pacific College, San Dimas, - City College of San Francisco units of undergraduate credit with emphasis on Information Systems, Database Management Systems, Java, Networking, and Calculus.
