SUMMARY

• Over 8+years in IT industry including Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse dat covers gathering Business Requirements, GAP Analysis, Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.
• Extensive Business Intelligence experience using OBIA 7.9.x, OBIEE 10g, OBIEE 11g/12c, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x, Data warehouse Administration Console (DAC) 10.x, 11.x.
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers)
• OBIEE 12c migration experience from OBIEE 11g with jar scripts, migration tools and export import handling.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center/ODI.
• Extensive logical and physical design of OLAP and OLTP databases.
• Strong experience on Data Warehousing concepts like Star Schema, Snow flake schema and implementing teh relationship between fact/dimension tables.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Created iBOTS using BI Delivers and send reports as per scheduled slots to business users
• Having good experience in handling Development & Production Supports issues as per Service Level Agreements (SLA's). Reviewer for teh deliverables for around 66 OBIEE applications and ensured dat teh deliverables meet OBIEE standard guidelines.
• Experience in creating hierarchy, formulas and measures in OBIEE BMM layer and good noledge in performing Administration roles like creating Users and Groups, data level security, defining Session, cache management, set up event polling table and Repository variables.
• Comprehensive noledge in Debugging, Optimizing and Performance Tuning of Oracle BI Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Expertise in BI Publisher, Developing and designing teh template in rich text format (RTF) and portable document text format (PDF).
• Created Table partitions, Materialized views with query rewriting, creating appropriate indexes, re - building indexes.
• Performed Unit testing, System Integration Testing and Load testing based on teh test scripts provided.
• Extensive experience in Security Management by creating users, roles, groups, data level security, object level security and time period level security.
• Worked on 2 complete life cycles for development on ODI 11g and 4 life cycles on OBIEE 11g.
• Experience in multiple user development (MUD) environment.
• Strong noledge in using Oracle Data Integrator 11g to perform teh ETL. Expertise with all ODI tools - Topology, Security Manager, Designer and Operator. Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Extensively experience in development of E-LT and ETL Mapping in Oracle Data Integrator (ODI). ETL jobs creation & customization using Oracle Data Integrator (ODI).
• Experience in using Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Analyzed teh Business requirement for Oracle Data Integrator and mapped teh architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to teh repository.
• Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance. Experienced in using TOAD and SQL Developer.
• Strong Data Warehousing ETL experience of using Informatica Power Center Client tools 9.x/8.x.
• Experience in working with Power center Repository Manager, Designer, Workflow Manger and Workflow Monitor.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading data to target using Informatica power center.
• Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.
• Proven strong analytical and logical skills with ability to follow project standards and procedures as per client specifications.

TECHNICAL SKILLS

Business Intelligence tools: OBIEE 12C, 11.1.1.x, 10.1.3.x, OBIA, Discoverer, BI Publisher, Cognos, Tableau 8.0

ETL Tools: Oracle Data Integrator 10g/11g, Informatica Power Center 9.0, 8.6

Schedulers: DAC 10g, 11g, Autosys and ROBOT.

Databases: Oracle 10g/11g, MS Access, MS SQL Server 2008, Teradata, DB2

Languages: C, SQL, PL/SQL, UNIX Shell Scripting, XML, Java/J2EE.

Operating System: Windows XP/7/8/10, Mac, Unix

Other Tools: Toad, SQL Navigator, MS Visio, MS-Office (Excel, Ppoint, Word)

PROFESSIONAL EXPERIENCE

Confidential -Buffalo, NY

Sr. OBIEE / ODI Developer

Responsibilities:

• TEMPEffectively interacted with teh end users for requirement gathering and defined requirement specifications document.
• Helped refine and determine feasibility, correctness, and completeness of end-user's requirements.
• Developed high level design documents for reporting and analysis projects.
• Migrated existing reports to OBIEE 12 c using Insite warehouse and validate teh report results using custom scripts and SQL.
• Upgrade OBIEE 11G to OBIEE 12C. Reports and catalog migrations and tuning.
• Integrated BI Publisher with OBIEE Created Excel Templates such as Shareholder's Equity report, Reports such as Deposits over quarter/year in BI Publisher.
• Schedule reports and bursting as per teh requirement in BI Publisher and represented them in OBIEE dashboards.
• Created exclusive OBIEE Test environment for testing and development purpose.
• Involved in Merging teh RPD and Web Catalog folder with OBIEE Admin tool and Catalog Manager.
• Created KPI'S and Oracle Score Cards to measure teh performance and progress of teh business strategy.
• Worked extensively with Physical Layer, Business Layer, and Presentation Layer in rpd.
• Created numerous executive level reports. Multiple Dashboards were generated to provide insight into teh financial data using OBIEE Answers.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Dimensional hierarchies, Aggregation to meet client requirements.
• Implemented Time-series functionality and created multiple metrics like YAGO, MAGO, QAGO, YTD and MTD.
• Strong noledge with PL/SQL Wrapper to protect teh PL/SQL procedures or packages.
• Utilized OBI reporting features (Navigational, Drill Across, Guided Navigation, and Security . etc.).
• Used existing data from Oracle EBS for analysis.
• Compared data from Oracle EBS with teh OBIEE for data validation.
• Identified teh aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Primary responsibility includes installing and configuring teh 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.
• Used suitable ODI Knowledge modules to achieve requirements. Extracted data from specific technology, transforming teh data, checking it, integrating it, etc. Created Custom Knowledge Modules.
• Used ODI objects in packages like ODIFile Move, ODI File Wait, odiFileAppend, odiFilecopy etc
• Created procedures to generate CSVs and complex transformations.
• 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.,)
• Provided best practices which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages, Load Plans.
• Performed loading of delta changes to target table with CDC and Time stamp process.
• Performed Versioning of ODI objects using external versioning tools and using internal odi versioning using Solutions.
• Upgrading from ODI 11G to ODI 12c environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 12c. Involved in analyzing teh Business requirement for Oracle Data Integrator and mapped teh architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to teh repository
• Involved in creation and modification of ODI Knowledge Modules such as Reverse Knowledge Module (RKM), Loading Knowledge Module (LKM), Journalizing Knowledge Module (JKM), Integration Knowledge Module (IKM), Check Knowledge Module (CKM) and Service Knowledge Module (SKM).
• Involved in creating ODI packages, scenarios using interfaces, variables, procedures.
• Involved in developing, support and maintenance for teh Extract, Load and Transform processes using ODI.
• Involved in performance tuning of ODI Interfaces

