We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

CT

Professional Summary

5+ years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server. Over 2 years of experience in DW/ETL Technologies.

Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment

  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
  • Feasibility study, planning, implementation, testing, deployment and close-out
  • Created logical and physical Database Design, data structures, Data Modeling, Schema Design
  • Applied Database Tuning and Optimization, Normalization in the new database design
  • Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms.
  • Granted resources, privileges and roles to users
  • Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
  • Wrote Audit programs for data consistency check and validation
  • Used SQL*Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packages
  • Automated SQL*Loader to load the data from the flat files
  • Used Materialized Views, Packages and Dynamic SQL
  • Created programs to transform data from Legacy systems into Oracle database
  • Performance Tuning of Oracle Applications using TKPROF
  • Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
  • Performed dimensional modeling and have very good understanding of Data Warehouse Techniques using MicroStrategy and Cognos
  • Tested and modified codes for quality

Technical skills

Operating Systems: Windows XP/2000/98, HP-UX, LINUX (Fedora 4.0), MS-DOS DBMS:Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access Languages:PL/SQL, SQL, XML/HTML, Unix Shell Script, C++/C,Java, C# Tools:Oracle SQL*Plus, Forms/Reports 9i/6i/2000, Discoverer 3.1, MicroStrategy, Cognos, SQL Navigator, VI Editor, TOAD, Crystal Reports, PowerBuilder, Business Objects, NetBeans, MS Visual C#, Mathcad, Eclipse, MS Project, Samba Other Skills:Oracle Applications 11i- Oracle Projects (Project Accounting)

PROFESSIONAL EXPERIENCE:

Client: Confidential, CT Oracle PL/SQL Developer January 2007-August 2009 Roles and Responsibilities:

  • Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts
  • Incorporated business rules and constraints and created new tables for all modules.
  • Worked on claims processing reports on investigation and payment.
  • Generated claims report weekly, monthly and yearly.
  • Worked on reports to give parallel comparison of different-2 fiscal year of claims.
  • Fine tuned long running claims reports.
  • Developed expense reports to provide claims from accessing different-2 tables.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Tuned SQL queries to improve response time.
  • Wrote UNIX shell scripts to run SQL scripts daily.
  • Fine tuned SQL queries using hints for maximum efficiency and performance.
  • Developed Claims reports that would produce Excel outputs for users.
  • Developed a customer data warehouse to understand customer behavior to various Claims related programs and identify critical customers in support of improved decision-making across the organization
  • Extensively worked in performance tuning of programs and processes.
  • Worked closely with Administrator for proper backup and recovery plans.
  • Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques.
  • Worked under tight schedules for successful development and implementation.

Environment: Oracle 10g, Oracle Forms/Reports 10g, PL/SQL, TOAD, SQL*Loader, Unix Shell scripts, UNIX (HP-UX 11.11), Business Objects, Crystal Reports

Client: Confidential, Houston, TX Oracle PL/SQL Developer September 2005-December 2006 Roles and Responsibilities:

  • Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens
  • Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files
  • Created database reports to get open enrollment and enrolled list reports
  • Created database tables and wrote database triggers applicable to business rules.
  • Developed triggers and packages to delete stored session data from various tables
  • Debugged various defects related to implementation of business logic

Environment: Oracle 9i, PL/SQL, Forms/Reports 9i, HTML, PowerBuilder, SQL*Plus, Oracle Designer and Toad, UNIX (HP-UX 11.11)

Client: Confidential, Seoul, South Korea Oracle Apps Developer January 2003-August 2005 Responsibilities at 'Upgrading Korea Telecom (KT) ERP System' project:

  • Implemented using Forms, Reports, PL/SQL, Flexfields and Workflow
  • Customized and maintained Project Accounting (Project Costing and Billing)
  • Performed Requirements Analysis, Data Flow Diagram (DFD), Entity Relationship Diagram (ERD) and Functional Hierarchical Modeling
  • Performed functional setups for Project Accounting
  • Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL
  • Created and maintained capital projects/tasks for network cable constructions
  • Used AMG (Activity Management Gateway) in Project Accounting and developed scripts to load Projects data into Oracle Projects
  • Created budgets to control project costs and task structures to monitor project status
  • Created both internal (Costing) and external (Billing) projects
  • Assigned key members and assets to projects for internal and external billing of labor and expenses
  • Assisted in user support and training

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL, UNIX (HP-UX 11.00), Forms/Reports 6i Modules: PA, GL, AP, AR, FA

Client: Confidential, Seoul, South Korea Oracle Apps Developer January 1999-December 2002 Responsibilities at 'Building Hanaro Telecom ERP System' project:

  • Implemented using Forms, Reports, PL/SQL, Flexfields and Workflow
  • Customized and maintained Project Accounting (Project Costing and Billing)
  • Performed Requirements Analysis, Data Flow Diagram (DFD), Entity Relationship Diagram (ERD) and Functional Hierarchical Modeling
  • Performed functional setups for Project Accounting
  • Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL
  • Created and maintained capital projects/tasks for network cable constructions
  • Created budgets to control project costs and task structures to monitor project status
  • Created both internal (Costing) and external (Billing) projects
  • Assigned key members and assets to projects for internal and external billing of labor and expenses
  • Used Oracle Discoverer for querying base tables and defining ad-hoc reports for users
  • Assisted in user support and training

Environment: Oracle Applications 11i, Oracle 8i, PL/SQL, UNIX (HP-UX 11.00), Forms 4.5, Reports 2.5, Discoverer 3.1, TOAD Modules: PA, GL, AP, AR, FA

Education & Training: M.S. in Computer Science B.S. in Computer Science Course on MS SQL Server 2005 Administration and self-study with MCTS Certification Exam 70-431 MS SQL Server 2005 Implementation and Maintenance published by McGraw Hill and Sybex respectively Course on Oracle 10gR2 Administration and self-study with OCA/OCP Certification Exam Study Guide published by Sybex

Hire Now