SQL Server Developer Resume Samples

Description :

• Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
• Designing and developing the automated routines (scripts etc.) to facilitate the application development and deployment process.
• Maintaining DB schema and code change management using TFS and Redgates SQL compare.
• Maintaining the product application data which is critical in product lifecycle and efficiently implementing the data migration in each release.
• Implementing the heartbeat product role-based security which defines access to each individual functionality based on their role-based permissions.
• Involving in database design, application development of health benefits functionality and developed mission-critical benefits eligibility exception report.
• Developing SQL routines for complex, enterprise-level application development tasks involving hierarchical tree structures.

Experience

10+ Years

Level

Management

Education

MS

Description :

• Working on full life cycle development (SDLC) involving in all stages of development.
• Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.
• Writing the stored procedures and user-defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.
• Extensively utilizing the joins and sub-queries to streamline complex questions including different table.
• Building, publishing customized interactive reports and dashboards, report scheduling using tableau server. ‬‬‬‬‬‬
• Developing the tabular queries for efficient analysis of report using pivot/unpivot in T-SQL.
• Creating and managing the clustered indexes and non clustered indexes and optimized queries using execution plan.
• Creating action filters, parameters and calculating the sets for preparing dashboards and worksheets in Tableau‬‬.
• Creating dimension model for reporting system by identifying required dimensions and facts using Erwin.

Experience

5-7 Years

Level

Executive

Education

DTS

Description :

• Involving in all phases of SDLC, and gathering business requirements from business people.
• Converting Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developing DTS packages to extract, transform and load into the campaign database from OLTP database using SQL server integration services (SSIS).
• Created ETL metadata reports using SSRS, reports including execution times for the SSIS packages, failure reports with the error description.
• Designed SSIS packages to extract, transfer, load (ETL) existing data into SQL server from different environments.
• Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL server 2008/2012.
• Performing documentation for all kinds of reports and DTS and SSIS packages.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

• Worked extensively with SSIS to import, export and transform the data between the linked servers.
• Involving in business analysis and technical design sessions with business and technical staff to develop entity-relationship/data models, requirements document, and ETL specifications.
• Creating the database objects like procedures, functions, packages, triggers, indexes, and views using t-SQL in development and production environment for SQL server 2005.
• Using DDL and DML for writing triggers, stored procedures, and data manipulation.
• Creating database and database objects like tables, stored procedures, views, triggers, rules, defaults, user-defined data types, and functions.
• Involving in unit testing, user acceptance testing to check whether the data is loading into the target, which was extracted from different source systems according to the user requirements.
• Generated database SQL scripts and deployed databases including installation and configuration.

Experience

10+ Years

Level

Management

Education

Bachelor Of Engineering

Description :

• Working on various possible performance-related issues including database tuning with the sole intention of achieving faster response times and better throughput. 
• Involving in the analysis of report design requirements and actively participating and interacting with team lead, technical manager and lead business analyst to understand the business requirements.
• Migrated DTS packages from SQL Server 2000 to SQL server 2012 as SSIS packages.
• Experience in working on cube structure optimization for MDX query performance in analysis services 2008.
• Excellent report creation skills using Microsoft SQL server 2012/2008r2 reporting services (SSRS) with proficiency in using report designer as well as report builder.
• Created SQL server reports based on the requirements using SSRS 2008.
• Worked on the reports module of the project as a developer on ms SQL server 2012 (using SSRS, t-SQL, scripts, stored procedures, and views).
• Developed complex stored procedures, views, and temporary tables as per the requirement.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

• Designing and developing the SSIS packages, stored procedures, configuration files, tables, views, indexes.
• Used SSIS to extract data from enterprise data warehouse, Oracle added multiple transformations to transform the data and finally loaded into the DB2 database.
• Using table difference, upsets, lookups, and conditional splits for finding deltas.
• Used SQL Bi-Xpress for managing, auditing and notification frameworks.
• Creating the SSIS jobs for monitoring the jobs that depend on daily loads and loading db2 database tables using SQL server agent.
• Automating tasks using active x script (similar to VB Script). Be able to implement failure alerts using email in SSIS.
• Involving in object-oriented design (UML, activity diagrams, use cases, and object modeling).
• Involved to develop the VB script, C#, and ASP.Net, VB.Net and dot Net framework creation in SSAS and SSIS.

Experience

10+ Years

Level

Management

Education

MS

Description :

• Performed server installation and configuration using SQL server 2012.
• Designing, implementing and maintaining the database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Maintaining the database schema in source code control (MS team suite database edition preferred).
• Developing the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Using the quality center (defect tracking tool) for bug fixing and resolution details.
• Involving in mock testing and unit testing and integration testing in SSIS, SSAS.
• Creating the automated stored procedures for day end operations using SQL server agent and CTE.
• Coordinating with the front-end for implementing logic in stored procedures and functions.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Engineering

Description :

• Creating the SSIS packages to load the data into SQL table using lookup transformation, conditional split, data conversion, derived column, join, merge join, slowly changing dimension.
• Extensively working on data flow tasks like for each loop container, execute process task, transfer SQL server objects task, transfer jobs task, transfer logins task.
• Working with SSIS packages involved FTP tasks, fuzzy grouping, merge and merge join.
• Using SQL Server package configuration technique to make dynamic configurations.
• Generating the periodic reports based on the statistical analysis of the data using SQL server reporting services (SSRS).
• Involving in creating calculated members, named set, advanced KPIs for the SSAS cubes.
• Designing cubes with star schema using SQL server analysis services 2008 (SSAS).
• Creating several dashboards and scorecards with key performance indicators (KPI) in SQL server 2005 analysis services (SSAS).

Experience

10+ Years

Level

Management

Education

Bachelor Of Engineering

Description :

• Extensively involved in gathering business requirements as an endeavor that will facilitate the planning and the implementation phase of a data warehouse.
• Working closely with the business owner, project manager, subject matter experts and system architecture to define business requirements and create business requirements documents for signoff and agreement.
• Designing the logical and physical model of OLTP database using Er-win and later forward engineered the physical model to Microsoft SQL server 2008r2.
• Creating UML diagrams - activity diagrams and sequence diagrams using Microsoft Visio.
• Creating the requirement enhancements document and scope document for modeling integration and data models.
• Creating Entity Relationship Diagram (ERD) to communicate and clarify the physical data models for subject matter expert and developers.
• Managing the database maintenance plans to maintain the database consistency and effective functioning.

Experience

10+ Years

Level

Consultant

Education

Bachelor Of Technology

Description :

• Designing and implementing the snapshots report, report subscription, data-driven subscription and report caching using report manager.
• Generating SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drill-downs, drill through, sub-reports, navigation reports.
• Creating parameterized reports like standard parameter reports, cascading parameter reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Creating the linked reports, ad-hoc reports based on the requirement. Linked reports are created in the report server to reduce the repetition in the reports.
• Creating the subscriptions to provide reports on a daily/weekly/monthly/quarterly and annual basis.
• Creating stored procedures to validate the data coming with different data discrepancies using data conversions.
• Creating sub-reports, bar chart, matrix reports, parameterized reports, cross-tab reports, drill down reports & summary reports for newly created markets.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Technology