We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

CA

Summary:

  • Eight years of experience in SQL SERVER 2000/2005/2008/R2/2012
  • Experience in writing stored procedures, user defined functions, views, query writing.
  • Extensive experience in installation and configuration of MS SQL Server SQL SERVER 2000/2005/2008/R2/2012 versions.
  • Ability to work in all stages of System Development Life Cycle
  • Solid experience in RDBMS database design, installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full Software Development Life Cycle.
  • Experience in Tuning SQL queries and improving the performance of the Database.
  • Excellent experience of T-SQL
  • Experience in creating XML using Stored Procedure and User Defined Function.
  • Created complex DTS Packages for Data Migration and Transformation using SQL Server 2000
  • Excellent knowledge in transforming data from one server to other servers using tools like Bulk Copy Program BCP and Data Transformation Services DTS .
  • Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
  • Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
  • Experience in creating Clustered and Non Clustered indexes on tables.
  • Experience in Integration, Reporting and Analysis Services such as SSIS, SSRS and SSAS.
  • Experience in writing and debugging stored procedures and triggers.
  • Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Worked with Business Analysts, Web development team, and users on database solutions.
  • Provided after hours and production support, when needed.
  • Excellent problem solving skills for delivering useful and compact solutions. Always keen and eager to face up to challenges by means of innovative ideas.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
  • Experience with software development life cycle SDLC and project management methodologies
  • Up to par with performance, scalability, high availability, security and compliance best practice guidelines in database design, performance tuning, implementation, and maintenance in a SQL Server 2005 environment
  • sStrong conceptual, analytical, and design skills. Good communication skills with leadership qualities
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Technical Skills

  • Languages : C, C , T-SQL, PL/SQL
  • RDBMS : SQL Server SQL SERVER 2000/2005/2008/R2/2012, Oracle 9i and MS Access 2000/97
  • Web Technologies : ASP.Net, VB.Net, HTML, JSP, JDBC and XML
  • Scripting Languages : JavaScript, VBScript
  • Operating Systems : Windows XP/Advance/2000/2003/NT
  • SQL Server Tools : Enterprise Manager, Profiler, Query Analyzer, Export Import DTS ,
  • BIDS, Service Broker, SSIS, SSRS and SSAS

Professional Experience

Confidential

SQL Server Developer

Confidential is aimed at implementing a packaged software namely HighJump for managing all the aspects of the warehouse. Orders received from various sources like B2C, B2B, EDI orders etc... Are transmitted from in-house ERP FoxMain to the HighJump WMS system

Responsibilities:

  • Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF's
  • Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
  • Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
  • Conversion / Migration of SQL Server 2005 to SQL Server 2008
  • Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
  • 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 integration
  • Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic VB scripts
  • Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
  • Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
  • Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
  • Implemented free text parser for FTP and web data feed in C .Net
  • Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
  • Involved in migration and conversion of Reports from SSRS 2005 to 2008
  • Created Parameterized, Cross-Tab, Drill Down Drill Through reports by using SSRS 2005/2008
  • Created report models for the ad-hoc reporting of the end users using Report Builder
  • Deployed SSRS reports in share point for web based access for multiple end users
  • Documented all the migration process documents for future reference
  • Involved in complete Software Development Life Cycle SDLC , which includes requirement gathering, analysis, design, development, and Implementation
  • Successfully tested all task in staging and stored all versions of data using team foundation server TFS .
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

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

Confidential

SQL Server Developer

  • Sales Management Compensation System SMCS calculates commissions for the following Verizon and Verizon Business sales channels/organizations: Premier, Corporate, Federal, System Integrators, Government and Education, Specialized Services, Business Application Solutions, Customer Service, Prepaid, Agents, and others.
  • It receives order entry and billing data 'billed revenue' from multiple upstream systems, and keeps track of who sold or is being paid on each account/product, calculates commissions, bonuses, and chargeback's, and sends payment information to the Verizon Business payroll systems

