SUMMARY

• Extensive Business Intelligence experience using Oracle OBIEE 10.1.3.x and Informatica 8.X/7.x/6.x.
• Very strong experience in OBIEE Administration and developing BI Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using page and dashboard prompts, Siebel Security Setup (groups, object and data level), LDAP, External Tables, configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.s.
• Expert in cache management, Repository migration, data level and object level security in OBIEE.
• Expert on implementing and configuring LDAP group on data level security and object level security.
• Experience in Designing Informatica logic for SDE, SIL Mappings and Workflows, DAC Subject areas and Execution plans.
• Proficient in Database analysis, Performance tuning, Requirement analysis, Data Migration, ETL development, Forms/Reports Development, Repository (RPD) and Reports development, Dashboard Creation and Unit Testing.
• Proficient in Gathering Business Users Requirements, Functional and technical specifications, Data modeling, High level and low level detail design specifications, Coding, Support, Administration and Testing in multi-tier applications with main focus on Database environment.
• Proficient in Configuration and Implementing OOB modules for Supply Chain and Financial Analytics
• Strong Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle database skills to assist with an ongoing project comprising OBIEE infrastructure and installation analysis and tuning, OBIEE design, implementation and administration with OBIEE setup, architecture, design.
• Proficient in Dimensional Modeling - Star and Snowflake Schemas and in full life cycle development of Data Warehouse including Dimensional Modeling, ETL strategies and Reporting
• Experience in all components of OBIEE like DAC, Informatica, Business Modeling, and Reporting structure Modeling & Report Building, Dashboards and Oracle Answers
• Proficient in Oracle 11g/10g/9i/8i/7.x and extensive hands on experience with Indexing, Views, Materialized views, Constraints, Triggers, Stored Procedures/Functions/Packages, Forms 10g/9i/6i/4.5, Reports 10g/9i/6i, SQL Navigator, TOAD and Quest tools.
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export, extract and load large volume of data.
• Experience in Tuning SQL queries and PL/SQL code to refine database design to improve system response time and efficiency.
• Strong problem solving, analytical skills, good verbal, written communication and presentation skills and ability to work in a time-constrained and team-oriented environment.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules and to import data from various sources into Oracle Applications using open interfaces and API’s.
• Conversant in writing PL/SQL procedures, packages, functions, triggers, advanced SQL like analytical functions, SQL*loader scripts, UNIX shell scripts and in using various utility packages.
• Expertise in gathering business requirements from end users and develop technical solutions, experience in designing MD50, MD70 documents.
• Experience in creating dashboards using dashboard manager and Crystal Xcelsius.
• Experience in creating universe, reports, dashboards, scoreboards using Webi and Deski in Business Objects XIR2 and 6.5, by using QaaWS and Live office in Xcelsius.
• Worked on migrating Business Objects from earlier versions to Version XIR2. Extensively used the import wizard in moving reports and universes from lover version of Bo to higher version like from 5.x to 6.5 and from 6.5 to XI, XI R2 and XI 3.1.
• Develop reports using SQL Server Reporting Services
• Experience Working with MS Office Suite (Word, Excel, Access and PowerPoint skills).
• Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Experience on Data warehousing testing and expertise of building the test strategy and test plans.
• Experience on imparting trainings on different process management and technical topics.
• Experience and expertise on different methodologies like Agile development, Scrum, Extreme programming and SOA etc.
• Experience of client management, requirement gathering skills and managing the team across the globe.
• Proven ability to quickly learn and apply new technologies. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Business Intelligence: OBIEE 10.1.3.4.1, BI Applications 7.9.6.2, DAC 10.1.3.4.1, Procurement and Spend Analytics, OUM, BI Publisher 10.1.3.4.1,SAP Business Objects XI 3.1/XI R2/XI/6.5/6.1/6.0/5.1, Informatica Data Analyzer (PA 8) & Power Analyzer 5.X/4.X, Xcelsius, COGNOS.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing, Investment Banking and Life Sciences Domain knowledge.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

