-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `components` text,
  `icon` varchar(255) DEFAULT NULL,
  `smallicon` varchar(255) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `access_level` smallint(6) DEFAULT '3',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` VALUES (1,'Projects','projects','add|edit|delete','projects.png','icon-paste',100,3),(2,'Staff','staff','add|edit|delete','staff.png','icon-group',400,3),(3,'Associates','associates','add|edit|delete','associates.png','icon-group',500,3),(4,'Categories','categories','add|edit|delete','categories.png','icon-th-large',600,3),(5,'Organizations','organizations','add|edit|delete','organization.png','icon-globe',700,3),(6,'Users','users','add|edit|delete|status_change','users.png','icon-user',800,2),(7,'Activity Log','activity_log','','logs.png','icon-cog',900,3),(8,'Dacons / Quals Merge','dacons_quals','','dqexport.png','icon-copy',200,3),(9,'CV Export','cv',NULL,'cvexport.png','icon-copy',300,3),(10,'Company Settings','company_settings',NULL,'company.png','icon-th-large',950,1),(11,'Document Templates','doc_templates','create|edit|delete|allow','doc_templates.png','icon-copy',850,3),(12,'Company Backup','company_backup',NULL,'backup.png','icon-folder-close',960,3),(13,'Exported Files','exported_files',NULL,'exported_files.png','icon-th-large',970,3),(14,'Bios','bios',NULL,'bios.png','icon-th-large',450,3);

--
-- Table structure for table `organization_contacts`
--

CREATE TABLE `organization_contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `org_id` int(10) unsigned DEFAULT NULL,
  `street1` varchar(100) DEFAULT NULL,
  `street2` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organization_contacts`
--

INSERT INTO `organization_contacts` VALUES (1,1,'PO Box 30577','','Nairobi','','100','Kenya'),(3,3,'3rd Floor, Building 13','The Woodlands, Woodland Drive, Woodmead','Gauteng','','','South Africa'),(5,4,'2000 L Street, NW','Suite 605','Washington D.C.','','20036','USA'),(8,5,'875 Fifteenth Street, NW','','Washington D.C.','','20005-2221','USA'),(14,8,'1300 Pennsylvania Avenue, NW','','Washington D.C.','','20523','USA'),(15,9,'Effingerstrasse 31','CH-3003','Bern','','','Switzerland'),(17,11,'9 G. Lusavorich','','Yerevan','','','Armenia'),(18,2,'1818 H Street, NW','','Washington D.C.','','20433','USA'),(20,6,'MCS Plaza Building','4 Seoul Street','Ulaanbaatar','','','Mongolia'),(23,12,'BP 323','1002 Tunis Belvedere','','','','Tunisia'),(24,6,'6 ADB Ave.','','Mandaluyong City','','1550','Philippines'),(26,6,'Level 18','1 Margaret Street','Sydney','NSW','2000','Australia'),(27,14,'1/32 Proshyan Street','','Yerevan','','19','Armenia'),(28,2,'9 Grigor Lousavorich Street','','Yerevan','','15','Armenia'),(32,6,'Ulaanbaatar','','','','',''),(33,2,'Bolshaya Molchanovka, 36 Build. 1','','Moscow','','121069',''),(34,4,'2000 L Street, NW, Suite 605','','Washington DC','','20036','Russian Federation'),(35,1,'1818 H Street, NW','','Washington DC','','20433','USA'),(36,4,'NEDO, 2000 L Street, NW, Suite 605','','Washington DC','','20036','USA'),(37,8,'U.S. Agency for International Development 1300 Pennsylvania Avenue, NW ','','Washington DC ','','20523',''),(38,9,'SECO, Effingerstrasse 31, CH-3003','','Bern','','','Switzerland'),(39,16,'6 ADB Ave.','','Mandaluyong City','','1550','Philippines'),(40,6,'Mongolia Resident Mission, MCS Plaza, 2nd Floor','Seoul Street-4 P.O. Box 1083 Central Post Office','Ulaanbaatar','','210613','Mongolia'),(41,2,'','','Tashkent','','','Uzbekistan'),(42,15,'8618 Westwood Center Drive Suite 220','','Vienna','','VA 22182',''),(43,14,'Proshyan 1st lane, 32 apt., RA','','Yerevan','','',''),(44,13,'Mr. J.Bat-Erdene, State Secretary, Ministry of Road, Transportation, Construction','','','','',''),(45,6,'1 A. Khodjaev Street 100027','','','','',''),(46,4,'MUZA Kawasaki Central Tower 1310 Omiya-cho, Saiwai-ku, Kawasaki','','Kanagawa','','212-8554','Japan'),(47,6,'25 Main Street','','Northampton','MA','1060','USA'),(48,6,'53 maple street','','','','',''),(49,41,'Victoria Park Suites, 3rd Floor, 14 - 17 Victoria Square North','','Port of Spain','','','Trinidad and Tobago'),(50,42,'PMB 9067','','Port Vila','','','Vanuatu'),(51,11,'Testing','','Testing 2','','','Algeria'),(52,43,'Testin 14','','Testing sep 11, 14','','','Aland Islands'),(53,44,'1818 H Street, NW','','Washington','D.C.','20433','United States'),(54,6,'ADB Building, Rua Alferes Duarte Arbiro','Farol','Dili','','','Timor-Leste');

--
-- Table structure for table `organization_members`
--

CREATE TABLE `organization_members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `org_id` int(10) unsigned DEFAULT NULL,
  `member_name` varchar(100) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `position` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organization_members`
--

INSERT INTO `organization_members` VALUES (1,1,'Patrick Mwangi','','+(254) 20 322 6323','pmwangi2@worldbank.org',''),(2,2,'Mohinder Gulati','','','',''),(4,2,'Gevorg Sargsyan','Climate Investment Funds','+1 202 458 1919','gsargsyan@worldbank.org','CTF and SREP Program'),(6,2,'Ani Balabanyan','','','',''),(8,5,'Anne Rothbaum','','+1 202 521-3600','rothbaumae@mcc.gov',''),(9,2,'Peter Johansen','','','',''),(10,6,'Shane Rosenthal','','+976 11 313440','',''),(11,2,'Kyran OSullivan','','','',''),(17,11,'Tigran Parvanyan','','','',''),(18,2,'Edon Vrenezi','','','',''),(19,17,'Carolyn Berry','','','',''),(20,6,'Teruhisa Oi','','','',''),(21,6,'Jeremy Cleaver','','','',''),(23,12,'J. H. Gandhi','African Development Institute','','0','Editor'),(24,6,'Januar Laude','East Asia Department','','',''),(25,2,'Ashok Sarkar','Sustainable Energy Department','+1 (202) 473-1000','','Sr. Energy Specialis'),(26,6,'Milovan Lucic','','','','Senior Economics Off'),(27,2,'Arthur Kochnakyan','','','',''),(28,14,'Tamara Babayan','','+374 10 588 011','director@r2e2.am','Director'),(29,6,'Keiju Mitsuhashi','Energy Division, Central and West Asia Department','-5630','kmitsuhashi@adb.org','Energy Specialist'),(30,2,'Yadviga Semikolenova','ECSSD','+1 202 202 473-7631','ysemikolenova@worldbank.org','Energy Economist'),(95,6,'Arnaud Heckmann','Urban and Social Sectors Division, East Asia Department','','0','Urban Development Sp'),(96,2,'Junior McIntyre ','Caribbean Regional Communications Infrastructure Programs (CARCIP)','(868) 627-0281/0347','0','Project Coordinator'),(97,41,'Junior McIntyre','Caribbean Regional Communications Infrastructure Program (CARCIP) ','','0','Project Coordinator'),(98,2,'Claudia Vasquez','Europe and Central Asia Energy Unit','','0','Energy Specialist'),(99,42,'Mr. Jesse Benjamin','Department of Energy, Ministry of ','+678 25201','0','Director'),(100,11,'Simona Spassova','Advisory Services in Public-Private Partnerships - Europe and Central Asia ','+ 352 691 674 250 ','0','Specialist'),(101,43,'Testing sep 11 14 member','testing sep 11 ','','0','testing sep 11 '),(102,2,'Zara Tokhmakhian','?','','0','?'),(103,2,'Fan Zhang','Eastern Europe and Central Asia','','0','Senior Energy Econom'),(104,6,'Craig Sugden','Public Management, Financial Sector and Regional Cooperation Division','+632 632 6390/4069','0','Principal Public-Pri'),(105,2,'Liu Feng','The Energy and Extractives Global Practice ','','0','Senior Energy Specia'),(106,2,'Liu Feng','The Energy and Extractives Global Practice ','','0','Senior Energy Specia'),(107,2,'Liu Feng','The Energy and Extractives Global Practice ','','0','Senior Energy Specia'),(108,2,'Liu Feng','The Energy and Extractives Global Practice ','','0','Senior Energy Specia'),(109,55,'Tom Stevens','Resource Economics','','0','Professor'),(110,55,'Julie Caswell','Resource Economics','','0','Professor and  Assoc'),(111,2,'Rhedon Begolli','Europe and Central Asia','','0','Energy Sector Specia'),(112,2,'Stephanie Gil','Europe and Central Asia','','0','Senior Energy Expert'),(113,2,'Raymond Bourdeaux','Energy','','0','Lead Infrastructure '),(114,6,'Tianhua Luo','Energy Division, Central and West Asia Department','','0','Senior Energy Specia'),(115,2,'Zubair K M Sadeque','Energy and Extractives ','','0','Senior Energy Specia');

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `information` text,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` VALUES (1,1,'The World Bank (Water and Sanitation Program)',NULL,NULL),(2,1,'The World Bank',NULL,NULL),(3,1,'South African Presidency and Business Trust (SAPBT)',NULL,NULL),(4,1,'New Energy and Industrial Technology Organization of Japan (NEDO)',NULL,NULL),(5,1,'Millennium Challenge Corporation (MCC)',NULL,NULL),(6,1,'Asian Development Bank (ADB)',NULL,NULL),(7,1,'Public Services Regulatory Commission of Armenia (PSRC) and The World Bank',NULL,NULL),(8,1,'United States Agency for International Development (USAID)',NULL,NULL),(9,1,'State Secretariat for Economic Affairs (SECO)',NULL,NULL),(10,1,'CHUBU Electric Power Company; Tokyo Electric Power Company',NULL,NULL),(11,1,'International Finance Corporation (IFC)',NULL,NULL),(12,1,'African Development Bank (AfDB)',NULL,NULL),(13,1,'Ministry of Road, Transportation, Construction and Urban Development, Mongolia',NULL,NULL),(14,1,'Armenia Renewable Resource and Energy Efficiency',NULL,NULL),(15,1,'Nancy Woronick IBTCI',NULL,NULL),(16,1,'Public Mgt. & Regional Cooperation Div. East Asia Department, Asian Development Bank Private Sector ',NULL,NULL),(17,1,'Carolyn Berry',NULL,NULL),(18,1,'Two Japanese electric utility companies',NULL,NULL),(19,1,'The Asian Development Bank (ADB)',NULL,NULL),(20,1,'Confidential Private Client',NULL,NULL),(21,1,'Other',NULL,NULL),(22,1,'Utilities Clients',NULL,NULL),(23,1,'National Renewable Energy Laboratory',NULL,NULL),(24,1,'California Renewable Energy Transmission Initiative',NULL,NULL),(25,1,'Haryana Electricity Regulatory Commission (HERC)',NULL,NULL),(26,1,'Federal Energy Regulatory Commission (FERC)',NULL,NULL),(27,1,'Agência Nacional de Energia Elétrica (ANEEL)',NULL,NULL),(28,1,'Andhra Pradesh Electricity Regulatory Commission (APERC)',NULL,NULL),(29,1,'SERC',NULL,NULL),(30,1,'The Japanese Government’s Energy R&D Entity',NULL,NULL),(31,1,'Japanese Ministry of Economy, Trade and Industry (METI)',NULL,NULL),(32,1,'Armenia’s Public Services Regulatory Commission (PSRC)',NULL,NULL),(33,1,'Pacific Gas & Electric (PG&E)',NULL,NULL),(34,1,'Gesellschaft für Technische Zusammenarbeit (GTZ)',NULL,NULL),(35,1,'Public Services Regulatory Commission (PSRC)',NULL,NULL),(36,1,'The World Bank Independent Evaluation Group (IEG)',NULL,NULL),(37,1,'Mastercard',NULL,NULL),(38,1,'Broad Peak Energy',NULL,NULL),(39,1,'Emergence Bioenergy',NULL,NULL),(40,1,'Citibank','',NULL),(41,1,'Caribbean Telecommunications Union (CTU)','Funded by the World Bank','2014-02-11 15:35:44'),(42,1,'Department of Energy, Ministry of Climate Change and Natural Disasters, Government of Vanuatu','','2014-04-28 17:01:57'),(43,1,'Testing sp 11, 14','','2014-09-11 10:34:58'),(44,4,'El Banco Mundial','','2015-01-07 16:19:13'),(45,1,'Vector Ltd','Type of Business	: Gas Utility Company\nCountry	: New Zealand\nStreet Address: 44 The Terrace\n\nWellington','2015-01-07 16:59:31'),(46,4,'Corporación Financiera Internacional (IFC)','','2015-01-07 17:07:40'),(47,1,'Commerce Commission of New Zealand','','2015-01-07 17:10:23'),(48,1,'Transpower NZ Ltd','Type of Business: Electricity Transmission Owner / Operator\nCountry: New Zealand\nStreet Address: 96 The Terrace, P. O. Box 1021','2015-01-07 17:13:44'),(49,1,'Electricity Authority','Type of Business: Independent Government Agency\nCountry: New Zealand\nStreet Address: Level 7, 3 Hunter St','2015-01-07 17:21:12'),(50,1,'Castalia Strategic Advisors','','2015-01-07 17:25:21'),(51,4,'Desarrollo del sector de la banca privada asiática, administración pública y departamento de coopera','','2015-01-07 17:31:05'),(52,4,'Ministerio de Carreteras, Transporte, Construcción y Desarrollo Urbano, Mongolia','','2015-01-07 17:35:21'),(53,4,'Recursos renovables y eficiencia energética de Armenia','','2015-01-07 17:44:39'),(54,4,'Banco Asiático de Desarrollo (ADB según sus siglas en inglés)','','2015-01-07 17:47:41'),(55,1,'University of Massachusetts Amherst','Department of Resource Economics','2015-03-10 18:32:11'),(56,1,'USDA Economic Research Service','','2015-03-10 18:49:54'),(57,1,'Department of Public Utilities','','2015-03-17 19:20:55');

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `project_name` text,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `contract_amount` double DEFAULT NULL,
  `contract_amount_currency` varchar(10) DEFAULT NULL,
  `approx_amount` double DEFAULT NULL,
  `approx_amount_currency` varchar(10) DEFAULT NULL,
  `total_staff_months` float(5,2) DEFAULT NULL,
  `total_staff_months_by_associates` float(5,2) DEFAULT NULL,
  `associates` text,
  `org_id` int(11) DEFAULT NULL,
  `org_members` text,
  `org_contacts` text,
  `address` varchar(255) DEFAULT NULL,
  `location_within_country` varchar(255) DEFAULT NULL,
  `countries` text,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (2,1,'P1208','Ulaanbaatar Urban Services and Ger Areas Development Investment Program','2012-07-02','2013-08-30',1000000,'USD',50000,'USD',1.50,40.00,'1,20',6,'95','24,32','Ulaanbaatar','Ulaanbaatar','148','2013-10-14 09:32:13'),(3,1,'P0806','Advice to South Africa\'s National Treasury on Institutional Reform of their PPP Unit','2007-01-01','2008-08-01',25200,'USD',25000,'USD',0.95,0.45,'1',3,NULL,'3','3rd Floor, Building 13, The Woodlands, Woodland Drive, Woodmead, Gauteng','National','206','2013-10-14 09:32:13'),(4,1,'P0701','Assesment of Opportunities for Energy Efficiency Investment in Russia','2007-04-01','2008-06-01',60000,'USD',60000,'USD',2.25,0.00,'',2,'4','33','Bolshaya Molchanovka, 36 Build. 1 121069 Moscow, Russian Federation','Moscow','183','2013-10-14 09:32:13'),(5,1,'P0704','Market Study of Cellulosic Ethanol Industry in the US','2007-11-01','2009-03-01',22885,'USD',22885,'USD',1.50,0.00,'2',4,NULL,'34','2000 L Street, NW, Suite 605, Washington DC, 20036 USA','','236','2013-10-14 09:32:13'),(6,1,'P0705','Assesment of Opportunities for Energy Efficiency Investment in Armenia','2008-02-01','2008-05-01',30000,'USD',23000,'USD',1.25,0.00,'',2,NULL,'18','1818 H Street, NW Washington DC, 20433, USA','Yerevan','12','2013-10-14 09:32:13'),(7,1,'P0807','Assessment of Infrastructure Needs and Financing Options in Mongolia\'s Gobi Desert Mining Region','2008-08-01','2009-01-01',130000,'USD',43000,'USD',3.64,1.73,'1',2,NULL,'18','1818 H Street, NW, Washington DC 20433','Ulaanbaatar and South Gobi Region','148','2013-10-14 09:32:13'),(8,1,'P0809','Evaluation of Millennium Challenge Corporation\'s Electricity Sector Investments in Tanzania','2008-10-01','2013-12-01',900000,'USD',60000,'USD',41.00,4.00,'5',5,NULL,'8','0','Dar Es Salaam','220','2013-10-14 09:32:13'),(9,1,'P0810','Capacity Building for the Ministry of Economy\'s Energy Department in Macedonia','2008-11-01','2009-12-01',25260,'USD',18000,'USD',0.75,0.75,'1',2,NULL,'18','0','Skopje','132','2013-10-14 09:32:13'),(10,1,'P0808','Reform of Public Urban Service Organizations in Mongolia','2008-12-01','2010-05-01',94000,'USD',94000,'USD',3.40,0.00,'1',6,'10','20','MCS Plaza Building, 4 Seoul Street, Ulaanbaatar, Mongolia','Ulaanbaatar','148','2013-10-14 09:32:13'),(11,1,'P0812','Options for Asset Transfer in the Reform of Kenya\'s Water and Sanitation Sector','2008-08-01','2009-04-01',64330,'USD',27000,'USD',2.00,0.75,'1',1,NULL,'35','1818 H St, NW, Washington, DC 20433','National','116','2013-10-14 09:32:13'),(12,1,'P0901','Market Study of Lithium Ion Batteries in the US','2009-02-01','2009-03-01',10000,'USD',10000,'USD',1.00,0.00,'2',4,NULL,'36','NEDO, 2000 L Street, NW, Suite 605, Washington DC 20036, USA','','236','2013-10-14 09:32:13'),(13,1,'P0904','Development of an Electricity Sector Investment Prospectus for Kenya','2009-02-01','2009-06-01',400000,'USD',50000,'USD',4.00,7.50,'1,6',2,NULL,'18','1818 H St NW, Washington, DC 20006','Nairobi','116','2013-10-14 09:32:13'),(14,1,'P0905','Market Study of the Smart Grid Industry in the US','2009-04-01','2009-05-01',12885,'USD',12885,'USD',0.50,0.00,'2',4,NULL,'36','NEDO, 2000 L Street, NW, Siute 605, Washington DC 20036, USA','Washington, DC','236,112','2013-10-14 09:32:13'),(16,1,'P0906','Design of Universal Services Fund in the Armenia Telecommunications Sector','2009-04-01','2009-10-01',80000,'USD',26200,'USD',2.80,1.60,'1,7,3',2,NULL,NULL,'','Yerevan','12','2013-10-14 09:32:13'),(17,1,'P0909','Capacity Building and Assessment of Reform Options for Water Service Providers in Mexico','2009-08-01','2010-12-01',42200,'USD',42200,'USD',2.67,0.00,'12',8,NULL,'37','U.S. Agency for International Development 1300 Pennsylvania Avenue, NW Washington, DC 20523','Mexico City and Torreon','144','2013-10-14 09:32:13'),(18,1,'P0912','Evaluation of SECO\'s Energy Sector funding to Eastern Europe and Central Asia','2009-09-01','2010-05-01',220891,'USD',149614,'USD',5.00,0.00,'',9,NULL,'38','0','NA','197,3,121,182','2013-10-14 09:32:13'),(19,1,'P0910','Development of an Energy Policy Note for the World Bank in Armenia','2009-09-01','2010-11-01',44400,'USD',44400,'USD',4.00,0.00,'',2,NULL,'18','1818 H Street NW, Washington DC, 20433, USA','Yerevan','12','2013-10-14 09:32:13'),(21,1,'P0917','Market Study of the US Smart Grid Industry for Japanese Utilities','2010-02-01','2010-03-01',14812,'USD',14812,'USD',1.00,0.00,'2',18,NULL,NULL,'','','236','2013-10-14 09:32:13'),(22,1,'P0918','Assessment of Potential for Private Sector Energy Efficiency Investment in Eastern Europe and Central Asia','2010-01-01','2010-04-01',9000,'USD',9000,'USD',1.00,1.00,'',11,NULL,'17','0','n/a','16,21,82,183,233','2013-10-14 09:32:13'),(23,1,'P0915','Assessment of the Impact of the Financial Crisis on the Energy Sector in Eastern Europe and Central Asia','2010-06-01','2010-11-01',48000,'USD',48000,'USD',1.55,0.00,NULL,2,NULL,'18','0','Yerevan, Armenia; Bishkek, Kyrgyz Republic; Bucharest, Romania; Belgrade, Serbia; Kiev, Ukraine','182,233,12,121','2013-10-14 09:32:13'),(24,1,'P1002','Advice on Financing and Procurement Modalities for Mongolia\'s Combined Heat and Power Plant ','2010-07-01','2010-11-01',75000,'USD',52624,'USD',2.00,0.00,'1',6,NULL,'20','0','Ulaanbaatar','148','2013-10-14 09:32:13'),(25,1,'P1008','Development of Utility Reform Options for Nauru\'s Electric and Water Utility','2010-11-01','2011-02-01',40500,'USD',27000,'USD',1.33,0.00,'',6,NULL,'20','MCS Plaza Bldg., 4 Seoul Street, Ulaanbaatar, Mongolia','National','155','2013-10-14 09:32:13'),(26,1,'P0913','Capacity Building for Mongolia\'s PPP Program and PPP Unit','2010-11-01','2013-09-30',78260,'USD',78260,'USD',2.00,0.00,'1,9,8,10',16,NULL,'39','6 ADB Avenue, Mandaluyong City 1550 Philippines, Tel: +63 2 632 4444, Fax: +63 2 636 2444','Ulaanbaatar','148','2013-10-14 09:32:13'),(27,1,'P1006','California Electricity Crisis Proceedings','2011-01-01','2012-02-01',200000,'USD',200000,'USD',6.00,0.00,'',17,NULL,'','Washington DC','California','236','2013-10-14 09:32:13'),(28,1,'P1103','Assessment of the Potential for Regional Power Trade in the Caucasus','2011-03-01','2011-11-01',25946,'USD',25946,'USD',2.00,0.00,'',2,NULL,'18','0','N/A','16,12,82','2013-10-14 09:32:13'),(29,1,'P1106','Support to Nepal\'s Town Development Fund in Appraising Loans to PPPs','2011-07-01','2012-03-01',104500,'USD',35200,'USD',12.00,10.00,'',6,NULL,'24','6 ADB Avenue, Mandaluyong City 1550, Metro Manila, Philippines','','156','2013-10-14 09:32:13'),(30,1,'P1107','Study on the Benefits of Building-Level Heat Metering in Ukraine','2011-07-01','2011-10-01',14900,'USD',14900,'USD',1.00,0.00,'',2,NULL,'18','1818 H Street, NW, Washington DC, 20433, USA','','233','2013-10-14 09:32:13'),(31,1,'P1109','PPP Training for the West African Power Pool','2011-09-01','2011-10-01',89800,'USD',7000,'USD',0.75,0.00,'15,1',12,NULL,'23','BP 323, 1002 Tunis Belvedere Tunisia, Tel: +216 71 10 22 95, Fax: 216 71 833 916, Email: J.Gandhi@afdb.org','','84','2013-10-14 09:32:13'),(32,1,'P1108','Reform Options for the Water and Sanitation Sector in Ulaanbaatar','2011-08-01','2011-10-01',52800,'USD',44000,'USD',1.00,0.00,'1',6,NULL,'40','Mongolia Resident Mission, MCS Plaza, 2nd Floor, Seoul Street-4 P.O. Box 1083 Central Post Office Ulaanbaatar 210613, Mongolia Tel +976 11 313440/323507/329836','Ulaanbaatar','148','2013-10-14 09:32:13'),(33,1,'P1101','Transaction Costs of Demand Side Energy Efficiency','2011-01-01','2011-11-01',19604,'USD',19604,'USD',0.75,0.00,'',2,NULL,'18','0','n/a','250','2013-10-14 09:32:13'),(34,1,'P1104','Assessment of Energy Supply Options for Kosovo','2011-05-16','2012-06-30',60000,'USD',60000,'USD',4.00,0.00,'',2,NULL,'18','0','NA','252','2013-10-14 09:32:13'),(35,1,'P1202','Corporatization and Commercialization of Nauru\'s Electric and Water Utility','2012-03-01','2012-08-01',74000,'USD',74000,'USD',2.00,0.00,'',6,NULL,'26','Level 18, 1 Margaret Street Sydney, NSW 2000, Australia','National','155','2013-10-14 09:32:13'),(36,1,'P1201','Development of Electricity Tariff and Subsidy Methodology for Armenia','2012-03-01','2012-12-01',82000,'USD',22800,'USD',2.00,0.00,'17,18',2,NULL,'18','1818 H Street, NW, Washington, DC 20433','Yerevan','12','2013-10-14 09:32:13'),(37,1,'P1203','Development of an Energy Strategy Note for Uzbekistan','2012-03-22','2012-05-01',27000,'USD',27000,'USD',3.00,0.00,'',2,NULL,'18,41','Tashkent, Uzbekistan','Tashkent','239','2013-10-14 09:32:13'),(38,1,'P1204','Evaluation of USAID\'s Municipal Heating Reform Project','2012-03-01','2012-07-01',32545,'USD',32545,'USD',1.60,0.00,'22,21',8,NULL,'14','8618 Westwood Center Drive Suite 220, Vienna, VA 22182','Countrywide','233','2013-10-14 09:32:13'),(39,1,'P1205','Updating the World Bank\'s Energy Sector Policy Note for Armenia','2012-05-16','2012-06-29',6900,'USD',6900,'USD',0.40,0.00,'',2,NULL,'18','1818 H Street, NW, Washington, DC 20433','','12','2013-10-14 09:32:13'),(40,1,'P1207','Economic and Financial Appraisal of the Potential Geothermal Power Plant at Karkar','2012-06-01','2012-09-01',44348,'USD',16200,'USD',3.00,1.00,'16',14,NULL,'43','Proshyan 1st lane, 32 apt., Yerevan, RA','','12','2013-10-14 09:32:13'),(42,1,'P1209','Transaction Advisory for Urban Services in South Gobi','2012-07-01','2013-07-01',520487,'USD',121060,'USD',25.00,5.00,'1',13,NULL,'44','Mr. J.Bat-Erdene, State Secretary, Ministry of Road, Transportation, Construction and','Southeast Gobi (Omnogovi and Dornogovi Aimags)','148','2013-10-14 09:32:13'),(43,1,'P1210','Inputs to ADB\'s Country Partnership Strategies for Armenia and Georgia','2012-07-05','2012-09-28',80100,'USD',80100,'USD',4.14,0.00,'',6,NULL,'24','0','N/A','12,82','2013-10-14 09:32:13'),(44,1,'P1212','Public Expenditure Review of the Kyrgyz Republic\'s Energy Sector','2012-11-01','2013-06-01',93898,'USD',93898,'USD',0.00,3.50,'17,18',2,NULL,'18','0','Bishkek','121','2013-10-14 09:32:13'),(45,1,'P1213','Developing a Prospectus for Readiness for Investment in Sustainable Energy (RISE)','2013-01-01','2013-04-01',50000,'USD',50000,'USD',4.00,0.00,'',2,'4','18','1818 H St NW, Washington, DC 20433, USA','','250','2013-10-14 09:32:13'),(46,1,'P0806','South Africa PPP Unit Institutional Options','2008-01-01','2008-06-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'0','Johannesburg','206','2013-10-14 09:32:13'),(47,1,'','Review of World Bank Energy Sector Assistance since Independence','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',36,NULL,NULL,'','','82','2013-10-14 09:32:13'),(48,1,'','Accelerating Public Private Partnerships (PPPs) in Infrastructure','2007-01-01','2008-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','206','2013-10-14 09:32:13'),(49,1,'','Reform of the Urban Water and Sanitation Sector','2007-01-01','2008-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','232','2013-10-14 09:32:13'),(50,1,'','Indonesian Risk Management Framework for PPPs','2006-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','104','2013-10-14 09:32:13'),(51,1,'','Private Sector Participation in Infrastructure','2006-01-01','2007-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','81','2013-10-14 09:32:13'),(52,1,'','Electricity Distribution Service Quality Standards','2006-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',35,NULL,NULL,'','','12','2013-10-14 09:32:13'),(53,1,'','Regulatory and Institutional Advisor to a Design?Build Lease Contract for the West Delta Irrigation Project','2006-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','66','2013-10-14 09:32:13'),(54,1,'','Survey and Analysis of Centralized Public Private Partnership (PPP) Units','2006-01-01','2007-01-01',0,'USD',0,'USD',0.00,0.00,'',2,NULL,NULL,'','Worldwide','250','2013-10-14 09:32:13'),(55,1,'','Tariff and Service Quality Guidelines for New Water and Sanitation Regulator','2006-01-01','1969-12-31',0,'USD',0,'USD',0.00,0.00,'',34,NULL,'','Nairobi','Nairobi','116','2013-10-14 09:32:13'),(56,1,'','California Electricity Crisis Refund Proceedings','2005-01-01','2006-01-01',0,'USD',0,'USD',0.00,0.00,'',33,NULL,NULL,'','California','236','2013-10-14 09:32:13'),(57,1,'','Bottlenecks for Investment in Rural Electrification','2005-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',11,NULL,NULL,'','','232','2013-10-14 09:32:13'),(58,1,'','Design and Implementation Guidelines for Water Supply and Sanitation Output Based Aid Arrangement','2005-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','Yerevan','12','2013-10-14 09:32:13'),(59,1,'','Preparation for Private Participation in Water in Greater Baku','2005-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','Greater Baku','16','2013-10-14 09:32:13'),(60,1,NULL,'Development of Model Management Contracts','2005-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',2,NULL,NULL,'0','N/A','250','2013-10-14 09:32:13'),(61,1,'','Establishment of Water and Sanitation Service Quality Monitoring System','2005-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',32,NULL,NULL,'','','12','2013-10-14 09:32:13'),(62,1,'','Armenia Power Sector Privatization Review','2004-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',2,NULL,NULL,'','','12','2013-10-14 09:32:13'),(63,1,'','Economic Benefits of Light Rail Transit','2004-01-01','2005-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(64,1,'','Transpower Regulatory Strategy','2004-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','159','2013-10-14 09:32:13'),(65,1,'','Japan Ministry of Economy, Trade & Industry / Nuclear Energy Regulatory Issues','2004-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',31,NULL,NULL,'','','236','2013-10-14 09:32:13'),(66,1,'','Major New Zealand Power Consumer / Power Purchasing','2004-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','159','2013-10-14 09:32:13'),(67,1,'','Rural Electrification, Bureau of Public Enterprises','2003-01-01','2004-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','162','2013-10-14 09:32:13'),(68,1,'','Establishment of Electricity Regulatory Commission, Bureau of Public Enterprises','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','162','2013-10-14 09:32:13'),(69,1,'','Armenia Energy Regulatory Commission','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','12','2013-10-14 09:32:13'),(70,1,'','Review and Analysis of Carbon Sequestration Programs and New Generation Technologies','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',30,NULL,NULL,'','','112','2013-10-14 09:32:13'),(71,1,NULL,'Survey of Electric Utility Activity-Based Costing Practices','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'0','NA','112','2013-10-14 09:32:13'),(72,1,NULL,'AES Sul Tariff Revision','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',27,NULL,NULL,'0','NA','32','2013-10-14 09:32:13'),(73,1,'','Cost of Service Forecast','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(74,1,'','Nuclear Plant Improvements','2003-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(75,1,'','Research and Analysis for Regulatory Filing','2002-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',26,NULL,NULL,'','','236','2013-10-14 09:32:13'),(76,1,'','Damages Calculation for Arbitration','2002-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',29,NULL,NULL,'','','236','2013-10-14 09:32:13'),(77,1,'','Western Power Market Price Mitigation Hearings','2001-01-01','2002-01-01',0,'USD',0,'USD',0.00,0.00,'',26,NULL,NULL,'','','236','2013-10-14 09:32:13'),(78,1,'','Distribution Utility Revenue Requirement','2001-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','S?o Paulo','32','2013-10-14 09:32:13'),(79,1,'','Development of Energy Practice, Enron and Shell','2001-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(80,1,'NA','EnergyE-Comm Retail Marketing Report','2000-01-01','2001-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'0','NA','236','2013-10-14 09:32:13'),(81,1,'','Support to Andhra Pradesh Electricity Regulatory Commission','2000-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',28,NULL,NULL,'','Andhra Pradesh','103','2013-10-14 09:32:13'),(82,1,'','Eletropaulo Revenue Requirement','2000-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','S?o Paulo','32','2013-10-14 09:32:13'),(83,1,'','Advised ANEEL on Tariff Concepts and Procedures','2000-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',27,NULL,NULL,'','','32','2013-10-14 09:32:13'),(84,1,'','Cost of Capital Estimation for Electricity Distribution Utility','2000-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','32','2013-10-14 09:32:13'),(85,1,'','Forecast and Analysis of World Demand for Gas Turbines','1999-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','Latin America',NULL,'2013-10-14 09:32:13'),(86,1,'','Preparation of Expert Testimony in Support of Merger of two U.S. Utilities before State Regulatory Commission','1999-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(87,1,'','Business Strategy Consulting','1999-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(88,1,'','Preparation of Expert Testimony in Support of Litigation between two U.S. Utilities','1999-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(89,1,'NA','Market Power Analysis in preparation for Market-Based Rates Application','1999-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',26,NULL,NULL,'0','NA','236','2013-10-14 09:32:13'),(90,1,'','Creation of Haryana Electricity Regulatory Commission','1998-01-01','1999-01-01',0,'USD',0,'USD',0.00,0.00,'',25,NULL,NULL,'','Haryana','103','2013-10-14 09:32:13'),(91,1,'','Preparation of Expert Testimony for a US Based Client','1998-01-01','1999-01-01',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(92,1,'','Tariff Revision of Escelsa','1998-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','32','2013-10-14 09:32:13'),(93,1,'','Northeastern U.S. Solar Renewable Energy Credit Market Study','2011-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',20,NULL,NULL,'','','236','2013-10-14 09:32:13'),(94,1,'','Western Interconnection Renewable Energy Market Entry Study','2010-01-01','2011-01-01',0,'USD',0,'USD',0.00,0.00,'',20,NULL,NULL,'','','236','2013-10-14 09:32:13'),(95,1,'','California Renewable Energy Transmission Initiative','2010-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',24,NULL,NULL,'','','236','2013-10-14 09:32:13'),(96,1,'','Western Renewable Energy Zones Project','2011-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',23,NULL,NULL,'','','236','2013-10-14 09:32:13'),(97,1,'','Utah Renewable Energy Zones Project','2010-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','Utah','236','2013-10-14 09:32:13'),(98,1,'','Renewable Energy Procurement Bid Reviews','2009-01-01','2010-01-01',0,'USD',0,'USD',0.00,0.00,'',22,NULL,NULL,'','',NULL,'2013-10-14 09:32:13'),(99,1,'','Business Development','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','',NULL,'2013-10-14 09:32:13'),(100,1,'','Market Assessment','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','',NULL,'2013-10-14 09:32:13'),(101,1,'','Briefing and Hearing: \"Deporteesn in Latin America and the Caribbean\"','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(102,1,'','Protection and Money: U.S. Companies, Their Employees, and Violence in Colombia','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(103,1,'','Briefing and Hearing: \"Violence in Central America\"','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(104,1,'','Congressional Members Working Group Dinner with Colombian President Álvaro Uribe','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(105,1,'','U.S.-Venezuela Relations','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(106,1,'','Biofuels, Energy Strategies, and U.S. Brazil Relations','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(107,1,'','The Future of Haiti’s Development','2007-01-01','0000-00-00',0,'USD',0,'USD',0.00,0.00,'',21,NULL,NULL,'','','236','2013-10-14 09:32:13'),(108,1,NULL,'Museo de Plantas Sagradas Mágicas y Medicinales','2011-06-01','2011-08-31',0,'USD',0,'USD',2.00,0.00,'',21,NULL,NULL,'0','Cusco','174','2013-10-14 09:32:13'),(110,1,'P1305','Armenia Scaling Up Renewable Energy (SREP) Investment Plan','2013-06-01','2013-10-31',260000,'USD',150000,'USD',8.30,3.80,'25,19',14,'28','27','','Yerevan','12','2013-10-14 09:32:13'),(111,1,'P1301','Armenia Power Sector Policy Note Update','2013-04-01','2013-10-31',119200,'USD',119200,'USD',4.60,0.00,'',2,NULL,NULL,'','Yerevan','12','2013-10-14 09:32:13'),(112,1,'','Identifying partners to influence Public Policy','2012-01-01','2012-01-01',0,'USD',0,'USD',0.00,0.00,'',37,NULL,NULL,'','','251','2013-10-14 09:32:13'),(113,1,'','Defining an evaluation mechanism for strategic initiatives','2012-01-01','2012-01-31',0,'USD',0,'USD',0.00,0.00,'',37,NULL,NULL,'','','251','2013-10-14 09:32:13'),(114,1,'','Identifying growth opportunities for solar power','2011-01-01','2012-01-01',0,'USD',0,'USD',0.00,0.00,'',38,NULL,NULL,'','','168','2013-10-14 09:32:13'),(115,1,'','Raising finances through grants and business plan competitions','2011-01-01','2012-01-01',0,'USD',0,'USD',0.00,0.00,'',38,NULL,NULL,'','','168','2013-10-14 09:32:13'),(116,1,'','Creating a go-to market strategy','2011-01-01','2011-01-31',0,'USD',0,'USD',0.00,0.00,'',39,NULL,NULL,'','','168','2013-10-14 09:32:13'),(117,1,'','Representing Consumer Banking products at the State Bank','2008-01-01','2010-01-01',0,'USD',0,'USD',0.00,0.00,'',40,NULL,NULL,'','','168','2013-10-14 09:32:13'),(118,1,'','Credit Risk Analysis','2008-01-01','2010-01-01',0,'USD',0,'USD',0.00,0.00,'',40,NULL,NULL,'','','168','2013-10-14 09:32:13'),(119,1,'','Deal Structuring','2008-01-01','2010-01-01',0,'USD',0,'USD',0.00,0.00,'',40,NULL,NULL,'','','168','2013-10-14 09:32:13'),(120,1,'','Industry risk rating adjustments','2008-01-01','2010-01-01',0,'USD',0,'USD',0.00,0.00,'',40,NULL,NULL,'','','168','2013-10-14 09:32:13'),(121,1,'P1302','Institutional, Legal, Regulatory and Financial Managament Assessment of Uzbekenergo','2013-02-01','2013-05-01',32000,'USD',32000,'USD',0.90,0.00,'',6,'29','24,45','1 A. Khodjaev Street 100027','Taskhent','239','2013-10-14 09:32:13'),(122,1,'P1306','Gas and District Heating Tariff and Subsidy Reform in Ukraine','2013-06-02','2013-08-30',20000,'USD',20000,'USD',1.00,0.00,'',2,NULL,NULL,'','','233','2013-10-14 09:32:13'),(123,1,'P1307','Power Sector Policy Note for the Kyrgyz Republic','2013-08-01','2013-11-01',30000,'USD',30000,'USD',1.50,0.00,'3,10',2,'9','18','0','Bishkek ','121','2013-10-14 09:32:13'),(124,1,'P1105','Assessment of the US Solar PV Market','2011-12-01','2011-12-31',3000,'USD',3000,'USD',0.50,0.00,'2',4,NULL,'5,46','MUZA Kawasaki Central Tower 1310 Omiya-cho, Saiwai-ku, Kawasaki, Kanagawa 212-8554 Japan','Kanagawa','112,236','2013-10-25 19:02:42'),(125,1,'P1309','Kyrgyzstan Energy Tariffs: Revision of Electricity and District Heating Tariff Methodology and Key Performance Indicators (KPIs)','2013-10-31','2014-10-31',145000,'USD',54000,'USD',6.00,1.27,'23,24',2,'6','18','0','Bishkek','121','2013-11-12 01:42:11'),(126,1,'P1105','Laws and Regulations Governing On and Offshore Wind Energy Development in the US','2011-11-01','2011-12-01',3000,'USD',3000,'USD',0.50,0.00,'2',4,NULL,'5,46','MUZA Kawasaki Central Tower 1310 Omiya-cho',', Saiwai-ku, Kawasaki, Kanagawa 212-8554','112,236','2013-11-13 02:48:02'),(127,1,'P1105','Geothermal Power Laws, Regulations and Codes in California','2009-01-11','2010-01-11',3000,'USD',3000,'USD',0.50,0.00,'2',4,NULL,'5,46','MUZA Kawasaki Central Tower 1310 Omiya-cho','Omiya-cho, Saiwai-ku, Kawasaki, Kanagawa 212-8554','112,236','2013-11-13 03:00:09'),(128,1,'P1105','Electricity Generation from Biomass in the United States: Current Technologies, Policies, and Regulation','2011-12-01','2012-01-01',3000,'USD',3000,'USD',0.50,0.00,'2',4,NULL,'5,46','MUZA Kawasaki Central Tower 1310 Omiya-cho','Omiya-cho, Saiwai-ku, Kawasaki, Kanagawa 212-8554','112,236','2013-11-13 03:07:06'),(129,1,'P1311','Kyrgyzstan ADB WSS Financial Analysis','2013-10-30','2014-04-30',105000,'USD',61264,'USD',2.90,0.00,NULL,6,NULL,'24','25 Main Street, Northampton, MA, USA 01060','Bishkek','121','2013-11-13 14:35:44'),(136,3,'54554','Test Project ','2013-12-04','2013-12-18',100,'USD',80,'USD',10.00,5.00,NULL,NULL,NULL,NULL,'New Address ','New Address ','236','2013-12-09 05:42:16'),(137,1,'P1313','Preparation of PPP ToR: Caribbean Regional Communications Infrastructure Project (CARCIP)','2014-01-01','2014-02-01',5000,'USD',5000,'USD',1.00,0.00,NULL,41,'97','49','0','Home','8,10,33,64,88,150,188,191','2014-02-11 10:09:48'),(138,1,'P1310','Belarus Heat Tariff Reform and Social Impact Mitigation Energy Stocktaking Analysis','2013-11-25','2014-06-30',35000,'USD',35000,'USD',7.50,0.00,NULL,2,'103',NULL,'1818 H St NW','National','21','2014-03-17 15:18:49'),(139,1,'P07049','Review of World Bank Assistance to the Energy Sector in the Republic of Georgia','2007-07-01','2007-10-31',25000,'USD',25000,'USD',1.00,0.00,NULL,36,NULL,NULL,'0','Tbilisi','82','2014-03-19 22:35:08'),(141,1,'P1403','Armenia Small Hydro Power Plant (SHPP) feed-in tariff analysis','2014-03-17','2014-04-30',16600,'USD',16600,'USD',1.50,0.00,NULL,2,'27',NULL,'0','Yerevan','12','2014-04-01 14:08:43'),(143,1,'P1402','Financial Analysis of Power Sector Utilities in the Western Balkans','2014-03-14','2014-05-15',33000,'USD',33000,'USD',2.70,0.50,'26',2,'98','18','0','Regional','29,132,149,197,252','2014-04-10 15:24:38'),(145,1,'P1404','Scaling Up Renewable Energy (SREP) Investment Plan for Vanuatu','2014-04-14','2014-10-31',200000,'USD',100000,'USD',3.00,3.00,'19',42,'99','50','0','Port Vila','240','2014-04-28 16:53:22'),(150,1,'P1405','Evaluation of PPP projects in Europe and Central Asia','2014-04-15','2014-10-15',175596,'USD',175596,'USD',6.00,1.00,'28,27,29',11,'100','17','0','Belgrade','115,132,252,3','2014-06-23 10:08:57'),(153,1,'P1210','Republic of Armenia: Energy Sector Assessment, Strategy and Road Map ','2012-07-28','2012-09-28',80100,'USD',80100,'USD',2.00,2.00,NULL,6,'114',NULL,'0','Yerevan ','12','2014-07-23 18:03:08'),(154,1,'P1308 ','Armenia Water Tariff Study ','2013-08-01','2014-09-01',99640,'USD',80000,'USD',13.00,4.00,NULL,2,'102',NULL,'0','Yerevan ','12','2014-07-25 15:22:53'),(156,1,'P1411','Least Economic Cost Planning of New Supply in Georgia','2014-09-24','2015-01-02',75000,'USD',75000,'USD',3.33,0.00,NULL,2,'27',NULL,'0','Tbilisi','82','2014-10-01 13:35:52'),(157,1,'P1410','Regional Energy Sector Diagnostic Report for the Western Balkans ','2014-10-17','2015-02-27',61000,'USD',61000,'USD',3.80,0.00,NULL,2,'98','18','0','Regional','3,29,252,132,149,197','2014-11-24 12:15:51'),(158,1,'P1409','Options for Power Sector Reform in Timor Leste','2014-07-25','2014-12-31',77250,'USD',77250,'USD',2.10,0.00,NULL,6,'10','54','0','Dili','222','2014-12-18 09:43:16'),(159,1,'','Review of Cost Filings related to the California Refund Proceeding','2005-09-01','2005-11-01',0,'USD',0,'USD',2.00,0.00,NULL,17,'19',NULL,'0','Washington D.C.','236','2015-01-07 15:08:04'),(160,1,'','Tariff Application for Pakistan Wind Power Project','2005-03-01','2005-06-01',0,'USD',0,'USD',1.00,0.00,NULL,50,NULL,NULL,'0','Wellington','159','2015-01-07 15:15:02'),(161,1,'','Wind Generation Investigation Project','2005-07-01','2007-04-01',0,'USD',0,'USD',12.00,0.00,NULL,49,NULL,NULL,'0','Welington','159','2015-01-07 15:17:21'),(162,1,'','Retail Cost Benchmarking','2006-03-01','2006-06-01',0,'USD',0,'USD',1.00,0.00,NULL,50,NULL,NULL,'0','Wellington','159','2015-01-07 15:22:22'),(163,1,'','Electricity Efficiency Potentials Study and Contracting for \"Negawatts\"','2008-03-01','2009-02-01',0,'USD',0,'USD',4.00,0.00,NULL,49,NULL,NULL,'0','Wellington','159','0000-00-00 00:00:00'),(164,1,'','Generation Capacity Adequacy Review','2006-08-01','2006-12-31',0,'USD',0,'USD',1.00,0.00,NULL,48,NULL,NULL,'0','Wellington','159','2015-01-07 15:30:14'),(165,1,'','Reserve Energy Arrangements Independent Review','2006-11-01','2007-02-28',0,'USD',0,'USD',3.00,0.00,NULL,50,NULL,NULL,'0','Wellington','159','2015-01-07 15:32:33'),(166,1,'','System Operator Service Provision Contract Negotiation','2007-09-01','2008-07-01',0,'USD',0,'USD',6.00,0.00,NULL,49,NULL,NULL,'0','Wellington','159','2015-01-07 15:36:14'),(167,1,'','Price Control Submission to the Networks Regulator','2012-07-01','2013-12-02',0,'USD',0,'USD',8.00,0.00,NULL,48,NULL,NULL,'0','Wellington','159','2015-01-07 15:38:57'),(168,1,'','Transmission and Distribution Regulatory Framework and Grid Investment Framework Development','2009-03-01','2011-03-01',0,'USD',0,'USD',12.00,0.00,NULL,47,NULL,NULL,'0','Wellington','159','2015-01-07 15:43:28'),(169,1,'','Gas Transmission Capacity and Pricing Issues','2008-01-10','2009-01-02',0,'USD',0,'USD',2.00,0.00,NULL,45,NULL,NULL,'0','Wellington','159','2015-01-07 15:45:52'),(170,1,'','Gas Pipeline Balancing Arrangements','2008-05-01','2008-10-31',0,'USD',0,'USD',3.00,0.00,NULL,45,NULL,NULL,'0','Wellington','159','2015-01-07 15:47:34'),(171,4,'P1309','Revisión de la metodología y los Indicadores Clave del Desempeño (KPIs) de la electricidad y la calefacción urbana','2013-10-21','2015-01-07',145000,'USD',54000,'USD',4.41,1.27,'30,31',44,NULL,NULL,'0','Bishkek','','2015-01-07 16:09:10'),(172,4,'P1308','Estudio de tarifas del sector del agua en Armenia','2013-12-01','2015-01-07',99,'USD',80,'USD',13.00,4.00,NULL,44,NULL,NULL,'0','Yerevan','12','2015-01-07 16:34:33'),(173,4,'P1402','Análisis financiero de la infraestructura del sector eléctrico en los Balcanes Occidentales','2014-03-14','2014-05-15',33000,'USD',33000,'USD',2.00,0.50,'32',44,NULL,NULL,'0','Regional','132,252,29,197,3,149','2015-01-07 16:51:40'),(174,4,'P1201','Desarrollo de la metodología de tarifas eléctricas y subsidios eléctricos para Armenia','2012-03-01','2012-12-01',82,'USD',22,'USD',9.00,0.00,'33,34',44,NULL,NULL,'0','Yerevan','12','2015-01-07 16:59:17'),(175,4,'P1403','Análisis de la tarifa de medición neta de las plantas de energía hidroeléctricas de Armenia','2014-03-17','2014-04-30',16600,'USD',16600,'USD',1.00,0.00,NULL,46,NULL,NULL,'0','Yerevan','12','2015-01-07 17:06:15'),(176,4,'P1310','Reforma de la tarifa de calefacción en Bielorrusia y análisis del impacto social  de la mitigación del almacenamiento de la energía','2013-11-25','2014-06-30',35000,'USD',35000,'USD',7.00,0.00,NULL,44,NULL,NULL,'0','Nacional','21','2015-01-07 17:11:15'),(177,4,'P1306','Tarifa de calefacción y del gas y reforma de los subsidios en Ucrania','2013-06-02','2013-08-30',20000,'USD',20000,'USD',3.00,0.00,NULL,44,NULL,NULL,'0','Kiev','233','2015-01-07 17:15:18'),(178,4,'P0913','Desarrollo de capacidades para la Asociación Público-Privada de Mongolia y la unidad de APP','2010-11-01','2013-09-30',78260,'USD',78260,'USD',35.00,0.00,'35,38,36,37',51,NULL,NULL,'0','Ulaanbaatar','148','2015-01-07 17:27:20'),(179,4,'P1209','Asesoría de transacciones para servicios urbanos en el sur del Gobi','2012-07-01','2013-07-01',520,'USD',121,'USD',12.00,5.00,'35',52,NULL,NULL,'0','Sureste de Gobi (Omnogovi and Dornogovi Aimags)','148','2015-01-07 17:33:33'),(180,4,'P1307','Nota sobre la política del sector energético para la República de Kirguistán','2013-08-01','2013-11-01',30000,'USD',30000,'USD',3.00,0.00,'39,40',44,NULL,NULL,'0','Biskek','121','2015-01-07 17:37:49'),(181,4,'P1305','Plan de inversión para el aumento de energía renovable (SREP según sus siglas en inglés) en Armenia','2013-06-01','2013-10-31',260000,'USD',150000,'USD',5.00,3.80,'41,42',53,NULL,NULL,'0','Yerevan','12','2015-01-07 17:42:18'),(182,4,'P1311','Análisis financiero ADB WSS de Kirguizistán','2013-10-30','2014-04-30',105000,'USD',61264,'USD',6.00,0.00,NULL,54,NULL,NULL,'0','Bishkek','121','2015-01-07 17:46:28'),(183,4,'P1301','Nota sobre la actualización de la política del sector energético de Armenia','2013-04-01','2013-10-31',119200,'USD',119200,'USD',7.00,0.00,NULL,44,NULL,NULL,'0','Yerevan','12','2015-01-07 17:49:57'),(184,4,'P1212','Revisión del gasto público del sector energético de la República de Kirguistán ','2012-11-01','2013-06-01',93898,'USD',93898,'USD',7.00,3.50,'33,34',44,NULL,NULL,'0','Bishkek','121','2015-01-07 17:53:24'),(185,4,'P1008','Desarrollo de opciones de reforma del sector público para el servicio de agua público de Nauru','2010-11-01','2011-02-01',40500,'USD',27000,'USD',3.00,0.00,NULL,54,NULL,NULL,'0','A nivel nacional','155','2015-01-07 17:57:22'),(186,1,'P1401','Advice on PPP Policy, Regulation and Transactions in China','2014-01-03','2015-01-03',70000,'USD',70000,'USD',2.40,0.00,NULL,6,'104','24','0','Beijing, Enshi','46','2015-01-14 15:32:22'),(187,1,'P1413','Nauru Utility Reform','2015-01-12','2015-11-07',45193,'USD',45193,'USD',2.67,0.00,NULL,6,'26',NULL,'0','Countrywide','155','2015-01-15 15:18:47'),(188,1,'P1414','Scaling Up Energy Efficiency Retrofit of Residential and Public Buildings ','2015-01-13','2015-06-30',42495,'USD',42495,'USD',3.20,0.00,NULL,2,'108',NULL,'0','Minsk','21','2015-01-25 14:51:16'),(189,1,'P1406','Finalizing Heating Assessments for Tajikistan and the Kyrgyz Republic','2014-06-11','2015-02-27',55000,'USD',55000,'USD',8.00,0.00,NULL,2,'6','18','0','Bishkek, Tokmok, Dushanbe, Khujand','121,219','2015-02-02 15:39:53'),(190,1,'P1303','Development of PPP Handbook for Mongolia\'s PPP Unit','2013-03-01','2013-12-31',47000,'USD',47000,'USD',1.00,0.00,NULL,6,'104','24','0','Ulaanbaatar','148','2015-02-02 17:23:09'),(191,1,NULL,'Consumer Willingness to Pay for Certified Bee Friendly Blueberries','2014-05-20','2015-01-17',0,'USD',0,'USD',0.00,0.00,NULL,55,'109',NULL,'0','Amherst','236','2015-03-10 18:24:16'),(192,1,NULL,'Impacts of the Food Safety Modernization Act Proposed Produce and Preventative Controls Rules on the Domestic Produce Industry','2014-01-20','2015-01-21',0,'USD',0,'USD',0.00,0.00,NULL,55,'110',NULL,'0','Amherst and DC','','2015-03-10 18:40:04'),(193,1,NULL,' DPU 12-86: Milford Water Company Rate Case','2013-08-01','2013-08-31',0,'USD',0,'USD',0.00,0.00,NULL,57,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:08:37'),(194,1,NULL,'DPU 13-75 :  Bay State Gas Company Rate Case','2013-04-01','2013-11-29',0,'USD',0,'USD',0.00,0.00,NULL,57,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:25:55'),(195,1,NULL,'DPU 12-115 :  National Grid Electric 2013 RDM','2012-02-01','2012-12-01',0,'USD',0,'USD',0.00,0.00,NULL,57,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:29:49'),(196,1,NULL,'DPU 12-97:  Western  Massachusetts Electric Company (WMECo) Revenue Neutral Rate Design','2012-11-01','2012-12-01',0,'USD',0,'USD',0.00,0.00,NULL,57,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:32:44'),(197,1,NULL,'DPU 12-25 : Bay State Gas Company Rate Case','2012-04-01','2012-11-01',0,'USD',0,'USD',0.00,0.00,NULL,57,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:36:35'),(198,1,NULL,'DPU 11-78 & DPU 11-79: National Grid Gas Company Request for Long-Term Financing','2011-08-01','2011-12-01',0,'USD',0,'USD',0.00,0.00,NULL,NULL,NULL,NULL,'0','Massachusetts','236','2015-03-17 19:38:33'),(199,1,'P1501','CAREC Power Sector Financing Roadmap','2015-02-28','2015-10-30',136000,'USD',136000,'USD',5.00,0.00,NULL,NULL,NULL,NULL,'0','Ulaanbaatar','1,16,115,121,148,219,229','2015-03-20 17:41:10'),(200,1,'P1312 ','Kosovo Supply Options Study Update','2014-02-03','2014-06-30',35000,'USD',35000,'USD',4.00,0.00,NULL,2,'113,111,112',NULL,'0','Pristina','252','2015-03-30 21:16:39'),(201,1,'P1412','Ukraine Heating Tariff Reform','2014-12-01','2015-06-30',54,'USD',54,'USD',3.00,3.00,NULL,2,'30',NULL,'0','Kiev','233','2015-04-01 13:31:25'),(202,1,'P1504','PPP Options for Municipal Light Plant Broadband Service','2013-08-01','2013-08-31',0,'USD',7000,'USD',0.25,0.25,NULL,NULL,NULL,NULL,'0','Massachusetts','236','2015-04-15 19:02:27'),(203,1,'P1503','Preparation of the Scaling-up Renewable Energy Program (SREP) Investment Plan in Bangladesh','2015-04-09','2015-12-31',247,'USD',98000,'USD',5.50,5.95,'19',2,'115',NULL,'0','Dhaka','','2015-04-16 21:54:05'),(204,1,'P1502','Contingent Valuation Study for Water Supply and Solid Waste Disposal in Dili','2015-04-13','2015-07-06',73056,'USD',63056,'USD',2.90,2.00,NULL,NULL,NULL,NULL,'0','Dili','222','2015-04-17 16:54:34');

--
-- Table structure for table `projects_description`
--

CREATE TABLE `projects_description` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) DEFAULT NULL,
  `description` text,
  `categories` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects_description`
--

INSERT INTO `projects_description` VALUES (5,42,'The Asian Development Bank (ADB) funded transaction advisory services to support the Government of Mongolia in carrying out recommendations for institutional reforms in the urban services sector. As part of the reforms, the Government solicited private sector operating companies to provide water and sanitation service in the Omnogovi and Dornogovi Aimags, and established a national independent regulator for water and sanitation services. Improved provision of urban services is particularly important in Omnogovi and Dornogovi because the population in these aimags is expected to double within the next ten years as a result of increased economic activity from mining and cross-border trade with the People’s Republic of China. Existing infrastructure is inadequate to serve even current populations.','4,1,14,9'),(6,43,'The ADB team wanted to prepare the energy sector assessment, strategies, and roadmaps (ASR) to better harmonize ADB’s support program and project planning in Georgia and Armenia. The energy sector ASR is an integral part of project planning and preparation to plan investment needs in developing the ADB’s Country Partnership Strategy (CPS) for Georgia and Armenia in 2013-2015.','8,4'),(7,45,'The World Bank Group (WBG) planned to develop a new set of global indicators assessing the Readiness for Investment in Sustainable Energy (RISE). The motivation for such indicators stemmed from the UN’s Sustainable Energy for All (SE4ALL) initiative, which states three goals for 2030: i) provide universal access to modern energy services; ii) double the share of renewable energy; and iii) double the rate of energy efficiency improvements. The RISE indicators were used to benchmark country level progress in developing enabling environments for renewable energy, energy efficiency and the provision of universal access to modern energy services.','5,8,4'),(8,39,'Currently, Armenia has adequate operational capacity to meet the domestic demand. However, given the impending decommissioning of the nuclear power plant estimated at 2020, uncertainties with the construction of the new one and the overall old age of the other generation assets, the country may experience peak demand shortages in the medium to long-term. Moreover, certain sections of the electricity transmission network are extremely old and require urgent rehabilitation/replacement. To address issues of long-term financial sustainability, energy security and regional integration, World Bank needed an analysis of the energy sector’s strengths, weaknesses, opportunities and threats.','8,5,6'),(9,37,'The energy sector in Uzbekistan faces the important challenge of ensuring the reliability and affordability in its power sector despite an emerging supply-demand gap and ageing power sector infrastructure. The World Bank requested assistance to identify these challenges and recommend solutions to overcome them, as well as to suggest a possible role for the World Bank in the sector.','8,4'),(10,41,'The Asian Development Bank (ADB) financed an ambitious investment and technical assistance program in Ulaanbaatar. The program aimed to promote an inclusive peri-urban development in the ger areas (informal settlements) of Ulaanbaatar, by supporting the socioeconomic development of urban subcenters located in those areas. The program included physical investments in extensions and upgrades to water supply, wastewater collection and district heating infrastructure, and technical assistance in (i) supporting urban governance, livelihood, and socioeconomic activities through better land use planning, and better access to financing; and (ii)  improving of the performance of urban service providers; and (iii) reforming legal, regulatory and institutional frameworks for urban service provision.',''),(11,38,'To help Ukraine reduce energy loss and consumption in its cities, the U.S. Aid for International Development (USAID) launched the four-year $18.5 million Municipal Heating Reform (MHR) project in February 2009. The MHR project was designed to help Ukraine create a financially viable and sustainable municipal heating sector that delivers quality services to residences, public institutions, and local businesses and industries. USAID needed an evaluation of the MHR project’s mid-term performance.','13,8,3,4'),(12,40,'The Armenia Renewable Resource and Energy Efficiency Fund (R2E2) requested the preparation of a geothermal power plant design and an economic and financial assessment of the conceptual power plant at the Karkar geothermal site. The objective was to provide a recommendation to R2E2 about whether or not the Armenian Government should proceed with exploratory drilling at the site.','5,8,6'),(13,11,'The World Bank wanted to help the Government of Kenya complete the ambitious reforms launched by the 2002 Water Act (“the Water Act”). The Water Act sought to address the problems in Kenya’s water supply and sanitation sector by creating new institutions, and reallocating functions between existing and new institutions. The details of this reallocation were specified in the 2005 Water (Plan of Transfer of Water Services) Rules (“the Transfer Plan”) under the Water Act. By 2008, the transfer of most of the assets, liabilities, personnel, responsibilities and powers had not yet taken place. The World Bank requested help to advise the Government on how to advance the transfer plan, and whether to change any aspects of the transfer plan to make it more feasible.','4,9'),(14,34,'The World Bank requested an analysis of the cost of alternative power plant options (developed on a BOT or BOO basis) available to Kosovo for meeting energy consumption and peak demand until 2025. Power plant options were to include lignite, gas and fuel oil plant, in combination with a fixed package of renewables.','5,8,6'),(15,3,'In 2007, the President’s Office and Business Trust of South Africa launched the Support Program for Accelerated Infrastructure Development (SPAID). One of SPAID’s main goals is to enhance Public Private Partnerships (PPPs) in infrastructure.','1'),(16,4,'The World Bank wanted to evaluate the potential benefits to Russia of improving energy efficiency at all segments of the value chain (production, transmission and consumption), and recommend energy efficiency policy priorities for Russian policymakers.','5,8,4,6'),(17,5,'Japan’s New Energy and Industrial Technology Development Organization (NEDO), requested a review of the technical and financial feasibility of cellulosic ethanol production in the United States. A second study was completed in 2009 with updates on the new policy as well as a review on technological breakthroughs during the year.','8,4,6'),(18,6,'The World Bank wanted to evaluate the potential benefits to Armenia of improving energy efficiency at all segments of the value chain (production, transmission and consumption), and recommend energy efficiency policy priorities for Armenian policymakers.','5,8,4,6'),(19,7,'The Government of Mongolia (GoM) was seeking to develop world class mines in the South Gobi region. The World Bank was assisting GoM to develop a regulatory framework. The World Bank commissioned Castalia to undertake a background study on the development of urban settlements in connection with mining development.','8,4,6'),(20,8,'The Millennium Challenge Corporation (MCC) wanted to evaluate the impact of several large electricity sector investments it was planning in Tanzania, namely, construction of a new subsea high voltage cable connecting Zanzibar Island to the mainland, construction of a new hydroelectric plant and distribution at Malagarasi; and rehabilitation and extension of low voltage and medium voltage networks in four regions. MCC wanted to measure, through a rigorous impact evaluation, whether those activities led to improved health, economic, and educational outcomes at the household level as well as better financial outcomes at the business level.','8,3'),(21,12,'Japan’s New Energy and Industrial Technology Development Organization (NEDO) wanted to know about recent trends in research and development (R&D) of lithium ion batteries for use in motor vehicle transport.','5,8'),(22,13,'The Government of Kenya had set ambitious targets to expand access to electricity throughout the country, and made an additional 1 million electricity connections by 2012. The World Bank wanted to help the Government plan for these new connections, and engaged Castalia to prepare a Prospectus that combined technical GIS-based electrification plans with least-cost financing options for the new investments.','8,4,5,6'),(23,14,'The New Energy and Industrial Technology Development Organization (NEDO) wanted to know about the use of “Smart Grid” technologies in the United States.  NEDO wanted a survey of ongoing Smart Grid initiatives to be conducted.  Specifically to be addressed were: federal and state level policies supporting Smart Gird, the market segmentation of Smart Grid companies, and current Smart Grid projects.','5,8,4'),(24,20,'The Asian Development Bank (ADB) wanted to assist the Government of Mongolia in designing and implementing a legal and regulatory framework for Public Private Partnerships (PPPs). Castalia was asked to advise on the drafting its new Public Private Partnerships Law (the “Concession Law”) and the establishment of a PPP Program and Unit.',''),(25,16,'The Law on Electronic Communications in Armenia required the Public Services Regulatory Commission (PSRC) to establish a Universal Services Fund (USF) for the telecommunications sector in Armenia. The World Bank wanted to help the PSRC develop regulations that would establish the USF, determine which services would be covered by the USF, and set the appropriate level of tax that would be levied on operators.','4,10'),(26,17,'The Government of Mexico and USAID wanted to improve the performance of the water and waste water utility companies.','4,9'),(27,18,'Switzerland’s State Secretariat for Economic Affairs (SECO) provides financial and technical assistance in the energy and water sectors. The goal of SECO intervention in the energy sector is to contribute to economic development by ensuring the supply of reliable and financially sustainable energy. SECO wanted to conduct an independent evaluation of energy sector interventions in 17 Eastern Europe and Central Asia countries.  SECO requested that the evaluation give special focus to the interventions in Albania, Kyrgyzstan, Romania, and Serbia. The evaluation would assess the effectiveness of SECO’s assistance by determining how project outputs, outcomes, and impacts aligned with SECO’s strategy for each country.','8,3,9'),(28,19,'The energy sector in Armenia faced several key challenges in the short- to medium-term related to generation capacity constraints, ageing infrastructure, regional integration, financial stability, and barriers to energy efficiency. The World Bank wanted to identify these key issues and bottlenecks, and get recommendations about short-term and long-term actions to overcome them.  The World Bank also wanted suggestions about it\'s role in the sector.','8,4,6'),(29,21,'Two of Japan’s largest electric utility companies (CHUBU Electric Power Company, Tokyo Electric Power Company) requested a report on the state of Smart Grid deployment in the US.','5,8,4'),(30,22,'IFC wanted to conduct a regional cross-country analysis of results from a survey conducted among small and medium-size enterprises to identify the existing energy efficiency markets conditions and barriers.','5,8,4'),(31,23,'The global financial crisis has put increasing pressure on investments in the electricity sector in Europe and Central Asia as private capital flows, domestic lending, and access to international capital markets have been heavily scaled back. The World Bank wanted to analyze the effects of the financial crisis on the electricity sector in Ukraine, Romania, Serbia, Kyrgyz Republic and Armenia.','8,6'),(32,27,'Pacific Gas & Electric (PG&E), a large US electric utility, wanted to demonstrate to the Federal Energy Regulatory Commission (FERC) that sellers in the California electricity markets during the summer of 2000 committed California ISO tariff violations. PG&E also wanted to calculate a set of competitive prices that would have been expected to occur in the California electricity markets if sellers had not committed tariff violations and compare those prices to the amounts actually received by sellers. Finally, PG&E wanted to calculate refunds that would be paid by sellers to California utilities for certain types of energy transactions in order to mitigate prices charged above just and reasonable levels.','8,4'),(33,24,'Following the passing of the Concession Law in January 2010, the State Property Committee (SPC) wanted to open a tender for the construction of a new combined heat and power (CHP) plant using a PPP transaction.','8,1,4'),(34,25,'The Asian Development Bank (ADB) asked DHInfrasturcture to advise the Government of Nauru on the reform of its utilities (electricity, water, fuel supply) sectors, given the poor reliability and quality of service, and near complete financial dependency on donors. All utilities are currently under direct control of the Ministry of Commerce Industry and Environment. DHInfrastructure drafted a policy note for Nauru\'s Cabinet, advising on the most viable reform options, including Public Private Partnerships (PPPs), and how to implement them.','8,1,4,9'),(35,28,'The World Bank wanted to assess the transaction opportunities for regional trade in the South Caucasus region, including Azerbaijan, Georgia, Armenia and Turkey. A team of technical consultants was hired to carry out an assessment of the technical potential for regional trade. The World Bank needed support with the technical assessment and stock taking study of the legal, regulatory, and institutional environment supporting regional integration and the barriers that will limit regional integration. The study would be focused, in particular, on legal and regulatory barriers to attracting private investment in new generation and transmission in each of the countries.','8,4,6'),(36,29,'The Asian Development Bank (ADB) wanted to help the Government of Nepal enhance the operations of the Town Development Fund (TDF), by helping to develop its capacity for dealing with public–private partnership (PPP) to meet the growing need for urban infrastructure and better delivery of urban services. ADB requested a consulting team to: 1.) develop TDF’s general financing policy and guidelines at the sector level; 2.) prepare TDF’s PPP financing policy and guidelines, including a review of existing PPP financing systems abroad (particularly in India) and of lessons for the TDF; 3.) provide support for consulting services on project appraisal and risk management for ongoing joint projects of the Asian Development Bank (ADB) and the TDF; 4.) develop a manual on PPP structuring and project appraisal for new projects and 5.) design two PPP demonstration projects to the stage when requests for qualification are issued and a shortlist of bidders has been established.','1,4,9'),(37,30,'The World Bank prepared a report that: 1.) assessed possible options of implementing consumer-end heat metering in Ukraine; and 2.) recommended a strategy of introducing building-level heat metering and consumption-based billing in Ukraine. The World Bank requested a consulting firm to prepare a report for widespread dissemination that summarized the results of public consultations on heat metering, demonstrated how heat metering benefits both customers and district heating companies, and recommended ways the World Bank could support heat metering implementation in Ukraine.','13,4'),(38,31,'The African Development Bank hired Hunton and Williams and Castalia to deliver training on Public-Private Partnerships (PPPs) to power experts from the West African Power Pool (WAPP) member countries. DHInfrastructure was hired as a subcontractor. The five-day training provided participants with an understanding of how to design PPP projects. In particular, this training focuses on designing PPPs in the power sector that comply with the legal, regulatory, and institutional framework of the Economic Community of West African States (ECOWAS) and WAPP member countries.','8,1,4'),(39,20,'The Asian Development Bank (ADB) wanted to assist the Government of Mongolia in designing and implementing a legal and regulatory framework for Public Private Partnerships (PPPs). DHInfrastructure was asked to advise on the drafting its new Public Private Partnerships Law (the “Concession Law”) and the establishment of a PPP Program and Unit.',''),(40,26,'ADB wanted to provide training to the newly-established Department of Public–Private Partnership (PPP) and Concessions (also known as the PPP unit) within the State Property Committee (SPC), and help them develop regulations under Mongolia\'s new concession law.','1'),(41,32,'Urban services are a priority area for public investment in Mongolia, as the quality and coverage of water, sewerage, heating, and solid waste is poor. Rising incomes and population growth are putting severe pressure on the capacity of weak public service networks in urban areas, including Ulaanbaatar. A long term investment program, supported by a multi-tranche financing facility, was planned for Ulaanbaatar starting in 2012, to strengthen water and sanitation services. ADB was working with the Ministry of Road, Transportation, Construction and Urban Development (MRTCUD) and the Municipality of Ulaanbaatar (MUB) to develop a road map for investment and concomitant institutional reforms.','5,8,4,14,9'),(42,33,'The World Bank (WB) wanted to develop a conceptual framework for assessing, both qualitatively and quantitatively, the transaction or delivery costs of demand-side energy efficiency (EE) measures. The conceptual framework was meant to serve as the basis for an illustrative assessment of the first order range of such costs for selected demand side EE programs/technologies, in order to better inform policy makers about options presented in typical marginal abatement cost (MAC) curves. The specific outputs of the activity were meant to help: 1.) advance the understanding of the range, magnitude and implications of incremental delivery costs of demand-side EE; 2.) demonstrate the approach and provide directions about how EE delivery costs could be estimated using data from selected projects; and 3.) better inform World Bank project managers, other donors, and client governments on how to treat the issue of delivery cost of greenhouse gas (GHG) abatement through EE options.','5,4'),(43,35,'The Asian Development Bank wanted to support government of Nauru in improving financial, operational and governance performance of the Nauru Utilities Corporation (NUC) through reforms to regulation and governance. The assignment specifically supported: 1.) the physical and accounting separation of NUC from the government; 2.) a review of NUC\'s institutional capacity and development of its business/corporate strategy; and 3.) the development of a performance management system for NUC, including the recommendation of Key Performance Indicators (KPIs). ','8,4,9'),(44,36,'Armenia’s power sector faces challenges in ensuring adequate energy supply, safeguarding energy security, and keeping energy supply affordable for customer, while maintaining financial sustainability of the sector. The World Bank wanted to assess the levels of the current electricity tariffs in terms of cost-recovery and recommended improvements to the tariff structure, in order to ensure efficient use of electricity in Armenia.','8,4'),(45,44,'The World Bank wanted to conduct a Public Expenditure Review (PER) for the energy sector of the Kyrgyz Republic as part of a larger project aimed at identifying ways in which the Government of the Kyrgyz Republic can achieve fiscal consolidation. The Bank asked DHInfrastructure to offer recommendations for improving sustainability of energy sector revenues and expenditures and the efficiency in provision of energy supply.','8,4,6'),(46,41,'The ADB implemented an investment program in Ulaanbaatar, Mongolia that aims to promote an inclusive peri-urban development in the ger or lower income areas. Combining spatial and sector approaches, it will introduce sustainable urban services and support the socioeconomic development of urban sub-centers located in ger areas. The proposed program will: (i) support urban governance, livelihood and socioeconomic activities through land use planning, and improved access to financial services; (ii) extend and upgrade appropriate and affordable water supply, wastewater collection, and district heating infrastructures; and (iii) improve the operation and maintenance capacities of service providers, and enable sound institutional and regulatory settings for service delivery. Castalia was hired to advise on the water, sanitation and district heating utilities, by conducting an in-depth review of the current performance, and suggesting reforms that would improve and upgrade the current services.',''),(47,46,'The Business Trust and President’s Office of the Republic of South Africa wanted to advise the National Treasury’s Public Private Partnerships (PPP) Unit on whether to change the organization and functions of the PPP Unit. This work followed from Castalia’s recommendations to the PPP Unit in 2007 on how to accelerate PPPs in infrastructure in South Africa.','1,4'),(48,47,'The World Bank Independent Evaluation Group (IEG) wanted to review the effectiveness of World Bank support to Georgia’s energy sector since the mid-1990s.','8,3'),(49,48,'A joint effort between the President’s Office and Business Trust of South Africa has launched the Support Programme for Accelerated Infrastructure Development. One of SPAID’s main goals is to enhance Public Private Partnerships (PPPs) in infrastructure. Castalia had been selected to identify the current barriers to PPPs in all infrastructure sectors in South Africa.','1'),(50,49,'Uganda has embarked on a comprehensive reform to extend water and sanitation coverage and improve service provider performance. As part of this program, the Ministry of Water and Environment (MoWE) and Germany’s KfW hired Castalia to: 1.) Support the evolution of the National Water and Sewerage Corporation (NWSC) into an Asset Holding Authority (AHA), with service provided through separate operating companies and 2.) Recommend changes to the regulatory framework for the urban water sector.','4,9'),(51,50,'As part of the infrastructure reform, Government of Indonesia wanted to develop a risk management framework and a guarantee fund for PPPs in infrastructure.','1'),(52,51,'The Government of the Gambia implemented a divestiture program for public enterprises. The National Water and Electricity Company of the Gambia (NAWEC), and the fixed and mobile telephone companies (GAMTEL and GAMCEL) were all candidates for divestiture.','8,12,4,10,9'),(53,52,'The Public Services Regulatory Commission (PSRC) needed a set of electricity (distribution) service standards and a service quality monitoring system. In the electricity sector, the PSRC regulates a single privatized distribution licensee.','8,4'),(54,53,'The West Delta Project had been conceived as a groundbreaking transaction in which a private firm will Design-Build-Operate and Lease a surface water irrigation system to eventually serve a total area of around 255,000 feddans, of which around 47% is currently cultivated. The main driver of the project was to provide an alternative source of irrigation water to existing groundwater sources which were rapidly depleting, had increased salinity and were costly to extract.','4,9'),(55,54,'The World Bank and the Public Private Infrastructure Advisory Facility (PPIAF) wanted to know whether specialized, centralized Public Private Partnership (PPP) units contributed to the success of PPPs, and under what circumstances.','3,1'),(56,55,'Under a Gesellschaft für Technische Zusammenarbeit (GTZ)-funded program, the Water Sector Regulatory Board, a newly-established sector regulator, needed to develop regulatory procedures and guidelines to support and guide its responsibilities in the sector.','4,9'),(57,56,'Pacific Gas & Electric (PG&E), a large US electric utility, wanted to demonstrate to the Federal Energy Regulatory Commission (FERC) that costs claimed by power marketers did not offset refunds owned to PG&E as a result of the price spikes in the California electricity market during 2000-2001.','8,2'),(58,57,'The International Finance Corporation (IFC) wished to evaluate the success of the rural electrification program in Uganda. The IFC wanted a thorough analysis of technical, financial, institutional and regulatory barriers to private sector investment in rural electrification, as well as project-specific barriers.','8,4'),(59,58,'The Government of Armenia wished to develop Output Based Aid (OBA) arrangements to facilitate the tender of a new lease contract for the Yerevan Water Supply Company. Castalia was engaged to develop the financial mechanisms and implementation guidelines for the OBA scheme, and recommend the level of subsidy.','4,9'),(60,59,'The Government of Azerbaijan sought to engage the private sector to operate the water and sewerage system for Greater Baku. This project sought to support the Transaction Advisory through regulatory and institutional advice.','4,9'),(61,60,'The World Bank wished to have guidance material and templates for Borrowers and World Bank staff on the procurement of management contract services in infrastructure (electricity and water and sanitation).','8,12,3,9'),(62,61,'Armenia’s Public Services Regulatory Commission (PSRC) needed a set of service quality indicators and a service quality monitoring system for its regulatory responsibilities in the water and sanitation sector.','4,9'),(63,62,'The World Bank wanted to document the process of power sector reform in Armenia and assess what benefits it had brought the country over a decade.','8,4'),(64,63,'A major Japanese electricity company was considering whether to build a Light Rail Transit (LRT) system in Japan, and wanted to know more about the experience with LRT in the United States.','8,3,1'),(65,64,'New Zealand’s state–owned, corporatized transmission company wanted to know what strategy it should pursue under new electricity regulatory arrangements in New Zealand. Under these new arrangements, and Electricity Commission, designed to function as an independent sector regulator would have to approve Transpower’s revenue requirement and pricing.','8,4'),(66,65,'As part of its ongoing tracking of United States nuclear regulatory practices, Japanese Ministry of Economy, Trade and Industry (METI) wished to understand the United States Nuclear Regulatory Commission (NRC) processes for strategic planning, budget planning, and self-assessment.','8,4'),(67,66,'A major forest products manufacturer in New Zealand needed advising on issues related to pricing of its long–term power purchase contracts and the merits of various electric regulatory and market models in predominantly hydro–electric systems like New Zealand','8,4'),(68,67,'The Government of Nigeria sought to increase access to electricity in rural and un-served areas of the country (95% of the country). In order to achieve this, the Government wanted a comprehensive rural energy policy, Rural Electrification Fund and Agency to distribute capital subsidies for rural electrification and increasing access to electricity in rural and un–served areas.','8,4'),(69,68,'The Government of Nigeria was working to establish a national electricity regulatory commission.','8,4'),(70,69,'The Government of Armenia had decided to extend the Armenian Energy Regulatory Commission’s authority to the water and sanitation sector. The Commission needed assistance in changing its institutional structure, amending sector laws and drafting new regulations to accommodate these new responsibilities.','8,12,4,9'),(71,70,'The Japanese Government’s Energy R&D Entity wanted to understand US and International Carbon Sequestration and New Generation Technologies programs.','8'),(72,71,'A large Japanese electric utility wanted to better understand the extent and nature of activity–based costing (ABC) and activity–based management (ABM) practices in the nuclear industry.','8'),(73,72,'A major electricity distribution company was undergoing one of its first tariff revision with the national electricity regulator, the Agência Nacional de Energia Elétrica (ANEEL).','8,4'),(74,73,'Mr. Hankinson forecast all–in cost of service for a utility until 2005. Responsible for adapting pre–existing probabilistic forecasting model to relevant U.S. energy market.','8,6'),(75,78,'Mr. Hankinson worked as part of a team determining the revenue requirement for a newly privatized distribution company in Brazil. He collected and analyzed client’s data, and drafted section of report on rate base calculation.','3'),(76,81,'Mr. Hankinson advised the newly created Andhra Pradesh Electricity Regulatory Commission (APERC) in Hyderabad. He provided on–site training and support for APERC’s economic and financial staff as they prepared for the state’s first tariff revision of an electricity distribution company.','8,4'),(77,82,'Mr. Hankinson worked as part of a team calculating the revenue requirement for Brazil’s largest distribution company, in anticipation of the company’s first tariff filing with national regulator. Responsibilities included collection and assessment of data; development of a model to calculate approximate revenue requirement for various test years; development of revenue requirement for notional revision period; sensitivity analysis using various parameters (test year, O&M cost methodology, cost of capital methodology, capital structure, rate base valuation method, treatment of non–concession activities); and assessment of results from a regulator’s perspective','3,4'),(78,83,'Brazil’s national electricity regulatory, the Agência Nacional de Energia Elétrica (ANEEL), needed to develop a comprehensive approach for determining tariffs of distribution companies.','8,4'),(79,84,'Mr. Hankinson used the Capital Assets Pricing Model (CAPM), Discounted Cash Flow Modeling (DCF), and the Comparative Earnings Method to estimate the return on equity for a major electricity distribution utility in Brazil','8'),(80,86,'Mr. Hankinson conducted an analysis of various states’ policies on treatment of an acquisition premium in electricity tariffs. He briefed an expert witness and drafted portions of expert testimony on these topics.','8,4'),(81,92,'For Brazil’s new electricity regulator (ANEEL), Mr Hankinson worked as part of a team calculating the return on equity for the regulator’s first tariff revision of a distribution company (Escelsa) after privatization.','8,4'),(82,93,'A private project developer client asked Black & Veatch to assess the Solar Renewable Energy Credit markets in the northeastern U.S. in order to decide which market it should enter.','8,4,6'),(83,94,'A large utility client asked Black & Veatch to forecast Renewable Energy Certificate prices in U.S. states with renewable portfolio standards in the WECC.  The client used this forecast to determine which REC markets they should enter with their renewable energy resources.','8,3,4,5,6'),(84,95,'As part of the California Renewable Energy Transmission Initiative, the State of California asked Black & Veatch to identify cost trends in solar PV installations over the past few years.','8,3'),(85,96,'The National Renewable Energy Laboratory asked Black & Veatch to provide technical assistance to a large scale transmission planning project.','8,5,6'),(86,97,'The Utah Geological Survey asked Black & Veatch to quantify developable renewable energy resources within the state and develop a screening level transmission planning tool to assist the state in planning high voltage transmission lines.','8,5'),(87,98,'Major investor-owned utilities periodically asked Black & Veatch to review procurement bids from renewable energy project developers.','8,3,5'),(88,108,'Museo de Plantas Sagradas Mágicas y Medicinales is a private project headed by the Director of the Perú Global Heritage Fund, Alejandro Camino, which was to be opened for the first time in the summer of 2011.','7,3'),(89,110,'The Armenia Renewable Resources and Energy Efficiency Fund (R2E2) wanted to prepare a renewable energy investment plan, which would be used to apply for funding through the Climate Investment Funds Scaling Up Renewable Energy Program (SREP). The objective of the Investment Plan was to bring together all prior analyses of renewable energy carried out in Armenia, and carry out more in-depth resource and financing modeling to identify the best renewable energy options in Armenia. The project would involve the assessment of the potential for developing the following renewable resource options: wind power, solar PV and solar thermal power, geothermal power, biomass, landfill gas, wastewater treatment plant gas, biomass, and solar thermal and geothermal heating. It would also involve working with a diverse set of national and international stakeholders from industry, academia and government to choose renewable energy options for investment.','8,5,6'),(90,111,'The World Bank requested a power sector policy note for Armenia. This document will help guide the World Bank\'s and the Armenian Government\'s strategy in the country\'s power sector. The objective of the note is to identify specific challenges facing Armenia’s power sector, including an emerging power supply gap, threatened energy security, and increasingly unaffordable electricity tariffs.','8,4,6'),(91,112,'MasterCard has historically had a passive and reactive relationship with regulators worldwide. In 2012, the company recognized the merit of collaborating with governments, an agenda which was exclusively assigned to the Vice Chairman. The company launched an initiative in 2012 to focus on improving government relations with select priority countries through business initiatives that affect public policy.','3,1,4'),(92,113,'The new strategy required that the MasterCard Government Services and Public Policy teams travel to each of the 10 priority countries to meet with stakeholders and respective country executive leadership. The teams collectively reached a consensus on the high impact public-private partnerships to be established.','3,1,4'),(93,114,'Pakistan has been facing its worst energy crisis which has shaved off close to half of its GDP growth. Urban households deal with this problem by installing Uninterruptable Power Systems (UPS), which provide back-up power during blackouts.','8'),(94,116,'Emergence BioEnergy is run by Dr. Iqbal Quadir, one of the pioneers of social entrepreneurship and the Director of MIT’s Legatum Center for Innovation and Entrepreneurship. Emergence was in the product-development phase of creating a distributed off-grid generator for usage in rural Bangladesh.','8'),(95,117,'Citibank is considered to be the leader in product development in the banking industry of Pakistan.','4'),(96,119,'Pakistan had been witnessing one of the worst energy crises in its history. This caused an influx of investment into the electricity infrastructure industry, while WAPDA, the Government-owned utility, underwent structural changes.','8'),(97,120,'As per internal policy, Citibank’s Corporate Bank revised industry lending covenants every year.','3,4'),(98,121,'ADB intended to make a loan to improve energy efficiency of the Takhiatash thermal power plant (TPP) through the adoption of energy efficient technology that would contribute to increased reliability of power supply and climate change mitigation. The Project included construction of a 280 MW (nominal size) combined cycle gas turbine (CCGT) power plant, decommissioning of inefficient existing power plant units, and capacity development. As part of this work, ADB wanted an assessment of the institutional, legal and regulatory environment for the power sector in Uzbekistan, and an assessmnt of Uzbekenergo\'s capacity, including its financial management practices.','8,4,6'),(99,122,'Existing pricing policies for natural gas and district heating services in Ukraine are poorly designed and create high explicit and implicit subsidies, which have negative consequences for the Government and the overall economy. The World Bank wanted to prepare a publishable report, which highlighted these challenges and provided recommendations for better targeting and delivery of subsidies.','13,4'),(100,123,'The power sector of the Kyrgyz Republic faces many financial and operational challenges that are expected to increase in severity in future years. The World Bank wanted an assessment of the most important challenges to the sector in the coming years, and recommendations on how best to address those challenges.','4,6,8'),(101,2,'The Asian Development Bank (ADB) financed an ambitious investment and technical assistance program in Ulaanbaatar. The program aimed to promote an inclusive peri-urban development in the ger areas (informal settlements) of Ulaanbaatar, by supporting the socioeconomic development of urban subcenters located in those areas. The program included physical investments in extensions and upgrades to water supply, wastewater collection and district heating infrastructure, and technical assistance in 1.) supporting urban governance, livelihood, and socioeconomic activities through better land use planning, and better access to financing 2.)  improving of the performance of urban service providers; and 3.) reforming legal, regulatory and institutional frameworks for urban service provision.','8,13,4,1,6,14,9'),(104,124,'Japan’s New Energy and Industrial Technology Development Organization needed help to produce a comprehensive report on recent trends in the US solar PV market. This included a market size analysis, as well as an evaluation of the legal and regulatory environment for solar technologies in the US.','8,4,5'),(106,125,'The Kyrgyz Republic currently does not have a defined methodology for setting power and heating tariffs for sector companies and end-users, or for enforcing indicators of the financial and operational performance of sector companies. The absence of tariff-setting and performance monitoring and enforcement frameworks has resulted in a lack of financial viability and poor service quality in the power and heating sectors of the Kyrgyz Republic.  The World Bank requested the development of a tariff methodology to remedy these issues.   ','13,8,4'),(108,126,'Japan’s New Energy and Industrial Technology Development Organization (NEDO) needed an assessment of the laws and regulations governing the development of on and offshore wind in the United States, including an analysis of federal, state and local laws and regulations.','5,8,4'),(109,127,'Japan’s New Energy and Industrial Technology Development Organization (NEDO) requested a report on geothermal regulations at the state and local level, using the State of California as a case study. NEDO wanted to know how water code regulations affected the development of geothermal resources and also what additional regulations applied to geothermal resources found in lands managed by the National Park Service (NPS), the National Forestry Service (NFS) or an Indian Tribe.','5,8,4'),(110,128,'Japan’s New Energy and Industrial Technology Development Organization (NEDO) requested a report describing the current state of the biomass power market in the US.','5,8,4'),(112,130,'The ADB wanted detailed designs for a new bridge...','7'),(113,131,'The Asian Development Bank wanted a design for a new bridge...','7'),(114,131,'Alternative description for alternative pitch...','3'),(115,132,'The ADB wanted complete technical specifications for a new project in xyz....','7'),(116,132,'Alternative description for alternative pitch...','8'),(117,133,'The Asian Development Bank wanted to have a detailed design for xyz...','7'),(118,133,'ADB wanted a detailed design for a public private partnership project for xyz...','1'),(119,129,'The Asian Development Bank (ADB) requested the financial and economic design of the WSS reform program, along with the financial and economic analyses required to support these reforms. This analysis would involve the assessment of past donor projects and the assessment of the financial sustainability and economic viability of demonstration projects. The study would include a willingness-to-pay survey, which would be used as the basis to develop a new tariff and subsidy mechanism. ADB also requested assistance in preparing an Asset Ownership Plan, which would determine ownership and management of rural WSS assets. Once the reform program design was complete, the final piece of the project would be to deliver the basic training required to operationalize the new rules, regulations and approaches.\n','9'),(120,9,'The Department of Energy (Department) within the Ministry\nof Economy (Ministry) is charged with creating a framework for sustainable\ndevelopment of the energy sector in Macedonia. The Energy Agency of the\nRepublic of Macedonia (EARM) is an agency under the Ministry which focuses on\nthe promotion of indigenous energy sources and energy efficiency. The Ministry\nasked the World Bank for advice on what functions it should fulfill in the energy\nsector; how well it is fulfilling these functions; and how to better perform those\nfunctions it is not carrying out as well as it could. The Ministry specifically wanted\nadvice on how to best organize and build capacity in the Department and EARM\nin order to better prepare them to undertake these functions.','8,4,5'),(121,10,'The Government of Mongolia wanted to improve service quality and\ncost recovery of multi-utilities that provide water, sewerage, heating, and solid\nwaste disposal services in Mongolia’s provincial capitals. The Asian Development\nBank (ADB) asked for recommendations on how the Government could achieve these goals by adopting alternative institutional arrangements for delivery of these services.','8,13,4,1,14'),(122,134,'The Asian Development Bank wanted xyz...','13,3'),(123,134,'ADB wanted xyz.... (alternative description)...','12,6'),(124,135,'The company was asked by ADB to prepare detailed designs....','12,1'),(125,135,'The company advised on a PPP related to...','5,6'),(126,136,'Dev',NULL),(127,137,'The Caribbean Telecommunications Union (CTU), with support of the World Bank, requested terms of reference for consultancy services for the design, preparation and implementation of a regionally-harmonized policy and institutional framework for open access and PPP based on international good practice, existing national policies, and institutional strengths and gaps, appropriate to the likely scale of PPP programs in OECS territories.   awareness and consensus building among a wide group of stakeholders in CARCIP participating countries regarding the use of PPP to develop infrastructure, and on the proposed PPP frameworks; the establishment and strengthening of institutions needed to implement the Framework - including the development and implementation of a capacity-building program, with a view to building and strengthening PPP networks.','1,10'),(128,138,'Belarus relies heavily on imported energy resources (mostly natural gas from Russia) to meet domestic energy demand. In 2009, the cost of natural gas imports constituted 5.2 percent of GDP. While still below the European market prices, import prices of natural gas have been increasing sharply over the last 5 years, as a result, the cost of district heating services has also increased increasing the fiscal burden to the government. The objective of this project was to understand the incidence of current energy subsidies in Belarus, to estimate the poverty and social impacts of proposed tariff and subsidies reform, and to identify and strengthen mechanisms to mitigate negative impacts of tariff increases.','13,4'),(129,139,'DHInfrastructure was asked to assess the effectiveness of all World Bank loans and technical assistance to the sector during that time period, and the consistency of outcomes with World Bank objectives for the country. Our report served as a chapter in a comprehensive IEG assessment of World Bank support to Georgia.','8,3'),(130,141,'The Ministry of Energy and Natural Resources (MENR) informed the IFC and World Bank team that the Government and the Public Service Regulatory Commission (PSRC) are currently discussing the tariff-setting principle for those small hydropower plants (SHPPs) for which the mandatory off-take period of 15-years at the Feed-In Tariff (FIT) approved by PSRC will shortly expire. The MENR suggested that the FIT for the above SHPPs should be revised in a way to avoid excessive profits by those SHPPs given that the current FIT includes recovery of capital cost. The World Bank and IFC teams would prepare a short note for the MENR to inform their thinking on the issue.  The objective of this assignment was to prepare an analytical piece with estimates of the cost structure of SHPPs which have been in operation for more than 15 years, and to provide recommendations on whether changes to the current uniform FIT for SHPPs are required for such plants.\n','8,4,5'),(131,143,'There is an increasing recognition by Governments in the Western Balkans of the need to address a number of long-standing issues in the power sector. One of the key constraints to implementing important reforms in the region is the lack of cost-reflective network tariffs and end-user tariffs. The existing price levels, which do not adequately reflect the cost of service provision, cannot support new generation investments, either by attracting private investors or by providing domestic utilities with the means to invest on their own.  For the purpose of assessing the financial viability of the power sector, The World Bank requested a comprehensive financial analysis of the power sector in the Western Balkans.','8,4'),(134,145,'The Government of Vanuatu needed assistance with the preparation of a renewable energy investment plan, which would be used to apply for funding through the Climate Investment Funds Scaling Up Renewable Energy Program (SREP). The objectives of the Investment Plan were to bring together all prior analyses of renewable energy carried out in Vanuatu, and to carry out more in-depth resource and financing modeling to identify the best renewable energy options in Vanuatu. The project involved the assessment of the potential for developing the following renewable resource options: wind power, solar PV and solar thermal power, geothermal power, biomass and biofuels, solar-based microgrids and pico solar. It also involved working with a diverse set of national and international stakeholders from industry, academia and government to choose renewable energy options for investment.','8,5,6'),(135,146,'IFC hired DHInfrastructure to conduct a review of the operations of the Southeast Europe Infrastructure Advisory (SEIA) and Europe and Central Asia Infrastructure Advisory (ECA IA) donor funded programs that it manages. DhInfrastructure performed an objective external assessment of the life cycle of the two programs in terms of their operations, organization, project work and business development efforts. The evaluation provided a substantiated opinion on the programs’ additionality in the region and outlined lessons learned about the workings and organization of similar donor funded programs. The review presented a critical analysis of the potential continued need of such programs in the Europe and Central Asia region. ','8,12,3,1,11,14'),(137,147,'WB asked us to do....','13,8'),(138,150,'IFC needed a consulting firm to conduct a review of the operations of the Southeast Europe Infrastructure Advisory (SEIA) and Europe and Central Asia Infrastructure Advisory (ECA IA) donor funded programs that it manages. To this extent, IFC and the respective Donors (Ministry of Finance of Austria, Ministry of Foreign Affairs of Norway and the Swiss State Secretariat for Economic Affairs) wanted to perform an evaluation of the performance of both programs, based on the OECD-DAC criteria of relevance, efficiency, effectiveness, impact, sustainability, and the IFC criterion of additionality. The main objective of this review was to provide lessons learnt that will generate actionable recommendations for IFC and the Donor governments on whether support for these programs should be continued past their expiry in 2015.','8,3,1,14'),(139,151,'asdfsadassada','8'),(140,153,'The Asian Development Bank requested assistance in the preparation of the energy sector assessment, strategies, and roadmaps (ASR) to better harmonize ADB\'s support program and project planning in Armenia. ADB needed an analysis of energy sector performance, challenges and opportunities and an assessment of the Government\'s strategy for the energy sector. In addition, ADB wanted an analysis of its sector experience and assistance program, and the construction of a sector results framework which would highlight the causal relationship between current constraints, challenges and sector targets, so as to better identify areas for future ADB input. ','8,5'),(141,154,'Water and wastewater tariffs in Armenia are very low and do not cover operating and maintenance (O&M) expenditures or provide sufficient funds to adequately deal with asset rehabilitation. Consequently, there are looming concerns about the long-term sustainability of service provision by existing public-private partnership (PPP) arrangements. The World Bank Group (WBG) requested assistance in developing a water sector tariff study for Armenia to assess the levels of the current water and wastewater tariffs in terms of cost-recovery.  The World Bank wanted a description of a number of tariff scenarios, taking into account financial, economic, efficiency and equity objectives.  Lastly, a plan of actions would be developed to move from the current tariff levels and structure to an agreed future tariff level and structure.','4,9'),(142,155,'dfdff','8'),(143,155,'xcvxc','12'),(144,156,'The World Bank requested a least cost power supply study for Georgia. The objective of the least-cost plan was to inform the Government on options for meeting future domestic and export power demand. The world Bank wanted several supply portfolios to be considered for the least-cost plan. The supply portfolios would take into account the existing hydropower potential in Georgia as well as other supply options such as CCGT, renewables, energy efficiency, and imports. The least cost plan would be determined by ranking each supply portfolio according to Long-Run Average Incremental Costs (LRAIC) and net present values. The final report would then provide the Government with a better understanding of the generation supply requirements in the coming years, along with a least cost plan for meeting these requirements, and a tariff impact analysis.','8,6'),(145,157,'The energy landscape in the Western Balkans has been in a complex and challenging state in the past three decades and no clear systematic picture of those challenges currently exists. The objective of this project was to identify key energy issues and constraints which require country-specific and regionally-coordinated interventions in the Western Balkans. ','5,8,13,4'),(146,158,'The Asian Development Bank (ADB) requested the preparation of reform options for greater private sector participation in Timor Leste’s power sector. This would require examination of the current policy framework governing Timor-Leste\'s power sector, including legislative and contractual arrangements defining the sector\'s structure and operations, and would highlight constraints to the expansion of reliable and sustainable electricity service to consumers at least cost. Moreover, options for PPP in the power sector needed to be examined, taking into consideration conclusions from the policy framework assessment, experience in Timor Leste, international case studies and a preliminary market sounding. The final result would be recommendations to MPS for the establishment of systems and practices for feasibility work including appraisal of projects and suitability for public-private partnerships.','8,1,4,6'),(147,171,'Actualmente la República de Kirguistán no tiene una metodología definida para establecer las tarifas de electricidad y calefacción urbana para las compañías del sector y los usuarios finales o para imponer indicadores de rendimiento financiero y operativo de las compañías del sector. La ausencia del establecimiento de tarifas, la monitorización del sector y los marcos de cumplimiento obligatorio, ha resultado en una falta de viabilidad financiera y una pobre calidad de servicio en los sectores eléctricos y de calefacción de la República de Kirguistán.',NULL),(148,172,'Las tarifas de agua y de agua residual en Armenia son muy bajas y no cubren los gastos operativos y de mantenimiento (O&M) ni proporcionan los fondos suficientes para afrontar adecuadamente la rehabilitación de activos. En consecuencia, hay preocupaciones inminentes acerca de la sostenibilidad a largo plazo de la provisión del servicio según los acuerdos existentes de asociación público-privada (APP).',NULL),(149,173,'Hay un creciente reconocimiento por parte de los Gobiernos de los Balcanes Occidentales acerca de la necesidad de corregir ciertos problemas que datan de tiempo atrás en el sector eléctrico. Una de las restricciones clave a la hora de implementar importantes reformas en la región es la falta de tarifas de red que reflejen los costos y de tarifas para los usuarios finales. Los niveles de precio existentes, que no reflejan adecuadamente el coste en la provisión de servicios, no pueden lidiar con las inversiones de la nueva generación, ya sea atrayendo a inversores privados o proporcionando infraestructuras domésticas con la finalidad de que inviertan por ellos mismos. ',NULL),(150,170,'Vector, as a signatory to the Gas Industry Company (GIC) (New Zealand\'s Gas Regulator) \nwanted to contribute to discussions on development of gas pipeline balancing rules. \nVector needed assistance to identify options, undertake analysis of the options, and \nprepare a discussion paper for internal discussion and submission to the GIC.','8,4'),(151,174,'El sector energético de Armenia le hace frente al desafío de asegurar el suministro de electricidad, salvaguardar la seguridad energética y hacer que el suministro de electricidad sea asequible para el consumidor, y a su vez mantener la sostenibilidad financiera del sector. El Banco Mundial quería determinar los niveles de las tarifas actuales de electricidad en términos de recuperación de costos, y recomendó mejoras en la estructura de la tarifa para así poder garantizar un uso eficiente de la electricidad en Armenia.',NULL),(152,169,'Vector sought to develop proposals on transmission capacity allocation and pricing, for submission to the Gas Industry Company (GIC) (New Zealand\'s Gas Regulator). The task included canvassing views from throughout the organisation, identifying and analysing options, and drafting a discussion paper for internal discussion and submission to the GIC. ','8'),(153,175,'El ministerio de energía y recursos naturales (MENR según sus siglas en inglés) informó a los equipos del IFC y del Banco Mundial que el gobierno y la Comisión Reguladora del Servicio Público (PSRC según sus siglas en inglés) se encuentran actualmente debatiendo la fijación de tarifas para aquellas pequeñas plantas hidroeléctricas para las cuales el período de extracción de 15 años, para la medición neta de tarifa (FIT según sus siglas en inglés) aprobada por el PSRC, terminará pronto. El MENR opina que el FIT para los siguientes SHPPs debería ser revisado para evitar beneficios excesivos por parte de esos SHPPs dado que el FIT actual incluye el coste de recuperación del capital. Los equipos del Banco Mundial y del IFC prepararán una nota breve para el MENR para dar a conocer su opinión sobre el tema. El objetivo de esta tarea era la de preparar una pieza analítica con cálculos del coste de estructura de los SHPPs que han estado operativos durante los últimos 15 años, y a la vez dar recomendaciones sobre si se tendría que cambiar el FIT uniforme actual para los SHPPs de dichas plantas. ',NULL),(154,168,'The Commission requested assistance with two main tasks: 1.) Development of Individual Price-Quality Path (IPP) Regulation to be applied to Transpower and and Default Price-Quality Path (DPP) Regulation to be applied to  network companies, and 2.) Development of a grid investment framework to be applied to large transmission investments. ','8,4'),(155,176,'Bielorrusia depende en gran medida de la importación de recursos energéticos (principalmente gas natural ruso) para satisfacer la demanda nacional de energía. En 2009, el coste de las importaciones de gas natural constituía el 5,2 por ciento del PIB. Si bien todavía por debajo de los precios del mercado europeo, el precio de importación del gas natural ha aumentado considerablemente en los últimos 5 años, y como resultado, lo ha hecho también el coste de los servicios de calefacción de los distritos, incrementando así la carga fiscal para el gobierno. El objetivo de este proyecto fue conocer la incidencia de los subsidios actuales en la energía en Bielorrusia, para así estimar la pobreza y el impacto social de la propuesta de reforma de las tarifas y los subsidios, y para identificar y fortalecer los mecanismos para mitigar los impactos negativos debido a los incrementos tarifarios. Con este objetivo, DHInfrastructure realizó un análisis del almacenamiento en el sector de calefacción urbana e incorporó todas las tareas pendientes en un informe final para el Banco Mundial. ',NULL),(156,167,'Transpower sought assistance with developing a price-quality path projection, based on historical expenditure and performance (including benchmarking), capital and operating and maintenance expenditure strategies and plans, for submission to the Commerce Commission.','8,4'),(157,177,'Las actuales políticas de precios del gas natural y los servicios de calefacción de los distritos en Ucrania están mal diseñadas y crean altos subsidios, tanto explícitos como implícitos, que tienen consecuencias negativas para el gobierno y la economía en general. El Banco Mundial quería preparar un informe que pusiera en relieve estos desafíos y se formularan recomendaciones para una mejor focalización y administración de los subsidios. ',NULL),(158,166,'The Electricity Authority sought project management and technical services to support renegotiation of the legacy service provider agreement between itself and the Transmission Grid Operator. The system operator contract is worth approximately NZD40 million per annum. ','8,4'),(159,165,'Following \"dry\" hydro years in 2001 and 2003, the Electricity Commission established Reserve Energy Arrangements aimed to ensure security of supply in such years. In 2006, it sought an independent review of the arrangements. The project included the following tasks: 1.) determine the optimal level of supply security for New Zealand; 2.) determine whether it is likely that this level of supply security will be delivered by the market; 3.) identify and analyse alternate arrangements that may enable the supply security standard to be achieved; and 4.) consult with stakeholders with regard to the recommended approach.','8,4'),(160,164,'Transpower sought advice regarding the adequacy of existing and projected generation capacity to meet generation and reserve requirements in the medium term.','8,4'),(161,178,'DHInfrastructure trabajó en estrecha colaboración con el Departamento de Asociación Público-Privada (PPP) y con el de Concesiones (también conocido como la unidad de APP) en el Comité de Bienes del Estado (CPE), lo que proporciona una amplia capacitación en la preparación de las transacciones y los  procesos de licitación. ',NULL),(162,163,'The Electricity Commission undertook a Potentials study, following which it sought to procure \"Negawatts\". ','8,4'),(163,162,'A major generator-retailer in the New Zealand market contracted Castalia to undertake some cost, price and margin benchmarking for its retail business.','8'),(164,179,'El Banco Asiático de Desarrollo (ADB según sus siglas en inglés) financió los servicios de asesoría de transacciones para apoyar al gobierno de Mongolia en la realización de recomendaciones de reformas institucionales en el sector de los servicios urbanos. Como parte de las reformas, el gobierno solicitó a las empresas operadoras del sector privado que proporcionaran servicios de agua y saneamiento en los aimags de Omnogovi y de Dornogovi y estableció un organismo regulador nacional independiente para los servicios de agua y saneamiento. La mejora de la prestación de servicios urbanos es especialmente importante en Omnogovi y Dornogovi porque se espera que la población de estos aimags se duplique en los próximos diez años como resultado de una mayor actividad económica a causa del comercio minero y la actividad transfronteriza con la República Popular de China. La infraestructura existente es inadecuada aún hasta para suministrar el servicio a las poblaciones actuales. ',NULL),(165,161,'New Zealand was facing a significant increase in grid-connected wind generation, and the Electricity Commission was concerned about the implications of this for dispatch, quality and security. The project, which utilised wind engineers, power system engineers, and other technical experts, involved undertaking studies into the potential issues (scheduling, dispatch, pricing, voltage stability and frequency management) to determine the likely magnitude of each, and identifying, analysing, and recommending options to address the issues. ','8,4'),(166,160,'The IFC requested that Castalia prepare a tariff application to the Pakistan electricity regulator for Pakistan’s first wind farm. ','8,4,5'),(167,159,'Following the Californian Electricity Crisis, FERC assessed payments between purchasers and sellers through the refund process. Castalia was engaged to review the filings made by the sellers to FERC, and support the expert witness with preparation of opposing  testimony for Pacific Gas and Electric, for submission to FERC','8,4'),(168,180,'El sector energético de la República de Kirguistán se enfrenta a diversos desafíos operativos, de los que se espera que incrementen su intensidad en los próximos años. El Banco Mundial quería realizar una evaluación de los desafíos más importantes del sector para los próximos años y recomendaciones sobre cuál era la mejor manera de afrontar tales desafíos.',NULL),(169,181,'El Fondo de Recursos Renovables y Eficiencia Energética de Armenia (R2E2 según sus siglas en inglés)le solicitó ayuda a DHInfrastructure en la preparación de un plan de inversiones en energía renovable, que se utilizará para solicitar financiación a través del Programa Scaling Up de Fondos de Inversiones en Energías Renovables (PAER según sus siglas en inglés). El objetivo del Plan de Inversiones era el de reunir todos los análisis previos de energías renovables llevados a cabo en Armenia y llevar a cabo una mayor modelización de recursos y de financiación para identificar las mejores opciones en energía renovable en Armenia. El proyecto consistió en la evaluación del potencial para el desarrollo de las siguientes opciones de energía renovable: energía eólica, energía solar fotovoltaica y energía solar térmica, energía geotérmica, biomasa, gases de vertedero, gases de plantas de tratamiento de aguas residuales, de biomasa y de calefacción térmica y geotérmica. También incluyó el trabajo con un conjunto diverso de actores nacionales e internacionales de la industria, la comunidad científica y el gobierno para elegir opciones de energía renovable factibles para la inversión. ',NULL),(170,182,'El Banco Asiático de Desarrollo (ADB) contrató a DHInfrastructure para realizar los análisis financieros y económicos necesarios para apoyar la reforma del agua y del saneamiento y el diseño de todos los aspectos financieros y económicos del programa de reforma. El ADB le solicitó a DHInfrastructure que analizara el rendimiento de los proyectos de los donantes del pasado para evaluar la sostenibilidad financiera y la viabilidad económica de los proyectos de prueba. DHInfrastructure diseñó y administró una encuesta sobre la disposición a pagar, y con base en esta información desarrolló un nuevo mecanismo de tarifas y subsidios. ADB también solicitó ayuda en la preparación de un plan de la propiedad de activos, lo que determinaría la titularidad y la gestión de los activos de agua y saneamiento rural. También se requiere que, en colaboración con el ADB, se proporcione la formación básica necesaria para poner en práctica las nuevas normas, reglamentos y enfoques. ',NULL),(171,183,'El Banco Mundial contrató a DHInfrastructure para preparar una nota sobre el sector energético de Armenia. Este documento servirá de guía a la estrategia en el sector energético del país propuesta por el Banco Mundial y del Gobierno de Armenia. El objetivo de la nota es el de identificar los desafíos específicos a los que se enfrenta el sector energético de Armenia, incluyendo una brecha emergente en lo que corresponde a la alimentación del sector, la amenaza en la seguridad energética y las inasequibilidad creciente de las tarifas eléctricas. El Banco Mundial le solicitó a DHInfrastructure que identificara y analizara los problemas y los obstáculos a los que se enfrenta el sector energético de Armenia, y que recomendara acciones para superarlos. Para este proyecto, DHInfrastructure preparó una actualización de las previsiones de la demanda de electricidad y desarrolló un plan de suministro de energía de menor costo, que incluía una evaluación de los impactos de este plan en los aranceles de los usuarios finales. DHInfrastructure también realizó una revisión de los obstáculos y las prioridades de inversión en la red de transmisión de Armenia. ',NULL),(172,184,'El Banco Mundial quería llevar a cabo una Revisión del Gasto Público (PER) en el sector energético de la República de Kirguistán, como parte de un proyecto más amplio cuyo objetivo es la identificación de las formas en las que el Gobierno de la República de Kirguistán puede lograr la consolidación fiscal. El Banco le solicitó a DHInfrastructure que ofreciera recomendaciones para mejorar la sostenibilidad de los ingresos y los gastos del sector energético y la eficiencia en la prestación del suministro energético. ',NULL),(173,185,'El Banco Asiático de Desarrollo (ADB según sus siglas en inglés) le solicitó a DHInfrasturcture que aconsejara al gobierno de Nauru en materia de la reforma del sector público (electricidad, agua, suministro de combustible), dada su poca confiabilidad, su pobre calidad del servicio y su dependencia en donantes externos. Todos los servicios están actualmente bajo el control directo del Ministerio de Comercio Industria y Medio Ambiente. DHInfrastructure redactó una nota sobre la política para el gabinete de Nauru, el asesoramiento sobre las opciones de reforma más viables, incluyendo asociaciones público-privadas (APP) y la forma de ponerlas en práctica.',NULL),(174,186,'The Asian Development Bank (ADB) requested as-needed support to various national government bodies in developing the policy framework for PPPs in China and to local governments in structuring transactions.','1'),(175,187,'The Asian Development Bank wanted to support government of Nauru in improving financial, operational and governance performance of the Nauru Utilities Corporation (NUC) through institutional strengthening reforms. The assignment specifically supports: 1.) the development of an asset management and maintenance plan; 2.) the implementation of a new asset management system that supports the financial management information system; 3.) the implementation of a performance management system for non-managerial NUC staff; and 4.) a review of the corporate governance of the organization. ','8,4,9'),(176,188,'The World Bank had requested a report for the government of Belarus, for the recommendation of financing and delivery options for scaling-up energy efficiency investments in thermal retrofits and heating system upgrades in residential and public buildings. The assignment consists of four parts: 1.) a stocktaking of the legal, regulatory, and institutional environment and characteristics of the building sector including management, ownership, and financing procedures; 2.)  an assessment of potential for energy efficiency improvements and investment needs; 3.) an analysis of the barriers and potential solutions to investment and 4.) development of a road map and areas for donor involvement. ','13,8,5'),(177,189,'The World Bank conducted a comprehensive heating assessment for the urban building sectors in the Kyrgyz Republic and Tajikistan and to identify viable heating options and related energy efficiency measures to help meet heat demand in urban residential and public buildings.','5,8,13,4'),(178,190,'ADB wanted to provide technical assistance to Mongolia\'s PPP Unit in its new location (and under new leadership) in the Ministry for Economic Development, and more generally provide training on PPPs to the newly-elected Government.','1'),(179,191,'Tom Stevens, a professor at the University of Massachusetts Amherst had an interest in conducting research about consumer willingness to pay for native pollinated produce.  This study was meant to add to prior research about consumer preferences regarding pollination and bee health.  ','3,4'),(180,192,'The USDA Economic Research Service (ERS) wanted to assess the economic impacts of the proposed Food Safety Modernization Act rules on the domestic and international produce industry.  This assessment was to be done through evaluations of the domestic and international produce supply chains, existing policies and regulations, and current and potential capacity for certification and enforcement.  ','4'),(181,193,'Milford Water Company (MWC) petitioned the DPU for a general rate increase of $3,817,870 (82.7 percent). A major factor for filing this case was the installation of a new water treatment plant that represented a $20,839,558 addition to rate base.','4,9'),(182,194,'Bay State Gas Company requested an increase in base rates for the second year in a row because it argued that its current rate structure did not allow for a reasonable opportunity to earn its permitted rate of return.  As a solution to its earning deficiency the Company proposed to create a regulatory asset for the recovery of depreciation, interest, and tax costs incurred on leak-prone pipe replacement projects between the in-service date and when the Company begins earning a recovery on the addition.  The Company also proposed six months of post-test year plant additions in order to account for the additional regulatory lag resulting from an extension of the DPU’s statutory rate suspension period from six to ten months.','8,4'),(183,195,' National Grid Electric Company submitted to the DPU for approval of its annual Revenue Decoupling Mechanism (RDM) filing.  National Grid’s RDM is based on a comparison of benchmark revenue per class to actual billed revenue per class.  In addition, the Company’s RDM filing also requested approval for its 2013 Capital Expenditure Factor (CapEx) that allows for recovery of certain additions to utility plant in 2012. ','8,4'),(184,196,'As part of a prior settlement agreement with the Attorney General of Massachusetts, WMECo agreed to file a new rate design aimed at aligning customer distribution rates closer to equalized rates of return.  The change in distribution rates coincided with a permanent reduction in one of the Company’s reconciling mechanisms that allowed for the increase in distribution rates of some customers without an overall increase in their total bill.  The need for a distribution rate realignment was due to the Company’s prior base rate proceeding in which rates were set for some customers below equalized rates of return leading to cross-subsidization between classes.  ','8,4'),(185,197,'Bay State Gas Company requested a $29.2 million rate increase from the Department.  The Company\'s proposal included the use of a future test year, modifications to an existing capital tracker, and updates to its decoupling mechanism.','8,4'),(186,198,'National Grid Gas requested Department approval to acquire $550 million in new long-term debt. The company requested flexible terms in order to quickly enter the market and capture the benefits of existing low interest rates.','8,4'),(187,199,'ADB wanted assistance with supporting the Central Asia Regional Economic Cooperation (CAREC) in several activities, including developing key documents guiding the organizations operations, supporting activities of the CAREC Energy Sector Coordinating Committee (ESCC), and assisting with the implementation of the 2013-2015 Energy Work Plan (EWP). ','8,4'),(188,200,'The World Bank wanted to update the results of a supply options study for Kosovo, which DHInfrastructure completed in 2011. The project team updated the supply options model and evaluated supply options under various sensitivities.','8,6'),(189,201,'The Government of Ukraine recently increased gas and heating tariffs. In order to protect the most vulnerable households, more comprehensive reform of social assistance programs is needed, especially since gas and heating prices will see further increases in the medium term to bring them to cost recovery levels. The World Bank has been tasked to help the government with these reforms, with the public information campaigns to explain the benefits of the reforms to the population, and with regulatory reform necessary to ensure that gas and heating tariffs remain reflective of the costs.','13,4'),(190,202,'A Municipal Light Plant (MLP) in Massachusetts wanted to hire a third-party to operate its municipally-owned, broadband network. ','1,10'),(191,203,'The Government of Bangladesh needed assistance with the preparation of a renewable energy investment plan, which would be used to apply for funding through the Climate Investment Fund’s Scaling Up Renewable Energy Program (SREP). The objectives of the Investment Plan were to bring together all prior analyses of renewable energy carried out in Bangladesh, and to carry out more in-depth resource and financing modeling to identify renewable energy projects where SREP resources and other sources of funds could be used to overcoming existing barriers preventing investment. The project involved the assessment of the potential for developing the following renewable resource options: wind power, solar PV, small hydropower, geothermal power, biomass and biogas, solar-based microgrids, solar home systems, and solar irrigation pumps. It also involved working with a diverse set of national and international stakeholders from industry, academia and government to choose renewable energy options for investment.','5,8,6'),(192,204,'The Asian Development Bank is providing a grant to the Government of Timor Leste for the Dili Urban Services Improvement Sector Project. As part of the proposed investment project, ADB asked DHInfrastructure to conduct a contingent valuation study to assess household willingness to pay for improved water supply and solid waste disposal services. The analysis will be used to determine if financially sustainable tariff levels are in line with willingness to pay for service improvements. ','9');

--
-- Table structure for table `projects_staff`
--

CREATE TABLE `projects_staff` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `services_provided` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=452 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects_staff`
--

INSERT INTO `projects_staff` VALUES (9,3,1,'Project Manager','As part of the first stage of this work DHInfrastructure\'s Denzel Hankinson led a series of 40 interviews with the Treasury PPP Unit, government line departments, and private sector project developers, financiers, and transaction advisors. He was the principal author of a report summarizing those interviews, and a report recommending how best to accelerate PPPs in infrastructure. In the second phase, Mr. Hankinson managed the team that offered South Africa a recommendation on the organization and functions of its PPP Unit based on comparisons of the organization, staffing and functions of similar units in a number of countries. He recommended a split between the Unit’s regulatory and technical assistance functions, and the creation of a new entity to take on the technical assistance function. His team provided a rationale for the new organizational structure, and recommended the legal form of the new entity, its organizational structure, source of funding, indicative budget, and draft job descriptions.'),(10,4,1,'Project Director','Denzel directed this project. He analyzed data on the costs and benefits of current and planned initiatives to improve energy efficiency in Russia and estimated the net benefits of various energy efficiency policies and initiatives. He then ranked those areas of potential improvement that have the greatest importance and value to Russia. He also recommended a plan of action for Russian policymakers, local authorities, multi-lateral lenders, and the private sector to support improvements in energy efficiency in the areas identified as priorities'),(11,5,1,'Project Director','Denzel analyzed changes in government support, private sector involvement, and expert opinion of the leading production technologies and feedstocks in light of fluctuations in oil prices, new US leadership, and changes in the US economy.'),(12,6,1,'Project Director','Denzel developed a model to calculate the economic and financial viability of energy efficiency investments in a range of sectors. He also recommended changes to policies and regulations the Government could implement to improve energy efficiency.'),(13,7,1,'Project Manager','Denzel\'s work focused on estimating the influx of non-miners to areas surrounding the mine, and the scale and cost of housing, utilities and social services needed to accommodate that influx. He reviewed international mining experience with influx, and developed a model to estimate the scale and cost of infrastructure needed to accommodate population growth in the region. He also suggested options for institutional and financial arrangements to ensure the necessary infrastructure is provided.'),(14,8,1,'Electricity Expert','Denzel advised on the design of the impact evaluation, surveys, and an output-based subsidy mechanism for new electricity connections.'),(15,9,1,'Project Director','Denzel met with key members of the Department and EARM to discuss the functions and responsibilities of each unit. He advised the Ministry on improvements to the way staff and work are organized in the DOE and the functioning of the EARM. He provided the Ministry with key recommendations for the next steps in developing the capacity of the two units. The recommendations were based on international best practice examples.'),(16,10,1,'Project Manager','Denzel advised ADB and the Government on service delivery arrangements used elsewhere in the world, and recommended an arrangement that best fits the legal, financial, and economic context in Mongolia.'),(17,11,1,'Project Manager','Denzel managed the team that was reviewing the 2005 Transfer Plan, including the legal and financial basis for it. The team developed recommendations for a new Transfer Plan, and model legal documents for implementing the new Plan.'),(18,12,1,'Project Director','Denzel directed this project, which included informing NEDO on: developments in US Government R&D programs, changes to R&D funding, and new technologies advancing in national laboratories, universities and the private sector. The analysis was informed by an extensive survey of public and private sector views on research and development trends in the industry.'),(19,13,1,'Institutional Specialist','Denzel served as the institutional regulatory specialist for this project, analyzing barriers to scale-up of investment in renewable and other forms of energy generation, and recommending legal, institutioanl and regulatory changes required to remove the barriers.'),(20,14,1,'Project Director','Denzel analyzed regulatory bottlenecks to Smart Grids at the federal and state levels, analyzed market segmentation of Smart Grid companies, and wrote several case studies on Smart Grid projects and technologies.'),(21,15,1,'Project Director',''),(22,16,1,'Project Manager','Denzel suggested options for services and service levels to be covered by the USF and the institutional arrangement, administration; and revenue generation mechanism of the Fund based on international experience, Armenian policy and law; and the current state of the telecommunications market in Armenia.'),(23,17,1,'Regulatory Expert','Denzel advised on options to improve water and waste water services. He presented different institutional and tariff arrangements that resulted in improved performance in other countries.'),(24,18,1,'Project Director','Denzel managed this project. He developed a program evaluation methodology and collected data from project documents and stakeholder interviews. He conducted in person interviews and site inspections in the three focus countries. The final report provided SECO with key lessons in order to help improve the relevance, effectiveness, efficiency and sustainability of future projects in the energy sector.'),(25,19,1,'Project Director','Denzel used historic load growth data and data on potential investments in new generation to forecast new capacity needs in Armenia. The model also estimated the resulting cost-recovery generation tariff based on the combination of possible new generation. Mr. Hankinson used this model to identify challenges and possible solutions in the energy sector in the short- to medium-term.'),(26,20,1,'Project Director',''),(27,21,1,'Project Director','Denzel oversaw all research and analytical work on this project'),(28,22,1,'Project Director','Denzel drafted a regional report summarizing the various country reports and surveys.'),(29,23,1,'Team Leader/Energy Economist','Denzel analyzed the impact of the financial crisis on electricity demand, private and public capital flows into the sector, operating and capital expenditures, and the cost of financing. Denzel used this analysis to identify financing gaps in the electricity sector and the associated economic costs (Published here: http://publications.worldbank.org/index.php?main_page=product_info&cPath=1&products_id=24110).'),(30,24,1,'Project Director','Denzel reviewed the project characteristics, analyzed why the previous transaction process did not succeed, reviewed the relevant regulations in Mongolia, recommending different PPP modalities and risk allocations, presented their advantages and disadvantages, and helped the Government to reach a decision.'),(31,25,1,'Project Director','Denzel drafted a policy note for Nauru’s Cabinet, advising on the most viable reform options, including Public Private Partnerships (PPPs), and how to implement them.'),(32,26,1,'PPP Institutional Expert','Denzel managed the preparation of a comprehensive PPP Handbook for Mongolian government agencies, as well as a capacity building, and business plan for the country\'s PPP unit. He also conducted training sessions for the PPP unit on PPP transaction tender and preparation. '),(33,27,1,'Project Director','Denzel helped to prepare expert testimony to FERC on behalf of PG&E. As part of this work, he analyzed bidding strategies used by power marketers’ and generators’ when selling into the California Independent System Operator and Power Exchange (CAISO-PX).'),(34,28,1,'Project Director','Denzel: i) reviewed the existing legal, institutional and regulatory framework in the three countries, ii) identified major legal, institutional and regulatory constraints in the region, and iii) identified policy and regulatory interventions that would be necessary to promote regional trade and integration in the short- and medium-term.'),(35,29,1,'Project Director/Municipal Infrastructure Finance Expert','Denzel directed all activities on this project, led the training, and was principal author of the appraisal manual.'),(36,30,1,'Project Director','Denzel led the team in preparing a report that analyzed possible options for implementing consumer-end heat metering in Ukraine. The analysis demonstrated how the cost of heat metering options affected the average heating tariff. Denzel used this analysis to assess the impact of heat metering on customer affordability and the financial sustainability of heat service provision.'),(37,31,1,'PPP Trainer','Denzel delivered four 90-minute long workshops, and facilitated several other workshop presentations. Mr. Hankinson’s workshops focused on structuring PPP options, PPPs in regional power sector exchanges, and pricing of PPP projects.'),(38,32,1,'Project Director','Denzel advised on a range of institutional, legal, and regulatory changes, which included improvements to existing performance contracts between Ulaanbaatar and the water and sanitation providers, and steps required for the eventual implementation of a lease contract in the sector.'),(39,33,1,'Project Director','Denzel advised on the development of the conceptual framework, prepared a survey of experts in the energy efficiency field, and analyzed the correlation between project costs and other factors thought to be “drivers” of transaction costs.'),(40,34,1,'Project Director','Denzel estimated the levelized energy cost (LEC) of each option, as well as the levelized average incremental cost (LRAIC) in economic terms. He also developed a detailed supply model which simulated hourly economic dispatch on Kosovo’s system.'),(41,35,1,'Team Leader/Utility Expert','Denzel managed the creation of a comprehensive asset register for NUC, and the development of key performance indicators (KPIs)  for inclusion in staff performance contracts. Denzel also worked closely with NUC\'s CEO and senior management to draft a corporate strategy.'),(42,36,1,'Project Director','Denzel used estimates of the cost of providing generation, transmission, distribution, settlement, and system operation services to calculate the short-run and long-run marginal cost of electricity in Armenia. He used time differentiated results of short-run marginal cost to recommend an optimal time-of-use tariff structure that promotes efficient consumption.'),(43,37,1,'Project Director','Denzel led the team to evaluate the economics of power sector infrastructure inefficiencies in terms of lost load and technical and commercial losses. The evaluation included cost of demand side energy inefficiency and energy losses through gas flaring. It described and quantified economic impact of these challenges and provided potential solutions to overcome them.'),(44,38,1,'Project Director','Denzel assessed the relevance and effectiveness of MHR project activities. He advised on the effectiveness of regulatory reforms; the approach, quality, and utility of energy audits; and the thoroughness of municipal energy plans as well as how well municipalities in Ukraine complied with those plans. As part of this work, Mr. Hankinson visited MHR project sites in five municipalities of different sizes both in the east and the south of the country. At the end of the project, he delivered an Evaluation Report that presented key findings and recommendations to USAID.'),(45,39,1,'Project Director','Denzel directed all of the work under this project.'),(46,40,1,'Project Director','Denzel directed the comparison of the economic and financial viability of the conceptual plant to the cost of Armenia’s other supply options to determine the plant’s viability in the context of Armenia’s power supply.'),(47,41,1,'Service Reform Specialist','Mr. Hankinson directed the comparison of the economic and financial viability of the conceptual plant to the cost of Armenia’s other supply options to determine the plant’s viability in the context of Armenia’s power supply.'),(48,42,1,'Utility Reform Specialist/Team Leader','Denzel led the transaction advisory team and oversaw all aspects of the project, including the structuring of the PPP arrangement, preparation of tender documents, evaluation and award of the project, negotiation of the contract, and advice on legal and regulatory reform. For the new Water Services Regulatory Commission (WSRC), he drafted a tariff policy, service quality guidelines, and a licensing regulation. He also provided extensive in-house training on water and sanitation tariff-setting methodologies, service quality monitoring and licensing.'),(49,43,1,'Project Director','Denzel directed the project work, including research and analysis for this project, as well as the preparation and presentation of the Draft and Final Sector Assessment, Strategy and Road Map for each country to the Asian Development Bank team.'),(50,44,1,'Project Director','Denzel directed the comprehensive review and assessment of past, current, and projected direct fiscal support and indirect quasi-fiscal deficits, lending and guarantees, as well as the structural factors contributing to these direct and indirect public financial obligations to the sector. He led an internal team to develop a consolidated financial model for the sector to assess the efficient cost of service and the financial performance of sector entities. Based on this analysis, he made recommendations for addressing the financial obligations to the sector, in line with the objectives of medium term fiscal consolidation.'),(51,45,1,'Project Director','Denzel directed and oversaw all work for this project.'),(52,45,4,'Project Manager and Renewable Energy Specialist','Joshua conducted a comprehensive literature review of scholarly papers on best practices in renewable energy policy development. He also moderated focus groups and in-depth one-on-one interviews with international renewable energy specialists to determine the best practices in renewable energy policy, law and regulation in developing countries around the world. He used all of this information to draft a set of renewable energy indicators that were vetted by renewable energy investors and developers before these indicators were incorporated into the RISE index.'),(53,37,4,'Senior Analyst','Joshua analyzed the efficiency of the current electricity generating fleet, the forecast balance of electricity supply and demand and the demand-side energy efficiency issues. This analysis will be used to produce strategic recommendations for the World Bank on ways it can assist Uzbekistan in overcoming its energy sector challenges.'),(54,40,4,'Project Manager','Joshua compared the economic and financial viability of the conceptual plant to the cost of Armenia’s other supply options to determine the plant’s viability in the context of Armenia’s power supply.'),(55,27,4,'Data Analyst','Joshua supported the preparation of expert testimony on behalf of PG&E. He built a database of electric market bid data and was using the database to identify economic withholdings of power marketers during the crisis.'),(56,44,2,'Project Manager','Lauren carried out a comprehensive review and assessment of past, current, and projected direct fiscal support and indirect quasi-fiscal deficits, lending and guarantees, as well as the structural factors contributing to these direct and indirect public financial obligations to the sector. She developed a consolidated financial model for the sector to assess the efficient cost of service and the financial performance of sector entities. Based on this analysis, she made recommendations for addressing the financial obligations to the sector, in line with the objectives of medium term fiscal consolidation.'),(57,43,2,'Project Manager','Lauren managed this project. She was responsible for preparing the Draft and Final Sector Assessment, Strategy and Road Map for each country.'),(58,39,2,'Project Manager','Lauren helped to develop a model that estimated the electricity generation capacity required to meet domestic demand based on historic load growth data and data on potential investments in new generation. The model also estimated the resulting cost-recovery generation tariff based on the combination of possible new generation. Results from the model helped to demonstrate financial and supply security challenges facing Armenia’s energy sector in the short- to medium-term. (http://siteresources.worldbank.org/ARMENIAEXTN/Resources/010912_01_eng.pdf)'),(59,36,2,'Project Manager','Lauren used estimates of the cost of providing generation, transmission, distribution, settlement, and system operation services to calculate the short-run and long-run marginal cost of electricity in Armenia. She used time differentiated results of short-run marginal cost to recommend an optimal time-of-use tariff structure that promotes efficient consumption.'),(62,33,2,'Senior Analyst','Lauren helped develop a conceptual framework for estimating the “transaction costs” of EE projects. She also developed and disseminated a user-friendly survey using Survey Monkey to gain World Bank staff opinion on transaction cost drivers.'),(63,30,2,'Project Manager','Lauren led the team in preparing a report that analyzed possible options for implementing consumer-end heat metering in Ukraine. The analysis demonstrated how the cost of heat metering options affected the average heating tariff. Lauren used this analysis to assess the impact of heat metering on customer affordability and the financial sustainability of heat service provision.'),(64,29,2,'Project Manager','Lauren developed a detailed appraisal manual for TDF staff. She prepared financial appraisals of roughly 10 water and sanitation sector projects in small towns. To help build TDF’s capacity to conduct appraisals, she developed a model that analyzes the financial viability of the projects given different tariff scenarios. The model also determines the minimum average tariff and block tariff structure required for financial viability and includes various sensitivity analyses to show how the minimum required tariff changes under different cash flow and financing scenarios.'),(65,28,2,'Project Manager','Lauren identified major legal, institutional and regulatory constraints in the region and in each of the countries’ power sectors that prevent regional electricity market development. This included assessing how transmission and distribution tariff methodologies discourage efficient pricing of traded electricity. She also identified policy and regulatory interventions, including tariff reform, that would be necessary for promoting regional trade and integration in the short and medium term.'),(66,27,2,'Project Manager','Lauren analyzed bidding strategies used by power marketers’ and generators’ when selling into the California Independent System Operator and Power Exchange (CAISO-PX).'),(67,22,2,'Senior Analyst','Lauren provided an overview of the existing legal and policy framework for energy efficiency in these countries. She also analyzed survey data to identify key issues for SME’s regarding energy efficiency.'),(69,19,2,'Senior Analyst','Lauren helped develop a model that estimated the electricity generation capacity required to meet domestic demand based on historic load growth data and data on potential investments in new generation. The model also estimated the resulting cost-recovery generation tariff based on the combination of possible new generation. Results from the model helped to demonstrate financial and supply security challenges facing Armenia’s energy sector in the short- to medium-term. (http://siteresources.worldbank.org/ARMENIAEXTN/Resources/010912_01_eng.pdf)'),(70,16,2,'Senior Analyst','Lauren analyzed international practice, Armenian policy and law, current demand for telecommunication services, and the state of the telecommunications market in Armenia. She used this analysis to help recommend the services and service levels to be covered by the USF and the institutional arrangement, administration; and revenue generation mechanism of the Fund.'),(71,14,2,'Senior Analyst','Lauren analyzed regulatory bottlenecks to Smart Grids at the federal and state levels, analyzed market segmentation of Smart Grid companies, and wrote several case studies on Smart Grid projects and technologies.'),(72,12,2,'Analyst','Lauren managed this project. Her work included informing NEDO on: developments in US Government R&D programs, changes to R&D funding, and new technologies advancing in national laboratories, universities and the private sector. Her analysis was informed by a survey of public and private sector views on research and development trends in the industry.'),(73,9,2,'Project Manager','Lauren helped map the Department and EARM’s current responsibilities and tasks. She also researched the characteristics of energy departments and energy agencies in EU and EU accession countries, including: size, organizational structure, market structure, and functions.'),(74,8,2,'Senior Analyst','Lauren analyzed hotel survey and utility data in Zanzibar during the pre-cable activity period to show how the new subsea cable would impact hotel and utility operational performance.'),(75,11,2,'Analyst','Lauren analyzed the Water Act and the Transfer Plan identifying areas of conflict between the two legal documents. She used this analysis to help develop recommendations for a new Transfer Plan.'),(76,6,2,'Analyst','Lauren recommended attractive investment options for improving energy efficiency in Armenia. Ms. Pierce researched relevant examples of government initiatives to promote economically and financially viable investments in energy efficiency. She used these international cases to assist in recommending changes to policies and regulations the Government could implement to improve energy efficiency.'),(77,5,2,'Analyst','Lauren assisted in analyzing changes in government support, private sector involvement, and expert opinion of the leading production technologies and feedstocks in light of fluctuations in oil prices, new US leadership, and changes in the US economy.'),(78,4,2,'Analyst','Lauren helped develop a model that analyzed the technical, economic, and financial potential for improving energy efficiency in Russia. Through research of barriers to energy efficiency throughout the world and government efforts to overcome those barriers, Ms. Pierce assisted in recommending policy and regulatory action the Russian Government could take to improve energy efficiency. These international case studies also helped to demonstrate areas where Russia could learn from international experience.'),(79,44,6,'Analyst','Jessica carried out a comprehensive review and assessment of past, current, and projected direct fiscal support and indirect quasi-fiscal deficits, lending and guarantees, as well as the structural factors contributing to these direct and indirect public financial obligations to the sector. She developed specific and detailed reform recommendations for addressing these looming financial obligations, in line with the objectives of medium term fiscal consolidation.'),(80,42,6,'Analyst','Jessica assisted in the development of the project methodology and managed the organization of project tasks.'),(81,40,6,'Analyst','Jessica conducted supporting research and analysis of geothermal generation technologies and possible geothermal sites in Armenia.'),(82,45,7,'Project Manager and Energy Efficiency Specialist','Joshua was the energy efficiency specialist for the project. He managed the development and refinement of the energy efficiency indicators, involving extensive literature review and input from sector experts. In collaboration with the Sustainable Energy Department at the World Bank, Mr. Morrison coordinated 3 private sector focus groups to solicit feedback on the indicators in Washington DC, Kenya, and New Delhi. Mr. Morrison also managed the implementation of a desk pilot of the initial set of 48 renewable energy, energy efficiency and energy access indicators in 6 countries, involving key-informant interviews with investors in each sector.'),(83,34,3,'Analyst','Brendan developed the forecast and hourly dispatch models used in the analysis. He also researched supply options for generation in Kosovo. '),(84,27,3,'Economic Analyst','Brendan supported the preparation of expert testimony on behalf of PG&E. He built database models to identify economic\nwithholding of power marketers and estimated a competitive price for electricity that would have been consistent with a market free of manipulation.'),(85,23,3,'Analyst','Mr. Larkin-Connolly analyzed the impact of the financial crisis on electricity demand, private and public capital flows into the sector, operating and capital expenditures, tariffs, and the cost of financing.'),(86,21,3,'Lead Analyst','Brendan prepared a report for the utilities that focused on how the American Recovery and Reinvestment Act (ARRA) affected Smart Grid. The influx of funding in Smart Grid provided by ARRA has affected the plans of utilities, regulators, and manufacturers alike. The report also included a review of the current market for smart grid technology and existing barriers preventing investment.'),(87,19,3,'Forecast Analyst','Brendan modeled electricity demand in Armenia using advanced regression techniques. The demand model was used to forecast electricity growth until 2030 as well as peak demand over this time forecasts were used to assess the potential of several generation options for meeting demand.'),(88,18,3,'Lead Analyst','Mr. Larkin-Connolly was in charge of developing all research and analysis procedures. He collected quantitative and qualitative data from project documents and stakeholder interviews. He used the collected data to create logframes for each of SECO’s project in order to clarify objectives and results.'),(89,14,3,'Lead Analyst','Brendan was the primary author of this report. Mr. Larkin-Connolly’s analysis included a summary of smart grid technologies, the benefits of a modern power grid, and government policy supporting implementation. In order to provide NEDO with a detailed account of current industry conditions Mr. Larkin-Connolly interviewed multiple industry leaders of the public and private sector. He also completed a survey of all Smart Grid projects in the planning stages or already in development.'),(90,6,3,'Analyst','Brendan compiled a dataset of energy use by country and formed a forecasting model to predict the potential benefit and cost of multiple sector specific energy efficiency initiatives in Armenia.'),(91,5,3,'Lead Analyst','Brendan was the primary author of this update of a similar report prepared by DHInfrastructure in 2008. Mr. Larkin-Connolly’s analysis included a survey of changes in the ethanol industry in 2008. The review included the effects of bio-fuel production, new production technologies, and recent government and state policy. This analysis also included a survey of the status of cellulosic ethanol commercial feasibility.'),(92,4,3,'Analyst','Brendan researched International examples of barriers to energy efficiency. He contributed case studies of potential solutions to energy efficiency, these solutions included: demand side management, energy service companies, energy efficiency labels, metering, loan guarantees, and targeted subsidies. In addition, Mr. Larkin-Connolly completed an extensive review of the value chain of the Russian energy sector and created a flow diagram documenting the potential for efficiency across all sectors.'),(93,36,6,'Analyst','Jessica supported the project by researching, analyzing and comparing various subsidy mechanisms in terms of coverage and targeting of the poor, administrative and fiscal costs and the level of economic distortion resulting from each subsidy delivery option. She also researched financing mechanisms for generation asset that could be applied in Armenia to reduce tariff shocks resulting from large investments.'),(94,8,6,'Analyst','Jessica supported this project by conducting research on energy usage patterns in Tanzania.'),(95,35,6,'Analyst','Jessica assisted in the development of NUC’s corporate strategy in various capacities, including consolidating work done by the Accounting and Asset Valuation Specialist, the Human Resources Specialist and the Utility Expert, creating and administering of a survey to determine key substantive components of NUC’s strategy as well as digitally designing the Corporate Strategy document.'),(96,43,4,'Project Manager','Joshua supported the research and analysis for this project, as well as preparing the Draft and Final Sector Assessment, Strategy and Road Map for each country.'),(97,35,4,'Analyst','Joshua assisted in the development of NUC\'s corporate strategy in various capacities, including consolidating work done by the Accounting and Asset Valuation Specialist, the Human Resources Specialist and the Utility Expert, creating and administering of a survey to determine key substantive components of NUC\'s strategy as well as digitally designing the Corporate Strategy document.'),(99,32,4,'Project Manager','Joshua oversaw the development of a report that provided an in-depth listing and description of the relevant laws and regulations governing wind energy development in the US.'),(101,37,2,'Senior Analyst','Lauren analyzed challenges facing the sector related to: legal and regulatory environment, demand-side energy inefficiency, export competitiveness, and regional integration.'),(102,34,2,'Senior Analyst','Lauren researched key assumptions used in the levelized energy cost (LEC) calculation. She also audited the calculations of the financial and economic of various generation options.'),(103,25,2,'Senior Analyst','Lauren drafted a policy note for Nauru’s Cabinet, advising on the most viable reform options, including Public Private Partnerships (PPPs), and how to implement them.'),(104,32,2,'Senior Analyst','Lauren analyzed a range of institutional, legal, and regulatory changes, which included improvements to existing performance contracts between Ulaanbaatar and the water and sanitation providers.'),(105,24,2,'Senior Analyst','Lauren supported by reviewing project characteristics, regulations in Mongolia, and analyzing the advantages and disadvantages of different modalities'),(106,23,2,'Project Manager','Lauren analyzed the impact of the financial crisis on electricity demand, private and public capital flows into the sector, operating and capital expenditures, tariffs, and the cost of financing.  Based on this analysis, Ms. Pierce identified financing gaps in the electricity sector and the associated economic costs. (Published here: http://publications.worldbank.org/index.php?main_page=product_info&cPath=1&products_id=24110).'),(107,18,2,'Senior Analyst','Lauren helped draft the final report, which provided SECO with key lessons in order to help improve the relevance, effectiveness, efficiency and sustainability of future projects in the energy sector.'),(108,17,2,'Senior Analyst','Lauren helped to advise on options to improve water and waste water services, including possible changes to the institutional arrangement in the sector. As part of this work, Ms. Pierce analyzed a draft of the new water law in Mexico and advised on whether the proposed law would achieve the intended sector reforms. This work involved recommendations for tariff increases, tariff restructuring, and subsidization of low income customers.'),(109,13,2,'Senior Analyst','Lauren developed an overview of the institutional and regulatory structure of the sector. She also helped analyze historical and current data on the track record of payments and the Government of Kenya’s future debt service requirements regarding external debt financing in the electricity sector.'),(110,10,2,'Senior Analyst','Lauren prepared case studies reviewing international experience in reforming the delivery of basic urban services, in particular drinking water and sewerage. The review explores viable reform options for the water and sewerage sector in Mongolia.'),(111,7,2,'Analyst','Lauren developed over twenty cases of international experience in mining and categorizing them into four recruitment and settlement models. She used influx data from these cases to estimate influx scenarios for South Gobi. She also helped develop a model to estimate the capital cost of housing, utilities and social services infrastructure needed to accommodate that expected influx.'),(112,16,3,'Analyst','Brendan had surveyed international experiences with universal service funds in order to present PSRC with different service options. He assisted on the drafting of requirements for universal service obligations. He estimated costs of installing the recommended service bundle using a set of cross-sectional data from other rural telecommunication projects in the region.'),(113,17,3,'Analyst','Brendan conducted a survey of the organizational structure and regulatory policies of water services at the state-level. As part of a review of Water Service Providers (WSP) in each state he evaluated the financial performance of each WSP based on collection efficiency, tariff recovery level, and operating costs.'),(114,13,3,'Lead Analyst','Brendan completed an analysis of the existing debt of the major energy sector participants. He also prepared a detailed report of existing internationally financed projects in Kenya\'s energy sector.'),(115,7,3,'Lead Analyst','Brendan surveyed international experience with population influx to mining regions; researched estimates for the cost of infrastructure; and built a model to forecast infrastructure needs based on population and type of dwelling.  He created multiple diagrams and written briefs to demonstrate current infrastructure and mining projects in Mongolia and also provided incite into a possible solution for infrastructure provision using case studies of Subic Bay, Philippines and Misima Island, Papa New Guinea.'),(116,10,3,'Analyst','Brendan wrote case studies on different service delivery arrangements used elsewhere in the world. These cases were presented to ADB and the Government of Mongolia as potential arrangement options.'),(117,25,3,'Analyst','Brendan researched the experience of utility reform on other small island countries. He developed case studies of countries that implemented each of the proposed reform options.'),(118,11,3,'Analyst','Brendan reviewed the 2005 Transfer Plan and helped identify barriers that had prevented its success. He also helped develop recommendations for preventing these barriers in new Transfer Plan.'),(119,46,1,'Project Manager','Mr. Hankinson managed a team that offered South Africa a recommendation based on comparisons of the organization, staffing and functions of PPP Units in a number of countries. He recommended a split between the Unit’s regulatory and technical assistance functions, and the creation of a new entity to take on the technical assistance function. His Castalia team also provided a rationale for the new organizational structure, and recommended the legal form of the new entity, its organizational structure, source of funding, indicative budget, and draft job descriptions.'),(120,47,1,'a','Denzel was asked to assess the effectiveness of all World Bank loans and technical assistance to the sector during that time period, and the consistency of outcomes with World Bank objectives for the country. His report served as a chapter in a comprehensive IEG assessment of World Bank support to Georgia.'),(121,48,1,'Project Manager','Denzel led a series of 40 interviews with the Treasury PPP Unit, government line departments, and private sector project developers, financiers, and transaction advisors. He was the principal author of a report summarizing those interviews, and a report recommending how best to accelerate PPPs in infrastructure.'),(122,49,1,'Project Manager','Denzel managed this project for Castalia and had primary responsibility for advising the Ministry of Water and Environment and NWSC. His work included: clearly specifying the functional responsibilities of the AHA and the separate operating areas of NWSC; advising on changes to the system of Internally-Delegated Management Contracts (IDAMCs) currently used by NWSC, including how to broaden the use of private sector participation in the sector; reviewing of the current regulatory framework for the urban water and sanitation sub-sector, identifying gaps and overlaps and institutional responsibilities, and recommending measures to fill those gaps.'),(123,50,1,'Contributor','Denzel wrote chapters on the theory behind PPPs and the value to potential investors of a possible government guarantee fund.'),(124,51,1,'Project Director','Denzel was asked to recommend what the World Bank might do within the context of current lending to help the Government improve conditions in the water and electricity sectors. He analyzed the financial and operational conditions of NAWEC, GAMTEL and GAMCEL, and analyzed the legal, regulatory and contractual framework within which these companies operate. He also assessed the technical capacity and effectiveness of the Gambia Divestiture Agency (GDA), and recommended options for future World Bank lending to GDA to strengthen the divestiture program.'),(125,52,1,'Project Director','Denzel reviewed the existing service quality standards and recommended others that could be used. He recommended benchmark levels of performance for each service quality indicator, recommended how to set targets for each indicator, and recommended reporting requirements for the licensee. Denzel also provided recommendations on how to determine which investments were linked to service quality improvements.'),(126,53,1,'Regulatory/Institutional Expert','Denzel developed the contractual and institutional arrangements for regulating services provided and prices charged by the irrigation system operator.'),(127,54,1,'Project Manager','Denzel reviewed the experience of 10 countries with PPP units. He interviewed key stakeholders and individuals with PPP unit experience, developed an analytical framework for measuring the success of the PPP units. He used the analysis to draw lessons about how to best design PPP units in the future.'),(128,55,1,'Tariff/Service Quality Expert','Denzel developed national customer service guidelines, a tariff methodology, filing guidelines and reporting forms for the new regulatory body.'),(129,56,1,'Project Manager','Denzel helped prepare expert testimony to the Federal Energy Regulatory Commission (FERC) on behalf of PG&E. As part of this work, he analyzed submissions by a variety of power marketers and utilities of power purchase costs. He conducted an extensive analysis of marketers\' and utility trading books, and simulated dispatch using resource stacking analysis to determine which resources were used to serve native load and which were used to sell into the California Independent System Operator and Power Exchange (CAISO-PX).'),(130,57,1,'Regulatory/Institutional Expert','Denzel interviewed 12 developers and relevant government agencies, and conducted due diligence of the rural electrification projects, reviewing project developers’ business plans and feasibility studies. He identified power generation and independent grid projects for which a subsidy award could be made, and advised on the likely success of various transactions, identifying obstacles to financial closure. He also identified additional financial and institutional needs required to advance future projects, and drafted a terms of reference for follow-on work by transaction advisors.'),(131,58,1,'Project Manager','Denzel completed an initial design of the OBA arrangement and estimated the level of subsidy required. The affordability study showed that the level of subsidy required was quite low, and Denzel therefore recommended the subsidy fund be reallocated for areas outside of Yerevan.'),(132,59,1,'Institutional/Regulatory Advisor','Denzel drafted a note for the Government and the World Bank on reform options designed to specifically address the high level of losses in municipally-owned condominium complexes.'),(133,60,1,'Analyst','Denzel analyzed World Bank existing prequalification and bidding documents for other types of contracts, as well as existing management contracts used in Ghana, Lesotho, Gaza, Albania, Tanzania, and Armenia. He interviewed World Bank task managers, procurement staff, and private sectors operators who had been involved in these transactions to develop a view of best practice. He prepared generic cross-sectoral prequalification documents, generic cross-sectoral sample bidding documents, and a a set of technical notes for each sector.'),(134,61,1,'Project Manager/Regulatory Expert','Denzel managed a team of engineers and economists developing standards, procedures, and reporting forms for service quality monitoring. He also recommended a “twinning arrangement” with an EU multi–sector regulator, and provided training for PSRC staff on issues related to service quality monitoring and assessment of investment needs for service quality improvement.'),(135,62,1,'Project Director','Denzel prepared a comprehensive review and analysis of Armenian experience in reforming its energy sector and privatizing its power distribution company. The report identifies policy, regulatory, institutional, and financial factors which determined the outcome and progress of the reform process, analyzes the fiscal and economic impacts of the reform and its effect on other infrastructure sectors, and compares Armenia’s power sector reform with similar in other sectors, and in other countries. The report was published as a book in 2006 (“From Crisis to Stability in the Armenian Power Sector: Lessons Learned from Armenia’s Energy Reform Experience”, with Gevorg Sargsyan and Ani Balabanyan. World Bank Working Paper No. 74. 2006).'),(136,63,1,'Project Director','Denzel studied the benefits of LRT, and innovative schemes (including public private participation) used to finance light rail projects. He conducted a case study of LRT in Portland, Oregon, and evaluated the social potential benefits in terms of reductions in traffic fatalities, congestion, consumer transport expenditures, changes in real estate prices and other factors.'),(137,64,1,'Regulatory Expert','Denzel provided recommendations to Transpower regulatory staff on the company’s regulatory position with regard to the regulator’s proposals on asset base valuation, CAPEX program, cost of capital estimation, allocation of revenue requirement, and transmission rate structures.'),(138,65,1,'Project Director','Denzel interviewed NRC staff, reviewed NRC documents and prepared a brief for the Ministry on NRC practices.'),(139,66,1,'',''),(140,67,1,'Project Manager','Denzel managed the project to draft a rural energy policy and make detailed recommendations on the design and functioning of the Rural Electrification Agency and Fund.'),(141,68,1,'Project Manager','Denzel managed his company’s work on this project. He was responsible for quality control on the following tasks: 1.) identifying and addressing physical resource requirements; 2.) developing a financial management reporting system and 3.) developing an accounting and operational procedures manual and specifying requirements for IT systems.'),(142,69,1,'Project Manager','Denzel was responsible for the overall project management and lead client contact. He drafted a water sector tariff methodology and quality of service recommendations; and provided on–site training on various tariff issues and financial modeling. Mr. Hankinson also oversaw other aspects of the project work including recommendations for restructuring the Commission; requirements for staffing and other forms of organizational support; and adaptation of the legal and regulatory framework required to establish the authority of the Commission as a multi–sector regulator.'),(143,70,1,'Project Director','Denzel directed analysts in a comprehensive review of these programs, including a review of the FutureGen and Carbon Sequestration Leadership Forum initiatives.'),(144,71,1,'Project Director','Denzel conducted a survey, and prepared several case studies of ABC and ABM practices at utilities within the US and abroad. The survey included a focus on IT requirements for ABC/ABM implementation, and use of ABC/ABM in tracking maintenance costs and outside contractor costs.'),(145,72,1,'Tariff Specialist','Denzel worked as part of a team estimating the utility’s proposed rate base, cost of capital, and efficiency factor (X–factor).'),(146,73,1,'Tariff Specialist','Denzel forecasted all–in cost of service for a utility until 2005.  Responsible for adapting pre–existing probabilistic forecasting model to relevant U.S. energy market.'),(147,74,1,'Project Director','Denzel analyzed recent improvements at US nuclear generating plants, and drafted report on recent changes in the US Nuclear Regulatory Commission’s (NRC) regulatory mechanisms and philosophy for a major Japanese utility.'),(148,75,1,'Power Market Analyst','Denzel researched and analyzed historical trends in electricity capacity margins, supply reliability, and prices for a Midwestern utility’s FERC filing.'),(149,76,1,'Power Market Analyst','Denzel built a database model to calculate damages for alleged violation of power supply contracts with power marketer for a SERC utility. The modeling involved an extensive analysis of power marketer’s trading books in order to determine their forward purchasing strategies.'),(150,77,1,'Power Market Analyst','Denzel built a database and analyzed CAISO dispatch, meter, and price data for testimony filed in FERC’s west–wide power market price mitigation hearings.'),(151,78,1,'Tariff Specialist','Denzel worked as part of a team determining the revenue requirement for a newly privatized distribution company in Brazil. He collected and analyzed client’s data, and drafted section of report on rate base calculation.'),(152,79,1,'Project Manager','Denzel helped an internet–based consulting firm to develop a research and news service for Enron and Shell. Denzel managed team of analysts writing customized, “real–time” analysis, research briefs, and competitive intelligence for Enron and Shell. He wrote research reports on a variety of regulatory topics including: Analysis of bidding rules in Argentine electricity spot market; estimation of configuration and supply/demand balance of proposed US Federal Energy Regulatory Commission’s Regional Transmission Organizations, a review of trends in the regulatory treatment of local distribution companies uncollectibles/bad debt; and an analysis of the Ontario Electricity Board’s performance based rates regime.'),(153,80,1,'Project Manager','Denzel wrote a report on internet energy retailers’ marketing strategies and capabilities. He also managed a content database for “Enerfind”, and energy sector-specific internet search engine and knowledge management tool.'),(154,81,1,'Regulatory/Tariff Analyst','Denzel advised the newly created Andhra Pradesh Electricity Regulatory Commission (APERC) in Hyderabad. He provided on–site training and support for APERC’s economic and financial staff as they prepared for the state’s first tariff revision of an electricity distribution company.'),(155,82,1,'Tariff Analyst','Denzel worked as part of a team calculating the revenue requirement for Brazil’s largest distribution company, in anticipation of the company’s first tariff filing with national regulator. Responsibilities included collection and assessment of data; development of a model to calculate approximate revenue requirement for various test years; development of revenue requirement for notional revision period; sensitivity analysis using various parameters (test year, O&M cost methodology, cost of capital methodology, capital structure, rate base valuation method, treatment of non–concession activities); and assessment of results from a regulator’s perspective.'),(156,83,1,'a','Denzel was part of a team advising ANEEL on the tariff approach most appropriate for Brazil’s electricity distributors under a performance-based (revenue cap) approach. Denzel developed proposals for ANEEL’s regulatory treatment of rate base, cost of capital, and the efficiency factor (X–factor), and drafted a paper outlining and explaining, for distribution licensees, these proposals.'),(157,84,1,'Tariff Analyst','Denzel used the Capital Assets Pricing Model (CAPM), Discounted Cash Flow Modeling (DCF), and the Comparative Earnings Method to estimate the return on equity for a major electricity distribution utility in Brazil.'),(158,85,1,'Analyst','Denzel estimated the balance of supply and demand in the market for gas turbines for the government of a large Latin American country. He analyzed and evaluated various forecasts of world electricity demand and installed capacity growth. He also collected data on the country’s electricity sector, and assembled and edited the data deck for use in proprietary least cost optimization model.'),(159,86,1,'Analyst','Denzel conducted an analysis of various states’ policies on treatment of an acquisition premium in electricity tariffs. He briefed an expert witness and drafted portions of expert testimony on these topics.'),(160,87,1,'Analyst','Denzel analyzed the electricity demand and supply conditions in the Desert Southwest and assisted with the modeling of the power sector in the Western Systems Coordinating Council (WSCC). Using a proprietary optimization model, he worked with a team of consultants to produce a price forecast for the states in the various sub–regions of the WSCC. He also conducted research and analysis on the upstream oil and gas industry in the U.S., providing advice to the client on oil and gas price trends, and returns to exploration and production companies.'),(161,88,1,'Analyst','Denzel assisted with drafting expert testimony and preparing an expert witness for deposition in a case involving a disputed merger agreement between two U.S. utilities. He conducted research and analysis on issues of stranded cost recovery in state regulatory proceedings, and the effect of stranded cost recovery on utilities\' market values.'),(162,89,1,'Analyst','Denzel built a database of energy, capacity, and ancillary service markets in the northeast U.S. for the purpose of analyzing client\'s market power. The data and analysis were used for expert testimony in support of the client\'s market–based rates application to the Federal Energy Regulatory Commission (FERC).'),(163,90,1,'Tariff/Regulatory Analyst','Denzelworked as part of a team creating, and providing long–term support for, the Haryana Electricity Regulatory Commission (HERC) in Chandigarh.  Denzel\'s responsibilities included review of the enabling legislation, assistance in drafting regulations and licenses, implementation of on-site regulatory training, on-site consulting on power procurement, and development of the commissions’ fuel adjustment clauses.'),(164,91,1,'Analyst','Denzel conducted a research on the New England Power Pool’s (NEPOOL’s) congestion management procedures, and the Federal Energy Regulatory Commission’s (FERC’s) transmission pricing policies, in support of an expert report and testimony for litigation involving two large U.S. energy companies.'),(165,92,1,'Tariff Specialist','Denzel worked as part of a team calculating the return on equity for the regulator’s first tariff revision of a distribution company (Escelsa) after privatization for Brazil’s new electricity regulator (ANEEL).'),(166,93,4,'Lead Analyst','Joshua researched the historical prices, utility compliance levels, alternative compliance payment prices, and delivery and contracting requirements for SRECs in states in this region.  He was also responsible for developing an economic model to forecast the future prices of SRECs in states in the region.'),(167,94,4,'Lead Analyst','Joshua was responsible for developing and running an economic model to forecast REC prices across the WECC, based on cost of generation, energy and capacity values and transmission costs of different renewable energy resources across the region.'),(168,95,4,'Analyst','Joshua analyzed the economics and performance of hundreds of installed solar PV systems in California to identify cost trends.'),(169,96,4,'Lead Analyst','Joshua was the lead analyst in charge of quantifying and estimating the cost of hundreds of thousands of theoretically developable renewable energy resources in the western U.S.  His responsibilities also included working closely with public and private stakeholders to develop assumptions for the study, as well as presenting results to them on many occasions.'),(170,97,4,'Lead Analyst','Joshua developed a screening level Excel-based transmission planning tool to model the delivered cost and value to the grid of Utah’s renewable energy resources across the high voltage transmission system using VBA.  He also quantified and estimated the cost and performance of the underlying renewable energy resources that are theoretically developable in the state.'),(171,98,4,'Analyst','Joshua worked in a team of other analysts to review the technical, financial and permitting feasibility of dozens of solar thermal, solar photovoltaic and geothermal projects and advise the utilities on whether or not to procure energy from each project.'),(172,99,4,'Research Intern','Joshua identified, researched and developed new clients for Optimum’s building energy management software, including the Clinton Foundation, with which Optimum closed a deal because of his work.'),(173,100,4,'Research Intern','Joshua sized the market for Optimum’s technology in different regions of the U.S. using data from the Commercial Buildings Energy Consumption Survey.'),(174,101,2,'Intern','Lauren developed briefing material on ramifications of U.S. deportee policies on recipient countries in Latin America and the Caribbean.  Ms. Pierce analyzed effects on domestic intelligence, gang violence and economic stability in recipient countries.  Briefing material was used to inform Congressional members of Subcommittee.'),(175,102,2,'Intern','Lauren coordinated research and preparation for multi-committee hearing on involvement of two major U.S. companies in murders of two labor unionists in Colombia.'),(176,103,2,'Intern','Lauren wrote questions for a hearing on increases in gang-related violence in Central America and U.S.-led international efforts to curb the violence.  Questions were asked by the Chairman and Democratic members of the Subcommittee after hearing witnesses proceeding congressional testimony.'),(177,104,2,'Congressional Program Intern','Lauren planned a dinner between members of U.S. Congress and Colombian President.  Dinner discussion centered on possibility of U.S.-Colombia Free Trade Agreement and labor killings as well as guerilla violence in Colombia'),(178,105,2,'Congressional Program Intern','Lauren organized and wrote summary report of Congressional Members Working Group dinner topic and discussion.  Dinner topic concerned a policy paper addressed to foreign policy officials of Bush administration on the steps needed to mend diplomatic relations between the U.S. and Venezuela.'),(179,106,2,'Congressional Program Intern','Lauren organized a congressional staff briefing on developments in production and consumption of biofuels in the U.S.  Briefing compared corn-based ethanol to sugarcane-based ethanol and demonstrated to Congressional staff the potential benefits of joint U.S.-Brazilian cooperation on biofuels initiatives.'),(180,107,2,'Congressional Program Intern','Lauren organized Congressional Members Working Group dinner on international support needed to sustain Haiti’s fledgling government.  Dinner discussion with director of the UN Stabilization Mission in Haiti focused on security, drug trafficking, and lack of infrastructural development as crucial areas requiring sustained support.'),(181,108,6,'Intern','Jessica assisted the opening of the museum in multiple capacities including research, organizational assistance, and translation of exhibits from Spanish to English. Her research responsibilities included investigation of medicinal plants of the Andean region, economic and societal impacts of drug production, and shamanistic traditions of local indigenous peoples.  Jessica also actively participated in the promotion and marketing of the museum through local networking and the creation of promotional PowerPoints and a brochure in both English and Spanish. In addition, she developed a reference system for over 300 books.'),(182,110,1,'Project Director','Denzel led a team of national and international technical consultants to carry out the renewable energy resource assessment and the financial analysis of potential renewable energy resource options. He then led the team in building financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Armenia\'s future energy supply. As a final output, he led the team in developing a complete investment plan proposal, which involved identifying specific investment opportunities and also specifying the sources of funding for each of these opportunities.'),(183,110,4,'Project Manager','Joshua oversaw and directed the production of a comprehensive renewable energy resource assessment and analysis for Armenia, which involved estimating the resource potential and performance of solar, wind, geothermal, small hydropower technologies across the country. He then developed a financial model to evaluate and compare each renewable energy option under various financing scenarios. This financial analysis is expected to be used to inform renewable energy incentive policy in Armenia. Mr. Finn also created a trade-off analysis comparing renewable energy options to assist the Armenian Government and various donors such as EBRD, USAID and the World Bank in choosing renewable energy options for investment under SREP, and to guide Armenia’s renewable energy policy framework in the years to come.'),(184,110,6,'Analyst','Jessica conducted research and analysis in various capacities, including research on the legal, institutional and regulatory framework and historical supply and demand characteristics of the energy sector of Armenia. In addition, Jessica researched barriers to development of renewable energy in Armenia and potential measures to mitigate these barriers.'),(185,111,1,'Project Director','Denzel directed and managed the assessment of Armenia’s power sector for the World Bank, and recommended specific transmission system and power generation asset investments. This assessment will inform power sector policy making on the part of the Armenian Government, and the World Bank’s energy sector engagement strategy in the coming years. For this project, Mr. Hankinson directed the following pieces of analysis: an evaluation of the bottlenecks and investment priorities on Armenia’s power transmission system, the development of a least-cost power supply plan for the next 20 years and an assessment of the end-user tariff impacts of this plan, an assessment of recent costs and lead times for nuclear power options across the globe to inform Armenia’s decision to pursue a nuclear power plant.'),(186,111,4,'Project Manager','Joshua managed the assessment of Armenia’s power sector for the World Bank, and recommended specific transmission system and power generation asset investments. This assessment will inform power sector policymaking on the part of the Armenian Government, and the World Bank’s energy sector engagement strategy in the coming years. For this project, Mr. Finn directed the following pieces of analysis: an evaluation of the bottlenecks and investment priorities on Armenia’s power transmission system, the development of a least-cost power supply plan for the next 20 years and an assessment of the end-user tariff impacts of this plan, an assessment of recent costs and lead times for nuclear power options across the globe to inform Armenia’s decision to pursue a nuclear power plant.'),(187,111,6,'Analyst','Jessica investigated energy supply options to provide input to the least cost supply analysis. She researched recent international experience constructing and financing nuclear projects. As part of this work, Jessica also reviewed changes in Armenia’s power sector since 2010, including changes to energy policy as well as changes to generation, transmission and distribution infrastructure.'),(189,112,9,'Graduate Associate','Ahmed worked with the company’s Vice Chairman and the Group Executive of Government Services and Solutions to identify public and private stakeholders for potential public-private partnerships. Through research on influential stakeholders and using information from country-level management, Ahmed made recommendations for strategic partnerships in Colombia, Mexico, U.S.A and India.'),(190,113,9,'Graduate Associate','Ahmed provided support in the decision-making process by enhancing information quality through background research, and later devised a framework to be used by the country management to evaluate effectiveness of each initiative in improving government relations.'),(191,114,9,'Co-founder','Ahmed identified an opportunity to retro-fit solar panels to UPS devices in order to enhance their performance and to reduce the load on the over-burdened grid. Along with his co-founder, Ahmed performed market research in Pakistan, got a prototype developed and formed an alliance with the Ministry of Environment and the Alternate Energy Development Board.'),(192,115,9,'Co-founder','As the co-founder, Ahmed played an integral part in writing grants, business plans and proposals to raise money for market research. As a direct result of these efforts, the project won the Dow Sustainability Innovation Award, was the finalist in the Tufts $100k Social Business Plan Competition and semi-finalist in the $200k MIT Clean Energy Prize.'),(193,116,9,'Strategy Consultant','Ahmed carried out market research for the launch of this product in Pakistan.'),(194,117,9,'Assistant Manager','As the Country Product Manager at the Branchless Banking Unit, Ahmed was responsible for maintaining relationships with the regulatory body, The State Bank of Pakistan, on issues of pricing, customer service and legal aspects of a portfolio of products including Debit Cards, ATMs and Online Banking Platforms.'),(195,118,9,'Assistant Manager','As Assistant Relationship Manager, Ahmed had client-facing responsibilities in managing their portfolio of assets and liabilities. This included performing credit risk analyses of multinational corporate clients, the reports for which were submitted for approval to the regional headquarters.'),(196,119,9,'Assistant Manager','Ahmed played a key role in arranging syndicated financing for a joint-venture between WAPDA and GE, where Citibank was the lead underwriter.'),(197,120,9,'Assistant Manager','Ahmed was part of the taskforce that performed quantitative and qualitative analysis of macroeconomic and industry data to make changes.'),(199,121,1,'Project Director','Denzel oversaw consultants who prepared the capacity development component of the Project. As part of the work, the team: i) Assessed current institutional and regulatory framework and  managerial practices in the power sector; ii) Proposed areas for improvement in institutional and regulatory framework to further commercialize the power sector, based on the result of the sector assessment; and iii) Assisted ADB project team to prepare the project.'),(200,121,2,'Project Manager','Lauren prepared the capacity development component of the Project. As part of the work, the team: i) Assessed current institutional and regulatory framework and  managerial practices in the power sector; ii) Proposed areas for improvement in institutional and regulatory framework to further commercialize the power sector, based on the result of the sector assessment; and iii) Assisted ADB project team to prepare the project.'),(201,26,7,'PPP Analyst','Joshua assisted in developing a Public-Private Partnership (PPP) Handbook for the Mongolian Ministry of Economic Development. The handbook outlined what PPPs are and how they are used, as well as an overview of how governments can identify potential PPPs, structure and procure contracts; and manage projects.'),(202,32,7,'Analyst','Josh conducted an analysis of strategies for economic development of an urban center at Khanbogd, the closest town to the Oyu Tolgoi copper mine. To conduct this analysis, Mr. Morrison assessed governance structures and financial arrangements for the provision of urban services, including energy, transportation, and water and sanitation.'),(203,111,7,'Power Sector Analyst','Joshua analyzed energy supply options to provide input to the least cost power supply analysis. This involved an assessment of the changes to nuclear regulation, costs, and lead times as a result of the Fukushima Accident, and how these changes affect Armenia\'s nuclear program and plans for additional energy supply.'),(204,44,4,'Project Manager and Power Sector Analyst','Joshua developed a system dispatch simulation to model the dispatch of the Kyrgyz Republic’s power generation assets over a 20-year time-frame.'),(205,43,6,'Analyst','Jessica researched and analyzed the institutional and regulatory framework of the energy sectors of Armenia and Georgia in various capacities. In particular, she reviewed Government policy and objectives, involvement of International Financial Institutions (IFIs) and the socio-economic context of each sector.'),(206,122,1,'Project Director','Denzel worked with the World Bank team to analyze existing natural gas and district heating tariffs in Ukraine and identify key pricing challenges in the sectors. They also reviewed the design and implementation of existing social safety nets in Ukraine.'),(207,122,6,'Project Manager','Jessica worked with the World Bank team to analyze existing natural gas and district heating tariffs in Ukraine and identify key pricing challenges in the sectors. She also reviewed the design and implementation of existing social safety nets in Ukraine.'),(208,123,1,'Project Director','Denzel conducted a comprehensive analysis of the financial and operational challenges facing the power sector and developed specific and detailed reform recommendations for addressing these looming challenges. This analysis reviewed historical performance as well as projected performance, which he assessed under a number of supply and demand scenarios.'),(209,123,6,'Project Manager','Jessica conducted a comprehensive analysis of the financial and operational challenges facing the power sector and developed specific and detailed reform recommendations for addressing these looming challenges. This analysis reviewed historical performance as well as projected performance, which Jessica assessed under a number of supply and demand scenarios.'),(210,123,9,'Analyst','Ahmed analysed the policy and regulatory framework of Kyrgyzstan\'s power sector. He also utilized historical financial data to prepare projections which incorporated the effects of potential future investments in the Kyrgyz power sector, and different assumptions about technical and non-technical losses, collections, tariffs, and demand growth.'),(211,123,0,'All','DHInfrastructure has identified the principal technical, financial and policy-related challenges faced by the energy sector and has recommended solutions for meeting those challenges.'),(212,24,0,'All','DHInfrastructure carried out the following tasks: 1.) Analyzed the recent PPP framework established in Mongolia and assessed its suitability; 2.) Identified several PPP model options for financing the new CHP; 3.) Assessed how current regulations could hinder PPP in energy sector; 4.) Examined policies of international lenders in supporting PPP in the energy sector; 5.) Produced a report on international best practices with PPP in the energy sector; 6.) Prepared a policy note with recommendations for future guidelines to improve PPP environment in the energy sector in Mongolia'),(213,122,0,'All','DHInfrastructure worked with the World Bank team to analyze existing natural gas and district heating tariffs in Ukraine and identify key pricing challenges in the sectors. They also reviewed the design and implementation of existing social safety nets in Ukraine.'),(214,121,0,'All','The consultancy services provided by DHInfrastructure focused on preparing the capacity development component of the Project. As part of the work, DHInfrastructure staff: 1.) Assessed current institutional and regulatory framework and  managerial practices in the power sector; 2.) Proposed areas for improvement in institutional and regulatory framework to further commercialize the power sector, including the identification of Key Performance Indicators (KPIs) for Uzbekenergo; and 3.) Assisted ADB project team to prepare the project.'),(215,3,0,'All','As part of the first stage of this work DHInfrastructure staff led a series of 40 interviews with the Treasury PPP Unit, government line departments, and private sector project developers, financiers, and transaction advisors. They summarized the interviews, and drafted a report recommending how best to accelerate PPPs in infrastructure. In the second phase, DHInfrastructure staff offered recommendations on the organization and functions of the PPP Unit based on comparisons of the organization, staffing and functions of similar units in a number of countries. They recommended a split between the Unit’s regulatory and technical assistance functions, and the creation of a new entity to take on the technical assistance function. The team also provided a rationale for the new organizational structure, and recommended the legal form of the new entity, its organizational structure, source of funding, indicative budget, and draft job descriptions.'),(216,111,0,'All','DHInfrastructure identified the principal technical, financial and policy-related challenges faced by the energy sector and recommended solutions for meeting those challenges. For this project, DHInfrastructure prepared an update to the electricity demand forecast and developed a least cost power supply plan, including an assessment of the impacts of this plan on end-user tariffs. DHInfrastructure also performed a review of bottlenecks and investment priorities for Armenia’s transmission network.'),(217,110,0,'All','DHInfrastructure led a team of national and international technical consultants to carry out the renewable energy resource assessment and the financial analysis of potential renewable energy resource options. DHInfrastructure then built financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Armenia\'s future energy supply. As a final output, DHInfrastructure developed a complete investment plan proposal, which involved identifying specific investment opportunities and also specifying the sources of funding for each of these opportunities.'),(218,6,0,'All','DHInfrastructure developed a model to calculate the economic and financial viability of energy efficiency investments in a range of sectors.  We also recommended changes to policies and regulations the Government could implement to improve energy efficiency. As part of this work we carried out the following tasks: i) Collected the necessary data and analyzed the major sources of energy inefficiency in Armenia; ii) Reviewed relevant literature about energy efficiency in Armenia and provided case studies of other countries as comparators; iii) Reviewed the legal and regulatory framework for energy efficiency in Armenia; iv) Reviewed past and ongoing energy efficiency initiatives in Armenia; v) Assessed the economic and financial viability of energy efficiency potential in Armenia; vi) Identified the barriers impeding the realization of energy efficiency potential and made government policy recommendations to overcome those barriers; vii) Evaluated electricity generation costs for nuclear, thermal, and renewable resources, which may be viable for Armenia, based on international prices.'),(219,4,0,'All','DH Infrastructure\'s work included: 1.) Conducted a literature review of relevant studies/papers and data collection on energy efficiency situation in various sub-sectors; 2.) Researched current and planned energy efficiency policies and initiatives in Russia; 3.) Collected data on the costs and benefits of potential government policies or other initiatives to improve energy efficiency in Russia; 4.) Analyzed the data to estimate the net benefits of various energy efficiency policies or initiatives; 5.) Ranked those areas of potential improvement that would have the greatest importance and value to Russia; 6.) Recommended a concrete plan of action for Russian policymakers, local authorities, multi-lateral lenders, and the private sector to support improvements in energy efficiency in the areas identified above as priorities.'),(220,34,0,'All','DHInfrastructure\'s analysis included a consideration of the cost of externalities (environmental and health-related) associated with each option. DHInfrastructure estimated the levelized energy cost (LEC) of each option, as well as the levelized average incremental cost (LRAIC) in economic terms. The team developed a demand forecast and a detailed supply model which simulated hourly economic dispatch on Kosovo’s system.'),(221,7,0,'All','DHInfrastructure’s work focused on estimating the influx of non-miners to areas surrounding the mine, and the scale and cost of housing, utilities and social services needed to accommodate that influx. The team reviewed international mining experience with influx, and developed a model to estimate the scale and cost of infrastructure needed to accommodate population growth in the region. The team also suggested options for institutional and financial arrangements to ensure the necessary infrastructure was provided.'),(222,22,0,'All','DH Infrastructure carried out the following tasks: 1.) Conducted cross-country comparison, analysis, and compilation of regional reports from Armenia, Azerbaijan, Belarus, Georgia, Russia, and Ukraine; 2.) Provided an overview of the existing legal and policy framework for energy efficiency in these countries.'),(223,23,0,'All','As part of this work, DHInfrastructure: 1.) Analyzed the impact of the financial crisis on electricity demand, private and capital flow into the sector, operating and capital expenditures, and the cost of financing; 2.) 	Identified financial gaps in the electricity sector; 3.) Presented results to energy sector stakeholders in Ukraine, Romania, and Armenia.'),(224,28,0,'All','DHInfrastructure carried out the following tasks: 1.) Reviewed legal, regulatory and institutional arrangements in each country’s electricity sector; 2.) Analyzed what additional legal, institutional, and regulatory arrangements would be needed to support regional electricity integration; 3.) Consolidated findings on legal, institutional, and regulatory barriers with those of technical consultants into one final report and 4.) Prepared executive summary and PowerPoint presentation on main findings from final report.'),(225,27,0,'All','DHInfrastructure supported preparation of expert testimony on behalf of PG&E. As part of this work DHInfrastructure: 1.) Constructed a database of market bid prices and production costs; 2.) Calculated economic withholdings of power marketers; 3.) Identified anomalous bidding strategies used by power marketers that constituted tariff violations; 4.) Analysed the bidding behavior of specific sellers in order to evaluate and rebut the opposing party’s arguments; 5.) Provided on-going analytical support and reporting using the constructed models.'),(226,17,0,'All','DHInfrastructure advised on options to improve water and waste water services. DHInfrastructure had presented different institutional and tariff arrangements that had resulted in improved performance in other countries.'),(227,26,0,'All','DHInfrastructure prepared two week-long training sessions on PPP transaction preparation and tender for the PPP Unit, and for their outreach activities to other government agencies (line ministries, local governments), the private sector, and civil society. DHInfrastructure also drafted a comprehensive PPP Handbook for use by government agencies in preparing PPPs. DHInfrastructure also drafted a capacity building plan and a business plan for the PPP Unit.'),(229,9,0,'All','DHInfrastructure staff drafted a paper which included: 1.) A mapping of DoE’s and EARM’s responsibilities and tasks; 2.) A comparison of this mapping to the actual activities of the DoE and EARM staff; 3.) Advice on improvements to the way staff and work are organized in the DoE; 4.) Advise on improvements to the functioning of the EARM; 5.) Recommended next steps in terms of developing the capacity of the two units; 6.) International examples to support our analysis and recommendations.'),(230,35,0,'All','DHInfrastructure coordinated all technical assistance (TA) activitie, managed the creation of a comprehensive asset register for NUC, and managed the development of key performance indicators (KPIs)  for inclusion in staff performance contracts. DHInfrastructure also advised the government on NUC’s institutional capacity, and worked closely with NUC\'s CEO and senior management to draft a corporate strategy.'),(231,16,0,'All','DHInfrastructure suggested options for services and service levels to be covered by the USF and the institutional arrangement, administration, and revenue generation mechanism of the Fund based on international experience, Armenian policy and law, and the current state of the telecommunications market in Armenia.'),(232,45,0,'All','DHInfrastructure performed a mapping exercise of existing indicators and conducted an extensive literature review on enabling environments in each of the three SE4ALL sectors. The desk research was used to develop an initial set of indicators, which were then vetted through a review process, involving feedback from more than 150 sector experts and investors from the US, India, Nepal, Kenya, Spain, Denmark and Peru. To further validate the proposed indicators, DHInfrastructure conducted a desk pilot in 6 countries. The findings from the desk pilot, along with the private sector consultations, were used to refine the RISE indicators in order to be scaled to a global assessment framework. DHInfrastructure also used the outputs from these tasks to develop an external prospectus to be used to raise donor funding for a pilot and larger scale implementation of RISE.'),(233,13,0,'All','The consortium helped the Government plan its program to scale-up access to electricity. The consortium compiled a GIS database that is used to prioritize areas for new connections based on social and economic factors, including household densities, income levels, productive uses of electricity and existing electricity infrastructure. The consortium also considered what financing options were available for the program, including commercial loans from the private sector, Government subsidies and grants, and grants and loans extended on concessional terms from international donor agencies.\nThe consortium’s work focused on developing a plan for expanding electricity coverage that was consistent with other sector developments in generation and transmission, and was well integrated with sector policies. The intention of the prospectus was to raise finance for the access program from multilateral and bilateral donor agencies, who wanted to support well-planned and credible initiatives to expand access to electricity.'),(234,19,0,'All','DH Infrastructure carried out the following tasks: 1.) Used historic load growth data and data on potential investments in new generation to forecast new capacity needs in Armenia; 2.) Estimated the resulting cost-recovery generation tariff based on the combination of possible new generation; 3.) Identified challenges and possible solutions in the energy sector in the short- to medium-term.'),(235,37,0,'All','DHInfrastructure evaluated the economics of power sector infrastructure inefficiencies in terms of lost load and technical and commercial losses. The firm also evaluated the cost of demand side energy inefficiency and energy losses through gas flaring. The firm described and quantified the economic impact of these challenges and provided potential solutions to overcome them. These solutions included making investments in transmission and distribution infrastructure; using opportunities for regional trade to reduce energy supply shortages; improving both demand and supply-side energy efficiency; increasing private sector involvement in the energy sector through the development of independent power purchase agreements.'),(236,36,0,'All','DHInfrastructure estimated the average tariff level reflecting total costs of efficient provision of electricity services to customers, and used these results to estimate the long-run marginal cost of electricity supply to end users. The team reviewed the existing end-user tariff structure and recommended improvements. Additionally, we assessed the social implication of the tariff rate changes and recommended mitigation measures. Lastly, we designed a transition plan to move from current electricity tariff structure and rates to full implementation of amended tariff structure and rates.'),(237,25,0,'All','DHInfrastructure carried out the following tasks: i) Analyzed the current tariff levels charged, constraints on affordability of water and electricity tariffs, and possible means of subsidizing service for lower income customers; and ii) Drafted a policy note for Nauru’s Cabinet, advising on the most viable reform options, including Public Private Partnerships (PPPs), and how to implement them.'),(238,40,0,'All','DHInfrastructure provided economic and financial analysis of the conceptual plant based on the engineering design provided by Mannvit kft. This included the development of economic and financial models of the conceptual plant and an analysis of the role of the conceptual plant in the greater Armenian power sector, based on other work DHInfrastructure had completed in Armenia.'),(239,8,0,'All','DHInfrastructure advised on the design of the impact evaluation, surveys, and an output-based subsidy mechanism for new electricity connections.'),(240,18,0,'All','DHInfrastructure carried out the following tasks: 1.) Developed program methodology for evaluation of 32 energy sector projects in ECA region; 2.) Collected project data from project documents and stakeholder interviews; 3.) Conducted in-person interviews and site inspections for projects in Albania, Kyrgyzstan, Romania, and Serbia; 4.) Rated each project in terms of  relevance, effectiveness, efficiency and sustainability; 5.) Provided SECO with key lessons to improve performance of future projects; 6.) Determined several potential areas for future SECO interventions.'),(241,38,0,'All','DHInfrastructure assessed the relevance and effectiveness of MHR project activities. We advised on the effectiveness of regulatory reforms, the approach, quality and utility of energy audits, and the thoroughness of municipal energy plans, as well as the how well municipalities in Ukraine complied with those plans. As part of our work, DHInfrastructure visited MHR project sites in five municipalities of different sizes both in the east and the south of the country. At the end of the project, we delivered an Evaluation Report that presented our key findings and recommendations to USAID.'),(242,43,0,'All','DHInfrastructure assisted ADB team in preparation of the Energy Sector Assessment, Strategies, and Road Maps (ASR). The consultant services included: 1.) reviewing all existing sector studies and information and filling gaps in knowledge; 2.) analyzing government sector development policy, strategies, and investment plans; 3.) diagnosing key sector development issues; and 4.) identifying areas of future ADB involvement.'),(243,5,0,'All','DH Infrastructure\'s work included: 1.) Identifying existing legislation and government incentive initiatives in place to support the development of the cellulosic ethanol industry; 2.) Surveying private and public sector views on the feasibility of different product technologies; 3.) Reviewing the current research on costs and benefits of cellulosic ethanol production.'),(244,12,0,'All','DHInfrastructure informed NEDO on developments in US Government R&D programs, changes to R&D funding, and new technologies advancing in national laboratories, universities and the private sector. The analysis was enhanced by an extensive survey of public and private sector views on research and development trends in the industry.'),(245,14,0,'All','DH Infrastructure\'s work included:  1.) Reviewing Federal and State energy policies that support Smart Grid deployment; 2.) Interviewing multiple industry experts; and 3.) Identifying all Smart Grid projects currently in development in the US and wrote several case-studies detailing the companies and technologies involved in each venture.'),(246,21,0,'All','DHInfrastructure prepared a report for the utilities that focused on how the American Recovery and Reinvestment Act (ARRA) has impacted Smart Grid. The influx of funding in Smart Grid provided by ARRA has affected the plans of utilities, regulators, and manufacturers alike. The report also included a review on the potential of distributed generation from renewable resources. This topic is of specific interest in Japan due to its industry’s high technical expertise in photovoltaic technology and energy storage devices.'),(247,11,0,'All','DHInfrastructure’s work included: 1.) Reviewing and assessing the status of the 2005 Transfer Plan; 2.) Reviewing the financial rationale for the asset transfer; 3.) Reviewing the legal basis for the asset transfer; 4.) Proposing a revised Transfer Plan; 5.) Identifying the assets to be transferred under the new plan; and 6.) Drafting headers of the model legal documents required to implement the plan.'),(248,31,0,'All','DHInfrastructure developed training materials for a five-day PPP course including modules on: 1.) introduction to PPPs and PPP arrangements; 2.) pricing and tariffs for cross-border electricity PPP arrangements; 3.) case studies of cross-border PPP in the electricity sector and 4.) institutional and market models in the electricity sector. The team presented materials to 30 power experts from WAPP member countries.'),(249,44,0,'All','DHInfrastructure carried out a comprehensive review and assessment of past, current, and projected direct fiscal support and indirect quasi-fiscal deficits, lending and guarantees, as well as the structural factors contributing to these direct and indirect public financial obligations to the sector. We then developed specific and detailed reform recommendations for addressing these looming financial obligations, in line with the objectives of medium term fiscal consolidation. DHInfrastructure also integrated analysis of PSIA to assess impact of any recommendations on the poor. Lastly, we assessed investment plans in the sector, with a focus on their recurrent cost obligations and estimates of whether these are consistent with available fiscal resources.'),(250,10,0,'All','DHInfrastructure advised ADB and the Government on service delivery arrangements used elsewhere in the world, and recommended an arrangement that best fits the legal, financial, and economic context in Mongolia. The arrangement ultimately recommended (and accepted by ADB and the client) was an \"operating management contract\", a lease-like PPP for to provide urban services.'),(251,32,0,'All','DHInfrastructure was asked to advise on options for reforming the supply of urban services (water and sanitation services in particular) in Mongolia’s capital of Ulaanbaatar, in preparation for the ADB Policy and Advisory Technical Assistance (PATA) activity. The team advised on a range of institutional, legal, and regulatory changes, which included improvements to existing performance contracts between Ulaanbaatar and the water and sanitation providers, and steps required for the eventual implementation of a lease contract in the sector.'),(252,30,0,'All','DHInfrastructure led the team in preparing a report that analyzed possible options for implementing consumer-end heat metering in Ukraine. The analysis demonstrated how the cost of heat metering options affected the average heating tariff. This analysis was used to assess the impact of heat metering on customer affordability and the financial sustainability of heat service provision.'),(253,29,0,'All','For this project, DHInfrastructure : 1.) Developed financial models for assessing the financial viability of TDF loans to water supply and sanitation, bus parks, and roads/drainage projects; 2.) Developed methodology for assessing the borrowing capacity of municipalities based on available data; 3.) Developed financial appraisal template, risk management guidelines, and project appraisal manual for use by TDF in future project appraisals; 4.) Prepared financial appraisals for seven WSS projects; 5.) Provided feedback on TDF\'s PPP financing policy and guidelines; and 6.) Managed inputs of all legal, regulatory, financial, environmental and social aspects of project.'),(254,42,0,'All','DHInfrastructure led the transaction advisory team and oversaw all aspects of the project, including the structuring of the PPP arrangement, preparation of tender documents, evaluation and award of the project, negotiation of the contract, and advice on legal and regulatory reform.'),(255,33,0,'All','DHInfrastructure assisted in the development and implementation of a framework for estimating the “barrier removal costs” (effectively, all non-capital costs) of World Bank/GEF energy efficiency projects. The purpose of the study was to provide policymakers and World Bank staff with more complete information on the options presented in marginal abatement cost (MAC) curves. DHInfrastructure advised on the development of the conceptual framework, prepared a survey of experts in the energy efficiency field, and analyzed the correlation between project costs and other factors thought to be drivers of barrier removal costs.'),(256,39,0,'All','DHInfrastructure updated the energy Strategy Note Power Point presentation which we prepared in 2010. This work included update of the load forecast, supply assumption, and other assumptions and facts. The focus of this presentation was transmission, generation, and energy efficiency.'),(257,2,0,'All','DHInfrastructure advised on options for reforming the supply of urban services (water and sanitation services in particular) in Mongolia’s capital of Ulaanbaatar, in preparation for the ADB Policy and Advisory Technical Assistance (PATA) activity. The team advised on a range of institutional, legal, and regulatory changes, which included improvements to existing performance contracts between Ulaanbaatar and the water and sanitation providers, and steps required for the eventual implementation of a lease contract in the sector.'),(258,2,1,'Utility Reform Specialist','Denzel advised on options for reforming the supply of urban services (water and sanitation services in particular) in Mongolia’s capital of Ulaanbaatar, in preparation for the ADB Policy and Advisory Technical Assistance (PATA) activity. He advised on a range of institutional, legal, and regulatory changes, which included improvements to existing performance contracts between Ulaanbaatar and the water and sanitation providers, and steps required for the eventual implementation of a lease contract in the sector.'),(259,124,1,'Project Director','Denzel oversaw the development of an analysis and assessment of the US market for solar PV and solar thermal technologies.'),(260,124,4,'Project Manager','Joshua carried out an analysis and assessment of the US Solar PV market. This included gathering and evaluating data on federal, state and local policies in the US solar market.'),(261,125,6,'Energy Sector Analyst','Jessica reviewed and prepared a comprehensive overview of the current market structure and the institutional and regulatory framework of the power and heating sectors of the Kyrgyz Republic. The overview included a description of current tariff setting practices in each sector.\n'),(262,125,3,'Project Manager/Tariff Specialist','Brendan managed all aspects of this project. He drafted the regulations for tariff setting and performance monitoring and then worked with Regulatory Department staff to adopt the regulations.  The tariff regulations took into account the existing institutional structure of the energy sector and international best practice. As part of the adoption process he conducted training sessions for Regulatory Department staff and briefed utility companies and government officials on the new tariff setting process. He also provided recommendations for options in establishing protections for low-income customers and the development of transition mechanisms for potential tariff increases.'),(263,125,10,'Analyst','For this project, Deborah analyzed the key performance indicators of the power sector in Kyrgyzstan and then presented international best practice performance indicators used by electricity regulators in the United States, United Kingdom, New Zealand and Australia. '),(264,125,0,'Description of Services Provided by DHI','The World Bank asked DHInfrastructure to support the Kyrgyz Republic in establishing a sustainable, transparent and equitable tariff setting methodology aimed at ensuring adequate service quality, and improved transparency and accountability in the power and heating sector. To this end, DHInfrastructure performed the following activities: 1.) Analyzed existing key performance indicators (KPIs) and suggested necessary modifications to these indicators and the overall framework for monitoring and enforcing KPIs; 2.) developed a methodology for determining power and heating tariffs for regulated power and heating sector companies and for each customer class of end-users; 3.) developed and designed transitional mechanisms to move towards proposed tariff setting mechanisms; and 4.) provided technical assistance to the Ministry of Energy, the Regulator and the sector companies to adopt and implement the proposed tariff setting methodology. '),(265,124,0,'Company','DHInfrastructure staff developed a report that reviewed solar PV and solar thermal technology. The report also explored current pricing trends in solar, and provided a state-by-state market size analyses for solar PV in the US. The report also included a description of the important policies, laws, regulations and incentives governing the development of solar PV facilities in the US.'),(266,126,1,'Project Director','Mr. Hankinson developed a report that provided an in-depth listing and description of the laws and regulations governing wind energy development in the US. This report included all federal laws, as well as descriptions of typical relevant state and local laws and regulations. The report gave special focus to the most recent offshore wind developments and the legal and regulatory challenges they have encountered.'),(267,126,4,'Project Manager','Mr. Finn developed a report that provided an in-depth listing and description of the laws and regulations governing wind energy development in the US. This report included all federal laws, as well as descriptions of typical relevant state and local laws and regulations. The report gave special focus to the most recent offshore wind developments and the legal and regulatory challenges they have encountered.'),(268,126,0,'Company','DHInfrastructure developed a report that provided an in-depth listing and description of the laws and regulations governing wind energy development in the US. This report included all federal laws, as well as descriptions of typical relevant state and local laws and regulations. The report gave special focus to the most recent offshore wind developments and the legal and regulatory challenges they have encountered.'),(269,127,0,'Company','DHInfrastructure reviewed all the federal, state and county regulations for geothermal energy production in California that govern geothermal energy, and produced a report describing these regulations. This report put emphasis on how water code regulations are applied to geothermal development, and also on how regulations govern geothermal development on controlled or protected lands.'),(270,127,4,'Project Manager','Joshua reviewed all federal, state and county regulations for geothermal energy production in California governing geothermal energy and produced a report describing these regulations. This report gave special treatment to how water code regulations are applied to geothermal development, and also regulations that govern geothermal development on controlled or protected lands.'),(271,127,1,'Project Director','Denzel reviewed all federal, state and county regulations for geothermal energy production in California governing geothermal energy and produced a report describing these regulations. This report gave special treatment to how water code regulations are applied to geothermal development, and also regulations that govern geothermal development on controlled or protected lands.'),(272,128,0,'Company','DHInfrastructure prepared a report on the US biomass power market that included a quantitative analysis of the market for various types of biomass power technologies. The report included a review of the technologies used for biomass power and their specific applications. The report also included an assessment of the federal, state and local legal and regulatory environments for biomass power in the US.'),(273,128,4,'Project Manager','Joshua prepared a report on the US biomass power market that included a quantitative analysis of the market for various types of biomass power technologies. The report included a review of the technologies used for biomass power and their specific applications. The report also included an assessment of the federal, state and local legal and regulatory environments for biomass power in the US.'),(274,128,1,'Project Director','Denzel prepared a report on the US biomass power market that included a quantitative analysis of the market for various types of biomass power technologies. The report included a review of the technologies used for biomass power and their specific applications. The report also included an assessment of the federal, state and local legal and regulatory environments for biomass power in the US.'),(284,129,0,'All','DHInfrastructure carried out the following tasks: 1.) Assessed financial performance of past donor projects; 2.) Financial analysis of demonstration projects; 3.) Designed and managed the willingness-to-pay survey; 4.) Identified financial management issues in the sector; 5.) Prepared the Asset Ownership Plan; 6.) Prepared the Tariff and Subsidy Setting Mechanism and 7.) Delivered training to operationalized the new rules, regulations and approaches.\n'),(285,129,9,'Finance Speclialist ','Ahmed  worked on the financial and economic aspects of the project. He performed financial analysis to assess value for money of past donor projects and conducted a study to determine financial and economic sustainability of demonstration projects. He also identified financial management issues throughout the supply chain, from operations up to sector governance, with a special focus on the gaps that present opportunities for corruption, and made recommendations to improve financial management. Mr. Malik prepared the Tariff and Subsidy Setting Mechanism, which ensured financial sustainability while also keeping in consideration social protection for poor customers. This study incorporated formulas for tariff and subsidy calculations, review mechanism, adjustment mechanism, and tariff reset periods or events. '),(290,136,0,'Dev','Dev'),(291,137,1,'PPP specialist','Denzel prepared the terms of reference for consultancy services for a regionally harmonized policy framework for public private partnerships (PPP), and open access in broadband infrastructure. The framework he created reflected international best practice for PPPs and was tailored to complement existing national policies and institutional strengths and gaps, appropriate to the Republic of Trinidad and Tobago. Included in his framework were recommendations for awareness and consensus building amongst stakeholders, and for the establishment and strengthening of institutions in Trinidad and Tobago and other CARCIP participating countries regarding the use of PPP to develop infrastructure.'),(293,137,10,'Analyst','Deborah contributed to preparing the Terms of Reference (ToR) by researching the CARCIP project and reviewing the PPP readiness for phase 1 participating countries of CARCIP, including Grenada, St. Lucia and St. Vincent and the Grenadines. She also assisted in drafting various section of the ToR.'),(294,137,0,'Staff','DHInfrastructure prepared the terms of reference for consultancy services for a regionally harmonized policy framework for public private partnerships (PPP), and open access in broadband infrastructure. The framework established in the ToR reflected international best practice for PPPs and was tailored to complement existing national policies and institutional strengths and gaps, as were appropriate to the Republic of Trinidad and Tobago. Included in this framework were recommendations for awareness and consensus building among stakeholders, and recommendations for the establishment and strengthening of institutions in Trinidad, Tobago, and other CARCIP participating countries, regarding the use of PPP to develop infrastructure.'),(295,138,0,'Staff','The World Bank asked DHInfrastructure to analyze the district heating sector of Belarus. To this end, DHInfrastructure examined the legal and institutional framework, and national energy programs related to the district heating sector as well as the current performance and tariff structure of the sector.  In addition, DHInfrastructure wrote the final report that incorporated all tasks related to this project, including the social and stakeholder analyses and energy efficiency components.'),(296,139,1,'Project Director','Denzel was asked to assess the effectiveness of all World Bank loans and technical assistance to the sector during that time period, and the consistency of outcomes with World Bank objectives for the country. His report served as a chapter in a comprehensive IEG assessment of World Bank support to Georgia.'),(297,139,0,'Firm','DHInfrastructure was asked to assess the effectiveness of all World Bank loans and technical assistance to the sector during that time period, and the consistency of outcomes with World Bank objectives for the country. The report served as a chapter in a comprehensive IEG assessment of World Bank support to Georgia.'),(298,141,0,'DHInfrastructure','The International Finance Corporation asked DHInfrastructure to assist in tariff-setting for Small Hydro-power Plants (SHPPs) in Armenia . \nMany SHPPs in Armenia have reached the end of the 15-year guaranteed off-take period provided for in the Feed-in-Tariff (FIT) regulations. DHInfrastructure prepared an analytical piece with estimates of the cost structure of SHPPs which had been in operation for more than 15 years, and made recommendations on the changes required in the current uniform FIT for SHPPs.'),(299,141,1,'Project Director','Denzel prepared an analytical piece with estimates of the cost structure of SHPPs which have been in operation for more than 15 years, and made recommendations on the changes required in the current uniform FIT for SHPPs.'),(300,143,6,'Project Manager','Jessica developed a financial model to assess the cost of service and evaluate the adequacy of existing tariffs in each of the five target countries. As part of this work, she also estimated the fiscal and quasi-fiscal deficits attributable to the power sector in each country. '),(301,143,1,'Project Director','Denzel oversaw all aspects of the project. '),(302,143,9,'Financial Analyst','[Ahmed to complete]'),(303,143,0,'Staff','The World Bank asked DHInfrastructure to conduct a comprehensive financial analysis of the power sector in the Western Balkans, for the purpose of assessing the financial viability of the sector in each country and in the region as a whole. Specifically, this study assessed the adequacy of current tariff levels and estimated the fiscal and quasi-fiscal deficits of each power sector. The analysis included a review of the financial state of the power sectors in Bosnia, Herzegovina, Kosovo, Macedonia, Montenegro, and Serbia. '),(304,145,0,'All','DHInfrastructure led a team of national and international technical consultants to carry out the renewable energy resource assessment and the financial analysis of potential renewable energy resource options. DHInfrastructure then built financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Vanuatu\'s future energy supply. As a final output, DHInfrastructure developed a complete investment plan proposal, which involved identifying specific investment opportunities and also specifying the sources of funding for each of these opportunities.'),(305,145,1,'Project Director','Denzel led a team of national and international technical consultants to carry out the renewable energy resource assessment and the financial analysis of potential renewable energy resource options. He then oversaw the preparation of financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Vanuatu\'s future energy supply. As a final output, Mr. Hankinson drafted a complete investment plan proposal, which involved identifying specific investment opportunities and also specifying the sources of funding for each of these opportunities.'),(309,150,1,'Project Director','As the team leader for this project, Denzel Hankinson performed an objective external assessment of the life cycle of the two programs in terms of their operations, organization, project work and business development efforts. The evaluation provided a substantiated opinion on the programs’ additionality in the region and outlined lessons learned about the workings and organization of similar donor funded programs. The review presented a critical analysis of the potential continued need of such programs in the Europe and Central Asia region.'),(311,150,0,'All','DHInfrastructure performed an objective external assessment of the life cycle of the two programs in terms of their operations, organization, project work and business development efforts. The evaluation provided a substantiated opinion on the programs’ additionality in the region. The evaluation also outlined lessons learned about the workings and organization of similar donor funded programs. The review presented a critical analysis of the potential continued need for such programs in the Europe and Central Asia region.'),(313,153,1,'Project Director','Denzel led a team and reviewed all existing energy sector studies and information, including filling gaps in knowledge, (ii) analyzing government sector development policy, strategies, and investment plans with the primary objective of diagnosing key sector development issues; and identifying areas for future donor involvement.'),(314,153,0,'All','DHInfrastructure conducted an analysis of primary energy sector performance, challenges and opportunities in relation to the Republic of Armenia\'s overall growth to date and future goals. The analysis included assessing reforms, risks and investment opportunities for the energy sector, with the objective of identifying structure constraints on sector development and policy dialogue. DHInfrastructure also provided recommendations for overcoming these structural constraints. '),(317,129,1,'Project Director','Denzel directed and oversaw all work for this project.'),(318,154,1,'Project Director','As part of this work, Denzel led a team that: 1.) estimated the operational, capital and total costs of provision of water services to customers under a number of alternative scenarios; 2.) undertaken quantitative and qualitative research to determine willingness to pay; 3.) determined affordability under various benchmarks; 4.) recommended the design of tariffs and social/financial transfers; and 5.) designed a transition plan to move from the current tariff structure and rate to full implementation of the amended tariff structure and rates.'),(319,156,3,'Project Manager','Brendan is overseeing all aspects of the cost planning study. He developed a forecast model for predicting hourly electricity demand from 2015 to 2030. In addition, he prepared an assessment of the generating capacity at existing and future power sector assets. This assessment involved meeting with sector stakeholders to discuss energy sector plans and gathering information on potential generation and transmission projects. The set of potential power sector projects was then evaluated on a least cost basis using dispatch modeling software. Brendan then developed a financial model to determine the potential tariff impact of the least cost plan.    '),(320,156,1,'Project Director','(Denzel to update)'),(321,156,0,'All','For this project, DHInfrastructure has: 1.) developed an electricity demand model  and prepared base-case electricity demand scenarios for the planning period; 2.) determined the existing supply capacity and potential electricity supply-demand gap; 3.) developed supply portfolio options; 4.) simulated supply dispatch for each portfolio; 5.) used dispatch results to produce LRAIC analysis of each portfolio; 6.) conducted sensitivity analysis of different demand, gas price, and financing scenarios; 7.) determined end-user tariff impact of least-cost plan; and 8.) presented final results to the Government.'),(322,154,0,'All','For this project, DHInfrastructure has: 1.) estimated the operational, capital and total costs of provision of water services to customers under a number of alternative scenarios; 2.) undertaken quantitative and qualitative research to determine willingness to pay; 3.) determined affordability under various benchmarks; 4.) recommended the design of tariffs and social/financial transfers; and 5.) designed a transition plan to move from the current tariff structure and rate to full implementation of the amended tariff structure and rates.'),(323,150,6,'Project Manager','As the project manager, Jessica oversaw all aspects of the external evaluations of the two IFC programs. In addition, she conducted in-depth assessments of PPP transactions in the energy sectors of Albania and Kosovo as well as a health sector transaction in Macedonia, based on interviews with key stakeholders, a thorough review of project documents, and outside research.\n'),(324,157,1,'Project Director','As the project director, Denzel oversaw all aspects of the regional diagnostic report and provided expert insight to regional energy sector issues in the Western Balkan countries.  '),(325,157,0,'DHinfrastructure','The World Bank hired DHInfrastructure to identify key energy issues and constraints in a number of energy sub-sectors including power, renewable energy, energy efficiency, heating, and natural gas. The results of the diagnostic will be used to position and guide the Bank’s policy dialogue, technical assistance, and financing support in the region.'),(326,157,6,'Project Manager','Jessica managed all components of the regional diagnostic report.  In addition, she conducted research and analysis to identify challenges in the energy sectors of the Western Balkan countries and provided recommendations for overcoming these challenges. '),(327,157,10,'Energy Analyst','Deborah conducted research and analysis to identify specific challenges to the energy sector in the Western Balkans. Her analysis focused specifically on renewable energy, energy efficiency and gas developments. '),(328,154,3,'Tariff Specialist','Brendan provided advice on the design options for end user tariffs. He prepared SWOT analysis on various tariff design options (uniform volumetric, non-uniform volumetric, increasing block, and fixed) and used this analysis to provide the Government with a recommended tariff structure.'),(329,42,3,'Utility Regulation Specialist','Brendan supported the development of the new independent regulator. He prepared training material on tariff setting and performance monitoring for new regulatory department staff. He also drafted regulations for licensing and service quality indicators. '),(330,158,13,'Analyst','Chris prepared the executive summary of the final options report. '),(331,158,1,'Project Director/ PPP Expert','Denzel directed and oversaw all aspects of the project. '),(332,158,10,'Analyst','Deborah analyzed the power sector of Timor Leste and prepared the first draft of the SWOT options report and presentation. She also prepared the presentation evaluating the performance of the electricity operator in Timor Leste, EDTL. She is currently contributing to research and writing of the final reform options report.'),(333,158,0,'Team','DHInfrastructure reviewed current GoTL policy for the sector, utility governance arrangements and business processes, to develop a high-level SWOT analysis of the country\'s energy sector. The SWOT analysis was used to evaluate the adequacy of existing polices to deliver the GoTL\'s policy outcomes and discuss with GoTL counterparts policy options for the power sector. Based on in-country discussions and the SWOT analysis, DHInfrastructure then prepared a reform options report, detailing and evaluating various market structure, governance/regulation options and PPP arrangements that allow the GoTL to meet social and economic development goals while reducing high fiscal deficits attributed to the power sector.'),(334,138,1,'Project Director','Denzel led an analysis of the legal and institutional framework, and national energy programs related to the district heating sector as well as the current performance and tariff structure of the sector. Denzel also oversaw the preparation of the final report that incorporated all tasks related to this project including the social and stakeholder analyses and energy efficiency components to this project.'),(335,145,12,'Principal','Bronwyn worked with a a team of national and international technical consultants to carry out the renewable energy resource assessment and financial analysis of potential renewable energy resource options. She worked with stakeholders, donors and consultants to select appropriate criteria for the analysis which were then used to determine which projects should be included in the plan. She undertook drafting of the investment plan proposal, which identified the specific investment opportunities and specified the sources of funding for each of these opportunities.'),(336,141,12,'Principal','Bronwyn analyzed costs of small hydro plant and assessed alternative approaches that the single buyer may use to establish generation tariffs for small hydro plant following the end of the feed-in tariff contract period.'),(337,138,12,'Principal','Bronwyn carried out analysis of the legal and institutional framework and the current performance and tariff structure of the district heating sector.  '),(338,35,12,'Principal','Bronwyn assisted with development of outcome-focussed KPIs for the Nauru Utilities Corporation. KPIs focussed on service quality to consumers and the financial and operational health of NUC.'),(339,34,12,'Principal','Bronwyn assessed potential options for replacement and additional new generation plant, based on resource availability and other resource specific factors, the levelized energy cost (LEC) of each option, and the levelized average incremental cost (LRAIC) in economic terms. \n\n'),(340,28,12,'Principal','Bronwyn assessed legal, institutional and regulatory constraints in the region and in each of the countries’ power sectors that prevent regional electricity market development. She identified policy and regulatory interventions that would be necessary to promote regional trade and integration in the short- and medium-term.'),(341,22,12,'Principal','Bronwyn conducted a cross-country comparison, analysis, and compilation of regional reports from Armenia, Azerbaijan, Belarus, Georgia, Russia, and Ukraine.'),(342,159,12,'Senior Analyst','Bronwyn reviewed and analysed filings submitted by California sellers to the Federal Energy Regulatory Commission (FERC), and assisted with preparation of expert witness testimony.'),(343,160,12,'Senior Analyst','Bronwyn\'s role was development of the tariff application.'),(344,161,12,'Project Manager','Bronwyn\'s was engaged as the Project Manager and Technical Specialist (Energy Markets and System Operation).'),(345,162,12,'Senior Analyst','Bronwyn undertook cost, price and margin benchmarking for the New Zealand retail sector in order for the business, a major generator-retailer, to gain understanding of its position in the sector.'),(346,163,12,'Project Manager','Bronwyn\'s role involved identifying target areas for contracting, running an RFP process, assessing cost effective areas for contracting for \"Negawatts\", developing contracts with commercial and industrial businesses for efficiency gains, and developing a monitoring and reporting programme.'),(347,164,12,'Project Manager','Bronwyn developed the methodology for the analysis, determined assumptions and time periods for consideration, collected the relevant data, carried out the analysis, and drafted a report to the client.'),(348,165,12,'Senior Analyst','Bronwyn was involved in all four parts of this project. Her primary work areas were considering whether the electricity market would likely deliver the optimal level of supply security, and what alternate arrangements might be considered. Bronwyn was also involved in consulting with stakeholders on the analysis and recommendations.'),(349,166,12,'Project Manager','Bronwyn was the Project Manager for the negotiation, managing a team comprising technical and financial experts,  Bronwyn also provided technical advice in relation to market/ system operation, and worked with the legal team to draft the new contract.'),(350,167,12,'Senior Analyst','Bronwyn developed business plans for key projects based on historical costs and performance (including benchmarking analysis against comparable transmission companies), target performance, and asset strategies.'),(351,168,12,'Senior Analyst','Bronwyn was extensively involved in development of the IPP and DPP regulatory frameworks and solely responsible for development of the grid investment framework, including the economic net benefits test. '),(352,169,12,'Senior Analyst','Bronwyn\'s role involved canvassing opinion from within Vector, and preparing a discussion paper setting out options, analysis of each, and recommended approach.'),(353,170,12,'Senior Analyst','Bronwyn considered alternative options that may be applicable in the New Zealand environment, undertook analysis, and in consultation with Vector staff, prepared a final discussion paper for discussion with the GIC.'),(354,171,14,'Gerente del Proyecto','\"jessica fill out\"'),(355,171,16,'Analista','\"deb fill out\"'),(356,171,15,'Expero en Tarifas','\"Brendan fill out\"'),(357,171,0,'All','El Banco Mundial solicitó a DHInfrastructure que asistiera a la República de Kirguistán en el diseño de una metodología sostenible, transparente y equitativa para establecer las tarifas orientadas a asegurar una calidad de servicio adecuada y una transparencia y rendición de cuentas mejoradas en los sectores de electricidad y calefacción. Con este fin, DHInfrastructure realizó las siguientes '),(358,172,17,'Director del Proyecto','\"Denzel fill out\"'),(359,173,21,'Analista Financiero','\"Ahmed Fill in\"'),(360,173,17,'Director del Proyecto','\"Denzel fill in\"'),(361,173,14,'Gerente del Proyecto','\"Jessica Fill in\"'),(362,174,18,'Gerente del Proyecto','\"Lauren fill in\"'),(363,174,17,'Director del Proyecto','\"Denzel fill in\"'),(364,174,14,'Analista','\"Jessica FIll in\"'),(365,175,17,'Director del Proyecto','\"Denzel fill in\"'),(366,177,14,'Gerente del Proyecto','\"Jessica fill in\"'),(367,177,17,'Director del Proyecto','\"Denzel fill in\"'),(368,178,17,'Experto institucional en PPP','\"Denzel fill in\"'),(369,178,18,'Experto en PPP','\"Lauren fill in\"'),(370,178,20,'Analista en PPP','\"Josh fill in\"'),(371,179,17,'Especialista en la reforma de servicios básicos/Líder del equipo','\"Denzel fill in\"'),(372,179,14,'Analista','\"Jessica fill in\"'),(373,180,17,'Director del Proyecto','\"Denzel fill in\"'),(374,180,14,'Gerente del Proyecto','\"jessica fill in\"'),(375,180,21,'Analista','\"ahmed fill in\"'),(376,181,17,'Director del Proyecto','\"Denzel fill in\"'),(377,181,19,'Gerente del Proyecto','\"Joshua fill in\"'),(378,181,14,'Analista','\"Jessica fill in\"'),(379,182,21,'Especialista financiero ','\"Ahmed Fill in\"'),(380,182,17,'Director del Proyecto','\"Denzel fill in\"'),(381,183,17,'Director del Proyecto','\"Denzel fill in\"'),(382,183,19,'Gerente del Proyecto','\"Joshua fill in\"'),(383,183,14,'Analista','\"jessica fill in\"'),(384,183,20,'Analista del sector energético','\"josh fill in\"'),(385,184,17,'Director del Proyecto','\"Denzel fill in\"'),(386,184,18,'Gerente del Proyecto','\"Lauren fill in\"'),(387,184,14,'Analista','\"Jessica fill in\"'),(388,184,19,'Gerente del Proyecto y Analista del sector energético','\"Josh fill in\"'),(389,185,17,'Director del Proyecto','\"denzel fill in\"'),(390,185,18,'Analista Sénior','\"Lauren fill in\"'),(391,185,15,'Analista','\"Brendan fill in\"'),(392,143,10,'Analyst','Deborah provided research assistance for this project, compiling data on 16 electricity utilities in the Western Balkans into a spreadsheet. She reported on the structure of the electricity sectors of each country and gathered the utilities financial reports from which DHInfrastructure conducted their financial analysis.   '),(393,154,10,'Analyst','Deborah prepared the affordability and willingness to pay components of the assignment. She helped develop the survey which used the contingent valuation stated preference method. She analysed the results of the survey and reported the findings in the final report. For the affordability section of the study, Deborah calculated the maximum threshold of affordability by various sub groups such as the poor and non-poor. This was conducted using estimated 2012 household expenditures, average water consumption.  The results were also projected to 2030, adjusted by % GDP growth, and price elasticity of demand for water.  The results will enable the government of Armenia to introduce appropriate mitigation measures if water tariffs (prices) are above the affordability threshold. Finally, Deborah also assisted in building parts of the tariff model. She built a segment of the model which enables the user to determine each tariff block necessary to cover sector costs by customer class. '),(394,110,10,'Analyst','Deborah conducted research on energy efficiency legislation, targets at the national state and city level in the United States. '),(395,129,10,'Analyst','Deborah helped develop the willingness-to-pay survey instrument for the project. She worked on question sequencing, developing the contingent valuation bid range and scenario, and prepared a memo on sample design. '),(396,186,1,'PPP Specialist','Denzel advised the Ministry of Finance and the National Development and Reform Commission (NDRC) on drafts of their PPP regulations and international practice in assessing Value-for-Money, assessing fiscal risk associated with PPPs, and risk mitigation techniques for PPPs. He also provided advice to a local government looking to restructure its PPP for wastewater treatment. As part of this advice he described options for renegotiating, or terminating and re-tendering the existing contract.'),(397,150,3,'PPP Specialist','Brendan prepared a summary of the PPP activity in the ECA region. His review included an assessment of the market for PPPs in the region and the individual experience of the countries served by SEIA and ECA IA.  '),(398,111,3,'Project Manager/ Energy Modeling Specialist','For this project, Brendan prepared a forecast of power demand in Armenia for the next 20  years; developed a least-cost power supply plan for meeting the projected demand; and assessed the end-user tariff impacts of this plan. He also prepared a summary presentation of the results of this project that was given to the Government of Armenia.  '),(399,187,1,'Team Leader','Denzel managed all aspects of this project including the development of an asset management and maintenance plan and a performance management system for non-managerial NUC staff. Denzel also worked closely with the CEO to review NUC\'s corporate governance and make recommendations for improving autonomy and accountability, including the creation of an independent board.'),(400,187,13,'Project Manager','Chris assisted in the preparation of deliverable reports. He also researched legislative and regulatory procedures in Nauru.'),(401,188,1,'Project Director/ Senior Energy Expert','[to be completed]'),(402,188,13,'Analyst','[to be completed]'),(404,188,7,'Project Manager','[to be completed]'),(405,188,10,'Project Manager','[to be completed]'),(406,188,0,'All','The World Bank asked DHInfrastructure to prepare a report for the government of Belarus recommending financing and delivery options for scaling-up energy efficiency investments in thermal retrofits and heating system upgrades in residential and public buildings. To this end, DHInfrastructure is currently working together with local consultants and the World Bank Team to prepare 1.) a stocktaking of the legal, regulatory, and institutional environment and characteristics of the building sector including management, ownership, and financing procedures; 2.) an assessment of potential for energy efficiency improvements and investment needs; 3.) an analysis of the barriers and potential solutions to investment and 4.) development of a road map and areas for donor involvement.'),(407,189,0,'All','DHInfrastructure prepared summary reports of the viable heating solutions for meeting residential and public demand in each country. The reports included an analysis of the economic viability of each option, and recommendations on legal, regulatory and other changes needed in the sector. '),(408,189,6,'Analyst','Jessica supported the project team in various capacities including thoroughly reviewing input reports provided by the international consultancy company and conducting an audit of technical spreadsheets assessing heating options for Tajikistan and the Kyrgyz Republic. In addition, Jessica assisted the team in finalizing presentations of the report findings for World Bank management and key stakeholders. '),(409,186,0,'All','DHInfrastructure advised the Ministry of Finance and the National Development and Reform Commission (NDRC) on drafts of their PPP regulations and international practice in assessing Value-for-Money, assessing fiscal risk associated with PPPs, and risk mitigation techniques for PPPs. The team also provided advice to a local government looking to restructure its PPP for wastewater treatment. As part of this advice he described options for renegotiating, or terminating and re-tendering the existing contract.'),(410,190,1,'Team Leader','DHInfrastructure provided training to various ministries on identifying and preparing PPPs. He also drafted a PPP Handbook for the new PPP Unit, and provided ad hoc support to PPP Unit on issues related to ongoing transactions.'),(411,190,0,'All','DHInfrastructure provided training to various ministries on identifying and preparing PPPs. The team also drafted a PPP Handbook for the new PPP Unit , and provided ad hoc support to PPP Unit on issues related to ongoing transactions.'),(412,187,0,'All','DHInfrastructure coordinated all technical assistance (TA) activities.  DHInfrastructure managed the development of an asset management and maintenance plan and a performance management system for non-managerial NUC staff. DHInfrastructure also worked closely with the CEO to review NUC\'s corporate governance and make recommendations for improving autonomy and accountability, including the creation of an independent board.\n'),(413,188,25,'Analyst','[to be completed]'),(414,129,25,'Analyst','[to be completed]'),(415,191,25,'Analyst','For this study Nicole B. Morin designed and implemented a consumer choice survey.  She used the results to model consumer purchasing behavior for blueberries, and to calculate willingness to pay for government and private Bee Friendly certifications.  These calculations were repeated for data segmented by socio-demographic characteristics.  The results were used to determine consumers’ value of bee health, and also to determine what price premiums farmers could reasonably expect to receive to offset the costs of bee friendly farming. '),(416,192,25,'Analyst','The USDA ERS collaborated with the University of Massachusetts to complete this research.  As a Research Assistant, Nicole B. Morin assessed economic impacts of the Food Safety Modernization Act proposed Produce Rule and Preventative Controls Rule on the domestic produce industry.  She used several crops as case studies for a qualitative analysis of the supply chains and to determine where along these chains the rules and their exemptions were likely to apply.  By compiling yield, acreage, and sales value data, all segmented by state and produce type, she was able to quantify compliance and exemption rates.  These case study results serve as an indicator of the expected impacts across the domestic produce industry.'),(417,187,22,'Analyst','Doris provided support in the preparation of deliverable reports.'),(418,189,13,'Analyst','Chris supported the project team in various capacities including thoroughly reviewing input reports provided by the international consultancy company and researching international best-practice case studies in support of recommendations for heating options for Tajikistan and the Kyrgyz Republic. In addition, Chris assisted the team in finalizing presentations of the report findings for World Bank management and key stakeholders.'),(419,193,3,'Rate Analyst',' Mr. Larkin-Connolly was responsible for a peer review of the Department’s Order for this case. He reviewed the proposed cost of service submitted by MWC and then checked the individual adjustments made by the Department in the Order. As part of the costs of service review he also checked the company’s proposed rate base, that included the water treatment plant additions. The Department disallowed costs of the plan addition related to contractor financing, unsubstantiated post-test year expenditures, and funds used during construction. Mr. Larkin-Connolly checked the calculations of these $979,164 in adjustments and updated the cost of service to account for the change in rate base. Total adjustments to the cost of service led to a $1,340,888 reduction in the proposed rate increase. '),(420,194,3,'Tariff Analyst',' Mr. Larkin-Connolly conducted a review of Bay State Gas Company’s operating costs over the previous ten years in order to assess the reason for the Company’s inability to earn its rate of return.  His analysis showed that while costs related to investment in plant had increased, the largest cost driver were administrative and general expenses.  He also reviewed the Company’s proposed test year and post-test year plant additions to determine whether they were both prudent and used and useful.'),(421,195,3,'Tariff Analyst','Mr. Larkin-Connolly reviewed the Company’s calculation of both the RDM and CapEx factors and helped draft an Order initially approving the rates subject to reconciliation following a final review after hearings and comments from interveners.'),(422,196,3,'Tariff Analyst','Mr. Larkin-Connolly prepared a presentation on the Company’s two rate design proposals to inform the Commission about the advantages and disadvantages of each proposal.  The Commission used his analysis to select a design that both moved classes closer to equalized rates of return but also gave all customer classes a reduction in total bills.'),(423,197,3,'Tariff Analyst','Mr.  Larkin-Connolly was responsible for reviewing these proposed regulatory mechanisms.  Given the Department\'s standard of basing rates on an historic test year, the focus on his investigation was whether the Company had presented a sufficient reason for needing to break from this tradition.  He presented his analysis on the impact of using a future test year versus the historic test year to the Department\'s Commissioners in order to provide them the necessary background information for making a decision on the Company\'s proposal.  Also, in response to the Company’s failure to meet the Department’s expectations to increase leak-prone pipe replacement under its existing capital tracker mechanism, he helped develop an annual mileage threshold the Company will have to meet in order to earn recovery of the investments outside of a rate case.  In addition, Mr. Larkin-Connolly reviewed the plant additions the Company proposed to add to rate base.  This review included an examination of project reports and cost-variance analysis for 272 projects with costs greater than $50,000.'),(424,198,3,'Tariff Analyst','Mr. Larkin-Connolly was in charge of the preparing the capital review and description of financing sections for the Department\'s Order. His review of the company\'s petition included extensive analysis of their utility plant account and current long-term debt.'),(425,36,3,'Advisor','Brendan advised DHInfrastructure staff on best-practice tariff setting approaches. He provided recommendations on the cost components to include in the revenue requirement and appropriate allocation factors for allocating the cost of service. '),(426,199,1,'Senior Energy Expert','Denzel provided substantive inputs and analytical support for the Energy Sector Coordinating Committee (ESCC) meetings, CAREC senior officials meetings as well as the CAREC Ministerial Conference (MC). He also updated the CAREC Energy Strategy 2020 and prepared the CAREC Energy Work Plan (EWP) for 2016-2020. As part of this work, Denzel also oversaw the preparation and implementation of TAs related to topics specified in the EWP, and administered capacity development program for ESCC members.'),(427,199,6,'Project Manager','Ms. Merrill provided various inputs in support of the CAREC Energy Sector Coordinating Committee (ESCC) meetings, CAREC senior officials meetings as well as the CAREC Ministerial Conference (MC). Based on the outputs of these key meetings, Ms. Merrill updated the 2020 CAREC Energy Strategy and contributed to the development of the Energy Work Plan (EWP) for 2016-2020.\n'),(428,199,22,'Analyst','Doris assisted in the preparation of presentations for CAREC Energy Sector Coordinating Committee (ESCC) meetings, CAREC senior officials meetings as well as the CAREC Ministerial Conference (MC). She analyzed the impacts of CAREC initiatives on the energy sectors of the region\'s member countries. Doris also worked on updating the 2020 CAREC Energy Strategy and provided support in developing the Energy Work Plan (EWP) for 2016-2020.'),(429,200,1,'[Denzel to complete]','[Denzel to complete]'),(430,200,6,'Modeling Specialist','Ms. Merrill contributed to the finalization of the supply options model and conducted a thorough audit of the model upon completion. She also provided ad hoc research and analytical support throughout the project.  '),(431,145,3,'Energy Sector Modeler','Brendan built financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Vanuatu\'s future energy supply. '),(432,125,1,'Project Director','Denzel directed all aspects of the project. As part of this work he conducted  training sessions on international best practice in performance monitoring and tariff setting for staff of the Regulator. He also advised on the drafting of  regulations on tariff setting and key performance indicators. '),(433,201,0,'All','The World Bank hired DHInfrastructure to support the design of strategic communication materials for promotion and dissemination. To this end, DHInfrastructure 1.) reviewed the first round of qualitative and quantitative work prepared by the World Bank\'s analytical team; 2.) created a  presentation outlining the main findings of the first round of qualitative work to be presented at a stakeholder workshop; 3.) prepared short dissemination materials; 4.) prepared summary material for a second stakeholder workshop outlining the main findings of the second round of qualitative and quantitative work; 5.) prepared a presentation summarizing the preliminary analysis of the performance of the new social protection program and suggested options to improve it; and 6.) prepared a short paper summarizing the results of the completed qualitative and quantitative work.'),(434,201,1,'Project Director','Denzel directed and oversaw all aspects of the project.'),(435,201,13,'Analyst','Chris helped develop presentations for the stakeholder workshops. He also researched and summarized tariff reform case studies.'),(436,156,13,'Analyst','Chris researched tariff-setting methodologies and procedures, and helped build a model for calculating a weighted average generation tariff.'),(437,157,13,'Analyst','Chris conducted research and analysis on the energy regulators in the Western Balkan countries. He also summarized each country\'s compliance with the Energy Community\'s Acquis on Electricity.'),(438,150,13,'Analyst','Chris researched issues related to infrastructure under-development in the region, and developed a summary of current donor activity in the region.'),(439,145,13,'Analyst','Chris conducted research on a variety of topics, including the Government\'s renewable energy strategy and the role of the private sector in renewable energy in Vanuatu.'),(440,186,13,'Analyst','Chris researched international best practice in Project Development Facilities (PDFs) for PPPs. He wrote a memo outlining procedures for performing Value-for-Money analysis. He also researched the UK\'s Five Case Model for developing business cases, and wrote a memo outlining how it could be adapted and integrated into China\'s PPP project cycle.'),(441,200,13,'Analyst','Chris researched the methodology for calculating the environmental cost of coal plants.'),(442,138,13,'Analyst','Chris assisted in the drafting and editing of an appendix on public communication strategies.'),(443,186,6,'Analyst','Jessica assisted in compiling a publication summarizing the proceeding of the 6th PRC-ADB Knowledge Sharing Platform: Deepening Public-Private Partnerships, which was held in the People\'s Republic of China in November of 2014. '),(444,199,0,'Company','DHInfrastructure provided substantive inputs and analytical support for the Energy Sector Coordinating Committee (ESCC) meetings, CAREC senior officials meetings as well as the CAREC Ministerial Conference (MC). The firm also updated the CAREC Energy Strategy 2020 and prepared the CAREC Energy Work Plan (EWP) for 2016-2020. As part of this work, DHInfrastructure also oversaw the preparation and implementation of TAs related to topics specified in the EWP, and administered capacity development program for ESCC members.'),(445,202,0,'All','DHInfrastructure advised the town’s Broadband Committee and Board of Selectmen (City Councilors) on options for structuring the contract with a third party operator, and key considerations with the type of contract they were considering.'),(446,202,1,'PPP Advisor','Denzel advised the town’s Broadband Committee and Board of Selectmen (City Councilors) on options for structuring the contract with a third party operator, and key considerations with the type of contract they were considering.'),(447,203,0,'All','DHInfrastructure led a team of national and international technical consultants to carry out the renewable energy resource assessment and the financial analysis of potential renewable energy resource options. DHInfrastructure then built financial models of dozens of renewable energy resources, and used dispatch modeling software to evaluate the impact of various renewable energy resources on Bangladesh\'s future energy supply. As a final output, DHInfrastructure developed a complete investment plan proposal, which involved identifying specific investment opportunities and also specifying the sources of funding for each of these opportunities.'),(448,203,3,'Project Manager','Brendan is managing all aspects of this project, which involves a comprehensive assessment of all potential renewable energy projects in Bangladesh. He will build a financial model for calculating the levelized energy costs (LECs) of each renewable energy option. The LEC analysis will be combined with an economic and social impact evaluation of each option to develop a priority ranking of renewable energy projects in Bangladesh. The rankings will be used as the basis for an investment plan that provides a summary of potential projects and solutions for funding them.'),(449,204,1,'Team Leader/Economist','Denzel directs and oversees the project. '),(450,204,25,'Analyst','Nicole is responsible for the survey design and analyzing results of the willingness to pay study. '),(451,204,10,'Analyst','Deborah is designing the survey and will travel to Dili to support the local study coordinator in testing and administering the survey. ');

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `information` text,
  `current` int(1) NOT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES (1,1,'Denzel','Hankinson',NULL,1,NULL),(2,1,'Lauren','Pierce',NULL,0,NULL),(3,1,'Brendan','Larkin-Connolly',NULL,1,NULL),(4,1,'Joshua','Finn',NULL,0,NULL),(5,1,'Shorena','Kalandarishvili',NULL,0,NULL),(6,1,'Jessica','Merrill',NULL,1,NULL),(7,1,'Joshua','Morrison',NULL,1,NULL),(9,1,'Ahmed','Malik',NULL,0,NULL),(10,1,'Deborah','Ong','',1,'2013-11-12 02:20:04'),(11,1,'New','Staff','',0,'2013-11-24 13:40:05'),(12,1,'Bronwyn','Ward','',0,'2014-11-05 09:55:28'),(13,1,'Christopher','Parcels','',0,'2014-11-25 16:26:22'),(14,4,'Jessica','Merrill','',1,'2015-01-07 16:10:08'),(15,4,'Brendan','Larkin-Connolly ','',1,'2015-01-07 16:11:13'),(16,4,'Deborah','Ong ','',0,'2015-01-07 16:11:31'),(17,4,'Denzel','Hankinson','',1,'2015-01-07 16:12:00'),(18,4,'Lauren','Pierce','',0,'2015-01-07 16:12:41'),(19,4,'Joshua','Finn','',0,'2015-01-07 16:13:26'),(20,4,'Joshua','Morrison','',1,'2015-01-07 16:13:47'),(21,4,'Ahmed','Malik','',0,'2015-01-07 16:52:32'),(22,1,'Doris','Hernandez','',1,'2015-01-22 11:57:47'),(23,1,'Barbara','Oegg','',0,'2015-02-22 23:29:20'),(24,1,'Eduard','Bublik','',0,'2015-02-22 23:29:48'),(25,1,'Nicole','Morin','',0,'2015-03-10 16:34:15'),(26,5,'New','User','',0,'2015-04-14 20:52:07');

--
-- Table structure for table `staff_bios`
--

CREATE TABLE `staff_bios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `bios` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_bios`
--

INSERT INTO `staff_bios` VALUES (1,9,8,'testing bios - '),(2,9,7,'Test 1'),(3,9,2,'Testing Ahmed Bio'),(4,1,1,'Denzel Hankinson has more than fifteen years advising on PPP policy, legal and institutional frameworks worldwide at the national and municipal level. As part of an Asian Development Bank project, Denzel is currently working with China’s Ministry of Finance to develop business cases for a number of PPPs and in the development of legal and regulatory frameworks for national and local government PPPs in China. He is also advising the Government of East Timor on power sector reform and the introduction of a PPP in the electricity sector. In 2011, Denzel helped the Government of Mongolia design a PPP model for a new combined heat and power plant in Ulaanbaatar (CHP5). For this project, he reviewed the current PPP regulations, determined the potential barriers to a successful transaction, and recommended several new PPP modalities the Government could select. Previously, Denzel advised the Parliament of Mongolia on the drafting of the Concession Law (passed in January 2010). Denzel has also advised the President’s Office and Business Trust of South Africa on ways to improve the country’s PPP program. As part of this work, he assessed the capacity of National Treasury’s PPP Unit, and recommended institutional and staffing changes to accelerate infrastructure PPPs in South Africa.'),(5,13,7,'Chris Parcels has experience researching a variety of issues, including renewable energy policy, value-for-money analysis for public private partnership (PPP) projects, and public communication campaigns. He is currently working with the World Bank on a report about heating and energy efficiency in the urban building sectors of the Kyrgyz Republic and Tajikistan. He is also working on a project to design a public communication strategy for energy tariff reform in Ukraine.\n\nPrior to joining DHInfrastructure, Chris worked as a Teaching Assistant at the University of Massachusetts and an Instructor at the Summer Institute for the Gifted. In these positions, he taught courses in history, law and government, writing, research methods, and statistics.\nChris has a MA in History from Villanova University in Pennsylvania. He graduated with a BA in History and Psychology and a certificate from the Liberal Arts Honors Program from Providence College in Rhode Island.'),(6,12,8,'Bronwyn Ward specializes in regulation of energy markets and energy infrastructure. She has considerable experience in competitive market arrangements, transmission access and pricing and power system operation in hydro/thermal power systems such as in New Zealand. She is recently completed work on development of a Renewables Investment Plan for the Government of Vanuatu, and on analyzing alternate approaches to establishing tariffs for small hydro plant in Armenia. \n \nOther recent work has included the development of building block models for price-quality regulation for electricity transmission and distribution businesses in New Zealand, advising on development of power trading in the South Caucasus, developing an economic assessment framework for large transmission system upgrades, and assessing options for new generation for Kosovo. '),(7,3,7,'Brendan Larkin-Connolly is a regulatory specialist with more than 5 years’ experience working with public and private sector clients. He has experience working on projects with the World Bank (WB), Asian Development Bank (ADB), and Switzerland’s State Secretariat for Economic Affairs (SECO). Brendan is currently working with the World Bank to advise Kyrgyzstan on the development of a tariff setting methodology for electricity and district heating. He also recently developed training materials on tariff setting and service quality standards for a new water and wastewater services regulator in Mongolia.    \n\nHe also has considerable experience modeling wholesale energy markets. In 2011, he supported the development of expert testimony submitted on behalf of the California Parties in the FERC Refund Proceedings (FERC docket EL00-95 et al.) that stemmed from the California energy crisis in 2000-2001.  As part of the analysis for the testimony he built database models for identifying economic withholdings of power marketers during the California electricity crisis and estimated what the competitive price for electricity would have been in California absent market manipulation.\n\nBrendan returned to DHInfrastructure in 2013 after spending two years as a staff member of the Massachusetts Department for Public Utilities (DPU), a state-level utilities regulator responsible for tariffs and service quality in the electricity, water, and natural gas sectors. As an analyst with the DPU, Brendan worked on a variety of regulatory cases providing him with an in-depth understanding of the regulatory process.  He has experience advising on rate base issues, revenue allocation, decoupling, capital cost recovery trackers, low income tariffs, and storm cost recovery.     \n\nBrendan has attended courses at New Mexico’s Center for Public Utilities and Michigan State University’s Institute of Public Utilities. Brendan has a MS in Resource Economics from the University of Massachusetts-Amherst and a BA in Economics from the College of the Holy Cross.  '),(8,10,7,'Deborah Ong is an analyst with experience working on energy and water sector projects in Asia Pacific, Eastern Europe and Central Asia. She is currently working a World Bank project to scale-up energy efficiency in the building sector in Belarus. In 2014, she was part of a team that prepared a World Bank report with recommendations for the district heating sector in Belarus. As part of this assignment, Deborah conducted a stocktaking analysis of the Belarussian district heating system and helped incorporate draft reports from the team into a final report. \n\nDeborah has also worked on a power sector reform project in Timor Leste funded by the Asian Development Bank. As part of this work, she analyzed aspects of the power sector in Timor Leste such as its institutional, legislative and regulatory framework, and energy demand and supply characteristics, to prepare a draft of the reform options report. She also prepared a presentation evaluating the performance of the electricity operator in Timor Leste, EDTL. \n\nIn 2013, Deborah conducted research to identify key challenges facing the power sector of Armenia and recommend potential solutions to address them. Specifically, Deborah analyzed the electricity sectors of Turkey, Georgia and Iran to determine Armenia’s potential to become a supplier to the region’s growing demand for energy. \n\nDeborah graduated with a BS in Economics and Political Science with departmental, and Latin honors, as well as a minor in Jewish Studies from the College of Charleston, Charleston, South Carolina.\n'),(9,6,3,'In 2014, Jessica managed DHInfrastructure’s external evaluation of two PPP programs administered by IFC: Southeast Europe Infrastructure Advisory (SEIA) and Europe and Central Asia Infrastructure Advisory (ECA IA). As part of the work, Jessica conducted in-depth assessments of PPP transactions in the energy sectors of Albania and Kosovo as well as a health sector transaction in Macedonia, based on interviews with key stakeholders, a thorough review of project documents, and outside research.'),(10,6,8,'Jessica has extensive experience conducting energy sector assessments in Eastern Europe and Central Asia. In 2014, Ms. Merrill worked with the World Bank to conduct a comprehensive financial analysis of power sectors of Western Balkan countries. As part of this work, she developed a financial model to assess the cost of service and evaluate the adequacy of existing tariffs in five target countries: Bosnia & Herzegovina, FYR Macedonia, Kosovo, Montenegro and Serbia. In 2013, Ms. Merrill worked with the World Bank to develop a Power Sector Policy Note for the Kyrgyz Republic (access report here). Under this project, she conducted a comprehensive analysis of the financial and operational challenges facing the power sector of the Kyrgyz Republic and developed specific and detailed reform recommendations for addressing these looming challenges. '),(11,6,7,'Jessica Merrill is an energy sector analyst with experience researching and evaluating a variety of topics including financial and operational performance of utilities, institutional frameworks of utility governance and regulation, and power supply and financing options. She has worked on projects with the World Bank, the Asian Development Bank (ADB) and the U.S Agency for International Development (USAID) in Armenia, Belarus, Bosnia and Herzegovina, FYR Macedonia, Georgia, Kosovo, the Kyrgyz Republic, Mongolia, Nauru, Serbia, Tanzania, Ukraine and Uzbekistan, conducting research and data analysis in various capacities.Jessica Merrill is an energy sector analyst with experience researching and evaluating a variety of topics including financial and operational performance of utilities, institutional frameworks of utility governance and regulation, and power supply and financing options. She has worked on projects with the World Bank, the Asian Development Bank (ADB) and the U.S Agency for International Development (USAID) in Armenia, Belarus, Bosnia and Herzegovina, FYR Macedonia, Georgia, Kosovo, the Kyrgyz Republic, Mongolia, Nauru, Serbia, Tanzania, Ukraine and Uzbekistan, conducting research and data analysis in various capacities.\n\nMs. Merrill holds a BA in Global Studies with Highest Honors and minors in Environmental Studies and Spanish from the University of North Carolina at Chapel Hill. Ms. Merrill recently attended the Advanced Regulatory Studies Program at Michigan State University’s Institute of Public Utilities, which covered advanced technical, methodological, and policy issues of ratemaking, accounting, finance and economics in the utility sector.'),(12,6,5,'In particular, Ms. Merrill has experience working on renewable energy projects. In 2013, she supported the DHInfrastructure team in putting together the SREP investment plan for Armenia by researching barriers to development of renewable energy in Armenia and potential measures to mitigate these barriers. In 2012, Ms. Merrill supported the economic and financial appraisal of a potential geothermal power plant in Armenia by conducting supporting research and analysis of geothermal generation technologies and possible geothermal sites in Armenia.'),(13,7,8,'Josh Morrison is a manager at DHInfrastructure with experience working in the Armenian energy and water sector, and with public and private clients in the energy, transport and urban development sectors. He is currently managing the Armenia Water Sector Tariff Study for the World Bank. \nIn 2013, Josh Morrison worked with the World Bank and IFC to create a global index for the Readiness for Investment in Sustainable Energy (RISE). Mr. Morrison was the energy efficiency specialist for the project. He managed the development and refinement of the energy efficiency indicators, involving extensive literature review and input from sector experts. In collaboration with the Sustainable Energy Department at the World Bank, Mr. Morrison coordinated 3 private sector focus groups to solicit feedback on the indicators in Washington DC, Kenya, and New Delhi. Mr. Morrison also managed the implementation of a desk pilot of the initial set of 48 renewable energy, energy efficiency and energy access indicators in 6 countries, involving key-informant interviews with investors in each sector. \nIn 2012, as part of the work for the Armenia Power Sector Policy Note Update for the World Bank, he analyzed energy supply options to provide input to the least cost power supply analysis. This involved an assessment of the changes to nuclear regulation, costs, and lead times as a result of the Fukushima Accident, and how these changes affect Armenia\'s nuclear program and plans for additional energy supply.\nMr. Morrision is the co-author of Sustainability in the Built Environment, a course at Brown University on energy efficiency in buildings and districts. Mr. Morrison is a LEED Accredited Professional and holds a B.A. in environmental studies and B.A in urban studies from Brown University.'),(14,7,12,'Josh Morrison is a manager at DHInfrastructure with experience working in the Armenian energy and water sector, and with public and private clients in the energy, transport and urban development sectors. He is currently managing the Armenia Water Sector Tariff Study for the World Bank. \nIn 2013, Josh Morrison worked with the World Bank and IFC to create a global index for the Readiness for Investment in Sustainable Energy (RISE). Mr. Morrison was the energy efficiency specialist for the project. He managed the development and refinement of the energy efficiency indicators, involving extensive literature review and input from sector experts. In collaboration with the Sustainable Energy Department at the World Bank, Mr. Morrison coordinated 3 private sector focus groups to solicit feedback on the indicators in Washington DC, Kenya, and New Delhi. Mr. Morrison also managed the implementation of a desk pilot of the initial set of 48 renewable energy, energy efficiency and energy access indicators in 6 countries, involving key-informant interviews with investors in each sector. \nIn 2012, as part of the work for the Armenia Power Sector Policy Note Update for the World Bank, he analyzed energy supply options to provide input to the least cost power supply analysis. This involved an assessment of the changes to nuclear regulation, costs, and lead times as a result of the Fukushima Accident, and how these changes affect Armenia\'s nuclear program and plans for additional energy supply.\nMr. Morrision is the co-author of Sustainability in the Built Environment, a course at Brown University on energy efficiency in buildings and districts. Mr. Morrison is a LEED Accredited Professional and holds a B.A. in environmental studies and B.A in urban studies from Brown University.'),(15,22,0,'Doris Hernandez has experience researching a range of issues including the potential of renewable energy, energy demand, district heating, water tariffs, and energy subsidies. She is currently working on a project with the Asian Development Bank on a capacity development technical assistance for institutional strengthening of Nauru’s Utilities Corporation.\n\nPrior to joining DHInfrastructure, Doris was a political section intern for the U.S. Embassy in Mexico City. In this position she developed weekly news reports, researched and wrote reports on the unaccompanied child migrants transiting through Mexico and ending at the United States’ Southern Border, and attended meetings and conferences with local and federal level political leaders.  She also spent a summer interning at the U.S. Embassy in Kiev where she led a research report on children with disabilities in Ukraine. During her senior year of college, Doris was a research assistant for the Department of Economics at the University of South Carolina. Under this role, Doris worked on a project commissioned by the Asia-Pacific Economic Cooperation where she researched rules and regulations affecting advertising in Mexico, Chile and Peru, and surveyed key informants for APEC’s study. \nDuring her undergraduate studies, Doris enrolled in courses such as International Development, International Political Economy, and Econometrics. She graduated with a BA in Economics and International Studies from the University of South Carolina-Columbia. Doris spent a semester studying abroad in Argentina in 2012, and also spent a semester in France in 2013. \n'),(16,22,13,'Doris Hernandez has experience researching a range of issues including the potential of renewable energy, energy demand, district heating, water tariffs, and energy subsidies. She is currently working on a project with the Asian Development Bank on a capacity development technical assistance for institutional strengthening of Nauru’s Utilities Corporation.\n\nPrior to joining DHInfrastructure, Doris was a political section intern for the U.S. Embassy in Mexico City. In this position she developed weekly news reports, researched and wrote reports on the unaccompanied child migrants transiting through Mexico and ending at the United States’ Southern Border, and attended meetings and conferences with local and federal level political leaders.  She also spent a summer interning at the U.S. Embassy in Kiev where she led a research report on children with disabilities in Ukraine. During her senior year of college, Doris was a research assistant for the Department of Economics at the University of South Carolina. Under this role, Doris worked on a project commissioned by the Asia-Pacific Economic Cooperation where she researched rules and regulations affecting advertising in Mexico, Chile and Peru, and surveyed key informants for APEC’s study. \n\nDuring her undergraduate studies, Doris enrolled in courses such as International Development, International Political Economy, and Econometrics. She graduated with a BA in Economics and International Studies from the University of South Carolina-Columbia. Doris spent a semester studying abroad in Argentina in 2012, and also spent a semester in France in 2013. \n'),(17,22,7,'Doris Hernandez has experience researching a range of issues including the potential of renewable energy, energy demand, district heating, water tariffs, and energy subsidies. She is currently working on a project with the Asian Development Bank on a capacity development technical assistance for institutional strengthening of Nauru’s Utilities Corporation.\nPrior to joining DHInfrastructure, Doris was a political section intern for the U.S. Embassy in Mexico City. In this position she developed weekly news reports, researched and wrote reports on the unaccompanied child migrants transiting through Mexico and ending at the United States’ Southern Border, and attended meetings and conferences with local and federal level political leaders.  She also spent a summer interning at the U.S. Embassy in Kiev where she led a research report on children with disabilities in Ukraine. During her senior year of college, Doris was a research assistant for the Department of Economics at the University of South Carolina. Under this role, Doris worked on a project commissioned by the Asia-Pacific Economic Cooperation where she researched rules and regulations affecting advertising in Mexico, Chile and Peru, and surveyed key informants for APEC’s study. \nDuring her undergraduate studies, Doris enrolled in courses such as International Development, International Political Economy, and Econometrics. She graduated with a BA in Economics and International Studies from the University of South Carolina-Columbia. Doris spent a semester studying abroad in Argentina in 2012, and also spent a semester in France in 2013. \n');

--
-- Table structure for table `user_permissions`
--

CREATE TABLE `user_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  `components` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=516 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_permissions`
--

INSERT INTO `user_permissions` VALUES (1,2,3,'add|delete'),(2,2,4,'edit'),(3,2,5,'add_member|add_contact'),(4,2,2,'delete'),(70,7,7,''),(71,7,3,'add|edit'),(72,7,4,'add|edit'),(73,7,9,''),(74,7,8,''),(75,7,5,'add|edit'),(76,7,1,'add|edit'),(77,7,2,'add|edit'),(78,6,7,''),(79,6,3,'add|edit'),(80,6,4,'add|edit'),(81,6,9,''),(82,6,8,''),(83,6,5,'add|edit'),(84,6,1,'add|edit'),(85,6,2,'add|edit'),(86,5,7,''),(87,5,3,'add|edit'),(88,5,4,'add|edit'),(89,5,9,''),(90,5,8,''),(91,5,5,'add|edit'),(92,5,1,'add|edit'),(93,5,2,'add|edit'),(94,10,7,''),(95,10,3,'add|edit'),(96,10,4,'add|edit'),(97,10,9,''),(98,10,8,''),(99,10,5,'add|edit'),(100,10,1,'add|edit'),(101,10,2,'add|edit'),(120,13,7,''),(121,13,3,'add|edit'),(122,13,4,'add|edit'),(123,13,9,''),(124,13,8,''),(125,13,5,'add|edit'),(126,13,1,'add|edit'),(127,13,2,'add|edit'),(128,12,7,''),(129,12,3,'add|edit'),(130,12,4,'add|edit'),(131,12,9,''),(132,12,8,''),(133,12,5,'add|edit'),(134,12,1,'add|edit'),(135,12,2,'add|edit'),(146,8,7,''),(147,8,3,'add|edit'),(148,8,14,''),(149,8,4,'add|edit'),(150,8,9,''),(151,8,8,''),(152,8,13,''),(153,8,5,'add|edit'),(154,8,1,'add|edit'),(155,8,2,'add|edit'),(186,15,4,'add|edit|delete'),(187,15,11,'create|edit|delete'),(212,9,7,''),(213,9,3,'add|edit'),(214,9,14,''),(215,9,4,'add|edit'),(216,9,12,''),(217,9,9,''),(218,9,8,''),(219,9,11,'create|edit|delete'),(220,9,13,''),(221,9,5,'add|edit'),(222,9,1,'add|edit'),(223,9,2,'add|edit'),(224,15,11,'create|edit|delete|allow'),(225,16,3,'add|edit|delete'),(226,16,14,''),(227,16,4,'add|edit|delete'),(228,16,9,''),(229,16,8,''),(230,16,11,'create|edit|delete|allow'),(231,16,13,''),(232,16,5,'add|edit|delete'),(233,16,1,'add|edit|delete'),(234,16,2,'add|edit|delete'),(235,17,3,'add|edit|delete'),(236,17,14,''),(237,17,4,'add|edit|delete'),(238,17,9,''),(239,17,8,''),(240,17,11,'create|edit|delete|allow'),(241,17,13,''),(242,17,5,'add|edit|delete'),(243,17,1,'add|edit|delete'),(244,17,2,'add|edit|delete'),(245,18,3,'add|edit|delete'),(246,18,14,''),(247,18,4,'add|edit|delete'),(248,18,12,''),(249,18,9,''),(250,18,8,''),(251,18,11,'create|edit|delete|allow'),(252,18,13,''),(253,18,5,'add|edit|delete'),(254,18,1,'add|edit|delete'),(255,18,2,'add|edit|delete'),(276,6,14,NULL),(277,20,7,''),(278,20,3,'add'),(279,20,14,''),(280,20,4,'add'),(281,20,9,''),(282,20,8,''),(283,20,11,'create'),(284,20,13,''),(285,20,5,'add'),(286,20,1,'add'),(287,20,2,'add'),(376,21,7,''),(377,21,3,'add'),(378,21,14,''),(379,21,4,'add'),(380,21,9,''),(381,21,8,''),(382,21,11,'create'),(383,21,13,''),(384,21,5,'add'),(385,21,1,'add'),(386,21,2,'add'),(387,22,7,''),(388,22,3,''),(389,22,14,''),(390,22,4,''),(391,22,9,''),(392,22,8,''),(393,22,11,''),(394,22,13,''),(395,22,5,''),(396,22,1,''),(397,22,2,''),(433,26,7,''),(434,26,3,'add|edit|delete'),(435,26,14,''),(436,26,4,'add|edit|delete'),(437,26,12,''),(438,26,9,''),(439,26,8,''),(440,26,11,'create|edit|delete|allow'),(441,26,13,''),(442,26,5,'add|edit|delete'),(443,26,1,'add|edit|delete'),(444,26,2,'add|edit|delete'),(475,14,3,'add|edit|delete'),(476,14,14,''),(477,14,4,'add|edit|delete'),(478,14,9,''),(479,14,8,''),(480,14,11,''),(481,14,13,''),(482,14,5,'add|edit|delete'),(483,14,1,'add|edit|delete'),(484,14,2,'add|edit|delete'),(485,23,7,''),(486,23,3,'add|edit|delete'),(487,23,14,''),(488,23,4,'add|edit|delete'),(489,23,9,''),(490,23,8,''),(491,23,11,'create|edit|delete|allow'),(492,23,13,''),(493,23,5,'add|edit|delete'),(494,23,1,'add|edit|delete'),(495,23,2,'add|edit|delete'),(510,28,3,'add|edit|delete'),(511,28,14,''),(512,28,4,'add|edit|delete'),(513,28,9,''),(514,28,5,'add|edit|delete'),(515,28,1,'add|edit|delete');


