Danish Kumar Hotta
Mobile: +61 431818724
Email:
Website: www.danishhotta.com
Nationality: Indian
Status: Married
Location:Sydney, Australia
Visa: 457
Executive Summary
Dedicated, focused, energetic and analytical BI professional having around 8.5 years of experience in Data Warehousing. Experienced in various working domain viz. 5.5 years of experience in Banking/Finance domain, 3 years in Telco and Other domains. Expert working with multi-cultural and multi-regional teams. Seeking a position where I can leverage my broad knowledge of business intelligence, financial reporting, project management, and software development to lead and plan the analysis, architecture and development of software solutions to answer business challenges.
Specialist Skills:
· Consulting on Hyperion suite of Applications. Worked on various versions of Hyperion viz. 6.5, 7.x, 9.x and 11.x.
· Strong experience in analysing, designing, developing, implementing, tuning and supporting the Oracle Suite of tools as Hyperion Essbase, Planning, HFM, FR, WA, IR and OBIEE. Managing infrastructure, Architecture and Technology aspects of Projects.
· Leading Support and Development teams, vendor management, resource management, leading Hyperion initiatives and SQA. Supporting new initiatives related to Hyperion technologies.
· Adhering to SDLC processes. Follow project management process and adherence to company guidelines and policies.
· Experience on Dashboards such as OBIEE and Microstrategy. Integrating Dashboards and BI functionalities to create Enterprise Reporting framework.
· Core understanding of Banking and Finance domain knowledge. Equipped with financial knowledge of Planning, Budgeting, IT Rollover, Forecasting, Budget allocation, Enterprise Reporting and MIS reporting.
· Good experience with various aspects of project management: project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation.
Personal and professional skills:
· Excel at mentoring and coaching team members and other colleagues
· Open to off work hours, new technologies and working environments.
· Very efficient and fast, self-learner.
· Strong knowledge of Business and Technology.
Experience Summary
Hyperion EPM:
1. Environment setup, Installation, configuration, troubleshooting and upgrade Hyperion systems on 9x and 11x versions. Worked on OS environments such as AIX (5.1, 7.1), Windows (2k0, 2k3, 2k8) and Linux (Exalytics Box). Extensive experience working on databases like Oracle 9i & 11g, Teradata 12, MS SQL server 2k5 and MS Access.
2. Design hardware specs, architect multi-tier Hyperion framework, interface setup, user training, optimize hyperion applications, establish multi level security, develop, test and implement changes.
3. Worked and managed projects on Hyperion Essbase, Planning, HFM, FR, IR, WA, Shared Services, add-in, smartview, workspace, LDAP config, Data Integrator and Provide services. Worked on versions 6.5, 7.1.3, 9.3.1, 9.3.3, 11.1.1.3, 11.1.2.2 and 11.1.2.3. Performed ETL on ODI 10 & 11 versions.
- Developed Planning Objects, created Jobs in ODI, design reports in IR and WA, optimized pre-existing scripts, writing and running rule files, report scripts, calculation scripts, writing MAXL scripts, writing rule files, MDX script conversion, cube refresh and archive scripts, Users and group management (security related). Writing PL/SQL and optimising queries, creating views, indexes, packages and triggers in SQL.
Project Management and Project Life Cycle:
1. Managed projects ranging from $2M to $300K cost. Managed BAU projects with fixed cost billing and Development team with UR based model. Prepared BCP environments for Hyperion systems.
2. Lead multiple teams ranging from 4 to 8. Lead Dev and Support teams simultaneously.
3. Did vendor management for 2 projects, working also as an SQA and Architect. Mentored projects not only from application prospects but also on Infrastructure and compliance.
4. Created SLA dashboards, Monthly management reports, weekly progress reports, CR reports and tickets analysis related to Support. Performed RTM, status update, progress follow ups, SQA, and documentation related to development. Preparing and adhering systems to meet Audit requirements from MAS. Presented during Release board, project status meeting and monthly management meetings. Done POC for new tools such as Microstrategy.
5. Helped in pre-sales by providing adequate info on Project estimation and system requirements. Responsible for Requirement analysis, Developing minor (1 week) to major (6 months) projects, performing testing (both unit and system), UAT support, production release (following proper release procedures), post production support, enhancing and maintaining current system, full cycle support (L2 and L3), designing Visio’s, documenting procedures, version management in SCM. Created DR environment for existing Prod Hyperion systems.
Other Tools:
1. Developer/Architect level experience in Clarity Performance Management (Budgeting, Forecasting & Planning tool) 5, 6 and 6.1, JS and VB coding, ASP page modifications, Oracle Forms and Reports. POC in BODI, OBIEE and Microstrategy. Active part of Cognos and BO competencies. Used SQL query tools e.g Toad and Rapid SQL.
2. Microsoft Excel 2000 and 2003, working on VBA macro’s, developing reports, writing complicated formulas, formatting reports developed in excel, running macros, converting complex Excel reports to clarity reports.
Work Experience Details
Qubix Technologies, Sydney Hyperion Consultant Sep’13 - Till Date
1. Telco Client (Sep’13 to Till Date): I was part of a BI project, which was initiated in direction to i. upgrade the existing Windows servers to Exalytics box ii. Upgrade from EPM 11.1.1.3 to 11.1.2.3 iii. Create additional Finance and Summary applications with more efficient data distributions.. Tools: Exalytics, EPM 11.1.2.3, ODI 11, Oracle 11g, Teradata 12.
Roles Performed:
a. Interacting with end clients to gather specific requirements to the module I developed. Meeting the client standards and guidelines, while delivering the deliverables.
b. Customization of smartview installations. To remove Oracle known bugs, customize SV options for user and add connections by default after installations.
c. Planning migration from 11.1.1.3 to 11.1.2.3. Creating customized migration strategy, due to challenges in client environment. Migrating artifacts including Forms, Business Rules (including sequences, rules, macros), Database objects, data and security. Individual contributor for the task and completed in 2 weeks.
d. Created new Finance planning applications to allow reporting & forecasting on finance lines. ODI was used to extract data/metadata from EBS and GL (based of Teradata). The ODI objects were developed under ODI framework defined for the client. It has interfaces for finance admin group to be able to perform adjustments to metadata, through file loads. I have performed necessary performance tuning during development, since the volume of the application was huge (100k members and 15G data). Created Business Rules for agg and data copy.
e. Proof of concept for using ASO as a plan type. ASO plan type was a new feature with 11.1.2.3. But the pros/cons were unknown for the technology. POC was done on the client environment and was determined that ASO can be used as an aggregation cube and perform forecasting on the application. The cons were that BR and calc cannot be executed on Planning ASO apps. BR's couldn't be associated for an ASO plan type, so customized BR's were used including Shell and Maxl scripting to perform the needful. The approach was then accepted for future applications.
f. Proof of concept for high dimensionality for BSO planning applications. There were 13 dimensions chosen for the POC which had members upto 20k. Data sizes were loaded upto 14 GB. The applications were tuned for Exalytics env and performance optimizations performed.
g. Creating Test sheets, reports and harnesses related to Smartview implementations, Planning migrations and new planning applications. Working with the Testing team to cover all areas of testing. Managing SQL database requests and advising the DBA's to process on request. Deciding the DB strategy to meet the needs of EPM components. Performing Dev, SIT & UAT migrations and test harnesses.
NCS (Client Bank, Singapore) Hyperion Project Lead Dec ‘10 to Sep’13
NCS undertakes the Support and Development for the T&O department for one of the best banks of Singapore. I was managing all the Support and Development for the client’s Finance BI applications. Below are the applications I lead. Each has its own setup and set of users.
· Decision Support System Hyperion: It comprises of a budgeting, actuals, risk calculation, balance sheet and allocation application. Uses Hyperion Essbase, Planning and Excel add-in
· Financial Management System: This includes one application used for consolidation data from GL and provides adequate reporting for Finance. Uses Hyperion HFM, FR and ODI.
· HK Management Information System: It is used to generate dashboards for HK finance to perform reporting. Uses OBIEE, FR and Essbase.
Below are my primary responsibilities:
ó Ensure the Project team gets adequate information to drive projects and deliver onto Client’s expectation. There on the project is lead and enhanced under my supervision. I was responsible to any activities that are further carried on, for those applications.
ó Ensuring the live projects meet the client’s standard and compliance needs. The projects have to meet MAS standards as well. Extend help to PM on Hyperion architecture design and adherence to the current methodologies.
ó Lead the Planning enhancements which are key KPI for the planning and budgeting system. Introduced enhanced processes like Cost Allocations, A2B, B2A, Currency rebasing, ABM cube modelling and Forecast transfer. Successful rollout and flawless support for Budgeting FY12 and FY13. Provided optimized solutions for faster user retrievals and faster nightly batches.
ó Performed DR setup for the existing Production environment. Coordinated with Infra and NW teams to arrange the full setup of DR in multi system environment. It was followed by SAN sync, DR Drill, BCP. System drill for source/target connectivity, RTO and data quality was performed. Preparing DR documents and Technical manual. Successfully guided the Support team to 2 cycles of DR drill. Also lead the team for Hyperion product upgrade from 9.3.1 to 11.1.2.1. I was involved in system architecture designing, acquiring HW, dealing with Infra, application installation and migration and managing stakeholders.
ó Ensure the weekly, monthly and yearly batches for the applications run smoothly. Support the monthly process of GL consolidations and reconciliations for the HFM application to ensure the monthly reports are generated as requested and on schedule. Also support actuals PnL and balance sheet reporting for the Finance. Similarly ensure that the HK Finance have the dashboards populated with actuals MIS data for monthly reporting.
ó Created Weekly and Monthly reports for SLA and performance, and presented the same to NCS Management. Advised ticket analysis to improve the support process. Categorized tickets to SR, BF, etc. implemented CR’s and Implementation with required release procedures. Maintained documentation and performed audit checks to ensure proper Audit compliance. Walkthrough existing functional ID’s and did changes to meet security policies and guidelines. Arrange for yearly resource allocation meeting and provide resource activity sheets to justify additional FTE for support. At the same time, advise resource sharing techniques to ensure proper resource utilization with effective support model. I was also responsible for resource hiring and on/off boarding processes.
ó Developing the Business Recovery Plan and setting up the Disaster Recovery for the environments. Participating in the corporate wide DR drills and ensuring the DR systems can be activated and used in the stipulated RTO and RPO.
OCBC Bank, SingaporeIT Manager Dec ‘09 to Dec ‘10
OCBC Bank is second largest financial services group in Southeast Asia, classified by assets. Working as an IT Manager at OCBC, I was responsible for enhancements to the existing system, optimizing the system and supporting the system.
Global MIS
Global MIS was an initiative to enhance current SG MIS and develop the MY MIS, finally merging into a single Global MIS. This would then serve as a central reporting system for the MIS stream and few non MIS stream as well. For the project, I was performing the role of a Hyperion Architect and Lead. Below were the responsibilities.
ó Provided workshop for the MY users to understand the existing system and build their UR. Based on the training and inputs provided, MY users developed the BRD for the project.
ó Interacting with the SG and MY Finance counterparts to collect the requirements, help them create the FS, prepare SOW and obtain necessary approvals.
ó Architect the new systems to adhere the existing EIS architecture. Ensure the SDLC standards were met and MAS audit requirements were followed through the project.
ó Perform Vendor management, by ensuring timely deliverables of the Project modules. Performing the SQA role on part of the bank, for all the Hyperion modules.
ó Integrate and interface the Hyperion Applications with the FDM (Financial Data Mart) and ensuring optimized database queries to avoid performance issues.
ó Achieved “Star Award” for the project for my contribution in, educating the Finance users to understand Hyperion functionalities. This helped the users to correctly state their requirements for the BRD and helped developers to deliver the needful Essbase applications.
Below are the other projects and responsibilities I had undertaken:
1. Hyperion Planning: The MIS and capital planning system runs during the August to December period for generating the Budgeted figures for MIS. I was involved in the tool setup, application managing and registration, outline preparation, migrating and modifying BR’s and initial Security setup. The webforms were generated and maintained by the users. During the planning cycle my responsibilities were to ensure the availability of the system, perform regular restart of services (to kill hanging HBR sessions), and look over the daily batches. I had to ensure the Budget Users were able to perform the Planning cycle under the SLA and within the budget cycle.
2. Dprime Reporting: Dprime is the MIS reporting system for OCBC. It uses Hyperion, BO and SAS tools for reporting. Financial reports were developed using Hyperion IR and WA 9.3.1. The IR reports were connected to Teradata and WA reports were connected to the Essbase Cubes.
ó Environment and project management: I was responsible for configuring Hyperion Suite and related technologies, services start and stop, troubleshooting server issues. Involved in DR activities and server patches. Also involved in project estimation, process implementation and application release.
ó Report creation and Security setup: There were 88 reports and around 115 user setup done for the MIS reporting. I was responsible for understanding all the reports and perform enhancements wherever required. Also generated new reports post live. There are total of 5 ASO cubes with daily and monthly batches running and I was responsible for all the maintenance and L2 support for issues.