ETL: Informatica Power Center 8.X/7.1.2/9.0.1 Power Mart 6.2/5.1.1, Workflow Manager, Work flow Monitor, ETL, ETI, Data mart, OLAP, OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader, Business Objects Data Services 3.1/ Data Integrator XIR2, Data Quality XIR2, Data Insight XIR2,SAP Net Weaver.

Databases: Oracle10g/9i/8i/8.0/7.x,Netezza 7.3,MS SQL Server 2005/2000/7.0/6.0, Sybase 12.x/11.x, MS Access.

Programming: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB,VB.net, C, C++.

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos.

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Lead

Responsibilities:

• Involved in full life cycle implementation of Procurement and Spend Analytics including installation, configuration, extension and customization for 90+ source systems
• Worked with functional, finance, and other business groups to identify, analyze, document business requirements and prepare technical specifications
• Installation, Configuration and Administration of OBIEE, Informatica and Datawarehouse Administration Console(DAC) on Windows
• Implemented MUDE (Multi User Development Environment) in OBIEE
• Managing OBIEE presentation services and object catalogs for multiple sets of business models and subject areas in a cluster environment
• Performed high level Implementation and Administration tasks related to the development and configuration of dashboards
• Managing OBIEE metadata in Deploying the RPD, Web Catalog in OBI Clustered environment
• Ensure the overall health and performance of OBIEE to include Performance tuning, environment reliability and availability
• Customized and configured Skins and Styles for Ingersoll Rand
• Modified and Created Dashboards with prompts, Charts, Pivot tables
• Implemented Write Back Feature in OBIEE, a solution to insert update data in the database
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance
• Configured Bi Scheduler and created iBots to schedule and deliver Analytics content to multiple delivery destinations and also as Cache Seeding mechanism
• Implemented the Caching Strategy according to the client’s data load frequency
• Developed repository model for Write Back logic that involved creating the Physical, BMM and the Presentation layer. Also implemented Security Model, created hierarchies, variables in the repository
• Migrating RPD, Web Catalog from Development to Test and Production Environments
• Query monitoring and load balance of user Queries on enterprise management
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using OBIEE
• Used OUM methodology to check the quality and to control checkpoints to all project activities throughout the projects.
• Worked through different phases like Inception, Design,Build,Transition, productionphases of OUM for the BI Projects.
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Created complex measures in BMM(Business Model and Mapping Layer) using Time Series calculations and different Aggregation Strategies
• Configured drill downs for various types of Hierarchies using Dimensional Hierarchies in BMM layer
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the connection pool settings according to the requirements
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created common header and footer templates for all the reports in Answers
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Extended the Informatica mappings and workflows by adding custom columns to existing Fact and Dimension tables.
• Worked on extracting data from EBS OLTP tables, flat files and excel files and loading data into OLAP system by designing new Fact and Dimension tables and custom Informatica mappings to load them
• Worked extensively with Informatica Designer tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Migrated DAC(Data warehouse Administration Console) execution plans between instances
• Configured sources, targets, execution plans and registered new DAC tasks to run Informatica workflows
• Monitored Full and Incremental data loads using DAC
• Involved in BI Apps Performance Tuning Discussions with Oracle.
• Designed invoices & working paper reports which also include the daily, monthly and annual generated Energy by using BI Publisher.
• Created Complex Matrix reports in BI Publisher for Daily, Monthly and Annual reports.
• Worked on converting existing Crystal reports to BI publisher reports.
• Used Sub Templates for calling the Header, Footer and the Watermark from a single template to all the reports.
• Worked on using variables for Totals and Subtotals in BI Publisher.

Environment: OBIEE 10.1.3.4.1, BI Applications 7.9.6.2, Informatica Power Center 9.0.1, 8.6.1, DAC 10.1.3.4.1, Procurement and Spend Analytics, Oracle 11g, OUM, BI Publisher 10.1.3.4.1,Toad, SQL Developer, PL/SQL, Windows.

Confidential, Atlanta GA

OBIEE Lead

Responsibilities:

• Involved in full life cycle implementation of Financial, Supply Chain and Procurement Analytics including installation, configuration, extension and customization
• Worked with functional, marketing, sales, finance, and other business groups to identify, analyze, document business requirements and prepare technical specifications
• Configured Integration of OBIEE with EBS environment using SSO
• Configured Bi Scheduler and created iBots to schedule and deliver Analytics content to multiple delivery destinations and also as Cache Seeding mechanism
• Implemented the Caching Strategy according to the client’s data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Implemented MUDE (Multi User Development Environment) in OBIEE
• Extended the Informatica mappings and workflows by adding custom columns to existing Fact and Dimension tables.
• Worked on extracting data from EBS OLTP tables, flat files and excel files and loading data into OLAP system by designing new Fact and Dimension tables and custom Informatica mappings to load them
• Worked extensively with Informatica Designer tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Extensively worked on various transformations like Aggregator, Lookup, Sequence generator, Filter, Normalize, Source Qualifier, Router, Joiner and Update Strategy
• Migrated DAC(Data warehouse Administration Console) execution plans between instances
• Configured sources, targets, execution plans and registered new DAC tasks to run Informatica workflows
• Monitored Full and Incremental data loads using DAC
• Created complex measures in BMM(Business Model and Mapping Layer) using Time Series calculations and different Aggregation Strategies
• Configured drill downs for various types of Hierarchies using Dimensional Hierarchies in BMM layer
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the connection pool settings according to the requirements
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created common header and footer templates for all the reports in Answers
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Customized the OBIEE messages by creating Custom Message XML files
• Created Dashboard Prompts for Selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching
• Integrated OBIEE with BI Publisher and created Bi Publisher reports using OBIEE metadata (Requests and Subject Areas)

Environment: OBIEE 10.1.3.4.1, BI Applications 7.9.6.1, Informatica Power Center 8.6.1, DAC 10.1.3.4.1, Financial Analytics, Order Management Analytics, Procurement and Spend Analytics, BI/XML Publisher, Oracle 10g, Toad, PL/SQL.

Confidential, Manchester

OBIEE Lead

Responsibilities:

• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Managed Oracle Delivers, Scheduler & iBots.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Developed several mappings to load data from multiple sources to data warehouse.
• End user training and documentation of functional and technical specs.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, Informatica 8.5.

Confidential

BO Lead/Solution Architect

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects.
• Used Aggregate tables in the universes for the query optimization process and Designer Functions like @Prompt, @Select, @Where to create and define condition objects and prompts required to generate reports.
• Developed WebI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL at Report level.
• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the
• Info view.
• Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, percentage reports, Prompts using Web Intelligence.
• Created Analytics, Metrics, Calendars and Dashboards using Business Objects Performance Management.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Responsible for migration of BO Objects(Universes, Reports) to various cycles of the Enviroment - Dev to Test and from Test to Production.
• Designed Universes by creating prompts, queries and applied Contexts and Aliases to remove loops.
• Created new classes & User Objects in designing the Universes, Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Managed all CMC content including reports, universes, folders, scheduling and Business Objects application and content access levels.
• Extensively worked on Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Created various filters at both Universe and report levels.
• Worked with Informatica ETL team in gathering required data tables and resolving data issues if any.
• Participated in regular status meetings with co-developers and Manager to discuss the progress of the assignment.
• Performed unit testing of the reports and involved in UAT at all stages.
• Responsible for data modeling and building the framework model.
• Involved in effort estimation, status reporting, team management, Project Management and onshore-offshore project co-ordination.
• Worked as the Software configuration coordinator and defect prevention coordinator in the project.
• Imparted trainings to team members whenever required.

Environment: Business Objects XIR3.1, Web Intelligence, Performance Management XIR2, Universe Designer, Netezza 7.3, Informatica 7.5.

Confidential

BO Consultant

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Set up and tune reporting environments.
• Developed various Ad-hoc reports with complex funstions inlcuding aggregate aware, @prompt, report level objects, filters and Derived Tables to speed up and fine tune the performance.
• Created templates in WEBI and Desktop intellegence for standardization of corporate documents.
• Transformation from legacy reporting to Business Objects XI version.
• Utilized scope of analysis technique to created complex Dill down hierarchical reports to provide broad to granular report detail level.
• Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on server
• Created Reports with heavy conditional formatting and functions to meet user requirement.
• Daily managed delinquent accounts and system updates of activity on accounts.
• Thoroughly written project documentation and the user manual.
• Identified potential problems and timely communicated them to management.
• Communicated specific enhancement requests, impact, alternative solutions and work-around.
• Identified and resolving key business challenges, applying best practices to the architecture of development objects.
• Client appreciated our performance and dedication towards the project.
• Got ETAC hero of the week award for the excellent performance on this project.

