Power BI Developer Resume Richmond, VA - Hire IT People

PROFILE SUMMARY:

Experienced IT professional with around 4 years of experience in developing custom SQL queries and performing testing and data analysis in an SQL Server environment for various companies.
Expertise in creating innovative reporting solutions integrating and leveraging SQL Server BI Stack (SSIS, SSAS, Power BI) and/or Tableau.
Skilled in designing database objects such as Stored procedures, Triggers, user defined functions and views.
Performed complex joins, subqueries, and set operators on very large databases.
Proven capabilities in implementing innovative ideas, projects and business solutions in the organizations worked with.
Strong written and verbal communication to interact effectively with both technical and non - technical users at all levels of the organization.

TECHNICAL FORTE:

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

SDLC: Agile, Scrum, Waterfall, and Spiral

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: Tableau Desktop, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Power BI Developer

Tools & Environment: SQL Server 2016, SSIS, SSAS, SSMS, SSDT, T-SQL, DAX, Power BI

Responsibilities:

Gathered business requirements from JRD sessions with business analysts, project managers and developers.
Designed complex stored procedures for performing data profiling and auditing in the pre-staging database.
Designed and implemented complex SSIS package to migrate data from multiple data sources .
Performed complex Joins and subqueries for querying purposes .
Created Stored procedure, Views, triggers and user defined functions to support application.
Implemented multiple grouping into several reports using visibility and toggle options.
Actively supported Business users for change requests and provide support to team members.
Produced lots of story telling data visualization charts for management team.
Used App source for custom visualizations such as Chord Charts.
Created many apps, content packs, and dashboards in power BI service for reporting purposes.
Utilized Data alerts and subscriptions to keep management team updated with information

Confidential, Dallas, TX

Power BI Developer

Tools & Environment: SQL Server 2016, SSIS, SSAS, SSMS, SSDT, T-SQL, Power BI, DAX

Responsibilities:

Gathered functional requirements from users and developers.
Designed and maintained complex database objects such as stored procedures, user defined functions, triggers, and views
Additional projects included automation of a manual process as the start of a data warehouse project.
Analyses data daily in SSAS, then produce visualization charts of those data in Power BI
Extensively used Power BI Desktop and Power BI service to inform management team with data subscriptions.
Performed front line code reviews for other development teams.
Designed and implemented complex SSIS package to migrate data from multiple data sources .