SUMMARY:


  
Over 6+ years of       diversified experience in the field of Information Technology with an       emphasis on Data warehousing which includes extensive experience in OBIEE formerly SiebelAnalytics and Datawarehousing tools.

  
Experience in       installing and configuring OBIEE.

  
Extensive experience in       implementing OBIEE for Sales, HumanResources and Order       Management, CSW, Finance and Supply Chain analytics.

  
Experience in       interacting with Business users to analyze the business process and       gathering requirements.

  
Designed and developed       the OBIEE Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions, Facts & Aggregates)       into Physical Layer using connection pool, developing multiple       dimensions (Drill-down Hierarchies) & Logical & Facts Measure       objects in Business Model Layer, and creating Presentation       Catalog in Presentation Layer.

  
Experience in setting       up the usage tracking, Creating Variables/Initialization Blocks.

  
Implemented Data       level and Object level security.

  
Experience in       Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, OBIEE       Security Setup (groups, access privileges), Metadata objects and Web       Catalog objects (Dashboard, Pages, Folders, Reports).

  
Developed many Reports       / Dashboards with different Analytics Views (Drill-down /       Dynamics, Pivot table, Chart, Column Selector, View Selector, Narrative,       Ticker, static Text, Tabular with local and global filters) using OBIEE       Answers.

  
Configured and       scheduled Intelligence agents (ibots) to send the real-time Alerts       to the end users using Delivers and Created reports using BI Publisher

  
Expertise in OLTP/OLAP       System Study, Analysis and E-R modeling, developing Database Schemas like       Star schema and Snowflake schema Dimensional Data Modeling used in       relational, dimensional modeling, Erwin data modeling and Slowly       Changing Dimensions.

  
Good experience in ETL process using Informatica PowerCenter for various transactions and       loading data from various legacy data sources.

  
Expertise in debugging       and optimizing Siebel Analytics Dashboards / Reports.

  
Good experience in Oracle and hands on on UNIX Shell scripting and extensively used TOAD.

  
Good understanding of Software       Development Life Cycle (SDLC).

  
Hands on experience in BI       Apps, DAC.

  
Excellent communication       skills, Good organizational skills, outgoing personality, Self-motivated,       hardworking, ability to work independently or cooperatively in a team,       sincere, eager to learn, ability to grasp quickly.



Technical Skills:

BI Tools: Siebel Analytics 7.x, OBIEE  10.1.3.x (Oracle BI Administration,

   Oracle BI Presentation, Oracle BI  Dashboards, Oracle BI Delivers, 

   Oracle BI  Publisher, Catalog Manager), BO, Brio/Hyperion.

  Data Warehousing: Informatica Power Center/Power  Mart8.1.x/7.1.x/6.2.x.

  Data Modelling:  Erwin 3.x/4.x 

  Databases: Oracle 8i/9i/10g/11g, SQL Server  2005/2000, MS Access, DB2,

  Languages:  SQL, PL/SQL, C, C++, HTML, XML,  Java Script and VB.

  OperatingSystem:  Windows XP/ NT/95/98/2000, MS DOS, LINUX.

  SQLTools: SQL Developer, TOAD.

Work Experience:

Confidential,Texas

    OBIEE Consultant  Oct 2009  - Till Now

Confidential, is a leading provider of global IT, security, and communication  solutions, with one of the world's most connected IP networks. It combines  broad range of strategic solutions, services, and expertise to help some of the  world's largest organizations- including 96% of the Fortune 1000  -  and  governments  -  meet the challenges of their increasingly extended enterprises. 

