SUMMARY

• 8 years of experience developing software application systems with multi tired architecture, client/server, GUI Design using Oracle 11g/10g/9i database, SQL and PL/SQL.
• Experience working in all phases of SDLC Software Development Life Cycle which involves Analysis, Design, Development, Testing, Implementation and Support with extensive exposure in database applications using Oracle technologies.
• Expertise in SQL, PL/SQL, Tables, Joins, Views, Functions, Stored Procedures, Packages, Synonyms, Sequences, Cursors, Ref Cursors, Triggers for processing data, enforcing referential integrity and needed business rules.
• Experience on Table Partitioning, Autonomous Transaction, Compound Triggers, Collections, Dynamic SQL and Materialized Views.
• Experience in using Bulk Collects, Bulk Load, Regular Expressions, FORALL and Merge.
• Performing analysis and table statistics for Query Optimization.
• Using SQLTRACE, EXPLAIN PLAN, TKProf for tuning SQL and PL/SQL code for better performance with the help of Hints, Bulk collection techniques and Indexes.
• Experience in developing user interface for database applications using the Oracle Application Express Apex .
• Worked on Oracle Forms and Oracle Reports.
• Knowledge of UNIX shells scripting.
• Performed multi source extraction transformation and loading ETL using SQL Loader.
• Tested deliverables for conformance with requirements and specifications.
• Can easily learn new concepts and applications.
• 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.

SKILL SET

EXPERIENCE

Technology: Oracle Application Express APEX , SQL, PL/SQL, Oracle 10g, Developer/2000, Oracle Developer

Role: Oracle Database Developer

Description: Deals application is designed and used for productivity enhancement for Consulting Sales department. It is considered as an enhancement to the existing Global Risk Management Bid Review System in Oracle. It eliminates email transmissions to get a deal reviewed and approved. This application provides improved audit ability and ease of use for business approvers. It also provides deal and deal approval metrics to measure sales cycle performance.

Contribution:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created new pages and edited existing pages in the Deals application which is built using Apex application through Oracle PL/SQL.
• Involved in bug solving as well as completing new enhancements within project deadlines.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• Created new procedures and functions as per requirement. Also edited existing packages to get the desired output as per new requirements.
• Involved in creation of complex views and triggers.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Used Bulk Collect feature to improve performance.
• Developed web layer design of the application using Oracle Apex.
• Fine tuned PL/SQL programs and SQL Queries for the maximum efficiency in various schemas across databases using oracle Hints, Explain Plans, Trace sessions and TKProf for Cost Based Optimization CBO .
• Developed PL/SQL Procedures for efficient error handling process by capturing errors into user managed tables.
• Designed and performed unit testing and reviewed with project management.
• Deployed the change releases to non-prod databases for UAT testing and moved changes to production.
• Interacted with the End users to gather user specifications and suggestions on a regular basis.
• Worked closely with the testing team to resolve day to day production issues.

Data integration management program librarian enabled

Technology: Oracle Application Express APEX , SQL, PL/SQL, Oracle 10g, Developer/2000, Oracle Developer

Role: Oracle Database Developer

• Description: The Data Improvement Management Process Librarian Enabler DIMPLE is a data quality work flow enabler used currently by the Global Sales Data Quality Data Desk to manage the work flow of data quality tasks. It handles the nuts and bolts of portioning work for data quality activity out to the data librarians.
• DIMPLE manages the activities of global sales data librarians and provides performance metrics. Instead of requiring a single line of actions through an entire task, DIMPLE allows a team of data librarians to optimize work at each individual step of a task. This pipelining of work across multiple team members dramatically improves productivity and allows specialization for each step. The performance metrics allow managers to evaluate the performance of team members and keep abreast of the status of in work projects.

Contribution:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• Created new pages using Apex application through Oracle PL/SQL.
• Created stored procedures, views, packages, functions, sequences, synonyms as per requirement using Oracle SQL Developer.
• Involved in creation of complex views and triggers.
• Created the indexes and analyzed the table for better performance.
• Involved in bug detection, analysis and fixing.
• Involved in creating desired new enhancements.
• Wrote Packages containing several Procedures and Functions in PL/SQL.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Fine-tuning the database by creating indexes and running explain plan on SQL scripts and using optimizer hints if necessary for faster retrieval data.
• Worked on scheduling Jobs using DBMS JOBS package for manually loading the data required for different processes.
• Involved in day to day meeting with development team in agile environment updating with further steps and providing feedback on current work.
• Designed and performed unit testing and reviewed with project management.
• Deployed the change releases to non-prod databases for UAT testing and moved changes to Production.
• Worked closely with the testing team to resolve day to day production issues.

Technology: SQL, PL/SQL, Oracle 10g, Developer/2000 Tools, Oracle Developer

Role: Database Developer

Description: The firm specializes in Portfolio management, fund management and investment management. It is a major player in corporate advisory, equity broking, stock advice and portfolio diagnostic.

Contribution:

