We provide IT Staff Augmentation Services!

Oracle Developer Resume

SUMMARY

  • Over 9 Years experience of software development life cycle experience in Software Design, Development and Implementation of SQL Server, Oracle, SQL, PL/SQL and Informatica.
  • Strong working experience in ETL, Data Analysis, Data modeling, logical and Physical database
  • Working experience in Banking, Aviation and Energy Industries.
  • Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts, Informatica mappings, Sessions and SQL Loader scripts.
  • Good understanding of oracle Data Dictionary and Normalization Techniques.
  • Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
  • Expertise in performing Data export, Import and various operations using TOAD.
  • Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, modifying database parameters.
  • Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
  • Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
  • Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL, Informatica8.6 to populate the tables in OLTP and OLAP Data warehouse Environment.
  • Involved in Production Support and troubleshooting data quality and integrity issues
  • Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
  • Used Exception Handling extensively to debug and display the error messages in the application.
  • Experience in Installing Software’s and Configuring Databases.
  • Experience in UNIX Shell Scripting.
  • Possess good communication skills and quick learning ability.

TECHNICAL SKILLS

Databases: SQL Server, Oracle 8i/9i/10g/11g, MS access

Programming Languages: C, C++, JAVA, HTML, HTML5, DHTML, Java Script, SQL, PL/SQL

Tools: and Utilities: SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad

Operating Systems: UNIX (RHEL, SOLARIS), LINUX, Windows (98/2000/XP/VISTA), DOS

ETL Tools: Informatica Power center 8.6

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow diagrams, Data Modeling, Data WarehousingSystem Integration.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

  • Gathering the requirements from Business Analysts and convert them to functional specifications.
  • Involved in complete life cycle of Software Development Life Cycle.
  • Involved in complete life cycle of ETL process to read the data form Source databases and load them to Target (Agile) Database.
  • Created/Modified oracle script - Packages, Procedures, and Functions to get data from flat files and load to Staging database and then to Target database.
  • Created Oracle tables, Indexes, Sequences to load the data to target tables.
  • Created Views/Materialized Views as per business logic.
  • Involved in Unit testing, Regression testing validate data and test the end result.
  • Create Active Batch jobs to automate the load process using Active Batch Scheduling tool.
  • Handling the trouble tickets based on priority levels.
  • Monitor Scheduled jobs during the load run.
  • Used finetune techniques in SQL -hints, bulk load, indexes and reduced the time effectively for performance loads.
  • Used Exception handling to debug and display the error messages in the application.
  • Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 12c/11g/10g, SQL Developer, SQL *Plus, TOAD, and Export/Import utility, UNIX, Windows XP, Active Batch Scheduling tool, Remedy Ticketing tool.

Confidential, Manitowoc, WI

Oracle Developer

Responsibilities:

  • Gathering the requirements from Business Analysts and converting them to Functional specifications.
  • Preparing Functional and Technical Design documents.
  • Created test cases for Unit testing, Integration testing and User acceptance testing.
  • Participated in developing architecture of staging databases and involved in designing the tables and partitioning them.
  • Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to AlCIE database.
  • Effectively used cursors, records, user defined objects, dynamic SQL, bulk loads, and exception handlers in the programming.
  • Wrote stored procedures, Functions and packages, triggers as per the business logic.
  • Created views, materialized views, sequences as per the requirement.
  • Handling the trouble tickets which come into an application from the users based on the priority level.
  • Used fine tune techniques in SQL (hints, bulk load, creating indexes etc.) and reduced the time effectively for each load.
  • Involved in scheduling automated jobs using Control-M and monitor during the load run.
  • Developed Unit test cases to validate and test the end result.
  • Used Exception Handling extensively to debug and display the error messages in the application.
  • Actively participated in Unit testing, Integration testing and Regression testing.
  • Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, SQL Developer, MCC Oracle, SQL *Plus, TOAD, and Export/Import utility

Confidential, Green Bay, WI

Oracle PL/SQL Developer

Responsibilities:

  • Gathering the requirements from Business Analysts and converting them to Functional specifications.
  • Preparing Functional and Technical Design documents.
  • Created test cases for Unit testing, Integration testing and User acceptance testing.
  • Participated in developing architecture of staging databases and involved in designing the tables and partitioning them.
  • Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to Actimize database.
  • Effectively used cursors, records, user defined objects, dynamic SQL, bulk loads, and exception handlers in the programming.
  • Wrote stored procedures, Functions and packages, triggers as per the business logic.
  • Created views, materialized views, sequences as per the requirement.
  • Implemented common auditing procedure to capture the load status for every job that occurs.
  • Developed CDC process for all account and Loan tables using hash key functionality.
  • Involved in running CDC process manually for testing purpose.
  • Handling the trouble tickets which come into an application from the users based on the priority level.
  • Extensively used informatica transformations like lookup, expression, filter, aggregator, normalizer, rank, sorter, sql, update etc.
  • Used fine tune techniques in SQL (hints, bulk load, creating indexes etc.) and Informatica (bulk loads, re-use cache, effective use of join and aggregate transformations etc..), reduced the time effectively for each load.
  • Involved in scheduling automated jobs using Control-M and monitor during the load run.
  • Developed Unit test cases to validate and test the end result.
  • Used Exception Handling extensively to debug and display the error messages in the application.
  • Actively participated in Unit testing, Integration testing and Regression testing.
  • Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, SQL Developer, SQL *Plus, TOAD, Control-M, Export/Import utility and Informatica 10.1.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to Warehouse.
  • Involved in Data Architecture and System Architecture and designed Database Tables for RDBMS system using ERWIN
  • Designed and Developed Data warehouse Admin Console
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Closely co-ordinate with the Lead in the Architecture of the data model
  • Analyzed critical/complex processes of application packages to design ETL processes and adopted strategy to prevent failures and acted swiftly to recover from application failures
  • Developed data loading plans to seamlessly automate the data loading procedures from
  • Multiple data sources (Flat files, SQL Server, Oracle) into Data Warehouses
  • Involved in test case preparation and performed UNIT Testing. Integration Testing and User acceptance Testing
  • Supported the Informatica developers in Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events
  • Creation and running of workflows and sessions in Workflow Manager.
  • Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
  • Majorly Involved in designing of Data warehouse and creating tables, Indexes, Procedures, Functions, Packages, Sequences using SQL, PL/SQL.
  • Used shell scripts for making the running procedure of mapping automated and as event based.
  • Documenting the ETL design specifications and mappings and maintaining the version control of mappings, which are changed according to the business rules.

Environment: Informatica Power Center 8.6, Oracle 8i, SQL, PL/SQL, and UNIX

Hire Now