We provide IT Staff Augmentation Services!

Power Bi / Msbi Developer Resume

Dover, NH

SUMMARY

  • Over 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2015/2017 and 2018 in Production, QA and Development Environments.
  • Motivated and results - driven BI developer with a proven track record in Business Intelligence(BI), Data Warehouse(DWH) and Data Analytics related consulting projects. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
  • Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
  • Ability to work in all stages of System Development Life Cycle (SDLC).
  • Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Experience in upgrading SQL Server 2008/2008 R2/2012/2014 to SQL Server 2016 and data migration among versions.
  • Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
  • Very strong in Azure system configuration, database migrations, backup and recovery, geographic data replication, performance monitoring and tuning and disaster recovery configuration and execution.
  • Extensive professional experience in design, development, implementation and support of mission critical Business Intelligence (BI) applications.
  • Experience across entire Microsoft BI suite of products including SQL Server, SSIS,SSAS, SSRS and Power BI SDLC from prototyping to deployment
  • Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
  • Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and SSAS (analysis services).
  • Expert in Extracting, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access , Excel , CSV , flat files using connectors, tasks and transformations provided by SSIS .
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
  • Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
  • Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
  • Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
  • Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema .
  • Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Strong knowledge/hands-on experience with Azure SQL Data Warehouse, Azure SQL Databases, Blob Storage, App Service
  • Troubleshooting in Azure cloud environment
  • Integrated Custom Visuals based on business requirements using Power BI desktop .
  • Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
  • Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
  • Experience in working with Database setup, partitions and maintenance.
  • Worked on Jira and infra tickets daily which include updating SQL queries/reports.
  • Strong knowledge on claim management process, well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
  • Experience in managing large data sets on MS Excel 2016.
  • Provided application security support for SQL applications with ADO.NET
  • Skilled in design of logical and physical data modeling using Erwin data modeling tool.
  • Worked with Business Analysts, Web development team, and users on database solutions.
  • Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, SQL Azure, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2016/2014/2012/2008 ), MS Access, MS Excel, Crystal Reports, Business Objects 4.0,PostgreSQL,MySQL server,PowerBI

Database: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C,Python,Java,AWS

Web Technologies: HTML, DHTML, XML and CSS

Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

Confidential, Dover, NH

Power BI / MSBI Developer

Responsibilities:

  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
  • Developed Power BI model used for financial reporting of P & L and Headcount.
  • Designed and documented the entire Architecture of Power BI Poc.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot
  • Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
  • Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases .
  • Expert knowledge on Microsoft proprietary SCOPE language specification ( de-facto standard for all data related operations) for Microsoft Internal COSMOS platform for most of, much of usage streams such as Azure Compute, Azure Storage, Azure SQL & Azure DocDB .
  • Data engineering using Microsoft Internal Geneva platform for Module creation, source data extraction, scheduling, DQ frame work and source swaps for Storage, Compute and SQL platforms .
  • Data Factory for on-perm to Azure SQL and Azure SQL to Microsoft Cloud Internal Implementation COSMOS.
  • Created reports with power BI desktop and published reports directly to power BI report server.
  • Shared reports for the users to consume on the web and across mobile devices to meet a range of business needs
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Published reports and dashboards using Power BI.
  • Provided continued development and maintenance of bug fixes for the existing and new Power BI Reports
  • Integrated Custom Visuals based on business requirements using Power BI desktop .
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Developed complex calculated measures using Data Analysis Expression language (DAX).
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Involved in creating new stored procedures and optimizing existing queries and stored procedures.
  • Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files .
  • Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split .
  • Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task .
  • Involved in Migrating Objects from SQL Data warehouse to Snowflake .
  • Develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s SnowSQL .
  • Provided support for data load process from SQL Server to Snowflake Data warehouse .
  • Involved into creating security Entitlement table for Snowflake from Active Directory users and Okta users.
  • Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
  • Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
  • Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
  • Provided 24X7 production support to ensure timely and error free delivery of reports.
  • Developed custom calculated measures using DAX in Power BI to satisfy business needs.
  • Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
  • Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Took up the team lead responsibilities for 3 months.
  • Worked with the team to understand the problem in current Var calculation.
  • Created Reports using Charts, Gauges, Tables, matrix .
  • Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
  • Created Drill Down Reports, Drill Through Report by Region.

Environment : MS SQL Server 2008, MS-Access 2010/2007, TOAD, SSIS,SSRS, SSAS,PowerBI, SharePoint Server 2010, XML, MS Office 2013, MS Visio 2010, VB.Net, C#. Net, Visual Studio 2017, TFS, JIRA.

