We provide IT Staff Augmentation Services!

Odi/obiee Developer Resume

Woonsocket, RI

SUMMARY

  • I have 9+ years of experience in software development and expertise in Oracle Warehouse Builder, OAC/OBIEE 10.1.3.4/ 11.1.1.6/ 11.1.1.7/ 12.2.1.2.0 , Informatica 8.6.1/9.1/9.5 , ODI 11g/12c and OBI Apps 7.9.6/7.9.5/11.1.1.7
  • Experienced in Crystal Reports and BusinessObjects Universe Design Tool.
  • Extensive experience in Oracle BI Administration Tool, BI Analysis, BI Dashboard, BI Publisher, BI Delivers, and iBots with OBIEE applications.
  • Knowledge on designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters.
  • Experienced in installation and configuration of OBIEE, DAC, and administering permissions, privileges to users based on their groups and responsibilities.
  • Good experience on OBIA Finance (Core GL Account Payables and Account Receivables), HR (Workforce, Payroll), Project (Project Costing, Purchase and Budget), Procurement and Spend (Purchase Order, Invoice Lines)
  • Worked on ODI 11g and ODI 12c studios
  • Experience in developing the load plans, packages and job scheduling
  • Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
  • Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM
  • Worked on slowly changing dimensions SCD, Change data capture CDC as part of data warehousing concepts.
  • Building of RPD application design for Physical, Logical (BMM), and Presentation layers, configuration of those layers, development of reports, dashboards, BI Publisher, and integration to Microsoft suite of tools, testing, and deployment.
  • Expertise in Business Model development with dimensions, hierarchies, measures, partitioning, aggregation rules, time series, cache management.
  • Experienced configuring interactive dashboards with drill-down capabilities using global and local filters, Siebel Security set-up (groups, access/query privileges), metadata objects and Web catalog objects (dashboard, pages, folders, reports).
  • Expertise in ETL methodology, supporting data extraction, loading, and transformation processing using Informatica PowerCenter.
  • Experienced in developing various Informatica transformations and mappings.
  • Experienced in tuning Informatica mappings, sessions, and SQL queries for better performance.
  • Experienced in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed, Deployed and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS.
  • Experience in Data modeling(Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
  • Performance tuning in OBIEE for star schema/Snowflake schema by implementing aggregate navigation, cache management, Materialized Views and Database tuning
  • Extensive experience in working with various enterprise data warehouses, data marts.
  • Expertise in debugging and optimizing the Oracle BI/Siebel Analytics dashboards/reports and Informatica mappings/workflows.
  • Knowledgeable in using Oracle Database, MS SQL Server, Toad, and SQL*Loader.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.6.1/9.1/9.5 , SSIS, ODI 11.1.1.9

BI: OAC/OBIEE 10.1.3.4/ 11.1.1.6/11.1.1.7 /12.2.1.2.0 , OBI Apps 7.9.5/7.9.6/ 11.1.1.10.2 , Tableau 9.1

Databases: Oracle 7.3/8i/9i/10g/11g/12c, MS SQL Server 2000/2005, MS Access

Languages: SQL, PL/SQL, HTML, Unix Shell Scripting

Data Modeling: Dimensional Modeling, Star, Snowflake

Tools: Toad, SQL Developer, SQL*Plus, Microsoft Visio

Reports: BI/XML Publisher

Operating Systems: Windows NT/95/98/2000/XP/7, Windows Server 2003/2008, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, WOONSOCKET, RI

ODI/OBIEE Developer

Responsibilities:

  • Responsible for gathering Business requirements, preparation of business requirement Specification document and performed Gap and Data Analysis.
  • Migration of OBIEE to OACS
  • Understand and customize delivered Oracle Analytics functionality
  • Development of ETL Solution using Data Sync Tool
  • Service Administration: managing Users/groups/roles, Authentication.
  • Resolve technical issues during Development & UAT phase.
  • Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables in the repository.
  • Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
  • Involved in the detailed design of the reports and dashboards.
  • Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements
  • Used ODI interfaces, joins, filters lookups to implement business rules.
  • Worked on ODI Topology Manager module to manage the data describing the information systems physical and logical architecture.
  • Created and modified SQL and PL/SQL database objects like tables, indexes, views, stored procedures, functions, packages, Triggers, Materialized views, analytical functions to make new enhancements or resolve problems.
  • Implemented a Change Data Capture (CDC) in ODI which increases efficiency of the job.
  • Monitoring the ETL jobs and troubleshooting the errors using the operator logs.
  • Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
  • Developed and customized some of the existing Dimensions Drill down Hierarchies Logical Objects in Business Model and Mapping Layer.
  • Developed Time Series Objects using To Date functions for time series comparisons.
  • Created Aggregations and Logical Based Measures in Business Model and Mapping Layer.
  • Created Analytical Views Compound Layout, chart, pivot etc. and Global/Local Prompts to design the Dashboards.
  • In OAC, developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations as per client’s requirement.
  • Enhanced the performance of Reports/Dashboards by implementing the Aggregate tables.
  • Effectively involved in Cache management for an improved performance of the system.
  • Created proactive Agents using BI delivers to schedule Cache seeding.
  • Configured Agents to deliver Analytics content based on schedule.
  • Created packages and generated the scenarios and created load plans and scheduled job on daily, bi weekly and monthly.
  • Worked with the repository and session variables. Created Initialization blocks to provide Object level security and Data level security for the users.
  • Work closely with production support team to troubleshoot and fix any production issues.

Environment: OBIEE 11g/OACS, ServiceNow, ODI (Oracle Data Integrator), PL/SQL, Oracle Database 11g.

Confidential, LEAWOOD, KS

OBIA (OBIEE/ODI) Developer

Responsibilities:

  • Worked on reimplementation of OBIA Finance (Core GL Account Payables and Account Receivables), HR (Workforce, Payroll), Project (Project Costing, Purchase and Budget), Procurement and Spend (Purchase Order, Invoice Lines) modules.
  • Worked on gap analysis and performing data profiling.
  • Participated in Data modeling session and created dimension models using ERStudio.
  • Created Data Lineage documents required for ETL
  • Configured and setup ODI, master repository, work repository, Models, sources and Knowledge Modules.
  • Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse.
  • Worked OBIA Type1 and Type2 customization
  • Creating and customizing ODI interfaces, packages, joins, filters lookups to implement business rules.
  • Good understanding on ODI knowledge modules and can do customization of KM’s.
  • Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets Relational Database Management servers including Oracle RDBMS, SQL Server and flat files including CSV, Excel, XML file formats.
  • Worked on ODI Topology Manager module to manage the data describing the information systems physical and logical architecture.
  • Imported dimensions and Facts into OBIEE Repository and built physical, Business Model & Mapping, and Presentation layers using Oracle Admin Tool.
  • Created dimensions, aggregations, and levels using admin tool in the Business Model & Mapping layer.
  • Developed custom reports/Ad hoc queries using Oracle BI answers and assigned them to application specific dashboard.
  • Developed many reports/Dashboards with different Analytics views (drill-down and drill-across, pivot table, gauge, graph, chart, view selector, column selector, with global and local filters).
  • Participated in UAT sessions and resolved UAT issues in stipulated timeframe.
  • Provided performance tuning by setting cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
  • Provided end-user training and documentation on developed dashboard, reporting metrics and reports.

Environment: OBIA 11.1.1.10.2 (Oracle Business Intelligence Applications), ODI 11.1.1.9 (Oracle Data Integrator), Oracle Database 11g, SQL Server Management Studio v17.3, ERStudio Data Architect 17.0, Erwin v9.0, PL/SQL.

Confidential, OXFORD, OH

ODI/OBIEE Developer

Responsibilities:

  • Participated requirements gathering and business analysis. Project coordination, End User meetings.
  • Configured and setup ODI, master repository, work repository, Models, sources and Knowledge Modules.
  • Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse.
  • Creating and customizing ODI interfaces, packages, joins, filters lookups to implement business rules.
  • Worked on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM
  • Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets Relational Database Management servers including Oracle RDBMS, SQL Server and flat files including CSV, Excel, XML file formats.
  • Developed Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 as a part of Performance Tuning
  • Worked on ODI Topology Manager module to manage the data describing the information systems physical and logical architecture.
  • Worked on creating new loan plans for loading the respective data warehouse tables.
  • Hands on ODI migration using smart import and export.
  • Worked on RPD Development, Oracle BI Administration,Oracle BIAnswers and Agents.
  • Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
  • Created complex requirements like Dimension hierarchies, time comparisons and share measures along with ranks.
  • Developed Month Ago, Year Ago Measures for Comparison of Facts and Used Time Series Functions and To Date Functions Extensively.
  • ImplementedOracle BIsecurity at the data and object levels and utilized variables and initialization blocks in the repository.
  • Utilized BI Delivers for sending real-time, personalized alerts viaintelligence agents (IBots) to intelligencedashboards for subscribed users.
  • Created operational reports withBI Publisherintegrated withOBIEE.
  • Created variables inOBIEEfor use with reporting - Repository Variables, Session Variables, Presentation Variables and Initialization blocks.
  • Managed and provided permissions for Reports and Dashboards inOBIEEPresentation Services Web Catalog.
  • Used group functions and created separate measures within the data model and used the group variables in the reports
  • Conducted UAT sessions and issue fixing.

Environment: Oracle Database 12c, SQL Developer, ODI 12c (Oracle Data Integrator), OBIEE 12c, PL/SQL, UNIX.

Confidential, FORT WAYNE, IN

OBIEE/Informatica Developer

Responsibilities:

  • Configured OBIEE Repository (RPD) and implemented Security (object and data level security in the OBIEE Repository & Answers) using Repository variables and session variables.
  • Used Informatica PowerCenter for extraction, transformation, and loading data from heterogeneous source systems.
  • Created connection pools, imported physical tables, and defined joins in the physical layer of the repository.
  • Migrated the Repository, OBIEE Web Catalog, and Informatica mapping across the environment.
  • Created time series measures-year ago, month Ago, year-to-date measures using AGO and To Date functions.
  • Created dimensional hierarchies for drill-down and level based measures and created aggregated tables to improve the performance of the reports.
  • Developed many dashboards with different views (pivot table, chart, tabular, and view selector), dynamic dashboard prompts and guided navigation links.
  • Set-up usage tracking option to monitor frequently run reports to provide caching for the reports and perform database optimization by analyzing query performance.
  • Created security settings in Oracle administration Tool to set-up groups, access privileges and query privileges and manages security for groups in BI answers.
  • Developed UI components folders, dashboards, pages columns, sections, requests/answers, filters, global filters, navigation links and views/charts using Oracle BI Presentation services.
  • Worked extensively on complex BI Publisher reports, Data Models and creating complex RTF templates using BI Publisher template Builder.
  • Worked on LDAP set-up in WebLogic console.
  • Analyzed stuck thread, managed servers, created default authenticated user and configured settings through WebLogic console.
  • Created and assigned application roles in WebLogic EM.
  • Worked on Trace level settings for WebLogic managed servers.
  • Created mapping/mapplets, reusable transformations using all the transformations including Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets, etc.
  • Implemented and configured actions on development, Test, production, and UAT assigned users are groups and masked the data and restricted users.

Environment: Oracle Business Intelligence 11.1.1.6/11.1.1.7 , BI Publisher, Oracle PL/SQL, SQL Server SSIS, Informatica 9.5, Toad, Windows XP, Oracle 11g.

Confidential, RIVERSIDE, CA

OBIEE/Informatica Developer

Responsibilities:

  • Worked on OBIEE answers and dashboards to create the reports per the Client requirements.
  • Used Informatica PowerCenter for extraction, transformation, and loading data from heterogeneous source systems and to create mappings, mapplets transformations, re-usable transformations, etc.
  • Performed design and development of complex ETL mappings and stored procedures in an optimized manner.
  • Implemented partitioning and bulk loads for loading large volume of data.
  • Implemented hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
  • Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
  • Used Informatica debugging techniques extensively to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Used third-party tools including control-M for scheduling along with Informatica PowerCenter and Oracle 10i developed Segment Value Detail, workorder Detail and OGA Repositories (RPD) by importing metadata into physical Layer, applied business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
  • Created catalog groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
  • Configured interactive dashboard with drill-down capabilities using global and local filters, metadata Objects and Web catalog Objects.
  • Applied cascading prompts and multi-level prompts on dashboards.
  • Identified issues, performance bottlenecks and optimized the Business Intelligence dashboards and reports.
  • Developed different kinds of reports (pivots, charts, tabular) using global and local filters.
  • Wrote custom SQL codes for the reports.
  • Applied optimization techniques for the better performance of the reports.
  • Worked with business analyst and users (financial advisors or FAs) to gather analytics requirements and created the business model using star schemas.
  • Trained end users and pilot users about OBIEE Tools.

Environment: OBIEE 10.1.3.4, Oracle BI Applications 7.9.4 (Financial Analytics, HR Analytics), Informatica 9.1, DAC, Oracle 10g, Oracle EBS, SQL Developer, SQL*Plus, Informatica PowerCenter 7.1, Windows XP.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Worked extensively on ETL code using PL/SQL to meet requirements for extract, transformation, and loading of data from source-to-target data structures.
  • Developed ETL-Informatica workflows per business standard document.
  • Used Shell scripting for automation of ETL work.
  • Developed ETL (Informatica) components to extract data from flat files and DB tables.
  • Loaded target tables as business requested to send the data to downstream systems.
  • Utilized PL/SQL tables and bulk collections to perform very quick loading of data.
  • Rewrote entire PL/SQL package which was being used to send daily load status updates to the Testing team. The email formatting was not elegant and had a lot of misalignment.
  • Used HTML tags in PL/SQL to deliver a well-organized and readable email status update to the testing group.
  • Optimized and tuned SQL queries through utilizing the explain plan to find out the problem area of the query.
  • Used SQL*Loader extensively to load data into the target tables.
  • Wrote control files based on the both positional mapping and for CSV or tilde separated values.
  • Provided support for the reporting team which was using crystal reports on the database.
  • Analyzed and corrected the SQL queries to give the expected values.
  • Wrote Unix Shell scripts to schedule time-based loads for the Cron jobs.
  • Created complex views using joins and aggregate functions to support the reporting team and the BI team.
  • Provided performance tuning of complex SQL queries using Explain Plan.

Environment: Oracle 10g, MS SQL Server SSIS, Informatica PowerCenter 8.6, Toad, PL/SQL, SQL, SQL*Loader, Unix.

Hire Now