Vijal Chokshi

Sr EPM Hyperion Consultant

add664@r.postjobfree.com

https://www.linkedin.com/in/vijal-chokshi-6ba40335/ Tel: 201-***-****

Professional Summary

● 10+ years of experience consisting of Analysis, Design, Implementation, Business Intelligence, Decision Support systems in Financial & Business applications, Testing and Documentation.

● Working knowledge of planning, budgeting, forecasting and financial consolidation /packaged application functionality processes and features for OOD (Oracle on Demand), on-premises and on CLOUD PBCS/FCCS as well.

● Hands on experience in OLAP Application Development and Administration using Hyperion Essbase, DRM, EPMA, Hyperion Planning, Hyperion Analyzer- Web Analysis Studio, Hyperion Financial Reports, Smart View, Excel Add- in, Essbase Studio, Essbase Integration services, HFM in Windows and Unix environment.

● Expert level skills in Hyperion suite of products, specifically Essbase, Hyperion Planning, HFM, Hyperion Reporting and FDM.

● Expertise in creating OLAP Cubes – MOLAP, ROLAP and HOLAP using Star and snowflake Schema.

● Extensive experience in Design, Analysis, Development and Implementation of various applications in client/server OLAP environment using DRM, Hyperion Planning, EPMA, Hyperion Essbase, Hyperion planning and Hyperion reports, Essbase Integration Services, Essbase Studio on both Windows and Unix environments.

● Expert in creating reports using Web Analysis, Interactive Reporting and Financial Reporting. Experienced in developing, maintaining and supporting financial applications using versions 11(Fusion Edition) and System 9 BI+.

● Experience using Business Rules, Calc scripts, Data Load Rules, Architecture, Design, Business Logic, Performance tuning, Report development and all the areas related to whole life cycle of Essbase application implementation.

● Expert in FDM, ERPi, EPMA, Financial Reporting, Security, Calc Manager and Smart View.

● Expert in building the hierarchies from MDM / DRM, Import/export process, Blenders, various metadata validation processes.

● Created both Block Storage Applications (BSO) and Aggregate storage applications (ASO).

● Strong Understanding of Dense and Sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed, and optimized report queries.

● Proficient in building Standard and Attribute Dimensions dynamically using dimension build methods such as Generation References, Level References and Parent-Child Method.

● Experience in Maintenance and Administration of Hyperion Essbase Cubes, strong experience in Data loading using Rule files, ESSCMD, Essbase Integration Services, Essbase Studio. Expertise in writing ESSCMD and MaxL Commands, MDX querying, Report scripts.

● Experience in creating and maintaining the Hyperion Planning application, Data Forms, Business Rules, Menus, Task Lists & Loading the Data from flat files and interface tables.

● Proficient in Excel Add-in and Hyperion Smart view. Experience with providing training to business users and technical team members on OLAP concepts, Excel Add-in and Smart View.

● Proficient in technical documentation including Design, SLAs, Requirements, Application Maintenance and troubleshooting documentation. Worked in varied environments of Development, and Maintenance projects with excellent result-oriented approach.

● Proficient in technical documentation including Design, SLAs, Requirements, Application Maintenance and troubleshooting documentation. Worked in varied environments of Development, and Maintenance projects with excellent result-oriented approach.

● Lead a team of technical experts - DevOps engineers who manage cloud server environments using automation tools such as Ansible, Kubernetes, and Terraform

● Lead continual improvement efforts and develop a strategic roadmap for DevOps offerings

● Direct technical leads to enhance and improve technical value of DevOps products and offerings

● Responsible for ownership of DevOps offerings including service definitions (SOWs) and pricing structure.

● Participate in pre-sales scoping discussions with IT staff and customers and represent offerings to technical and nontechnical audiences.

● Database- Experience working with Relational & NoSQL databases as well as in-memory caches

(Redis/Memcached)

● Working hand in hand with great DevOps engineers building out DevOps best practices in the federal space. This will include creating and document CI/CD jobs, creating infrastructure with terraform, writing ansible playbooks, and building tools.

● In-depth experience with config management tools like: Chef, Ansible, Puppet, Salt Stack, Technical Skills

