We provide IT Staff Augmentation Services!

Sr.oracle Developer Resume

4.00 Rating

Nashville, TN

SUMMARY

  • More than 8 years of experience in Application Development using Oracle PL/SQL.
  • Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
  • Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling.
  • Good Knowledge on Oracle Architecture and Database Design.
  • Excellent conceptual knowledge of Oracle10g/11g, PL/SQL and SQL.
  • Experience in different phases of Oracle Applications Implementation life cycle including Technical Design, Data Conversion, Oracle Forms development, Oracle report development, Unit Testing, Integration Testing, End User Training, Production Support.
  • Experience in designing business requirements and modeling using oracle designer.
  • Experience in developing External Tables, Joins, Indexes and sequences.
  • Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
  • Extreme Use of Exception Handling methods
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5.
  • Good experience in Oracle Forms and Reports.
  • Participated in collecting the requirements, analyzing the System Requirements.
  • Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
  • Experience with Data Modeling using ERWIN 4.0/3.5.2, SQL Server, Toad data modeler.
  • Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
  • Extensive experience in developing complex mappings with Custom Transformations.
  • Experience in Performance Tuning of sources, targets, mappings and sessions.
  • Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
  • Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
  • Good experience working on End - To-End implementation of data warehouse and strong understanding of Data Warehouse Concepts, ETL, Star schema, Data Modeling, experience using Normalization, Business Process Analysis, Reengineering, Dimensional Modeling, FACTS &Dimensions tables

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g.

Scripting: UNIX, PERL.

Languages: SQL, PLSQL, HTML, UNIX, JAVA.

Tools: SQL Developer, TOAD, SQL plus, SQL Navigator, Informatica.

OS: Windows 7, Windows XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr.Oracle Developer

Responsibilities:

  • Worked with the Business analysts, Business and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Developed procedures, functions, packages, views, and materialize views etc to meet the business requirements.
  • Involved in daily monitoring of EDI transactions, troubleshooting and fixing them.
  • Data loaded from flat file sources using PL/SQL and SQL*Loader.
  • Modified existing/created new PL/SQL blocks for doing the validations on data and to generate response to the trading partners accordingly to meet the technical specifications.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Used UTI FILE PACKAGES for creating/opening of files.
  • Used oracle utility DBMS UTILITY for the compilation of Invalid objects like packages, functions, procedures, triggers etc.
  • Performing DML operations for daily activities.
  • Developed database objects: tables, views, procedures, packages and other database objects using Oracle tools like SQL* Plus, SQL*Developer and TOAD for Oracle.
  • Extensive use of performance tuning by creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
  • Improved execution of queries by using Bulk Collections, Indexes, and Materialized Views.
  • Developed re-usable transformations, mappings and Mapplets conferring to the business rules.
  • Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
  • Updated the mappings according to the changed requirements.
  • Creation of Sessions and executing them to load the data from the source system using InformaticaWorkflow Manager.
  • Developed and documented Data Mappings/Transformations, and Informatica sessions as per thebusiness requirement.
  • Involved in modification/troubleshooting of batch jobs to meet the requirements and scheduling tasks.
  • Coordinated with all the stake holder involved for the quick resolution of issues and also providing technical solutions to the client.
  • Documented recurring issues and it's fixes to avoid delays.

Environment: Oracle 11g/10g, SQL, PL/SQL, Informatica, TOAD for Oracle 12.7, SQL*Loader, UNIX Shell script, Windows XP/2003, Oracle forms and reports 10g, Windows Task scheduler.

Confidential, Raleigh, NC

Sr.PL/SQL Developer

Responsibilities:

  • Participated in project planning sessions with business analysts and team members to analyze business IT Requirements and translated business requirements into working model.
  • Worked extensively on Data migration for new merchant acquired by First Data from the competitors.
  • Custom reports generation based on the requirements.
  • Involved in Initial designing and developing web pages for various requirements.
  • Generation of reports and analysis.
  • Enhancements in existing reports and PL/SQL blocks.
  • Extensive use of performance tuning.
  • Usage of Unix commands for transferring files to merchants.
  • Using import and export utilities for large data transfer.
  • Worked with Business in full development life cycle for Prepaid Business project. And involved in developing procedures, functions, packages, triggers, views, and materialize views etc.
  • Created and ExecutedWorkflowsandWorkletsusing Workflow Manager to load the data into theOracle Database.
  • Developed re-usable transformations, mappings and mapplets confirming to the business rules.
  • Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
  • Designed ER diagram using Erwin, to set the logical and physical relationships of database.
  • Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, Informatica Power Center 8.6, SQL*Loader, UNIX Shell script, TOAD, UNIX, Windows XP/2000.

Confidential, Franklin Lakes, NJ

Sr. PL/SQL Developer

Responsibilities:

  • Handling the data requests from multiple clients.
  • Handling complex SQL scripts for data retrieval.
  • Generating files based on daily requests.
  • Using UNIX for file transfer to client side.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Performing DML operations for daily activities.
  • Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems using PL/SQL and SQL*Loader.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
  • Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
  • Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD.

Confidential

Sr. PL/SQL Developer

Responsibilities:

  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Created SQL*plus reports as per client's needs, and developed business objects.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/SQL blocks and even have experience with exception handling..
  • Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, JAVA, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, Windows XP/2000.

Confidential 

Sr. PL/SQL Developer

Responsibilities:

  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Created SQL*plus reports as per client's various needs, and developed business objects.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Created Indexes and partitioned the tables to improve the performance of the query.
  • Involved in SDLC including designing, coding and testing.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval frommultiple tables.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Ordacle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

We'd love your feedback!