We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

Ramsey, NJ

SUMMARY:

  • A results - oriented software engineer with around 8+ years of experience in database analysis, design, application development, implementation and production support activities in a Client/Server environment with a core competency in Oracle developer forms/reports, crystal reports and support experience in Unix and Windows.
  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance
  • Expert in the development of PL/SQL Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
  • Proficiency in data warehousing techniques for Data Profiling, Change Data Capture, Data Cleansing, Dimension phenomenon, surrogate key assignment.
  • Proficient in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
  • Expert knowledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 3.5.
  • Extensively worked with Data Stage PX for extracting data from legacy systems to stage and then to cleanse, process and loading into data marts and data warehouse.
  • Expertise in using oracle streams for site to site replication.
  • Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes
  • Experience in using Composite Data Types in Oracle.
  • Proficient in all DBA related responsibilities such as user management (synonyms/privileges, roles, quotas, table, table partitioning, index, sequence), space management (table spaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity)
  • Expertise in working with Oracle TOAD, SQL Navigator, SQL * Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications.
  • Knowledge in schema structure design and involved in estimation and optimization of data storage Experience in utilizing Oracle tools and methods like the use of External Tables, Pipelined functions.
  • Experience in migration and conversion from Flat Files/MS Access/SQL-Server to Oracle usingOracle SQL* Loader
  • Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Well-versed in using tools like SQL*Plus, SQL Developer and TOAD.
  • Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g)
  • Expertise in using PVCS (VM and Tracker) tools and also CollabNet Subversion Edge to handle the version control system.
  • Expertise in using Atlassian JIRA, CRUCIBLE, FISHEYE for project tracking, teams planning and also reviewing and commenting the code base.
  • Involved in review and gap analysis of Functional Requirement documents.
  • Creation of Technical Documents and related Test Case Document.
  • Expertise in fixing software bugs and problems quickly and effectively.
  • Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents.
  • Creation of Technical Documents and related Test Case Document.
  • Great learning skills to adapt the rapid changing technologies and implementing the same at work.
  • Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS:

Databases: SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

Operating Systems: DOS, Windows 2000/NT/XP, Vista, 7 Sun, AIX, UNIX, LINUX

Languages: SQL, PLSQL, PRO*C, C, C++, Java

Scripting Languages: JavaScript, JQuery, Perl, HTML, PHP, XML, ANT scripting, UNIX shell scripting

GUI's Technologies: Oracle Forms and Reports 10g/9i/6i, Oracle Designer 2000, Crystal Reports 9/10, Discoverer10g, Erwin … ODI, J2EE (Servlets, JSP, JSF, JDBC), Oracle APEX

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, Toad, Oracle Sql Developer, SQR, UTL File, ETL tools Informatica Power Center, OEM, Datastage

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point, MS-Vi

WORK EXPERIENCE:

Sr. Oracle Developer

Confidential, Ramsey, NJ

Responsibilities:

  • Created heavy stored procedures for financial transactions by using procedural parameters & working with packages, blocks & exception handling.
  • Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
  • Extensively mapped data and migrated to a new built instance using various developer tools and prepared conversion mapping documents for .
  • Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
  • Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
  • Extensively used PLSQL tables and Bulk loader programs for processing data and loading intooracle.
  • Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
  • Create Execute and Optimize SQL queries while providing an interactive community to support the user experience by using TOAD.
  • Used SQL*Loaders to download the data into database from the text files and spread sheets.
  • Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracletemp tables for day to day customer financial transaction reconciliation.
  • Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
  • Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
  • Worked on creating Materialized Views to maintain copy of the remote data at local node.
  • Solving the complicated run time errors while running the process along with DBA team members.
  • Involved in supporting/fixing production defects and day to day business transaction issues.
  • Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
  • Developed various reports from scratch utilizing Oracle Reports Builder for day to day validations.
  • Created various adhoc reports as of when required for the production analysis and issue fixing.
  • Constant interaction with Java Developers for tuning of SQL statements, embedding them in Java code using SQL and for unit testing and other test sequence comparisons
  • Create database partitions on the tables to improve the performance

