PROFESSIONAL SUMMARY

• Around 8 years of extensive experience in Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Reporting on Windows and UNIX platforms.
• Expertise in configuring Interactive Dashboards with drill-down capabilities and drill-across capabilities using Dashboard Prompts, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization and setting up a Multi-User Development Environment MUDE .
• Experience in complete Software Development Life cycle SDLC including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc.
• Experience in Oracle BI Apps that include OBIEE, ETL Tools and in Banking, Financial and Insurance domains.
• Involved in Data Modeling techniques like normalization, denormalization,Star Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server, DB2, Flat Files and XML Files into ODS Operational Data Store and EDW Enterprise Data Warehouse systems.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Involved in fixing bugs in production environment and was a part of the production support team.

TECHNICAL EXPERTISE

PROJECT EXPERIENCE:

Confidential

Role: OBIEE Developer

Responsibilities:

• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Created Views and alias for complex queries in the physical layer of OBIEE 11g in order to improve the performance of the reports and to implement complex reports.
• Creating, Monitoring and verification of the ETL code.
• Created hierarchies to allow for drilldowns on time scale and region scale.
• Creating aggregate tables such that it allows for drilldowns in the OBIEE reports combining various measures to improve performance.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary. Created the mapping documents based on the data model and the client requirements.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and Scheduling AGENTS IBOTS in OBIEE 11g.
• Involved in meetings/interviews with users, BSA's, and data analysts, and examined the business, functional and technical requirement documentation for developing the repository and extraction of reports.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Using the Cache Seeding option to increase the performance of dashboards.
• Migrated repositories and catalogs from Dev environment to QA and Production environments.
• Upgraded 10g Repositories into 11g.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Developed and debugged many Dashboards using different Analytics Views Pivot, Table, Chart, and Column Selector, View Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Built reports with action links
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Created Initialization Blocks, Repository and Session variables.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, Creating Indexes etc.
• Used TOAD/SQL Developer/PLSQL Developer to develop Oracle PL/SQL, DDL's and Stored Procedures

Environment:Oracle Data Integrator 10.1.3.5, Oracle Business Intelligence Suite OBIEE 11.1.1.7/11.1.1.6, Oracle 10g/11g, BI Publisher, TOAD, SQL, SQL Server 2000/2005, Windows 7, Unix, Linux and Windows 2003.

Confidential

OBIEE developer/Admin

Responsibilities:

• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
• Prepared Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Upgraded Discoverer and OBIEE 10g Reports to OBIEE 11g 11.1.1.6 .
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Created init blocks, session variables and used them in front end to set these variables.
• Involved in taking backups of Repository and Web Catalog files.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created new Repositories/Subject areas and merged the same with different environments which are Development, Test, Stage and Production using Subversion.
• Created users and granted permissions using BI Admin tool.
• Involved in Performance Tuning in BI by implementing aggregate navigation and cache management.
• Configured Security at the repository level, Catalog level the OBI Application level.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Developed Ad-hoc and standard Reports/dashboards with different Analytics Views Drill Down, Drill across Cascading Style sheets, Pivot Table, Chart, Column Selector and Tabular With Prompts, Global and local Filters, Contextual Navigation, Business rules with user identity and role within the OBIEE suite.
• Worked in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.

Environment:OBIEE 11.1.1.6/OBIEE 11.1.1.5 BP2, Linux, Windows 2008,SQL Loader, TOAD, Informatica 9.5.

Confidential

OBIEE Developer

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Worked on UNIX/LINUX operating systems.
• Designed and developed the OBIEE Analytics Metadata Repository .rpd using OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports pivots, charts, tabular using global and local filters.
• Customized Dashboard reports using drill-down capabilities.
• Integrated BI Publisher with OBIEE. Created Templates ,Reports and Prompts in BI Publisher
• Created and used Delivers and iBots extensively.
• Extensively used ETL to load data from multiple sources to Staging area Oracle using ODI.
• Created Interfaces, Procedures, and variables in ODI.
• Imported knowledge modules for work flow and customized them according to the requirements.
• Involved in developing testing documents, including Estimates, Test Strategy, Test Plan, Use Cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.

Environment:OBIEE 10.1.3.4.0/10.1.3.4.1, BI Publisher, Toad, Windows XP, ODI, PL/SQL.

Confidential

OBIEE/ETL Developer

Responsibilities:

• Studying the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identification of various Data Sources and Development Environment.
• Was involved in Data modeling and design for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Oracle Business Intelligence Enterprise Edition OBIEE Configuration - Installing, Configuring and Administration of OBIEE Repository, Presentation services, BI Scheduler and Publisher.
• Created and configured Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using Power Center / Power Connect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Worked on Toad for Oracle.
• Created PL/SQL packages, Stored Procedures for data transformation on the data warehouse
• Performance Tuning OBIEE/OBI Apps/Informatica / Dashboards / DAC/Reports.
• Analysed and Fixed OBIEE application performance issues to render faster reports and Dashboards.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings
• Usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.

Environment: OBIEE 10g, Informatica Power Center 7.1, Informatica Power Exchange, DB2, Oracle 10g,Toad, UNIX Shell Scripting, XML ,DAC, Windows NT

Confidential

ETL/OracleDeveloper

Responsibilities:

• Assisted in Design of physical logical models using Erwin Data Modeler
• Interface with Sales and Production Management Team to capture and analyze business strategic requirements.
• Developed many mappings / mapplets using various transformations for extract and loading the sales data.
• Created sessions and batches for executing the mappings.
• Involved in the performance tuning of mappings.
• Provided support to report developers in developing the reports.
• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on Server.
• Designed and developed Oracle Monthly Reports.
• Created Materialized views to calculate aggregated data, such as a sum of monthly revenue.
• Developed Database Objects - Triggers, Packages, Procedures and functions.
• Modified, Maintained and Developed the SQL,PL/SQL codes to develop new enhancements
• Develop and maintain the documentation to support the team and business
• Responsible for the fixation of the errors in data as part of testing

Environment: Oracle 9i/8i, SQL Server 2000, Informatica Power Center 7.1, UNIX Scripting Ksh , Sun Solaris 7, Windows XP Professional