SUMMARY

• Over 10 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL and Java/J2EE Technology.
• Experienced in different Web technologies including requirements, Analysis, Design, Development, Testing and Implementation.
• Experience in front end development using HTML 5, CSS 3, JavaScript, J2EE technologies like Servlets, JSP, SOAP and REST web services, JDBC.
• Proficient in creating ER - Diagrams, logical and physical database design, data structures, and implemented large databases using Erwin.
• Extensively worked in Client-Server application development using Oracle 9i, 10/g/11g, PL/SQL and SQL *Plus.
• Rich experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, Dynamic SQL, Exceptions.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, FOR ALL statements, and Troubleshooting Oracle database issues.
• Experiences with Database Administration activities like Installation of Oracle Database, Oracle 10g Application Server, configure Database with DBCA, Oracle Enterprise Manager, Oracle Net Listener Configuration.
• Creating and managing Schema Objects, Users and their privileges, Backup and recovery.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, partition tables, external tables, materialized views, sub-queries and analytical queries.
• Expert in maintaining data integrity using various constraints and database triggers.
• Developed Test Scripts, Test Cases, SQL QA Scripts to perform Unit Testing, System Testing, Load Testing and Regression Testing.
• Experience in Informatica PowerCenter.
• Experience in programming languages like C, Java, VB Script, JavaScript and XML.
• Good working experience in Unix and Shell Script.
• Good working experience in version control tools like VSS, SVN and Bug Tracking Tool like Bugzilla.
• Worked on multiple projects simultaneously.
• Experienced in working in Banking & Finance, Health Care and Telecommunication.
• Self-starter with ability to work independently with good understanding of technologies such as Object Oriented Designing, web based application development, multi-tier Client/Server architecture, reusable components, security and work-flow.
• Proficient in interpersonal relations, team lead skills, project management, communication and presentation skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX/Linux Shell scripting, VB, VB Script, ASP, C, C#, JavaHTML, XML, Java Script, JSP

Databases: Oracle 10g/9i, MS SQL Server 2000/2003/2005 , MS Access

Tools: used: Erwin Data Modeler, PL/SQL Developer, Bugzilla (bug tracking), SVN, Informatica Power Center 9.6, Visual Basic6.0, SQL*Loader, SQL Developer, FileMaker, Front Page2000.

Operating Systems: Windows 95/98/NT 4.0/2000/XP/7, RH Linux 4.0 Enterprise, MS-DOS

Domain Knowledge: Banking, Finance, Health Care, Telecommunication

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Understanding the existing application architecture, flow of the system, making changes for customizing business needs.
• Provide parallel solution to support business requirements for the Second Brand(2nd Brand) Customer without impacting the existing process by replicating code and making necessary changes.
• Created web interface module using JSP, developed reusable components using JavaScript, XML and HTML.
• Writing PL/SQL stored procedures, creating views based on the functional requirement and technical specification document. Analyzing and making changes in the dynamically created tables and it's parameters in the stored procedures.
• Optimization of the SQL using data analytic functions with inline queries as a part of performance tuning.
• Using merge statement for bulk data updates has improved the performance significantly.
• Making Changes in the stored procedures to log the information into external file.
• Creating External table, retrieving and DML on external tables.
• Prepared test case document, sample test data for all possible scenarios for end-to-end processing.
• Understanding and making changes Linux shell scripts as per the requirement.

Confidential, MA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Understanding the existing application architecture, flow of the system and data modeling.
• Writing PL/SQL stored procedures, creating views based on the functional requirement and technical specification document. Analyzing and making changes in the dynamically created tables and its parameters in the stored procedures.
• Developed programs in JAVA for accessing the database using JDBC thin driver to execute queries, Prepared statements, Stored Procedures and to manipulate the data in the database.
• Using merge statement for bulk data updates has improved the performance significantly.
• Making Changes in the stored procedures to log the information into external file.
• Creating External table, retrieving and DML on external tables.
• Creating XML files from tables using SQL and parsing XML file to store the data into tables.
• Working on tuning PL/SQL Procedures/Packages to enhance performance designing new views, and triggers to cater modified ICD Code changes.
• Prepared test case document, sample test data for all possible scenarios for end-to-end processing.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Writing and interpreting Program specification from Functional Specification.
• Participating into discussion for clarification and implementation for new enhancements and defect analysis/fixing.
• Hands on as well as guiding team members for back end including Database and SQL related deliverables.
• Involved in release/configuration management using SVN/LiquiBase using Bugzilla and Whizible as trackers.
• Design and development of application using Java, J2EE & XML.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Developed Oracle PL/SQL triggers and procedures.
• Created records and nested tables in the procedures for handling of data.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Tuning SQL queries using Explain Plan and TKPROF utility to improve performance of the queries.
• Involved in managing security, granting and revoking privileges on database objects.
• Creating External table for data retrieval and processing.
• Perform Unit Testing to ensure technical accuracy and reliability based on Functional requirement and Technical specification document.
• Prepare sample data for various test cases in order to do end-to-end testing.
• Support for the development, test and the production databases.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, Windows XP, Bugzilla, SVN.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with clients to deliver new products, upgrades and program fixes.
• Created database objects, tables, indexes, procedures, SQL scripts.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles in different schema.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Worked on different types of Array’s (Collections, Record Types).
• Used %Row type and %type to define data types based on row and column respectively.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, inline, and correlated sub queries).
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Performed exception handling for the procedures created.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Involved in Impact analysis of the defects to the associated functionality and modules.
• Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Support for the development, test and the production databases.

Environment: Oracle 9i/10g, PL/SQL Developer, SQL Developer, Windows 2000, Front Page2000

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with clients to deliver new products, upgrades and program fixes.
• Active Participation in different in house project.
• Physical designing and development of Database
• Creating database objects like tables, synonyms, sequences and views
• Created and modified procedures and functions to suite the improved business requirements.
• Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing.
• Extensively worked towards optimizing the query to enhance the performance.
• Managed and resolved design issues during different phases of Project.
• Created records and nested tables in the procedures for handling of data
• Worked on different types of Array’s (Collections, Record Types).
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created.
• Created indexes for faster retrieval and improved query performance.

Environment: Oracle 9i/10g, PL/SQL Developer, SQL Developer, Windows 2000, Front Page2000, MS SQL Server 2005, Visual Basic6.0.

Confidential

SQL/Oracle Developer

Responsibilities:

• Gather requirement specifications from the client.
• Verifying functional spec by interacting with the client.
• Tracking progress, prioritizing work and prepared work plans.
• Writing PL/SQL Stored procedures, complex SQL queries, creating views, functions and triggers.
• Revisit stored procedures/views to determine compatibility with projected or identified client needs.
• Communicate status of assignments to Manager/Client on weekly basis.
• Involved in QA, functional testing, unit testing and integrated testing .
• Database/application Customization, support and troubleshoot.

Environment: Oracle 9i, SQL Developer, Windows 2000, Front Page2000, MS SQL Server 2005, Visual Basic6.0, FileMaker.

Confidential

Software Developer

Responsibilities:

• Gathering business requirements.
• Worked with many different clients to deliver new products, upgrades and program fixes.
• Active Participation in the System Study
• Physical designing and development of Database
• Creating database objects like tables, synonyms, sequences and views
• Created and modified procedures and functions to suite the improved business requirements.

Environment: Oracle 9i, SQL Developer, Windows 2000, Front Page2000, MS SQL Server 2005, Visual Basic6.0.