SUMMARY

• Over 7+ years of experience in IT industry, dis includes
• More TEMPthan 5 years of experience in Requirements gathering, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence solutions for various business sectors.
• Extensive experience in Siebel Analytics and Oracle BI EE.
• Expert level Business Intelligence experience using
• OBIEE 11g/10g and Siebel Analytics 7.7/7.8.

TECHNICAL SKILLS

• Proficient in Siebel Analytics, Oracle BI EE.
• Experience in Installing, Configuring and Administering OBIEE/Siebel Analytics Server, both stand - alone & Enterprise Applications.
• Strong noledge in OBIEE/Siebel Analytics Repository (.rpd) development at three layers (Physical Layer, Business Model & Presentation Layer), building business models and configuring metadata.
• Highly skilled in OBIEE/ Siebel Analytics security at teh data and object levels.
• Experienced in OBI Answers and Dashboards for both OBI/Siebel Analytics stand-alone/ integrated implementation and BI Publisher.
• Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in creating complex and standard reports using various views in Answers.
• Expertise in designing Interactive Dashboards, incorporating dashboard prompts, navigation, drill-down and Web Catalog Objects using OBIEE.
• Strong Expertise in designing teh report layout templates in teh BI Publisher.
• Proficient in full life cycle implementation of Business Intelligence with Star and Snowflake Schemas.
• Good understanding of database design, relational integrity constraints, OLAP, OLTP, and Normalizations.
• Excellent backend skills in creating SQL objects like Tables, Views, Indexes, Triggers, Roles, Defaults.
• Good understanding of Object Oriented Programming concepts and hands on with java.
• Proven team player, with multi tasking capabilities and possess excellent interpersonal and communication skills.

TECHNICAL EXPERTISE:

BI: OBIEE 11g, OBIEE 10.x (Administration Tool, Analytics,Answers, Dashboards, Delivers and BI Publisher) and Siebel 7.x (Administration Tool and Analytics)

ETL: Informatica Power Center 8.6/8.1

ERP: Oracle Apps EBS R12

CRM: Siebel CRM 8.6

Languages: SQL/PL SQL,C, Java, HTML

RDBMS: Oracle 11g/10g/9i/8i, (SQL), MS SQL Server 2000/2005, Teradata, DB2

OS: Windows 2008/2003/XP/2000/NT 4.0/Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Sr.OBIEE Developer

Responsibilities:

• Performed Installation and configuration of OBIEE 11g standalone application.
• Conducted interactive sessions with business users for requirements gathering for developing repository, reports, and define security for OBIEE with EBS for both FA and SOP projects
• Built Stand Alone Repository, framed subject areas for SOP project
• Designed teh repository with physical, Business model and mapping and presentation Layers.
• Framed Time based and Product based hierarchies and also multiple level hierarchies for each dimension.
• Created repository variables for different purposes to use in reports for pulling teh data.
• Developed various reports using multiple views and prompts scope at page and dashboard level
• Creation of different users and groups and assigning specific roles and provide privileges to access teh reports and dashboards based on teh roles.
• Implementation of complex joins, alias tables which halped in improving teh performance of teh system.
• Creation and scheduling iBots for delivery of personalized reports to users.
• Implementation of Security for BI Publisher, OBIEE Answers using roles and responsibilities from EBS at data level and object level.
• Documentation of functional and technical specifications in defining teh requirements for teh project
• Provided training for business users in getting familiar with OBIEE 11g Answers which is teh latest version in developing teh reports

Environment: OBIEE 11.1.1.6.0, OBIEE v10.1.3.4, EBS R12, Discoverer, Oracle 11i/10g, SQL Server 2005, Windows 2008 Server R2

Confidential, CA

OBIEE Developer

Responsibilities:

• Worked on full life cycle implementation of OBIEE.
• Participated in meetings with teh business users in gathering requirements for developing repository and created detailed requirement specifications document (Report Requirement Document).
• Installation and configuration of OBIEE standalone application.
• Built RPD by designing Physical Layer, Business Model & Mapping Layer and Presentation Layer in teh Administration Tool.
• Mapped connection pools, imported teh required tables into teh Physical Layer. Created alias tables in teh Physical Layer and defined teh physical joins based on teh business entity schema in teh Administration Tool.
• Worked on teh BMM layer in teh OBIEE Repository to create logical joins, logical keys and framed hierarchal levels to support Drill-down, Aggregation and Sum over columns etc.
• Used Variable Manager in Administration Tool to define Repository and Session variables.
• Implemented Object (RPD & Web Catalog) and Data (role based) level security.
• Implementation of Active Directory security.
• Created Presentation Catalogs in Presentation Layer.
• Used OBIEE Answers to develop Ad-hoc & Standard reports and published them on Dashboards with different Views (Pivot Table, Chart, Column Selector, and Tabular with Prompts) to visualize data more effectively in different forms.
• Developed complex reports on different Subject Areas, worked creatively on Combined with Similar Request, Add Result Column, Advanced SQL Issued, displayed results in Pivot and Narrative Views.
• Developed Interactive Dashboards consisting of Prompts, Folder (Adhoc reports) and Drill-down reports. Used prompts, with Presentation Variable, as column selector for multiple reports on teh Dashboard.
• Created Materialized views and Aggregates to improve teh performance.
• Performed Unit, Integration, and Regression testing of Reports/Dashboards and RPD.
• Administered and maintained teh SharePoint Service (Report Queue, Work Queue & Status) for teh report release and migration.
• Migrated OBIEE 10g repository to 11g repository.
• Implemented new enhancements and features of OBIEE 11g and figured many issues and also found an work around for those issues

