PROFESSIONAL SUMMARY

• Above 10 years of IT experience with over 8+ years of experience in Business Intelligence, Dataware housing and Oracle Business Intelligence EE 10.x, Siebel Analytics 7.x., BI Publisher.
• Involved in Analysis, Design, Development, Testing, Implementation, and Business User's Requirements Gathering.
• Domain experience in Financial Services, Telecommunication, Pharmaceuticals, Healthcare Insurance, Consumer Goods, Retail,and Manufacturing industries.
• Extensive working knowledge in retail sales and sales management.
• Experience in various Solution areas, such as Customer Relationship Management (CRM), Supply Chain Management, Financial Services and Sales Revenue Management.
• Knowledge of all phases of Software Development Life Cycle (SDLC) - Planning, Analysis, Design, Development, Testing, Implementation & Maintenance.
• Strong understanding of Transactional and Dimensional Data Modeling, Data Warehousing Concepts, and Designing Star & Snowflake Schemas, for OLAP and OLTP Systems.
• Involved in full life cycle of Oracle BI project implementation, design and development.
• Experienced in business requirement gathering and design discussion of data warehouse & BI.
• Worked on different Oracle BI module like Oracle BI Answers, Dashboards, Delivers, BI Publisher, Security configuration, Repository design and development.
• Knowledge of ETL life cycle.
• Familiar with Oracle BI 11g and its new features and architecture.
• Knowledge and experience in Test case design, Unit Testing, and User Acceptance Testing (UAT), as well as White-boxand Black-box Testing.
• Excellent Verbal & Written Communication, Presentation, Analytical, & Problem Solving Skills.

TECHNICAL SKILLS

• Business Intelligence & ETL Tools: Oracle BI EE (11.1.3.x & 10.1.3.x), Siebel Analytics8.x/ 7.x., BI Publisher.
• ETL Tools: Informatica Power Center (7.1, 6.2, 5.1).
• Databases: Oracle 10g/ 9i/ 8i, My SQL, MS Access.
• DB Tools: TOAD 7.x, SQL Plus 10.x/ 9.x/ 8.x, ODBC.
• Operating Systems: Windows NT/2000/2003/XP/Vista, IBM AIX 4.x/ 5.x, HP UNIX, Linux.
• Languages: SQL, PL/SQL, JavaScript, HTML, XHTML, XML, CSS.

WORK EXPERIENCE
Confidential, CA August 2010 - till date
Sr. OBIEE Analyst/Developer
Enterprise Business Analytics (EBA) allows Symantec to keep track of how their Channel Partners are doing. It helps Symantec to disseminate key sales, marketing, service, support, and training, pricing and ordering information of its Channel Partners and helps to take business decisions accordingly.

Responsibilities:

Worked with OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
Interacted with business representatives for need Analysis and to define Business and Functional specifications. Participated in the Design team and user requirement gathering.

• Developed OBIEE repository to on top of Sales, Marketing data warehouse.
• Configured Dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Time Series.
• Involved in security configuration to provide Data level as well as Object level security.
• Created different repository and session variables for reporting requirements and security configuration.
• Modified presentation layer columns as per business requirements. .
• Developed User Interface (UI) components Folders, Dashboards, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts using Oracle BI Presentation Services.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
• Worked on Multi-user development environment (MUDE) and created different projects for each location.
• Configured on cache purging strategy using event-polling table.
• Implemented Usage Tracking and developed usage tracking related dashboard and reports.
• Configured OBIEE scheduler and worked on delivers and iBots to notify the corporate managers and region managers immediately about the different trends and alerts. Generated iBot alerts for reports to be delivered by email.
• Involved in Unit testing and documentation of reports generated by using OBIEE.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x, Oracle 10g, Siebel CRM 7.7, Windows Server 2003/ XP.

Confidential, Basking Ridge, NJ Jan '09 - July '10
Sr. OBIEE Analyst/Developer
Verizon Wireless is a leader and specializes in delivering broadband, wireline, and wireless communication innovations to mass market, business, government, and wholesale customers. This project involved collecting data from Contact Centers, and generating reports for the same. Worked on BI solutions project, Sales & CRM for Billing Analytics, Service Request Analytics and Revenue collections.
Responsibilities:

• Participated in business analytics requirements gathering and meetings with Sales, Marketing, andBusiness Analysts/ Users.
• Designed and Developed Customer Feedback Text Analytics Metadata repository (.rpd), with Customer and Product Hierarchies.
• Designed and Validated Business Model, using Logical Table Sources (LTS), Logical columns, Logical Expressions, and complex calculations in Business Model & Mapping (BMM) Layer.
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Performed Migration of Repository and Web Catalog objects from Development to QA to Production environments, using Catalog Manager.
• Configured and scheduled iBots using Oracle Delivers, to deliver customized Reports to key Business Users on daily and weekly basis, to their email, mobile, and hand-held devices.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Materialized Views (MV), Cache Management, re-organizing data, and making some changes to Reports.
• Developed and Implemented Usage Tracking Reports.
• Created Feedback Metrics Dashboards and Reports, using Time Series Functions, for comparing the usage variations between Quarters.
• Setting up with the Multiuser Development Environment (MUDE) using the BI Administration Tool and work in the multiuser environment.
• Built Test Cases and tested Reports/ Dashboards, by comparing theSQL Outputon theData warehouseto the values in theReports/ Dashboards, and documented the Test Results.
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x, Oracle 10g, Informatica PowerCenter 7.1, Siebel CRM 7.7, Windows Server 2003/ XP.

