SUMMARY:

• More than 12 years of experience in IT with emphasis on Software Development involving wide areas of Software industry.
• Expertise in Oracle, Pl/Sql, Crystal Reports 2008,Oracle Service Cloud,Microsoft SSRS.
• Excellent knowledge of PL/SQL.
• Vast working experience in software development environment, with focus on Backend Programming.
• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports, ETL.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Strong experience complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Strong experience working with stake holders to Determine reporting specifications
• Strong experience with Crystal Reports/OBIEE Designing, developing, reporting with Oracle back - end,Testing and deploying
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Extensively used QUEST TOAD 7.6.
• Team player with self-driven analytical mind thriving on challenges and responsibilities
• Oracle SQL and PL/SQL package and procedure development (Oracle 9i/10g).
• Involved in the full lifecycle from analysis and planning to development and deployment.
• Experience in technical support for the testing and implementation effort.
• Experience designing and developing Oracle data models including performance tuning.
• 4 years of experience as Delivery Project Lead.
• Expertise in basic database administration skills/experience (procedures for change control, test and production release.
• Participated in customer definition and design meetings to gather requirements and functional specifications.
• Extensively used ACCELA Automation Product.
• More than 4 Years of Experience as Project Lead
• Experience Working in Onsite Offshore Model
• Experience in Database modeling and design experience.
• Experience developing technical documentation.
• Experience in Batch Management, Batch Migration and Scheduling tools (Tidel, Autosys)
• Knowledge of best practices in the areas of application design, performance, scalability and maintainability.
• Expertise in Data mapping and data migration from Sybase (legacy) to Oracle databases.
• Expertise in designing Oracle database schemas.
• Expertise in Data Cleansing in the preparation of data migrations.
• Experience in Testing, Verfication, Documentation, DataAnalysis, Design related to Oracle database migrations
• Knowledge of design, development and implementation of Client/Server Applications, Web and
• Enterprise applications using the core Java, J2EE technologies, with using the WebSphere, IBM MQ Series Messaging, XML technologies including (XML Schema, XSLT, DOM and SAX Parsers) WEB SERVICES.
• Knowledge of SOA architecture.
• Knowledge of Financial-domain and Telecom-domain Workflow.

TECHNICAL SKILLS:

Databases: ORACLE 12c,11g,10g/9i/8i

Tools: SQL*Loader, SQLNavigator, AutoSys, TOAD,Embercardero Rapid SQL

Languages: SQL, PL/SQL, C, C++, UNIX shell scripts

Operating Systems: Windows NT/XP/200/2003, Linux, Sun-Solaris

Version Control: Visual Source Safe, Perforce, PVCS, CVS. Clear Case.

Others: Object Oriented Designing Methodology and RDBMS concepts

EXPERIENCE:

Confidential, Albany, NY

Senior PL/SQL & Crystal Reports Developer

Responsibilities:

• Understand and analyze the initial requirement.
• Prepared the questionnaire based on the analysis of the initial requirement document and share them with the agencies.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Extensively used SQL DEVELOPER.
• Extensively used ACCELA.
• Loading external data into database.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Used complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle 12c database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Worked on Crystal Reports/OBIEE Designing, developing, reporting with Oracle back-end,Testing and deploying
• Usage of various Built-In PL/SQL packages based on requirements.
• Working on Enhancements using Oracle 12c, Pl/SQL.
• Usage of various Built-In PL/SQL packages based on requirements.
• Conducted pre-analysis sessions with all the agencies and capture information for the questions raised in questionnaire document.
• Involved in developing complex reports using crystal reports.
• Project Lifecycle used AGILE methodology.
• Prepared the Data Conversion and Cleansing plan based on initial requirement document, pre- analysis sessions and answers to the questionnaire.
• Extensively worked on Crystal Reports, Oracle Service Cloud.
• Extensively worked on SQL Query Tuning.
• Involved in preparing testcases and testing the application.

Environment: Oracle 12c,SQL Plus, SQL Developer, SQL*Loader, Oracle Utilities, Crystal Reports 2008, MS Access.

Confidential, Tallahassee, FL

Senior PL/SQL Developer

Responsibilities:

• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Extensively used TOAD.
• Loading external data into database.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Working on Crystal Reports/OBIEE Designing, developing, reporting with Oracle back-end, Testing and deploying
• Usage of various Built-In PL/SQL packages based on requirements.
• Extensively used Crystal reports for reports development for e licensing,NYBE and License Lite.
• Working on Enhancements using Oracle, Pl/SQL.
• Developed Internal facing console reports using oracle service cloud.
• Extensively worked on SQL Query Tuning.
• Usage of various Built-In PL/SQL packages based on requirements.
• Involved in preparing test cases and testing the application.

Environment: Oracle 11g,SQL Plus, TOAD, SQL*Loader, Netezza, Oracle Utilities., Crystal Reports 2008, MS Access.

Confidential, Tallahassee, FL

Senior PL/SQL Developer

Responsibilities:

• Promoting the code the Test,Model Office and Production environments.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Supporting the Claims sub system
• Running UNIX Batch Jobs
• Extensively used TOAD and PLSQL Developer.
• Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Working on Crystal Reports/SSRS Reports,OBIEE Designing, developing, reporting with Oracle back-end,Testing and deploying
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Working on Enhancements using Oracle, Pl/SQL.
• Usage of various Built-In PL/SQL packages based on requirements.

Environment: Oracle 11g,Unix SQL Plus, Crystal Reports SQL* Navigator, Sybase, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Cleveland, OH

Senior PL/SQL Developer

Responsibilities:

• Writing code to extract the data from production.
• Writing transformations based on the required to load the data to IWMS
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Working on Crystal Reports/OBIEE Designing, developing, reporting with Oracle back-end,Testing and deploying
• Loading flat files to SQL Server and writing transformations as per the Business requirement and Loading data to csv files.
• Extensively used Embarcadero ORACLE SQL Developer and PLSQL Developer.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, andTriggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Working on Enhancements using Oracle, Pl/SQL.

Environment: Oracle 10g, SQL Plus, Crystal Reports, SQL* Navigator, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Winston Salem, NC

Senior PL/SQL Developer

Responsibilities:

• Developed the time critical data loading layer, to load the data to staging tables.
• Interacting with Users to resolve the issues related to SPS
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Production Support for SPS.
• Worked with stake holders to Determine reporting specifications
• Extensively used Embarcadero RAPID SQL.
• Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• Working on Crystal Reports/OBIEE Designing, developing, reporting with Oracle back-end,Testing and deploying
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Experience in using Tidel.
• Form scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL.

Environment: Oracle 10g, SQL Plus, Crystal Reports, SQL* Navigator, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Boston, MA

Production Support Module Lead

Responsibilities:

• Handling all types of Production issues.
• Interacting with Users
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Handling all types of Environmental issues.
• Worked with stake holders to determine reporting specifications
• Administrating Changes made in Network, Mainframe, Winnt, Firewall etc are done by ZeroDowntime plan, like having a backup or temporary resource to manage the downtime as ZDT.
• Extensively used QUEST TOAD.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, andTriggers.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Usage of various Built-In PL/SQL packages based on requirements.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL, UNIX
• Working on Post Mortems.
• Coordinating with Teams for the patching events.
• Extensively worked on Event Plan creation, Event Notifications and followup, EnvironmentNotifications, Project support, Incident management, change requests, Process improvements.
• Support Disaster Recovery testing.

Environment: Oracle 10g/9i, SQL+ Plus, SQL* Navigator, TOAD, SQL*Loader, Oracle Utilities, HP UNIX.

Confidential, Quincy, MA

Senior PL/SQL Developer

Responsibilities:

• Designed and developed the time critical data loading layer, to read data from various flat files and load the data into the liquidity schema.
• Interacting with Users
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries.
• Production Support for Charles River Development IMS.
• Loading and monitoring POC (proof of concepts) Loads.
• Worked with stake holders to Determine reporting specifications
• Extensively used QUEST TOAD.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
• Strong experience performance tuning complex SQL/PL SQL against an enterprise Oracle database, Data analysis and root cause analysis
• OBIEE Designing, developing, reporting with Oracle back-end,Testing and deploying
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Usage of various Built-In PL/SQL packages based on requirements.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL, UNIX
• Support Disaster Recovery testing.

Environment: Oracle 10g/9i, SQL+ Plus, SQL* Navigator, TOAD, SQL*Loader, Oracle Utilities, HP UNIX.

Confidential, Plano, TX

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports.
• Worked with stake holders to Determine reporting specifications
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and
• Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated PRO*C Programs as per the Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs

Environment: HP UNIX (Shell Scripting) with Oracle 10G & PL/SQL, Oracle Reports, Clear Case, Quality Centre 9.0, Citrix Neighborhood, VBA (for Automatic Report Generation tool)

Confidential, Hartford, CT

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated PRO*C Programs as per the Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Experience in using Autosys.
• Running UNIX Batch Jobs

Environment: HP UNIX (Shell Scripting) with Oracle 10G & PL/SQL, Oracle Reports, Clear Case, Quality Centre 9.0, Citrix Neighborhood, ITG (In-house defect logging tool), Autosys (Job scheduling), VBA (for Automatic Report Generation tool for Insurance Agents).

Confidential, Dublin, OH

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Developing Unix Shell Scripts based on User Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Unit Testing

Environment: Oracle 9I, Power Builder, UNIX, Win/NT, 2000, PL/SQL, Remote Desk Top, TOAD, PVCS Dimensions 9.0.