Summary:

• Over 6 years of work experience in the IT, acquiring both technical and functional skills
• Over 5 years' experience in Business Intelligence projects that span the full life cycle implementation of OracleBusinessIntelligence (Siebel Analytics), Informatica and DataWarehousing
• Expertise in building repositories, developing Subject Areas, and applying security at object and data level in Administration Tool
• Strengths include Seibel Analytics development and Administration, attention to detail and problem solving
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE
• Expertise in creating complex reports in Answers using various views
• Extensive experience in creating iBots and scheduling them using delivers
• Designing the report layout templates in the BI Publisher
• Extremely strong in OBIEE Metadata development
• Expertise in OBIEE DAC configuration
• Strong understanding of data modeling and dimensional modeling, and designing Kimball'sStar and Snowflake schemas
• Good at understanding business requirements and translating them into data warehouse dimensional modeling
• Significant experience with ETL/Data Integration using tools such as Informatica
• Expertise in analyzing business issues and providing possible reporting solutions to end users
• Expertise in providing end-to-end user training and support and provided detail documentation
• Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi site development

Technical Proficiencies:

Reporting Tools

OBIEE 11.1.1.6,OBI EE 10.x (Administration Tool, Analytics, Answers, Dashboards, Delivers and BI Publisher), BI APPS 12.1.2, Hyperion OBI SE 10.x (Discoverer) and Siebel 7.x (Administration Tool and Analytics)

ETL

Informatica (Power Center 8x/7.x/6.x), ODI

RDBMS

Oracle 11g/10g/9i, MS SQL Server 2000/2005, MS Access, Teradata and DB2 UDB 9.x/8.x

Languages/ Technologies

SQL, PL/SQL, HTML and XML.

Operating Systems

Windows XP/2000/NT 4.0/Vista, UNIX, Sun Solaris and Linux.

Tools

Erwin 4.0, Oracle JDeveloper 11g/10.1.3.3, Autosys, Tidal Enterprise Scheduler, and MS Visio.

Education:

Bachelors of Science in Information Technology

Professional Experience:

Client: Confidential, VA Aug' 10 - Till' Date

Role: OBIEE Specialist/BA

National Industries for the Blind provides opportunities for economic and personal independence of persons who are blind, primarily through creating, sustaining and improving employment.
------------
Environment: OBIEE 10.1.3.2.1/ 11.1.1.6, Oracle EBS12.1.2, BI Applications 7.9.4(Financial analytics, Order Management), Oracle 10g/11g, SQL Developer, SQL Server 2005 and Windows 7

Responsibilities

• Gathered the requirement from user through meetings, understanding the business from end user technical perspective and preparing a functional design document.
• Involved in integrating OBIEE with Oracle E-business suite
• Involved in Migration of OBIEE 10g to 11g
• Worked with business and finance stakeholders to develop BI Portals and reporting solutions
• Conducted project planning and work estimations
• Created an Logical Star Schema in OBIEE
• Independently Designed and developed subject areas in the RPD
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates)
• Define appropriate joins, calculations, dimensions and measures in the repository
• Wrote Custom SQL Codes (Views) for the reports
• Created and customized various Reports and Dashboards for various user groups
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Developed and scheduled iBots for delivering personalized reports to users on time
• Migrated RPD and Catalog from DEV to TEST to PROD
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository
• Managed security privileges for each subject area and dashboards according to user requirements
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables
• Created Materialized Views to improve the performance of the reports
• Applied Patch
• Created user manuals and troubleshooting guides
• Responsible for supporting and enhancements of OBIEE
• Trained End Users to Build Ad Hoc Reports using OBIEE

Client: Confidential, Cleveland, TN Aug'09 - June'10

Role: OBIEEReport Developer

A high performance, integrated application for companies in the deferred-deposit market and financial technology solutions that drive customer relationship management, electronic banking, and electronic funds transfer and card solutions
Environment: OBIEE 10.1.3.4.1, Oracle 10g Windows 2003 Server and Linux.

