Oracle Pl/sql Application Developer Resume
SUMMARY:
- Oracle PL/SQL Developer with almost 5 years of extensive experience in analysis, designing, developing, implementing and maintaining database applications and solutions, primarily using Oracle database technologies.
- Expert in writing efficient SQL and PL/SQL code (Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages) on TOAD to analyze very large data sets.
- Expert data integration. Import export from raw data file to database and database to dat/txt/csv file.
- Hands - on experience using Oracle tools like SQL *PLUS, SQL Developer, PL/SQL Developer and TOAD in many development projects.
- Good knowledge on Pro*C coding.
- Complete understanding of Oracle architecture including SGA(Database Buffers, Redo Log Buffers, Shared Pool) Log writer, Achiever, PMON, SMON, PGA, Listener services, Data dictionary Views
- Expertise in system integrations and client interactions in preparing functional designs.
- Experience on Oracle Collections and Oracle Partitioning.
- Expertise with Oracle Analytic functions.
- Good knowledge on performance tuning activities.
- Expertise with concepts of referential integrity and constraints.
- Experience in working on Regular Expressions.
- Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.
- Experience in working on SQL Loader.
- Extensive experience in Performance Tuning (both SQL Tuning and PL/SQL Tuning) using TKPROF, SQL TRACE, TIMED STATISTICS & Explain Plans, DBMS PROFILER.
- Good knowledge with Unix Shell Scripting.
- Good knowledge of Data Modeling and creation of Entity Relationships Diagrams.
- Knowledge of Data warehouse and ETL.
- Expertise in requirements gathering, software requirements specifications, systems development, testing (unit, performance), reporting, application maintenance, application / production support.
- Good domain knowledge of Banking, Retail and Financial institutions.
- Excellent documentation and presentation skills, great verbal and written communication skills
- Analytical thinker, quick learner and proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
TECHNICAL SKILLS:
Databases: Oracle 11g/10g/9i
Languages: SQL, PL/SQL, HTML, PRO*C, UNIX Shell Scripts
Tools: SQL Loader, Import/Export, Oracle Developer Suite. SQL * Plus, Toad,WinSCP,Putty
Repositories: VSS,Clear case(Version Controlling tools)
Reporting Tools: Business Objects (Crystal Reports)
Operating Systems: UNIX, Linux, Windows 2000/XP/NT
Productivity Applications: MS Office, Edit plus, Visio, Visual Studio, .NET
PROFESSIONAL EXPERIENCE:
Confidential
Oracle PL/SQL Application Developer
Responsibilities:
- Creating complete end-to-end software solutions by developing, testing, rolling out and supporting systems, reports and services
- Worked on design/ development of Customer Integration system.
- Developing program specs based on Functional specifications.
- Wrote procedures to import raw data into oracle database instead of using SQL*Loader.
- Wrote procedures to extract data into excel/csv/dat/txt format for interfacing.
- Wrote procedures to identify possible duplicate to staging table.
- Wrote procedures to load data from different tables for mapping table.
- Created the role level security for database and tables.
- Modified existing forms and reports, designed new forms and reports as per business requirement.
- Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
- Creating SQL, PL/SQL database objects.
- Wrote Views, PL/SQL packages, procedures and function for processing business logic in the database.
- Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
- Responsible for following up bugs reported by various users and suggesting possible patches to be applied.
- Enhanced the performance of legacy PL/SQL packages by using Oracle 10g new features like FORALL and BULK COLLECT.
- Written the Interface Stored Procedures for Data Transformation
- Used PL/SQL developer tools for faster application design and developments
- Developed procedures using Dynamic SQL, UTL FILE.
- Involved in Testing (Both Unit and Integration Level) and Implementation.
- Tested the entire application in testing environment and exported to Production.
- Wrote PL/SQL packages, procedures, triggers and function for processing business logic in the database.
- Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
- Involved in Designing of Data Modeling the, Design Specifications and to analyze Dependencies.
- Responsible for creating and maintaining the packages, stored procedures, triggers functions and cursors.
- Involved in Unit level testing, Module level testing and System testing.
- Involved in preparing functional specifications, release notes, & documentation using MS-Office.
Technologies: Oracle10g/11g(SQL*PLUS,PL/SQL),MS-Office,SQL*Loader,TOAD,Windows,ClearCase, WinSCP,Putty, Development, Testing and Production environment, Windows, UNIX, Visio
Confidential
Oracle PL/SQL Application Developer
Responsibilities:
- Creating SQL, PL/SQL database objects.
- Involved in data maintenance for static tables.
- Involved in preparing test datas for testing.
- Worked on checking log files on UNIX while working on support for production environment.
- Worked in SQL Loader for loading data from various sources like flat file, excel etc. into tables.
- Involved in developing PRO*C batch programs.
- Attending client meeting to discuss functional design for conversion programs.
- Worked Extensively on Oracle Analytical functions like partition over by, rank, dense rank, lead, lag.
- Created database tables, indexes and partitioned existing tables.
- Worked on Bulk loader utilities like Sql loader for moving data from external files into the Oracle database.
- Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
- Worked Extensively on Collections (Varrays, Associative arrays and Nested tables).
- Created database tables, indexes and partitioned existing tables.
- Performed unit, system and Integration testing.
- Developed FTP process to extract data from Flat files received from various systems.
- Used PL/SQL developer tools for faster application design and developments
- Developed procedures using Dynamic SQL, UTL FILE.
- Involved in Testing (Both Unit and Integration Level) and Implementation.
- Tested the entire application in testing environment and exported to Production.
- Done the documentation and provided on-site production support.
Technologies: Oracle 9i, PL/SQL, Pro *C, SQL Plus,Visual Source Safe,Pl/Sql developer,Toad,Putty, Windows 2000 and UNIX