Server Developer Resume Samples

Description :

1. Designed and implemented snapshots report, report subscription, data-driven subscription and report caching using report manager.
2. Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drill down, drill through, sub-reports, navigation reports.
3. Created 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.
4. Reporting parameters included single-valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.
5. Created linked reports, ad-hoc reports based on the requirement. Linked reports are created in the report server to reduce the repetition in the reports.
6. Created subscriptions to provide reports on a daily / weekly /monthly / quarterly and annual basis.
7. Created stored procedures to validate the data coming with different data discrepancies using data conversions.
8. Created subreports, bar chart, matrix reports, parameterized reports, cross-tab reports, drill down reports & summary reports for newly created markets.

Experience

10+ Years

Level

Management

Education

BS

Description :

1. Worked on full life cycle development (SDLC) involving in all stages of development.
2. Created database objects - schemas, tables, indexes, views, stored procedure, constraints, and roles.
3. Used various transformations like a derived column, data conversion, condition split, lookup etc. in SSIS to load data from flat Files, Excel and XML files to SQL databases.
4. Designed and developed data load jobs using SSIS package and scheduled using SQL agent.
5. Migrated legacy data from MS Access and Oracle database into SQL server 2014 using SSIS packages in SQL server data tools.
6. Created SSIS packages (.Dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
7. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB command, conditional split, aggregator, merge, union all, script component data conversion and derived column.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Experience in using T-SQL for creating stored procedures, indexes, and functions.
2. Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
3. Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and stored procedures.
4. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
5. Enhanced and deployed the SSIS packages from development server to production server.
6. Wrote the ETL scripts to load the data into the database from various source files.
7. Experienced in error handling and troubleshooting the scripts in failure to load the data into the database.
8. Created SSIS templates for developing ssis packages in such a way that they can be dynamically deployed into development, testing and production environments.

Experience

7-10 Years

Level

Senior

Education

Bachelor's

Description :

1. Used the SSIS to migrate databases such as Excel files, flat files and SQL server database to centralized IT destination.
2. Created many complex database code objects such as stored procedures/ views/ functions and used them in reports directly to generate reports on the fly.
3. Created queries in T-SQL, stored procedures, and views to store the data of clients, advisors.
4. Implemented OLAP cubes, facts and dimensions for providing summarized and aggregate views of large sets of data.
5. Created user-defined functions, triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
6. Developed tables, views, stored procedures, and triggers using SQL server management studio.
7. Developed tabular reports, subreports, matrix reports, drill down reports and charts using SQL Server Reporting Services (SSRS).
8. Created various SSIS packages to transfer data from OLTP databases to the staging area and then into the data warehouse.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Involved in requirement gathering sessions, understanding the requirements, involved in discussing the solutions with solution architect, creating a design document, coding, unit testing and production deployment.
2. Wrote complex T-SQL queries and stored procedures to build specific logic.
3. Created role-specific views to provide restricted access to different role specific profiles.
4. Optimized the performance of queries with modification in t-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes wherever necessary.
5. Used SQL Profiler for tracing and debugging of the T-SQL scripts & efficient report generation.
6. Optimized stored procedures and long-running queries using indexing strategies and query-optimization techniques eliminated redundant and inconsistent data, established joins.
7. Created ad-hoc queries to provide ad-hoc reports based on available data as per the request received from the business team.
8. Created SDS documents for implementing the client specified requirements.
9. Communicated effectively with business users to identify current reporting procedures and clarify program objectives.

Experience

7-10 Years

Level

Senior

Education

Engineering

Description :

1. Involved in creating functional and technical specification documents after gathering requirements from the business.
2. Created database objects like tables, views, stored procedures, functions, joins, and indexes in T-SQL based upon the functional specifications.
3. Designed and developed data models (physical/logical data models) based on the given specs.
4. Developed complex T-SQL queries and SQL scripts for efficient data load based on complex business rules.
5. Designed complex ETL strategies to pull data from different sources, like SQL Server, Oracle, and flat files and load it to the destination database after using multiple transformations.
6. Experience in writing SQL queries for pulling a large volume of records from facets and claims database using stored procedures, and extraction transformation and loading (ETL) process using SSIS.
7. Experience in migrating databases from one environment to another environment using linked servers.
8. Designed and developed reports using report builder to easily generate reports by the user.
9. Configuring SSIS packages using package configuration wizard to allow packages run on different environments.

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Worked with implementing conditions for various built-in facets like stored procedures, auto-create statistics.
2. Created and executed SQL server integration service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
3. Created SSIS packages using SSIS designer to export heterogeneous data from OLE DB source (Oracle), Excel spreadsheet to SQL server 2008.
4. Migrated legacy data using SQL server integration services (SSIS) and modified the packages accordingly using the advanced features of SQL server integration service.
5. Designed ETL packages dealing with different data sources (SQL server, flat files, and XML etc. ) and loaded the data into target data sources by performing different kinds of transformations using SQL server integration services (SSIS).
6. Experience in creating multiple reports (SSRS) in drill mode using financial tables, crosstabs, and charts.
7. Designed, deployment, and maintenance of various SSRS reports in SQL server 2008.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

1. Worked closely with Users, SMEs, and Technical Manager to fully understand the requirements of the system.
2. Created database objects such as tables, views, stored procedures, triggers.
3. Maintained referential integrity, domain integrity, and column integrity by using the available options such as constraints.
4. Identified columns for primary keys in all the tables at the design time and create them.
5. Created functions to provide custom functionality as per the requirements.
6. Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
7. Optimized the database by creating various clustered, non-clustered indexes and indexed views.
8. Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
9. Used various SSIS tasks such as conditional split, derived column, which was used for data scrubbing, data validation checks during staging, before loading the data into the mart tables.
10. Experience in error and event handling, precedence constraints, breakpoints, checkpoints, and logging.

Experience

10+ Years

Level

Management

Education

MS

Description :

1. The primary objective of the project is to extract, transform and load data from various sources using Microsoft integration services (SSIS) and maintain them in a data warehouse.
2. Responsible for loading data (gets from various legacy systems) into SQL servers by creating integrated packages (SSIS) and makes available data for analysis (SSAS) cubes and reporting services (SSRS).
3. Created SSIS packages to load the data into SQL table using lookup transformation, conditional split, data conversion, derived column, join, merge join, slowly changing dimension.
4. Extensively worked on data flow tasks like for each loop container, execute process task, transfer SQL server objects task, transfer jobs task, transfer logins task.
5. Worked with SSIS packages involved FTP tasks, fuzzy grouping, merge and merge join.
6. Used SQL server package configuration technique to make dynamic configurations.
7. Generated periodic reports based on the statistical analysis of the data using SQL server reporting services (SSRS).
8. Involved in creating calculated members, named set, advanced KPIs for the SSAS cubes.

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Creating tables, views, indexes, synonyms, triggers, functions procedures, cursors, and packages.
2. Created programming code using advanced concepts of records, collection and dynamic SQL.
3. Used advanced bulk techniques (for all, bulk collect) to improve performance. Developed installation scripts for all the deliverables.
4. Extensively worked on writing complex SQL queries (cursors, ref cursors, subqueries, correlated subqueries).
5. Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
6. Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeeded.
7. Optimized the existing SSIS packages to fix various issues and improve performance.
8. Designed new SSIS packages to extract data from newer OLAP and OLTP sources and transferred the data to SQL server using bids.
9. Responsible for SQL running using explain plan, optimizer hints.
10. Involved in RDBMS design and developed er-diagrams using Erwin. Participated in code walkthroughs and review sessions with the development team.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology