We provide IT Staff Augmentation Services!

Ms Sql Server Developer/ssis/ssrs/power Bi Resume

3.00/5 (Submit Your Rating)

Eagan, MN

Hire Now

PROFESSIONAL SUMMARY:

  • Over 5 years of Database Design and Development experience on Power BI and SQL server 2016/2014/2012 .
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Hands on experience with Power BI Services, Power BI Desktop and Power BI Mobile App
  • Excellent T - SQL Development Skills to write Complex Queries involving Multiple Tables, great ability to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views
  • Good Knowledge of various source systems- Oracle, Excel and other database systems.
  • Expertise in Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data from various data sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
  • Proficient experience in deploying and configuring packages, Error handling, check points and troubleshooting Reports using SSRS.
  • Proficient Knowledge with source control (GIT), Dev Ops, Azure Cloud, Agile Concepts

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016/2014/2012 , Oracle 8i/9i, MS Access.

Database Tools: SSIS, SSAS, SSRS, Management Studio, Power BI

Programming Languages: SQL, TSQL

Applications: Microsoft Office

Operating Systems: Windows 10/7/XP

PROFESSIONAL EXPERIENCE:

Confidential, Eagan / MN

MS SQL Server Developer/SSIS/SSRS/Power BI

Responsibilities:

  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
  • Created Calculated Columns and Measures in Power BI and Excel on the requirement using DAX queries.
  • Experience on publishing Power BI reports on dashboards in Power BI server.
  • Designed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, flat file, CSV,Text file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
  • Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
  • Involved in development, enhancement, testing and performance tuning of the application.
  • Involved in developing database objects such as procedures, triggers, constraints, indexes and views.

Environment: SQL Server 2012, Microsoft SQL, MS SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), T-SQL, Power BI, MS Access, MS Excel, Windows 7

Confidential, ATLANTA, GA

SQL/Power BI Developer

Responsibilities:

  • Connect to data sources, importing data and transforming data for Business Intelligence.
  • Develop visual reports, dashboards and KPI scorecards using Power BI desktop.
  • Implement row/report level security on data and worked on application security layer models.
  • Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
  • Strong Experience in Analysis Services components including Power Query, DAX
  • Generated and consolidated monthly reports to drive forecast production plan with Power BI.
  • Scheduled reports using Power Bi to generate daily, weekly, monthly and quarterly reports.
  • Worked with T-SQL to create tables, views, stored procedures, triggers, Indexes and user defined functions for complex business logic.
  • Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.

Environment: Power BI, MS SQL Server 2008, MS SQL Server 2005 Window XP, MS Word 2010, Visual Studio 2008, MS Excel 2010.

Confidential, Houston, TX

Power BI Developer

Responsibilities:

  • Worked in creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
  • Worked with different types of connection managers like file connection manager such as flat file, Excel, Ole Db connection manager.
  • Designed and developed SSIS ETL process In SSIS (2008/2014).
  • Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
  • Configuring Power BI Gateway for SSAS Live connection and DirectQuery.
  • Used Power BI Power Pivot to develop data analysis prototype, used Power View and Power Map to visualize reports.
  • Implemented Row-level security (RLS) on Power BI reports.

Environment: SQL Server 2012/2014, SSRS 2014/2008, SSIS - 2008,2014, SSAS, power BI, T-SQL, Excel, Access, Windows 2000/XP

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship