We provide IT Staff Augmentation Services!

Msbi Developer Resume

4.00/5 (Submit Your Rating)

Indianapolis, IN

SUMMARY

  • Over 6 years of strong experience in MS SQL Server 2008/2012, SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Service).
  • Experience in creating and deploying Data Transformation Services (DTS), knowledge of Integration Services packages (SSIS) and Reporting Services (SSRS).
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
  • Highly proficient in teh use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Efficient in upgrade and migration from SQL Server 2005/2008 to SQL Server 2012.
  • Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

Data Warehouse Tools: - MS SQL Server 2005/2008/2012 Analysis Services, Data Mining Tools, Integration Services

Business Intelligence Tools: - SQL Server 2008/2012/2016 Business Intelligence Development Studio, MS Data Tools, ProClarity

Languages: - T-SQL, C#, ASP.NET, XML, HTML, CSS, JavaScript, MVC, Python

Reporting Tools: - MS-Access Reports, SQL Server 2005/2008/2012 Reporting Services, MS-Excel 2010/2013, Power BI

Development Environment: - Visual Studio.Net 2013/12/10/08/05, Product Studio, WTT

Data Modeling Tools: - Microsoft Visio 2010/2013

Operating Systems: - Windows 10/8.1/8/7, Vista, 2003/XP/2000/Me/NT/98/95

XML Technologies: - DBB

PROFESSIONAL EXPERIENCE

Confidential - Indianapolis, IN

MSBI Developer

Responsibilities:

  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code and SQL joins for applications.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst, and clients withQuery Optimizationto increase teh performance of teh Report.
  • Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2012.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Applied stored procedures for teh transformation of data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
  • Maintained better running of DTS packages through SQL Joins, sub queries, tracing, and performance tuning.
  • Develop quick small applications using Microsoft PowerApps, Power Automate, SharePoint online and Azure Cognitive services.
  • Used Python, T-SQL and ASP.Net languages.
  • Completed incremental load with several Data Flow Task and Control Flow Tasks using SSIS and created and implemented master child package using variables in SSIS.
  • Created many complex Query's and used them in Power BI Reports directly to generate reports on teh fly.

Technologies and tools used: MS SQL Server 2012, SQL Server Integration Services 2012, SQL Server Reporting Services 2012 Visual Studio 2012/13, TFS 2012/13.

Confidential - Indianapolis, IN

MSBI Developer

Responsibilities:

  • Designed, developed, modified, and enhanced teh database structures and database objects.
  • Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in databases.
  • Created, developed, and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
  • Diagnosing and tuning teh server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
  • Developed Query for generating drill down/drill through reports in SSRS 2008.
  • Created ETL packages to validate, extract, transform and load data to data warehouse databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.
  • Created Dashboard and teh Content Pack for teh originations to get teh updated Power BI Reports. And added teh refresh time for each tile in teh dashboard.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
  • Developed teh SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSRS and SSIS.

Technologies and tools used: SQL Server 2012/2016, 2008/2008 R2, Business Intelligence Studio (SSIS, SSRS), T SQL, MS Excel

Confidential - Indianapolis, IN

BI Developer

Responsibilities:

  • DevelopedPowerPivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
  • Generated various reports with drilldowns, calculated members, dropdowns from teh cubes by connecting to Analysis server from SSRS.
  • Simultaneously maintained teh existing ETL and recreated new SSIS packages and created test cases for testing teh SSIS packages.
  • Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
  • Generated various reports with drilldowns, calculated members, dropdowns from teh cubes by connecting to Analysis server from SSRS.
  • Used MicrosoftPowerBIPowerQuery to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
  • Simultaneously maintained teh existing ETL and recreated new SSIS packages and created test cases for testing teh SSIS packages.

Technologies and tools used: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, PowerPoint, Excel), ETL, Microsoft Visual Studio, Power BI.

We'd love your feedback!