Name : Kavyasree Byreddy

Email : actace@r.postjobfree.com:actace@r.postjobfree.com

Contact : 201-***-****

Professional Summary

Over 7 (Seven) years of experience in design, analysis, development and implementation of various applications in client/server environment by using various versions of Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Workspace, Hyperion Shared Services, EPMA and generating numerous reports by using Essbase Excel Add in /SmartView, CHANGE Management, Process Transformation, Financial Reporting and Hyperion Interactive reporting. Experienced in working on database side to Map, Extract and Manipulate data and performed Gap Analysis.

Extensive experience in developing and designing of Essbase Cubes, Dynamically Build members in the Cube, load Rules, ESSCMD, MaXL, Calc scripts, Security and Provisioning in Hyperion Shared Services, Hyperion Planning ( Data Forms, Security, Metadata maintenance and Business Rules), Web Analysis, Essbase Excel Add-In, Financial reporting and Hyperion Interactive Reporting Studio (Complex Reports, Reporting Studio, Joins and Data Modeling).

Involved in installation and configurations of various products of Hyperion system 11.x, 9.x, 7.x such as Hyperion Analytics Services, HFM, Hyperion Planning, Analytic Services Client and Essbase Administrative Service (EAS) Console

Migration of Hyperion applications from 11.1.2.3 and higher.

Extensive experience in Hyperion Essbase System 11.x/9.x/7.x.

Designed and developed numerous complex Essbase and Hyperion Planning applications with excellent balance of Dense and sparse dimensions.

Developed various OLAP Models and Meta-Outline using Essbase Integration Services.

Expertise in working in ASO and BSO cubes.

Worked on modifying existing VB scripts in FDM.

Extensive knowledge in CHANGE Management, Process Transformation.

Created forms based on the user requirement using Hyperion Planning.

Proficient in the star and snowflake schema data modeling techniques used to design for data warehouse and data mart.

Trained and supported End users in UAT.

Experience in providing support & maintenance for Hyperion Applications.

Experience with Java-based process to automatically generate Excel workbooks containing EIS drill through reports, and email them to Cost Center owners. Each Cost Center owners receives a workbook containing data specific to their Cost Center.

Experienced in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, ESSCMD and Batch Scripts.

Experience with Capex, Work force and RevOpex

Experienced in writing SQL quires for improving data load performance.

Experience in the full software development life cycle (SDLC) using the Waterfall Model and Rational Unified Process (RUP) with a good understanding of Agile Methodologies

Administered Hyperion shared services for creating users and groups, and granting access to applications and databases

Technical writing - Use Case development, sequence diagrams, process & workflows, data dictionaries, gap analyses, change requests, test scripts, etc.

Skilled in working with both client & development team. Successfully complete projects & works with client to develop ongoing relationship.

Versatile team player with ability to work independently having excellent analytical, presentation and inter-personal skills with ability at building productive relationships

Good knowledge of financial reports like balance sheet, income statements, p&l statements, cash flow statements, account receivables and payables.

Technical skills: Oracle/Hyperion Business Performance Management & Intelligence Solutions Products:

Hyperion Applications

Hyperion Essbase 11.x/9.x/7.x,Hyperion Planning 11.1.2.3, Hyperion financial management(HFM), Hyperion Workspace, Essbase Integration Services (EIS), Hyperion Shared Services, Essbase Analytic Services, FDM, EPMA

Reporting Tools

Excel-Add-In, Hyperion Smart view, SQL server reporting, Web Analysis, Hyperion Financial Reporting, Hyperion Interactive Reporting (Brio),

Databases

MS SQL Server 2005, Oracle 10g/9i/8i

Languages

C, Microsoft VBA, HTML, SQL, MaXL, MDX, JAVA

Operating Systems

Windows 98/2000/2003/NT/XP, Windows server 2003, Unix

Microsoft Office suite

Microsoft Power point, Visio, MS Project, MS Excel, MS Word, Microsoft VBA.

Education: Bachelor's Degree in Computer Science,India

Work Experience

Client : BaseCommerce, Tempe, AZ May 2014 - Current

Hyperion Essbase and EPMA

An electronic payments enablement platform with best-in-class tools and support for software developers and business applications focused on multi-merchant products services. Used agile process (with Scrum methodology) for development. Meet with clients for define needs. Thus identifying and analyzing possible system solution/ redesigning.