Confidential,Irvine, CA Apr '07 to Dec '08
OBIEE Developer

Responsibilities:

• Analyze, Design and Developed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Siebel Analytics Server Admin tool.
• Worked with Business People for gathering requirements, Identified Analytics Report requirements
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Configured and extensively used Siebel Delivers, Schedulars and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Developed aggregated fact tables using the content tab and fragmentation.
• Configured Repository and session variables to get dynamic reports and dashboards
• Added new Dimensions and Columns to the Subject Areas to full fill the additional
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, Execution Plan
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.
• Environment: OBIEE 10.1.3.3.2 , UNIX Shell scripts, Oracle 10g, UNIX, PL*SQL, TOAD

Confidential, RI Apr '04 to Mar '07
Sr Siebel Analytics Developer

CVS Caremark is the largest provider of prescriptions and related health care services in the nation. The Company fills or manages more than 1 billion prescriptions annually. Through its unmatched breadth of service offerings, CVS Caremark is transforming the delivery of health care services in the U.S. The Company is uniquely positioned to effectively manage costs and improve health care outcomes through its approximately 6,300 CVS/pharmacy stores; its pharmacy benefit management, mail order and specialty pharmacy division, Caremark Pharmacy Services; its retail-based health clinic subsidiary, Minute Clinic; and its online pharmacy, CVS.com. The project involved creating business intelligence solutions for the Sales, Finance, Marketing departments.
Responsibilities:

• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers (Physical, Business and Presentation) for Sales Analytics, Financial Analytics and Contact Center Analytics by creating new models to support the business.
• Built the Siebel Analytics repository/metadata and define/create the subject areas where reporting and analysis are centered around.
• Designed and developed complex reports, answers related to sales, customer, Revenue, customer Insights, marketing, commission, and products.
• Built the Star Schemas based on the functionality and technical requirements.
• Created dimension hierarchies to achieve the drill down functionality.
• Created, modified, and administered analytics intelligence interactive dashboards, answers with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Expert in using presentation variables to create a dynamically changing header reports.
• Used dashboard and criteria prompts (column and image prompts), column and view selectors, filter and narrative views.
• Constructed data visibility and security rules and implemented them within Siebel Analytics to provide record-level, team-based and group-based security into the Data warehouse.
• Implemented Cache management by using Event-polling tables in database to optimize the performance.
• Identified most economical source and configured the content as a part of performance tuning.
• Implemented Multi-User Development (MUD) in Production.
• Involved in migrating repositories across development, testing and production environments.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to generate Trend reports & sent notifications Alerts to Managers.
• Performed administrative tasks like creating users and assigning them privileges to groups
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing.
• Responsible for delivering world-class business and technology solutions that enable client to become high performance businesses.
• Configuration of in-scope functional and technical requirements based on design documents including data structures, data mapping, and related Performance Tuning.

Environment: Siebel Analytics 7.7, Solaris 5.2, Windows NT 4, Oracle 10 and SQL.
Confidential, Benton Harbor, MI Jul '03 to Mar '04
Sr Siebel Analyst

Whirlpool Corporation is the world's leading manufacturer and marketer of home appliance brands. I worked on "Revenue Creation" project to implement business intelligence solutions, with a goal of Marketing Programs Optimization (MPO), and Customer Service Enhancement (CSE).
Responsibilities:

• Interacted with Marketing Team, business analysts/ users in Requirements Gathering meetings, and performed GAP Analysis, to identify missing elements in Data Marts and Data Warehouse.
• Designed, Developed, Migrated and Tested Siebel Analytics Web Catalog (.webcat) objects from Development to Testing, and then to Production Environments.
• Designed and developed OBIEE/Siebel Analytics RPD using OBIEE/Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Variables, Initialization Blocks, & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed manyCase SolutionsTime Series Wizardobjectsfor comparing various Marketing Campaigns' related Current, Previous and Year Ago Quarter / Month Requests.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters).
• Configured and AutomatediBotsto deliverAnalyticsReports to Users, based on Schedules.
• Performed Data Sanity Check, by executing SQL queries, and comparing it with OBIEE reports.
• ImplementedData LevelandObject Level Security, by creating Session/ Dynamic Repository Variables, and Initialization Blocks.
• Expertise in Business Model development with Dimensions, Hierarchies, Level Based Measures, Aggregation Rules, Time Series and Caching.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns or customizations to Siebel systems.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
• Created Training Documentation, Provided necessary Cross Training, and supported key Business Users, in generating and creating Reports fortheir complex reporting needs.
• Conducted the Knowledge Transfer (KT) and cross training sessions for business users.

Environment: Siebel Analytics 7.7, Oracle 9i, Informatica PowerCenter 6.x, UNIX, Siebel Marketing Analytics, Siebel Contact Center, SQL Plus.
Confidential, Vallejo CA. Jul '01 to June '03
Analyst

Worked on HR project for retail store chain. This project covered HR, Applicant tracking, Third party applicant background checking. The technologies used were Lawson HR and oracle. This was a web based application.
Responsibilities:

• Primary responsibilities included testing HR modules.
• Wrote use cases for other members in the QA group.
• Tested system fordifferent browsers including IE/Firefox & Opera for compatibility reasons.

Responsible for tracking bugs as the progress in the development cycle.