Sandeep Singh

Professional Summary:

• MBA (Finance) with an experience of 7+ Years in Finance & Business Intelligence.

• Worked as a Techno Functional Consultant in analyzing, designing, testing and delivery of Planning &

Budgeting processes and techniques.

• Proficient in creating and maintaining business requirements Document, functional specification documents,

user manuals, interfacing guides and system test plans.

• Hands on experience in Calculation Scripts, Performance Optimization, Excel Addin & Reports.

• Automation experience through Maxl & .bat file.

• A go getter with a flexible and positive attitude. Detail oriented and efficient with strong interpersonal skills and

the ability to relate to people at all levels across the organization.

• Expertise in implementation of Hyperion Planning, Hyperion Financial Reporting, and Hyperion Capex

Planning and Hyperion Strategic Finance. Proficient in maintaining quality related documentation as per client

standards.

• Cube creation expertise with respect to ASO & BSO and modeling it as per the client requirement.

• Technical knowhow in HFM and consolidation process.

• Quick learner, good presentation and communication skills. Good analytical and troubleshooting skills.

• Good data modeling, analytical and problem solving skills and very good team player with excellent

communication skills.

• Proficient in maintaining quality related documentation as per client standards

Achievements:

• Best Project Award In Oracle & Appreciation Certificates

• DCP Midstream Appreciation Certificates

• First SSL (Secure Socket Layer) upgrade Project.

Educational Qualification:

• Master of Business Administration in Finance and Business (MBA) from University of Wales, Cardiff, U.K.

• Bachelor of Commerce in Finance and Costing (B.Com) from Utkal University, India.

Page 1 of 10

Sandeep Singh

Professional Certifications:

• Hyperion Planning 9.3 Administrator I and II

• Oracle Certificate of Appreciation –Testing, Version 11.1.2.1

• AMFI Certified

• Capital Markets Certified

Skills Profile:

Domain Finance, Banking and Insurance, Planning & Budgeting, Consolidation

Hyperion Planning, Hyperion Capital Asset Planning, Hyperion Strategic

Business Intelligence Skills

Finance, Essbase 9x,11x, HFM (Basic)

Data Loading Tools Hyperion Financial Data Quality Management & ODI (Basic)

Hyperion Financial Reporting, Web Analysis, Smart View, Essbase

Reporting Tools

Spreadsheet Add In

Operating environments Windows 9x/XP/2K/Vista

Experience Summary :

Current Employer HCL America (Jul 2012 – Continuing)

Project Experience Snapshot:

Client Readers Digest Association

Designation Lead Consultant

Environment EPM 11.1.2.0 (Essbase, HP, HFM, FR, WA, HSS & Foundation)

Type Support & Enhancements (11 Months & Continuing)

Description

The Reader's Digest Association, Inc. (RDA) is a global media and direct marketing company. It has grown to include a

diverse range of magazines, books, music, DVDs and online content. Currently Client is in Hyperion 11.1.2.0 and using it

for effective FP&A.

Responsibilities:

Page 2 of 10

Sandeep Singh

• Day to Day enhancements and providing solution to the client for their decision making through EPM.

• GL to Hyperion Integration through PERL Scripting, Manually, & third party tools.

• Team Mentoring and guidance through solution matrix & 360 degree approach.

• Maintenance and upkeep of all the related Hyperion serves.

• Cube Creation, converting Data for the feed, Maintenance & Development

• BAT File, Calculation Scripts, and Business Rule development.

• Provisioning Filters and security updates on all the Hyperion environments.

• User Support in all Hyperion Suite of Products Essbase, Planning, HFM,, FR, Web Analysis & HSF

• Essbase ASO & BSO cube creation along with Data load and Test from Source system.

• Automation Back up Jobs, Outline, Data load through Maxl & Esscmd commands.

• Cube Creation & Development with respect to cube fundamentals & rules.

• Data load & Dimension rule file creation with proper Testing.

• FR & Web Analysis report development and maintenance for user requirement.

• Model creation in HSF and validating it with end Users.

• Installation, Configuration & patching activities in all Hyperion servers & user machines.

