Imran Hussain

SQL / Power BI developer

ad3gq9@r.postjobfree.com

708-***-****

PROFESSIONAL SUMMARY:

* ***** ** ********** ******* in Business Intelligence Developer with technical knowledge to design, develop and implement data and analytical solutions.

Experience in Data Warehouse Design, Data Analysis/Reporting with Power BI, verbal, and written communications. I have over the years leveraged my BI experience and expertise to contribute to numerous projects helping organizations achieve business goals.

Hands-on experience in groups, hierarchies, and measures, KPI.

Developed and implemented reporting, analytics, and Data visualization solutions with Power BI.

Working knowledge of Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop, Power BI Publisher) and DAX.

Explored data in a variety of ways and across multiple visualizations using Power BI Desktop and Service.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

Experienced on creating multiple kind of Report in Power BI and present it using Story Points.

Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS.

Migrate existing data into the Power BI

Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

Assist end users with problems installing the Power BI desktop, installing, and configuring the Personal and On-Premises gateway, connecting to data sources, and adding the different users.

Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

Experience of creating SQL queries optimizing SQL query performance and modifying SQL elements such as procedure functions and views with a solid understanding of database principles.

Experience of designing and developing data analytic reports dashboards Business Intelligence reports and data warehouses

Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools.

Design and develop reporting data module for Marketing Analysis.

Creating Row Level Security with Power BI Desktop and integration with Power BI Service portal.

Experience in optimizing reports and setting up Power BI service, gateways, and scheduling data refresh.

Collaborated in Software Development Life Cycle (SDLC) using different methodologies.

EDUCATION:

Masters in information technology

TECHNICAL SKILLS:

Platform:

Advanced MS Excel, MS Words, MS PowerPoint, MS Outlook.

BI Tools

MS SQL Server, SSRS, Power BI, MS Office Suite, SharePoint, Snowflake, Salesforce.

Management Tools

Azure SQL Data base, Data Migration Service (DMS), JIRA.

PROFESSIONAL EXPERIENCE:

CVS Health, IL

Power BI developer

Jan 2022 - Present

Responsibilities:

Create, analyze, and distribute ongoing reports as needed by key stakeholders by turning multiple data sets into valuable and interactive insights.

Design and create innovative and valuable visualizations to identify patterns, trends and exceptions which enable the business executives and senior leaders to make data driven decisions.

Understand, own, and support Operational dashboards, business performance dashboards, interpret the results, and summarize opportunities for improvement.

Create insightful BI based reports to monitor and highlight contributing factors to financial and operational variances and anomalies helping the executives in key decision making.

Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

Assist end users with problems installing the Power BI desktop, installing, and configuring the Personal and On-Premises gateway, connecting to data sources, and adding the different users.

Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.

Designed STAR, SNOWFLAKE Schemas.

Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.

Utilized Power BI (Power View) to create various analytics dashboards that depict critical KPI along with slicers and dicers enabling end -user make filters.

Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for Power BI service.

Assist in planning and managing changes to dashboards because of new or improved business processes.

provide support to end users and team members on BI dashboards and other Business Intelligence needs.

Passion to understand the unknown. A willingness and desire to embrace unfamiliar processes with an open-minded approach and a team player.

Johnson & Johnson, TX

SQL / Power BI developer

Sep 2018 – Aug 2021

Responsibilities:

Understood, identified, acquired, and analyzed data from multiple sources to streamline the delivery of information across the company platforms using ETL tools and MS SQL server.

Created ETL Packages, cleansed data, and worked on system integration and data migration using API and XL Connecter- Enabler to bulk loads data from multiple sources into the CRM.

Defined, developed, and implemented data models to generate meaningful insights and delivered self-service analytical data visualizations to the business users using Power BI reports.

Designed and created innovative and valuable visualizations to identify patterns, trends and exceptions which enabled the business executives and senior leadership to make data driven decisions.

Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.

Used various sources to pull data into Power BI such as SQL Server, oracle.

Involved in installation of Power BI Report Server.

Developed reports to visually explore data and create an interactive report Excel and Power BI.

Using a query editor in Power BI performed certain operations like fetching data from different file.

By using Power BI desktop connected to various data sources, working with different visualizations.

Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop.

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

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.

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

Consolidate and aggregate data for visualizations.

Schedule dashboard refreshes and set up proactive notifications.

Demonstrated outstanding communication skills to gather business requirements from end-users and translate them into a meaningful visual product.

Effectively communicated and interacted with business and technical personnel to solve complex, data related business and technical problems.

Actively participate in work group/team activities as an enthusiastic, positive, and dependable team member.

Working extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots, heat maps, setting alerts.

Setup Data gateways for on premises data servers Implement row level security to keep report access to specific users in the organization.

PayPal, CA

SQL/Power BI Developer

Jul 2016 - Aug 2018

Responsibilities:

Responsible for gathering/refining requirements from the customer for developing reports in Power BI.

Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).

Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.

Designed rich dashboards with power BI and prepared user stories to create compelling dashboards to deliver actionable insights.

Created reports in Power BI utilizing the SSAS Tabular via Analysis connector.

Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Created drill down and drill through report to go to details and child report within power bi based on hierarchy.

Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.

Secured the Power BI reports using Row Level Security (RLS) and DAX filters.

Worked with DAX/MDX queries in building expressions for various business calculations.

Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.

Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.

Created Grouping, sorting columns and writing expressions according to the business requirements.

Created SSIS packages to Export data from text file to SQL Server Database.

Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Identified and worked with Parameters for parameterized reports in SSRS.

Used star and snowflake schema in designing cubes for creating SSAS packages.

Interacted with clients to gather the clients.

Contact this candidate