We provide IT Staff Augmentation Services!

Sr. Oracle Plsql Developer Resume

SUMMARY

  • 12+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
  • 9+ years of Database experience using Oracle 11i/10g/9i/8i/7i, MS SQL Server 6.5/7.0.2000 , MS Access 7.0/2000, Oracle Report Writer, flat files, SQL, JCL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Mainframe, Windows 3.x/95/98/2000, Win NT 4.0 and Unix. Proficient in working with PL/SQL to write stored procedures, packages, and triggers. Worked with testing team to create test cases for unit and integration testing. Expertise in Endevor, WinSQL, TOAD (Tool for Oracle Application Developers).
  • Proficient in Analyzing Business processes requirements and translating them into technical requirements.
  • Extensively worked on PL/SQL Object Types, Collections, Ref Cursors, Pipeline functions, Compound triggers, Materialized Views and Table Partitioning.
  • Extensively worked with collections to reduce the overhead and improve the performance using bulk collect and bulk bind. Also handled exceptions in collections using Save Exception and %BULK EXCEPTIONS.
  • Experienced with DBA activitieslike creating users, granting and revoking privileges on database objects.
  • Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
  • Good Debugging skills and good at using Exceptions and Error Handling.
  • Expertise in optimizing and tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF & hints, and scheduling the tasks using DBMS JOB/DBMS SCHEDULER.
  • Extensively worked on Data Migration from Oracle to Postgres, Postgres to Netezza and vice versa.
  • Experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse.
  • Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
  • Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical, Analytical, Communication and Organizational Skills.
  • Experience in Creating, maintaining, and implementing oracle forms application enhancements and reports that interact with an Oracle database.
  • Experience in Supporting, re - design and re-engineering of Oracle forms system interfaces, applications, stored procedures, database tables, system design proof of concept, and system implementation.
  • Designed and developed various Oracle Forms and Reports for both Oracle Applications and Custom Development.
  • Excellent team player and can work on both development and maintenance phases of the project.
  • Efficient team player with excellent communication skills and good interaction with users.
  • Well Versed with Agile methodology and worked as Scrum Master.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7i, PostgreSQL9.0, MS SQL Server 2008, MYSQL 5.6,Netezza, MS Access 7.0/2000.

DB Dev. Tools: TOAD, SQL Developer, PL/SQL Developer, PGAdminIII, SQL*Plus, Aqua Data Studio, Razor SQL, SQL*Loader, SQL Server Management Studio, Aginity Workbench.

Tools: /Utilities: Eclipse, CVS, MS Access Reports, SQL, PL/SQL, SQL Server 2008/2005, SQL*Loader, TOAD 7.x/8.x/9.x, Enterprise DB Migration Studio, JIRA, Win SQL, SQL Navigator, Winscp, MS Project 2000, Microsoft Visual Source Safe (VSS), Concurrent Version System (CVS), Perforce, ERP, Win runner, Load Runner, Test Director.

Operating Systems: UNIX, LINUX, Windows XP/2000/98/95, MS DOS, MAC.

Languages/Web: C, SQL, PL/SQL, SQL*Plus, HTML, Shell Scripting and MS-Excel, XML, XSLT, HTML, Unix Shell Scripting.

Reporting Tools: Oracle Forms and Reports 10g/9i/6i, Crystal reports 9/10.

Data Warehousing: OLAP, OLTP, MOLAP, ROLAP, ETLInformatica, ETI, Data marts, Star Schema, Snowflake Schema, Data mining, Data Cleansing, Data Profiling.

XML Technologies: XML, HTML.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle PLSQL Developer

