VARA SAMANTHULA

Phno- 502-***-****. h59tfv@r.postjobfree.com

Summary of Experience:

 Over Seven years of experience in Information Technology working on RDBMS concepts and Application Development, Testing and Implementation using Oracle 10g/9i/8i, SQL, PL/SQL,SQL* LOADER, Query Optimization, Performance Tuning and Trouble Shooting.

 Over 4+ years as Oracle Developer and Expertise in Data Analysis.

 Experience in Oracle Programming and Application Development

 Strong Programming skills in SQL*PLUS, PL/SQL for developing cursors, stored procedures, functions, packages and database triggers, SQL Tuning.

 Expertise in creating Tables, Table Partitions, Views, Materialized Views, Unix Shell Scripting, Business Objects.

 2 years as DBA and 1+ years on RAC; Database Administration, Installation, Up gradation & Migration, Backup and Recovery, Performance Tuning, Database Security, Development and Production support on Oracle 10g/9i/8i in local and remote environments on Operating Systems like, AIX, HP-UX ,Solaris, Windows.

 Developed, implemented and managed database backup and recovery procedures through RMAN. Implemented RAC on oracle 10g using ASM in SAN

 Added/reconfigured nodes and instances in a multi-node cluster. Expertise in using srvctl, crsstat, DBCA, NETCA and VIPCA.. Worked on patching applications, databases upgrades up 7TB, migrated 9i to 10g databases using CRS and ASM..

 Expertise in crontab and shell script and disaster recovery. Skilled in Oracle Architecture, memory and process structures, data dictionary.

 Strong background in Data Modeling, Database Design, Capacity Planning Monitoring and optimizing the Database Performances through SQL Tuning, I/O Tuning, Memory tuning, System Tuning, and Application Tuning.

 Extensively used Oracle utilities like TOAD, Oracle Enterprise Manager (OEM), Export/Import, Data Pump and SQL *LOADER, also Reporting tools like Oracle forms and Reports.

 Good communication and presentation skills.

Technical Skills:

RDBMS Oracle 10g/9i/8i/7.x(SQL,PL/SQL, Stored Procedures, Triggers, Cursors),

SQL Server and Access, RAC, RMAN, Crystal Reports,

Operating Systems UNIX , Windows NT/98/95, WIN 2000/XP

Languages/Utilities SQL, PL/SQL, Unix shell scripts, Java, Servlets, JSP, TSQL, C++

IBM- Web Sphere- MQ- ADMIN. 6.0

Other Tools Reports 3.0/6.0/6i, SQL*Loader, TOAD,SQL *PLUS and tkprof,

PL/SQL Developer, AccuRev, PVCS

Web Technologies HTML, JSP, Java Scripting ,Sevelets

Choice Systems, Inc, Louisville, KY May ’08– Present

Oracle Developer/Jr.DBA

Choice Systems is an innovative leader in the health industry. I worked for the COMPAS (Comprehensive Policy Administration System).Gathered the requirement from the client and translated the business details into Technical design. Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures and generated system test plans.

Environment: Oracle 10g/9i, SQL*PLUS, SQL* LOADER, PL/SQL, TOAD, HTML, Java, JSP,Servelets,Unix Shell scripts, UNIX, Linux, Windows 2000, Web Services.

Responsibilities:

 Involved in analysis, database design, coding, and implementing

 Loaded data into multiple tables using SQL Loader

 Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers, SQL Tuning.

 Tuned SQL queries using Tkprof utility to improve performance

 Used Microsoft Visio for Dataflow and Entity relationship diagram

 Extensively used PL/SQL in reports to perform calculation and to get desired output

 Developed single HTML page to serve as a centralized menu for the web application, and then broadcast URL.

 Developed automated notification of Emails, using UNIX shell script, to the users in case of failure in the process from time to time

 Implemented the technical and functional aspects of DEPOT project

 Interacted with end user for problems faced and providing necessary technical support by fixing the bugs

 Participated in installing and configuring 10g Grid Control and Maintenance of DB

