We provide IT Staff Augmentation Services!

Power Bi Consultant Resume

SUMMARY

  • A pragmatic, technically versatile and goal - orientated BI Developer with 8+ years’ experience. Experience in Requirements Analysis, Enterprise Analysis, Requirements Management and Communications, Business Analysis Planning and Monitoring.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Text file, MS SQL and Oracle Servers by using SSIS and SSMS services.
  • Expertise in creating and managing Event Handlers, Dynamic Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Experience in creating SQL Server Agent Jobs, SQL Mail Agent, Alerts and Schedule SSIS Jobs.
  • Good analysis and modification of existing stored procedures and queries to integrate them into previously built reporting application, utilizing SSRS and SQL Server Management Studio.
  • Proficient in Power BI visualization, Reporting and creating Dashboards.
  • Expertise in Creating and publishing various reports in Power BI using DAX and complex data models from Excel, SSAS Tabular & MDX, SQL Tables and SharePoint.
  • Excellent experience in maintaining PBI Premium Capacity, Pro Licenses, Workspaces, Data flows, User accesses, RLS and Schedules.
  • Performance Tuning and Optimization of BI reports at all levels.
  • Good knowledge of DWH concepts, OLTP, OLAP, Normalization, Star and Snowflake schemas.
  • Generated OLAP databases using the KIMBALL method and calculated measures by writing MDX queries. Dimensional Data Modelling and Cube development in SQL Server 2014 Analysis Services.
  • Led small teams and provided support on large environments.
  • Experience in Database Design, Development, and Query Optimization using MS SQL Server 2008/2012.
  • Experience in writing complex Database Queries, Stored Procedures, Triggers, and Cursors using MS SQL Server and PL/SQL.
  • Experience in web development and programming using ASP.NET, Visual Studio, C#, HTML, Bootstrap.
  • Experience in Requirements Analysis, Enterprise Analysis, Requirements Management and Communications, Business Analysis Planning and Monitoring. Very good knowledge on Dotnet C#, ASP.Net, MVC, Dotnet Core, Web Services, WCF Services, ADO.Net, LINQ, Entity Framework, SQL Server, .NET Framework 3.5/4/4.5 and .NET Core, Angular, HTML, CSS, jQuery, JavaScript, Angular 2+, Angular 6, Bootstrap, nunit Testing.
  • Create Entity classes, relationships between entity classes using LINQ to SQL, LINQ to Entities, and LINQ to Dataset to manage relational data as objects.
  • Support Continuous Integration and Continuous Deployment activities using Jenkins.
  • Worked in CI/CD ways of working using tools like Azure DevOps.
  • Works with business partners to align with business strategies as BSA.
  • Supports low to moderately complex business processes.
  • Conducts data gathering and analysis to understand business strategy requirements.
  • Leadership skills enabled by capacity to mingle easily, instill confidence in each member, and encourage team participation.
  • Straightforward and confident communication skills combined with talent for motivating sharing of thoughts.

TECHNICAL SKILLS

Query Languages: SQL and T-SQL

Databases: SQL Server 2008/2012/2016 , MySQL, Oracle

ETL Tools: SQL Server Integration Services (SSIS)

OLAP Tools: SQL Server Analysis Services (SSAS)

Reporting Tools: Power BI, SSRS and QlikView

SCCS Tools: TFS and SVN

Programming Languages: VB.Net, C#.Net, Classic ASP, VBA

Web Technologies: ASP.Net.

Front End Technologies: Angular 2+, Kendo UI, Bootstrap, HTML, CSS, JavaScript, JQuery

Cloud Technologies: Microsoft Azure

Other Technologies: ADO.NET, Web Services, WCF Services, MVC 4.5

Editors: MS-Office, Visual Studio .Net 2008/2010/2012/2013.

Application Server: IIS 6.0/7.5.

Version Control: Team Foundation Server (TFS), VSS, Tortoise SVN, GIT

PROFESSIONAL EXPERIENCE

Confidential

Power BI Consultant

