We provide IT Staff Augmentation Services!

Senior Sql Developer Resume Profile

Cedar Rapids, IA

Professional Summary:

  • 8 years of IT Experience in Database Design, Development and Support of Microsoft SQL Server 2012/2008/2005in Development, Test and Production Environments with various business domains like Insurance and Healthcare.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes using T-SQL.
  • Good hands-on experience in using all kinds of SQL Server Constraints, Writing Transact SQL T-SQL Queries Dynamic-queries.
  • Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
  • Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text file, Teradata by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
  • Experience in migrating DTS Packages from 2000 to 2005, 2000 to 2008.
  • Experience with ETL framework standards, including error processing, validation and data reconciliation.
  • Extensive experience in creating SQL Server Analysis projects using MS SQL Server 2008/2012.
  • Experienced in testing the Data stored in databases. Creating reports using MS Excel.
  • Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2008/2012.
  • Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. Table, chart and matrix reports .
  • Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
  • Experience in data migrating using tools like DTS, BULK INSERT, BCP between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
  • Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2012/2008/2005.
  • Experience in upgrading SQL Server software to newer versions and applying service packs and hot fixes and unattended Installation.
  • Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
  • Experience defining and building audits and controls to ensure the accuracy of the data.
  • Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
  • Good knowledge of Software Development Life Cycle SDLC .
  • Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2012/2008.
  • Experience in Creating Roles and Assigning Permissions to the users.

Technical Skills:

Languages

C, T-SQL, PL/SQL, COBOL, JCL

RDBMS

SQL Server 2012, 2008, MS-Access,DB2.

Version Controlling Tools

PVCS Version Manager, Tortoise SVN

SQL Server Tools

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

Data Modeling Tool

Visio 2003 2010

Operating System

Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Mainframes

Methodologies

Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization

Professional Experience:

Confidential

Senior SQL Developer

Responsibilities:

  • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Created database objects like Procedures, Functions, Packages, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created trace files on the queries and optimized the queries which were running slowly
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Created reports using Microsoft SQL Server 2012/2008 Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder and deployed on report server.
  • Experience with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive Web-based reports
  • Generated matrix reports, drill down, drill through, sub reports, multi parameterized reports.
  • Created complex Stored Procedures for better performance to generate reports.
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Created SSIS packages to extract data to OLAP systems and Scheduled Jobs using SQL Agent/Control-M to call the packages and Stored Procedures.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
  • Wrote stored procedures to generate different market claims for different types of accounts.
  • Imported various files provide by the clients into the relational database systems.
  • Used PVCS-Version Manageras Version Control Tool.

Environment: Windows server 2003, MS SQL Server-2012/2008 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, PowerShell,Control-M,PVCS-Version Manager, Office-2010, MS Excel

Confidential

SQL Server BI Developer

Responsibilities:

  • Experienced in Creating simple to complex queries involving Joins, Correlated Subqueries and Stored Procedures as per business requirements.
  • Active participation in and gathering requirements from workgroup meetings and making changes to existing logic as per business requirements.
  • Experienced in Analyzing the Data that is stored form the UI into the databases. Creating a detailed report using MS Excel.
  • Experienced in Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow and Data Flow Tools and then verifying it. .
  • Wrote the ETL scripts to load the data into database from various source files.
  • Developed standards and guidelines to maintain and develop SSIS packages and Data Flow Diagrams
  • Created SSIS packages and automated jobs to monitor, backup, import/export data for data warehouse extracts
  • Created database structures as required in a SQL Server environment.
  • Experienced in development of Test Cases in various scenarios around the SQL Code in Dev, QA and UAT
  • Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
  • Experience defining and building audits and controls to ensure the accuracy of the data.
  • Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
  • Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Microsoft Visio.
  • Good knowledge of Software Development Life Cycle SDLC .
  • Developed AdHocSSRS reports for the users for analysis purpose
  • Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2012/2008.
  • Experience in Creating Roles and Assigning Permissions to the users.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
  • Defined Key Performance Indicator metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2012, SSIS, SSRS, T-SQL , Visual studio 2005/2008, Tortoise SVN

Confidential

SQL Server BI Developer

Responsibilities:

  • Core member of project team worked in all stages of the project, from requirement gathering to production deployment, defining requirements, project planning, development, testing, and production implementation
  • Developed standards and guidelines to maintain and develop SSIS packages and Data Flow Diagrams
  • Created SSIS packages and automated jobs to monitor, backup, import/export data for data warehouse extracts
  • Performance optimization of the SSIS packages that are built to load large flat files to the database tables
  • Implemented Parallel processing in SSIS packages to reduce the package run time
  • Developed complex stored procedures and functions to extract the data.
  • Developed, and scheduled variety of reports like List, Matrix and Sub Reports with SSRS
  • Maintaining database integrity and consistency schema data changes and database design
  • Acted as single point of contact for support of SSIS packages in production. Collaborated with external teams and partners to resolve production issues
  • Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization
  • Manage and schedule SQL Agent jobs to import and export terabytes of data to external data warehouse and Mainframe systems
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Promoted database objects to development, test, and production environments Played Key role SQL Developer in building Enterprise Data Ware House

Environment: SQL Server 2008/2008r2, T-SQL, Data Transformation Services DTS , Integration Services SSIS , IBM ClearQuest , Query Analyzer, SQL Profiler Enterprise Manager SEM , , Microsoft BI Studio 2008

Confidential

SQL Server BI Developer

Responsibilities:

  • Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services SSIS .
  • Created the automated processes for the activities such as database backup processes using the Integration Services.
  • Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
  • Created complex stored procedures and functions to support efficient data storage and manipulation.
  • Created procedures to test the existing of database objects and tested the existence of database objects in production before releasing the systems.
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
  • Monitored the performance of SQL Server using SQL Server Profiler
  • Wrote user reports on SSRS to retrieve information from the Sales Page database.
  • Worked with Application Teams on creating a productive Development, Test and Production environment for Application Databases.
  • Helped in designing and developing the database using normalization techniques.

Environment:SQL Server 2000/2005, T-SQL, Data Transformation Services DTS , Integration Services SSIS , Query Analyzer, Enterprise Manager, Business Intelligence Development Studio

Hire Now