We provide IT Staff Augmentation Services!

Odi/tableau Developer Resume

TX

SUMMARY:

  • Over 7Years of IT experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes Oracle Data Integrator 11g/12c, OBIEE, SOA Suite 11g, and WebLogic server 10.3.
  • Experience in leading small and medium teams and extensive experience in onshore coordination.
  • Experience in Analysis, Design, and Development including Implementation of Business Intelligence BI solutions using OBIEE/Siebel Analytics.
  • Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Worked on ODI 11g and ODI 12c studios.
  • Using Data Warehousing DWH tools like OBIEE, ODI and JDeveloper.
  • Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers, Answers, Dashboards, Catalog Manager.
  • Configured the Oracle Data Integrator ODI software tool in a three - tier Environment and performed periodic upgrades, performed source-to-target mappings, storage capacity planning, developing ETL
  • Developed and delivered ETL scenarios in the context of Services Oriented Architecture SOA
  • Worked on Bulk data loading on Oracle EBS environments and involved to resolve the production issues.
  • Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI 11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
  • Gathering requirements from users to develop interfaces and packages.
  • Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
  • Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.

TECHNICAL SKILLS:

Confidential, TX

ODI/Tableau Developer

Responsibilities:

  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Primary responsibility includes 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 ETL
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Extensively involved in production issues.
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
  • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
  • Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
  • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
  • Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
  • Extensively used ODI to load data from Oracle, XML files and flat files
  • Worked closely with the end users/business and designing the documents to the track changes.
  • Coordinated with the on-site and off-shore team and working on service requests as team.
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
  • Created new reports and dashboards as per the business need.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.

Confidential, TX

OBIEE/ODI DEVELOPER

Responsibilities:

  • Creating and submitting status reports to up line managements.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
  • Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
  • Caching options configured and defined overall cache strategy
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into Data Ware House (DWH).
  • Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Oracle data warehouse.
  • Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Created and Imported/Exported various Sources, Targets, and mappings in interfaces using ODI Designer and generated scenarios and scheduled as per client requirements.
  • Loaded data from different source systems to target warehouse using mapping with Knowledge modules like LKM, IKM and CKM for data quality check.
  • Developed several Interfaces, Packages, Procedures and Scenarios in ODI
  • Used most of the transformations such as the Source table joins, using Expression in mapping area, aggregations like SUM, MIN, MAX using in mappings, lookups, Filter, Datasets.
  • Customized ODI KM like LKM and IKMs
  • Created a Physical, logical schemas and Contexts for ELT process.
  • Creating Test cases for Unit Test, System Integration Test and UAT to check the data.
  • Performed scheduling with ELT jobs using Agents in ODI
  • Primary responsibility includes 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 ETL
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Extensively involved in production issues.
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
  • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
  • Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
  • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
  • Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Confidential TX

Data & Business Intelligence Analyst

Responsibilities:

  • Identified components for migration to DataStage through in-depth impact analysis
  • Prepared high level and low-level design documents for the projects
  • Designed ETL processes to Extract, Transform and Load from files into DB2 database and vice versa
  • Used DataStage Designer for developing various ETL jobs
  • Designed parallel jobs using various stages like Sequential File, Complex Flat File, ODBC, Join, Merge, Filter, Lookup, Modify, Transformer, Change Capture and Funnel
  • Extensively used Complex flat file stage to read Mainframe files (Fixed and Variable)
  • Developed jobs in Quality Stage to standardize the data and used Info Analyzer for column, primary key and foreign key analysis
  • Used Autosys to schedule DataStage ETL batch jobs on a daily, weekly and monthly basis
  • Performed unit, integration and regression testing of ETL jobs
  • Used DataStage Director to monitor and collect statistics of various ETL jobs
  • Fine-tuned ETL jobs for better performance and cost effectiveness
  • Requirements Gathering and Business Analysis. Project coordination, End User meetings
  • Development and design of ODI interface flow for Upload / Download files
  • Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle, DB2) feeds using ODI and CDC
  • Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures
  • Develop packages for the ODI objects and scheduled them as scenarios
  • Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator Enterprise Edition 11g.
  • Support in full legacy to ODI data conversion and Integration task
  • Translated business requirements into technical specifications to build the Enterprise Data Warehouse
  • Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
  • Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
  • Installation and Configuration of Oracle Data Integrator (ODI)
  • Responsible for creating complex mappings according to business requirements, which can be scheduled through ODI Scheduler.
  • Responsible for configuration of Master and Work Repository on Oracle
  • 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.

Technical skills: Productivity Tools:

Advanced skills with ODI, OBIEE, SQL server, Tableau, and Power BI.

Oracle Data Integrator ODI 11g/12c, OBIEE 11g/11.1.1.7, OBIA 11.1.1.7.1, Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX.

Hire Now