We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer . Resume

St Louis, MO

PROFESSIONAL SUMMARY:

  • Over 9+ years of programming experience as a Oracle Database Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Hands on experience in design, development of end user screens and reports using Oracle Forms & Reports, Business Objects, Crystal Reports, JIRA Reports, Informatica Powercenter 9.0, Oracle Developer Suite 10g ,and other front - end tools.
  • Expertise in writing SQL Queries using optimizing techniques.
  • Extensive knowledge of Normalization and Relational Database Management Systems.
  • Experience with Data flow diagrams, Data dictionary, Entity relation modeling and design techniques.
  • Good knowledge on logical and physical Data Modeling using Normalization Techniques.
  • Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
  • Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
  • Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
  • Extensive experience in using Cursors and Ref-cursors for processing of data.
  • Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types,Pragma Exceptions etc.
  • Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
  • Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
  • Experience in UNIX Shell Scripting.
  • Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
  • Enforcing experience in data integrity using integrity constraints and database triggers.
  • Expertise in handling errors using Exceptions.
  • Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file,to Oracle
  • Data analysis and data migration by transferring them using SSIS packages.
  • Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
  • Experience in creating Materialized Views and DB links.
  • Good Knowledge on Data warehousing concepts & Informatica ETL Tool.
  • Good working Knowledge on over all architecture and applications, Design and development based on requirements.
  • Excellent analytical and interpersonal skills, oral and written communication skills.
  • Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
  • Ability to learn and adapt the things and technologies quickly .
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

TECHNICAL SKILLS:

Databases: MS Access, Oracle 12c/11g/10g/9i/8i.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, SSRS, SSIS,SSAS

Languages: PL /SQL, SQL, C, Java, JSP, HTML, XML, UNIX Shell Scripting.

Operating Systems: Windows XP/ 2000/2003/2007/8/ NT, Sun Solaris 9.0/8.0, Linux 8.0

Oracle Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, Oracle Forms and Reports 10g/9i/6i, SQL Server Management Studio .

Office Applications: MS Office, Word, Access, Excel, PowerPoint, Outlook.

Business Objects: Crystal reports XI and XIR2

Datawarehousing Tools: Informatica Powercenter 9.0

DataModelling Tools: Erwin 4.0, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Oracle PL/SQL Developer .

Environment: Oracle Database 12c, SQL Developer, SQL*PLUS, Windows 2010, Jenkins, IBM Urban Deploy, MS Word, MS Excel, SQL Server 2012,PAC2000,TortoiseGit2.7.0 SVN,MS VISIO 2010.

Responsibilities:

  • Acts as a lead in providing application design guidance and consultation.
  • Analyzes highly complex business requirements, designs and writes technical specifications.
  • Acts as an expert technical resource for modeling, simulation and analysis efforts.
  • Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.
  • Oversees overall systems testing and the migration of platforms and applications to production.
  • Providing support for production issues of our applications.
  • Involving in performance tuning of SQL Queries for various projects.
  • Enhancing or Modifying Packages, Stored Procedures based on the requirements.
  • Writing high performance queries/programs using Collections, Bulk Binds, Objects,Records Nested tables, REF Cursors, pipeline functions, Pragma Exceptions etc.
  • Tuning PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, table partitions, Explain plan and analyzing the tables.
  • Creating Materialized Views for high performance.
  • Building and Deploying code in different environments using Jenkins and UrbanDeploy .
  • Analyzing, Debugging and Fixing code for errors to help or support team.
  • Converting DB2 stored procedures to Oracle Packages/Stored procedures.
  • Writing SQL Queries in SQL Server 2012 RDBMS for some of the projects.
  • Involving in Team meetings and discussions about the updated status of the projects and issues on production support.
  • Providing support to the testing team for the ongoing applications.
  • Working on PAC2000 and Tortoise SVN for Change Management and Source Control Products.

Confidential, Topeka, KS

Oracle Database Developer .

Environment: Oracle database 11g, Business Objects(Crystal Reports) TOAD 9.5, SQL Developer, SQL*PLUS, MS SQL SERVER, T-SQL,AIX Unix operating system, Windows 2008, Tivoli Workload Scheduler, WinSCP, Filezilla, Putty and MS Visio 2010.

Responsibilities:

  • Involved in analysis, system design documentation and created project Blueprint.
  • Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
  • Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
  • Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
  • Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions or T-SQL Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, table partitions, Explain plan and analyzing the tables.
  • Extensively involved in data migration.
  • Used UTL FILE built-in package to generate files as per the requirement.
  • Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
  • Wrote UNIX shell scripts to automate load process and scheduling batch jobs.
  • Extensively worked on IBM’s Automation tool-Tivoli Workload Scheduler, Used to Run, Hold, delete a job from a job stream and also used to validate the Jobs.
  • Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits & rollbacks to maintain Transactional consistency & database integrity.
  • Wrote complex in-line Views which summarized the business needs to the fullest.
  • Involved in Migrating the entire database setup from test environment to production.
  • Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.
  • Designed Reports that had complex SQL, PL/SQL code and stored procedures using Crystal Reports.
  • Involved in the continuous enhancements and fixing of problems.
  • Involved in creating Detail Design Documents for the requirements.
  • Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages.
  • Wrote T-SQL procedures based on the requirements.

Confidential, Richfield, MN.

Oracle PL/SQL Developer .

Environment: Oracle 11g, Windows XP/2003,SQL Developer, Informatica powercenter 9.0

Responsibilities:

  • Develop queries/stored procedures to analyze and correct issues in the Oracle OIM/OIA provisioning system.
  • Data analysis to determine discrepancies between the two systems and generation of SQL to correct issues as they are found as well as reporting trends in those discrepancies.
  • Cleanup of data initiative for the mainframe. This involves data ETL of both data from mainframe reports and OIM/OIA data.
  • Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
  • Develop other ad hoc queries based on need for OIA/OIM clean up.
  • Created and maintained Tables, procedures, and Indexes.
  • Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
  • Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
  • Exporting and importing the data into the database as and when user provided the data and do analysis.
  • Worked closely with the ETL Team to provide database information .

Confidential

Database Developer/Analyst/Application Developer

Technology Used: Oracle 6i&10g, Forms & Reports, Crystal reports, Oracle 8i,9i,10g.

Responsibilities:

  • Designed, developed and enhanced custom Forms and Reports according to the functional specification.
  • Did code reviews of other developers and provided suggestions to improve performance
  • Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.
  • Helped other developers in tuning queries or programs and trained them to write well-tuned code.
  • Provided expertise to development managers in design or preparing proof-of-concept testing.
  • Converted Forms & Reports from 6i to 10g.
  • Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts for efficient data storage and manipulation.
  • Involved in handling Exceptions through PL/SQL Blocks.
  • Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
  • Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
  • Tuned batch jobs and other daily/monthly reports/downloads.
  • Involved in migrating the oracle forms and reports from 6i to 10g.
  • Developed and Enhanced around 200 Reports using 10g/6i to meet the business needs.
  • Developed critical Reports that helps the business users
  • Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
  • Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus
  • Used Toad for creating and modifying procedures, functions and triggers.
  • Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).
  • Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
  • Maintaining different version of software (version control) using CVS.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Preparing test plan for QA for testing before moving from Preproduction to Production environment.
  • Trouble shooting the day to day problems in the areas of Costing, Process Raw materials and Raw material accounting, Security system, Stores, Private vouchers, OptiVISION (OTIF).
  • Doing month end activities.
  • Providing data to corporate auditors and to the users as per their requirement.
  • Modifying forms, reports and stored procedures & packages, triggers, functions etc to meet the business requirements.

Hire Now