S U M M A R Y

• A professional with over 5 years of experience in Information Technology industry in areas of Software Analysis, Design, Development, Testing and Maintenance of various Software applications.
• Four plus years experience with client/server applications project using Oracle 10g/9.x/8.x/7.x, SQL Server 2000/2005
• Experience building client/server applications using Oracle Developer 2000, Designer2000 tools
• Experience in healthcare industry spanning pharmacy, financial insurance entities.
• Experience in financial industry within employee benefits and compensation program
• Worked in multi capacities as individual and in groups with good communication and technical skills. Strong Inter-personal, Organizational, Communication and Writing skills.
• Good understanding of quality assurance testing methodology relative to the Business Analysis, Application Design and overall Software Development Lifecycle (SDLC).

P R O F E S S I O N A L E X P E R I E N C E
DB Developer

Building interfaces using Oracle data objects between pharmaceutical and insurance industries.
RESPONSIBILITIES

• Involved in design and development of migration/upgrade process from National Association of Board and Pharmacy (NABP) to National Provider ID (NPI)
• Gathered user requirements, developed functional, and technical specifications for Walmart, Rite-Aid data load
• Involved in system maintenance, enhancements and production support for various db applications.
• Developed Oracle packages comprising of stored procedures and functions written using PL/SQL to process financial, RXSA, and non-financial sponsors data and load them in to appropriate audit DB objects.
• Designed and wrote adhoc reports using PL/SQL procedures. Also wrote adhoc reports using perl script.
• Developed backend processes for automation of Walmart and Rite-Aid weekly load.
• Wrote DBMS JOBS to kick off nightly process for processing weekly load. Also wrote SQL procedures to load Walmart and Rite-Aid data into partition tables.
• Designed and developed stored procedure for managing reversal transactions from pharmacies.
• Worked on moving/archiving partitioned data to history tables and create new partitions to store current data.
• Performed SQL tuning to get better performance on SQL queries.
• Analysize production defects provide resolution mechanism along with duration.
• Wrote test case scenarios for performing unit testing for the modules that I developed.
• Used homegrown perl based testing tool to create new test scripts and generate test results.
• Installed and used Visual Source Safe to keep track of change controls.

ENVIRONMENT : Oracle 10g, PL/SQL, Toad 9, Unix, PERL, WINDOWS 2000, WINDOWS XP PRO, VSS .
ORACLE DEVELOPER

Client server application using JAVA/J2EE UI and ORACLE for db for managing master, service, business accounts, trouble tickets, and assets.
RESPONSIBILITIES

• Developed new db components to connect from JSP scripts to DB objects.
• Created java stored procedures to retrieve accounts information.
• Developed Oracle packages, triggers and functions to manage nightly batch process to load transaction details
• Generated ad-hoc reports with query parameters to view transaction details.
• Written functions and sub-routines for various calls necessary.
• Rewrote many Oracle stored procedures for better performance using appropriate indexes.
• Participated in building installation packages, coordinating QA activities, creating migration requests.
• Used UNIX OS for production and training environments.

ENVIRONMENT : Oracle 9i, PL/SQL, J2EE, JAVA, JSP, TOAD, MF IIS, JAVASCRIPT, HTML, Unix.
Oracle DEVELOPER

Document management system is used to secure internal as well as client documents. It provides a flexible and secured physical file management. It is a role-based system with simple and advance search features with version control and version history capabilities. This system also provides a browser version of advanced document viewer.
RESPONSIBILITIES

• Attended Business meetings with End Users.
• Mapped business requirements with use cases.
• Developed backend procedures to migrate fulfillment data.
• Wrote database triggers to initiate different batch processes.
• Created DB objects to maintain document product, category types
• Identified test conditions and mapped them with business requirements.

ENVIRONMENT : Visual Basic, Oracle 8.x, SUN SOLARIS, TEST CASE GENERATOR, VSS
SOFTWARE ENGINEER

• Involved in JAD session for analysis, design phases to produce a scaleable architecture to address current and future business entities.
• Made necessary changes in DB to generate user request reports.
• Wrote SQL queries and stored procedures for the above-mentioned business modules.

ENVIRONMENT : ASP, Oracle 8.x, Windows NT server, VSS, Rational Rose.

CONSULTANT

Home grown intranet CRM system to help recruiting and account managers team to create opportunities, follow-up, close sales, create and manage accounts and troubleshoot customer service request.
RESPONSIBILITIES :

• Worked closely with BAs to determine and identify contents and flow of various business processes.
• Created requirement Specification and Design documents to outline different client customizations and configurations.
• High-level functional flow and design document for customer driven entities using PL/SQL functions.
• Wrote complex SQL scripts and used SQL queries extensively to test the data on the database.
• Developed forms for trending and forecasting, order entry, inventory and stock keeping modules using SQL*Forms.
• Developed reports for trending and forecasting, transportation tracking modules using SQL * Reports.

ENVIRONMENT : SQL* Forms, SQL* Reports, SQL PLUS, PL/SQL, Oracle 7.x, WINDOWS NT

Nicknamed TITAMS for Tomorrows Information Technocrats And ManagerS [TITAMS]. The site was basically developed as a freelance project for the Alumni association of the IT Department at Madurai Kamaraj University. The site content provides information about the Faculty and the Student profiles. The site features a guest book, a web based photo album and a Hot News ticker. Involved in design and development of the website.

Environment: Allaire HomeSite 3.0, HTML, JavaScript, IIS, VBScript and MS Access under Windows 95.