SUMMARY:

• 9+ years of diversified IT experience in delivering Business Intelligence solutions by gathering requirements,analysis, design, development, testing and implementation using standard SDLC methodologies for various Business Intelligence (BI) applications.
• Extensive hands on experience on all versions of OBIEE 11.x/10.x, Siebel Analytics 7.x, Oracle BI Applications (OBIA) 7.9.x, which include installing, upgrading, building and configuring repository (.rpd), creating and managing OBIEE Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel iBots/ Scheduler, BI Publisher and design the complete architecture of Extraction Transformation and Loading using Informatica power center 9.x/8.x/7.x, Oracle Data Integrator ODI and DAC.
• 5+ Years of Team Lead experience in handling all phases of Quality Assurance life cycle and SDLC of the Oracle BI projects which involves meetings with Business Users, creating LOE using MS Project Planner, POC, Gap analysis, converting FRD to BRD, Tech Specifications Docs, Design, development, Unit testing, Deployment, Support, Distributing work and co - coordinating with On-Site & Off-shore team members.
• Expert in providing BI solutions for Financial, Insurance, Pharmaceutical, Retail, Banking and Telecom for their various business processes and implemented OBIEE best practices.
• Expertise in converting and using Oracle OOTB rpd/pre-built rpd's (Financial, HR, Sales, Supply Chain, Order Management, Procurement and Spend Analytics etc), CRM (CRM Sales, CRM Service Analytics) and Oracle Financialsfor GL, AP and AR subject areas according to business requirements.
• Experience working with ERP Systems like Siebel CRM & Oracle EBS (E-Business Suite), Relational and Multi-Dimensional Data Sources.
• Experience in Installing, Upgrading and Configuring OBIEE, OBIA from 10.1.3.4.1 to 11.1.1.3.0 and from 11.1.1.3.0 to 11.1.1.5.0 and 11.1.1.7.x.
• Experience in working with OBIEE 11g Web Logic Server, Enterprise manager Fusion Middleware, .RPD and Webcatalog.
• Extensive experience in at all three layers (Physical, Business Model and Presentation)of RPD using the Oracle BI Administration.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, building Analytics Repository and Metadata Modeling consisting of three layers (Physical Layer, Business Model (Semantic Layer) & Presentation Layer, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Expertise in identifying the KPI's and Business Model development with Facts, Dimensions, slowly changing dimensions Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series. Repository and Session variablesand Initialization blocks
• Very Strong Experience in developing Interactive Dashboards with drill-down capabilities using global & local Filters,Contextual Navigation, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects & Web Catalog Objects (Dashboard, Folders, and Reports).
• Experience in managing users and setting up their privileges and profiles using LDAP, Active Directory & External table Authentication.
• Experience in setting up a Multi-User Development Environment (MUDE), Usage Tracking, Applying Patches, Single Sign On (SSO), Load Balancing (Clustering).
• Experience in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports at the Database level by creating aggregate tables, materialized views, Bitmap, B Tree Indexes and at RPD level by cache mangement. creating Database hints indexing hints in physical Layer.
• Experience with BI Publisher creating RTF Template in MS Word to view the report data in BI Publisher.
• Strong working knowledge in architecture, design and development of ETL Extraction, Transformation and loadingprocess with Informatica and ODI with Data in ETL tools. Experience in Performance Tuning of sources, mappings, targets and sessions. Data(Dimensional and Relational) modeling for Data warehouse(EDW) efficient using DAC to configure, monitor and schedule ETL routines. Experience in Installing, configuring and customizing DAC(execution plans, subject areas, tables, task) and monitoring ETL process using DAC(7.9.5, 10.1.3.4.1 ) & Informatica workflow manager.
• Extensive experience working on the Unix and Linux servers for installing BI environments and expert in SQL, PL/SQL, UNIX, LINUX, UNIX Shell Scripting.
• Vast expertise in migration of RPD's and Webcat to PROD environment using catalog manager.
• Expertise in implementing Caching Strategy for the reports and usage tracking of reports.
• Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports generated from Informatica and OBIEE.
• Experienced in troubleshooting production issues and maintenance of delivered projects.
• A self-starter looking for challenges with good leadership and interpersonal skills. And an enthusiastic project and result oriented team player.

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business Suite R12/11i, Oracle Financials(GL, AR, AP, FA),Supply Chain, HRProcurement and spend Modules.

Application Tools: Oracle Business Intelligence Enterprise Edition 10.x/11.x, 11.1.1.7, Reports 10g/6i, Forms 10g/6iCognos, Developer 2000, XML/BI Publisher, Siebel, Oracle Enterprise Manager (2.1.0).

ETL Tools: Informatica Powercenter 5.x/6.x/7.x/8.x/9.x, Datastage, Oracle Data integrator ODI

Databases: Sybase, Oracle 8i/9i/10g/11g, Netezza, MS SQL Server 2000/2003/2005/2008, DB2.

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, XML

Web Technologies: HTML, JAVASCRIPT, ASP and PHP

Scripting Languages: Unix Shell scripting, C shell

Operating Systems: Unix, Linux (Red hat enterprise) and WINDOWS 98/2000/NT/XP/VISTA/windows8

Data Modelling Tools: MS Visio, CA Erwin, SQL Architect

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Senior OBIEE Consultant

Responsibilities:

• Worked on OBIEE 11g servers and completed evaluation and recommendations.
• Collaborate with business users and data owners to successfully implement a SDLC and maintain an enterprise level business analytics and data warehousing solution.
• Responsible for the design, set up and maintenance of both Production and Non-Production environments.
• Responsible for leading the reporting project and worked with team of developers off shore and on site.
• Develop the road map for the line of business and developed front-end, metadata and ETL specifications to support business requirements for reporting across the organization.
• Worked with users involving gathering Business Requirements and understanding the needs of the users and turn their needs of reporting to realty did GAP Analysis, Data Modeling Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts.
• Worked on advanced rpd core Business Model layer to create business model designs.
• Monitored and tested Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Monitored team in implementation of vanilla installations of OBIEE 11.1.1.7.1 of weblogic servers and BI servers on the linux boxes and completed configurations for different clustered groups of transactional buckets. Did the upgrade of OBIEE 11.1.1.7.1 from 11.1.1.5.x on the VM servers and patching for client machines and did branding on servers and configured high availablity.
• Actively administrated OBIEE, Informatica, and DAC. Performed routine maintenance tasks(backups, security, scheduling, tuning, processing user requests).
• Created Multi user development environment (MUDE) for the different groups of developers to work on the central rpd and dev rpds in DEV and TEST environments. Managed migration of OBIEE reports, dashboards, help files and folders.
• Responsible for the support and maintenance of OBIEE security for all the reporting groups of the organization.
• Worked on extracting data from Oracle EBS R12, Siebel, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system for Enterprise source systems of Bank.
• Configured Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Responsible for the ETL Customized of fact & dimension tables to add columns as per the client requirements.
• Design and Developed metadata repository (.rpd) that consists of physical layer, business model and presentation layer.
• Helped in Delivery of Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Helped to create and implement a long term storage and business continuity strategy including backup & recovery and data storage and archiving.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report.
• Configured new customized mappings and work flows in DAC for new customized subject area.

Environment: OBIEE 11.1.1.7.1, Informatica 9.5.1, Oracle Applications R12, DAC, JAVA, BI Apps /OBIA 7.9.6.4, Oracle (Financials), Oracle 11g.

Confidential, Minneapolis, MN

Senior OBIEE consultant

Responsibilities:

• Designed architectural frameworks for OBIEE applications to meet business needs. Provided support in routine maintenance and enhancement of OBIEE application.
• Participated in design reviews and recommended improvements.
• Assisted in integrating OBIEE application with Oracle RDBMS database. Reviewed and executed application changes.
• Performed recovery and restoration operations for OBIEE application.
• Performed security testing and system integrity testing of OBIEE application. Provide support in OBIEE architecture of the organization through database design, modeling and implementation.
• Anticipate the end-to-end scope of analytical need of the client and design valuable BI and ETL solutions accordingly.
• Used the best practices of business intelligence to design the analytical solutions.
• Involve in unit and system testing to maintain the flow and relevancy of the solution.
• Maintain and update a unique data storage facility to avail data back-up, recovery and archive.
• Learn new business processes and OBIEE solutions to apply them in the projects.
• Train team members on OBIEE, ETL and OLAP concepts, new techniques and methodologies.
• Ensure availability and security of the analytic data and system
• Prepare documentation for all data and reporting development.
• Develop, implement and deploy data warehousing and business analytical solutions
• Engage in project planning, controlling and writing technical documentation
• Design and create metadata and ETL solutions to aid the reporting process across the enterprise
• Troubleshoot all issues and figure out the root cause/s of those issues
• Standardize and improvise data quality through periodical data cleansing and auditing process
• Maintain and monitor the data documentation for all data warehouse and reporting formats
• Collaborate with end-users to check the efficiency level based on report requirements
• Work with various teams across the organization, clients and other stakeholders to successfully carry out the enterprise level BI solutions. Assisted in determining cost estimates for proposed work.
• Worked with management in requirements definition, planning, designing and developing OBIEE applications.
• Identified architectural problems and determined corrective actions.
• Performed load automation, data cleansing, and data acquisition activities.
• Carried out performance management and tuning operations.
• Designed data security model based on user access requirements.
• Developed and maintained metadata repository.
• Assisted in installation and configuration of OBIEE components. Expert on server maintainance and administrative tasks on security and management on OBIEE 11.1.1.5.0 and on different environments of PRD, UAT and DEV.Successfully completed upgrading and configuring OBIEE 11.1.1.3.1 from 11.1.1.5.x on the weblogic servers and clients without errors on BIP publisher reports and obiee reports and dashboards.
• Developed and enforced architectural policies.
• Worked on the relational and star schema data modeling using multiple facts for core models of finance and Payroll business.
• Gather reporting and analysis requirements and worked with BA's, Created technical design documents for the report specifications, implementing the rpd metadata layers including Physical, Business Model and Mapping and Presentation layers.
• Create centralized dimensional models for the offshore BI developers to work easily on the target physical tables for ERD's using CA ERWIN and SQL architect.
• Installations and configuration of OBIEE on BI environments on Linux boxes and Cluster configuration of servers for different source data and High availability.
• Worked on cross training the users and developer teams on product features and functionalities on regular basis as a part of brown bag and sprint planning.
• Developed an ETL process design in Informatica that extracts data from the source (PeopleSoft) and loads into the target Data warehouse built on Oracle 11g. Designed Informatica Mappings, Transformations and Workflows to de-normalize the History Tables in the Staging area.
• Bridged the newest module upgrades with business intelligence function transactional system and Created complex BI publisher reports.
• Implemented GIS maps in OBIEE for the custom maps provided for campus buildings and offices by the third party with different format.
• Completed configuration and upgrade of OBIEE 11.1.1.6.0 on Shiboleth authentication for security.
• Implemented security based on LDAP Authentication for a different set of public users groups.
• Used OBIEE Web Catalog to set up groups, access privileges and query privileges and managed GUID and refreshing of Groups, Users, group members tables on daily basis.
• Worked on tuning the reports and jobs which run using SQL and PL/SQL procedures on backend MSAS cubes.
• Defined and created many Star schema models in rpd and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Delivered complex Dashboards using the pivot tables and graphical representation of measures for easy usability to users.
• Work with various different Hierarchies on different Levels, and implemented Business Logic by creating level based measures in OBIEE business model and mapping layer.
• Worked with ODI and with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files and SAS cubes.

Environment: OBIEE 11.1.1.5.1, OBIEE publisher 11.1.1.5.1, ODI, Informatica 9.1, Oracle 10g/11g, SQL, PL/SQL, SQL server, MS Analysis Services cubes, SAS analytics, Hyperion essbase cubes, TOAD, JAVA and ASP .net, Sybase, Autosys, DAC, HP Quality Center, UNIX.

Confidential, Fridley, MN

Senior OBIEE lead

Responsibilities:

• Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment and all aligned phases of the overall project.
• Understand Oracle Apps Financial core structure and Gathering of the functional requirements of the Financial Users and analyzing the creating feasible design approach.
• Installed and Configured the weblogic and BI servers for the OBIEE 11.1.1.3.1 and implemented LDAP security authentication and managed priviledges and did patching for updating versions and bug fixes
• Worked proficiently on the Enterprise Manger to set up the application roles in EM.
• Configured OBIEE 11.1.3.1 for High Availability of clustered servers.
• Created many star schema models for Business modules and designed reports and dashboards from those Created Technical Specifications Document and signoff from Business User.
• Developed the overall Design of the profitability in SDD (Solution Design Document) and add ons of different versions as per new requirements on T&M basis and took the Sign Off from Solution Architect team and users on the same
• Implemented MUDE (Multi User Development Environment ) for the different environments
• Preparation of Project Plan for Different Phases of the Project Including Development, UAT and Go live of the Project by working in sync with Project coordinator.
• Developed and coordinated the ETL Mappings on ODI tool along with the Offshore team in data transformation and OBIEE 10.1.3.4.1, 11g and RPD development and dashboards for PGBU Profitability Analysis and migration to Stage Environment for UAT with Global users.
• Solely carried all enhancements relating to code change in all ETL mapping of Informatica and OBIEE RPD changes and modifications for all entities identified in project and migrated to the production environment through the Confidential change request process successfully.
• Worked extensively on design of DAC (Datawarehouse Administration Console) 10.1.3.4.1 .20090415.0146, execution plan for the project and ran and monitored the loads during US time for all uploading of the CSV files to UNIX server for ETL s and pull data to OBIEE Front End during UAT and post development phases.
• Deal with on-shore and off-shore clients and ensure project delivery on time
• Solely supported the issues resolution during the UAT and pre UAT along with the Business users.
• Converted the HFM report from hyperion to Developed complex designs of Elimination process and Line of Business Categorization which will give the exact figures for financial users for their entities for particular product basis.
• Worked extensively on CSV files data interpretation for bringing data to OBIEE through all CSV files and UNIX scripting for possible reconciliation with HFM(Hyperion Financial Management).

Environment: OBIEE 10.1.3.4.1 /11.1.1.5, ODI, Noetix, Hyperion EFM, Hyperion Essbase cubes Oracle EBS R12 (General Ledger GLAccount Payables AP, Account Receivables AR, Purchasing PO, Order Management OM), Oracle 10g, TOAD,SQL developerPL/SQL,, Sybase, Oracle BI APPS 7.9.6, DAC, Informatica 8.1.0, BI Publisher 10.1.3.x/11g, SQL*Loader.

Confidential, Laurel, MD

OBIEE Consultant

Responsibilities:

• Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Configured MUDE multi user development environment for the different BI servers for different business groups.
• Installed and configured OBIEE 10g and upgraded to 11g latest version and all components and did regular patching with new releases to fix bugs. Created Appplication roles in Enterprise manager EM in Obiee 11g
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client. Did the Performance tuning and monitored the different jobs and report time.
• Monitored incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Granting access to users and maintain security by using database authentication and authorization.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
• Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Involved in developing the Incremental ETL processes i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
• Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
• Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
• Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using OBIEE.
• Developed Replenishment Interface in Oracle Inventory (INV) based on data sent from warehouse in flat file. Used Loader program to load the data into the staging table, and then performed PL/SQL validations to load the data into the interface tables.
• Developed balance sheet, profit and loss statement using BI Publisher.
• Worked on tools like TKPROF and Explain Plan for tuning of PL/SQL queries for better database performance.
• Resolved open issues with production system
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents.

Environment: OBIEE 10.1.3.4.1, OBIEE 11g, Oracle EBS R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM), Oracle 10g, SQL in TOAD and SQL developerPL/SQL,, Oracle BI APPS 7.9.6, DAC, Informatica 8.6.1, XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL*Loader.

