We provide IT Staff Augmentation Services!

Sr. Sql Server Developer Resume

Rosslyn, VA

Professional summary

  • About 10+ years of experience in IT, as MS SQL Server 2008/2005. Database Developer in Windows environment.
  • Extensive experience knowledge in ETL using SQL Server Integration Services 2005 /2008(SSIS).
  • Experience in Designing and Implementation of Business Intelligence applications using SQL Server 2005 and 2008 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Expert in Creating stored procedures, Views, Indexes and effective User Defined functions and appropriate Triggers to facilitate data manipulation using T - SQL.
  • Experience with Data Transformation Services (DTS) an Extract Transform Load (ETL) tool of SQL Server to populate data from various data sources by creating packages for different data loading operations for each application.
  • Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, Netezza, MS SQL, Excel and MS Access.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2008/2005
  • Experienced in designing and developing large number of enterprise reports (SSRS) using the data from ETL loads and various heterogeneous data sources.
  • Expertise in creating Cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
  • Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
  • Design / develop database using SQL SERVER 2000 / 2005/2008.
  • Expert level skills in Data Modeling, Normalization, Optimization and Performance Tuning.
  • Experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and Tuning MS SQL Server Performance
  • Experience in different team projects with extensive project implementation, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
  • Excellent communication, analytical and inter personal skills and ability to learn new concepts. Experienced in working effectively under pressure in order to meet deadlines in a rapidly changing environment.
  • Ability to learn new languages and tools quickly and efficiently with the ability to work under high pressure distinguishes me from my peers.

Technical Skills

  • Databases - SQL Server 2008 / 2005/2000 , MS Access, Excel., Agresso 5.5
  • Database Utilities - Enterprise Manager, DTS, SSIS,SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Jobs, SSAS.
  • Reporting Tools - SQL Reporting Services (SSRS), Crystal Reports, Business Object.
  • Languages - C/C++, T-SQL, PL/SQL,VB.6, C#, Java Scripts.
  • Operating Systems - Win 2003, Win 2000, Win NT, XP, Mainframes.
  • Application Packages - MS-Office 2003 / 2007 / 2008
  • Web Tools - MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.
  • ERP Solution- Agresso5.5
  • Other Tools - Microsoft Visual Studio 2008/2005/2003
 

Professional experience

Confidential, NJ

Sr. SQL Server Developer

Responsibilities:

  • Gathered requirements from Business and documented them based on functional specifications.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources.
  • Created SSIS package to extract, validate and load data into Data warehouse.
  • Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
  • Created Stored procedure, Views, Cursors and functions to support application
  • Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
  • Implemented multiple grouping into several reports using visibility and toggle options.
  • Actively supported Business users for change requests and provide support to team members.
  • Provided support by troubleshooting and solving the issues.

Environment: MS SQL Server 2008 R2,SSMS 2008, Neteeza,DB2, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010, Star Team.

Confidential, Rosslyn, VA

Sr. SQL Server Developer

Project scope: To Develop a Grant Management application known as CNS for Housing Urban Development (HUD).

Responsibilities:

  • Involved in the information gathering and developed the Multi-Dimensional Data model based on the existing OLTP System and the requirements using ER-Win / MS-Visio and created Requirement Traceability Matrix doc.
  • Worked closely with business unit to understand key business drivers and then identify the individual business metrics and key measures that support them.
  • Created and implemented the staging database prior to the final data warehouse.
  • Extracted the data from the different sources (Oracle and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Created Stored procedure, Views and user defined table type and functions to support application and for Reports back end code.
  • Created SSIS package to extract, validate and load data into Data warehouse. Have used Execute Package task to execute SSIS packages.
  • Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
  • Implemented multiple grouping into several reports using visibility and toggle options.
  • Created Web Pages using java Scripts.
  • Actively supported Business users for change requests and provide support to team members.
  • Provided support by troubleshooting and solving the issues.

Environment: MS SQL Server 2008 R2,SSMS 2008, Visual Source Safe TFS, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010.

Confidential, Frederick, MD

Sr. SQL Server Developer

Project scope: Developed various projects, processes and reports per day to day requirements. Automate the old processes (from sources like Mainframes, Access, and BO) and converted in SQL platform.

Responsibilities:

  • Gathered requirements from Business and documented them based on functional specifications.
  • Created SSIS packages to extract data from OLTP to Data warehouse and scheduled jobs to call the packages.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Created Stored procedure, Views and user defined function. Extensively used Joins also Cross join on the tables for extracting desired data.
  • Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
  • Wrote and modified numerous Stored procedures and Functions and created and modified existing SSRS reports and uploaded them on Repositories.
  • Created complex Drill Down reports, Custom Code functions, Chart Reports, Parameterized and Matrix SSRS reports.
  • Involved in analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Worked on various ADHOC reports request and generated results on Excel and CSV file Reports.
  • Provided support by troubleshooting and solving the issues.
  • Actively participated in review team meetings with Manager to ensure that the development of projects meet business and system requirements also Received appreciation for dedication to service and overall excellent management of assigned duties.

Environment: MS SQL Server 2005,2008,SSMS 2005,2008, Visual Source Safe, EXCEL, Access, Mainframes, Windows 2003 Server, Windows XP Professional, Visual Studio 2005,2008.

Confidential, Wilmington, DE

Sr. SQL Server Developer

Responsibilities:

  • Installed and Configured SQL Server 2005 and Agresso 5.5 ERP system on application server in production and testing.
  • Gathered requirements from accounting department and documented them based on functional specifications.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created Stored procedure, Views and user defined function. Extensively used joins on the tables in joining the data on Agresso5.5 ERP system for various projects.
  • Rewrote the existing ASQL queries according to the requirement and executed them to check the performance.
  • Developed various databases in SQL for testing purpose and creating a staging area.
  • Created, Scheduled and maintained nightly Backup jobs , using SQL Server Agent in SSMS.
  • SQL Server Reporting Services (SSRS) were configured both in standalone and SharePoint Integrated modes.

Environment: MS SQL Server 2005,SSMS 2005, Agresso5.5, Performance Point Server 2007, MOSS 2007, Agresso Report writer, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2005, ASQL, SSIS, SSRS.

Confidential, Jacksonville, Florida

SQL Developer

Responsibilities:

  • Involved in gathering requirements from the finance department.
  • Involved in identifying the source system and creating mapping documents based on the schema comparison from DB2, Excel, CSV and flat files.
  • Created Stored Procedures, views and user defined functions. Extensively used joins in joining the data using T-SQL while designing the SSIS packages.
  • Created complex SSIS packages for processing data and bringing down to staging area for massaging and data scrubbing.
  • Used Conditional split, Derived column and Data Conversion task for cleaning the data.
  • Used Sort task to merge the data and loaded in the final database and event handling and loggings to handle an error.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Created reports, drilldown reports according to requirement for finance team and for day to day analysis purpose by creating store procedure and views and deployed them on SSRS server.
  • Generating ad-hoc reports using Report Builder and Crystal Reports
  • Used Subscriptions to deliver the reports.
  • Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.

Environment: SQL Server 2005/2008 Enterprise Manager, SSIS, SQL Profiler), T-SQL, MS Access, SSMS, Business Intelligence Development Studio/SSIS, MS Excel, MS Word and SQL Server Reporting Services(SSRS) 2008 Crystal Report, Windows.

