Summary:

• Over 3+ years of work experience in the IT, acquiring both technical and functional skills
• Over 3 years experience in Business Intelligence projects that span the full life cycle implementation of Oracle Business Intelligence (Siebel Analytics), Informatica and Data Warehousing
• 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
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI/Siebel Analytics .rpd
• Worked on Siebel Analytics features (i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Variables/Initialization Blocks configuration etc.)
• Extracted data from various ERP systems like SIEBEL CRM, Oracle EBS
• 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
• Expertise in creating reports of Oracle EBS using BI Publisher.
• Strong understanding of data modeling and dimensional modeling, and designing Kimball’s Star 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 OWB, and Informatica
• Expertise in Hyperion Essbase to provide access to advanced calculations and aggregated data.
• 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:

BI:

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

ETL:

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

RDBMS:

Oracle 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:

BS in Information Technology

Professional Experience:

Confidential,TX Jan 2008 - Till Date
OBIEE Developer

­­­­­­­­­­­­
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
• 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
• Expertise in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• 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
• Created reports of Oracle EBS using BI Publisher through OBIEE.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Expertise in writing the queries using PL/SQL.
• 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
• 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

Environment: OBIEE 10.1.3.2.1, Oracle 10g ,PL/SQL and Windows 2003 Server

Confidential,IN Aug 2006 – dec 2007
Siebel Analytics Developer

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 Star schemas
• 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
• Implemented OBIEE security for users and groups in administrator tool
• Created reports by applying views, filters, calculations and conditional formatting in answers
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Created reports of using BI Publisher through OBIEE
• 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

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