PROFESSIONAL SUMMARY:

• Over 7+ years of experience in IT industry, this includes
• More than 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.
• Extensive business understanding of Retail, Health care, Financial Domains.
• Excellent planning, scoping, scheduling, and delivery skills.
• Strong understanding of Agile software development and SDLC processes.
• Solid team empowerment, motivation, communication and leadership skills.
• Strong documentation and reporting skills.
• Experience in preparing documentation such as Business Requirement Document, High Level Design, System Requirement Document, Functional Requirement Document, System Interface Agreement, UAT Plan Document, etc.
• Established myself as an effective leader and communicator with strong interpersonal, technical, leadership, analytical skills, Quality Process, Project Delivery, and Risk Management.
• Proficient in Siebel Analytics, Oracle BI EE.
• Experience in Installing, Configuring and Administering OBIEE/Siebel Analytics Server, both stand - alone & Enterprise Applications.
• Strong knowledge 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 the 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 the report layout templates in the 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 the 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 the 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 the reports and dashboards based on the roles.
• Implementation of complex joins, alias tables which helped in improving the performance of the 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 the requirements for the project
• Provided training for business users in getting familiar with OBIEE 11g Answers which is the latest version in developing the 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, Brea, CA

OBIEE Developer

Responsibilities:

• Worked on full life cycle implementation of OBIEE.
• Participated in meetings with the 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 the Administration Tool.
• Mapped connection pools, imported the required tables into the Physical Layer. Created alias tables in the Physical Layer and defined the physical joins based on the business entity schema in the Administration Tool.
• Worked on the BMM layer in the 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 the Dashboard.
• Created Materialized views and Aggregates to improve the performance.
• Performed Unit, Integration, and Regression testing of Reports/Dashboards and RPD.
• Administered and maintained the SharePoint Service (Report Queue, Work Queue & Status) for the 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 v 10.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 the 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 the 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 the 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 the management, sales teams.
• Involved in Performance Tuning of Dashboards/Reports by implementing the materialized views, creation of indexes, SQL query testing.
• Hosted training sessions for the End Users to build Complex and Ad Hoc Reports using OBIEE.

Environment: OBI Apps 7.9.6, OBIEE v 10.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 the JAD sessions and gathered the Business Analytics requirements.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Modeled the Logical mappings and joins based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on the 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 the business model to different users and assigned group permissions to the catalog folders.
• Worked Extensively on Siebel Answers to create the reports as per the 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 the full SDLC (Software Development Life Cycle) process which includes documentation, development, testing, deployment, Implementation, and maintenance.
• Interacted with business teams for gathering the 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 the requirements from the 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 the existing web-based application.
• Played a key role in creating all the 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 the Application.
• Involved in the turnover of code from Development to System Test environments and then to the 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