Click www.theory-test.co.uk 

Click www123yum.com

This website is fully developed for selling medical equipments for any hospital.The site has two module one for user and another for admin module.The site also have integrated payment gateway which accepts any type of credit card. Email notification is sent to user from admin after completion of purchase.

Click www.usaihgmedical.com 

Citizentest website’s primary objective is to help applicants pass the ‘Life in the UK’ test in their first attempt. Secondary objective is to provide information about the test and attaining naturalisation is an easy to understand plus practical way.

Project Background

Non-SA QME and SA QME (Quality Monitoring Exercise) are activities undertaken once a year in each area, to check the quality of work done on Non-SA cases and SA Cases. Approximately 250 / 300 cases from each area will be checked. The input is done by a total of 70 users, spread over the different areas. At present the QME Report Form is used to collect the information, however no proper validation exists and there are problems processing the data.

Functional requirement

·        The system should allow the on-line completion and input of the QME Report form, QMO Analysis of Pre-Selections and Large Errors Report.

·        The system should collate all data input and then populate a SQL database

·        The system should allow reports to be produced

Responsibilities included:

§        Processing of Flat data files with more than 100 attributes

§        Initial data check and file transfer to input area using unix shell script

§        Data transformation from source to warehouse area

§        Data Transformation from warehouse to mart (Informatica  & Unix)

§        Business Objects reporting

The system also involves processing of the complex calculations given by Inland Revenue statisticians with the help of ETL tool.

Project Background

The goal of Employer Compliance is to ensure that Employers meet their obligations of running PAYE schemes correctly and that relevant returns are submitted on time and contain accurate information, and to take appropriate action when these obligations are not met. The Employer Compliance System (ECS) is used to capture Employer Compliance information and to manage the Employer Compliance activity.

Some subject areas that have been covered in the system are listed below.

·        P35 returns

·        P11D returns

·        P11D(b) returns

·        Penalties

·        Appeals

·        Directors Remuneration

·        Employer characteristics

·        PAYE Settlement Agreements (PSA)

·        Dispensations

·        Contractors

·        Compliance Reviews

Responsibilities included:

§        Processing of 7 years worth cutover historical data sent in 64 flat files

§        Processing of 64 flat files incremental data on daily basis 

§        Data transformation from source to warehouse area to mart area

§        Business Objects reporting

The system has more than 19 BO universes based on different data marts designed for each subject area.

Project Background

Asset Share for a policy is a measure of the underlying value of a policy with profits elements. Asset share calculations are required primarily for (a) Solvency Reporting, and (b) PPFM reporting. PPFM (Principles and Practises for Financial Management) is a statement that Norwich Union is required to publish detailing how with profits business will be managed. As per new government regulations, companies need to ensure that with-profits business is managed fairly for policyholders and that companies are following their published Principles and Practices of Financial Management (PPFM). Asset share methodology and information are key to being able to demonstrate this.

Responsibilities included:

 § Processing of context data and Asset share data

§        Data transformation from Source System to Staging area

§        Data Transformation from Staging to data warehouse (Informatica  & Unix)
(Policy ON/OFF Fact and Dimension data loading)     (Oracle database)

§        Policy Aggregation using Aggregate Facts (Informatica  & Oracle Stored Procedure)

§        Error processing

§        Business Objects reporting

§        Delivery of the Proof of Concept using Informatica PC 6.1 on Oracle 9i to process over 20 million rows per hour of complex financial transformations.

§        Working closely with business users and technical teams in a customer facing role to bring together requirements into a cohesive design whilst keeping focus on stringent timescales and external regulations.

§        Detailed design of the Informatica mappings and HUB structures to facilitate parallel ETL processes. This was done using Oracle and Informatica Partitioning technology.

§        Development of Informatica Powercenter mapping components whilst acting as the key design authority for a HUB development team.

§        Hub design and development comprised:

-         Integration of over 30 disparate source systems on varying legacy mainframe and proprietary application systems such as VSAM, Cobol, DB2, Oracle Applications.

Client Requirement and system analysis
Creation of designed document
To ensure successful execution of all phases of the project
 (Coding, Unit testing, Implementation, UAT support, Migration to Production)

To study of Business end user requirements
To study existing source systems
To create logical dimension data model
To create solution architecture document
To estimate efforts for DWH solution

To prepare the proposal
Client requirement and system analysis
Creation of requirement document(Defining BO reports )
Creation of solution architecture document
Creation of preliminary Design document
Creation of efforts estimation plan

To customize OneView system
(Mappings/Sessions/Unix Shell script/Database objects)
To create BO universe for OID
To create Discount and Backlog BO reports

Client requirement and system analysis
Creation of designed document
To ensure successful execution of all phases of the project
(Coding, Testing, Implementation, UAT, Migration to Production)

·        Creation of designed document objects)

·        Unit testing

·        Communications with Client

·        Client Requirement and system analysis

·        Creation of designed document

·        Coding (Mappings/Sessions/Database objects)

·        Unit testing

·        Client Requirement and system analysis

·        Creation of designed document

·        Monitoring of the complete OneView project

-         Data Extraction(from the PRIME Oracle ERP Application using SQL scripts daily)

-         Data Loading (into relevant tables in the PRIME ODS database on daily basis. 

-         ODS Database (The PRIME ODS database is the data repository.  It contains both current and historical transactional data.  )

-         Front-end Reporting (Using BO)

-         The Application is hosted on a Sun Solaris server. Motorola has an intermediate Staging database on Oracle RDBMS.

·        Client Requirement and system analysis

·        Database tuning

·        Coding, testing and implementation

This is a windows application designed for driving theory-test in UK.
This user friendly application environment allows users to practice theory test and hazard perception clips.

Click www.pass-test.co.uk 

-         To Create COM VB DLL which would contain Report conversion, FTP, error handling and Email modules.

-         To create Report converter and FTP Exes

-         To Schedule these Exes using NT scheduler

·        Client Requirement and system analysis

·        Creation of designed document

·        To ensure successful execution of all phases of the project

       (Coding,Testing,Implementation,UAT, Migration to Production)

·        Project management Activities and client communications

·        Coding and implementation of functionality

·        Testing (unit, integration and random)

§        Security and access

§        Maintenance of reference information

§        Personal Training Record

§        Archiving

§        Reports

-         The scrambling and unscrambling procedures for database access had to be removed and replaced with Oracle stored procedures

-         Converted Oracle 7 objects (OO40 version7.1) into Oracle 8 objects. (OO40 version 8)

-         Used resource files for messages

-         Created Install Set through Install Shield Express

·        Requirement and estimation studies

·        The scrambling and unscrambling procedures for database access has to be removed and replaced with stored procedures

·        Convert Oracle 7 objects into Oracle 8 objects.

·        Use resource files for messages

·        Create Install Set through Express Install Shield

-         Machine DBF processing.

-         Leave application processing

-         Early Late processing

-         Over Time processing