SUMMARY

• Expertise in setting up overall Oracle Business Intelligence Architecture and in implementing OBIEE Best Practices
• Extensive experience in creating complex reports, configuring Interactive Dashboards with drill-down capabilities, Contextual Navigation, Filters and Rules with User Identity and Roles, BI Publisher, Usage Tracking,KPIs and Agents
• Extensive experience in interacting with all levels of Business Users in requirements gathering, authoring requirement specification Complete Development Life Cycle implementation experience of BI systems including System Analysis, Data Analysis, Design, Development, Testing of Business Intelligence and Data Warehouse using Oracle Business Intelligence OBIEE /Siebel Analytics, Informatica and DAC
• Extensive experience in interacting with all levels of Business Users in requirements gathering, authoring requirement specification documents and in gap fit analysis
• Expertise in OBI Repository development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Caching and Performance Tuning
• Extensive experience in customizing Oracle BI Apps, OOTB ETL adaptors and prebuilt analytics
• Extensive experience in developing Informatica Mappings/Mapplets and Workflows with Worklets and Tasks using various Transformations for ETL from various source systems to the Data Warehouse, in implementing Slowly Changing Dimensions and in Performance Tuning
• Extensive experience in configuring DAC, administering and managing full and incremental loads
• Extensive experience in working with different source systems including PeopleSoft Financials and HR, Siebel, Custom Applications in Oracle, SQL Server, Excel and Text Files
• Siebel experience in working on Siebel Call Center, Siebel Financial Services, Siebel Communications Modules. Strengths include Campaign Management, Smart Scripts, Siebel Visual Basic, eScript, Configuration using Siebel Tools, EIM, Server Administration, Application Administration, Workflow Manager, Assignment Manager
• Expertise in Project Management from Initiation, Design, Development and Deployment

TECHNICAL SKILLS

Business Intelligence: OBIApps7.9.6, OBIEE 111.1.1.7, 10.1.3.4 Siebel Analytics 7.5/7.7

ETL: Informatica Power Center 7.x, 8.x, 9.x,DAC 11.1.1.6, 10.1.3.4, ODI 11.1.6

Source Systems: Siebel, PeopleSoft HR and Financials,Oracle EBS,Taleo, ClaraBridge

CRM: Siebel 99, 6, 7.x, 7.8

Database: Oracle7.3.4, 8.0.5, 9i, 10g, 11g, MySQL, SQL Server 2005, MS-Access

Languages: Siebel VB, Siebel eScript, SQL, Transact SQL,PL/SQL, Visual Basic.Net, Visual Basic 6.0, VB Script, JavaScript

Case Tools: Designer 2000

Third Party Tools: Infragistics, TOAD, PL/SQL Developer, SQL Developer

Reporting: Actuate Workbench 6.0, Crystal Reports 8.0, SQL Server 2005 Reporting Services

WORK EXPERIENCE

Confidential

Oracle BI Architect/Senior Developer

• Dashboard and Reports design and development
• Customization of OBIEE Repository for Asset Management,Supply Chain,Inventory,HR,Procurement and Project Analytics
• Informatica ETL mappings and DAC configuration
• Development of Usage Tracking dashboard
• Development of Alerts and KPIs
• User Training

Confidential

Oracle BI Architect/Senior Developer

• Worked with OBIA and customized OBIEE Repository for Financial,HR,Procurement and Project Analytics
• Developed Custom Dashboards and Reports
• Modified OOTB Informatica ETL mappings per user requirements
• Configured DAC to run full and incremental loads
• Imparted custom User Training

Confidential

Oracle BI Architect/Senior Developer

• Designed and configured of OBIEE metadata Repository using best practices for Dimensional Modeling
• Server Administration, design and implementation of security, both object and data level
• Designed and developed an Executive Dashboard and reports displaying data from disparate data sources
• Designed and developed custom subject areas to facilitate ad hoc reporting
• Designed and developed the ETL Architecture for integrating data from different data sources

Confidential

Oracle BI Architect/Senior Developer

• Drew up Software Requirement Specifications and defined scope of work by interacting with the Business User Community and by studying legacy reports and future analytical requirements
• Led the customization effort of the RPD with an offshore Development Team
• Modified OOTB RPD in OBIEE 11g as part of OBIA to accommodate Dell specific requirements and also to accommodate data from disparate sources including PeopleSoft 9.1 and Taleo
• Customized OBI Apps to bring data into the warehouse modifying Informatica Mappings/DAC to accommodate RPD Design changes

Confidential

Oracle BI Architect/Senior Developer

• Designed a Dimensional Model with views in Teradata from multiple Sources including Siebel
• Designed custom stars with newly identified Facts and Dimensions and also with existing conformed dimensions
• Developed a Custom Model and all the three layers Physical, BMM and Presentation in OBIEE RPD incorporating the new stars
• Migrated Informatica Mappings and Workflows from Development to Integration environment

Confidential

Oracle BI Architect/Senior Developer

• Interacted with Business Users to identify requirements and Dow specific reporting needs
• Customized OBI Apps OBIA involving designing new ETLs to bring in data from tables in PeopleSoft which was being upgraded from 8.0 to 9.0
• Created new ETLs to bring in data from text files
• Designed new stars in OBIEE to accommodate reporting requirements from Custom tables
• Customized HR analytics to accommodate reporting requirements specific to Dow's business processes
• Customized the OOTB repository per business requirements in the Physical, BMM and the Presentation layers using OBIEE Admin Tool to facilitate Dashboards/Reports creation
• Modified out of the box ETLs to bring custom fields to the data warehouse with PeopleSoft HR as the source
• Configured DAC to monitor and control both OOTB and custom workflows and handle both full and incremental loads

