We provide IT Staff Augmentation Services!

Sr. Sql Server Developer Resume

Morrisville, NC

SUMMARY:

  • Over 5+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL, Reporting and Analysis of data using MS Business Intelligence initiatives.
  • Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) 2012, 2008 R2, 2005.
  • Familiarity with Star and Snowflake schema data modeling techniques for OLAP database design.
  • Proficient in database modeling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
  • Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front - end, web and reporting applications.
  • Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
  • Proficient in Debugging, Testing, Deploying Complex Stored Procedures and different Database Objects across various SDLC environments.
  • Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
  • Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
  • Have hands on experience and proven track record of expertise with performance tuning.
  • Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
  • SQL Server RDBMS database development including T-SQL programming.
  • Involved in entire Software Development Life Cycle (SDLC) from business analysis to final deployment and testing.
  • Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
  • Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms and Exceptions.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
  • Excellent problem solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, C, C++, XML, HTML, DHTML, HTTP.

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000, Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Packages: Microsoft Office Suite 2007/2010/2012/2016

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 7/10,MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Sr. SQL Server Developer

Responsibilities:

  • Worked on a Government HealthCare Services project
  • Worked as a shared resource for both Development as well as Production support based on need basis and priority of requirements.
  • Worked as an ETL resource maintaining and monitoring the application workflows,dashboard integrated reports and scheduled sharepoint upload of reports.
  • Worked on T-SQL programming, stored procedures and views in the processing of developing reports. Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
  • Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources such as flat files, csv files, D-mart repositories.
  • Used BIDS to create parameterized reports and exported reports in excel
  • Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
  • Involved in code review and preparing unit test cases.
  • Created Joins and Sub-Queries for complex queries involving multiple tables.
  • Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
  • Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Used SQL Profiler for monitoring the SQL statements and procedures.
  • Discussed and gathered requirements from Product and Account team for new developments related to SSRS reports or new data loads to database through ETL processes.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2012/2008 R2/2005, IIS, SharePoint, VB.Net scripting, SSIS, SSRS, T-SQL, Visual Studio 2008/2012/2013 Indexes, .Net Framework 3.5, 4.0, backup/restore, MS Office suite 2016

Confidential, Newport Beach, CA

Oracle Database Developer

Responsibilities:

  • Created PL/SQL packages, procedures, functions applying the business logic to update the database with customer applications from dealers and to decision contracts.
  • Created custom triggers to automatically populate different tables.
  • Created the custom tables to import the data of customers, dealers and credit bureau records.
  • Deployed naming standard to the Data Model and followed company standard for Project Documentation
  • Improved the performance of large queries to improve the response time of the application.
  • Requirement gathering with Business partners, analysts and end users.
  • Wrote two major packages to populate credit bureau tradelines and collections records of customer applications received by Dealers
  • Worked on extracting data from XML and insert into respective tables
  • Responsible for resolving the issues involved with the application in testing phase.
  • Rewrote existing Procedures and Packages using Collections for better performance and tuned existing queries in the procedures.
  • Wrote very complex queries to provide data in fewer amounts of DB calls
  • Supported various data change and enhancement change requirements from dealers, by modifying respective packages and procedures.
  • Involved in preparing functional document, user document, process flow diagram and flow charts.

Environment: Oracle 11g, SQL*Plus, PL/SQL, Oracle Forms, XML,SQL Developer, Serena PVCS, Win-SCP, Citrix

Confidential, San Diego, CA

SQL Server Developer

Responsibilities:

  • Worked with business gathering requirements.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
  • Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Deployed different SSIS packages on test and production servers.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
  • Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
  • Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
  • Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
  • Created Joins and Sub-Queries for complex queries involving multiple tables.
  • Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
  • Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Created Linked Servers to retrieve data from other databases.
  • Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
  • Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
  • Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
  • Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
  • Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

  • Worked with business gathering requirements.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
  • Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Deployed different SSIS packages on test and production servers.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
  • Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
  • Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
  • Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
  • Created Joins and Sub-Queries for complex queries involving multiple tables.
  • Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
  • Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Created Linked Servers to retrieve data from other databases.
  • Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
  • Involved in preparing detailed technical documents.
  • Involved in code review and preparing unit test cases.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Hire Now