SUMMARY:

• Around 7 years of experience in implementing Business Intelligence and Data Warehousing solutions for various clients across diverse business segments.
• Extensive experience in the full life cycle implementation SDLC of BI projects that includes: gathering Business Requirements, performing GAP Analysis, Designing, Developing, Testing and Documentation of business processes.
• Extensive experience in OBIEE 11g/10.1.3.4.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, customizing and managing repository and Presentation services Answers, Dashboards Delivers , OBI/Siebel iBots BI Scheduler , BI publisher, BI RPD and Web-catalog administration.
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas and ETL processes that is key to Data Consistency and Integrity.
• Experience in installing, configuring and administering the different versions of OBIEE 11gR1, 10g and Web Logic Server 10.3.5 on Linux and windows environments.
• Expert in developing Oracle BI Repository .rpd which consists of: Physical Layer, Business Model and Mapping Layer, Presentation Layer.
• Expert in developing Interactive Dashboards, Reports with drill-down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, iBots BI Publisher reports.
• Worked with functional analysts and stakeholders to ensure that the respective OBI environments support the implementation plan and future requirements of the business.
• Bridged the gap between IT and business personnel to exchange ideas, resolved outstanding issues and rolled out innovative and Strategic Reporting Roadmaps utilizing Key Performance Indicators KPI's and business performance metrics
• Expert in setting up and managing security in OBIEE 11g, 10g.
• Implemented Data Level Security, Object Level Security and LDAP authentication.
• Upgraded OBIEE 10g repositories into OBIEE 11g environment and resolved migration issues by validating the prompts, data mismatch and formats.
• Experience in setting up Multi User Development MUD environment.
• Expertise in tuning performance by utilizing aggregate tables, materialized views etc.
• Expert in administering, monitoring and scheduling ETL routines using DAC.
• Expert in Supporting implementation and maintenance of reports and dashboards using Oracle Business Intelligence Enterprise Edition on production and development environments for different OBIEE versions.
• Experience in Data Modeling Star, Snow Flake schema using Erwin data modeling tool.
• Knowledge on writing PL/SQL Stored Procedures, Packages, Functions, Triggers and other objects.
• Hands-on experience in QA Life Cycle, includes preparing the Test Cases and Testing the developed programs Unit testing, Integration testing, Regression testing, System testing
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure.
• Followed the industry best practices, adhered and implemented processes that enhanced quality of technical delivery.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Consultant

Responsibilities:

• Worked on High Level Design Solution required for creating OBIEE Metadata Layer RPD .
• Created mapping documents from Source to Target based on the Source System Data Analysis.
• Worked on OBIEE Administration Tool End to End, which includes importing Data, creating connection pools to multiple data sources, developed Physical Layer, Business Model and Mapping Layer and Presentation Layers.
• Upgraded OBIEE 10G to 11G and configuring OBIEE 11g Security integrated with Active Directory.
• Worked on RPD, Creating Level based Hierarchies, Level Based Measures, and time series measures, Creating Aliases, Creating Logical Table Sources, Created Initialization Blocks and Variables, Data Level Security, User Level Security.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in warehouse.
• Implemented data level, Column level and Catalog level security in OBIEE.
• Created BI Publisher reports by using BI answers.
• Worked on Creating Functional Specifications and translating them into Technical Specifications.
• Created complex Analysis reports in OBIEE using the Answers Module
• Created Dashboards, Dashboard Prompts, Navigational Reports, Guided Navigation Reports, Automated iBot Queries, Customized BI Publisher Reports.
• Used Informatica and developed Mappings and Workflows and executed them on multiple sources using various Transformations and loaded the data into targets.
• Worked on DAC for scheduling the ETL jobs
• Used ODI to implement CDC through Journalization Knowledge Modules KM's and to Implement SCD's.
• Used Sql Loader to load data to Oracle tables and Pl/Sql Utilities to download data from tables to files.
• Granted privileges to the ODI users using Security Manager and purged the logs in operator

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Siebel CRM, Informatica Power Center 8.1, Oracle EBSR12, Erwin, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Oracle 11g/10g, ODI 11g,Hyperion Essbase, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

