Sql Oracle

RAMANA TUNUGUNTLA

Wheeling, IL

******@*******.*** / Phone: 602-***-****

SUMMARY:

• Experience in software development including database design.

• Ability to work effectively in teams as well as individually with excellent communication, analytical, design,

organizational and problem solving skills.

• Excellent skills in PL/SQL programming, Oracle Forms, Oracle Reports and Crystal Reports

• Extensive experience in Extraction, Transformation and Loading (ETL) processing

• SQL Loader and Ab Initio GDE

• Database experience developing transactional and data warehouse environment

• Ability to work in a fast paced environment and meet tight project schedules

TECHNICAL SKILLS

Oracle 9i, 10g, 11g; SQL*Plus®, PL/SQL, Query Tuning, SQL Navigator 6.2, SQL Developer, TOAD, Crystal Reports

8.5, Oracle Reports, Oracle Forms, VISIO, Silverrun Design Tool, Oracle Design Tool, MS Access, MS Excel, MS Word,

SQL*Loader, ETL using PL/SQL, SVN Source Control, Visual Source Safe Source Control, SDLC Methodology,

Unix/Shell scripting, UNIX / LINUX environment, UNIFACE 6.0, COBOL, Ab Initio

EXPERIENCE

Abbvie, Waukegan, IL (Contract) April 2013 – July 2013

Senior Software Analyst –

• Re-arch of existing TCGM (Trading Cost Gross Margin) application

o cleanup of the old and unused code,

o removing of tables which were not used, merging different tables

o adding proper errors/messaging information

• Analyzing, problem determination, troubleshooting and resolutions

o with offshore team for development of production issues

• Participate in status calls / issue resolution calls / Troubleshoot issues

• Create views, procedures to feed the reports software

Environment: Oracle 11g, SQL*Plus®, PL/SQL, Toad, MKS Version control, Bug Tracker

Allstate Insurance, Northbrook, IL (Contract) January 2012 – March 2013

Technology Lead –

• Coordinating the software releases to production (Major/Minor/Hot Fix releases).

• Design & Code Review the programs (developed in SQL) for business standards.

• Managed defect teams while working with upper management.

• Organized regression testing meetings.

• Carried out communications between the offshore team and management.

• Analyzing, problem determination, troubleshooting and resolutions.

• Participate in status calls / issue resolution calls / Troubleshoot issues.

Environment: Oracle 10g, SQL*Plus®, PL/SQL, SQL developer, IBM Clearcase, IBM Clearquest, Sharepoint, MS

Excel

Ramana Tunuguntla

Redflex Traffic Systems, Phoenix, AZ September 2006 – July 2011

Sr. Database Developer –

• Analyze business and product requirements and translate these into a good physical data model and database

design.

• Designed and Developed PL/SQL programs including packages, procedures, triggers, views, collections,

indexing, Data Mapping, and Profiling.

• Worked with project managers, VPs, and directors to get requirements, status updates, and direction.

• Worked directly with in-house and external clients including city officials to define business requirements and

resolve data-issues before, during, and post-production.

• Led design and support meetings with clients to make sure their needs were met.

• Agile, Waterfall - SDLC / SW development processes

• Monitored day-to-day production application activities and Support Inbox emails as prioritized by the Support

Team on a daily basis.

• Identified and resolved problem, emails relating to Bank Interface, Collections Interface, Violation Notices, daily

reports.

• Designing and constructing the ETL (Extract, Transform, and Load) jobs to process the adjudication and

disposition data files.

• Review the developed programs for business standards. Analyzing, problem determination, troubleshooting and

resolutions.

Environment: ORACLE 10g, 11g; SQL*Plus®, PL/SQL, SQL Navigator 6.2, SQL Developer, Crystal Reports 8.5,

VISIO, MS Access, MS Excel, MS Word, SQL Loader, ETL using PL/SQL, SVN Source Control, Visual Source Safe

Source Control, SDLC Methodology, Unix/Shell scripting, LINUX

United Health Group, Phoenix, AZ August 2003 – September 2006

Analyst/Programmer -

• Design & Develop the AZ Encounters System – Extract payment claims to submit the Medicaid claims in

Proprietary formats using Oracle 10g database PL/SQL packages, functions and procedures.

• Develop the programs to submit the AZ Encounters claims into more secured HIPAA format, specifications

designed by the AZ HIPAA team and testing the submissions.

• Design & Develop programs to accept and process and submit the Pharmacy claims to the AZ State.

• Resolving production, system issues.

Environment: ORACLE 9i; SQL*Plus®, PL/SQL, Query Tuning, TOAD, VISIO, MS Access, MS Excel, MS Word,

SQL*Loader, Ab Initio GDE, ETL using PL/SQL, Visual Source Safe Source Control, SDLC Methodology, Shell

scripts, UNIX

SILVERLINE TECHNOLOGIES, INC February 1995 – August 2001

Systems Analyst/Developer -

Breakdown of clients and roles:

Carboline Company, St. Louis, MO

• Carboline is in the business of developing, manufacturing, and marketing products and services of high

performance industrial coatings and fireproofing to industrial, architectural and applicator companies throughout

the world.

• This was a comprehensive application system comprised of Order Entry, Billing, Sales and Inventory modules.

The Order Entry module maintained information on all orders placed by customer representatives and the Billing

module generated invoices and invoice details for all processed orders.

• Prepared the program specifications and developed and tested the report programs for the Order Entry, Inventory

Control and Sales modules. Views and stored procedures were written to generate complex reports.

• Developed and tested Oracle Forms for the Sales Module to enter, access, change, or delete data from the

database. Created parent/child forms, menu, buttons, event handler, triggers, etc.

• Conversion from COBOL

Ramana Tunuguntla

Environment: ORACLE Database; ORACLE Reports, ORACLE Forms, UNIFACE, COBOL

NDC Health, Phoenix, AZ

• NDC Health Information Services is a fully owned subsidiary of National Data Corporation. It gathers data from

data agents, pharmacies, drug store chains and health care providers from individual practitioners to hospitals and

large HMOs - to give its customers, primarily the health care manufacturers, information on which to base their

business decisions.

• Developed standards and procedures for production support including error handling, restart/restore, error

severity escalation. Modified scripts developed in UNIX shell.

Environment: Shell scripts, UNIX

Communication Technology Center, Bellevue, WA

• The project with CTC was to replace the existing Payroll/Personnel Management System (PPMS) into HRMS for

Technical Colleges in the State of Washington. The system included modules such as foundation, payroll,

employee information, personnel planning, applicant tracking and employee benefits.

• This was a continuation of the project to develop a HRMS. I was responsible for the Low Level Design and

Development of Help, Transaction Approval sub-modules.

• Conversion from PROTOS-COBOL

Environment: ALLBASE Database, UNIFACE, Silverrun Design Tool, ORACLE Design Tool, PROTOS-COBOL

The Robinson Group, Phoenix, AZ

• This project with The Robinson Group (TRG) involved developing a Student Financial Aid package for the

University of Chicago. The system was developed in a client / server architecture, using UNIFACE, to allow for

multiple users and platforms.

• I was responsible for preparing the Technical specification conversion, Data modeling, Development and Testing.

Environment: ORACLE Database, UNIFACE

EDUCATION

Bachelors of Science, India

Ramana Tunuguntla

Contact this candidate