SUMMARY:

• 9 years of IT experience in Business Intelligence and Analytics, Data Warehouse Analysis, Data Analysis, Project Coordination, Business and Systems Analysis in Banking, Financial, Healthcare, Oil Gas and Pharma Domains.
• Currently BI Lead for Data Warehouse-Business Intelligence project at Weatherford International.
• Well acquainted with Software Development Life Cycle. Excellent team player with problem-solving and trouble-shooting capabilities.
• Expertise in OBIEE 11g, Oracle BI Applications and customizing prebuilt mappings and developed technical solutions to business problems in the OBIEE repository.
• Experience gathering requirements from both Business and Technical Users. Experience writing use cases. Strong experience in OLAP Data Modeling using Dimensional Data Modeling using ERWIN.
• Excellent Aptitude in designing Star Schema / Snowflake Schema using OBIEE Administration tool. Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, Fact Dimensions tables, Physical logical data modeling.
• Installing, Configuring and upgrading OBIEE 10g, OBIEE 11g and BI Applications.
• Involved in upgrading OBIEE projects from 10.1.3.4 to 11.1.1.3, 11.1.1.3 to 11.1.1.5 to 11.1.1.7
• Sound understanding of various aspects of ETL Development in Informatica/ODI/Data Stage
• Data warehousing ETL experience using Informatica Power Exchange, Power Center 9.1/8.6. Good Experience on Managing, Scheduling, and Monitoring of Informatica workflows.
• Hands on Experience developing with BI Development in Physical, Business Model and Presentation Layers. Expertise with BMM development - Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Cache Management.
• Extensive knowledge in configuring Interactive Dashboards with drill-down capabilities, Security Setup groups/access privileges , Metadata, Web Catalog Objects Folders, Dashboard, Pages and Reports and Agents iBots .
• Expert in configuring and managing OBI Server, Oracle BI Answers and Dashboards, Agents/iBots, OBIEE plug-ins, BI Publisher and configuration of Analytics Metadata objects.
• Knowledge in dealing with various OBIEE functionalities like Dashboard prompts, views, aggregates, global filters, scheduling, contextual/guided navigation, conditional formatting of reports.
• Knowledge of BI solutions in various domains such as Oracle Financials, Sales, Order Management, Supply Chain, Human Resources PeopleSoft HR Analytics and Health Care integrating ERP Systems like Oracle EBS, PeopleSoft and Siebel.
• Experience in extracting the financial data from Essbase Cubes through Hyperion and leveraging Hyperion hierarchies in OBIEE reporting.
• Working with DAC design and development including Customizing Execution Plan, Subject areas, Task groups and Task definitions.
• Experience with SQL tuning, writing complex SQL queries, triggers and stored procedures.
• Excellent Business Analysis Skills. Expertise creating High Level Requirements Document, Technical Specifications Document, Business Requirements and Traceability Matrix.
• Highly motivated and efficient team player with problem-solving, trouble-shooting and leadership skills

Technical Skills

Professional Experience

Confidential

Sr BI Architect

• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Worked extensively with business users to understand business rules and processes and conducted brainstorming session to gather reporting requirements and specifications.
• Performed gap analysis and feasibility study for the given requirement.
• Worked on Workforce, Learning and Recruitment Modules in OBI Apps 7.9.6.3
• Customized the OTB BI Analytics SDE/SILOS Informatica mappings, RPD objects according to the reporting needs of the Supply Chain, HR, Financial business users.
• Localized the metadata names In RPD and implemented translation lookup tables for Multilingual Data Support as part of Global Integration Project. Customized OTB Row Level Security
• Worked extensively with business users in gathering requirements and specifications. Involved in Business Model Design and development for Enterprise Data Warehouse.
• Worked on OBIEE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Created RPD, Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions Drill-Down Hierarchies Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Integrated Windows Active Directory authentication LDAP with OBIEE.
• Configured Security settings in Oracle Enterprise Manager. Created custom groups, access privileges and query privileges and also managed security for groups in BI Dashboards.
• Developed Dashboards in Oracle Financials, General Ledger, Sales, Supply Chain and Marketing, procurement and spend Modules for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing reports.
• Used OBIEE Delivers to automate Agents iBots queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Experience in extracting the financial data from Essbase Cubes through Hyperion.
• Developed Source to Target Mappings using Informatica Designer and loaded data from source systems like SQL Server and Flat files to target database
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used DAC for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Enhance performance of Financial Module Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Data conversion and reconciliation of legacy data to Oracle BI Applications, Customization of reports in General Ledger and HR Analytics and creation of stored procedures and Triggers.
• Worked on Oracle EBS sources like Oracle 11g, Essbase for getting the financial data.
• Created saved several BI Publisher reports by selecting an Answers request as Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Created comprehensive and easy-to-understand Documentation Functional Specifications, Technical Specifications and Mapping Documents of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema .
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: OBIEE 10.1.3.4/11.1.1.3/.5/.7, OBIEE 10g, Oracle11g, Informatica 9.0.1 , Informatica 9.1, BI Apps 7.9.6.1, DAC, Toad , JDE, Mobile BI developer, BI Publisher, SQL Server 2008, WINDOWS XP/Server 2003, Oracle Linux, Hyperion

Confidential

Sr. OBIEE Lead

• Co-ordinate various BI Projects simultaneously across various teams and locations.
• Closely worked with business users to identify the requirements and worked on GAP analysis documents.
• Designed repository design documents based on the user requirements and modeled RPD using OBIEE Administration tool 11.1.1.6.
• Worked extensively on Management Scorecard for US and Canada.
• Customized and created new OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
• Worked on HR Analytics along with ETL team to develop custom tables and generated reports, as per requirements. Integrate custom Performance Management module with HR Analytics by extending OBIA model.
• Worked closely with ETL team to understand the issues and troubleshoot data issues.
• Co-ordinate with the business and ETL team to load the business data into warehouse
• Designed Star schema for fact dimensional tables and created alias for the dimensional tables. Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Certified Business Intelligence and Data-warehouse tools on Windows 8 with recommend settings.
• Integrated TDS LDAP server with OBIEE across various environments.
• OBIEE tools and extensively with business users in gathering requirements and specifications. Involved in Business Model Design and development for Enterprise Data Warehouse.
• Installed and configured Map Viewer for OBIEE 11g and created Geo-based reports.
• Installed OBIEE 11g Production environment and migrated the VAL repository and web catalog.
• Integrated Informatica Server with DAC and Customized the data warehouses in DAC.
• Created Tasks and Task group and Subject Matter in DAC.
• Co-ordinate with Oracle Support creating Service Requests and resolving various server issues.
• Worked on Forecasting, Med-Ed, Marketing, Sales Operations, Canada BI, IMS portal, Roster, Managed Care BI projects.
• Worked with users to leverage BI through OBIEE office plug-ins.
• Written Test Scripts for BI install and validation processes.
• Provided End-user Trainings on using BI dashboards and creating ad-hoc analyses etc.

Environment: OBIEE 11.1.1.6.x , OBIEE 10g, Oracle11g, Informatica 9.0.1 , BI Publisher, SQL Server 2008, WINDOWS XP/Server 2003

Confidential

BI Lead/Architect

• Worked extensively with business users in gathering requirements and specifications. Involved in Business Model Design and development for Enterprise Data Warehouse.
• Created Repository and OBIEE reports for Enrollment, Claims, Customer Service and Routes
• Worked on the OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
• Designed Star schema for fact dimensional tables and created alias for the dimensional tables when necessary. Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Migration in Development, Testing and Production environment. Provided End User Training and documentation for DWH-BI Project.
• Worked for performance tuning by finding out the bottlenecks in Reports.
• Setup Multi User Development Environment using the Admin Tool for efficient Development.
• Created Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Integrated Windows Active Directory authentication LDAP with OBIEE including the security levels at group level.
• Installed and Configured OBIEE 11.1.1.5 platform on Win Server 2008 and configured for SQL Server 2008 as Data Warehouse
• Used Erwin for designing Logical and Physical Data Models.
• Worked with BI Office plug-in to export analysis to Excel format.
• Implemented Usage Tracking for better administration and auditing purposes.
• Implemented End-2-End report/analytics for RCI in OBIEE 11g for Key Performance Indicators.
• Worked with BI Publisher 11g for document composition and delivery.