Client Godiva Chocolatier

Designation Lead Consultant

Environment EPM 11.1.2.1 and 9.3.1(HFM, FDM, FR, HSS & Foundation)

Type Upgrade & Automation (3 Months)

Description

Godiva Chocolatier is the world leader in super premium chocolate, available in over 80 countries. It offers a range of

chocolate products. Currently Client is in Hyperion 9.3.1 HFM, FR & FDM and wants to upgrade to EPM 11.1.2.1

Responsibilities:

Upgrade

• Defining Project Plan & Time lines with client approvals & sign offs.

• Analysis and study of the existing 9.3.1 system and architecture

• Built dynamic and stable 11.1.2.1 architecture with a Load Balancing feature through Cluster.

• Team Management through leading & delegating activities to the Team members and ensuring that project is in

timeline.

• Designing Documents such as As Is, Upgrade Strategy, Back out Plan, Design Document, Information

Document.

• Uninstallation and cleaning of Hyperion 9.3.1 components from the existing setup.

• Installation & configuration of EPM 11.1.2.1 and third Party software Components in the different servers.

Page 3 of 10

Sandeep Singh

• Risk Mitigation by proactive approach and experience.

• Troubleshooting/ Resolution of issues and problems during different phases.

• Artifacts Metadata, Data, Filters, Security, *.rul file migration & backup.

• Adhering all the required protocols as per quality and client group policy in case of DCOM settings, IIS and

Database servers.

• Web logic & SSL certificates deployment to respective Hyperion components.

• Enhancements in the current process like automation copy application utility.

• Testing & Bug Fixing in the new Version after Users testing.

• Issues & problem resolution in current production/development servers.

• Validation of artifacts with 9.3.1 viz 11.1.2.1 environment after the migration.

Employer L&T InfoTech Ltd (Aug 2008 – Jul 2012)

Client DCP Midstream– Denver, US

Designation Lead Consultant

Environment Essbase 9.3.3, HFM 9.3.3, HAL, EPM 11.1.1.3

Type Upgrade, Automation & Support (13 Months)

Description

DCP Midstream, LLC, headquartered in Denver, Colorado, leads the midstream segment as one of the nation's largest

natural gas gatherers and processors, the largest natural gas liquids (NGLs) producer and one of the largest NGL

marketers in the U.S. Currently Client is in Hyperion 9.3.1 Essbase, BI Plus reporting & HFM (SSL & Web logic Server)

and want to upgrade to EPM 11.1.1.3 (SSL & Web logic Server)

Responsibilities:

Upgrade

• Analysis and study of the existing planning Process

• Leading & Assigning activities to the Team members and ensuring that project is in timeline.

• Designing Documents such as As Is, Upgrade Strategy, Back out Plan.

• Dimension Study and design, settings, properties.

• System compatibility, Support Matrix & Third party software’s installation

• Artifacts Metadata, Data, Filters, Security, *.csc, *.rul file etc migration & backup.

• Installation & Configuration of EPM 11.1.1.3 on the desired servers

• Web logic & SSL certificates deployment to respective Hyperion components.

• Enhancements in the current process like automation data loading through Tech Scheduler,

substitution Variables automation, Partitioning.

Page 4 of 10

Sandeep Singh

• Testing & Bug Fixing in the new Version after Users testing.

• Issues & problem resolution in current production/development servers.

Support

• User Support in all Hyperion Suite of Products Essbase, HFM, ODI, FR, Web Analysis & HSF

• Essbase ASO & BSO cube creation along with Data load and Test from Source system.

• Automation Back up Jobs, Outline, Data load through Maxl & Esscmd commands.

• Cube Creation & Development with respect to cube fundamentals & rules.

• Data load & Dimension rule file creation with proper Testing.

• FR & Web Analysis report development and maintenance for user requirement.

• Model creation in HSF and validating it with end Users.

• Installation, Configuration & patching activities in all Hyperion servers & user machines.

• Supporting HFM data load through ODI and ensuring all the conditions are met for successful load.

Client Marvell– Santa Clara, US

