Input your fixed/hourly price in this field.
Freelancers
freelancer
Sarath D
0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • NC
  • Save

• 8+ years of experience in Oracle Business Intelligence Enterprise Edition (OBIEE) and in Oracle Business Intelligence Apps (OBIA). • Expertise in implementing BI APPS 7.9.6.4 for Procurement and spend analytics, Financial Analytics and HR Analytics modules with in-depth understanding of Procure-to- pay, Account Receivables, Account Payables, General Ledger, Aging buckets and Purchase requisitions, Purchase Orders and work force. • Experience in configuring interactive Dashboards with drill-down capabilities, OBI Security Setups for metadata objects, and Web Catalog Objects (Dashboard, Pages, Folders, Reports). • Extensive working knowledge in various SDLC methodologies like Waterfall, Agile Scrum and Kanban. • Extensive experience working in JAD sessions and understanding of scrum methodology and project tracking using jira and the project cycle as a whole. • Ability to design and develop ad hoc queries, reports, analytics through OBIEE solutions • Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBIEE Administration tool. • Proficient in developing the rpd using Physical Joins, Complex Joins, Complex Measures and Time Series Functions. • 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). • Thorough understanding of Change Data Capture (CDC), Slowly Changing Dimensions (SCD) and implementing them using ODI. • Setting up ODI Security for external authentication and to build roles and profiles for the existing users. • Worked with Actions and procedures for re-usability of contexts and whilst altering DDLs if needed. • Worked with Hyperion DRM (Master Data Management ) to pull the hierarchy on to the obaw schema for reporting. • Proficient in developing complex ODI interfaces, packages and scenarios by using global/local variables. • OBIEE 12c migration experience from OBIEE 11g with jar scripts, migration tools and export import handling. • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau. • Hands-on experience working on Informatica development working through mappings and transformations. • Experienced in working on Tableau (Desktop, Server, Reader), creating Dashboards and Reports using different functionalities • Strong SQL experience in writing queries for data analysis and report development and testing • Experiencein gathering business requirements, Design / Modeling with Star and Snowflake Schemas • In depth knowledgemanaging SDE and SIL using the Data Warehouse Administration Console (DAC) • Experience configuring Interactive Dashboards with drill-down capabilities using global and local filters • Strong in de-bugging, optimizing and performance tuningof Oracle BI Dashboards / Reports • Manage security privileges for each subject area and dashboards according to user requirements • Intermediate skill in developing mappings using various transformationson data imported from multiple sources to data Warehouse,creating workflows with work-lets & tasks and scheduling using workflow manager • Intermediate knowledgeworking with Informatica Server and Client tools like Power Center Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Server Manager • Working closely with the database developers on indexes and the data in the tables with the appropriate facts and dimension measures • Experience working with Tableau development skillset including visualization development, use of parameters, and report optimization. • Experience with designing complex dashboards taking advantage of all tableau functions including data blending, actions, parameters, etc. • Experienced in working on Tableau (Desktop, Server, Reader), creating Dashboards and Reports using different functionalities. • Publish a visualization to Tableau Server • Participate in gathering customer requirements & use it for dimensional modeling • Working with DBA’s, Java Developers, QA and the entire team throughout the project and sort out some developmental and administrative tasks. • Hands on experience withSQL Developerfor access to database tables, create new tables and update/delete the data as per the requirement • Well-developed organizational and communication skills, with strength in inter-personal relationships. • 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: • OBIEE 11.1.1.x/10.1.3.x, OBIA 7.9.6.4, 11.1.1.7.x, Tableau Desktop 8.2, Tableau Server • Informatica 9.1.0, DAC 11.1.1.x, ODI 11g, SQL Developer 4.0, Toad • Oracle 10g, 11g • Windows, Linux and UNIX • Microsoft suite – Excel, Outlook, Word and PowerPoint • MS Project and MS Visio

0

Ongoing projects

0

Completed projects

0

Cancelled projects

3

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer