Sql Server Developer Resume
NJ
PROESSIONAL SUMMARY:
- 7+ Years of extensive experience in Software Design, Development, Analysis, Testing with Data mart, Data Warehouse, Data modeling and Business Intelligence tools.
- Experienced in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
- Extensively experienced in Extraction, Transformation, and Loading tasks in SSIS while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Access, Flat File, Raw File and XML File.
- Experienced in Developing and Tuning T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks.
- Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
- Expert in Designing, Developing and Deploying SQL Server Reports using SSRS.
- Experienced in defining Query for generating drill down reports in SSRS 2005/08.
- Expert in handling sub reports in SSRS 2005/08. Creating different types of Complex Reports using SSRS.
- Expert in ETL, Data warehousing & OLAP technology.
- Thorough understanding of how to design and develop cubes using SQL Server 2005/08 Analysis Services and leverage the advanced BI functionality of SQL Server 2005/08/08R2.
- Experience in Performance Tuning the Stored Procedures, Index Tuning, Query Optimization, and Database Consistency Checks using DBCC Utilities.
- Excellent knowledge skills in database backup, recovery and restoration of Transactional Databases and SSIS (SQL server Integration Services) files system and SSRS (SQL Server Reporting Services) server.
- Strong experience with analyzing query plans, managing indexes and locks, troubleshooting.
- Possess excellent skills in Data Modeling using Erwin for implementing Star and Snowflake Schemas.
- Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
- Ability to work with a team and individually.
- Excellent communication and problem solving skills.
- Experience in developing written documentation for technical audience.
TECHNICAL EXPERIENCE SUMMARY
Languages and Tools : C, C#, MATLAB, T-SQL, PL/SQL
Web Technologies : HTML, DHTML, XML.
ETL Tools : DTS, SQL Enterprise Manager, SQL Server Management Studio,
Configuration Manager, Query Analyzer, SQL Profiler, SQL Server Agent
Software : MicroStrategy, Microsoft Office.
Databases : PL/SQL, MySQL, SQL Server, Oracle 9i, 10g, DB2, Microsoft Access
Reporting Services : SQL Server Reporting Services (SSRS), Crystal Reports 2008
Operating Systems : Windows (2000/XP/Vista), Unix.
PROFESSIONAL EXPERIENCEERIENCE
Confidential
SQL Server Developer
Responsibilities:
- Involved to work with troubleshooting the stored procedures, functions, views, triggers etc & part to be increasing the performance tuning.
- Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
- Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
- Developed SSIS ETL packages to meet data flow needs.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
- Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
- Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
- Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
- Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
- Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
- Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
- Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
- Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
- Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
Environment: MS SQL Server 2005,2008R2,MS Access, ETL, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, TFS, Unix shell script.
Confidential
MS SQL Server Developer
Responsibilities:
- Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Responsible for testing to optimize the procedures and triggers to be used in production.
- Involved in project planning also schedule for database module with project managers.
- Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
- Involved in database migration from SQL server 2000 to 2005/08.
- Created ETL packages to Load data into Data Warehouse Using SSIS
- Involved in analyzed and designed disaster recovery / replication strategies with business managers to meet the business requirements.
- Responsible for creating user defined, attributes hierarchy towards the SSAS cube.
- Designed and implemented the warehouse data model, dimension, fact and summary tables.
- Configured replication servers and transactional replication between production and standby server for disaster recovery.
- Wrote various stored procedures for the purpose of application development.
- Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.
Environment: MS SQL Server 2000/05, ETL, MS Access, MS Excel, Windows 97/2000/XP, ER-Win v4.0.
Confidential
SQL Server Developer
Responsibilities:
- Worked on iteration basis to make sure the deliverables are achieved on time.
- Involved in the meetings with business users to design the business required document for the enhancements proposed.
- Involved in the meetings with business users to design the business required document for the enhancements proposed.
- Designed, altered the existing schemas to enhance the functionality of the portfolio tracking system.
- Generated Weekly, Monthly and Yearly reports for time reporting systems (TRS).
- Worked on various complex stored procedures on back end to calculate budget data and provide actual and forecast information for all global domains.
- Involved in developing SSIS configuration and developed the SSIS Framework.
- Enhancing the existing functionality to display more qualitative data to the business.
- Worked on enhancing DB scripts for the actuals and forecast budget data screens to determine the flow of money across various global projects.
- Performed the activities on production servers to deploy the changes made during the iteration.
- Coordinated with production support and DBA team in refreshing the existing Database instances from the production servers.
- Provided the data as required for the front end developers to restructure the existing presence of the UI Screen.
Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2005 Management Studio, Microsoft SQL Server 2000 Enterprise Edition, Microsoft Visual Basic 6.0.
Confidential
SQL Developer
Responsibilities:
- Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
- Used SQL Server Reporting services for creating, editing and scheduling various reports
- Created and maintained database objects, Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.
- Created various reports using SQL Reporting Services.
- Developed complex reports, which are migrated from different reporting tools.
- Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler. .
- Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, SQL code with proper grants to all the users and roles.
- Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting
- SQL performance tuning by modifying SQL or adding/changing indexes.
- Created and automating the regular jobs.
- Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
- Integrated Stored Procedures to generate the Reports.
Environment: MS SQL Server 2005,2000, T-SQL, DTS,MS Access 2002,Flat files, SQL Server 2005 Management, and Windows 2003 Server.