Download PDF

Skills

Other Technologies and Skills
Scapa Stress Testing Platform Executive Viewer (Temtech) Proclarity Visual Basic 6 + .NET
Operating Systems
Windows AIX Linux Solaris Amazon Elastic Computing (EC2)
Oracle 8i, 9i, 10g
BI/OLAP Tools
Oracle EPM Oracle Business inteligence (OBIEE) 10.1.3.4 Oracle Essbase 6.x - 11.x on Windows, AIX, Solaris and Linux MS OLAP Clarity FSR Cognos TM1

Work History

2008Present

AVP

Credit Suisse

  • Act as project manager and key stakeholder liaison for significant RTB projects and initiatives.
  • RTB BOW managment for L3 activities.
  • Act as a Application support lead and escalation point for run the bank team in New York.
  • Maintenance, Enhancement and bug fixes including technical competencies like Oracle Essbase, VB Api's, Oracle EPM, Oracle business intelligence (OBIEE), TM1 and Clarity FSR.
  • Assist Technical SME's in project design.
  • Application performance tuning and batch improvements.
  • Production incident tickets review and management.
  • Release co-ordination and act as a gate keeper for production releases.
  • Work closely with Oracle engineers to resolve software bugs and patches.
  • Manage NYK RTB resource.
Aug 2008Nov 2008

Senior Consultant

Full 360 Inc

Full 360 is a leading provider of Business Performance Management and Business Intelligence Solutions in the Financial Services Industry. The  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. Full 360 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 – Nov 2008->Implement 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).

 -> Design and develop Essbase database to host on cloud.

 -> Automation of Essbase cube build and data load using EIS.

 -> OBIEE dashboard design and devlopment for customer POC on amazon cloud.

-> OBIEE integration in EPM workspace.

-> Single sign on implementaion accors OBIIE and EPM worspace using custom autentication.

-> EPM Financial reports design and development.

-> FR batch command line batch schedling automation using unix wrapper scripts.

-> EPM workspace folder design and secuirty implementation.

-> Design overall Security matrix in EPM share services.

-> Security automation using Java Api's

-> Automation of essbase cube back and recovery using Amzamon S3.

-> Level3 support for cubeFlex.

Dec 2007Aug 2008

Senior Hyperion Consultant

JP Morgan Chase

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.

