SUMMARY

• Over 6 years of progressive experience in the IT industry with prime focus on analysis, design, development, customization and maintenance of various Business Analytics in an effective way to deliver leading edge software solutions.
• Involved in all phases of design, development and implementation business Intelligence applications and my areas of expertise include business analysis, dimensional modeling, implementing Business Intelligence analytics solutions using Oracle BIEE 11g (11.1.1.7), Informatica Power Center 8.6.1/8.1.1/7. x/6.x.
• Expertise in Data Warehouse Administration Console (DAC) 11g, 10.1.3.4.1 , 7.x to configure, monitor and schedule ETL and system integration/user acceptance testing.
• Experience in Informatica customization (category 1 & 2) and OBIEE repository customization using the Admin tool according to the business requirements.
• Worked with Informatica PowerCenter Designer to create various mappings and mapplets used for ETL operations.
• Strong skills in requirement gathering, gap analysis, scope definition, disconnected analytics, synchronization, recommendations to business process improvements, development of procedures, forms & documentation, project tracking.
• Experience in debugging the ETL load using Informatica.
• Proficient in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer) using OBIEE Admin tool.
• Expertise in developing OBIEE repositories from scratch, and also many Reports/dashboards with different analytics views (drill - down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters) using OBIEE.
• Experience in implementing Oracle Business Intelligence data level and object level security.
• Expertise in implementing the LDAP, External Table and database authentication in OBIEE 11g.
• Expertise in developing ad-hoc reports and dashboards as per business requirements
• Expert in configuring the delivers and scheduling the reports using the OBIEE Delivers.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Experience in designing the data warehouse using the dimensional modeling techniques.
• Experienced in Installation, configuration, upgrade, migration and administration of OBIEE and Informatica Power Center.
• Extensively used SQL Server to write stored procedures, functions, package and triggers.
• Experience in managing and coordinating onsite/offshore team.
• Ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

• OBIEE 11g
• Administration Tools
• Analytics
• OBIA
• SQL*plus
• Dashboards
• BI Publisher
• MS SQL Server
• DB2
• Teradata
• PL/SQL
• TOAD
• HTML
• ASP
• Set up Agent
• Informatica
• Power Center
• Oracle Database administration console
• JavaScript
• Star Schema Modeling
• Snow-Flake schema Modeling
• Fact and Dimensions Tables
• UNIX
• Windows

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

OBIEE Developer

Responsibilities:

• Gathered requirements from the users and generated reports to help the business to visualize the design
• Used Informatica Mapping Designer to create/update mapping using different transformations required to load data into data warehouse
• Created workflows for full load and incremental loads to be used by DAC
• Developed RPD using BI Administration Tool
• Imported Physical Tables, created Alisa Tables and defined Relations and Keys at Physical Layer
• Designed Schemas/Diagrams by using Fact, Dimensions, Alias and Extension tables
• Created Business Models in the BMM layer and defined Complex Joins and Keys
• Created Dimension Hierarchies, and Level Based Measures at BMM Layer
• Set levels to support Drill-down and Aggregation navigation
• Utilized Aggregation to improve query performance
• Generated corresponding Dashboards and dashboard pages
• Created reports according to user requirements
• Modified Reports and Dashboards by using Report features like Pivot Tables, Charts and View Selector
• Customized Dashboards with Global Prompts, Column selectors, Navigation, and automatic drill-down
• Implemented BI Security using External Table and LDAP for Authentication and Authorization
• Created Users and Groups and added Users to the Groups
• Created Application Roles in Web Logic Console of OBIEE 11g
• Granted the Permissions to the groups by using Repository and Session Variables
• Managed Security Privileges for each Subject Area and Dashboards according to user requirements
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Designed Data Models, Layout Templates in BI Publisher and generated various formats reports
• Involved in post testing stage of the development and responsible for fixing the defects
• Developed highly complex RTF templates for the reports and modified them according to the desired layout
• Set up Agent to deliver reports to the recipients

Environment: OBIEE 11g, Oracle Map Viewer, BI Applications, Informatica, DAC, Oracle 11g, SQL Server, SQL*plus, PL/SQL, TOAD, Windows, UNIX

Confidential, Cheyenne, WY

OBIEE Developer

Responsibilities:

• Interacted with the business users and defined Subject Areas for analytical data requirements
• Configured Physical Layer - Import tables, Create Alisa Tables, Add physical Joins and Keys
• Configured BMM Layer - Create Logical Tables and Columns, Create Logical Joins and keys
• Create Logical Hierarchies, Set levels to support Drill-down, Aggregation / Sum over Columns.
• Created Repository Static and Dynamic variables.
• Created Initialization blocks for Session variables, which are used for authentication and security.
• Developed and debugged many Dashboards
• Reports with different Analytics Views like Table, Pivot, Chart, Static View and Narrative View, Interactive Dashboards with drill-down capabilities using global and local Filters.
• Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Implemented OBIEE Security - Object Level and Data Level Security in the OBIEE Repository and Web) using Repository Variables, Session Variables and Initialization Blocks.
• Implemented the Time Series Function for comparing measures in different time Periods.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/BI Delivers for caching and delivering the reports to subscribed users.
• Designed Data Models and various layout templates in BI Publisher and generated reports in PDF, XLS, RTF, PPT, etc.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Develop Mappings and Workflows to generate staging files.

Environment: OBIEE 10/11g, OBIA 7.9.6.3, Oracle 10g, Oracle data integrator11.1.1, SQL Server, PL-SQL, SQL*plus, TOAD, Informatica, MS-Excel, SQL Server, Windows, UNIX

Confidential, Erie, CO

OBIEE Developer

Responsibilities:

• Participated in gathering and analyzing the Business Requirements
• Configured Repository (RPD) using Physical Layer, Business Model and Mapping Layer and Presentation Layer using the Oracle BI 11g Administration Tool
• Modified the existing RPD according to the requirements
• Imported the required Data into Physical Layer, defined Joins and Keys, and created Alias Tables
• Configured Logical tables/Dimensions, Columns
• Created Logical Joins, Keys and Dimension Hierarchies
• Created Level Based Measures, Set levels to support Drill-down and Aggregation navigation
• Generated Subject Areas in Presentation Layer
• Generated corresponding Dashboards, Dashboard Pages on the Business Analytics
• Created Reports according to user requirements on the Dashboards
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View)
• Created Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Setup the visibility of Dashboards to employees with respect to their responsibilities
• Defined Data Level Security for users based on their groups or responsibilities by using Data Filter
• Tested reports and Set the Logging Level as production
• Used OBIEE Delivers and Agents to send Reports

Environment: OBIEE 10/11g, Informatica, Oracle 11g, SQL Server, SQL*plus, PL/SQL, TOAD, Windows, UNIX

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with the Business analytics to understand the Business requirements, Involved in Designing and Configuration of OBIEE Repository as per Business Needs
• Worked with Oracle BI Administration Tool, making use of the existing physical/logical objects, creating reports based on pre - built rpd.
• Created Alias and configured repository with logical dimensional modeling using star schema.
• Customized dimensional hierarchy in used shared child level when creating the sub level hierarchies.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Configured interactive dashboards by adding embedded content such as links/images, and folders.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters using Analytics
• Implemented Prompts to provide dynamic filter condition to end users.
• Configured repository and session variables to get dynamic reports and dashboards.
• Migrated rpd and merged repositories.
• Implemented RPD level security, Object level security and Data level security in OBIEE
• Extensively worked on Informatica Power Center tools

Environment: OBIEE, Informatica Power Center, Oracle 10g DAC, Toad, MS-Excel, SQL Server, PL-SQL, SQL*plus, Windows, UNIX

Confidential

OBIEE Developer

Responsibilities:

• Participated in gathering business requirements
• Defined subject areas for analytical data requirements
• Developed RPD using BI Administration Tool
• Imported physical tables and defined relations between Physical tables at the Physical Layer
• Created Business Models, Drill down Hierarchies, defined joins and keys
• Implemented logic by creating Level Based Measures at BMM Layer.
• Created Aggregation tables to improve query performance
• Generated dashboards and reports using different views and filters
• Modified existing reports according to the requirements
• Implemented BI Security for Authentication and Authorization
• Created user and groups
• Assigned filters to objects and granted access privileges to users or groups
• Tested and saved reports

Environment: OBIEE, Oracle 10g, Windows, SQL Server, SQL*Plus