We provide IT Staff Augmentation Services!

Sql Server Developer Resume

0/5 (Submit Your Rating)

Nashville, TN


  • Around 7 plus years of experience in Database Development of MS SQL Servers 2000/2005/2008, in Production, QA, and Development environments.
  • Extensive experience in MS SQL Server 2008 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services
  • Very good understanding of SQL Server Architecture design.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.
  • Experience in Creating SSIS and DTS package development and implementation for different tasks.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
  • Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
  • Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
  • Expert in creating SQL Server Reports using SSRS 2005 in designing stylish report layout parameterized, performance, Chart Reports, ad - hoc reports.
  • Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
  • Experience in report writing according to the business requirement in SSRS.
  • Very strong experience in ad-hoc reports, Tabular and Charts reports in SSRS.
  • Experienced in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts
  • Familiar with OLAP cubes and fact table, star and snowflake schemas
  • Using Data Mining Wizard and Designer to Design, Manipulate models.
  • Strong experience in design and construction of data marts, data views and data mining.
  • Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Very good experience in Installation, configuration and maintenance of SQL Server.
  • Experience in backup and disaster recovery procedures.
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Used Microsoft Source Safe for version control and configuration management.
  • Strong communication skills and ability to work in a team and individually.


Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/Vista, Linux, UNIX

Languages: C, C++, T-SQL, PL/SQL, VB, C#.NET, ADO.NET, JAVA

RDBMS: Microsoft SQL Server 2000/2005, MS Access, Oracle 10g

IDE: Microsoft Visual Studio 2003/2005

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Export & Import (DTS), SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Web Technologies: HTML, JavaScript, PHP, ASP.NET, ColdFusion

Other Tools: ERwin, MS Visual SourceSafe, VERITAS Backup Exec 10, MS Office suite, MS Visio, SPSS


Confidential, Nashville, TN

SQL Server Developer


  • Create joins and sub-queries for complex queries involving multiple tables.
  • Generated dynamic stored procedures, triggers for the database development.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
  • Involved in Report writing according to business requirment using SSRS and Crystal Reports.
  • Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
  • Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
  • Worked on .Net data access layer and ADO.Net and developed various clauses to connect to database with the front end pages.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Configure the report server and generated the report models for user interactions.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
  • Developed unit test plans for SSIS packages.
  • Involved in migrating data from MS SQL server 2005 database to MS SQL server 2008 database.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
  • Hands on experience in SSAS (SQL Server Analysis Service) with MDX.
  • Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS)
  • Created MDX queries to extract data from the data mart.
  • Involved in building an extensive OLAP data warehouse on SQL Analysis services (Cubes, stars schema)
  • Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
  • Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
  • Created reports to retrieve data using stored procedures that accept parameters.
  • Responsible for monitoring and tuning SSRS Report Performance.
  • Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server.
  • Experience in creating SSIS packages using different type’s task and with Error Handling.
  • Fine tuned the complex database stored procedures and increase performance up to 5%.
  • Taking weekly database backup and schedules job using SQL Agent.
  • Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Environment: MS SQL Server 2005/2008, Management Studio, ETL, DTS, Erwin, Oracle 10g, Notification Services, Crystal Reports, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS, community server, Erwin.


SQL Server BI/SSAS Developer


  • Provided recommendations and guidelines for development of ETL, Analytical & Decision Support system based on SQL Database Warehousing using presentations, demos and meetings.
  • Involved in Logical and physical design of the data warehouse and ODS in SQL Server 2008 using Star Schema.
  • Responsible for Data mapping document: Source/Transformation/Destination.
  • Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Migrated DTS packages from SQL Server and scheduled their execution time.
  • Loading data from various sources like Excel, flat files to SQL Server database Using SSIS Packages.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Involved in taking backups of SSAS database and restoring them when needed.
  • Worked on SQL Server Analysis Service and participated in creation of Dimensions, Cubes and Partitions on Cubes, Develop KPIs and Calculations for various Measures.
  • Helped in creating new component in SSIS called Partition Tasks that creates partitions for the Cubes and drops partitions based on some criteria.
  • Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.
  • Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
  • Designed dynamic reports on the newly developed ERM Model for financial data users using SSRS.
  • Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
  • Worked with SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
  • Created user groups in Report Manager for limited access to the end users in SSRS.
  • Developed Ad Hoc Report Model for specific users is SSRS.
  • In SSAS, created cubes on top of the data warehouse for reporting purpose and wrote MDX.
  • Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
  • Created multiple 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 with various security standard.
  • Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
  • Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSRS, SSIS, T-SQL, SSRS, Windows Server 2008, Oracle 10g..

