Essbase Developer
Resume:
Dharanidharan Ramakrishnan
Email Id : *********.*******@*****.***
Phone : +91-984*******
Professional Summary:
To provide a platform to my career by being a privileged member of an esteemed and
renowned organization and to update myself with the rapid springing up technology which is
beneficial for the growth of organization and for my personal development as a techie.
Good working knowledge on the Hyperion products like Essbase, Spread Sheet Add Ins.
Good working knowledge on designing, Modifying and building of cubes and assigning
member properties in Essbase.
Good working at Dynamic Dimension build methods, Dimension rules and Data Load
rules
Good working at writing reporting Scripts used for Data loading and reporting.
Good working at writing calculation scripts used to calculate the database.
Good knowledge in writing Esscmd commands in essbase and Unix scripts for
automation
Good working knowledge on Autosys job scheduler.
Professional Experience:
Organization Duration
CSC India Pvt Ltd Jul 2012 – Till date
Educational Qualification:
MCA (Computer Application) – VeltechMultitech engineering college, Chennai -8.03(CGP)
BCA(Computer Application) – St.Joseph’s College of Arts and Science, Cuddalore – 63%
H S C – Government Higher Secondary School, Pudupet – 71.1 %
S S L C – Government High School, Anguchettipalayam. – 85.4%.
Software Skills:
Applications : Hyperion Essbase 11.x
Operating System : Windows, UNIX
MS-office tools : Word, Excel, Power point
Scripting language : HTML
Scheduling Tools : Autosys, JIL scripts
Database Languages : SQL, DB2
Reporting Tools : Microsoft Excel Spread Sheet Add in for Essbase,
And Smart view
Dharanidharan Ramakrishnan
Email Id : *********.*******@*****.***
Phone : +91-984*******
Particulars of Projects:
Project 1:
Project Description: Chrysler is one the leading manufacturers of automobiles in U.S, The
system has several Applications (Around 30 apps) like G&A, S&M Income statements, CFA etc.
which stores data regarding actuals and forecasts, Using this existing Applications/Databases, the
system should provide the variance between the two selected scenarios and the variance should
be presented in the 9 forms such as Incentive, Discounts etc.
Project Name Variance Reporting Start Date Jul 2012
Client Chrysler LLC. End Date Nov 2012
Essbase 11.x, Autosys, Solaris, Windows, Excel
Tools Role Team Member
Add In
Contributions:
Setting up outline as per the requirements.
Involved in designing, modifying and building of cubes and assigning member properties.
Involved in creating, modifying calc scripts as per the business requirements to solve
production issues.
Involved in optimization of outline, calculation scripts and Reporting Scripts.
Involved in designing the load rule files for dimension building and data loading from
Excel sheets and flat files.
Involved in designing security filters and groups and assigning them to end users.
Involved in writing ESSCMD commands for automation of Essbase jobs through Java
interface.
Developed the UNIX shell scripts for automated data loading .
Project 2:
Project Description : Chrysler is one the leading manufacturers of automobiles in U.S, The
system has several Applications(Around 30 apps) like G&A, S&M Income statements, CFA etc.
which stores data regarding actuals and forecasts, Using this existing Applications/Databases, the
Dharanidharan Ramakrishnan
Email Id : *********.*******@*****.***
Phone : +91-984*******
system should analyze Sales, profit and forecasts and generates reports at Segment
level(NAFTA,APAC,EMEA,LATAM).
Project Name Segment Reporting Start Date Dec 2012
Client Chrysler LLC. End Date Mar 2013
Essbase 11.x, Autosys, Solaris, Windows, Excel
Tools Role Team Member
Add In
Contributions:
Setting up outline as per the requirements.
Involved in designing, modifying and building of cubes and assigning member properties.
Involved in creating, modifying calc scripts as per the business requirements to solve
production issues.
Involved in optimization of outline, calculation scripts and Reporting Scripts.
Involved in designing the load rule files for dimension building and data loading from
Excel sheets and flat files.
Involved in designing security filters and groups and assigning them to end users.
Involved in writing ESSCMD commands for automation of Essbase jobs through
Autosys.
Developed the UNIX shell scripts for automated data loading and month end rollovers
Project 3:
Project Description : Chrysler is one the leading manufacturers of automobiles in U.S, The
system has several Applications(Around 30 apps) like G&A, S&M Income statements, CFA etc.
which stores data regarding actuals and forecasts, Using this existing Applications/Databases, the
system should analyze Sales, profit and forecasts and generates reports for CFA, Inventory and
Tax Forecast.
Project Name Finance & Controlling – Essbase Start Date Apr 2013
Client Chrysler LLC. End Date Till Date
Essbase 11.x, Autosys, Solaris, Windows, Excel
Tools Role Team Member
Add In
Contributions:
Setting up outline as per the above study.
Involved in designing, modifying and building of cubes and assigning member properties.
Involved in creating, modifying calc scripts as per the business requirements to solve
production issues.
Dharanidharan Ramakrishnan
Email Id : *********.*******@*****.***
Phone : +91-984*******
Involved in optimization of outline, calculation scripts and Reporting Scripts.
Involved in designing the load rule files for dimension building and data loading from
Excel sheets and flat files.
Involved in designing security filters and groups and assigning them to end users.
Involved in writing MaxL scripts, ESSCMD commands for automation of Essbase jobs
through Autosys
Developed the UNIX shell scripts for automated data loading and month end rollovers
Project 4:
Project Description: Running the Jtest on the java codes which are in production with the rule
set given by the Chrysler and Updating the Client about the efficiency in the java codes, and we
completed it as a module.
Project Name JTEST for Java applications Start Date Nov 2013
Client Chrysler LLC. End Date Jan 2014
Tools JTEST Plug In Role Team Member
Operating
Environment IBM IRAD 6.5 Windows 7
System
Contributions:
Gathering the required java ears and supporting jar files from the different sub portfolios.
Setting up the workspace
Updating the results of Jtest in the excel sheet and presenting to the client.
Attending the client calls.
Recognizations:
• Received Appreciation certificates for supporting the ESSBASE applications.
Personal Traits:
Capable of distilling complex technical concepts to non –IT executives,
Capable of Gathering the requirements clearly,
Capable of motivating the team to deliver the project on time,
Able to prioritize the work,
Personal Profile:
Name : Dharanidharan Ramakrishnan
Dharanidharan Ramakrishnan
Email Id : *********.*******@*****.***
Phone : +91-984*******
Father’s Name : Ramakrishnan
Sex : Male
Nationality : Indian
Languages known : Tamil, English
Date of Birth : 28-06-1989
Declaration:
I hereby declare that all the information furnished above is true to the best of my
knowledge.
PLACE:
DATE : (Dharanidharan
R)
Contact this candidate