Confidential, NJ

OBIEE Consultant

Responsibilities:

• Full project life cycle implementation for Oracle Business Analytics Warehouse (OBAW).
• Performed Project Scoping, Project Organization and Management including Business & IT requirements, Priorities, Project Execution Plan and Resource Plan.
• Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the
• BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables. Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Developed BI Consumer reports using OBIEE 11g.
• Created executive level Reports and Dashboards catering to provide insight into the sales and marketing data.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Expertise in segmentations and scheduled programs on daily basis.
• Worked on Informatica Performance tuning methods depending on the size of source and lookup tables.
• Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these tables.
• Proficient in working with HP Service center and Quality center.Worked in production support and seen through the phase of the developments in the production and done various bug fixes.

Environment: OBIEE 10.1.3.3./11 g, BI Apps 7.9.6, Xcelsius, Informatica 8.0, Oracle 10g, SQL, PL/SQL, DAC, TOAD, SQL* Plus, Windows XP.

Confidential, Philadelphia, PA

OBIEE Consultant

Responsibilities:

• Installed and configured OBIEE 10g and all components and applied patches for upgrade of some bi servers.
• Identified & Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
• Installed and configured the MUDE multi user development.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to usersand groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.1.3, Informatica8.1.1, DAC, Oracle 10g, SQL Developer, SQL*PlusBI Publisher 10.1.3.x,XML Publisher, Windows-XP.