Responsibilities:

  • Designed a robust, scalable, structured, efficient cube delivery platform which gets the feeds from different source systems (LOB's) into the data mart
  • Designed customize framework for adding additional LOB’s cubes. All the code is reusable.
  • Sophisticated process that built two cubes one daily snapshot and one comparison that restructured the data with current day hierarchies
  • Table driven data staging for loads (reduced load time to 5 mins for 1 day data)
  • Sophisticated process that built two cubes one daily snapshot and one comparison that restructured the data with current day hierarchies
  • A reduction of the cube build time from 1hr+ to 5mins
  • Developed a automated customized query materialization which reduced the retrieve time from 5 min+ to 10-8 secs.
  • Developed a various MDX queries based on common user queries for query materialization.
  • Designed outline query hint for Materialization.
  • Developed a Reference cube to the daily snapshot cube in order to report based on old hierarchies with the current data. Made use of reference cube concept to improve the performance. 
  • Created wrapper shell scripts (parameter driven) to automate the process.
  • Implemented robust data-access security and user management
  • Package the cube and re-create them from a particular day (needed for As-of-day hierarchy), this whole process takes less than 10min’s.
  • BPM interaction for kicking of the cube build. 
Oct 2007Apr 2008

Senior Consultant

Credit Suisse is a leader in investment banking, financial services, Assets management, Personal Banking and Securities, was involved in design, develop and supporting various applications of CS.  Responsibilities:       . 

  • Framework design for hyperion system 9 platform
  • Installation and configuration of Hyperion system 9 products.
  • Design and develop Revenue application for Client Profitability team.
  • Design and develop Country application for Client Profitability team.
  • Conceptualize the design and manage the development of Forecasting/Reporting/Budgeting Essbase  application for the investment-banking department.
  • Design and develop IT-Cost transparency application for Asset management department.
  • Developed a customized Essbase cascade function using Excel VBA and Essbase VB API to pick a group of members and generate reports automatically.
  • Design and developed a global security sweep system between peoplesoft and essbase global application of Credit-Sussie.
  • Designed and developed IT-Cost ASO cube with various MDX formulas.
  • Automated routine operations using Maxl, VB API’s , EIS and Control-M.
  • Determined and implemented performance optimizations for over a half dozen Hyperion Essbase cubes
  • Involved in unit, system and regression testing.
  • Responsible for maintaining and supporting existing projects in production.
  • Design and develop various highly formatted reports in financial reporting Web analysis and Interactive reporting.
  • Developed various static reports Using Hyperion Smart View and Smart View Api’s
  • Integrated Hyperion workspace into Credit Suisse Clients@ portal.
  • Developed various SQL queries to extract data from source system.
  • Act as a Systems Administrator/Developer for Hyperion Essbase upgrade projects.
  • Train end users and various IT team on Hyperion Essbase software via formal classroom training
Jun 2006Aug 2007

Consultant

Credit Suisse
  • Framework design for hyperion system 9 platform
  • Installation and configuration of Hyperion system 9 products.
  • Design and develop Revenue application for Client Profitability team.
  • Design and develop Country application for Client Profitability team.
  • Conceptualize the design and manage the development of Forecasting/Reporting/Budgeting Essbase  application for the investment-banking department.
  • Design and develop IT-Cost transparency application for Asset management department.
  • Developed a customized Essbase cascade function using Excel VBA and Essbase VB API to pick a group of members and generate reports automatically.
  • Design and developed a global security sweep system between peoplesoft and essbase global application of Credit-Sussie.
  • Designed and developed IT-Cost ASO cube with various MDX formulas.
  • Automated routine operations using Maxl, VB API’s , EIS and Control-M.
  • Determined and implemented performance optimizations for over a half dozen Hyperion Essbase cubes
  • Involved in unit, system and regression testing.
  • Responsible for maintaining and supporting existing projects in production.
  • Design and develop various highly formatted reports in financial reporting Web analysis and Interactive reporting.
  • Developed various static reports Using Hyperion Smart View and Smart View Api’s
  • Sep 2003Jun 2006

    Developer

    Hewlett-Packard is a technology company that provides wide range of solutions in Imaging, Printing and enterprise servers, was involved in design, develop and supporting various applications of Imaging and Printing group department.

     Responsibilities:

    • Responsible for Developing, maintaining and supporting IPG suite of Finance applications for EMEA region. The entire suite consists of 14 applications each having a unique objective viz., Shipments, Expenses, Discounts, Marketing, and Headcount etc.
    • Monitoring and resolving various applications on production environment and taking proactive measures to maintain the application health
    • Involved in planning the support activities to provide better quality of support.
    • Developed data load rule files to load data based on ad-hoc user requirements
    • Provided technical solution within the team and also created automated jobs which reduced manual monitoring of production jobs on daily basis
    • Responsible for communicating the support processes within the team and to the customers.
    • Actively participated in Testing, UAT, Move to Test, and Move to productions of new releases.
    • Involved in developing new functionalities for the applications.
    • Involved developing calculation scripts and reports in Essbase.
    • Involved in performance tuning of essbase. Build multi-dimensional database and designed standard dimension, attribute, members and security.
    • Designed dynamic dimension building using incremental build.
    • Loading text data files using load rules into Hyperion Essbase
    • Responsible for defining and implementing Security Matrix.
    • Prepare data load file, design rule file, load data using the rule file and calculate database.
    • Maintained security and added/deleted users per management requests.
    • Performed monthly backups of Hyperion Essbase data.
    • Used Excel VBA to model and develop financial reports for using in Hyperion Essbase.
    • Created a brio queries to extract data from different legacy source systems.
    • Created security plan to manage security at user and group layer, global access layer and Server level.
    • Created executive and proclarity reports based on user requirements.
    • Developed several Reports for Hyperion, validating and reconciling data using Retrieve Excel Spreadsheets and Executive viewer reports.
    • Automated routine operations using ESSCMD and ESSMSH.
    • Provided troubleshooting and advice to improve the current Essbase database. This included adjusting the layout and configuration of the load rules and outlines.

    Other Projects and Prior Experience

    Details can be provided on request

    ALPHA TECHNOLOGIES, 2003

    PROJECT: ALPHA GL CUBE

    PROJECT:BILLING PROJECT

    HCL TECHNOLOGIES, 2000-2002

    PROJECT: CUSTOMER PROFITABILITY

    PROJECT: HYPERION 7 MIGRATION

    PROJECT: ETHERNET DEVICE DRIVER

    Education