Responsibilities:

  • Created new tables, views, stored procedures, user defined functions and triggers in development.
  • Worked closely with Web Developers and Business Analysts to produce all required documentation.
  • Handled database objects with Enterprise Manager and Query Analyzer.
  • Created DTS packages for data loads.
  • Used Data Transformation Services DTS to populate data from various data sources.
  • Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and stored procedures.
  • Modified some of the existing stored procedures and created new stored procedures for the current year to implement business logic.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
  • Dropped and recreated the Indexes on tables for performance improvements.
  • Involved in writing detail design document for future reference.
  • Created DTS packages to load the files feeds into the database.
  • Imported data from text files and excel spread sheets into database using DTS package.
  • Involved in setting up the data for testing.
  • Responsible for moving the database objects from development to testing environment SIT for testing.
  • Responsible for Unit testing and helped the QA team in fixing up the defects at the time of system testing.
  • Used SQL Profiler to optimize queries and enhance the performance of database.
  • Responsible for stored procedures optimization, performance tuning and index tuning.
  • Extensively used SQL Analyzer and Profiler for studying the SQL statements and procedures.
  • Extensive testing on the Performance of the Stored Procedures.

Environment: Windows XP, MS SQL Server SQL SERVER 2000/2005/2008/R2/2012, ASP .Net, T-SQL, DTS

Confidential

SQL Server DBA/Developer

Confidential is one of the leading financial organizations. It offers a range of services and products to its customers such as credit cards, checking, And Savings accounts etc. and has over 200million customers. My role was to develop, implement and maintain all databases including stored and complex queries, which include the various databases in both development and production environment. Focused on maintaining, and optimizing the existing databases

Responsibilities:

  • Installation of MS SQL enterprise servers on test and development boxes
  • Designed and Created databases, tables, views, stored procedures and triggers.
  • Created groups, roles, users and assigning access privileges to users.
  • Database and Log Backups Restoration, Backup Strategies, Scheduling Backups. Backing up master system databases and restoring them when necessary
  • Monitored and scheduled existing/new jobs on production environment.
  • Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers
  • Worked to tune the SQL queries using SQL Profiler.
  • Tested backup and recovery strategies in a test environment before and after moved to production environment.
  • Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones
  • Converting existing DTS Packages to Integration Service SSIS Packages.
  • Deploying database objects from development/testing environment to production environment.
  • Involved in working with SQL Server 2005 BIDS and SSIS Integration Services .
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS
  • Created Reports using SSRS
  • Created cubes to extract some related data quickly by using SSAS.
  • Load data using Bulk Insert.
  • Was Available for support 24/7

Environment: MS SQL Server 2005, MS SQL Server SQL SERVER 2000/2005/2008/R2/2012, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net

Confidential

SQL Server DBA/Developer

Confidential serves over 3 million households and businesses in hundreds of communities in 19 Western and Midwestern states. It provides a full range of commercial individual banking products and services.

Responsibilities:

  • Created and maintained various databases for development and testing environment using SQL server 2000.
  • Performed daily backups and developed recovery procedures.
  • Created and Modified procedures, triggers and functions.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Created used stored procedures for database transactions in SQL Server
  • Created automatically running Stored Procedures and Triggers
  • Create and customize DTS packages and used DTS to load data from different sources.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Extensively used the SQL Analyzer, and Profiler to study the Statements procedures
  • Responsible for stored procedures optimization, performance tuning and index tuning.
  • Setting up logical/physical backups for the newly created databases.

Environment: MS SQL Server 2000, Windows 2000 Advance Server, Query Analyzer, Enterprise Manager, ASP, Visual Basic

Confidential

SQL Server Developer

Sykes Enterprises, Incorporated is a global leader in providing outsourced customer contact management solutions and services in the business process outsourcing BPO arena. It provides an array of sophisticated customer contact management solutions to Fortune 1000 companies and medium sized businesses around the world primarily in the communications.

Responsibilities:

  • Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
  • Involved in gathering and analysis of user requirements.
  • Create functional and technical specifications for projects.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Responsible and for logical and physical design of database.
  • Use Crystal Reports to design and develop reports.
  • Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
  • Bulk data migration using DTS from flat files.
  • Performance tuning and testing on stored procedures, indexes, and triggers

Environment: MS SQL Server 2000, Windows 2000 server, Crystal Reports, VB, Query Analyzer, Enterprise Manager

Confidential

SQL Server Developer

Confidential deals with the consumer products. HLL has various Database applications running across its various Profit Center's Cost Center's. IMAGE is the one of the Database project, which was the most challenging IT projects taken up by HLL at that time.

Responsibilities:

  • Installed SQL Server on Windows 2000 Server.
  • Involved in the Analysis and Design
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
  • Responsible for General Database Administration, Query Performance tuning.
  • Backup recovery schedules, Backup scripts.
  • Worked with DTS packages to load the massaged data into Data warehousing system.
  • Tuned the SQL queries using SQL profiler. Involved in tuning the database.
  • Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows 2000 Server, Query Analyzer, Enterprise Manager, ASP

Hire Now