SUMMARY

• Over 8 years of experiencein Information Technology in designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments with Core focus on Data Warehousing OLAP tools, BI and PL/SQL.
• Experience in various domains like Education,HealthCare, Finance, Manufacturing, Retails and Insurance.
• Experience in complete SDLC with Agile methodology (gathering Business Users Requirements, Analysis, Design & Modeling, Development, and Testing) of Business Intelligence using Oracle Business Intelligence (OBIEE)/ Siebel Analytics.
• Extensively worked with large Databases in Development, Testing and Production environments.
• End to End OBIEE Expertise in configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects, Time series objects and scheduling IBots.
• Expertise in Data Warehousing tools like OBIEE/Siebel Analytics, ODI. Exclusively worked on OBIEE Administration - Developing OBIEE Metadata repository (.rpd)models that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies & time series functions, Presentation layer with catalogs & folders using Oracle BI Administration tool. Created global Prompts used can be used across dashboards with default values.
• Experienced in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Experienced in configuring the security settings inOBIEE Administration Toolto set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication.
• Expertise in Installation of OBIEE 11g, Upgrade from 10g to 11g on single and clustered servers, Migration of RPD/Web catalogs across different environments.
• Expertise in cache management and Performance tuning, Debugging, optimizing at Report level and Data base level and also setting up MULTI USER DEVELOPMENT (MUD) Environment.
• Strong understanding of the principles of Datawarehousing,Fact Tables, Dimension Tables, slowly changing Dimensions, starandsnowflake schemamodeling..
• Analyzed the Business requirement for Oracle Data Integrator and usedODIfor reverse engineering to retrieve metadata from data storage and load it to the repository.
• UsedOracle Data Integrator Designer (ODI)to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator (ODI)reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Involved and Interacted with DBA Team in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Experienced with custom reports in XML/BI publisher. Automated the process of migrating Data Definitions and Templates from Instance to Instance. Created Complex Matrix reports in XML/BI Publisher Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked with the bursting team to successfully send report outputs to customer’s printer, fax, and email. Worked closely with Oracle Product Development team to resolves issues in BI publisher.
• Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability of new technology’s, Easy adaptability to new environments.

TECHNICAL SKILLS

Reporting Tools: OBIEE 11g (11.1.1.7)/10g/9i, Siebel Analytics 7.8.x/7.7.x/7.5.x, BI publisher, Crystal, Jasper, BI Apps.

ETL Tools: Oracle Data Integrator 12c/11g, Sunopsis, DAC, Informatica Power Center 8.x

Database: Oracle11g/10g/9i/8i, SQL Server, MS Access.

Languages: SQL, PL SQL, Java, C, JavaScript, Shell,Hive

Operating System: Windows 95/98/2000/XP, Windows NT, UNIX, Ubuntu.

Data Base Tools: SQL Developer, TOAD, PLSQL Developer, SQL Plus 10.x/ 9.x/ 8.x

Change Management Tools: Remedy, Clear Quest

Web: JSP,XTML,HML

Other: MS Visio, MS Office, Adobe acrobat

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. OBIEE /BI Publisher/ODI Developer

Responsibilities:

• Interacted with business representatives for gathering the Reports/Dashboards requirements and to define business and functional specifications.
• Architect of OBIEE/BI Publisher Reports Custom Interface In line with TN State Standards.
• Created OBIEE Repository(.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, and Aggregate Navigation, Level Based Measures, Variables and Initialization Blocks.
• Configured Physical Layer- Import tables, create tables, add/change physical joins/keys. Configured Logical Layer- Create Logical Tables/dimensions, Create Logical Joins/Keys, Set levels to support Drill-Down, aggregation/sum over columns, configured Presentation Layer- Create Folders/Sub-folders, Standard Queries for different User Groups.
• Created Area/group/user Specific Complex Dashboards with Drilldowns and security In place by creating Users & Groups, setting up External Table Authentication, Creating Session variables,Initialization Blocks and Access Privileges, Query Privileges using LDAP and external database authentication.
• Setup MUDE Environment for Development of RPD for Developers.
• Managed the migrations of the webcatlog and RPD among different Environments.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing.
• Created master & work repositories and configured ODI connections for source and target systems in topology.
• Experience in ODI designer, Operator, Topology and Security, Performance Tuning in Oracle Data Integrator.
• Worked with multiple sources such as Relational database, Flat files for Extraction,Transforming and Loading data into target tables.
• Optimized the knowledge modules to improve the functionality of the process and Developed packages, scenarios using interfaces and variables.
• Debugging the master jobs and packages by using operator navigator,Monitoring the execution logs in operator.
• Experienced in Working with Load Plans and Scenarios. Implemented Send E mail to the DBA on interface execution failure.Used ODI commands like OdiFileMove, odiFileAppend,odiFilecopy etc.
• Participated in all phases of project development, testing, deployment and support.Good knowledge in creating File to DB and DB to DB related interfaces.
• Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM). Implemented SCD type1, SCD type2,CDC.
• Performed unit testing at various levels of ELT flows,Execute test cases with multiple data sets to attain exact test results and capture faulty.
• Extensively used XML/BI publisher to Created Complex Matrix reports in BI Publisher ( > 100 colums), Reports with datasets from different sources with analysis combination. Used Template, sub Template method for a creating single report with multiple Layouts, Created PDF/EXCEL/Word output’s for reports based on requirements.
• Used the Repeating Sections, Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked with the bursting team to successfully send report outputs to customer’s printer, fax, and email with appropriate Triggers In place. Worked closely with Oracle Product Development team to resolves issues in BI publisher.
• Lead UAT Process and Hands On Training for full time employees.