Confidential (Houston, TX)

SQL Server Developer Contract


  • Installed and Configured SQL server 2005 on windows 2003 advance server system.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user .
  • Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
  • Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
  • Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and DHTML.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Involved in Report writing according to business requirement using SSRS and Crystal Reports.
  • Used the Report Manager to Create folder structures, modify data sources, Controlling access to Report Services resources
  • Optimized query performance by creating indexes.
  • Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Provided support to the application developers on the application databases.
  • Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.

Environment: MS SQL Server 2005, Enterprise Manager, Management Studio, Integration Services, Reporting Services, SSRS, T-SQL, DB2, Windows 2003, Tuning Advisor, ETL, SQL Profiler, SQL Server Agent, Data ware Housing, BCP, and Visual Basic 6.0.

Confidential (Framingham, MA)

SQL Server Developer (SSIS/SSRS/ASP.Net) Contract


  • Designed and developed several Reports using SSRS (SQL 2005 reporting services) according to business requirements.
  • Creating complex SQL Queries to partition and aggregate the data based on cookie and session ids of millions of visitors.
  • Creation of temporary tables, efficient index mechanisms and optimizing joins to match the performance expectations of the system.
  • Multiple stored procedures with transaction processing for different modules.
  • Creation of tables, mapping of page ids to the product line categories and the sources of information.
  • Creation of SSIS packages to request a dump of weekly page views from Staples databases to our databases.
  • I worked on authenticating users and providing on-demand reports using server-side scripting with ASP.Net (VB Script). It involved connecting to database, calling queries and stored procedures, displaying forms and tables and implementing means for navigation to different reports.
  • Identified the data source and defined them to build the data source views.
  • Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
  • Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
  • Designed and created drill down reports in SSRS 2005.
  • Identified and worked with parameters for parameterized reports in SSRS 2005.
  • Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005.
  • SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
  • Designed ad-hoc reports using Report Model and configured using Report Manager.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Windows XP


SQL Server/Application Developer Contract


  • Involved in Data modeling to develop the database design using Erwin 4.0
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user .
  • Actively involved in Normalization & De-normalization of database.
  • Designed DDL and DML for MS SQL Server 2000.
  • Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types and user defined functions.
  • Actively designed the database to fasten certain daily jobs, stored procedures.
  • Optimized query performance by creating indexes.
  • Involved in writing SQL batch scripts.
  • Write T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Developed complex stored procedures to create various reports.
  • Configuring, tuning, and optimizing SQL Server 2000.
  • Developed complex financial reports using Crystal reports.

Environment: SQL Server 2000/7.0, T-SQL, Stored Procedures, Windows XP, Crystal Reports 9, ASP.NET 1.1, IIS3.0.


Software Engineer


  • Involved in requirements gathering, analysis, design, development, change management, deployment and user .
  • Perform quality assurance and testing of SQL server environment.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Documented and maintained database system specifications, diagrams, and connectivity charts.
  • Provide database coding to support business application with T-sql.
  • Participated and trained in designing of website using .net application for clients.
  • Supported developer team and DBA in Configuring replication, tuning, and optimizing SQL Server 2000.

Environment: SQL Server 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, T-SQL, BCP, Replication.

We'd love your feedback!