SUMMARY

• 8 years of experience in Information Technology.
• Technical Lead with extensive experience in Database design, Database Migration as well as performance optimization skills.
• Specialist in Oracle database and Oracle PL/SQL development.
• Domain experience in Banking Credit Risk Management, Capital Requirement Calculation Fund services Life Insurance Annuities and Claims and ERP.
• Extensive experience in leading database technologies such as Oracle 9i/10g/11g, SQL Server Sybase ASE.
• Expertise in Oracle SQL, Analytical functions, PL/SQL, SQL Loader, UNIX Shell scripting, Performance tuning, Data modeling, Data Analysis and Development DBA Activities.
• Strong knowledge in developing PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links triggers.
• Strong knowledge in Table partitioning as well as database design.
• Experience in providing end - end solution for data extraction and loading.
• Extensive experience in Onsite/Offshore model and experience in handling offshore teams.
• Strong knowledge in Oracle file handling utilities such as SQL loader UTL FILE.
• Solid knowledge on Oracle 9i/10g/11g architecture.
• Extensive hands on experience in performance tuning of SQL queries PL/SQL programs.
• Thorough experience on Information Technology domain with key emphasis on Analysis, Design, Development, Unit as well as UAT testing, production deployment and Application Management.
• Sound experience in design, develop maintain data load processes, backup processes and reporting frameworks.
• Oracle certified professional in Oracle 9i advanced PL/SQL.
• Good knowledge on SQL server.
• Decent knowledge on Crystal Reporting tool and Microsoft .NET

Technical Skills

Programming Languages

Oracle SQL PL/SQL, Sybase SQL, SQL Server, UNIX Shell scripting

Databases

Oracle 9i/10g/11g, Sybase IQ 15, Sybase ASE SQL Server

IDE Tools

TOAD, PL/SQL developer, SQL Developer, ASE iSQL

ETL Tools

Erwin, Toad and Microsoft Visio

Reporting Tools

Crystal reports 10/11

Version control tools

Microsoft Visual Source Safe CVS

Other Utilities

Oracle SQL loader, Putty, WinSCP, HP Quality Center

Operating Systems

Windows UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Lead Oracle PL/SQL Developer

Description: Pricing Request System is an intelligent, workflow management web application that defines and facilitates the end to end pricing process.

Responsiblities:

• Analyzed Internal External Source systems and Business Requirements to develop Health Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL Facts and Dimensions and Business Process Model.
• Developed back end interfaces using Tables, PL/SQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems by using Hints, Indexes, Partitioning and analyzing the Stats updates.
• Extensively usedtheTriggers, Indexes, Views and Materialized Views for the Application design.
• Performed subsequent alterations usingSQL, PL/SQL to make any changes on adhoc requirements.
• Implemented Business Rules using PL/SQL Procedure/Packages with complex water fall calculations.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Developed PL/SQL Procedures, Functions and Packages for Business Intelligence.
• Actively involved in Data Mapping of tables from Source system to Target system, including preparation of Entity Relationship Diagram.
• Involved in Data Extraction, Transformation and Loading ETL process from source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Data Migration and Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Used UNIX Shellscripts KORN for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Environment:

• Java, J2EE, JSP, Log4J, JavaScript, Tomcat, CVS, HTML, Eclipse, Struts, Weblogic 10.3, Ant, Red hat Linux 4, MS Windows 7 professional, Oracle SQL Developer
• Database: Oracle 10g, Oracle 11g Cluster.

Confidential

Role: Oracle PL/SQL Lead

Description: Confidential program has been designed where group and corporation are parties to a Primary care physician PCP participation agreement whereby group participates in the carefirst Blue choice participating Provider network maintained by corporation which was established a voluntary medical primary care medical home programme for the purpose of rewarding primary care physician for providing, arranging, coordinating and managing quality, efficient, cost-effective, health care services for individuals enrolled in health benefit plan issues and administrated by corporation Members .

Role and Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Installed new databases, upgraded existing databases, created new database instances
• Involved in creating PL/SQL Packages, Procedures Triggers and Cursors.
• Involved in creation of database objects like tables, views, stored procedures, Indexes and Collections.
• Implemented SQL Loader direct path option for bulk inserts into database.
• Written many database triggers for automatic updating the tables and views.
• Designed logical and physical database layouts to minimize I/O contentions among data files.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Involved in loading the data from flat files to Oracle tables using SQL Loader and C.
• Involved in creating user documentation and providing End user training.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Involved in creating the forms from the scratch using PLL's and object groups.
• Performed Unit testing for the Developed component.

Environment: UNIX, Perl, SQL, PL/SQL, Toad, SQL developer, SQL Loader, UNIX Shell Scripting, ReqPro.

Confidential

Role: Oracle PL/SQL Developer

Description:

