We provide IT Staff Augmentation Services!

Bi Developer Resume

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.

Hire Now