Environment: OBIEE 11.1.1.5, OBIEE 10g, ERWIN, OBIEE , ORACLE 11g, Informatica 8.6.1/9.1, Weblogic Server, CSS, JavaScript, PL/SQL

Confidential

OBI Lead

• Serving as BI Lead for EDW/BI initiative with TMG
• Integrating various source systems and customizing the Oracle Prebuilt OBIA 7.9.6 applications to cater the business needs.
• Working as lead in the design and development of Repository, Reports and dashboards.
• Working with business team to get the requirements and converting them into functional requirements
• Integrating OBIA HR, Account Receivables with Disputes, Payments subject areas to cater the requirement of business
• Developed Metadata Repository model based on requirements that involved customizing Out-of-the-box Oracle BI Analytics Applications Repository.
• Redesign Informatica DAC mappings based on user requirements.
• Configured DAC to run nightly data loads on daily basis based on the execution plan.
• Configured new customized mappings and work flows in DAC for customized subject area.
• Managing security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Implemented the OBIEE upgrade process from OBIEE 10.1.3.4 to OBIEE 11g for better support for real time decisions
• Configured iBots/agents to deliver Analytics content based on schedule, automated ibots queries to obtain daily and weekly reports.
• Involved in gathering requirements from End Users and translated requirement documents into Design Documents.
• Worked on OBIA Human Resource analytics and Financial Analytics reports like AR, invoice aging, Past Dues, Billing quality, Open Invoices,
• Rebuilding the existing legacy dashboards exists in OBIA environment
• Working on offshore-onsite model and managing the team and validating/reviewing the work done by the offshore team
• Managing the project plans, estimates, and deliverables.
• Developed OBIEE Repository, Implemented time Series functions, Dimensions, Data and Object level security.
• Developed the RPD's in MUDE, Worked on Repository and Session variables and initialization blocks
• Involvement in application performance improvement efforts
• Configured OBIEE iBots/delivers to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance

Environment: OBIEE 11.1.1.5/10.1.3.4, OBIEE 10g, ERWIN, OBIEE , Informatica 8.6/9.1, Weblogic Server, CSS, JavaScript, PL/SQL, Administration, BI Answers, Dash Board, Deliverables , OBIA 7.9.5, Oracle10g DB, TOAD, DAC, Unix Shell Scripting

Confidential

Sr. OBIEE Developer

• Extensively worked on installing the OBIEE 10.1.3.4. Including the security levels at group level.
• Performed the analysis of BI apps like HR, Marketing, Operations and Ticketing Subject Areas to identify facts, dimensions and hierarchies of dimensions.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports. Customized reports with CSS, JavaScript as needed.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Involved in upgrading the RPD from OBIEE 10.1.3.4 to OBIEE 11g WebLogic Server.
• Involved in the installation and configuration of Oracle Business 11g.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings and worked with integration with Oracle Apps modules like HRMS
• Worked on the OBIEE reports based on the specifications given by the analysts.
• Trained and guided staff for the best practices and OBIEE Architecture.
• Solved many bottle necks on data issues in E-Business Suite/ Oracle Applications.
• Extensively worked and configured Oracle indicators I Phone Application.
• Worked with BI Office plug-in to export analysis to Excel format.

Environment: OBIEE 10g/11g, SQL Server 2008, OBIEE office Plug-in, Windows Server, Informatica 7.1,Siebel Analytics 7.8.5, WebLogic Server, CSS, JavaScript, E-Business Suite, Data Modeling

Confidential

OBIEE Developer

