Data Sql Server
Resume:
SWATI SUBHADA MISHRA
*************@*****.***
Contact: 408-***-****
PROFESSIONAL SUMMARY
Around 9 years (Onsite/Offshore) of professional experience comprising of Analysis, Design,
Implementation, Support, Testing, Documentation of various BI&DW products.
7 years of OLAP Application Development and Administration using Hyperion Essbase,
Hyperion Financial Data Quality Management, Hyperion Planning, Hyperion Financial
Reports, Hyperion Interactive reporting Studio, Smart View, Excel Add-in in Windows and
Unix environment.
Created both Block storage Applications (BSO) and Aggregate storage applications (ASO) in
Essbase.
Strong Understanding of Dense and Sparse dimension, performed dynamic calculations.
Experience in Maintenance and Administration of Hyperion Essbase Cubes, strong experience
in Data loading using Rule files, ESSCMD.
Expertise in writing ESSCMD and MaxL Commands.
Excellent knowledge in automating Hyperion processes using batch script, shell script.
Proficient in Excel Add-in and Hyperion Smart view.
Expertise in building Dashboards in Hyperion Interactive Reporting Studio.
Experience in designing and creating Hyperion FDM applications.
Well experienced in Oracle Data Integrator and Hyperion Financial Report.
Experienced in installation, maintenance, administration, and upgrade of Hyperion products
suite.
TECHNICAL SKILLS
Hyperion System: Hyperion Essbase 7.x/9.x/Hyperion System 11.1.2.1
Hyperion System 9 BI+ Interactive Reporting Studio
Hyperion Financial Reports, Hyperion Financial Data Quality Management
Hyperion Application Link, Hyperion Smart view, ESSCMD, MAXL
Hyperion Workspace, Hyperion Shared Services, LCM
Other Tools: Oracle Data Integrator
Languages: SQL, PL/SQL
Script: JavaScript, Shell Scripts, Batch Scripts, VB Scripts
Databases: Oracle
PROFESSIONAL EXPERIENCE
INTEGRATED FORECAST PLANNING
Client: Cisco Systems Dec, 2013 – Till date
Environment: Hyperion Essbase 11.1.2.1, Hyperion workspace 11.1.2.1,
Hyperion Shared Services 11.1.2.1, Unix, $Universe, LCM,
Oracle 11g
• Worked closely with business users to understand requirement for forecast cycle
and prepare scripts accordingly.
• Production Support, maintenance for Hyperion Essbase and Hyperion Planning
applications
Weekly manual data load
Month End manual Actual Load
Quarterly manual data load
• Migration using LCM
• Created Calculation Scripts for production activities
• Restart Planning Services when down
• Checking Planning Logs as per business requirement
• Performance tuning by Defragmentation.
• Data validation using smart view/excel add in.
LOCAL CURRENCY ACTUAL INTEGRATION
Client: Paramount Pictures JUL, 2012 – MAY, 2013
Environment: Hyperion Financial Data Quality Management, Hyperion
Essbase, SQL Server 2005
• Designed FDM applications to map the source data file as per the target Essbase
application.
• Created procedures and views in SQL Server to extract data from FDM
application.
• Created VB scripts to extract data from database Views and tables to text file so
as to load into Essbase database.
• Created and automated batch script to import & validate data in FDM
Application.
• Created and automated batch scripts to extract data from SQL staging and load
into ASO cube.
• Validated the loaded data using Excel add-in.
AMKOR REDESIGN
Client: Amkor Technology FEB, 2012 – JUN, 2012
Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Oracle Data
Integrator 10.1.3.5, Hyperion Financial Reporting 11.1.1.3, Hyperion
Excel add in
• Designed Essbase outline to accommodate the Meta data as per SAP BI feed.
• Built the Hyperion Planning application outline using ODI.
• Historical data migration to the new FINPBU cube by considering the new
dimensions. This is achieved by using ODI to define mapping of accounts and
locations between old and new application
• Created and automated shell scripts to migrate history data into cube.
• Re-design existing 210 FINPBU FR reports to accommodate the changes per
new cube.
• Test & Validate data interfaces for data quality testing using excel tie out
templates and FR reports.
AMKOR UPGRADATION
Client: Amkor Technology MAR, 2011 – JAN, 2012
Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion
HAL 7.0, Hyperion Financial Report 11.1.1.3, Hyperion Excel add in
• Upgrade Hyperion Planning 3.5.1 to 9.3.1 and then 9.3.1 to 11.1.1.2.
• Upgrade Hyperion Essbase 7.2 to 9.3.x and then 9.3.x to 11.1.1.2.
• Loaded Meta data into Hyperion Planning application using HAL.
• Created and automated shell scripts to load data into cube.
• Hyperion Financial Report development and testing.
• Prepared unit test cases to test shell scripts.
• Production support.
MARVELL SUPPORT
Client: Marvell Semiconductors NOV, 2010 – FEB, 2011
Environment: Hyperion Planning 9.3, Hyperion Essbase 9.3, Hyperion Financial
Report
• Created reports using Hyperion Financial Reports.
• Prepared automation scripts to export, load partial data from one cube to another
and calculate.
• Prepared calc scripts.
SATYAM COMPUTER SERVICES LTD FEB, 2005 – OCT, 2010
GLOBAL BUSINESS INSIGHT SOLUTION
Client: Electronic Arts
Environment: Hyperion Essbase, Clarity Performance Management, Remedy
• Monitoring the nightly processes i.e. Cube data archival, oracle procedures
pertaining to ETL and Cube building processes including special processes
during month ends, and troubleshooting related issues.
• Created user accounts and granted access based on their specific needs, on CPM
(Clarity Performance Management).
• Maintenance activities like restarting the Essbase server, and support activities
like monitoring sessions in Essbase and take measures to handle hanging
sessions.
• Developed automation processes using VB script for easy maintenance of project
documents.
EFRA
Client: CISCO
Environment: Informatica
• Analysis of the specifications provided by the clients.
• Develop and execute simple mappings using Informatica.
• Unit testing of the mappings.
• Responsible for overseeing the Quality procedures related to the project.
GOLDEN RULE SCORECARD DEVELOPMENT
Client: Golden Rule Insurance Company
Environment: Hyperion Interactive Reporting Studio, SQL Server, SPC XL
• Analysis of the specifications provided by the clients.
• Design and develop scorecard using Hyperion Interactive Reporting Studio.
• Develop Java scripts to export the intermediate results of tables on scorecard to
Excel/PDF files.
• Write the VB script for control chart creation using SPC XL utility.
• Setup a batch job for control chart creation using SPC XL.
• Setup up batch files for upload of control chart to Hyperion Repository in SQL
Server Enterprise Manager.
• Preparation of Unit Test Cases.
• Preparation of manuals including Operations Manual and User Manual.
• Unit Testing.
EDUCATION
MASTER IN COMPUTER APPLICATION
Contact this candidate