SUMMARY

• 7 years of experience in Gathering user requirements, Data warehouse Analysis, Design, Development Architecting Business Intelligence Solutions, Development of Software Applications and Maintenance.
• Excellent experience in Dashboards, Answers and rpd objects.
• Extensive experience in performing Extraction, Load and Transformation ELT using Oracle Data Integrator ODI .
• Hands on experience in designing and implementing the E-LT architecture that is required to build data warehouse, including source-to-staging area, staging-to-target area, data transformations, and EL-T process flows.
• Implementing the extraction, loading, and transformation EL-T of data using Oracle Data Integrator configuring the ODI master and work repositories, ODI models, defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules.
• Experience in identifying the sources and mapping them with data marts.
• Strong knowledge in data warehousing techniques including data modeling.
• Extensively used Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, Interactive Dashboards and Security Implementation.
• Experience in implementing a fact less fact table for global prompt in the OBIEE dashboard as part of improving performance of global prompt.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE
• Experience with repository development, configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports . Added Metadata changes to the OBIEE/Siebel Analytics .rpd
• Extensive experience in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.
• Experience in Developing and customizing PL/SQL packages, procedures, functions, triggers and reports using Oracle SQL Developer.
• Experienced with different RDBMS such as Teradata, Oracle 9i/10g, MS SQL Server 2008 and MySQL.
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Expertise in configuration and integration of BI Publisher with BI server and BI Answers.
• Experience in Toad, Sql Loader, Export/Import and writing control file scripts for loading large loads of data into tables.
• Hardworking, enthusiastic and highly committed to the growth and success of the organization.
• Highly motivated, detail oriented, has ability to work independently and as a part of the team with Excellent Technical, Analytical and Communication skills.

TECHNICAL SKILLS:

BI tools : OBIEE platform 10.1.3.2, 10.1.3.3, 11.1.1.5, 11.1.1.6.2, Seibel Analytics 7.8/7.7

ETL tool : ODI 11g, 10.1.3 x

Data Modeling : Dimensional modeling, Star, Snowflake

Database : MS SQL Server 2005/2008, MySQL, Oracle 8i/9i/10g/11g, DB2, Teradata

Languages : SQL, PL/SQL, C, C , HTML, DDL Scripting, UNIX Shell Scripting

Tools : TOAD, SQL Developer, SQL Plus, Microsoft Visio

Operating System : Windows NT/XP/98, Windows Vista, Sun Solaris, HP UNIX, Linux

Reports : BI/XML Publisher

EXPERIENCE:

Confidential

Sr. ODI/OBIEE Developer

Roles and Responsibilities:

• Identified and mapped required database fields and tables
• Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
• Scheduled and administered database queries for off hours processing
• Participated in planning, reporting and database needs
• Worked with staff to verify and trouble shoot data validity issues
• Designed and developed database SQL programs necessary to extract, transform and/or load data
• Executed data definition language DDL scripts, created by the data modeler, and created the data base schemas
• Worked on date related issues in reports and fixed them
• Installed and configured OBIEE and ODI tools.
• Worked on cleansing of data at the Staging area to remove redundancies and erroneous content
• Prioritized the urgency of multiple demands and assume responsibility to make things happen
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Responsible for managing the connection pool entries associated with Physical Data Sources
• Customized and developed repository configured metadata objects Subject Area Table Column and Web Catalog Objects Dashboard Pages Folders Reports .
• Created different types of customized reports Drill-down, aggregation to meet the client requirements.
• Developed custom reports/ Ad-hoc queries using OBIEE answers and assigned them to application specific dashboards.
• Created reports according to user requirements and also created corresponding dashboards for the reports and actively involved in deployment and post release support.
• Migrated Analytics RPD and Webcat from one environment to another
• Implemented Object level security as well as Data level security, identifying the groups and their permissions and privileges as per business needs.
• Assisted in creation of pivot table request allowing the manager to analyze the business from different perspectives provided optimized Analytics using Column selector.
• Implemented and Administered OBIEE Security using an External Security database table.

Environment: ODI 11g, OBIEE 11.1.1.6, Oracle 11g, DDL Scripting, BI Publisher, SQL, PL/SQL, Stored procedures, Windows XP, Toad.

Confidential

Sr. OBIEE/ODI Developer

Roles and Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement
• Involved in gathering the requirements of source and target systems
• Involved in extensive data cleansing and profiling
• Extensively used knowledge modules in achieving the client requirements
• Used ODI designer to create projects and release scenarios
• Created master and work repositories for ODI by coordinating with Oracle DBAs
• Used RKM to reverse the metadata of the system database
• Involved in creating database connections, physical and logical schema using the Topology Manager
• Extensively worked on creation of packages, construction of data warehouse and data marts, and synchronization using ODI
• Applied DDL changes to each environment as required
• Involved in loading the data from flat files into staging area
• Extensively used Oracle Business Intelligence Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository
• Involved in installation and configuration of OBIEE on Linux enviroment.
• Involved in RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation

• Created scorecards to establish individual budget targets
• Implemented usage tracking to monitor system and ad hoc query performance on usage details

• Configured and Created repository using Oracle BI Admin tool
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Configured metadata objects Subject Area, Table and Column and Web Catalog Objects Dashboard, Pages, Folders and Reports .
• Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer
• Worked extensively on BMM Business Model and Mapping layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema
• Created Session and Repository variables
• Built Interactive Dashboards and Reports using Tabular and Pie Chart Reports with Drill down and drill up capabilities to enhance granularity in the Data
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities
• Experienced in migrating the Web catalog developments by using the Catalog manager and Repository developments to Production from the Test environment.
• Implemented External Table Authentication security mechanism
• Migrated the project from 10.1.3.4 to 11.1.1.5 and did rpd merging
• Modified the dashboard using 11g and repository patching
• Involved in Reconciliation Process while testing loaded data with user reports

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.5, OBIEE 11.1.1.6, DDL Scripting, Oracle 11g, BI Publisher, ODI, SQL, PL/SQL, Windows XP, Linux, Toad.

Confidential

OBIEE/ODI Developer

Roles and Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables
• Involved in data extraction and loading using Oracle Data Integrator ODI
• Created ODI Data stores in the Model to store the metadata Reverse Engineered from Sources
• Managing the process of reviewing and promoting ODI code from offshore teams into an ODI master repository testing, building, and validating ODI repositories for QA
• Created DDL scripts required to generate or modify the database
• Customizing, developing, and creating new ODI knowledge modules to support loading and transformation of data including data dump and materialized view knowledge modules
• Worked extensively with complex Interfaces using ODI. Expertise in implementing complex business rules by creating ODI Interfaces. Implemented DW Best Practices
• Created numerous ODI Interfaces to implement Business Logic with ODI Graphical Designer, Topology Manager, Operator, Security Manager Knowledge Modules Reverse-engineering, Journalizing, Loading, Check, Integration, Service
• Used Analytics Web Catalog to set up groups, access privileges, migrating reports from dev to production and query privileges
• Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Established the logical joins/keys required to support drill-down aggregation
• Designed and Configured Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams
• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management CRM to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards
• Developed custom reports/Ad-hoc queries using OBIEE Answers and Filters
• Analyzed and validated the business model in Siebel Analytics Administration tool by performing consistency check validating logical source tables' logical columns and also validating repository level calculations done in the business model layer
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE

Environment: OBIEE, Oracle 10g, Toad 9.0, Oracle Data Integrator 11g/10.1.3.x, DDL Scripting, Windows Adv Server 2003, SQL, PL/SQL, MS Visio 2007 professional

Confidential

OBIEE/ODI Developer

Roles and Responsibilities:

• Worked with functional technical leads, marketing, sales, finance, and other business groups to identify, analyze, and document requirements
• Worked with business analysts and acted as a liaison between technical departments and business departments
• Experienced working with Oracle BI Server, Presentation Server, all three layers in the repository RPD Physical, Business Model and Mapping and Presentation Layer and Oracle BI Administration
• Experience in Data warehousing concepts with emphasis on ETL and life cycle development Created, executed and managed ETL processes using ODI
• Assisted in Installation configuration of Oracle Data integrator ODI in the Windows environment
• Used different ODI Interfaces for Extraction/Loading/Transformation, data consolidation, data Integration and data cleansing
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces by applying joins with execution location as Target
• Used ODI Topology Manager to create connections to various technologies such as Oracle, SQL Server, Flat files, XML, etc.,
• Executed data definition language scripts and creating the data base schemas
• Involved in maintaining and creating new data servers, connections for different data sources through the ODI Topology manager
• Used ODI Knowledge Modules Reverse Engineering, Journalizing, Loading, Check, Integration, Service to create interfaces to cleanse, Load and transform the Data from Sources to Target
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer
• Worked in conjunction with data analysts for developing dashboards and other end user solutions
• Setting up Delivers to configure iBots based on user requirements
• Splitting of repository projects and make it available to developers
• Responsible for managing the connection pool entries associated with Physical Data Sources
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository
• Effectively migrating webcast, Skins and Style sheets from one server to another server by using catalog manager
• Integrate Oracle BI Publisher reports in Interactive Dashboards
• Merging of repositories and migrating to multiple servers
• Responsible for developing new reports in Oracle XML/BI publisher
• Installed OBIEE in windows server
• Creating production builds and getting approvals from senior management
• Customized and developed the OBIEE Business Model and Mapping layer
• Granting access to users and maintain security by using database authentication and authorization
• Added column/data level security at the repository level and defined dimensional hierarchies and associated the proper level of granularity to the fact table
• Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures
• Created auto purge for repository projects and scheduled as per the demand
• Trouble shooting the issues related to repository models and report development

Environment: OBIEE 10.1.3.2.1, Siebel OLTP 7.7, ODI 10.1.3.4 / 10.1.3.5, SQL, DDL Scripting, PL/SQL, Mercury Quality Center, Windows XP

Confidential

OBIEE Developer

Roles and Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps
• Built the Oracle BI repository Physical Layer, Business Model and Mapping Layer and Presentation Layer
• Created logical tables and defined the complex joins for a business model
• Developed Calculated Measures, Level based measures and Dimension hierarchies in the Business Model and Mapping Layer
• Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, Graph and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters
• Generated different kinds of reports using Answers and assigning them to application specific dashboards
• Created DDL scripts required to generate or modify the database
• Worked on Answers to build Interactive Dashboards with drill-down capabilities based on period and class hierarchies
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Created Users, Groups and giving the permissions in Oracle BI Administration Tool and verified the Permissions of the users in Oracle BI web
• Responsible in creating Alias and configured repository with logical dimensional modeling using star schema
• Involved in user trainings on the generated reports for this project
• Participated in Post implementation reviews with the Project teams

Environment: OBIEE 10.1.3.3, SQL Server 2003, SQL, DDL Scripting, SQL Plus.

Confidential

Siebel Analytics Consultant

Roles and Responsibilities:

• Involved in Full project life cycle implementation for Data Warehouse
• Identified the granularity level of the data required to be available for analysis
• Developed Metadata repository .rpd , configured metadata the Business Model Layer Physical Data Model and Web Catalog Objects as per the data requirements using Siebel Analytics Server Admin and Web tool
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets
• Identified and solved numerous technical and operational problems in the Data mart design and ETL implementations

Environment: Siebel Analytics 7.5, SQL Server 2003, SQL, SQL Plus, TOAD, PL/SQL, Windows.

Confidential

Oracle Developer

Roles and Responsibilities:

• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations
• Wrote generic PL/SQL code modules PL/SQL Libraries for Reports to handle data manipulations on client
• Developed Database Objects - Triggers, Packages, Procedures and functions
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on Server
• Developed Mappings using various transformations like connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Stored procedure, Sequence Generator, Update strategy and Joiners etc. depending upon requirement
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Created Materialized views to calculate aggregated data, such as a sum of monthly revenue
• Designed and developed Oracle Monthly Reports

Environment: Oracle 9i, SQL PLUS, PL/SQL, Reports 6i, Toad, FTP. Oracle 8i / 8 Developer / 2000 Forms 6.0 / 5.0 / 4.5 / 4.0, SQL Loader, UNIX IBM AIX 4.0 , Windows NT / 2000 / 95.