PROFILE SUMMARY:

• Power BI Developer with 8 years of hands - on experience in data modeling, database programming, development tools, integration tools, analysis services, and so on.
• Total 4 years of Experience in Power BI Report and Dashboard Development, have expert Industry knowledge of Power BI Desktop and Service.
• Excellent knowledge in Physical and Logical Data Modelling.
• Highly motivated and a conceptually strong individual with exceptional analytical and communication skills.

TECHNICAL FORTE:

Programming Languages: T-SQL, Dynamic SQL, DAX, Python.

Reporting Tools: SSRS, Tableau Desktop, Power BI.

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

Database: SQL Server 2016, 2014, 2012, 2008/R2

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Participated in Daily Stand Up sessions to gather requirements and outline functional requirements.
• Build dashboard from various reports to display statistics about internal business functions.
• Pin visuals from many sources such as Q&A and workbook to dashboard to tell a story.
• Pull data from azure sql database to make reports for Power BI Workspace.
• Worked with azure synapse to process 30 Billon rows of data for Business intelligence analysis.
• Worked with Confidential power apps to insert video segments into a power bi report.
• Design interactive buttons in power bi report to adjust for viewing pleasure.
• Write complex dax queries to implement business logic.
• Use data from management one drive to make report for aesthetic purpose.

Confidential

BI Developer

Responsibilities:

• Participated in JRD sessions to gather requirements and outline functional requirements.
• Pull data from SharePoint online for reporting creating purposes.
• Contribute to a portfolio of projects on SharePoint done in Power BI.
• Directly connect to Azure DevOps database for data source in Power BI.
• Craft report as part of a bigger dashboard for internal use at navy federal.
• Worked in an agile environment, hold team meetings every 2 weeks as a sprint to discuss new goals and s.
• Wrote SQL Code to fine tune Direct Query Mechanism to apply filter to a data set.
• Frequently use charts such as combo, clustered column, water fall charts etc to tell a story about data.
• Utilize star schema to fine tune performance in power BI.
• Pull live data from Azure SQL Database using direct query.

Confidential, New York, NY

BI Developer

Responsibilities:

• Participated in JRD sessions to gather requirements and outline functional requirements.
• Daily meetings to discuss the goals and task of each day.
• Pull data from Azure Storage tables as data source to be used in Power BI Dashboards
• Design Power BI Dashboards according to user feedback.
• Data cleansing in Power Query such as replacing values of NaN, renaming columns, changing column data types.
• Write complex dax functions such as find out the week over week or month over month changes.
• Ensure data accuracies through the using of export function in azure and client’s excel formatted data.
• Create beautiful looking dashboards to present to the clients.
• Occasionally mentors non-technical upper management in functionalities that can be done in Power BI.

Confidential, Richmond, VA

BI Developer

Responsibilities:

• Participated in JRD sessions to gather requirements and outline functional requirements.
• Developed data marts by following star schema methodology using industry leading data modeling tools such as Erwin.
• Created data marts involving bottom-up approach and star schema.
• Wrote functions to provide custom functionalities in T-SQL.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Designed the technical specifications document for ETL processing of data into master data warehouse and strategized the integration test plan and implementation.
• Utilized different DAX functions and measures while implementing transformations in Power query.
• Published reports to Power BI service and pinned tiles from reports and Q&A to create dashboards.
• Maintained synchronization between published Power BI reports and data set utilizing Power BI gateway.
• Created roles-based security in Power BI data models using DAX filters.
• Created Power BI apps to share dashboards, reports and datasets with user groups.
• Developed visually-rich charts, maps, slicers, word cloud, funnel, gauges utilizing Power BI, delivering actionable insights.
• Utilized different type of filters and slicer in Power BI reports for enhanced search operations.
• Stored all source code in the Team Foundation Server (TFS) and updated development status in the TFS timely.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Assisted with business analysts to gather project specifications and coordinate with project assets.
• Designed critical staging procedures to load data marts and report databases with multiple features.
• Created a SQL Server job in SSMS for package executions.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using SSIS.
• Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Developed reports utilizing relational databases and OLAP cubes.
• Created drill through, drill down, linked, sub and parameterized reports for improved analysis.