ASHAKIRAN BATTULA

858-***-****© ukefct@r.postjobfree.com

OBJECTIVE:

Highly motivated, creative and organized software engineer with strong technical expertise, analytical skills, seeking a challenging position as Oracle PL/SQL developer.

PROFESSIONAL SUMMARY:

• Over six years of diversified experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.

• Expertise in using Oracle 8i/9i and good knowledge in 10g databases.

• Proficient working experience in SQL, PL/SQL, stored procedures, functions, packages, DB triggers and indexes.

• Working Knowledge of UNIX shells scripting.

• Strong in using tools such as PL/SQL developer, SQL*Loader, TOAD and SQL*Plus.

• Experienced in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.

• Good working experience in Reports 6i/9i for customization of several reports as per client specifications.

• Expertise in Visual Basic for applications for MS Office.

• Expertise in all phases of Software Development Life Cycle including analysis, physical and logical design, resource planning, code development, testing, validation, implementation and maintenance.

• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Visual Basic, VB Script

Databases: Oracle 8i/9i/10g, SQL Server 2000, MS Access

Packages: MS Office (Word, Excel, Access)

Operating Systems: Windows 2000/XP/UNIX

Oracle Tools: PL/SQL Developer, TOAD, SQL*Loader, Oracle Reports 6i/9i

Testing Tools: Test Director 8.2/8.0,Quality Center 9.0, QTP 9.0/8.2/8.0.

EXPERIENCE:

Nationwide, Columbus, OH 01/2010-Current

Nationwide is insurance company. It offers insurance for health, life, insurance; mortgage, car and business oriented insurance policies. My primary responsibility at Nationwide was to process the data obtained from the insurance members and simultaneously develop applications for using this data. Tasks include:

• Functional and Technical understanding of the insurance domain to validate the data obtained from the insurance members.

• Used SQL*LOADER to store data in the Oracle database from different types of flat files.

• Developed stored procedures to validate the data obtained.

• Developed Packages, procedures, functions and triggers in the database to explicitly handle various feeds.

• Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the database.

• Developed reports using Oracle reports 9i for the summary of customer report.

• Developed user documentation for all the application modules.

Environment: Oracle 10g/9i, SQL*Loader, UNIX, PL/SQL developer, VB

Eastman Kodak, San Diego, CA 04/2008--12/2009

Designed and developed Test Cases, Scripts for Kodak All-in-one Home Center application on the windows platform. It is in Kodak family of three models of thermal Inkjet AIO (All-in-One) printers such as 5100, 5300 and 5500 used to perform different actions on printers such as Printing, Scanning, Copying and Fax. Tasks include:

• Worked with other Team members in designing Test Plans, Regression Testing and release planning.

• Implemented various Test Cases with the following concepts.

• Understood Functional Requirements and System Specifications.

• Developed both Manual and Automation Test Cases.

• Designed Test Procedures for different parts of the application, GUI and Non-GUI.

• Provided documentation.

• Used the Test Director, Quality Center and QTP concepts on various project tasks.

• Parameterized property values for objects and checkpoints in QTP.

• Worked with Object Repository to identify objects in the application.

• Used Data Driven Testing to check the behavior of application with different inputs of data.

• Generated detailed reports of the Bugs, Pass-Fail report and assigned defects to other team members.

Environment: QTP 9.0, Test Director 8.2, Quality Center 9.0, MS Excel

Prudhvi Solutions Ltd, India 01/2007--03/2008

The main purpose of the project is to store all the details of the patients in the hospital. This project mainly gives the information about hospital. This project contains Patient Registration, Bed Record Maintenance, Service Charge Maintenance, Bill Generation, Payment Collection, List of Patients and Vacant Bed List. Tasks include:

• Involved in requirement analysis and design.

• Created and managed the database.

• Created database triggers for data security.

• Coded Stored Procedures, functions to be called by java modules.

• Fine Tuned the SQL queries using hints for maximum efficiency and performance.

• Created various reports using Oracle 6i.

Environment: Oracle 9i, Reports 6i, SQL Loader, Toad.

Raymond India Ltd, Hyderabad, India 04/2006--12/2006

Member of the team that designed, developed, tested and implemented as Sales Order Processing

(Client/Server ) application which keeps track of customer’s information, dealer’s information, variation of pricing, order status, agent commissions, payments to dealers and manufacturers.

• Customized reports to give business users meaningful data.

• Writing Oracle Packages, Procedures and Triggers.

• Loading of data periodically using SQL*Loader Utility.

• Worked with SQL Queries to extract data from the databases and indexes.

• Technical documentation to make all development process oriented.

• Use of Sequences to automate number generation.

Environment: Oracle 9i, PL/SQL, SQL*PLUS, SQL, TOAD, SQL*Loader, VB.

A.M. Technologies, Gujarat, India 01/2005--03/2006

A.M Technologies is a School Management System having Student details, employee details, timetable, School Inventory, grade system, Progress report, accounts module etc.

Responsibilities:

• Did analysis for the school requirement module.

• Did SQL query to get data from the database related to each button and list in the front end.

• Wrote DDL Scripts and created tables, indexes, and views.

• Created new Tables, integrity constraints (Primary Key/Foreign Key) in Oracle.

• Implemented business rules on data using Stored Procedures, Functions and Packages.

• Created reports using Oracle reports for fees receipt, exam report, attendance report, pay check, timetable etc.

Environment: Oracle 8i, Reports 6i, SQL*Loader, TOAD.

Contact this candidate