IT JOBS: {SAP JOBS USA:125191} Availability of OBIEE/BI Apps Lead Consultant

Wednesday, 25 September 2013

{SAP JOBS USA:125191} Availability of OBIEE/BI Apps Lead Consultant_RajKumar

Greetings !

I am trying to place

Consultant

on a contract at this time. Also attached

his

resume

. Please free to contact directly for additional information(Only for Direct client requirements)

Contact details for include:

Business Intelligence developer - Irving/Dallas, TX (MR) Rajkumar

• Full Legal Name : Rajkumar

• Current Location: Austin, TX

• Work Authorization (US Citizen/Green Card/H1 etc):Green Card

• Expected Pay rate

:$100/hr all inc

Professional Experience summary:

●      Over 14 years of IT experience including over 6 years of expertise in Creating Complex Applications with special emphasis on design & development of Data Warehousing, Business Intelligence and Database Administration.
●      Hands on experience in ETL process using Informatica Power Center for various transactions and loading data from various legacy data sources.

●      Designed and developed Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer of OBIEE.

●      Possess good knowledge in importing prebuilt OBIA mapping to Oracle DAC (Data Warehouse Administration Console) and customize prebuilt mapping based on requirements.

●      Experience in Developing Informatica Mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with worklets & tasks and scheduling using Workflow Manager.

●      Expertise in debugging and optimizing OBIEE Dashboards / Reports

●      Experience in setting up DAC, creating Source System Container, Subjects Areas and Execution Plans for scheduling and executing existing Informatica Workflows.

●      Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks

●      Experience in creating, populating and maintaining data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

●      Experienced in Building Cubes and Measure Group, Measures, Dimensions with different Architectures and Data Sources for Business Intelligence.

●      Experience in Database Query Optimization & Performance Tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

●      Experienced in Database Backup and Disaster Recovery Procedures.

●      Experienced in Replication – Snapshot, Merge and Transactional.

●      Experienced in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.

●      Experienced in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

●      Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

●      Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

●      Extensive experience in writing MDX Scripting and MDX Queries.

●      Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.

●      Post-production support, enhancements and performance tuning.

●      Strong experience in working with Banking, Finance, Real Estate and Telecommunications domains.
●      Worked with Major Clients like PayPal, Texas State Government (DARS), IBM, Citi Bank, Deutsche Bank, Motorola India Electronics and Efunds.