Responsibilities:

  • Worked as a Database Developer and involved in supporting the Assurtrack Speciality Property application.
  • Automated the process of sending emails in excel format creating Oracle packages and scheduled them in Endevor a source code management and release management tool for mainframe computers using JCL.
  • Understand the Business requirements, create the technical design document and convert them into technical specifications.
  • Developing and enhancing PL/SQL Stored Procedure, Packages, Triggers and Views as per the work requests and coordinate accordingly with the Business.
  • Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
  • Worked with Analytic functions to compute an aggregate value based on a group of rows, aggregate functions and other different built Oracle Functions.
  • Experienced with DBA activities like creating users, grant and revoke privileges on database objects as per the user’s request.
  • Writing and reading PL/SQL Packages to reduce context switching.
  • Ability to write complex queries including inline sub queries and correlated sub queries and against very large data sets as per the business requirements.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Create and debug SQL procedures by effective exception handling by creating user defined errors using pragma exception init and raise application error for the ease of debugging and displaying the error messages and scripts used as part of production cycle run.
  • Experience with building BI models for standard and adhoc reporting, analysis and risk dashboards.
  • Extensive experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse.
  • Create, modify or design program reports using SQL scripts by understanding the business requirements.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, JCL, Mainframe, Endevor, Web services, Oracle Forms 11g, Cobol.

Confidential

Sr. Oracle PLSQL Developer

Responsibilities:

  • Worked as a Database Developer and involved in Developing JWDS Dashboard (UI) and Web Page application by collaborating with front end Java Developers.
  • Development and optimization of queries that are used to drive this company's business support systems with a focus on train data.
  • Understand the Business requirements and convert them into technical specifications.
  • Developing and enhancing PL/SQL Stored Procedure, Packages, Triggers and Views and coordinate accordingly with the Java Developers.
  • Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
  • Worked with Analytic functions to compute an aggregate value based on a group of rows, aggregate functions and other different built Oracle Functions.
  • Experienced with DBA activities like creating users, grant and revoke privileges on database objects as per the user’s request.
  • Experience using Bulk processing, ETL operations, implicit and explicit cursors, Ref Cursor, collections, DBMS packages.
  • Implement the developed code, test along with the Java Developers by pointing their local to the required Database Object and deploy accordingly.
  • Writing and reading PL/SQL Packages to reduce context switching.
  • Ability to write complex queries including inline sub queries and correlated sub queries and against very large data sets as per the business requirements
  • Analyze and resolve data issues and also recommend and implement solutions to prevent recurrence.
  • Collaborated with the Core team and facilitate them to run database objects in Unix environment and involve in any further trouble shooting.
  • Used UTL FILE package to manipulate the data from files before insertion into the database.
  • Interacted with the DBA team for Performance Tuning and database issues.
  • Tuned the SQL statements using explain plan for quick data retrieval involving complex joins.
  • For Optimization Process actively involved in creating views, materialized views, partitioning tables etc.
  • Created parallel hints to parallelize operations and indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
  • Experience with SQL*Plus, SQL*Loader, Data Pump, Exp/Imp, TKPROF, Oracle scheduler, Advanced Queues, Object management.
  • Experience with building BI models for standard andadhoc reporting, analysis and risk dashboards.
  • Used Concurrent Version System (CVS) plug in along with Eclipse tool so that all the developed scripts are checked in, checked out accordingly for any future production.
  • Worked as a Scrum Master in agile environment in the absence of my Boss in Scrum meetings.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, UNIX, Toad, Agile, CVS Eclipse, Web services, Java.

Confidential

Database Developer

