• Over 11 years of IT experience with over 6+years of experience in Business Intelligence especially in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using Siebel Analytics 7.x/ OBIEE 10.x./OBIEE 11g.
• Having Good Experience in BI Applications in Finance, Procurement and Spend Analytics and HR.
• Very strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Mapping & Model, and Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down and drill-across capabilities using global & local Filters, OBIEE/Siebel Analytics Security Setup (users/groups, access / query privileges), configured OBIEE/Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog Objects (Dashboard, Pages, Folders, Reports), scheduling iBots.
• Having good working knowledge in Oracle applications tables in GL, AP, and HRMS.
• Having good working knowledge in Oracle Discoverer 9i Administrator.
• Having good working knowledge in Business Objects 6.5 Administrator.
• Having good working knowledge in Hyperion Essbase.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x /5.x
• Very strong in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (using pmcmd)
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Multi-platform experience on UNIX and Windows Server family of products; as well as Enterprise Java Application Servers
• Expertise in business planning, analysis & software designing skills with ability to transform business users’ input into software requirements and specifications
• Excellent Written and Verbal Skills, results oriented and Self-Starter looking for challenges, ability to rapidly learn and apply new technologies and improve processes, Self-motivated and results-oriented with solid work ethic.

Technical Skills
OBIEE 10.1.3.4.1/Siebel Analytics 7.x.
Informatica 5.1/6.x/7.x/8.x
Oracle 7x/8.0/8i/9i/10g.
SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x,Toad.
Windows 95/98/NT/2000, UNIX, Sun Solaris, IBM AIX, HP UNIX
Certification:
Oracle Certified Associate.
Education:
Bachelor of Science
Professional Experience
Confidential,
NJ.
Sr.OBIEE Consultant Mar 2011 – Feb 2012.

Compensation Accounting has four main locations New York, London, Hong Kong and Bangalore. It has worldwide responsible for the payment and Accounting of all salary, bonus and other types of the remuneration paid to employees of the firm. Compensation Accounting are responsible for reporting wage information & processing the payments to domestic & international tax authorities and for the accounting wage reporting & taxation of equity compensation. Areas of human capital management, tax, treasury, and management reporting.

Responsibilities:

• Analysis, Design and Development of Business Intelligence Reports and Dashboards in OBIEE on the basis of functional user requirements..
• Analysis, Design and Development of OBIEE Technical Design Document on the basis of Business requirements for the development of both Dashboards and Reports.
• Upgraded of OBIEE Infrastructure from OBIEE 10.1.3.4 to OBIEE 11.1.1.5.
• Upgraded both Repository and Web catalog from OBIEE 10.1.3.4 to OBIEE 11.1..1.5.
• Designed and development of OBIEE repository (rpd) according to the OBIEE Technical Design Document for the development of metadata in repository by importing the required facts and dimensions using Connection pool using OCI/ODBC.
• Development of repository at physical, business model and mapping and presentation layers using Administration tool.
• Creation of Hierarchies, Level based measures, Initialization blocks, Repository, session and Presentation variables, Time-series functions.
• Developed dashboards and answers using pivot view,table view,narrative view,title view, chart view.
• Implemented Oracle BI Server security and Presentation services security groups.
• Implemented externalize Authorization security OBIEE from BI server security.
• Unit test and Regression testing of both reports and Dashboards.
• Merging and Deployment of webcatlog and rpd from development to test and test to production.
• Maintenance of BI Server and Configuration files.
• Interaction with Functional Users and Training Users in access of OBIEE.
• Closing SRS tickets of Production support of OBIEE issues.

Environment:: OBIEE 10.1.3.4.1,OBIEE 11g,Global Payroll PeopleSoft, Oracle 9i/10g,Aqua data studio, Windows 2003 server.

Confidential,
CT
Sr.OBIEE Developer Mar 2010 – Feb 2011

Valassis is one of the nation’s leading media and marketing services companies. It delivers value to customers how, when and where they want through our consumer brand,RedPlum.It reaches 100 million shoppers each week, touches 9 out of 10 U.S households in the mail, maintains largest database of over 13,000 publications.

Responsibilities:

• Analysis, Design and Development of Business Intelligence Reports in OBIEE, Discoverer, Business Objects on the basis of User Requirements.
• Analysis, Design and Development of OBIEE Technical Design Document on the basis of Business requirements for the development of both Dashboards and Reports.
• Designed and development of OBIEE repository (rpd) according to the OBIEE Technical Design Document for the development of metadata in repository by importing the required facts and dimensions using Connection pool using OCI.
• Development of repository at physical, business model and mapping and presentation layers using Administration tool.
• Creation of Hierarchies, Level based measures, Initialization blocks, Repository, session and Presentation variables, and Time-series functions.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication and in Dashboard / Report-level security.
• Unit test and Regression testing of both reports and Dashboards.
• Merging and Deployment of webcatlog and rpd from development to test and test to production.
• Worked closely with Users to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository
• Involved in implementation of BI Apps in HR, Financial, Procurement and Spend Analytics.
• Analysis of Data in DWH and ERP in BI Apps in HR, Procurement and Order Module and Preparing the Gap Analysis Document.
• Developed OBIEE reports by using Oracle Fusion Transportation Intelligence option for Oracle Transportation Management data.
• Interaction with Functional Users and Training Users in access of OBIEE.
• Involved in data modeling and security of BI Apps and OBIEE.
• Production support and Maintenance of Business Objects by Closing IT Helpdesk Tickets.
• Loading Weekly Order Reports to the Production Tables.

Environment:: Business Objects 6.5,Discoverer 9i,OBIEE 10.1.3.4.1,BI Apps,OTM,Hyperion Essbase,Oracle 9i/10g,Toad,SQL Server 2005,Attunity.

Confidential,
Austin,TX.
Sr.OBIEE Developer/Admin Sep2009 – Mar 2010.

Rail Road Commission of Texas has primary regulatory jurisdiction over oil and natural gas industry, pipeline transporters, natural gas and hazardous liquid pipeline industry, natural gas utilities, the LP gas industry and coal and uranium surface mining operations. The commission is responsible for research and education to promote the use of LP –gas as an alternative fuel. Analytics solutions will enhance the decision-making process regarding data and statistics of drilling, field data, gas storage, natural gas service, online research queries, operators, open records, pipeline safety, production, propane liquefied gas compressed gas, well information.

Responsibilities:

• Analysis, Design and Development of OBIEE Technical Design Document on the basis of Business requirements for the development of both Dashboards and Reports.
• Designed and development of OBIEE repository (rpd) according to the OBIEE Technical Design Document for the development of metadata in repository by importing the required facts and dimensions using Connection pool using OCI.
• Development of repository at physical, business model and mapping and presentation layers using Administration tool.
• Creation of Hierarchies, Level based measures, Initialization blocks, Repository, session and Presentation variables, and Time-series functions.
• Customization of the OBIEE Dashboard banner by adding the logo of Rail Road Commission of Texas.
• Customization of Dashboards by modifying the instanceconfig.xml and web folders for the requirements of Rail Road Commission of Texas.
• Cache Management done at both Repostory, Presentation services levels.
• Developed many reports and Dashboards with different Analytics views like pivot table, chart, and view/column selector, tabular with global and local filters using presentation services.
• Upgraded OBIEE 10.1.3.3.2 to OBIEE 10.1.3.4.1 on Solaris Sprac to rectify some of the existing bugs in previous version.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication and in Dashboard / Report-level security.
• Unit test and Regression testing of both reports and Dashboards.
• Merging and Deployment of webcatlog and rpd from development to test and test to production.
• Developed OBIEE and Business Objects reports in OTM.
• Worked closely with Users to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository.

Environment: OBIEE 10.1.3.4.1, HRMS, Sun Solaris Sprac, Oracle 9i/10g, Toad.

Confidential,
CA. Jul 2008 – Aug2009.
Sr.OBIEE Developer / Analyst

CRPM (Customer Reliability Performance Metric) provides a measure that indicates how a customer’s individual hardware products (PID’s) are performing with in their network. The Product performance is measured by comparing the calculated field performance or Field MTBF to the products predicated MTBF.Utilizing Cisco Manufacturing’s established Reliability ratio methodology to monitor performance.

Responsibilities:

• Getting the functional requirements from Functional team and Interacted with Business representatives for development of Reports and Dashboards.
• Design and development of OBIEE Technical Design Document on the basis of Business Requirement Document for the development of reports and Dashboards.
• Designed and developed the OBIEE/Siebel Analytics Metadata Repository(.rpd) using

OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.

• Development of Repository (Rpd) at Physical, Business Model Mapping and Presentation Layers in OBIEE.
• Creation of Hierarchies, Level based measures, Initialization blocks, Repository, session and Presentation variables, and Time-series functions.
• Developed many reports and Dashboards with different Analytics views like pivot table, chart, and view/column selector, tabular with global and local filters using presentation services.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
• Merging and Deployment of web cat and Rpd through using Kintana and PVCS tools.
• Source of data is Oracle E business Suite.
• Modify existing Discovered reports using Oracle Discoverer 9i Administrator.
• Created test data and Unit Tested the Informatica Mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Created scripts, which were part of the mapping’s session properties. Used sessions to move files from directory to other and used to compare files.
• Developed Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository

Environment: OBIEE 10.1.3.3.2, Discoverer 9i,Oracle E-Business suite, BI Apps,Essbase,Informatica Power Center 8.1.1,Oracle 10g.

Confidential,
TX. Jan ’07 – Jun 2008
Sr. OBIEE – BI Analyst

The Customer Services (CS) Analytics solution will enhance decision-making process regarding Operations/Services Enhancements of TXU personals. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers (around 2.2 millions) as well used to report to Texas Public Utilities Commission (TPUC).

Responsibilities:

• Analyzed the Functional Specifications provided by the Architect and created Technical Specs documents for all the mappings.
• Interacted with Case Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Identified the GAP’s by analyzing the CS Data Mart instance and provided alternative solutions as well recommended changes to database.
• Designed and developed the OBIEE/Siebel Analytics Metadata Repository (.rpd) using OBIEE/Siebel Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool and creating the Presentation catalogs in Presentation Layer.
• Developed many Case Solutions Time Series objects for comparing the various case types’ service requests between the quarters.
• Developed BI Reports using Conditional Formatting and Looping, Number and Date Formatting, Page Breaks, Page Totals and Running Totals in BI Publisher.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services/Siebel Analytics Web
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports
• Security by creating roles & web groups, checks with External table and LDAP Authentication.
• Migrated Business Objects Reports to OBIEE.
• Expertise in Business Objects 6.x Administrator for modifies the existing reports.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository
• Life-cycle support for migration efforts from Development to Integration Test to Production Analytics
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made c

Corresponding changes to OBIEE/Siebel Analytics Repository

• Performing the benchmark for up gradation process from OBIEE/Siebel Analytics to Oracle Business Intelligence

Environment: OBIEE 10.1.3.3.2, Business Objects 6.x, Sun Solaris, Informatica Power Center 6.x/7.x, Oracle 9i/10g.

Confidential,
VA Jul ’05 – Jan ‘07
Sr. Siebel Analytics
The CRM project provides sales and order Analytics solution to Exxon Mobil to enhance decision making process regarding their products and customers. The system will allow users to perform data analysis and track their products and customer details.

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Developed Siebel Analytics Repository (RPD) per user requirements and available information in DW.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Implemented Security for various users and groups using External Table Authentication.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Responsible for creation of pivot table requests and bar/column charts allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector/view selector, multi-select page prompts
• Created and used Siebel Delivers and iBots extensively.
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment
• Developed Informatica mappings with re-usable transformations and mapplets using various transformations like Filters, Aggregator, Lookups, Expression Aggregator ,Sequence generator, Joiner and Update Strategy
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment

Environment: Siebel Analytics 7.x, Informatica 6.2, Oracle Applications 10.7(E-Business suite), Oracle 9i, Sun Solaris.

Confidential,
NC Mar ’04 – Jul ’05
Siebel Analytics Consultant
The Siebel Analytics BI Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse analytical information assets in retail finance at Wachovia, a nation-wide leading financial services company.
Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document Business requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Worked extensively on Siebel applications (Siebel Answers, Delivers, and Dashboards).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Involved in design and development of repository (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts.
• Implementation of Siebel Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Used Workflow Monitor to monitor the performance of the Jobs.
• Developed and executed test plans and played an active role in product rollouts.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.

Environment: Siebel Analytics 7.x, Informatica Power Center 6.x/7.x, Oracle Applications (E-Business suite), Oracle 9i/10g, Sun Solaris.

Confidential,
GA. Jan ’03 – Mar’ 04
Informatica Consultant

Bellsouth Broadband and Internet Services (BBIS) Data mart is implemented to analyze the usage metrics and also to measure performance of customer operations.

Responsibilities:

• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex Informatica mappings and mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator) for loading the data into Data Warehouse.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Performance Tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
• Designed and Developed many Shell Scripts for pulling data from remote machines, session using Cron, Backup/Migration of metadata from version, development and production, FTP, sending files to source directory, managing sessions files in the server directory.

Environment: Informatica Power Center 5.x/6.x, Oracle 8i/9i, HP UNIX.

Confidential,
OK May ’01 – Dec ’02
Informatica Consultant

Customer’s Trends data warehouse was developed to aid and assist the management committee in making various decisions regarding the customers. Data Mart was built to do customer-rating analysis, to monitor the various shopping trends of the customer (this data was used to detect a pattern), Track & Record updates.
Responsibilities:

• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer
• Creating ETL mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure and Update strategy
• Created and used Reusable Transformations to improve maintainability of the Mappings
• Created various Reusable and Non-Reusable tasks like Session.
• Created and used different tasks like Decision and email tasks
• Responsible for monitoring sessions that are running, scheduled, completed and failed
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution

Environment: Informatica PowerCenter 5.x/6.x, Oracle 8i, HP-Unix.