PROFESSIONAL SUMMARY:

• 10 years of experience in Software Development and Expertise in OBIEE and Siebel Analytics.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, Delivers and iBots,Toad,SQL Developer,SAP BO,BICS, Tableau,Articulate,Captivate,Blackboard.
• Experience in providing end - to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
• Created various data integration project components Interfaces, Packages, Procedures using Oracle Data Integrator’s Designer.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Experience in Installing, Upgrading and Configuring OBIEE, OBIA from 10.1.3.4.1 to 11.1.1.3.0 and from 11.1.1.3.0 to 11.1.1.5.0 and 11.1.1.7.x to 12.2.1.3.0 .
• Experience in working with OBIEE 11g Web Logic Server, Enterprise manager Fusion Middleware, .RPD and Webcatalog.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, building Analytics Repository and Metadata Modeling consisting of three layers (Physical Layer, Business Model (Semantic Layer) & Presentation Layer, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views .
• Knowledge in Data warehousing development using ETL tools such as Informatica Power Center 7.x/ 6.x and developed Informatica Mappings and Workflows with Worklets& Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experience working with various Heterogeneous Source Systems like Oracle, Teradata, and Flat files.
• Migrated Repository and Web Catalog from one environment to another environment.
• Hands on experience on SAP BO, BICS, Tableau

TECHNICAL TOOLS:

ETL Tools: Informatica Power Center, Power Mart 6.2/5.1

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, Tables, Physical and Logical.

Tools: Toad, SQL Developer

Languages: SQL, PL/SQL, HTML, C, C++

Operating Systems: UNIX (AIX 5.1), Windows NT, Windows 95/98/00/xp, Linux.

Business Intelligence: Siebel 8.1,OBIEE (Oracle Business intelligence Enterprise Edition), Administration, Answers, Interactive Dashboards, Oracle BI Publisher, BI Delivers, Web Catalog Administration, Analytics Server Administration

Reporting Tools: Biapps 11.1.1.7.1 /8.1 , OBIEE 12c, 11g, 10g, Siebel Analytics 7.8.x/7.7.x/7.5.x, BI Publisher 10.1.3.4/11.1.1.5./11.1.1.6.2 Business Objects 6.5, Siebel Analytics 7.8.4, Oracle Report Builder 10g, SAP BO, BICS, Tableau 9

WORK EXPERIENCE:-

Confidential

Sr. OBIEE Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Set up the Topology including physical architecture, logical architecture and context.
• Did reverse engineering for the data sources and targets.
• Did SQL and PL/SQL programming for oracle.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Provide support in OBIEE architecture of the organization through database design, modeling and implementation
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.

Environment: Web Logic Server, Oracle 12.2.1.3.0 , 11.2.0.2, SQL, PL/SQL, TOAD, SQL* Plus, Unix, Windows XP, OBIEE 11/12

Confidential, Hartford, CT

Sr.Report Developer/Lead

Responsibilities:

• Interacted with Business Analyst, data Modelers in understanding the Analytics report requirements
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Expert in infographics and Dashboarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Provided 24/7 production support for Tableau users and tableau desktop
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Worked extensively on Customizing Physical Data Layer, Business model and mapping layer and Presentation Layer in Administration Tool.
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, and Table) like Drill Down, Pivot Reports using Column Filters and Prompts to filter the request in Answers.
• Configured the scheduler which runs the Ibots and delivers the content

Environment: Tableau Server v8/v9, Tableau Desktop v6/v7, Oracle Business Intelligence 11.1.1.7, SQL Developer, Quality Center, Windows XP Professional

Confidential, Los Angeles, CA

Sr. OBIEE Developer

Responsibilities:

• Performed in-depth analysis and documentation of business logic and requirements.
• Developed high level design documents for reporting and analysis projects.
• Developed and deployed the RPD from MUDE to DEV, QA and production environments
• Worked with database administrators to optimize report performance through database tuning.
• Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
• Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Provide HIPAA regulation expertise to make sure environment is compliant with FDA regulations
• Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
• Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G
• Worked on scheduling BIPublisher reports basing on user requirement.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.

Environment: Oracle Business Intelligence(OBIEE) 11.1.1.7/12.2.1.0.0 , BI Publisher 11.1.1.7.1 , Template Builder, OBIEEE 10G, Oracle BI Server, BI Publisher Enterprise,SQL Developer, TOAD, Oracle 12c

Confidential, Pittsburgh, PA

Sr. OBIEE Admin & Lead

Responsibilities:

• Install, upgrade, patched and configure all components of OBIEE on Development, Test and Production server.
• Implemented security based on LDAP Authentication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Migrated RPD, catalog and configured Active Directory Security on servers.
• Design and implement data in various layers including physical, business and presentation .
• Assist the teams in generating dashboards and reports properly Perform validation of data on the reports and monitor the performance status of the same .
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Developed Data model and loaded data for and Healthcare Analytics in BICS.
• Created Reports and Dashboards for and Healthcare Analytics in BICS.
• Created user level security for intelligence dashboards based on Business Requirement.
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Created users, groups, access privileges and query privileges using Security settings in OBIEE AdminTool Integrated BI Publisher with OBIEE.
• Inpleted obiee 12c for connecting cloud data dase.

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, BICS, OBIA(7.9.6.x), Manufacturing Analytics, Oracle BI Server, BI Publisher Enterprise, BI Publisher,TOAD, Oracle11, Oracle BI Presentation Server, OBIEE Administration Console, OBIEE Enterprise Manager.

Confidential, Charlotte, NC

OBIEE Developer

Responsibilities:

• Interacted with Business Analyst, data Modelers in understanding the Analytics report requirements
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table) like Drill Down, Pivot Reports using Column Filters and Prompts to filter the request in Answers
• Developed Various custom reports/Ad-hoc Reports for querying and Filters and prompts.
• Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions.
• Developed interfaces to load data between interface tables using PL/SQL.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Developed technical specifications and test cases and resolved issues during testing

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, Oracle BI Server, BI Publisher Enterprise, SQL Developer, Quality Center, Windows XP Professional

Confidential, Clearwater, FL

Business Analyst

Responsibilities:

• Identified Facts, Dimensions, and Hierarchies of the business model.
• Involved in Analysis, Requirement gathering, function/technical specification, development and testing.
• 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.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• 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.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: Windows XP, OBIEE 11, Oracle Financial Analytics 7.9.5, Oracle 11g, SQL, TOAD, PL/SQL.

Confidential, Houston,TX

Instructional Designer(Intern)

Responsibilities:

• Created eLearning courses using Articulate Storyline.
• Created job immersive scenario-based using storyboards and facilitator guides
• Analyzed Course Development documents such as course circulam, use cases, and troubleshooting flows in order to define learning objectives.
• Collaborated with SMEs to obtain and refine content to ensure a good customer experience.
• Designed deliverables for ILT and e-learning delivery methods including facilitator guide,
• Strategized conceptual design with e-learning developers to create online modules.
• Contributed to development of templates and assisted with team process improvement and workflows

Environment: Articulate,Captivate,BlackBoard

Confidential

Siebel Analytics Developer

Responsibilities:

• Identified Facts, Dimensions, and Hierarchies of the business model.
• Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.
• Created transformations like Expression builder, joiner, and router.
• Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
• Tuned the performance of the reports by creating various types of indexes wherever appropriate.
• Used existing data from Hyperion Essbase for analysis.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies.
• Created variety of interactive dashboards containing charts, graphs and pivot tables using BI Answers.
• Utilized features like narrative views, dashboard prompts to create interactive dashboards.
• Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.