We provide IT Staff Augmentation Services!

Etl/power Bi Developer Resume

SUMMARY

  • Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings.
  • Broad experience in different phases of Software Development Life Cycle (SDLC).
  • Strong experience with demonstrated success in the Database Design, Development and Implementation using MS SQL Server 2016/2012/2008.
  • Extensive experience in T - SQL for developing Stored Procedures, Triggers, Indexes, View, User Defined Functions, CTE, Temp Tables, Table Variables and SQL Joins.
  • Experience in relational database and Data Warehousing Design concepts.
  • Proficient in Data Modeling using ER Model and Multidimensional Model, Good knowledge in Star Schema and Snowflake Schema.
  • Handful experience in design & creating SSIS packages for extracting, transforming & loading (ETL) data from Excel, Flat Files & other sources to different databases & data warehouses.
  • Experience in providing Logging and Error handling by using Event handler, & Custom Logging
  • Expertise in creating different reports like Drill-Down, Drill-Through, Parameterized, and Tabular reports based on client requirement using SSRS.
  • Experience in designing, developing, and implementing Power BI solutions.
  • Experience demonstrating Power BI building blocks including visualizations, dashboards, reports, apps, and datasets.
  • Experience with interactive/dynamic report and dashboard development and leveraging all visualization and functionality options available in Power BI using Visual Insight Dashboard and Reporting Service Document.

TECHNICAL SKILLS

Databases: MS-SQL Server 2008/2012/2016/2017 , MySQL, MS-Access

BI Tools: SSIS, SSRS, SSAS, Power BI

Project Management Tools: Trello

Ticketing System: Zendesk

Version Control System: GitHub, TFS, Azure DevOps

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux, Unix

Communication: Slack, Outlook, WebEx

PROFESSIONAL EXPERIENCE

ETL/Power BI Developer

Confidential

Responsibilities:

  • Created Dimensional Data Model based on business specifications
  • Involved in gathering business requirements & prepared technical specifications documents
  • Created stored procedures, triggers, views, and functions and wrote complex queries using T-SQL to address various reporting operations and application development
  • Created SSIS packages for data extraction from heterogeneous Sources
  • Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Lookup and Derived Columns with Multiple Data Flow tasks.
  • Scheduled Daily, Weekly & Monthly SSIS package execution using SQL Server Agent
  • Utilized event handling effectively to generate audits and logs for the SSIS packages.
  • Migrated SSIS packages from SQL Server 2012 to SQL Server 2016.
  • Generated parameterized reports, sub reports, tabular reports using SSRS.
  • Actively supported business users for changes in SSRS report & Data flows processes
  • Worked extensively on Power BI Services in creating Analytical and operational reports.
  • Configured Power BI Workspace in Power BI Service
  • Published Power BI Reports to Power BI Workspace
  • Created SSAS Tabular and multidimensional cubes for data analysis
  • Created Documents and Dashboards in Design mode and Executed in Web.
  • Worked on developing complex reports which involved advanced metrics, filters, custom groups, and Consolidations using Power BI.

SQL/ETL Developer

Confidential

Responsibilities:

  • Designed & developed T-SQL procedures, query performance tuning and SSIS packages.
  • Analyzed the source data for data mapping to staging tables, data warehouse & data marts.
  • Created functions to provide custom functionality as per the requirements.
  • Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
  • Created indexed views and appropriate indexes to reduce complex queries runtime.
  • Performed data cleansing & validation to support report requirements.
  • Used SSIS to implement slowly changing dimensions to maintain historical data
  • Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing & data validation during staging process
  • Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent

Hire Now