Sign in

Engineer Software

New Albany, Ohio, United States
May 30, 2018

Contact this candidate


Jitendra Kumar Sethi E-mail –

Phone - +1-614-***-**** Work Authorization – H1B (Approved I-140)


• 14 years of experience in IT industry in Oracle Hyperion EPM Product Suite and Business Intelligence

• Handled multiple roles – Project Lead,Team Lead, Solution Architect, Developer

• Experience in leading large teams with more than 15 members

• Proficient in analyzing, designing, developing, implementing, optimizing and supporting the Oracle Hyperion Suite of tools.

• Extensive experience in Implementation and support of native Essbase (BSO & ASO) and Hyperion Planning Applications (multi-currency)

• Extensive experience in developing Maxl Scripts for automation of data loading and hierarchy building

• Create Maxl scripts from SQL scripts during run time automated load.

• Data and metadata load using SQL load rules.

• Essbase security automation using HSS import/export utility

• Unix Shell/ windows batch scripts to automate Maxl scripts execution

• Data auditing in Essbase and Planning

• Expertise in maintenance and support of Hyperion Products in Retail, Banking, Healthcare and Manufacturing domain.

• Expertise in creating complex Hyperion Financial reports like rolling forecast, variance reporting, YoY trend reports etc.

• Strong ability to maintain effective working relationships with key collaborators and business partners

• Extensive experience in Requirement gathering, Impact Analysis, Effort estimation, Resource & capacity planning

• Demonstrated coaching, mentoring skills and leadership skills CAREER PROFILE

Organization Designation Duration Period

Mast Technology Services Ltd. (L Brands) Hyperion Applications Consultant

3 Yr 7 months 09/2014

till date

IBM India Pvt. Ltd. Sr. Hyperion Consultant 5 Yr 2 Months 07/2009 to 09/2014

Wipro Technologies Ltd. Technical Leader 2 1 2 Months 05/2009 to 07/2009

Tata Consultancy Services Ltd. Assistant Systems


2 Yr 7 Months 08/2006 to


Satyam Computer Services Ltd. Software Engineer 2 Yr 5 Months 02/2004 to 07/2006


Primary Skills Hyperion Product suite 9x and 11x - Essbase (BSO & ASO), Planning, HFM, FDM, FDMEE, HFR, Hyperion Shared Services, Financial Reporting, EPMA Secondary Skills Oracle SQL, SQL Server, Informatica, Unix Shell script, Batch Scripting


Bachelor of Engineering in Information and Technology, Biju Patnaik University of Technology, India PROFESSIONAL EXPERIENCE

The details of the various assignments that I have handled are listed here, in reverse chronological order. L Brands Inc. – Mast Technology Services Inc Sep 2014 – Present Hyperion Application Consultant

Mast Global formerly known as Mast Technology Services Inc. (MTS) provides global production, sourcing and logistics and technology services for L Brands, Inc. L Brands operates in the highly competitive specialty retail business, selling women's intimate apparel, personal care products, and women's and men's apparel through its 3000 specialty retail stores and direct response (catalogue and e-commerce) businesses. L Brands 2015 sales exceeded $12.7 billion, with a net income of $1.1 billion. L Brands uses Mast Global technical expertise to maintain, support and implement their Hyperion applications. In this scope I am responsible for the following

• Work with the different business team and Center finance team in transforming business requirements into Functional Requirements Document and to Technical Design Documents

• Responsible for requirement gathering, estimation and impact analysis of the new enhancement for Hyperion Applications

• SME for the entire Hyperion system in onsite-offshore model which includes Hyperion Financial Management, FDMEE, Hyperion Planning, Essbase, Financial Reports,

• Support the monthly financial close cycle and address the support tickets on severity basis.

• Create FDMEE flash locations, check entities, check rules, validation reports and data load mappings and data load rules for SAP GL application to HFM application.

• Administration of HFM including month end closure activities like Metadata management, Rules, VB scripting, Process management, Journals, Data reconciliation, Consolidation, reporting.

• Handling complex analytical problems for HFM and Planning applications.

• Performed Month end, Quarter End and Year End maintenance to the Planning, HFM and FDM applications.

• Designed several automation jobs in Essbase using batch scripts and MaxL.

• Dimension building, data loading, security setup, data form, Calc scripts, HBRs for Planning applications.

• Creation of testing strategy and test cases as well as executing the test case for newly created Hyperion Applications and helping the testing team.

• Offshore team management, resource planning and capability planning.

• Review Work Products/ deliverables for the team’s quality and completeness and preparation of project status report