Responsibilities:

  • Understand the Business requirements and convert them into technical specification.
  • Designed, developed and maintained database objects such as Tables, Views, Indexes, Stored Procedures and Materialized Views in Oracle, PostgreSQL and MySQL.
  • Created Custom Triggers on Application tables to keep track of changes for Auditing in AOMA application.
  • Experienced with DBA activities like creating users, granting and revoking privileges on database objects as per the user’s request.
  • Implement various advanced features of Oracle such as Table Partitioning, Indexing strategies, DBMS Scheduler according to the requirement.
  • Involved in Performance tuning and query optimization using SQL Trace, Hints, TK Prof, and Explain Plan.
  • Research production issues and provide documented analysis and sizing required to fix the issue.
  • Detailed understanding and implementing of coding design and documentation protocol as well as unit testing, change management and release procedures.
  • Creating scripts to Migrate data between different databases like Oracle to Postgres and Postgres to netezza, vice versa using enterprise migration tool kit and Unix scripts.
  • Developed scripts in Postgres, required for the different versions of production build or deployment and coordinated with the java team to execute them as per the set up.
  • Used Concurrent Version System (CVS) Plug in along with Eclipse tool so that all the developed scripts are checked in, checked out accordingly for any future production build so that different developers can work simultaneously on different parts of the same project while tracking changes and ensuring that the project as a whole remains functional.
  • Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
  • Written complex SQL’s using joins, sub queries and correlated sub queries in Oracle to generate business reports accordingly.
  • Developed few ad hoc reports on demand basis. The output results were exported in different formats i.e. Excel, CSV and fixed length.
  • Extensive experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse.
  • Carried out knowledge transfer sessions to other members of team and provided training to users within the department.

Environment: Oracle 11g, PostgreSQL 9.0, MYSQL 5.6, Netezza, UNIX, PL/SQL Developer, PGAdmin III, Razor SQL, Aqua Data studio, Migration tool kit, Jira, CVS Eclipse, Datastage.

Confidential, Tampa, FL

Production Support Analyst

Responsibilities:

  • Analyze different issues in the Production environment and finding out the root cause followed by an efficient solution in the EMM (Electronic Mobile Measurement) application.
  • To Lead Technical discussion on business rules applied or used for the current production cycle and clarify the questions (File missing, incorrect format, spike in data and other data issues) raised by Ops team during their Biz QC meetings or data processing stages.
  • Worked with Panelists data retrieval using correlated sub queries and nested sub queries.
  • Worked extensively with XML files in the production environment.
  • Create and debug SQL procedures by effective exception handling by creating user defined errors using pragma exception init and raise application error for the ease of debugging and displaying the error messages and scripts used as part of production cycle run.
  • Acquainted and done reverse engineering of the PL/SQL Procedures, Functions, Views and Complex SQL scripts to find out the business requirement.
  • Extensively worked with development of Business reports by pulling the data from the new archive data base and on reports for technical assistance such as asking for a SQL extract or technical input for a design document.
  • Sorted issues of long time taking queries by using dynamic SQL statements like Execute Immediate and DBMS SQL.
  • Developed the PL/SQL Procedures, SQL Scripts and Complex SQL Queries to prepare the Key Performance Indicator (KPI) Vendor Metrics and calculated the Churn rate and Retention rate of the Panelists as a part of analyzing the trend of Business accordingly.
  • Interacted with the DBA team for Performance Tuning and database issues.
  • Tuned the SQL statements using explain plan for quick data retrieval involving complex joins.
  • For Optimization Process actively involved in creating views, materialized views, partitioning tables etc.
  • Created indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
  • Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
  • Worked on loading data from excel into Oracle Table using external tables.
  • To support proactively like decisive on the database or application services, whenever required.
  • Monitor the common queue in CCM.Net tool and resolving the tickets as per the business requirement.
  • Hosted calls to facilitate and lead the meeting for any incidents, defect triage, Root Cause Analysis and troubleshooting for any monitoring alert scripts by coordinating with Command center or monitoring tools team and coordinating closely with App Dev, Operations and external Vendors.
  • Good Understanding in implementing and utilizing JQuery.
  • Worked on Parameterized SQL statements to avoid SQL injection attacks in VB Environment.
  • Involved in organizing production environment for different warehouse projects and documentation of complete project for maintenance purposes.
  • Worked closely with various DW Analyst/Developers working on specific data marts, multiple business units to identify key information that will enhance business decision-making.
  • Responsible for extensive data validations, feeding of live data and user acceptance for each module.

Environment: Oracle 11g, Toad, SQL Server 2008, SQL Server Management Studio, Perforce, Putty, Perl, Web logic, CCM.Net, JQuery.

Hire Now