Environment: OBIEE 11.1.1.7, B.O, Crystal, ODI12c, Oracle11g, TOAD11.5, PLSQL DeveloperWindows 7, LINUX, PLSQL, Java script, HTML

Confidential, Houston, TX

Sr. OBIEE Developer

Responsibilities:

• Worked with Business Users for gathering the requirements and to define business and functional and technical specifications.
• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository.
• Involved in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements.
• Created a repository using OBI Administration tool by importing tables into the physical layer and created the business and mapping model to in corporate the business logic.
• Interacted with Systems Engineering team to design - Facts & Dimensions for Repository.
• Developed multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards.
• Worked extensively on security for users and groups based on the individual and group responsibilities.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.
• Developed Performance Tuning Strategies for optimizing the performance.
• Developed custom reports/ad-hoc queries using BI Answers and assigned them to application specific dashboards.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• UsedODIDesigner for importing tables from database, reverse engineering, to develop projects, and release scenarios, Implemented Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.

Environment: OBIEE 11.1.1.5, ODI 11g/10.1.3.4, Oracle 10g, TOAD 11.5, Windows XP, LINUX, Java script.

Confidential, CA

Sr. OBIEE/ ODI Developer

Responsibilities:

• Extensively used ETL to load data from MS SQL Server, Oracle, Excel spreadsheet and flat files.
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets usingODITopology Manager, creating Designer models, developing integration interfaces.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and usedODIfor reverse engineering to retrieve metadata from data storage and load it to the repository
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Primary focus and/or development efforts were in the reengineering of the ETL processes using theOracle Data Integrator (ODI).
• Developed variousODIinterfaces to load data from Flat file & Relational Sources to Oracle Data Mart.
• Used Knowledge modules LKM, RKM, IKM and JKM and Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it etc.
• Developing OBIEE Repository (.rpd) at three layers - Physical Layer, Business Model & Presentation Layer, Time Series Objects, InteractiveDashboards with drill-down capabilities.
• Using OBIEE built reports, dashboards, and bookmark navigation.
• Involved in identifying and defining business and technical requirements.
• Created new repository, customized existing metadata Repository (.rpd)
• Designed and developed Physical Data Layer, Business Model & Mapping and Presentation Layer using BI Administration Tool.
• Designed OBIEE Physical relationship diagrams using Fact and Dimensional tables, Developed Dimensions and Time Series objects in the Business Model and Mapping Layer.
• Configured measures in the Logical Layer and mapped to multiple Physical source tables
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Creating new measures as well as modifying the existing measures at RPD levels.
• Involved in creating dimensional hierarchies to support drill downs.
• Developed the Oracle BIEE Metadata repository (.rpd) model with for Sales & Marketing subject areas that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies & time series functions, Presentation layer with catalogs & folders using Oracle BI Administration tool

Environment: ODI11g/10.1.3.x,OBIEE, Oracle 10g, SQL*Loader, PL/SQL, TOAD, UNIX.

Confidential, Waltham, MA

OBIEE Developer

Responsibilities:

• Worked onOBIEEAdministration Tool to customize and modify the metadata according to the requirements at all the three layers of metadata repository (.rpd).
• Imported Source Data from multiple databases & files, and maintained the connection pools.
• Worked Extensively on BI Answers to create the reports as per the business requirements, Configured Intelligence Dashboards by adding embedded content such as links/images, HTML objects and folders.
• Developing OBIEE Repository (.rpd) at three layers - Physical Layer, Business Model & Presentation Layer, Time Series Objects, Interactive Dashboards with drill-down capabilities.
• Performed in building reports, dashboards, and bookmark navigation.
• Involved in identifying and defining business and technical requirements,Created new repository, customized existing metadata Repository (.rpd)
• Designed and developed Physical Data Layer, Business Model & Mapping and Presentation Layer using BI Administration Tool.
• Designed Physical relationship diagrams using Fact and Dimensional tables.
• Developed Dimensions and Time Series objects in the Business Model and Mapping Layer.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Creating new measures as well as modifying the existing measures at RPD levels.
• Involved in creating dimensional hierarchies to support drill downs.
• Developed the Oracle BIEE Metadata repository (.rpd) model with for Sales & Marketing subject areas that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies & time series functions, Presentation layer with catalogs & folders using Oracle BI Administration tool
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement
• Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
• Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
• Design & Customize OBIEE Answers Views & charts Create & save Filters Create Charts & Tables Bins in OBIEE Answers.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
• Created Dashboard prompts global filters and combined similar requests inOBIEEAnswers
• Designed pivot table reports setting aggregation rules sort orders and formulas.

Environment: OBIEE10.1.3.x, BI Publisher, Oracle 10g, SQL*Loader, PL/SQL, TOAD, UNIX

Confidential

Siebel Analytics /OBIEE Developer

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Worked closely with the data modeler in designing the logical data model/physical data model (star schema).
• Configured and created repository using Siebel Analytics Administration Tool.
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation.
• Layer in a Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Involved extensively in SiebelAnswers, Siebel Delivers, and Siebel Intelligent Dashboards with Siebel.
• Involved in Data Modeling and Data Mapping review, including sources, staging areas, and target database.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Suggested and implemented Siebel recommended Performance tuning practices to improve Siebel Analytics server performance by reorganizing database indexes and configuring NQSConfig.
• INI files performance parameters.
• Involved in developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboard.
• Created Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Siebel Answers. Involved in unit testing, integration testing of the reports generated using Siebel Analytics.

Environment: Siebel Analytics 7.5, Oracle 9i, Windows 2000, PL/SQL, TOAD