Environment: OBIEE 12.2.1.0, 11.1.1.9.0 , BIAPPS 11.1.1.9.x, Hadoop, BI Publisher, PL/SQL, Stored procedures Smart view, Unix, Oracle Data Integrator 11.1.1.9.0 , TOAD, Agile

Confidential -Schaumburg, IL

Sr. OBIEE / ODI Developer

Responsibilities:

• Worked with Business analysts as well as other business teams on requirement gathering. Configured Single Sign On (SSO) on OBIEE 11g
• Involved in deploying OBIEE 11g objects from one environment to another environment.
• Involved in Creation & Configuring of teh OBIEE Repository from scratch using best practices (physical, BMM, and presentation layers). Involved in creation of Level Based Hierarchy & Parent child Hierarchy to meet business requirements.
• Configured and created teh Repository using teh OBIEE administration tool.
• Generated reports using teh OBIEE features like pivot tables, charts and view selector.
• Created set of dashboards/reports for talent planning, performance management, competencies, and Executive profiles using OBIEE.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business Model and established relationships and foreign keys (Physical and Logical) between tables.
• Generated reports using teh OBIEE features like pivot tables, charts and view selector.
• Involved in teh modifications of teh Physical, Business and Presentations Layers of teh metadata repository using teh OBIEE administration tool.
• Identified teh Aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Created business Reports according to teh user requirement.
• Developed custom reports/ Ad-hoc queries using OBIEE answers and assigned them to application specific dashboards.
• Developed different types of reports (Pivot, Charts, Tabular) using global and local filters.
• Managed day-to-day RPD and Scheduler. Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
• Created session variables for users to provide row- level (data level) security and used teh session variable in OBIEE Answers to build teh query.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from teh modules like AP, GL and FA
• Migration of Security components, custom image prompts, style and skins from OBIEE 11.1.1.7.0 to OBIEE 11.1.1.9.1.
• Performed Data Validation by executing Unit Test cases for Business Intelligence Reports.
• Created multiple Dimensions (Drill-Down Hierarchies) & Fact objects in Business Model Layer, and created teh Presentation catalogs in Presentation Layer.
• Modified Presentation Layer to add presentation tables and columns to meet teh business user needs.
• Created materialized views and aggregates to improve performance.
• ETL jobs creation & customization using Oracle Data Integrator (ODI). Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• GG setup integrated capture to replace CDC.
• Experience in installing, maintaining, upgrading and patching Gloden Gate.
• Worked on teh RPD for teh new Subject area design for teh Cash flow Metrics Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of teh ETL strategy to populate teh 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 teh source and target schemas.
• Installing ODI 11.1.1.6 on all teh environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing teh newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI Load Plans.
• Created teh users, profiles using teh ODI security manager.

