Oracle Pl/sql Developer Resume Profile
Irving, TX
SUMMARY:
- Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling Logical and Physical , and Implementation of Business Applications using the Oracle Relational Database Management Systems.
- Extensively worked in Client-Server application development using Oracle 11g/10g/9i, SQL SERVER CE, FORMS 10g/6i, REPORTS 10g/6i, Oracle Import/Export Utilities.
- Experience in PL/SQL programming developing packages, stored procedures, triggers and functions in Oracle database.
- Extensive experience with various states of Software Development Life Cycle, including requirements gathering amp analysis, development, unit testing, QA testing, production migration, and production support.
- Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF.
- Experience with Data Modeling using ERWIN 4.0/3.5.2, SQLServer, MSAccess, SQL, PL/SQL, SQL Plus, Toad, and MS SQL Server, Query Analyzer.
- Proficient in PL/SQL programming Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects Tables, Views, Materialized Views, Triggers.
- Experience of work in AGILE development environment by making customer satisfied by rapid delivery of useful software and welcoming changing requirements, even late in development.
- Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.
- Good Understanding of GUI using JavaScript, HTML, DHTML, XML,COLD FUSION 8.0
- Used Advanced PLSQL concepts, PL/SQL tables and Dynamic SQL for DML operations for better performance.
- Extensively worked on the Extraction, Transformation and Load ETL process using PL/SQL to populate the tables in database using DB Links.
- Strong Data Cleansing experience using PL/SQL, SQL Coding, and UNIX Shell Scripting.
- Proficient in Oracle Tools and Utilities such as SQL Loader, Import/Export, TKPROF and SQL Navigator v.4.5.
- Experience with DBA activities like creating Tablespace, granting and revoking privileges on database objects.
- Hands on extracting source data and loading it into target using INFORMATICA.
- Expertise in Tuning of Procedures, Oracle Reports developer Oracle developer suite 10g/AS
- Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL Trace and Table partitioning.
- Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler package DBMS PROFILER , explain plan, auto trace.
- Participated in collecting the requirements, analyzing the System Requirements.
- Proficient in Microsoft Office Suite to include PowerPoint, Visio, Project, SharePoint and Access
- Experience in Installing Software's and Configuring Databases.
TECHNICAL SKILLS:
Databases: Oracle 10g, 9i, 8i, SQL server 2000/2005.
Operating Systems: Windows XP/ NT/2000/Windows 7, UNIX
Tools/Utilities: SQL Plus, SQL Loader, SVN, Telerik WebUI test studio, SoapUI, QTP, CodedUI, Bugzilla, MS Office, MS Excel
Languages: SQL, PL/SQL, MYSQL, PHP, JAVA, UNIX Shell Script,
Database/Development tools: TOAD, SQL Plus, SQL Loader, Work-flow, SQL Navigator. D2K Forms amp Reports Builder 6i/10g
Case Tools: Rational Rose
Scripting/markup languages: UML, HTML, JavaScript, XML
GUI: Oracle Pl/SQL Developer Suite, Reports 9/10
PROFESSIONAL SUMMARY:
Confidential
Role: Oracle PL/SQL Developer
Environment: Oracle9i/10g, TOAD, SQL Loader, Windows XP, UNIX, Erwin.
Responsibilities:
- Understanding Account Aggregation and Asset Classification, Bonds, Stock, Mutual Funds and other financial domain terminology.
- DesignedTechnical Design Documents based on business requirements and followed standards designed by the company.
- Involved in the design and implementation of the process for loading the monthly loads coming from S P into staging tables in the Oracle Database using Shell scripts.
- Developed packages for processing data in the staging tables according to the Clients requirements
- Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
- Used Refcursors and Collections for accessing complex data resulted from joining of large number of tables.
- Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Optimized existing queries for better performance and less impact on database.
- Used Materialized views in places where the data does not change very frequently.
- Created various UNIX Shell Scripts for scheduling and loading process.
- Maintained the batch processes using Unix Shell Scripts.
- Validated customer credits and adjustments by writing procedures.
- Identified undefined accounts, invalid transaction and handled them through exceptions.
- Extracted source data and loaded into target after applying required transformation using INFORMATICA.
- Worked on workflow creation and verifying records through INFORMATICA
Confidential
Role: Oracle PL/SQL Developer
Environment: Oracle10g, Oracle FORMS/REPORTS 10g , Designer10g,APEX 4.1, TOAD, Oracle ApplicationServer 9i and UNIX Shell Scripting.
Responsibilities:
- Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
- Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
- Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
- Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
- Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
- Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
- Generated Oracle FORMS and REPORTS using Designer 6i.
- Designed and Developed Reports using Oracle Discoverer 9i.
- Improved Performance of Discoverer Reports using Materialized views.
- Developed UNIX Shell Scripts for Autonomous Jobs.
- Experience in developing logical and physical database design, data modeling using Erwin.
- Designed, Developed and Tested application in UAT environment and Deployed in Production.
- Provided Productions supports and ongoing user supports for the application.
- Used APEX 4.1 in building some of the data intensive websites.
- Some of the common web applications used in the web browsers are done using APEX 4.1
- Designed Development Documentation and Support Documentations.
Confidential
Roles: Oracle Pl/Sql Developer
Environment:Oracle 10g, SQL, PLSQL, SQL Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.
Responsibilities:
- Created SQL Loader control files for loading the data from flat files to staging area tables.
- Worked on designing and developing a data warehouse for providing business intelligence on the data gathered by the OLTP server.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Involved in the Analysis, Design, Coding and Testing of the application.
- Developed SQL scripts to create database objects like tables, views and sequences.
- Used SQL Loader to load bulk data from various flat files.
- Developed SQL and PL/ SQL scripts for migration of data between databases.
- Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
- Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
- Developed complex triggers in reports before/after for validation of user input.
- Designed and developed user interfaces using Oracle Forms 10g.
- Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
- Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
- Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
- Developed UNIX shell scripts in VI Editor with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
- Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
- Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
- Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.
Confidential
Role: PL/SQL Developer
Environment: Windows XP, Oracle 9i, UNIX shell scripting, SQL Plus, SQL Developer, Java, JDK, JSP, JMS,JDBC, HTML, XML.
Responsibilities:
- Analyzed database design requests and Created databases according to client needs
- Developed PL/ SQL modules such as Packages, Triggers, Procedures and Functions.
- Heavily involved in Performance Tuning at the application level.
- Developed Front end using SERVLETS, JSCRIPT and HTML
- Developed the backend using Servlets, Java Beans and JDBC.
- JMS messaging method is used for communication between software applications
- Extensively utilized XML and SOAP for the data transfer between web clients and server
- Developed UNIX Shell scripts that will interact with the PL/ SQL Objects.
- Documented and performed unit testing for all components prior to migrating them to production.
- Maintained existing applications.