SUMMARY:

• Over 8 years Information Technology experience including 6 years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps). Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, Informatics, DAC ETL tools, System Analysis, Design and Data Modeling.
• Experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE), including 3 full life cycle implementations.
• Sound knowledge of Data Warehousing Concepts.
• Good understanding of developing logical and physical Data Models using Erwin.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Worked with Oracle OLAP server like Essbase.
• Experience in Deploying data for ETL and data warehouse objects and administrating metadata using Data Warehouse Application Console (DAC).
• Exposed in performing various Tests in debugging and correcting errors before they go in to the Production code.
• Worked with OBIEE for the reporting and OWB to build DataWarehouse on the Oracle.
• Implementation of Oracle E-Business Suite’s Oracle Financials and Supply Chain which include General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Cash Management (CE), Order Management (OM), Inventory (INV), Pricing (QP), Shipping (WSH), Trading Community Architecture (TCA).
• Good understanding of Oracle RAC nodes.
• Integration of OBIEE on EBS like Oracle R12.
• Worked on MD .050 and MD .070 documents from AIM (Application Implementation Method).
• Used OBIEE catalog manager and merge the catalogs developed by different developers
• Proficient in ETL processes of creating Source/Target definitions, building Mappings/Mappletsusing various Transformations, creating and monitoring Sessions/Workflows
• Extracted datausingFinancial Analytics, Order Management Analytics through DAC from various modules like HR, Payroll, Financial etc.
• Working in Software Development Life Cycle (SDLC) through requirements analysis, design specification, testing and maintenance of applications using Java/J2EE technologies.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Proficient in writing PL/SQL Procedures, Functions, Packages, and Database triggers.
• Configured DAC for Financial Analytics and extracted data through Informatica
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Installed and configured OBIEE.Admin tool and Siebel web components including Intelligence Dashboards, answers, delivers and Analytics web and BI Publisher.
• Experience in Pharmaceutical, Insurance, Financial and Marketing industries.
• Acquainted with service orient architecture in order to integrate with external systems such as ESB, JMS, SOAP
• Experience in prebuilt and customized OBI Applications like Finance, Marketing, pharmacy, Workforce analysis, HR, OM.
• A quick learner with an eye for detail and excellent analytical and quantitative skills

TECHNICAL SKILLS:

Methodologies: Dimensional Data Modeling Logical / Physical

OBIEE Tools: Oracle BIEE 11.1.1.6.8 /10.1.3.1/3.2/3.3/3.4 , Oracle BI Applications 7.9.5/7.9.6/7.9.6.4.

ETL Tool: ODI 10g (10.1.3.5, 10.3.5.6) and ODI 11.1.1.7, Informatica 8.6.0/8.6.1/9.1 Informaticaon Demand & DAC

OBI Apps Modules: Oracle Financials GL, AP, AR, Oracle SCM OM, PO, INV,Oracle Manufacturing OM, PO, INV, Sales Analytics, Procure and Spend AnalyticsHuman Resource Analytics project Analytics.

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

Database Tools: TOAD, SQL Navigator, SQL* Loader, SQL* Plus, SQL* Developer, MySQL.

Languages: SQL, PL/SQL, XML, Java

Web Technologies: HTML, JSP, XML.

RDBMS: Oracle 11g R1/10g/9i/8i/7.x, MS Access, SQL Server 7.x.

Operating System: UNIX, Windows NT/XP/2000/98, Linux, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential, IL

OBIEE/ODI/ BIApps Developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica.
• Worked on customizing the OBIA Prebuilt mapping and loading metadata into DAC for initial full load.
• Worked on adding new tasks to the DAC.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements.
• Created catalog folder in the presentation layer and setup visibility of the presentation catalog to users with respect to their responsibilities.
• Added data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Migrated Analytics RPD and Webcat from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sign on (SSO).
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• 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 suite.
• Customized Dashboard pages like Marketing, Field Sales, Marketing Service, and etc.
• Installing and ConfiguringODI 11.1.1.6 on all the environments with standalone agents for custom Data Warehouse project.
• Upgrading ODI from 10.1.3.4 to 11.1.1.6.0. , and applying patch from 11.1.1.6.0 to 11.1.1.6.4 .
• 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.
• Created the users, profiles using the ODI security manager.
• Extensively worked and utilized ODI Knowledge Modules (Reverse Engineering, Loading, Integration, Check, Journalizing and service)
• Created various procedures and variables.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Creating standalone agent on windows server.
• Implemented CDC through ODIJournalizationKnowledge Modules (KMs).
• Configuring windows standalone agents with OPMN and running windows agents as services.
• Patching ODI 11.1.1.6.0 to 11.1.1.6.4 .
• Upgrading ODI from 10.1.3.4 to 11.1.1.6.4 .
• Worked with the team and a DBA to communicate and negotiate data needs
• Developed various report for data extracts in different format for
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Details Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Environment: OBIEE 11.1.1.6.8 , BIApps 7.9.6.4 (HR Analytics,SCM Analytics, Procure and spend analytics ), Informatica 9.0.1, DAC 11.1.1.6.4 , ODI 10.1.3.4, ODI 11.1.1.5.0 , ODI 11.1.1.6.4 Oracle EBS 11i/R12, SQL*PLUS, SQL Developer, Toad, Windows XP.

