We provide IT Staff Augmentation Services!

Sql Server Developer Resume

5.00 Rating

Columbus, IN

SUMMARY

  • Over 7 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008R2/2008, 2005 and 2000 in Production, QA and Development Environments.
  • Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
  • Working knowledge of software development life cycle (SDLC) and project methodologies, as well as tools and techniques within each phase.
  • Expert in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS, DTS, Bulk Insert, BCP and XML.
  • Hands on experience with SQL Server and T - SQL in constructing triggers, tables, user defined functions, views, indexes, relational database models, data dictionaries, and data integrity.
  • Extensive experience in writing Complex Stored procedures as well as analysing and debugging existing complex stored procedures.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Experience in creating applications to perform Data Cleansing, Data Conversion and Data Loading.
  • Extensive experience in debugging query performance problems by analysing execution plan, server trace, client statistics, index tuning wizard.
  • Expert in working with trace files and execution logs.
  • Strong experience in developing Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services (SSRS).
  • Created MDX queries to retrieve data from the cube and also to display SSRS reports.
  • Experience in creating complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Hands on experience in designing and developing SSAS (SQL Server Analysis Service) cubes and dimensions and writing MDX queries.
  • Excellent knowledge of Normalization/De-Normalization, Data Design methodology and build Referential Integrity across multiple tables.
  • Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server 2000/2005/2008 .
  • Expert in of various source transformations, including flat files, XML and relational systems.
  • Excellent Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
  • Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
  • Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
  • Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
  • Expert in creating Report Builder models for ad hoc reporting purposes.
  • Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS.
  • Experienced in Index Creation, Query Optimization and Performance Tuning.
  • Experienced in working with Star Schema modelling to develop ROLAP/MOLAP Cubes using SQL Server 2005 Analysis Services (SSAS).
  • Accomplished in working with users to understand and assess their needs and requirements prior to developing application systems and work effectively as a part of team or independently under deadlines and extreme pressure.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008, Oracle 9i,10g/11g, MS Access

BI Tools: SSIS, SQL Server, Business Intelligence Dev Studio, DTS

Languages: T-SQL, PL/SQL, C#, VB.Net, Visual Basic 6.0, HTML, DHTML, XML, VB Script, Java Script, C, C++Technologies .NET Framework 3.5, WPF, WCF, CSS, XSL, XSLT, COM, COM+, Remoting, ASP.NET, AJAX, Web Services

IDE Tools: Visual Studio.NET, Visual cut

Designing Tools: Infragistic Tools, Erwin, Microsoft Visio

Web Servers: IIS 4.0 and IIS 6.0

Configuration Tools: Visual Source Safe

Reporting Tools: SSRS, Crystal Reports 10, Crystal Reports XI

Operating Systems: Windows 95/NT/2000/XP and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

SQL server developer

Responsibilities:

  • Involved in design and documenting the Technical Design Document and the Program Specifications document.
  • Coding Triggers, Stored Procedures, Functions and required Database objects as per the design logic defined in the Low Level Design Document for different reports and data validation.
  • Created the Staging tables, successfully migrated old data from legacy system into SQL Server 2008 using SSIS Packages.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Defined relationship between dimensions and measures groups, calculated slowly changing dimensions for different OLAP cubes.
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
  • Created SSIS Packages to import and export data from Excel, XML and Text files.
  • Involved in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
  • Cubes design and development with measures, calculation and actions using MDX queries in SSAS and reports development using performance tuning as per the requirements.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Responsible for creating calculations and named sets using MDX.
  • Transferred data by adding Derived column Transformation, count of records, merging of data has been done while pulling data from Source to the Target.
  • Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS.
  • Performed complex Expressions to create calculated fields and used Global Variables in SSRS.
  • Designed and Developed parametric Reports, Cross-Tabbed and Sub-Reports in SSRS.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Created SSRS Report Model Projects in BI studio as well as created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Responsible for Testing in different Environments like Unit testing, SIT and UAT before moving code to Production and Responsible for debugging and troubleshooting of the reported errors.
  • Effectively participated and coordinated with offshore team.

