Project Management

Professional Summary:

*+ years of total IT experience which includes 3+ years of experience in Oracle SQL, PL/SQL, VB6.0, Dot Net, and Crystal Reports. Remaining 2 years experience is as a System and Network administrator which includes installing software, creating Domain server, managing ADSI users, crimping network chords, solving network issues, managing proxy and other responsibilities.

Experience includes DBA skills like “Exporting and Importing Database dumps”, “Changing the Character set”, “Privilege management” etc.

Extensive experience in developing Stored Procedures, Functions, Materialized Views, Views, Cursors, Packages and Triggers.

Achieved “Best Managed Project” award from CSSI for the year 2011.

Good Knowledge on Software Development Life Cycle (SDLC).

Good Knowledge on server architecture.

Professional Experience:

Currently working in CSSI, Hyderabad from January 2011 to till date.

Worked with SUVARNA Techno soft Ltd., Hyderabad from April 2009 to January 2011.

Worked with FEDELE Info solutions Pvt. Ltd., Hyderabad from Jan 2007 to March 2009.

Qualification:

Bachelor of Technology from Jawaharlal Nehru Technological University in 2005.

Skill Set:

Databases : Oracle 9i, 10g, 11g

Languages : DOTNET, VB6.0, Basics of C

Tools : TOAD, SQL Developer

Oracle Utilities : SQL Loader, exp/imp, expdp/impdp, nid, rman

Report Tools : Crystal Reports

Web technologies : HTML

Project Profile: CSSI

Project #1 : RSLI (Reliance Standard Life Insurance)

Environment : Oracle 10g, VB6.0, DOTNET and crystal Reports

Role : Developer

Team size : 5

Duration : March 2011 to till date

Project Description

RSLI is an efficient system capable of handling agent, agent licensing, commission calculation. It takes care of licensing and appointment aspect of agents and agency viz. add new agent, terminate agent and update agents, agent renewal, etc. The system also takes care of plan transfer between the agents, rearrangement of hierarchy, adjustments of advances paid (if any), maintains the levels for agents and suggests for change in level. . The commission is given to the agent based on the policy premium and adjustments of the policy. This project includes daily commission cycles, payment inbounds and premium related extracts.

Roles and Responsibilities:

Development (using Stored Procedures, Functions, Packages …), Unit testing and bug fixing.

Implementing the enhancements.

Fixing the issues posted by team and posted by client.

Involved Production Support and client interaction.

Responsible for Release Management.

As per RSL terminology yearly bonus is called as MACA. I am part of MACA Implementation team for the year 2011.

Downloading maintaining the database dumps from client, restoring in internal database and regularly backup the development database.

Project Profile: CSSI

Project #2 : IH (Independent Health)

Environment : Oracle 10g, DOTNET and crystal Reports

Role : Developer

Team size : 4

Duration : April 2011 to till date

Project Description

IH is mainly a health insurance product. It is an efficient system capable of handling mainly Medicare related products and policies. It takes care of agents, agent licensing, appointing and plan transferring. It takes care of premium calculation, which is used in calculating commissions for agents. Involves charge back, renewals, etc. Agent can transfer a single policy or bulk of policies at a time to another agent. IH mostly concentrates on Bonus section that can be previewed in every monthly commission cycle and Bonus calculation for every year. This Bonus schedule changes frequently for every year.

Roles and Responsibilities:

Responsible for generating Extracts.

Involved in doing major changes in Bonus Schedule. This also involves report design changes.

Support the compensation team and understand the processes.

Interacting with client and gathering Requirements.

Responsible for Release Management.

Solely Implemented Bonus schedule changes for 2011 and 2012 years with less management involvement.

Download database dumps from FTP, restoring and regularly backup the development database.

Project Profile: CSSI

Project #3 : Coventry Health Care

Environment : VB6.0, Oracle 9i and crystal Reports

Role : Developer

Team size : 5

Duration : January 2011 to till date

Project Description

VUE Compensation Management has been the broker commissions system in use at Vista Health Plan (Vista). With the acquisition of Vista by Coventry Health Care (Coventry) a decision has been made to replace Vista’s policy administration system (MHS) in with Coventry’s corporate standard IDX. As part of this migration the VUE Compensation Management data feeds from MHS will need to be supplanted with equivalent sources from IDX. Coventry and our company resources have conducted a review on the planned cross reference (Xref) documents to determine the impact to the VUE Compensation Management system.

Roles and Responsibilities:

Implementing the enhancements like A646 Health Reform changes.

Development (using Stored Procedures, Functions, Packages …), Unit testing and bug fixing.

Taking backup form production server and importing to internal database when required.

Involved in Production Support.

Responsible for Release Management.

Product Profile: SUVARNA

Project #1 : HIMS (Hospital Information Management System)

Major Client : Krishna Institute of Medical Sciences (KIMS), Hyderabad.

Environment : Oracle 10g, VB6, Dot Net, Windows 2003 SERVER

Role : PL/SQL Developer

Team size : 12

Duration : April 2009 to Jan 2011

Product Description

HIMS has been developed for information management in a health care center. This is a software package for processing and managing various hospitals information. The package is flexible & modular and can be customized to suit the need of different hospitals. The entire system consists of various information modules catering to different activities of a hospital. The various modules are Front Office, In/Out Patient, Billing, Operation Theatre, Blood Bank, Medical Records, Pharmacy, Financial Management, MIS etc. In/Out module handles In-patient admissions, Discharge details, Bed Transfer details and Out-Patient Consultations with the billing information. Billing module generates the inpatient and outpatient final bills. This on-line transaction processing system has been developed using popular RDBMS – Oracle as database and other contemporary tools. The information is fed into the computer screen forms. The centralized information can be accessed from any place in the hospital complex through the distributed terminals

