SUMMARY

• More than 20 years of experience in designing and developing of software applications.
• Expertise includes database design, application design, database administration, and performance tuning.
• More than 10 years involved in architecting and developing Health care application database.
• Significant experience in solving customer business problems, providing technology solutions, n - tier application architecture, and in data center operations.
• Ability to play multiple roles and in working with cross-functional teams.
• Strong analytical, management, presentation and leadership skills.
• Self motivated, goal oriented, and organized.

OBJECTIVE

Enterprise Database architect and/or Lead DBA position in the renowned organization that will allow me to use my design and development skills with continued to learn new technology and software.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Enterprise Database Architect / DBA Advisor

Collaborated with different product management & development teams and developed an Enterprise datamodel for the HzERM applicaiton. Architected ERM data model using ERWin and it has more than 900 tables.

• Work with senior management, product management, technical and client teams in order to determine business/data requirements and best practices for advance data manipulation, storage
• Wrote an utility to install & upgrade the application schemas, wrote PL/SQL packages to generate the standard synonyms, sequences, FKs constraints.,
• Wrote utility to verify the customer site schemas against our base line.
• Proposed new ideas and design and implement those.
• Developed a database design & best practice documentation, it is adopted by DBA & Development teams.
• Improved the upgrade process to reduce the downtime more than 3 times.
• Developed an APEX tool help to fix the Encounter Out of Balance (EOOB) issues. This saved lot of support and service team time.
• Wrote more 300 scripts to check and validate quality of the data in online and offline.
• Developed a Clinical conversion process, its converts the data older version into new.
• Installed and maintain Oracle 10g/9i on Unix platforms. Implemented database backup and recovery processes.
• Worked on Horizon Meds Manger(HMM) re-architecture project for 7 months. Re- architect the HMM datamodel to utilize the EDMized.
• Performance improvement of the SQLs, modules.
• I performed as DBA team lead for few years; I gave training for new DBAs as well development team.
• This project is off source and on site development environment; I worked with both on site & offshore teams.

: Application and Data Architect

Confidential, Atlanta, GA. Confidential

ENA Inc. is involved in the development of OSS for Telecom provisioning, called "20.20 ProvisionView". This product has the modules: Service Provisioning, Service Order, Workflow Management, Physical Inventory, Bandwidth Management, Trouble Ticket. As an early member of the development team I was involved in the following roles.

Application Architect/Project Management:

Interacting with Sales, Marketing, Professional Service, QA, and Customers to gather product requirements for "20.20 ProvisionView". Involved in design and development of the client web application. Involved in planning and managing of product releases. Involved in creating project plan, managing the development, providing functional and technical guideline. Part of my job is product demo, presenting the new module/release architecture, feasibility study on adding new modules/feature, etc., I used the following tools C, C++, PL/SQL, ASP, Pro*C, Visio, PowerPoint, Microsoft Project, VSS, etc. Design and developed Trouble Ticket system using Remedy software (Action Request System).

Data Architect:

This data model is intended to support a telephony management system. The design of the data model relies heavily on graph theory. The information is presented to the user as Property Sheets, Trees (for directed arcs) and Diagrams (for non-directed arcs). Used ERWin to design the logical and physical data model to store metadata for the client business objects. Designed user and group level access control. Designed flexible data model to support user configurable business rules.

Database administrator

Install and maintain Oracle 9i / Oracle8i databases on Linux and Windows platforms. Implement database backup and recovery processes. Setting up and troubleshooting of oracle tools. Writing complex PL/SQL stored procedures, functions and triggers. User administration, space capacity planning, review and monitor the oracle instances. Performance tuning - Database and queries. Data Extract Scripts using PL/SQL, Pro*C. Documentation of the above procedures/processes.

: SYBASE Database Administrator, Confidential, Atlanta, GA.

Installing/Maintaining SYBASE SQL server 11 and Backup server on NT. Implemented physical design of the database using POWER DESIGNER 6.0. Developed shell scripts to perform DBCC, backup database & transaction log, update statistics and refresh database from one to another database. Developed scripts to drop and re-create indexes, foreign key constraints and logins. Implemented application\'s business rules and logic using stored procedures, rules, and triggers. Performed production server troubleshooting, recommend as well as implement various solutions to improve application performance. Maintain and apply database patches like Data Definition Language (DDL), stored procedures, triggers, and rules to development, testing, production and training.

AConfidential, Atlanta, GA. Confidential