Environment: Oracle Database 10g/11g, Toad, SQL*Plus, SQL*LOADER, UNIX, Forms11g, Reports 10g, UNIX & Shell scripting.

Sr. Oracle Developer

Confidential, Ohio

Responsibilities:

  • Created new Schemas, Tables, Synonyms, Views, Indexes, Partitions and Sequences needed as per new requirements.
  • Extensively worked on data mapping, validation, SQL loader and Control file creation, Bulk processing for loading data into Oracle database.
  • Tuned the SQL queries and complex procedures to improve performance. Used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
  • Developed various database objects like views, packages, stored procedures, triggers, functions etc using TOAD.
  • Developed SQL*Loader scripts to load the data from external flat files that are exported from SQL Server.
  • Migrated forms from 6i to 11g, by recompiling and modifying the code as needed to support the complex functionality embedded.
  • Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
  • Modified and optimized complex queries for data retrieval and modification.
  • Involved in XML parsing and loading XML files into the database.
  • Involved in using of features of Oracle 11g like Analytical functions, Flash back Query, regular expressions etc. Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement.
  • Used UTL FILE package for writing DBMS OUTPUT messages to file.
  • Used an in house defect tracking tool and Clear Case for defect tracking.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
  • Uploading the Test cases, Manual Test Scripts, Codes and Specification Documents on Visual Source Safe (VSS) for version controlling.
  • Worked on UNIX environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API's Using PEARL Scripts.
  • Involved in providing 24/7 database production support and troubleshooting data quality and integrity issues.
  • Actively involved in transforming the business requirements in to system requirement specifications and creating functional design documents.
  • Writing and tuning SQL Queries, PL/SQL Stored Procedures, Functions and Triggers
  • Identify deficiencies of the business application and constant data integration using Java components, SQL and PL/SQL
  • Identify stakeholders need to modify the component and the database layouts (design) and to create custom database tables
  • Oracle PL/SQL Functions, Procedures, Korn Shell Scripts were used for staging transformation and loading of the data from flat files to target.
  • Worked on SQL Tuning with Query optimization techniques for SQL statements.
  • Extensively worked on Performance tuning by using Explain plans and various hints.
  • Creating Materialized Views for replication of the actual data present over a DB Link.
  • Prepared Test Plans for various functionalities developed and assisted the testers in creation of test scripts that are used in testing the Oracle stored procedures.
  • Involved in Defect Prevention activities like identifying the root cause of major defects and raise change requests in HP Quality Center.
  • Worked on requirement analysis for Change requests and fixed the defects raised by the user community and other stakeholders.
  • Carried out extensive Unit testing and Integration testing of the system and created Unit Test Plan (UTP) and Unit Test Results (UTR) documents.
  • Detected and corrected bugs during system integration and User Acceptance Testing (UAT)

Environment: Oracle Database 9i/11g, Oracle Forms 6i/11g, Oracle Reports 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, .Net, DTS, TOAD, Clear Case, VSS, UNIX.

Oracle Developer

Confidential, Hoboken, NJ

Responsibilities:

  • Involved in the analysis, design, coding and testing of the application.
  • Analyzed and modeled data for Logical to Physical Data models using ERWIN.
  • Created tables, indexes and Materialized views and also database triggers for data integrity maintainability.
  • Created Oracle schema i.e., tables, indexes, constraints, triggers, synonyms, database links, roles etc. in development database.
  • 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.
  • Customized and developed several forms using CUSTOM.PLL and TEMPLATE.FMB to meet client's requirement.
  • Used UTL FILE built - in package to generate files as per the requirement.
  • Extracted data from various sources like SQL Server, DB2, flat files, Excel spreadsheets, Oracleand XML files and loaded into the oracle database
  • 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 User Acceptance Test with business users.

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