Roles and Responsibilities:

Collected User Requirements by participating in meetings and studying existing System.

Created database objects like Tables, Views, Sequences, Directories, Synonyms, Stored Procedures, Function and Packages, Cursor, Ref Cursor and Triggers.

Involved in analysis, design, coding and testing.

Involved in modifying various existing Packages, Procedures, Functions and Triggers according to new business needs.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Used SQL LOADER to upload the information into the database.

Used Explain plan for query optimization.

Wrote test cases and performed unit testing.

Involved in writing Technical Specification Documentation.

Project Profile: SUVARNA

Project #2 : Interface for Laboratory Analyzers

Environment : DOTNET, Microsoft access, Microsoft Excel, Oracle 10g

Role : Application Developer

Team size : 1

Duration : April 2009 to Jan 2011

Project Description:

A lab information system (LIS) is a class of software that receives, processes, and stores information generated by medical laboratory processes. These systems often must interface with instruments and other information systems such as hospital information systems (HIS).Interface for Laboratory Analyzers is to automate the manual test selection and result entry using the Bar coding system. We have used different Bar-coding Techniques like CODE-39, CODE-128 B, CODE 128 A, CODABAR, etc. . . . To communicate with the Laboratory Analyzers we have used the Serial Ports and TCP/IP ports. The communication standards followed in this project are ASTM, HL7 and some Analyzer defined standards. For automating the process of test selection and result entry, information from both access database and Oracle database are joined. Access database is used for Interface application where as Oracle is the database used for HIS. Every analyzer uses its own protocol or the standard protocol for communication. Also the Cable configuration differs from analyzer to analyzer. These all are mentioned in Interface manual which is provided by the Manufacturer. Every new analyzer’s interface is a new task. Reading the Interface manual, understanding the Communication protocol and cable configuration is important. Then automating that through the application is the major task for Interface.

Roles and Responsibilities:

Created the database structure in MS access.

Developed procedures, triggers and functions in Oracle database.

Prepared the cables for Serial communication and TCP\IP communication.

Communicating with the COM class objects and reading the data from serial port.

Understanding the Communication method by reading the Interface manual.

Updating the Patient Test results to HIS database based on appropriate Barcode.

Saving the Quality Control data in Access database and Exporting the Quality Control data to Excel sheet.

Implementation at the client place.

Project Profile: SUVARNA

Project #3 : PACS(Picture Archiving and Communication System)

Environment : DOTNET, Oracle 10g

Role : Application Developer

Team size : 2

Duration : January 2010 to May 2010

Project Description:

In medical imaging, “Picture Archiving and Communication Systems(PACS) have been developed in an attempt to provide economical storage, rapid retrieval of images, access to images acquired with multiple modalities, and simultaneous access at multiple sites". Electronic images and reports are transmitted digitally via PACS; this eliminates the need to manually file, retrieve, or transport film jackets. The universal format for PACS image storage and transfer is DICOM (Digital Imaging and Communications in Medicine). Non-image data, such as scanned documents, may be incorporated using consumer industry standard formats like PDF (Portable Document Format), once encapsulated in DICOM. A PACS consists of four major components: the imaging modalities such as CT and MRI, a secured network for the transmission of patient information, workstations for interpreting and reviewing images, and archives for the storage and retrieval of images and reports. Combined with available and emerging Web technology, PACS has the ability to deliver timely and efficient access to images, interpretations, and related data. PACS breaks down the physical and time barriers associated with traditional film-based image retrieval, distribution, and display.

Roles and Responsibilities:

Research on PACS environment, DICOM standards and Network port communication protocols.

Created architecture for PACS environment. Also prepared SRS for this Project.

Created the database structure.

Developed a windows service as a SERVER side application.

Understating and Using a Third party OCX control for developing the client side application.

Developed procedures, triggers and functions in Oracle database.

Work Profile: FEDELE

Worked as a System/Network administrator form January 2007 to March 2009; This role includes creating DNS (Domain Named Server), Software installations, ADSI user management, Proxy management, solving network related issues and other responsibilities.

Also includes

1. User administration (creating and managing ADSI accounts).

2. Maintaining systems (changing Hardware components).

3. Verifying that peripherals are working properly.

4. Quickly arrange repair for hardware in occasion of hardware failure.

5. Monitor system performance.

6. Software Installations including Operating Systems (Windows and Linux), Oracle Server/client, Dot Net, VB6.0, Proxy software and etc based on the requirement.

7. Monitor network communication, Crimping network chords.

8. Update system as soon as new version application software release.

9. Implement the policies for the use of the system.

10. Maintaining Internet policies using CC Proxy and Wingate.

11. Scheduling Server maintenance activity.

12. Configured RAID for Database server using RAID1 (Mirroring).

Personal Details:

Father Name : Basaveswara Rao

Date of Birth : June 1st 1984

Gender : Male

Marital Status : Married

Present Address : 201, C.V.R. Towers, HIG-459, 6th Phase,

KPHB Colony, Hyderabad – 500072.

Languages Known : Telugu, English and Hindi

Passport Number : F7363209

Issue date : 24/03/2006

Expiry date : 23/03/2016

Thanks & Regards,

Kalluri Raghuram

Contact this candidate