Environment: OBI Apps 7.9.6, OBIEE 11.1.1.3.0,OBIEE v10.1.3.4.1, Oracle SQL Developer, Oracle 11i/10g, Oracle 10g and Windows 2003 Server

Confidential, Houston, TX

OBIEE Developer

Responsibilities:

• Participated in user interactive sessions and Involved in documenting Functional Specifications, Design Specifications documents and created Report Specifications documents and updated them as and when needed.
• Extensively worked on OBIEE Repository Multi User Development Environment, implemented and configured to achieve single and centralized Repository development.
• Created dimensional hierarchies and set various levels in teh BMM Layer of Repository implementing drill down, Aggregation and Sum over columns.
• Implemented basic security and External Table Authentication Security Mechanisms.
• Created Repository, Session variables and Initialization blocks using Variable Manager in OBIEE Admin Tool.
• Designed teh security model in OBIEE to implement visibility based on user roles by Creating users and groups and assigning explicit and individual permissions and privileges to access teh data.
• Used appropriate filters, column filters, Report prompts, dashboard prompts and calculations in reports.
• Developed Reports and Dashboards using Analytical Views (ticker, narrative, column selector, view selector, legend, funnel Pivot Table, Chart) to visualize data in different perspectives using OBIEE Answers.
• Created interactive report templates using BI Publisher.
• Implemented Report Bursting feature and created hyper links.
• Configured iBots and used Delivers to deliver analytical content to users to alert teh management, sales teams.
• Involved in Performance Tuning of Dashboards/Reports by implementing teh materialized views, creation of indexes, SQL query testing.
• Hosted training sessions for teh End Users to build Complex and Ad Hoc Reports using OBIEE.

Environment: OBI Apps 7.9.6, OBIEE v10.1.3.4.0, BI Publisher, DAC (Data Warehouse Administrator Console), Informatica Power center v8.1.1, Oracle 11i/10g, Oracle 10g and Windows 2003 Server

Confidential

Programmer Analyst

Responsibilities:

• Worked closely with Business Analyst, during teh JAD sessions and gatheird teh Business Analytics requirements.
• Imported teh Physical Meta Data from Various Data marts into teh Physical Layer by defining teh connection pool settings.
• Defined teh Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Modeled teh Logical mappings and joins based on teh Business requirements in teh Business Mapping and Modeling Layer and Developed teh necessary Star Schemas.
• Worked on Aggregates, Hierarchies, Calculation wizard in teh Logical Layer.
• Worked on teh Time Series Wizard and implemented time comparison measures.
• Used column Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up in Reports thus improving performance.
• Managed security privileges for each subject area and dashboard according to user requirements.
• Have worked on different modules like OKC, NEIC and batch related data.
• Customized/Created presentation layer catalog folders, to show different views of teh business model to different users and assigned group permissions to teh catalog folders.
• Worked Extensively on Siebel Answers to create teh reports as per teh client requirements.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.

Environment: Siebel Analytics 7.8.2, Siebel Call Center, Siebel Tools, Informatica 6.2, Peoplesoft, Oracle 9i, Windows 2k.

Confidential

Programmer Analyst

Responsibilities:

• Involved in teh full SDLC (Software Development Life Cycle) process which includes documentation, development, testing, deployment, Implementation, and maintenance.
• Interacted with business teams for gathering teh Reports / Dashboards requirements and to define Business and Functional Specifications and translate it to ETL specifications & Business reports.
• Involved in designing Logical and physical data models using Erwin following Star Schema methodology.
• Created/Modified Metadata repository (.rpd) and configured Metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard Pages, Folders, Reports).
• Built and debugged various Dashboards with drill-down capabilities based on hierarchies using local and global filters using Siebel Answers.
• Created detailed report documentation (mockup of reports in excel and presented to user to get approval).
• Worked on role based dashboards in Pharma Sales.
• Configured secured dashboards, metadata objects and report level security to set up role based functional dashboard access.

Confidential

Programmer Analyst

Responsibilities:

• Participated in Knowledge transfer sessions in understanding teh requirements from teh business analyst.
• Prepared Functional and Technical specification documents and presented to SME (Subject Matter Experts) for review.
• Development and Testing TSP module in CAS One Source.
• Analyzing and testing various other modules like GU, Exceptions and Misc in CAS One Source.
• Code development support for TSP module.
• Supported in maintaining teh existing web-based application.
• Played a key role in creating all teh required project documentation.
• Worked on a wide variety of open source servlet containers such as JBoss and Tomcat.
• Developed unit test cases for various project deliverables.
• Played a key role in carrying out User Acceptance testing for teh Application.
• Involved in teh turnover of code from Development to System Test environments and then to teh Production environment.
• Worked closely with production support team to carry deployment activities and resolve production failures.

Environment: Windows XP, Eclipse, Struts 1.1,Tomcat, TOAD