Confidential, Richmond, VA

Sr OBIEE Consultant

Responsibilities:

• Did an Upgrade on OBIEE 10g and configured the servers as per new requirements and applied patches for bug fixes with ORACLE service requests.
• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specification.
• Implemented MUDE multi user development and designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository (RPD).
• Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services.
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality

Environment: OBIEE 10.1.3, Informatica 7.1, SQL, PL/SQL, TOAD

Confidential

OBIEE Consultant

Responsibilities:

• Involved in translating business requirements into logical business dimensional model.
• Performed GAP Analysis between the 'AS-IS' process and 'TO-BE' process.
• Involved in converting business requirements into Functional Specifications and Technical Specifications.
• Installed and configured OBIEE on UNIX boxes.
• Did an Upgrade and applied patches to fix bugs with the SR raised to oracle.
• Implemented MUD multiuser development process. Responsible for creating a prototype.
• Installation of Siebel Servers and Web Servers. worked in implementing SSO security model using Siebel.
• Worked on development of Star schema models in OBIEE RPD - Physical, Business Model and Mapping and Presentation Layer, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports). Mapping of data sources using OBIEE Admin tool to create repository.
• Created Drill Down Hierarchies and implemented Level Based Measures, Cache Management, and Performance Tuning using Aggregate tables in OBIEE Business Model Layer.
• Created star schema models and created Session and Repository Variables and Initialization Blocks for desired functionality.
• Created Groups/Users and set up Security using LDAP Authentication.
• Created Pivot Tables, Pie charts, Column/Bar Charts, View Selectors, Narrative Views, and Column Selectors in OBIEE environment.Migrate and Deploy of RPD and Webcat in Development, Test, and Production Servers.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities, Dashboard/Page Prompts.
• Created i-BOT's using OBIEE Delivers and scheduled daily and weekly reports.
• Designed and developed the ETL Mappings for the source systems (Relational, Flat Files, and Excel) data extractions, data transformations, data staging, movement and aggregation.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy. Extensively worked on performance tuning of Informatica mappings.
• Involved in Migration, UAT, Go-Live, and Production Support.

