PROFESSIONAL SUMMARY

• 9 Years of solid experience in End-to-End Business Intelligence project delivery using Oracle BI Applications and several enterprise grade reporting tools OBIEE, Hyperion , Informatica, data warehousing and building software applications.
• Expertise in OBIEE Admin Tool, Analytics Web, Presentation Services, Security setup.
• In depth knowledge of RPD development 11G and 10g , Web catalog customization, Web logic based security structure, BI Apps components, BI Upgrade, Data Modeling Star Schema and overall playing the senior hands on developer role.
• Experience in development and implementation ofOBIA 7.9.x, OBIEE 11g and 10g experience in technical development using Oracle r12 Financials modules AP, GL, AR, PO etc .
• Experience as Oracle BIEE Developer and design and Implementation of Data Warehouse/Data Mart, experience in gathering Business Requirements, performing Analysis, Design / Data Modeling, Development, Testing using agile development techniques, development of metadata repository using OBIEE Administration tool, Intelligent Dashboards, Answers, Delivers, iBots and Oracle BI Publisher.
• Proficient in ETL Extract Transform Load using Informatica Powercenter 9.x and 8x in Data Warehousing and OBIA 7.9.6.X / 7.9.5 Financials, Procurement, data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification
• Developed critical Sales / Marketing / HR Insurance, Supply Chain, Academics dashboards using multiple data elements to measure KPI s for each Quarter.
• Developed Reports/Dashboards with different Analytics views Pivot table, Charts, Views and Column selector with global and local filters using Oracle BI Presentation Services.
• Designed and developed many Performance Measurement Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts.
• Expertise in implementing dashboard/Reports using Repository Variables, Initialization Blocks, and Session Variables
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Experience in Performance tuning of Informatica mappings and Data Warehouse loads and resolve any data inconsistencies across loads.
• Extensive experience with various databases Oracle 11g/10g, Extensive experience in gathering requirements, gap analysis, design, development, Testing and Implementation of the OBIEE/ETL/Data Warehouse project.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmap indexes and partitions.
• Solid experience conducting data analysis using SQL and Excel Reporting.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies.

TECHNICAL SKILLS

• Business Intelligence Tools: OBIEE 11g and 10g, OBIA 7.9.6.X / 7.9.5
• ETL: Informatica, DAC
• RDBMS: Oracle 11g, 10g, MS SQL Server 2008R2/2008/2005/2003
• Languages: C, .Net C .Net, ASP.Net, VB.Net , Web Services, WCF, WPF, JSP, Visual Basic, XML, JavaScript, HTML, PL/SQL, SQL, VBScript, AJAX.
• ERP Applications: Oracle EBS r12 Financials, TOAD, SQL Plus, SQL Developer

PROJECTS

Confidential

Title: Senior OBIEE Consultant

Responsibilities:

• Worked with end users to translate their business information requirements into technical data definitions.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed migration and merging of RPD's in OBIEE.
• Created MUD Multiple user Development environment by utilizing projects in OBIEE 11g.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Worked using Catalog manager to migrate web catalog between different instances.
• Created Pivot Tables and manipulated Initialization Blocks for report analysis.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Developed Dashboard pages like Budget Vs Actual, Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
• Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE 11g.
• Customized Material adjustment report, Slow moving inventory report in Inventory using XML/BI Publisher.
• Developed Back Order Detail Report and Sales Tracking Report in Order Management using XML/BI Publisher.
• Resolved open issues with the production system.
• Prepared technical document MD50, MD70 for the customizations done.

Environment: Oracle Applications 11i GL, AP, AR, OM, PO, PA , Database 10g,DAC 10.1.3.x, OBIEE 11g, OBIA 7.9.6, Discoverer 10g, Informatica 7.x, SQL Loader, PL/SQL.

Confidential

Title: Senior OBIEE Developer.

This project is to drive an effort of upgrade the BI application 7.9.6.1 to 7.9.6.3 of Project Analytics, HR, OM and procurement application. The work involved replacing the OBIEE 10 G with 11G, upgrade to Informatica 9.0.1 from 8.6.1, doing the 11G related works like using RCU to create the RPD, handling enterprise management and web logic admin console, upgrade the dwh schema from 7.9.6.1 to 7.9.6.2 and then to 7.9.6.3 and also the RPD conflict management activities and incporating the old Informatica customizations to the new structure. Client was inclined to use the flavor of OBIEE 11G,hence went for this up gradation.Apart from playing the role of senior BI architect, It also required to manage an onsite offshore model and frequent client interactions to come up with a successful end result.

Responsibilities:

• Lead the effort of identifying all the necessary steps that need to be taken to upgrade a 7.9.6.1 application 7.9.6.3.This involves identifying all the components and chart down pre and post upgrade activities.
• Under the pre upgrade work he was leading the effort of uninstall infa 8.6 and reinstall the infa 9 version with hotfix 2, create new schemas and point them to infa integration services and repository, installation of web logic, doing the necessary BI Apps related work like moving the source LKP files to correct folders, upgrade the DWH schemas and 3 way merging the RD and web catalog.
• Involved with business and IT team to identify all the customization that has been made on PRD ETL level.
• As part of post upgrade job, he was leading the RPD conflict management activities by incorporate the old customizations, bringing the necessary changes in DAC by modifying the seed tasks or importing the new tasks and subject area in the custom container, fixing the UI layer issues also the security aspects.
• Managed an onsite offshore delivery model to come up with this successful up gradation.
• Helped the Internal team to realize different features of 11G and chalked out a plan how best they can use this new tool.
• Helped the IT team to build the test cases around this upgrade the code migration and change management process of OBIEE, ETL and database schemas in multiple environments DEV, UAT and PROD .
• Involved in End User Training and enterprise wide BI training activities.

