professional Summary:

• Over 8 years of experience in Software Development, and over 6.5 years with OBIEE 11/10
• Over 1.5 years experience with BI/XML Publisher
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher, Delivers and iBots within OBIEE suite
• Experience in installation and configuration of OBIEE and administering permissions, privileges to users based on their groups and responsibilities
• Expertise in configuration and integration of BI publisher with BI Answers and BI Server. BI Publisher reports development, render the same via BI Dashboards
• Installation and configuration of OBIEE 11 ,Repository Configuration Utility RCU , Enterprise Manager 11g, Weblogic Server 11g.
• Expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center
• Experienced in tuning Informatica Mappings, Sessions and SQL queries for better performance
• Designed Star schemas, Snowflake schemas for Data Marts and Data Warehouses
• Experience in shell scripting pre-sessions and post-sessions commands
• Expertise in debugging and optimizing the Oracle BI / OBIEE Dashboards / Reports and Informatica Mappings / Workflows
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies
• Excellent problem solving, troubleshooting and decision-making skills.

Technical Summary

OLAP Tools: OBIEE 11/10, OBIA, BI / XML Publisher,

Siebel Analytics 7.8.2, Hyperion Essbase 9.3.1

RDBMS: Oracle 11g/10g/9i/8i

Applications: Oracle E-Business Suite Releases 11.x GL, AP, AR, PO / R12, Siebel CRM

Oracle Tools: Oracle Discoverer, Oracle Reports , Oracle Forms, SQL Loader, SQL Developer

ETL Tools: Informatica Power Center 8.2/7.1/5.1, Informatica PowerMart 5.0/4.7, DAC

Data Modeling: MS Visio, Erwin.

Languages: VB, PL/SQL, Java Script, VB Script, Toad

Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX Solaris

Projects Involved

Confidential

Sr. OBIEE Developer

Confidential provides the financial expertise to help people for life's other goals along the way with a full array of financial products and services like Retirement plans, Education savings, Mutual funds, Life Insurance.

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling Agents.
• Install, configure, and administer the OBIEE platform.
• Analyzed the specifications provided by the client, understanding the business.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Performance has been an issue with many of the custom built reports Dashboards which are solved in many ways like tuning the Query, content filters, Bitmap Indexes.
• Object Data Level Security has been enabled to all the HR Finance RPD tables also to the catalog reports.
• Created Session Repository Variables to achieve desired functionality.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps to configure and created repository .rpd and prepared a detail design document.
• Implemented Data/Row level security in repository using filters and object level security and assigned privileges according to the AD groups/application roles.
• Tested and migrated code over Dev, QA and Production of Repository, Dashboard Reports.
• Debugged modified some of the existing reports and dashboards, and fixed issues related to performance, data quality etc., during production support.
• Monitor logs by setting log level and debugged reports issues by understanding the SQL queries behind them used Oracle Sql Devoloper to run these SQL queries .
• Performed unit, integration, and regression testing to validate report and mapping functionality.

Environment: OBIA 7.9.6.4, DAC11g, Informatica 9.1,OBIEE 11.1.1.7, Red Hat Linux, Oracle SQL Developer, PeopleSoft 9.1 Finance HR Modules.

Confidential

Sr. Business Intelligence Devoloper/Administrator

Confidential site is one of the tools that the NYS Office of Mental Health uses to evaluate all of the programs licensed or funded by the NYS Office of Mental Health is the Patient Characteristic which is a one week survey conducted every two years. Results from the Patient Characteristics Survey are summarized into reports at the state, region, county and facility levels. The reports posted on this site allow users to sort data by geographic region of provider and other demographic variables. The PCS is the only OMH data source that describes all of the mental health programs in New York State. The information that is compiled is available on the OMH public website, and is used for planning and program evaluation by OMH and local governmental units the results are also used to describe the state public mental health system to state and federal funding agencies and legislative bodies.

Responsibilities:

• Developed many reports/dashboards Analytic views Pivot Tables, Charts, Column Selector, and View Selector .
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.
• Analyzed and used various data sources- Oracle and Excel and Web services.
• styles Sheets, Pivot Table, Charts, Column Selector, Tabular with global and local filters using Siebel Analytics Web.
• Developed many reports / Dashboards with different Analytic Views drill-Down / dynamic, Cascading
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Identified the Gap's by analyzing the data mart instance and provided alternative solutions as well as recommended changes to database.
• Involved in meetings business representatives for requirement analysis and to define business and functional specifications.
• Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and to define business and functional specifications
• Created the test schema and Test data according to Report Requirements and recommended Data model changes
• Developed the Incremental ETL Processes like Mappings Mapplets using various Transformations. And workflows with Sessions/Tasks. Executed the workflows with Shell Scripts.
• Created measures and level Based measures in Business Model
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Created Dimension hierarchy in Business model layer.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.
• Wrote complex sql queries to test the data warehouse.
• Involved in testing whether ETLs are accessing and picking up right data from right source and all the data transformations are correct according to the business rules and data warehouse is correctly populated with the transformed data.
• Tested the rejected records that don 't fulfill transformation rules.
• Involved in Integration testing
• Tested sequence of ETLs jobs in batch and Initial loading of records on data warehouse.
• Worked in Incremental loading of records at a later date to verify the newly inserted or updated data.
• Tested the rejected records that don 't fulfill transformation rules.
• Performed Unit, Integration and Regression testing to validate report and mapping functionality.
• Working Closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Designed and developed the OBIEE metadata repository .RPD using OBIEE Server Admin tool by importing required objects Dimensions, Facts, Aggregations with integrity constraints into physical layer using connection pool, developing multiple dimensions and logical and facts/ Measures objects in business model layer, and creating the presentation catalogs in presentation layer.
• Developed many reports/dashboards with different analytic views Pivot table, charts, Column selectors, view selectors
• Implemented basic security and external table authentication security mechanism
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment : OBIEE, Informatics Power Center 8.1.1, Oracle 10g, DAC, PL/SQL , T-SQL.

Confidential

Sr. Business Intelligence Lead/Administrator

Confidential is a large international industrial gases company. Praxair supplies atmospheric, process, and specialty gases as well as high-performance coatings and related services. I was involved in the HR Department and Manufacture Department Canada and US Projects. We created the reports for the General Ledger of the products, Sales, Marketing and Production Statistics of the Company. I been also involved in the Creating AD hoc Reports based on the requirements of the End User

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
• Managed team of IT, business and marketing personnel to transition and enhance custom developed software
• Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
• Created need/want analysis matrix for stakeholders to help them set project priorities and scope
• Managed teams of 4 6 consultants for a consulting company specializing in Internet application development
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Involved in star schema creation in the metadata layer and the corresponding reports built on top of this using OBIEE 11g.
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Involved in Merging Repositories using administration tool and Web Catalogs using Catalog Manager migration
• Highly experienced with repository development, configured metadata objects Subject Area, Table and Column and Web Catalog objects Dashboards, Pages, Folders, Reports .
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers Physical, Business and Presentation for the financial data mode
• Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports
• Layer, Business Layer and Presentation Layer .RPD to get new column as per BU.
• Developed OBIEE repository for LDAP data source by creating Physical, Business and Mapping and Presentation layers using OBIEE 11.1.1.5 Administration tool.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Involved in Configuration of Web Catalog Security and Cache Management
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector , Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments
• Environment: OBIEE 11G 11.1.1.5,11.1.1.6 , ODIEE,Micro strategy, Windows XP / 2003 server,ODI

Confidential

Confidential is a proprietary system of Wells Fargo Company, which presents information on Customer profitability at various levels Customer, Relationship, Officer, AU, Organizational Unit OU , etc. in total or by product. Information is displayed for single and multiple time periods as specified by the User. The Confidential System has two basic modes of usage: Inquiry and the Report Module. In addition, the Confidential System has a set of utilities accessible through a menu system such as File Upload, Customer Account Search, Relationship Structure, and Compensation Assignment.

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
• Created need/want analysis matrix for stakeholders to help them set project priorities and scope
• Managed teams of 4 6 consultants for a consulting company specializing in Internet application development
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Lead development of dynamic e-commerce and e-business solutions for numerous clients
• Involved in star schema creation in the metadata layer and the corresponding reports built on top of this using OBIEE 11g.
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Provide support in the implementation of OBIEE component
• Administer and create documentation on reports and system environment
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Assist and administer the deployment process of UNIX, OBIEE and repository codes
• Prepare monthly reports and present it to the management
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• Train the administration team on new OBIEE and ETL tools
• Worked extensively on Physical Layer, Business Layer and Presentation Layer .RPD to get new column as per BU.
• Developed OBIEE repository for LDAP data source by creating Physical, Business and Mapping and Presentation layers using OBIEE 11.1.1.5 Administration tool.
• Designed Star schema for fact dimensional tables for metadata imported from LDAP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards
• Involved in Configuration of Web Catalog Security and Cache Management
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher reporting.
• Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector , Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments
• Worked on Performance tuning on the Dashboards and Answers
• Created security settings to setup groups, query privileges and access privileges

Environment: OBIEE 11G 11.1.1.5,11.1.1.6 , ODIEE,Micro strategy, Windows XP / 2003 server,ODI