Cloud: AWS EC2, EBS, S3, load balancers, SQS/SNS, Dynamo DB, AWS AMI custom images & cloning, EC2 bootstrapping, EMR, Auto scaling configuration, AWS IAM security, Cloud Forms, VPC/Subnet concepts. Languages: Python, Perl, Shell, Ruby and a working knowledge of Golang (Go) Continuous Integration: Jenkins, Bamboo, VSTS, Cruise Control Continuous Delivery/Configuration Management: Puppet, Ansible, Salt Stack, Bamboo Code Repos: GIT, TFS, Bitbucket

Agile: JIRA, Confluence, VSTS

Microservices: Docker, Kubernetes, OpenShift, Swarm, Mesos Analytics and databases: Snowflake Data Wearhouse, PostgreSQL, MySQL, MongoDB, Cassandra Professional Experience

General Electric Company (GE), 191 Rosa Parks St, Cincinnati, OH 45202 From: 05/01/2017 To Present

Job Title: Sr. EPM Hyperion DevOps Manager

Job Duties

• Responsible for the design, development and operational support for GE EPM Hyperion applications which include PBCS, Oracle Hyperion Financial Management (HFM), Hyperion Planning, Hyperion Essbase, Financial Data Quality Management Enterprise Edition (FDMEE), Data Relationship Management and Automic Software.

• Administer the Oracle Hyperion Planning (PBCS/EPBCS) Application, and related Enterprise Performance Management (EPM) components including the creation and maintenance of models, forms, rules, reports, dashboards, and other elements associated with maintaining an Enterprise wide application.

• Work with cross-functional teams to define EPM\Cloud strategy and roadmap, define and deliver features and execute the roadmap with high quality

• Partner and work closely with Hyperion DevOps team members and Functional Business partners on EPM initiatives such as Financial Consolidation, Intercompany Elimination, SOX Compliance, Cash Flow Analysis and External Reporting using Hyperion Financial Management (HFM).

• Manage the development of break-fixes, enhancements, releases, and patches of ES HFM code set Business Rule file to the Release timetable set by the ES HFM Manager.

• Administering Oracle Hyperion EPM suite of products (DRM, Essbase, SmartView, Planning and HFM) Linux/Windows systems administration, database design and optimization, AWS/Azure cloud migration.

• Provide infrastructure/operations support for server maintenance activities such as disk space management, backups and application patches. Implement solutions towards a continuous deployment and continuous integration

(CI/CD), implement, with strict development timeline.

• Validated latest GE ES HFM Business Rules Logic with intercompany eliminations, chart of accounts design, metadata hierarchies and custom attributes such as Supplemental details and financial reporting.

• Worked on DRM (Data Relationship Management) for HFM and ERP Chart of Account Governance and maintenance.

• Managed and define integration rules for financial consolidation and close process, optimize close cycle and minimize manual intervention/work during close process.

• Created data forms, data grids, financial reports, rules scripts, member lists, journal module, objects, consolidation sequence and data clearing procedures to optimize HFM consolidation.

• Developed and maintain Hyperion User Security, Data Forms, Data Grid and HFM task flows as per GE business requirements.

• Worked with application developers to determine how enterprise infrastructure will optimize for efficient Quarter close, while promoting adherence to analysis, design, and development standards and methodologies.

• Created automated ODI integration Process to perform reconciliation between local ERP and HFM.

• Partner with Corporate Finance IT and GE Business Unit IT organizations to define requirements, establish plans and execute accordingly.

• Worked on HFM Optimization to reduce consolidation time from 60 min to 35 min.

• Analyze impact of move from On-premise to Oracle Cloud for PBCS, FCCS and Data management and perform fit- gap analysis

• Managed documentation of Business Requirements gathered using Client interactions, Brainstorming Sessions; Evaluating Data Sources, Translating Requirements into SOW.

• Worked on Business rules development, Customized Data form design, Task list creation, planning process management and Hyperion shared services security management.

• Deep understanding and application of Agile approaches and techniques, such as XP, Scrum, Kanban, User Stories, TDD, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Exposure to cloud product PBCS and Data Management, VBA and Essbase API

