Around 8 years of experience in IT industry with hands on experience in design, development and implementation and production support of complex business requirements / application software.

• Strong analytical and conceptual skills in Database Design and Development in SQL, PL/SQL.
• Expert in Development of PL/SQL Stored procedures, Functions, Database triggers, Packages to implement business logic.
• Migrated systems from lower versions to higher versions in Oracle.
• Expert in writing Cursors and Handling Exceptions while developing the applications.
• Expertise in development of business applications using Oracle 11g/10g/9i/8i/8/7.3, SQL, PL/SQL, SQL Loader and Open Interface.
• Experienced in Project planning and scheduling, System design, Functional Specification, Design specification, Coding and System test plan.
• Worked with scripting languages like JAVASCRIPT, HTML and XML.
• Excellent in writing UNIX and LINUX Scripts.
• Hands on implementation experience in industries like Banking, Trading, Energy distribution, Telecommunications and Health insurance.
• Worked with applications like Manufacturing Process, Banking Information Systems, Health Care Management Information Systems, and Financial Accounting.
• Experienced in the Retail and Supply chain management activities.
• Experienced in Query Optimization, Debugging, and Tuning for improving performance of the applications.
• Strong Background in implementation of RDBMS concepts.
• Strong Problem solving, Decision making and Result oriented skills.
• Team player with excellent interpersonal skills and ability to work as part of a team.
• Able to work independently under minimum supervision.

Confidential delivers technology, health information, consulting and outsourcing solutions. Commercial health plans, physicians, hospitals, life sciences companies, government agencies and other organizations that comprise the health care system depend on Confidential solutions and insights to improve their performance Confidential a leading information and technology-enabled health services company dedicated to making the health system work better for everyone. Axolotl is now Confidential part of Confidential - a leading health services business.

Responsibilities:

• Actively Participated in different phases of SDLC. Extensively worked towards optimizing the Queries to enhance the performance. Analyzed Indexes on regular basis.
• Created Database Objects like Tables and Views as per Client Requirements.
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Involved in the optimization of Oracle queries.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Design, development and implementation of complex ETL Processes with Informatica.
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance. Implemented Triggers based on the business rules.
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to Staging Area Tables. Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues. Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Worked with Dynamic Queries SQL . Served as a technical expert in developing database designs for Data Warehouse. Created users privileges and managed user roles and grants. Worked on DBMS SCHEDULER to automate jobs. Made use of DB LINKS for accessing data across different databases. Stored data in the audit log tables using the old and new column attributes. Loading data into Database using SQL LOADER. Used the Oracle Import/Export utilities for taking backup of a particular partition data.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.

Environment: Oracle 11g/10g, Oracle Forms and reports 10g, Sun Solaris 10, Erwin, SQL Plus, TOAD, Quality Center, Relational Clear Case, Informatica Power Center 8.1.1.

Confidential organizes an Annuity Fund to sell life insurance. Confidential turns to a Hartford, Connecticut. Aetna has been named Confidential in the Health Care: Insurance and Managed Care category for.

Responsibilities:

• Created tables, Partioning tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms, Procedure, packages for the business application development.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Created database links to retrieve data from multiple servers.
• Created public synonyms on the database links for easy reuse.
• Monitored database performance using TKPROF, explain plan and sql trace.
• Involve in Tuning, Performance, and Optimization of queries and standardization of the code.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Written database triggers for automatic insertion of tables on different schema
• Used Packages DBMS JOB, DBMS PROFILER.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Experience with different backup strategies using Export/Import utilities.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Involved in Tuning, Performance, and Optimization of queries and standardization of the code.
• Preparing Design documentation and getting approval from the client.
• Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Created different kind of Charts in the reports for the purpose of Analysis.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.

Environment: HP-UX 11i, Oracle 10g/9i, SQL Developer, PL/SQL, Sun Solaris 5.7, Crystal Report 10.

Confidential Company offering full service consulting, systems, and operations support and services to Public and Private businesses throughout the Confidential principals have a combined experience of more than 60 years in providing end-to-end government solutions, enterprise software development and implementation. Confidential is a leader in the implementation of high technology and business applications. Our team has extensive experience in developing and operating large school information systems, Medicaid administration, and Medicaid and Foster Care revenue maximization practices.

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating and working with GTT Global Temporary Table
• Made use of Sub query-Factoring WITH clause to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 9i, 11g SQL, PL/SQL , Oracle Developer Suite 10g, oracle forms 9i/11g, oracle reports 9i/11g, TOAD 9.0, Erwin 4.0, UNIX, VSS

Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Analyzed and Reviewed the Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, unit testing.
• Designed and created Database objects.
• Wrote PL/SQL procedures and packages as per the requirement.
• Wrote complex SQL queries.
• Created views for better performance.
• Created indexes for faster access of the tables.
• Worked on Materialized Views and Query Rewrite.
• Wrote the script to merging the data from one system to another system.
• Used SQL Loader to load data from flat files excel/access to Oracle database.
• Used explain plan to improve the database performance.
• Extensively involved in the analysis and tuning of the Application code SQL .
• Fine-tuned PL/SQL Procedures for better performance.
• Wrote shell scripts for scheduling jobs.
• Used PVCS for source code configuration management.
• Assisted in testing and deployment of the application.

Environment: Oracle 9i, PL/SQL, PL/SQL, Forms 6i, Reports 6i, Shell scripts, Pro c

Project: The project dealt with the management of raw material available, the suppliers of the materials and customers. Created and maintained the data warehouse. I was responsible for segregating customers into various risk levels based on their previous promptness in paying of bills. Features included transactions, orders and billing for the items.

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC
• Developed capacity plan for the database, estimated the table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for Protection of data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among the various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.

Environment: Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML, ultra edit