We provide IT Staff Augmentation Services!

Sql Server/ssis/ssrs Developer Resume

4.00 Rating

Willington, DE

OBJECTIVE:

  • Seeking SQL Developer position where my professional technical experience can add value to a dynamic team.

SUMMARY

  • Having 6 years of IT experience in Database Developer using SQL Server 2016/2014/2012/2008 R2.
  • Strong experience in Stored Procedure, triggers, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.
  • Highly proficient in teh use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
  • Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
  • Expertise in Creating, Configuring and Fine-tuning ETL workflows designed using SSIS of MS SQL Server 2016/2014/2012/2008 R2
  • Extensive Knowledge in creating complex SSIS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
  • Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
  • Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
  • Proficient in creating sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2016/2014/2012/2008 R2 (SSRS).
  • Highly skilled in writing Parameterized Queries for generating parameterized reports and Sub reports using global variables, Expressions, and Functions, Sorting teh data, Defining Data sources and Subtotals for teh reports using SSRS 2016/2014/2012/2008 R2
  • Familiar working wif both Waterfall and Agile Methodology.
  • Expert in using tools like MS SQL Profiler, Database Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
  • Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

  • Microsoft SQL Server
  • SQL Server Integration & Reporting Services
  • Agile
  • Waterfall
  • Oracle 11g/10g/9i
  • T-SQL
  • SQL server management studio
  • UNIX
  • PL-SQL
  • MS SQL Profiler
  • Putty
  • Excel Macro
  • SQL Job Agent
  • Database Tuning Advisor
  • Index Tuning
  • SQL Query Analyzer
  • MS Visual Studio
  • MS Access
  • Excel
  • OLAP
  • OLTP.

PROFESSIONAL EXPERIENCE

Confidential, Willington, DE

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, SQL Server, Excel and Access to SQL Data Tools.
  • Optimized queries using Database Engine Tuning Advisor and SQL Profiler.
  • Worked wif different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
  • Responsible for solving ticket for ssis packages and T-sql from Workfront.
  • Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse.
  • Worked wif different database and different server wif teh use of linked server.
  • Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.
  • Worked on CDC (Change Data Capture), Captured teh inserted, updated and deleted data into SQL server tables by using CDC.
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
  • Built packages and handled slow changing dimensions to maintain teh historic data.
  • Responsible for monitoring and tuning a database to provide a high availability service
  • Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Designed and developed matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS.
  • Created different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
  • Used cascading parameters to generate a report from two different data sets in SSRS.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS).
  • Involved in team meeting for discuss task, Issue, Ticket description as well as presented packages and code which me have been created in team meeting.

Confidential, Boston, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Designed SSIS packages to Extract data from different sources like SQL server 2012, MS Excel, MS Access and transform and tan load into Dimension and Fact tables in Data Warehouse using SSIS.
  • Developed SSIS packages using for each loop in Control Flow to loop all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert data into teh SQL table.
  • Interact wif teh Enterprise Data Warehouse team to facilitate and document teh data mapping to teh Reporting SQL Server environment.
  • Gatheird report requirements and determined teh best solution to provide teh results in either a Reporting Services report or an Excel pivot table.
  • Worked on SQL Profiler to view indexes performance to mostly eliminate table scan.
  • Performed operations such as Fine-tuning highly complex TSQL stored procedures for maximum efficiency and performance.
  • Produced operational reports in SSRS 2012 me.e. drill-down, drill-through, chart reports, parameterized reports and snapshot reports.
  • Provided design, implementation and maintenance for custom reports using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
  • Responded to ad hoc requests and special projects that require immediate attention while at teh same time maintaining deadlines on existing requests.
  • Worked wif project manager and technical leads for resolution of technical issues.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Slowly Changing Dimension and row count etc.
  • Worked on formatting SSRS reports using teh Global variables and expressions.

Confidential, Weehawken, NJ

SQL Server Developer

Responsibilities:

  • Experience in migrating data from MS-Access, MS-EXCEL and other external data sources.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types and Indexes using T-SQL.
  • Proven good team player responsible for design, build, and normalizing of data models.
  • Developed database triggers, stored procedures, views and database functions that were required for teh application program interfaces.
  • Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, creating new Database, Creating and Modifying Table space and Optimization.
  • Actively involved in co-ordination wif teh project leader/Team Lead in planning and scheduling of teh project time lines.
  • Implemented an TEMPeffective peercode reviewprocess.
  • Provided 24/7 Production support as well as on call support for various projects.

Confidential, Berkeley Heights, NJ

SQL Server Developer

Responsibilities:

  • Worked wif project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2008 to store data and to maintain database efficiently.
  • Used ETL to implement teh SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
  • Developed and deployed data transfers packages using SSIS 2008, also maintained teh jobs running on Servers.
  • Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system, Staging DB to Data warehouse and Data marts.
  • Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling teh packages.
  • Deploying, Testing and Scheduling SSIS packages using SQL Agent.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
  • Created many Cascaded parameters in teh reports using SQL SSRS 2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2008).
  • Highly involved in automating reports generated weekly and monthly basis for teh client and business sales teams.
  • Worked wif production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.
  • Worked wif DBA teams for database update and system restarts.

Confidential

Entry Level SQL Server Developer

Responsibilities:

  • Involved in all phases of theSDLC (Software Development Life Cycle)from Requirement Gathering, analysis and design, development, testing, maintenance wif timely delivery against aggressive deadlines.
  • Involved in training session.
  • Developed and customized procedures, User defined functions and Triggers.
  • Created table, view, synonyms and sequences.
  • Involved in ETL Data validation, count and source to target table mapping using SQL queries and back-end testing.
  • Involved in Writing Backend Sql queries for source And Target Table Validation.
  • Developed and deployed data transfers packages using SSIS 2008, also maintained teh jobs running on Servers.
  • Created many reports using SQL SSRS 2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2008).

We'd love your feedback!