GRISEL GONZALEZ
949-437-4940
SUMMARY
Seeking a senior-level SQL Server Developer/Analyst position. Offer demonstrated proficiency in analysis, design, and development tasks with a concentration on database modeling, design and implementation. Strengths include superior written/verbal communication skills, detail orientation, excellent organization, strong analytical and troubleshooting skills, and the ability to work on several projects in a collaborative team environment as well as independently.
EXPERIENCE
Autobytel, Irvine, CA 2007 - present
Consultant
Irvine Technology Corporation, Irvine, CA
Developer
Ø Designed and developed the initial conversion and Extract/Transform steps for an ETL process which integrates financial data on an ongoing daily basis. Data resides in an in-house Autobytel Contract Management custom application (CM) and is converted into Softrax, a 3rd party enterprise revenue management and billing software solution.
Ø Designed and implemented tables, indexes, stored procs, functions, triggers and DTS Packages to transfer data between servers in a SQL Server 2000 environment.
Ø Worked closely with Autobytel’s Accounting & Finance department to determine business rules
American Medical Response (AMR), Torrance, CA 2001 - 2007
Senior Database Architect
Ø Served as an Analyst while working with business users to capture data requirements and inherent business rules. Translated these into data objects.
Ø Created logical and physical models in ERwin for multiple projects ranging from Contract management (AMOS) to Billing.
Ø Designed, implemented and maintained data interfaces for multiple end-to-end systems consisting of disparate data sources on heterogeneous platforms. Data interfaces implemented via DTS packages and T-SQL stored procedures.
Ø Encapsulated business rules and functional requirements in T-SQL stored procedures, functions and triggers on SQL Server 2000 and SQL Server 2005.
Relational Data Systems (RDS), Irvine, CA 1997 - 2001
System Architect
Ø Modeling: Created logical and physical models in PowerDesigner for Lance, a pharmaceutical client/server application that provides the entire core business service for order entry, production processing, shipping, billing and inventory control for the 11 pharmacies in the CAPS organization (CAPS McGaw). Also designed logical and physical models for Classic Industries (a large auto parts mail order company) and Universal Music Group.
Ø Development: Encapsulated business rules in Sybase Adaptive Server 11 stored procedures and triggers (CAPS McGaw) and MS SQL Server 7 stored procedures and triggers (Classic Industries). Created the Microsoft SQL Server 7 database layer (tables, indexes, stored procedures) for a 3-tier e-commerce system (Guidance). Wrote stored procedures for data grooming and business rule enforcement in Oracle 7 (Robert Half International, Universal Music Group).
Ø Data Conversion: Wrote procedures to convert and validate data in the CAPS xBase legacy system into Lance (CAPS McGaw). Wrote DTS packages and T-SQL stored procedures to groom and convert 10 years of xBase legacy data into MS SQL Server 7 (Classic Industries). Created Microsoft SQL Server DTS packages and stored procedures to convert Huxley sales and financial legacy data into Firstwave’s NetGain Sales, a commercial application (Amplicon Financial).
Ø 3rd Party Integration: Developed procedures to integrate a set of third-party database (Medi-Span) data containing drug indices into the Lance system (CAPS McGaw). Wrote stored procedures to import DialRight data and automatically correct contact phones in the database for area code splits (Amplicon Financial). Incorporated UPS and FedEx zone and domestic/international shipping rate data (Classic Industries).
Ø Migration: Migrated the Lance application from Sybase Adaptive Server 11 to Microsoft SQL Server 2000 (CAPS McGaw).
Ø Replication: Assisted in the development of multi-directional replication using Sybase Replication Server to provide both a central repository of all Lance operational data as well as redundant servers in each pharmacy for emergency use (CAPS McGaw). Co-developed all T-SQL code (articles, subscriptions, triggers, stored procedures, etc) to implement Microsoft SQL Server 7 snapshot and transactional replication for a large 12 database site (NRT). Installed Sybase Replication Server (PeopleLink).
Ø Sybase Adaptive Server Anywhere: Designed and developed Lance Link, a subset of the Lance application implemented in Sybase Adaptive Server Anywhere, to be used off-site by CAPS customers (CAPS McGaw).
Ø Documentation: Co-wrote Disaster and Recovery Plan (PeopleLink).
Ø Database Optimization: Participated in multiple performance tuning engagements. Created CRUD matrix for performance and tuning engagement of Sybase Adaptive Server and MS SQL Server databases. Reviewed existing indexing scheme and stored procedures and suggested changes to improve performance (Epoch Transaction Service, PeopleLink, United Lending Group).
DirecTV International, Long Beach, CA 1996 - 1997
Senior Project Engineer
Ø Wrote Informix SQL stored procedures for data grooming and business rule enforcement.
Carl Warren & Co., Orange, CA 1996
Database Administrator
Ø Created and modified database objects for the Claims Management System (CMS).
Ø Established standards for database design, usage and documentation within the department.
Ø Administered and monitored multiple Microsoft SQL Server 6.5 production servers running on Windows NT 4 platform.
Ø Implemented backup and recovery management, database consistency checking, and performance monitoring and tuning.
Century 21 Real Estate Corporation, Irvine, CA 1994 - 1996
Database Analyst
Ø Interfaced with Business Analysts and Divisional Staff to gather data requirements. Developed and maintained logical and physical data models. Encapsulated business rules in stored procedures.
Ø Wrote a Database Design document for a new development proposal that significantly reduced coding and debugging time for the project.
Ø Designed and implemented T-SQL scripts and stored procedures to validate and convert Pick legacy data to Microsoft SQL Server 6.5. Delivered the converted databases on time under tight deadlines.
The Aerospace Corporation, El Segundo, CA 1983 - 1994
Member of the Technical Staff
Ø Designed and implemented a cross-platform compatible (Mac & PC) client/server application utilizing Sybase 4.2.1 on the server side, Omnis 7 on the client side and Dataprism for reporting.
SKILLS
RDBMS: Solid knowledge of Microsoft SQL Server, Sybase Adaptive Server Enterprise, Sybase Adaptive Server Anywhere. Experience with Sybase Replication Server, Oracle, Informix
Software: ERwin, PowerDesigner, DBArtisan, Visual SourceSafe, Microsoft Office, FrontPage
Languages: SQL, HTML, Pascal, PL/1, FORTRAN, APL, ADA
EDUCATION
University of Southern California - Master of Science Degree in Computer Science
California State University Long Beach - Bachelor of Science Degree in Computer Science & Electrical Engineering with a Minor in Mathematics