SUMMARY

• Software professional with approximately 8 years of extensive experience providing business solutions in the areas of Business Intelligence, Data warehousing, Data Analysis and Application Development.
• Capable of developing end to end Business Intelligence solutions using Oracle Business Intelligence Enterprise Edition (OBIEE), good understanding of Data warehousing and OLAP concepts.
• Extensive Dimensional Modeling experience in Star schema/Snowflake schema design, Fact and Dimension tables.
• Worked Extensively on Oracle BI Administration Tool, Oracle BI Answers, BI Publisher, Oracle Delivers (iBots), Interactive Dashboards and Security Implementation.
• Developed Metadata Repository (.rpd) using BI Server Administration tool by importing the required objects (Dimensions/Facts/Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill - down Hierarchies) and Logical/Facts/Measure objects inBusiness Model Layer, and created Presentation Catalog in Presentation Layer.
• Experienced in building Interactive Dashboards with drill-down and drill-across capabilities using global and local filters, contextual navigation, guided analytics, business rules with user identity roles, profiles and personalization.
• Strong knowledge of OBIEE as a Business Intelligence tool and Data Extraction using Informatica as ETL tool.
• Experience in implementing Oracle BI security setup according to user requirements by setting up group/data access/query privileges, Metadata Objects, Web Catalog Objects (Dashboards/pages/folders/reports).
• Experience working on MAA implementation, using OBIEE clustering/scale Out with multiple servers.
• Good experience in PL/SQL with the ability to develop and test stored procedures, triggers, functions and packages.
• Proficient at interviewing stakeholders and end users, and in translating users’ statements of needed system behavior and functionality into Business and Technical Requirements.
• Worked with Business Analysts/Partners/Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications, Traceability Matrix, Risk Analysis and Integration testing.
• Experience in identifying Test cases and writing Test Scripts, with the ability to communicate with cross platform teams during the Test and pre-production phases.

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2005/2008/2012 , MS Access

Tools: /Utilities: SQL*PLUS, SQLDEVELOPER, Informatica

Agile & PM: Rally for Agile Development, Microsoft Project

Reporting Tools: OBIEE 11.1.1x

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle BI Consultant

Responsibilities:

• Developer and systems admin role in BI team in custom development using OBIEE, Oracle Database
• Configuring and installing OBIEE, Weblogic Server and Database in Unix and Windows platform.
• Modeling of the underlying database into a Star Schema suitable for OLAP analysis using OBIEE
• Wrote various Reports, dashboards, filters, prompts and other artifacts on the presentation layer.
• Created a POC around the mobile dashboard capability introduced in OBIEE 11.1.1.6+
• Translate functional requirements into technical specifications.
• Extended the basic measures in BMM to include complex time series and trend measures
• Identifying performance bottlenecks and tuning queries
• Participate in Design Reviews of Data model and Informatica mapping design.
• Worked on Mapping designer, workflow designer, workflow monitor etc. of Informatica.
• Scheduling OBIEE reports, briefing books and other forms of report delivery to the managers and executives
• Worked on MAA implementation, using OBIEE clustering/scale Out with multiple servers.
• Creating iBots, used Oracle BI Delivers to capture and distribute notifications via multiple channels to a requested user accounts
• Code management and migration using MUD, Catalog Manager and EM among various environments.

Environment: OBIEE 11.1.1.7x, BI/XML Publisher, Informatica, Oracle 11g/12c, OBIEE MUD, SQL Developer, PL/SQL, SQL*LOADER, UNIX Shell Scripting.

Confidential, Durham, NC

OBIEE Consultant

Responsibilities:

• Worked closely with the SME’s to gather business requirements for reports and Dashboards and converted them into functional and technical specifications.
• Coordinated with all stake holders to define the Key Performance Indicators (KPI) for various score boards.
• Coordinated with the infrastructure teams during the data validation phase and deployment phase.
• Designed and developed Metadata Repository (.rpd) using BI Server Administration tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Created Aggregated Tables to improve the Performance of the Reports.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Involved in the Cache management to improve the overall system performance.
• Developed end-user documentation outlining the features and capabilities of various reports with screen shots on how to schedule and execute them.
• Experience in installation and configuration of Informatica Services.
• Development and maintenance of Informatica Repository and OBIEE repository.
• 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 using Answers in OBIEE.
• Worked on MAA implementation, using OBIEE clustering/scale Out with multiple servers
• Created Filters and provided customized prompts appropriately to avoid excessive data showing in reports.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Installed & Configured Oracle BI Publisher to integrate with Oracle BI Presentation Services for Multi-Data source functionality.
• Designed & Integrated BI Publisher Reports to Oracle BI Dashboards for Analysis to PDF/RTF template formats.
• Configured BI Publisher, to extract the data from the source and publish reports.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Identified test cases and wrote test scripts for various Standard and Ad-hoc reports.
• Performed Unit, Integration and performance testing on both Standard and Ad-Hoc reports.
• Coordinated with the teams during the Defect Tracking process.

Confidential, Raleigh, NC

Oracle OBIEE Developer

Responsibilities:

• Interacted with business representatives and business analysts forrequirements analysisand to definebusiness and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• DevelopedOracle BI Metadata repositoryusing BI Administration tool.
• Developed interactiveDashboards and ReportsinOracle BI Answersas per the reporting specifications.
• Defined and createdInitialization Blocks, Repository and Session Variablesfor generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Developed measure for time comparison using time functions,ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• 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.
• Performed thePerformance Tuningof Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Implemented security based onLDAP Authentication.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Created schedulers and developediBotsto deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Createdreport prototypesand presented them to users to get approval.
• Attended weekly meetings with BA and Stakeholders for project status updates.
• Performedunit and integration testingof reports and dashboards.
• Migration from 10.1.13.6

Environment: OBIEE 11.1.1.3/.5 , Oracle 10g, SQL, Toad 9.0, Windows XP.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• UsedSQL loaderto load the data from the files provided by the interfacing applications.
• Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Createdpartitioned tablesandpartitioned indexesto improve the performance of the applications.
• WrotePL/SQL Database triggersto implement the business rules in the application.
• Createdexternal tablesto handle huge volumes of data which is not used frequently.
• Optimized lot ofSQL statementsandPL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for the top management for decision making.
• Implemented all modules logic by usingTriggersandIntegrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Createdmaterialized viewsrequired for the application.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Developed procedures usingDynamic SQL..
• Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
• Developed database objects includingtables, clusters, Indexes, views, sequences, packages,triggers and proceduresto troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.

Environment: VB 6, JAVA, Oracle Database 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.