We provide IT Staff Augmentation Services!

Sr Sql Ssis Ssrs Powerbi Developer Resume

Carry, NC

SUMMARY

  • Over all Seven years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
  • Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Worked Extensively on ETL process using SSIS package.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
  • Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
  • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience in Creation and deployment of cubes on SSAS.
  • Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014.
  • Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
  • Experience in designing Power BI reports and Dashboards.
  • Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
  • Hands on experience in working on SQL Server 2005/2008R2/2012/2016 databases, Azure SQL, Azure Data Factory &Azure Data Lake
  • Experience in working Confidential Azure cloud platform in components of ADF, ADL and Azure SQL & Datawarehouse.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Involved in DBA activities such as backups and restores.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

TECHNICAL SKILLS

SQL Server Tools and Databases: SQL Server Management Studio (SSMS), SQL Server 2012, 2014,2016, MS Access 2008, Oracle 11g, SQL Server Integration Services (SSIS), SSRS (Reporting Services), SSAS (Analysis Services), Microsoft Visual Studio 2012/2014/2016 , SQL Server Business Intelligence Studio(BIDS), SharePoint, .Net, Azure SQL Database, Azure cloud platform (Azure Data Factory, Azure Data Lake, Azure SQL

BI tools: Power BI, Qlikview, Tableau

Statistical tools: SPSS, SAS JMP

Applications: Visual Basics, Excel -Macros

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Carry, NC

Sr SQL SSIS SSRS PowerBI developer

Responsibilities:

  • Extensive participation in logical and physical database design and normalizing the database to accommodate possible changes in OLTP & created data flow diagrams and enforced all referential integrity constraints.
  • Created Stored Procedures and functions.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
  • Created new database objects like tables, synonyms, Packages, Triggers, Indexes and Views using T-SQL in Development, Test and Production environment for SQL Server.
  • Worked on the revamping the existing architecture and implemented the new architecture on Azure SQL
  • The SSIS packages were implemented to use in a SQL Agent Job using on-premises SQL Server and connect to Azure SQL database using encrypted connection
  • Creating Azure Data factories for loading the data to Azure SQL database from Cosmos platform.
  • Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
  • Design and Develop reports primarily using Tableau 10.x or higher.
  • Design and create best-in-class data visualizations (reports and dashboards) using tableau
  • QlikView, Qlik sense, Npriniting, Thoughtspot ‘proof-of-concept’ design.
  • Excellent data visualization skills and Experience in telling stories based on data.
  • Performs detailed data analysis required for the reporting.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Experience working with large datasets using various data wrangling and visualization tools..
  • Liaise with clients and manage relationships while being assertive.
  • Maintain and enhance existing reports for customers. Create ad-hoc queries and reports. Designed and implemented data access stored procedures and Triggers for automating tasks.
  • Experience in SQL reporting tools, including Crystal Reports, Hyperion, SAS, and/or Tableau, Alteryx.
  • Document reporting requirements and propose solutions that go beyond the requirement.
  • Implemented constraints on tables and performed database tuning and performance planning.
  • Involved in performance tuning using indexing (Clustered Index, Non-Clustered index) tables.
  • Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data. Experience working in Agile/Scrum development team.
  • Developed data warehouse model in snowflake for over 100 datasets using whereScape.
  • Heavily involved in testing Snowflake to understand best possible way to use the cloud resources.
  • Outstanding knowledge& working experience of slice & dice Looker, Power BI & Cognos.
  • Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) and Data warehouse.
  • Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
  • Created SSIS packages for transferring the data from different systems such as SQL/Oracle server, Flat Files, CSV Files and xml files.
  • Involved in Job scheduling and alerts

ENVIRONMENT: MS SQL Server 2012/2014/2016 , Microsoft Management Studio, Teradata SQL Assistant, Azure SQL Database, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, T-SQL.

Confidential, Charlotte, NC

Sr SQL SSIS SSRS PowerBI developer

Responsibilities:

  • Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
  • Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
  • Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
  • Experience in Data Analysis, understanding trends and patterns in data.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
  • Converted the old Data flow logic written in .NET C# to SSIS packages.
  • Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
  • Configured the Azure SQL Server and created the databases.
  • Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
  • Involved in scorecard and KPI Reporting.
  • Implemented and successfully tested Log shipping in SQL Server 2012 and SQL Server 2016.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Transformed and combined the data using Query Editor in the Power BI.
  • Experience with Java script, Shell scripting, and PL/SQL scripting to pull data from different sources
  • Experience supporting a 24x7 production reporting environment
  • Used SSAS features to build and configure Hierarchical dimensions, define Measure groups, create Calculated Measures, KPI, configure Partitions, aggregations as well as Actions.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS.
  • Experience in migration of on - premises SQL Server 2012 to Azure SQL Database (PaaS) on cloud
  • Experience in Azure SQL configuration for the database and automation of tuning, vulnerability Assessment, Auditing and Threat Detection
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2014 and in adding calculations using Multidimensional Expression MDX & DAX.
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS. Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
  • Developed Star schema using SSAS cubes.
  • Created parallel period, filter, ancestors, and cross join MDX queries.
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
  • Involved in designing and publishing visually rich and intuitive Power BI dashboards.
  • Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Provided maintenance and development of bug fixes for the existing and new Power BI Reports
  • Experience with Power BI desktop and Power BI Service.
  • Published dashboards on an intranet site using SharePoint Server.
  • Migration of SQL Databases from SQL 2012 to SQL 2016.

ENVIRONMENT: MS SQL Server 2012/2014/2016 , Microsoft Management Studio, Teradata SQL Assistant, Azure SQL, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, T-SQL.

Confidential, Peoria, IL

Sr SQL SSIS SSRS developer

Responsibilities:

  • Created SSIS process design architecting the flow of data from various sources to target.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation
  • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
  • Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services (SSRS).
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Trouble shoot any kind of data issues or validation issues
  • Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
  • Design the ETL framework for the data load into FRY Tables.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Worked on the ADW Data Warehouse for Santander Bank.
  • Create Master Package to run different other ETL in one Master package.
  • Bug fixes in SSIS, SSRS and stored procedures as necessary.
  • Used C# and VB Scripts in ETL Packages wherever necessary.
  • Worked in an agile scrum methodology.
  • Scheduling the jobs to run for ETL using SQL Server Agent.
  • Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
  • Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
  • T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Perform T-SQL tuning and optimizing queries for SSIS packages..
  • Production support for SSIS and SSRS jobs.
  • Worked as an IBM - COGNOS Report Designer and created number of Business-Critical sales reports for company’s Management team.
  • Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

ENVIRONMENT: MS SQL Server 2012/2014, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 (MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Erwin Data Modeler.

Hire Now