I am trying to place
Contact details for include:
• Full Legal Name : Rajkumar
• Current Location: Austin, TX
• Work Authorization (US Citizen/Green Card/H1 etc):Green Card
• Expected Pay rate
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.
Thanks & Regards,
Mark Spencer
Business Development Manager
Integration Business
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
For more options, visit https://groups.google.com/groups/opt_out.