BACKGROUND SUMMARY:

• Have 8+ years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing and deploying Business Intelligence (BI) applications using OBIEE/Siebel Analytics
• Strong working knowledge in design and development of ETL (Informatica) Process, Data(Dimensional and Relational) modeling for Data warehouse(EDW) and scheduling DAC
• Extensive experience in OBIEE 11.1.1.5/10.1.3.3/10.1.3.4.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, configuring, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), OBI/Siebel iBots (BI Scheduler), BI publisher, BI(RPD and Web - catalog) administration
• Expertise in handling all phases of Quality Assurance Life Cycle(QALC) and Software Development Life Cycle(SDLC) of the BI Projects
• Strong experience in Customizing the OOTB RPD file for Oracle CRM ( CRM Sales, CRM Service Analytics) and Oracle Financials for GL, AP and AR Subject Areas.
• Experience in developing, validating BI technical design document from business specifications document
• Expertise in identifying dimension and fact tables and modeling into star schema, developing dimensional Hierarchies, level based measures and summary tables as necessary
• Strong working knowledge in Metadata Modeling in all three layers (physical, BMM, presentation)
• Extensive experience in achieving aggregate navigation and most economical source in BMM
• Expertise in Security administration (authentication, object & row level security, role-based)
• Experience in using Repository and Session variables and Initialization blocks
• Experience in developing various dynamic and interactive complex reports/dashboards with intuitivedrilldowns, drill-acrossand drillable charts using Answers
• Extensive Knowledgeon Oracle Delivers and Implemented schedule based iBots to deliver reports
• Expertise in BI performance tuning through cache management, indexing(hints) and materialized views
• Actively administrated OBIEE, Informatica, and DAC. Performed routine maintenance tasks(backups, security, scheduling, tuning, processing user requests)
• Experience installing and configuring OBIEE Platform, DAC and out of box BI applications 7.9.5/7.9.6
• Experience in migration of RPD and Webcat to PROD environment using catalog manager
• Over 4 years of Experience in ETL Informatica 8.x/7.x/6.x
• Proficiency in Informatica Designer Components (source analyzer, warehouse designer, mapping designer, mapplet designer, transformation developer, workflow manager and workflow monitor)
• Proficient in developing reusable transformations and mapplets
• Experience in Installing, configuring and customizing DAC(execution plans, subject areas, tables, task) and monitoring ETL process using DAC(7.9.5, 10.1.3.4.1) & Informatica workflow manager
• Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2
• Experience in developing customized Oracle SQL queries and PL/SQL Programs
• Strong Knowledge in Oracle SQL query Performance tuning using Explain plan
• Ability to learn quickly and apply new skills in addressing business and technical problems
• A self starter, committed to achieve results in team environment by working cohesively

TECHNICAL SKILL SUMMARY:

Operating Systems: Win XP/2000//2003, Windows NT/98 & UNIX (Linux)

Programming Languages: C, C++, SQL, PL/SQL, Shell Scripting

Relational Databases: Oracle 9i/10g, SQL Server 2000/2005, IBM DB2 UDB 8.2

Web Technologies: HTML, XML

Database Tools: TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer

BI Tools: Siebel Analytics 7.X, OBIEE 11.1.1.X,10.1.3.X & BI Applications 7.9.X

ETL Tools: Informatica Power Center 8.6/8.1.1/7.1/6.1

Networking Protocols: TCP/IP, UDP, IP, SMTP

MS Suite: MS outlook, Microsoft office 2003/2007, MS Access, Excel

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Oracle BI Apps (OBIA) consultant

Responsibilities:

• Involved with Finance Team and users to gather requirements
• Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point of view
• Based on user requirements, identified various fit-gaps on existing Oracle analytics warehouse and developed solutions to meet Amazon’s requirements and loaded the user required data into the OBAW
• Involved in developing Project Plan for the future scope of the Financial Analytics project which includes developing learning management and recruitment subject areas from flat files provided by third party vendors using Universal adapters
• Involved with Project managers and users to gather KPI’s from warehouse for Financial reporting
• Administrated BI Environment by debugging identified issues and delivered solutions
• Identified Financial Analytics facts, dimensions & star schema models of workforce profile subject area
• Created Materialized Views to look up Organization Hierarchy Descriptions for OOTB Hierarchy tables
• Customized OBIEE repository by adding custom columns and tables using BI administration tool for Service Analytics tables like W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, W OPTY D tables in Service Analytics ( Oracle CRM).
• Involved in customizing Account Recievables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards. The tables like W AP BALANCE F, W AR BALACE F, W GL ACCOUNT D were customized as per user requirements.
• Identified bugs and updated OBIEE Infrastructure with oracle provided updates and patches
• Involved with DBA’s to tune the DB by setting DB Parameters and tuning BI generated SQL queries
• Created custom Indexes on OOTB Tables to improve dashboard Report performance
• Used catalog manager to migrate custom dashboards, requests, filter and prompts to ProdETL & DAC:
• Informatica Power center 8.6 is used to load the Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders
• Have been involved in customizing W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, W OPTY D tables in Service Analytics ( Oracle CRM) and W AP BALANCE F, W AR BALACE F, W GL ACCOUNT D, W STATUS D, W LEDGER D tables in Financial Analytics.
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Identified Data warehouse and staging tables, Informatica workflows/mappings and DAC tasks related to Finance data and customized Informatica mappings to load historical data
• Took back-up of DAC, BI & Informatica repositories and BI Web catalogs
• Involved in Knowledge transfer to Amazon IT Developer on various issues and product maintenance

Environment: OBIEE 11.1.1.5/10.1.3.4.1, BI Apps 7.9.6, DAC 10.1.3.4.1, Informatica PC 8.6, Oracle EBS Apps, Red-Hat Linux, Oracle 11g (11.1.0.7.0), Windows server 2003, SQL Developer

Confidential, San Jose, CA

OBIEE Developer/Administrator

Responsibilities:

• Interacted with operations and billings subject matter experts (SME) & business analysts in gathering and analyzing the report requirements for the sales managers
• Involved in developing and documenting technical specifications(TSD) from business requirements
• Involved in meeting with the sales and team managers to gather KPI’s from analytics data mart
• Actively interacted with team members to discuss technical enhancements and progress of work
• Performed fit-gap analysis on identified Facts and Dimensions and made required changes to the Operations and Billings Datamart(OBAW Database)
• Extensively used BI Administration Tool for customizing the physical, business and presentation layers of sales and marketing analytics repository
• Worked extensively with Oracle answers to create reports containing charts, pivot tables, gauges
• Customized OOTB insurance executive, insurance marketing dashboards as per client requirements
• Used custom filters & dashboard prompts appropriately to avoid excessive data showing up in reports and maintained effectiveness in creating the dashboards by using guided navigational links & drilldowns
• Configured scheduler and created iBots to send alert messages and reports to subscribed users
• Managed security privileges for each subject area & dashboards by setting the role based security for different users and business analysts
• Performed pre and post implementation testing and validating dashboards through data validation
• Implemented user security authentication using LDAP server directory
• Involved in performance tuning for BI server and Oracle SQL queries
• Configured event polling cache purging method to clear the stale data
• Actively participated as production support during system file migrations and patch updatesETL & DAC:
• Involved in preparing system requirement specification and design document to provide an overview of the technical design specifications required for the warehouse enhancements
• Informatica was used to translate the business rules into mappings to include OLTP custom columns & tables from Siebel Billings application system into OBA warehouse
• Created 8 new mappings and modified several existing mappings as per the business requirements
• Modified the account and product hierarchies by assigning custom attributes to various levels in the hierarchy tree structure
• Configured Informatica custom workflows & synchronized with DAC tasks for routine scheduling
• Involved in co-coordinating onsite-offshore teams in various life cycles of the projects

Environment: OBIEE 10.1.3.3.x, Informatica 8.1, BI Apps 7.9.5, DAC 7.9.5, Oracle 10g, MS SQL Server 2000, Windows 2000 Server, Oracle’s Siebel Insurance 8.0, TOAD

Confidential, Lambard, IL

Sr.Siebel Analytics Developer

Responsibilities:

• Gathered the business requirements and specifications from end users, marketing executives and managers.
• Analyzed, Designed and Developed Siebel Analytics Metadata repository (.rpd) with aggregates, dimensions, Time Series Objects, Catalogs, Folders, enforced external table security using session variables.
• Developed calculated measures & assigned aggregation levels based on dimension hierarchies.
• Informatica was used to translate the Business requirements into mappings, and to load data into Data warehouse.
• Built and debugged various Dashboards with drill-down capabilities based on hierarchies using local and global filters using Siebel Answers.
• Designed Reports with different Analytics Views (Pivot Table, Chart, Tabular & View Selector)
• Developed mappings using transformations like Connected and Unconnected lookups, Aggregator, Update strategy, Router, and Sequence generator.
• Developed different reports using pivots, charts, global and local filters using Siebel Answers.
• Used the expression builder utility to create new logical columns and calculation measures.
• Customized prompts appropriately to avoid excessive data showing up in Reports and Graphs.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created new Time series measures using AGO and To Date functions for forecasting.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.

Environment: Siebel Analytics 7.5, Informatica Power Center 6.2, Windows XP, UNIX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential, Bloomington, IL

Siebel Analytics Consultant

Responsibilities:

• Interacted with business analysts to understand business reports/dashboards requirements and to define functional and technical specifications for developing metadata repository
• Identified facts, dimensions, aggregate tables and designed star schema models on database tables
• Created & configured BI server metadata for a dish networks analytics(DNA) reporting project
• Connection pools were used to import the data objects from OLAP into Physical Layer
• Designed and developed Siebel Analytics RPD’s using administration tool and configured repository with logical dimensional modeling using star schema methodologies
• Created dimensional hierarchies, level based measures, and added aggregate tables against base fact tables and performed physical and logical measure calculations and value based partitions(fragmentation) in Business Model Layer(BMM)
• Modeled time series calculations using ago and to-date functions
• Created presentation catalogs(folders) and subfolders in Presentation Layer of admin tool
• Using Siebel answers, various dashboards were designed and developed with different analytics views (drill-down, pivot table, interactive charts, column Selector, global and local Filters)
• Implemented data level security on user groups in repository as per user requirements
• Implemented presentation services security on user groups based on their roles through web catalog
• Implemented Security through external database table authentication and authorization through session system variables, Initialization blocks and groups
• Achieved dashboard Performance through caching, aggregates and indexing on database tables
• Prepared production migration document following the BI best practices
• Involved in the migration of RPD and catalog files from TEST to PROD environment
• Performed Unit and Integration testing to validate report and mapping functionality
• Involved with ETL team to Monitor workflows and to debug errors
• Involved in UAT and post production support

Environment: Siebel Analytics 7.8, Informatica Power Center 7.1, DB2 8.1, Oracle 10g, TOAD, Linux

Confidential

Siebel Analytics Developer

Responsibilities:

• Identified key measures & dimensions from documentation for business performance and analysis
• Analyzed sources systems and involved in development of detailed design & upgrade documents
• Involved in upgrading Siebel Analytics and related components for UAT & prod environments
• Good understanding of OLTP, Siebel OLAP data models, Pharma Sales and Marketing analytics
• Customized Siebel Pharma Analytics metadata repository (RPD) using Siebel Analytics admin tool by importing required objects into physical Layer
• Developed custom fact based dimensional models in the Business Model and Mapping Layer
• Developed and customized some of existing multiple dimensions (Drill-Down Hierarchies) & logical objects in BMM Layer, and created presentation folders in presentation layer
• Involved in customizing vanilla pharma sales, pharma executive & sales representative dashboards
• Customized web catalog objects (dashboards, pages, folders, and reports)
• Configured iBots to deliver analytics content based on schedule
• Coordinated the RPD and web catalog objects migration from UAT to production environment
• Implemented External Database table Authentication for users to access presentation services
• Involved in complex SQL queries using TOADETL:
• Interacted with Business Analyst to understand the data warehouse enhancement requirements
• Also participated in analyzing ETL mappings using Informatica 7.1
• used transformations like aggregator, update strategy, filter, lookup, sorter and router
• Worked in developing transformations and mappings using Informatica designer and processing tasks using workflow manager to move data from multiple sources into targets
• Customized SRMW (Siebel relationship management warehouse tables) as per requirements
• Performance tuning of the sessions using workflow manager statistics and front end query tools
• Scheduled and monitored ETL (SIL and SDE) runs using DAC Siebel 7.8 Vertical adapters

Environment: Siebel Analytics 7.8, Informatica 7.1, Pharma Sales Analytics 7.8, Siebel DAC, Oracle 9i, MS SQL Server 2000, SQL Query Analyzer, Win 2000