Oracle Developer

Confidential, Camp Hill, PA

Responsibilities:

  • Created Stored Procedures and tuning SQL for maximum performance.
  • Created new Tables, Indexes and Sequences where needed.
  • Wrote procedures to calculate calendar year returns & trailing year returns both Annualized & Compounded.
  • Created Oracle schema i.e., tables, indexes, constraints, triggers, synonyms, database links, roles etc. in development database.
  • Extensively used BULK SELECTS and BULK INSERTS in migration stored procedures for enforced data migration.
  • Created normal views and materialized views where business requirements needed.
  • Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
  • Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
  • Used SQL Navigator, a popular tool which increases user productivity and application code quality to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
  • Documented changes and enhancements in code.
  • Communicated issues and progress to project manager.
  • Data migration and conversion done utilizing Oracle Export & Import utility.
  • Developed packages for processing data in the staging tables according to the Clients requirements.
  • Used SQL*Loader to load data into different tables.
  • Verified the data in addition to re - designing the database, front end using Forms 4.5 and Reports 2.5.
  • Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
  • Involved in solving day-to-day problems, giving support to the users.
  • Involved in production support and maintenance.

Environment: Oracle 9i, Forms 6i, Reports 6i, PL/SQL, SQL*Plus, Exp/Imp, UNIX, Quality Center, Windows XP.

Oracle Developer

Confidential, Atlanta, GA

Responsibilities:

  • Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
  • Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
  • Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
  • Wrote SQL scripts to create temporary tables and developed SQL*Loader Control files to load the data into the temporary tables.
  • Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
  • Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
  • Involved in analyzing business requirements and designing the functional specifications and also translated functional requirements into technical specs.
  • Extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
  • Used SQL*Loader to upload data into the staging files from flat files.
  • Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
  • Used UTL FILE built - in package to generate files as per the requirement.
  • Wrote complex in-line views which summarized the business needs to the fullest.
  • Wrote complex SQL queries, Control files, Procedures, Triggers and PL/SQL Packages used for data validations, error handling and data cleansing activities.
  • Used Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Loader, TOAD, Forms and Reports 9i, MS Visio, UNIX and Windows NT.

Oracle, PL/SQL developer

Confidential, Menlo Park, CO

Responsibilities:

  • Involved in the complete life cycle of the product from requirements gathering to end of system testing.
  • Created PL/SQL Packages, Procedures, Function and Triggers.
  • Worked on developing a financial application system to handle all the bank transactions.
  • Used SQL*Loader to load the database from flat files.
  • Performed SQL performance tuning using Explain plan, Trace utility & TKPROF.
  • Designed and developed data validation, loading and testing process using PL/SQL Stored Procedures, Functions and Database Triggers.
  • Developed Menus, PL/SQL Libraries and Object Libraries extensively for code reusability and standardization.
  • Worked on Table Partitioning (Range and List) and deploying Local Indices on partitioned tables.
  • Implemented Performance Tuning by creating Indexes, executing EXPLAIN PLAN on SQL Scripts and using Optimizer Hints if necessary for faster retrieval.
  • Performed the uploading and downloading flat files from UNIX server using FTP.

Environment: Oracle 9i, SQL, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator Forms and Reports 4.5i, UNIX, Win XP.

Database Developer

Confidential

Responsibilities:

  • Prepared program Specification for the development of PL/SQL procedures and functions.
  • Created Custom Staging Tables to handle import data
  • Created custom triggers, stored procedures, packages and functions to populate different database
  • Developed SQL* loader scripts to load data in the custom tables
  • Run Batch files for loading database tables from flat files using SQL*loader
  • Created UNIX Shell Scripts for automating the execution process
  • Created indexes on tables and Optimizing Stored Procedure queries
  • Design, Development and testing of Reports using SQL*plus
  • Created Indexes and partitioned the tables to improve the performance of the query
  • Involved in preparing documentation and user support documents
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000

Hire Now