• Migration of existing database from MS SQL Server 2005 to Oracle 10g.
• Development of new requirements and enhancements in Oracle 10g.
• Involved in creation of tables, partitioning tables for business application development and as per business rules from the client.
• Created stored procedures, views, indexes, functions, explicit cursors as per requirement.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted into the tables.
• Wrote Materialized views and complicated queries using SQL.
• Worked with different types of sub queries Inline, correlated and used for loop and while loop to suit the business logic.
• Used advanced Bulk techniques ForAll, Bulk Collect to improve performance.
• Identified if any programs or any updates in the table or any deletion by setting up the DBMS JOB package.
• Use of sequences to automate number generation.
• Involved in database normalization and performance tuned the PL/SQL stored procedures.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Interacted with users regarding the proposed solution and design for customization and the migration strategy of the database.

Technology: SQL, PL SQL, Oracle 10g, Developer/2000 Tools, Oracle Developer

Role: Database Developer

Description: Rak Bank is leading national bank of UAE and oldest financial institution serving over 400,000 customers. This software serves end-to-end requirements of a prepaid card issuer including program management, card life-cycle management, registration, fee management, authorizations, transaction processing, account funding, dispute management, risk management, customer care and card holder self-care.

Contribution:

• Involved in development, design and coding of forms for visa incoming files, transaction processing, etc.
• Wrote PL/SQL procedures, packages, triggers in Oracle 10g and Oracle Forms as required.
• Worked extensively on customizing existing forms appearance, validation logic, behavior and incorporating new functionalities to the existing forms.
• Developed Forms level validation triggers, Procedures, Alerts, Record Group, LOV etc.
• Customized and created various reports using Oracle Reports and registered them under the concurrent manager.
• Involved in fixing the bugs detected by the client and completing the new enhancements in the application as required by the client bank.
• Involved in design, coding and development of reports, pl/sql functions, procedures, views and triggers.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Experience in writing complex SQL queries using joins, sub queries and correlated sub queries.
• Performed SQL tuning using Explain plan and Auto Trace.
• Documented business rules, technical designs, test cases, and user guide.

Technology: DB2, Z OS, JCL

Role: DB Development

Description: SafeCo is an insurance company based in the US. It offers various insurance policies to customers like providing health, life and auto Insurance. Its web portal incorporates a wide range of features for policyholders and new customers. Worked on an application that took care of online account services which included member enrollment, account summary, billing history, online payments, updating customer profile, ordering auto insurance ID cards, claims, and subscriber billing.

Contribution:

• Involved in fixing the bugs detected by the client and completing the new enhancements in the application as required by the client company.
• Worked on starting and stopping DB2 subsystems.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Analysis and recommendation for best access path for the application programs.
• Performed data verification and validation in a batch and interactive IBM MVS Mainframe environment.
• Updating the statistics of data into DB2 tables.
• Performance Monitoring and tuning recommendations for the applications.

Technology: VB.Net 2, SQL Server 2005, ADO.net, Crystal Reports11

Department: Health care Domain

Role: DB Administration

Description: ProDoc is an advanced medical information technology solutions that is built to address the specific problems faced by doctors, clinics and hospitals. This practice management software can integrate the workflow processes of any healthcare practice with other administrative applications, to provide an end-to end seamless solution.

Contribution:

• Experience in designing, developing, testing, deploying, and modifying end-user reports using Crystal Reports.
• Converted/migrated reports from lower environment to higher in Crystal reports.
• Experience in installing and configuring SQL server.
• Experience in performing database administration tasks like periodically taking database backups and database recovery.
• Performance monitoring and tuning of SQL code.
• Responsible for dealing with problems, DB bug fixing and troubleshooting.
• Involved in user creation and assigning Roles and Privileges.
• Wrote stored procedures, functions, views, triggers as per requirement.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.

Technology: SQL, PL/SQL, Oracle 9i, Developer/2000 Tools, PL/SQL Developer 7.0

Role: Software Engineer

Description: Business Intelligence reporting for Central Railway Nagpur DRM. The project involved Oracle forms and reports development in payroll and Quarter modules. System was developed to generate forms. It supported for inquires and different ad hoc queries and reports. Creation of new vendor and his balance was also considered.

Contribution:

• Involved in the development, design and coding of forms using Oracle Forms.
• Involved in program development.
• Involved in generating reports using Oracle Reports.
• Extensively use cursors and exception handling.
• Created DDL scripts, indexes, sequences, synonyms.
• Worked on SQL query tuning using explain plan and auto trace.
• Modified several reports to add custom fields, layout objects and altered layouts as per client requirements.
• Involved in developing a program module using PL/SQL procedures, packages, views, sequences, synonyms and triggers.
• Created PL/SQL functions to facilitate business functions and calculations.
• Developed, tested and migrated the Oracle PL/SQL scripts to production.
• Wrote document for user manual.

Technology: SQL, PL/SQL, Oracle 9i, Developer/2000 Tools, PL/SQL Developer 7.0

Role: Software Engineer

Description:

System was developed to generate forms. All the forms from Indent to Purchase Order were generated. It supports for inquires and different ad hoc queries and reports.

Contribution:

• Involved in the development, design and coding of forms like Indent generation, Vendor inquiry, Purchase Order.
• Enforced database integrity using primary keys and foreign keys.
• Developed the program module using PL/SQL procedures, function, packages, triggers, etc.
• Involved in the study of the present system and collection of information from the company employees.
• Worked on PL/SQL code optimization techniques and error handling mechanisms.
• Working with Oracle databases to manage data for development, testing and production environments.
• Developed detailed Custom Reports as per the manager requirements.
• Resolved application-related issues and documenting procedures.