We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Baltimore, MD

SUMMARY

  • An Experienced Business Intelligence Developer, Expertise in business Intelligence applications design, development, and Maintenance of Power BI, SSIS and MS SQL Server 2016/2014/2012/2008 R2/2008.
  • Excellent in creating Report, Dashboard, Dataset, Workspace, App, Incremental Refresh, Embed Report, Pin tiles, Power BI Gateways, Relationships and DAX.
  • Experienced in SSIS ETL Integrated data from heterogenous source to destinations performing transformation like lookup, Data Conversion, Merge Join and slowly changing dimensions. great analytical and problem - solving
  • Skills able to multi-task and adapt to shifting priorities, meet deadlines set in project planning and Produce quality deliverables.
  • Ability to adapt in a fast-paced environment in a high growth industry. Ability to have conversation with stakeholders and manage good relationship with them.

TECHNICAL SKILLS

  • Power BI
  • SSIS
  • SSRS
  • SQL
  • Azure
  • API
  • Power BI Desktop
  • Power BI Service
  • Mobile View Layout
  • Report
  • Dashboard
  • Dataset
  • Visuals
  • Tiles
  • Teradata
  • KPI
  • Bar Chart
  • Line Char
  • Map
  • Metrix
  • Gauge
  • Custom Visuals
  • Slicer
  • Filter
  • Drill Down
  • Drill Though
  • DAX
  • Calculated Column
  • Calculated Measure
  • Row Level Security
  • Time Intelligence
  • Filter
  • Relationship Functions
  • Power Query
  • Power Pivot
  • Power View
  • Power Map
  • Power Q&A
  • Direct Query
  • Import
  • Data Transformation
  • Cleansing
  • M Language
  • Modeling
  • Relationship
  • Incremental Refresh
  • Workspace
  • Embed Report
  • Power BI Gateway
  • Control Flow Task
  • Foreach loop
  • Execute Package Task
  • Script Task
  • CDC
  • File System Task
  • Data Flow Task
  • Data Conversion
  • Merge Join
  • Conditional Split
  • Derived Column
  • Multicast
  • Lookup
  • Deployment
  • SQL Server Agent Jobs
  • Star Schema
  • Snowflex schema
  • Normalization denormalization

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, Baltimore MD

Responsibilities:

  • Worked on all types of transformations that are available in Power BI query editor.
  • Worked with a team to deliver solutions that help drive the business forward.
  • Published Power BI reports in the required organizations and made Power BI Dashboards available in Web clients and Mobile apps.
  • Scheduled Automatic refresh and scheduling refresh in power BI service.
  • Develop and implement Data Engineering Solutions and ETL processes with Azure Data Factory and SSRS.
  • Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
  • Developed Complex calculated Measure, Calculated Column and Role level security using DAX.
  • Created reports using time intelligence calculations and functions.
  • Created tables, views, store procedure, user defined functions, triggers, CTE, indexes, constraints, tamp table and table variables using T-SQL.
  • Created Drill-down and Drill-through reports to provide interactive representation of data for Data Analysis, Forecasting and business decisions.
  • Implemented row level security on data and have good understanding of application security layer models in Power BI.
  • Developed and maintained SQL server database and Data Warehouse
  • Experience in designing SSIS package for integrating data using OLEDB connection from heterogenous sources (excel, SQL database, CSV, flat files etc.) by using multiple transformations provided by SSIS such as Data conversion, conditional split, merge, union all etc.
  • Used SSIS and Azure Data Factory to create jobs for extracting, cleaning, transforming, and loading data into Data Warehouses and used SQL Server Agent jobs and Azure Trigger run to automate jobs.
  • Maintained excellent attendance record, consistently arriving to work on time.
  • Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.

SQL/Power BI Developer

Confidential, Chicago, IL

Responsibilities:

  • Involved in maintaining data consistency and data integrity using various constraints like Unique, check, primary key, and default.
  • Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting).
  • Connected to multiple data sources like SQL Server, Oracle, Db2, Azure SQL DW and Flat Files and transformed data in Power Query using both graphical interface and M Formula Language.
  • Loaded data from SQL server to 3 different databases using SSRS.
  • Oversaw database management, including upgrade, backup, recovery, and migration.
  • Carried out day-day-day duties accurately and efficiently.
  • Modeled Data warehouse using Star and Snow flex schema, created complex Store procedure, Trigger, Functions, Views, Joins, CTE, Indexes and Constraints.
  • Involved in Migrating Objects from Teradata to Snowflake.
  • Demonstrated respect, friendliness, and willingness to help wherever needed.
  • Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.

SQL Server Developer

Confidential, DC

Responsibilities:

  • Developed, implemented, and optimized stored procedures and functions using T-SQL.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Developed and maintained SQL server database and Data Warehouse
  • Performed regular database backup.
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications.
  • Extracting, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSRS.
  • Strong Knowledge in dimensional star schema and snowflakes schema.

Hire Now