KOTA.KRISHNA CHAITANYA

Contact #: 099******** tln4rd@r.postjobfree.com

OBJECTIVE

To obtain a lead position that will utilize my experience in programming and software design and that would bring out the qualities of leadership and teamwork, which would lead to mutual growth, satisfaction, and achievement of goals.

PROFESSIONAL PROFILE

Around 4+ Years of Experience in the field of Software Development and Implementation with Proficiency in Oracle 8i/9i/10g, SQL, PL/SQL that includes Complete implementation.

• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.

• Hands on experience in design, development of end user screens using ASP front-end tools.

• Worked with query tools like Toad, SQL*Plus, SQL Developer.

• Created ER Diagrams on ERWIN and MSVISIO using Normalization Techniques and MSVISIO.

• Experience in Performance Tuning & Optimization of SQL statements.

• Experienced in identifying Business requirements, Technical requirements troubleshooting and writing interfaces.

• Created materialized views like primary key, rowid, and sub query materialized views.

• Strong in writing Stored Procedures and SQL queries

• Proficient in data loading/extraction using SQL*Loader.

• Good understanding of the Oracle database, related utilities and tools.

• Domain knowledge of Telecom Systems, Utilities.

• Strong Background in implementation of RDBMS and OOPS concepts.

• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

• Excellent analytical and interpersonal skills, oral and written communication skills.

• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

• Ability to explain technical concepts and communicate with users and system administrators at all levels.

CERTIFICATIONS

successfully obtained Oracle PLSQL Developer certified associate (OCA) and Oracle Certified Professional (OCP) from Oracle Corporation.

TECHNICAL EDUCATION

Degree University YEAR Per (%)

M.Sc (IT ) Anna University , Chennai 2004 73

B.Sc ( Comp.Sc ) Kakatiya University , Warangal 2001 54.8

Intermediate Board of Intermediate Education 1998 60

S.S.C. BSE 1996 67.8

PROFESSIONAL EXPERIENCE:

ClearBenefits.com

Technologies Oracle 10g,11i(Server),PL/SQL Developer, SQL Developer , ASP.NET 1.1, VB.NET 1.1

Duration Nov’2010 to Till date

Team Size 2

Role SQL and PL/SQL Programming writer

Analyze business requirements and system specifications

Communicating with the client for any clarifications or queries in the requirements or specifications.

Interacting with designers and software developers to understand application functionality and navigational flow

Document and report bugs found out during the process of product.

Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.

Client Organization Health Care Insurance (Clear Benefits)

Organization A3Logics(I)Ltd, Hyderabad

Description Clear Benefits is a web-based software application that automates the management, administration and communication of employee benefits, payroll and HR information. The product significance is to deliver a complete end-to-end employee benefits management, communication, and transaction system to help employers and brokers reduce costs, improve service, and refocus their efforts on the things that matter most. With different modules, or user interfaces, unified through a secure, hosted application, clear benefits “interacts” the participants – brokers, employers, employees and carriers/third parties – in a real-time exchange of benefits information and communications. The followings are main modules in CB Product.

Worked on Open Enrollment (This time period happens on an annual basis)

Open Enrollment is the period of time employers set up to allow employees to choose from the plans available to them. Usually open enrollment covers insurance plans such as health, dental, vision, life, accidental death & dismemberment, short term disability and long term disability. It also covers any additional voluntary or supplementary plans your company may offer. (Employees can choose: To start coverage if they don’t have any; Change from one plan to another, if that option is available; or Drop coverage completely, if that’s an option).

Mobile Number Portability (Operations and Maintenance of Prepaid Billing System)

Technologies Oracle 9i, Asp, Toad 9.5.

Duration Dec’09 to Oct’10 (Worked at offsite)

Team Size 6

Role Providing CDR’s to Legal department, Nodal department and TRAI.

Reconciliation of INCDR and MSCCDR in daily basis from the dumps which we receive from IN and Mediation (Central) Team.

Activating of Vodafone related Services for the subscribers who are falling under the respective business logic.

Changing the plan for the subscribers from Prepaid to Postpaid and vice versa as per their request.

Automation of scripts for monitoring and maintaining the proper flow of operations.

Providing MIS and AD HOC reports to Marketing, Customer Services, and Finance departments.

Tracking of subscribers profile mismatches in BSCS (Business Support Control System) with the Local Prepaid Database through PL/SQL scripts.

Coordinating and performing IT operations with the Central Team ,IN and VAS Team for the following activities like Range Migration , OS Patch, Server Side Performance Tuning .

Client Organization IBM Private Ltd (Vodafone Project), Hyderabad

Organization WEB DEVELOPMENT COMPANY LTD., KOLKATA

Description In Telecom Billing, technical Support, development of applications according to client requirements, enhancement of existing applications, Maintenance of the existing systems with 100% uptime, reviewing the business requirements, resolving the customer related issues in the given TAT.

Enterprise wide IT Solution for HMWSSB

Technologies Oracle 9i , 10g Express Edition

Duration 20 months

Team Size 2

Role • DBA activities

• SQL developer, Writing PL/SQL, Stored subprograms and Triggers

• Export Import from Development to Production.

Creating users and granting privileges to access the database.

Client Organization Hyderabad Metropolitan Water Supply & Sewerage Board, Hyderabad

Organization Co Options Technologies Ltd, HYDERABAD

Description In the current system will maintain organization with structure of 17 Regional Offices, 5 Divisional, Circle Offices and HO’s. It’s a complete ERP application on Water Utility domain. This project enables the Water board to facilitate its customers with best of services in terms of water delivery and conveniences of payments, Improve the operational efficiencies and bring in accountability and transparency into all the subsystems of the board and streamline the processes and monitor the progress of works. It includes various modules Metro Customer Care, Single Window Cell, Billing & Recovery System, Human Resource & Management, Non Revenue Water, Inventory Management System, Supplies & Purchases, Employee Management System, Payroll and FAS.

TECHNICAL SKILLS:

Operating Systems : Windows 98 / NT / 2000 / XP

Languages : JAVA, C, C++, SQL, PL/SQL

Oracle Tools : SQL Developer, SQL*Plus, TOAD (Versions: 7.3, 9.6),

SQL Developer, SQL*Loader, TORA 2.0, PL/SLQ Developer

Scripting Languages : Java Script, VB Script

Web Technologies : JSP, ASP, HTML

DBA : Self-Serving DBA, users, roles, privileges, schema and

Objects management, data loading, export/import,

Backup/restore, session monitoring.

PERSONAL DETAILS

Father’s Name : K.Venkata Ramana

Date of Birth : 27th August 1981

Marital Status : Married

Language Known : English, Telugu and Hindi.

Address : FlatNo.101,PltNo.105/A, Balaji’s K.K.Residency,

Opp: NRI Academy Boys Hostel, Pragathinagar, Kukatpally,

Hyderabad -500090.

K. Krishna Chaitanya

Contact this candidate