Oracle PL SQL Developer - Information Technology Resume Search
Oracle PL SQL Developer - Information Technology Resume Search
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Oracle PL/SQL Developer Resume


Desired Industry: Information Technology SpiderID: 67229
Desired Job Location: Santa clara, California Date Posted: 2/12/2013
Type of Position: Contractor Availability Date: 2/12/2013
Desired Wage:
U.S. Work Authorization: Yes
Job Level: Experienced with over 2 years experience Willing to Travel: Yes, Less Than 25%
Highest Degree Attained: Masters Willing to Relocate: Yes


Objective:
 Over 7+ years of experience in analysis, design, development and deploying Business solutions using Oracle Technologies.
 Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
 Extensively worked on Data modeling and design (Data Architect) using SQL Developer Data Modeler and ERWIN .
 Excellent track record in the implementation of business applications and in using RDBMS OLAP, OLTP and OOPS Concepts and effective utilization of the technologies viz. Oracle Database, TOAD and SQL Navigator.
 Design of data models and objects including Tables, Views, and User defined Functions, Triggers and Stored Procedures for applications.
 Experience in migration and conversion from Flat Files/MS Access/SQL-Server to Oracle using Oracle SQL*Loader and PL/SQL interfaces.
 Extensive experience in Oracle Back-end PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers using SQL Developer, Toad and SQL Tools as development tools.
 Experience in Dynamic SQL, Records, and Exceptional handling.
 Extensive experience in developing applications using Oracle database 11g/10g/9i/8i, on Windows/Unix/Linux Environment.
 Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace & TKPROF utilities.
 Experience in Query optimization & Performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor.
 Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes.
 Strong knowledge of UNIX Shell Script on Sun Solaris and HP UNIX.
 Worked on Bash and KORN Shell Scripts to write maintenance script for Oracle.
 Worked closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
 Proven leadership skills with experience in various industries like Banking, Insurance and corporate finance in multinational environments
 Energetic, highly motivated individual, with excellent Analytical and Communication skills (Oral and Written), an effective team player and team builder.


Experience:

American Modern Insurance Group, Amelia, OH Sep. 2011-Till Date
AMIG’s business is specialty insurance. With more than 45 years of insurance experience, AMIG delivers specialized products and services for residential property that does not need an HO-3 (Homeowners insurance coverage) policy or that does not qualify in the standard market because of value, locations, etc.., My work was to load the data into an oracle data warehouse database using PL/SQL

Responsibilities:
 Involved in analysis, design and documentation.
 Involved in Extraction Transformation and Loading (ETL) process for populating the data into the database.
 Designed and created tables, sequences, indexes, views and materialized views.
 Created Custom Staging Tables to handle import data.
 Involved in the development of Functions, Procedures, and Packages to transfer data into the database tables.
 Used SQL*Loader to download the data into database from text files and spread sheets.
 Used Oracle loader to load data into external tables.
 Created indexes to large tables for tuning and wrote SQL scripts utilizing indexes for better performance.
 Development of Database level triggers to update data into multiple tables.
 Trouble shooting performance issues using Explain Plan and TKPROF.
 Optimized and tuned PL/SQL subprograms to reduce the loading process.
 Developed and modified existing reports in Oracle Reports.
 Developed Reports using complex queries as per client request as a part of production support.
 Developed Object Libraries to maintain standards in Forms.
 Wrote Shell Scripts for the automation of several processes.
 Created test scenarios for the developed code and distributed across to the QA along with knowledge transfer and work flow documentation.
 Involved in the User Acceptance Test with the business users.



Environment:
Oracle 10g/11g, SQL, PL/SQL, SQL*PLUS, Forms and Reports 10g, TOAD, SQL Developer,
SQL*Loader, Version Control Software CVS, UNIX Shell Scripts, Windows XP.


Cengage Learning, Boston, MA Dec. 2010 – Aug. 2011

Cengage learning is a leading publishing company which provides solutions for academic, professional and library markets worldwide. One of the major products in Cengage is SAM 2010. SAM 2010 is a web-based software application which measures user’s proficiency in Microsoft Office 2010 Suite as well as Internet Explorer 9 and Windows 7. The software is used as an effective tool in schools worldwide both by professors and students which give great leverage for the professors to schedule weekly, quarterly and yearly assignments well in advance and also retrieve the results of the assignments taken by the students, the entire assignment scheduling and results retrieving process is stored and managed through a centralized oracle database server.

Responsibilities:
 Involved in the analysis, design, coding and testing of the application.
 Analyzed and modeled data for Logical to Physical Data models using SQL Developer Data Modeler.
 Created tables, indexes and Materialized views and also database triggers for data integrity maintainability.
 Involved in writing Technical and Functional Design Documents.
 Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
 Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
 Used UTL_FILE built-in package to generate files as per the requirement.
 Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
 Developed Reports in 10g and also developed spreadsheet reports using packages.
 Created UNIX Shell scripts for automating the execution process.
 Conducted extensive performance tuning using TKPROF and pipelined table functions.
 Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
 Involved in Unit testing and also wrote Test Cases for testing all kinds of oracle objects.
 Involved in User Acceptance Test with business users.
 Responsible for troubleshooting the errors that occurred when the production group hit a roadblock.

 Developed Reports using complex queries as per client request as a part of production support.
 Involved in the continuous enhancements and fixing of production problems.
 Used PVCS (VM and Tracker) tools to handle the version control system.

