We provide IT Staff Augmentation Services!

Ms Sql Server Developer Resume Profile

IA

Professional Experience:

  • Over 7 years of IT experience as SQL developer in design and development of various applications for Retail, Financial, Insurance, and Manufacturing Industries.
  • Designed and developed routines for doing statistical analysis of research date. Created complicated SQL procedures as stored procedures to meet the requirements of the systems being developed.
  • Extensive exposure to creation of databases, objects, stored procedures, triggers, security, SSIS i.e. Import and Export , Bulk Loading of Data, Transact-SQL, and SQL Server Agent and SQL Server profiler.
  • Experience in designing InfoPath forms, form templates, template parts, master-detail forms and integration of these forms with Microsoft Outlook, SharePoint.
  • Migration of database from SQL Server 2008 to 2012.
  • Experienced with scripting in T-SQL in constructing tables, joins, user functions, views, indexes, triggers, synonyms and user profiles.
  • Developed complex stored procedures and queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
  • Experienced working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views.
  • Implemented cursors for rebuilding indexes.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Managed all database servers in development, staging, test and production environments.
  • Experienced in ETL Extracting, Transforming and Loading development using DTS and SSIS for migration of data between legacy systems, ERP to SQL Server 2008/2008R2
  • Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
  • Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
  • Experience in MS SQLServer suite of products like SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS and SQL Server Analysis Services SSAS .
  • Experience in Designing and Building the Dimensions, Fact Tables with star and snow flake schemas using SQL Server Analysis Services SSAS .

TECHNICAL SKILLS:

  • OPERATING SYSTEMS:
  • Windows 95/98/NT/2000/XP, Red Hat Linux and Unix
  • RDBMS:
  • SQL Server 2008/2008R2/2012,Oracle11g/10g/9i/8i,Teradata v2r5 and MS-Excel 7.0.
  • LANGUAGES:
  • SQL, PL/SQL, Transact SQL, Visual Basic, C , C, C , Unix Shell Scripting
  • SOFTWARE/ APPLICATIONS/ TOOLS:
  • SQL Server Management Studio,Enterprise Manager,SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio and Data Transformation Services DTS , Team Foundation Server
  • WEB TOOLS
  • HTML, XML
  • Data Warehousing
  • OLAP, OLTP, Star Schema Modeling, FACT and Dimension Tables

PROFESSIONAL EXPERIENCE:

Confidential

Role: MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Design and Developmentof SSIS Packages to import data from Oracledatabase in form offlat files,transform and load data into SQL Server database.
  • Transformation of Data into SQL Server database by development of views, Staging tables and load data into tables using Stored Procedures.
  • UpgradedSSIS packages for an entire Application from 2005 to 2008 using Project wizard and successfully deployed packages.
  • Managed the complete migration of SQL Server 2008R2to SQL Server 2012.
  • Used Automated Processing Environment APE Application for Automating daily SQL jobs and for execution of packages automatically.
  • Developed Package labels for test and production environments and execution of SSIS packages automatically.
  • Provided organizational reporting and timely reports utilizing SSRS SQL Server Reporting Services
  • Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
  • Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.
  • Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshotting via SharePoint User Interface.
  • Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
  • Mainatained and Supported Microsoft TeamFoundation Server TFS to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
  • Created star schema in SSAS and developed SSRS reports based on the cubes.
  • Managed Query Optimization and Performance Tuning of Stored Procedures, Functions and several complex queries.
  • Managed production servers with multiple databases, with a couple over 3 terabytes both in clustered environment with mirroring and replication
  • Wrote triggers After and Instead Of and stored procedures to capture updated and deleted data from OLTP systems.
  • Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
  • Implemented Log Shipping and Transactional Replications as part of disaster recovery plans.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
  • Scheduled jobs for backup, and created alerts for Error reporting.

Environment: SQL Server 2005/2008 R2/ 2012 , Visual Studio 2005/2008/2010, T-SQL, MS Access, MS- Excel, SQL Server Integration Services, SQL Server Reporting Services, SharePoint MOSS,VB.Net,C .Net.

Confidential

Role: MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Involvedin upgrading of SQL Server 2005 to SQL Server 2008
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Designed and developedSSIS Packages to import data and export data from MS Excel, flat files, SQL Server and transform and load data into SQL Server database.
  • While importing data from flat files used various used Error Output Descriptions which manages error outputs from flat files.
  • Updated Package Configurations of entire database from XML Configurations to SQL Server Configurations so as to assist in execution of packages in development, test and production environments.
  • Provided organizational reporting and timely reports utilizing SSRS SQL Server Reporting Services
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data
  • Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
  • Conversion of MS Access Scripts into Transact-SQLScripts
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • 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: Windows 2007,SQL Server 2008 R2 , Visual Studio 2008, T-SQL, MS Access, MS Excel, SSIS, SSRS, SharePoint MOSS,BIDS,C .Net

Confidential

Role: SQLServer Developer