Responsibilities:


  
Every  day attend Follow up calls about the OBIEE Buisness Processes with End Users  and Team Members. 

  
Created Repositories by building physical Layer, Business Model and Mapping Layer, and Presentation  Layer using Oracle Admin tool

  
To Create Connection  pools import physical tables and define joins in physical layer

  
Developed and Customized Some of the existing Dimensions (Drill Down Heirarchies) & Logical  Objects in Business Model and Mapping Layer and Presentation Catalogs in the Presentation Layer.

  
Created Aggregations and Logical Based Measures in  Business Model and Mapping Layer. Created Analytical Views (Compound  Layout,chart,pivot etc.,) and Global/Local  Prompts to design the Dashboards.

  
Created Security Settings in Oracle Administration Tool to setup Groups and Provide  Access Privileges and Query Priviliges and also managed security for Groups in  BI Answers.

  
Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the  full benefit of Analytics in providing summary and detail reports.

  
Used OBIEE  Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team  members.

  
Worked in creating Transformations and Mappings using Informatica Designer and processing  tasks using Workflow Manager to move  data from multiple sources into targets.

  
Used DAC (Data warehouse Application Console) for both incremental and full loads.

  
Monitored and Scheduled ETL along with reducing  application configuration and development time by using DAC.

  
Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table  execution path by making use of hints, Creation/Re-building of Indices and  Cache Management.

  
Involved in developing the Incremental ETL  process (Mappings & Mapplets) using various Transformation and Workflows  with Sessions/Tasks, executed  workflows through shell scripts using pmcmd.

  
Created & saved several BI Publisher reports by selecting an Answers request as Data  Source.

  
Built multiple execution plans in DAC for weekly and daily loads.

  
Created comprehensive and easy-to-understand Documentation of the complete implementation  of the Customer Sales Business modules (Reports, Dashboards, Security and Star  schema).

  
Build test  cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the  Reports/Dashboards, documented the test results.

  

  Environment: Oracle Business Intelligence Enterprise  Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.6, Data Warehouse  Administration Console (DAC), Oracle BI Publisher, Oracle Delivers,Windows XP,  UNIX/LINUX Oracle 11g/10g, SQL,ODI, PL/SQL, and TOAD 6.3/7.0.


Confidential,  Mar 2008 -  Sept 2009

    Role: OBIEE consultant

AT&T is the largest provider of local, long  distance telephone services in the United States, and also sells digital  subscriber line Internet access and digital television. 

Project: Implementing HR analytics as part of setting up  the warehouse environment for BI.

