Power BI

Manish Singh

Power BI Developer/ MSBI Developer

adzzto@r.postjobfree.com 469-***-****

Over 4 years of professional IT experience in Business Intelligence solutions using Power BI (Power BI Desktop and Power BI Service), T-SQL, SSRS, SSIS, SSAS and Data modeling, data design, Programming using DDL, DML, DCL commands for various business applications.

Experience in connecting with multiple data sources like SQL Server, and Excel from Power BI to build complex Datasets.

Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL statements for various applications.

Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.

Experience in coding the T-SQL using the Temp tables, Table variables by analyzing the Business logics.

Generated complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries.

Proficient in Performance Tuning/Query optimization using indexes. Tuning the performance of stored procedures and large TSQL Queries using Clustered Indexes, efficient coding standards.

Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.

Extensively worked on performing the ETL Activities in Power Query.

Good experience in filtering Unwanted Data in Power Query.

Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un-Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc.

Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.

Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.

Extensively worked in Power View for Presenting the Data in Graphical Format using Different Visualizations in Power BI.

Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play dimension in SSAS.

Hands on experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.

Experienced on creating multiple kind of Report in Power BI and present it using Story Points and Created, Maintained & scheduled various reports in Power BI like Tabular Reports, also deployed the reports to reporting server by assisting deployment problems.

Good experience in creating Hierarchies and Drill-down Reports.

Good experience in sorting the Data in Visualizations, Grouping and Binning the Data in Power BI.

Extensive experience in Creating APP Workspaces and adding the Members to Workspace to Manage the Content in Power BI Service.

Experience in publishing the Reports to Power BI Service, creating Dashboards using multiple Reports, setting up the Necessary connections, and sharing these Reports and dashboards with End Users.

Worked on On-Premises Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.

Implemented Row Level Security (RLS) as part of security in Power BI.

Hands of experience in using SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.

Worked on different Agile Methodologies like TFS, Azure DevOps.

Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.

Education Details

Bachelor in Electronic Commerce

Babu Banarasi Das Institute of Technology & Management Lucknow, India

Technical Skills:

Languages: T-SQL, PL SQL.

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2018/2016/2014, Oracle,

ETL Tools: SSIS (SQL Server Integration Services), DTS

Tools: Microsoft Visual Studio 2016/2014/2012, Microsoft Azure, MS Office, Oracle SQL Developer

Reporting Tools: SSRS (SQL Server Reporting Services), Power BI, Tableau.

Operating System: Windows family

Power BI Developer Ally Financial – Dallas TX 02/2021 - Present

Responsible for creating Database Objects like Stored Procedures, User-defined Functions, triggers, Views, Tables, etc.

Create and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance

To ensure the participation of clients in the process of development

Created Database and Database Objects like Tables, Stored Procedures, Views, User Defined data types, and functions.

Developed, deployed, and monitored SSIS Packages for new ETL Processes

Created SSIS packages to populate data from various data sources.

Responsible for developing and building the Reports/Dashboards and deploying them into Power BI.Com service.

Responsible for importing data from SQL Server and building the dashboards as per the requirement.

Responsible for Creating Relationships b/w the tables using Modeling in Power BI

Responsible for Creating calculated columns and calculated measures as per the business needs.

Responsible Import, reshaping, and modeling the data.

Responsible for scheduling the dashboards according to frequency(daily, weekly)

Responsible for creating Workspaces and sharing insights with specific business customers/partners and stockholders.

Work closely and build relationships with team members and clients.

Created various Power BI Visualizations using Maps, Waterfall, Bar charts, Column charts, Line charts, Area charts, Tree maps Card, and KPIs

Applying transformation techniques Using Power Queries like appending, merging queries, custom columns, and Un Pivot columns

Created calculated columns and calculated measures as per business needs in Power BI

Responsible Import, reshaping, and modeling the data.

Responsible Create stunning reports and visualizations.

Responsible for importing data from SQL Server and building the dashboards as per the requirement.

Responsible for scheduling the dashboards according to frequency.

Power BI Developer ExxonMobil – Irving TX 08/2019 - 01/2021

Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data mode.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI

Implemented role-based security and row level security on data in Power BI

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Involved in integration of SSRS reports to embedded Power BI reports and deploy them on to Power BI service.

Created Power BI dashboard and generated reports using the SQL server tables as source.

Lock objects on the reports

Used Power BI for the creation of dashboards and Reports for the tracking of SQL Jobs activities for our Data warehouse.

Developed integration of Power BI reports into Power Apps and interacting the data by visuals through Power Apps and modifying the existing records in real time accordingly

Worked as a database developer on databases like MS SQL Server using T- SQL, stored procedures, and views to get data from Data warehouse.

Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc.

To generate underlying data for the reports and to export cleaned data from Excel, Text file, and XML file to different data Marts.

Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

Deployed, Tested and Scheduled SSIS packages.

Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS)

Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.

Converted MS SSRS and Excel based reports to MS SSRS based reports.

Performed data extraction, transformation, and loading (ETL) between systems using SQL tools such as SSIS.

Generated multi parameterized reports in Report Builder allowing users the ability to make selections before executing reports; thus, making them user friendly.

Extensive experience delivering OLAP cubes solutions by developing Corporate Dashboard Reports using MS SQL

Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

Developed dashboards to show survey, design, construction, and information to field contractors.

Developed various packages to extract the data from different sources like relational tables and flat files.

Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dumping the data in to SQL.

Database

Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server R2 and

Report Builder

Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services

Involved in understanding their requirements and translating functional requirements to technical specifications.

Environment: Power BI, SQL Server, SSIS, SSRS, TSQL, MS PowerPoint, MS Project, Visual Studio, OLAP, ETL, Excel and Windows.

Contact this candidate