We provide IT Staff Augmentation Services!

Oracle Sql & Etl Developer Resume

0/5 (Submit Your Rating)

Kansas City, KS

SUMMARY

  • More than 6 years experience wif proven ability in the area of Client/Server and Distributed Multi - tier Application Development, Data modeling, Database Design, Data processing, Data Warehouse and Support mainly using Oracle technology on different platforms.
  • More than 6 years proven experience in PL/SQL dat includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
  • Over 5 years experience in Oracle data warehousing and Business Intelligence: Data modeling in dimensional structures - Star/Snowflake schema, ETL, OLAP, OLTP, VLDB (very large application).
  • Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
  • Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
  • Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
  • Use Obiee for different Business Intelligence OLAP report purpose.
  • Proficient in using UNIX and Shell Scripting.
  • Experience in Advance Queue
  • Experience in Data flow Diagram, ER Diagrams using Oracle designer.
  • Exclusively followed all phases of System Development Life Cycle (SDLC) and Best Practices.
  • Strong interpersonal skills, ability to interact wif people at all levels. Good communication and presentation skills.

TECHNICAL PROFICIENCY:

Languages: SQL, PL/SQL, SQLPLUS

RDBMS: Oracle 11g/10g/9i/ 8i, MS SQL Server, Ms-Access

Business Intelligence Tool: OBIEE 10.1.3.4.1

Modeling: Visio, Oracle designer

ETL: SQL, PL/SQL

Other Tools: TOAD 8.0/8.5/9.0, SQL Developer, SQL Navigator, XML, iSQL, PVCS, FTP

Operating Systems: Sun Solaris, HP-UX, AIX, Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, KS

Oracle SQL & ETL Developer

Responsibilities:

  • Experience in Data modeling and Dynamic SQL.
  • Writing Unix Shell l Scripts to load the data as per the Business functionalities.
  • Involved in fixed assets interface creation from JDE system to oracle e business suites. Fixing the interface issues.
  • Applied Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
  • Working on order Management conversions.
  • Interacted wif the user group on a regular basis to discuss requirements and updates.

Environment: Oracle Applications SQL, PL/SQL, SQL*Loader, Oracle, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology..

Confidential, Plano, TX

Oracle PL/SQL Developer

Responsibilities:

  • Designed and created complex PL/SQL code for the ETL Converting/Migrating data from Mainframe, DB2 and Flat files into Oracle database tables for Data warehousing and BI purpose.
  • Utilized business rules for data profiling, data analyzing and cleansing.
  • Extensively Works wif merging three large Data integration and Business Intelligence Project for Home Finance.
  • Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
  • Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
  • Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
  • Prepare Proper Documentation and Decode Mapping for further upgrade of code.
  • Created Complex SQL script, Dynamic SQL, Analytical function.
  • Works wif performance tuning issues for multi terabyte Database.
  • Used Normalization and Denormalization in Database.
  • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
  • Experience in Oracle Report.

Environment: Oracle Database 11g, 10g, DB2, VISIO, TOAD 9.7, Business Intelligence (BI), Mainframe, UNIX, Oracle RAC, PVCS

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

  • Created data warehouse objects - Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures wif parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading (PEL).
  • Converting/Migrating data from SQL Server, XML and Flat files into Oracle database tables for Data warehousing and BI purpose, designing and creating OWB mappings, process flows for the ETL.
  • Utilized business rules for data profiling, data analyzing and cleansing.
  • Created PL/SQL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse.
  • Prepared shell scripts for ETL to run in batch.
  • Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
  • Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
  • Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
  • Writing Complex SQL script, Analytical Function.
  • Improved query performance by query optimization - tracing the query execution plan (explain plan).
  • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.

Environment: Oracle Database 10g, Oracle Warehouse Builder 10g R2 OWB),Erwin, Oracle 10g Developer Suite, Oracle Application Server 10g, TOAD, Business Intelligence (BI), Oracle Discoverer 10g, Oracle Reports, HP-UX.

NRECA, Arlington, VA

Oracle PL/SQL Developer

Responsibilities:

  • Created Custom Packages, Stored Procedures, Function and SQL Scripts to load data into Data warehouse from different sources clean and transform data to provide quality information, and manage corporate metadata.
  • Created/updated ETL procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts wif Business Intelligence reporting layers using Oracle Warehouse Builder.
  • Prepared/updated shell scripts for ETL to run in batch.
  • Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.
  • Utilized business rules for data profiling, data analyzing and cleansing.
  • Created Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.
  • Heavy SQL tuning for performance improvement.
  • Load Data monitoring of the pharmacy data warehouse scheduled jobs and support.
  • Design Data Conversion/Interface wif the use of SQL*Loader and convert data.
  • Writing Unix Shell Scripts to load the data as per the Business functionalities.
  • Provide adequate documentation on unit testing.
  • Support the implementation of the project and address any post implementation defects.

Environment: Oracle Database 10g R2, Visio, Oracle 10g Application Server, TOAD, Oracle Reports, Sun Solaris/UNIX.

Confidential, Dearborn, MI

Oracle Data Modeler

Responsibilities:

  • Created staging area for accumulating periodical data from various data sources include Data mart creation, Extracting data from different source, Transformation data in the Staging area and load data into the Fact table.
  • Actively participated in the team for the purpose of defining project scope, sizing & technical design to establish technical direction regarding technology, platforms & development tools, development standard and guide lines.
  • Writing Complex SQL script, Analytical Function using packages, procedures, functions and database triggers.
  • Utilized business rules for data profiling, data analyzing and cleansing.
  • Used aggregate routines for views, summary tables, materialized views, reports etc.
  • Applied Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
  • Code for Fact and Dimension table population using SQL, PL/SQL.
  • Data Modeling using ERWIN.
  • Use SQL Loader and External Table for data Load.
  • Work wif Business Object Developer.

Environment: Oracle Database 10g, Oracle Warehouse Builder 10g (OWB), Visio, TOAD, Business Intelligence (BI), Linux.

We'd love your feedback!