Responsibilities:

Involved with data analysts in design of Extract, Transform and Loading of meta-data From people-soft to Oracle Database, EPMA, Essbase Studio and in downstream Applications.

Performed EPMA filtering, configuration, batch jobs for the different applications and Financials Reports.

Involved in Migration from 9.1.2.to 11.1.2.3.

Developed a Java-based process that compares 2 Essbase outlines against each other, identifying missing members, differences in parent-child relationships, and so on. This process was used to validate that a dimension or cube promoted from one environment to another matched.

Implementation involves Capex, Workforce and RevOpex

Involved in analyzing requirements, functional specifications, design documentation and testing strategies.

Involved in coding of stored procedures and functions.

Worked on Shared services in revising and setting up new groups and filters.

Worked on Two ASO cube OPBS C01 and REPORT cube.

Involved in production support and maintenance of existing cubes.

Performed Impact Analysis.

Performed end to end System Integration Testing.

Handle UAT defects and performed production Deployment.

Environment: Hyperion Essbase 11.1.3, Hyperion planning 11.1.3,EPMA, Java, Shared Services, Hyperion Workspace, Smart View, Excel Add- In, Excel Query Designer and Windows 2005 server, Oracle 10g, Informatica 8.1 & 9.1.

Client : Etailz, Spokane, WA Jan 2013 – April 2014

Hyperion Planning lead Developer

Operates e-commerce sites that offer environmentally-friendly products including GreenCupboards.com, EcoMom.com and EveryCasa.com. It also develops proprietary software tools that optimize purchasing decisions, inventory management, fulfillment and customer service each and every billing process.

Responsibilities:

Analyzed the Business Requirements Documents to understand and construct the prospective planning cube and interact with the business users to facilitate the mutual understanding and implementation of the application in production environment.

Write and maintain the TTD (Technical Design Document) for the EXPFCST planning application.

Actively participate in weekly status meeting during development phase and daily standup meeting during UAT phase.

Involved with business users and database team for extracting, transforming and loading the dimensions and data into planning application through the help of Informatica 8.1

Worked on Oracle Database for load optimization.

Developed SQL load rules for some dimensions and loaded some dimension and attributes through flat files.

Performed migrations using LCM between environments

Developed calc scripts and business rules.

Installed and configured ODI standalone agents.

Created POV's for actuals and budget data loads through Hyperion smart view

Developed all Informatica Mapping, Session and Workflows.

Created Web Forms Menus according to requirements.

Automated building dimensions, loading data and calculation scripts using MaxL.

Developed a numbers of web forms including composite web forms.

Create task lists and planning unit hierarchy for Process management.

Maintain FX rates, Merit rates, Fringe rates, Allocation rates and Bonus rates through different business rules.

Worked on supporting detail on the beginning of each planning cycle.

Schedule the entire process using windows batch scheduler in development environment.

Worked on Excel Add-in and Smart view Tools to generate various ad-hoc reports for analyzing the business.

Migrate the application and code form development to UAT environment and UAT environment to Production

Communicated with the financial team in order to meet reporting and consolidation requirements

Created the CI Logs for all the application objects.

Continuously worked on problem solving, and adding needed documentation

Environment: Hyperion Essbase 9.3.3, Hyperion planning 9.3.3, Hyperion Workspace, Hyperion Web Launcher, Excel Add- In, Excel Query Designer and Windows 2005 server, Oracle 10g, Informatica 8.1 & 9.1.

Client : MedHok, Tampa, FL Nov 2011 – Dec 2012

Hyperion Essbase Developer/Report Developer

Provides SaaS that improves clinical outcomes and quality measures and links reimbursement to improved quality outcomes for health plans, accountable care organizations, patient centered medical homes, pharmacy benefit managers and prescription specialty organizations.

Responsibilities:

Involved in gathering and analyzing requirements, functional specifications, design documentation and testing strategies.

Involved in Capacity Planning meetings and project management meeting.

Involved with customers and data analysts in design of Extract, Transform and Loading of data into data marts.

Extensively used ESSCMD &MaXL script to run automation job on UNIX system.

Designed & developed the Essbase CUBE dynamically using Load Rule Files.

Worked on SQL databases for load optimization.

