We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

4.00 Rating

Chicago, IllinoiS

SUMMARY

  • Over 6 years of development experience as an ODI Developer, Oracle Database Designer and Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
  • Strong experience in translating business requirements into creation of Database Objects.
  • Strong experience in writing Complex Database Objects like Stored Procedures, Functions, Cursors, Triggers and Database Administration.
  • Strong experience in SDLC including Water fall and Agile Scrum environments in Data Migration projects in government sectors.
  • Experience in Client Server application development using Oracle 11g/10g/9i, PL/SQL, SQL*PLUS, TOADAND SQL DEVELOPER.
  • Excellent experience in Designing, Maintaining and tuning various RDBMS like T - SQL & MS SQL Server 2005/2008/2008 R2/2012 and MS Access databases.
  • Experience in working all the stages of Data Migration.
  • Worked extensively on Ref Cursor, External Tables and Global Temporary Tables.
  • Experience in Dynamic SQL, Exception handling and Analytical Functions.
  • Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
  • Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
  • Extensive usage of Oracle collections and standard API’s like DBMS LOB, UTL FILE etc. for business logic in user defined API’s.
  • Expertise in dealing with complex data models and object relational database mapping, while producing complex reports.
  • Good Exposure to UNIX shell scripting.
  • Expertise in developing outbound and inbound interfaces.
  • Hands on experience in Data migration (ETL) across different databases via SQL scripts.
  • Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
  • Experience in requirement gathering, gap-analysis and solution design.
  • Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
  • Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
  • Great team player and ability to work collaboratively and independently as required.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows

Database: Oracle 9i/10g/11g, MS SQL Server and MS Access

Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i

ERP: Oracle Applications R12.

Languages: SQL, PL/SQL, JAVA, HTML, XML and shell scripting

Tracker Apps: BMC Remedy, BugZilla

Version control: PVCS

Office Tools: MS Office and Generic text editors

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO, ILLINOIS

Sr. PL/SQL DEVELOPER

Responsibilities:

  • Implemented UI screens using JSP, JDBC and interacting with PL/SQL interfaces.
  • Parsing and processing of XML data, using DOM, XPath, and XQuery in oracle XMLDB.
  • Implemented XML schemas to validate XML.
  • Applied design patterns including Factory, Model-View-Controller and Singleton.
  • Defined Views and materialized views for simplifying reporting queries and performance.
  • Responsible for tracking requirements by interacting with business team.
  • Enhancement of Logical and Physical models to in corporate new features.
  • Involved in development, enhancement and maintenance of PL/SQL interfaces such as defining packages, developing procedures and functions.
  • Created several programs written in Perl to extract data and create reports.
  • Addressed errors in communication between the application and other websites.
  • Responsible for development and maintenance of Reports.
  • Made changes in the existing data model and system for new enhancements.
  • Created rerun able shell scripts for meta data creation and maintenance.
  • Supported nightly builds and deployments and also part of 24/7 support team.
  • Responsibly followed build and release process.
  • Prepared test data, test cases.

Environment: Oracle10G, SQL, PL/SQL, XMLDB, Oracle Forms and Reports 9i/10g,Shell Script, Java, J2EE, Erwin, Perl Scripting, Toad, Clear Case, Web logic 8x, HP-UX, Ant, and See Beyond.

Confidential, Birmingham, AL

Sr. PL/SQL DEVELOPER

Responsibilities:

  • Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Used Tortoise SVN version control for changing the codes.
  • Making changes to the existing apex applications in the production.
  • Created SQL*plus reports as per client's various needs, and developed business objects.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, 11g, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, UNIX Shell script, MS Windows XP/2000, Oracle Development Suite.

Confidential, MILWAUKEE, WI

Sr. Oracle PL/SQL Developer

Responsibilities:

  • SME for Accounting Databases and DataMarts.
  • Applying Code releases.
  • Defect Fixing and Automation of repeating defects.
  • Involved in review of the database design.
  • Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
  • Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
  • Monthly Reports and Data Extracts.
  • Monitoring and Optimizing Database.
  • Communicating with the offshore team for project related activities.
  • Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-TRACE, TK-PROOF and Explain plan utilities.
  • Responsible writing UNIX shells scripts.

Environment: Oracle 9i, SQL, HTML, UML, SQL * Loader, PL/SQL, Crystal Reports, TOAD, XML and UNIX Shell Scripting.

Confidential - IRVING, TX

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for tracking requirements by interacting with business team
  • Enhancement of Logical and Physical models to in corporate new features
  • Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
  • Designed and developed the ETL process for learning data mart and made use of database objects efficiently towards the fulfillment of business requirements.
  • Designed and developed the Developed Cognos reports for Learning Survey Reporting using complex PL/SQL procedures.
  • Created List Reports, Dash Board Reports, Cross-tab Reports, and Charts using Tabular SQL, Tabular References and Tabular Sets to reduce the load on the Framework Manager model and improve the report performance.
  • Enhancement of Logical and Physical models to in corporate new features
  • Defined Views and materialized views for simplifying reporting queries and performance.
  • Developed PL/SQLStoredprocedures, Triggers and Functions and embedded them in packages.
  • Designed dynamic workflows for the factory planner using ABPP.
  • Performed Query optimization and PL/SQL tuning to maximize performance
  • Supported nightly builds and deployments and also part of 24/7 support team
  • Responsibly followed build and release process
  • Involved in Unit Testing, Integration testing, Performance testing and Regression testing.

Environment: Oracle 10G, SQL, PL/SQL, Oracle Forms and Reports 9i/10g, Shell Script, Erwin, Toad, Clear Case, Ant, and See Beyond.

Confidential, Columbus, OH.

Oracle PL/SQL Developer

Responsibilities:

  • Involved in designing ER diagram usingERWIN and VISIO. To set the logical and physical relationships of database.
  • DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL.
  • Developed data model,SQL Coding,SQL Query tuning processandSchemas.
  • Migration of DBMS jobs tocontrol M.
  • Scheduling jobs incontrol Mand handling them.
  • UsedTORTOISE SVN versioncontrol for changing the codes.
  • Making changes to the existingapexapplications in the production.
  • CreatedSQL*plus reportsas per client's various needs, and developed business objects.
  • DevelopedSQL Scripts, Packages and Proceduresfor Business rules check to implement business rules.
  • Developed and designed dynamic configuration wrapper in Perl to generate flat fund reports.
  • Providedbackend supportfor various Perl based applications.
  • UsedBulk Collections, Indexes, and Materialized Viewsto improve the query executions.
  • UsedRef cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
  • Atomized routine jobs usingDBMS JOB.On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
  • Involved in SDLC including designing, coding and testing.
  • DevelopedSQLandPL/SQLscripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems (ETL Operations) usingPL/SQL and SQL*Loader.
  • Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Archived many applications in the existing system and retrieval of necessary data from them.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential

Software Programmer

Responsibilities:

  • Gained experience in C & C++ programming on UNIX for JIST Applications and also developed PL/SQL Code for updating the payment terms.
  • Design, Development and testing of Reports using SQL*plus.
  • Worked closely with architects, designers and developers to translate data requirements into the physical schema definitions for Oracle.
  • Creating SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases.
  • Developed Stored Procedures, Functions, Packages and Triggers using SQL, PL/ SQL and Run Batch files for loading database tables from flat files using SQL*loader.
  • Developed UNIX Shell Scripts for automating the execution process.
  • Involved in preparing documentation and user support documents.
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: PL/SQL, Oracle 9i, UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/XP.

We'd love your feedback!