SUMMARY:

• Nearly 14 years of Software industry experience in Software analysis, requirements gathering, reports, design, development, coding, business intelligence solutions, data warehousing, application development and database administration, integration, re - engineering, maintenance, testing, installation, implementation and enhancements of various Sophisticated Applications, Client / Server Applications, N-Tier Application & WEB Applications.
• Extensive experience in Oracle EPM 11.x, Hyperion Performance Suite 8.x/BRIO Intelligence/Enterprise suite of products (BRIO QUERY DESIGNER / EXPLORER), Data Warehousing (OLAP) tools like Brio Query Designer 5.5 / 6.0/ 6.6, Brio Query Enterprise server 6.6 and ETL Tool Informatica, Informatica Power center 5.1, Brio Query Designer, On-demand Server, Broadcast server and Portal Server.
• Excellent communication skills. Ability to interact with End users, Managers and Technical Personnel, self-motivated and team player.

TECHNICAL SKILLS:

REPORTING/OLAP Tools: OBIEE, Oracle BI Server, Oracle BI Answers, Oracle BI Dashboards, Oracle BI Publisher, Hyperion Essbase, Hyperion Planning, Web Analysis, EPM System 11.1.1.3/9. x,Workspace, Shared Services, Hyperion Performance Suite 8.3, Hyperion Foundation, Brio Portal, Brio On-Demand Server, Brio Broadcast Server, Brio EIS, Hyperion Dashboards, Brio/Hyperion Designer and Report Builder, Teradata, Seagate Crystal Reports, Business Objects, Cognos, Brio QIQ, ESDashboard, ESDesigner, SQR Reports, People soft query and Seagate Crystal Reports, Business Objects5.0

ETL Tools: Informatica (Power Mart 4.7, Power Center1.7)

RDBMS: Oracle 7.X/8.0/9/10g, SQL Server7, MS-Access2000

OPERATING SYSTEMS: Windows95/98/NT, UNIX

LANGUAGES: LanguagesPL/SQL 2.3,8 SQL Loader, SQL, C, C++, JAVA, COBOL, Pascal

GUI: Developer2000, VB 6.0

INTERNET TECHNOLOGIES: HTML, Java Script, and Servlets

ERP: People soft 7.5/8.0

PROFESSIONAL EXPERIENCE:

Confidential, Golden, CO

Responsibilities:

• Under the direction of the Hyperion Administrator at Social Security Administration, continue to perform administrative support, design and development activities related to the integration of Hyperion at SSA.
• Actively involved in the migration from Hyperion 8.3 to EPM 11.1.13
• As part of migration involved in the testing of the EPM 11.1.13 product, which includes the testing of the workspace and shared services functionality.
• Created the Data Access Service (DAS) connections in System Configurator (CMC) for the new repository and created required ODBC connections to support DAS connections.
• Due to changes in the group management between HPS 8.3 and EPM 11, provisioned all groups with View privileges.
• Involved in the View Manager cleanup.
• As part of the post migration process involved to update the Physical Resource, FTP directories to avoid any issues with the FTP jobs running concurrently in the BIG and BIG2 environments.
• De-provision the ‘World’ group and deleted un-needed groups.
• Configured the Usage Tracking and the Event Tracking in EPM 11.
• After all of the other post migration task have been completed, launched the Configuration Management Console (CMC) to enable the job service(s).
• Created and republished the repository Open catalog extension (oce) files.
• Developed administrative Hyperion Dashboards using Hyperion Explorer.
• Scheduled the various reports (Jobs) on Hyperion Foundation and send the output to FTP and Email.
• Created users and user groups in Foundation and assigned various types of Permissions to User Groups to access the reports.
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into the
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future .
• Performed production support for the project

Environment: Hyperion System 11.1.13/9.x, Hyperion Performance Suite/Brio 8.3.2, Hyperion Explorer 8.3.2, OBIEE, Oracle BI Server, Oracle BI Answers, Oracle BI Dashboards, Oracle BI Publisher, Java Script, UNIX, Oracle 9i/8i, Windows NT.

Confidential, Denver, CO

Senior Brio Developer

Responsibilities:

• Designed and Created Drill Down, PIVOT, CHART and Tabular reports and Generated Pre-Defined drill paths.
• Designed and developed EIS sections (GUI)/Dashboards and written Java-script code to implement them to make web enabled reports.
• Customized data by adding calculations, summaries and functions.
• Created dynamic EIS pages and load data from the result set.
• Generated Switch, Pie, Bar, Nested Charts, Line Displays.
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into the
• Using Java Script the Limit values are passed dynamically to the Query and Tables
• Designed and developed reports published and scheduled them in Insight Server (On- Demand Server, Broadcast Server) now called Hyperion Performance Suite or Foundation.
• Created Job Parameter, Cycles and Actions to distribute job output in various formats.
• Created users and user groups in Foundation and assigned various types of Permissions to User Groups to access the reports.
• Created and defined Custom Calendars, Scheduling Events and External Triggers.
• Translating functional requirements into Technical Specifications.
• Identifying & Resolving problems and Unit Testing and QA of reports.

Environment: Hyperion Performance Suite/Brio 8.3, Brio Designer 6.6, Brio Portal, Brio On Demand Server 6.6, Brio Broadcast Server, Brio Query Designer, Java Script, Unix, Oracle 9i / 8i, Windows NT

Confidential, Beaverton, OR

Senior Brio Developer

Responsibilities:

• Responsible for developing various Brio reports, EIS Dashboards using Brio Designer
• Developed Brio Reports Using Explorer, Designer
• Customized data by adding calculations, summaries and functions
• Designed and Developed Data Models using Brio Query Designer 6.6
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into the respective Objects
• Using Java Script the Limit values are passed dynamically to the Query and Tables

Confidential, Houston, TX

Senior Brio Developer

Responsibilities:

• Responsible for developing and publishing (integrating) various Brio reports to Brio ODS.
• Developed Brio (EIS Dashboards) using Brio Designer
• Schedule the various reports on Broadcast Server
• Responsible for end-users in reports building using Brio
• Developed Brio Reports Using Explorer, Designer
• Customized data by adding calculations, summaries and functions
• Created dynamic EIS pages and load data from the result set
• Designed and Developed Data Models using Brio Query Designer 6.6
• Generated Switch, Pie, Bar, Nested Charts, Line Displays.
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into the
• Using Java Script the Limit values are passed dynamically to the Query and Tables

Confidential, Los Angeles, CA

Senior Brio Developer

Responsibilities:

• Responsible for developing and publishing (integrating) various Brio reports to Brio Portal.
• Developed Brio (EIS Dashboards) using Brio Designer
• Developed Brio QIQ Dashboard using ESDesigner.
• Worked on QIQMerge for merging two separate Brio bqy files.
• Created users, groups and folders on On demand Server and Broadcast Server andassign appropriate privileges to users.
• Schedule the various reports on Broadcast Server
• Responsible for end-users in reports building using Brio
• Developed Brio Reports Using Explorer
• Customized data by adding calculations, summaries and functions
• Created dynamic EIS pages and load data from the result set
• Designed and Developed Data Models using Brio Query Designer 6.6
• Generated Switch, Pie, Bar, Nested Charts, Line Displays.
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into therespective Objects
• Using Java Script the Limit values are passed dynamically to the Query and Tables
• Passing data from EIS page to Another page by using Java Script
• Translating functional requirements into Technical Specifications.
• Identifying & Resolving problems and Unit Testing and QA of reports.

Environment: Hyperion Performance Suite/Brio 8.0, Brio Designer 6.6, Brio Portal, Brio On Demand Server 6.6, Brio Broadcast Server, Brio Query Designer, Java Script, Unix, Oracle 9i / 8i, Windows NT

Confidential, Norwalk, CT

Responsibilities:

• Designed and developed various Pivot, Tabular, Chart Reports to be used by various User Groups and
• Created Java Script based Brio 6.5 reports for Web enabling the reports.
• Developed Executive Dash Boards to accomplish launching various Reports.
• Created JavaScript based BRIO 6.5 reports. Extensively worked on designing complex reports
• Using Brio One.
• Scheduled these reports on Broadcast Server and deployed on On-Demand server, Portal that can be viewed and required over Intranet, Internet using Brio - Insight Plug - In.
• Developed the informatica scripts/transformations in order to copy data from production environment to the data warehouse environment
• Using Java Script the Limit values are passed dynamically to the Query and Tables.
• Passing data from EIS page to another page by using Java Script.
• Configured the On-Demand Server for the end-users to browse the reports on the Web.
• Configured the Broad Cast Server to publish report to ODS and send mail to Customer.
• Maintaining and Administrating ODS and BCS Server.
• Modifying existing reports like adding computed columns/Database Changes.
• Extensively worked in Brio Portal and ODS to Publish reports on Web.
• Involved ONE/Administrator to manage users, groups, categories, objects, jobs, and service agents in
• Involved in Customizing Brio Portal System to optimize Brio Portal performance, customize ONE/web client, run and schedule jobs.

Environment: Brio Enterprise Suite 6.5, Brio On-Demand Server, Brio Broadcast Server, SQR, Brio EIS, Brio Designer, Brio Query, ODBC, SQL, PL/SQL,Oracle8i, SQLServer2000, Informatica5.x, Erwin, JavaScript and WinNT.

Confidential, Phoenix, AZ

Responsibilities:

• Designed and developed various Pivot, Tabular, Chart and OLAP Query Reports to be used by various User Groups and Created Java Script based Brio 6.5 reports for Web enabling the reports.
• Exported Brio reports to MS Excel for easy access to user.
• Responsible for analyzing business requirements and developing queries an reports using adhoc query tool (Brio) and other web development tools to provide Web-enabled data analysis solutions to business clients.
• Designing and Implementing OLAP solutions using MS SQL Server 2000.
• Written several stored procedures and SQL queries to retrieve data from tables.
• Developed Executive Dash Boards to accomplish launching various Reports.
• Developed the informatica scripts/transformations in order to populate the BILLING database from flat file to DB2 database.
• Worked with MX Views API available with informatica to produce the status of load to the team in terms of Web portal
• Developing EIS applications, testing queries developed by others and supporting users.
• Extensively used BRIO suite of products for reporting. BRIO for OLAP applications in enterprise. Created various types of reports for Various User Levels.
• Created JavaScript based BRIO 6.5 reports. Extensively working on designing complex report using BRIO.
• Scheduled these reports on Broadcast Server and deployed on On-Demand server which can be viewed and re-queried over Intranet, Extranet and Internet using Brio - Insight Plug - In.

Environment: Brio Enterprise Suite 6.5, Brio On-Demand Server, Brio Broadcast Server, SQR, Microsoft SQL Server 2000 OLAP, Brio EIS, BrioDesigner, BrioQuery, ODBC, DB2, SQL, PL/SQL, Forms6.0, Oracle8i, SQLServer2000, Informatica5.x, Erwin, JavaScript and WinNT/Solaris 2.7.

Confidential, WA

Responsibilities:

• Designed and developed various Types of Reports (Pivot, Tabular, Chart and OLAP Query Reports) to be used by various User Groups.
• Developed Executive Dash Boards to accomplish launching various Reports.
• Responsible for analyzing business requirements and developing queries an reports using ad hoc query tool (Brio) and other web development tools to provide Web-enabled data analysis solutions to business clients.
• Developing EIS applications, testing queries developed by others and supporting users.
• Developed the informatica scripts/transformations in order to copy data from production environment to the data warehouse environment.
• Developed and used Stored Procedures to transfer processing load to the backend server. Extensively used BRIO suite of products for reporting. BRIO for OLAP applications in enterprise. Created various types of reports for Various User Levels.
• Created JavaScript based BRIO 6.5.x reports. Extensively working on designing complex report using BRIO, and Working on heavy data analysis related to HR Dept with Oracle database.

Environment: Oracle 8i, Brio 6.2.x, Brio Enterprise Suite, Brio On-Demand Server, Brio Broadcast Server, SQR, Brio EIS, Brio Designer, Brio Query, Business Objects, ODBC, SQL, PL/SQL, JavaScript and WinNT

Confidential, SanFransisco CA

Responsibilities:

• Extensively used BRIO suite of products for reporting.
• BRIO for OLAP applications in enterprise. Created instances of reporting database on Oracle from heterogeneous databases like MS SQL Server, Oracle and Informix.
• Extensively created Confidential registration reports, management reports, medical reports. Created.
• Created Accounts receivables reports, Accounts payables for supplier’s reports. Migrated version 5.5 Brio reports to 6.0.
• Created EIS JavaScript based BRIO reports for web enabling the reports.
• Involving in the activities like system testing, full User Acceptance Test.

Environment: ORACLE 7.x, Brio 5.5/6.0, Brio Designer/Explorer, Business Objects, SQR, SQL, and Win98/NT, Solaris.

Confidential, Golden, CO

Responsibilities:

• Developed SQRs to load initial master data into SAP TIME ENTRY SYSTEM.
• The initial data transfer program generates a flat file. This file was the initial load data for every employee. The file was transferred to SAP Unix box by FTP.
• Developed an SQC procedure to compute vacation hours.
• Developed an SQR to load sick hours and vacation hours once a year for all Coors hourly and salaried employees. This SQR also refreshes PS LEAVE ACCRUAL and PS AUDIT LEV ACC C tables.
• Developed a PL/SQL procedure to extract the daily changes that are made to the People soft database that is pertinent to SAP. It places changes in the form of Messages on the MQ Series queue through an Oracle procedural Gateway.
• Developed a PL/SQL procedure to eliminate NULL values in PS LEAVE ACCRUAL table.
• Created Coors custom fields and records to fulfill business needs.
• Created Audit tables to monitor changes, data manipulated through people soft panels.
• Used Import Manager to insert Social Security numbers into PS SSN CNV TBL C, a Coors custom table.
• Written a PL/SQL procedure to Scramble Social Security Numbers.
• Made PSCATS instance, a copy of the production database specifically for SAP TIME ENTRY SYSTEM.
• Setup PSCATS PROCESS SCHEDULER server.
• Scheduled PER099C.SQR to refresh PS EMPLOYEES table daily.
• Used ORACLE GATE WAY and MQS to input messages to BDC.
• Used DEC scheduler to trigger Daily interface programs.
• Involved in unit testing the employee master data.
• Involved in unit testing PEOPLE SOFT TO SAP Daily interface.
• Involved in system testing to test the impact on other SAP modules like SAP PS (Project Systems), SAP FI-AA(Asset Accounting) and SAP IM (Investment Management) which provides additional functionality to integrate Project Management and Asset Accounting.
• Inserted data for actions like HIR, REH, PAY, TER, LBR etc. through People soft panels to test the system.
• Interacted with the end-users to understand the process and implemented the changes accordingly.
• Designed Documentation for end user and power user

Environment: People soft 7.5(HR/Benefits/ Payroll), SQR, Crystal ReportsOracle 8i.

Confidential

Responsibilities:

• Involved in developing entire system requirements (life cycle) and database. Implemented hex - xml parser to store/fetch questions in XML format.
• Generate various types of reports and graphs showing results of an individual in all the tests, final results, top scores for selected subject/pattern.
• Implemented JavaMail API to send result of the test by e-mail after evaluation.

Environment: JDK1.1, Servlets, XML (HP’s Hex-parser), Java Mail, JavaScript, HTML, Java Web Server 2.0, MS Visual J++, Oracle 7.3

Confidential

Responsibilities:

• Involved in analysis, design and development of various customized forms and reports using Forms, Reports Involved in processing of all data for generating the decision making type of report using PL/SQL.
• Involved in the development of the database triggers and stored procedures for processing of report.
• Involved in the development of complex master detail forms.
• Used Crystal Reports for OLAP applications in enterprise. Involved in the design of corporate Data warehouse planning

Environment: Crystal Reports, ODBC, ORACLE7.x, and Windows NT

Confidential

Responsibilities:

• Involved in feasibility study and system study. Designed database and user interface individually. Reviewed the code at regular intervals for fine-tuning. Prepared materials to help the users for normal maintenance and operation of this package.

Environment: IBM Pentium, Unix, Oracle 7.0 and Forms.