Professional Summary

• 6 years of IT experience in Analysis, Design, Development, Implementation and testing of various Client/Server and Data Warehousing Technologies.
• Five years of strong experience on Siebel Analytics/OBIEE in designing Dashboards (Oracle/Siebel), Answers (Oracle/Siebel) and Analytics/Oracle Administration, Scheduler and BI Publisher tool.
• In depth knowledge of source and target table mappings in Siebel Data Warehouse.
• Strong experience in the Siebel Analytics RPD Metadata i.e. Customized Siebel Analytics Repository, defining Physical Data Layer, setup LDAP Authentication, developing Business Model and Presentation Layer using Siebel Analytics Administration tool, developing dynamic and Interactive dashboards with drill down and drill across capabilities, Security Setup.
• Experience in developing Dimensional Hierarchies, New Logical Columns, Filters and Variables as per business requirements.
• Extensive knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, contextual Navigation, Guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Well versed with the Database and Data Warehouse concepts like OLTP, OLAP, Star and Snowflake schemas, RDBMS, Multidimensional Modeling.
• Development of Business Reports, Business Alerts with the help of Oracle/ Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots, Oracle BI Publisher to create reports from multiple data sources.
• Experience with scheduling tool Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse.
• Worked with Siebel developers on Siebel CRM Modules including Siebel Sales, Siebel Finance, and Siebel Marketing.
• Experience in Installation, Configuration and Administration of OBIEE 10.1.3.x, Oracle BI Apps.
• Extensively worked on migration presentation catalog between different environments.
• Assisted in developing Informatica Mappings/Mapplets using various Transformations and Oracle PL/SQL for ETL of data from multiple sources to Data Warehouse.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Experience in working with web based technologies like HTML, Java Script, CSS, AJAX. Excellent skills in creating Business Requirement Document (BRD) and Functional Specification Document (FSD).
• Extensively implemented Data Level Security and Object Level Security.
• Production Support (24/7) and Maintenance of Data Warehouse application. Scheduled ran and monitored the production jobs for successful completion.
• Ability to be flexible, pro actively manage workload, meet aggressive deadlines, organize and prioritize work.

Bachelor of Technology in Computer Science and Engineering

Technical Expertise

OLAP Tools: OBIEE 11g/10.1.3.4/10.1.3.3/10.1.3.2, Siebel Analytics 7.8/7.9, Oracle
Business Intelligence Apps, Siebel Data Warehouse Application
Console (DAC), BI Publisher, Informatica.
Databases: Oracle 11g/10g/9i/8i, MS SQL SERVER 2000/2005/2007, DB2,
MS ACCESS.
Languages: C, C++, Java, VB, SQL, and PL/SQL.
Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX, Vista.
Scripting Languages: JavaScript, VB Script.
Web Technologies: HTML, CSS, DHTML and XML.
Applications: MS Office Suite, SQL Developer, Dreamweaver and Adobe Photoshop.

Professional Experience

Confidential, Round Rock, TX May 11 - Till Date
Sr OBIEE Consultant

Confidential, is a multinational information technology corporation that develops, sells and supports computers and related products and services.
Confidential, has implemented a Human Resource Analytics project in order to have perfect picture of the employee details and their internal organization\'s data. The implementation builds the reports based on the data that is fetched from PeopleSoft systems and HR Direct Systems that are Dell's own employee management systems.

Responsibilities:

