SUMMARY:

• Having 5+ years of IT experience with 8+ years of experience in OBIEE 11g/10g and ODI 11G and 5 years of experience in manual and automation testing.
• Good experience in Dimensional Data Modeling using star Star Schema/Snowflake modeling, Fact & Dimensions tables, Physical & logical data modeling.
• Well - versed in Data Transformations and Data Migrations using ODI 11g/10g from heterogeneous sources such as Oracle,Sql Server and Flat Files to perform ETL operations
• Skilled in using ODI graphical interface modules - Security Manger, Topology Manager, Designer and Operator with versions ODI 11g/10g
• Expertise in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge modules (LKM, IKM, CKM, RKM and JKM).
• Expertise in providing end-to-end Business Intelligence solutions using (OBIEE 11g/10g) with greater emphasis on BI Admin Tool, Analytics and BI Publisher
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Objects.
• Analyze, design, develop, modify and test OBIEE Dashboards/Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Experienced in working with Multi User Development environment (MUD) and configuring the security settings in OBIEE administration tool to setup groups, access privileges using LDAP and external database authentication.
• Familiar with database performance tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and analyzing query execution using the explain plan.
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas of ODI jobs and OBIEE reports.
• Extensively utilized OBIEE delivers for sending alerts via intelligence agents (i Bots) to interactive dashboards for subscribed users.
• Extensively worked with third party database tools like TOAD, SQL Developer.

TECHNICAL SKILLS:

ELT Tools: Oracle Data Integrator (12C, 11.1.1.6, 11.1.1.7, 11.1.1.5, 10.1.3.5, 10.1.3.4)

BI Tools: OBIEE (11.1.1.6.5 , 11.1.1.6, 11.1.1.5, 10.1.3.4.0/10.1.3.3/10.1.3.2 )

Database: Oracle 11g, 10g

Languages: SQL, Pl/SQL, Java

OS: Windows 9x/2000/NT/XP, Windows Server, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Compton, CA

Sr ODI/ OBIEE Consultant

Responsibilities:

• Worked exclusively on ODI to integrate the date from various legacy systems including Oracle, DB2, Flat files and CSV files
• Reviewed, analyzed, evaluated, and documented business systems and user requirements and acted as SME for entire Financial Transaction module and Legal Actions module.
• Implemented Change Data Capture (CDC) feature of ODI to reduce the volume of source data being processed and minimize the data load time.
• Customized and optimized various ODI knowledge modules based on the requirements and also used various hints in the ODI knowledge modules to enhance the performance.
• Created ODI Global Objects such as Variables, Reusable Mappings, User Functions, complex Packages, Procedures based on the client requirements.
• Created ODI Agents, ODI Load plans and scheduled ODI runs to automate data integration process.
• Defined and established ODI data quality and data flow rules for entire Financial Transaction and Legal actions module.
• Used SQL and PL/SQL programming to perform data cleansing as per design requirements.
• D esigned customized interactive dashboards   in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Created   security settings   in OBIEE Administration Tool to set up groups, access privileges, query privileges and also managed security for groups in Answers.
• Developed test cases and performed   Unit Testing and Integration Testing   for ETL, Repository (rpd) and Web Catalogs.
• Performed root cause analysis on bugs and resolved performance tuning related issues.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Provided production support for end-users including system training, responding to questions, resolving problems, and providing ad-hoc reporting.

Environment: ODI 11.1.1.7, OBIEE 11.1.1.6, SQL Plus, Toad, Oracle 11g

Confidential, Santa Barbara, CA

ODI/ OBIEE Consultant

Responsibilities:

• Primary responsibility include installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ELT.
• Provided best practices, which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages and Load Plans.
• Performed loading of delta changes to target table with CDC.
• Performed Versioning of ODI objects using external versioning tools and using internal ODI versioning using Solutions.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• After Upgrading in Development environment performed export and import.
• Used Smart export and import for finding dependencies to perform export and import of ODI objects.
• Worked on Physical and Logical tabs where in physical tab we can choose KM’s and in logical tab we can create mappings.
• Worked on Reusable mappings, which is newly introduced in ODI 11g.
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning such as using Hints, Indexes, Analyzing tables, Explain plan.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: ODI 11.1.1.5, OBIEE 11.1.1.6, SQL Plus, Toad, Oracle 11g

Confidential, San Francisco, CA

Project Lead

Responsibilities:

• Managing and planning the tasks for the resources and coordination through Onsite-Offshore Model.
• Drive the scrum calls on a daily basis and get the update on requirements and make sure the team is working towards the commitment
• Coordination with the stakeholders and the program team and make sure the requirement are addressed and delivered by the team
• Make sure the team is aware of the complexities and challenges on requirements for estimation process
• Prepared HLD’s (High Level Design), LLD’s (Low Level design) and participated in Data Model Reviews.
• Participated in GAP analysis, Impact Assessment, and prepared necessary documents for multiple projects.
• Expert in presenting the designs to business and in getting signoff’s with some report mockups (without actual developing the reports).
• Worked extensively with Physical Layer, Business Layer and Presentation Layer and built business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer

Environment: OBIEE 11.1.1.6, 11.1.1.5, SQL Plus, Toad, Oracle 1og, Windows Server

Confidential, San Francisco, CA

Software Engineer

Responsibilities:

• Gathered analyzed user requirements and worked closely with Business analysts, IT team to create Technical Specifications
• Created prototype of the project and received sign off on POC from business users
• Designed Mappings for bringing in data from various data sources
• Identified the fact and dimension tables, created the data mapping field matrix
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical Layer, Business Model and Mapping Layer and Presentation Layer of the Repository(.RPD)
• Configured Business Model and Mapping Layer - Created Logical tables/dimensions, columns, Create Logical Joins, complex joins/keys Set levels to support Drill-down, Aggregation / Sum over Columns.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Enhanced the subject areas as and when suggested by the business analyst.
• Configured more measures in the Business Model Layer that are not critical to performance and mapped them to multiple logical source tables
• Developed Time Series objects. Also created Fragmentation content for few fact tables
• Designed Aggregate Tables modeled the repository for improving performance of the reports.
• Implemented OBIEE security at the data and object levels.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
• Responsible for Developing RPD and configuring metadata and handled all the migration activities.
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers
• Performed Knowledge Transfer to other Developers, DBA and Business Analyst after successful completion of the project

Environment: OBIEE 10.1.3.4.0/10.1.3.3/10.1.3.2 ,SQL Plus, Toad, Oracle 1og, Windows Server.