Summary

• Over 1o years of experience in experience in Design, Development, Enhancement and Maintaining applications using Oracle 9i/10g/11g , SQL, PL/SQL , and DBA activity.
• Strong knowledge in Oracle 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms 9i/6i, Reports 9i/6i, UNIX Shell Scripting.
• Good experience in Oracle Database Installation, configuration and Administration, Backup and Recovery, Database Migrations.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control ,AWR, ADDM, STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Experienced in identifying business requirements, technical requirements, database design and troubleshooting.
• Extensive experience in Oracle Technologies in back-end oracle database design, development, testing, performance tuning, production migration.
• Extensive experience in Oracle Development in table design, writing stored procedure, database triggers, functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
• Good command over creating and managing database objects like Views, Clusters, Indexes, Sequences, partitions etc.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Used ETL features like Merge, SQL loader, external tables, pipelined/table functions.
• Used Oracle Data Integrator to move data from text files to Oracle database.
• Used partitioning and sub partitioning to improve performance.
• Experienced in development through the full life cycle at CMM level 3
• Involved in preparing Release Notes and Implementation Plans.
• Involved in doing unit testing, system testing, acceptance testing and Shakeout test.
• Experience in Collections Nested Table, Varray and Associative Array , collection methods and Autonomous Transactions, Bulk Collect and Bulk Bind.
• Experience in Oracle streaming.
• Used SQL profiling for Query Plan and tuning.
• Perform Sizing estimations of different objects getting created as part of new releases, monitor organic growth of DB Objects.
• Forecasting the space requirement.
• Experience in resolving performance issues by analyzing AWR/ADDM reports, V Dynamic performance view.
• Extensive experience in SQL tuning and understanding of business requirement/frontend application
• Excellent interpersonal and communications skills. Ability to interact with people at all levels and good presentation skills.
• Used data modeling tools like ER-WIN and ER diagrams, Normalization Techniques for designing database with Relational technology

Provided scripts for all sort of modification table creation, index creation, package creation, all sort of alterations associated with new release to deployment team.

• Worked in Oracle RAC Real Application Cluster environment.
• Extensive experience in Data Migration through SQL Loader.
• Good hands on experience in OLTP, ODS database.
• Worked on Recovery Manager RMAN .

SKILLS:

PROFESSIONAL EXPERIENCE

Confidential

Role Database Administrator DBA

The Rx-Connect software system is being built to meet the CVS Store operations needs. It is an online transactional software system enabling pharmacy to fulfill the needs of prescription filling, drug dispensing and verification activities. The system captures all interactions with the CVS customer and provides functionality to fill the prescription in an easy and efficient manner. The system will support the CVS enterprise organization consisting of multiple pharmacies dispersed across a large geographically area.

• Developed data quality checks queries to validate the data loaded in stage.
• Developed procedures and functions to automate the validation process.
• Developed procedures for Universal data driven solution for automating the validation process.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• AWR and ADDM report analysis.
• Creating many procedure's and query for data preparation
• Query optimization and Tuning.
• Created scripts for new tables, views, queries for new enhancement in the application using
• Worked on preparing Quality Documents for Coding Best Practices for Oracle and Coding Standards.
• Written/Debugged Packages, Procedures, Functions and Triggers.
• TOAD to create new workflows for Company.
• Extensively used Oracle Stream, SQLT and SQL Profiling for tuning of database.
• Extensively used OSWATCHER for Tuning of database at OS level.
• Extensively used Partitioning methods for Performance and Tuning.
• Worked on Oracle Streamlining for data replication.
• Wrote many shell scripts for data loading.
• Monitor performance metrics during peak load.
• Planning with the concern teams to reschedule batch jobs at destination for accounting latency
• Developed scripts to create huge synthetic data over 20 million records with integrity constraints to populate in Simulated DB environment.
• Extensive experience in SQL tuning and understanding of business requirement/frontend application.
• Perform Sizing estimations of different objects getting created as part of new releases.
• Worked on Table Re-partitioning and Table Redefinition.
• Involved with DBA team in Database migration from oracle 10G to 11G.
• Worked on RMAN toll.
• Good experience in applying Critical Patch Update CPU Patches on Databases.
• Expertise in replication technologies including Oracle STREAMS and MATERIALIZED VIEWS.