Testing, Integration System test, Implementation (test with users) and documented

General Electric (GE) Jan ‘07– Feb’08

PL/SQL Developer

General Electric (GE) had a database of purchasing Appliance parts. The users can purchase products online and update their orders. For this, I was involved in the design & development of an application for GE, to aid the Sales and Purchase procedures for the Parts Business Division using Oracle, and Windows 2000.

Environment: Oracle 9i/8i, SQL, PL/SQL, SQL* LOADER, tkprof, UNIX, Java, Access and Windows 2000, Business Objects.

Responsibilities:

 Participated in all the Life Cycle phases including requirement analysis ,Client Interaction Design, Coding, Testing, Support and Documentation

 Created Functional Specification document and High-level design document

 Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement

 Developed Oracle Stored Procedures, Triggers, SQL TUNING to effectively incorporate Business rules .

 Worked with Dynamic SQL, Global temporary tables

 Used PL/SQL Tables ,Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process

 Import/Export utility is used for transforming data from Production to testing.

 Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools. Batch Processing, Unix Shell Scripting, Business Objects.

 Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views also created the partitioning tables.

 Written SQL queries for data Validation

 Worked with Oracle Discoverer for generating Reports.

 Worked extensively with composite data types, Cursors and Dynamic SQL

 Written complex SQLs using joins, sub queries and correlated sub queries.

 Written UNIX scripts and run/review production jobs in the UNIX environment

 Participated in code review meetings.

Cardinal Health, Columbus, OH Jan’06 – Dec’06

Oracle Developer

The Rebate Management System consists of CARS/IS application, CARS/IS reporting environment and various operational systems like SCORE, DISTRACK, JDE financial application modules etc. The process of rebate calculation is based on very intricate algorithms which utilize product, vendor, customer, contract, sales and purchase data. To separate the process of reporting from transactional processing, a separate database containing abstracted data from CARS/IS has been created

Environment: Oracle 9i/8i, PL/SQL, HP Unix, Unix shell scripting, Toad, SQL Server-2005

Responsibilities:

 Involved in requirement gathering and analysis.

 Worked closely with the users to understand their requirements.

 Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints and indexes.

 Extensively developed complex packages for Pricing

 Developed PL/SQL procedures to implement business rules

 Worked extensively with composite data types, Cursors and Dynamic SQL

 Written complex SQLs using joins, sub queries and correlated sub queries, SQL Tuning, TSQL.

 Schedule meetings and present technical issues to business users and developers

 Written UNIX scripts and run/review production jobs in the Unix environment

 Triggers have been created to notify the support group of any problems in the function of databases by sending automated emails

 Performed database tuning using Explain plan

 Participate in review meetings.

 Performed unit testing, system integration

 Responsible for production support

LIC (Life Insurance Corporation), India Sept ’02 – Dec’05

(PL/SQL Developer)

Life Insurance Corporation of India is basically an insurance company which insures on life by selling their products which comes with different plans every year, The Company has various branches located throughout India and it has many zones and divisions, a group of divisions comes under one zone. So here the data has to be maintained centrally in a ware house located in Mumbai so that they can maintain historical data which the data can be accessed by any branch office as and when needed based on the authentication key exchange

Responsibilities:

 Schema Design and Created Mappings for Staging & Targets (Dimensions and Facts).

 Data migrating using UTL-FILE package and SQLLDR utility.

 Scheduling the scripts for Data Migration using UNIX Shell scripting.

 Involved in Data Migration from different OLTP sources to central Database.

 Generated reports like business Object reports at quarterly, half yearly, annually.

 Wrote PL/SQL stored procedures and functions to access and store data.

Environment: Oracle 8i, PL/SQL, UNIX, Java Script, Java, Windows 2000 / NT

Education Qualifications:

 Master of Technology (M.Tech.) in Computer Science, India

 Bachelor of Technology (B.Tech.) from Andhra University, India

Contact this candidate