Data Ssis

SSIS/SQL DEVELOPER

SUMMARY OF QUALIFICATIONS:

Project Management

oExperienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings

oExperienced using Agile Project management tools like Trello and JIRA

oHands on experience working on Waterfall Projects with full SDLC

MS SQL Server Database

oExperience in creating database, tables, indexes, complex queries, stored procedures, views, triggers, user defined functions, temp tables, complex joins, T-SQLMS SQL Server /2008/2012/2008 R2/2016

oHands on experience on identifying and resolving performance issues using SQL Profiler, Database Tuning Advisor, DBBC commands and Execution Plans.

oExperienced in building parameterized stored procedures to support application team

oExperienced in converting functional requirements into T-SQL Scripts and materialized views

Data Warehousing

oExperienced in Dimensional Data modeling including Start and Snow Flake Schema

oWell versed implementing Slowly changing dimensional using SSIS Package

oExperienced in denormalization process and grain identification

oExperienced in writing T-SQL Script to sync staging Data to Dim and Fact tables

Reporting and Visualization

oExpertise in Creating, Reports through SQL Server Reporting Services (SSRS)

oExperienced in configuring and managing Report Subscriptions

oExcellent in building C-Level Dashboards using Power BI

oWell versed in configuring and managing Dataset refresh on Power BI Service

oHands on experience managing in users on Report Server and Power BI Service

oHands on experience configuring Power BI workspace

ETL and Data migration

oWell versed on building SSIS Packages for file management and Data Flow

oExcellent in building SSIS packages to integrate data from various sources into a DW

oStrong Experience in Creating, Configuring, Deploying and Testing SSIS Packages

oExperienced in Data Profiling and Transformations using SSIS

Soft Skills

oExcellent problem-solving ability, skill to work in team, efficient in organizing and leading

TECHNOLOGY AND TOOLS:

Core Technology

Core Competencies

Database - MS SQL Server

Data Warehousing, T SQL Scripting

ETL – SSIS, Import and Export

SSIS Package development and implementation

Reporting – SSRS, Power BI, Tableau

Report and Dashboard

Modeling – Oracle SQL Modeler

Relational and Dimensional Data Model

Collaboration- Slack, WebEx

Remote work and Team Collaboration

Project Management - Trello

Agile and Water Fall

MS Office

Excel, Power Point, Word, Access DB

Visualization –Power BI, Tableau

Dashboards and Stories

Database Tuning Advisor

Database Performance

SQL Profiler

SQL Server Performance

NeighborWorks America Jan 2019 Present Washington, Dc

ETL/SSIS Developer

Responsibilities:

oCreated SSIS packages to migrate data from different data sources to data warehouse.

oSuccessfully extracted transformed and load data into data warehouse.

oCreated packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

oExtensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

oScheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

oInvolved in enhancing and deploying the SSIS Packages from development server to production server.

oInvolved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.

oDesigned, deployed, and maintained of various SSRS Reports in SQL Server 2012.

oWrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

oDefined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

oDeveloped complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

oResponsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard

oInstalled and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

HMS Host Apr 2017 to Dec 2018 Bethesda, MD

ETL/MS SQL Server Developer

Responsibilities:

oDesigned Data Warehouse schemas such as star schema and snowflake by using Oracle Data Molder

oDeveloped ETL workflows to load data into Dim and Fact tables using SSIS Package

oExtracted data from diverse data sources such as CSV, Excel and Text file from Client servers and FTP

oUsed FTP to transfer large volumes of data to and from different servers.

oDeployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.

oDeveloped a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing

oDeveloped and deployed SSIS packages using proper control and data flow elements with error handling.

oEnhanced and deployed SSIS Packages from development server to production server

oIdentified and resolved issues related to SSIS package configuration and deployment.

oMaintained data integrity by performing data validation checks.

oWrote complex T-SQL queries and used in stored procedures and triggers and modified existing ones.

oDeveloped C level visualization such as Dashboards and Reports using Power BI

oDeployed Power BI reports and Dashboards to Power BI Service.

oCreated and Managed Power BI new and traditional workspaces

oScheduled dataset refresh on Power BI Service

Asurion Aug 2014-Mar 2017 Nashville, TN

SQL Server Developer/SSIS/SSRS

Responsibilities:

oResponsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

oCreated DTS packages for the data cleansing/transfer and transformation.

oUsed SSIS to unite data from existing system and performed transformations on MS SQL 2008-R2.

oUsed various transformation components in the data flow task to implement business logic.

oUsed various tasks in control flow and data flow to cleanse and filter duplicates in tables.

oConfigured SSIS packages using Package configuration wizard to allow package run on different environments.

oCreated custom and Ad hoc reports using SSRS.

oCreated complex variables, multiple breaks, sorts in the reports.

oCreated Tabular and Matrix reports using SSRS.

oDeveloped multiple reports using reporting services.

oCreating functions and developing procedures for implementing application functionality at the database side for performance improvement.

oCreating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

oCreated Packages in both DTS and SSIS

oCreated ETL package for data conversion using various transformations tasks.

oCreated Stepped and Block reports using SSRS

oExperience in building star schema and snowflake schema depending on the business data requirement.

oInvolved in complete SDLC, which includes requirement gathering, analysis, design, development, implementation.

Contact this candidate