SUMMARY

• Over 8 years of overall IT experience involving Design, Development, Analysis, Testing and Implementation of Data Warehousing and Business Intelligence Applications.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema.
• Experience in IT portfolio management, PMO administration and support, Quality Assurance/Quality Control QA/QC support and information technology management activities with federal government.
• Hands-on experience in RDBMS including SQL programs.
• Detailed knowledge in Data warehouse Application Console DAC and Informatica Servers.
• Experience in Informatica Data Integration Tools Repository Manager, Designer, Workflow/Server Manager, and Workflow Monitor.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool.
• Experience in building BI Publisher Reports and using various templates to publish the reports as per user requirements.
• Experience in Creating Navigation based on other reports, column selector, dashboard prompts, and drill down reports.
• Experience in creating dimension hierarchies and level-based measures.
• Experience in Cache management using Purge Scripts and Performance tuning using Aggregate Tables, Level Based Measures and Fragmentation.
• Implemented security by creating roles web groups, checks with External tables and LDAP, and Object Level Security.
• Expertise in converting and using Oracle pre-build Rpd's Financial, HR, Sales, Order Management etc. according to business requirements.
• Expertise in designing and developing the OBIEE/Siebel Analytics Metadata Repository consisting of three layers viz. Physical Layer Business Model Mapping Layer and Presentation Layer using Administration tool.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports , ibots/agents alerts .
• Experience with two complete Lifecycles gathering Business Users Requirements, Analysis, Design Modeling, Development, and Testing of Business Intelligence using OBIEE.
• Expertise in Inventory management using Rational Portfolio Management RPM tool.
• Working experience in performing portfolio governance and QA/QC activities as per IS 9000 Quality Management system.
• Experience in Tracking tool ClearQuest, SharePoint.
• Outstanding communication skills, ability to work in a team or independently, and highly motivated.

TECHNICAL SKILLS:

Reporting Tools OBIEE 10.1.3.x, 11.1.1.x, OBIA 7.9.x, BI-Publisher, Siebel Analytics 7.x

ETL Tools Informatica Power Center 8.x/7.x, DAC

Database Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Essbase, MS-Access

Programming Languages C, SQL, PL/SQL

Office Applications Microsoft Office 2007/2003/2000/97 Word, Excel, PowerPoint , MS Visio

ERP Oracle EBS 11.5.10, PeopleSoft 9.0/9.1,

Web Technologies HTML, XML

Operating Systems UNIX, Windows XP/2003/2000/NT/98/vista

Utilities SQL Developer, SQL Navigator, TOAD, SQL PLUS, SQL

Bug Reporting Tool ClearQuest

Other Tool Rational Portfolio Management Tool

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Developer

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with Business and Identified Facts, Dimensions, and grain of the Dimensional modeling. Also prepared the requirement specifications document based upon the background study and research.
• Worked on Agile methodology by sprint based releases for every two weeks.
• Worked on Phase 1 and Phase 2 of the Next Gen Project with HR, Acquisitions and Finance Data.
• Worked with OBIEE Analysis, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting, and complex union reports to satisfy the end users.
• Developed Oracle BI Metadata Model Repository based on different requirements, with the necessary logic that involved building the Physical, Business Model Mapping and the Presentation layer.
• Developed various Measures/Metrics and defined dimensional hierarchies.
• Extensive usage of repository variables, server variables, and presentation variables, following best practices and standards.
• Developed report with multiple Compound Layout to distinguish between the Financial Summary and Details view including titles and parameter values.
• Knowledge in Setting up Multiuser Development Environment MUDE and Cache Management Event Pooling Table Using Oracle BI Administration Tool.
• Worked efficiently in creating the session variables and also assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Created Operational Dashboard with Performance Tile with multiple different data sources.
• Good understanding in Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server and BI SQL Group Provider as Providers.
• Worked with Oracle Enterprise Manager to monitor, manage and configure Oracle BI system components.
• Worked in migration to various environments DEV, UAT migrations and Web Catalogs using catalog manager and presentation services.
• Involved in OBIEE 11g performance testing on multiple browsers.
• Responsible for Unit and System Testing and performed Data Validation using Quality center tool.
• Build the BI Reports based on the BI Best Practices and Perform Unit Testing
• Worked in Creation of the High Level Design Document HLD and Technical detailed design document TDD of Repository and Web Catalog file reports/dashboards .
• Created technical design specs and converted functional to technical specs and production support document.

