Quality Assurance Project Manager
Resume:
Anusha Perera
Staten Island,
New York,
10314
Tel : 646-***-****
Email: ****************@*****.***
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