Home Oracle Corporation
PDF Print E-mail

Senior Instructor – OLTP/OLAP Developer, Data Modeler, DBA, PL/SQL Programmer

Oracle Corporation

Sept 2000 - May 2003

  • Consistently ranked in the Oracle Master Certification Quality club by scoring a 97% average weekly student evaluation and Created, streamlined and enhanced Data Modeling, Data Warehouse, PL/SQL and SQL certification focused curriculums and labs
  • increasing quarterly departmental revenues by 20%.
  • Consistently ranked in the Oracle Master Certification Quality club by scoring a 97% average weekly student evaluation and received recognition in award ceremony.
  • Very strong SQL skills, including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns, and creative use of the CASE and EXISTS operator.
  • Instructed courses in Data Warehousing, JAVA, PL/SQL, SQL, Object Oriented programming, OO software and database design with UML, ORM and ER engineering notation.
  • Expert knowledge and skills in Database Administration and Architecture, Performance Tuning, SQL Statement Tuning, Stored Procedures, Triggers, Extended Data Retrieval and Large Objects. received recognition in award ceremony.
  • Conducted workflow and data flow studies to enhance employee performance and coded web services using SQL, PL/SQL, XML, Javascript to run on Oracle, and UNIX platforms.
  • Refactored OLAP databases Reducing data redundancy by 20% and implemented data cleaning routines additionally lowering data administration costs by 30%.
  • Administered object and account security, password management and encryption policies, database auditing guidelines and created disaster recovery and back up plans.
 

Knowledgy SQL RSS

SearchSQLServer: Expert advice on database development
Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.
SearchSQLServer.com
  • Utilize SSAS for data predictions and classification using Excel
    Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Useful reading for users who are not typically creating data mining algorithms and SAS/SCL programmers

  • The sqlcmd utility in SQL Server
    The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting started using sqlcmd in interactive mode, and shows you have to use sqlcmd in Management Studio.

  • Top 10 SQL Server Tips of 2008
    Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most viewed SearchSQLServer.com tips of the year.