Power BI Developer Resume St. Louis, MO - Hire IT People

OBJECTIVE

Seeking a position as a BI Developer or Data Engineer that plays a key role on the sales team by building and maintaining sales reporting, forecasting, trade management and opportunity analysis to guide organization success.

AREAS OF EXPERTISE

Experience writing Power Query, DAX, MDX for complex data projects
Experience authoring, diagnosing, and altering SQL Server objects and T - SQL queries
Experience creating and maintaining reporting assets in Power BI
Knowledge of general data modeling concepts
Understanding of process engineering concepts and measurements
Excellent written and verbal communication skills
Ability to work effectively with remote teammates and users
Designing beautifully organized analytics dashboards for upper management
Experience using Agile/SCRUM techniques
Understanding of Power BI Premium

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, St. Louis, MO

Responsibilities:

Utilize Power BI to deliver high quality BI solutions in a mature enterprise data warehouse environment
Assist in the collection of user requirements and creation of functional specifications
Translate functional specifications into technical specifications, including tasks, timelines, and time estimates
Working from technical specifications
Create and modify existing reporting assets
Analyze relational and multidimensional data sets
Design and enhance relational and dimensional data models
Build data visualizations including dashboards and reports
Document data profiling and quality assurance results, data dictionaries and analytical findings
Comply with team development, IT, and company processes and policies
Assist and train users in the use of business reporting assets
Work with teammates to plan mid - and long-term product and technical strategies
Assist with crafting the development lifecycle process to fit tools and needs
Communicate clearly with business users and IT professionals about enhancements that are being made to the existing system
Performed administrative functions to backup and refresh reports in Power BI Service
Created data gateways for desktop to cloud and cloud to cloud connections
Created row level security to provide security to for sensitive company data
Created an app workspace for the development and production of an app from a report
Published Power BI apps

Azure Data Base Administrator

Confidential, Dallas, TX

Responsibilities:

Analyzed the data to implement incremental load using the MERGE statement and overseen the migration of large amounts of data from OLTP to OLAP using SSIS ETL tool
Created complex SSIS packages with error handling capabilities using various data flow task transformations (conditional split, data conversion, look up, merge), tasks (execute SQL, data flow, script, send mail tasks) and containers (sequence container, for loop, for each loop container) etc.
Performed SQL query performance tuning by creating indexes, setting transaction levels and changing query structures with CASE statements, CTE's and VIEW's. Successfully reducing query duration by 60%-300%
Built SSIS ETL process to migrate data from multiple data sources (SQL Server, Oracle, Excel, Flat Files, SharePoint, XML etc.) to destination database server data warehouse.
Developed advanced SQL queries and Stored Procs to generate data reports by digging into database details to ensure appropriate data filters are applied based on the business requirements
Collaborated with the business and technical staff to develop requirements document and ETL design specifications
Built data warehouse with Star and Snowflake Schemas to generate OLAP data cubes to analyze via SSAS with data modelling best practices
Built data warehouse and storage for streaming media
Power BI Service Administrator for workspace and refresh
Created Power BI data gateway connections
Created Power BI row level security