Dataware House Projects
|
Project |
Technology Used |
|
Motorola eServicing
|
Informatica, Oracle Apps ,Business Objects and legacy source systems, Unix |
|
OneView Off invoice Discount
|
Oracle 8i,Infomatica Applications, Business Objects ,Oracle Apps 11.0.3,Unix |
|
OneView ROAM Mx |
Oracle 8i,Infomatica Applications, Oracle Apps 11.0.3,Unix |
|
OneView PHS |
Oracle 8i,Infomatica Applications,i2 DP, Unix |
|
Informatica OneView |
Oracle 8i,Infomatica Applications eCRM, Unix, Business Objects |
|
OneView Production |
Oracle 8i, Business Objects, Infomatica Applications, Oracle Apps 11.0.3,Unix |
|
Wiser Application |
Oracle 8i,Oracle Apps 11.0.3,Unix |
Motorola eServicing
Client MOTOROLA, Global
Platform Oracle 9i, Infomatica , Business Objects Customized Apps (MClaims,ACE
etc.) Unix.
Project Objectives
To do the requirement and feasibility study for designing data warehouse
solution of servicing and quality data of Motorola
Application Scope
To study of Business end user requirements
To study existing source systems
To create logical dimension data model
To estimate efforts for DWH solution
Responsibilities
• To prepare the proposal
• Client Requirement and system analysis
• Creation of requirement document(Defining BO reports )
• Creation of preliminary Design document
• Creation of efforts estimation plan
|
OneView Off invoice Discount
Client MOTOROLA, Global
Platform Oracle 8i,Infomatica, Business Objects, Oracle Apps
11.0.3(OE,AP,AR,GL),Unix
Project Objectives
To design system for effective analysis and tracking of off invoice discount
for Asia, EMEA,NA and LA.
Application Scope
To customize OneView system (Mappings/Sessions/Unix Shell script/Database
objects)
To Create BO universe for OID
To create Discount and Backlog BO reports
Responsibilities
• 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) |
Receivable Order management Administration System for
Mexico
(OneView ROAM Mx)
Client MOTOROLA, Global
Platform Oracle 8i,Infomatica Applications, Oracle Apps 11.0.3,Unix
Project Objectives
PCS is implementing an integrated ERP business solution that aims to
consolidate several legacy systems and processes. The ROAM NA project is
going to implement Oracle (version 11.03) to capture order and financial
data for US, Mexico, and Canada in one Oracle instance. It will replace the
Order entry and account receivable functions in the legacy systems (i.e.
TCOPS, CANCOPS, GPOE/GPAR, FocusP). TCOPS will remain as the distribution
system for NA and will support packing /shipping functions. Oracle OE will
capture whole sales order, book and send order data to Distribution. The
distribution system(s) will feed Oracle OE the shipment confirmation data
when the order has been fulfilled.
Application Scope
As part of this project new extracts were developed in OneVIEW to extract
the Order, Shipping and invoicing information from ROAM and hierarchy
information from i2 and load it into OneVIEW. Sessions stored in the
Informatica Power Center, execute daily to extract data and insert this data
into the staging database. Informatica then transform this data and load
into the final data warehouse tables.The scope of this project includes
modification in existing Mappings/Mapplet, creation of new Mappings/Mapplets,
changes in Data Model for OneView, creation of parameter file etc.
Responsibilities
• Creation of designed document
• Coding (Mappings/Sessions/Database objects)
• Unit testing
• Communications with Client |
Product Hierarchy Standardization (PHS)
Client MOTOROLA, Global
Platform Oracle 8i,Infomatica Applications, Oracle Apps 11.0.3,Unix
Project Objectives
The document details the modifications to OneVIEW due to changes I2 DP
staging database. This design is mainly concentrated around Configuration
for i2 – Global - Rel2 of OneVIEW. This document also gives detail about
historical fix. It details the different OneVIEW objects (Mapplets/Mappings/Sessions/Tables)
that must be modified in order to incorporate new format of I2 DP.
Application Scope
The scope of this project includes modification in existing Mappings/Mapplet,
creation of new Mappings/Mapplets, changes in Data Model for OneView
Responsibilities
• Client Requirement and system analysis
• Creation of designed document
• Coding (Mappings/Sessions/Database objects)
• Unit testing
• Communications with Client |
Informatica OneView
Client MOTOROLA, Global
Platform Oracle 8i,Infomatica Applications, Business Objects, Oracle Apps
11.0.3,Unix
Project Objectives
The objective of this project is to consolidate different regions NA, LA, EMEA, ASIA into one global repository. This project also includes
customization of Informatica applications for Asia specific region in order
to incorporate new requirements specific to Motorola region.
Application Scope
The scope of this project includes modification in existing Mappings/Mapplet,
creation of new Mappings/Mapplets, changes in Data Model for eCRM,
eProcurement, eBizOps, creation of eCRM BO universe and BO reports
Responsibilities
• Client Requirement and system analysis
• Creation of designed document
• Monitoring of the complete OneView project
|
OneView Production
Support
Client MOTOROLA, Global
Platform Oracle 8i PL/SQL, Informatica 5i,6i,Business Objects, Unix
Project Objectives
The objective of this project is to provide 24 * 7 production support to
OneView application. Activities involved of production support team are
• To monitor sessions continuously and take necessary action on failed
sessions.
• To Check data completeness and data Quality on daily basis
• To execute small change request
• To inform the status of data loading to the Managements
• To execute Adhoc change requests asked by Business end users.
• To create/run adhoc BO reports
• Performance tuning (Mapping/Session/Bo Reports) |
WISER Application
Client MOTOROLA, Singapore
Platform Oracle 8i PL/SQL,Oracle Apps 11.0.3,Unix
Project Objectives
The objective of this project is to provide Support and Enhancement services
for WISER Extraction and Loading of data from offshore to carry out work
assigned by the customer for applications hosted on their various servers as
given in the list below.
Application Scope
The scope of this project could be broadly divided as follows:
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.
Responsibilities
• Client Requirement and system analysis
• Database tuning
• Coding, testing and implementation
|
Client/Server Projects
|
Project |
Technology Used |
|
Report Conversion Application |
Visual Basic 6.0 |
|
TRS –IV Enhancement and Excel Report
Utility |
VB 6.0, Oracle8i, Excel, OO40,
Windows NT |
|
UPM (United Pig Marketing) Web project |
ASP, VBScript, HTML, XML/XSL, SQL
Server 7.0,,java Script, OLAP |
|
NMR-Impelpro/Movement, U.K |
VB 5.0, MsAccess-97, Crystal Report
6.5,Windows 95/98/NT |
|
NMR-Training Record System (NMR-TRS),
U.K |
VB 6.0, Oracle8, OO40, Windows NT |
|
Time Industries- Attendance system |
(Oracle 8.0 /Access 97) with Visual
Basic-5.0/6.0 |
|
Report Conversion
Application
Client MOTOROLA, Singapore
Platform Visual basic 6.0
Project Objectives
To design Report conversion and FTP application
Application Scope
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
Responsibilities
• 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)
|
|
TRS –IV Enhancement and Excel Report
Utility
Client NMR-Training Record System (NMR-TRS), U.K
Duration 2 Months, July 2001 to Aug 2001
Platform VB 6.0, Oracle8i, Excel, OO40, Windows NT
In this project, some more functionality related features are implemented in
TRS product.
For more details about TRS, please refer to page TRS.
Also small utility is designed to export the data into the Excel file.
|
|
UPM(United Pig Marketing) Web project
Client NMR-Software Solutions (NMR SS), U.K
Platform ASP, VBScript, HTML, XML/XSL, SQL Server 7.0,java Script
This project is basically automates all manual transactions of pig market in
UK.
It also provides interface for historical pig kill data.
XML data feed utility is also designed to process historical pig kill data
XML file on FTP site, which then updates historical Pig kill database. The
VB Exe created is scheduled using SQL Server Schedule task so as to pick up
XML files uploaded by different UPM companies on the FTP site.
This utility has been designed using VB 6.0,SQL Server 7.0, XML, SQL Server
Schedule task.
|
|
Herd Management System
Client NMR-Impelpro/Movement, U.K
Platform VB 5.0, MsAccess-97, Crystal Report 6.5,Windows 95/98/NT
ImpelPRO software is designed and developed by National Milk Recording
Software Solutions, UK (Hereafter NMR). Currently PCS is doing enhancements
in the product (Movement, Milk yield)
ImpelPRO, a product developed for the Ministry of Agricultural Farm &
Fisheries (MAFF) United Kingdom (UK), is a herd management package that
allows farmers to run their herds and is designed to be a planning and
forecasting tool. The impelPRO architecture is implemented as Shell and
Addins. An Addin represents a module The impelPRO architecture has been
designed so as to integrate new addins (i.e. modules) without recompiling
the shell. The existing system has 3 Addins called Dairy, Animal enrolment
and Milk Prediction. A new Addin called Movement was implemented by the
current project. The Movement module facilitates moving an animal between
holdings and herds. The special feature incorporated into the existing
system by the Movement Addin was to send mails to BCMS (British cattle
movement Service), MAFF (Ministry Of Agriculture Farm and Fisheries) and to
HUKI (Holstein Friesian Society)
The responsibilities included were:
• Project management Activities and client communications.
• Coding and implementation of functionality
• Testing (unit, integration and random)
|
|
Training Recording System
Client NMR-Training Record System (NMR-TRS), U.K
Platform VB 6.0, Oracle8 PL/SQL, OO40, Windows NT
This system has been developed to manage the staff training needs and
assessment of competencies for all staff at Huntington UK sites, and across
all disciplines, to ensure compliance with regulatory and client
requirements. The five major areas of functionality were:
• Security and access
• Maintenance of reference information
• Personal Training Record
• Archiving
• Reports
The scope of the project was as follows:
• 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
Responsibilities included:
• 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
|
|
Attendance System
Client Time Industries- Attendance system
Platform (Oracle 8.0 /Access 97) with Visual Basic-5.0/6.0
This system processes machine data that comes from Punch card machine (RAC
900).
It is basically customized Time and Attendance recording System.
The System consists of following Events.
• Machine DBF processing.
• Leave application processing
• Early Late processing
• Over Time processing
• Payroll input table
His responsibilities included:
• Client Requirement and system analysis
• Database design and forms design
• Coding, testing and implementation
|