Sr. Business Intelligence Lead/Administrator

Confidential technology research and advisory company providing technology related insight. End user project allows end users to easily build their own reports and modify existing ones with little to no training. End User reporting generates reports that meet individual information requirements quickly and easily, allowing end users to dynamically modify and drill through report data for powerful information analysis. It was built with the end user in mind simplifying reporting and providing a completely user friendly experience. End user reports is self service, allowing reports to be easily built with the exact information that users require without tying up developer resources. Affording business users the ability to take control of some of their own reporting needs helps them to extract maximum value from both their data and their application

Responsibilities:

• Conducted research and analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
• Involved in translating functional requirements into technical requirements.
• Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and used various data sources DB, XML, Excel, and OLAP.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modelling.
• Customized and developed RPD Physical, BMM and Presentation Layer .
• Developed many Reports / Dashboards with different Analytics Views Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics web.
• Configured OBIEE iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles web groups, checks with External tables and LDAP, and Object Level Security.
• Performed Unit, Integration, and Regression testing to validate report.
• Used MS office plug-in for analyzing data.
• Implemented write back functionality.
• Designed Star schema for fact dimensional tables for metadata imported from LDAP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Involved in Configuration of Web Catalog Security and Cache Management
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher reporting.
• Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector , Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments
• Worked on Performance tuning on the Dashboards and Answers
• Created security settings to setup groups, query privileges and access privileges

Environment: OBIEE 11G 11.1.1.5,11.1.1.6 , ODIEE,Micro strategy, Windows XP / 2003 server,ODI

Sr. Business Intelligence Developer

By enabling searches across a wide variety of sources, Oracle's InQuira knowledge management products offer simple and convenient ways for users to access knowledge that was once hidden in the myriad systems, applications, and databases used to store enterprise content. To help users of their Websites find answers amid a growing mountain of online information, companies are turning to enterprise search ES or enterprise knowledge management EKM . ES is designed to index large amounts of information with the goal of making that content searchable.

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Worked Majorly for the Oracle client such as Apple, Symantec,Skype,Yahoo,Nokia ,T-Mobile Cisco,EBAY,Avaya, GE etc
• Upgraded Micro Strategy to OBIEE 11.1.1.6 and changes to new reports
• Involved in creating the Star Schema, Logical and Physical Modeling, identified Facts, Dimensions, and Hierarchies of the business model
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked Closely with ODI developers in creating new metrics for the Reports.
• Involved in creating Style sheets for the Report Catalog.
• Worked Extensively on RPD in creating the presentation variables and repository variables.
• Worked extensively in the RPD level security and Repository Level security.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.
• Experience in preparing Test Execution Report, Participated in unit-testing, and supported User Acceptance Testing
• Debug the sessions by utilizing the logs of the sessions.
• Perform unit testing at various levels of the ETL.
• Transition knowledge and train developers.

Environment: OBIEE 11G 11.1.1.5,11.1.1.6 , ODIEE,Micro strategy, Windows XP / 2003 server,ODI

OBIEE Developer

Provide hospital customers a cohesive acute care ordering solution tailored to their unique needs which include: Google-like search capabilities, category browsing, linked item recommendations, vendor portlets, order tracking, route delay/outage notifications, improved product availability information, enhanced back order management, improved inventory management and better integration with 3rd party hospital applications.Specifically for the mobile space the requirement is provide hospital customers a mobile access to key Order Express functionalities from a mobile device including rugged devices MC 55/MC75 , Smartphone's Android and iOS and Tablets Android and iOS users should have access to the following capability: Ordering,Shelf Labeling, Receiving ,Inventory

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
• Prepared, Integrated and Configured Siebel CRM 8.1 with BI publisher 10.1.3.4.1.
• Configured Outbound web services for BI Publisher server and created report responsibilities in Siebel Application.
• Configured Security and Authentication with Siebel security model and LDAP security model.
• Embedded BI Publisher scheduled reports view in Siebel and Configured BIPDataService WSDL for BI Publisher server.
• Manages the BIP servers perform Administration, Migration and Update responsibilities.
• Created custom reports , created new Integration objects and involved in the process of registering and scheduling of reports in BIP and Siebel servers.
• Involved in packaging and Migrating of reports from Source to Target environments using Application Deployment Manager.
• Configured BI Publisher and Integrated with OBIEE server
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Design and build ETL processes Star Schemas and ETL for relational reporting
• Participating in problem solving and troubleshooting for the applications implemented with Odi Documenting all new and modified mappings according to standards as part of the Data Operations documentation
• Debug the sessions by utilizing the logs of the sessions.
• Perform unit testing at various levels of the ETL.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications. Experience in preparing Test Execution Report.

Environment: OBIEE 11, Siebel CRM 8.1, BI Publisher, Windows XP / 2003 server,ODI

OBIEE Senior Developer

Confidentialis one of the best financial banks in USA and is well known for its superior services in multiple fields.UPS and the COD processor will be required to exchange data and information that will be integrated into various platforms. File deliveries will have schedules and SLAs defined with a potential process improvement item to implement acknowledgment file processing. Fifth third bank is working with UPS to deliver Transaction flow of the cheques and Payments and also tracking the shipper details in the Data Base and also manage the process of the flow from COD Processor, Vector sort and Direct Lock Box to the UPS Driver Notifications for the End of the day processing data for UPS

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing
• Installed and configured OBIEE 10g and Custom development of the RPD on Oracle 11g RDBMS.
• Extensive BI Publisher reports development using BI Answers and Subject Areas BI Server as Data Sources. Includes both Finance and operational reports. Configured and Integrated BI Publisher scheduler to schedule reports and view the saved data
• Integrated BI Server and BI Publisher, with LDAP security model, folder access management within BI Publisher for those LDAP roles and groups
• Worked extensively on various Cache Management techniques to increase the performance of both Real-Time and Non Real-Time reports
• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries
• Implemented Dashboard Prompts, and presentation variables for global reports and Dashboard usage.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent
• Participated in unit-testing, and supported User Acceptance Testing
• Transition knowledge and train developers.
• Developed few XML Publisher reports in PeopleSoft 9.0

Environment: OBIEE 10/ 11, OBIA 7.9.6.3, BI Publisher, Oracle 10/11g, Toad, Windows XP, PL/SQL, Erwin.

Confidential is one of the biggest financial organizations offering variety of financial products ranging from Credit Cards, Mortgages, Brokerage, Personal Banking and Loans. Project focus was on web-based application for brokerage and credit cards. Second phase of the project was to implement the process for verification of Check-acceptance according to the User accounts using the check processing software of Old National bank

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Upgraded Siebel Analytics 7.8 to OBIEE 10.1.3.2 and changes to new reports.
• Involved in creating the Star Schema, Logical and Physical Modeling
• Built the Analytics repository Physical Layer, Business Model and Mapping Layer and Presentation Layer
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance
• Created BI Publisher RTF templates in MS Word, publish the same in BI Publisher Enterprise Edition, as well as on BI Interactive Dashboards.
• Configured BI Publisher and Integrated with OBIEE server, and its security model
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics
• 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
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog
• Involved in Testing the reports and writing Test cases for Reports developed

Environment: Oracle 10g, OBIEE 10.1.3.2, BI Publisher, Informatica, DAC, SQL Developer, Windows NT

OBIEE Developer

Confidentialis one of the best hospitals in USA and is well known for its superior services in multiple fields. The project, Easy Chart was an EHR application which allows the user to handle tasks like storing and editing the paper documents in digital format, maintain patient charts Medicine history, FMHX, PMHX, Routine Medications, and Insurance etc. , integrate Lab results with patient's diagnosis reports and provide real time updating of central server database. The software also handles various healthcare plans, efficiently adopts the changes made in those plans and handles healthcare claims. It was a client-server application which encrypts the communication to avoid VPN. It has Care Tree which records encounters patient progress history , tests and other records.

Responsibilities:

• Participated in migrating Oracle Discoverer End-User-Layer EUL over to OBIEE platform
• Reviewed existing Oracle Discoverer environment on Oracle 10g Database, and architected migration of reporting over to OBIEE solution
• Utilized Oracle provided migration utility to migrate Discoverer EUL metadata over to OBIEE RPD
• Extensive re-work of hierarchies, BMM mappings, joins, and other areas broken with the migration utility first release
• Architect and lead development of OBIEE repository and security model to mimic the one in Discoverer
• Developed and supported creation of new Adhoc Answers requests and Dashboards in OBIEE
• Configured OBIEE Event Caching and Cache management features for improved end-user query experience
• Security configuration of OBIEE presentation catalog and data access
• Integration of BI Publisher with OBIEE and Oracle Discoverer environment
• Developed several BI Publisher reports with both BI Answers, and Oracle Discoverer as the data sources. Oracle Discoverer data source was a temporary solution, while being entirely migrated over to OBIEE
• QA testing and data validation support

Environnent: Oracle Applications Release 11.5.10 PA, PO, Financial , Oracle BI Publisher, Oracle RDBMS 10g, Oracle Application Express 3.1, Oracle Business Intelligence Enterprise Edition 10.1.3.3