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