Oracle Plsql Developer Resume
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:
Responsibilities at 'Upgrading Korea Telecom (KT) ERP System' project:
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
"I did my oracle training in greens technology, Chennai. Now I got placed in Virtusa. I really thank Dinesh for his involvement in my training. His way of teaching is really awesome. I never saw such quality teaching and placements were so fast. Thanks a lot Greens Technologys for your support. I wish dinesh sir all the best for his new IT development venture."
"I thought I knew oracle until I took this course. My company sent me here against my will. It was definitely worth and I found out how many things I was doing wrong. Dinesh is awesome. but i got a lot inspired by you. I will keep in touch and will always try to learn from you as much as I can. Thanks once again Dinesh for the Best Oracle training !"
Oracle Placement Training in Chennai
Greens Technologys Overall Reviews
5
out of 5
based on 17,981 ratings.
17,981 user reviews.
"""I think this is the best Oracle training course in chennai I have taken so far..Well I am still in the process of learning new things but for me this learning process has become so easy only after I joined this course in greens technologies..as Dinesh is very organized and up to the point.. he knows what he is teaching and makes his point very clear by explaining numerous times. I would definitely recommend anyone who has any passion for Oracle.." ""