• Expertise in Functional Testing to ensure a Data Quality after Migration and experience in conducting User Acceptance Testing (UAT) to ensure business requirements have been fulfilled.

• Strong ability to thoroughly document User Manuals after subsequent releases and conducting User Training Workshops to familiarize Business users to the changes in Hyperion system.

• Critically review and analyze current standards, processes, tools, and operational metrics in order to recommend and implement changes leading to Hyperion best practices.

• DRM implementation project with integration of R12(EBS), DWH tables, EPMA and Classic Planning.

• Proactively drive the prioritization and resource planning of IT work to support business objectives and key initiatives for Controllership and Financial Planning and Analysis (FP&A).

• Setup, integrate, and maintain a scalable, stable set of CI/CD tools to support development, testing, and security scanning.

• Build, Publish and Automate the deployment of Docker images on Kubernetes.

• Install, configure, test, and maintain containerization and orchestration management tools

• Take ownership of tools used in our pipeline such as Red Hat Open Shift, Jenkins, SonarQube, Nets parker, Artifactory and SoapUI.

• Work with business stakeholders and senior leaders to deliver on Cloud initiatives that are a part of the company's overall strategic direction

• Working knowledge of supporting IT infrastructure technologies and standards including software & hardware life cycle, system configuration policies, security, hardening, high availability, disaster recovery etc.

• Proficiency with Windows OS, RedHat Linux, Mac OS, IIS, and Active Directory

• Unify CI and CD expertise to ensure an integrated tool suite into one pipeline.

• Ability to automate and orchestrate using Ansible.

• Experience in SQL architecture such as MySQL, PostgreSQL or MS-SQ

• Ability to create and support AWS environments and Terraform Employer: Essential Technologies, GA 1586 ATKINSON RD, STE 108, LWARENCEVILLE GA 30043 Client: United Services Automobile Association (USAA), San Antonio From: 03/01/2016 To 04/30/2017

Job Title: Sr. Programmer Analyst (Oracle Hyperion Developer) Job Duties

• Designed Integrated Planning and Consolidation solution with Hyperion (EPM) suits of products(PBCS, HFM, Planning, Essbase, DRM, ODI, SmartView).

• Worked with application stakeholders to gather business requirements, document current business process, perform fit-gap analysis, design future process, design system integrations, perform data migrations and set up solutions using industry best practices for Hyperion.

• Managed Agile Methodology; translate unstructured or ambiguous work requests into actionable user stories and work units through problem decomposition and planning

• Developed all application metadata, data loads and reconciliations, serves as contact for all user inquiries, and works closely with the accounting and FP&A team to design and improve planning and reporting processes with Hyperion Applications.

• Supported consolidation process of monthly flash data, perform necessary checks and work closely with controllership and FP&A finance teams to ensure timely financial reporting.

• Worked on business requirements for HFM metadata, business rule, data form, security and reporting solution.

• Developed the Calculation scripts to calculate complex values like Currencies, Acquisition Cost, Gross Margin / Inventory Turn, Revenue / Payroll, Total Head Count, Revenue per QTY, Revenue per Square Foot, Return on Assets, Property, Plant & Equipment, Cash Cost per User and YTD Commitment & Variance.

• Created integration script in FDM to connect to and load data directly from Oracle GL tables, instead of first exporting to a flat file and then loading.

• Provided strategic oversight, tactical and operational leadership to drive team optimization and individual team member growth.

• Created an enterprise view of financial chart accounts, with the help of Hyperion DRM, with a view to govern ongoing financial management and consolidations.

• Managed system requirements performed design and analysis, and coding and unit testing of complex to highly complex system functionality and defect correction across multiple platforms.

• Developed and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes.

• Worked extensively in developing complex business rules to spread variance between actual and current forecast scenario.

• Developed Web Forms, Composite Web Forms, Menu, Task Lists, and User Variables based on the Functional and Technical Requirements requested by the business.

• Built loads into EPMA IM tables, launch EPMA scripts, and build loads directly into Essbase and launch Essbase calc scripts.

• Managed Metadata and Security using Web based Planning and applied Security to the members of the following dimensions: Account, Scenario, Entity, Product, and Version.

