SUMMARY

• Having 7 years of IT experience in Complete Software development Life cycle SDLC of Database, Data warehouse and Business Intelligence Applications using Informatica and Siebel Analytics which includes experience in OBIEE 10.1.3.x/11.1.1, Administration tool, Intelligent Dashboards, Answers, Delivers, Oracle BI Publisher, and Oracle BI Applications 7.9.5 DAC , Oracle Data Integrator 11g.
• Strong knowledge on .Net frame work which includes c,c , Asp.net, Ado.Net, Mvc frame work.
• Strong knowledge on Html, xml, Jquery, Java Script.
• Proficiency in developing OBIEE Repository at the Physical, Business and Presentation Layers Data Modelling , Time Series Objects, Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE/Siebel Security setup users/group, access/ query privileges , configuring OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog objects Dashboards, Pages, Folders, Reports and Scheduling iBots.
• Experience in Building Data Warehouses Star Schema and Snow Flake Schema from OLTP and ODS Databases performing ETL from different Data Sources using Informatica.
• Experience in performance tuning of reports
• Experience in Oracle Data Integrator development
• Worked on ODI with data source as Oracle BI server by connecting using JDBC driver.
• Strong Proficiency in Business Objects, Oracle database 11g, SQL, TOAD/SQL Developer and UNIX
• Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Job Manager, Catalog Manager, BI Publisher, Marketing and Disconnected Analytics.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Working Knowledge of tables, processes and configurations
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, functions, procedures etc 11g,10g/9i/8i
• Highly experience in following standard Workflow structure WFS in development.
• Hands-on experience with the installation, configuration and management of Oracle and Microsoft SQL Server 2008/2005 databases running on various versions of Windows and UNIX platform
• Strong understanding of OBIEE 11g concepts, especially in configuring Security settings using Weblogic Server Users and Groups , Oracle Enterprise Manager OEM for Roles and Privileges and Presentation Catalog, Score Cards, Key Performance Indicator KPI
• Experience in Implementing QA, Generating test scripts and Writing Test Case.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.
• Good experience in using Application Implementation Methodology AIM
• Strong understanding of the organization's goals and objectives.
• Good knowledge of applicable data privacy practices and laws
• Strong knowledge of business processes involved in Supply Chain Management.

Technical Skills :

Languages: ASP.NET, C .NET, VB.NET, ADO.NET, SQL, ASP, PL/SQL,

OLAP TOOL: OBIEE 10.1.3.4.2,OBIEE 11g,Oracle BI Apps

Other Tools: Integration services SSRS, SSIS , Microsoft identity Life Cycle Manager, Forefront identity manager.

ETL Tool: Informatica Power Centre 8/9.5

Platforms: Windows NT/2000/XP/2003/2005

Databases: SQL Server 2000/2005/2008/2010, Oracle, PL/SQL

Web Technologies: XML, XSLT, IIS 7.0/6.0/5.1, HTML, DHTML, CSS, SOAP.

Web Server: IIS 5.0/6.0 Internet Information Server .

Work Experience

ROLE : Sr. OBIEE DEVELOPER

Confidential

Responsibilities:

• Involved in gathering technical requirements and preparation of Requirement Specifications documents from various end users.
• Monitored each and every dashboard loading time and defaulted prompts to show less data when report loads initially and took several performance tuning measures for good performance.
• Involved in design and development of repository Creating / Modifying objects in Physical, Business and Presentation layer and the process of repository migration.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Migrated all reports from BIEE 10G to BIEE 11.1.1.6.6
• Closely worked with users, Business Analyst, Program manager to get requirements and clarifications about new changes to the current reports, business objectives and user requirements.
• Created different lookup reports like Account lookup, Single Deal look up reports for debugging issues for manager, Analyst and users as well.
• Closely worked on IBM Data pro and Oracle Flexcube to understand Business Transactional data
• Installed OBIEE and Oracle 11g in Windows Professional Environment and configured them for the end users.
• Worked and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in BI Repository .rpd using Oracle BI Administration Tool.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Created Users, Groups and giving the permissions in OBIEE Administration Tool and verifying the Permissions of the users in OBIEE web.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Responsible for unit testing, integration testing of the reports generated using BI analytics.
• Involved in the migration of from Dev to QA and Production and providing permissions and access to the end users.
• Supported the Business with the publishing of daily and weekly reports, fixing the codes and bugs, designing the layouts.
• Implemented Comprehensive Security Model, by creating User Roles and Web Groups, and setting up External Tables and LDAP Servers.
• Created new universe and also modified existing universe for creating WebI reports.
• Created Crystal Reports using Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports.

Environment: OBIEE 10g, OBIEE 11.1.1.6.6, Oracle 10g, IBM data pro, Oracle Flex cube, SQL, PL-SQL, TOAD 9.5, Informatica 9.0, MS-Excel

ROLE : Sr. OBIEE Developer

Confidential

Responsibilities:

• Configured MUDE Multiuser development Environment and as well as define an SCM process to address parallel developments
• Assist development team with tool configuration and customization, process definition for parallel development using MUDE Multi User Development Environment , troubleshooting of errors, implementing friendly error messaging
• Improve configuration: Work with environment lead to improve troubleshooting of issues. Including documentation explaining how to set up the appropriate log levels on all OBIEE/Web Logic logs
• Provided developing changes to application UI as well as user facing error messaging
• Support application installation on all environments up to UAT , PROD acceptance
• Documented all configuration changes including how the lifecycle should be adopted when working with MUDE
• Migrated the code from DEV to all testing environment SIT,UAT and to PROD
• Merged and Deployed the RPD in all the Environments.
• Upgraded from OBIEE 11.1.1.6.0 to OBIEE 11.1.1.6.8 on Linux Environment
• Customized the OBIEE UI with Dell company Logo
• Provided the Proxy Act capability to the Business users.
• Provided the SSO security setup by configuring the Weblogic .

Environment: OBIEE 11.1.1.6.0/11.1.1.6.8, OBIEE HR Analytics, PeopleSoft, Oracle 10g , SQL, PL-SQL, TOAD 9.5, Informatica 9.0, MS-Excel, MS SQL Server 2012, Windows NT

Role : Sr. OBIEE DEVELOPER

Confidential

Responsibilities:

• Implemented Financial Analytics and Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL . Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Extensively worked on SRs as per the client's requirement to get the reports for the Business Analyzation.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Created Environment Variable on Unix/Linux Environment.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Responsible for extracting Data from Oracle Apps Modules loading into stage system and warehouse system.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in iProcurement, Payables and General ledger.
• Developed 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.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed InformaticaMappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed and Developed Sessions and Workflows.
• Conducted training Sessions on Informatica power center.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

ENVIRONMENT: OBIEE 11.1.1.6.X, BI Apps 7.9.6, Informatica 8.6.0, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, EBS 11i, R12, Discoverer 10g/4i/3i, Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, , SQL PLUS, SQL Loader, TOAD, Unix.

Role: OBIEE Developer

Confidential

Responsibilities:

• Created Dashboards and Answers for End user.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Setup Multi User Development Environment MUDE in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica Workflow Monitor.
• Responsible for extracting data from Oracle Apps Modules loading into stage system and warehouse system.
• Created and ran Sessions Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Created VPD security for reports in OBIEE.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Created custom reports in Payables in OBIEE according to user requirement.

ENVIRONMENT: OBIEE 10.1.3.2, Informatica 8.1.1, BI Apps 7.9.5, DAC 7.9.5, Oracle Applications 11i/R12 I procurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, , SQL PLUS, SQL Loader, TOAD, Unix.

Role: OBIEE Developer

Confidential

Responsibilities:

• Interacted with Operations and Subject Matter Experts SME , Business Analysts and Users in gathering and analysing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Marts.
• Using ODI Topology manager, i had define the system architecture, connections, databases, data servers, tables etc.
• Have Used Oracle Data Integrator's reusable reverse engineering knowledge modules RKMs
• To retrieve nonstandard metadata from databases PeopleSoft
• Have worked on different type of knowledge Modules of ODI
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Installed and configured ODI 11g
• Involved in designing and developing subject areas in Repository .RPD catering to the OLAP reporting needs of OBI Project.
• Customized/Modified by importing the newly designed fact and dimension tables and configured it in the 3 layers of the RPD. Created the required aliases, views in Physical layer. Implemented Level Based Metrics in the BMM layer. Implemented the Time Series Wizard for comparing measures in different time Periods. Created Compound facts in the BMM as per the client requirement. Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables which are used for authentication and security.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests drill-downs and guided navigation . Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Performance tuning in OBIEE for star schema's by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Created Management and Executive level Dashboards and KPI using OBIA from PeopleSoft data source for CRM analysis
• Involved in Unit, Integration testing and User Training of the generated reports.
• Worked with Quality Center for logging, tracking and fixing bugs in QA Testing.
• Involved in migrating of OBIEE/Siebel Analytics code from dev - UAT- Prod for deployment.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Installed and configured OBIA 7.9.6.x for HR analytics module
• Extensively created custom reports with custom tables using HR repository
• Created Operations metrics reports using HR analytics for the Business users
• Worked in Production support.
• Developed complex new Informatica ETL process and Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Performed High performance Batch Load using Oracle Data Integrator

Environment: OBIEE 10.1.3.4.1/11.1.1.3, OBIA 7.9.6.3, PeopleSoft, Oracle 10g , Oracle data integrator11.1.1, SQL, PL-SQL, TOAD 9.5, Informatica 8.1, MS-Excel, MS SQL Server 2005, Windows NT

Role: ORACLE DEVELOPER

Confidential

Responsibilities:

• Developed Syndicated oracle packages to include the rolling 24-month syndicated third party data that was mainly in flat files.
• Provided support activities to their existing warehouse by developing new PL/SQL programs to support their existing structure and also data validation.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
• Developed complex new Informatica ETL process and Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Designed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex Informatica mappings and mapplets to build key interfaces using transformations reusable transformations Source Qualifier, Update Strategy, Lookup, Expressions and Aggregator for loading the data into DW.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable / parameters for simplifying complex mappings.
• Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
• Developed many Shell Scripts for pulling data from remote machines, Backup / Migration of metadata from version, development and production, FTP, untar sending files to source directory, managing sessions files in the server.
• Extensively developed complex PL/SQL packages for ETL.

Environment: Oracle 10g R2, TOAD, Informatica 6.x/7.x, Windows XP, Sun Solaris.