PROFESSIONAL SUMMARY
Accomplished OBIEE developer with over 6 years of experience in complete software development life cycle (SDLC) implementation of various Business Intelligence and Data Warehouse/Data Marts, including gathering business requirements, proof of concept, GAP analysis, design/modeling (Star and Snow flake), development, implementation and documentation (Oracle AIM).

• Experienced in configuring interactive Dashboards with drill-down capability by making use of Filters, OBIEE Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Folders, Reports)
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Designed and developed OBIEE metadata repository(.rpd) using Oracle BI admin tool by importing the required objects (Dimensions, Facts and Aggregates) with constraints into physical layer by employing connection pool, developing multiple dimensions and Logical and Facts measures objects in BMM Layer, and developing web catalog in presentation layer
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Caching
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents and embedded content, such as images, text, charts, and tables
• Implemented security by creating roles and web groups, checks with external tables and LDAP
• Administered various OBIEE environments with large number of users and provided optimum system uptime and performance; designed security matrix, configured authentication and authorization architecture, and provided permissions to users according to their role
• Experience in developing OBIEE repository from scratch in past projects; developed 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 Answers/Dashboard; troubleshot various technical issues and bugs
• Expertise in debugging, optimizing the performance tuning of OBIEE repository and dashboards/reports
• Expertise in bridging gap between IT and business to exchange ideas, resolve outstanding issues and rolling out innovative and strategic reporting roadmaps utilizing key performance Indicators (KPIs) and business performance metrics
• Did configuration of NQSCONFIG.INI file for usage tracking
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters
• Employed OBIEE Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users
• Good understanding of dimensional modeling and relational database management systems
• Developed effective working relationships with Business Analyst to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively managed business expectations
• Strong analytical, interpersonal, problem solving, written and communication skills

Confidential, PA03/2011 - Present
Sr. OBIEE Developer

• Used OBIEE 11.1.1.5Administration tool to develop and enhance meta-data.
• Extensively worked on building the Data warehousing Model by designing and implementing various methodologies.
• Interacted with business representatives for gathering the reports / dashboards requirements and to define business and functional specifications.
• Designed project scoping with other consultants to understand the project.
• Involved in sessions of Data mart designing and analyzed the best source systems to get the required feeds as per user requirements and created BID documents for mainframe systems.
• Involved in data profiling to make sure the feeds satisfy the business requirements.
• Designed and developed the Metadata Repository (.rpd) 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 and facts / measures objects in Business Model Layer, and creating the presentation catalogs in Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed schema / diagrams using fact, dimensions, physical, logical, alias and extension tables.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports.
• 'Dashboards' were generated to provide insight into the financial data and tested the reports which migrated from Siebel and OBIEE 10.1.3.2 to OBIEE 11.1.1.5.
• Involved in working on level based data metrics and aggregation tables.
• Created different types of customized reports (drilldown, aggregation) to meet client requirements.
• Built business model and established relationships and foreign keys (physical and logical) between tables.
• Developed custom reports / Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed many reports / dashboards with different analytics views (drill-down, pivot table, chart, and columnselector, tabular with global and local filters) in OBIEE 11.1.1.5.
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Implemented security by creating roles and web groups, checks with database authentication.
• Performance tuning of dashboards / reports and made changes to database by implementing the aggregation table and Cache management through event pooling table.
• Created HLD, LLD, unit test case and technical architecture documents.
• Performed production supports on existing dashboard requests including making enhancement, changes, and add-ons functionalities of the dashboard report.
• Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems and made corresponding changes to the repository.

Environments: OBIEE 11.1.1.5/10.1.3.2, InformaticaPowerCenter 8.1.1, Oracle 10g, Win XP, Win 7, TOAD.

Confidential, PA 09/2009 - 02/2011
OBIEE Developer

• Worked with business people for gathering requirements; identified Analytics Report requirements
• Worked extensively on OBIEE/Siebel Analytics Siebel Analytics Web/Presentation Services, Answers, and Interactive Dashboards and Security implementation
• Configured and extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, performing Gap Analysis, identifying dimensions (type-1, type-2 and type-3), facts and aggregate tables, Measures and Hierarchies
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer
• Configured charts, pivot table views, filters in user interface; configured Global Filters and Prompts in Siebel Analytics Web
• Developed aggregated fact tables using the content tab and fragmentation
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Implemented security by creating roles and web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Involved with the testing team to resolve, fixing and testing problems found during the Systems integration test, UAT phases.

