We provide IT Staff Augmentation Services!

Sql Server Developer/ Ssis /ssrs Resume

0/5 (Submit Your Rating)

Lincolnshire, IL

SUMMARY

  • 7+ years of experience in Data Warehousing using SQL Server Integration Service(SSIS) 2012/2008R2/2008/2005,SQL Reporting Services (SSRS) 2012/2008R2/2008/2005, and SQL Server Analysis Services (SSAS) 2012/2008R 2/2008/2005.
  • Good knowledge on Relational Database Management Systems (RDBMS) Concepts with strong experience in Database Design and Programming using SQL Server.
  • Strong working experience in SQL Server and T - SQL in constructing triggers, tables, Joins, cursors, user functions, views, indexes, user profiles, relational database models and data integrity.
  • Experience in building Package Deployment and Package Configurations.
  • Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables.
  • Experience in Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
  • Proficiency in creating different types of reports such as Tabular, Matrix, List, Drill-Down, Drill-Through, Chart Reports and Sub reports, and formatting them using SSRS 2005/2008/2012 .
  • Experience in deploying created reports in various sources like Web browser, Excel and PDF.
  • Expertise in Subscribing Reports using SSRS in both the modes (SharePoint and Report Manager).
  • Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications and Production support/Maintenance Activities.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Identifying & resolving blocking and deadlocks.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012 , Oracle 10g/9i/8i, MS-Access

Operating Systems: Windows Server 2003, Windows 98/NT/XP/Professional

Languages: T-SQL, PL/SQL, C/C++, HTML, DHTML, XML, VBScript

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL server Reporting Services (SSRS)

Tools: SQL Server Enterprise Manager, Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

SQL Server Developer/ SSIS /SSRS

Responsibilities:

  • Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple transformations.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Performance tuning, and optimization of procedures and queries.
  • Created SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Aggregations, and Multicasting).
  • Created Event Handlers, Checkpoints and Logging to maintain active SSIS packages.
  • Configured SQL Mail Agent for sending automatic emails when a SSIS package is failed or succeed.
  • Responsible for gathering/refining requirements from the customer for developing reports.
  • Designed and developed various Reports like Cascading Prompts, Sales Reports, Inventory Reports, sub-reports, charts, and parameterized reports and conditional reports and deployed various reports on Share Point Portal.
  • Dynamically designing the Table headings, groups and Field values and creating Reports with Interactive sorting.
  • Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Implemented different types of constraints on tables.

Environment: SQL Server 2012/2008R2, SSIS, T-SQL, SSRS, Windows Server 2008.

Confidential, Conshohocken, PA

SQL Server Developer

Responsibilities:

  • Responsible for Schema objects like tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
  • Worked with complex SQL statements using joins, sub queries and correlated sub queries.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle i.e. to load data from OLTP to Data marts (OLAP).
  • Used SSIS control flow tasks Loop Containers, FTP, Bulk insert and different data flow tasks such as Derived Column, data conversion etc.
  • Using SSIS enabled Checkpoints to control flow tasks to ensure that if package fails after multiple tasks have succeeded, the progress made will not be lost.
  • Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
  • Scheduling and executing SSIS Packages, using SQL Server Agent.
  • Developed Incremental Data Load package using SSIS to load the updated and new records coming from different sources.
  • Written complex expressions using Cascading parameters, Drill-Through reports, and Parameterize reports using SSRS based on client requirements.
  • Designed and Developed Sub-Reports, Drill-Down Reports for the clients.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Support and Maintenance for existing SSRS Reports.

Environment: MS SQL Server, MS SQL Server Integration Services, MS SQL Server Reporting Services.

Confidential, Bloomington, IL

MS SQL / SSIS /SSRS Developer

Responsibilities:

  • Actively supported business users for change requests.
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Monitored performance and optimize SQL queries for maximum efficiency.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
  • Used Report Builder to do Ad-hoc Reporting.
  • Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
  • Designed and generated reports with different layouts using SSRS 2008/2005 and exported them into Excel, PDF and HTML.
  • Support and Maintenance for existing SSRS Reports.
  • Managed reports in reporting server with proper caching, snapshot, and report security.
  • Assisted in migrating denormalized report DB into a Star Schema design.
  • Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
  • Maintained the client relationship by communicating the daily status and weekly status of the project.

Environment: SQL Server 2008/2005 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008,Report builder, Visual Studio 2008,Ms Excel, Query Optimizer, MS Access, Windows Server 2003.

Confidential, Medford, MA

BI Developer

Responsibilities:

  • Documented ETL (SSIS) process design based on business requirements and system specifications including source to target mappings and transformations.
  • Studied the existing source tables and created facts, dimensions and star schema representation for the data mart.
  • Created databases, tables, stored procedures, views, functions, and triggers using T- SQL.
  • Created the clustered/non-clustered indexes on tables, and traced out for any table required any indexes and determine the type of index on it.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures.
  • Created SSIS packages and Bulk Insert/ BCP utility for transferring data from various health care data sources like MS Access, Excel, *.Txt file, *.CSV files.
  • Created triggers to enforce complex business rules and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
  • Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
  • Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations using SSIS.
  • Effectively made use of Package Configurations in the SSIS packages to make it easier to make changes to parameters in UAT and Production.
  • Responsible for deploying the packages in both UAT and Production and for scheduling the SSIS jobs.
  • Responsible for creating the use cases for UAT testing and for testing the ETL SSIS packages.

Environment: MS SQL Server, SSIS 2008, SSRS 2008, DTS, T-SQL, Visual Basic(VB), Visual Studio 2005, SQL Server Profiler, Erwin Data Modeller 7.2,VSS

Confidential

Jr. SQL Server Developer/ DBA

Responsibilities:

  • Wrote T-SQL statements using DML and DDL for retrieval of the data.
  • Created database objects like tables, users, roles, stored procedures, triggers.
  • Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases.
  • Implementing MS SQL Server Security and database Permissions.
  • Created Packages that extract data from excel files to database tables.
  • Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
  • Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
  • Involved in creating Technical Specification Document for the project.
  • Involved in project planning and scheduling database module in conjunction with project managers.

Environment: SQL Server 2005/2000, T-SQL, Query Analyzer, DTS, Windows 2000 Advance server, Windows NT.

We'd love your feedback!