We provide IT Staff Augmentation Services!

Sql/bi Consultant Resume

3.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • Over 8+ years of Professional experience in teh IT industry as a MS SQL Server, Power BI and Azure Data Factory Developer in Utility, Finance, and Health Care Domains.
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, PowerBI, Azure Cloud) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
  • Skilled in Data warehousing tools, Data Mapping, Data Dictionary’s, Unit Testing, Migration, Conversions, and Process Documentation.
  • Expert in RDBMS concepts, Data warehousing concepts, ER diagram, OLTP & OLAP.
  • Worked with ETL team in Defining teh transformation logic in teh ETL (Azure Data factory).
  • Experience in working Data Migration using SQL, SQL Azure, Azure storage, Azure Data Lakes, Azure Data Factory, SSIS and PowerShell.
  • Created Pipelines in ADF using Linked Services/Datasets/Pipeline/to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse and backwards.
  • Excellent in writing T - SQL, working on DTS, SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
  • Experience in using Azure Devops to maintain code repository and to update daily task.
  • Hands - on experience in Azure Cloud Services (PaaS & IaaS), Azure Data Pool, SQL Azure, Data Factory, Azure Monitoring, Key Vault, Azure Data Lake and Azure Active Directory.
  • Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
  • Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
  • Experience in developing Dashboard Reports, Parameterized Reports, linked reports and Sub reports by Region, Year, Quarter, Month and Week using Power BI
  • Experience in Generating ad-hoc reports in Power Pivot and shared them using Power Bl to teh decision makers for strategic planning and data driven subscription reports by using Report Builder.
  • Experience with file transfer protocols, including standard FTP and SFTP
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • In depth understanding of SQL Server Migrations and problem management
  • Experience in using SSIS Script task with VB .Net and C# .Net code.
  • Experience in testing ETL SSIS packages and ADF pipelines and data flows in DEV and UAT.
  • Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
  • Having excellent communication skills, analytical skills, understanding of business requirements in various domains.
  • Expertise in SQL and PL/SQL.
  • Hands on experience in Oracle database.
  • Having academic Knowledge in UNIX operating system.

TECHNICAL SKILLS

  • MS SQL Server 2016/2014/2012/2008 R2/2008/2005
  • SSRS
  • SSIS
  • DB2
  • DAX (Power BI)
  • Azure SQL
  • Azure Data Pool
  • Azure Data Factory
  • Azure Storage
  • Azure Data Lakes
  • MS-Access 2000
  • MS Excel
  • Team Foundation Server
  • Erwin 8.0/7.2/7.1
  • MS Visio 2016/2010/2007/2005
  • MS Dynamics
  • Oracle 11g/10g
  • Unix
  • T-SQL
  • XML
  • Java script
  • VB Script
  • C#
  • Visual Studio 2016/2012/2008 R 2/2008/2005/2000
  • MS office
  • Windows NT/ 2000 Server/ XP
  • PowerShell script.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL/BI Consultant

Responsibilities:

  • Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS/Azure Data Factory tools, target data warehouse, Data marts, and Reporting tools.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule teh same as jobs using SQL Server Agent
  • Perform data analysis on teh multiple data sources for designing teh most effective data warehouse structures and ETL processes.
  • Designed data warehouse star schemas and snow flex schema including fact table and dimension tables.
  • Design & build SSIS ETL (Extract, Transform & Load) process load data from heterogeneous sources like DB2, flat files, SQL Server and to perform complex transformations to load data in Dimension tables, granular and aggregated Fact tables for various SSRS and Excel Pivot reports.
  • Designed ADF pipeline using copy data, for each loop, if condition, metadata lookup and delete actives.
  • Responsible for transferring files from on-premise to Azure Data Lakes using self-hosted integration runtime.
  • Used various SSIS control flow tools like Sequence containers, for each Loop containers, script task, Send Mail Task to enhance teh performance and implement business rules.
  • Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling teh packages.
  • Good experience in tracking and logging end to end software application build using Azure Devops.
  • Configured files to deploy teh SSIS packages across all environments.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing teh disk usage and me/O resources.
  • Involved in transformation logic in teh ELT (Azure) and migrating teh SSIS packages to Azure Data factory.
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
  • Developed and maintained Power BI reports, Dashboards using different sources like SQL Server, Excel and Oracle based on teh business needs.
  • Added calculated columns, and measures as per teh requirements using DAX Formulas like CALCULATE, FILTER, SWITCH, Time Intelligence functions, etc...
  • Created various visualizations using bar graph, line graph, Pie chart, Donut chart, World map to depict different KPIs and compare Budget and Actual amounts by department, region, groups and Accounts.
  • Implemented Row level security using Roles to restrict data access in Power BI reports.
  • Published reports to teh required workspaces and made them available to Business users.
  • Scheduled auto refresh using enterprise gateway to update data in Power BI service.
  • Good Expertise in using Source Control Tools such as Team Foundation Server (TFS) and maintain a Repository of teh T-SQL, SSIS developments
  • Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting teh data, Defining Data sources and Subtotals for teh reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
  • Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Confidential

SQL/BI Consultant

Responsibilities:

  • Created/Updated database objects like tables, views, stored procedures, function, packages,
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
  • Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
  • Involved in providing ETL support for teh production server.
  • Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
  • Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
  • Involved in creating SSIS jobs to automate teh reports generation and cube refresh packages.
  • Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).
  • Enhanced teh functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
  • Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.

Environment: SQL Server 2008/2012 Enterprise Edition, BIDS, SSIS, SSRS, T-SQL, DAX, MDX, ETL, VB.Net, ASP.Net, C#, Performance Point Server 2007, Talend 5.6.

Confidential

Software Developer

Responsibilities:

  • Created ztable to store teh master data of Survey, Feedback, Quiz, Area of interest, Portfolio management, Surgery Management, Demographic and Psychographic/Behavioral
  • Developed module pool program to upload teh master data from teh excel
  • Developed GET List/detail and Create RFC’c for retrieving/saving data from ztable in CRM.

We'd love your feedback!