SUMMARY

• Expertise in setting up overall Oracle Business Intelligence Architecture and in implementing OBIEE Best Practices
• Expertise in developing Dimensional Models including star and snow flake schemas
• 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, Scheduler and Agents
• Extensive experience in customizing Oracle BI Apps(OBIA), OOTB ETL adaptors and prebuilt analytics
• Extensive experience in developing Informatica Mappings/Mapplets and Workflows and Tasks using various Transformations for ETL from various source systems to the Data Warehouse, in implementing Slowly Changing Dimensions and in Performance Tuning
• Experience in setting up Topology, creating new models for multiple data sources and reverse engineering for data sources and targets
• Experience in working with different Knowledge Modules and in creating ODI interfaces, packages and scenarios
• Extensive experience in interacting with all levels of Business Users in requirements gathering, authoring requirement specification documents, both functional and technical
• 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, ODI and DAC
• Expertise in OBI Repository development with Dimensions, Hierarchies, Measures, Aggregation Rules and 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, Oracle EBS, 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: OBIA 11.1.1.8, OBIEE 11.1.1.8, 12C, Siebel Analytics 7.5/7.7

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

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

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

Database: Oracle 11g,12C, MySQL, SQL Server, MS-Access

Languages: Siebel VB, Siebel eScript, SQL, Transact SQL,PL/SQL, Visual Basic.NetVisual 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

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

OBIEE Architect/Senior Developer

Responsibilities:

• Designing and developing solutions that addresses business requirements
• Identification of violation of best practices in the legacy 10g environment and implementation of fixes for the same in the new installation of 12C
• Development and customization of OBIEE/OBIA 12 C Repository with multiple data sources including Oracle, DB2 and SQL Server
• Building new ETL mappings in Informatica, sourcing data from multiple data sources and including them in execution plans in DAC
• Customizing and modifying pre-built mappings to extract data from disparate sources, including Siebel and custom data sources, adding new ports, tables, filters and transformations, and load data into target systems and configuring the corresponding workflows in DAC for execution and monitoring purposes.
• Building the security model configuring both data and object level security
• Designing and Developing interactive dashboards, analyses and building subject areas for users to create adhoc reports
• Working with Performance tuning of reports

Confidential, San Diego, CA

OBIEE Architect/Senior Developer

Responsibilities:

• Work with business users to gather requirements and then define functional and technical specifications from the same to be used as input to the application design
• Identify the types of visualizations best suited for the client’s requirements
• Collaborate with the development team and lead the development of the appropriate dimensional model
• Work on OBIA Sales Analytics customizing the OOTB RPD almost from scratch involving configuring the metadata and create the Physical, BMM, and presentation layers
• Design and Develop custom mappings to populate the Data warehouse tables using Informatica
• Load data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger)
• Modify out of the box ETLs to bring custom fields to the data warehouse
• Manage, configure and customize the data load process using DAC
• Validate repository level calculations done in the business model layer by using PL/SQL in database
• Design and develop Interactive Dashboards and Reports with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, View Selector, and Tabular with global and local Filters)
• Work on performance tuning of Reports and Dashboards
• Create drill down hierarchies per requirements
• Create initialization blocks and variables for usage in reports
• Validate the business model, logical source tables and logical columns by performing consistency checks and resolve errors

Confidential, Houston, TX

OBIEE Architect/Senior Developer

Responsibilities:

• Contributed as a key technical subject matter expert and resource and interacted with business users in delivering improvements to technical architecture, subject area and user interface design
• Designed innovative approaches to view and interact with data for analysis using different visualizations
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns and drillable charts using Oracle Answers, global local filters and page/dashboard prompts
• Customized OBIEE/OBIA Repository for Asset Management, Supply Chain, Inventory, HR, Procurement, and Project Analytics
• Designed and developed Informatica ETL mappings and configured DAC
• Developed Usage Tracking dashboard
• Worked on Performance tuning in order to reduce query response time for reports
• Conducted user training

Confidential, Houston, TX

Oracle BI Architect/Senior Developer

Responsibilities:

• Customized OBIEE/OBIA Repository for Financial, HR, Procurement, and Project Analytics
• Developed Custom Dashboards and Reports
• Validated the dimensional model by performing consistency checks, validating logical source tables, logical columns and also validating repository level calculations done in the business model layer.
• Modified OOTB Informatica ETL mappings per user requirements
• Configured DAC to run full and incremental loads
• Imparted custom User Training

Confidential, Dallas, TX

Oracle BI Architect/Senior Developer

Responsibilities:

• Designed and configured 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
• Designed and developed ODI interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Developed ODI packages, scenarios using interfaces and variables.

Confidential, Austin, TX

Oracle BI Architect/Senior Developer

Responsibilities:

• 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/OBIA RPD in OBIEE 11g to accommodate Confidential 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, Dayton, OH

Oracle BI Architect/Senior Developer

Responsibilities:

• 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, Saginaw, MI

Oracle BI Architect/Senior Developer

Responsibilities:

• 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, the Woodlands, TX

Oracle BI Architect/Technical Lead

Responsibilities:

• 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, Houston, TX

Oracle BI Architect/Technical Lead

Responsibilities:

• 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, Houston, TX

Senior Siebel Analytics Developer

Responsibilities:

• 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 Confidential 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, Consumer, TX

Siebel Analytics Developer

Responsibilities:

• 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, Houston, TX

Siebel CRM Developer

Responsibilities:

• Designed and developed Smart Scripts to support multiple campaigns for Confidential &T (formerly SBC); the scripts were designed to create orders during the call flow
• Coded using Siebel VB Confidential 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
• Configured 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
• Developed Response and Sales output file processes
• Enhanced application functionality by writing scripts using both Siebel eScript and Siebel VB in Application Object, and in various Business Components, Applets and Business Services
• Developed process for loading data from text files to Siebel database using EIM, SQL Loader and PL/SQL Procedures
• Integrated Siebel with external pricing Application developed in Visual Basic
• Designed and developed Workflow Processes to transport data to Third-party Verifier’s external application