SUMMARY:

• Over 6 Years of experience in Analysis, Design, Development with a strong background in Oracle Business Intelligence (OBIEE) with 3 full life cycle implementations. Extensively used shell scripting concepts to recreate the existing dashboard from OBIE into Qlikview and also to automate the repository builds process on production servers.
• 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 and 12c upgrade experience.
• Assisted in migration of BI Publisher reports from OBIEE10g to OBIEE11g/12c.
• 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 using Tableau. 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 Tableau.

BI Tools: OBIEE 11G, OBIEE 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: MS SQL SERVER 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.

WORK EXPERIENCE:

Sr. OBIEE Lead Developer

Confidential, Ashburn, VA

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Analyzed pros and cons of the BI architecture and implemented the BI by building reports for the customers successfully.
• Extensively used SQL coding skills in writing complex queries in an efficient way and also used shell scripting to automate the repository builds on different production and testing environments.
• Played a keen role in updating BI server platform from 11.1.1.7 to 11.1.1.9/12 c on the operating systems Windows server, Linux/Unix servers successfully.
• Made adaptive and useful recommendations in updating the design for building reports and architecture of the data model.
• 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.
• Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• 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.
• Lead OBIEE Application/Analytics team with emphasis on Analytics and established requirements analysis.
• Experienced in building and writing complex PL/SQL statements in order to pull the data in an efficient way from the respective database in order to improve the performance/efficiency of the reports.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer in repository building (OBIEE 11g/12c).
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• 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 object level and row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Also worked as an admin in solving issues with the server platform, upgraded OBIEE tool from 11.1.1.7 to 11.1.1.9/12 c on both Linux as well as windows platforms.

Sr. OBIEE Developer

Confidential, California

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Lead OBIEE Application/Analytics team with emphasis on Financial Analytics and established requirements analysis.
• Experience performing expenditure actuarial and financial analysis for businesses.
• Extensively worked 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.

Sr. BI Developer/Admin

Confidential, Houston, TX

Responsibilities:

• Managed planning and portfolio for business investments budget.
• Extensively used shell scripting and Qlikview data model concepts to recreate the existing dashboard from OBIEE 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, which was 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 defects and 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 levelsecurity 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, Essbase 9.3.1, DAC.

Sr. OBIEE Consultant

Confidential, Oklahoma City, OK

Responsibilities:

• Assess clinical laboratory industry expenditure trends, reimbursement changes by commercial and government payers, and related data to inform Avalon's business plans and client services.
• Perform data quality analytics on customer, member, product, premium, and claim data information in Harvard Pilgrim's EDW.
• Investigate, research, resolve, and test EDW data integrity issues to support Finance analytics.
• Experience in Care Management and Care Outreach.
• 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, Tableau, SQL Developer, Windows 2008 Server, TOAD, PL/SQL Procedures.