Manager Sql Server
Resume:
Badhrinath S
Sr Hyperion Essbase Developer
PROFESSIONAL SUMMARY:
> 8+ years of IT experience as a Developer, Analyst and Module lead in
building up Enterprise Data Warehouse, Real time reporting, Decision
systems in Insurance and Airlines sector
> My technological forte is Hyperion Essbase (11x, 7x, 6.5x) and SAP-
Business Objects (Universe Designer, Business Views, Crystal Reports,
Infoview, CMC).
> Tremendous knowledge in Insurance and Airlines Domains
> Experience in working with end users, mostly decision making managers, in
collecting requirements, bridging the technology and manufacturing
functionalities.
> Worked on end to end project estimation leveraging onsite offshore
efforts aligned towards the project objective and financial goal.
> Has been involved in the migration of Hyperion Essbase from 6x version to
11 x versions.
> 3 years and 5 months of experience in Production application support for
applications developed in VB 6.0.
> Experience in estimating the effort required for giving production fix in
Essbase applications from the developers perspective.
> Experience in getting Knowledge Transfer of applications and sharing the
same with team through Knowledge Transfer sessions.
> Good knowledge and experience in supporting and developing SSIS packaged
applications.
> Experience in training freshers in Hyperion Essbase 6.5.5 version for
three weeks.
> Good Understanding of Airlines Domain with a valid basic certification of
the same.
> Good understanding of Insurance domain with a valid basic certification
in insurance domain.
> Good analytical skills with ability to fix an issue with the root cause
analysis.
> Good communication skills with an experience of 4 years and 10 months in
communicating with both UK and US clients.
> Good team player and also has the ability to work individually..
> Experience in designing and developing SSIS and DTS packages.
TECHNICAL SKILLS:
> Databases : Hyperion Essbase, MS Access,
SQL Server 2000/2005/2008, DTS
Packages with SQL Server 2000, SSIS Packages
with SQL Server
2005/2008
> Reporting tools : SAP Business Objects, Crystal
Reports 2008, Business View Manager,
Basics of Universe Designer, Infoview, CMC
> OLAP : Hyperion Essbase, Hyperion
Spreadsheet Addins
> Operating Systems : Windows OS .
> ETL Tools : Basics of Ab-inito and SSIS
Packages
> Programming Languages : VB Script, Oracle SQL, PLSQL, SQL
> Batch Scheduler/Other Tools : Tivoli Batch Scheduling Console,
IBM Mainframes.
PROFFESSIONAL EXPERIENCE
Client: Southwest Airlines, Dallas, TX
Mar- 2012 -Till date
Role: Sr Hyperion Essbase consultant
Roles & Responsibilities:
. Worked with Subject Matter Experts (SME), business analysts, business
users and with other team members in gathering business requirements,
functional specifications, testing strategies and planning the
project.
. The Ab Initio system which is the source system for the Essbase cubes
has been upgraded from SIRAX to LINUX version. It produces .txt format
data and dimension input files to the Essbase cubes that are critical.
These text files helps in building the Essbase cubes daily, monthly
and quarterly through batch files. These batch files are triggered
through a batch scheduling console TIVOLI.
. Data Load Performance Tuning in the Essbase ASO cubes
. To Create an Error Handling process when the batch job fails or if the
source files are not available.
. Addition of New members for the Metric Roll Up measures and including
them to the rule files to be picked up from the Source file.
. To create a Crystal Report that pulls the Flight Details such as
Flight Date, Number, Origin, Destination, Out Time, In Time, Departure
Gate, Arrival Gate, Flight Type etc for the selected Date from the
Teradata and schedule the report through Infoview to email the
customers on a daily basis.
. Have to create many BO/Crystal reports as per Customer requests and
requirements
. Create a new BO report that provides the customers with the Delayed
and Cancelled flights on a daily basis.
. Create a report to find the Passenger Name Records (PNR) created
between 7 and 14 days ago where the 1st departure date is more than 3
days after the booking date and greater than the report date based on
the entered Pseudo City Code value. PNRs that have been ticketed via
Point Of Sale (POS) or Ticketless or show a form of payment have been
excluded.
. Analyze the business requirement.
. Estimate the effort required by the developer to complete the work.
. Convert the business requirement into technical design.
. Creating a TEST Application and Database with the latest outlines in
the PRODUCTION
Environment.
. Requirement gathering by directly interacting with end users.
. Preparing user requirement document and sign off.
. Development coordination with offshore team.
. Check the quality of the deliverable.
. Develop / review test plans.
. Tracing the requirement with development and test cases.
. Creating status reports and reporting to internal manager and client
side manager.
. Unit Testing
. System Testing
. User acceptance testing.
. Code migration and post migration checks
. Application Support Post.
Environment: Hyperion Essbase 7x, Hyperion Essbase Spread Sheet Addins,
Teradata, Oracle 11g Database, Business Objects, Infoview, Crystal Reports
2008.
VISA INC, Foster city, CA
Apr 2010
to Feb 2012
Senior Hyperion Essbase Developer
Major scope of the project is to Implement Essbase in connection with
financial budgeting, sales forecasting and marketing analysis to produce ad-
hoc reports.
Responsibilities:
. Translated end-user requirements into application design
specifications.
. Assured optimal match between cube design and report specifications.
. Develop new Essbase cubes and database objects or update existing ones
to meet new business requirements.
. Optimized outline structure, loading and calculations through
appropriate dense and sparse settings of dimensions, storage
allocations and by dynamic calculations and debugging.
. Optimized cache settings, established user security, managed
applications migration, established substitution variables and
settings for dynamic time series, asynchronous processing, and
editing/validating scripts.
. Developed and designed cubes using Essbase Integration Services.
. Managed system upgrades and client installations based on users
requirements.
. Developed Batch files using MaxL, and Rules files to upload data from
financial systems Database to Essbase cube.
. Handled performance tuning, weekly back-ups and monthly consolidations
of data and automated monthly/quarterly/annual report generation.
. Developed Analyzer OLAP views and sophisticated what-if scenarios for
the end users.
. Documented and issued procedures pertaining to Essbase applications.
. Provided business analysts with advice and options on opportunities to
leverage the tool and increase usage.
Environment: Hyperion Essbase 7x, Hyperion Essbase Spread Sheet Addins,
Teradata, Oracle 11g Database, Business Objects, Infoview, Crystal Reports
2008.
Client: AXA Sun-life Insurance, Bristol, United Kingdom
Oct 2008- Mar 2010
Role: Software Engineer- Essbase Support
. We have been using the Hyperion Essbase version 6.5.5 for all the
applications and databases. But, now we have to migrate all the
Applications and the databases from the old server with Hyperion
Essbase version 6.5.5 to the new server of the latest version of
Hyperion Essbase 11.1.1
. The financial data will be downloaded from the IBM Mainframe systems
into a .txt file format. This text file is then fed into MIST system
through an interface system called THAT system and from there it is
loaded into Essbase through automation panels. Addition of a new
member to the outline and go through end to end testing through
Essbase.
. Business needs to amend a SSIS package in the production Database
inorder to process an additional input file produced by the business
on a weekly basis, by creatin few more temporary tables in the
database with the help of stored procedures and amend the data along
with the existing Output file that would be provided to the them on a
weekly basis.
. Touch Stone Change in IDM-SDR :
. The financial data without any touch stone code generally flows into a
code named xxx, however the business wanted this to be changed. A new
touchstone code called 90 has to be created and all the data that
comes in without a touchstone code has to flow under this code.
. VB Applications Support.
. Analyze the business requirement.
. Estimate the effort required by the developer to complete the work.
. Convert the business requirement into technical design.
. Creating a TEST Application and Database with the latest outlines in
the PRODUCTION
Environment.
. Requirement gathering by directly interacting with end users
. Preparing user requirement document and sign off.
. Development coordination with offshore team.
. Check the quality of the deliverable.
. Develop / review test plans.
. Tracing the requirement with development and test cases.
. Creating status reports and reporting to internal manager and client
side manager.
. Unit Testing
. System Testing
. User acceptance testing.
. Code migration and post migration checks
. Application Support Post Migration
Environment: Oracle Hyperion Essbase 6.5.5, Oracle Hyperion Essbase 11.1.1,
Hyperion Essbase Spread Sheet Addins, MS Access, SQL Server 2000/2005/2008,
DTS Packages with SQL Server 2000, SSIS Packages with SQL Server 2005/2008
Tata Consultancy services, INDIA
July 2006 Sep 2008
Hyperion Essbase Developer
This application is developed for Lehman Brothers is a global investment
bank serving the financial needs of corporations, institutions, governments
and high net worth investors worldwide. Lehman Brothers deals with variety
of services ranging from Credit Risk Management, Equities, Fixed Income,
Global Economics, e-Commerce, Investment Banking, Lehman Brothers Bank, Ops
& Corp Services, Private Client Services and Private Equity. This purpose
of this project was to automate Listed Derivatives (Futures and Options)
processing, involving Futures Operations Department, Product Data Quality
Group, Trading Systems, Equity Operations Desk, etc. This system enhances
the use of Lehmans Electronic Trading Services.
Responsibilities:
. Designed efficient and effective outlines and calculation scripts and
created rules files to automate dimension building and data loading.
. Used standard Essbase practices of building outlines and partitions,
including level and parent references.
. Expertise in building cube Financial Budgeting and Forecasting OLAP
applications with Essbase Involved in optimization of Essbase server
settings for the best performance, created queries using the Essbase
query designer, created calc scripts.
. Extensively involved in changing the outlines for cubes.
. Child methods of building outlines. Developed calc scripts to derive
complex calculations such as cash cost per user, YTD commitment,
variance, capital expenditure forecast and budgeted cash flow
statements.
. Developed scripts to automate daily backup and consolidations of
monthly data.
. Performed performance tuning and database optimization by using
appropriate dense/sparse configuration, outline structure strategies
such as dynamic calculations, attribute dimensions, partitioning etc.
and optimization of calc scripts and tuning of calc cache.
. Created ESSCMD scripts to update outlines in batch, load data and
execute calc scripts, during maintenance.
. Involved in administrative activities such as installation and upgrade
of software products including ESSBASE, setting up users, security
groups and access filters to set the security policy and to ensure
maximum security.
. Involved in day-to-day administrative activities such as managing
users on the Essbase server, backing up cubes, identifying and
resolving problems.
. Coordinated with users in getting signoff on the changes
additions/deletions. Involved in the migration of Essbase from version
6.5x to 7.1.6
. Designed and developed Quality Assurance standard and processes to all
levels of project team
. Documented the defects and their trailing history in ClearQuest and
helped developers identify the modules and code sections to be fixed
by executing the related scenarios with different combinations of data
. Identified risks, methods (inspection, review), baseline acceptance
criteria and deliverables
Environment: Hyperion Essbase 7.1/6.x, Hyperion Reports, shell scripts,
Oracle SQL, IBM AIX, UNIX, Shell Scripting, PL/SQL and Oracle 8i.
Contact this candidate