Insurance Developer
Resume:
Raghu Pagidi
*****.******@******.***
*****.******@*****.***
Oracle Reports Developer
PROFESSIONAL SUMMARY:
6+ years plus of progressive IT experience working as Oracle Technical Consultant/Analyst
on Operating Systems viz. Windows 2000/NT/XP/2003 Server in 24x7 Production and
Development environments.
Experience with Oracle 8.x, 9i and 10g versions.
Experience in writing Procedures, functions, triggers and packages using PL/SQL.
Experience in Data warehousing design & Concepts and ETL
Experience in Oracle 7.x, 8.x and 9.x,10g (both on UNIX and Windows NT environment),
SQL*Loader, Export, Import, PL/SQL, SQL*Plus, Performance Tuning of Database by
optimizing SQL, PL/SQL scripts, DB links, Materialized view creation, index creation and
fine tune queries.
Monitoring and optimising the SQL Queries through Database Tuning.
Expertise in developing forms using Oracle Reports 4.5/5.0/6.0/6i/9i/10g.
Experience on Logical & Physical Designing of Databases. Data Modelling, Conceptual
Design & Data Architecture..
Very Strong in database management, excellent understanding of Oracle Internals,
Architecture and Data Dictionary.
Basic DBA activities like creating of databases, users, and table spaces.
Experience in Administering Oracle Database using Toad.
Documentation as per the client requirement.
Expertise on Insurance Domain knowledge.
Extensively worked on Onsite-Offshore models. Participated in Requirements gathering onsite and
transferred the knowledge to offshore.
Responsibilities include extensive client interaction to understand expectations, requirements,
formulating solutions, designing the architecture and developing the application besides
managing teams.
In depth knowledge in Software Analysis, QA testing, design, development and implementation
in various Client/Server which involves all phases of SDLC.
Played an active role in quality-related activities leading the projects to CMM-Level 5 and ISO-
9001 quality standards.
Involved in Management related activities like generation of metrics on monthly basis and
submitting the same to the clients.
Initiating the project with identifying the requirements, estimating and designing. Ensuring
and implementing a good development plan. Work distribution and tracking is one of the
prime responsibilities.
Extensive experience in software development lifecycle and adept in software coding
standards.
Excellent interpersonal, analytical and communication skills.
EDUCATION:
Bachelors in Engineering
TECHNICAL SKILLS:
Operating Systems: Windows 2000/NT 4.0/98/95/XP
RDBMS: Oracle 7.x, 8i, 9i, 10g, MS SQL Server 2000/7.0 and MS-Access
GUI Tools: Developer 2000 (Forms 4.5/5.0//6.0/9.0, Reports 6i/10g)
OLAP Tools: Business Objects5.x
Languages: SQL, PL/SQL.
Other Tools : SQL*LOADER, TOAD,PL/SQL Developer
PROFESSIONAL EXPERIENCE
Client: Schering Plough,Springfield, NJ Aug 08- Tilldate
Project: AERS
Oracle Reports Developer
Oracle AERS is a full-featured adverse event reporting system that enables you to capture, review, and
report adverse events from clinical, spontaneous, and post-marketing sources. Oracle AERS System
Administrators have various responsibilities, which include managing security (from Oracle AERS sites to
Product Groups to Users); generating regulatory and non-regulatory reports; gathering drug compound
information; and administering code lists, studies, and reporter records. Oracle AERS reports are highly
configurable
Schering-Plough is an innovation-driven, science-centered global health care company. Our combination
with Organon Biosciences is a transformational step on Schering-Plough’s continuing journey as we build
a high-performance company for the long term. Schering-Plough’s closely linked global animal health
business is a leader in its industry, serving veterinarians, farmers
And pet owners with important products and services.
.
Responsibilities
Designed and developed various types of complicated Reports.
Written stored procedures, Functions and Package to implement business rules using SQL
and PL/SQL.
Developed database tables/views for designing the database using primary keys and foreign
keys and establishing relationship between the Tables.
Extensive Use of normalization techniques to fine tune the database to reduce the Data
Redundancy for better performance
Responsible for customizing various reports.
Responsible for extensive data validations, feeding of live data and user acceptance for each
module.
Actively participated in User Acceptance Testing.
Written SQL scripts during implementation at the client's place and trained the end users.
Actively participated in Preparing UTC(User test checklist) and involved in executing the
checklist.
Designed and extensively worked on project documentation.
Extensive use of TOAD for extracting scripts from the dictionary
Use of Bit map and Function based indexes to improve performance of queries
Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref
Cursors.
Involved in Preparing Report design Specification Technical documentation.
Environment: Oracle 10g & D2K, Reports 10g, Windows XP
Client: Beta Health Association, Denver, CO Feb 07-June 08
Project: PREMIA Lite
Oracle Reports Developer
PREMIA Lite is a fully integrated, Intel based, single entry, processing system, designed to meet the
complex data processing needs of Insurance companies, Managing General Agents, Program
Administrators, Brokers and Retails Agents. With PREMIA Lite, we provide small and mid-market
insurance enterprises our rich industry-specific expertise and knowledge gained from many successful
global Insurance solution implementations. PREMIA Lite supports all the major lines of business and can
be used by Insurance Carriers, Managing General Agents, Program Administrators, Brokers and Retail
Agents.
Beta Health Association, Inc. is a Denver, Colorado based company specializing in both voluntary
(employee paid) and contributory (employer paid) dental insurance, dental services, and dental plans
since 1990. Beta Health Association, Inc offer individual dental plans and group dental plans as well as
group dental insurance. Beta Health Association, Inc is affordable in dental services and dentist offices
throughout Colorado and strive to provide customer service and value.
Responsibilities
Designed and developed various types of Interface Forms and Reports.
Written stored procedures, Functions and Package to implement business rules using SQL
and PL/SQL.
Developed database tables/views for designing the database using primary keys and foreign
keys and establishing relationship between the Tables.
Extensive Use of normalization techniques to fine tune the database to reduce the Data
Redundancy for better performance
Responsible for extensive data validations, feeding of live data and user acceptance for each
module.
Actively participated in User Acceptance Testing.
Using the advance Oracle functions Like Analytical functions.
Written SQL scripts during implementation at the client's place and trained the end users.
Customized maintained several interface Forms and Reports.
Design and development of Interfaces to Integrate modules
Use of LOVs, RG, Alerts, Object groups and other important features of D2K
Extensively Involved in Developing Reports,Interface Forms which involve a lot of validations
at all the levels.
Also Involved in Resolving the Tickets in Service Center depending on the priority of the
tickets.
Worked as Primary on the roles of the production support.
Designed and extensively worked on project documentation.
Extensive use of TOAD for extracting scripts from the dictionary
Use of Bit map and Function based indexes to improve performance of queries
Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref
Cursors.
Involved in Preparing Detailed technical documents
Providing code fixes as well as data fixes for bugs raised in SSP – Premia QC Calls, UAT
Calls
Environment: Oracle 10g & D2K, Forms 10g, Reports 10g, Windows XP
NMIC(Navada Mutual Insurance Company), Las Vegas, NV Nov 05- Dec06
Project: PREMIA
Oracle Reports Developer
PREMIA10i is a product for insurance companies. It provides great flexibility to insurance
companies to handle their activities. This basically contains four modules. They are Underwriting, Claims,
Re-Insurance, and Accounts. Underwriting involves the process of raising the quotations, proposals, Risk
Analysis, Covers, and Policy Issuing. Claim Deals with Process like Claim Intimation Details, Estimation
of Loss, FIR Details, and Survey Reports. Re-Insurance is a process of sharing losses among different
insurance companies, usually when the risk is very huge the insurance companies prefer this approach.
Finally, Accounting Deals with the monetary issues of the insurance companies Business.
This Product PREMIA10i is used for a wide variety of products like Fire, Motor, Marine Cargo,
and Aviation along with the general insurance. Any Insurance company can easily configure this product
according to their requirements.
Nevada Division of Insurance granted Nevada Mutual a Certificate of Authority authorizing it to
offer medical professional liability insurance to Nevada doctors. Nevada Mutual is the only doctor-owned
insurer domiciled in Nevada and only insures Nevada doctors.
Responsibilities
Developed Front-end screens using Developer 2000.
Involved in Preparing the test cases and also Unit testing.
Involved in Preparing Low Level Design Documents, High Level Design Documents,
Program Specifications
Coded the Stored Procedures and function. And well tuned the SQL in the application.
Involved in Developing Reports And Interface Forms
Migration of databases from one version to the other versions and applying patches.
Creation of schema objects, granting of roles and privileges to the users, compilation of
procedures etc.
Generation of the flat files using UTL_FILE package for the mainframe users
Database design, E-R diagrams, Logical, Physical layout design using Erwin.
Extensively Involved in Knowledge Transfer for the documentation team for the development
activities carried out by our team.
Data modeling, database design and creation of database using data modeling tools.
Involved in creating JSP pages with HTML and Javascript.
Defining and reviewing the coding standards, besides reviewing the code.
Designed and extensively worked on project documentation.
Analyzing the enhancement / support request, estimating effort and providing architectural
and technical support to the team, besides developing key components.
Directly interact with the client to get the requirement and domain knowledge.
Responsible for Detail Design, Coding, Implementation of Reports.
Written extensive SQL, PL SQL code as needed
Preparation of Checklists, identification of Test Cases, preparing and executing Test Plans at
Unit and Integration level.
Providing code fixes as well as data fixes for bugs raised in SSP – Premia QC Calls
Environment: Oracle 10g & D2K, Forms 10g, Reports 10g, Windows NT Involved in creating JSP
pages with HTML and Javascript..
Client: Westminster Insurance Company, Maryland May 04 to Oct 05
Project: Auto Insurance
Oracle Forms/Reports Developer
This is an auto insurance company which deals with the insurance of automobiles in USA.
Responsibilities
Writing Custom Packages to implement various functional areas
Schedule jobs via Oracle jobs using DBMS_JOB.
Responsible for Detail Design, Coding, Customization of Reports and coordinate with Onsite
Implementator
Providing code fixes as well as data fixes for bugs raised in SSP – Premia QC Calls
Written extensive SQL, PL SQL code as needed
Involved in Internal Unit Testing.
Involved in sending patches to QC.
Use of various DBMS packages to reuse code and automate scripts
Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref
Cursors.
Extensive use of Oracle 9i features
Extensive use of TOAD for extracting scripts from the dictionary
Extensive use of PL/SQL Collections and Records
Creation of Synonyms to create read only objects to maintain the security to give access to
specific users.
Use of Sequences to automate number generation
Use of different Exception Handlers and also Create Some User defined Exception Handlers.
Customization of the support screens
Use of Bit map and Function based indexes to improve performance of queries
Design and development of Interfaces to Integrate modules
Use of LOVs, RG, Alerts, Object groups and other important features of D2K
Environment: Oracle 9i/8i, SQL, PL/SQL, SQL*Loader, ISQL * plus. Windows 98
Client: HALLMARK FINANCIAL SERVICES, INC, TEXAS Jan 03-March 04
Oracle Reports Developer
Hallmark's business plan is to operate as a diversified underwriter of niche property and casualty
insurance products. This plan is executed by four wholly owned operations, each with separate specialty
product focus. Each operation is independent of each other and has their own senior management,
underwriting, and claims staff.
Responsibilities
Involved as a key team member for Requirement Analysis during the design phase and
interaction with the client.
Involved in Preparing Detailed technical documents
Extensively worked on Developing Reports 6i and Testing of Reports in every Level .
Involved in Code Review and preparing unit test cases
Extensive Use of Bulk Binds, Bulk Collect.
Involved in Writing Backend Procedures, Function & Packages in PL/SQL
Optimized and enhanced the existing procedures and SQL statements for the better
performance.
Defining and reviewing the coding standards, besides reviewing the code.
Preparation of Checklists, identification of Test Cases, preparing Test Plans.
Integrating and deploying in production
Preparation of low-level and high-level specifications
Responsible for Detail Design, Coding, Implementation of Reports
Involved in Development of new Reports, Interface Forms as per Client requirement and
coordinate with Onsite Implementator
Written extensive SQL, PL SQL code as needed
Involved in Internal Unit Testing
Involved in sending patches to QC.
Experience in the Cretation of XML Reports with Oracle
Environment: Oracle 9i & D2K Reports 6i, Windows 98
Global Payments, Atlanta Aug 02 to Nov 03
Project: Electronic Transaction Processing
Oracle PL/SQL Developer
Global Payments (NYSE: GPN) is one of the world’s largest transaction processors and offers
worldwide, world-class electronic transaction processing services through our high speed, robust
electronic information networks. These networks process billions of business and consumer payment card
and money transfer transactions annually for customers in the United States, Canada, Europe and Latin
America
Responsibilities
Involved as a key team member for Requirement Analysis during the design phase and
interaction with the client.
Involved in Writing Backend Packages extensively in PL/SQL.
Involved in Code Reviews and preparing unit test cases
Maintained the data integrity and security using integrity constraints and database triggers
Optimized and enhanced the existing procedures and SQL statements for the better
performance.
Defining and reviewing the coding standards, besides reviewing the code.
Created, debugged, and modified stored procedures, triggers, tables, views, user-defined
functions etc.
Extensively Involved in Preparing Detailed technical documents from the functional
specifications.
Integrating and deploying in production
Preparation of detail design documents.
Customization of code as per the user requirements.
Involved in the analysis of the existing database.
Designed and extensively worked on project documentation.
Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc.
Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE,
HINTS etc. Oracle query tuning and optimization.
Extensive Use of Pragma Autonomous Transactions.
All the values that need to hard code extensively use parameters for better procedural
development.
Built Error management System for the Capturing all the Errors in the Packages and all the
errors that belong to pl/sql are generated using error management system by QNXO
Also Built Error Logging system so that the debugging of the packages becomes convenient
Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
Co-ordination between development, testing and production teams and attending bridge calls
and technical. Discussions regarding future developments and releases.
Environment: Oracle 9i/8i, SQL, PL/SQL, Windows 95
Contact this candidate