Optimized the Essbase cube to balance the calculation and retrieval performance.

Designed and developed OLAP models and Meta outlines in EIS for all the Essbase cubes.

Automated building dimensions, loading data and calculation scripts using MaxL.

Created data models for Interactive Reporting and generate numerous complex queries and reports using drill paths and scheduled interactive reports job on demand.

Performed migration of all applications to the performance management architect.

Developed the analytic reports using Hyperion Web Analysis, Interactive Reporting, Financial Reporting, Excel Add-in and Smart view.

Worked on two Hyperion planning application on 11.1.2 as a production support. The day to day task involved the maintenance of planning Hierarchy, data loading, adding and maintaining business rules, Task list and clearing supporting detail.

Involved in writing source code using sql,pl/sql.

Schedule the entire process using windows batch scheduler in development environment.

Migration cubes and code form development to testing environment sand testing environment to Production

Performed lifecycle management migration of numerous oracle hyperion planning applications.

Participated in testing, debugging and documentation

Involved in coding of stored procedures and functions.

Worked on Excel Add-in and Smart view Tools to generate various ad-hoc reports for analyzing the business.

Migration of Hyperion applications and reports from system 9.3.1 to system 11.1.2

Worked on designing the database outlines to get the best performance of Essbase Server.

Created filters on subdivision of various cubes to grant appropriate access according to users jobs and responsibilities using Data Definition Language.

Environments: HyperionEssbase 11.1.2, Essbase Studio, Essbase Integration Services,, Hyperion Essbase 9.x, Hyperion Planning 9.x, EPMA, Hyperion Web Analysis, Hyperion workspace, Hyperion Interactive reporting, Hyperion Excel Add-in, Smart View, UNIX,SQL Server 2008, Oracle 9i& Windows 2005 server, Financial Reports and Web analysis.

Client : Fulton Communications, Roswell,GA Aug 2010 – Oct 2011

Hyperion Essbase Developer/ Hyperion Planning

A full service communications provider, specializing in SIP, VM and MPLS deployments. It also integrates low voltage wiring, surveillance and monitoring systems for clients in various businesses.

Responsibilities:

Involved in gathering and analyzing requirements, functional specifications and design documentation.

Worked in a team of 6 to create a system for all sales data

Functions and Formulas were used to drive reports where users can see lower level data from summary level (drill-through)

Optimized data loads and calculation scripts by proper ordering of members in dense/sparse dimensions.

Works on Data base to map data according to outline for faster loading.

Involved in designing, modifying, and optimizing the Essbase database outlines, and data blocks

Developed Essbase cubes, loaded data, and designed reports with Web-Analysis

Created rule files to upload data from the system’s database to Essbase

Created planning application objects and Forms.

Performed migration of all applications to the performance management architect.

Created planning classic application for testing.

Generated numerous Financial reports and charts on weekly/Monthly basis for users

Optimized the database by writing calculation scripts to improve performance

Developed reports using Hyperion Interactive reporting.

Continuously worked on problem solving, and adding needed documentation

Environment: Hyperion Essbase 9.x, Essbase Integration Services, Hyperion Workspace, Excel Add- In, Excel Query Designer, Hyperion Financial Reporting and Windows 2000/NT

Client : CompuMasterInc,India Aug 2008 – July 2010

Hyperion Consultant

Designed and developed Fixed Income Wrap System. In this System, Holdings information must be extracted from the Beta System and presented to the Portfolio Manager who can then generate the necessary trades to bring accounts in line with a model account in terms of effective duration, market value, etc.

Responsibilities:

Built Essbase, performed data loading of financial data and utilized calculation scripts to properly update information

Created rules files for dynamic outline build.

Developed & Maintained BSO Cubes

Modified and maintained Hyperion Essbase applications and databases to incorporate new business requirements

Utilized Excel Spreadsheet Add-in and SQL server reporting tools to help meet the reporting needs of business and management

Worked on SQL server to Map data bases. And constructed Data Mart.

Developed and employed calculation scripts

Perform the analysis necessary to design and architect solutions that meet identified client requirements

Work closely with client management and users to define requirements and project scope

Managed the use of time and other resources to complete projects

Environment: Hyperion Essbase 7, MS Windows 2000/NT/XP, Excel Add-In, SQL server

Contact this candidate