. Primetech Systems Inc.
Skip Navigation Links
Home
About Us
Career
Perspectives
Sitemap
Contact Us
PrimeVerify
 

Ø  PrimeVerify

Ø  Primetech Systems has identified a need to build automated tie-out reports to assist in the verification of CTRM data between Production and the parallel test of the CTRM upgrade / implentation project.

Ø  The process involves the following steps:

o   Create and run Aligne (or similar ETRM systems) reports to generate ZTables containing the transactional and market data sets

o   Write Oracle SQL Queries against the two sets of tables to generate differences and exceptions.

o   Clone or modify these sets of queries to implement the needs of Front, Mid and Back offices

o   Modify reports/ queries to add/ remove attributes in the comparison results as needed

o   Write routines to compile all exceptions from various reports into a more presentable flavor of the report

o   Set up many share locations to copy the result files

o   Send emails to appropriate business owners for their approval/ denial of acceptable differences

Ø  These are a few of the many tasks that are performed by the Technical resources on a frequent basis. The processes are very tedious and time consuming and also prone to accidental over-writes and other un-intended errors

Ø  PrimeVerify tool will not only help build the queries on the fly but also perform verifications at all levels of aggregation. Also, this tool will provide the ability to generate automated emails and send it to respective recipients as appropriate. The tool will also empower the business users to generate comparison results at different levels of granularity, provide the ability to add or remove attributes and generate the computed results in different file formats like Excel, CSV, XML, PDF or Data-Cube as needed

 

 

Skip Navigation Links
Home
ServicesExpand Services
SolutionsExpand Solutions
Case StudiesExpand Case Studies
Client Space
Employee Space
Company Profile
BlogExpand Blog
 
 
Login
 User Id
 
 Password
 
60 Abele Road, Suite 1105, Bridgeville, PA 15017 ***Phone: 866-678-7600/412-221-7600 ***Fax: 412-221-7642
Primetech,Primetech Systems Inc.,Consulting,IT Consulting,Management Consulting, Application Integration, Custom Development, IT Outsourcing, CRM, SCM, Peoplesoft, SAP, Datawarehouse, Oracle, SQLServer, Sybase, .Net, Java, J2EE, Active Directory Service, Application Servers, BPO, Outsourcing, Consulting, Staff Augmentation, Energy Technology, Ebusiness, Energy,FASB, FASB 133, FASB133, Hedge Effectiveness, Energy Trading, Zai*Net, CAMINUS, PrimeFAS, Prime FAS, Risk Management,HIPAA Implementation,Wireless Technology, Primetech,Primetech Systems Inc.,Consulting,IT Consulting,Management Consulting, Application Integration, Custom Development, IT Outsourcing, CRM, SCM, Peoplesoft, SAP, Datawarehouse, Oracle, SQLServer, Sybase, .Net, Java, J2EE, Active Directory Service, Application Servers, BPO, Outsourcing, Consulting, Staff Augmentation, Energy Technology, Ebusiness, Energy,FASB, FASB 133, FASB133, Hedge Effectiveness, Energy Trading, Zai*Net, CAMINUS, PrimeFAS, Prime FAS, Risk Management,HIPAA Implementation,Wireless Technology, Primetech,Primetech Systems Inc.,Consulting,IT Consulting,Management Consulting, Application Integration, Custom Development, IT Outsourcing, CRM, SCM, Peoplesoft, SAP, Datawarehouse, Oracle, SQLServer, Sybase, .Net, Java, J2EE, Active Directory Service, Application Servers, BPO, Outsourcing, Consulting, Staff Augmentation, Energy Technology, Ebusiness, Energy,FASB, FASB 133, FASB133, Hedge Effectiveness, Energy Trading, Zai*Net, CAMINUS, PrimeFAS, Prime FAS, Risk Management,HIPAA Implementation,Wireless Technology, Primetech,Primetech Systems Inc.,Consulting,IT Consulting,Management Consulting, Application Integration, Custom Development, IT Outsourcing, CRM, SCM, Peoplesoft, SAP, Datawarehouse, Oracle, SQLServer, Sybase, .Net, Java, J2EE, Active Directory Service, Application Servers, BPO, Outsourcing, Consulting, Staff Augmentation, Energy Technology, Ebusiness, Energy,FASB, FASB 133, FASB133, Hedge Effectiveness, Energy Trading, Zai*Net, CAMINUS, PrimeFAS, Prime FAS, Risk Management,HIPAA Implementation,Wireless Technology, Primetech,Primetech Systems Inc.,Consulting,IT Consulting,Management Consulting, Application Integration, Custom Development, IT Outsourcing, CRM, SCM, Peoplesoft, SAP, Datawarehouse, Oracle, SQLServer, Sybase, .Net, Java, J2EE, Active Directory Service, Application Servers, BPO, Outsourcing, Consulting, Staff Augmentation, Energy Technology, Ebusiness, Energy,FASB, FASB 133, FASB133, Hedge Effectiveness, Energy Trading, Zai*Net, CAMINUS, PrimeFAS, Prime FAS, Risk Management,HIPAA Implementation,Wireless Technology