SUMMARY

• Expertise in setting up overall OAC/Oracle Business Intelligence Architecture and in implementing OAC/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
• Expertise in configuring data and object level security
• 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
• Extensive experience in OBIEE Admin activities including migration of objects between environments and modifying configuration files to support expected behavior
• 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
• Experience with OBIEE migration and troubleshooting post migration errors
• 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, Eagle, 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 11g, BI Apps 11g, OBIEE 11g, 12C, Oracle Analytics Cloud (OAC) 105.8, OAC DVD,Siebel Analytics 7.5/7.7,Tableau

ETL: Informatica Power Center 7.x, 8.x, 9.x, DAC 11.1.1.6, ODI 11g, ODI 12C

BI APPs: Sales, Marketing, Financial, HR, Procurement and Spend, Project Analytics

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

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

Operating Systems: Windows, Linux

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, GA

OBIEE Architect/Senior Developer

Responsibilities:

• Interacting with business users to gather business requirements and provide technical solutions
• Building Interactive Dashboards, Dashboard Pages and Reports
• Building BI Publisher Reports
• Building Agents to schedule jobs to deliver reports by email and to deliver alerts
• Helping users with DVD self-service reports with data mash up
• Configuring data and object level security for OAC
• Customizing RPD to support building Dashboards and Reports
• User creation and management
• Migration of catalog objects between environments
• Building ETL mappings SDE, SIL and PLP to load data from target to source
• Performance tuning of Reports

Confidential, Houston, TX

OBIEE Architect/Senior Developer

Responsibilities:

• Collaborating with business users to capture & define business requirements and then design and develop technical solutions that meet business needs
• Migrating from OBIEE 12C to OAC and addressing post migration errors
• Performing configuration and administration activities in OAC
• Customizing metadata for the Physical, BMM and Presentation layers of the OBIA RPD and altering the dimensional model to facilitate reporting while ensuring optimal performance
• Building Interactive Dashboards, Dashboard Pages and Reports
• Creating Action Links to provide navigation between BI content
• Building Agents to schedule jobs to deliver reports by email and to deliver alerts
• Helping users create OAC DVD self-service reports with data mash up
• Applying OAC patches to environments following best practices as necessary
• Configuring data and object level security for OAC
• Creating session and repository variables and using them in RPD and analyses
• User creation and management
• Creation of snapshots in OAC
• Migration of catalog objects between environments
• Building Informatica ETL mappings to source data from multiple sources to EDW and to Target Data warehouse tables
• Configuring Workflows and monitoring DAC to ensure successful full and incremental loads.
• Performance tuning of Reports
• Performance tuning of Informatica mappings
• Creating PL/SQL stored procedures for use in mappings as well as independently for loading custom target tables
• Data sanity check between source and target systems
• Used Jira Kanban boards to track and manage assigned tasks
• Building BI Publisher Reports

Confidential, Irving, TX

OBIEE/OAC Architect/Senior Developer

Responsibilities:

• Identification of violation of best practices in the legacy 10g environment and implementation of fixes for the same in the new installation of 12C
• Designing and Developing interactive dashboards, reports, agents and building subject areas for users to create adhoc reports
• Development and customization of OBIEE/OBIA Repository with multiple data sources including Oracle, DB2 and SQL Server with Siebel as the Data Source
• Building the security model configuring both data and object level security
• Working with Performance tuning of reports
• Performing data sanity checks and validations between the source systems and the data warehouse
• 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.
• Implemented slowly changing dimensions for key fields identified by end users
• Migrating from OBIEE 12C to OAC
• Worked on OAC DVD and helped end users with creation of self-service reports
• Building new ETL mappings in Informatica, sourcing data from multiple data sources and including them in execution plans in DAC
• Used Jira Kanban boards to track progress on assignments
• Creation of Tableau Workbooks using Data blending to gather data from multiple data sources
• Creation of Tableau Dashboards with context filters
• Provided user training to Business Users

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
• 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)
• 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
• 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
• Provided user training to regular and power users

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 Spend, 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
• Customized OBIEE/OBIA Repository for Financial, HR, Procurement and Spend, 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
• 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
• 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 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, 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
• 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, 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
• Conducted User training sessions
• 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
• 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
• Designed and developed 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
• Maintained and supported SmartScripts
• Drew 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