Power Data

Mithila

*********@*****.***

Work Authorization-GC

Profile:

* ***** ** ********** ** SQL server/ Power BI developer having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server.

Development, TSQL, Azure, Power BI for building, deploying and managing applications.

Led the development of end-to-end Power BI reporting solution for large clients including data modeling, dashboards, apps and content packs, SQL queries and ETL processing, workflow and transformations.

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008.

Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.

Excellent understanding of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.

Extensive knowledge in Tuning T-SQL queries to improve the database performance.

Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) on Microsoft SQL Server.

Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.

Formed various measures and calculated columns utilizing DAX in Power BI to answer business questions. Performed time series analysis using DAX expressions in Power BI.

Excellent hands-on experience in groups, hierarchies and measures, KPIs, well verse in creating DAX (Data Analysis Expressions) functions in creating Power BI dashboards reports.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density chart Created and managed workspaces, apps, dashboards and packs for various business users across multiple tenants.

Build solution driven dashboards by developing different chart types including Crosst Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Power BI Pro.

Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of it.

Shared dashboards and reports with user groups by using Power BI App and content packs.

Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report using Power BI and.

Education:

Master of Business Administration (Major: Finance)

Stamford University, Bangladesh-2010

Bachelor of Business Administration (Major: Finance)

Stamford University, Bangladesh-2008

Professional Experience:

Telecom Technologies services March2018- Oct2020

Power bi Developer

Goal: My goal was to gather business requirement documents and implement using Power BI utilize power bi desktop and power premium to create reports and dashboard for the sale department, quality management, and validation department to track and monitor various product and give insight into data by utilizing different visualization.

Responsibilities

Implemented acquisition processes to fetch the data from the desperate sources.

Extracted data from SQL Servers, Azure, excel sheet, CSV files.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI.

Integrated custom visuals based on business requirements using Power BI Desktop.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Power BI Service (hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.

Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT, CALCULATE FUNCTION, CALCULATE TABLE AND RELATEDTABLE.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.

Converted all the existing operational excel reports into Power BI reports.

Generated context filters and data source filters while handling large volume of data using Power BI.

Formed Row level security with Power BI and integration with Power BI Service Portal

Created data refreshes schedule for data sources on Power BI service by configuring enterprise data Gateway.

Extensive knowledge and experience in developing scripts using T-SQL for querying against databases.

Tool & Environment Power BI Desktop, Power BI Service, Data Gateway, MS SQL Server, DAX, T SQL, Oracle,SQL Profiler,XML, MS Excel, Windows 10, DAX Studio, M Query.

SM group and company, Bangladesh Mar 2010 to Jan2015

Financial Analyst

Goal: The project was about creating packages for extracting and loading data in data warehouse and according to business user various reports were implemented.

Responsibilities

Generating and designing Business Intelligence solutions and application development in financial industry.

Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like excel Access and Oracle.

Work with executives and other business leaders to identify opportunities for improvement.

Create reports for internal teams and/or external clients.

Collaborate with team members to collect and analyze data.

Establish KPIs to measure the effectiveness of business decisions.

Structure large data sets to find usable information.

Work with a team of analysts and other associates to process information

Create presentations and reports based on recommendations and findings.

Performed data analysis and data profiling using SQL on various sources systems including SQL Server.

Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform data manipulations.

Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.

Tools & Environment: SQL Server 2012/2008, MS Excel 2003-2007, ETL, T- SQL, MS SQL Server Integration Services (SSIS)

Contact this candidate