Environment:OBIEE 10.x, InformaticaPowerCenter 8.1.1, Oracle 10g, PL/SQL, TOAD, UNIX Shell scripts, UNIX

Confidential, Warren, NJ04/2007 - 08/2009
OBIEE Developer

• Proven ability to strategically plan, lead, inspire and mentor project team.
• Worked on MUD and with multiple project teams.
• Interacted with case services management business representatives for gathering the reports / dashboards requirements and to define business and functional specifications.
• Extensively worked on general ledger, summit, trading activity, foreign exchange, cash flow subject areas.
• Extensively worked on KPI's and data metrics and generated reports depending on user requirements.
• Involved in working on level based data metrics and aggregation tables.
• Involved in gathering and analyzing the user requirements in coordination with business and identified facts, dimensions, and grain of the dimensional modeling.
• Also prepared the requirement specifications document based upon the background study and research.
• Worked extensively on Dimensional hierarchies.
• Designed and developed the Metadata repository (.rpd) using OBIEE administration tool by importing the required objects (dimensions, facts and aggregates) with integrity constraints into physical layer using connection pool, developing multiple dimensions (drill-down hierarchies), logical and facts / measures objects in Business Model Layer and creating the presentation catalogs in presentation layer.
• The data was imported from different sources and after applying business rules, the required presentation catalogues were created.
• Analyzed and validated the business model in OBIEE administration tool by performing consistency check, validating logical source tables (LTS), logical columns, and also validating repository level calculations done in the business model layer.
• Implemented time series measures to have chronological analysis of the business.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created the High Level Design Document (HLD) and Technical detailed design document (TDD) of Repository and Webcat (reports / dashboards).
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Worked extensively on the SA_SYSTEM tables and USAGE Tracking.
• Implemented both object level and row level security based on roles and responsibilities.
• Configured out-of-the box as well as custom analytics / dashboard reports using BI answers.
• Created reports for each department using different analytics views (pivot table, chart, table, and gauge).
• Extensively worked on procurement analysis for the bank and also created reports and dashboards on procurement.
• Worked on migrating the reports from Oracle EBS Discoverer to OBIEE.
• Migrated couple of subject areas from Oracle EBS Discoverer to OBIEE.
• Extensively worked on stored procedures, triggers, views and functions.
• Also worked with database administrator in upgrading OBIEE to newer version by implementing patches.
• Implementing report level business logic using function editor.

Environments: OBIEE 10.x, Informatica PowerCenter7.1/8.1.1, Oracle 9i/10g, Win XP, UNIX, MS Office.

Confidential, NJ 05/2005 - 02/2007
Siebel Analytics/ETL Developer

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document business requirements
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Designed Metadata Repository - physical layer, business mapping and model layer, and presentation layer.
• Created initialization blocks and system session variable for security using external table authentication.
• Worked extensively on Siebel UI (Siebel answers, delivers, and dashboards).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics
• Involved in data and object level security in the Siebel administration console.
• Used ETL processes to accommodate changes in source systems and new requirements.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (update strategy, filter, router, expression, lookup and aggregator) for loading data into Data Warehouse.
• Designed and developedUnix Shell scripts, backup/migration of metadata, FTP, sending files to source directory and managing session files.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency.
• Used Workflow monitor to monitor the performance of the jobs.
• Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.

Environments:Siebel Analytics 7.8.5, Informatica 7.x, Oracle 9i.

TECHNICAL SKILLS SUMMARY

• Business Intelligence: OBIEE 11.1.1.5/10.1.3.x
• Data Modeling: Star-Schema FACT and Dimensions, Snow-Flake Schema FACT and Dimensions
• ETL Tools: Informatica9.x/8.x/7.x
• Languages: T-SQL, PL/SQL
• Web Technologies: HTML, XML, JavaScript
• Designing Tools: MS Visio, UML, Rational Rose
• Operating Systems: Windows 2000/2003/2008, UNIX, LINUX
• Scheduling Tools: DAC
• Databases: SQL Server 2008/2005, Oracle 11.1.1.5/10g/9i
• Web Servers: Internet Information Services
• Other Tools: TOAD, SQL Developer