Environment: Oracle 10gR2, 11gR2, AIX 5/6 , TOAD , PL/SQL Developer.

Confidential

Role - Sr. Database Developer/DBA

Project:

The scope of the project is to understand current application, design, develop, test, rollout, support and document. TCS will be working with CVS Pharmacy team for the software development/Testing part of the Third Party Management System.

Responsibilities

• Developed data quality checks queries to validate the data loaded in stage
• Developed procedures and functions to automate the validation process
• Developed procedures for Universal data driven solution for automating the validation process
• Tuned SQL queries and performed refinement of the database design leading to significant improvement
• in system response time and efficiency.
• Continuous Interactions with onsite team for requirement gathering and analysis, especially during
• Change requests.
• Development of new module and CR Change Requests
• Handle major modules as technical as well as functional.
• Grooming new Team Member in terms of technical as well as functional.
• Designed and developed PL/SQL stored procedures, functions and database triggers required
• in the application.
• Took Responsibility as a Production Lead and resolve all the technical issues related to PL/SQL batches
• and involve in Performance Tuning of SQL Queries.
• Perform Sizing estimations of different objects getting created as part of new releases.
• Forecasting the space requirement
• Assist architecture team in redesigning application load balancing with addition of new node.
• Developed many Batch code for Batch Processing Jobs and implement corn tab through shell scripting.
• Worked in Performance tuning of oracle databases using Oracle Grid Control ,AWR, ADDM,
• STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Worked on Recovery manager tool RMAN for database restore and backup.
• Perform Sizing estimations of different objects getting created as part of new releases.
• Worked on Table Re-partitioning and Table Redefinition.
• Extensively used Oracle Stream, SQLT and SQL Profiling for tuning of database.

Environment: Technical Environment: Oracle 10gR2, AIX 5/6, TOAD, PL/SQL Developer

Confidential

Confidential

Role Sr. Oracle Developer/Application DBA

Confidential

Nucleus Software works on banking projects and has its own product name FINNONE. Finnone include lending, cash, and deposit and FAS Finance against Securities solution of banking. I was a team member of a project team, and worked on a module Loan Management System LMS .

Responsibilities

• Developed procedures and functions to automate the validation process
• Developed procedures for Universal data driven solution for automating the validation process
• Configured Flat File and Oracle Data Source.
• Used Clear case to check in code.
• Developed migration scripts for migrating code to UAT and SYSTEM TEST
• Involved in Development and design of data model for the Finnone Banking application
• Created and modified design documents
• Analyzed Business requirements and created and modified design documents
• Generate 6 Sigma reports for the data quality check for the Business
• Involved in preparing Release Notes and Implementation Plans
• Involved in Builds and Deployment.
• APLUS data analysis and mapping for migration in Finnone Tables.
• Data migration of Customer, contract, guarantor and Payment for shopping credit portfolios 3000
• approx .
• Billing, allocation and outstanding calculation for about20 lacks of contracts loans for guarantee and
• non Guarantee portfolio.
• Managing team of 4 efficiently and handled the bulk and incremental migration for shopping credit.
• Optimization and Performance tuning - Experience in designing and maintaining Tables in Oracle
• 9i.Issues handled by optimizing queries and reducing processing at time of Applications Implementing
• the logical code in form of Triggers, Packages, procedures and functions.
• Client interaction with high proficiency.
• Project timelines issue handling Offshore Support .
• Development of new Oracle Forms for ever changing requirements of client.
• Customized the front end interface for the users using Oracle Forms 10g.
• Tracking project status and provide status reporting, issues and manage the resolution process.
• Charting out different impact analysis on the migration activity with an alternate strategy for system
• Conversion. Interacting with the client for gathering and managing the requirements.
• Estimation, Coding, and Code review, testing.
• Tuning queries in SQL and PL/SQL.

Environment: Oracle 10G, 11G, Clear Case, Form 6i, 9i, Report 6i/9i

Confidential

Role - SR Oracle Developer/Application DBA

Project:

