Ms Sql Server Developer Resume
Kansas City, MO
SUMMARY
- Over Seven years of extensive experience in the IT industry as a MS SQL Developer/BI Developer (SSRS, SSIS,) in MS SQL Server 2005/2008R2.
- Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.
- Experience in RBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
- Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
- Expertise creating various complex reports in SSRS 2005/2008 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.
- Highly proficient in the use of SQL Server and T - SQL in constructing triggers, tables, user functions, Stored Procedures, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
- Experience working in various domains verticals like Health, Insurance, Pharma, Agri etc.
- Experienced in tuning the performance of database and queries by creating indexes, views.
- Involved in various admin level activities such as creating and maintaining of databases and other security objects like logins, Roles, Users and Schemas.
- Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
- Experience in deploying and enhancing the SSIS Packages from development server to production server.
- Sound knowledge in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
- Experienced in sorting the data, defining data source, using global variables, expressions, functions and subtotals for the reports.
- Good Knowledge in installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in windows environment, BI components (DTS/SSIS, SSRS).
- Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
- Proficient in writing complex T-SQL (DDL, DML), using new features like CTE, ranking functions, top(n), pivot and building referential integrity constraints.
- Thorough understanding of how to design and develop cubes using SQL Server 2005 Analysis Services and leverage the advanced BI functionality of SQL Server 2005.
- Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
- Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
- Excellent interpersonal skills, analytical, problem solving and presentation skills.
TECHNICAL SKILLS
- MS SQL Server 2005/2008
- MS SQL Integration Services 2005/2008
- MS SQL Reporting Services 2005/2008
- MS SQL Server Analysis Services 2005/2008
- C
- C++
- Visual Basic 6.0
- Visual C++
- ASP
- C#
- Erwin Designer 2000
- Crystal Reports
- Windows 2003 Server
- Windows XP/2000/Vista/W7.
PROFESSIONAL EXPERIENCE
Confidential, Alpharetta, GA
SQL Server/SSRS Developer
Responsibilities:
- Gathered user requirements, analyzed and designed of software and database solutions.
- Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
- Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the business users.
- Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.
- Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
- Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
- Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
- Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
- Created reports using Reporting Services 2008 to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
- Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
- Auto dispatching of simple and complex reports with parameters to different business users using Data driven subscriptions all across the organization based on defined schedules.
- Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
- Improving query / stored procedure performance for fast generation of reports.
- Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.
Environment: SQL Server 2008, Visual Studio 2008, ETL, SSRS 2008, DB2, MS Access 2008, WindowsEnvironment: Agile Methodology, Microsoft .Net Framework 3.0, C#.NET, Windows Forms, Visual Studio 2010
Confidential, Franklin, TN
SQL Server/SSRS Developer
Responsibilities:
- Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Involved in development and implementation of SSIS application solutions for various business units across the organization.
- Responsible for transferring the data using SSIS packages.
- Developed, monitored and deployed SSIS packages.
- Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
- Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
- Design and developing SSIS (ETL).
- Involved in performing migration of DTS packages to SSIS packages
- Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
- Analyzed reports and fixed bugs in stored procedures for the ongoing database operations, to resolve business problems.
- Generated reports using SQL Server Reporting Services (SSRS).
- Created report models for Report Builder and managed reports using Report Manager.
Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.NET, MS Excel, Windows XP.
Confidential, Kansas City, MO
MS SQL Server Developer
Responsibilities:
- Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
- Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
- Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
- Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
- Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
- Performed extract, transform, and load data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
- Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
- Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
Environment: SQL Server 2000/2005, MS Office Suite 2003 (Word, Excel, Access, PowerPoint and Outlook), Visio, Erwin, DTS, SSIS 2005, SSRS 2000.
Confidential, Wilmington, DE
SQL Server Developer
Responsibilities:
- Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
- Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
- Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
- Developed Store Procedure and Staging table for data push from CDW to Sales Force.
- Preformed QA Testing for all the Store Procedures to validate the sales results.
- Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
- Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
- Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
- Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
- Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
- Created SQL server configurations for SSIS packages and XML & Windows event logs.
- Used sub reports functionality for complex report calculations.
- Created parameterized reports passing parameter through report screen.
- Rendered reports in different formats like Pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.
Confidential
SQL Developer
Responsibilities:
- Involved in creating tables and databases, defining entity, attributes relationships using constraints
- Achieve proper database design using Normalization.
- Implementation of constraints in database design.
- Involved in maintaining of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing.
- Understanding of Data files, Log files and File groups.
- Modeling the relationships between entities of database using Entity Relationship diagram.
- Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2K, SQL Profiler, Active Directory, MS Access, and MS Excel.