Description
Summary * Architected and Implemented integrations with Essbase, Planning, FCCS which include technologies DRM, FDM/FDMEE from end to end for downstream Hyperion applications like Essbase, Planning and HFM applications. * Worked on developing ETL workflows using Hyperion DIM / Informatica 7, ODI 10g/11g and experienced in developing and administering application security process, creating users/groups, security profiles using filters. * Architected, Designed and developed Essbase (ASO & BSO with EAS and Essbase Studio) and Planning (CAPEX, OPEX, WORKFORCE) applications with triangulation and multi-currency applications. * Good understanding of Planning administration, Essbase Cube Analysis, Design and Maintenance, Essbase Database Administration upgrades, Database backups, Performance tuning and Optimization. * Worked with integrations projects with SAP, PeopleSoft (GL integrations and Chart of Accounts), Oracle EBS (OBIEE, BI Apps), Tableau and Hyperion suite with Essbase, FCCS, PBCS, Hyperion Planning, HFM, DRM, HFR FDMEE, ODI tools. * Provide solid consulting presentation and delivery services for industry corporations ranging from small to fortune 500 across various sectors from healthcare, consumer goods, technology, services, retail, investment, biotech and industrial goods both domestically and internationally. Worked independently as well as amongst and or led teams of 3-6 at times. * Supporting details Oracle Certified Essbase developer and experienced with Planning/Administrator/Financial Reports with 15+ years of IT experience in Financial Services (Loans, Mortgage, e-commerce models), Banking, E-commerce, Insurance, Healthcare and 16yrs of total experience in Advanced research facilities, software programming, Six sigma methodologies, Project management etc * Designing and implementing Hyperion solutions to cater solutions based on accounting standards like IFRS (International Financial Reporting Standard), SAP (Statutory Accounting Principles) and GAAP (Generally Accepted Accounting Principles) standards. * Experienced in writing Calc Scripts, Report Scripts, Maxl scripts and Load rules, DL/WB rules Good Exposure on Hyperion Planning, Essbase and consolidation applications. Business Intelligence Skills Essbase EAS and Essbase Studio, HTP, PBCS, EPBCS, FCCS, Hyperion Planning (HSF, Hyperion Budgeting and Forecasting) IR/Web Analysis / SQR Reporting, Hyperion Financial Reporting (HFR), EPMA, DRM, Shared services security. Classic Wizard Planning Apps, Financial Reports (HFR), EPMA ASO, Business Rules/ Calc Manager Profitability and Cost Management, SQL, SQL/PLSQL, Teradata, SAP ECM Smart View (11.1.2.2/1), Hyperion Visual Explorer (HVE), DODECA, EXCEL add-in, APS. Calc Scripts/Report Scripts, Shared Services, EIS, EPMA, DRM, DRG, ODI and FDM ( FDMEE and ERPi) Erpi / FDM, FDMEE, DRM, ODI 11g, 10g, EBS, Informatica, PeopleSoft Excel Add-in, Outline Extractor OBIEE, OBIA, Microstrategy, BI Apps Information Technology Skills EPM Oracle EBS, OBIEE, Python, Jython, Perl, EPMA, EAS, Oracle DRM, ETL Process Java, C, C++, ASP (VB Script, Java Script), DHTML, Perl Weblogic Admin, IIS Admin, Endeca Requirements analysis, gatherings and Client interfacing Microsoft SQL Server 2005 / Oracle 10g Unix Shell Scripting, Linux, MAXL, ESSCMD, Windows batches Redhat Linux, Unix, WebLogic, Apache, Windows 2003/2008 Server MS Office Suite & Project CMMI Level 5 & Sixsigma (certified
Accomplishments
Highlights:
Keywords