• Worked with Oracle/Hyperion Support team to resolve issues and reported new Bugs in the software.

• Periodically review and analyze current standards, processes, tools, and operational metrics in order to recommend and implement changes leading to best practice operations.

• Identifies and creates solutions to improve system performance and availability, performed root cause analysis of system issues to minimize impact and future occurrences. Employer: Essential Technologies, GA 1586 ATKINSON RD, STE 108, LAWRENCEVILLE GA 30043 Client: General Electric Company, Houston, TX

From: 06/01/2013 To 02/28/2016

Job Title: Sr. Programmer Analyst (Oracle Hyperion Developer) Job Duties

• Participated into the design, code review meetings to ensure the compliance as per the GE standards of the organization and SOX compliance.

• Configuration of Hyperion Financial Management, Hyperion Planning, Hyperion Essbase, Hyperion Financial Reporting, Hyperion Web Analysis, Oracle Hyperion SmartView.

• Engaged with GE business partners, IT Teams, Offshore teams and consulting partners to ensure solutions developed meet deliverables and transform GE.

• Implemented Oracle Planning and Budgeting Cloud Services (PBCS) R11.1.2.3 which enable improved reporting, analysis and decision support of business processes.

• Designed Hyperion planning application for US Profit &Loss, Balance Sheet and Capex planning.

• Developed task list and process management for quarterly rolling forecast.

• Worked on functional requirements for capital asset-related expenses, driver-based calculations and financial reporting.

• Managed users and roles on Oracle Identity Manager(IDM) across all cloud services.

• Monitor active, expired and pending services on Oracle Cloud Support Dashboard.

• Migrated On – Premises Hyperion apps to Oracle Planning and Budgeting Cloud Service Production Environment

• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning and optimization of calc scripts and tuning of calc cache.

• Automation of dynamic dimension building & Loading into the Cube using MaxL Scripts.

• Managed queries, tables, and relational references, and maintaining the referential and data integrity with PL/SQL.

• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.

• Worked with star schema using extended analytics to integrate with Oracle 11g and HFM to transfer the actual data from HFM to Planning and Essbase.

• Designed seamless integration with Oracle EBS using FDMEE, along with write back capabilities.

• Created reports using Hyperion Financial Reports and Smart view (Excel Add-In) from HFM (Hyperion Financial Management) and Hyperion Planning.

• Managed version upgrade from 11.1.2.2 to 11.1.2.3 for HFM, FDMEE, Essbase & Planning.

• Managed Hyperion Infrastructure with Windows\Unix operation system, WebLogic app server & SiteMinder capabilities.

• Managed data reconciliation and maintain data integrity of information being collected and uploaded into HFM application utilizing FDM and other Oracle standard tools

• Worked with FP&A staff for their monthly and quarterly reporting requirement with Hyperion Planning and Financial Reporting Studio.

• Developed process and procedure for overall database and applications IT operations, production controls, capacity planning, disaster recovery planning, execution and testing and system backup and recover

• Provided efficient end user support with SmartView troubleshooting & access management with IDM

• Managed Hierarchy, Node, Security and Validation with Oracle Data Relationship Management (DRM).

• Successfully implemented Hyperion Financial Close Management as a “One Day Close” solution

• Managed Hyperion and Tableau integration for “Cost Visibility” dashboard. Employer: Essential Technologies, GA 1586 ATKINSON RD, STE 108, LAWRENCEVILLE GA 30043 Client: Nexteer Automotive, Saginaw, MI

From: 04/01/2013 To 05/31/2013

Job Title: Sr. Programmer Analyst (Oracle Hyperion Consultant) Job Duties

• Designed architect level document that includes the integration details for each of the reporting entities.

• Designed and development of Oracle's Hyperion Financial Management, Financial Data Management (FDM) and Enterprise Performance Management Architect (EPMA) to meet business needs.

• Documented Hierarchy changes and update of substitution variables and business rules.

• Collaborating with Infrastructure group to ensure reliable and responsive financial systems

• Identifying and resolving issues critical to the clients' strategic and operational success

• Designed Integration document with recommended approach for ERPs such as QAD, Access, Hyperion Enterprise