• Primary responsibilities included gathering business requirements, designing functional and technical specifications for reporting needs
• Identified Facts and Dimension Levels/Hierarchies of Dimensional model.
• Responsible for installing the HR Analytics module, which is associated with the data from PeopleSoft.
• Customized and developed RPD (Physical, Business Model and Presentation layer), configured metadata objects and Web Catalog Objects.
• Developed many reports/dashboards Analytic views (Pivot tables, Charts, Column Selector, and View Selector) using OBIEE 11g.
• Integrated Informatica Server with DAC and customized data warehouses in DAC.
• Created Tasks, Task Groups and Subject Areas in DAC.
• Developed the Incremental ETL Processes like Mappings & Mapplets using various transformations and Workflows with Sessions/Tasks to pull data from PeopleSoft systems into the warehouse.
• Created Measures and Level Based Measures in Business Model.
• Created Logical Tables and Logical Columns, Physical Columns.
• Created Measures with Logical columns and Physical columns.
• Created Dimension Hierarchies in Business Model and Mapping Layer.
• Used Informatica Workflow Manager to schedule and monitor session status.
• Implemented Slowly Changing Dimensions - Type I and Type II in different mappings as per requirements.
• Created dynamic reports by building custom templates using BI Publisher.
• Performance tuning of Dashboards/Reports and made changes to database by implementing materialized views and partitions, rebuilding indexes.
• Worked on security management for users, groups and web groups using the various authentication systems such as LDAP, OS, Database and Database Table Authentication using Session Variable features, as well as Dashboard/ Report level security.
• Created iBots and delivers to send Alert messages to subscribed users.
• Worked constantly with users, to resolve the production problems by reviewing design changes.
• Performed unit, integration and system testing for all components in OBIEE.
• Documented the design for intuitive understanding and future reference.

Environment: OBIEE 11.1.1.3, Oracle 11g, Informatica 8.6, DAC, OBIA 7.9.6, PeopleSoft 9.1, Windows 7, Windows Server 2003, TOAD for Oracle, BI Publisher, DELL HRDirect.

Confidential, Melville, NY Apr 10 - April 11
Sr. OBIEE Developer
Confidential, is an international electricity and Gas Company and one of the largest investor-owned energy companies in the world. Its main business is the delivery of electricity and natural gas.
Confidential, has implemented a Sales Analytics project in order to have a detailed view of the sales of the company and the statistics of the customers of the company. The main objective of the project is to develop and implement a customer information system by providing a detailed view of the customer data in the form of reports.

Responsibilities:

• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.
• Configured the tables and joins between them in the Data Warehouse.
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Migrate the repository and presentation catalog between different environments like Dev, Test, QA and Maintenance.
• Worked on Configuration & Application Deployment Management.
• Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, and Presentation Layer that came with OBIA and modifying it according to the business requirements.
• Worked on Metadata Repository objects and also Web catalog Objects, which include Dashboards, Reports, Pages and Folders.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Worked on scheduling tool Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Security settings were implemented in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges.
• Configured and Scheduled BI Scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Created templates as required by the client using BI Publisher.
• Created sessions, tasks, and workflows etc. in Workflow Manager.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 10.1.3.3, Oracle 10g, Informatica 8.1, DAC, OBIA 7.9.5, Windows Server 2003, TOAD, BI Publisher, Siebel CRM 7.8, Siebel Call Center 7.7.

Confidential, Healthcare Products and Pharmaceuticals, WI Apr 08 - Mar 10
OBIEE Developer
Confidential, offer products and information targeting baby care, skin and hair care, oral care, nutritionals, pain relief, topical care and much more.
Confidential, has adopted and implemented Oracle Supply Chain and Order Management Analytics to gain detailed insight into orders and inventory data. Thus result into better decision-making and experience improved financial performance and customer satisfaction. Maintaining and managing all possible distribution scenarios including commission payments of Sales Reps. for internal, external and third party clients. The revenue and the number of opportunities in each region are reviewed by the management in form of reports and alerts.

Responsibilities:

• Worked with Business Users, Involved in Discussing and Gathering theAnalytics requirements from different user groups.
• Identify Data Sources & Extension columns - Identify OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP's Physical layer tables/schemas.
• Configured and developed Order ManagementandOrder Fulfillment reportsusing OBIEE Answers and Oracle BI Publisher.
• Worked on Repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used the Security settings in OBIEE Admin Tool to set up users, groups, accessprivileges and query privileges.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, Gauge Views, filter in user interface.
• Configured Global Filters and Dashboard and page Prompts in OBI Web.
• Expertly used the OBIEE add-ins to insert and analyse reports in Word, Excel and PowerPoint.
• Developed new reports and migrated existing excel reports to OBIEE dashboards.
• Configured repository and session variables to get dynamic reports and dashboards.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.
• Configured LDAP server to Authenticate users and implemented both object level and row level security based on roles and responsibilities.
• Hands on experience with DAC in creation ofTasks, Task Groups, Subject Areas, and Execution Plans.
• Experienced in DAC to configure, monitor and schedule ETL routines.
• Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Extensively worked in fine-tuning of Informatica Mappings, Troubleshoot ETL performance issues.
• Created sessions, tasks, and workflows etc. in Workflow Manager.
• Involved with the Testing team to resolve,fixing and testingproblems found during theSystems integration test, UAT Phases.

Environment: Oracle Business Intelligence Enterprise Edition 10.1.3.4, Oracle 11GR1, Informatica 8.1, DAC, OBI Apps 7.9.5, Oracle EBS, Microsoft Windows XP, UNIX, SQL Developer.

Confidential, Jersey City, NJ Mar 07 - Feb 08
Sr. OBIEE Developer
Confidential, Mellon Shareowner Services offers a robust and flexible suite of services designed to meet each client\'s needs. With a deep commitment to accuracy and profound attention to detail, they provide comprehensive administration services for employee stock option, restricted stock and stock purchase plans. As a Sr. OBIEE developer, I worked on the Employee Stock Option Reporting System for BNY Mellon Investor Services. This Project is to convert all the Existing Crystal Reporting System to Oracle Business Intelligence.

Responsibilities:

• Analyzed technical requirements and used metadata designing principles to design repository and followed best practices.
• Identified Facts and Dimensions (with levels & hierarchy)
• Design and Developed repository (.rpd) that consists of physical layer, business model / layers with aggregates & dimensions, presentation layers with catalogs & folders and external table security with session variables using Oracle BI Analytics Administration tool.
• Developed many Dashboards / Reports for providing analytical information using Oracle BI Answers and Dashboards.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.
• Integrated data into Hyperion cubes and helped in the implementation of Hyperion planning application.
• Created financial scorecard reports for the business user with the help of BI Publisher.
• Developed custom reports/Ad-hoc queries using OBI Answers and assigned them to application specific dashboards.
• Security management for users groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
• Trouble shooting the issues related to repository models and report development.
• Maintained extensive documentation for design, implementation and testing OBI reports, Dashboards and Informatica mappings.

Environment: Oracle BIEE 10.1.3.3, SQL Server, SQL, HTML, TOAD.

Confidential, Parsippany, NJ Aug 06 - Feb 07
OBIEE Developer/Administrator
Confidential, objective is to provide existing SMART application to IAD (Individual Annuity Department) users. The IAD SMART Implementation project aims to identify and implement the necessary changes required to the existing SMART system in order to meet the IAD's requirements. NYLIM wants to provide relevant existing functionality with necessary modifications and new IAD functionality.

Responsibilities:

• Worked closely with Business Analyst and analyzed the business requirements for new reports and modifications to old reports for the new IAD SMART application.
• Analyzed the Physical and Business model of SMART and created the new Physical layer, Business model & mapping and Presentation layer for IAD System.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Merged SMART & IAD repositories by creating different projects for each. Worked with all the issues raised during the Merge.
• Customized Oracle BI Warehouse tables in Dev, Test and Production Environments.
• Created Security policies by creating user groups & assigning different users to different groups.
• Customized Dashboards, Administered permissions and privileges for dashboard visibility and modifications to users.
• Configured LDAP server to Authenticate users and implemented both object level and row level security based on roles and responsibilities.
• Trouble shooting the issues related to repository models and report development.
• Maintained extensive documentation for design, implementation and testing OBI reports, Dashboards.
• Involved in unit testing, integration testing the reports generated using OBIEE.

Environment: OBIEE 10.1.3.2, Informatica 7.1, Oracle 9i, Toad.