SUMMARY

• Around 8+years of experience in the development of client/server and multi tired applications using Oracle Database, SQL and PL/SQL of different platforms like Windows NT/2000/XP, UNIX and Linux. Good knowledge of key Oracle performance - related features, such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning, analysis, design, development, and testing of business applications in web based Client/Server architectures.
• Hands on experience in closing the tickets for the CDP/VBS application environment.
• Client interaction for the business process.
• Hands on experience in Coordinating and maintaining the Operational Readiness Review Database.
• Handling the review meetings with the work streams and stakeholders.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Implementation and Post Implementation surveys.
• Good knowledge of Data Base Administration.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications Development Toad, SQL Plus, PL/SQL Developer, UNIX and working knowledge of UNIX editors, Debuggers.
• Solid Experience and knowledge in ETL and Data warehousing concepts.
• Lead experience with the offshore and onsite from India/ China Development team.
• Hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions and Process Documentation.
• Good Knowledge in Oracle Apps 11i Technical and Functional with the modules like GL, AP, AR, I-Expenses, PO, FA, I-Supplier, BOM, WIP, and AME.
• Strong in using tools such as PL/SQL developer, SQL*Loader, oracle Discoverer, TOAD and SQL*Plus.
• Experience in performance Tuning and Explain plan, SQL loader, DBMS Scheduler, Utl File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
• Over 2 years of experience in designing job schedule, creating job scripts for scheduling jobs in AutoSys.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, SQL*Loader, SQL*Plus, UNIX Shell scripting, Performance tuning and Query Optimization, Proc C.
• Experienced in Dynamic SQL, PL.SQL Collections and Exception handling.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, and functions.
• Triggers, cursors, Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler, Oracle Advanced Queuing.
• Having knowledge in Perl Scripting.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Proactively interacted with Business Analytical, technical analysts, Developers, Testers and External clients.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i, Oracle reports 10g/9i/6i, ETL, Oracle Portal, SQL,PL/SQL, SQL Server 2005

Languages: SQL, PL/SQL, C, C++, AJAX, XML, HTML, CSS and Visual Basic

Query Tools: TOAD, PL/SQL Developer, SQL Navigator, and SQL* PLUS, ETL

GUI Tools: Oracle Forms 6i / 9i and 10g, Oracle Reports 6i/9i/10g

Operating Systems: Windows 95/2000/XP/Vista/Windows 7, UNIX.

Other Tools: Discoverer 9i, SQL*Loader, Putty, TWS, PVCS, BASE, CYGWIN WinSCP

PROFESSIONAL EXPERIENCE

Confidential - Cincinnati, OH

Sr. Oracle Developer

Responsibilities:

• Working for development ofWells Fargo bank credit card points system.
• Creating database object like package, function, procedure loading table through Sql-loader.
• Create a staging table and staging table history and a control file.
• Created packages to validate and load data from Wells Fargo into the database.
• Writing business logics to insert into database from staging tables running it from shell scripts.
• Created packages to extract the data from database into text filesto send themto Wells Fargo.
• Used bulk collect and bulk bind for improved results for both extraction as well as load.
• Used utl file utility in order to load and to insert the extracted data in text file.
• Responsible for moving the source code to UAT.
• Involved in Debugging and resolving the problem.

Environment: s: Oracle 10g, PL/SQL Developer 9.0, Putty 0.62, Windows 7, SQL*Plus, Unix.

Confidential - New York, NY

Sr. Oracle Developer

Responsibilities:

• Involved in the Basel 2 to Basel 3 transformation.
• Involved in gathering the requirements, Documenting from the offshore and onshore.
• Handling the CCP/LER/TT completely.
• Responsible for moving the source code to Production.
• Involved in Production Changes is the major part.
• Lead experience with the offshore and onsite from Singapore TT team.
• Scheduled backup maintenance updates meetings with the off shore team TT.
• Creating the UIT tags for the changes made in the code.
• Involved in Debugging and resolving the problem.
• Creating the patches for the Bug releases.
• Scheduled weekly status meetings and reporting monthly.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment (UAT, UIT, and TT) Management team in solving the raised issues.
• Supported developers for efficient SQL query and performance.

Environment: s: Oracle 10g, SQL Developer 3.1, Putty 0.62, RCS, Windows 7, SQL*Plus, Unix, Forms & Reports10g, Citrix, MKS.

Confidential - Rochester, NY

Sr. Oracle Developer

Responsibilities:

• Analysis of business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review from the CDB/VBS. Teams from offshore and onshore.
• Handling the CDB database completely.
• Responsible for moving the source code to Production.
• Involved in Production Changes is the major part.
• Scheduled review & status updates meetings with the stake holders and off shore team.
• Scheduled XMX/IMM meetings weekly and MOM process monthly.
• Based on the feedback, small enhancements have been implemented into the CDB/VBS.
• Used XMS application
• Involved in resolving the problem and requesting a solution in Problem Management and Change Management using MKS.
• Lead experience with the offshore and onsite from India Development team.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment Management team in solving the raised issues.
• Supported developers for efficient SQL query and performance.
• Created, maintained the Contract Database as per the required schedule dates and get the approvals before moving to production.
• Given transition to the new project mates.

Environment: s: Oracle 10g, SQL Developer 3.1, Putty 0.62, RCS, Windows 7, SQL*Plus, Unix, Forms & Reports10g, Citrix, MKS.

Confidential, MN

Tech Lead/Project Coordinator

Responsibilities:

• Maintaining the Operation Readiness Review database for the LVTS.
• Analysis of business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review from the SLM’s, workstreams & performance testing teams.
• Handling the ORR database completely.
• Responsible for moving the source code to Production.
• Involved in Pre-Production Changes that are part of a Pre-Production Environment.
• Scheduled review & status updates meetings with the stake holders and off shore team.
• Based on the feedback, small enhancements have been implemented into the ORR database.
• Used GIM application
• Schedule the jobs using Tivoli Work Scheduler.
• Involved in resolving the problem and requesting a solution in Problem Management and Change Management.
• Created ManageNow id’s as per the requirement.
• Lead experience with the offshore and onsite from India/ China Development team.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment Management team in solving the raised issues.
• Supported developers for efficient SQL query and performance.
• I am involved in developing Oracle Reports; maintain the database using PL/SQL.
• Created, maintained the ORR Database as per the required schedule dates and get the approvals before moving to production.
• Created the Environment Tasks Plan for Monitoring, Readiness, DR setup & other tasks.
• Created the Batch jobs using TWS.
• Involved in writing the shell scripts for checking the web, application provided production support and played a major role in debugging errors during implementation and deployment.
• Used shell scripting to change and modify data.
• Given transition to the new project mates.

Environment: Oracle 10g, ORR database, GIM Application, TWS, SQL & PL/SQL Development, Forms & Report, Dynamic SQL, SQL*Loader & Database Links, Pro*C, Oracle SQL Developer, UNIX Shell Scripting and Windows XP.

Confidential, Downers Grove, IL

Sr.Oracle Developer

Responsibilities:

• Analysis of new business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review.
• Created stored procedures, functions, Packages, data base triggers, constraints, indexes, grants and sequences based for Data Conversion and migration.
• Analyze capacity and growth of database using various automated stress testing tools and performance optimization.
• Responsible for moving the source code to Production.
• Created, modified and reviewed Procedures, Packages and functions and cursors to suit business requirements.
• Used Korn Shell scripts to automate Oracle import/export.
• Supported developers for efficient SQL query and performance.
• Handled database server tuning, application tuning and Normalized the database for better performance.
• Created maintained and compared objects in multiple schemas for developers.
• Reuse the Portals availability in the webcentral application.
• Written shell scripts for rebuilding existing databases to keep up with the latest developments.
• Provided production support and played a major role in debugging errors during implementation and deployment.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Used shell scripting to change and modify data.
• Integrated, tested, debugged and implemented application systems.

Environment: Oracle 10g, SQL & PL/SQL Development, Procedures, Functions, Packages, Triggers, Cursors, Dynamic SQL, SQL*Loader & Database Links, Oracle SQL Developer, Oracle Portal, Oracle Forms and Reports 9i, ERWIN, UNIX Shell Scripting, Unix and Windows XP.

Confidential, Orlando, Florida

Sr. Oracle Developer

Responsibilities:

• Involved in gathering the requirements, Documenting and Review.
• Participated in all phases including Requirement Analysis; Client Interaction; Design, Coding, Testing and Documentation.
• Created stored procedures, functions, Packages, data base triggers, constraints, indexes, grants and sequences based for Data Conversion and migration.
• Analyze capacity and growth of database using various automated stress testing tools and performance optimization.
• Supported developers for efficient SQL query and performance.
• Worked on Packages to encapsulate procedures and functions.
• Handled database server tuning, application tuning and Normalized the database for better performance.
• Responsible for performing Data Upload for all static tables using SQL*Loader.
• Extensively used Export/Import Utilities for performing logical backups and transferring data between other Applications.
• Involved in code reviews and acceptance testing of the application.
• Involved in creating Index’s, passing hints, analyzing the table statistics, testing the stored procedures for performance and Table partitioning.
• Improved performance of existing report views by using hints.
• Provide test data QA team to validate front end application and also involved in unit testing.
• Monitored all the Production, System Test and developments boxes for any errors in the logs and fix them as needed.
• Solving day to day issues rose with the loading process.
• Reorganized databases and seized database objects to meet standards and improved performance by 30%.

Environment: Oracle 9i/10g, SQL & PL/SQL Development, Procedures, Functions, Packages, Triggers, Cursors, Dynamic SQL, Oracle SQL Developer, Oracle Forms and Reports 9i, UNIX Shell Scripting, Unix and Windows XP.

Confidential

PL/SQL Developer

Responsibilities:

• Developing the Oracle reports based on the project requirements.
• Conducting the unit testing and performance testing on the reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Used TOAD to develop application code in PL/SQL.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle Reports.
• Created LOV’s for data elements in Oracle Forms.
• Created Master/Detail forms. Wrote SQL scripts to perform Back End testing of the Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended Design meetings, code review and test review meetings.

Environment: Oracle 9i, SQL & PL/SQL Development, Oracle Forms and Reports 9i, XML, Windows 98/2000/XP.

Confidential

Oracle Developer

Responsibilities:

• Developing the Oracle reports based on the project requirements.
• Conducting the unit testing and performance testing on the reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle Reports.
• Created LOV’s for data elements in Oracle Forms.
• Created Master/Detail forms.
• Wrote SQL scripts to perform Back End testing of the Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended Design meetings, code review and test review meetings.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Extensive experience in loading high volume data and Performance tuning.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes.
• Expertise in handling errors using Exceptions.
• Attended Design meetings, code review and test review meetings.
• Attended meetings and review to discuss current issues and processes to tackle issues.

Environment: Oracle 8i/9i, SQL & PL/SQL Development, Oracle Forms and Reports 6i, HTML & CSS, Windows 98/2000/XP.