& Mainframe.

• Maintaining documentation on key systems and processes which consist complex currency conversion & Intercompany elimination process

• Support for accurate and timely reporting of financial data including ongoing update maintenance of Hyperion Financial Management (HFM), BI+ Environments and other related products as the primary platform for all-financial reporting/consolidations activities.

• Function include GL and related data collection strategies, Analysis of reported data and application administration of metadata, rules and security as well as support project management for ongoing enhancements to maximize tools processes and resources.

• Enterprise wide end users Subject Matter Expert (SME) training and support with SmartView, Grids, queries and functionalities to facilitate financial data mining for analysis, inquiries and ad hoc reporting. Employer: Essential Technologies, GA 1586 ATKINSON RD, STE 108, LAWRENCEVILLE GA 30043 Client: CHEP Inc, Orlando, FL

Job Title: Oracle Hyperion Developer

From: 09/01/2012 To 03/31/2013

Job Duties

• Installed & Configured EPMA 11.1.1.3 across Dev, Test & Prod Environment.

• Designed complete architecture of application along with technical & functional specifications.

• Collaborated with end-users and stakeholders to bring clarity to a multitude of data sources which enabled data to be displayed in a meaningful analytic way

• Managed Task Flow with data load, translation, consolidating parent entities and extracting data through Extended Analytics,

• Partnered with senior management to create daily report showing detailed and summary sales activity across entire enterprise, encompassing 12 sales feeds.

• Developed Web Forms, Composite Web Forms, Menu, Task Lists, and User Variables based on the Functional and Technical Requirements requested by the business.

• Perform Planning application upgrade implementation from V9.3 to V11.1.1.3

• Streamlined data movements/interfaces across different plan types and applications using XREFs and DATAEXPORT options.

• Prepare innovative financial and business-related analyses and research in such areas as financial and expense performance, rate of return, depreciation, working capital and investments.

• Performed detail analysis of historical data that would be used to populate dimensions and members.

• Managed data reconciliation and maintain data integrity of information being collected and uploaded into HFM (Extended Analytics) application utilizing FDM and other Oracle standard tools

• Loaded actual into Planning Application and consolidated actual, forecast and budget numbers to provide a complete financial view.

• Developed and scheduled MaxL scripts for overnight batch processes.

• Defined and maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console of Hyperion Shared Services Employer: Essential Technologies, GA 1586 ATKINSON RD, STE 108, LAWRENCEVILLE GA 30043 Client Name: Baker Hughes Inc, Houston, TX

Job Title: Hyperion Consultant

From: 06/01/2012 To 08/31/2012

Job Duties:

• Design overall Architecture of Planning application along with Functional Requirement, Technical Specification & Server Hardware Configuration

• Designed strategy for Data Architecture, Master Data, ETL Process, Security & Backup Recovery.

• Worked closely with business stakeholders to capture complex business logic into Hyperion Planning Application.

• Created OLAP Models and Meta outlines using Essbase Integration Services (EIS) to populate Essbase database.

• Created the Multi-Currency applications with knowledge of functionality and conversion which allow the currency input transformed in reporting currency.

• Created integration script in FDM to connect to and load data directly from SAP GL tables to Hyperion Application.

• Managed complex hierarchy with Hyperion DRM, which allows Import/Export metadata, Blender & Versioning.

• Designed multiple Planning Forms with annotation & cell level description for better user interface.

• Managed system level security, Object level Security & Data level security through security filters in Hyperion Shared service.

• Created Replicate Partition from BSO to ASO cube for management reporting, converted all the BSO member formulas and calculation scripts to the appropriate MDX formulas and correct solve-order

• Designed Complex Hyperion Business Rules for Aggregation, Currency Conversion & Data Allocation logic.

• Worked on End User Training material & UAT related issues. Employer: CyberThink Inc, NJ 685, Route 202/206 Ste. 101, Bridgewater NJ 08807 Client Name: Levi & Strauss & Co, San Francisco, CA Job Title: Hyperion Consultant

From: 03/01/2012 to 05/31/2012

Job duties

• Installation, Configuration and Administration of Exchange Server and Clients.

