Technical Summary: I am an SQL Server, Oracle, DB2/UDB, MySQL and Sybase database administrator, developer, data architect, programmer, website designer and developer, quality assurance manager, systems analyst, website developer, and BroadVision Administrator with 20 years of experience in all phases of MIS development, programming, implementation, and operations; excellent skills in team building, people management, communications, and problem solving. Extensive development experience in Perl / CGI, Javascript, PHP, TOAD, PowerBuilder, dBArtisan, Redhat Linux, ETL, DTS and SSIS package design and programming, OLTP, OLAP, Systems analysis, specification, design, coding, optimization, implementation and deployment, quality assurance and documentation. Object-oriented analysis, design, and programming using Rational Rose, Unified Modeling Language, Jacobsen Use Case, Wirfs-Brock, Booch, Rumbaugh, and Yourdon methodologies; two and three-tier client server, application servers, transaction servers, content caching servers, automatic fail-over clusters, replication, hot standby database.

DETAILED EXPERIENCE

Confidential,- Los Angeles, CA, August 2007 to present. DBA / Developer. Application design, development, and quality assurance of a variety of shrink-wrap tools and development aids, including datawarehousing design and analysis, b2b supply chain, regional fulfillment, and basic stock inventory management application with electronic PO\\\'s, sourcing, fulfillment, electronic payment, reporting, metrics. Datawarehousing design and implementation, including slice and dice, star schema, online analytical processing, multi-dimensional optimazation and schema design. Environment: SQL Server, MySQL, Sybase 12.5, DB2/UDB, Oracle 8i. 9i / AS, 10G RAC, Oracle Financials 11, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, PHP, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, .NET, PowerBuilder, CORBA, Orbix, VisualAge Smalltalk, Websphere, Team Foundation Server, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, VSAM, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Confidential,- Los Angeles, CA, June-July 2007. MySQL DBA, Oracle DBA. Installation of Oracle 10G for use with MicroStrategy for departmental data warehouse, 10G Standard Edition Release 2 10.2.0.1, with upgrade patch to 10.2.0.3. Troubleshooting and optimization of MySQL queries, review of MySQL 4.1 dynamic SQL queries for conversion to MySQL 5.1 stored procedures. Environment: MySQL 4.1 and 5.1, Red Hat Linux, x86_64 servers, Oracle 10G Standard Edition on Red Hat Linux, MicroStrategy 8, Navicat, Toad, design of data conversion and loading of data from MySQL production servers to Oracledata warehouse server.

Confidential,Los Angeles, CA, December 2006 to May 2007. DBA / Developer. Application design, development, and quality assurance of a variety of shrink-wrap tools and development aids, including datawarehousing design and analysis, b2b supply chain, regional fulfillment, and basic stock inventory management application with electronic PO\\\'s, sourcing, fulfillment, electronic payment, reporting, metrics. Datawarehousing design and implementation, including slice and dice, star schema, online analytical processing, multi-dimensional optimazation and schema design. Environment: SQL Server, MySQL, Sybase 12.5, DB2/UDB, Oracle 8i. 9i / AS, 10G RAC, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, PHP, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, .NET, PowerBuilder, CORBA, Orbix, VisualAge Smalltalk, Websphere, Team Foundatin Server, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Confidential,West Los Angeles, CA September to November 2006. Design SQL Server 2000 upgrade to SQL Server 2005 cluster server, including requirements, specifications, upgrade methodology, validation and acceptance tests, functional verification tests. 10 DTS packages, 70+ production databases, 100+ applications. Design and coding of stored procedures, views, reports, optimization, troubleshooting. Environment: Windows 2000, SQL Server 2000, SQL Server 2005, DTS, SSIS, .NET, ASP, ADP, Microsoft OLE DB provider for ADO//ODBC.

Confidential,Toluca Lake, CA August to Septermber 2006. Design, coding, deployment, upgrades, and maintenance of a commercial website, Push-button drop-down multi-level menuing, forms with drop-down picklists and field validation alerts, push-button popups, CGI email, floating navigation menu bar, anchor links, file downloads from website, compatible with both javascript-enabled browsers and javascript-disabled browsers. Environment: HTML, XHTML, DHTML, CSS (Cascading Style Sheets), Javascript, Perl, and CGI hosted on a Unix webhosting server. AlleyCode HTML and Javascript text editor, nVu WYSIWIG HTML editor, Ipswitch WSFTP, Xara Xtreme graphics tool, Xara MenuMaker tool, Internet Explorer, Windows XP Professional.

Confidential,Beverly Hills, CA April to July 2006. SQL Server 2000 and 2005 Developer and Data Architect: SSIS package design, development, and deployment; ETL, data migration, T-SQL design and programming, schema design and implementation, Unit Test and Systems Integration Test Scripts, Functional Verification Testing, design and implementation for deployment and cut-over to new production system. Migrated production database application from SQL Server 2000 to SQL Server 2005, including schema re-design, conversion of stored procedures from row-at-a-time to “set theory” statements to improve performance, design and creation of pre-populated index columns to improve performance for multi-table joins of 20+ million row tables to 40+ million row tables, SSIS package design and development for ETL of large datasets into production SQL Server 2005 database. Environment: SQL Server 2000 and SQL Server 2005, SSIS, PHP, MySQL, Windows 2000 and Windows XP.

Confidential,- Burbank, CA. October to December 2005. Proof of technology project: Oracle 9i and 10G XML DB application design and development for mission critical application Schema design and registration in XML DB, structured and CLOB; insert and validation of large-scale xml data files; extraction and aggregation of sales transacation data for export to Oracle General Ledger and downstream production systems. Design, coding, and implmentation of UDF\\\'s, PL/SQL stored procedures, scalability testing and optimization, unit test, systems integration test, and functional verficiation test, creation and implementation of test plans and test fixtures. Design and preparation of XML DB documentation for company-wide knowledge transfer for use by in-house dba\\\'s and developers. Environment: Oracle9i Release 2, Oracle 10G, Oracle Enterprise Manager, Altova XMLSPY Professional 2006, TOAD, Advanced Queing, ACL, Streams, Oracle XML DB.