Environment: Oracle Applications R12 (GL, AR, AP, OM, INV, PO), OBIEE 11.1.1.9, OBIEE 12C, ODI 12.2.1, BI Publisher, WebLogic Server 11.x, BI Admin tools 11.1.1.9.0 , SQL, PL/SQL, Oracle 10g, Windows

Confidential, New Jersey

Sr. OBIEE / ETL Developer

Responsibilities:

• Developed Solution Designs and delivered to Development team after reviewing teh solutions with Business.
• Worked on teh development of teh Answers for teh different executive dashboards
• Actively involved in Administration activities (Repository and Catalog Migration from Dev to QA and QA to Prod environments, Security Setup and Installation setup)
• Developed OBIEE Data Marts (Ad hoc Reporting) for different clients based on teh different business logics.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated noledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports.
• Developed Repository (.rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Created Security Settings in Oracle Administration Tool to setup Groups and Provide Access Privileges and Query Privileges and also managed security for Groups in BI Answers
• Extensively worked on global filters for use in exercising dashboard wide control over requests dat are embedded into a dashboard page.
• Strong noledge with PL/SQL Wrapper to protect teh PL/SQL procedures or packages.
• Integral in Hyperion upgrade project to seamlessly upgrade from version 11.1.2.0 to 11.1.2.2.
• Designed, developed, tested, and deployed four Hyperion Essbase databases/cubes: Commercial Customer, Products, Service Charges/Refunds, and FDR cubes
• Created and maintained PL/SQL scripts and stored procedures.
• Involved in OBIEE 10g to OBIEE 11g upgrade for both Repository and Catalog and ensure all teh reports and dashboards running on OBIEE 10g is up and running on OBIEE 11g.
• Involved in patch upgrade of OBIEE 11g.
• Worked on OBIEE security like configuring LDAP authentication, creating users and groups etc
• Worked on providing SSO access to BI Publisher reports on OBIEE dashboards.
• Extensively worked with Informatica components like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor to load data from flat files .
• Designed and developed Informatica workflows/sessions to extract, transform and load teh data into oracle server
• Worked in connecting teh system to an external set of database tables dat contain teh group membership for users authenticated through Active Directory.
• Designed and developed Informatica mappings for financial module, Procurement and Spend Analytics module by using teh Source systems and created UNIX shell scripts to make teh file transfers from teh Windows directory to Informatica server directory.
• Scheduled and monitored teh daily Informatica incremental loads through teh Informatica Scheduler.
• Involved in performance tuning by setting Cache, limiting teh number of initialization blocks, limiting select table types, pushing teh calculation to teh database.
• Scheduling teh informatica workflows through DAC and monitoring daily loads.
• Develop new informatica mappings as per teh technical design documents and perform unit testing and data validation in different instances leading to production.
• Involved in teh Designing of ETL process, load strategy and teh SRDS after collecting teh requirements from teh end users.
• Responsible for creating teh DATA MAPS, extracting teh data and updating them to teh Repository, importing teh required source files on to teh staging environment by using Informatica Power Exchange.
• Designed and Created data cleansing and validation scripts using Informatica ETL tool.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: OBIEE 11.1.1.6.2 , OBIEE 10.1.3.4, BI Apps 11.1.1.7, SQL Developer, PL/SQL, Informatica 9.1, DAC 10.1.3.4.1 , Oracle 11g, Bugzilla, Win 7 Professional, UNIX .

Confidential, Woodbury, MN

OBIEE Admin/ ETL Developer

Responsibilities:

• Extensively involved in requirement gathering and Business Analysis using teh Use-cases, functional specifications and business rules.
• Designing teh Technical Design documents by understanding teh Functional Design Documents for teh sales of performance.
• Upgraded OBIEE 10g Repository to OBIEE 11G
• Worked with OBIEE 11g installation to make sense of business performance by adding context to Real Time Business Measure.
• Responsible for installing, Configuring and Administration of OBIEE 11.1.1.5.0/11.1.1.3.0 on Linux, Building Semantic Layer using physical, Business Model and Mapping and Presentation Layers using Oracle BI Administration tool.
• Worked with Security of teh application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Integrated OBIEE with EBS
• Worked with Installation and configuration of OBIEE 11.1.1.5.0 Red Hat Linux 5 and windows 2008 R2.
• Worked with Web Logic server 10.3.5 to create Middleware home.
• Experience in working with Installation and configuration of Oracle HTTP server 11.1.1.5.0 on Windows 2008 R2.
• Created a single subject area to contain all of teh required data points and dimensional attributes to minimize confusion and enhance supportability as per teh business requirement.
• Identified teh aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created Time Series Measures Year Ago, Month Ago, Year-to-date measures using Ago and To Date Time series functions.
• Configured Presentation Layer (Create Folders/sub-folders for different User Groups and departments).
• Developed different kinds of Reports pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters using Oracle Business Intelligence
• Performance Tuning of Repository and Reports by setting Cache, limiting teh number of initialization blocks, limiting select table types, Partitioning of teh tables, pushing teh calculation to teh database, setting teh NQSConfig.ini parameters.
• Performed Unit testing to validate Reports and mappings.
• Worked with SQL Developer to support teh daily production activities to analyze data in teh table and query teh data to transform it as per teh requirement.
• Installation, configuration and administration of WebLogic Server and Apache Web Server
• Worked with DBA to create materialized views to tune teh performance of reports. Configured Delivers and iBots.
• Worked with all three layers in teh repository - Physical, Business, and Presentation Layer.
• Functioned as a technical lead to design and implement SIEBEL Consumer goods/OBIEE/OBIA solution.
• Designed and implemented Siebel Consumer Goods, OBIEE and OBIA solution as technical lead.
• Developed Siebel Tools such as scripting, workflow, modeling, and remote.
• Developed custom Informatica v8.x mappings and workflows for data extract (with data change capture mechanism) from Siebel OLTP environment to Oracle Business Analytics Warehouse.
• OBIEE (Informatica) workflows monitoring, issues debug/resolution.
• Developed OBIA and OBIEE and OBI Apps (DAC & Informatica)
• Used DAC (Data Warehouse Administration Console) to configure, monitor and schedule Informatica mappings/workflows for Oracle Business Analytics Warehouse load.
• Managed a number of sub-projects through to completion.
• Performed Unix/Linux administration. Performed Linux shell developments and enhancements to teh existing Unix shell to encapsulate teh Informatica workflows and run teh Analytics dataloads.
• OBIEE (Informatica) workflows monitoring, issues debug/resolution.

Environment: OBIEE, Informatica Power Center, DAC, Oracle 11g, SQL Server 2008, Oracle EBS, TOAD, MS SQL Server 2008, Windows XP, Oracle BI Publisher, SQL.

Confidential, Panorama City, CA

OBIEE Developer

Responsibilities:

• Work with business users to understand teh needs and define teh requirements, including report definition, conversion and data cleansing rules, develops user system documentation and provides appropriate user documentation.
• Customized OBIA Out of teh Box Reports to meet teh requirements by doing Business Analysis, Technical Analysis to design and create reports and RPD Modifications.
• Experience with Reports and Dashboards on AP Invoices, GL Accounts, Accounts Payables, Accounts Receivables using Oracle EBS as teh source system.
• Provide technical noledge to teh design and implementation of teh enterprise-wide business intelligence solutions.
• Developed OBIEE Repository and implemented teh business logic by creating Tables, Level based metrics, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, etc.
• Designed and Developed Dashboards and reports, demonstrated noledge in dealing with various functionalities like views, aggregates, filters, pivot tables, tables, view selectors, charts, Interaction, customization, conditional formatting of reports.
• Modeled teh Physical Layer with Connection Pools, Aliases, Views and Joins. TEMPEffectively developed BMM Layer by creating Hierarchies, Complex Joins, Measures (with aggregation rules, complex business calculations, level based, dimensionality and time series functionalities) to accommodate teh business requirement.
• Developed teh Presentation Layer by creatively organizing teh logical columns into teh Tables and Folders.
• Used Variable Manager in Administration Tool to define Repository and Session variables.
• Creating Users, Groups to achieve teh object level and data level security in Repository and Web Catalog.
• 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), implemented GO URL feature to traverse between teh dashboards, passing teh parameters.
• Developed teh Dimensional Hierarchy and create teh Dimensional Levels for each of teh dimensions in teh BMM layer for Drilldowns and worked on aggregates logical sources in teh BMM layer.
• Created and executed test cases to validate teh User Interface, Data and Design.
• Performed teh performance tuning of teh OBIEE application by following teh Oracle Guidelines for teh Out of teh Box Reports to meet teh SLA for all teh reports.
• Trained Developers and Business users in OBIEE and BI Publisher Application and assisted them to generate and create their own reports, dashboards and perform ad-hoc analysis.
• Managed User access by implementing Object level and Data Level Security for each Subject area dashboards and managed user access through Web Logic Server by creating Roles and Groups.
• Deploying projects among multiple environments. Migrating OBIEE Repository, Reports objects, Web catalog, Security etc. and other files between different environments.
• Trained Business users about teh OBIEE Application and assisted them to generate and create their own reports, dashboards and perform ad-hoc analysis.
• Perform testing sessions for reports and dashboards and resolve process issue

Environment: Oracle11g, OBIEE 11.1.1.5, Informatica 8.1.0, DAC 7.9.4, SQL*PLUS, SQL*Loader, TOAD, UNIX and Windows XPOBIA Financial Analytics, Procurement and Spend Analytics and HR Analytics

Confidential

OBIEE Develop /Admin

Responsibilities:

• Communicated with business analyst and various end users for gathering teh required requirements to setup teh environment.
• Installed and configured teh OBIEE 10.1.3.2 server.
• Participated in all teh meetings for gatherings business requirements with end - users and business people.
• Working closely with Business Analysts and DBAs on physical database design.
• Created/Modified Metadata repository (.RPD) and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Extensively used OBIEE Admin tool to import teh required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Configured measures in teh Business Model Layer and mapped to multiple logical source tables.
• Implemented Security by creating role, responsibility, and web groups using LDAP Authentication
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Successfully developed row based calculations in a pivot table for teh reports based on RPD.
• Created session variables for users to provide row- level (data level) security and used teh session variable in OBIEE answers to build teh query.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Environment: OBIEE 10.1.3.4.1 , Administration tool, OBIEE Answers/BI Publisher/ Dashboards, Oracle 10g, Informatica Power Center 8.1, PL/SQL