Confidential, Boston, MA

MSBI Developer / PowerBI

Responsibilities:

  • Interacting with Business users, gathering and analyzing requirements.
  • Designing and developing data warehouse and RedShift BI based solution
  • Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Automated Power Query refresh using power shell script and windows task scheduler.
  • Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
  • Installed and configured Enterprise gateway and Personal gateway in Power bi service.
  • Created Workspace and content packs for business users to view the developed reports.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
  • Weekly presentation to the business users about the reports and their changes as required.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures and SQL queries to pull data into power pivot model.
  • Created SSIS Data Migration using SQL server 2012
  • Worked on Agile/SCRUM methodology for iterative and incremental development for insurance department.
  • Worked on migrating data from SQL server 2000 to SQL server 2016 .
  • Migrated data from legacy system (text based files, Excel spreadsheets and access ) to SQL server Databases using SQL server integration services (SSIS) and stored procedures to overcome the transformation constraints.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Studied the data requirements and the impact analysis on the existing schema.
  • Responsible for design, develop and maintain SSIS packages.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Created and deployed SSIS packages and applied various data transformations and tasks like Sort, Union All, Conditional Split, Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations, Execute SQL task, Execute process task, script task etc.
  • Worked on Dimensional modeling of the data from Scratch (Extracted the scratch data from heterogeneous sources and doing the ETL for incremental data loads using SSIS and building them into Dimension and Fact tables using Star Schema).
  • Worked in maintaining SAP BPC, SAP DW, SAP HANA and developing ETL packages with SAP data sources.
  • Worked with Linked Servers and linking different databases like MS Access, Oracle, Teradata, SAP HANA
  • Created several SSIS schedule tasks and monitored those tasks regularly.
  • Worked on Performance Tuning and Optimization of SSIS packages.
  • Developed and assisted in migration of web application to Angular 4 Application.
  • Designed and developed tool for recruiters that helps in hiring process (Resource Management) using C#.NET, ASP. Net MVC and deployed into App Service in Azure .
  • Utilized Azure Sql Server for storing the data related to the recruitment and Wrote Efficient queries and stored procedures that saved the manual efforts of cleaning the data and efficient data handling and sanitized data.
  • Performed validations on Web Forms using .NET Validation Controls and Client Side Validation using Angular4
  • Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
  • Created Joins, tables, Indexes, DML, DDL, TCL, DCL statements and sub quarries using SQL.
  • Improved Performance of the database by Performance tuning and Debugging the SQL code
  • Design, coding, testing, debugging and documentation of applications.
  • Part of the team implementing rest APIS in Python using micro-framework like Flask with SQLALCHEMY in the backend for management of data center resources on which OpenStack would be deployed.
  • Understanding Python files in OpenStack environment and make necessary changes if needed.
  • Working with QA team for testing SQL codes.

Environment: MS-SQL Server 2018, MS-Access 2010/2007, TOAD, SSIS,PowerBI, SAS, SharePoint Server 2010, XML, MS Office 2013, MS Visio 2010, VB.Net, C#. Net, Visual Studio 2017, TFS, JIRA, Python.

Confidential, Austin TX

Power BI Developer / SQL Developer

Responsibilities:

  • Identifying the bottleneck for the process which are taking long time.
  • Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
  • Worked on Data Consolidation/Migration Project building.
  • Performed successful installation and configuration of SQL Server 2017.
  • Created Temporary tables with Temporary variables using Transact SQL (T-SQL).
  • Created Dim and Fact tables and multidimensional Cubes.
  • Created Reports, Dashboards using SSRS, Excel.
  • Involved in performance monitoring, tuning and capacity planning.
  • Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
  • Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
  • Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
  • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
  • Optimized report performance with caches and snapshots.
  • Translated business requirements into BI application designs and solutions.
  • Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Maintaining custom vacuum strategies at table and db level.
  • Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
  • Developed highly optimized stored procedures, functions, and database views to implement the business logics and created clustered and non-clustered indexes.
  • Worked on analysis of the data and develop plan based on the ETL specifications.
  • Designed and Implemented plan for the moving data to various destinations.
  • Created mappings and workflows as per the business requirement.
  • Fine-tuned queries to make the reports run faster, worked on query run time analytics.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Created and maintained data flow diagrams for existing and future ETL processes.
  • Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

Environment: SQL Server 2016/2017, Visual studio 2015, SQL Server Integration Services (SSIS), Analysis Services (SSAS),POWER BI, Microsoft Visual studio 2013, Excel, VBA, C#.

Hire Now