Summary

• Around 8 years of IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solution.
• Expertise in OBIEE 10G/11G, Oracle BI Applications 7.9.6, Informatica 8.6.1/9.0.1, ODI 12c and DAC 10.1.3.4.1.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Set up the Topology including physical architecture, logical architecture and context.
• Expertise in Building Metadata Repositories .rpd Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Expertise with developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Development of Business Reports, Business Alerts with help of Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle Ibots/Agents, Oracle BI Publisher to create reports from multiple data sources.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Caching.
• Created PL/SQL stored procedures, functions and triggers.
• Involved in designing the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Extensively used ODI Oracle Data Integrator to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology ,Manager, Designer and Operator with versions ODI 10g 10.1.3.5,10.3.5.6 and ODI 11.1.1.x
• Experience in Configuring Multi User Environment MUDE on Shared environment to allow Development team to work as well as Merge 2-Way and 3-Way Merging.
• Experience in Configuring Cache Purging Cache Seeding for Report Performance using BI Ibots/Agents
• Experience in Mappings using expression, joiner. Aggregate etc. and Sequences,precedures and Packages
• Experience in Setting up Dynamic, System and Non-System Variables in ODI.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services
• Familiar with database Performance Tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and analyzing query execution using the Explain Plan.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Updating Knowledge Modules Using Java Edit Expression for Mappings
• Experience in developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experienced with designing ETL execution plan and scheduling task using DAC.
• Experienced in Pre-Build, Packaged Oracle Analytics including Financial Analytics, Human Resources Analytics, Order Management Analytics, Procurement and Spend Analytics.
• Active participation in Presentation of Project concept, status, plans and progress.
• Good at prioritizing along critical path, meeting project milestones and deliverable dates.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

Technical Skills

Methodologies : Dimensional Data Modeling Logical / Physical

OBIEE Tools : OBIEE 11.X/10.X, OBIA 7.9.5/7.9.6/ DAC.

ELT/ETL Tool : ODI12c, ODI 11.1.1.X ,Informatica 8.6.0/8.6.1/9.0.1, Informatica on Demand.

OBI Apps Modules : Supply Chain, OM, Financial Sales Analytics.

Databases : Oracle 8i/9i/10g/11g, MS SQL Server2000/2005/2008

Query Tools : SQL, PL/SQL, TOAD

Languages : C/C , C , XML, HTML,Java.

Operating Systems : Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003/2008 R2

Other : Visio, MS Office, Adobe Acrobat.

Professional Experience

Confidential

OBIEE Developer

Responsibilities:

• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems Flat files, Active Directory-LDAP, SQL Server and Oracle .
• Created Repositories, Agent, Contexts and both of Physical Logical Schema in Topology Manager for all the source and target schemas.
• Knowledge on OBIA 11.1.1.8.1
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers.
• Created Reports, Dashboard Prompts and Dashboard Pages like Budget and Actual, Balance Sheet.
• As an administrator I was responsible for security across multiple users and groups.
• Created PL/SQL stored procedures, functions and triggers.
• Created ODI Packages, Mappings Jobs of various complexities and automated process data flow.
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules KMs .
• Developed Expressions, filter, joins,Split,Variables,user functions Using ODI
• Developed interfaces for loading the lookup and transactional data
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, ODI12c, ODI 10.1.3.4, ODI 11.1.1.5.0, Oracle 11g, SQL PLUS, SQL Developer, Toad, Windows XP

Confidential

OBIEE Developer

Responsibilities:

• Developed GO URL's for various Reports, Dashboard Pages and Dashboard in Report, PDF, PowerPoint and CSV formats.
• Created Repository and session variable in RPD.
• Worked on Navigator Portal with Share Point team. Complete responsible for Book of Business and Portfolio Management reports.
• Designed level measures and aggregate calculation using RPD
• Used Filters and provided customized prompts filtering options appropriately to avoid excessive data showing up reports.
• Created Reports, Dashboard Pages like Book of Business Summary View, Expanded View, Exposure View, Targets View, Aggregates View, etc.
• Performed high level and detailed design of the star schema.
• Custom built the repository RPD from the scratch with Facts like Position Summary Trade Date, Holdings Trade Date, Holdings Settle Date and 9 Dimensions and 4 confirmed Dimensions.
• Analyzed reporting Investment Reporting requirements for dashboard reports.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, and testing and project coordination.
• Installation, Configuration of OBIEE 11.1.X and TOAD.
• User Level Permission for Region Manager done in RPD.
• Implemented Security using WLS Admin Console, EM Fusion Middleware and Identity Manager.
• Involved in upgrading from OBIEE 10g to OBIEE 11g.
• Worked on Oracle Enterprise Manager to activate and Deploy RPD, Security, Capacity Management etc.., in OBI 11.1.1.6.
• Used Java J2EE code for RESET FILTER BUTTON, and for removing Print, Download icons from the Dashboard page.
• Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.
• Complete responsible for preparing the END to END Document.
• Worked with the QA team Onsite on SIT and UAT issues.
• Supported PROD environment.
• Daily coordination with offshore OBIEE development team.
• Worked towards the knowledge transfer with support team for smooth transition.