OBIEE Consultant

Responsibilities:

• Gathered the requirement, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers Using Repository Variables, Session Variables and Initialization Blocks.
• Created Aggregated Tables, Logical Tables, Logical Columns with Measures Calculated and Logical Designs, Physical Designs and Star Schemas as per the Business need.
• Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs Designed, Developed and Tested Data security and Dashboard security in OBIEE
• Involved in Application maintenance activities and implementation.
• Created Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges ,
• Configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports
• Created Financial reporting to generate a master report of all cost centers, bursting out individual cost center reports to the appropriate manager.
• Created hyperlinks, generated formatted text files and called stored procedures from Oracle ware house to have up to date data in the reports
• Good knowledge on Calling multiple templates within the template, development of graphs hyperlinks in graphs , left to right flow techniques in BI Publisher.
• DAC was utilized for scheduling of data loads
• Developed Informatica Mappings using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Workflow manager Task developer and scheduling.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Involved in Application performance improvement efforts
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Data conversion and reconciliation of legacy data to Oracle Applications, Customization of reports in AR and creation of stored procedures and Triggers.
• Wrote SQL scripts to create temporary tables and developed SQL Loader control files to load the legacy customers into the temporary tables.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Created/Enhanced Stored Procedures to generate automated testing SQLs
• Developed many PL/SQL procedure functions and used the same in mappings, pre and post sessions.
• Created complex mappings using Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner
• Worked with TOAD to support the daily production activities to analyze data in the table and query the data to transform it as per the requirement.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database, setting the NQSConfig.ini parameters.
• Performed Unit testing and System Integration Testing to Validate the Report.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Informatica Power Center 8.6, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle 11g/10g, SQL,ODI, PL/SQL,sybase and TOAD 6.3/7.0.

Confidential

OBIEE Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details and translate those requirements into a data warehouse design.
• Worked with System Engineering team to design Facts, Dimensions, ERD, Dimensional data model, Data Structures relational and OLAP and Hierarchies of the business model.
• Experienced in working with OLAP cubes.
• Worked with Oracle BI Applications, Oracle BI Publisher to build custom applications leveraging existing data sources and infrastructure.
• Worked with Generation of XML data and Create Upload the Templates in BI Publisher.
• Worked with creating RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Worked with Financial Analytics to perform intra-period balance sheet and income statement analyses to determine on a real time basis how the business is performing and with HR Analytics to provide complex analysis on both the workforce's and the HR department's performance and impact on other areas of the company.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Experience in working with PL/SQL in OBIEE Through a pipelined function.
• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the Informatica jobs in Oracle Business Analytic Warehouse.
• Implemented security by creating users groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day Rpd, Scheduler iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to subscribed users.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Developed Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data into data warehouse.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Worked with dashboard user interface design documents.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Involved in preparing/executing Test scripts, executes Test plans establishing Test Data, and recording defects, assembles and document the results.
• Coordinated the OBIEE .Rpd and Web Catalog objects migration from Redevelopment environment to QA environment and then to the Production environment.
• Experience in working with End users in defining and preparing System requirements.
• Conducted user training to familiarize them to the new reporting environment.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Informatica Power Center 8.1,Data Warehouse Administration Console DAC ,Java Script, Oracle BI Apps, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g,Oracle 11i, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Siebel Analytics Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Developed different kinds of reports pivots, charts, tables using global and local filters.
• Configure Interactive Dashboards with delivers/iBots to alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• 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.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Designed and developed new Aggregates using Informatica ETL processes.
• Developed and tested stored procedures, functions and packages in PL/SQL for data ETL process.

Environment: Siebel Analytics 7.0, Informatica 6.1, Oracle 8i, UNIX, SQL server, Windows NT 2000.