• Created OBIEE Repository .rpd which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management Data level/Object level security , Variables, Initialization blocks and cache management..
• Successfully implemented OBIEE delivers/Created Proactive agents iBots and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Performed the analysis of GL, HR, AP Data marts to identify facts, dimensions and hierarchies of dimensions.
• Used Bottom-Up approach to perform Data Modeling. Created Data models at Physical, BMM and Presentation Layers for OBIEE. Optimized Data models for reporting and aggregate analysis
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created complex reports by using Set operations and direct database request.
• Worked extensively on security for users and groups based on the individual and group responsibilities.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Designed templates and created reports using BI Publisher XML Publisher
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Integration with Oracle Apps specific to Oracle Financials specific to modules of E-Business Suite like GL General Ledger, E-Business Tax etc
• Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Created Several Informatica Mappings to populate the data from Oracle, SQL Server into dimensions and fact tables.
• Involved in upgrading the Siebel analytics web catalog to Oracle BI presentation catalog. Also performed upgrading the existing repository for use with Oracle BI infrastructure.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Implemented Slowly Changing Dimension methodology for accessing the full history of the injured workers.
• Designing mapping templates to specify high level approach.
• Designed and developed UNIX scripts for creating, dropping tables used for scheduling the jobs.
• Designed and Developed PL/SQL Procedures and UNIX Shell Scripts, Data Import/Export and Conversions
• Involved in Unit testing and documentation.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8.5, Informatica Power Center 7.1, Erwin, Oracle 10g, OIC, Oracle R12 TOAD, DAC, MS SQL Server 2005, UNIX , Windows NT, DB2, Oracle SQL Loader, BI Publisher, LINUX, Data Models

Confidential

Siebel Analytics/OBIEE Developer

• Defined additional views narrative, pivot, chart views of the data returned by the request to visualize data in different ways.
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Managed security privileges for each subject areas and dashboards according to user requirements.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
• Installed Analytics Application in Dev, Test and UAT Environments.
• Worked closely with Business Analyst, during the JAD sessions and gathered the Analytics requirements.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.
• Created intelligent bots ibots to send Alert messages to subscribed users.

Environment: OBIEE 10.1.3.2, Siebel Call Center, Siebel Tools, DB2, Informatica 7.1, PeopleSoft, Oracle 9i, Windows 2k

Confidential

Siebel Analytics Developer/OBIEE

• Performed Business Analysis to support the re-design of the Mortgage Asset Management System Worked with major business areas including customer service, escrow and reserve administration, collateral inspection and monitoring, purchase acquisitions Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process Extensively used Informatica for transformation and mapping in ETL process. Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management Conducted interviews with key business users to collect requirements and business process information Developed business requirement specification documents as well as high-level project plan Established business analysis methodologies around the RUP Rational Unified Process . Designed and developed project document templates based on SDLC methodology. Comprehensively performed requirement gathering for enterprise reporting system-using Requisite Pro Designed and developed all Use Cases and UML models using Rational. Worked on upgrading from Siebel Analytics to OBIEE. Used Upgrade Assistant and Crypto tools in the upgrade process. Helped the testing team documenting the system requirements and testing system development Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test UAT . As necessary, assisted with the process of identifying and recommending vendors and assisted with the vendor relationships. Architected the Extract Transform Load process flow from ODS to web tracking tools and reporting applications. Biweekly status reporting with other team project managers involved in this project. Lead the effort of End-to-End QA execution plan and testing of data quality.

Environment: OBIEE 10.1.3.x, Informatica Power Center 7.1.x, TOAD7.x, Oracle 10g, Windows server 2003, XML Publisher.

Confidential

Oracle PL/SQL Developer

• Worked on a trading project for a client to develop an application to trade coal, gas and power.
• Gathered user requirements and created the business requirements documents.
• Documented the technical specification for the reports and tested the generated reports.
• Created and managed Database.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Created stored procedures and functions to be called by the application.
• Created Packages to be called by Visual Basic modules
• Created trading reports using Crystal Reports.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Prepared user manual and technical support manuals.
• Entered static data into the application.

Environment: Oracle 8i, SQL Loader, PL/SQL, Crystal Reports 7, Windows NT.