Environment: Microsoft SQL Server 2008 Enterprise Edition, Management studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SSAS,SSMS, Ms excel 2003, Microsoft Visual Studio.NET 4.0, c#, BIDS, Visual Source Safe.

Confidential, St. Louis, MO

Sql Server developer

Responsibilities:

  • Analysed the end to end functionality of the old system and reviewed various reports the old system is generating.
  • As part of the database design, actively coordinated with DBAs and architects in design of Database in SQL Server 2005 and SQL Server 2008.
  • Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
  • Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
  • Loading Fact Tables and Dimensions into the SSAS cubes transferring and migrating Data from Source views showing the relation between the above.
  • Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
  • Created SSIS packages using Conditional Split, Data Conversion and Fuzzy Logic and C #.
  • Created SSIS Packages to import and export data to and from various sources like Access, Spread sheets, Xml and Text files.
  • Created the Staging tables, successfully migrated old data from legacy system into SQL Server 2008 using SSIS Packages.
  • Developed several Complex Reports (daily, weekly, monthly, quarterly and yearly) using SSRS (SQL Server Reporting Services).
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Created Ad hoc reports, Drill down and drill through reports, sub reports using SSRS.
  • Enhanced the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented into SQL Server 2008.
  • Used sub reports functionality for complex report calculations.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
  • Created DTS packages and scheduled data migration from old system to new system and verified making different reports on new system.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and Troubleshooting for any error occurs in execution.
  • Performed unit testing and regression testing in testing various reports and to check the validity of the data retrieved from the database.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, Management studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS),SSAS, SSMS, Ms excel 2003, Microsoft Visual Studio.NET 3.5, c#, BIDS, Crystal Reports, Visual cut, Visual Source Safe.

Confidential, Dover, NH

MS SQL Server/SSAS/SSIS Developer

Responsibilities:

  • Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
  • Constructed OLTP and OLAP Databases.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Used SQL profiler to view indexes performance to mostly eliminate table scan.
  • Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Used multiple join statements to retrieve data from multiple several tables and constructed Cubes based on data volumes mostly adhering to Star Schema.
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
  • Created Unit test cases and executing them.

Environment: MS SQL Server 2005, SQL Server Reporting Services 2005, SQL Server Integration Services 2005,BIDS, SQL Server Analysis Services 2005(SSAS), MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

  • Worked with business analysts to analyse the business needs.
  • Designed and developed packages, transformation logic and processes in SSIS for implementing business rules and standardization of source data from multiple systems into the fact tables.
  • Coding complex store procedures, triggers, views, user defined functions and other objects to capture updated and deleted data from OLTP systems.
  • Used DTS jobs for importing data from legacy systems to the current model.
  • Implemented strong referential integrity and auditing by the use of triggers.
  • Extract the data from SQL Server 2000 to SQL Server 2005 using SSIS as ETL tool.
  • Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2000 to the SQL Server 2005.
  • Created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table.
  • Developed the T-SQL Statements for loading the data into Target Database.
  • Wrote queries for drill down reports and developed a Tabular Reports using SSRS Report Designer.
  • Debugging reports and deploying reports on server.
  • Analyzed old reports designed in Crystal Reports and transform those reports into SSRS Report with proper mapping and error handing.
  • Used complex expressions to calculate groups, filters, parameterize, and format the contents of the reports
  • Created complex reports in Crystal Reports using procedures from SQL Server by passing parameters as per business needs.
  • Involved in code reviews for better performance and coding conventions guidelines.
  • Responsible for Testing in different Environments like Unit testing, SIT and UAT before moving code to Production and Responsible for debugging and troubleshooting of the reported errors.

Environment: SQL Server 2000/2005, SSIS, SSRS, Crystal Reports,Visual Source Safe,ADO.NET, Visual Basic 6.0, BIDS.

We'd love your feedback!