Environment: Windows, Oracle Hyperion Product suite Essbase, Planning, HFR, HFM, FDMEE L Brands Inc. – IBM Jul 2011– Sep 2014

Hyperion On-site Project Lead

L Brands operates in the highly competitive specialty retail business, selling women's intimate apparel, personal care products, and women's and men's apparel through its 3000 retail stores and direct response

(catalogue and e-commerce) businesses. L Brands 2014 sales exceeded $11 billion. L Brands has outsourced support and maintenance of applications to stay competitive and leverage IBM’s expertise to maintain/support and enhance their Hyperion applications. In this scope I was responsible for

• Project management, Offshore team management, resource planning and capability planning.

• Performed the same duties as my current role in L Brands ( mentioned above) Environment: Windows, Unix, Hyperion Product suite Essbase, Planning, HFR, HFM, FDQM American Express Ltd – IBM Dec 2009 – Jun 2011

Hyperion Tech Lead

America Express has built up several Essbase applications for their various analytical needs. These cubes have data related to B/S, P&L and Statistical accounts etc. Several Financial reports are developed out of these cubes using HFR tool. These reports are used by AMEX to analyze their business performance and make strategic decisions. IBM as a vendor is responsible to handle all new developments related to Essbase and financial reporting and is also responsible to handle the entire change request raised by AMEX . As a Technical Lead I was responsible for the below items -

• Requirement gathering, Impact Analysis, Effort estimation, project planning etc.

• Team lead and SME for Essbase applications.

• Reviewing team work products and deliverables for quality and completeness

• Development/Enhancement of Essbase ASO and BSO cube.

• Essbase Cubes and Essbase Integration Services (EIS) architecture expertise

• To develop EIS OLAP and Meta-models to build drill through reports to EDW

• Create SQL load rules to load data and metadata from EDW

• Generate Maxl scripts from SQL script and execute them using automated Unix scripts

• Developing/Enhancements Maxl Scripts for automation of data loading and hierarchy building

• Automate user security assignment using HSS import/export utility

• Create multiple FR reports that including Balance Sheet, P&L, Rolling Forecast reports

• Automated migration scripts to move codes from one environment to another. Environment: Windows, Unix, Informatica, Oracle Apps, Oracle Hyperion Product suite Essbase, HFR, EIS, HSS

Hospital Corporation of America – IBM Jul 2009 – Nov 2009 Hyperion Consultant

Hospital Corporation of America has built several dashboards to capture the KPIs which will help them to take strategic decisions for different Line of Business.

• To provide Essbase Cubes and Essbase Integration Services (EIS) architecture expertise

• Create Functional and Technical specification for Essbase Cubes Design

• To develop EIS OLAP and Metamodels to build ASO Essbase Cubes

• Create Drill through report from Essbase to Data warehouse.

• ASO incremental data loading and dimensional building Environment: Hyperion Product suite 9.3- Essbase, EIS, Planning, HFR, Teradata, SQL Server Wipro Technologies May 2009 – Jul 2009

Solution Architect /Pre-sales consultant

The Business Technology Services Central COE is a dedicated group of resources involved in solution, proposal development, POC, researching on new technologies in EPM practice. I was involved in

• Creating a common chart of accounts for HFM and Planning Application.

• Creating HFM and Planning applications using the common COA using EPMA

• Creating Financial reports to support BS, P&L and Intercompany reporting.

• Pre-sales consulting and Proposal Development for various clients

• Requirement Gathering, Effort Estimation, Gap Analysis Environment: Hyperion Product suite 11.1.x- EPMA, HFM, Planning and Essbase, FR, Web Analysis, HSS Tata Consultancy Services Ltd Aug 2006 – Apr 2009

Hyperion Architect /Offshore lead

• Worked for multiple manufacturing clients like Barrick Gold Corporation and Alcoa Inc.

• Technical lead for managing a 16 member offshore team.

• SME for Support/Enhancement of Planning and Essbase Applications, Web Analysis and Financial Reports

• Due diligence for solution re-architect of existing Hyperion Planning and Budgeting Environment Environment: Windows 2003 Server, Unix servers, Hyperion 9.3.x – Essbase, Planning, HFR, Web Analysis General Electrics - Satyam Computer Services Ltd Jun 2004 – Jul 2006 Software Engineer

• Worked on multiple projects for GE as an Informatica, BO and Hyperion Essbase Developer and Module lead on Data Warehousing.

Environment: Informatica 6.5, Business Object 5.5, Hyperion Essbase 9.1,Windows 2003 Server, Unix servers, Autosys, TOAD, SQL/PL SQL, UNIX Shell scripts

Contact this candidate