We provide IT Staff Augmentation Services!

Msbi Developer Resume

VA

SUMMARY

  • 7+ years of experience in End - to-End Implementation of Database Systems, data warehouses, integration services, reports, and database development (T-SQL) using SQL Server stack SSIS, SSRS, SSAS Power Bi. Hands-on experience in the analysis, development and implementation of strategic BI systems and reporting frameworks.
  • Provided design support for the development of business intelligence solutions. Management of large teams of varying skill sets.
  • Good Experience on creating dashboards, volume reports, operating summaries, and presentations and graphs. SSRS Integration to Power BI.
  • Experience in Software Development Life Cycle (SDLC) Methodologies such as Waterfall, AGILE, SCRUM, RUP (Rational Unified Process), Extreme Programming, Iterative Development, System Analysis & Design concepts.
  • Working knowledge of Data warehousing, Data marts and OLAP technologies including Star Schemas, Snowflakes using Erwin Tool and Microsoft Visio ETL processes, dimension modeling and reporting tools.
  • Expertise in RDBMS Database Design, Installation, Configuration, Performance Tuning, Optimization, Backup-Recovery and Maintenance activities.
  • Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
  • Developed business logic usingC#, used the developed data layer module extensively for database related transactions.
  • Expert on creating multiple type of reports using tools like Power BI, SSRS, Tableau, Excel (Pivot Table, Matrix, Power Map) and SAP Business Object.
  • Experience in creating Power BI Desktop reports in Report view to Power BI service.
  • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Proficient in Data warehousing and Business Intelligence technologies (WSBI).

TECHNICAL SKILLS

Operating Systems: Windows Server, Unix, Linux

Languages: T-SQL, PL/SQL, ASP.NET, .Net Framework, C#, XML

Data Warehouse: SSIS, SSRS, SSAS, BIDS (Business Intelligence Development Studio), Data tools, DTS, Informatica Cloud, TFS, Erwin, Business Process Automation, Data Quality Service, MDM (Master Data Management)

Databases: MS Access, SQL Server, Oracle, Teradata, MySQL, DB2

Reporting Tools: SSRS, Power BI, Tableau

Other Tools: SQL Sentry Power Suite, VSS, TFS, GitHub

PROFESSIONAL EXPERIENCE

Confidential, VA

MSBI Developer

Responsibilities:

  • Involved in complete SDLC process by analyzing business requirements and functional workflow of information from source systems to destination systems.
  • Expertise in analysis, design, and development of end-to-end business intelligence solutions using theMSBIsuites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
  • Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the multi-dimensional data warehouse.
  • Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document.
  • Extensively involved in creating robust complexpowerBImodels, writing complex DAX logic's involving rank, filters and data massaging.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • ManagedPowerBIPortal - Data refreshes / User management and set up gateway data refresh.

Confidential, Richardson, TX

MSBI Developer

Responsibilities:

  • Good Experience on creating dashboards, volume reports, operating summaries, and presentations and graphs. SSRS Integration to Power BI.
  • Hands on experience on Optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
  • Expertise in analysis, design, and development of end-to-end business intelligence solutions using theMSBIsuites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
  • Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
  • Involved in creating complicated packages with custom coding usingc#.NET in SSIS.
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
  • Extensively involved in creating robust complexpowerBImodels, writing complex DAX logic's involving rank, filters and data massaging.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
  • Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2016, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, Autosys, MS Visio, Excel PowerPivot, MS Excel 2010/2013, C# .NET

Confidential, Riverwoods, IL

Software Developer

Responsibilities:

  • Responsible for data modeling, designs and development, oversight of implementation, testing, and managing the relationship between the client and the development team.
  • Created complex SSIS package to automate complete process and deployed them to File Share & Server to enable users execute these processes using SQL Server 2016.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Analyzed the requirements and their usage for different reporting purposes using Tableau andPowerBIVisualization tools.
  • Explore data in a variety of ways and across multiple visualizations usingPowerBI.
  • Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • ETL processes development from third party FTP site to Local SQL Database using Integration Services (SSIS) and .Net Scripting inC# SSAS
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and analyze multi-dimensional reports.
  • Used SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
  • Used Team Foundation Server (TFS) to check-in/check-out SSRS reports & SSIS packages.

Environment: MS SQL Server 2012/2008R2, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), SQL Profiler, Windows 10 and Windows 2003/2008 Server.

Confidential - Atlanta, GA

Database Developer

Responsibilities:

  • Involved in complete SDLC process by analyzing business requirements and functional workflow of information from source systems to destination systems.
  • Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document.
  • Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the data warehouse.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
  • Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
  • Used XML & environment variables in package configuration for Deploying SSIS packages.
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, Parameterized reports in SSRS.
  • Customized new columns and KPI's in Power Pivot models utilizing DAX.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • Converted Excel reports into SSRS reports and also into other required formats.
  • Integrated SQL Server reporting services with Microsoft SharePoint Portal Server to deliver automatically generated reports to the Share Point portal.
  • Used TFS to manage different versions of new and existing reports and code, branching and merging into production.
  • Developed functional and technical documentation to assist in the design, development, and maintenance of deliverables.

Hire Now