We provide IT Staff Augmentation Services!

Sql Server/bi Developer (ssis, Ssrs, Ssas) Resume

SUMMARY

  • 7+ years of Professional experience in Database design and development using Microsoft SQL Server 2008 R2/2012/2014 and BI tools like SSIS, SSRS and SSAS across all environments.
  • Expert in developing stored procedures, views, user defined functions, triggers and complex join queries using T - SQL.
  • Experienced in advanced query concepts like Group by, having, clause, common table expressions (CTE) and sub queries.
  • Expert in T-SQL development to write complex queries by joining multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions
  • Excellent understanding of Relational Database Systems and Normalization
  • Experience in planning and implementing Microsoft SQL Server Security and database permissions.
  • Experience in automating maintenance plans using SQL Server Job Agent and Task Scheduler to perform tasks such as creating backups, cleaning up, database shrinking index rebuilding, index reorganizing and updating statistics
  • Hands-on experience with analyzing query plans, employing Stored Procedures, managing locks and troubleshooting deadlocks.
  • Good knowledge on Index tuning operations and query optimization to improve query performance.
  • Proficient in creating ETL packages using SQL Server integration Services for data extraction, transformation and loading from various sources.
  • Experienced in ETL operations from various sources like DB2, Oracle, Flat files, CSV and excel.
  • Experience in Error and Event Handling, Break Points, Check Points and Logging in SSIS to identify the root cause of errors in SSIS.
  • Well versed in using SSRS for Configuring, designing, deploying and tuning of Reports.
  • Experience in creating SSRS reports using Report designer and Report builder.
  • Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
  • Created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
  • Ability to write SQL queries to read the data from various sources like Oracle, DB2 and MySQL to design reports using SSRS.
  • Good knowledge and understanding of SSAS, OLAP cube and Architecture.
  • In-depth understanding of all stages of software development life cycle (SDLC).
  • Experience Manual Testing.
  • Experience in Waterfall and Agile models.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server BIDS

Languages: T-SQL, PL/SQL, C, C++, Java, C#, VB.Net

Operating System: Windows 2010/2007/2000/2003/ XP/Vista/Win7

Servers: Windows NT/ 2000/2003/2008/2012

ETL Tools: Data Transformation Services, SQL Server Integration Services(SSIS) 2014/2012/2008 R2/2008/2005

Reporting Tools: SQL Server Reporting Services 2014/2012/2008 R2/2008/2005, Report Builder

OLAP Tools: SQL SERVER Analysis Services 2012/2008R2/2008/2005

Data Modeling Tools: Visio, ER-Win

Scripting Languages: PowerShell

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

  • Created and maintained database objects, complex Stored Procedures, Tables, Views and SQL Joins and other statements for various applications.
  • Creation of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
  • Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
  • Developed ETL packages across all environments for Warehouse data loading using SQL Server Integration Services.
  • Created notifications and alerts, subscriptions to reports in the Power BI service.
  • Scheduling report refreshes using power BI services.
  • Creating data gateways for on-premise data in power BI services
  • Monitor, Track and resolve issues with the Power BI reports.
  • Automation of sending Email process daily, to view refreshed Power BI dash boards.
  • Extracted data from multiple sources like Flat file, CSV, excel, DB2 and Oracle for ETL operations
  • Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
  • Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
  • Worked on the development of Power BI Dashboard reports for Key Performance Indicators for the top management.
  • Create SSIS packages for incremental data loads using SCD, CDC and Lookup transformations.
  • Created event handlers to handling the errors and debugging the packages.
  • Install, Configured and maintained the SQL Server reporting services across all environments.
  • Developed various SSRS reports like Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.
  • Convert Crystal reports to SSRS and change the SQL queries accordingly.
  • Used cascaded parameters to generate a report from two different Data Sets.
  • Developed SSRS reports using Report designer and Report builder
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Creates Snapshots and Cache refresh options on schedule basic to improve the performance of reports

Environment: MSSQL Server 2014/2012/2008 , Visual Studio 2013/2010/2008 , Reporting Services (SSRS 2008), MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Web, Object Manager, Integrity Manager), .NET 4.0/3.5, Business Intelligence Development Studio (BIDS), MS Office 2007, Office 365, PowerPivot, UNIX, MS Access, OLTP and OLAP (Data warehousing), SVN Tortoise, ETL, MS Excel, Oracle SQL developer.

Confidential

SQL Server/ BI Developer

Responsibilities:

  • Interacted with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
  • Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2005, flat files, Excel files, Access Database.
  • Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Worked on Power Query (M Language) Functions.
  • Worked on Power Query Parameters and Variables.
  • Worked on Power Query Lists, Tables and Records.
  • Worked on DAX Functions and Usage.
  • Worked on DAX Measures and Calculations.
  • Worked on BI Enhancements using DAX.
  • Worked on Power BI Cloud and App Creation, Publishing.
  • Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.
  • Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS).
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
  • Used different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
  • Worked on various possible performance-related issues including Database Tuning with the sole intention of achieving faster response times and better throughput.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
  • Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
  • Worked on debugging Reports and deploying Reports.
  • Scheduled the Reports to run automatically.
  • Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
  • Used different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
  • Worked on various possible performance-related issues including Database Tuning with the sole intention of achieving faster response times and better throughput.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
  • Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
  • Worked on debugging Reports and deploying Reports.
  • Scheduled the Reports to run automatically.
  • Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Experience in handling Tabular Data Modeling in SSAS.
  • Created reports in Power BI Desktop and published to portal utilizing the SSAS Tabular via Analysis connector.
  • Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
  • Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
  • Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
  • Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.

Environment: Microsoft SQL Server 2008/2012/2014 , Microsoft Windows 2000/2003, Windows server 2008, XML, Visual Studio, SSIS, SSRS, SSAS and Reporting Services Shell Scripting, Oracle, Crystal Reports.

Confidential

SQL Developer Intern (Project)

Responsibilities:

  • Under fine guide lines of Professor Mahesh Sarathy .PhD created college database.
  • Created numerous simple to complex SQL queries involving joins, correlated sub-queries and CTE’s techniques for diverse college requirements.
  • Using SQL queries created Databases, Tables and maintained a record per college requirements.
  • Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: Microsoft SQL Server 2008, SQL Server Management Studio.

Hire Now