We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

Summary

  • Over 7 Years of IT experience which includes System Analysis and Design, Development Support of MS SQL Servers 2008 R2/2005 in Production, QA and Development Environments.
  • Experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
  • Experience in Managing Security of SQL Server 2005/2000 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
  • Strong experience with T-SQL DDL DML in Implementing Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating Updating tables and checking the database consistency by executing DBCC Commands.
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server 2005 Reporting Services SSRS , SQL Server 2005 Integration Services SSIS in Business Intelligence BI .
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
  • Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS 2000 and SQL Server Integration Services SSIS 2005 .
  • Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
  • Ability to work in all stages of System Development Life Cycle SDLC .
  • Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports ex: drill down reports using different objects using SSRS.
  • Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Experience in .NET/C application development environment to use SQL Server Databases.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
  • Worked with Business Analysts, Web development team, and users on database solutions.

Technical Skills:

Operating System

Databases

Programming Languages

Business Tools

Database Tools

Reporting Tools

ETL Tools

Data Modeling

MS Tools

Internet Tools

Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, Windows 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

MS SQL Server 2008 R2/2005/2000, MS Access, My SQL

T-SQL, C, C , Shell Scripting, SQL, XML, C , VB.NET, MDX

Word, Excel, PowerPoint, Access, Visio, Outlook.

SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS,SSAS,Index Analyzer, SQL Client Utility.

Reporting Service SSRS 2005/2008 R2.

DTS, SSIS.

Erwin v 4.0, Visio 5.0

Management Studio, Visual Studio.

Internet Information Server IIS 5.0 / 6.0 , FTP,TCP/IP

Professional Experience:

Confidential

SQL Server/BI Developer SSIS, SSRS, SSAS

Responsibilities:

  • Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
  • Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for Warehouse system.
  • Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
  • Performance tuning of Queries and Stored Procedures.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Implemented query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services SSRS .
  • Designed ETL structures for data imports from various sources such as Oracle, Tera Data, Excel, Access and DB2.
  • Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
  • Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Created several database constructs such as views, triggers and extensively worked on performance tuning.
  • Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Created Tabular, Matrix reports also called as crosstab or pivot , Charts and graphs as per customer requirements Using SSRS.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker.

Confidential

SQL Server/BI Developer SSIS, SSRS, SSAS

Responsibilities:

  • Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
  • Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for Warehouse system.
  • Extensively used T-SQL to manipulate and architect to produce results for users.
  • Performance tuning of Queries and Stored Procedures.
  • I Used SQL profiler to view indexes performance to mostly eliminate table scan.
  • Worked with development teams in the design of physical databases and in modification.
  • Creating Tabular, Matrix reports also called as crosstab or pivot , Charts and graphs as per customer requirements Using SSRS.
  • Good understanding of Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
  • Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services SSRS .
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Created ETL SSIS packages both design and code to process data to target databases.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SQL Server Management Studio.

Confidential

SQL BI Developer

Responsibilities:

  • Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Converted ETL from DTS to SSIS.
  • Extensively used T-SQL to manipulate and architect to produce results for users.
  • Worked with development teams in the design of physical databases and in modification.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
  • Creating Tabular, Matrix reports also called as crosstab or pivot , Charts and graphs as per customer requirements Using SSRS.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Actively engaged in client meetings in requirement gathering and development updates.
  • Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
  • Good understanding of Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential

MS SQL Server Developer SSRS/SSIS

Responsibilities:

  • Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
  • Streamlined database design process using creation of table structures in 3NF using DDL statements using T-SQL.
  • Facilitated constraints such as Primary, foreign, default, unique and Not Null.
  • Implemented Set-based DML statements such as set-based update and delete statements.
  • Creation of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
  • Wrote complex T-SQL batches with Common Table Expressions CTE's for recursive operations.
  • Offered production support at regular periods for migration and data issues.
  • Developed re-usable stored procedures for database application support.
  • Created several database constructs such as views, triggers and extensively worked on performance tuning.
  • Wrote complex nested Case structures to implement complex business logic.
  • Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
  • Wrote complex stored procedures for streamlining incremental data loads using left join.
  • Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Designed ETL structures for data imports from various sources such as Oracle, Tera Data, Excel, Access and DB2.
  • Implemented Data Warehouse ETL design structure utilizing Star Schema. Designed and developed Fact and Dimension structures for various types of data related health information of the patients.
  • Actively engaged in client meetings in requirement gathering and development updates.
  • Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
  • Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
  • Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variable such as PackageName, PackageStartTime, etc.
  • Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
  • Implemented SSIS and T-SQL executions as jobs under SQL Agent.
  • Implemented system stored procedure sp send dbmail for notifications upon encountering job failures by sending notification emails for distribution lists.
  • Actively utilized Microsoft Team Foundation Server and its features for code sharing and updates from other team members.
  • Designed archive structure for error logs for auditing purposes using T-SQL and Integration Services.
  • Proficient in writing distributed queries such as openrowset using Linked Servers in T-SQL.
  • Extensively used T-SQL Pivot and Unpivot for de-normalizing and normalizing source data for designing daily data loads for Warehouse.
  • Analyzed existing stored procedures using DB Tuning advisor for performance improvements.
  • Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Microsoft Excel and Access.

Confidential

SQL Server/BI Developer SSIS, SSRS, SSAS

Responsibilities:

  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint/Moss2007 integration.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
  • Generated Custom ETL scripts using SSIS 2005 and develops and unit test SSIS load processes for performance check.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created various complex reports and manage them using SQL Server Reporting Services SSRS 2008/2005 according to ERLC.
  • Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
  • Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Wrote and integrated stored procedures to generate the special reports according to client's need.
  • Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008,SQL BI Suite SSIS, SSRS , Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 Windows Server 2003.

Confidential

MS SQL Server/BI Developer

Responsibilities:

  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • Constructed OLTP and OLAP Databases.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Implemented different types of constraints on tables.
  • Designed and applied entity and attributes description and definition for the models.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Migrated DTS objects to SQL Server Integrated Services SSIS environment.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Responsible for gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
  • Developed optimal stored procedures and queries to create data sets for reports.
  • Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
  • Developed Cube with Star Schema.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005/2000, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, WindowsXP/2000.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in various stages like development, system Analysis design, and creating stored Procedures.
  • Designed and developed Interfaces which were used for connecting to SQL Server database.
  • Validated and coded the application using VB.
  • Debugged and fixed the bugs.
  • Designed the Logical and Physical databases of SQL Server.
  • Performed database testing maintaining the data by using the procedures.
  • Designed and validated the forms according to client requirement by using VB.
  • Imported and Exported database using DTS utility.
  • Wrote SQL stored procedures to implement business logic.
  • Developed and coded applications in T-SQL. .
  • Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.

Hire Now