We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

NJ

SUMMARY:

  • ETL implementation using SQL Server Integration Services SSIS in OLTP and Data warehouse Environment.
  • Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Very Good Understanding and Experience in SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • SQL Server 2005/2008/2012 RDBMS database development including T-SQL programming.
  • Working Experience on SQL 2000/2005/2008/R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
  • Around 8 years of IT experience in the Analysis, Administrating, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
  • Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.
  • Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schema using SQLServer Analysis Services SSAS .
  • Expert in performing ETL operations using various tools such as SQL Server Integration Services SSIS , DTS, Bulk Insert and BCP.
  • Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports using SSRS.
  • Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Hands on experience in installing, configuring, managing and troubleshooting SQL Server, and have excellent communication and analytical skills, understands business requirements in various domains.
  • Experience in developing Life Cycle using Agile Methodology.

TECHNICAL SKILLS:

  • Databases : MS SQL Server 2008, 2008 R2, ORACLE
  • Database Tools : MS SQL Server 2008/2008 R2, SSIS, DTS, SSAS, OLAP, and BIDS
  • Development skills : T-SQL, PL/SQL, SSIS/SSRS/SSAS
  • Languages : COBOL, CICS, JCL, MVS, PL/SQL, T-SQL, SSAS, OLAP, C, C ,
  • Reporting Packages : SQL Server Reporting Services, MS Excel
  • Tools/Methodologies : MS Visio, MS Project, SQL Profiler, MS Office

PROFESSIONAL EXPERIENCE:

Confidential

Role: SQL Server Developer/SSIS/ BI developer

Responsibilities:

  • Created several prototypes using MS Access.
  • Developed several data mapping documents and data mining SSIS transformation documents according to protocols.
  • Created Queries in T-SQL, tables and stored procedures, and Views to store the data of clients using SQL Server 2008 R2.
  • Developed Report Models in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS of Visual Studio 2008.
  • Wrote different complex SQL queries including inner, outer join and updated queries.
  • Developed reports for payment and BI Count to show organizational and seasonal comparison.
  • Created several SSIS jobs and packages and executed those tasks.
  • Developed DTS packages to extract, transform and load into the database from OLTP database using SQL Server 2008 R2 Integration Services SSIS .
  • Creation and scheduling of Maintenance plans database and log backups and cleanups , DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
  • Loading data to the destination base tables.
  • Involved in Data scrubbing/Cleansing/Validating/Translating and scheduling SSIS packages.
  • Developed windows schedule tasks for different data pulls and directly populate data to SQL Server by creating several ODBC connections.
  • Transformed data from various data sources using OLE DB connection by creating various DTS /SSIS packages.
  • Installed and Configured SQL Server 2008 R2 and also Upgraded the existing database to SQL Server 2008 R2.

Environment: Microsoft SQL Server 2008R2, SQL Server Reporting Services SSRS , Management studio, Visual Studio 2008, XML, SQL Server Integration Services SSIS , Windows Server XP.

Confidential

SQL/SSIS Developer

Responsibilities:

  • Created tables, indexes and constraints.
  • Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
  • Migrated SQL Server 2000 DTS packages to SSIS 2005.
  • Developed SSIS 2005 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
  • Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
  • Developed, deployed and monitored SSIS Packages.
  • Developed custom reports and deployed them on server using SSRS.
  • Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
  • Formatted reports using Global Variables, Expressions and Functions for the reports.
  • Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
  • Configured Report Model for developing ad-hoc reports by the end-users.
  • Uploaded reports on to the report manager and organized them into folders.
  • Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
  • Automate and enhance daily administrative tasks, including space management, object alteration, backup recovery and performance monitoring.
  • Assisted in the application development, debugging, configuration, and optimization from database perspective.
  • Involved in implementation of replications like Snapshot and Transactional.

Environment: MS SQL Server 2005, 2008, DTS, SSIS, SSRS, PPS, T-SQL, ETL, Excel, Visual Studio 2008.

Confidential

Role: Software Test Programmer Bilingual

Responsibilities:

  • Participating in reviews with Team members. Manual testing was done to check the functionality of the application.
  • Developed functional and GUI Test cases. Prepare the Test data as per client requirement. Tracked the results and reported the system defects and bugs.
  • Involved in preparation of test reports. Developed test scripts for the requirements.
  • Involved in Regression testing, System testing, Integration testing and Batch Testing.

Tools and Technology: Windows NT, C program, DB2, WinRunner 4.0.

Confidential

Role: SQL Server Developer

Responsibilities:

  • Designed and created SQL Database, tables, indexes, and views based on user requirements.
  • Created User Defined Functions, cursors, and Triggers.
  • Created used stored procedures for database transactions in SQL Server.
  • Created tables, views, clustered non-clustered index, user defined data types and functions.
  • Developed stored procedures and views for managing efficient data retrieval.
  • Wrote various Stored procedures for the purpose of application development
  • Developed backup restore scripts for SQL Server as needed.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Used multiple join statements to retrieve data from multiple tables.
  • Worked in the team for gathering and analyzing the needs of end user requirements.
  • Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Environment: MS SQL Server 2000/2005 Enterprise Edition, MS Access, MS Excel, DTS, SQL Profiler, PL/SQL.

Hire Now