Confidential

Oracle BI Architect/Technical Lead

• Led and managed a team of BI resources for Oracle Business Intelligence implementation
• Interacted with stakeholders and end users for requirements gathering and to define corporate KPIs , management reports, dashboards and customized login screens
• Designed and developed the ETL process using OOTB and custom fact and dimension tables including Mappings and Mapplets using various Transformations and Workflows with Sessions/Tasks
• Used DAC console and client extensively to manage, configure and customize the data load process from Siebel OLTP database to the data warehouse - full load as well as incremental load
• Implemented slowly changing dimensions for key fields identified by end users
• Customized BI Apps OBIA extensively, designed and developed custom repository, Metadata with necessary logic that involved creating the Physical, BMM and the Presentation layer and Dashboards/Reports, using OBIEE Admin Tool
• Developed methodologies for migration of Informatica mappings, workflows, RPDs, webcatalog files and DAC Repository from DEV to UAT and to PROD
• Enhanced performance of Reports/Dashboards by implementing Aggregate tables, Materialized Views, Table partitions, rebuilding of indexes, overwriting the SQL execution path by making use of hints, Creation/ Rebuilding of Indexes and managing Cache
• Developed multiple Reports/Dashboards with different Analytics Views Pivot Table, Chart, Column Selector, Dynamic/Interactive Dashboards with drill-down capabilities, tabular using global and local Filters ,Guided Navigation

Confidential

Oracle BI Architect/Technical Lead

• Led a core team through requirements analysis to detailed design and implementation of custom business intelligence solutions that involved Physical, BMM and Presentation layer, and Dashboards using the Siebel/Oracle BI Analytics platform
• Interacted with Client Services Management business representatives for gathering the Reports/Dashboards requirements and to define business and functional specifications
• Extensively used OBIEE Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository
• Created new custom mappings and modified out of the box SDE and SIL mappings
• Created and customized DAC Execution plans for full and incremental data load from OLTP to OLAP stars
• Created complex reports using Answers and Automated iBot queries to deliver weekly reports, and to send alerts to related managers and team members
• Implemented SCDs for select fields identified by the users

Confidential

Senior Siebel Analytics Developer

• Interviewed Client Services Personnel to understand the current reporting system and gathered the reporting requirements to prepare the requirement specifications document
• Configured the Siebel Analytics Repository at the Physical Layer , Business Model/data mapping and Presentation Layer level
• Used Siebel Analytics Web to design and develop ad hoc and standard Reports/Dashboards with different Analytics Views Drill-Down/Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Configured iBots to deliver scheduled Analytics content
• Implemented Security/Access privileges by creating roles and web groups by checking with External tables
• Optimized performance of Dashboards/Reports and ETL processes
• Developed complex Informatica Objects Workflows/Sessions, Mappings/mapplets with various transformations i.e. expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy for performing the delta/incremental loading/processing

Confidential

Siebel Analytics Developer

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Developed Metadata repository rpd , configured metadata the Business Model Layer and Physical Data Model and Web Catalog Objects as per the data requirements using Siebel Analytics Server Admin and Web tool
• 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
• Involved in design development and performance tuning of Informatica ETL mappings like increasing the caching size, overriding the existing SQL

Confidential

Siebel CRM Developer

• Design and development of Smart Scripts to support multiple campaigns for AT T formerly SBC .The scripts were designed to create orders during the call flow
• Coding using Siebel VB at List Management Business Component level to promote prospects to Contacts and Accounts programmatically. This process eliminated loading Lead information into multiple tables Example: S CONTACT, S ORG EXT, S ADDR PER and S ADDR PER CUTX , thus reducing lead loading time
• Configuration of Siebel Business Objects, Business Components, Screens, Views, Applets, Links, Joins, Pick Lists, MVG Applets, Toggle Applets and drill-downs
• Bulk import of customer lead data into Siebel database using EIM, SQL Loader and PL/SQL Procedures
• Created Custom Extension columns and tables to accommodate lead data
• Development of Response and Sales output file processes
• Enhancement of application functionality by writing scripts using both Siebel eScript and Siebel VB in Application Object, and in various Business Components, Applets and Business Services
• Development of process for loading data from text files to Siebel database using EIM, SQL Loader and PL/SQL Procedures
• Integration of Siebel with external pricing Application developed in Visual Basic
• Design and development of Workflow Processes to transport data to Third-party Verifier's external application

Confidential

Developer and Module Leader

• Design and development of a Hospital Management System using Visual Basic 6.0 and Oracle
• Siebel Tools - Modification and creation of BCs business components and displaying the underlying data from the BCs in the form of Screens, Views and Applets in the User Interface UI Layer to match the overall functionality of the system
• Wrote event driven Siebel VB code in Applets and Business Components
• Configured EIM for import of bulk data into Siebel from external databases
• Application Administration involving Position and Responsibility Management, LOVs Product and Pricelists
• Maintenance and support of SmartScripts
• Drawing up Software Requirement Specifications SRS after interaction with Clients, drawing up Software Design Specifications based on the SRS and using Designer 2000 to draw Entity Relationship diagrams