Manu K.

Background

About Manu K.

Experienced in Database technologies like SQL Server, MySQL and Oracle. Experienced as BI developer/analyst on designing, developing and implementing reporting systems using tools like SSRS, Power BI and Tableau. Worked with end users and business analysts to understand business requirements, recommended technical solutions and documented functional requirements. Worked on various Microsoft technologies tools and different third party tools for reporting. Experienced in creating DAX Expressions and implement partitions in Tabular Models for Power BI. Experienced in publishing Power BI Reports of dashboards in Power BI Server and Scheduling the dataset to refresh for upcoming data in Power BI Server. Experienced importing data from different data source to create Power BI reports and dashboards. Experienced with the SDLC process - performing detailed analysis, collecting business requirements, Design, Development & implementation. Experienced with DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys for T-SQL and PL/SQL. Knowledge of Data warehouse, Data modeling with Star schema and Snowflake schema. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Experienced in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables. Knowledge of Database Recovery models, Performance tuning, Database backup and disaster recovery procedures. Expert in creating Databases, Tables, Stored Procedure, Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. Strong understanding in installing MS SQL SERVER on both AWS and Azure environments. Good Knowledge on AWS services like EC2, Cloud Front, and Cloud Formation templates etc. Knowledge in analyzing Data warehouse by building and deploying cubes using SQL Server Analysis Services.