Objective:
Seek position as Hyperion Reports Developer in which I can be a major contributor, enhance my skills and broaden my areas of expertise. I am enthusiastic about continuing my experience and advancing to new areas. I have proven my ability to meet challenges in over 8 years of diverse experience and I am now ready for a new challenge.

Summary of qualification:

• Possess over eight years of experience in Relational Databases, Data warehouses, Client-Server applications and Oracle and SQL Server Database Administration.
• Over seven years of functional experience indesign, analysis, development and implementation of various applications using Hyperion Enterprise Performance Management system including Hyperion Business Intelligence suite, Planning, Essbase and Financial Management under Windows, AIX and UNIX environments.
• Have hands on experience on creating dashboards and reports using Hyperion SQR Production reporting, Financial Reporting, Interactive reporting (Brio) and Web Analysis.
• Have hands on experience in the entire Life Cycle of Data warehouse design and in designing, Writing and Executing Test Plans.
• Good hands on experience with building the application interface using Java scripts and worked on building control to dashboard, standard and Ad-Hoc Reports.
• Experience in architecting complete data models combining multiple transaction systems ETL tools and relational and multidimensional data stores for star schema, snow flake schema designs and reporting tools.
• Designed and developed various types of reports (Pivot, Tabular and Chart and OLAP Query reports) to be used by various user groups using Hyperion Interactive Reporting (Brio/Intelligence Explorer).
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Excellent in coding Oracle SQL, PL/SQL, Stored Procedures and Triggers in PL/SQL and administrating databases in Oracle and SQL Server.
• Effective team player, self-motivated, capable of adapting to new technology and possessing strong problem solving and analytical skills, excellent verbal, written and inter-personal communication skills.

Technical skills:

Reporting Tools: Hyperion Interactive Reporting (Brio), SQR Production Reporting, Financial Reporting (Reports), Web Analysis (Analyzer) and Cognos BI reporting v8.
OLAP Tools: Hyperion Essbase 11.x/9.x/7.x - Essbase Integration Services, Essbase Administration Services, Excel Add-In, Visual Explorer and Essbase Query Designer.
Business Intelligence Tools: Hyperion BI+ Suite, Hyperion Planning, Hyperion Application Link (HAL) and Hyperion Financial Management Suite (HFM).
Dimensional Modeling: Star-Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.
Internet Technologies: ASP, XML, HTML, MS FrontPage, Dream Weaver, Macromedia Flash.
RDBMS: Oracle 10g/9i/8i, 7.0, DB2, Teradata, MS SQL Server, MS Access.
Operating system: Windows 98/2000/XP, MS DOS 6.22, UNIX (Solaris), Linux and AIX version 5L.
Languages: C, C++, Java, Visual Basic, C #, JavaScript, VB script, SAP - ABAP, SQL, PL/SQL, SQL*Plus 3.3/8.0, UNIX Shell Scripting.

Educational history:

• Completed BS from Anna University, Chennai with First class with distinction,Spr'01.
• Certified Hyperion Professional (May 2006).

Employment history:

Confidential, is the central banking system of the United States which is responsible for conducting the nation\'s monetary policy by influencing monetary and credit conditions. The Project involved in creating dashboards and reports for the client's applications using Hyperion Interactive reporting Studio (Brio), Financial Reporting and Web Analysis.

Roles & Responsibilities:

• Extensive Dashboards were built providing easy access to the managers and executives to various reports using Hyperion Interactive Reporting Studio (Brio).
• Used Web Analysis, Financial Reporting and Interactive reporting to prepare quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Developed and Published Daily and weekly reports using Financial Reporting studio to the Senior IT Managers.
• Published and scheduled handful of trending analysis dashboards and reports in Hyperion Workspace for the Strategic Finance team.
• Developed customer user-friendly reports and graphs self-contained in financial models.
• Data Models were used to analyze many business issues and to integrate the strategic planning processes.
• Worked with building client interface with Java, Java scripts and worked with publishing the reports with Java portal.
• Good hands on in working with building the custom Java scripts using the both QIQ and standards Java controls.
• Enhanced/modified existing financial reports as per changes in reporting requirements.
• Created the functional design documentation and specifications for the reporting modules.
• Upgraded and migrated the Hyperion products and applications to 9.3 and then to 11.1 from client's older version, 8.3.
• Created numerous Management Report & Booksfor the Client's Payment History application using Financial Reporting Studio.
• Created ODBCs, DAS and OCEs to establish a connection between the Hyperion Interactive Reporting (Brio) and the relational databases.