Confidential, Boston, MA

Project: Data Migration / DDL Support

Role: SQL Developer

Responsibilities:

  • Gathered requirements from business analysts and documented them based on functional specifications.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Developed SSIS packages, architecting the flow of data from various sources such as MS SQL Server 2000, MS Access, MS Excel, CSV files to target (MS SQL Server 2005).
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Created stored procedures to incorporate the flow of business and called various stored procedures from SSIS packages to make the flow of the package effective.
  • Rewrote the existing SQL queries according to the requests made by the clients and executed them to check the performance.
  • Created Clustered and Non Clustered Indexes to optimize the queries performance.
  • Wrote batch files and scheduled jobs to rename and change the location of the files received from the client.
  • Scheduled jobs for executing the stored SSIS packages which are developed to update the database.
  • Provide 24x7 support and ensure that all critical database problems are resolved in timely manner.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL, MS Visual Studio 2005, MS Excel, Windows 2003/2000, VB 6.0, VB.Net.

Confidential, New York

Sr. SQL Developer

Responsibilities:

  • Involved in the requirement gathering phase.
  • Involved in the team for identifying the source system and creating mapping documents and workflows from carrying out the migration of the existing system to the Data-warehouse solution.
  • Used Data Derived task and, Data Mining Query for checking the data consistency in order to load it in Data warehouse dimension tables.
  • Implemented ETL by creating several SSIS packages to load the historical and operational data using full load, sort task and merge as well as incremental loading.
  • Created and designed stored procedure to extract data from different sources and transformed them by using SLOWLY CHANGING DIMENSION, LOOK UP task for comparing and checking if the data exist and merge the data to load in the final database in the staging environment.
  • Designed and implemented SSIS package and stored procedure for loading aggregated and rollup table for cube processing.
  • Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
  • Designed cubes and loaded aggregated tables for the finance team to create expense report and analysis and Deployed cube on the OLAP server.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services(SSRS) and Developed stored procedures and views to generate Drill down reports.

Environment: MS SQL Server 2000/2005, Oracle 9i, T-SQL, SSIS, DTS, SSRS, SSAS, SQL/PLSQL, Profiler, EXCEL, Crystal Report, Windows 2003 Server, Visual Studio 2005.

Confidential, Addison, TX

SQL Developer

Responsibilities:

  • Involved in Creation of database, tables and procedures to update and clean the old data.
  • Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule
  • Created Indexes and Triggers to maintain data referential integrity using T-SQL.
  • Created various parameterized, linked sub reports using MS Reporting Services(SSRS).
  • Implemented ETL by creating the SSIS packages to migrate and load the data
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Actively supported business users for change requests.
  • Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
  • Uploaded reports on to the report manager and organized them in folders.
  • Delivered reports using ‘pulled’ and ‘pushed’ methodologies and formatted them using Global variables and expressions.
  • Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
  • Monitored performance and fine tuned the database objects and server to ensure efficient data retrieval.
  • Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2005 (SSIS, SQL Profiler), T-SQL,MS SQL Reporting Services 2005(SSRS), MS Access 2003, MS Excel, Window 2003.

Confidential, UK

SQL Server Developer

Responsibilities

  • Expertise in entire project life cycle including database Design, Development, Testing, Optimizing, deploying on development and production servers
  • Actively Expertise in Normalization of database
  • Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures, Clusters, Triggers and maintaining referential integrity
  • Expertise in performance tuning of TSQL queries and Stored Procedures
  • Wrote T-SQL statements for retrieval of data
  • Expertise in writing SQL batch scripts.
  • Created joins and sub-queries for complex queries involving multiple tables
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation
  • Performed daily database backup & restoration and monitored the performance of Database Server
  • Optimized query performance by creating indexes
  • Troubleshoot the problems by using SQL server profiler

Environment: MS SQL Server 2005/6.5/7.0 , T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler.

Hire Now