Anusha Perera

***, ***** ****,

Staten Island,

New York,

10314

Tel : 646-***-****

Email: sd8085@r.postjobfree.com

Objective:

To obtain a challenging Software Engineer position with opportunity for growth and career advancement.

CAREER PROFILE

• Has FOURTEEN YEARS of professional experience in Database Development using SQL and PL/SQL, System Study, Design, Development and Implementation of various Software Applications.

• Has more than Twelve years of extensive Analysis, Design, Development and Implementation experience in Oracle Applications.

• Her expertise includes extensive technical knowledge & work experience on ORACLE 8i/10g, using Oracle Forms, PL/SQL, ORACLE Reports, SQL*Plus, DESIGNER 2000, DEVELOPER/2000, DEVELOPER/6i and other related tools and techniques on ORACLE database system.

• Has good experience in developing front-end GUI based applications using DEVELOPER/6i, DEVELOPER/2000, and Oracle Forms and Reports 6i.

• Has excellent Technical skills & Work Experience in Development & Implementation on ORACLE INSURANCE and FINANCIALS System. Worked extensively on Financial modules like General Ledger GL , Accounts Payable AP , Accounts Receivable AR , Money laundering, Bank Reconciliation, Cash Management CM and Fixed Assets FA and also Manufacturing modules like Inventory INV .

• Has three years experience in Oracle and Data warehouse and Solid experience and knowledge in ETL and Data warehousing concepts.

• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)

• Familiarity with Oracle data warehousing features such mappings ,Scheduling, materialized views, bitmap indexes, Index Organized Tables, external tables etc.

• Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables

• Sound Knowledge and Experience with Business Objects XI 3.1

Universe Builder, SAP Business Objects (Web business Intelligence Document)

• Experienced in Database Optimization by making use of various Performance Tuning techniques.

Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN and index.

• Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes.

• Experienced in Normalized Database Design and Modeling. (Logical and Physical design of database)

• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.

• Experience in physical and logical data modeling.

• Very good knowledge and experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc.

• Extensively worked in Oracle Forms, Reports.

• Very good working knowledge in TOAD.

• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.

• Worked with version control tools like VSS, CVS.

• Experienced to translate reporting and analytical needs into technical solutions

• Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and plans.

EDUCATION

Academic and Professional Qualification Qualifications

Duration Course/Examination Institute

Sep 2007 to March 2010 Master of Information Technology

University of Colombo School of Computing,

Sri Lanka

June 1996 to November 1999

B.Sc Degree concentration on Information Technology

Industrial Management

University of Keleniya ,

Sri Lanka

Dec 1999 march 2000 Under went training on ORACLE 8.0, 8i, Developer/2000 (Forms 6.0 & 6i, Reports 6.0 & 6i) John Keels Institute of Information Technology a division of TATA INFOTECH LTD India.

Jan 2006 Oracle Database 10g: SQL Tuning workshop Oracle University in India

June 2008 Oracle Database 10 g

Advanced PL/SQL Training Oracle University In India

Familiar Software/Hardware

Area Description

Programming Languages Developer/2000 Forms 6i, Report 6i, SAP Business Objects XI 3.1, Oracle warehouse builder 10g, Java, JavaScript, XML ,PHP,HTML,

Visual InterDev (Java Script, VB Script, ASP) Visual Basic 6

SQL, PL/SQL, Oracle Forms 10g , Reports 10g,Business

ORACLE Discoverer (Analytical reporting tool),

C++, Pascal

Database

ORACLE 10g, ORACLE 9i, ORACLE 8i, My SQL, MS SQL Server 2005, MS Access, WAMP Sever, Oracle Warehouse Builder 10g.

Application Software

Microsoft Office, Open Office

Operating Systems

Windows XP, Linux ,MSDOS, Windows 95, 98, 2000, Windows NT

Experience

Janashakthi Insurance Co. Ltd. is the third largest market leader in the insurance market in Sri Lanka. The company provides employment for over 4000 staff-servicing customer’s island wide 24x7 with different types of product and services. Janashakthi is able to render high quality service with tremendous IT infrastructure, which has connected most of its branches island wide online.

The insurance application at Janashakthi has been developed to cover all aspects of insurance such as general and life insurance and also has incorporated financial modules such as accounting, fixed assets, inventory purchasing, sales and marketing and MIS reporting.

And also this system provides facility to end user to analyze the data and make management decision among their competitors.

Data warehouse is another application used to analyzed data in the transaction system and it helps to make decision to the top management

2 years

3 Years

Data Warehouse and Business Intelligent Developer

Duties and Responsibilities

System analysis and design

Technical writing

Software development

Application fine tuning

Quality Assurance

Data transfers between Oracle Databases (production and testing)

User training and Coordination with other divisions.