Designation Hyperion Techno Functional Consultant

Environment Hyperion Planning 9.3.1 & Essbase 9.3.1

Type Automation & Support (3 Months)

Description

It is one of the pioneer in tailoring application specific package design, assembly and test solutions of various electronic

products & wireless products. Using Hyperion Planning and Hyperion Essbase suite the client manages its financial

planning, budgeting and reporting requirements. To enhance the planning & budgeting process, they are looking forward

to automate & enhance business process by “Financial Planning & Analysis” application using Hyperion Planning 9.3.1

and integrate it with the existing suite of Hyperion applications.

Responsibilities:

• Creating Basic Dimension build rule files.

• Automating various process like Data loading, Substitution variable update.

• Building Rule file for data loading & Dimension build up.

• Meeting user’s requirements of any logic/script.

• Testing/Analysis of new built script to deploy it in production.

• Loading data and Involving in all aspects like Development and Maintenance

• Performance Tuning for better data retrieval & application optimization.

• Security filters

• Reporting with Essbase Spread sheet add in

• Creating report templates using Excel Addin for office

Page 5 of 10

Sandeep Singh

• Created technical and user documentation which has the step by step process of creating reports and using

the functionality of Business User’s

• To & Fro feedback with User’s for effective Business process.

Client Oracle India, PD Bangalore

Designation Hyperion Techno Functional Consultant

Environment EPM Suite 11.1.2.1

Type New Version 11.1.2.1 Testing (3.5 Months)

Description

Testing of New Version in Oracle India Product Development IT Company one of the Fortune 100 Companies engaged

in business software and hardware systems with one of the robust Database in world.

Responsibilities:

• Understand the New Enhancement carried out in EPM 11.1.2.1

• Install & Upgrade Hyperion planning & HFM from 9.3.3 to 11.1.2.1 and 11.1.1.3 to 11.1.2.1

• Test Various features and enhancements in Planning Applications such as Task list, Dataforms, and

functionality

• Create Database in DB Server

• Application Creation and planning unit hierarchy

• Check Dimensions, Data forms, Task list, Smart list etc.

• Check process flow management and life cycle management system in shared service library

• Create new users, groups and provision security access to them

• Data base backup for planning application and create a new application from that Backup

• Import and export utilities, security filters

• Test Public sector budgeting planning application

• Interact with product development team and update about the defects in the application and system

Client Beaulieu– US

Designation Hyperion Functional Consultant

Environment Hyperion Planning 11.1.1.3, Hyperion Capital Asset Planning, Hyperion

Financial Reporting Studio 11.1.1.3, Hyperion Smart View, FR

Type Implementation (11Months)

Description

Page 6 of 10

Sandeep Singh

It is one of the largest Carpet Manufacturing Company. Using Hyperion Planning and Hyperion Essbase suite the client

manages its financial planning, budgeting and reporting requirements.

Responsibilities:

Managing the team members and their activities as per Project Plan.

1.

Analysis and study of the existing planning Process

2.

Dimension Study and design, to generate the MIS reports in the desired format.

3.

Web Forms & Process Flow designing

4.

Test/Verify P&L outline, interfaces, rule file, data forms, business rules & security

5.

Designing of the template for testing.

6.

Testing and updating of reports with users.

7.

Writing Calculation script & Testing

8.

Define Report format for Client analysis & study.

9.

• Handling all the Client queries & implementing it in Planning.

• Mapping members of current system to Hyperion Planning for loading Data in Actual using FDQM.

• Understand the various statutory reporting requirements.

• Designing financial reports such as P & L report, Balance sheet and other variance reports in Hyperion

Financial reporting tool.

• Develop statutory dynamic reports using Hyperion Financial Reporting.

• Creating books and batches for scheduling reports, Financial Reports testing

• Assigning security models for financial reports.

• Applied formatting and conditional formatting at row/column/cell level through report studio and workspace to

achieve management report functionalities.

Client Infrastructure & Development Projects Ltd.

Designation Hyperion Techno Functional Consultant

Environment Hyperion Strategic Finance 9.3

Type Implementation (8 Months)

Description

