PROFESSIONAL SUMMARY:

• A Senior Oracle PLSQL Developer having around 8 years of professional IT experience with an earned reputation for meeting strict deadlines and delivering mission critical solutions on time and within budget. Self starter and well motivated to rapidly acquire new skills on the job. Good at technical report writing, presentation and communication skills. Subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives. Works on problems and projects of diverse complexity and scope, Exercises independent judgment within generally defined policies and practices to identify and select a solution. Have ability to handle most unique situations and acts as an expert providing direction and guidance to process improvements and establishing policies.
• Over 8 years of experience in Oracle PLSQL Development with Extensive knowledge and work Experience in design and development of Database applications in Client/Server environment using Oracle Database and PL/SQL Programming.
• Expertise working with Oracle 11g/10g/9i/8i, Developer 2000, PL/SQL, Oracle Forms 10g/6i, Reports 11g/10g/9i/8i, SQL Loader.
• Extensive experience as Oracle PLSQL Developer in utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader.
• Strong problem solving technical skills coupled with confident decision making for enabling effective
• Solutions leading to high customer satisfaction and low operation costs.
• Customized and developed Forms and reports using Forms9i/6i, Reports11g/10g/9i.
• Experience in performance tuning and sql optimization using Hints, Explain Plan, Auto Trace, and Tkprof , restructuring tables, denormalize tables and build Materialized views.
• Adept Knowledge in writing UNIX shell scripts, scheduling jobs, DBMS JOB and good understanding of ANSI standard C.
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable
• Ways to fix the problem.
• Good experience in Data Modeling, Relational Database concepts and Entity relation diagrams ERD .
• Involved in design of dimensional models like Star Schema and Snowflake Schema.
• Possess strong communication and problem solving skills developed through a variety of projects.
• Ability to work independently and also great team player.
• 24/7 production support and involved in implementation of coding standards and Data Base change requests.

TECHNICAL SKILLS:

• Operating System : MS DOS, Windows/98/NT/2000, Linux, Mac
• Languages : C, C , SQL, PL/SQL, Java, Html, Dhtml, Xml, Vb script, JavaScript, Microsoft VB.NET
• Tools and Utilities : Toad, SQL Loader, UTL, Discoverer
• Database : Oracle 8i /9i/10g
• GUI : Forms 6i/9i/10g, Reports 6i/11g/10g

CONFIDENTIAL

Role: Oracle PLSQL developer

• CONFIDENTIAL is a global leader of next-generation information technology IT services and solutions. The TPL subsystem of Medicaid Enterprise Restructuring Program maintains current and historical information to support the benefit recovery functions of the Maryland MMIS system. DHMH uses this information to reduce its liability to pay for recipients MMIS claims. The TPL subsystem ensures that Medicaid is the payer of last resort. DHMH has contracted with a TPL vendor to perform much of DHMH COB recovery-related functions. DHMH makes use of MMIS COB Functionality in the area of cost avoidance and supporting TPL recoveries by providing the TPL Vendor with The needed MMIS data. The TPL vendor also provides data about recipients having TPL to the MMIS and Administrators.
• Third party liability correspondence letter generation for Lien , Estate , Special Needs Trust and Subrogation
• Developed the package supporting the task
• Third party liability Outbound 270 and 271 transactions for Policy verification of recipient to HIPPA.
• Involved in Assisting the business Analyst business and technical documents.
• Creating SSIS Packages to Extract, Transform and Load data into database.
• Found a new plan for SQL statements and verified them to perform better than the existing accepted plan.
• Prepared the specification documents for business Register of wills process and HMS outbound process.
• Developed Register of Wills inbound interface for recording Recipient information. The interface stores the decedent and other party information.
• Worked on Preparing DCR and SCR changes for Data modeling team.
• Developed Child Support Enforcement Agency interface containing information related to child, absent parent and custodian parent.
• Implemented all the Data Modeling changes.
• Maintained different versions of software using software Clear Case.
• Developed and maintained existing reports Recipient case information, Estate Recovery and reports related to all other recovery types.
• Developed the TPL lead structure for policy verification of recipient.
• Handling ISR jobs for all the interfaces in Third party liability subsystem in the project.
• Tuning queries for better application performance.
• Preparing Questionnaire and Mapping details for interface specification document.
• Analysing COBOL layouts send my interface team.
• Analyzing the impact to the application after data model changes.

Environment: Oracle 11g/Oracle 10g, PLSQL developer 8.0, TOAD.

CONFIDENTIAL

Role: Oracle PL SQL developer

Responsibilities:

• Created the databases Tables and implemented the data integrity validation checks through constraints and triggers.
• Involved in oracle data base sizing to support capacity planning
• Responsible for analyzing tables and indexes from time to time to keep the STATS up-to-date.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Develop new SSIS/SSRS packages to meet business needs.
• Used the trace facility to check the PLSQL code at Server side for issues and better performance.
• Designed and developed the interface program to load the item cost from a legacy system into item master using SQL Loader, PL/SQL package through Open Interface.
• Involved in developing packages for implementing business logic through procedures and functions.
• Extensively used UTL FILE packages to generate files as per requirements.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the
• Designed and developed GUI front-end applications using Oracle Forms for user interaction with the database..
• Developed various UNIX Shell Scripts to automate the routine tasks.
• Developed and modified existing reports in Oracle Reports.
• Assisting the Data modeling team and implementing the changes,.
• Maintaining different version of software version control using CVS.
• Was involved in Tech Upgrade where the Entire application was moved to Linux from windows.
• Also involved in PCI Payment Card Industry Data Security Standard Upgrade Project.
• Handling the change requests CRF .
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 11g/Oracle 10g, PLSQL developer 8.0, TOAD.