Software configuration management

Assistant Manager (New product development) - Janashakthi Insurance company Limited

New product development team to the Janashakthi Insurance PLC

Developed new product for Life Insurance And General Insurance

E-Business Application of Easy -pay Module for the Janashakthi insurance system

This system was integrated with the existing Insurance system and it is facilitated to the customer to pay the premium by using SMS and mobile application for the insurance system

ERP Application of Agent training Module

This system is enabling to the human recourse department to track the agent training and analysis the cost benefit to the company.

Handling ERP System

Supply chain management

Order to cash, inventory, order entry, purchasing, product configuration, supply chain planning, supplier scheduling, inspection of goods, claim processing, commission calculation

Human resources

Human resources, payroll, training, time and attendance, benefits

Financials

General ledger, cash management, accounts payable, accounts receivable, fixed assets ,Bank reconciliation

Customer relationship management

Sales and marketing, commissions, service, customer contact, call-center support

Data services

Various "self-service" interfaces for customers, suppliers and/or employees

Access control

Management of user privileges for various processes

Technical Leader - Janashakthi Insurance company Limited

Duties and Responsibilities

System analysis and design

Technical writing

Software development

Application fine tuning

Quality Assurance

Data transfers between Oracle Databases (production and testing)

User training and Coordination with other divisions.

Software configuration management

Technology & Tools

ORACLE 10g as the Backend Data Repository

Database Stored Procedures and Functions

Oracle Developer 6i forms and Reports and Oracle Developer suite 10g

SQL Plus

SQL Navigator (Quest Software)

Toad (Quest Software)

Business Object XI

2 Years System analyst - Janashakthi Insurance company Limited

Duties and Responsibilities

System analysis and design of the accounting system and

Management reports for the Marketing and Management team

Data analysis and providing some decisions

Technical writing

Software development

Application fine tuning

Quality Assurance

Data transfers between Oracle Databases (production and testing)

User training and Coordination with other divisions.

Technology & Tools

ORACLE 9i and ORACLE 10g as the Backend Data Repository

Database Stored Procedures and Functions

Oracle Developer 6i forms and Reports and Oracle Developer suite 10g

SQL Plus

SQL Navigator (Quest Software)

Toad (Quest Software)

Business Object XI

Role Played Team

System Analysis and Design 7 Members

Forms and Reports Development

Quality Assurance

Implementation & user training

Database Installation and Configuration

Database backup and recovery

Technology and Tools

ORACLE 8i as the Backend Data Repository

Database Stored Procedures and Functions

Oracle Developer 6i forms and Reports

Power Designer (Sybase)

SQL-Navigator (Quest Software)

5 Years Analyst Programmer -Janashakthi insurance company Limited and

National Insurance company had in-house build Insurance system and it was consist of all general and Life Insurance module.

Life Insurance system

General Insurance system

Hrm system

Payroll system

Role Played Team

Team Leader 6 Members

Systems Analysis and design

Research

Software development

Quality Assurance

Technical Documentation & User Manual

Implementation

User Training

Technology & Tools

ORACLE 9i and ORACLE 10g as the Backend Data Repository

Database Stored Procedures and Functions

Oracle Developer 6i forms and Reports and Oracle Developer suite 10g

SQL Plus

SQL Navigator (Quest Software)

3 Years Analyst Programmer -National insurance company Limited

National Insurance company had in-house build Insurance system and it was consist of all general and Life Insurance module. It was also consist of the Pay roll system HRM system and

Life Insurance system

General Insurance system

Hrm system

Payroll system

Role Played Team

Team Leader 6 Members

Systems Analysis and design

Research

Software development

Quality Assurance

Technical Documentation & User Manual

Implementation

User Training

Technology & Tools

ORACLE 9i and ORACLE 10g as the Backend Data Repository

Database Stored Procedures and Functions

Oracle Developer 6i forms and Reports and Oracle Developer suite 10g

SQL Plus

SQL Navigator (Quest Software)

6 Months Project Manager – Fault Tracking System to It Department

This Project Was developed Using PHP and My SQL this is a web based system

Role Played Team

Project Manager 4 Members

Project Planning

Writing software program specification

Handle review Meetings

Quality assurance

Technical Documentation & User Manual

Implementation

User Training

Technology & Tools

WAMP server as the Backend Data Repository

Database Stored Procedures and Functions

PHP

1 Year Computer Demonstrator - University of Kelaniya

MIS system-To University of Kelaniya

Overall development of this project .

Role Played Team

Project Manager 4 Members

System analyst

Designing and development

Quality assurance

Technical Documentation & User Manual

Implementation

User Training

Technology & Tools

WAMP server as the Backend Data Repository

Database Stored Procedures and Functions

PHP

References

Available upon request.

Contact this candidate