Environment: Business Objects XIR2, Oracle 9i, Informatica 7.5, Universe Designer.

Confidential

BO Consultant

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Created Different Universes for separate reporting requirements which run against Oracle 9i Database.
• Created classes and objects and gave business names and logically grouped them together.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies.
• Used different business objects @functions like @select, @where, @prompt, Hierarchies, custom LOV’s.
• Created Full Client reports using different Data providers like Oracle, MS-Excel, and MS-SQL server.
• Extensively used slice and dice for generating master/detail and tabular reports.
• Created Reports from Excel files using Business Objects through Personal data files.
• Strong working knowledge of Business Objects Web Intelligence, Desktop Intelligence
• Created Mappings, lookups and transformations on ETL level using Informatica.

Environment: Business Objects XIR2, Oracle 9i, Informatica 6.1

Confidential, Walnut Creek, CA

BO Consultant

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Created Different Universes for separate reporting requirements which run against Oracle 9i Database.
• Created classes and objects and gave business names and logically grouped them together.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies.
• Used different business objects @functions like @select, @where, @prompt, Hierarchies, custom LOV’s.
• Created Full Client reports using different Data providers like Oracle, MS-Excel, and MS-SQL server.
• Extensively used slice and dice for generating master/detail and tabular reports.
• Created Reports from Excel files using Business Objects through Personal data files.
• Strong working knowledge of Business Objects Web Intelligence, Full Client.
• Well versed in Business Objects with experience in Supervisor, Designer, Reporter, BCA Server Web Intelligence 2.5/2.6.1/6.0, and Info view, Application Foundation, Dashboards, Auditor and Schema Design.

Environment: Business Objects 6.5, Web Intelligence, Info View, UNIX.

Confidential

Software Engineer

Responsibilities:

• Design the flow diagrams, E-R diagrams and sketching out the requirements of the operators.
• Designing of new databases incorporating existing concepts and normalizing databases in MS Access and SQL Server.
• Designing and coding of front-end application in Visual Basics as they have Visual Basic as their licensed software.
• Interacted with the users for understanding and gathering business requirements.
• Created and maintained catalogs using Impromptu Administrator
• Installed and Configured COGNOS series 7 (IWR, Upfront, PPES and Access Manager)
• Created IQDs in Impromptu and used these IQDs as data source for creating structure of the model and cube in Power Play transformer.
• Used COGNOS Impromptu to create Catalog files, created IMR/IQD using COGNOS Impromptu.
• Created Catalog and assigned joins as per the requirements.
• Created standard and Ad-hoc reports (Formats, Layouts, quality data to carry) using COGNOS Impromptu.
• Implemented filters, calculations, graphs and prompts.
• Set up drill through functionality between reports.
• Design and Development of dash board applications using Visualizer.
• Created Exception highlighted reports and ranked reports.

Environment: Microsoft Visual Basic 6.0, Microsoft Visual Studio .NET, MS SQL Server 2005, MS Access, Windows 2003 server, COGNOS.

Confidential

Software Engineer

Responsibilities:

• Installation of Business Objects.
• Assist in establishing a Business Objects environment.
• Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and
• developing new and maintaining existing reports.
• Generates several periodical reports like daily, fortnightly, monthly and yearly etc.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, complex conditions on queries, combined queries.
• Designed reports that contain data from different data providers.
• Created several user objects according to the user requirements.
• Designed several master-detail reports with drill down analysis, which can be used in the analysis purposes. Analyzed the data using drill-down, slice and dice.
• Responsible for end-user training to work on reports.

Environment: Windows 2000, Oracle 8i, SQL Plus, Oracle Discoverer, TOAD, Business Objects 5.1.x, Web Intelligence 5.1.x and InfoView.