We provide IT Staff Augmentation Services!

Pl/ Sql Developer Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Familiar with SQL*Loader to load data from external source like flat files into database tables.
  • Good exposure on Performance Tuning for Oracle RDBMS and knowledge in working with Unix shell scripting and query optimization.
  • Good experience in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, cursors and effectively using Oracle Built - in packages.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like using Records and Collections, Bulk Bind, Ref Cursor, Nested tables and Dynamic SQL.
  • Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
  • Experience with oracle supplied packages such as DBMS SQL, DBMS LOB and UTL FILE.
  • Worked on ETL Processes consisting of data extraction, data mapping, data manipulation, transformations and loading.
  • Hands on experience of working with Joins, Table Partitioning, Collections, Analytical Functions, Query Re-write and in in database administrative duties like Grants, Loads and Backup/Recovery and performance.
  • Proficiency in using various Oracle utility tools SQL Plus, TOAD, SQL navigator, SQL Loader, PL/SQL Developer.
  • Worked in Debugging and tuning the PL/SQL code, Explain plan, Tuning queries for the oracle database and experience in performance tuning using Cost Based Optimization.
  • Good knowledge of key oracle performance related features such as Query optimizer, Execution plans, Indexes and in standard Business Intelligence Reporting tools like business objects and SSRS.
  • Good Experience in Data analysis, Data Migration, Data Modelling, Data profiling, Data Quality, Data Integration and Database Design, Data warehouse.
  • Experience in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Knowledge in processing the data and flowcharting techniques.
  • Good Confidential designing, coding and testing custom queries using Confidential -SQL and expertise in creation and scheduling of Confidential -SQL jobs to run daily.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Functional Responsibilities: Involved in all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery, requirements gathering, functional gap analysis, module setup script generation testing and production support.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, JAVA, C#, ASP.NET.

Databases: SQLSERVER 2008/2012, ORACLE 11g/10g/9i/8i, MS SQL SERVER 2005.

Web Technology: HTML5, HTML4, CSS3, XML, Java Script.

Design& Simulation Tools: SQL Server Management studio, Visual studio, Eclipse, SQL Developer, PL/SQL Developer, TOAD.

Microsoft Office Suite: MS WORD, MS EXCEL, MS VISIO, POWERPOINT, OUTLOOK.

Tools: SSIS, SSRS, SSAS, Tableau, DQC, SharePoint, ODI, IWAY DM, AWR, DataStage.

Operating Systems: Windows, UNIX, MacOS

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

PL/ SQL Developer

Responsibilities:
  • Utilized PL/SQL tables and bulk collections to perform very quick loading of data. Extensively used SQL Loader to load data into the target tables.
  • Actively involved in optimization and tuning of SQL queries through utilizing the explain plan to find out the problem area of the query.
  • Data Analysis primarily identifying Data sets, Source Data, Source Meta Data, Data Formats and Data Definitions.
  • Created and manipulated stored procedures, functions, packages and triggers. Wrote heavy stored procedures using dynamic SQL to populate the data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in Development of End - to - End Application from Data Transfer from Source system applications to till report generation.
  • Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
  • Worked on Table partitioning and Index creation to improve the performance of the query.
  • Involved in Requirement gathering, High level Design, Low level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
  • Extensively used the advanced features of PLSQL like Records, Tables, Object Types and Dynamic SQL.
  • Developed the SQL*LOADER, external tables to accept the data from third party systems.
  • Involved in the Development of ETL processes such as data transformations, data sourcing, mapping, conversion and loading.
  • Worked on Exception Handling, to trouble-shoot PL/SQL code and to display the error messages in the application.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL* Loader, SQL Developer, Oracle Enterprise Manager, Windows 2000, ETL Tool, UNIX.

Confidential, Culver City, California

Senior PL/ SQL Developer

Responsibilities:
  • Prepared Program specification for the development of PL/SQL procedures and functions.
  • Programmed in UNIX Shell scripts to provide a user interface to Oracle forms and reports.
  • Used Oracle packages like DBMS STATS to collect statistics of tables as an aid to improve performance of application.
  • Involved in working with Implicit cursors, Explicit cursors and Ref cursors.
  • Involved in creating various utility scripts to generate log files in UNIX Shell scripts.
  • Developed Stored procedures and Triggers to facilitate consistent data entry into the database.
  • Worked with Business Analyst clients to clarify business requirements, map them to systems capabilities, and recommend technical solutions.
  • Design Development and testing of reports using SQL*plus.
  • Used UTL FILE packages for writing DBMS OUTPUT into the files.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Developed ETL jobs using ODI tool for data migration operations.
  • Developed complex PL/SQL Data transformation tool for data mapping and transformation of the legacy data.
  • Developed the SQL*LOADER, external tables to accept the data from third party systems.
  • Created Materialized Views, Tables, Complex SQL queries and Correlated sub queries, Nested queries, Views and Function based Indexes for effective Business Application Development.
  • Used Explain Plan DBMS Profiler for tuning the PL/SQL blocks.
  • Monitored the Production batches and fixed the issues within SLA.
  • Debug data quality issues by analyzing the up-stream sources and provide guidance to team
  • Performed Unit test on the developed code to ensure that its bug free.

