SUMMARY

• An experienced and results Power BI Developer and Solution Associate with 5+ years of progressively responsible experience in Developed Power BI model, Dashboards, API, Scorecards DAX functions in Power BI, Excel BI add - in on power query, power pivot, Power view and power Map.
• In Xvelocity in memory analysis engine. I could working with automate deliver and schedule Power BI reports, data model, calculations and quality of analytical output.
• In addition to those I have strong skills to connect to variety of data source, proficiently using the queried data in Power BI, in development of highly visual reports, dashboards and data narratives.
• In Power BI service, Data Analysis, Design, Implementation, Administration and Support of Business Intelligence.
• Microsoft Certified Solutions Associate (MCSA) certified IT professional in implementing a Data Warehouse with Microsoft SQL Server 2012/2014 and Microsoft SQL Server 2012/2014 Certification.
• Experience in developing power BI Report, Dashboards, API and Scorecards.
• Design, implement, and support platform providing ad-hoc access to large database.
• Strong working experience with data like reporting layers.
• Collaborate with team to integrate new data source.
• Ability to quickly gather requirements, learn subject matter and extract and transform data.
• Working knowledge on how to automate, deliver and schedule PowerBI reports
• Ability to test data model, calculations, and quality of analytical output.
• Expertise in use and application of DAX and constructing advanced calculations
• Strong ability to connect to variety of data sources, proficiently using the queried data in PowerBI
• Proficient in the development of highly visual reports, dashboards, and data narratives
• Strong knowledge of source of tools like SQL, Excel, Power BI Desktop file, Azure and Text/CSV file.
• Demonstrable experience in visualization best practices, data optimization and model efficiency
• Ability to effectively deliver and present work to the appropriate audience.
• Expertise doing Excel BI add -in on power query, power pivot, Power view, power Map and Power BI templates.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) .
• Skilled in data analysis, system application analysis, data Architecture, and development, Testing and deployment of Business Intelligence using data warehousing and database business system in the areas of different companies I used to work with.
• Good knowledge of Business Intelligence, OLAP, Dimensional modeling, Star and snowflake schema extraction, transformation and loading (ETL) process.
• Very good understanding of Network managements, the TCP/IP model including application layer protocols and Storage management.
• An excellent team player and easy to work with. Flexible to work in different working schedule. A dedicated employee who is always eager to learn more.
• Immediately available to conduct interview requirement and have a flexible negotiable salary demand. If I am given the opportunity to be part of your team, I will prove that I bring with me exceptional input and will be an asset to the company.
• Can easily ascertain that I am a hardworking, honest, reliable and consistent person.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, SQL reporting, SSIS, and Idera.

Programming: SQL, TSQL, Power BI, SQL Server Data tools and BASIC

Operating Systems: Windows XP/Vista/ Windows7/8/and 10, Linux.

Network Topologies: TCP/IP

Case Tools: MS Office 2000/XP/ 2003/2007/2010 , MS Outlook 2000/ 2003/2007/2010 , Visio, Clear Quest.

Development skills: T-SQL, MS SQL, SSIS/SSRS and Power BI.

ETL Tools: SSIS(SQL Server Integration Services), SQL Reporting Services (SSRS), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Databases: SQL Profiler, SQL Query Analyzer, Index Tuning, SSRS, SSIS, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, IP Mon and Lite Speed.

PROFESSIONAL EXPERIENCE

Confidential

Power Business Intelligence Developer

Responsibilities:

• 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.
• Working knowledge on how to automate, deliver and schedule PowerBI reports
• Developed power BI Report, Dashboards, API and Scorecards.
• Design, implement, and support platform providing ad-hoc access to large database.
• Collaborate with team to integrate new data source
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Extract Transform Load (ETL) development Using SQL server 2012/14, SQL 2012/14 and 16 Integration Services ( SSIS )

Confidential

SQL Server DBA/MS Power BI Developer

Responsibilities:

• SQL Server Database Administrator.
• Installed and configuration SQL Serve 2008R2,2012, and 2014 and 2016 on windows 2003/2008 and 2010 environment.
• Implemented High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping.
• Working with SQL Database Security.
• Involved in Monitoring and troubleshooting replication issues
• Configured Server Memory for maximum Performance and effective utilization.
• Configured Temp DB for to increase the performance of SQL Server.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Worked and generated reports using SQL Server 2008 R2,2012 and 2014 Reporting Services (SSRS), (SSIS), and (SSAS)
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tested data model, calculations, DAX and quality of analytical output
• Developed of highly visual reports, dashboards, and data narratives
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Extensively worked on 24X7 Production support and involved in on call rotation.
• Extensively worked on Documentation of run books and release documents for production deployments and other processes.