Responsibilities:

  • Analyzing over SSAS Multidimensional, Tabular cubes and Dataflows for better data modelling in PowerBI and prepared proof of concepts.
  • Creating complex data models on Power BI Desktop for reporting.
  • Build reports and dashboards via Power BI
  • Leading multiple reporting projects from requirements gathering to publishing and having frequent meetings with users across EMEA team.
  • Replacing Excel reports with PowerBI for fully automated, improved visualisation.
  • Using Excel, SharePoint, SAP, Big Query and SSAS cubes as sources for Reports.
  • Creating complex DAX measures for Visualisations, Reports and Dashboards.
  • Extensively using Query Editor with M Code for data cleansing in Power BI.
  • Handling Power BI Premium Capacity, User accesses, Gateways, Dataflows and Admin.
  • Managing User Rules and Roles, Power BI Apps on service and schedule refreshes.
  • Experience developing complex SQL scripts, views, CTE and stored procedures.
  • Experience handling/processing large volumes of data.
  • Conduct root cause analysis and advanced performance tuning for complex business processes and functionality.
  • Perform SQL query performance tuning by creating/modifying indexes, setting transaction levels and changing query structures.
  • Experience with various databases, including: Oracle or SQL Server.
  • Experience handling/processing large volumes of data.
  • Experience working on .net. HTML, Bootstrap.
  • Following Agile Methodology in project development and using ServiceNow for sprints and incidents.
  • Using Team foundation server (TFS) for managing source code changes. worked in CI/CD ways of working using tools like Azure DevOps.

Environment: PowerBI, SSAS, Excel, SharePoint, ServiceNow, SQL server 2016, Oracle PL/SQL, Visual Studio, C#, HMTL, Bootstrap, Azure Devops

Confidential

SQL/BI Developer

Responsibilities:

  • Designed new DWH by creating various SSIS packages and automated them.
  • Created Drill down and drill through reports in SSRS.
  • Wrote Procedures, Views and logical T-SQL scripts to consolidate data.
  • Performed normalization of database to reduce redundancy and achieve maximum system performance.
  • Created and manage schema objects such as tables, views, cursors, indexes and stored procedures.
  • Used Query analyzer to optimize query performance.
  • Provide support for the deployment of database scripts in development, test, pre-production and production environments.
  • Used data encryption methods to bond with GDPR.
  • Structure the data into meaningful DWH tables by extracting from various Excel and Text files.
  • Integrated the data using Script task by writing C# code in .net framework.
  • Worked with SSAS Cubes for faster reporting and better performance and Analysis.
  • Consolidated daily/weekly/monthly data feeds from SFTP server to SQL Server.
  • Created measures in PowerBI using DAX queries, designed dashboards and published them on Service.
  • Led small teams and actively interacted daily with business professionals.
  • Worked in a Cloud computing/Azure environment.
  • Expert using MS Excel and Power point.
  • Followed Agile methodologies in project development process.
  • Uses Azure DevOps / Team Foundation Server (TFS) to respond to organizational requests, document and track progress, and maintain version control of reports and code.

Environment: SQL Server 2012/2016, SSIS 2012/2015, PowerBI

Confidential

Datawarehouse Analyst/Developer

Responsibilities:

  • Designed New SSIS packages for data Extraction and load into DW.
  • T-SQL programming to create/alter Stored Procedures, Views and Joins.
  • Created jobs/steps and scheduled them through SQL server Agent.
  • Extracted data from Excel, Text files and loaded into SQL Server tables.
  • Created various reports in QlikView and scheduled the refreshes.
  • Wrote technical documents for all developments and achieved sign off by project managers.
  • Used all the software release control systems to release the developments from UAT to Live.
  • Daily interaction with end users.
  • Monitored and fixed the failed daily SQL Server agent jobs on production servers.
  • Maintained Code standards and Quality reviews.
  • Worked in an Agile Environment and delivered Sprints on time.
  • Development is done in agile methodology and all the tasks are tracked on Trello.
  • Participates in scrum meetings, sprint planning using planning poker, spring review, sprint retrospective.
  • Use JIRA to track Sprint related tasks.

Environment: SQL Server 2012/2016, MySQL, SSIS 2010

Confidential

MSBI Developer

Responsibilities:

  • Integrated several source systems by applying transformation rules and built a new DW for better reporting purpose.
  • Developed and Maintained SSIS/ETL’s packages.
  • Integrated the data from SQL Server systems to Microsoft Dynamics CRM.
  • Used Derive column, Conditional split, Aggregate, Lookup, SCDs, and Execute SQL Task to load data into the data warehouse.
  • Wrote various T-SQL scripts for better performance.
  • Wrote C# for Script task to achieve complex requirements.
  • Worked on data profiling and cleansing with validation rules using DQS.
  • Created jobs and scheduled them through SQL server Agent.
  • Maintained responsibility for building packages, deployments and package configurations.
  • Designed monthly, weekly and daily reports for analytics and reporting teams using SSRS.
  • Followed Agile Methodologies while integrating data from Multiple Sources.

Environment: SQL Server 2012, SSIS 2012

Hire Now