• 10+ years of IT experience in Requirements Gathering, System Analysis, Design, Data Modeling, De...
• 10+ years of IT experience in Requirements Gathering, System Analysis, Design, Data Modeling, Development, Testing and end-to-end Implementation of Business Intelligence Analytic Solutions for various business verticals like HealthCare, Auto, Manufacturing, Pharma, Banking, Avionics with source ERP Systems like Oracle EBS and PeopleSoft and JD Edwards • Extensive Implementation Experience of 8 years in customizing Oracle Business Intelligence Applications (OBIA ) pre-built solutions in various areas like Financial, HR, SCM and Service Analytics using Oracle Business Intelligence (OBIEE) and Informatica Power Center following full SDLC/Agile life cycle. • Oracle Certified Associate with SQL and PL/SQL certifications. • Strong Management experience guiding onshore and offshore teams for the client deliverables. • Comprehensive Data Integration experience in ETL using Informatica Power Center – Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica/ Repository Server manager • Expert ETL skills in customizing Pre-built BI apps Informatica workflows Source dependent extract (SDE) and Source Independent Loads (SILOS) in accordance with business requirements • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. • Extensive experience in configuring Interactive OBIEE Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and Key Performance Indicator (KPI’s). • Expertise in building Metadata Model (rpd), building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool with Aggregate aware logical dimensions • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUD). • Experienced in BI Publisher, MS Office Plug-in for rich reporting and Expertise in Cache, Usage tracking, Aggregate navigation, Variables/Initialization Blocks configuration etc. • Developed several Reports / Dashboards with different Analytical Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using OBIEE Analytics Web. • Expert Orchestration skills in Data Warehouse Administration Console (DAC) to Configure, Monitor, Schedule ETL • Experienced in OLAP Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling using Data Modeler (Erwin) • Multi-platform experience on Unix/ Linux and Windows Server family Technical Skills: Reporting Tools OBIEE 10.1x/11.1x, Siebel Analytics 7.x, BI Publisher ETL Tools/Schedulers Informatica Power Center 9.x/8.x/7.x, Erwin, DAC, Tidal Scheduler Databases Oracle 9i/10g/11g, SQL Server, Teradata, Bigdata Languages SQL, PL/SQL Packages OBIA 7.9.x ,11g, Oracle EBS R12, PeopleSoft Environments Windows, UNIX, SQL Developer, TOAD, Java Net Beans IDE Application Servers Weblogic 9/10/11.x Technologies JAVA Scripts, XML, PHP, HTML, CSS, AJAX, SOA, BPEL Process SDLC, Agile, ITIL, Project Management
* Click the button to send an offerSend offer