Ms Power Bi Developer Resume
PROFESSIONAL SUMMARY:
- 8+ years of Professional experience with Microsoft SQL Server 2005/2008 R 2/2012/2014/2016, SSIS, Power Pivot, SSRS and Power BI.
- Extensive experience in BI Solutions (ETL & Reporting) using SSIS, Power pivot, SSRS, Power BI, and T - SQL Programming using DDL, DML, and DCL commands for various business applications.
- Strong SQL Server Developer Skills including writing Transact-SQL Queries, Stored procedures, User defined functions, Views, Triggers, Constraints (Primary key, Foreign Key, Unique, Default), Indexes, CTEs and Good understanding of Normalization /Denormalization.
- Importing large amount of data using the bcp utility, openrowset and bulk insert. Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
- Experience in SQL Optimizing by using SQL Profiler, Database Tuning Advisor, and Query Execution Plans.
- Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views
- Worked with linked SQL Server instances for the purpose of load balancing. Experience in scheduling jobs to automate different database related activities.
- Knowledge of creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
- Expertise includes FACT & Dimension Tables.
- Working in Power BI desktop and Services and writing DAX for creating measures.
- Experience in creating Azure Databricks notebooks using Spark SQL and creating and managing jobs to schedule run of the notebooks.
- Has very good experience in complete ETL cycle including data analysis, database design, data mapping, conversion, and data load.
- Experience in creating jobs, alerts, and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
- Well-versed in usage of SSIS Control Flow items (Execute package/SQL tasks, Script task, For each loop, Sequence containers etc.) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge Join, Pivot etc.).
- Expert in involving variety of features using complex expressions to Calculate, Group, Filter data in the report using SQL SSRS
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.
- Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports using SQL Server Reporting Services (SSRS).
- Migration of existing reports from various existing platforms to SSRS report.
- Over 1-year experience using Power BI to create dashboards and reports using DAX queries and calculated columns.
- Designed Power BI dashboard utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- A self -motivated Individual with exemplary analytical and problem-solving skills.
- Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
PROFESSIONAL EXPERIENCE:
Confidential
MS Power BI Developer
Responsibilities:
- Work closely with management and stake holders to create and evaluate business requirements.
- Building Azure Databricks notebook using Spark SQL, to compute the required data for the Power BI Source file.
- Creating and managing jobs in Azure Databricks clusters.
- Creating tables to convert the transactional data to the source fact tables for Power BI visualization using SQL joins, pivot and group by.
- Using the base dimension tables, created the dim tables according to the dashboard specific requirements.
- Worked on the star and snow flake schema containing multiple fact and dimension tables.
- Build Power BI visuals like line and clustered column charts, line charts, donut charts, cards and table visuals using self-created source tables.
- Writing DAX for creating measures in Power BI.
- Publishing pbix file on Power BI services and scheduling and managing the scheduled refreshes for the dashboards.
- Overtook existing Power BI dashboards and Azure Databricks notebook from other team member and took KT and documented the entire transition process.
- Worked closing with the UI/UX team to integrate the Power BI visuals to an internal dashboard.
- Involved in weekly meetings with the stake holders to closely understand the requirements/expectations.
Environment: SQL Server 2016, Azure Databricks, Power BI.
Confidential, PA
MS SQL SSIS/SSRS/Power BI Developer
Responsibilities:
- Work closely with management and end-users to create and evaluate business requirements.
- Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
- Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks
- Experience in Error handling and debugging coding issues and troubleshoot production problems.
- Source Analyser, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor
- Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
- Experience in writing custom code expressions in SSRS.
- Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
- Created Report Models for Business Users to create their own reports.
- Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Create and maintain data model/architecture standards, including master data management (MDM).
- Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs did not interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
- Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
- Monitoring the scheduled SSRS. Re-running the reports in case of any failures or data mismatches.
- Involved in deploying the changes to QA, Staging and Prod environments.
- Managed offshore team in Report migration project.
- Followed agile methodology and coordinated daily scrum meetings.
- Involved in Product Releases and support calls.
Environment: SQL Server 2016, SQL Server Business Intelligence Studio SSIS, SSRS, Visual Studio, Power BI.
Confidential
Database Developer
Responsibilities:
- Requirement Analysis, Design and Development of ETL and reports.
- Code reviews and Issue management.
- T-SQL Development - Mainly worked on Procedures, functions, triggers, constraints, tables and Index creation and exception handling in SQL Server.
- Status Reporting as well as resolve business ad-hoc queries.
- Responsibilities include Interaction with client for Requirement Analysis, Design and Development
- Performed the role of DBA for all SQL Server database environments, Creating the logins and SQL server agent jobs.
- Worked to understand the requirement and implemented the same.
- Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
- Developed Power BI reports and dashboards from multiple data sources.
Environment: SQL Server 2016, MySQL, SQL Server Business Intelligence Studio SSIS, SSRS, Visual Studio, GIT, Power BI.
Confidential
SQL /MSBI Developer
Responsibilities:
- Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Worked on SQL jobs for daily management reporting.
- Involved in developing database objects such as views, constraints, indexes and procedures for the development of SSRS reports.
- Deployment of SSRS reports on the Report manager.
- Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
- Worked on underlying views on Oracle and SQL Server for the SSRS reports.
- Regularly monitoring the production logs to ensure the data flow is going fine.
- Working on job fails on production.
- Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL Developer.
- User Access Management - Granting/ revoking a user access to the database on both the pre-production and production environments.
- Discussions with customers on service call issues, if required.
Environment: SQL Server 2014\2016, Oracle PL/SQL, SQL Server Business Intelligence Studio SSIS, SSRS, Visual Studio, Power BI.
Confidential
Application Development Analyst
Responsibilities:
- T-SQL Development - Mainly worked on Procedures, functions, triggers, constraints, tables and Index creation and exception handling in SQL Server.
- Created jobs to import/ export data, Involved inDatabase Backup andrecovery.
- Created and maintained various logins and managed security based on the required access.
- Created Database on Microsoft SQL Server and Deployed Application on IIS
- Handling the change requests on existing Applications.
- Work with tools incorporated with DFM: File handler, Document integrator, Feeder, Submission tool.
- Database issue and problem management and enhancement of the web application.
- Gathering requirements from end users, designing, developing, testing, deployment and ddocumentation as required.
- Preparing SQL scripts for database related changes and also Backup\Restore of database from production to lower environment.
- Importing/exporting data using Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008/2012)
- Importing data using Talend job and creating dashboard for reporting on Power BI.
- Providing Knowledge Transfer to the team and new joiners on various functionalities of different applications.
- Preparing Technical Documentation, Application Designing.
- Involved in developing database objects such as procedures, triggers, constraints, indexes and views using SQL Server 2014/2012/2008.
- Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
- Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
- Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
- Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
- Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
- Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients.
- Involved in Denormalization of existing tables for faster query retrieval.
- Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.
Environment: SQL Server 2014/2012/2008/2005, SSRS, SSIS, SSAS, C# Scripting, BCP, SQL Server Management Studio, T-SQL, XML, Oracle 9i, Toad, MS Excel, Visual Team Foundation Server, Crystal Reports, visual studio 2005/2008/ 2012, TFS 2008/2010, Power BI, QlikView.