Jay Parmar
Lead Oracle Business Intelligence Consultant at Veracity Consulting- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Ky Crout
I have known Jay for many years, and worked with him on several large global CRM implementations (C&W, IBM, Reuters and GAM). In each of those projects, Jay played a pivotal role, and contributed to the ultimate success of each release/roll-out. Jay is a rare breed that is able to occupy both functional and technical roles, but very definitely is a leading authority in the OBIEE and general reporting space. Jay's calm and professional demeanour ensures he integrates well within his team and is able to strike up solid relationships with stakeholders. It is without hesitation that I would recommend Jay.
Jon Ireson
Jay was part of our development team at Christies, very proficient at building complex reports for a high profile investment programme based around Siebel Technology. He was a reliable, knowledgeable and hard working member of the team who I would work with again.
Ky Crout
I have known Jay for many years, and worked with him on several large global CRM implementations (C&W, IBM, Reuters and GAM). In each of those projects, Jay played a pivotal role, and contributed to the ultimate success of each release/roll-out. Jay is a rare breed that is able to occupy both functional and technical roles, but very definitely is a leading authority in the OBIEE and general reporting space. Jay's calm and professional demeanour ensures he integrates well within his team and is able to strike up solid relationships with stakeholders. It is without hesitation that I would recommend Jay.
Jon Ireson
Jay was part of our development team at Christies, very proficient at building complex reports for a high profile investment programme based around Siebel Technology. He was a reliable, knowledgeable and hard working member of the team who I would work with again.
Ky Crout
I have known Jay for many years, and worked with him on several large global CRM implementations (C&W, IBM, Reuters and GAM). In each of those projects, Jay played a pivotal role, and contributed to the ultimate success of each release/roll-out. Jay is a rare breed that is able to occupy both functional and technical roles, but very definitely is a leading authority in the OBIEE and general reporting space. Jay's calm and professional demeanour ensures he integrates well within his team and is able to strike up solid relationships with stakeholders. It is without hesitation that I would recommend Jay.
Jon Ireson
Jay was part of our development team at Christies, very proficient at building complex reports for a high profile investment programme based around Siebel Technology. He was a reliable, knowledgeable and hard working member of the team who I would work with again.
Ky Crout
I have known Jay for many years, and worked with him on several large global CRM implementations (C&W, IBM, Reuters and GAM). In each of those projects, Jay played a pivotal role, and contributed to the ultimate success of each release/roll-out. Jay is a rare breed that is able to occupy both functional and technical roles, but very definitely is a leading authority in the OBIEE and general reporting space. Jay's calm and professional demeanour ensures he integrates well within his team and is able to strike up solid relationships with stakeholders. It is without hesitation that I would recommend Jay.
Jon Ireson
Jay was part of our development team at Christies, very proficient at building complex reports for a high profile investment programme based around Siebel Technology. He was a reliable, knowledgeable and hard working member of the team who I would work with again.
Experience
-
Veracity Consulting
-
United Kingdom
-
Business Consulting and Services
-
1 - 100 Employee
-
Lead Oracle Business Intelligence Consultant
-
Sep 2019 - Present
-
-
-
Association of International Certified Professional Accountants
-
United States
-
Accounting
-
400 - 500 Employee
-
BI Technical Manager
-
Jan 2017 - Sep 2019
-
-
-
CIMA
-
United Kingdom
-
Accounting
-
400 - 500 Employee
-
Oracle BI Technical Lead
-
Nov 2013 - Dec 2016
CIMA's strategic decision to purchase Oracle ERP Fusion Cloud system - Oracle Finance Cloud (OFC) Planning Budgeting Cloud Service (PBCS) and Procurement. Allowed me to gain new skills. CIMA won the 2016 Oracle Cloud Platform Innovation Award for Cloud Integration• I successfully migrated Supplier data into Oracle ERP Cloud R11 from CIMA’s legacy ERP system• Customised Data Models and built new RTF templates for BI Publisher Reporting• Produced the first BI Publisher Report that integrated Siebel CRM with OFC• Assisted in the Data loading into the PBCS system. Used SmartView tool for Dimensional Data• Produced the BACS and SEPA Payment Processing file using BI Publisher • Provided Administration, Support and Training in all aspects of the Supplier moduleCIMA’s OBIEE systems were based on OBIEE Analytics 11g with Oracle 11g and an Exalytics machine with a TimesTen in memory database. Informatica PowerCenter V 9.5.1 and DAC V 11.1.1.6 were used for ETLs• Designed, Developed, Supported, Deployed OBIEE repositories (RPDs) and ETL• Performed BI RPD changes using the Oracle BI Admin Tool V 11.1.1.7 for both OBIEE system versions• Used Oracle Enterprise Manager and Weblogic mainly for RPD deployment, instance configuration, secu-rity model, java bean and export related changes• Built new and enhanced ETL mappings and workflows using Informatica and TOAD, most recent being CIMA Exam and Qualification KPI’s and Slowly Changing Dimension tables• Used Oracle DAC to create custom ETL execution plans, Tasks, Table changes. OLTP was Siebel CRM• Debugged Informatica mappings• Created BI Publisher customised RTF templates using new data models based on customised connections and logical SQL generated by OBIEE• Diagnosed and carried out root cause analysis on production systems such as timeouts, caching, odbc errors and blacklisted connection pools. • Developed, deployed and supported Siebel BI Publisher Reports
-
-
Siebel Analyst/Development Specialist
-
Jul 2012 - Nov 2013
The CIMA CRM system was based on Siebel V8 Call Center running against an Oracle 11 Database• Converted all Actuate reports to Oracle BI Publisher reports as part of the Siebel Upgrade• Introduced new Siebel Data Validation techniques and automated the refunds process with Cybersource• Integrated systems into the CIMA CRM Siebel system using Siebel Enterprise Application Integration (EAI)• Configured Siebel using Siebel 8 tools and performed 3rd line support of the CIMA CRM system• Trained new members of the team
-
-
-
-
Siebel & BI Publisher Development Specialist
-
Sep 2011 - Feb 2012
-
-
-
GAM Investments
-
Switzerland
-
Financial Services
-
700 & Above Employee
-
Siebel Consultant
-
Mar 2010 - Jul 2011
-
-
-
Ricoh UK
-
United Kingdom
-
IT Services and IT Consulting
-
700 & Above Employee
-
Functional Consultant
-
Oct 2009 - Mar 2010
-
-
-
GAM Investments
-
Switzerland
-
Financial Services
-
700 & Above Employee
-
Siebel Consultant
-
Nov 2005 - Dec 2008
-
-
-
Christie's
-
United Kingdom
-
Retail Luxury Goods and Jewelry
-
700 & Above Employee
-
Siebel Consultant
-
2005 - 2005
-
-
-
Thomson Reuters
-
Canada
-
Software Development
-
700 & Above Employee
-
Siebel Consultant
-
2002 - 2005
-
-
-
-
Siebel Consultant
-
2000 - 2002
-
-
-
IBM
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Siebel Consultant
-
1998 - 2000
-
-
-
-
Programmer
-
1996 - 1998
-
-
Education
-
University of Hertfordshire
BSC (Hons), Computer Science