• Energetic and goal oriented professional with 7+ years of experience in MSBI, Oracle BI, and trained on SAS BI.
• Microsoft 2012 certified Solutions Associate.
• Extensive experience in MSBI tools such as SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Database and Oracle’s Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI), Oracle Database.
• Hands on experience in installation, upgrade and configuration of Microsoft SQL Server and databases
• Expertise in creating Stored Procedures, Functions, Views and Indexes.
• Expertise in creating Dynamic Reports using SSRS.
• Experience in designing complex reports using Drill Down and Drill Through features of SSRS.
• Proficient in using expressions to filter, group, parameterized and format of reports.
• Hands-on experience in designing an ETL solution using SSIS.
• Experience in designing SSAS Cubes
• Good knowledge in creating Calculations, KPI’s and Partitions in SSAS.
• Hands on experience in end to end development of OBIEE Reports, filters & Charts
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Snowflake Schema Modeling of Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool
• Experienced in answers, dashboards.
• Experienced in writing stored procedures using PL/SQL.
• Experienced in merging RPD and moving RPD and webcat files to different environments and ware of using catalog manager.
Reviews For This Service