SUMMARY

• 14+ years of experience in Oracle PL/SQL development, design, requirements analysis, data analysis, trouble - shooting, problem-solving, some database administration, oracle discoverer, and system testing in consulting.
• 14+ years of technical hands on Oracle, PL/SQL programming and development experience.
• 9+ years of Data Analysis experience
• + years of Data Modeling experience
• 7+ years of Oracle consulting experience
• 4+ years developing Oracle applications using Oracle forms and reports
• 4+ years of Oracle 9i/10g discoverer experience
• Posses very strong analytical, troubleshooting, problem solving, critical and logical-thinking skills

TECHNICAL SKILLS

• Oracle 8/9i/10g Enterprise Edition
• Oracle 8/8i/9i/10g
• Advanced PL/SQL
• SQL plus
• Oracle 7.3 xs, 98i, 9i, 10g, 11g
• SQLLOADER
• Oracle 9i/10g Discoverer
• Oracle Developer 6, 6i, 9i, 10g (Forms and Reports)
• TOAD 7.x/8.x/9.x/10.x
• Developer 2000
• Windows NT/95/98/2000/XP
• Oracle Database Administration
• Project Management
• Oracle Forms and Reports
• Data Modeling
• Oracle Datawarehouse Builder
• Oracle 10g/11g SQL Developer
• Golden Development Tool
• Harvest
• Change Management
• UNIX Sun Solaris
• Unix Vi Editor
• Oracle 10g Database Express
• Requirements Analysis
• Data Analysis
• PL/SQL programming and development
• Complex SQL Development
• Trouble - shooting/Problem-Solving Oracle related issues
• Oracle Reports Development
• Oracle 9i/10g Discoverer

PROFESSIONAL EXPERIENCE

Confidential, Redwood Shores, CA

Sr. Oracle PL/SQL Developer

Environment: Oracle 10g, 9i, Windows NT/XP, UNIX Sun Solaris, Data Warehouse - Retail

Tools: TOAD,ORACLE, SQLPLUS, PL/SQl, Quality Center, Harvest, Oracle 10g, Change Management Tool, VI Editor, FTP

Responsibilities:

• Responsible for Oracle10g Development, PL/SQl Development, Unix Scripting, trouble-shooting and resolving code related issues both in UNIX and Oracle Database environments.
• Handled several projects relating to Data Loading and production support issues.
• Handled PL/SQL code Analysis, coding, tuning, modifications, and new developments based on requirement.
• Handled Oracle New Object Creations - Tables, Indexes, Sequences, Procedures, Functions, and Triggers.
• Handled data analysis, validation, and trouble-shooting issues based on customer requirements.
• Handled retrieval and loading of data based on customer requirements via import/export mechanism.
• Utilized TOAD 9.x, Oracle SQLPLUS, and Windows Command Prompt for creating objects, modifications, import/export, trouble-shooting and resolving issues.
• Utilized Microsoft Outlook for Emails.
• Utilized Microsoft Excel and Word for spreadsheet related tasks.
• Utilized Quality Center for creating defects and logging tasks.
• Utilized Change Management for New and Old Projects Deployment purposes.
• Utilized Oracle10g/11g, SQLPLUS, Windows NT/XP, Unix Vi Editor, Sun Solaris for creating and modifying both Oracle & Unix related objects.
• Utilized TOAD for data loading - importing/exporting tables’ data in Oracle environment.
• Utilized SQLLOADER for data loading - importing tables’ data in Oracle environment.
• Utilized Harvest for checking-in/checking-out objects for both new developments and existing ones.

Confidential, Foster City, CA

System Analyst

Environment: Oracle 10g, Unix, Windows NT/XP

Tools: Golden, TOAD, ORACLE10g, SQLPLUS10g, PL/SQL10g, Test Director, JTRAC, SQL Developer11g, SharePoint

Responsibilities:

• Responsible to design, code, and test PL/SQL scripts for test data generation for performance testing
• Responsible to assist in support of application projects
• Created high level design document for test data generation for performance test projects.
• Created PL/SQl scripts based on high level design document to generate data for 14 table objects
• Loaded several million records to test PL/SQL scripts
• Resolved issues encountered during testing
• Worked on data cleansing/scrubbing and data loading projects
• Worked on Oracle PL/SQL code modifications/enhancements to resolve issues
• Served as primary/secondary on-call person on rotational basis
• Participated in team/project meetings
• Documented all work performed
• Used JTRAC, Test Director, SharePoint to log requests, defects, check-in/check-out respectively
• Used Oracle 10g, SQL Developer 11g, Golden TOAD 9.x, SQLPLUS10g
• Volunteered to some community services