A Pioneer Infrastructure & Development Projects Company engaged in construction of Roads, Dams, & Building with an

annual Turnover of over Rs 2 billion.

Page 7 of 10

Sandeep Singh

Responsibilities:

• Developing dashboards, reports and free style reporting in the tool.

• Study and Analysis of project so that it can be developed in the HSF.

• Developing and Building logic so that the all financial statements can provide the strategic information.

• Ratio Analysis, Project IRR and Net Present value development.

• Understanding the project work flows and financing.

• Budgeting and Forecasting of the Project.

• Effectively mapping of business processes with HSF and ensured minimal customizations

• Scenario Creation of Models developed in HSF, Debt Scheduler, Valuation Techniques and Financial

Reporting.

• Provide intensive support to User Acceptance Testing (UAT)

• Conduct manual functional testing to ensure proper implementation of requirements

• Provide application (functional) training to end users and technology teams

• To work with Design and Business team to review possible improvements in processes and procedures

Company – RBS Bank (Pune, India) (Jan 2008 – Aug 2008)

Wealth Manager Planning & Investment

Responsibilities:

• Designing Portfolio for various Clients on needs of Duration Management, Credit Risk & Exposure

Risk of Portfolio – Specially Provident Funds and Corporate Treasuries

• Mutual Funds – Marketing & Distribution of Open end & Close end products of Debt Short term

(Liquid / STP’s / FMP’s / long term (Income / Gilt); Hybrid & Structured Capital Protection products – MIP &

Balanced Funds & Fixed Duration Hybrid Products and various Equity funds (Large Cap; Mid & Small cap;

Thematic; ELSS along with Close Ended Schemes).

• Client profile study, having regular interaction with clients to track their investment requirements by

calculating IRR, NPV and doing Trend analysis for their current investments and providing ongoing updates to

clients on market trends.

• Responsible for maintenance, deepening & growth of the relationship with high net worth individuals

(HNIs) by way of providing Portfolio Management Service, includes different asset classes like Direct Equity,

Mutual Funds, Life Insurance, Gen. Insurance, Gold Coins etc. vis à vis acquisition of more and more clients.

Page 8 of 10

Sandeep Singh

• Handling Capital Adequacy Ratio & Fixed Asset Management System in Branch.

• Hands on experience on FINACLE Banking Software

• Maintain Management Information System (MIS) for Loan Division

Company – Axis Bank (Pune, India) (Oct 2006 – Jan 2008)

Deputy Manager

Responsibilities:

• Functions as the financial advisor to customers, handling and maintaining their portfolios and other

advisory services etc. for Mutual Funds / Bonds & Insurance.

• Asset Management Business – Process knowledge at client level, equity trading and also marketing

of IPO’s, online trading accounts etc.

• Retail and Corporate Banking Operations like inward –outward clearing, Tax Challan, Salary credits

and Loan processing.

• Handling Capital Adequacy Ratio & Fixed Asset Management System in Branch.

• Hands on experience on FINACLE Banking Software

• Maintain Management Information System (MIS) for sales, brand Improvement and all Customer

Service issues.

• Designing Portfolio for various Clients on needs of Duration Management, Credit Risk & Exposure

Risk of Portfolio – Specially Provident Funds and Corporate Treasuries

• Client profile study, having regular interaction with clients to track their investment requirements by

calculating IRR, NPV and doing Trend analysis for their current investments and providing ongoing updates to

clients on market trends.

Company – Lloyds TSB Bank (Newport, U.K) (Sept 2004 – Apr 2006)

Customer Officer

Responsibilities:

• Advising and processing customer claims for the loan protection.

• Fact finding & analysis of the claim from different government departments like Job center, Hospitals,

Claim Center.

Page 9 of 10

Sandeep Singh

• Payment processing & approvals.

• Maintaining the Targets & MIS reporting.

• Case study of the claim in terms of coverage & rejection limitations

Banking operations.

•

Personal Details:

E mail acb7sy@r.postjobfree.com

Mobile no 914-***-****

Date of Birth 03/27/1981

Page 10 of 10

Contact this candidate