Curriculum Vitae :
Dayakar Reddy Mannem
Email : dayakarreddy4ever AT gmail.com
Phone : 1-876-8573324
Objective :
To work in an environment that provides a challenging and rewarding career ensuring a high-level job satisfaction. In the process apart from benefiting my employer, I also expect to learn for my overall development.
Professional Summary :
Having 4.8 years of experience in software development using Oracle SQL, PL/SQL including Procedures, Functions, Triggers, Packages, Object types and Jobs.
Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Ref Cursors, Packages and Exceptions Handling.
Sound knowledge in Oracle 10g/11g & SQL and PL/ SQL programming.
Working with Creation of Table Space, DB Link, Database Export and Import.
Database software installation, patch and upgrade to development, test and production servers.
Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
Excellent in the use of the import and SQL Loader utilities to load data and performing exports as supplemental to daily hot, cold and RMAN backups to be used for database restore and recovery.
Modify database structures as required by developers due to business or application requirements
Clone development databases for testing and training.
Knowledge and understanding of Real Application Cluster (RAC) and Data guard.
TECHNICAL SKILLS :
Languages : SQL, PL/ SQL, PostgreSQL, JAVA, C, C++.
Databases : Oracle 9i/10g/11g, Firebird. PostgreSQL
Tools : Toad.
Reporting tools : I-Reports, Pentaho Reporting.
Utilities : Sql * Loader.
Operating Systems : Windows, Linux
EDUCATION :
Bachelor’s in Information Technology from JNT University in 2007.
EXPERIENCE :
Worked as software developer for REFER2WIN, Hyderabad from July 2007 to Aug 2008.
Worked as software programmer for Zinnia Software Solution, Hyderabad from Oct 2008 to Feb 2011.
Working as System Analyst and PL/SQL Programmer in Advanced Integrated Systems Ltd., Kingston 5, Jamaica from April 2011 to Till Date.
PROFESSIONAL EXPERIENCE :
Product#1 :PAS (Provider Access System).
Clients : Sagicor, Guardian Life, NHF Jamaica, CINICO (Cayman).
Environment : ORACLE 9i, Java, Windows 2003 Server.
Role : System Analyst and PL/ SQL Programmer
Team Size : 6
Description :
PAS decides whether a person’s insurance policy covers a particular medical procedure and provides different benefits based on age, health conditions, patient history and many other factors.
Patient’s information will be capture by swiping the patient’s card. While swipe the card, magnetic strip is faced towards the light of the swipe device and swipe from top to bottom. If card is swiped correctly no red light will be displayed on the swipe device. In that case the patient’s information should be displayed in the patient field on the screen. Then the claims fee will be processed.
Responsibilities :
Collected User Requirements by participating in meetings and studying existing System.
Creation of Table Spaces, Data files and Batch files.
Creating database objects like Tables, Views, Sequences, Stored procedures, functions, and packages, Cursor, Ref Cursor and Triggers.
Used Explain Plan for query optimization.
(Dayakar Reddy Mannem)