• Managing requirement with Business User.

• Worked on architecture of Hyperion Workspace and shared services related to groups and security.

• Advance script for Hyperion Financial Management.

• Migrated Data from SAP to Hyperion Financial Management.

• Provide support for Oracle FDM

• Managed data reconciliation and maintain data integrity of information being collected and uploaded into HFM application utilizing FDM and other Oracle standard tools.

• Design Batch script for Auto Data Load.

• Write script for Data mapping.

• Design Intercompany reports.

• Created reports for Income Statements, Balance Sheets, Operating and Admin Expenses & Revenue.

• Enhance functionalities of HFM applications, SmartView reports and templates, and Hyperion reports.

• Optimized Data Loads and Calc Scripts. Worked with UDAs and Member formulas.

.

Employer: CyberThink Inc, NJ 685, Route 202/206 Ste. 101, Bridgewater NJ 08807 Client Name: Seiko Corp, Mahwah, NJ

Job Title: Business intelligence Developer

From: 01/19/2012 To 03/31/2012

Job duties

• Installation, Configuration and Administration of Hyperion Enterprise Performance Management System version 11.1.2

• Managed Database System with Oracle JD Edward.

• Advanced Mapping using Oracle Finance Data Management.

• Design System for Sales & Planning Application.

• Hyperion Backup and Recoveries.

• Conduct User Acceptance Test.

• User and Group management.

• Managed Metadata and Security using Web based Planning and applied Security to the members of the following dimensions: Account, Scenario, Entity, Product, and Version.

• Actively involved in project development lifecycle from analysis of functional specifications document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training across subsidiaries.

• Designed test script for User Acceptance Test.

Client Name: Cisco Systems, Milpitas, CA

Job Title: Hyperion Consultant (Business Intelligence Developer) From: 10/01/2011 To 1/18/2012

Job duties

• Full life-cycle development of Hyperion Essbase (using ASO and BSO technologies and complex partitions) and Hyperion Planning applications for corporate consolidations, management and financial reporting, currency analysis including general ledger and sales data.

• Collecting Business Intelligence Requirement.

• Developing application using Oracle Hyperion Planning.

• Design Data modeling using Star Schema.

• Managed Oracle Data Integrator.

• Design VB scripting for application integration.

• Troubleshoot with Enterprise Performance Management System Employer Name: DecisionCraft Analytics Ltd, Ahmedabad, India Office no. 601, 6th Floor, Shapath- II, S.G. Road, Ahmedabad – 380055 Gujarat, India

Job Title: Excel VBA Developer (Business Intelligence Developer) From: 09/03/2007 to 10/03/2007

Job Duties:

• Identifying and modeling the relation between important price drivers and prices through a series of expert statistical correlations using multivariate regression model.

• To use ARIMAX method for crude oil & Naphtha price forecasting.

• Assess client needs and convert business requirements into Business Intelligence solutions with Oracle technologies.

• Performed complex data manipulation using advanced data extraction and analytical tools and techniques

• Implemented enterprise data architecture and data models for operational and data warehouse applications. Employer Name: Technocrat Solutions

A201, Ashoka Chambers, OPP State Bank of India,

Mithakhali, Ahmedabad -38006 India

Job Title: Business Consultant (Business Intelligence Developer) From: 01/01/2006 to 08/31/2007

Job duties:

• Analysis of computer-based systems and software models.

• Conduct data analysis using sophisticated statistical and financial analysis techniques.

• Implementing Econometric methods such as Linear regression model with object-oriented programming.

• Writing scripts (database and UNIX shell/ Perl) for database administration, monitoring, maintenance of standby databases

• Coordinates database system and application maintenance with business partners and Information System team.

• Run headcount ETL process

• Participates in gathering business requirements and data analysis to support business processes and projects. Tools:

- Microsoft Excel, C/C++,Visual Basic 6.0, Oracle DB EDUCATION

MBA

Year Completed: May 2011

New York Institute of Technology

M.Sc. In Computer Application & Information Technology Gujarat University

Year Completed May 2006

B.Sc. In Computer Application & Information Technology Gujarat University

Year Completed May 2004

Contact this candidate