PROFESSIONAL SUMMARY:

• 10+ years of experience as Oracle Business Intelligence Developer (OBIEE 11g/10g and BI Publisher) with successful track record in gathering user requirements, designing, developing and supporting different Business Applications, Oracle Applications R12/11i (E - Business Suite) Consultant, Technical Developer with expertise in Oracle Manufacturing Modules, Financials modules and System Administrator.
• Core competencies include design and development of OBIEE repositories, and building OBIEE Dashboards/Reports, BI Apps and Informatica.
• Over 4+ years of experience in Information Technology designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse applications under different environments. Core focus on Data Warehousing and ETL tools OBIA 7.9.6/7.9.5 Financials, Procurement & Spend and Order Management Analytics.
• Experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Experience in Data Architecture, Data Analysis providing Business Intelligence solutions using OBIA 7.9.6, 7.9.5 upgrades/Siebel Analytics, Informatica (Power Center/Power Mart) with strong business understanding knowledge of Consumer Sector, Financial and Telecommunication domains on VLDB (Very Large Database) environments.
• Strong experience in developing and customizing OBIEE, Reports and Forms using Oracle Reports 6i/4.5/2.5, BI Publisher 5.6.3/5.6.2.
• Experience in OBIEE such as server installations, repository configuration using administration tool across physical, semantic, presentation layers, creation of dashboards and reports, iBots for report scheduling, maintain security administration, cache management, and metadata migration to different environments.
• Experience in data modeling to determine definitions and establish referential integrity of the system.
• Implemented complex aggregation strategies for metadata in semantic layer; created reports in OBIEE Answers / Dashboard and trained the business users / power users to create reports in Analytics Answers and also led them into best practices in managing and sharing reports.

TECHNICAL SKILLS:

Reporting Tools: OBIEE (11.x, 10.x), Siebel Analytics 7.x, Oracle BI apps 7.9.5

ETL Tools: Informatica (Power Center 9.x, 8.x, 7.x), Power Mart, DAC (10.x, 7.x)

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

Operating Systems: Windows 2000/NT/XP/7, Windows Server 2008, UNIX, Redhat Linux

Web technologies: HTML, JavaScript, XML

Tools: Toad, SQL*plus, SQL Developer

RDBMS: Oracle 11g/10g/9i/8i, EXADATA MS Access, MS SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Detroit - MI

Sr. OBIEE & Visual Analytics Developer

Responsibilities:

• Interacted with Business Analyst and business function users in Manufacturing and BI team to ensure that requirements are designed, developed and implemented
• Designed and Developed OBIEE dashboard, score cards and KPI, Dynamic & Interactive dashboards/reports with intuitive summary to detailed drilldown reports, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, bubble-charts), Capabilities split reports for summary & details information, local & global filters and cache monitor, Union reports based on business service requirements
• Developed several reports/dashboards with different analytics views with drill-down/dynamics, CSS, pivot table, chart, column sector, tabular with local and global filters using OBIEE Analytics Web by creating reports to showcase RMA’s Shipped Quantity’s for MTD, YTD, QTD etc.
• Worked on OBIEE 11g tool evolution and recommendations.
• Configured OBIEE Components for reports performance tuning.
• Implemented security by creating users & groups, setting up External table Authentication, creating session variables & Initialization blocks and associated catalog objects and web modules with the created groups.
• Participated on RPD data modeling
• Developed unit test cases, scenarios and scripts to validate functionality of Business Intelligence dashboards and provide ad-hoc analysis
• Conducted unit and system integration tests for project solutions and fix bugs
• Provided on-demand action in order to support BI Production needs
• Contributed and developed dashboards to BI Proof of Concept solutions
• Analyzed and resolve data discrepancies, performance issues, defects and bugs
• Adapted to changes in the project plan and business service requirements
• Deliver business service requirements by following Agile/SCRUM methodologies
• Followed SDLC and Change management and document the procedures on reporting and BI solutions to meet the SOX Compliance

Environment: OBIEE 11.1.1.7.14/11.1.1.6.8/ 11.1.1.5/ 10.1.3.4.1, Oracle 11g, RedHat Linux 5.x, Windows Server 2007, Toad Client, Informatica Power Center 9.x, SQL Developer 4.02, File Zilla, Putty

Confidential, Philadelphia, PA

Sr. OBIEE Developer/Analyst

Responsibilities:

• Responsible for design and development of interactive business operational reports, scorecards, KPI dashboards, and automated reports used for measuring productivity and performance.
• Designed and developed many dashboards/reports that are dynamic & interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, bubble-charts). Capabilities split reports for summary & details information, local & global filters and cache monitor.
• Developed several reports/dashboards with different analytics views (drill-down/dynamics, CSS, pivot table, chart, column sector, tabular with local and global filters) using OBIEE Analytics Web by creating real-time customer call volume reports to handle better IVR (Interactive Voice Recording).
• Developed complex reports by using the different views like Table, Pivot, Chart, Column Selector, View Selector and Combined with similar requests.
• Used repository, session and presentation variables to obtain user requirements and generate reports.
• Created complex reports using time series functions to show data for (T-7,T-14 & T-30).
• Enhanced performance by requesting aggregate tables, indexes and managing cache after benchmarking performance-tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Provided full-lifecycle support for migration efforts from development to QA to production analytics
• Worked on end-to-end SDLC process.
• Delivered s by creating and providing documentation to end-users.
• Configured Oracle BI Scheduler configuration for alerts/iBots.
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Generating the results in Toad by using the SQL generated behind the report in order to determine the behavior of the generated report in OBIEE.
• Created documents associated with the dashboards & reports.