CONFIDENTIAL

Role: Oracle PLSQL developer

CONFIDENTIAL is a major global financial services provider engaged in retail banking, credit cards, corporate and investment banking and wealth management with an extensive international presence in Europe, the Americas and Africa and Asia. Citi Bank operates in over 50 countries and employs over 140,000 people. Citi Bank moves, lends, invests and protects money for 48 million customers and clients worldwide.

Responsibilities:

• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.
• Involved in Technical Design, Development, Testing, Implementation and Training with web Development team.
• Generated Automated Workload Repository AWR report to check the health of the oracle instance.
• Processed new accounts for customers and assisted existing customers with account maintenance.
• Worked with Developer/2000 Reports Designer to develop reports for validating data in system tables.
• Adherence to reporting procedures to provide information to Corporate Office from all regions.
• Collecting report requirements from the cross-functional teams and providing the decision supporting reports, performing analysis of the reports and presenting to the managerial staff.
• Implemented triggers to enhance functionality, supplement validation, and default transaction processing.
• Involved in developing the ETL mappings using Informatica.
• Performed database Normalization and ed-normalization tasks.

Environment: SQL Plus, PL/SQL, TOAD, SQL Navigator, Oracle 9i, Oracle Forms/Reports 6i, Windows NT, UNIX

CONFIDENTIAL

Role: Oracle PLSQL Developer

CONFIDENTIAL helps consumers and organizations secure and manage their information-driven world. Its software and services protect against more risks at more points, more completely and efficiently, enabling confidence wherever information is used or stored.

Responsibilities:

• Involved in complete Software Development Life Cycle SDLC .
• Extensively worked on SQL Loader to load data from external system and developed PL/SQL programs to dump the data from temporary tables into Base tables.
• Written Complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions.
• Supported and maintained OLTP systems.
• Involved in Data analysis and reducing Data discrepancy of the Source and Target schema.
• Responsible for writing database triggers to validate business logic using PLSQL
• Coded Reports and programs to support Billing functions in SQL, Oracle Reports and PLSQL.
• Developed many Inventory control reports like Stock status report, Customer comparison reports.
• Developed various forms for client's application using Developer/2000.
• Conducted code walk through internal/peer reviews.
• Assist in developing test scenarios, test scripts, and test data to support unit and system integration testing.
• Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.
• Installing Weblogic server using graphical installer and configuring a simple domain in web logic server.
• Provided production Support.

Environment: Oracle 9i, PL/SQL, Forms 6i, Reports 6i, SQL Navigator, VB, HTML, Windows/Unix,Weblogic server.

CONFIDENTIAL

Role: Database Developer

CONFIDENTIAL The largest water-cooler delivery company in the US, the company deliver to homes and offices, owning more than 25 manufacturing sites across some 30 US states.

Responsibilities:

• Developed, debugged, tested and supported mission critical software solutions with PL/SQL to be used through out the enterprise in the areas of Customer Service, Warehousing, Call Center, EDI, Order Entry, Inventory, Work Order Processing, Purchasing and Reporting.
• Created tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Oracle developer skills using Developer 6i reports/forms, SQL, PL/SQL, SQL Plus, SQL Loader and Toad against an Oracle database at release 9i or above.
• Created Functional indexes, Bitmapped indexes, Domain indexes and Btree Indexes to improved performance.
• Data Loading and data migration Used SQL Loader to load data from Flat files into staging tables and developed PLSQL programs and packages to load data from staging tables to Base tables.
• Supported current ETL processes, shared responsibilities for monitoring Data warehouse loading process.

Environment: ORACLE 8i/9i, PL/SQL Packages, Procedures, Functions, Triggers, TOAD, Windows 2000

CONFIDENTIAL

Role: Oracle /Software Programmer

CONFIDENTIAL a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems.

Responsibilities:

• Building multi table relationship and writing stored procedure to clean the existing data.
• Coding of database Triggers, Stored Procedures and Maintaining Integrity Constraints.
• Developed SQL Plus reports to allow the manager to analyze the data directly accessing Oracle Server.
• Design and implementation of stored procedures and triggers for automating tasks.
• Report development and maintenance work in PL/SQL using applications like Microsoft Access Reports.
• Handled Errors and Transaction Processing in the Procedures.

Environment: Oracle 9i, SQL Server 2008, Visual Basic, MS Access

CONFIDENTIAL

Role: SQL Developer

CONFIDENTIAL is one of the world's leading management firms for executable strategy, operations, technology, and human capital advisory services. The firms practice is built around integrated core capabilities - people, process and technology and industry expertise - the capabilities needed to help clients to tackle their most complex challenges.

Responsibilities:

• Preparation of Technical specification.
• Developing PL/SQL, SQL programs using Oracle 8i as back end and Developer 6i as front end.
• Sql and performance Tuning.
• Used sql loader to load data from csv files into Oracle tables.
• Pl/Sql bulk programming.
• Used Sql to create cross tab reports.
• Developing forms and reports as per the requirements.
• Developing triggers, procedures, and functions for common usage of the development team.
• User Training.
• A good understanding of Java, JSP, web services.

Environment: Oracle9i, Oracle Forms Reports, Windows NT