SUMMARY OF EXPERIENCE:

• Around 8 years of experience as an Oracle Developer (Oracle PL/SQL Developer) primarily using SQL, PL/SQL, SQL*FORMS, C, PRO*C, SQL Server.
• Managed and supported Production databases.
• Strong experience of developing, implementing and maintaining application systems under UNIX Operating System using SQL, PL/SQL, SQL*FORMS, C, PRO*C, SQL Server, Unix Shell Script, Oracle 10g/9i database.
• Good experience in Utilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Expertise in Data Transformation and Data Migration.
• Experience in working in Data Warehouse Environment.
• Solid experience in performance tuning and Query Tuning (Generating Plan Table, Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF etc).
• Experience in system analysis, design, development and implementation of large to medium scales business applications using Oracle/UNIX technologies in Client-Server and Internet environments.
• Good understanding of relational database system structure, Oracle Database architecture and design and having performed some DBA duties, such as Table partitioning, import/export and data pump.
• Experience in writing Test cases using Mercury Quality Center.
• Experience in analysis and extreme sensitivity for defects, faults and bugs in software systems.
• Expert in problem solving and trouble shooting skills. With performance improvement for pre-existing applications.
• Good spoken and written communication skills.

TECHNICAL SKILLS:

Operating Systems : UNIX, Windows 2000/NT, MS DOS.
Languages : SQL, PL/SQL, MY SQL, C, C++, Perl, HTML, XML,
Java script, CSS, C#, ASP.NET, VB Script, Visual
Basic 6.0, Java,
UNIX Shell Scripting, Pro * C.
RDBMS : Oracle 11g/10g/ 9i/8i, SQL server 2005
Tools : Toad, SQL*Loader, Quality center, Informatica.
Developer Tools : Forms 6i and Reports 6i.

EDUCATION: Bachelor Of Computer Application’s (BCA)

PROFESSIONAL EXPERIENCE

Confidential,Louisville, KY Mar 2008 – Till date
Role: Oracle PL/SQL Developer

HUMANA is one of the nation\'s largest publicly traded health benefits companies, with approximately15 million medical members located primarily in 15 states and Puerto Rico. Humana offers coordinated health insurance coverage and related services to Medicare members. Medication Therapy Management (MTM) is a tool to provide enhanced services to Medicare members. My primary responsibility in this application was to achieve computerization of the various activities, collection of relevant data in the Relational database through various dynamically generated forms, processing and generation of useful reports.

Responsibilities:

• Coordinate with the application development team working on Java to provide them with the necessary stored procedures and packages and insight into the data.
• Wrote PL/SQL procedures, packages, triggers. Involved in creation of databases, moved databases by creating control files, export/import, and complete backups.
• Created and maintained Oracle schema objects like Tables, Indexes, Sequences and Synonyms.
• Designed Logical and Physical data, defined relationships, and implemented business rules as constraints for normalization / denormalization of entities.
• Wrote SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Involved in Data Migration and Data Transfer.
• Involved in writing complex SQL queries using Analytical functions in Oracle OLAP.
• Utilized Qwest tools (Toad 8.0, SQL Navigator) for database monitoring and tuning.
• Involved in ETL processes to load data from Flat files, XML, SQL Server, Access and Excel spreadsheets into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Worked on Performance tuning by using Explain Plan and various Hints.
• Involved with DBA in creating schema and related privileges and roles.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Involved in Unit Testing, System testing and UAT Testing.
• Involved in creating Test Plans, Test cases and Test Scripts using Quality Center.
• Documentation of all modules for user level and system level maintenance.

Environment: Oracle 10g, SQL*LOADER, SQL Server, UNIX shell scripting, TOAD, Java, JSP, HTML, Informatica, Erwin, UNIX, Quality Center.

Confidential,GA Feb 2007 – Feb 2008
Role: Oracle PL/SQL Developer

Practice Management System and Claim Processing
The practice management software involves super bill processing, online appointment scheduling, patient demographic information maintenance etc. It is a web based portal that conveys information according to the role the user work in hospitals. It has well versed role base access and identity management system. The appointment booking module enables doctors to schedule/reschedule their appointment timings and the users to book their appointments online.
The Claim processing system is used for validating the data sent by doctors and to send valid claims to various insurance parties. This module incorporates all the state wise rules for insurance offices. It also incorporates various modes of sending claims like HCFA, UB 92 and EDI ASC X12 Standards.

Business Data Synchronization/ Data Manager/Data analyst
This system takes major responsibility of maintaining data consistency between the outsourced medical billing analysts and healthcare practices available in different geographical locations. It maintains data and structural consistency between heterogeneous databases. This system focuses on the fact that the servers that needs to be in data consistency need to be in online all the time. This synchronization process happens asynchronously by doing time sliced polling on the machines that needs synchronization.

Responsibilities

• Worked directly with user groups, management and other team members to analyze and evaluate requests, and write detailed description of user needs.
• Developed all the OLTP backend processing using PL/SQL packages and cursors.
• Involved in design of master tables to store the business data.
• Developed build scripts for building the PL/SQL Stored procedures.
• Created SQL script to create/drop database objects viz: tables, views, indexes, constraints, sequences and synonyms.
• Developed SQL*Loader scripts to load the data from external files that is exported from SQL Server.
• Wrote UNIX shell scripts to spawn the SQL*Loader job for daily load of data.
• Involved in SQL performance tuning.
• Wrote Java Script to add the Functionalities to the web pages.
• Developed Cascading style sheets for adding styles to the webpages.
• Data modeling as per customer requirements using Erwin tool.
• Used TOAD extensively to develop backend packages, triggers and views to implement business logic.
• Analyzed the business requirements and Oracle database architecture (Erwin), translated them into functional specification and built a Workload Report Application to summarize employees’ workload Upgrade Accounting, Human Resources Databases, Performing tuning activities.

Environment: SQL, PL/SQL, Oracle 10g, SQL*Loader, SQL Server, ASP.NET, Visual Studio 2008, Java, JSP, Java script, CSS, HTML, Erwin, C, TOAD, PERL, UNIX.

Confidential,Houston, TX Jan 2006 – Dec 2006
Role: Oracle PL/SQL developer

Eagle Global Logistics is a supply chain company which provides reports of expenses and maintains logistics of its clients. The project was intended to develop tools for reporting the financial information of the company in the hierarchical structure and making adjustments for client count. My involvement in the project is to develop Logic at backend using PL/SQL.

Environment: SQL, PL/SQL, Oracle 10g, SQL Server, SQL*Loader, Java script, CSS, C++, TOAD, UNIX Shell Scripting, UNIX, Windows NT/XP.

Client: Health Quest, NY Feb 2005 – Dec 2005
Role: Oracle PL/SQL Developer

The Health Quest is Mid-Hudson valley’s largest healthcare network providing service to the one million people who reside in the New York counties of Columbia, Dutchess, Ulster, Orange, Putnam and northern Westchester. This system takes the input from different tables and makes the timesheet for each employee. This timesheet contains Employee id, employee name, project code, time spent in each project, extra activity like project meeting and so on. On basis of this output, one ASCII flat file will be generated that contains an extra column, which reflects the percentage time, spend on each project.

Environment: SQL, PL/SQL, Oracle 9i, SQL Server, SQL*Loader, Java script, JSP, CSS, C++, TOAD,
Erwin, UNIX Shell Scripting, UNIX, Windows NT/XP.


Confidential,India Mar 2002- Dec 2004
Role: Oracle PL/SQL Developer

Environment: SQL, SQL * Plus, PL/SQL, Oracle 9i, SQL*Loader, Java, TOAD, UNIX.

Confidential,India Jan 2001 - Feb 2002
Role: Oracle Developer

Environment: Oracle 9i, SQL plus, Visual Basic, Windows 98, SQL, PL/SQL.