Database Developer

Jeannie Cole

TECHNICAL SKILLS

• Oracle PL/SQL: 9i, 10g • DataFlux dfPower Studio

• MS SQL Server 2000: Transact-SQL • C, C++

• DB2: SQL Stored Procedures • UNIX/Solaris

• Sybase: Transact-SQL • Shell Scripting: C, Bourne, Korn

• JavaScript, HTML, CSS • JAM Application Builder

• VBScript, ASP • Visual World/Flex Basic

• Microsoft Access 2000 • GUI Development

EXPERIENCE

Customer Data Steward/Data Analyst Sun Microsystems, Inc./Oracle America, Inc., Broomfield, CO

Sep 2008 – Sep 2010

Technical and Operational Support for Customer Data Quality and Hierarchies

Oracle PL/SQL, DataFlux dfPower Studio, Oracle Applications, C Shell

Part of team responsible for significant improvements in customer data quality in Sun's Oracle 11i Customer Data Hub, using data quality, reporting, and development tools such as DataFlux dfPower Studio, Oracle PL/SQL, and DbVisualizer. Contributions to data cleanup include resolving duplicate data, customer hierarchy, and conversion issues. Main support person for legacy hierarchy management tool in marketing data mart context. Contributed PL/SQL and DataFlux programs for Sun-to-Oracle customer data migration staging.

Functional Engineer Computer Sciences Corporation at Sun Microsystems, Inc., Broomfield, CO

Feb 2006 - Sep 2008

Service Contracts Application Support for Legacy Systems and Oracle Applications 11i

Oracle PL/SQL, Oracle Applications, C/Bourne Shell

In a very short time, came up to speed and made important contributions in support of a large, complex, legacy application area. Led in support of the newer Oracle 11i production environment that replaced the legacy system. Exhibited strengths in the areas of documentation writing and organization, effective user communications, and research of issues as the support team's "go-to" person for information in the following application functional areas: Service Contracts, TCA, and Advanced Pricing.

Web Technician Blue River Digital, Inc., Roseville, CA, www.blueriverdigital.com

Apr 2004 - Jan 2006

Web Site Maintenance

HTML, VBScript, JavaScript, CSS, ASP, Access 2000, MS SQL Server 2000/Transact-SQL

Performed ongoing web site maintenance and administrative support for fast growing large-format digital color shop. Responsible for enhancing usability and product options for users in shopping cart areas of site. Contributions to BRD customer websites as well, including converting legacy site to CMS site, building new database-driven site for restaurant supply business, enhancements to music collection site.

Data Conversion Consultant Table For Six, San Francisco, CA

Dec 2004 - Aug 2005

Data Conversion

Visual World, Microsoft SQL Server 2000/Transact-SQL

Successfully migrated data for dating service from Visual World proprietary system to Microsoft SQL Server database. Analyzed data requirements for moving to relational database structure and wrote complex stored procedures for converting legacy client data.

Software Engineer/Business Analyst Benefit Partners, Inc./PacAdvantage, Roseville, CA

Sep 1999 - Oct 2002, Jan 2003 - Jun 2003, Aug 2003 - Dec 2003, May 2004 - Nov 2004

Data Conversion

DB2/SQL Stored Procedures, Visual World/FlexBasic, Access 2000

Coded complex stored procedures for successful manipulation of millions of records of legacy data in preparation for multi-tiered insurance administration system. As business analyst, assisted with the conversion of invoice data, ensuring accuracy and completeness, writing and utilizing legacy system programs as needed to efficiently accomplish verification tasks.

Health Insurance Administration System

Visual World/FlexBasic

Developed creative solutions in support of Administration System for large insurance pool. Became productive immediately in coding on proprietary software, in spite of lack of documentation or assistance from software vendor. Designed and coded enhancements for quoting, enrollment, billing, transmissions, and financial reporting needs.

JAM Consultant Robert Half International at Sprint, Rancho Cordova, CA

Nov 1998 - Jul 1999

Voice/Data Rating System

JAM/JPL, C++, Sybase/Transact-SQL, SQR, UNIX/Solaris, Korn shell

Major modifications to rating system, including JAM front-end enhancements, database conversion and batch program changes. Quality enhancements to complex cost report in C++ resulted in high user satisfaction. Y2K code changes for rating system done in half the time allocated.

Software Systems Engineer Sun Microsystems, Inc., Palo Alto, CA

Jun 1991 - Sep 1997

Human Resources Information System, Nametool Application, Payroll Reporting, Training System

JAM/JPL, C/C++, Sybase/Transact-SQL, UNIX/Solaris, C/Bourne shell, SQR, Motif, Xview

Member of large project team which developed key company-wide HR application used by managers and HR for a variety of tasks (hires, terminations, salaries, etc). Additionally, developed solutions and provided support for Nameslist, Payroll Reporting, and Internal Training System.

EDUCATION/TRAINING

Oracle 11i Customer Data Management class, Oracle University, March 2008

Oracle 11i Multi-module class (Service Contracts, TCA, Advanced Pricing), Oracle University, May 2007

B.S., Computer Science, California State University, Chico, 1991, Business Minor

Contact this candidate