Giri

HI

I have 5 years experience in Microsoft Business Intelligence and power bi tools.
I have experienced in SSIS, SSRS, SSAS( multidimensional )., power bi tools
I have experienced the SQL server database.
â?¢ Experience in Design, Development, debugging, Implementation of ETL using SSIS (SQL Server Integration Services).
â?¢ Experience in Creating packages (SSIS) Using Business Intelligence 2008-2010-2014.
â?¢ Creating reports (SSRS) Using Business Intelligence .
â?¢ Expertise in providing business intelligence solutions by configuring metadata & building dimensional data modeling design, generating reports, and creating Dashboards using MS Power BI.
â?¢ Extensive experience in designing datasets and developing complex calculated measures using Data Analysis Expression language (DAX).
â?¢ Experience in configuring scheduled refresh for the data sets and reports in the Power BI Web using Gateways.
â?¢ Strong Conceptual, Business Analytical skills with ability to provide work estimate and meet deadlines.
â?¢ Good knowledge on Data Warehousing, Dimensional Modeling, Schemas (Star, Snowflake) and OLAP Concepts.
â?¢ Experience in writing T-SQL queries.
â?¢ Experience in writing T-SQL queries StoredProcedures, Functions, Triggers, SQL Query, Indexes.
â?¢ Experience on T-SQL Performance Optimization
â?¢ Creation execution and monitoring of SQL Jobs .
â?¢ Experience in designing SSAS Cubes
â?¢ Good knowledge of creating aggregations on SSAS cube level.
â?¢ Having good Knowledge on Data warehouse design concepts.
â?¢ Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
â?¢ Good knowledge on created named queries and creating Attribute relationships.
â?¢ Having good Knowledge on Create the cube level partitions with SSIS packages.
â?¢ Involved in the creation of the Demission level hierarchy.
â?¢ Having good Knowledge (MDX), mathematical formulas, and user-defined functions and create the calculated measures.
â?¢ Involved in creation of multiple perspectives on cube level.
â?¢ Having good Knowledge of Creating SSIS packageâ??s to run the cubes.
â?¢ Handled the tuning and troubleshooting of a cube at Deployment mode.
â?¢ Awareness of issue tracking and project management LIKE Jira .
â?¢ Direct interaction with Client for requirement .
â?¢ Coordination with different Stakeholder to meat the delivery expectations.
â?¢ Operational knowledge of Software Development Life Cycle (SDLC).
â?¢ Ability to learn & develop using new technologies quickly.
â?¢ Analytical approach for analyzing & understanding the domain & business logic
â?¢ Good communication and interpersonal skills. Responsible for Daily Client Reports, client communication and status reporting.