Environment: OBIEE 11.1.1.7.x/11.1.1.6.x, BI Publisher 11.1.1.x, Weblogic 10.3.6/10.3.5, Hyperion FR 9.3.1, Oracle 11/10g, Oracle SQL Developer, Windows 2008 R2/7, Essbase 11.1.1.4, Essbase Plug in, Cognos Framework Manager 8.4.1, Cognos Connection 8.4.1.

Confidential

OBIEE Developer and System Analyst

Responsibilities:

• Performed requirement validation of the reports and drill downs with business users.
• Developed reports for BI Apps Financials for General ledger, Budget execution, Funds control Module FCM .
• Developed reports for the Annual budget Planned vs. Actual Burn-down reports.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Generating Reports and Dashboards using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Supported existing dashboards, reports and subject areas in OBIEE.
• Developed Burden Rate Analysis report using the GL balances from Payroll accounts and labor costs to derive effective accrual rate to match the Trail Balance data for comparison between years.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Involved in creating the Star Schema, Logical and Physical Modeling Complex Joins, Alias Tables and Views. .
• Developed Calculated Measures and assigned the Aggregation levels based on Dimension Hierarchies.
• Also worked as part of Portfolio management support team, Developed Benefit - Cost Analysis Reports
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.
• Supported the Technical Services Group management in taking decisions by providing the Project status and Performance reports.
• Maintained and updated the Inventory using Rational Portfolio Management RPM within the Technical Services Group. Used ClearQuest as a tracking tool to update the Inventory.
• Used Involved in operational analysis of applications using various industry standard mechanisms to help the Technical Services Group determine whether to modernize or to re-engineer or replace and retire an application.
• Was involved in QA audit activities as part of iCMM gap analysis and prepared QA Audit reports for TSG management review.

Environment: Oracle Federal Financial DELPHI , Windows NT, Oracle 10g/11g, OBIEE 10.1.3.4/11.1.1.3, BI Apps 7.9.6.x, SQL, PRISM, Rational Portfolio Management RPM , ClearQuest, MS SharePoint and Java.

Confidential

OBIEE Developer

Responsibilities:

• Provide support for gathering requirements by attending meetings and finalize the requirements.
• Analyze the requirements and provide an estimate on time and effort needed for development.
• Maintain, update and keep track of requirements document.
• Develop reports using OBIEE/BI Publisher as appropriate depending on the requirement and by following the best practices recommended for the tool used to develop reports.
• Supported existing dashboards, reports and subject areas in OBIEE.
• Thorough analysis of enhancement requests and provide with Gap analysis.
• Used Time Series Functions and To Date Functions. Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Created and modify dashboards using OBIEE Answers, BI Publisher as appropriate for the requirement.
• Configured Interactive Dashboard with drill-down capabilities, Pivot Table, Chart, Tabular with local and global filters using OBlEE Analytic Web.
• Maintain BI RPD configuration and Consistency check using best practices recommended by Oracle.
• Maintain accuracy of data on the reports with thorough Testing process.
• Responsible for Development, Support and Maintenance of Business Models at Repository Level and Reports, Dashboards at BI Answers Level.
• Worked in conjunction with System Administrator for migration, deployment and performance tuning of reports and repositories.
• Used ETL to load data from multiple sources to Staging area Oracle using Informatica Power Center 8.6
• Created mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence and Update strategy.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test.

Environment: OBIEE 10.1.3.4, Oracle BI Applications 7.9.6.2, Informatica 8.6, DAC, Oracle DB 10g, SQL Developer, Windows-XP.

Confidential

Oracle data warehouse developer

Responsibilities:

• Involved in the design, development, testing phases of the project and enhancements.
• As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms.
• Customization of ETL mappings for leveraging reports and new reporting requirements.
• Created packages for initial load and daily updates.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Day to Day Production support.
• Root Cause Analysis and Fixing issues.
• Involved in fixing the bugs reported back after initial stages of implementation.

Environment: Oracle 8i, MS Access, Informatica 7.1.1, SQL, PL/SQL, XML, Windows XP.