Rohit Amarnath

Rohit Amarnath

Skills

Skills

Other Technologies and Skills

Hyperion Master Data Management Scapa Stress Testing Platform Visual Basic 3, 4, 5, 6 + .NET

Operating Systems

Windows OSX AIX Linux Amazon Elastic Computing (EC2)

Oracle 8i, 9i, 10g

Datawarehousing, BI, OLAP

Oracle Datawarehousing Oracle EPM Oracle Essbase 5.x - 11.x on Windows, AIX, Solaris and Linux HyperRoll  

Work History

Work History
1999 - Present

Principal Consultant

Full 360 Inc

Full 360 is a leading provider of Business Performance Management and Business Intelligence Solutions in the Financial Services Industry. Our team has significant experience in architecting, implementing and supporting Customer Profitability, G/L reporting and Risk analytics. Full 360 has strategic partnerships with leaders in the Data Warehousing and Business Intelligence areas, including Oracle + Hyperion and HyperRoll. We have also created a unique overseas center of excellence for Financial Services Solutions in South Asia, Africa and Asia Pacific regions by leveraging our Wall St. domain expertise. INTERNAL PROJECTS AT FULL 360PROJECT: cubeFlexMay 2008 – presentImplement Oracle EPM software stack for upcoming product release of cubeFlex, a hosted infrastructure for Business Intelligence in the cloud. This is being implemented on Amazon Web Services (AWS) and Elastic Computing (EC2). PROJECT: metaControllerMaintain and extend metaController, an event driven scheduling product

Sep 2007 - Aug 2008

Datawarehouse and Reporting Architect

JPMorganChase

PROJECT: Market Risk Reporting System (MARRS)MaRRS is the risk reporting system for the Investment Banking division. The primary goal for this project was to provide flexible ad-hoc and standardized reporting for Value at Risk (VaR). This sophisticated calculation and variations thereof uses position level P&L vectors for the past 252 days. This allows the firm manage risk by accurately predicting the maximum possible losses for the following trading day.

  • Developed Data warehouse and OLAP cube design and architecture
  • Implemented radical data feed driven, near real-time cube generation architecture
  • Considered massive data volumes in the system design (6M position level records with year’s worth of P&L vectors daily)
  • Developed sophisticated MDX to calculate VaR, iVaR and mVaR
  • Tuned ASO and data warehouse to trim end to end build time from 2hrs to 5mins.
  • Hyperion EPM 9.3.1 and Oracle 10g on Solaris
Aug 2004 - Sep 2007

Datawarehouse and Reporting Architect

http://www.ml.com

PROJECT: MERRILL P&L REENGINEERING PROJECTNov 2006 to Sept 2007

  • Functional Design and Strategy
  • Platform architecture and strategy
  • Data warehouse and OLAP cube design
  • Hyperion MDM management for P&L redesign

PROJECT: GLOBAL LEGAL, MANAGEMENT AND PLANNING REPORTING SYSTEMSAug 2005 to Nov 2006

  • Engagement Management
  • Platform architecture and strategy
  • Testing Framework and Strategy using Scapa Toolset
  • Data warehouse and OLAP cube design
  • Architecture lead  for reengineering legacy data warehouse
  • Hyperion Essbase 7 and Oracle 9i on AIX

PROJECT: GLOBAL PRIVATE CLIENT – UNIT COSTING MODELAugust 2004 – July 2005

  • Engagement Management
  • Data warehouse and OLAP cube design
May 1999 - May 2004

Datawarehouse and Reporting Architect

http://www.db.com

PROJECT: Data Services, Global OLAP Reporting PlatformData Services is the centralized MIS and Information Delivery Group for the entire bank. The group’s data warehousing eporting platform supports the financial, HR and Regulatory analysis and reporting needs of the bank.

  • Developed the Overall Strategy and Vision for the platform
  • Architecture lead for reengineering legacy data warehouse
  • Designed infrastructure architecture for the platform
  • Migrated legacy environment to fully productionalized environment including Dev, Test, High Availability and DR capabilities
  • Evaluated and recommended hardware, tools and third party systems to meet performance and manageability goals
  • Designed and implemented innovation that separates the Essbase batch process from the user query  process on separate  servers, presented this solution jointly with Deutsche Bank, at global user conference
  • Evaluated, Tested and Certified HyperRoll for production worthiness.
  • Migrated select Essbase databases to HyperRoll
  • Represented Deutsche Bank at every Hyperion Customer Advisory Board Meeting, since board inception
  • Hyperion (Arbor) 5, 6x and Oracle 9i on AIX 4.3.x

Other Projects and Prior Experience

Details can be provided on request

FULL 360, 2006-2007PROJECT: ESTABLISH HYPERION CENTER OF EXCELLENCE IN MUMBAI, INDIAIBM, NEW YORK, NY, 2007PROJECT: SYSTEM 9 MIGRATION AND METACONTROLLER IMPLEMENTATIONCREDIT SUISSE, NEW YORK, NY, 2007PROJECT: CUSTOMER PROFITABILITYHDFC BANK INDIA, NY, 2007PROJECT: HYPERION SYSTEM 9 MIGRATIONEUROHYPO, NEW YORK, NY, 2006PROJECT: MANAGEMENT REPORTINGHYPERION, SANTA CLARA, CA, 2006PROJECT: CUSTOMER 360 DATA WAREHOUSE, CUSTOMER PROFITABILITY PROOF OF CONCEPTSTANDARD CHARTERED BANK, SingaporePROJECT: BASEL II DATA WAREHOUSEBANKERS TRUST, New York, NY, July ’98 to May ‘99PROJECT: CERTS: CLIENT EXPENSE REIMBURSABLE TRACKING SYSTEMPAINEWEBBER, Weehawken, New Jersey, September 1996 – June 1998PROJECT: PRODUCT DATABASE ADD-UPDATEDec ’97 to June ‘98    PROJECT: CHAIRMAN’S CONTACT MANAGEMENT APPLICATIONNov ‘97 to Dec ’97PROJECT: BILLING PROJECTAug ’97 to Nov ’97    PROJECT: CRDB ADD-UPDATESept ’96 to Aug ’97CENTER FOR INTEGRATED MANUFACTURING STUDIES, Rochester Institute of Technology, Rochester, New York

Software Application Developer : WHEELS ©March ‘96 to Sept ‘96    COLLEGE OF BUSINESS, Rochester Institute of Technology, Rochester, New York

DECIDE © & DECIDE © Administrative PackageSept. ‘95 to Sept ‘96    JOHN H. MCGEE & SONS, MONUMENTS AND MARKERS, Rochester, New York

McGee Marketing System ©March ‘92 to Sept ’95

Education

Education