Responsibilities:


  
Worked closely with the business users to       identify various KPI's and designed solutions to enhance business       decision-making.


  
Participated in complete life cycle of the  project from project initiation, to development, to production support and  maintenance.

  
Worked on Oracle BI EE Administration tool for  customizing the Physical layer, Business layer, Presentation layer and  modifying it according to the business requirements.

  
To create Connection pools, import physical  tables and define joins in the Physical Layer.


  
Developed and customized some of the       existing Dimensions (Drill-Down Hierarchies)       & Logical objects in Business Model Layer, and creating the       Presentation catalogs in Presentation Layer.

  
Created Global/Local Prompts, Narrative       Views, Filters, Charts, Pivot Tables, Compound layouts to design the       dashboards. 

  
Created Security settings in Oracle       Administration Tool to set up groups, access privileges and query privileges       and also managed security for groups in BI Answers. 

  
Designed dashboards and reports for role       based users like Executive Management, Rep Level.

  
Developed Dashboards for Compensation,       Retention, Performance and Workforce.

  
Developed Reports like Turnover       Demographics, Trend Analysis, Top performers, Employee lists, overtime       expenses, Headcount Trend and many more. 

  
Developed Dashboards for each of metrics       by embedding reports and providing intuitive drill-downs and links to       exploit the full benefit of Analytics in providing summary and detail       reports.

  
Used       OBIEE Delivers to automate iBot queries, obtain weekly reports and to send       alerts to related managers and secured team members.

  
Used       DAC (Data warehouse Application Console) for both incremental and full       loads.

  
Monitored and Scheduled ETL along with       reducing application configuration and development time by using DAC. 

  
Enhance performance of Reports/Dashboards       by implementing the Aggregate tables, Table execution path by making use       of hints, Creation/Re-building of Indices and Cache Management.

  
Created & saved several BI Publisher       reports by selecting an Answers request as Data Source.

  
Built       multiple execution plans in DAC for weekly and daily loads.

  
Created comprehensive and       easy-to-understand Documentation of the complete implementation of the       Customer Sales Business modules (Reports, Dashboards, Security and Star       schema.

  
Build       test cases and tested the Reports/Dashboards by comparing the SQL Output       on the Data warehouse to the values in the Reports/Dashboards, documented       the test results.

  
Designed and documented the custom ETL       process to gather data from different data sources to populate the OLAP       database (Star Schema). 

  
Extensively involved in performance       tuning.

  
Closely worked with ETL team and DBAs for       query tuning. 


Environment: Oracle Business Intelligence Enterprise Edition (OBIEE)  10.1.3.2, Informatica Power Center 7.1.4, Data Warehouse Administration Console  (DAC), Oracle BI Publisher, Oracle Delivers, Windows XP & SQL.


Confidential, Wamu San Francisco, CA  Feb  2007 - Feb 2008

    Role: OBI Developer

Confidential, data warehouse processes 25  million credit card accounts, 46 million customers, 21 million Retail  customers, and 3 Million mortgages. The campaign data mart aims to provide a  Central Repository and a Decision support system. There are approximately 400  users of the data. It supports analytics; weekly campaign offers (Credit Cards,  Retail Bank and Home Loans). There are 463 data extraction workflows and most  of them are updated on daily, weekly, and monthly basis. The department is  using the onshore/offshore model (24/7). 

Project: The goal/objective of this project is to analyze  and measure the effectiveness of various marketing campaigns initiated by the  marketing group.

Responsibilities:


  
Customized OBIEE Applications  Financial management module based on the business requirements.

  
Created connection pools, physical  tables, defined joins and implemented authorizations in the physical layer of  the repository 

  
Configured and Created repository  using OBIEE 10.1.3 Admin tool.

  
Created numerous executive level  reports. 'Dashboards' were generated to provide insight into the  marketing/financial data. 

  
Designed Schema/Diagrams using Fact,  Dimensions, Physical, Logical, Alias and Extension tables. 

  
Analyzed and validated the Oracle BI repository  by performing consistency check as per the oracle best practices.

  
Created groups and users to manage the security privileges for each subject area in  RPD and dashboards according to user requirements

  
Designed and customized RPD's, Oracle Answers  (webcat), Dashboards and Cache. 

  
Created different types of Customized  Reports (Drilldown, Aggregation) to meet client requirements.

  
Built Business model and established  relationships & Foreign Keys (Physical & Logical) between tables.

  
Generated various Analytics Reports  like Formulary Report and Direct Sales Report using global and local filters. 

  
Identified the aggregate levels for  each source and created dimension sources for each level of aggregates. 

  
Involved in managing appropriate  Security privileges on subject areas and dashboards according to business  requirements.

  
Developed custom reports/Ad-hoc  queries using OBIEE Answers and assigned them to application specific  dashboards.

  
Developed different kinds of Reports  (pivots, charts, tabular) using global and local Filters. 

  
Created proactive agents iBots and  interactive Dashboards to alert the Marketing team about business changes. 



Environment: Oracle Business Intelligence Enterprise Edition (OBIEE)  10.1.3.4, Informatica Power Center 8.1,Oracle Delivers, BI Publisher, Windows  XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0,  EPM 8.9 on Oracle 10g.


Confidential, Boca Raton, FL Oct 2005  -   Jan 2007

    Role: Siebel Analytics Consultant

National Council on Confidential, based in  Boca Raton, FL, manages the nation's largest database of workers compensation  insurance information. The purpose of this project is to create and maintain a  central data warehouse and to create reports for the financial group for  further business analysis. Siebel analytics was implemented for the generation  of the reports.

Responsibilities


  
Worked closely with Business Analyst in  understanding the Analytics requirements and created the business model for  generating reports as per the user requirements.

  
Worked closely with the data modeler in designing  the logical data model/physical data  model (star schema). 

  
Configured and created repository using Siebel  Analytics Administration Tool.

  
Created and administered the Physical Layer,  Business Model and Mapping Layer and Presentation.

  
Layer in a Siebel Analytics Repository using Siebel  Analytics Administration Tool.

  
Developed calculated measures and assigned  aggregation levels based on dimension hierarchies.

  
Involved extensively in Siebel Answers, Siebel  Delivers, and Siebel Intelligent Dashboards with Siebel.

  
Analytics Integrated implementation (Siebel  Business Analytics Applications).

  
Involved in Data Modeling and Data Mapping  review, including sources, staging areas, and target database.

  
Developed custom reports/Ad-hoc queries using  Seibel Answers and assigned them to application specific dashboards.

  
Maintained effectiveness in creating the  Dashboards by appropriately including guided navigational links and drilldowns.

  
Suggested and implemented Siebel recommended  Performance tuning practices to improve  Siebel Analytics server performance by implementing Query Caching, using  aggregate tables, tuning & reorganizing database indexes and configuring  NQSConfig.INI files performance parameters.

  
Involved in developing different kinds of  reports/Ad-hoc queries using Siebel Answers and assigned them to application  specific dashboard.

  
Created Security settings in Siebel Analytics  Administration Tool to set up groups, access privileges and query privileges  and also managed security for groups in Siebel Answers.

  
Used filters and provided customized prompts  (filtering options) appropriately to avoid excessive data visibility in  reports. 

  
Involved in unit testing, integration testing of  the reports generated using Siebel Analytics. 


Environment: Oracle 9.2.0.6, Informatica Power  Center7.1.4, Erwin, SQL, PL/SQL, TOAD 7.3, Siebel Analytics 7.8.2, HP UNIX's,  and Microsoft tools Excel, Word.

Education:


  
 Bachelor of Information Technology