We provide IT Staff Augmentation Services!

Pl/sql Developer Etl Developer Resume Profile

Las Vegas, NV

Summary:

  • More than 7 year's experience with 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 7 year's proven experience in PL/SQL that 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 7 year's 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.
  • Developed different Business Intelligence OLAP report using OBIEE.
  • 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 with people at all levels. Good communication and presentation skills.

Technical Proficiency:

Languages

SQL, PL/SQL, SQL Plus,MY SQL

RDBMS

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

Business Intelligence Tool

OBIEE 10.1.3.4.1,Oracle reports 10g/9i/6i, Discoverer

Modeling

Visio, Oracle designer, ERWIN,Oracle Data Modelar

ETL

SQL, PL/SQL

Other Tools

AdTempus jobs scheduler tools,TOAD 8.0/8.5/9.0/9.6, PL/SQL Developer,SQL Developer, SQL Navigator, XML, ISQL,PVCS, FTP, Toad, SDLC

Operating Systems

Sun Solaris, HP-UX, AIX, Unix, Linux, Windows

Professional Experience:

Confidential

Role: PL/SQL Developer ETL Developer

  • Worked with Help Desk people to solve problem and create batch job.
  • Created monthly campaign manifesto work for business improvement.
  • Worked with Middle Tire and Guie for Design and Development for project.
  • Wrote complex PL/SQL package, functions, procedures, batch processes using bulk processing, ref cursors and Pl/Sql Tables.
  • Did Design Document and create ER Diagram for project development.
  • Designed Data Flow, Entity Relation and others Diagrams with Erwin,
  • Visio, SDPRO, Oracle Data Modeler tools.
  • Coordinated with DBA in creating and managing Indexes, Db Links and Privileges.
  • Exclusively followed all phases of System Development Life Cycle SDLC
  • Created complex program unit using PL/SQL Records, Collection types
  • Nested Tables and Varrays in complex backend packages.

Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.PL/SQL

Developer.

Confidential

Role: PL/SQL Developer ETL Developer

Responsibilities:

  • Did Extracting data from Teradata.
  • Handled complex Exceptions.
  • Packages using Oracle utilities like PL/SQL, SQL Plus, SQL Loader and
  • Created database objects like Tables, Views, Materialized views, Procedures
  • Designed the process flows to record the dependencies between the mapping runs.
  • Did technical design document for future development process.
  • Nested Tables and Varrays in complex backend packages.
  • Created complex program unit using PL/SQL Records, Collection types
  • Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
  • Worked on production support team for EOM process issue.
  • Coordinated with DBA in creating and managing Tables, Indexes, db links and Privileges.
  • Testing and taking measures for maximum performance utilizing optimization hints,
  • Indexes, partitions, parallelism, storages and query optimization.
  • Experience in Advance Queue.
  • Worked on performance tuning of SQL, PL/SQL and analyzed Tables.
  • Detailed user requirement Analysis and Design of systems.
  • Created UNIX Shell Scripts for automated execution of batch process.
  • Developed Application Interfaces using PL/SQL stored Packages,

Procedures, Functions, Collections, Object types and Triggers.

Environment: Oracle 11g, 10g, PL/SQL, SQL Plus, Toad, SQL Loader, SQL Developer, Shell Scripting, AIX, Erwin, Windows XP Professional clients.

Confidential

Role: PL/SQL Developer

Responsibilities:

  • Identified resources for information and source systems data flows.
  • Did basic script using PERL.
  • Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, lookups.
  • Designed the process flows to record the dependencies between the mapping runs.
  • Code for Fact and Dimension table population using SQL, PL/SQL.
  • Worked as a Data Warehouse Developer using OWB.
  • Created metadata, ETL mappings using Oracle DB 9i later started building enterprise Data Warehouse using Oracle DB 10g and upgrading from 9i to 10g.
  • Developed packages, procedures, functions and database triggers using SQL and PL/SQL.
  • Use SQL Loader and External Table for data Load.
  • Testing and taking measures for maximum performance utilizing optimization hints, indexes, partitions, parallelism, storages and query optimization.
  • Used UNIX shell scripts to clean and re-organize tables from time to time.
  • Data modeling using ERWIN tools.
  • Created OLAP reports using Oracle Discoverer/OBIEE.
  • Customizing Reports in Oracle Report Developer 6i.

Environment: Oracle Application 11.5.10 GL, AR, AP, PA, OM , Oracle Workflow,

Oracle Database 9i/10g R2, SQL, PL/SQL, Discoverer 10g and Developer Forms Reports 6i, SQL Loader Oracle Application Server 10g, UNIX, Red Hat Linux, Windows XP Professional clients, Toad.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

  • Wrote Stored Procedures for effective insertion and updating of the data in to the tables.
  • Complex Sub-queries and joins were extensively used in select statements
  • Involved in extensive coding in Oracle forms/reports using PL/SQL.
  • Used SQL Loader to automate the load of data from Text files to Oracle Tables.
  • SQL Loader was used to load the data from the file in CSV format to oracle tables.
  • Worked on Oracle Forms and Reports 6i.
  • Created matrix reports using Oracle Reports 6i.
  • Used Collections like variable arrays, nested tables extensively.
  • PL/SQL was extensively utilized for coding and writing complex stored procedures and packages.
  • worked on performance tuning of SQL, PL/SQL and analyzed Tables.
  • Database Objects Recreation on Development after Refresh from Production
  • Worked on Table partition.
  • Worked as a Data Warehouse Developer using OWB.

Environment: Oracle 9i/10g R2,Oracle Developer 6i, SQL, PL/SQL,UNIX, Windows 2000/XP, TOAD, Toad, SQL Developer, SQL Loader, Erwin.

Confidential

Role : Oracle PL/SQL Developer

Responsibilities:

  • Created Dimensions, measures and hierarchies for providing drill down options in the reporting environment.
  • Extracted data from Oracle database 9i and flat file, perform mappings and load it into target Oracle tables using PL/SQL.
  • Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.
  • Created report using Oracle Discoverer, Any report can further pivot, sort, stoplight, graph the data presented.
  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
  • Modified Korn shell scripts as per technical specifications in HP-UX/SUN OS environment.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
  • Developed forms and reports using Oracle Forms 6i and Reports 6i for Financial System.

Environment: Oracle Warehouse Builder 9i, Oracle Database 9i, Discoverer 9i, Oracle Developer6i, HP-UX, SUN OS, Windows 2000/XP, TOAD, Toad , SQL ,PL/SQL Developer, SQL Loader, Erwin.

Confidential

Role: Database Designer

Responsibilities:

  • Integrated software system for Apparel Manufacturer.
  • Maintained liaison with the client executives and technical teams.
  • Functional requirements gathering, high-level and detail design.
  • Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio and SDPRO.
  • Designed and Created forms and reports with Oracle Developer6/6i/ Crystal Report, PL/SQL, Procedures, Functions, Triggers.
  • User Interface elements and reports design.
  • Coding, unit, integration and load test.
  • Commissioning and system support.
  • Installed and configured oracle 9i.
  • Created instances, schemas, users, profiles and roles.

Environment: SQL, PL/SQL of Oracle 8i/9i and UNIX Shell scripting, Visio, Erwin and SDPRO.

Developer 6 forms Report and Discoverer EUL.UNIX, Windows 2000/NT Environment, Toad, SQL Loader.

Hire Now