Environment: OBIEE 10.1.3.4.1/11.1.1.6, OBIA, Oracle EBS, Informatica 8.6.1, DB2, TOAD, JIRA, Windows XP, UNIX, RPD, Share Point, Version 1, Navigator Portal.

Confidential

OBIEE Developer

Responsibilities:

• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables
• Created FACT table Calculation in RPD
• Developed Expression calculation,join,split,filter,procedures,varibales,packages using ODI12C
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities.
• Studied the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Created Global and project variables in ODI
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Created Facts like Opportunity, Project for Project Portfolio Subject Area.
• Created Metrics like Conversion rate, Amount in USD.
• Created Customized Dashboards like Pipeline, Project Portfolio catering to provide insight into the sales / marketing / financial data.
• Developed Dimension Hierarchies in BMM layer in RPD
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards and dashboard prompts.
• Created BI Publisher report based on Answers report
• Worked on OBIA on Supply Chain module in organizing data and implementing security.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes and managed day-to-day Repository, Scheduler iBots.
• Managing appropriate security privileges on subject areas Data Level and dashboards Object Level according to business requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Integrating and automating Informatica workflow loads using DAC.
• Created tasks and execution plans in DAC and scheduling the ETL run.
• Developed customized mappings, sessions and workflows for some of the Subject Areas, using the Informatica Power Center Designer, Power Center Workflow Manager.
• Created new reports in BI Publisher and made substantial modifications to existing reports, to meet new needs.
• Involved in unit testing, integration testing, Functional testing to analyze and fix the issues encountered.
• Performed end-user training to develop ad-hoc reports using OBIEE Answers.

Environment: OBIEE 10.1.3.4, RPD, OBIA 7.9.6, Oracle EBS, ODI 10g, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Created metrics like MTD Sales, QTD Sales, YTD Sales, MAGO Amount, QAGO Amount and MTD Expected Revenue, Opportunity Amount.
• Custom built the OBIEE repository RPD from the scratch with 4 Facts and 9 Dimensions and 4 conformed Dimensions.
• Performed Execution plans in the DAC Console.
• Created reusable transformations and mapplets and used them in mappings.
• Created Facts like OpportunityLineitem, OpportunityHistory, Sales, Budget, Goals and dimensions like Opportunity, PriceBookEntry, User, Region, Account,
• Worked on extracting the legacy data from the application.
• Extensively worked in developing SalesForce Adapters for Sales and Opportunities.
• Developed new Adapters using Informatica 8.6.1, complete end to end development against Salesforce.com source.
• Extensively used Informatica On Demand for replicating the data from Sales Force to local Database.
• Extracted data from various source systems like relational data bases, Flat files and data into the datawarehouse using Informatica On Demand.
• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Installation, Configuration and Administration of Informatica Power Center Client , Server 8.6.0 ,Oracle 10g and OBIEE 10.1.3.4
• Performed high level and detailed design of the star schema as well as the reporting metadata.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements..
• Developed process for object level migration of web catalog, for post-production release of - enhanced and bug fixed reports
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool.
• Developed complex and rich Reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.
• Created some Reports for analyzing the Trend in Opportunities, sales and Sales Reps Efficiency.
• Analyzed reporting requirements for dashboard reports and created dashboard prompts.
• Complete responsible for preparing the END to END Document.

Environment: OBIEE 10.1.3.4, Informatica 8.6.0, DAC 10.1.3.4, Informatica On Demand, Sales Force, Flat Files, Oracle10g, Windows XP, PL/SQL, TOAD.

Confidential

PLSQL/ETL Developer

Responsibilities:

• Developed Syndicated oracle packages to include the rolling 24-month syndicated third party data that was mainly in flat files.
• Involved in designing the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• 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 9i, TOAD, PL/SQL, Informatica 6.x/7.x, Windows XP, Sun Solaris.

Confidential

SQL PL/SQL Developer

Responsibilities:

• Participated in Requirements review
• Involved in developing E-R model Entity-Relationship
• Developed the SQL queries to create tables and Views.
• Developed PL/SQL procedures, functions, Triggers using TOAD.
• Loaded Data using SQL loader and developed the control files for the same.
• Developed custom reports using SQL Plus.
• Wrote and executed test plans, maintained versions of change components to ensure accuracy and update.
• Tested the software using many methodologies like Functional Testing, Load testing, and Regression Testing. Tuned few queries to resolve Performance issues.
• Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.
• Developed workbooks and worksheets using Oracle Discoverer for custom queries for analyzing data.

Environment: Oracle 8i, TOAD, SQL Loader, Oracle reports, Oracle Discoverer