SUMMARY

• 8 + years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive experience in developing Oracle objects such as SQL Queries, tables, views, Sequences, Stored Procedures, Functions, Packages, Triggers, Views, Cursors, Packages and Indexes on Oracle.
• Used Collections like PL/SQL tables, arrays, nested tables extensively.
• Analyzing SQL statements using EXPLAIN PLAN to improve the system performance.
• Proficiency in PL/SQL programming to develop Data Migration using UTL File Package and loading data from flat files to DB tables using external Tables.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in SQL Server 2005, T - SQL
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER, Oracle AWR
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables
• Excellent knowledge onUNIX Shell Scriptsfor invoking SQL.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Involved in the development of enhancements related to Oracle Human Resources (Core HR), Oracle Payroll modules.
• Involved in the Clarifying queries related to payroll, absence and workflow issues to the business users

TECHNICAL SKILLS

Database Technologies (RDBMS): Oracle 8i/9i/10g/11g, PL/SQL, SQL Server 2005

Languages: UNIX shell script

Application Package: MS-Office

Reports Development Tools: Oracle Reports Developer Suite 10G

Operating Systems: MS-DOS, Windows, UNIX

IDE Tools: TOAD, SQL Loader, PL/SQL developer, SSMS

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer/Lead

Responsibilities:

• Work on the different JIRA tickets raised by the customers to automate the daily jobs.
• Working on the incidents, Work order and change requests as per the business need
• Working with the DBA team to create the Data model using ERWin tool.
• Work with DBA to analyze the database performance issues
• Tuning the queries based on the suggestions provided by DBA
• Work closely with the business team and the developers to resolve the issues on the portal
• Identify the areas to automate the manual efforts
• Working on the incidents related to the BI team
• Involved in the AGILE methodology implementation
• Performance tuning of existing procedures
• Involved in creation of primary database objects.
• Involved in development of stored procedures, functions and packages extensively using PL/SQL.
• Used Collections like PL/SQL tables, arrays, nested tables extensively.
• Writing Complex queries and packages to in corporate system functionality.
• Used Explain Plan for query optimization and Index creation for tuning / to improve the performance
• Involved in Unit testing of the objects.

Environment: Oracle 11g

Confidential, De Pere Wisconsin

Technical Lead

Responsibilities:

• Converts the manual reports into automated reports using PL/SQL and shell scripts which are used by business team.
• Work on the different projects to automate the daily jobs.
• Developed the data models using the ERWin Tool.
• Working on the incidents, Work order and change requests as per the business need
• Work with different vendors (Costco, Progressive, Road America, claims and sales)
• Work with DBA to analyze the database performance issues
• Tuning the queries based on the suggestions provided by DBA
• Preparing test plans and unit test cases after developing the new projects
• Identify the areas to automate the manual efforts
• Working on the incidents related to the BI team
• Involved in the deployment life cycle for the developed or modified projects
• Performance tuning of existing procedures
• Involved in creation of primary database objects.
• Involved in development of stored procedures, functions and packages extensively using PL/SQL.
• Used Collections like PL/SQL tables, arrays, nested tables extensively.
• Writing Complex queries and packages to in corporate system functionality.
• Used Explain Plan for query optimization and Index creation for tuning / to improve the performance
• Involved in Unit testing of the objects.

Environment: Oracle 11g, UNIX, Oracle report Builder

Confidential, Charlotte North Carolina

Oracle PL/SQL Senior Developer

Responsibilities:

• Acted as SME L3 for the application and coordinated with L1& L2 for the deployments.
• Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures.
• Establish an applications security requirements during development
• Keep the database administrator informed of required changes
• Conducted training sessions on the servers and the applications.
• Creating a procedures based on the requirement
• Coordinating with Application Admin and Application Support teams for the issue resolution
• Involved in patching the database servers and the application updates
• Involved in creation of Oracle database objects.
• Involved in development of stored procedures, functions and packages extensively using PL/SQL.
• Used Collections like PL/SQL tables, arrays, nested tables extensively.
• Writing Complex queries and packages to in corporate system functionality.
• Used Explain Plan for query optimization and Index creation for tuning / to improve the performance
• Involved in Unit testing of the objects.
• Developing Dynamic SQL Code.
• Develop Process for data upload from flat files to database tables using external tables.
• Bug Fixing in SIT and UAT environment.

Environment: Oracle 11 g, UNIX, SWIFT, SSRS

Confidential, Quincy Massachusetts

Oracle Developer

Responsibilities:

• Involved in all phases of the SDLC (Soft Development Life Cycle) from analysis design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.

Environment: Oracle 10 g, Manual Testing

Confidential

Oracle developer, SQL Server DBA

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Developed the data models using Erwin data modeler
• Database design through data modeler
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: SQL Server 2005, Oracle 10 g, SSRS

Confidential

Oracle developer, Oracle DBA

Responsibilities:

• Created users & privileges with appropriate roles and levels of security.
• Converted the reports from Actuate to Jasper using the XMLS
• Participated in data base design using the data modeler for Oracle
• Developed application to hold the Jasper reports loaded from the XMLS.
• Database Re-organization (Database, Tablespaces, Tables etc.). Re-Org is done from time to time for the primary storage objects like Tables, Indexes.
• Creates a number of Dev/Stg and prod Database instances.
• Performing logical backups using export utility and recovering specific object or schema using import utility.
• Monitoring and performing daily incremental backups, weekly backups.
• Troubleshooting performance issues reported by the application team.
• Backup of the production and Development Database, based on business requirements.
• Schema, Table, Database refreshes on demand for dev teams.
• Interaction with client/users on various issues.
• Experience in supporting production and development environments.
• Taking care of all other daily routine DBA tasks like creating users, roles, table space.
• Analyzing GUI problems.
• Locking and unlocking transaction codes.
• Monitoring Database growth, backup logs, archives directory status.
• Table space monitoring.
• Maintaining all the database servers on offshore.
• Provided different schemas for the developers with different privileges.
• Developed the Exception handling utility in all the procedures.
• Assisted the client with database issues.
• Supported the team by deploying the application.
• Created and maintained the database on Dev/QA/Prod instances.
• Implementing troubleshoot techniques for the issues that are going to occur.
• Reviewed all the procedures and allowed the developers to maintain the standards suggested by the client.

Environment: Oracle, Java, Developed Reports using iReport.