We provide IT Staff Augmentation Services!

Power Bi Developer /bi Developer Resume

SUMMARY

  • To obtain employment in a diverse and innovative company that utilizes my technical expertise and interpersonal skills and enables me to constantly contribute to the success of the company and at the same time, provides a platform to hone my skills as a MS SQL Admin and BI DEVELOPER.
  • Expertise in installation on both stand - alone and cluster mood, configuration, patching, performance tuning and maintenance with outstanding skill troubleshooting capabilities production servers and virtual machine
  • Extensive experience and skilled troubleshooter continually focused on identifying, isolating and resolving technical issues.
  • Developed and maintain SSIS packages using ETL tools into data warehouse from various sources expertise in enhancing and deploying the SSIS Packages from development server to production server
  • Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
  • Extensive hand-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
  • Generated ad-hoc reports in Excel power pivot and shared them using power BI to decision maker for strategic planning
  • Experience in Reporting services, power BI (Dash Board Reports), and SSRS using MS SQL server
  • Utilized Power BI ( Power View) to create various analytical dashboards that depicts critical KPIs billing hours and case proceeding along with slicers and dicers enabling end-user to make filters
  • Analytical, highly adaptable professional with extensive experience developing, deploying and evaluating systems aimed at improving quality and efficiency.
  • Extensive experience coding, testing and supporting database solutions in SQL server environments.
  • Successfully ensure security and integrity of databases by administering, maintaining, developing and recommending appropriate policies and procedures.
  • Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.
  • Positive attitude and willing to take new responsibilities
  • Maintained individual service accounts for SQL server services on cluster with different security groups to raise security mark.
  • Extensive experience in software installation and upgrades, resolving errors and failures, auditing activities, and resource utilization.
  • Experience in deploying SQL Databases in cloud Microsoft Azure using ADF, data lake, deploying and scheduling pipeline
  • Migrated SQL server databases from SQL server 2005/2008/2012 version to 2012/ 2014/2016 SQL server version on different environments enabling use of new SQL server features.
  • Recognized for expert assistance to users through extensive review of help desk software operations and monitoring of phone and email inquiries.
  • Integrated custom visuals based on business requirement using power BI desktop such as Aster plot, Radar plot, Sankey plot and Chord plot.
  • Design and implementation of comprehensive backup and disaster recovery strategies.
  • Significantly improve performance by identifying and monitoring long running queries, blocking, locking, missing and unused indexes, I/O bottlenecks, and statistics, fragmentation, and wait stats.
  • Implemented power BI gateway different source to matching, analysis criteria and further modeling for power pivot and power View
  • Perfected import of data from flat file and Excel data source to SQL server databases through graphical user interface and DTS, SSIS packages in SQL server database management studio.
  • Strong Knowledge and skill on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,. In addition to that I had also great experience on analysis services (SSAS), reporting services (SSRS).

TECHNICAL SKILLS

  • Windows Server 2012R2, 2008, 2003$2, 2003 Windows XP Professional, Windows 7 Professional, VMware ESX 3.x
  • SQL Server RDMS
  • SQL Server Management Studio, Database Upgrade Advisor, Query Analyzer, SQL
  • Profiler and Database Tuning Advisor, SQLCMD, Reporting Services Configuration
  • Manager, BIDS, SQL Server Configuration Manager
  • SSIS,BCP, DTS. Power BI. SSIS, SSAS and SSRS
  • SQL, T-SQL, Store Procedures, Trigger
  • ER-Win, MS Visio, Red gate

PROFESSIONAL EXPERIENCE

Confidential

Power BI developer /BI DEVELOPER

Responsibilities:

  • Designed, implemented and Supported Business intelligence systems for management group
  • Creating SSIS packages providing specific functionality like data profiling and data cleansing for clean ETL process and populating Data Warehouse and Data-Marts
  • Imported data from SQL Server DB, Azure SQL DB and other resources to Power BI to generate reports.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Explore data in a Variety of ways and across multiple visualizations using Power BI
  • Created DAX Queries to generated computed columns in Power BI.
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Generated ad-hoc reports in Excel power pivot and shared them using power BI to decision maker for strategic planning
  • Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Created reports using time intelligence calculations and functions.
  • Executed dashboard setups and data manipulation using DAX
  • Utilized power BI (power View) to create various analytical dashboard that depicts critical KPIS such as legal case matter, billing hours and case proceeding along with slicers and dicers enabling end-user to make filters
  • Implemented power BI gateway different source to matching analytical criteria and further modeling for power pivot and power view
  • Utilized power query in Power BI to pivot and un-pivot the data model for data cleansing and data messaging
  • Directed concurrent technology projects, including identifying and resolving database performance issues, capacity planning, replications and other distributed data issues in line with aggressive timeline, quality and best practices requirements
  • Team Collaboration: Liaised with software development teams to effectively assess the impact of database changes on system performance
  • Project Management: Installed, configured and managed SQL server 2012, 2014 AND 2016 in development, test and production environments, patching SQL server packs and hotfixes with recent update, migrating databases and creating relational databases and database objects
  • Maintenance: Create server agent jobs and maintenance plans while successfully problem solving failed jobs and monitoring server database alerts.
  • Disaster Recovery & High Availability: Manage and test SQL server backups and create and manage different SQL server high availability solutions, such as Replication, Log Shipping, Mirroring, Always On and Clustering.
  • Performance Tuning: Monitor and improve SQL server performance by suing different tools, such as DMV’s DMF’s, SQL server Profiler, Query Plan, and Database Tuning Advisor.

Environment: MS SQL Server 2016/2014/2012 , SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential

POWER BI / BI developer

Responsibilities:

  • Data Migration: Captained migration of SQL Server databases from SQL server 2005/2008 to SQL server 2012.
  • Independently configured, installed and implemented clustered and standalone SQL server 2014/2008R2 production environments, SSIS and SSRS. Expertly applied service packs and hotfixes.
  • Implementing and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL server using SSIS, SSAS, SSRS
  • Experience in providing logging, error handling by using event handler, and custom logging for SSIS package
  • Explored data in variety of ways and across multiple visualization using Power BI strategic expertise in design of experiments data collection, analysis and visualization
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Developed Power BI reports and dashboards for multiple data sources using data blending
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Maintained log information in Text file to tracking error and recording package execution status, created configurations, checkpoints and Breakpoints.
  • AZURE SQl Database - deploy SQL Server DB to Azure SQL data base using ADF, create, deploy and scheduling Pipeline in Azure SQL DATABASE
  • Integrity: Diagnosed and problem-solved issues across all systems to ensure database health and integrity.
  • Developed and implemented SSRS reports with multi-parameter, chart, sub-reports, and interactive capability.
  • Designed, created and implemented complex ETL strategies Using SSIS packages that extracted the data from different heterogeneous sources like flat Files, Excel Files and dumped it into a centralized data mart
  • Developed and modified complex stored procedures in supporting ETL processes in data warehousing environment.
  • Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse.
  • Data Capacity: Monitored and managed database capacity growth and refreshed data from production to lower environment.

Environment: MS SQL Server 2014/ 2012/2008/2005 , SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2012, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential

POWER BI/BI DEVELOPER

Responsibilities:

  • Efficiency & Quality Improvements: Reviewed and revised execution plans, tuned long and ad hoc queries and created missing indexes for optimal performance
  • Created and designed SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
  • Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse.
  • Understood the existing ETL and relational database framework and scheduled package using SQL SERVER AGENT JOBS
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • 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.
  • Disaster Recovery/High Availability: Project-managed solutions, such as mirroring, log shipping, replication and clustering.
  • Systems Management: Brainstormed, implemented and tested full disaster recovery at all levels of SQL server while performing database backups and restoring databases in point in time recovery.

Environment: MS SQL Server 2012/2008/2005 , SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2012, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential

junior SQL Developer/ SQL Server DBA

Responsibilities:

  • Recognized for superior work in the installation and configuration of SQL server 2000 and 2005 on Windows server 2000 and 2003 multi instances and service packs. Managed database backups to verify integrity.
  • Created stored procedures, views, triggers and constrains to implement the database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
  • Troubleshooting: Problem-solved SQL job failures and implemented database maintenance plan.
  • Server Support: Ensured all instances of server were up and running perfectly while monitoring development and deployment of software applications.
  • Performance: Helmed the performance tuning, query tuning and index tuning using DBCC Command, Wizards and SQL Profiler.

Hire Now