We provide IT Staff Augmentation Services!

Etl And Oracle Pl/sql Developer Resume

Los Angeles, CA

SUMMARY

  • 7+ years of IT Experience as Oracle Developer and ETL developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g, 11g, 12c and Informatica Power Center 10.x, 9.x in Production, Staging, Development environments, Oracle Forms & Reports (6i, 10g & 11g) and support of Data warehousing applications.
  • Expert in creating SQL Queries, PL/SQL packages, functions, stored procedures, triggers, and cursors.
  • Created several database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
  • Experience in Data warehouse development, working with Data migration, Data conversion and Extraction/Transformation/Loading using Informatica Power Center and Informatica cloud platform.
  • Enforced data integrity using integrity constraint and database triggers.
  • Developing Custom Oracle Forms for Oracle Applications 10g using Oracle Forms 10g, 11g and 12c.
  • Excellent understanding of ETL design process, development and maintenance using Mapping Designer, Workflow Manager, Monitor and Repository Manager.
  • Worked with different Databases & Files - Oracle, DB2, Sybase, My Sql, Sql Server, Teradata, Flat files & XML.
  • Proficient in advance features of Oracle for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
  • Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
  • Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
  • Involved working on the transformations like Source Qualifier, Filter, Router, Joiner, java, Aggregator, Expression and Lookup.
  • Expert in Data Modeling using Star Schema/Snowflake) Schema, Fact and Dimensions tables and slowly changing Dimensions (SCD1, SCD2).
  • Experience with Informatica Power Exchange change data capture ( Confidential ), also the traditional Confidential method.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Extensively used Cubes & Rollups for making cross-tabular reports.
  • Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
  • Expertise in handling errors using Exceptions.
  • Expert in performance tuning using Explain plan.
  • Making structural changes to the database objects.
  • Upgraded, maintained and troubleshoot Oracle Forms and Reports.
  • Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
  • Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
  • Experience in working high-transacted OLTP systems.
  • Extensive experience with building application using Oracle APEX.
  • Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
  • Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, High Level Design, Low level Design, STM, Test Plan, and Test Script & Test Cases.
  • Have worked in fast-paced AGILE environment & attended daily scrum meeting.
  • Experienced in writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) &System Integration Testing.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2.0/9.6.1 , IICS, Data Services 4.2

Data Warehousing: OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension TablesConceptual, Physical & Logical Data Modeling.

Databases: Oracle 11g,10g/9i/8i/8/7.3, My SQL, MS-Access

Languages: XML, Java, SQL, PL/SQL, UNIX Shell Scripting, PERL Scripting.

Operating System: HP-UX11/10/9, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows

XP Professional/2000/NT/98/95/7:

Other Tools: SQL*Plus, PL/SQL Developer, Export/Import, TOAD, SQL NavigatorMicrosoft Office tools, Quality center, SVN, Erwin, Toad

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

ETL and Oracle PL/SQL Developer

Responsibilities:

  • Extensively worked with Business Analyst & Users in understanding the Source to target Mapping documentation.
  • Created complex mappings using Source Qualifier, Expression, Joiner, Connected/Unconnected Lookup, Sorter, Aggregator, Filter, Java, Update Strategy and Router transformations for populating target tables in efficient manner.
  • Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
  • Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
  • Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and by using Mapping Parameter files.
  • Extensively involved in both ETL Informatica & Database performance tuning.
  • Analyzed session log files in session failures to resolve errors in mapping or session configuration.
  • Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
  • Created mapplet and used them in different mappings.
  • Extracted data from different heterogeneous sources Flat Files, XML, My Sql and Oracle
  • Implemented Slowly Changing Dimension Type I & Type II for different Dimensions.
  • Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
  • Created Mapping parameters and Variables and written parameter files.
  • Created UNIX shell scripts for various needs.
  • Worked with the Debugger Wizard in debugging the mappings.
  • Created Complex Functions, Stored Procedures, Packages by using Oracle PL/SQL by analyzing the business requirements and Data.
  • Created API’s and Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.
  • Used partition exchange concept to exchange the partitions from base tables to archive tables.
  • Extensively worked on SQL performance tuning using explain plan.
  • Created schedulers Jobs to run the archiving scripts.
  • Customization of code as per the user requirements.
  • Providing status of project by attending weekly status call.
  • Implemented Informatica Procedures and Standards while developing and testing the Informatica objects.
  • Debugged the complex data stage job errors by using error logs detection
  • Unit testing the PL/SQL code.
  • Was working for the Project in Agile Methodology.

Environment: Informatica 10.2.0/9.6.1 , Data Services 4.2, IICS, Oracle 12c/11g, SQL, PL/SQL, Erwin, SQL*Plus, TOAD, SQL*Loader, Shell Scripts, Windows 10, UNIX.

Confidential, Columbus, OH

Oracle PL/SQL Developer.

Responsibilities:

  • Created and modified Complex Functions, Stored Procedures, Packages and Triggers by using Oracle PL/SQL based on the business rules.
  • Created E-R Diagrams, Data Flow Diagrams and Built Logical and Physical Modules using Designer/ Erwin.
  • Extensively worked on Schema Migration, Database Program Migration and Data Migration from Sybase to Oracle by using Oracle SQL Developer.
  • Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER and Hints etc.
  • Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
  • Extensively used PL/SQL advanced features like Forward Declaration, Procedure Overloading.
  • Extensively used Oracle 11g features like RESULT, Compound Triggers etc.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
  • Extensively used Oracle 11g features like RESULT, Compound Triggers etc.
  • Worked on Table Partitioning and Index Creation to improve the performance of the query.
  • Worked with DBA's regarding the data checks during Migration, Loading, Creation and Management of Tables, Indexes, Table Spaces etc.
  • Developed PL/SQL Triggers and Master Tables for automatic creation of primary keys.
  • Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & integration Testing of Data Migration process using ETL Methodology.
  • Creation of database objects like Tables, Views, Materialized Views, Procedures and Packages using Oracle tools like Toad, SQL Developer and SQL* plus.
  • Developed PL/SQL Procedures and UNIX Scripts for running files in Batch Mode.
  • Extensively worked on developing PERL scripts.
  • Create a risk plan and list all the mitigations.
  • Advised Optimization of queries by looking at Execution Plan for better tuning of the database.
  • Updated tables without breaking the existing functionality.
  • Involved in Unit Testing and Integrated Testing.
  • Was working for the Project in Agile Methodology.

Environment: Oracle 11g, SQL, PL/SQL, Erwin, SQL*Plus, TOAD, SQL*Loader, Shell Scripts, PERL Scripts, Windows 7, UNIX.

Confidential, Oaks, PA

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements for the automation of reports.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Involved in data modeling, development and enhancement of various modules.
  • Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
  • Performed the uploading and downloading flat files from UNIX server using FTP.
  • Unit testing the PL/SQL code.
  • Was working for the Project in Agile Methodology.

Environment: Oracle Database11g, TOAD, SQL Developer, SQL* Plus, UNIX.

Confidential, West Des Moines, Iowa

Oracle PL/SQL Developer

Responsibilities:

  • Analyze the requirements, existing code and suggested the enhancements for business requirements.
  • Involved in gathering business requirements, clarification and system design.
  • Extensively worked in End-to-End phases of the application design, development, testing, production deployment and documentation.
  • Prepared proto-types for the system design & approach and participated in business user’s presentations.
  • Implemented RDBMS (normalization) concepts in Data modeling.
  • Developed PL/SQL packages, procedures, functions, Indexes, SQL scripts for the implementation of the very complex business requirements.
  • Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.
  • Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
  • Used explain plan and Auto trace for identifying the low performance SQL Queries.
  • Involved in Performance Tuning of SQL statements.
  • Used advanced Bulk technologies (FOR ALL, BULK COLLECT) to improve performance.
  • As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
  • Worked on archiving the oldest records to improve the performance.
  • Used partition exchange concept to exchange the partitions from base tables to archive tables.
  • Created schedulers Jobs to run the archiving scripts.
  • Performed some basic database administrative tasks creating users, tables, table spaces, grants, indexes, partitioning tables in DEV and TEST environments.
  • Customization of code as per the user requirements.
  • Providing status of project by attending weekly status call.
  • Worked for the production deployment of the project by working closely with the Business team and deployment assistance team.
  • Involved in Customizing and testing of Packages.
  • Also, responsible for system integrity testing and user acceptance testing before final migration of the programs to the PROD instance

Environment: Oracle Database11g, TOAD, SQL Developer, SQL* Plus, Windows 7.

PL/SQL Consultant - Oracle Forms& Reports

Grove, IL

