Voice: 415.412.4748
Email address: jagracia@jgracia.com
WWW: http://www.jgracia.com
 | MBA in International Business and Finance. Technology leader with expertise in Biotechnology, Retail, Real Estate, Health Care, Exporting, and Consulting. |
| Hands on Database Administrator and management professional with over fourteen years of successful I.T. development and high-performance team oversight. |
| Unique combination of advanced technology and business skills with a consistent record of reaching tactical objectives while providing strategic vision. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Business Intelligence |
Bio- Cheminformatics |
ER/Studio, dbArtisan |
MannKind
Corporation Biopharmaceutical company focused on the discovery,
development and commercialization
of therapeutic products for diseases such as
diabetes and cancer
28903 North Paine Avenue, Valencia, CA 2003 - Present
Manager, R&D Informatics and Database Services. Responsible for all Oracle databases and systems applications, design, integration, enhancements, tuning, maintenance, and planning
|
Responsible for needs assessment and assembly of the Informatics Group’s annual budget. |
|
Developed I.T. strategic plan for both Informatics and other R&D departments. |
|
Responsible for database, web, and scientific systems procurement and relationships with vendors. |
|
Managed support lifecycle for database and web development. |
| Developed Executive Dashboard and Scorecard |
| Implemented Bio and Cheminformatics Systems |
|
Redesigned and implemented enterprise-wide database services in a Solaris/Windows environment. |
|
Designed, deployed, and managed R&D Intranet Portal. |
|
Designed and implemented Data Warehouse for R&D departments. |
| Designed, built, and deployed several web-deployed database applications to the intranet |
Deltagen,
Inc. Provider of drug discovery tools and services to
the biopharmaceutical industry
740 Bay Road, Redwood City, CA 1999 - 2003
Director of Database Systems. Responsible for building new databases and systems applications, enhancing, servicing, tuning, and maintaining both internal and client database systems. Manage daily activities of three to six database administrators and developers.
| Built database services from one Oracle instance to twenty throughout four locations in the United States and Europe. |
| Built Deltagen into a 24x7 shop by eliminating system downtime, creating redundant systems, and increasing overall availability and performance. |
| Reduced expenses by $250K annually by implementing programs and procedures to automate database monitoring and security. |
| Developed and implemented backup and recovery strategies for all databases using batch scripts, tape backup, and Storage Area Network technology |
| Managed product development for Deltagen’s database product, DeltaBase, from design and implementation through client deployment and maintenance. |
| Automated network and database integration using Oracle, JAVA, LDAP, and Active Directory |
| Designed several database applications including a data warehouse using Oracle Designer, ER/Studio, and custom ETL tools. |
| Administered integration of legacy systems with Oracle databases and data warehouses. |
| Responsible for assembling the Information Technology Group’s annual budgets. |
969-G Edgewater Blvd #785 Foster City, CA 1996 - 1999
Clients: Deltagen, Inc., City and County of San Francisco, Sierra Cybernetics, Canon Research of America, Guittard Chocolate Company
Independent Consultant. Performed systems and database administration, database and application programming, and extensive stored procedure, package, and trigger development. Representative projects include:
| Developed Microsoft SQL Server and Visual Basic applications to display scanned images for image-document database for Canon Research. |
| Database Administrator and Technical Coordinator supervising five application developers and systems analysts in development of mission-critical Building Permit Tracking System for the City and County of San Francisco and Sierra Cybernetics. |
| Requirements Analysis and database design for Deltagen, Inc. |
10 Guittard Road, Burlingame, CA 1996 - 1997
Database Administrator in Windows and Oracle-HP-Unix environment.
| System Administrator for Oracle Financials and Manufacturing Applications. |
| Unix/Windows Database Administration, Client/Server Systems design and programming. |
| Managed company-wide upgrade of user workstations to next release of Windows. |
| Coordinated rollout of Oracle Financials server and client upgrade to version 10.7. |
| Data mapping from production databases to data warehouse and EDI documents. |
| Strategic planning, budgeting and staffing. |
City & County of San Francisco
1660 Mission Street, San Francisco, CA
Department: Department of Building Inspection
1994 - 1996
Senior Project Leader and Database Administrator. Directed development and implementation of several Oracle-based systems impacting Department services and revenues.
| Managed implementation of imaging, workflow, and city-wide GIS projects. |
| Designed and programmed Client/Server systems using Oracle Designer, Oracle Forms, Oracle Reports, PLSQL, and Delphi. |
| Prototyped Intranet and other web-based technologies. |
| Worked closely with IT Director to develop budgets and hire new staff |
Ciber, Inc. Advanced Technology Services
2020 N. Central Ave Phoenix, Arizona 1992 - 1994
Application Developer. Programmed applications for CIGNA Healthcare of Arizona. Developed and implemented key Provider Information Database application using an object-oriented approach.
| Managed project from initial conceptualization and system specification through programming, configuration planning, installation, and end-user/technical training. |
| Designed and programmed a multi-user, quality management system to track provider performance and appraisals. |
| Developed provider referral pricing model and physician group reporting system. |
| Performed ad hoc hospital utilization and medical financial analysis. |
Gemini Development Group
San Francisco, California and Phoenix, Arizona 1987 - 1994
Independent Consultant providing management consulting and programming services.
| Created real estate investment, financial and economic forecasting models |
| Developed multi-user Resolution Trust Corp reporting and asset management system |
| Designed and implemented litigation support database |
| Translated technical documents from Spanish to English |
The Quaestus Group International Computer Systems integration and
Consulting
San Francisco, California 1985 - 1988
Vice President of $3 million international computer systems integration & consulting organization.
| Responsible for finance, accounting, strategic planning, new business development, purchasing, and human resources. |
| Conceived and implemented international marketing strategy. |
| Established 13-country distribution network serving Europe & Latin America. |
| Developed business plans for company's international & domestic business and recapitalized through equity financing. |
Andersen Consulting International Management and Information
Systems Consulting
One Market St., Spear Street Tower San Francisco, California 1984 -1985
| Designed, programmed & tested a cost accounting system for a San Francisco community hospital. |
| Conducted several studies of general ledger systems for financial institutions. |
| Evaluated & tested international money market tracking system for a California bank. |
| Formulated & implemented financial & economic models for hospitals and other non-profits. |
Sedgwick,
Detert, Moran & Arnold
One Embarcadero Center San Francisco, California 1980 - 1982
| Legal Assistant and field investigator for this large law firm specializing in insurance defense litigation. |
| Prepared detailed reports and summaries on complex scientific and financial issues. |
| Conducted investigations of bank financial losses in Central America on behalf of European insurance underwriters. |
| Translated all Spanish language general correspondence, legal, and financially related documents to English. |
University of California, Berkeley
Dean's Honor List
Oracle Master Database Administration
California Real Estate License (Id: 01439729)
Copyright
© 2002-2007 by J. Gracia. All Rights Reserved
Created by: jagracia@jgracia.com
Changes last made on: Monday, November 12th 2007