Installing/maintaining SQL server (11/10), backup server, and replication Servers (10.0), LTMs. Creating replication objects such as repdefs, rules, function strings. Implemented logical and physical design the database using SilverRun RDM 2.3. Managing production support help desk, focal point between the users and other DBAs. Trouble shooting production problems including locking, application deadlocks, querying application using advanced T-SQL techniques. Estimating space for data, lock, memory and procedure cache. Setting up and maintaining regular DBA maintenance jobs using MAESTRO DBA maintenance jobs are database/transaction dumps, DBCC, update statistics, syncheck, and syncfix. Monitoring the SQL and replication servers using PATROL. Maintaining multi-clients, multi-environments, and multi-servers. Developing UNIX shell programming for every day DBA activities and training database refreshment. Migration of Sybase SQL server from system 10 to system 11.

: Consultant, Confidential, Atlanta, GA.

Confidential

Technical expert for the Reporting/Performance client/server team. Responsible for C, JAM and SQR3 applications utilizing extensive embedded SYBASE 11/10.0 SQL routines to maintain a large cellular customer billing database. Developed DB-Lib C programs, stored procedures for batch processing, analyzed and tuned SQL procedures, triggers, and applications. Also responsible for maintaining reporting database schema, and analyzing indexes requirements. Performance tuning for the client server/reporting modules. Responsibility also includes acting as the liaison between the developers and the reporting customers on technical issues and providing direct support to both production and product test environments. Provided technical assistance for programming and unit testing to the developers, investigate areas of the system that are considered to be technically high risk.

: Programmer/Analyst

Confidential, Bombay.

Worked on the development of a GUI based shares Register and Transfer System. This system takes all transaction such as share transfer, transformation, split/consolidation of shares. The system would produce audit reports, dividend posting, certificate printing etc., Involved in design and development of this system using SSADM methodology, MS-WINDOWS 3.1, POWERBUILDER V3.0a, SYBASE Rel 4.5, JAM 6, AND TURBO ANALYST Case Tool.

: Programmer/Analyst, Confidential, India.

Worked on the following projects as Programmer/Analyst:

Purchase Order Processing System:

This system prints the purchase order against the Store Purchase Requisition (SPR), Material Inward Note (MIN) against the purchase order, generating credit note for the rejected items and bill value more than the purchase order value. It also takes care of value analysis on purchase, pending order, and purchase journal printing.

I was involved in design, development, testing, and implementation of this system using SSADM methodology, MS-WINDOWS 3.1, POWERBUILDER Ver 3.0a, ORACLE 6.0 & TURBO ANALYST Case Tool.

This system maintains and monitors the stores of the machine tools division, motor pumps division, and foundry division of the company. Functions included material receipts, issues, material transfer, disposals and returns. Provides control reports on fast moving items, slow moving items and ABC analysis.

I was involved in design, development, testing and implementation of this system using SSADM methodology, MS-WINDOWS 3.1, POWERBUILDER Ver 3.0a, ORACLE 6.0 & TURBO ANALYST Case Tool.

Production System:

This system included Process & Job Card process, Non - Confirmative accounting, Finished parts Stores maintenance, Rejection Analysis and Incentive Calculation. Production reports on production follow-up, pending status, machine & man utilization.

I was involve design, development, testing and implementation of this system using SSADM methodology, UNIX V Rel3, ORACLE 6.0, SQL *FORMS 3.0, SQL *PLUS, PL/SQL, SQL *REPORT Write 1.0, PRO *C, TURBO ANALYST Case tool.

Bill of Material System:

This system maintains the Bill of material products, assemblies and Parts, releasing work order and maintaining the production follow up and purchase follow up. Generated production details and various MIS reports.

I was involved in design, development, testing, and implementation of this system using SSADM methodology, UNIX V Rel 3, ORACLE 6.0, SQL *FORMS 3.0, SQL *Plus, PL/SQL, SQL *REPORT Write 1.0, PRO *C, TURBO ANALYST Case tool.

COMPUTING SKILLS

LANGUAGES & GUI Tools:

PL/SQL, Pro *C, C, C++, ASP, VB Script, Java Script, Java, UNIX shell programming

DATABASES:

Oracle 10g/Oracle9i/Oracle 8i, Sybase Rel 11.5/11.x

OPERATING Systems:

Linux, HP-UX 10.0, NT 4.0, SCO UNIX, WINDOWS, NOVELL Netware

CASE Tools:

ERWin, SilverRun RDM 2.3, Power Designer 6.0, TURBO ANALYST.