• Participated in the installation and configuration of Oracle BI EE in the windows as well as the Linux environment
• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details
• Involved in the detailed design of the reports/dashboards and data model.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Worked Extensively on Siebel Answers to create reports as per the client requirements.
• Developed custom reports using Seibel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local Filters.
• Implemented the delivery of iBots using Oracle BI Delivers to alert the associated teams and Agency personnel also used iBots for CacheSeeding and Cache purging.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data LevelSecurity for Region and Product dimensions, using Session Variables.
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.

Client: Confidential, CT Oct'08 - June'09

Role: Oracle BI Analyst.

Confidential, Company provides innovative health benefit plans, dental and vision pharmacy benefits management services. This project was intended to implement OBIEE and to develop reports for Financial Department.

Environment: OBIEE 10.1.3.2.1, HR Analytics, BI Publisher, Oracle 10g and Windows 2003 Server

------------Responsibilities

• Gathered and analyzed reporting requirements for the claims and payment departments
• Involved in Data Modeling,Design Documents, and data warehouse
• Conducted project planning and work estimations
• Responsible for supporting and enhancements of OBIEE
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Created an Logical Star Schema in OBIEE
• Independently Designed and developed subject areas in the RPD
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates)
• Define appropriate joins, calculations, dimensions and measures in the repository
• Migrated and moved Webcat files to obiee using saw migrate tool
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository
• Created and customized various Reports and Dashboards for various user groups
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative)
• Developed and scheduled iBots for delivering personalized reports to users on time
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels
• Created report templates using BI Publisher
• Developed BI PublisherReports and published them on dashboards
• Integrated BI Publisher with concurrent manager within Oracle E-business suite
• Configured Repositories on XMLDB on file systems
• Extracted data from multiple Databases in the same report
• Created Reports using BI Publisher for Word, Excel and Pdf
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables
• Created user manuals and troubleshooting guides
• Trained End Users to Build Ad Hoc Reports using OBIEE

Client: Confidential, IN Aug'07 - Sep'08
Role: Siebel Analytics Lead

SBC-Ameritech provides local telephone/data services in mid-west region. This project was intended to develop reports for the Human Resources Department.

Environment: Siebel Analytics 7.8.2, OBIEE 10.1.3.2.0, HR Analytics, BI Publisher, Informatica Power Center 7.1.3, Oracle 10g, Teradata and Linux

Responsibilities

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE
• Upgraded and migrated Siebel repository (.rpd) database from Siebel Analytics7.8.2 to OBIEE
• Designed and build Starschemas
• Configured repository (RPD) to use the LDAP authentication
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer
• Defined dimensions and facts in the subject areas
• Involved in migration of reports from production to testing using Webcat
• Implemented OBIEE security for users and groups in administrator tool
• Created report templates using BI Publisher
• Developed BI PublisherReports and published them on dashboards
• Integrated BI Publisher with concurrent manager within Oracle E-business suite
• Configured Repositories on XMLDB on file systems
• Extracted data from multiple Databases in the same report
• Created Reports using BI Publisher for Word, Excel and Pdf
• Created reports by applying views, filters, calculations and conditional formatting in answers
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Created and scheduled iBots as per the business requirements
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process
• Applied Optimization techniques and tuned performance of the reports
• Provided technical and user documentation and training

Client: Confidential, Manhattan, NY Mar'06 - July'07
Role: Siebel Analytics Developer

Confidential, is an online emerging markets information service. It aggregates and produces unique content including full-text news articles, financial statements, and company information. This project was intended to work on Sales and Marketing Department.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL and Windows 2000

Responsibilities

• Gathered and refined requirements from the business users
• Installed and configured Siebel Analytics
• Configured the Siebel Analytics repository (rpd) to implement organization wide data-level security
• Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer, and created customized user views and set up catalog folders in the Presentation layer using administrator tool
• Developed Star schema as per business requirements
• Designed and Developed new subject areas/ Customizations.
• Interacted with users, developed and maintained Reports and Dashboards
• Resolved application issues faced by users
• Configured Analytics Dashboard HTML style sheets to meet reports layout requirements
• Configured Analytics iBots and the Scheduler
• Responsible for Daily/Weekly/Monthly on time report delivery to the end users
• Developed front end reports
• Configured report level security and user interface designs
• Applied Optimization techniques and tuned performance of the reports
• Implemented caching to improve performance