We provide IT Staff Augmentation Services!

Ms Sql Server Developer Resume

3.00 Rating

Basking Ridge, NJ

SUMMARY

  • Over 7 years of IT experience with SQL Server Development
  • Also have equally good experience working as a BI Developer
  • Well acquainted with all the phases of SDLC (Software Development Life Cycle)
  • Over 5 years of experience with Business Intelligence Technologies like SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) of MS SQL Server 2005/2008
  • Efficient in migrating DTS packages, reports, analysis services project from SQL Server 2000 to SQL Server 2005/2008
  • Worked on normalizations of a database
  • Worked on Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services in SQL Server 2005/2008 and DTS in SQL Server 2000
  • Very proficient in the using the Data Manipulation Language and Data Definition Language
  • Extensive usage of stored procedures, tables, triggers, functions and views
  • Worked on SQL Server Agent for scheduling jobs and DTS packages
  • Designed and scheduled complex SSIS packages for manually transferring data from multiple data sources to SQL Server
  • Expert in creating reports using SQL Server Reporting Services by creating OLAP cubes
  • Written a number of MDX queries
  • Experienced in performance tuning and query optimization
  • Also worked with .NET, C# and HTML while creating web pages
  • Excellent experience from working in different sectors namely, Financial, Health, Insurance and Banking
  • Worked with other developers and DBA’s
  • Also worked in close proximity with the Business Analysts
  • Strong problem solving skills and an excellent team player
  • Strong communication skills when communicating with other developers, DBA’s or project managers

TECHNICAL SKILLS

  • SQL Server 2000/2005/2008
  • SQL Server Management Studio
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Cubes
  • MDX
  • OLAP
  • DTS
  • Visual Studio 2000/2005/2008
  • MS Access
  • Microsoft office 2003/2007
  • BCP
  • SQL Server Agent
  • Data Analysis
  • C/C++
  • C#
  • .NET Framework
  • Visual Basic
  • HTML
  • XML

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

MS SQL Server Developer

Responsibilities:

  • Written many complex stored procedures to assist the data import and export
  • Involved in building tables, updating these tables
  • Worked with functions, indexes
  • Kept a check on the performance of the query
  • Worked with SQL Server 2005 version
  • Worked with Oracle Database when exporting data to a SQL Server Database
  • Involved in building reports and populate the data into power point dynamically
  • Involved in Scheduling jobs and Altering using SQL Server Agent
  • Written a number of T - SQL queries and a number a nested queries
  • Created reports using Excel
  • Also worked with enterprise manager in SQL
  • Worked on SSIS packages in SSIS, DTS Import/Export for transferring data from other databases
  • Imported data from excel sheets into SQL Server
  • Used Visual studio to analyze the reports using SSAS
  • Performed a lot of analysis from the reports
  • Worked extensively with OLAP cubes to access the size of the database
  • Written some MDX queries
  • Worked extensively with fact tables, measures, dimensions while creating cubes
  • Used cubes for the analysis of the data for a particular requirement
  • Created test cases from project documentation that can be understood to anyone with a vast knowledge of application
  • Deployed a number of reports on the server and also deployed them on a SharePoint server
  • Created web pages using .NET and deployed all the reports on these
  • Ensured test cases are mapped to the requirements
  • Met project schedule deadlines for several complex projects
  • Report daily testing status using the Standard test status analysis

Environment: MS SQL Server Developer 2005 and 2008,Oracle, MS SQL Enterprise manager, SQL Server Analysis Services, SQL Server Reporting Services, MDX queries, Import/Export, OLAP Cubes, T-SQL, SharePoint, .NET

Confidential, Chicago, IL

BI Developer/SQL Server Developer

Responsibilities:

  • Responsible for creating reports based on the requirements using SSRS 2005
  • Actively supported business users based on their requirements
  • Identified the database tables for designing the queries for reports
  • Monitored performance and optimized the SQL query for maximum efficiency
  • Identified and defined the datasets for report generation
  • Implemented calculated members and actions such as URL actions, Report actions and Drill Through actions in SSAS 2005
  • Written queries for drill down reports
  • Extensive usage of Data Definition Language and Data Manipulation Language
  • Identified and included report parameters and formatted reports using global variables and expressions. Deployed the reports onto the server
  • Defined attribute properties in Parent Child Dimensions
  • Responsible for hiding and disabling the attribute hierarchies
  • Maintained data integrity by performing validation checks, tuned and monitored server performance
  • Written T-SQL, MDX queries for data retrieval
  • Fine-tuned the database objects and server to ensure efficient data retrieval
  • Created views, several stored procedures and modified them according to the specifications
  • Created several other database objects like tables and indexes
  • Worked on Data warehousing, Data marts based on Star and Snow flake schemas
  • Extensive usage of Drill mode and Slice and Dice techniques to modify the reports according to the user’s analysis requirements
  • Active involvement in planning, documentation and administrative tasks
  • Deployed 12 reports over a week’s deadline