Responsibilities:

  • Maintained and supported Microsoft Team Foundation Server TFS to allow for a secure code in a multi-team environment.
  • Created database architectures and designs in SQL Server 2005.
  • Experienced with transactional and merge Replication in SQL server 2008.
  • Designed reports in Crystal Reports, Ad Hoc, and Custom Analytics.Customized Cover Page and Table of Contents for report packets.
  • Built signature image files in Crystal Reports that would insert a signature on a Purchase Order based on approver.
  • Defined and Implemented Processes and Procedures for QA Departments
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Identify and recommend database techniques to support business needs.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
  • Deployed different SSIS packages on development and test environments.
  • Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
  • Designed Report Templates, Bar Graphs and Pie Charts based on the sales data.
  • Worked on querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email.
  • Defined Report Layouts for formatting the report design as per the need.
  • Generated test data and tested new database consistency with existing databases.

Environment: Windows 2007, DB2 Version 8 EE/EEE/WSE SQL Server 2008 Enterprise Manager, Visual Studio 2005, T-SQL, MS Access, MS Excel, SSIS, SSRS, SharePoint MOSS,BIDS,C .Net

Confidential

Role: MS SQL Server /SSIS/SSRS Developer

Responsibilities:

  • Created SQL Server Reports using SSRS 2008.
  • Identified the Data Source and defined them to build the Data Source Views.
  • Developed Query for generating drill down reports in SSRS 2008.
  • Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Deployed the generated reports directly on the client's workstation.
  • Responsible for transferring the data using SSIS packages.
  • Developed, monitored and deployed SSIS packages.
  • Analyzed reports and fixed bugs in stored procedures.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Implemented different types of constraints on tables.
  • Designed and applied entity and attributes description and definition for the models.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Monitored Scheduled jobs and alerts.
  • Migrated reports from Cognos EP Series 7 to Cognos 8 Environment.
  • Upgraded reports from 8.3 to 8.4.

Environment:

MS SQL Server 2008/2008 R2, DB2 Version 8 EE/EEE/WSE, Erwin4.1,Cognos8.4/8.3,CognosEPseries7.3

Confidential

Role: SQL Server Developer

Responsibilities :

  • Designed reports in Crystal Reports, Ad Hoc, and Custom Analytics.Customized Cover Page and Table of Contents for report packets.
  • Built signature image files in Crystal Reports that would insert a signature on a Purchase Order based on approver.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Resolve any database issues in accurate and timely fashion.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates
  • Oversee utilization of data and log files.
  • Created reports on SQL server reporting services 2008.
  • Built reports through Report Builder and Report Designer.
  • Created reports using Report Model and applying row level security filters.
  • Studied the existing OLTP system s and created facts, dimensions and star schema representation for the data mart.
  • Designed and developed OLAP Cubes in SSAS.
  • Integrated SQL Server 2008 Reporting Services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point Portal SSRS .
  • Worked on PROCLARITY to create cost effective reporting and analytical solution.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Designed, built the dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
  • Worked on Cube structure optimization for MDX query performance in Analysis Services 2005 SSAS .
  • Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
  • Migrated DTS packages from SQL Server 2005 to 2008 and scheduled their execution time.
  • Created SSIS packages using Active X scripts and with Error Handling.
  • Enhanced and deployed the SSIS Packages from development server to production server.
  • Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
  • Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
  • Used T-SQL for creating stored procedures, indexes, cursors and function.

Environment:DB2 Version 6 - OS/390,Z/OS,SQL Server 2008, Microsoft Share point Portal Server,Crystal Reports 8.5/Xi, SQL Diagnostic Manager, SQL LiteSpeed

Confidential

Role: SQL Server BI Developer

Responsibilities:

  • Involved in all phases of SDLC, and gathered business requirements from business people.
  • Design/develop database using SQL SERVER 2005/2008.
  • Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
  • Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.
  • Developed SSIS Packages using xml, ADO.NET, OLEDB, file system, Active X script, Look up tasks.
  • Designed high level ETL architecture for overall data transfer from the OLTP toOLAP with the help of SSIS.
  • Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services SSRS .
  • Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
  • Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
  • Deployed SSRS Reports in SharePoint Environment.
  • Created OLAP Cubes and Dimensions using SSAS in data warehouse environment.
  • Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
  • Scheduled Complex Stored Procedures using SQL Server Agent.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard,MS SQL Server Integration Services SSIS ,MS SQL Server Reporting Services SSRS ,SQL Server Analysis Services SSAS , SharePoint Moss 2007, Windows XP

Confidential

Role: SQL Server Developer

Responsibilities

  • Understanding the customer requirements, analysis, design, development and implementation into the system.
  • Created complex conceptual database designs in SQL Server 2000/2005 using various constraints procedures and queries in T-SQL.
  • Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
  • Migrated data from different sources text based files, Excel spreadsheets and Access to SQL Server databases using SQL Server Integration Services SSIS .
  • Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
  • Used custom .NET assemblies for Script Task in SSIS.
  • Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through and Sub Reports
  • Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
  • Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
  • Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.
  • Maintain Disaster recovery strategies for the database and fail-over methods.

Environment: SQL Server 2005, SSIS, SSRS, Oracle 9i/10g, ASP .Net, Visual Studio .Net, UNIX, Windows XP.

Hire Now