Professional Summary

• IT Professional - Oracle Developer
• Worked with 11i and R12 apps, Reports 8i and 11g, BI Publisher
• Capable of building customized SQL and PL/SQL programs
• Experience in developing training document
• Proven results-oriented work ethic

Experience

Confidential

Oracle Developer

• Worked on converting 130 customized reports from 8i to 11g
• Converted reports are used by a third party apps called EPersonality
• Upgraded SQL queries in the reports for additional business logic
• Added PL/SQL logic in the reports for additional functionality
• Performed SQL tuning on a number of reports to enhance performance
• Troubleshoot report issues and found fixes
• Re-formatted report layout for additional fields and images
• Added report parameters to coincide with application parameters
• Proactive in learning EPersonality features especially from a developers perspective
• Developed forms in EPersonality for reporting application: function IMFN , parameter IMPM and design IMFD
• Developed a training manual for users on the usage of the reports

Confidential

Fulltime Non Oracle position

• Involved in a joint venture entrepreneurial business
• Performed various customized queries on SQL server for reporting
• Assisted in the functional side of the MS RMS Operations and Manager systems
• Designed and created traffic analysis ratio
• Migrated data from SQL server using .csv files to Oracle tables
• Involved in building/maintaining e-commerce site
• Managed financial and operational duties for store

Confidential

Fulltime Oracle Apps Developer

• Supported 11i Apps using 9i server and R12 using 11g server
• Apps include Order Management OM , Accounts Receivable AR , Accounts Payable AP , WMS
• Programming languages and tools: SQL, PL/SQL, Oracle BI/XML Publisher, Oracle Reports 6i and 10g, Discoverer
• Built customized PL/SQL programs for departments such as marketing, web, financial, operations and customer care
• Developed customized BI XML publisher documents/reports
• Utilized APIs to import customer and order information
• Supported OBIEE team to provide back-end programs
• Performed production deployment support, performance tuning and trouble shooting of DB related issues
• Ability to work independently or as part of a team
• Analyzed situations, identify problems, and recommended solutions
• Strong problem solving, interpersonal and communication skills
• functions, packages, triggers, views, materialized view and XML features and writing complex SQL queries
• Strong Oracle DB and PL/SQL application development skills and excellent knowledge of stored procedures,
• Unix/Linux Shell scripting for FTP protocols and data transfer processes
• Able to learn new technologies and processes quickly
• Experienced with data analysis, data modeling process, modeling and system development life cycle methodologies
• Developed and ensured adherence to standards for program and system documentation
• Excellent written and communication skills

Confidential

Oracle PL/SQL Programmer

• Built programs to process raw data from different departments and import into various repositories
• UNIX scripting ftp data files into staging folders for processing
• Supported datawarehousing and form teams for SQL queries and PL/SQL
• Created objects for repositories, such as tables, synonyms, views, sequences, db links, jobs, stored procedures, packages, directory, triggers
• Utilized DBMS supplied packages and enhanced codes in existing systems
• Migrated table structures and data into production
• Documented technical processes of programs as dictated by standards

Confidential

Oracle Developer

• Enhanced existing procedural source codes as dictated by business rules
• Analyzed and used Constellar hub to ETL source data for datawarehousing
• Enhanced existing process of Constellar interfaces as dictated by business rules
• Modified UNIX script files
• Developed and executed AppWorx chains to schedule and run various modules
• Created test data to run and evaluate enhancements and interfaces
• Documented and produced test summary results

Confidential

Oracle Developer

• Developed the Complaint Tracking System using PL/SQL program in the backend and Oracle Forms/Reports 6i on front end
• Installed/configured Oracle forms/reports runtime on the client to allow user access
• Performed various startup and shutdown procedures of the databases
• Created and executed SQL and PL/SQL scripts to search for contentions and answer DBA inquiries
• Created schema, tablespaces, tables, indexes and other objects with storage definitions
• Monitored the database daily using script files, Oracle Enterprise Manager, alert log and trace files
• Cloned the production database for test and development instances
• Migrated data, objects, constraints, constructs using Oracle export/import utilities
• Database Server
• Requested TAR on various critical server and application issues, and requested ODC
• Applied required patches c, g, and d patch drivers
• Responded and resolved apps bugs using Oracle support fixes
• Configured, maintained and defined apps users, responsibilities, menus, printer
• 11i APPS
• Oracle11i Application DBA/Oracle DBA role
• Built Drive School Stat Database using MS Access
• Documented workflow
• Completed system as specified and within schedule
• Developed and created tables using ERD diagrams
• Migrated financial data using DataLoader from MS Excel into Oracle
• Supported Business Analysts to extract, analyze and isolate critical financial data

Confidential

Contract - Oracle DBA

• Performed operational database administration in a production Oracle9i database
• Monitored production database daily with Oracle Enterprise Manager, alert log file and trace files
• Defined schemas and granted system/object privileges
• Created profiles and roles to control user resources and security
• Replicated object structures and/or data using Oracle exp/imp utilities and CTAS
• Cached new, existing and selected tables and indexes to improve buffer hit ratio
• Created tablespaces, tables, indexes, views, and other database objects
• Allocated additional storage spaces to existing tablespaces, datafiles and segments
• Involved in backup and recovery using Recovery Manager
• Aided in monitoring, maintaining and optimizing database performance
• Proactive in developing a contingency plan to backup and recover the database
• Documented activities, decisions and performance reports
• Provided support to other departments having database issues

Confidential

Technical Trainer

Technical Trainer

• Oversee the course development, facilitation and consultation of the Auto Service Activation Program ASAP
• Trained technical topics, developed training courses and system set-up
• Trained up to sixteen clients per session

Oracle DBA Support Role

• Worked on Oracle8i server under HP UNIX environment in the training department
• Replicated table structure or records using CTAS, or imp/exp utilities
• Cached new, existing and selected tables and indexes to improve buffer hit ratio
• Created tablespaces, tables, indexes, views, and other database objects by considering storage parameters
• Defined schemas and the granted system/object privileges
• Created SQL statements and PL/SQL procedures to query and manipulate the database
• Allocated additional storage spaces to existing tablespaces, datafiles and segments
• Installed and configured Oracle9i databases on Windows 2000 in the trainer laptop
• PL/SQL scripting created using the UNIX vi editor

Technical Summary

• Databases: Oracle8i, 9i, 10g, R12
• Application/Reporting Tools: R12 BI Publisher, SQL Developer, Forms/Reports 6i, TOAD, Discoverer 3.1
• Database Management Tools: SQL Plus, OEM, STATSPACK, Oracle scripts, DBCA, RMAN
• Oracle Migration Tools: Import/Export Utility, SQL Loader, DataLoader
• Languages: SQL, PL/SQL, XML, XSLT
• Oracle11i Apps OM, AR, AP, WMS
• Operating Systems: Windows NT/2000/XP, UNIX, MS-DOS
• Others: MS Office Tools 2000, Acrobat Frame Maker