Environment: MS SQL Server 2005, SSAS 2005, SSRS 2005, MDX queries, Optimization, Calculated members and actions, Data warehousing, Parent child dimensions, Attribute Hierarchies

Confidential, Kansas City, MO

MS SQL Server Developer

Responsibilities:

  • Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application
  • Worked with the 3-Tier Architecture which includes the presentation layer, business logic layer and the database
  • The presentation layer was the front end which included creating web pages and the database acted as the back end
  • Created all the tables for patient’s information, doctor’s information, medical information and all the relevant information
  • Actively involved in Normalization (3NF) and De-normalization of the database
  • Created several complex stored procedures and triggers using SQL Server 2005 to retrieve data
  • Used MS Visual Source Safe 6.0 for the source control
  • Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks
  • Involved in developing Cubes in Business Intelligence Development Studio using SSAS
  • Analyzed the requirements and finely tuned the stored procedures to improve the performance
  • Documented the SQL Server Integration Service Standards to be followed
  • Implemented the DTS packages in SSIS to transfer and load the data
  • Handled Query Optimization by making extensive use of Index Implementation and Index Tuning Wizard SQL Server 2008
  • Used SQL Server Reporting Services (SSRS) 2005 to query the databases to generate different types of complex ad-hoc reports
  • Worked on DTS package in SSIS, DTS Import/Export for transferring data from heterogeneous databases

Environment: MS SQL Developer 2005, SSIS 2005, Cubes using SSAS, DTS packages, Query optimization, tuning, MDX queries, T-SQL Queries

Confidential, West Chester, PA

MS SQL Server Developer/BI Developer

Responsibilities:

  • Involved in the designing, development, modification and enhancing the database structures and database objects
  • Developed logical and physical data models, design access strategies and write SQL code to access and manipulate data stored in OLAP databases
  • Created SQL Server Analysis projects, multi-dimensional databases, OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
  • Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures
  • Created numerous Data Transfer Services (DTS) packages in Microsoft SQL Server 2000
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005
  • Created web pages for the frontend using HTML
  • Transferred data into various formatted files and updated my manager with the automated email systems
  • Wrote several complex stored procedures for efficient handling of the application
  • Debugged and optimized several complex stored procedures
  • Tuned several slow running queries in production
  • Implemented Indexes and used Re-Indexes to achieve time performance
  • Constructed cubes based on data volumes mostly adhering to Star Schema
  • Eliminated the old analyzed data to provide more data space on production
  • Created different types of reports including Cross-tab, Conditional, Drill-down, OLAP and sub reports
  • Based on the user input, modified the report content and exported reports in multiple formats
  • Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports
  • Identified and worked with parameters for parameterized reports in SSRS 2005
  • Developed daily, weekly and monthly reports and published them on the company’s intranet

Environment: SQL Server Developer 2000 and 2005, Stored procedures, Cubes, MDX queries, SSRS deployment, OLAP databases, Indexes, SSRS 2005, SSAS 2005, Oracle, HTML

Confidential, Carson, CA

SQL Server Developer/Data Analyst

Responsibilities:

  • Maintained data flow and error logs
  • Checked/Tested the EDI exception bucket and fixed the problem
  • Supported backend of the TLSDB (Transload System Database)
  • Created complex stored procedures and functions to maintain efficient data storage and manipulation
  • Optimized the performance of queries with modification/revision in index system for TLS
  • Created data reports using SQL Server Query Analyzer, Crystal Reports and Excel 2003
  • Created stored procedures for faster access of information and smoother flow of data
  • Wrote stored procedures for ad hoc, daily and weekly reports
  • Created custom stored procedures and functions to support various new operations
  • Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning wizard
  • Participated in different testing and debugging for the system
  • Documented all processes involved in maintaining Database for future reference

Environment: SQL Server Developer 2000, T-SQL, DTS packages, stored procedures, Reporting Services

We'd love your feedback!