SUMMARY

• Over 8 Years of experience in Analysis, Design, Development with a strong background in Oracle Business Intelligence (OBIEE) 10.1.1.3/11.1.1.6/ Siebel Analytics 7.9.x with 3 full life cycle implementations.
• Extensively used Qlikview data model concepts to recreate the existing dashboard from OBIE into Qlikview.
• Extensive experience in designing analytical/OLAP and transactional/OLTP databases.
• Possess good skills in understanding and working knowledge of EBS Financials.
• OBIEE11g expert with strong BI Publisher experience and OBIEE10g to OBIEE11g upgrade experience.
• Assisted in migration ofBI Publisher reports from OBIEE10g to OBIEE11g.
• Expert in data warehousing concepts like OLAP, Dimensional Modeling, Data Modeling using Normalization, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
• Expertise in Installation and Configuration of OBIEE on various platforms of AIX/Windows and developing Metadata, Repositories, Dashboards and Reports.
• Experience configuring Interactive Dashboards with drill - down capabilities using global and local Filters, Analytics Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Strong expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Work closely with the business team and other project team members to quickly diagnose issues and implement solutions in a timely manner.
• Experience in integration of various data sources like SQL Server, Oracle, Flat files, DB2, Mainframes into the staging area.
• Experienced in Installation, Configuration, Upgradation, Migration and Administration of Informatica Power Center/Power Mart Client.
• Expertise in ETL methodology in Data Extraction, Transformation and Loading. Experience in Performance Tuning of sources, mappings, targets and sessions.
• Ability to quickly master new concepts and applications. Excellent team worker with good interpersonal skills and leadership qualities.
• Possess good communication skills, strong dynamic and analytical in nature. Attitude for challenging assignment, task oriented and commitment to goals and objectives.
• Well oriented to enrich technical, human conceptual areas to meet the future expansion of the organization.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/7. x/6.x/5.x.

BI Tools: OBIEE 11G, OBIEE 10.1.3.4, Siebel Analytics 7.7, Oracle (IBots), BI Apps 7.9.5, 7.7.1.

Operating Systems: MS Dos, Win 95/98, NT 4.0, Win 2000, Win XP, AIX UNIX.

RDBMS: Oracle11g/10G/9i/8i/8.0/7.x, MS SQL SERVER 2008/2005, PLSQL.

Languages: C, C++, Java, HTML, PHP, SQL, PL/SQL, UNIX Shell Scripting.

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS.

Modeling Tools: Erwin, Microsoft Visio.

Applications: MS Office suite, Dreamweaver and Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Lead OBIEE Application opportunities with emphasis on Financial Analytics and established requirements analysis.
• Extensively working with OBIA Financial Analytics.
• Worked on EBS Financial (General Ledger, AP, Asset Accounting and Sub ledger) reports.
• Created number of Gross margin, Revenue Growth reports and published on EBS portal.
• Generated the build instructions and work closely with the Operations team to deploy the solution.
• Expertise in conducting Oracle BI Analytics which includes Oracle Financial Analytics (General Ledger, Payables, Receivables, Profitability), Oracle Procurement and Spend Analytics (Supplier performance, Procurement and Spend analytics), Oracle Projects Analytics, Human Capital Management, Campus Solution.
• Implementation of OBIA: P&S Analytics, Spend Classification and SCM analytics.
• Assisted with the upgrade of OBIEE10g to OBIEE11g.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer in SOA.
• 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.
• Worked on Metadata Repository objects and also Web Catalog Objects, which include Dashboards, Reports, Pages and Folders.
• Designed specs to modify ETL maps as necessary to extract GL, AP, AR, Billing and Project Costing data from FMS & Workforce Profile, Benefits, Compensation and Payroll data from HCM.
• Developed SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Developed and coded a number of DB objects: Stored Procedures, Triggers, Functions, Materialized Views, DB Links, Bitmap indexes and Partitioning strategies.
• Worked on scheduling tool Data Warehouse Administration Console (DAC) i.e. Data warehouse architecture to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse.
• 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.
• Customized Out of the box Repository (RPD) to work with other ERP systems and ESS base. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Compared SAP BW with OOTB Oracle Data warehouse and advocated the use of OOTB data warehouse.
• Created sessions, tasks, and workflows etc. in Workflow Manager.

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

Confidential, Houston, TX

Sr. BI Developer

Responsibilities:

• Managed planning and portfolio for business investments budget.
• Extensively used Qlikview data model concepts to recreate the existing dashboard from OBIE into Qlikview.
• Worked with direct and cross functional teams to drive foundation plans, execution plan, administration, and reporting.
• Conducted Financial Analytics with OBIA.
• Performed Business and Financial Analysis using oracle EBS for assigned portfolio and across cross matrix business areas.
• Created Daily & Monthly balance reports for regular operational purpose and published on same EBS portal, whichwas central Portal for business needs.
• Worked Asset accounting reports (Total Value, Taxable value reports).
• Provided comprehensive consultation to infrastructure administrators and business analysts in resolving issues.
• Perform trouble shooting for all defectsand analyzed of GL, AP and AR data models.
• Prepared security matrices, designed security architecture and implemented row-level security at OBIEE and PeopleSoft level.
• Developed Technical design solution, and unit testing.
• Extensively conducted Master Data Management.
• Created impersonator username, made changes in instanceconfig.xml and implemented SSO for the organization.
• Ensured restricted, confidential and sensitive access to data with the design of solid security architecture.
• 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.
• Designed reporting data model also called as RPD, which acted as the base for developing canned as well as ad-hoc reports using OBIEE Answers.
• Involved in system study, analysis, design, coding, testing and debugging of software, implementation and training for users.
• Delivered data visualizations in the form of reports and dashboards required by projects within a project team for larger projects and as the primary resource for smaller projects.
• Performed analysis on data from multiple sources and worked with Architect to provide input to Data Model and ETL processes.
• Reported development tasks, such as RPD and report/dashboard design and development.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• 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.
• Created templates as required by the client using BI Publisher.
• Performed Unit, Integration and Regression testing to validate reports and mapping.

Environment: OBIEE 10.1.3.4.1 , Oracle Financial Analytics, Oracle Supply Chain Analytics, Qlikview, Oracle BI Publisher 10.1.3.4.1 , Informatica Power Center 9.1/8.6.1, Oracle 10g, OBIEE Disconnected Analytics 10.1.3.4.1 , Ess base 9.3.1, DAC.

Confidential, Oklahoma City, OK

Sr. OBIEE Consultant

Responsibilities:

• Conducted implementations and research with OBIA Financial Analytics.
• Involved in Gathering, Analyzing Business Requirements for Reports.
• Created/Modified Metadata repository, defined/developed Physical Data Layer, Business Model (Aggregates, Dimensions and time Series functions) and Presentation Layer using BI Administration Tool.
• Implemented Delivers & Schedule Job using Agent for delivery of reports through email, hand-held devices and mobile phones.
• Configured & managed Application role & Application Policies for Users & Users group using Enterprise manager.
• Implemented Object Level and Data Level Security in the Enterprise Manager and Repository Variables, Session Variables and Initialization Blocks.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Development of interactive flash-based drillable charts such as bar-charts, Gauges etc.
• Worked extensively on OBIEE Skin & Branding as per client requirement.
• Create the style sheet (.css) which was followed in the dashboards.

Environment: OBIEE 11g, OLAP, Informatica, SQL Developer, Windows 2008 Server, TOAD, PL/SQL Procedures.

Confidential, Fargo, ND

OBIEE Consultant

Responsibilities:

• Created MUD (Multiple user Development) environment by utilizing projects.
• Splitting of repository projects and accordingly made it available to developers.
• Effectively migrating web cat, Skins and Style sheets from one server to another server by using catalog manager.
• Merging of repositories and migrating to multiple servers.
• Installed OBIEE in windows server.
• Created production builds and getting approvals from senior management.
• Customized and developed the OBIEE Business Model and Mapping layer.
• Granting access to users and maintain security by using database authentication and authorization.
• Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Created auto purge for repository cache and scheduled as per the demand.
• Trouble shooting the issues related to repository models and report development.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Aliases and defined Role-Playing Dimensions.
• Used Time Series Wizard to create alias tables in the BMM and Physical Layers to compare measures and spot trends.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Developed/Customized Siebel Dashboards, Siebel Answers, Siebel Delivers (I-Bots)
• Created Reports based on user requirements.
• Worked on Dashboard and Page level prompts and Report filters.
• Documentation, Knowledge transfer and User training.

Environment: Siebel Analytics 7.8, Informatica 7, Sun Solaris 9, Oracle 10g

Confidential

BI Developer

Responsibilities:

• Involved in designing of physical and logical models of databases, tables and all objects using Erwin 4.0
• Performed data modeling studies and develop detailed data models.
• Used Star Schema approach for designing of database for the data warehouse.
• Developed mappings in Informatica to load the data from various sources includes Oracle, SQL Server, DB2 into the Data Warehouse using different transformations like Source Qualifier, Expression, Stored Procedure, Look up, Aggregate, Update Strategy, Joiner, Filter and Router.
• Designed relational data models, using Erwin, for the data staging area to facilitate smooth data loads from multiple sources.
• Wrote shell scripts called them through command tasks into order to implement Pre and Post cleanup processes.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PLSQL code in Autosys.
• Developed K-shell scripts to run from Informatica pre-session, post session commands. Set up On Success and On Failure emails to send reports to the team.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests. Provided 24/7 Production Support.

Environment: Oracle 9i, SQL Server 2000, Informatica Power Center 7.1, Erwin, UNIX Scripting (Ksh), Autosys, Sun Solaris 7, Windows XP Professional.