Environment: (Used v11.1 and v9.3) Hyperion Interactive Reporting, Hyperion Workspace, Hyperion Financial Reporting, Smart View, Essbase - Administration Services, Integration Services, Essbase Visual Explorer, Hyperion Excel Add-in, Oracle 10g, UNIX and Windows.

Sr. Hyperion Reports Developer
Confidential, Chicago, IL Jul 2008 - May2009

Confidential, is one of the nation's leading electricity generating and distributing company headquartered in Chicago, IL. The project involved in building a new planning application to help budgeting and forecasting processes, develop numerous dashboardsandreports using Interactive Reporting Studio and Financial Reporting Studio for the business units.

Roles & Responsibilities:

• Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion Interactive reporting studio (Brio).
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion financial reporting and Hyperion Smartview.
• Extensively involved in developing a planning application, which provides a platform to do budgeting and forecasting the Energy generation and utilization for the next 20 years.
• Responsible for publishing the dashboards and reports in Hyperion Workspace for various Accounting teams.
• Upgraded existingbrio reports from version 6.x to 9.3 and then to 11.1. Also performed the conversion of Business Objects reports to Hyperion as per client's request.
• Created numerous data models to help the report building process which is very complex, since we got data from multiple data sources.
• Led a team of four,responsible for migrating and converting the older version Hyperion Brio reports and Business Objects to the Hyperion Interactive Reporting and Financial Reporting.
• Provided training to the Exelon users in running the reports and consolidations and also to analyze the Essbase data using Hyperion Visual Analyzer and Hyperion Excel add-in.
• Consolidated the MS-Excel and MS-Access data from various users to Oracle database using Hyperion write back capabilities.

Environment: (Used v11.1.1 and v9.2) Hyperion Interactive Reporting, Financial Reporting, Data Integration Management (DIM), Smart View, Hyperion Workspace, Web Analysis, Essbase Administration Services, Hyperion Planning, Hyperion Excel Add-in, Oracle 10g and Windows.

Sr. Hyperion Reports Consultant
Confidential, Houston, TX Apr 2007 - Jul 2008

Confidential, is a worldwide oil and natural gas exploration and production company based on Houston, TX. The project involved in building a reporting infrastructure for the planning applications, putting the data load processes for automation and designing and generating reports and dashboards for helping the management with financial reports.

Roles & Responsibilities:

• Developed Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
• Developed new dashboards and ad hoc reports for different business teams using Interactive Reporting (Brio) and Hyperion Web Analysis (Analyzer).
• Assisted the integration of Interactive reporting process along with streamlining of method improvement for data collection and loading processes.
• Responsible for gathering business requirements from numerous business units.
• Created custom calendars using Job Utilities menu to support the events and jobs scheduled to run the IR reports.
• Used Oracle Business Intelligence Enterprise Edition (OBIEE) to build and deliver reports based on OBIEE Data warehousing tables.
• Applied various Filters for efficient and accurate retrieval of required data using Hyperion Interactive Reporting Studio.
• Upgraded and migrated all the applications and databases from older versions. Prepared monthly procedures, system and training documentation for Marathon Oil Corporation users.

Environment: (Used v9.3) Hyperion Interactive Reporting (Brio), Essbase - Administration services and Integration services, Hyperion Planning, Web Analysis (Analyzer), Financial Reporting (Reports), Excel Add-in, Hyperion Strategic Finance (HSF), HAL, OBIEE, Smart view, Clarity 2.3, SAP, Windows and SQL server 2000.

Hyperion Reports Developer
Confidential, New York, NY Dec 2005 - Mar 2007

Confidential, is the financial and insurance company based on Manhattan in New York City. Developed and maintained Dashboards and Reports for the Hyperion Planning and budgeting application, optimized queries and scheduled data loads and reports generation for the whole year, monthly, weekly and daily as per the requirement from business users.

Roles & Responsibilities:

• Extensively worked on Hyperion Interactive Reporting (Brio), Hyperion SQR Production Reporting and Hyperion Analyzer (Web Analysis) to generate financial reports from relational databases as well as Multi-Dimensional Databases.
• Worked with business users to obtain requirements and design, build and deploy new Brio reports in Windows environment.
• Created tabular, non-tabular, master/detail system independent portable reports along with graphs and charts to present data in visual terms.
• Published reports in the Hyperion performance Suite and give access privileges to various user groups.
• Using functionality of Hyperion Interactive Reporting (Brio) and SQR production reporting, created personalized dashboards and report queries and performed detailed analysis using pivots and charts.

Environment: HyperionInteractive Reporting (BRIO) 8.3, SQR Production Reporting, Hyperion Essbase 7.1.2, Hyperion Planning, Hyperion Reports (Financial Reporting), Hyperion Analyzer (Web Analysis) 6.5, Business Objects, Oracle 9i Database, AIX, Windows NT and LINUX.

Hyperion Developer
Confidential, Birmingham, AL Dec 2004 - Dec 2005

Confidential, the public held banking company operated in the Southern states. The project involved development of two financial applications and numerous cubes and reports highlighting the financial results of various businesses at the bank.

Roles & Responsibilities:

• Responsible for developing dashboards and reports, creating technical specifications, testing and QA of reports.
• Created queries and developed reports using Hyperion Intelligence Explorer (Brio/Interactive Reporting).
• Established the Usage and Event tracking mechanisms in Hyperion Workspace for future auditing purposes.
• Created Management, Trending and Statutory reports based on client's reporting needs.
• Responsible for performing financial consolidation operations such as currency conversions and internal data eliminations.
• Maintained over 100 reports and updated the reports to reflect database changes. Wrote Currency Conversion scripts since the client used multiple currencies with US dollars.

Environment: HyperionInteractive Reporting (Brio/Intelligence Explorer) 8.3/6.6, SQR Production Reporting, Hyperion Analyzer (Web Analysis), Hyperion Performance Suite/Hyperion Portal, Hyperion Essbase 6.5/7.1, Oracle Database, DB/2, Windows 2000 and AIX version 5L (v5.2).

Hyperion Reports Analyst
Confidential, Chicago, IL Mar 2003 - Nov 2004

Confidential, a subsidiary of HSBC bank, in which the project involved in building the Hyperion Enterprise and Essbase applications and performed integrating Hyperion with the existing suite of main applications for its local usage for approving loans and credits to its consumers and departmental analysis.

Roles & Responsibilities:

• Modified, replaced and duplicated existing financial, marketing reports developed in Hyperion Intelligence Explorer (Interactive Reporting) and Reports (Financial Reporting).
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users.
• Worked with Brio Portal and Demand Server to Publish reports on Web.
• Created a template to maintain the member alias names and data locks. Also cross-trained the Essbase administrators to use the template in effective manner.

Environment: Hyperion Essbase 6.2/6.5, Hyperion Intelligence Explorer (Interactive Reporting/Brio) 6.2, Hyperion Analyzer (Web Analysis), Hyperion Spiderman, Hyperion Enterprise, Hyperion Reports (Financial Reporting), SQL server and Windows.

Oracle developer/Essbase developer
Confidential, Framingham, MA Jun 2002 - Mar 2003

Confidential, is a leading retailer for office supplies, business services, furniture and technology in North America and Europe. Essbase was implemented to keep track of all the sales information taking place in various places.

Roles & Responsibilities:

• Developed an Essbase cube for sales department for forecast, reporting and consolidations.
• Developed the Load Rules to automatically validate the data and feed into Essbase new structure. Also created batch files to run calc scripts, data load and data calculations.

Environment: Hyperion Essbase 5.1/6.0, Hyperion Analyzer (Web Analysis), Excel Add-in, Hyperion Reports (Financial Reporting), Oracle 7i, PL/SQL and Windows.

Database Developer
Confidential, Chennai, India Jun 2001- May 2002

Confidential, is a technology and solution provider company based on Chennai, India.

Responsibilities:

• Developed several forms, such as, master table maintenance screens, Purchase Requisitions, Purchase Order generation, Sales Invoice Preparation, etc.
• Wrote Stored Procedures and Database Triggers using PL/SQL.

Environment: C, C++, Java, Oracle PL/SQL, SQL*PLUS, Windows NT.