Oracle PL/SQL Developer Resume Dallas, TX - Hire IT People

SUMMARY

8 years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server
Good understanding of Business Functionality in the banking payments & Retail Domain
Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment
Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
Granted resources, privileges, and roles to users
Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
Used SQL*Loader, Import/Export, UTL FILE, DBMS XMLQUERY, DBMS PIPE and other Oracle built - in packages
Automated SQL*Loader to load the data from the flat files
Performance Tuning of Queries used in Production.
Wrote Shell Scripts for scheduling jobs in Unix/Windows, regular backups, instance start/shutdown and migrating data into tables.
Experience on Data migration activities and business data validations.
Good experience in Trouble shoots the issues (weblogic, PL/SQL, Batch scripts).
Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
Delivered training on SCM and JDA functional concepts various times
Offshore consulting experience on JDA SCM & Retail products like Demand Planning, Fulfillment, and Allocation in implementation, migration, enhancement, and support projects.

TECHNICAL SKILLS

Databases: Oracle 10g/9i

Operating Systems: Windows XP/2000/2003, MS-DOS

Tools: Oracle SQL*Plus, SQL Navigator, TOAD

Utilities: SQL*Loader, Data base Export & Import

Languages: SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts
Incorporated business rules and constraints and created new tables for all modules.
Tuned SQL queries to improve response time.
Wrote batch scripts to run SQL scripts daily.
Generated claims report weekly, monthly, and yearly.
Writing Unit test cases for the CR’s and Bug fixes.
Responding to the user queries for the UI’s and administrating the same.
Trouble shoots the issues (weblogic, PL/SQL, Batch scripts).
Worked closely with Administrator for proper backup and recovery plans.
Data patch implementation in production environment.
Monitor the weekly cadence flow for any job aborts and fix it within the SLA timelines.

Confidential, St. Louis, MO

Responsibilities:

Writing SQL queries to manipulate, retrieve, search and extract information on solution in the oracle database
Written batch scripts needed for the project
Building up Environments (DSM BR1/ DSM BR2) using JDA products/ Solutions. (ABPP, SCP and S&OM).
Work on Deployment/ fixes/ New Patch to the Regression/ PSR/ Pre-Prod (UAT)/ Production environment.
Written procedure and packages needed for the solution.
Taking care of Database Export and import operations using data pump utility
Written control files for SQL loader to load the input data to interface tables.
Trouble shoots the issues (weblogic, PL/SQL, Batch scripts).
Involved in preparing test cases.

Confidential, South Portland, ME

Responsibilities:

Designing and creating database tables, indexes, views, synonyms, packages, procedures, functions, DB triggers and other schema objects in oracle.
SQL queries, Triggers and stored procedures development.
Defining the requirement and Preparing technical specifications
Daily Jobs analysis and constructions.
PL/SQL Scripts for the backfill and yearly database maintenance.
Impact analysis.
Unit Testing and Documentation.
Production support
Also taking care of the on-site activities during implementation phase of package.

Confidential, Woonsocket, RI

Responsibilities:

Prepared dependency diagrams for the legacy and new databases.
Compared legacy and new databases and find out the columns and table names and added to the new database to fulfill the requirements.
Mapping of columns between legacy and new databases.
Preparing the scripts for new database.
Created tables in the new database.
Performed code debugging and verification.

We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship