We provide IT Staff Augmentation Services!

Ms Sql Server/ssis/ssrs Developer Resume

GA

SUMMARY

  • Over 6 years of IT experience as SQL developer in design and development of various applications for State, Insurance, Financial and Manufacturing Industries.
  • Created T - SQL stored procedures to meet the requirements of the business and application being developed.
  • Extensive exposure to creation of databases, objects, stored procedures, triggers, security, SSIS (i.e. Import and Export), Bulk Loading of Data, Transact-SQL, and SQL Server Agent and SQL Server profiler.
  • Migration of database objects and updating scripts from SQL Server 2008 to 2012 .
  • Experienced with scripting in T-SQL in constructing tables, joins, user functions, views, indexes, triggers, synonyms and user profiles.
  • Worked on importing and exporting xml files from and to SQL Server database.
  • Developed complex stored procedures and queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
  • Experienced working on Normalized Databases and designed database/tables and the requisite relationships.
  • Managed all database servers in development, staging, test and production environments.
  • Experienced in ETL (Extracting, Transforming and Loading) development using SSIS for migration of data between legacy systems to SQL Server 2008R 2/2012/2014.
  • Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
  • Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
  • Experience in MS SQL Server suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
  • Experience in Designing and Building the Dimensions, Fact Tables with Star and Snow flake schemas.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 7/10

Database: SQL Server 2008/2008R2/2012,MS-Access, MS-Excel

LANGUAGES: SQL, PL/SQL, Transact SQL, Visual Basic, C#

SOFTWARE/ APPLICATIONS/ TOOLS: SQL Server Management Studio, SQL Profiler, SSIS, SSRS, Business Intelligence Development Studio, Guide-Wire Claim Center 7.0

Source Control and Ticketing tools: Team Foundation Server(TFS), GIT Source Control, SVN Source Control, JIRA Rally, Squish-list, Service-Now, Softeon WMS

Web Tools: HTML, XML

Data Warehousing: OLAP, OLTP, Star Schema Modeling, FACT and Dimension Tables.

PROFESSIONAL EXPERIENCE

Confidential, GA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Involved in Agile methodology by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
  • Conversion of data from legacy (DB2 and Hierarchical systems) system to new MN-Crash application with backend as SQL Server database.
  • Design of ETL conversion strategy with SQL Server Integration services (SSIS) as main tool and development of packages to convert data from legacy to new system.
  • Creation and modification of Transact-SQL scripts for new enhancements and existing elements of Conversion to convert the legacy data for ten years’ worth of data.
  • Designing data mapping documents from source to target and understand existing mapping documents developed by vendor to implement conversion of data.
  • Development of T-SQL Scripts for validation and checking consistency of data converted from legacy to new system.
  • Modification of scripts and unit testing of data through various levels of data load depending on the business needs of data.
  • Working with downstream teams from different departments of State to extract converted data and deliver to different stakeholders.
  • Create SSRS Reports through Validation scripts to check Reconciliation of data from Legacy system to Converted system.
  • Record results of validation and bugs related to each sprint in Rally as tracking system.
  • Generated xml data from the Legacy database and exported xml files to be imported into applications through SQL Server Management Studio (SSMS) and used XML editors like Altova XML Spy Editor and Microsoft XML Notepad according to business needs.

Environment: SQL Server 2012/2014, SQL Server data tools for VS 2014, MS- Excel, SQL Server Integration Services, SQL Server Reporting Services, VB Script, C#.

Confidential, IL

SQL Developer

Responsibilities:

  • Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
  • Worked on Property & Casualty (P&C) and Workers Compensation conversion projects from Legacy systems (DB2 and SQL Server) to Guide Wire (GW) Claim Center application with backend as SQL Server Database.
  • Creating and analyzing existing high level ETL design documents and data mapping documents.
  • Developing complex T-SQL queries, common table expressions (CTE), stored procedures and functions used for designing SSIS packages.
  • Performed database backups and restores on the SQL Server 2008 test and development instances.
  • Worked on migrating servers from different versions of SQL Server from 2008 R2 to 2016.
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
  • Designing Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
  • Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
  • Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
  • Record results of conversion updates, validation results and issues related to sprint in tracking systems: JIRA and Service now.
  • Building a company specific Data Mart for the Claims related data in Star Schema Dimensional modeling.
  • Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports on data mart database.
  • Worked on importing xml files into Claim Center server and also importing xml files into SQL Server database through SSIS.
  • Generated xml data from the Legacy database and exported xml files to be imported into applications through SQL Server Management Studio and used XML editors like Altova XML Spy Editor and Microsoft XML Notepad according to business needs.

Environment: MS SQL Server 2014 | 2012 | 2008 R2, Windows Server 2012 R2| 2008, SQL Server Management Studio, Profiler, Database Tuning Advisor, Spotlight, Red Gate

Confidential

SQL Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Design and Development of SSIS Packages to import data from Oracle database in form of flat files transform and load data into SQL Server database.
  • Implemented Error handling through Common Table Expressions (CTEs).
  • Created Clustered/Non-clustered indexes on tables, created views, stored procedures.
  • Efficient use of Joins and sub-queries in queries that retrieve data from multiples tables.
  • Transformation of Data into SQL Server database by development of views, staging tables and load data into tables using Stored Procedures.
  • Involved in development and debugging of complex T-SQL procedures and functions.
  • Upgraded SSIS packages for an entire Application from 2005 to 2008 using Project wizard and successfully deployed packages.
  • Managed the complete migration of SQL Server 2008 R2 to SQL Server 2012.
  • Used Automated Processing Environment (APE) Application for Automating daily SQL jobs and for execution of packages automatically.
  • Involved in Waterfall model of SDLC and gathered business requirements from Business Analysts.
  • Record results of validation and bugs related to project in Gemini as tracking system.
  • Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)
  • Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
  • Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.
  • Deployed SSRS reports into Report manager and managed reports subscriptions, delivery, generation, rendering.
  • Maintained and Supported Microsoft Team Foundation Server(TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
  • Built Reporting database which is a mirror database to the existing OLTP database, used for reporting purposes only.

Environment: SQL Server 2005/2008/2008 R2, Visual Studio 2005/2008/2010 , T-SQL, MS Access, MS- Excel, SQL Server Integration Services, SQL Server Reporting Services, VB Script, C#.

Confidential, VA

SQL DBA

Responsibilities:

  • Involved in upgrading of SQL Server 2005 to SQL Server 2008
  • Developed, deployed, and monitored SSIS Packages including upgrading DTS to SSIS.
  • Designed and developed SSIS Packages to import data and export data from MS Excel, flat files, SQL Server and transform and load data into SQL Server database.
  • While importing data from flat files used various used Error Output Descriptions which manages error outputs from flat files.
  • Updated Package Configurations of entire database from XML Configurations to SQL Server Configurations so as to assist in execution of packages in development, test and production environments.
  • Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)
  • Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
  • Conversion of MS Access Scripts into Transact-SQL Scripts
  • Implemented Event Handlers and Error Handling in SSIS packages.

Environment: Windows 2007, SQL Server 2008 R2, Visual Studio 2008/2010, T-SQL, MS Access, MS Excel, SSIS, SSRS, SharePoint, BIDS.

Hire Now