SUMMARY

• Having 7 Years of experience in development and testing of Web applications, Client Server as a PL/SQL Developer.
• Strong Development and Testing experience on different domains such as Telecom, Media & Entertainment and Banking applications.
• Extensive experience in using SQL & PL/SQL.
• Extensive experience in design and development and Configuration of Servers for various applications.
• Managing Users, Privileges and Roles, profiles, and other data accesses.
• Used PL/SQL collections to improve performance of the code.
• Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
• Created/Designed new tables, views, queries, PL/SQL Functions, packages, procedures for the new application, changes and Enhancements.
• Modified existing Unix Shell Scripts and scheduled UNIX scripts through Crontab.
• Involved in developing PL/SQL Procedures, Packages, and Triggers.
• Involved in query tuning to improve the performance Confidential site operation using Oracle 9i as backend.
• Experience in Complete Software Development life cycle (SDLC) and Software Test life cycle (STLC).
• Experience in performing Backend/Database testing and writing SQL queries from SQL Server, Oracle for Data Integrity and used TOAD to execute the queries.
• Experience in using Test Management and Defect tracking tools Quality Center, Test Director, Bugzilla and JIRA for fixing and Tracking the Defects.
• Proficient to develop Test Strategy, Test Plan, Test Scenarios, Test cases and Test Scripts.
• Experience in executing the Test cases and Test Scripts in different phases of testing like GUI Testing, Functional, Regression, Integration Testing, System and User Acceptance testing.
• TEMPHas good experience of SQL Server, Joins, Triggers, Stored Procedures and database connectivity for Back - end testing.
• Involved in writing and modifying UNIX scripts using commands as per the requirements.
• TEMPHas good experience in web servers, application servers and Database servers.
• Interacted with Business users, Project managers, and other team members to ensure problem solutions and user satisfaction.

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL

Data base: Oracle 9i, 10g, 11g and SQL Server 2005 and 2008.

Browsers: Internet Explorer, Netscape Navigator, Mozilla Fire Fox and VMware.

Scripting Languages: HTML, DHTML, UML and XML.

Defect Tracking Tools: Quality Center, Clear Quest, SVN, JIRA.

Others: MS Office, MS Excel, Word, PPT, MS Visio, Adobe, Acrobat, Win merge, VeryPDF, Visual Studio.

Operating Systems: Windows 2000, 2003, XP, XP Home, Vista and UNIX.

Protocols: TCP/IP, FTP, HTTP and HTTPS.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta GA

PL/SQL Developer/Oracle ADBA

Responsibilities:

• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Responsible for planning, scheduling, and implementing database upgrades and patches.
• Responsible for supporting Development/Testing/Training/Staging/Production environments.
• Identifies, maintains & controls database server’s configuration items.
• Managed users, roles and privileges, profiles, and other data accesses.
• Performed backups, restores and refreshing databases and applications.
• Ensured availability of client production systems and internal instances.
• Performed Windows Server and UNIX system administrator tasks as part of maintenance.
• Writing the script to monitor the database with shell and PL/SQL code such as procedure, function and package.
• Involved in all phases of database development from needs assessment to QA/QC, design and support.
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts.
• Expertise in creating databases, table spaces, tables, indexes and other database objects.
• Expertise on SQL Loader to load the data and Datapump utility to create new users in other Database Environments.
• Working on Enhancements of OPUS application and Working on Testing Issues and the deployments.
• Involved in patching and upgrading the testing and production Environments.
• Extensive experience in design and development and Configuration of Servers for various applications.
• Creating tables and views for developer and client needs.
• Involved in Performance Training Issues, Explain Plan and Replication->Oracle streams and Gloden gate.
• Working/Fixing on Database related tickets/issues in Dev/Training/QC/LT/Prod environments and deployments.
• Worked with development teams closely and provide assistance to developers as needed.
• Provided on-call support during the peak load of project delivery.

Environment: Oracle11g, Toad, Java, SVN, ClearQuest, Itrack, SharePoint

Confidential, Baltimore MD

PL/SQL Developer

Responsibilities:

• Involved in Developing stored procedures and functions for the VPS, VPSO, CCA &Register applications.
• Dealing with performance tuning Heavy SQL related issues and resolving the Issues with Oracle 9/10g
• (Advanced Functions) as to cope up with con-current processes to make sure no process fails due to thedelay in the preceding process/s.
• Verified the data in different DB tables as per the requirements.
• Analyzing new and altering the existing Stored Procedures to meet the customer requirement for implementing their business logic.
• Managed users, roles and privileges, profiles, and other data accesses.
• Used advanced PL/SQL concepts including Global Temporary table, Collections (Bulk Collect, Varrays, Nested Tables and PL/SQL Tables).
• Created new back end Triggers to provide the Foot Note functionality for all the major Transaction Screens.
• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Involved in loading large amounts of data with SQL Loader.
• Identifies, maintains & controls database server’s configuration items.
• Involved in all phases of database development, from needs assessment to QA/QC, design and support.
• Developed new packages to Import from Excel and Export to Excel functionality.
• Modified existing Unix Shell Scripts and scheduled UNIX scripts through Crontab.
• Created the new backend programs using PL/SQL Packages, Procedures, and Functions for submitting theJobs.
• Requirements gathering from Specs, Users/PM’s and documentation, data cleansing and extraction,report design and implementation, and testing.
• Creating Oracle Database objects based on the new requirement (Tables, Indexes, views, partitions,Constraints, triggers etc.,).
• Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
• Create the jobs and schedules them to run on the specific times and will not affect the system performance,Email notification setup for failure notifications.

Environment: SQL, PL/SQL, UNIX, Quality Center, MS office, Toad, SVN, ClearQuest, Itrack, SharePoint

Confidential, Orlando FL

PL/SQL Developer

Responsibilities:

• Performed Backend testing, writing SQL queries and execute in TOAD.
• Involved in implementing stored procedures for Reservation management, Accounting, Folio and Room Inventory management modules.
• Used advanced PL/SQL concepts including Global Temporary table, Collections (Bulk Collect, Varrays, Nested Tables and PL/SQL Tables).
• Dealing with performance related issues and resolving the Issues with Oracle SQL and PL. /SQL programs.
• Experience in using SQL queries to develop complex queries for data validation.
• Creating Oracle Database objects based on the new requirement (Indexes, view, constraints, partitions).
• Designed and developed new custom applications which support the daily business and synch with current level of application.
• Performing Unit test before going to Test team to make sure the software application works perfectly.
• Executed scripts in UNIX environment using putty.
• Developed complex Tasks for their trusted vendor requirements.
• Wrote the packages to provide vendor requirement data in their format as flat file.
• Involved in Pre-Production support for resolving the issues.
• Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily transaction.
• Loading the data into the application, which came in flat files and process them for correctness.

Environment: Windows XP, Quality center, UNIX, SQL, PL/SQL, Toad, MS office

Confidential

PL/SQL Developer

RESPONSIBILITIES:

• Involved in writing complex queries to generate reports as per client request as part of production support.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers.
• Wrote Procedures with bulk collection & bulk binding concepts for better performance.
• Scheduling UNIX jobs through Crontab.
• Involved in Unit Testing & Bug fixing.
• Worked closely with QA team in testing the developed Program units and successfully moving them to Production.
• Delivered a set of DDL scripts to create tables, views, primary/foreign keys, unique/check constraints, indexes, sequence and other Oracle database objects.
• Wrote stored procedure, packages, Functions, triggers, shell scripting (UNIX batch jobs) for the automation and scheduling of jobs. Confidential the application level to Register Concurrent program.
• Re-wrote PL/SQL stored procedures and optimized data.
• Created complex SQL queries, Stored Procedures, functions for the purpose of data analysis.
• Analyzing new and altering the existing Stored Procedures to meet the customer requirement for implementing their business logic.
• Involved in query tuning to improve the performance using Oracle as backend.
• Created/Designed new tables, views, queries, PL/SQL Functions, packages, procedures for new enhancement in the application.
• Modified existing Unix Shell Scripts and scheduled UNIX scripts through Crontab.
• Involved in developing PL/SQL Procedures, Packages, and Triggers.
• Developed Test Plans and Test cases for coding.
• Prepared the design specification documents, test plan for all the above modules.

Environment: SQL, PL/SQL, UNIX, TOAD, MS office.