PROFESSIONAL STRENGTH & CAREER SUMMARY:
A result-driven professional career with 4 years of experience in Business Intelligence and Analytics, which includes Power BI, Power BI Embedding Tableau, Qlik Sense, SSIS, SQL, and Data Warehousing. Rich experience & knowledge of BI Applications especially Microsoft Power BI.
- Experience in understanding and analyzing the client's needs/requirements.
- Gathered information regarding users, workflows, functionality, appearance, and permissions.
- Ability in leveraging data analysis tools and techniques and extracting insights from data and drive resultant business action
- Have good Experience in customizing portal features based on the Requirements and Business solutions.
- Worked Power BI embedding reports into an external application
- Worked on DAX expressions like filters, Aggregate, Mathematical Functions, etc., measures, and calculated columns.
- Comfortable in working with filters/calculated columns/measures/relationships and transformations of the Edit Query section.
- Worked on On-Premises Gateway to refresh the data sources/create a live connection.
- Worked on Power BI Premium dedicated capacity reports and also implemented incremental refresh functionality.
- Designed and implemented basically to advanced transformations to generate reports meeting data quality requirements.
- Worked on drill-downs, Bookmarks, parameters, and trend analysis with analytical functions.
- Designed and implemented basically to advanced transformations to generate reports meeting data quality requirements.
- Worked on drill-downs, Bookmarks, parameters, and trend analysis with analytical functions.
- Developed physical and logical data models from the source data, and optimized data models.
- Worked on RLS, Subscription, Scheduling, and report sharing on Power BI Service
- Worked on Power BI report Builder to create paginated reports.
- Worked on Microsoft flow and Power BI automation part.
- Basic knowledge of SQL Server and Snowflake.
- Creating CI/CD build and release pipeline for continuous integration and deployment on all the environments like Dev/Test, UAT, and Prod.
- Good experience in working with CI/ CD, code reviews, and working in agile development.
- Creating Database objects – tables, views, and developing procedures for implementing application functionality at the database side for performance improvement.
- Proficient in SQL querying Views, Stored Procedures (comfort with temporary tables and multi-step queries).
- Strong Knowledge of Power BI to import data from various sources such as SQL Server, Azure SQL DB,Azure data warehouse, Snowflake and MS Excel, etc.,