SUNAYANA SHETTY

Ph# 502-***-****

Email id :- aco9li@r.postjobfree.com

PROFESSIONAL SUMMARY.

1. Professional experience in Software Development life Cycle, Business & Data Analysis having specialized in

the areas of Client Server Architecture with special emphasis on Oracle Technologies.

2. Ambitious and self-motivated SQL developer with a strong technical background and 8+ years of work

experience.

3. Programming experience in Forms, Reports, and PL/SQL as well as writing Triggers Procedures. Functions,

Packages in Oracle and extensively worked on end-user requirements, analysis, systems study,

implementation.

4. Specialized in user requirement analysis, documenting test plans and execution.

5. Experienced in Bug Fixing, adding new features and bringing it up to date with the Database Version.

6. Expertise in creating Database Triggers, Stored Procedure, Stored Functions, Stored Packages and Exception

Handling in Oracle 8.x/9i.

7. Provide detailed technical specifications according to the client requirements.

8. Excellent team player with strong written, communication, interpersonal, analytical skills.

9. Self-disciplined and the ability to work with the minimum of supervision

10. Valuable experience in coordinating with distributed teams across the world.

TECHNICAL SKILLS

Databases : Oracle 10g/9i/8i/7.x, MS SQL SERVER 6.5/7.0, MS Access

Oracle Products : Developer 2000, Forms 3/4.5/5/6/6i/9/10g, Reports 2.5/3/6i, Designer 6i, DBMS,PL/SQL

Developer 7 Packages, Oracle Diagnostic and tuning package

Operating System : Windows NT and Windows XP/2000/98/95

Languages : SQL plus 7.3/8.0, PL/SQL 7.3/8.0, SQL*Loader, Java, J2EE, HTML, XML, C, Java Script

Application Server : Oracle Application Server 9i AS

ETL Tools : Oracle warehouse builder,Informatica

Business Intelligence Tools : Business Objects 7.0and MS access Reports

Data Modeling Tools : Erwin 3.5/4.0, ER/Studio

EDUCATION

1.Bachelor Of Engineering in Computer Science, University of Mangalore, India

CERTIFICATIONS

2.Oracle Certified - PL/SQL

PROFESSIONAL EXPERIENCE

Client Artech/Caterpillar/Peoria,Illinois

Duration May 2014 - August 2014

Role Oracle SQL Developer

Telematics ODS Project

Caterpillar Telematics Operational Data Storage System provides Caterpillar, its dealers and its customers with the

ability to remotely monitor equipment.

The Telematics Network Manager (also known as the A5:N2 device), used in conjunction with the new telematics

offering, enables the following capabilities:

• Real Time Data Streaming

• Two Way Communication (including remote configuration changes)

• Remote Diagnostics

• Increased CAT Engine and Ancillary System Monitoring

• Increased Customization to User Assets

Responsibilities

1.Analyze table structures and relationships in the ods database.

2.Create new tables and alter existing tables to add indexes,primary and foreign keys.

3.Alter views to include new fields,tables and modify existing joins on tables based on the requirements.

4.Tune queries for optimal performance.

SkillSets:-

Databases:-Oracle 11g

Oracle Products :- PL/SQL Developer,Oracle SQL Developer,Toad

Languages:- SQL plus,PL/SQL,SQL* Loader

Client Carewisehealth/SHPS, KY,US

Duration Nov 2007 – August 2013

Role Junior SQL Developer

KY Medicaid P roject And Tpagen P roject

Shps has 2 main products Ky Medicaid and Tpagen,Both these products use MaxMc Software for case and utilization

management.KY Medicaid serves the department for medical services through subcontract with HP.Prime product is

utilization management/basic prior authorization of services.It also serves as clinical partner.Reviews overstated

Health Care Bills and save money for clients.Each of these products include triggered communications that are

triggered for different events.When an event occurs,a sql query designed to identify this event extract data required to

produce the letters.These sql queries are executed by a .net app that outputs data in XML files.The xml files are then

sent to Exstream to generate letters.

SkillSets:-

Databases:-Oracle 10g/9i

Oracle Products :- PL/SQL Developer,Oracle SQL Developer

Languages:- SQL plus,PL/SQL,SQL* Loader,HTML,XML,C#.net

Automation:FLUX

Responsibilities

1.Tuning existing SQL queries to deliver optimal performance.

2.Writing SQL Queries as per the business specs for KY Medicaid and Tpagen.

3.Migration of the Perl scripting which embedded the sql queries to C#.

4.Development,documenting and maintenance of SHPS applications.

5.Improve maintainability over existing structure.Reduce development and implementation time.

6.Participant in design discussions for new features/functions within SHPS application suite.

7.Proactively look for learning opportunities with technical and subject matter domain.

8.Unit testing of code modifications to ensure that they meet the requirements outlined in the business specification

document.

9.Clearly communicate status,road blocks and concerns to the management on a on going basis.

10.Trained team members on the technical and subject matter of the ky Medicaid and tpagen projects.

Flux Automation Project – Migrates Processes to more transparent model.

Language – Java Bean Scripting

Brief Overview

Generate Flux Maps to automate the process flow execution of application.Simplifies and reduces the staff

duties.Automate the retrieving and sending of files to clients and vendors.Flux managed file transfers reduces errors

and improves timeliness over manual methods.Create automated workflows that contain conditional

branching,dependency,looping,parallelism,splits and joins.

Client Humana, US

Duration June 2007 – August 2007

Role Sql Developer

Project : Corporate Information Management

CIM is responsible for maintaining databases for Humana medical claims information. The department is transitioning

the databases to a data warehouse environment to enable better data analysis for the business analysts.

Responsibilities

1. Tune the existing SQL queries to deliver optimal performance

2. Find alternatives for intermediate table creations with more efficient joins.

3. Employ the explain plan, index & partition uses for better query output

4. Use Hints, parallelism and optimizer modes and convey the results to educate the team about the efficient

SQL techniques

5. Understand the structure of new tables and transition the old queries with new tables.

6. Sound knowledge in STAR schema concepts and implementation of SQL queries.

7. Complete field to field comparison of the transitioned tables.

8. Surrogate Key Checks for all the transitioned tables.

Environment

PL/SQL Developer

Client HealthCare Recoveries/Trover Solutions, US

Duration Jan 2007 - May 2007

Role PL/SQL Developer I

Project : Evidence Retention

Evidence has to be retained on health recovery claims in which the recovery opportunity depends on proof that a defect

existed in a product. As a result of evidence retention we have evidence stored both on-site in Louisville, KY and off-

site at various storage facilities. External facilities charge a monthly or quarterly storage fee for holding the product.

Currently, the evidence information is stored in On base, Troveris activity notes, party screen(s), and expense table.

Responsibilities

1. Create a screen to store evidence information, consisting evidence details and location.

2. Evidence screen should be available from the Add/Update Party screen.

3. Create a new expense type 'Estimate' that works similar to Void but can then be changed to active status.

Adjust all expense formulas accordingly.

4. Allow related estimated and paid expenses to be viewed from the Evidence screen.

5. Create a flag on party role code that indicates the party is an Evidence party.

6. Add a button to the party screen that allows user to add an Evidence party; add/update screen can be the

current screen, but filter for party role codes where evidence = yes.

7. Only enable Evidence button on Add/Update Party screen if party role code is flagged as Evidence party; if

party role code is changed to a non-Evidence party, delete Evidence information but include it in an activity

log.

8. Allow multiple evidences per party.

9. Add button on Party tab that allows user to View Evidence for the active party; allow user to move between

multiple Evidence for that party.

10. Management reports.

Environment

Oracle Forms 10g, PL/SQL Developer 7, UNIX

Project : Royalty Payments for Crawford

Incorporate the new client from Crawford Royalties in the Troveris System based on whether it is an existing Crawford

client or client referred to Troveris by Crawford and the contract status with the client. The hierarchy of setting up the

contract status is based on the employer, branch and client group levels.

Responsibilities

1.Developed user interface screens, Master detail relations and Report Screens.

2.Developed various reports for the end user as per the requirement and also created many reports to suit the pre-

printed format of the company.

3.Front end coding and Creating Lov's, Record groups, Libraries and menus

4.Write audit trails to the client activity table for all changes and

5.Display all the audit messages in entry date descending order

6.Charge a contingency fee and be able to invoice a client for specific charges as part of monthly reconciliation.

7.Set tiered pricing at a pursuit level.

8.Set up a contract based on the line of business (i.e.: auto vs property vs workers compensation)

9. Create a monthly extract detail all the information necessary for forecasting and reconciliation of Crawford Royalty

payments.

Environment

Oracle Forms 10g, PL/SQL Developer 7, UNIX

Client Hewlett Packard (HP), India

Duration April 2004 - November 2004

Role Technical Analyst –Tier I

Project VCI, VCPA, VCPG

Platform O racle 9i, Toad, Business Objects 5.x, HPUX, Win XP

* *Received HP Award for Excellent Contribution with personal commitment* *

Virtual Credit Intelligence (VCI) is the Global Credit and Collections Data Warehouse providing a standard worldwide

reporting environment. VCI is also designed to deliver business intelligence so that Hewlett Packard can better manage

the credit lines of its customers. Business Objects is the tool used in VCI. My role was to efficiently design the

repositories; ensure the productive output for the schedulers and the Web Intelligence services.

Virtual Credit Professional - Analysis (VCPA) is a web-based intranet application that is a credit analysis tool and a

data repository for HP customer credit-related information. It is the unique front office credit application used by HP

Credit to support transaction processing, decision making, static credit data maintenance, and document management.

All customer information, credit approvals and static credit data such as credit rating, credit line, credit scores,

financial information and credit analysis, is stored in one central location easily accessible by the WW credit

community, regardless of physical location.