Responsibilities:

  • Analyze the requirements, existing code and suggested the enhancements for business requirements.
  • 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).
  • Design flow for the ETL process for building up the data repository.
  • Design Unix scripts and shell scripting for batch jobs
  • Responsible for developing custom PL/SQL wrappers for fixing the data issues for support team.
  • Worked on TIVOLI Work Scheduler for the scheduling of batch jobs.
  • Work in store procedure to prevent SQL Injection
  • Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization
  • Performed some basic database administrative tasks creating users, tables, table spaces, grants, indexes, partitioning tables in DEV and TEST environments.
  • Worked with FTP and SFTP efficiently for processing.
  • Performed the requirement gathering from Business Analyst and suggested the crucial data to be loaded in the Master tables. Single handedly handled the production deployment phase of Consumer Business Billing Application project using the ITG Request deployment framework.
  • Develop and integrate Data Stage jobs
  • Develop new screens using Oracle Forms 11g for application as per requirements.
  • Develop Oracle scripts and PL/SQL procedures.
  • Develop Oracle reports required by the application using Oracle Reports 11g.
  • Customization of code as per the user requirements.
  • Providing status of project by attending daily status call.
  • Program customizations through modification of existing SQR programs.
  • Formulated SQL queries, functions and processes as per customization requirement for APEX
  • Followed the Scrum methodology for development of projects and implemented the development in sprints.
  • Worked for the production deployment of the project by working closely with the Business team and deployment assistance team.
  • Making changes to the existing apex applications in the production
  • Debugged the complex data stage job errors by using error logs detection
  • Involved in Customizing and testing of Packages.
  • Involved in Concurrent Program Registration and Manual creation of Lookups.
  • Also, responsible for system integrity testing and user acceptance testing before final migration of the programs to the PROD instance

Environment: Oracle Database11g, Oracle Forms & Reports 11g, SQL Server 2008, TOAD, SQL*Developer, UNIX, PUTTY, Shell script

Confidential, St. Louis, MO

PL/SQL Consultant - Oracle Forms & Reports

Responsibilities:

  • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
  • Involved in Business Requirements, System analysis and Design of the Data warehouse application.
  • Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Designed Physical and Logical Data model and Data flow diagrams.
  • Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
  • Worked on various tables to create Indexes to improve query performance. Also, worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
  • Created Schema Using the XML schema.
  • Generated XML using the Procedures, Functions and Packages.
  • Involved in writing several Queries and Procedures.
  • Built database objects like Tables and Views.
  • Involved in the Database Design (Relational and Dimensional models) using ERwin.
  • Defined both logical views and physical data structure using ERwin.
  • Developed PL/SQL Packages to extract, transformation and loading of data.
  • Developed Oracle Forms and Oracle Reports using 10g depending on the functional requirement document.
  • Review/Create/Modify the Reports RDF and Forms in Oracle 10g.
  • Filtered and Loaded data from different formats of data sources into Database Tables.
  • Validation and Testing of forms.
  • Extracted required data from the database tables and exported the data to different sources in different formats.
  • Worked with several tools to access and perform several operations on database.
  • Experience in Generating Reports.
  • Developed Data entry, query and reports request screens and tuned the SQL queries.
  • Used joins, indexes effectively in where clauses for Query optimization.
  • Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Toad, SQL* Plus, SQL* Loader, Oracle 10g, Forms & Reports 10g, MS SQL Server, ERwin, Windows XP, UNIX.

Jr. Oracle Developer

Responsibilities:

  • Analyzed all business functionality related to back end database interfaces
  • Developed technical specifications for various back end modules from Business Principles. Specifications are made per standard specification formats.
  • Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
  • Worked with DBA in making enhancements to physical DB schema.
  • Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, dB links and privileges.
  • Developed customer and order packages to process all customers and orders.
  • Developed back end interfaces using PL/SQL stored packages, procedures, functions, Object Types, triggers.
  • Involved in tuning and optimizing SQL queries by using quest control tools and manual by explain plan.
  • Utilized SQL*Loader to load flat files database tables.
  • Utilized PL/SQL developer tool in developing all back-end database interfaces.
  • Responsible for performing code reviews.
  • Interaction and coordination with various application teams for resolving issues, patch movements.
  • Preparation and Reviewing Production Patch Implementation Documents.
  • Creation of Change Requests for bimonthly changes movements.
  • Responsible to keep the production test machine in sync with production.
  • Also, responsible for writing test plan documents and unit testing for the application modules.

Environment: Oracle10G, UNIX, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, PL/SQL Developer Tool, TOAD.

Hire Now