NAME (M) 91 xxxxxxxxxx – *********@gmail.co *********@gmail.com m OBJECTIVE
To contri contribut bute e to a Busin Business ess Intell Intellige igence nce team team where where the BI concep conceptua tuall knowl knowledg edge e and practi practical cal development/implementation experience of Oracle Hyperion BI applications coupled with excellent client management skills can be utilized to deliver va lue added solution to the business users SUMMARY
Around Around 8 years years of experienc experience e in clien clien en!a!e"e en!a!e"en# n# re$uire" re$uire"en en !a%erin !a%erin!# !# de&elopin de&elopin! ! and i"ple"en i"ple"enin! in! Oracle Oracle Enerpri Enerprise se 'erfor"a 'erfor"ance nce Mana!e"e Mana!e"en n soluion soluions s usin! usin! Oracle Oracle (yperion (yperion 'lannin!)Ess*ase# Oracle (yperion +inancial Mana!e"en# Oracle +inancial ,aa Mana!e"en# ,aa Ine!ra Ine!raion ion Mana!e"e Mana!e"en n and Oracle Oracle +inanci +inancial al Reporin Reporin! ! for pri"arily pri"arily Manufacu Manufacurin! rin!## (eal%care and Ban-in! secor cliens. Co"pleed Oracle (yperion 'lannin! // Cerified I"ple"enaion Specialis cerificaion in 01/2. Inhe Inhere rent nt part part of the the 're3sales 're3sales ea" that provided Oracle Hyperion Hyperion architect architecture ure based solution responses which was then successfully converted to implementation/maintenance implementation/maintenance pro!ects "ustomer#focused$ highly organized self#starter with effective customer#service skills and demonstrated ability to manage technical aspects$ architect customized solutions$ build and maintain relationships and communicate solution strategy to clients %xperienced in planning and managing pro!ects$ interacting with multi#national clients from onsite and offshore &roven troubleshooting skills and committed follower of 'uality and process standards laid by the company E4'ERIE5CE
Oracle (yperion Business Inelli!ence Inelli!ence Consulan Consulan 6Co"pany 5a"e7. Ban!alore
Au! 01/2 3 'resen
'ro9ec 'ro9ec O&er&ie: O&er&ie: ;lo*al ;lo*al Ine!ra Ine!raed ed 'lannin 'lannin! ! (yperion (yperion Applicaio Applicaion n ,e&elop"e ,e&elop"en n < Suppor Suppor The engage engagemen mentt is struct structure ured d to do (evelo (evelopme pment$ nt$ %nhanc %nhanceme ement$ nt$ )uppo )upport rt and *ainte *aintenan nance ce of &lanning/%ssbase cubes for &lanning$ Budgeting and +orecasting tracks for a Telecom client based in ,- ,eli&ered responsi*iliies responsi*iliies
Role .elease *anager &lanning/%ssbase0
*anaging deployment and migrations for all ma!or global and technical releases
*anage escalations and high priority issues within planning cycles and processes
"oordinating change re'uests and related ,1T to ensure the release goes with zero or minimum known defects post production go live &ublishing release documents pertaining to metadata and security elements post go live *anaging offshore production support team for &lanning/%ssbase 2 +(* and helping them resolve issues in con!unction with )I partners and clients &roposing and developing new solutions to automate processes related to artifact migration$ security3 bring in checks and balances to ensure issues are caught proactively and root#cause analysis is swift
Tec%no ec%nolo lo!y !y Oracl Oracle e (yperi (yperion on 'lann 'lannin! in!)E )Ess* ss*ase ase //./.0. /./.0.=# =# Oracle Oracle (yperi (yperion on +inan +inancia ciall ,aa ,aa Mana!e"en //./.0.=# Oracle (yperion S"ar Vie: //./.0.=
'ro9ec O&er&ie: Corporae +inancial Syse"s (yperion Applicaion ,e&elop"en < Suppor The engagement is aimed to do (evelopment/Implementation$ %nhancement$ %nhancement$ )upport and *aintenance of H+*/+(* and &lanning/%ssbase cubes for +inancial "onsolidation and .eporting3 )upply "hain *etrics .eporting3 &lanning$ Budgeting and +orecasting tracks for a *anufacturing domain "lient based in ,)1 ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion H+*/&lanning/%ssbase0 H+*/&lanning/%ssbase0 "onsultant
Trave ravell lled ed onsi onsite te 4ew 4ew 5ers 5ersey ey$$ ,)10 ,)10 to do the the Busin Business ess and Syse"s Syse"s Analy Analysis sis process and understand understand the as#is Hyperion Hyperion %nterpri %nterprise0 se0 monthly/' monthly/'uart uarterly/ erly/annual annual financial financial data submissi submission on and consol consolida idatio tion n and alloca allocatio tion n functi functiona onall and techni technical cal proces processes ses in detail detail along along with with a team team of implementation consultants with a view to setup H+* and +(* for global financial consolidation and reporting Helped the implementation team in *etadata build$ setting up H+* rules$ validation rules$ building member lists$ shared services and application access process$ smart view reporting templates$ etc during the build phase 1ided the team in building +(* mappings to be able to submit data coming through different source systems like )1&$ 5(% and manual templates Travelled to )hanghai$ "hina to facilitate H+* end user training sessions for batch consisting of 1sia &acific users 6orked 6orked with with the pro!ect pro!ect managemen managementt team to sail through the ,ser 1cceptance 1cceptance Testin Testing g thereby thereby resolving with the team any identified technical issues o r variances in data between H+* and H% &lanned and implemented global roll out of )mart 7iew tool installation and connection preferences setup for close to 899 end users (evelop differential rules to calculate Inventory metrics viz (OH$ (&O and ()O for 1ctual and Budget scenarios as well as :; month average calculations (evelop reports using Interactive .eporting and )<= batch scripts to produce exception reporting for &rocess "ontrol and &romotion "ontrol for audit purposes Basic high level performance tuning to H+* application$ underlying relational Oracle (B and )mart view registry parameters on client end0 to optimize 'uery response times )upportin )upporting g month end financial financial close process$ working working on issues issues raised raised by users and providing providing resolutions answers0 to their 'ueries$ redirecting tickets to "orporate team or backend IT team as necessary$ necessary$ providing system access thru )hared services to <1 and &roduction systems as necessary Built a &lanning cube to capture current access to the H+* application for the managers of the users to approve the access of their immediate subordinates to the system for audit purpose every 'uarter )upporting client team during external auditing by producing history audit logs from H+* application$ +(* audit tables and )hared services module
Handled an offshore team of >#8 resources for close to ; years and trained them to support$ enhance and maintain the H+* application as well as &lanning/%ssbase cubes as part of month end financial and supply chain close process
Tec%nolo ec%nolo!y !y Oracle Oracle (yperion (yperion +inanci +inancial al Mana!e"e Mana!e"en n //./.0./# /./.0./# Oracle Oracle (yperio (yperion n +inancia +inanciall ,aa Mana!e"e Mana!e"en n //./.0 //./.0./# ./# Oracle Oracle (yperion (yperion 'lannin! 'lannin!)Ess )Ess*ase *ase //./.0./# /./.0./# Oracle Oracle (yperion (yperion S"ar S"ar Vie: Vie: //./.0././1=
'ro9 'ro9ec ec O&er O&er&i &ie: e: 3 Man Mana! a!e" e"en en Acco Accoun uni in! n! < 'la 'lann nnin in! ! Sys Syse" e" The engagement is aimed to do (evelopment and %nhancement of &lanning/%ssbase cubes for &lanning$ Budgeting and +orecasting tracks for a Banking domain "lient based in ,)1 ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
Travelled Travelled onsite .ichmond$ ,)10 to do the Business and Syse"s Analysis process and understand the monthly outlook and allocation processes in detail with a view to setup an offshore support model to co#ordinate development and support all related techno#functional tasks =ed an offshore team of five for around six months to ensure high 'uality and timely deliverables related to the *1&) process which include deliverables related to development$ testing and support phases &layed an individual contributor Hyperion consultant0 role to resolve functional and technical issues in sister sister concern concern teams teams related related to Hyperion Hyperion Interactiv Interactive e .eporting$ .eporting$ Hyperion +inancial +inancial .eporting .eporting and OBI%% tracks
Tec%nolo!y Oracle (yperion 'lannin! //././.=# Oracle (yperion Ess*ase //././.=# IR# +R.
'ro9ec ec O&er &er&ie: 3 Bud!e Transac sacion Syse se" The pro!ect was aimed to do (evelopment and %nhancement of &lanning/%ssbase cubes for &lanning$ Budgeting and +orecasting tracks for a Healthcare domain "lient based in 1ustralia 1ustralia ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion &lanning "onsultant
Travell ravelled ed onsite onsite )ydn )ydney ey$$ 1ustra 1ustralia lia00 to do the Re$uire" Re$uire"en en ;a%erin! ;a%erin! process for an ongoin ongoing g Budgeting Budgeting process meant to track track budget budget numbers numbers in greater greater detail$ detail$ in understand understanding ing the clients clients existing planning exercise and translate it into Hyperion &lanning (esign re'uirements To be part part of the the Soluion ,efiniion team$ in mapping client business re'uirements to Hyperion application functionalities and coming up with future solution architecture for Budgeting and tracking budgeted numbers To desi!n and creae a prooype prooype for the Budget Transaction Transaction application including metadata and data to incorporate Budget data posted through manual inputs into the primary &lanning application and an .(B*) application and demo it to high level +inance user groups and take approval to build the main application To develop the entire Budget Transaction application including metadata and data to incorporate Budget data posted through manual input into the primary &lanning application and an .(B*) application for tracking Budgeting numbers with additional information viz ,ser name$ Transaction time$ etc
To be part of ,1T for the entire Budgeting process from end to end and aid in identifying and fixing issues pointed by the end users Handli Handling ng an offs offshor hore e team team of four four member members s to track track their their delive deliverab rables les$$ doing doing ",T ",T and )IT and managing the final deliverable before moving it to ,1T ,1T through a period of ; months
Tec%nolo!y Oracle Hyperion &lanning ::::?$ Oracle Hyperion %ssbase ::::?$ 6eb 1nalysis
'ro9ec 'ro9ec O&er&i O&er&ie: e: 3 +in +inanc ancial ial Bud Bud!e !ein in! ! < 'lann 'lannin in! ! and Repor Reporin in! ! The pro!ect is aimed to do (evelopment and %nhancement of &lanning/%ssbase cubes for &lanning$ Budgeting and +orecasting tracks for a *anufacturing domain "lient ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion &lanning "onsultant
To be part of the Re$uire"en ;a%erin! process for Budgeting 2 +orecasting$ in understanding the clients existing planning exercise and translate it into Hyperion &lanning (esign re'uirements To be part part of the the Soluion ,efiniion team$ in mapping client business re'uirements to Hyperion application functionalities and coming up with future solution architecture for Headcount Budgeting To create the entire &lanning application including metadata and data to incorporate Headcount data from )1& B6 source system into primary &lanning application for Budgeting process considerations using (I* mappings To develop an offline cost center budgeting template in %xcel using complex )martview function$ formulas and macros to aid budgeting users in the organization that do not have relevant Hyperion )martview licenses To be part of ,1T for the entire Budgeting process from end to end and aid in identifying and fixing issues pointed by the end users To develop reports in Hyperion +inancial .eporting and report books in 6orkspace for business users to budget headcount in the &lanning application along with other financial accounts (evelop Interactive .eporting reports highlighting the status of all the important (I* workflows and publishing it in Hyperion 6orkspace for the end user reference on a daily basis 1id in development of complex ,4I@ ,4I@ based *ax= scripts used to trigger commands commands from (I* server to start .eplicated partitions on %ssbase server server Building 6orkflow for planning approval process and locking data in %ssbase once planning process is frozen "reating .eplicated and Transparent partitions from source to copy cubes to enable data flow into reporting cubes from the primary &lanning 2 +orecasting cubes "reating +inancial .eports with traffic lighting for highlighting forecasting accuracy of the +orecasting process "reating Budget book for approvals by +inance top level management users using +inancial .eports
Tec%nolo!y Oracle Hyperion &lanning A;:$ Oracle Hyperion %ssbase A;:$ Oracle Hyperion +inancial .eporting A;:$ (I* :
'ro9ec O&er&ie:3 (yperion Enerprise o (yperion +inancial Mana!e"en Mi!raion The internal solution was being developed with a view to enable customers who had Hyperion %nterprise migrate Hyperion +inancial *anagement which is a faster and better consolidation tool ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
Installation and configuration of Hyperion +inancial *anagement v>9 Building H+* metadata and security from Hyperion %nterprise metadata using %xcel based macros
Tec%nolo!y Oracle Hyperion +inancial *anagement >9$ Oracle Hyperion %nterprise C9
'ro9ec O&er&ie: (yperion 'lannin! < Reporin! Tesin! The pro!ect involved developing +unctional and Technical Test cases/scripts as part of ",T and )IT
,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
Duidin Duiding g the &lanni &lanning ng 2 .epor .eporti ting ng Testing esting team team on functi functiona onall aspect aspects s to aid them them in develo developin ping g +unctional and Technical Test cases/scripts as part of "ode and ,nit Testing and )ystem Integration Testing
Tec%nolo!y Oracle Hyperion +inancial .eporting ::$ Oracle Hyperion 6eb 1nalysis ::
'ro9ec O&er&ie: 'rocess Consulin! for I"ple"enin! (yperion 'lannin! The pro!ect involved "onsulting for implementing Hyperion &lanning to perform Budgeting 2 &lanning ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
)coping of &lanning 2 Budgeting re'uirements of the customer on a high level "harting hardware re'uirements re'uired to be employed to implement Hyperion &lanning solution "harting an ideal workflow for planning approval process
Tec%nolo!y Oracle Hyperion &lanning
'ro9ec O&er&ie: Mi!raion of (yperion 'erfor"ance Suie and (yperion +inancial Repors The scope of the pro!ect covered migrating Hyperion &erformance )uite and Hyperion +inancial .eports from an old server to a new server without any change being evident to the end users ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
Installation$ "onfiguration "onfiguration and *igration of all Hyperion .eports and H&) from and old to a new server Involved in ,1T$ ,1T$ fixing issues pointed out by end users and delivering post production support &roactive testing of issues arising out of migrating users from 4ovell to *)1( )etting up user security$ performing performing unit testing of all financial reports and components of H&)
Tec%nolo!y Hyperion &erformance )uite E$ Oracle Hyperion +inancial .eporting
'ro9ec O&er&ie: ,e&elop"en ,e&elop"en of Ess*ase cu*es for Mana!e"en Bud!ein! Bud!ein! < Reporin! The pro!ect re'uired building *anagement 2 Budget .eports from %ssbase cubes which earlier had H+* as their data source ,eli&ered responsi*iliies responsi*iliies
Role Oracle Hyperion "onsultant
.econc .econcil iling ing %ssbas %ssbase e and H+* H+* outlin outlines3 es3 reconc reconcili iling ng %ssbas %ssbase e calc calc script scripts s with with H+* H+* rules rules and reconc reconcili iling ng data data at every every level level betwee between n %ssbas %ssbase e and H+* H+* hierar hierarchi chies es meant meant for *anage *anageme ment nt Budgeting 2 .eporting Building Hyperion +inancial .eports having Hyperion %ssbase as data source
Tec%nolo ec%nolo!y !y Oracle Hyperion %ssbase $ Oracle Hyperion +inancial .eporting $ Oracle Hyperion +inancial *anagement ;8
BIIM 're3Sales Consulan 6Co"pany 5a"e7 3 Ban!alore
,eli&ered responsi*iliies responsi*ili ies
May 011> Mar 0118
Role F Role F &resales "onsultant "onsultant
.espon .espondin ding g to .+&s .+&s/.+ /.+Is Is with with approp appropria riate te sugges suggestiv tive e soluti solution$ on$ soluti solution on archit architect ecture ures$ s$ effor effortt estimations and customer references &roactive (emand DenerationG "harting the IT infrastructure$ &roblem )tatement$ )olution *ap and %ntry 2 Influencing )trategy for prospective .etail$ ,tilities 2 Health"are clients Organizing -nowledge )haring sessions for onsite and offshore based &resales "onsultants &reparing &ro!ect plans viz Dantt charts on *icrosoft &ro!ect ?99; &reparing %ffort %stimation 2 .esource loading charts for prospective pro!ects
Mana!e"en Trainee 6Co"pany 5a"e7. Mu"*ai)(ydera*ad Mu"*ai)(ydera*ad
May 011? June 011?
'ro9ec O&er&ie: 1nalyze the 6holesale 6holesale dealer channel infrastructure$ infrastructure$ coverage coverage and display over two territories territories ,eli&ered responsi*iliies responsi*ili ies
Role F Role F (ealer "hannel 1nalyst
(evelo (evelop p and analyz analyze e 6holes 6holesale ale (ealer (ealer 6(0 6(0 perfor performan mance ce using using -)+ -)+ metric metrics s and identi identify fy improvement areas using )&)) :; &rimary survey of dealers and retailers across :> towns and cities of 1& Benchmarking against desired performance
E,UCATIO5A@ ,ETAI@S
ualificaion
Colle!e ) Uni&ersiy
Year of 'assin!
&D(B*
I*T$ Dhaziabad
?99
B% %lectrical0
+aculty of Technology 2 %ngineering$ *),$ Baroda
?998
@II
D)%B
?99:
@
D)%B
:AAA