Environment:
Oracle 10g/11g, SQL, PL/SQL, SQL*PLUS, Forms and Reports 10g, TOAD, SQL Developer, SQL*Loader, Version Control Software CVS, UNIX Shell Scripts, Windows XP.


Kinder Morgan Energy Inc., Houston, TX May 2009 – Nov. 2010

Kinder Morgan is the largest midstream and the third largest energy company (based on combined enterprise value) in North America. We own an interest in or operate approximately 75,000 miles of pipelines and 180 terminals. I was involved in the EP2DART project, which is a conversion project, which helps in migrating data from EL PASO to DART.

Responsibilities:
 Designed the Data Modeling and normalized the data structure.
 Created the databases Tables and implemented the data integrity validation checks through constraints and triggers.
 Responsible for analyzing tables and indexes from time to time to keep the STATS up-to-date.
 Involved in reviewing Functional design documents and prepared Technical design documents.
 Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
 Designed and developed the interface program to load the item cost from a legacy system into item master using SQL*Loader, PL/SQL package through Open Interface.
 Involved in developing packages for implementing business logic through procedures and functions.
 Extensively used UTL_FILE packages to generate files as per requirements.
 Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
 Designed and developed GUI front-end applications using Oracle Forms for user interaction with the database.
 Developed and modified existing reports in Oracle Reports.
 Developed various UNIX Shell Scripts to automate the routine tasks.
 Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning.
 Responsible for Performance Tuning, Optimizing SQL and PL/SQL scripts.
 Maintaining different version of software (version control) using CVS.
 Involved in Production Support and troubleshooting data quality and integrity issues.


Environment:
Oracle 10g/11g, SQL, PL/SQL, SQL*PLUS, Forms and Reports 10g, Toad, SQL*Loader, MS Visio, UNIX Shell Scripting, WINDOWS XP.


TD Bank North Inc., Lewiston, ME Nov. 2008-Apr. 2009

TD Bank North Inc. is a leading and financial services company headquartered in Portland, Maine and a majority-owned subsidiary of TD Bank Financial Group. TD Bank north, N.A. provides a full line of retail and commercial products and services for customers in Connecticut, Maine, Massachusetts, New Hampshire, New Jersey, New York, Pennsylvania and Vermont.

Responsibilities:
 User interaction, requirement analysis, functional specification, design, development and implementation.
 Designed UML models (Visio) and Relational data models for applications.
 Involved in developing DB objects like tables, triggers and Views.
 Involved in the development of Functions, Procedures, and Packages to transfer data into the database tables.
 Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
 Wrote SQL, PL/SQL, programs to retrieve data from the flat files which are outputs of SQL Server.
 Transferred data from flat files into the database tables using SQL* Loader.
 Extensively used IMPORT utility to load the exported files.
 Developed Forms, Reports, Menus, Object Libraries, and the PL/SQL Library using Oracle Forms 9i.
 Automated data loading, extraction and report generation using UNIX Shell Scripting.
 Carried out Performance Tuning of critical SQL queries to avoid Full Table Scans.
 Fine-tuned the performance of database using EXPLAIN PLAN and TKPROF
 Used Partitioning and Bulking techniques to further improve the performance while accessing tables containing large number of columns and rows.
 Involved in Extraction Transformation and Loading (ETL) process for populating the data into the database.
 Involved in Unit Testing and preparing test cases for User Acceptance Test.
 Responsible for the Production Support and Code Fixing.


Education:
Bachelor’s in Computer Science – TRIBHUVAN UNIVERSITY


Skills:
Technical:
Oracle 8i/9i/10g/11g, SQL, PL/SQL and UNIX shell scripting, C, C++, Java, XML, TOAD, SQL Navigator, SQL*PLUS and PL/SQL Developer, Windows 2000/NT/XP, Windows 95/98, UNIX, LINUX, Microsoft Office Suite- MS-Word, MS-Excel, MS-Power point, SQL*Loader, MS-Visio, ERWIN, Visual Studio.


Additional Information:
Technical:
Oracle 8i/9i/10g/11g, SQL, PL/SQL and UNIX shell scripting, C, C++, Java, XML, TOAD, SQL Navigator, SQL*PLUS and PL/SQL Developer, Windows 2000/NT/XP, Windows 95/98, UNIX, LINUX, Microsoft Office Suite- MS-Word, MS-Excel, MS-Power point, SQL*Loader, MS-Visio, ERWIN, Visual Studio.


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2019 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links