Environment: BI Apps 7.9.6.1, BI Apps 7.9.6.3, Informatica 8.6.1, Informatica 9.0.1, DAC, UNIX, TOAD, SVN version controlling, Test Director, Oracle 11G

Confidential

Title: Oracle BI / Data Consultant.

Confidential is the largest health insurer in the Northwest/Intermountain Region, serving members as Regence BlueShield of Idaho Confidential. The scope of the project was to generate Medical, Pharmacy, Member, Dental, Group and Medicare Advantage data files for each data feed. Mainly worked on Standard plus and custom data feeds where the data is mainly used for the benefit analysis

Responsibilities:

• Involved in testing/validating and debugging the applications using SQL scripts and appropriate log files and provided end-user training to generate the reports.
• Configured Intelligence dashboards by adding embedded content such as links/images, HTML objects and folders and implemented OBIEE delivers/ibots proactive agents to alert the business/field users based on the delivery profile.
• Created column filters, global filters, column prompts and defined additional views compound, table, chart views, Pivot Table of the data returned by the request to visualize data in many different ways.
• Coordinated with the Infrastructure team for migrating repository between environments
• Defined static and dynamic repository variables, session variables, created star schema based dimension models, time series measures using AGO and To Date functions for forecasting.
• Created and modified logical tables, logical columns, dimensions, dimension hierarchies, levels, level based and shared measures, newly calculated measure using existing logical columns.
• Imported physical tables and defined primary key, foreign key joins, complex joins in the physical layer of the repository, created connection pools to retrieve data from the Analytics database.
• Provided production support for the existing data models and during the initial loads for the newly implemented subject areas and given support for the daily issues.
• Involved in after hours and weekend support to execute, monitor all automated jobs, scheduled system back up jobs and provided notifications to the relevant team based on the impact of the results.
• Created users, groups and setting permissions for the repository objects including connection pools and presentation catalogs and setting the query limits and filter conditions.
• Created repositories, configured services, created users and set permissions for different repository objects using repository manager.
• Created source and target definitions, mappings using different transformations such as source qualifier, expression, lookup, aggregator, router, rank, filter, sequence generator, update strategy in the designer client applications based on the business requirements
• Used Informatica to translate the business requirements into mappings to move data from facets application database to analytics data warehouse.
• Calculated projected cash flow values and stored date wise based on the product profile.
• Identified the key dimensions like amount, products and groups using dimension mapping in Informatica mapping wizards.
• Created and configured workflows, worklets and sessions to transport the data to target warehouse tables using Informatica workflow manager and monitored the sessions using the workflow monitor.
• Created event wait and event raise tasks, command tasks and reusable tasks.

Environment: Informatica 8.6, IDQ Informatica Data Quality 8.6.2, Oracle OBIEE 10.1.3.x Analytics, DAC Data warehouse Administration Console , Oracle BI Applications 7.9.5/7.9.4, Oracle 10g, UNIX, Windows XP, TOAD

Confidential

Title: BI Consultant.

The reports were developed to provide market trends, projections, policy holders, opportunities and sales in the global market. The target users for these reports were the directors located in different employment centers throughout the US. Some reports also provided a seven year history of insurance losses associated with an individual and the data identified for each loss like the date of loss, loss type, and amount paid along with general information such as claim number were generated.

Responsibilities

• Interacted with business to gather requirements and translate the same into technical design, and develop Hyperion Interactive reports.
• Designed and developed and maintained reports.
• Responsible for the Scheduling Jobs that created reports for Weekly, Monthly and Yearly.
• Responsible for Maintaining the Access Control for Users, and Groups of the organization for data security.
• Developed reports that were used for strategic Decisions.
• Created Data models for Power Users to create their own Adhoc reporting for the management to make informed decisions using Hyperion Query Designer.
• Created Metadata and Meta Topics in Data models.
• The report was generated dynamically in word, PDF format.
• Developed reports using Hyperion Versions v8.3.
• Developed key performance integrators dashboard which would update daily to pull the latest time service data and create the charts dynamically for the data.
• The target users for these reports were the Insurance Agents and the directors located in different employment centers throughout the US.
• Developed Custom BRIO Query reports with complex user interface EIS to provide real-time reporting capabilities and extensively used JavaScript for creating EIS Executive Information System Reports.
• Designed and developed Dashboards, Pivots, and Reports, Charts, and Data models using Hyperion Query Designer.
• Created Output directories to store the output of the scheduled Interactive reporting jobs in Hyperion Intelligence Portal.
• Created new Discoverer Reports needed for Sales Order information bookings, prices, delivery date
• Create reusable common modules for restart, reject, and incremental aggregation.
• Performance tuning of long running queries through explain plan.
• Provided support for users issues.

Confidential

Title: Oracle Apps Technical Consultant

• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters , contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Developed new report Credit Memos in AR using Discoverer.
• Developed GL journal Importinterface program in General Ledger.
• Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger using FSGs.
• Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Created new responsibilities and involved in defining the required system profile options.
• Loaded data to the interface tables and populated data to Standard Tables through Standard Order Import Program.

Environment: Oracle Applications 11i 11.5.10 , General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Oracle 9i, Discoverer 10g, Windows 2000/NT, SQL Plus, TOAD, Reports 6i ,Kintana, UNIX.