Developer Project
Resume:
SUNAYANA SHETTY
Ph# 502-***-****
Email id :- ***************@*****.***
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