Environment: OBIEE 11.1.1.7.1/11.1.1.6.8/ 11.1.1.5/ 10.1.3.4.1, Oracle 11g, RedHat Linux 5.x, Windows Server 2008, Toad Client, Informatica Power Center 9.x, File Zilla, Putty.

Confidential, Los Angeles, CA

Sr. OBIEE Developer/Analyst

Responsibilities:

• Designed and developed the OBIEE metadata repository (.rpd) using OBIEE Admin tool by importing the required objects (dimensions and facts) with integrity constraints into physical layer using connection pool, developing multiple dimensions (Drill-Down Hierarchies) and logical & Facts/Measures objects in business model layer, and creating Presentation catalogs in presentation layer.
• Designed the Logical Table Source for the Logical tables in the Business Model Layer to support the structure of the RPD for generating the desired reports.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Implemented security by creating roles & web groups, checks with LDAP.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Used many Repository, Session and Presentation Variables to obtain the user requirements and generate the reports.
• Developed various Analytical and Operational OBIEE Reports/Dashboards with different Analytics Views (Drill-Down/Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Presentation Services.
• Responsible for setting up the framework architecture from front end perspective from high level to detail level reporting that include page/dashboard prompts, local/shared filters etc.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on Siebel Answers to build OBIEE Interactive Dashboards with drill-down and drill through capabilities.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Cache management.
• Involved in developing complex ETL process.
• Remediating the generated reports according to the feedback received from the end-users and FDIC to populate the data records in case of change in requirements.
• Generating the results in Toad by using the SQL generated behind the report in order to determine the behavior of the generated report in OBIEE.
• Extensive use of the MUD Environment for making online changes in the RPD in parallel with the Development team using the Check in Checkout and Merge functions.
• Migrating the reports from the different environments such as the Local, Development, testing and Production using the Webcat reports through Catalog Manager.

Environment: PeopleSoft 9.1 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 11.1.1.5/ 10.1.3.4.1, Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, DAC 10.1.3.4.1, Toad, Linux, File-Zilla.

Confidential | New Jersey

Sr. OBIEE Solution Consultant/Business Analyst

Responsibilities:

• Configured OBIEE 10.1.3.4.1 in Development, Testing & Production.
• Implemented Security by creating roles & web groups with External Database Authentication to set object level and row level security based on roles and responsibilities.
• Performed the detailed design of Reports/Dashboards using OBIEE Answers and Webcatalog, Analytical Data Model (Metadata/.rpd) and performed Fit/Gap Analysis
• Configured Multiuser (MUDE) for development users to work on the same subject area in the repository
• Created Session Variables for prompts to filter results based on user logins and user selection.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Created custom Skins & Styles for dashboards based on user logins.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Wealth Management Queries (Reports, Dashboards, Security and Star schema).
• Developed 5 Dashboards/40+ Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes.

Environment: Oracle Business Intelligence suite 10.1.3.4.1, Informatica 8.x, Oracle10g, Toad 9.7, UNIX, UNIX Shell Scripting, Putty, File- Zilla, Windows XP

Confidential | Twinsburg, OH |

OBIEE Developer/Business Analyst

Responsibilities:

• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Built the Physical Layer/Business Model and Mapping Layer/Presentation Layer of a Repository by using Star Schemas.
• Experience using Briefing Books and Bi Cluster Controllers
• Added Aggregate measures using Aggregate Persistence Wizard.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level.
• Upgraded RPD, Web catalog from OBIEE 10.1.3.4.0 to 10.1.3.4.1

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.3, Siebel Analytics 7.8.4, Oracle 10g, Teradata, Informatica PowerCenter 8.7, Toad, Win XP, UNIX.

Confidential | NJ |

Siebel Analytics Solution Design Engineer/Business System Specialist

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design of Reports/Dashboards and Analytical Data Model (Metadata/.rpd).
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.,
• Implemented Security by creating roles & web groups, External tables and LDAP.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Aggregator, sequence, look up, expression, filter, Joiner, Rank, Router, Sequence generator, Update Strategy transformations used in this populating data process.

Environment: OBIEE 10.1.3.X, Oracle 10g, DAC, Informatica PowerCenter 7.x, Microsoft Windows Server 2003 and XP.

Confidential

Siebel Analytics /OBIEE Developer

Responsibilities:

• Involved in Installation of OBIEE on AIX and Windows environment and also configured BI Server.
• Developed The OBIEE Metadata Repository Model that involves creating the Physical, Logical (BMM) and Presentation Layer.
• Created hierarchies, variables, time series objects, joins, aggregate navigation and event poll strategies in the repository.
• Created various Dashboards based on the subject areas that were used for managerial decisions and created various Reports in multiple views (Pivot Table, Charts, Tabular, View Selector), configured Global Filters and Prompts. Configured implicit fact columns, Bridge & Helper tables.
• Performed Performance Tuning of Dashboards/Reports by implementing strategies like aggregate navigation, cache management, materialized views.
• Administered NQSConfig.ini and Instanceconfig.xml configuration files.
• Used BI Server as data source for loading data into custom tables and integrated them using ODI and JDBC driver of BI Server.
• Worked with other developers on a repository in a MUDE environment.
• Configured iBots to deliver Analytics content and automated iBot queries for daily and weekly reports.