Confidential - Cupertino, CA

Sr. Oracle PL/SQL Developer/Data Analyst

Environment: Oracle 10g, 9i, Windows NT/XP

Tools: Golden, TOAD, ORACLE, SQLPLUS, PL/SQL, Quality Center, Centrix, Oracle 10g Discoverer

Responsibilities:

• Responsible for Oracle9i/10g Development, PL/SQL Development, Complex Oracle SQL Development, trouble-shooting and resolving code related issues.
• Handled several projects relating to RJ-11, FlexPay, SIVR, WEB, and Retail.
• Handled PL/SQL code Analysis, coding, tuning, and modifications.
• Handled development and tuning of complex Oracle SQL queries based on customer requirements.
• Handled creation of Oracle Temp Tables, Indexes, Sequences, and Database Links.
• Handled data analysis, validation, and trouble-shooting issues based on customer requirements.
• Handled retrieval and loading of data based on customer requirements via import/export mechanism.
• Utilized TOAD 8.x, Oracle SQL Developer, and Golden Applications for creating objects, modifications, import/export, trouble-shooting and resolving issues.
• Utilized Microsoft Outlook for Emails.
• Utilized Microsoft Excel and Word for spreadsheet related tasks.
• Utilized Quality Center for creating defects and logging tasks.
• Utilized Oracle10g,SQLPlus in Developing Views, Procedures, Triggers, Sequences, Tables, etc. for Quality Center Reporting Project.
• Utilized Centrix for logging timesheets for the client.
• Utilized Oracle9i/10g, SQLPLUS, Windows NT/XP for creating and modifying Oracle related objects.
• Exposure to Oracle 11g.

Confidential - San Francisco, CA

Sr. Oracle PL/SQL Developer

Environment: Oracle 10g, 9i, 8i Windows NT/XP

Tools: StarTeam, TOAD,ORACLE, SQLPLUS, PL/SQL, Oracle 10g Discoverer Responsible for Oracle9i/10g Development, PLSQL Development, trouble-shooting and resolving code related issues.

• Handled Conversion project.
• Handled PL/SQL code Analysis and modifications.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Handled creation of Oracle Tables, Triggers, and Materialized View.
• Handled creation of test plans, and technical specifications for developed and/or modified objects. Handled loading data required for system testing, setting up necessary test environment, and system-testing developed Oracle objects.
• Utilized TOAD 8.x for creating objects, modifications, trouble-shooting and resolving issues. Utilized Oracle 10g Discoverer to administer and create reports.
• Utilized StarTeam for check in/check out objects, and logging tasks.
• Utilized Oracle9i, SQLPLUS, Windows NT/XP for creating and modifying Oracle objects. Oracle 11i / Oracle Financials Training - CBT

Confidential - Palo Alto, CA

Oracle Developer PL/SQL Programmer

Responsibilities:

• Responsible for Oracle9i/10g development, PL/SQL Development, trouble-shooting, and resolving issues as they surfaced.
• Handled PL/SQL code modifications, enhancements and tuning.
• Handled Oracle Reports development, modifications, enhancement, and tuning and Oracle 10g Discoverer Reports design, development, enhancement, and tuning.
• Created Tables, views, materialized views, wrote SQL scripts, Indexes, etcAnalyzed Oracle objectsResolved performance issues - like fixing Chaining issues, and documenting projects.
• Responsible for Database objects performance tuning
• Tools/Skills set include the following:
• Create several Procedures, Functions, Views, Packages, Tables, Sequences, Synonyms, Indexes, Materialized
• Views, and Analyzing Oracle Objects and resolving Chaining issues in Oracle Databases.
• Analyze data and resolve Oracle related issues on a regular basis
• Use Oracle versions 9i & 10g PL/SQL & SQL*PLUS for Back-End development of modules for the projects
• Use Oracle Discoverer (versions 4.x & 10g)
• Use TOAD (versions 8.0 & 8.x - up to the latest version - 8.5), and PL/SQL Developer
• Use Windows NT/XP, Oracle 9i, Oracle 10g
• Use SQLLOADER for Data Loading
• Use Unix AIX

Confidential - San Jose, CA

Oracle Developer PL/SQL programmer

Responsibilities:

• Responsible for developing over 100 new Custom Reports, Import/Export Utility, Several Data Loading Projects, etc
• Responsible for Oracle development, PL/SQL Development, Oracle Forms & Reports 6i/9i/10g.
• Loaded Data utilizing SQLLOADER, Oracle packages, functions, procedures (Extensive PL/SQL Coding).
• Responsible for Data migration, Data cleansing, testing, trouble-shooting, problem-solving, and resolving issues as they surfaced. Imported and exported Oracle Objects.
• Handled PL/SQL code modifications, enhancements, and tuning.
• Designed, developed, modified, enhanced and tuned Oracle reports and Oracle Discoverer Reports.
• Created Tables, Triggers, views, materialized views, and SQL scripts
• Tools/Skills set include the following:
• Create several Procedures, Functions, Views, Packages, Tables, Sequences, Synonyms, and Materialized Views
• Create several new custom Reports
• Perform several Data Loads
• Create new Forms and modify existing ones
• Analyze data and resolve Oracle related issues on a regular basis
• Deploy some Forms and Reports to the web
• Use Oracle versions 9i & 10g {L/SQL & SQL*PLUS for Back-End development of modules for the projects
• Use Oracle Developer 6i (Forms 6i and Reports 6i)
• Use Oracle Developer 10g (Forms 10g, Reports 10g, and Graphics 10g)
• Use Oracle Discoverer (version 10g)
• Use TOAD (versions 8.0 & 8.x - up to the latest version - 8.5)
• Use Windows NT/XP, Oracle 9i, Oracle 10g
• Use SQLLOADER for Data Loading
• .Use XMLSpy for XML Data Loading

Confidential - Santa Clara, CA

Oracle Database/PL/SQL Development, Oracle Developer

Responsibilities:

• Worked on PL/SQL modifications/enhancement.
• Analyzed data, trouble-shoot/researched issues dealing with Oracle 8i/9i databases.
• Performed Oracle database tuning for database objects and data warehouse objects.
• Resolved row migration and chaining issues; exposure to Informatica.
• Documented some PL/SQL and SQL codes as well as other database objects.
• Tools/Skills set for above projects include the following:
• Data Modeling, Database development using Advanced PL/SQL 8i, SQL, SQLLoader, and SQL*PLUS Scripting
• Responsible for creating and assigning roles and profiles to Database users
• Responsible for creating Procedures, Functions, Views, Packages, Tables, Clusters, Sequences, Synonyms
• Databases, Table spaces, and Snapshots
• Analyzed data and resolved Oracle related issues on a regular basis
• Trained/worked with Oracle 9i
• Developed some web enabled Forms and Reports for the Security Vehicle Permits project
• Responsible for deploying client/server Forms and Reports to the web
• Used Oracle versions 8i & 9i PL/SQL & SQL*PLUS for Back-End development of modules for the projects
• Trained/exposure to Oracle Portal and Oracle Workflow, and Oracle 9iAS
• Used Oracle Developer 6 (Forms 6 and Reports 6)
• Used Oracle Developer 6i (Forms 6i and Reports 6i)
• Used SQL Server 2000
• Used Oracle Discoverer (versions 3.1 & 4.1.x)
• Used TOAD (versions 6.0.4 & 7.3)
• Used Windows NT/98/2000/XP, Oracle8 & 8i Enterprise Edition, Oracle 9i, Oracle 8i, Oracle 8x

Confidential - San Francisco, CA

Oracle Database Developer & Project Manager

Responsibilities:

• Worked closely with DBAs and other team members to plan, test and implement several Oracle database related projects for customers.
• Analyzed data on a regular basis.
• Created, updated, tuned and modified Oracle Procedures, Functions, Packages, Tables, and View for better performance.
• Developed Project scopes, test plans, executed the test plans, and assisted in projects implementation.
• Participated in deploying client/server Forms and Reports to the web.
• Participated in team/customer conference calls/meetings to discuss new and existing database projects and other related issues. Maintained daily operation of proprietary applications.
• Developed and ran Oracle reports queries on daily basis for data extraction utilizing SQL and SQL*PLUS.
• Performed Functional and data requirement analysis, and some light DBA work. Involved in researching, analyzing, troubleshooting, and resolving Oracle related issues as they materialized.
• Recognized by senior management for outstanding performance resulting in receiving some days off bonuses.
• Met projects deadline.
• Always on call for after hours projects in-progress as the project manager.
• Performed customer database cleanup projects consisting of millions of records/transactions to enhance and tune the database for better performance