PROFESSIONAL SUMMARY:

• 12 Years of experience in analysis, design, development, implementation and Production Support as SQL/PLSQL Developer/support person working on Oracle 9i/10g/11g platforms.
• Strong team player with excellent communication skills.
• Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Database Triggers using features like Cursors, Collections, Exception Handling and Bulk binding.
• Very strong in full suite of Oracle Tools PL/SQL etc.
• Good experience in Business object XIR2 reporting tool along with strong knowledge in Crystal report.
• Experience with oracle and other utilities like PLSQL developer, SQL Navigator and Toad.
• Strong skills in developing applications using Oracle RDBMS 10g/9i and developing reports using reporting tool.
• Very proficient in SQL tuning and optimization of queries.
• Strong experience in database designing, database development, enhancement, migration projects.
• Hands on experience working on UNIX platforms in developing shell scripts.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus.
• Experience in Designing and developing reports using BI/BO/crystal report Publisher.
• Proficient in preparing technical documents based upon user requirement.
• Have strong experience in Leading the team and handling production issues in crisis.

• Data Bases
• Oracle 11i/10g, Oracle 9i, Oracle 8i
• Oracle Tools
• SQL Developer, PLSQL Developer, SQL Navigator, TOAD
• Documentation
• Small work document (SMW), Test design document TDD
• Code Control Tools
• CVS, VSS
• Languages
• Oracle, SQL, PL/SQL, Unix Shell Scripting, Crystal report, BUSINESS OBJECT XIR2
• Office Tools
• MS Office, MS Project
• Development Tools
• SQL*Plus, Enterprise Manager (Import/Export)
• Other Tool
• Appworx

PROFESSIONAL EXPERIENCE:

Confidential, California US 

Tech Lead

Responsibilities:

• Involved in handling any issues related to confidential.
• Efficient in gathering requirement and writing plsql code.
• Worked in preparing functional document, user document, process flow diagram and flow chart.
• Loading with SQL Loader and to base table with interface programs.
• Involved in preparing complex queries as per client’s requirements.
• Participated in meetings with business users to understand and explain Data requirements.
• Interacted daily with business users and functional resource to gather facts of confidential.
• Efficient in working on AOTS tickets as YODA team.
• As an Onsite co - ordinator, also worked as mentor for new team member.
• Made good repo with client by being available for any issue at any time.

Environment: Oracle 11g, TOAD, Appworx, UNIX

Confidential, Alpharetta US 

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering requirements from business users, analysis and system design.
• Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
• Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Worked in preparing functional document, user document, process flow diagram and flow chart.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Loading with SQL Loader and to base table with interface programs.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
• Developed multiple views using Ref Cursor for reporting purposes on Order management system.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and Triggers to development needs.
• Worked for Performance tuning.
• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Used version control tools VSS/CVS to checking the scripts.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Review of the Technical Designs and Codes.
• Participated in meetings with business users to understand and explain Data requirements.
• Interacted daily with business users and functional resource to gather requirements for dashboard.
• Worked to create Unix shell script for loading data from flat files to Oracle tables.
• Hands on experience in scheduling batch jobs in unix CRONTABS.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application for Oracle procedures as well as Unix scripts.
• Also worked on Migration from Unix to Linux for cloud environment, tested Linux scripts after migration.
• Aware of Golden gate data synchronization process.
• Created Deployment scripts to deploy changes in production environment.

Environment: Oracle 11g, Oracle 10g, flat files, SQL Developer, TOAD, UNIX,LINUX, Windows XP,SQL Loader

Confidential, UK 

Senior Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Developed Technical design document for the business requirements.
• Created and modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Prepared requirement specification document that gives the comprehensive details about the Requirements.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Reports.
• Developed complex SQL queries, triggers for building different reports.
• Developed complex triggers in reports before/after for validation of user input.
• Worked in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
• Extensively worked on production issues with effective defect management.
• Design and development of customizations, Reports and all technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Wrote ad hock SQL scripts to assist QA in back-end testing and data validation.
• Developed custom reports and added columns in the existing reports according to the requirement.
• Developed new BO/Crystal reports using Universe.
• Involved in developing new reports as per Client Requirement.
• Provided technical support to the user with regard to operational aspects.
• Review of the Technical Designs and Codes along with leading team.

Environment: Oracle, PL/SQL, SQL, SQL Navigator, Crystal Report, Business Object XIR2.

Confidential 

Responsibilities:

• Developed Conceptual, Logical and physical data model and scripts to create users, roles and schema objects.
• Developed customized several reports using BO to meet the client requirement and necessities.
• Created Universe from scratch to build BO report environment.
• Developed and designed the Reports that had complex SQL, PL/SQL code and Stored Procedures. The Filter condition for the Queries was dynamic in nature and it included Lexical parameters.
• Wrote PL/SQL Database triggers to implement business rules.
• Interacted with the Users for the Business requirements and designed the layout for the reports.
• Involved in migrating the Business Object 8.5 to Business object XIR2. Solved Problems while doing Migration and corrected the Errors.
• Customized the reports and scheduled to gather data and mail using Business object reporting tool.
• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Sometimes it includes online System & Regression Testing.

Environment: SQL, PL/SQL, Oracle, SQL Navigator, Business object 8.5 and XIR2

Confidential

Oracle Developer

Responsibilities:

• Involved in understand new requirements.
• Involved in database design for each requirement.
• Developed several Procedures and Database Triggers as per Business requirement.
• Worked with Synonyms, Sequences, Views and Materialized Views.
• Documents the functionality into the form of business requirement document.
• Developed Forms like Invoicing, Delivery Order, Quotation, Stock Inwards, Stock outwards, adjustments etc.
• Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages.
• Code review for Logical errors.
• Involved in the support and maintenance activities.
• Testing and reviewing the programs.
• Unit and Integration Testing.

Environment: PL/SQL, SQL*Plus, Oracle database version 8i, ASP.NET, VB.NET