Confidential, Atlanta, Georgia

OBIEE/BIApps Developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica.
• Worked on customizing the OBIA Prebuilt mapping and loading metadata into DAC for initial full load.
• Worked on adding new tasks to the DAC.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements.
• Created catalog folder in the presentation layer and setup visibility of the presentation catalog to users with respect to their responsibilities.
• Added data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Migrated Analytics RPD and Webcat from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sign on (SSO).
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• 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 suite.
• Customized Dashboard pages like Marketing, Field Sales, Marketing Service, and etc.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Details Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Environment: Oracle Business Intelligence (OBIEE) 10.1.3.2.1 , Oracle 10g/9i, SQL Server 2000, Linux, Windows.

Confidential, Wooddale, IL

OBIEE Developer

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gap
• Extracted data from Various ERP Systems like Siebel OLAP database, Oracle E business Suite (EBS)
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer
• Implemented Security for various users and groups using External Table Authentication
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Responsible for creation of pivot table requests and bar/column charts allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector/view selector, multi-select page prompts
• Created and used Siebel Delivers and iBots extensively
• Performance Tuning of database, sources, targets, mapping and session was performed.
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment
• Developed Informatica mappings with re-usable transformations and mapplets using various transformations
• Extensively involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL
• Developed / modified mappings per gaps identified
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution
• Coordinated the Analytics RPD and Web Catalog objects migration from Development environment to QA environment and to the Production environment

Environment: Sun Solaris, SQL Server XML, Oracle Delivers, Windows XP, UNIX/Linux, Shell Scripting, Oracle 10g

Confidential, CT

OBIEE developer

Responsibilities:

• Involved in developing the Data Warehouse using Star schema.
• Analyzed the requirements, functional specifications and identified the source data to be moved to the Data Warehouse.
• Project involved collecting the data from different sources like Flat files, SQL Server and Oracle.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Created various data files, which included details such as all Open Purchase Orders, and all PO’s less than a particular amount.
• Analyzed the Sources and Targets and designed mappings and Transformations
• Extensively used Lookup, Aggregator, Expression, Update Strategy, Stored Procedure, Filter and Router transformations
• Involved in GAP Analysis identifying the missing/orphaned columns based on the end user requirements.
• Created, scheduled and monitored the sessions and batches using WorkflowManager.
• The Work done by the Sales Personnel was measured by the Task definition and Reported Task, this involved the amount of time the personnel was productive which included the Login and Log out time.
• Interacted with Business Users to create Subject Areas, Folders/Sub-Folders.
• Configured Physical & Business Model Layer and Web Catalog.
• Configured drilldowns, Pivot tables, Charts, reports in Siebel answers and embed them into dashboard pages.
• Filters (Prompts) and Filter Criteria were created and configured as per the business requirements
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Involved in Reconciliation Process while testing loaded data with user reports.

Environment: Windows 2000/2003, SQL-Server 2000, Query Analyzer, Oracle 8.0, Erwin, Informatica Power Center 5.1.

Mindware Soft Solutions. Hyderabad, India July2009 - April 2010

Oracle Technical Consultant

Responsibilities:

• Involved in configuring Enterprise Call Center(ECC) and performance tuning of the ETL mappings
• Administer Jobs and fix broken workflows, data loads.
• Optimize heavily loaded tables and ETL mappings.
• Extensively worked on DAC to run and schedule the workflows.
• Involved in tuning Informatica and DAC in the DEV and PROD environment.
• Worked on gathering right data from the IVR source and loading it in the warehouse.
• Configured/Customized Initialize, Universal Load, Post Load Processing (PLP) mappings and workflows for the IVR Data.
• Configured DAC to run customized workflows and created custom tasks to run IVR workflows.
• Created batch scripts in automating the archiving process for the source files.
• Involved in performance tuning of ETL processes and identified the Network Bottlenecks in large data loads
• Created indices on the customized tables to improve the performance of the end user application (Siebel Analytics 7.8.2) generated queries.
• Worked on setting up the Siebel Analytics scheduler (IBots).
• Worked with the Production team in fixing issues with the production setup.

Environment: Siebel Analytics 7.8.x, TOAD, PL/SQL, Informatica 6.x/7.x,DAC, Windows XP.

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, OBIA,Windows XP, Sun Solaris.