Aplus is a guarantor Non-banking financial corporation in Japan which is responsible for taking guarantee of customers who take loan on the basis of Shopping Credit card. Mortgage solutions provided by us are designed according to user specific requirements which cater to the specific needs of the individual customers. I Work for Offshore customization as per user's request which includes taking requirements from the customer and getting them developed in order to provide cost effective quality solutions. Working in a team of more than 40 professionals. My profile involves guiding my team in Data migration, developing, rectifying testing ensuring successful implementations. Apart from this, I work in migration, customization and enhancements required by the users ensuring timely production deliveries.

Responsibilities

• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, synonyms and database triggers to meet the business requirements.
• Executed upload and load procedures to check the data feed is correctly getting loaded in to the tables.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Performed extensive SQL tuning and optimization on queries generated by reporting front-end packages and developers Using explain plan etc. Data loading/extracting using SQL Loader, import, export etc.
• Worked on the problem resolution and support of many issues during development and testing phases
• Consolidated data from subsidiaries non-oracle systems by importing data and from other subsidiaries Oracle systems by transferring balances using PL/SQL.
• Performed Administrative tasks like adding security, granting privileges, and scheduling and sharing of Business Areas and Workbooks.
• Worked on the forms customizations using Forms developer and custom .pll changes.
• Worked on the month end closing processes and month end reporting.
• Development of new Oracle Forms for ever changing requirements of client.
• Customized the front end interface for the users using Oracle Forms 10g.
• Worked in Data migration team.

Environment: Oracle 10G,11G, Form 6i,9i , Report 6i/9i , Clear Case, Oracle 10 g AS Release 1

Confidential

Role - Senior Oracle Developer/DBA

Confidential

Project:

IAP has a technical and academic alliance program with more than 40 companies and organizations worldwide, creating a pooled workforce of over 5,000 employees. As such, we transcend time zones bringing our skills and services to meet client needs 24-hours a day, 7-days a week.

Work on implementation/customization of exiting software OCMS , developed new Forms/Reports and implemented carious procedures for monitoring purpose, Backup of database and tuning activity and provide Technical support to other team member at client side.

Responsibilities

• Wrote PL/SQL Procedures and Functions to validate data in custom tables and populated Invoice interface tables.
• Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting.
• Tuning of SQL queries for enhancing the load performance.
• Wrote Scripts for creation of database objects like tables, views, indexes etc
• Expertise in using UTL FILE packages to extract data into flat files.
• Developed packages, Stored Procedures, views and cursors using PL/SQL, Oracle 9i.
• Responsible for creating stored procedures and packages.
• Involved in creating new tables, views, developed queries and stored procedures.
• Developed stored procedures, views and cursors using PL/SQL.
• Analyzed the existing database model and involved in re-organization of table structures.
• Responsible for designing and developing application by modules for user management module.
• Involved in system study, designing, developing, testing and implementing of the project
• Responsible for developing and Creating new custom form using Template.fmb as per the client requirement
• Developed forms and reports as per the requirement of the system
• Expertise in Registering Reports as Concurrent Programs and Creating Value Sets, Registering Forms, Functions, Tables and Creating Menus.
• Customized existing reports and developed new reports for users.

Environment: Oracle 10G, Forms 6i , Reports 6i.

Confidential

Role - Oracle Developer

Involved in design and migration of data from SQL Server Billing System to Oracle 10G .Developed oracle applications for Dairy management for Mother Dairy India Ltd. MDIL , developed forms and reports as per the requirement of the system Expertise in Registering Reports as Concurrent Programs and Creating Value Sets, Registering Forms, Functions, Tables and Creating Menus Customized existing reports and developed new reports for users

Responsibilities

• testing phases
• Worked on the problem resolution and support of many issues during development and
• Performed extensive SQL tuning and optimization on queries generated by reporting front-end packages and developers Using explain plan etc. Data loading/extracting using SQL Loader, import, export etc.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• enforcing business rules.
• Developed Complex system and application triggers using PL/SQL for data integrity and
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Executed upload and load procedures to check the data feed is correctly getting loaded in to the tables.
• Created and maintained database objects like tables, views, materialized views, synonyms and database triggers to meet the business requirements.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Developed SQL Loader scripts for loading data
• Developed Custom Reports/Forms as per the Client Requirement

Environment: Unix,Oracle 9i Forms/Reports 6i ,SQL Server, Access, Erwin 7.1 Data Modeler, Sql Developer. Toad.