Environment: OBIEE 10g, Informatica PowerCenter 7.x, Oracle 9i/10g, LINUX

Confidential, Northlake, IL

Siebel Analytics Consultant

Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance and administration, and other business groups to identify, analyze, and document Business requirements.
• Implemented, identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements. Related data sources were derived from Siebel CRM as well as numerous enterprise applications, retail and supply chain systems.
• Installation and configuration of OBIEE on Development, Stage, and Production Servers
• Worked extensively on Siebel Analytics applications (Siebel Answers, Delivers, and Dashboards).
• Ability to perform Server and component tuning, optimization
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Created various reports using Column Selector, View Selector, Pivot View, Chart View, and Guided Navigation
• Involved in design and development of repository and various star schema models (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Performance tuning of the reports through rpd design and sql queries and stored procedures
• Migration and Deployment of OBIEE in Development and Production Servers.
• Used ETL processes to accommodate changes in source systems and new requirements.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Used Workflow Monitor to monitor the performance of the Jobs.
• Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x, Oracle 9i, UNIX.

Confidential, CA

Siebel Analytics Consultant

Responsibilities:

• Interacted with functional & technical leads, SME's, sales and marketing teams, and other business groups to identify, analyze, and document business requirements.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel Analytics platform
• Implemented MUDE multi User development environment for developers to work in tandem.
• Developed of Metadata Repository (.rpd) with multiple business layers using complex joins, presentation catalogs with access validations and external table security repository and repository migration.
• Designed and developed many Smart Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information, and local & global filters and cache monitor using Siebel Analytical Web.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.

Environment: Siebel Analytics 7.x, Oracle 9i, Sun Solaris

Confidential, CA

Siebel Analytics Consultant

Responsibilities:

• Design and development of repository (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc
• Implementation of Siebel Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones
• Security management for users, groups and web-groups using the various authentication systems such as LDAP, OS, Database and External table authentication using Session Variable features, as well as Dashboard / Report-levelsecurity
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views
• Implementation of criteria filters to narrow-down the result set from the analytics requests
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations
• Developed and executed test plans and played an active role in product rollouts
• Life-cycle support for migration efforts from development to QA to production analytics
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.

Environment: Siebel Analytics 7.7, Informatica PowerCenter 6.x, Oracle 9i, Sun Solaris