Environment: Oracle 9i/10g/11g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, ODI, UNIX, WINDOWS2000/XP, SQL Developer, Oracle Forms 10g.

Confidential, Detroit, Michigan

Data Architect

Responsibilities:
  • Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
  • Created Oracle Stored Procedures to implement ETL Process control logic.
  • Created Tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*plus.
  • Documented all the ETL and Oracle Procedures developed.
  • Used SQL*Loader, Microsoft Excel and Oracle to test the validity of data extracts as well as research related to client data requests for information.
  • Automation of data migration process using UNIX Shell scripting.
  • Worked on Database Security like Encryption of Critical Database Login information.
  • Wrote control files and loaded the data into the oracle database with SQL*Loader.
  • Worked on Creation of scripted automations for DBA operations to help in minimizing manual effort and for standardization of process.
  • Implemented Materialized view for extracting the data from the remote database.
  • Coded UNIX Shell scripts to call SQL scripts and to manipulate the returned data.
  • Extensively worked on Explain plans and various HINTS for Performance tuning.
  • Analyzed data to check for Data Integrity and Referential Integrity when loaded to source staging tables.
  • Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
  • Prepared the Data Analysis Queries for Validating the Data into Source systems

Environment: Oracle 10g/11g, SQL*Loader, SQL Navigator, TOAD, SQL*Plus, WINDOWS 2000 SERVER, WINDOWS XP, UNIX, ORACLE SQL DEVELOPER, ETL, PUTTY, ORACLE FORMS 10g, ORACLE REPOTRS 10g.

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:
  • Created Database objects such as Tables, Indexes, Views and Constraints.
  • Worked with users and application developers to identify business needs and provide solutions.
  • Created many complex SQL queries and used them in Oracle reports to generate reports.
  • Created and implement report modules into database from client system using Oracle reports as per the business requirements.
  • Implemented data validations using Database Triggers.
  • Created Oracle Stored Procedures for Segment Dimension which holds all the dimension keys.
  • Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
  • Created Unit Test plans for various ETLs developed and performed Unit Testing and Integration Testing for the ETLs.
  • Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
  • Used SQL Hints and Indexes as needed to improve SQL performance.
  • Used UTL FILE to load the data into Oracle tables from FLAT, CSV and Text Files.
  • Worked on all phase of the project life-cycle.
  • Implemented various customized Oracle reports using different techniques in Oracle SQL/PL-SQL.

Environment: Oracle Database 10g, SQL Loader, WINDOWS XP, UNIX, PL/SQL Developer Oracle Forms 10g, Putty, TOAD, EXPORT, IMPORT.

Confidential

Jr. PL/ SQL Developer

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Created SQL*Loader scripts to load data into temporary staging tables.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Created Views by joining multiple cash flow tables to show output as report to the user.
  • Used File Handling in Oracle to read and write into files associated with the modules.
  • Tuned pre-existing PL/ SQL programs for better performance.
  • Used import export utilities such as UTL FILE for data transfer between tables and flat files.
  • Worked with built-in Oracle standard Packages like DBMS SQL, DBMS JOBS and DBMS OUTPUT.
  • Involved in Development of End - to - End Application from Data Transfer to Report Generation for User Analysis.
  • Performed SQL and PL/SQL query tuning and optimization using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Developed UNIX Shell scripts to automate various periodically repetitive database processes.

Environment: Oracle 9i, PL/SQL, UNIX, HTML, SQL *LOADER, SQL*PLUS, SQL, WINDOWS XP.

Confidential

Oracle PL/SQL Developer

Responsibilities:
  • Created database objects like Tables, Indexes, Sequences, Constraints, and Views.
  • Developed PL/SQL procedures that handle key business logic.
  • Designed and Created database using SQL and PL/SQL, wrote backend stored procedures, functions and triggers which allow users to analyze daily, weekly and monthly connection requests, issued connections versus projected issues and keeping track of customer details monthly.
  • Implemented triggers to enhance functionality supplement validation and control navigation.
  • Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Extensively used DTS Package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
  • Prepared Unit Test Plan and deploy the code in Production Environment.
  • Developed the shell scripts to process PL/SQL procedures and wrote PL/SQL program units for data extracting, transforming and loading.
  • Developed SQL*Loader scripts to load data into the staging tables from the flat files.
  • Deploy the code in Various environments after getting the approval from Change meetings.

Environment: Oracle 9i/10g, SQL Server, SQL*LOADER, UNIX, Windows 2000 Professional, PLSQL, SQL, HTML.

Hire Now