We provide IT Staff Augmentation Services!

Sr. Sql/bi Developer Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • 7+ years of experience in Project Design, Analysis, Development & Management using various database technologies like (SQL Server 2005/2008/2008 R 2/2012/2 /2018 , T - SQL, Azure Big data) in both OLTP, OLAP and data warehousing environments.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and worked in a technically challenging environment.
  • Expertise in SQL Server and T-SQL (DDL, DML and DCL) in constructing Tables, Joins, Indexed views, Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules.
  • Extensive experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 6.x/7.x/8.x/9.x
  • Experience in developing, maintaining, and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, MDX, Excel pivot tables, Power Pivots, Power BI, Power Query, DAX)
  • Strong technical knowledge in SQL Server Bisuits (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools
  • Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
  • Experience managing Big Data platform deployed in Azure Cloud
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
  • Experience in Monitoring and Tuning SQL Server Performance
  • Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools
  • Expert in creating, debugging, configuring, and deploying ETL packages designed MS SQL Server Integration Services (SSIS)
  • Experience in configuration of report server and report manager for job scheduling, giving permissions to different level of users in SQLServer Reporting Services (SSRS)
  • Experience in creating OLAP Data marts using SQL Server Analysis Server (SSAS)
  • Experience in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions.
  • Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Servicesusing multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
  • Responsible for creating Requirements Documentation for various projects
  • Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease
  • Experience in writing code in R for data loads, extracts, statistical analysis
  • Provided 24x7 production support to Batch, continuous flow process for daily, monthly, and weekly job schedule

TECHNICAL SKILLS:

RDBMS: MS SQL server 2005/2008/2008 R 2/2012/2014/2016 , MS Access, MS Excel.

SQL Server Tools: SQL Server Management Studio (SSMS), BRDS (SSIS, SSAS, SSRS), SQL Server Query Analyzer, Red Gate, SQL Server profiler.

BI Tools: SSIS, SSRS, SSAS, DTS, TFS, Tableau, DB2, TOAD, Azure, and Sybase

VB Script, T: SQL, HTML, XML, BRDS, .RDL, Java Script, R, C, C++, C#, MDX and DAX

Operating System: Windows 95/2000/2003/ XP/VISTA, Windows NT/LINUX

Tools: ERWIN, SVN,GIT, MS Visio, Power BI View, Power Pivot, QTP, Selenium.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. SQL/BI Developer

Responsibilities:

  • Installed SQL 2016 SQL server Database engine, SSIS & SSRS features in the Development environment as needed.
  • Experience in dealing with ambiguities to create rational and functional solution from imperfect requirements
  • Performed DB ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.
  • Responsible for extracting the data from OLTP and OLAP using SSIS
  • Worked with various tasks and transformations in Control flow and Data flow items
  • Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports
  • Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables
  • Worked in Creating DAX Expressions and implement Partitions in Tabular models
  • Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
  • Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
  • Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
  • Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
  • Created notifications and alerts, subscriptions to reports in the Power BI service
  • Wrote Kusto queries to pull telemetry data for analysis
  • Used R to extract the data from Cosmos and load it into SQL database
  • Knowledge of managing security and metrics of the data presented using the Admin portal
  • Used Visual Studio Team Services(VSTS) for version controlling, assisted in documentation, and creating data dictionary

Confidential, Peoria, IL

Sr. Azure/SQL Developer

Responsibilities:

  • Working as Azure SQL developer maintaining the database, pull the data from blog storage loaded into the SQL Data warehouse.
  • Creating pipelines Azure Data Factory jobs and Schedule to import the data from legacy to Cat Digital Platform
  • We are recently Upgraded to Microsoft Azure Version 2.0 to create automatic alerts to developers notify if any pipelines failed or we are not receiving data it will notify the root cause.
  • Involved in Deployment, Design, testing on premises Azure Environment
  • Designed ETLpackages and Workflows with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
  • Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business
  • Created C#.Net Script for Data Flow & Control Flow Error Handling using Script component in SSIS.
  • Maintaining, enhancing, and developing architecture of our platform
  • Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS.
  • Responsible for Migrating the SSIS packages from .
  • Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
  • Exposure creation of different kinds of reports Audit reports, Fixed income Reports, Sales Forecasting reports, Revenue reports and Decision-making reports.
  • Taking Backup to cloud Storage Account using Cloudberry Cloud Storage Tool
  • Worked on Migrating from SQL Server 2008R2 to SQL Server 2012
  • Created and Published Tableau Dashboards into Tableau Server.
  • Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS and Power BI
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries & power queries to retrieve data from the database which should be displayed in various forms.
  • Developed MS Excel dashboards for executive data management presentations of procurement and supply chain metrics and KPIs.
  • Generated Sub-Reports, drill down reports, drill through reports, Tabular Report, Crystal, and Parameterized reports using SSRS.
  • Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
  • Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
  • Configured Checkpoints on SSIS packages so that the package would restart from the point of failure.
  • Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
  • Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
  • Involved in the implementation of Performance Point Server (PPS).
  • Modified OLAP Cubes to add Dimensions, Creating User Defined Hierarchy, created new calculated members using MDX and DAX Expression as per the business requirement.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2008R2/2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SQL Server Data Tools 2016, MS SQL Profiler, Sybase, SVN, Power BI, Power Query, Hadoop, R, MDM, SQL Query Analyzer,ORM, Red Gate, DAX, SQL Server Index Tuning Wizard, SSD, BRD, Visual Studio 2010, Windows XP, MS Office 2007/2013, MS Access, Excel.

Confidential, Dallas, TX

Sr. SSIS/SSRS Developer

Responsibilities:

  • Created Various Reports using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Tabular, Matrix and Linked reports from Database Objects.
  • Migrated and Deployed SSRS Reports ( ) to SharePoint and provided Security and Subscription to various Users.
  • Creating and managing scheme objects such as tables, views, Indexes, Procedures, triggers and maintained Referential Integrity.
  • Handling IT support tickets with Issue resolution or customer requests from various levels.
  • Provided expertise, skills and to effectively support customers of new and existing information systems within the organization.
  • Performing Unit and Integration Testing on the Development and Test Servers.
  • Participated in the review of Technical, Business Transformation Requirements Document.
  • Created C#.Net Script for Data Flow and Error Handling using Script component in SSIS.
  • Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
  • Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
  • Involved in the implementation of Performance Point Server (PPS).
  • Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
  • Modified OLAP Cubes to add Dimensions, Creating User Defined Hierarchy, created new calculated members using MDX Expression as per the business requirement.
  • Worked on Migrating from SQL Server 2008R2 to SQL Server 2012.

Environment: SQL Server 2008R2/2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SQL Server Data Tools 2016, MS SQL Profiler, Sybase, SVN, Power BI, Power Query, R - Shiny, Hadoop,SQL Query Analyzer, Red Gate, ORM, DAX, SQL Server Index Tuning Wizard, SSD, BRD, Visual Studio 2010, Windows XP, MS Office 2007/2013, MS Access, Excel.

Confidential, San Jose, CA

Sr. SSRS Developer

Responsibilities:

  • Modified the existing stored procedures to get the new functionality depending on the client requirement.
  • Created many tables with the clusters and non-clustered indexes on columns.
  • Design work for specific EDI Mapping Projects, Mapping and Implementing message translations for connecting trading partners to each other and to the applications
  • Worked with prospective trading partners to determine data processing and EDI operation requirements
  • Deployed power pivot model to SQL server Analysis services tabular instance.
  • Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, For each Loop Container.
  • Created stored procedures and SQL queries to pull data into power pivot model.
  • Import Data into Power BI using different ETL methods, SQL Azure, Power query, Direct Query, Restful API Generator, build relational model with in Power BI to generate Marketing Campaigns metrics related to landing pages, Email Analysis, and Visitors. Slice data by Month, Campaigns, and Area dimensions.
  • Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
  • Development and Unit Testing of Azure modules
  • Created various database objects such as tables, indexes and views based on requirement.
  • Created daily, weekly, monthly reports for various categories and hierarchies based on business needs using SSRS
  • Create reports such as parameterized, cascading, Drill through/Drill downreports, charts and specialized in producing sub reports using relational data warehouse and OLAP cubes.
  • Created many SSRS reports with lots of metrics on it using row grouping and column grouping
  • Created table valued functions and used in the report stored procedures on the fly Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
  • Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX & DAX query performance of Hierarchies and Fact Dimensions.
  • Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS and OLAP databases.
  • Developed Drill-down/thru, sub-reports, linked and Dashboard reports using SSRS
  • Involved in Designing and deploying cubes in SSAS environment using data modeling tools like Snowflake and Star Schema Designs for the operational data
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Worked on the summary of clinical data like Demographic, Adverse Events, Serious Adverse Events, and Related Adverse Events leading to Discontinuation.

Environment: SQL server 2012/2016, SQL server Management studio(SSMS), SQL server integration services (SSIS), Tableau, SQL server reporting services (SSRS), Power BI, SQL server Analysis services (SSAS), C#, Red Gate, R, SVN, ASP.NET, Hadoop, Sybase, SQL server profiler, Microsoft visual studio 2010, Team Foundation server (TFS), MS Excel and Access.

Confidential, Summit, NJ

Sr. SQL/SSRSDeveloper

Responsibilities:

  • Worked closely with the business Analyst for understanding the requirement and involved in planning and designing data based on business requirements.
  • Wrote complex SQL queries using joins, sub queries, power queries and correlated sub queries to retrieve data from the database.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
  • Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
  • Published views and dashboards in Tableau Server for auditor review.
  • Implemented validations to merge data from different sources like Excel, SQL etc.
  • Written Excel-VBA code for several activities to place milestones and connect milestones depending on several business rules.
  • Experience in writing DAX in MS Power BI Desktop.
  • Experience in creating calculated measures and columns with DAX in MS Power BI Desktop
  • Integrated Excel with Azure SQL Server to fetch data and load into the visual that's used by stakeholders.
  • Using Checkpoints in packages to enable the package to run from the point of failure.
  • Created package dependencies by calling Child packages within Parent.
  • Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
  • Designed and developed the web application in ASP.NET2.0, C#.
  • Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
  • Generated SSRS Report through SSIS Package using script component as per business requirement.
  • Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
  • Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
  • Constructed Cubes based on data volumes mostly adhering to Star Schema.
  • Documented all the project work in support for maintenance.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SSD, BRD, MS SQL Profiler, SQL Query Analyzer, TOAD, SVN, Red Gate, Power Query, ASP.NET, SQL Server Index Tuning Wizard, Visual Studio 2008, Windows XP, MS Office 2003/2007, MS Access, Excel.

Confidential

Jr. SQL Developer

Responsibilities:

  • Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience.
  • Created new database logically and physically designed to fit new business requirements.
  • Created various database objects Tables, Indexes, Views, SQL Joins, and Triggers
  • Writing T-SQL queries, Views, Stored Procedures, and User Defined Functions.
  • Filtered bad data from legacy system using complex T-SQL statements, implemented various constraints, and triggers for data consistency.
  • Used DBCC Utilities for Performance Tuning, Query Optimization, and Client Server Connectivity&Database consistency checks.
  • Planned the complete backup (with the suitable recovery model) of various Databases.
  • Creates technical specifications, test plans and test data to support ETL processes
  • Customers Insurance Policies were formatted for creating reports that are deliverable to the policy holders and the manager.
  • Developed different types of tabular reports, matrix reports, chart and graphs, crystal reports that aggregate data using SQL Server Reporting Services.
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
  • Created OLAP cubes using KPI’s for analyzing financial trends before and after company mergers and created calculated members using MDX and DAX.

Environment: MS SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Business Intelligence Development studio, Erwin, Excel, Windows 2003, Visual Studio.

Hire Now