Virtual Credit Professional - Global (VCPG) is a WW operational credit data store for exposure consolidation and

order filtering. It has a daily feed from HP customer master systems as well as daily feeds from HP accounts

receivable systems. VCPG also contains a customer cross reference table, which houses HP internal customer

identification numbers as well as the corresponding D&B numbers and hierarchy information. This allows HP Credit

to aggregate A/R exposure at a country legal entity level and enables a consistent treatment of a customer across all

related sites within a company’s legal structure.

My role included the following tasks:

1.Technical expert for credit application suites

2.Responsible for the high-availability of the applications and performance issues

3.Strategizing and implementing the new releases/features.

4.Problem analysis; Recovery; Communication and coordination with data providers for inbound and recipients of

outbound.

5.Testing and move-to-production activities of new projects and involved in the testing of service requests.

6.XML feasibility analysis for repository data storage for local access

7.Performance tuning of repositories for improving productivity

Project MAXIMO

Client Hewlett Packard (HP), India

Role Technical Analyst – Tier I

Duration March 2004 - May 2004

Platform SQL Server 2000, Win 2000

Maximo is a real estate workspace application (REWS) used to create and maintain work orders for all the service calls

which are routed to a call centre at Houston .It is also used to store details about how to fix an issue or maintain an

equipment. It helps in auditing of items in the inventory.

My role included the following tasks:

1.Assisting the lead architect in designing workflow tables

2.Fine tuning the workflow data source for efficient usage.

3.Responsible for the high-availability and accuracy of the report generation capability

4.Assign security groups to the applications users based on their roles

5.Performance tuning of repositories for improving productivity

Project On Guard

Client Hewlett Packard (HP), India

Role Technical Analyst – Tier I

Duration February 2004 - March 2004

Platform SQL Server 2000, Win 2000

On Guard application is used to monitor the site doors, alarms, cameras of a particular site. This application can also

be used to monitor security across a region or several sites/locations. On Guard offers the ability to partition the system

database into several individual segments. Each partitioned segment contains its own unique parameters and guidelines

for management, such as for access levels, time zones, and cardholders. Each operator within the system has unique

viewing, adding, modifying, and deleting rights over their segment's data. Multi-tenant environments can manage each

individual tenant under their own segment while keeping each company's data restricted only to their users. Corporate

environments use this option to allow their distinct operations/sites to have partitioned security while maintaining a

single cardholder population.

My role included the following tasks:

Regression testing of security applications to ensure high quality and safe operation of critical processes

Assign security groups to the applications users based on their roles

Project Product Packaging

Client HSBC, India

Role Packaging Support Engineer

Duration Sep 2002 – Feb 2004

P latform I nstallShield, Tivoli, Win 2000, Win NT

The project involved application migration and developing silent setups. Application migration is the process of

converting third party installation packages into Windows Installer setups (.msi) or InstallShield setups (setup.exe)

with the customizations. The packaged application consists of a setup.exe and the Install and removes batch scripts

which are used to initiate the install and remove the application.

The Tivoli software package editor [SPE] is used to create the software package block. The Tivoli desktop is then used

to create the software package profile through which the application is remotely distributed to several machines. Using

InstallShield and Windows Installer services as a packaging and deployment mechanism helped to simplify the overall

deployment and management process and lowered costs associated with the application deployment.

My role included the following tasks:

1.Create test scripts to test application installations

2.Application repackaging using Install Shield developer and Windows installer

3.Support, maintain and debug applications in adherence to company standardsProject

eBooks Generator

Client MagnaSoft Consulting, India

Role Trainee

Duration Sep 2001 - Aug 2002

P latform X ML, Windows NT

This project dealt with conversion of textbooks based on C, C++, Java, Perl to e-books. The code snippets from

textbooks were converted to complete executable programs before they were loaded on to the web servers.

My role included the following tasks:

1.Researching and analyzing eBooks development kits and techniques.

2.Assisting the lead architect in designing data schema for XML data store

3.Developing functional and design documents

4.Coding XML data retrieval module

5.Testing the application add-on feature with other applications.

6.Enhancing the presentation layer for ebooks setup.

Project Online Flight Reservation system.

Client University of Mangalore (Final Year Academic Project)

Duration April 00 - April 01

Platform Java 2.0, MS Access, Windows 95

This project implements airline reservation using client/server architecture. The server consists of the passenger, plane

and account databases. The project facilitates online booking of tickets.

My role included the following tasks:

1.Design and development of the system in Java technology employing object oriented methodologies.

2.Developing a user friendly web interface to the application

3.Testing the application against subset of real time data flight data

4.Analysis of other data store formats.

5.Documenting the help for the application

EDUCAT ION

Bachelor Of Engineering in Computer Science (First class), 2001

University of Mangalore, India

TRA I N I NG PROGRAMS ATTENDED

InstallShield Training, Microsoft Installer Admin Studio, CMM Level 3, Effective Communication Skills, Time

Management

Contact this candidate