We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

0/5 (Submit Your Rating)

Columbus, OH

SUMMARY

  • Professional with about 7+ years of IT experience in analysis, design, development, testing and implementation of application software as Oracle SQL and PL/SQL developer.
  • Expertise in SQL and PL/SQL programming and strong knowledge on Oracle architecture and database design.
  • Experience in Design, Development, and Enhancement and maintaining applications in Oracle 10g/11g using SQL and PL/SQL.
  • Strong experience in designing and developing oracle objects Tables, Views, Indexes, PL/SQL Stored Procedures, Functions, Packages, Triggers and fine tuning them.
  • Experienced in interacting with Business Users, Project Managers, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specification.
  • Good knowledge in Relational Data Modelling.
  • Developed normalized Logical and physical database models to design OLTP system.
  • Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Temporary tables, Object Oriented PL/SQL Programming.
  • Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes and managing database.
  • Strong knowledge in Oracle Cursor Management and Exceptional Handling.
  • Good Understanding of Oracle Data Dictionary, RDBMS, Normalization Techniques.
  • Expertise in using tools such as TOAD, PL/SQL Developer, Oracle 10g/11g, SQL Server 2008, SQL*Loader.
  • Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
  • Experienced in Unit testing and Integration Testing with excellent debugging skills.
  • Good knowledge in Performance tuning, SQL Tuning, Data optimization, query optimization, job scheduling.
  • Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
  • Quick learner and a team player with strong communication and interpersonal skills.
  • Worked on production support, troubleshooting the application and resolving bugs.
  • Excellent Analytical, Conceptual, Root cause analysis and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 10g/11g, MS SQL SERVER 2005/2008 and MS Access

Programming Languages: SQL, PL/SQL, C, HTML

ETL Tools: Star & Snow - Flake Schema Modeling, SSIS, Clover ETL

Analytics and Visualization Tools: R, SAS, RapidMiner, QlikView, Tableau, SSRS, Microsoft Excel

Other Tools: TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. PL/SQL Developer

Responsibilities:

  • Participated in the full software development life cycle and analyzed, designed, modeled, and implemented new database schemas.
  • Involved in development, maintenance of Triggers, Joins, Cursors and Views.
  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
  • Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
  • Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
  • Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
  • Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
  • Optimized the performance using PL/SQL table types and record types.
  • Developed SQL and PL/SQL code for ODI and Oracle.
  • Developed AR Credit memo and AR Customers forms.
  • Worked extensively with ODI Designer, operator and metadata Navigator.
  • Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
  • Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process.
  • Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
  • Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
  • Performed Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
  • DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
  • Created complicated reports using reporting tool Cognos.
  • Used DS Erwin MetaBroker to import Erwin 4.x Metadata into DataStage Repository.
  • Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
  • Involved in Unit testing and Integration testing of forms and reports and Coding of documents in XML for data transformation.
  • Implemented table and index partitioning of various tables with huge data.
  • Developed scripts in Korn shell and Perl for network management.
  • Provided Post production Technical Support to the users.

Environment: Oracle 10g /11g, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, TOAD, UNIX, Shell scripting, Oracle Warehouse Builder 11.2.0.2, Subversion (SVN), Perl.

Confidential, Princeton, NJ

Sr. PL/SQL Developer

Responsibilities:

  • Participated in the full software development life cycle and analyzed, designed, modeled, and implemented new database schemas.
  • Involved in creating Logical and Physical data modeling using ERWIN.
  • Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
  • Created database objects like Tables, Sequences and Constraints as per the business requirement.
  • Extracted data from the source views by writing the procedures to load the data into staging tables.
  • Created database views and materialized views.
  • Created database triggers based on business requirement.
  • Developed stored functions, packages based on requirement.
  • Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created Test cases for the mappings developed and then created integration Testing Document.
  • Followed Informatica recommendations, methodologies and best practices.
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
  • Use various SQL Profiler templates for tracking execution time of TSQL Statements.
  • Created indexes on tables and optimized procedure queries.
  • Maintained Database security by authenticating users, using logon triggers.
  • Running explain plan for tuning the SQL queries.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Created test scripts documentation for all the procedures developed.
  • Involved in production support, like monitoring the performance of the Unix jobs.
  • Involved in the Error Diagnosis, developing test plans to conduct the Unit and Integration testing.
  • Researching and resolving the problems occurred with the Jobs and also involved with the end user to resolve the problems.

Environment: Oracle 11g, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad 9.1, SQL*Loader, UNIX, Shell Scripts, SQL Navigator, Erwin r7, QC 10.0, Windows

Confidential

Application Consultant (Oracle PL/SQL Developer)

Responsibilities:

  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Actively coordinated with offshore teams through requirements gathering, design, development and testing phases.
  • Collaborated with the DBA in creating tables required for the application.
  • Developed validations to dynamically trigger visits and forms in the study by writing Procedures, Functions and Queries.
  • Used dynamic SQL to create views/triggers and also debugged complex Procedures and Functions in Oracle.
  • Creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Programs and Jobs.
  • Performed staging and cleansing of data as per requirement.
  • Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
  • Designed validation for the client on server side as well as client side to enforce data integrity (Item dynamics, Soft stops, hard stops).
  • Made use of Cursors in Procedures to generate high performance queries and PL/SQL code.
  • Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
  • Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
  • Developed numerous SSIS packages to pull in the data from heterogeneous data sources.
  • Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules.
  • Used SQL Trace, Analyze, Explain Plan Utilities and Hints to develop better SQL Queries.
  • Worked on ETL’s for migration of data from one database to another database.
  • Utilized SQL*Loader to load data into Oracle database from flat files.
  • Issued Grants to the business users for appropriate Database tables, views.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Set up the trial of Avail study in the Dev and QA environments by importing the dump.
  • Fixed the defects obtained during the QA that included code modifications as well as issue data analysis and delivered the solution to production.
  • Documented and transferred knowledge regarding the various projects.

Environment: Oracle 10g, Toad 9.0, PL/SQL, SQL, PL/SQL Developer, SQL* Loader, UNIX, SVN, JIRA, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Trained in the essentials of RDBMS, SQL, Shell Scripting, Linux and MS SQL Server Management Studio.
  • Analysis and gathering of new business requirements from the business resources and transforming them into functional and technical specifications.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
  • Developed various queries using views, sub-queries, joins, merge and grouping aggregation functionality.
  • Extensively wrote SQL queries (Sub Queries, correlated sub queries and join conditions) for generating various kinds of reports as per the user requirement.
  • Involved in debugging, fine tuning and optimization of different SQL queries to ensure faster response time.
  • Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment.
  • Work with QA team to debug/fix issues.
  • Assisted in day-to-day duties of DBA work like taking backup and recovery of database environment.
  • Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 10g, PL/SQL, SQL.

We'd love your feedback!