professional Summary:

• Over 8 years of experience in Software Development, and over 6.5 years with OBIEE 11/10, 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, DAC 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
• Experience in developing Informatica Transformations and Mappings
• 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.

Education:

Bachelor of Technology

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, Campus,

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,CT Aug-2012 – Present
Sr Business Intelligence Developer

Gartner is an information 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:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Imported dimensions, measures and other metadata from oracle OLAP directly into the repository and used as a data source for OBIEE reports and dashboards creation
• Worked extensively on Physical Layer, Business Layer and Presentation Layer (.RPD) to get new column as per BU.
• Involved in Merging Repositories using administration tool and Web Catalogs using Catalog Manager (migration)
• Developed OBIEE repository for OLAP datasource 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 OLAP 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 ofWebCatalog 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

Confidential,Orlando,FL Dec-2011 -July 2012
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 ,Tmobile 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
• Worked on Oracle Warehouse Builder 11G R2 (OWB) and Oracle Data Integrator (ODI) implementation and training for staff to enable building the OBIEE Logical Layer
• 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.
• Transition knowledge and train developers.
• Environment:OBIEE 11G(11.1.1.5,11.1.1.6), ODIEE,Micro strategy, Windows XP / 2003 server,ODI,

Confidential,USA April 2011-Dec 2011
OBIEE Devoloper
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 webservices 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.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Experience with ODI integration between OBIEE and/or Hyperion Planning is a plus
• Experience with customizing knowledge modules
• Experience developing complex transformations
• Experience with Oracle SOA Suite
• Prepared and uploaded new / modified / preconfigured report layout templates to BI Publisher server and multiple Siebel server environments.
• Involved in Administering automatic purging of reports in Siebel file system and purging of schedule reports from BI Publisher server.
• 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.
• Worked on Oracle Warehouse Builder 11G R2 (OWB) and Oracle Data Integrator (ODI) implementation and training for staff to enable building the OBIEE Logical Layer
• 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

Confidential,USA Mar 2010 - March 2011
OBIEE Senior Developer
Fifth Third Bank is 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.
• Upgraded from OBIEE 10g to OBIEE 11g including the upgrade of 7.8.4 applications to 7.9.6 applications
• Support Informatica Power Center mappings design and development
• Extensive development within BI Answers and Interactive Dashboards
• Configured BI Publisher and Integrated with OBIEE server
• 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.
• Involved in installation and configuration of OBIEE 11.1.1.3 , BI Publisher Enterprise, Repository Configuration Utility (RCU), Enterprise Manager 11g, Web logic Server 11g for future upgradation.
• 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,MA Jan 10 – Mar 10
OBIEE Developer
Bank of America Bank 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 Bank of America Bank.
Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Installed and configured Oracle BI EE 10.1.3.4/ Oracle Financial Analytics 7.9.5 on Windows.
• Installed and configured BI Publisher and Integrated with OBIEE server.
• 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 extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drill downs. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Implemented Prompts to provide dynamic filter condition to End users.
• Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.
• Providing object level security for different web groups based on responsibilities.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.6.
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings & Mapplets using various Transformations.
• Redesign Informatica ETL & DAC mappings based on new requirements.
• Configured DAC to run nightly data loads on daily basis.
• Configured new customized mappings & work flows in DAC for new customized subject area.
• Migrated the mappings and workflows from the development server to the Test Server to perform the integration and system testing.
• 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.

Environnent: OBIEE 10.1.3.4, BI Publisher, Oracle 10g, Informatica 8.6, DAC, Toad, Windows XP, PL/SQL, Erwin.

Confidential,IL Apr 08 – Nov 09
OBIEE Developer

Old National Bank 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