SUMMARY

• Over 6.5 years of experiencein Design, Development and Testing of Applicationsusing Oracle Relational Database Management System(RDBMS)
• Expertisein Software Development Life Cycle (SDLC) involving cross platform solutions,Agile development, scrum methodologiesandfast paced work environment
• Strive towards development and implementation of cost effective application solutions
• Production support experience, identifying issues, correcting codes
• Extensiveexperience in creating Procedures, Functions, PackagesandTriggers
• Expertise in using Dynamic SQL for achieving complex functional requirements.
• In depth understanding in implementingPL/SQL Collections,SQLObject Types
• Ability to effectively and efficiently use Exception handling
• Implementation knowledge of Advanced Queuing techniques
• Good understanding in designand developmentofPL/ SQLETLSolutions
• Expertise in Interfaces and Conversions track of OracleApplications
• Development ofMaterialized Views for data replication in distributed environments
• Knowledge in SQLQuerytuningwith Optimizer Hints,Execution Plans, Indexes
• Good understanding of Cost Based Optimization
• PL/SQLPerformancetuningusing BULK processing, Parallel processing techniques
• Proficiency in using various Oracle utility tools SQL Plus, TOAD, SQL Developer, PL/SQLDeveloper, SQL*Loader
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification and archival techniques.
• Strong experience in UNIX Shell Scripting
• Knowledge of Data warehousing, Data Integration and BI Tools.
• Good working experience with Oracle Apps Interfaces and Conversions
• Proficient in ETL and SQL Loader.
• Develop, maintain and enforce PL/SQL coding standards
• Effectively utilize MS Officefor proper documentation and presentation.
• Expertise in using version control tools like SVN for PLSQL development.
• Good experience in oracle data base design, data migration, performance tuning…etc.
• Expertise in reading and writing XML files using PLSQL
• Acquired above industry standardwritten and verbalcommunicationskills.
• Passion for Data and Data Analysis with an eye towards Big Data.
• Expertise in creating and presenting key requirement artifacts,systems flow charts and logic diagrams to describe existing and proposed operations
• Ability to work independently on development projects
• Ability to work in a team environment; to work collaboratively with business users.
• Excellent analytical and problem solving skills with strong communication and interpersonal Skills.
• Substantialdomainknowledge inMedical, BankingandManufacturingindustries

TECHNICAL SKILLS

• Operating Systems
• Windows
• UNIX (Sun Solaris
• HP - UX)
• LINUX
• Database
• Oracle 11g/10g/9i/8i
• MySQL
• DB2
• General
• Good Programming Practice
• Technical Documentation
• Presentation Skill
• Programming Languages
• Oracle SQL & PL/SQL
• C
• C++
• JAVA
• Scripting
• Shell Scripting
• Other
• Webservices
• Oracle Weblogic Server
• Informatica
• ODI
• Tools: TOAD
• SQL Developer
• PL/SQL Developer
• SQL Plus
• MS Office
• Visio
• SVN
• ClearCase
• Notepad ++
• Excel

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

PL/SQL Developer

Responsibilities:

• Created Stored Procedures, Functions and Triggers to maintain various business rules.
• Actively participated in different phases of SDLC. Extensively worked towards optimizing the queries to enhance the performance.
• Involved in data Mapping, Transformation and loading data in a complex and high volume environment.
• Extensively worked on Data modeling, Performance tuning and optimization of Oracle queries.
• Create/develop Tables, Indexes, Constraints, Views, Sequences and Stored Program Units.
• Involved in data migration.
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance. Implemented Triggers based on the business rules.
• Wrote Database Triggers and stored procedures using PL/SQL
• Used PLSQL Records, Collections (Nested Tables and Varrays), SQL Object Types in complex backend packages.
• Developed and used number of explicit cursors in PL/SQL development.
• Efficiently used exception handling concept to handle runtime errors.
• Analyzed the existing stored procedures, Functions, Triggers and cursors on performance issues. Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR LOOPS, WHILE Loops while developing procedures.
• Worked with Dynamic SQL to achieve complex business requirements.
• Worked on DBMS SCHEDULER to automate jobs. Made use of DB Links for accessing data across different databases.

Environment: Oracle 11g/10g, SQL, PL/SQL,Toad, SQL* Plus, Quality Center, SVN, Oracle Fusion 11g

Confidential, Lincolnshire, IL

PL/SQL Developer

Responsibilities:

• Tune the SQL queries and complex procedures to improve performances.
• Created database triggers for data security and consistency.
• Written procedures, functions and packages for new requirements.
• Worked on design, development and testing of applications with Oracle as DB. Supported the backend part of the project.
• Implemented advanced PL/SQL concepts for better performance of PL/SQL Applications.
• Analyzed user requirements and writing optimized queries to retrieve data from Oracle database.
• Developed packages for processing data in the staging tables according to the clients requirements.
• Created materialized views and normal views where business requirements needed.
• Worked in unit, integration and performance testing.
• Documented changes and enhancements in code.
• Coordinated with the team of java developers to accomplish complex financial calculations.

Environment: Oracle 11g/10g, TOAD, SQL* Plus, Quality Center.

Confidential, Phoenix, AZ

Oracle Developer

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
• Designed and developed analytic and reporting solutions using Oracle PL/SQL.
• Created database triggers for data security and consistency.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages according to the requirement.
• Communicated issues and progress to project Manager.
• Worked with Oracle E-Business suite to support business process.
• Developed Packages for processing data in the staging tables according to the client requirements.
• Created new Tables, Indexes and Sequences where needed.

Environment: Oracle 10g, UNIX, SQL*PLUS, PL/SQL Developer, Oracle reports 6i, Oracle forms 6i,XML, Windows XP.

Confidential, Strongsville, OH

PL/SQL Developer

Responsibilities:

• Created stored procedures, Functions and Triggers to maintain various business rules.
• Managing Tables, Indexes, Constraints, Views, Sequences and Stored Program Units.
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance. Implemented Triggers based on the business rules.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR LOOPS, WHILE Loops while developing procedures.
• Gathered statistics and analyzed Tables and Indexes for performance tuning.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Used Advanced PL/SQL Concepts like Bulk Collect, PL/SQL tables and Dynamic SQL for better performance.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Turned SQL queries and complex Procedures to improve performance.
• Involved in Unit Testing for the application.
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment: Oracle 10g, UNIX, SQL*PLUS, PL/SQL Developer, Oracle reports 6i, Oracle forms 6i,XML, Windows XP.

Confidential, Dublin, OH

PL/SQL Developer

Responsibilities:

• Worked as a Database Developer.
• Created Procedure, Functions, Triggers, Cursor and handle exception using PL/SQL.
• Extensively involved in writing SQL queries (Sub queries and join conditions) for generating complex reports for analysis
• Involved in Designing, Creation and Maintaining of database for loading and production environment.
• Execution of Test documents for unit testing phase.
• Involve in redesign indexes and flows of stored procedure for enhance performance.
• Optimization of SQL queries, identifying problematic code, creation of indexes, re-writing queriesusing an optimized path and gathering necessary statistics on objects etc.
• Created Dynamic SQL queries to generate reports.
• Worked onUAT and Production support issues

Environment: Oracle 10g, SQL & PL/SQL Development, Procedures, Functions, Packages, Triggers, Cursors, Dynamic SQL, SQL*Loader, TOAD and Windows XP.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in user requirements gathering and analysis.
• Designed reports that had complex SQL, PL/SQL code. The filter conditions for the Queries were dynamic in nature and included lexical parameters
• Provided Technical documentation for the components developed.
• Designed and implemented the interfaces for Sales Order Information from legacy system to staging tables using SQL Loader and wrote various procedures and functions to perform validations to populate the data in the tables.
• Interacted with Business Analyst and client representatives and understood the requirements using the functional and requirement documents.
• Wrote Database Triggers and stored procedures using PL/SQL
• Used PLSQL Records, Collections (Nested Tables and Varrays)
• Developed and used number of explicit cursors in PL/SQL development.
• Efficiently used exception handling concept to handle runtime errors

Environment: Oracle Apps11.5.9 Implementation (modules:AR, AP, OM, SCM, Inventory), Oracle 9i, UNIX, PL/SQL, SQL, SQL*PLUS, SQL*Loader

Confidential

PL/SQL Developer

Responsibilities:

• Coded and implemented PL/SQL packages to house stored procedures and functions.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, indexes, packages, sequences, and synonyms.
• Enforced constraints for data validation and data integrity.
• Created Database links to maintain copies of remote data on the local node.
• Created INSTEAD OF triggers for modifying the views which cannot be modified directly by DML statements
• Worked on user defined and system defined exceptions to handle different types of errors like INVALID CURSOR, DUP VAL ON INDEX
• Loaded data sets to and from the Oracle databases using several kinds of tools such as SQL*Loader, Toad and external table facility.
• Participated in status meeting and walkthroughs.
• Worked on production support issues post implementation.

Environment: Oracle Apps11.5.7 Implementation, Oracle 9i, SQL*Plus, PLSQL Developer, Shell scripting