PROFESSIONAL SUMMARY:

• More than 7years overall IT experience in complete Software Development Life Cycle (SDLC) in Client/ Server, Database, Oracle Data Warehouse and Business Intelligence applications in Windows and Linux/Unix environments from initiation through design, development, deployment and post go - live support.
• Proficient in Design, Development, Implementation, Administration and Support of OBIEE10g/11g, OBIA 7.9.6.x, Informatics, DAC and Oracle Database.
• Experience in building and configuring Repository, creating and managing OBIEE Intelligent Dashboards, OBIEE Answers, OBIEE Delivers, and OBIEE iBots.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, and Cache Management.
• Expertise in installation, configuration, troubleshooting, performance tuning and administration of Oracle BI EE 10.1.3.x/11g.
• Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
• Experience in DAC (Data Warehouse Administration Console) with Importing Subject Areas, Creating Execution plans, registering the Informatica Work flows, Metadata management and Scheduling.
• Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator, Abinitio, Informatica, Datastage and RDBM systems like Oracle, Teradata and SQL Server.
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Exposure to Insurance, Banking, Financial, Healthcare, Industrial sectors and business with regard to Data warehouse development.
• Worked on Financial Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics
• Experience in Designing and developing Star, Snow flake and multi-dimensional Schemas.
• Complete Knowledge of data warehouse methodologies (Ralph Kimball, Inman), ODS, EDW and metadata repository.
• Experience in Performance tuning on different levels of OBIEE objects
• Experience in Installation and configuration of Informatica Power Center 7.x/8.x and creating Mappings, Mapplets, Sessions and Workflows.
• Troubleshooting production issues and gave post production support for couple of projects.
• Good experience in Linux and writing shell scripts.
• Excellent Interpersonal communication, documentation skills and experience coordinating with project Managers, Business Analysts, Architects, DBA’s and Developers.
• Excellent Management skills, analytical and dynamic troubleshooting skills, Multi tasking, Posses good communication skills, Quick learner and adapts to new environments easily.

TECHNICAL PROFICIENCY:

Reporting Tools: OBIEE 10g/11g, Siebel Analytics 7.x

ETL Tools: Informatica Power Center9.x/ 8.x/7.x,designing execution Informatica Power Exchange.

Business Intelligence: Oracle Business Intelligence Application 7.9.6.x/7.9.5.x

RDBMS: Oracle11/10g, 9/8i, MS SQL Server 2003/2000, Access7.0/2000.

Tools: Toad, SQL*Loader, SQL Developer.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: Linux EL5, Windows NT/2003/2008, Windows 95/98/00/xp, Linux, Solaris.

Scheduling tools: DAC (Data Warehouse Administration Console)

Internet Technologies: HTML, XML, ASP, ASP.net, JSP, VBScript and JavaScript.

PROFESSIONAL EXPERIENCE:

Confidential, Novato, CA

Sr.OBIEE / Informatica Developer

Responsibilities:

• Created ETL for sourcing the data received in Excel files for vendor processed payments
• Worked on creating reports using the existing/ extending metadata content to fulfill the report requirements.
• Automated the feed transfer inbound/ outbound between Confidential and Concur.
• Worked on the creation of the dashboards for the reports developed in step 2 to provide easy access to the data.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Did SQL and PL/SQL programming for ODI and oracle.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Used ODI commands like ODI File Move, ODI File Append, ODI File copy etc
• Performance tuned the ODI interfaces.
• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Loaded the flat files data using Informatica to the staging area.
• Involved in the ETL design and its documentation.
• Involved in monitoring the workflows and in optimizing the load times.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Designed and developed InformaticaMappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Configured DAC (Data Warehouse Administration Console)for Creating Execution plans, Metadata management and monitoring the Informatica ETL Process.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
• Experience in configuring DAC to run nightly data loads on daily basis.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created SHELL SCRIPTS for generic use.
• Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Oracle Business Intelligence 11.1.1.7, Informatica Power Centre 9.5, DAC, BI Analysis, Oracle 11g, SQL Developer, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, SQL Server 2003, TOAD

Confidential, Novato, CA

ETL Developer

Responsibilities:

• Modified SDE,SIL mappings of financial analytics to Extract the data from Oracle EBS into EDW
• Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Using Informatica Power Center Modified mappings and Mapplet to transform the data according to the business rules.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Documented Informatica mapping specifications in Excel spread sheet.
• Implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Observed configuring DAC environment created and scheduled execution plans.
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Extensively used SQL scripts/queries for data verification at the backend.
• Designed and Developed UNIX Shell Scripts, Data Import/Export.

Environment: Oracle EBS, OBIA 7.9.6.x, DAC, Oracle Business Intelligence 11g, Oracle 11g, SQL Developer 1.1.3., Windows XP/ NT/2003, UNIX, Linux, Shell scripting, SQL Server 2003, TOAD

Confidential, Novato, CA

OBIEE / Informatica Developer

Responsibilities:

• Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Informatica.
• Created Shell Scripts for coping the files from Concur site to OBIEE server
• Developed ETLs to source the data from SAE into EDW.
• Created complex mappings which involved Slowly Changing Dimensions
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Involved in extracting the data from the Flat Files and Relational databases into staging area
• Monitored Workflows and Sessions using Workflow Monitor.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
• Worked on the Multidimensional data model to store the data provide support for reporting
• Created an RPD model for reporting through BI answers.
• Involved in creating Dimensional Hierarchies to support drill downs.
• Designed Security to provide controlled access to the data
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on creating Reports and Dashboard to provide access to the employee level data.
• Involved in Performance tuning at Informatica level and at Data base level.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Monitoring Incremental & Full load throughDAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Re-organized pages & reports into new dashboards.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Oracle Business Intelligence 11g, BI Publisher, DAC, Oracle 11g, SQL Developer 1.1.3., Windows XP/ NT/2003, UNIX, Linux, Shell scripting, SQL Server 2003, TOAD

Confidential, Minneapolis

OBIEE Developer / ETL Consultant

Responsibilities:

• Implemented OBIEE with Financial and Procurement & Spend Analytics against Oracle EBS
• Gathered user requirements by conducting interviews, identifying ISW reports and created SR’s and CR’s from the gathered requirements.
• Managed repository during the development using OBIEE 10.1.3.4 Admin Tool.
• Worked on SDE and SIL mappings for different Source containers like Oracle R12
• Worked on Core Modules like GL, AP, and AR.
• Used flat files to source the data from flat files into DW using Informatica Mappings, Sessions and Workflows
• Monitored performance by creating OBIEE’s Usage metrics. Improved performance by using aggregate navigation, indexes and materialized views.
• Copied existing RPD’s from server into the local machine for testing and tuning of dashboards.
• Created Metadata Dictionary for all the subject areas created.
• Migrated RPD and Catalog changes from DEV to QA and PROD.
• Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence.
• Restarting the BI Servers with RPD changes, Running Cache Scripts and Catalog Merging on Dev and QA environments on Linux.
• Created Presentation catalogs, Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
• Worked on Single Sign On security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
• Experience in configuring DAC to run nightly data loads on daily basis.
• Worked on Data Extraction Transformations, Loading, Conversions and Analysis.

Environment: Oracle EBS, Oracle Business Intelligence 10.1.3.4, BI Publisher, DAC, BI Office, OBIA 7.9.6.x, Oracle 11g, SQL Developer 1.1.3., Windows XP/ NT/2003, UNIX, Linux, Shell scripting

Confidential, Woodland Hills, CA

OBIEE Analytics / ETL Consultant

Responsibilities:

• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked on Answers, Dashboards and Security for users and creating complex reports.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Created various Static and Dynami cvariables for different report and Security requirements.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Re-organized pages & reports into new dashboards: CORE GL, AP, AR.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Configured implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.
• Configured Delivers (iBots) to alert the users based on the user needs.
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Deployed Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.
• Monitored the daily Incremental Loads in Production environment and fix any issues during the Load.
• Worked on Informatica OOB and customized SDE and SIL mappings for different Source containers like Oracle R11
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Used various transformations Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence for mappings based upon the requirement.
• Created Custom mappings to update Facts and Dimensions and worked on performance tuning of various transformations.
• Monitoring Daily ETL data load in DAC.
• Worked using DAC to perform scheduling and executing incremental loads.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Migrated Analytics RPD and Webcast from one environment to another.

Environment: Oracle Business Intelligence 10.1.3.3, BI Publisher, DAC, Oracle EBS R11,Oracle Financial Analytics 7.9.x, Windows 2k, DAC 10.1.3.4, OBIA 7.9.5, Oracle 10g, SQL Server 2003, TOAD.

Confidential

Siebel Developer / Informatica Programmer

Responsibilities:

• Worked with Informatica Power Center Source Analyzer, Data Warehousing designer, Mapping Designer&Mapplet, and Transformations for creating Mappings.
• Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports using Seibel.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Developed and Scheduled workflows using workflow Manager created and modified parameter files according to the business requirements.
• Used aggregator, sequence Generator, expression, transaction control, Normalize transformations.
• Performed requirement gathering, scope analysis and finalizing the functional points.
• Designed and developed design document for common functions and packages.
• Created DDLs to create the staging, dimension and fact tables in the Data Warehouse.
• Developed and tested PL/SQL procedures, functions and packages.
• Designed and developed packages and PL/SQL programs to find the given word matches in the text stored in columns.
• Developed wrapper programs using shell scripts.
• Also, developed Perl programs for pattern matching utilities.
• Implemented Materialized views, Bulk binding and Collections to achieve performance for PL/SQL programs.
• Prepared technical specifications and common function manuals for the releases.

Environment: Informatica Power Center 5.1, BI Analysis, PL/SQL, Oracle 8.1, SQL Server 2000, XML, PL/SQL, Perl 5.6 and UNIX, Linux, Shell Scripting, TOAD.