• Confidential is a global provider of business process and technology management services, offering a portfolio of enterprise and industry-specific services. Confidential serves clients in various industries including banking and financial services, insurance, capital markets, healthcare, life sciences, consumer goods, retail, aerospace, automotive, energy, hitech, transportation logistics, and hospitality.
• The Associate Productivity Tracker is used to capture the Time on System of the agents who take calls. The System also handles the attendance and maintains Leave Balance. The system provided multiple benefits to the Organization as well as the agents for their appraisal. It is a dynamic system, which has the capability to add on any number of agents in the future.

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Installed new databases, upgraded existing databases, created new database instances
• Involved in creating PL/SQL Packages, Procedures Triggers and Cursors.
• Involved in creation of database objects like tables, views, stored procedures, Indexes and Collections.
• Implemented SQL Loader direct path option for bulk inserts into database.
• Written many database triggers for automatic updating the tables and views.
• Designed logical and physical database layouts to minimize I/O contentions among data files.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Involved in loading the data from flat files to Oracle tables using SQL Loader and C.
• Involved in creating user documentation and providing End user training.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Involved in creating the forms from the scratch using PLL's and object groups.

Environment: Oracle-11gR2, Teradata-, Teradata Sql Assistant-13.11.0.3, SQL Loader, Informatica-8.6, MS SQL-Server 2008, TOAD-11.5.0.56, SQL Developer-3.1.07, R-2.15.2, Windows7, MS Excel 2010, Python

Confidential

Role: Oracle PL/SQL Consultant

Description: Confidential is a web application in ASP.Net framework for processing loans with functionalities like Document control, Appraisal, underwriting, Data integrity and compliance review. At the time of appraisal, ILOG comes to action. ILOG will have certain business rules according to that it will work. ILOG is a rule engine and it's the part of Matrix. ILOG checks for certain parameters and do some calculation for validating loan profile after appraisal. When under writing comes into picture and say if sampling of 10-15 is satisfied then whole loan bundle is accepted. Once under writing is done it is checked for data integrity and sent back to CSFB.CSFB will decide for negotiating or funding etc.

Role and Responsibilities:

• Requirements analysis and solution preparation by co-ordination with Team Lead.
• Developing procedures, Functions, database triggers, creation of tables, Views, cursors..etc.
• New Change Requests for Application functionality and code perspective.
• Involved in the Development of the several modules of the Project.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Delivering the product successfully for the UAT Phase and to maintain the Product Version Management. Provide the UAT Support. Responsibility is to address any data issues found during UAT testing.
• Responsible to implement the product successfully in the Production environment..
• Load data into Oracle table using EXTERNAL Table.
• Wrote Complex SQL script, Analytical Function.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.

Environment: Oracle-11gR2, TOAD-11.5, SQL Developer-3.1, Windows 7, MS Excel 2013, Pentaho 4.4, Eclipse 4.3.2, Cygwin 1.7, Tortoise SVN

Confidential

Role: Oracle PL/SQL Developer Description

Confidential is the second largest IT consulting outsourcing services company in India. The objective of this project is to develop an Online Shopping cart applications, which enables customers to buy products Online, the system is accessed via internet throughout the world. The entire system features easy transaction, user friendly views, single sign on, knows discount and offers of the product. Also this was developed in such a way that the E-store can adopt its functionality. Product catalogue information system and shipping system are the modules developed. The features are POP up menus, normal search and advanced search, viewing recent select items, links for navigation, promotional items, suggested products, sending mail to customers, tracking information of each and every order, return history info, carrier type and follow up action.

Responsibilities:

• Involved in Requirement gathering, design, code implementation.
• Created E-R diagrams using MS-Visio.
• Created Tables, Synonyms, Sequences, Views and Stored procedures.
• Requirement gathering, design, code implementation.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines
• Enforced database Integrity using primary keys and foreign keys.
• Created and Modified existing functions and procedures based on business requirements.
• Worked extensively on Exception handling to trouble-shoot PL/SQL code.
• Developed Indexes for faster retrieval of data.
• Implemented join conditions, group by functions and nested queries.
• Used TOAD for PL/SQL development.
• Fine Tuned SQL Queries for maximum efficiency.
• Created parameterized reports and customized existing reports for presentations using Oracle Forms and Reports.
• Creating Oracle jobs Using Oracle 10G DBMS SCHEDULER to automate the report generation process.
• Tune the time consuming SQL queries.
• Defined and implemented performance tuning techniques using Oracle hints, creating indexes and collecting statistics.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Perform unit testing and track the defects in QC.
• Involved in Designing, Testing and Coding of New Reports using Crystal Reports 9.
• Discussion with the core users and end users for requirements freezing.
• Create control files and load data from flat files to tables using SQL Loader.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Client Specific Report Customization Using IFS Report Builder and Oracle Reports 6i.
• Provide training to the IT department on Crystal Reporting tool.
• Plan, participate and prepare documents for Data Migration using Oracle 10g PL/SQL and Reports Development using Crystal Reports 9.

Environment: Sun Solaris 2.5, Oracle8.1.5, Forms 4.5 and Reports 2.5, SQL, SQL Plus, PL/SQL, SQL Loader, Toad, Windows 2000 and Windows NT.