SQL Server BI Developer Resume Samples

Description :

1. Installed, configured, maintained and supported SQL server 2012 and 2014 in different environments.
2. Handled memory configurations for SQL Server 2014 and SQL server 2012.
3. Created complex stored procedures, triggers, functions, indexes, tables, views and other t-SQL code and SQL join for applications.
4. Created and executed SQL statements in both SQL production and development environments.
5. Used a merge statements to modify data in a target table based on data in a source table.
6. Creating, inserting, updating, and deleting data by using merge statements.
7. Created SSIS packages to process the data. Made use of various control flow and data flow items from the toolbox.
8. Performed error handing and version log using event handler.
9. Transferred the data (ETL) to data warehouse by SSIS and processed SSAS cubes to store data to olap databases.
10. Created EIM process to load the claim status bill feedback data from eim tables to siebel base tables and created activities for missing data.

Experience

5-7 Years

Level

Senior

Education

MS

Description :

1. The project involves developing a BI solution for strategic analysis by sales, marketing, and pricing.
2. Providing marketing and campaign management capability, an ability to measure effectiveness across all products and provide single data set for analysis and tracking of results to the management.
3. Responsible for analyzing business requirements and defining sales and marketing CRM system specifications.
4. Supporting the business and technical professionals in process improvement, technical designs, and quality assurance.
5. Building the CRM sales and marketing application reporting structures using SSRS, SSAS, SSIS, TSQL and SQL server.
6. Responsibilities also include enhancements of the CRM tailored to meet Dressbarn's needs while administering day to day activities for supporting the sales and marketing CRM activities.
7. Writing high-level test plans and test cases based on the baseline requirements.
8. Creating business reports and helping users to create their own reports.

Experience

10+ Years

Level

Management

Education

MS

Description :

1. Involving in requirement gathering, analysis, implementation, development, and production.
2. Creating dynamic queries to perform ETL operations by looping through multiple database servers and tables.
3. Importing and extracting data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
4. Designing and developing the various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.
5. Troubleshooting SSIS packages and migration procedures and documenting the complex SSIS packages and migration procedures.
6. SQL server database modeling, design and development with complex sql scripts, stored procedure, views, defined functions, triggers.
7. Designing and developing the mappings to load the data from flat file to SQL server tables for reporting purposes.
8. Working on business intelligence standardization to create database layers with user friendly views in teradata that can be used for development of various tableau reports/ dashboards.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Involving in the complete software development lifecycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
2. Designing and developing the SSIS packages to import and export data from ms excel, SQL server 2005 and flat files.
3. Experience in data normalization and data modeling and generating mapping documents.
4. Used various transformations in SSIS data flow, control flow using for loop containers and fuzzy lookups etc.
5. Involving in ETL architecture enhancements to increase the performance using query optimizer.
6. Worked on ssis project deployment, configure different environments, catalogs, environment parameter mappings and configured log settings at the server level for packages deployed in integration services catalogs.
7. Involved in designing, developing and testing the ETL (extract, transformation, and load) strategy to populate the data from various source systems feeds using ssis.

Experience

10+ Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Developing SQL programs and stored procedures as required for the ETL processes and data integration activities.
2. Building and maintaining SQL scripts, indexes and complex queries for data analysis.
3. Planned, designed and implemented application database code objects, such as stored procedures, functions and views.
4. Creating complex SQL scripts using joins (inner and outer), CTE and derived table.
5. Working on functional design, system analysis, the gathering of user requirements and maintaining good documentation.
6. Extensively using joins, stored procedures and sub-queries to simplify complex queries involving multiple tables.
7. Experience on normalization and de-normalization of existing tables for faster query retrieval.
8. Working on query optimization using tools like database tuning advisor, execution plan, and profiler etc.
9. Using send mail task that uses the template to send the report to the end user.

Experience

5-7 Years

Level

Senior

Education

BS

Description :

1. Involving in all phases of SDLC, and gathering the business requirements from business people.
2. Converting the Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
3. Developed DTS packages to extract, transform and load into the campaign database from OLTP database using SQL server integration services (SSIS).
4. Creating ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with the error description.
5. 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.
6. Performed documentation for all kinds of reports and DTS and SSIS packages.
7. Created ETL SSIS packages both design and code to process data to target databases.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Interacting with business users to gather business requirements and translate them into technical specifications and table design documents.
2. Creating and developing the databases and database objects such as tables, indexes, views, stored procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2014.
3. Creating clustered and non-clustered indexes on the columns recommended by the query optimizer to improve the performance of the slow running queries and stored procedures.
4. Implementing the error handling in stored procedures using try-catch blocks.
5. Implementing slowly changing dimensions (SCD) type-II for large datasets using merge statements in stored procedures to maintain historical data in the data warehouse.
6. Maintaining transactions(begin a transaction, commit transaction and rollback transaction) with error handling in stored procedures.
7. Working with data migration from Oracle to SQL server 2014 and migrated PL/SQL code to SSIS packages.
8. Re-created existing dimensions and fact tables using star schema in SQL server 2014.

Experience

7-10 Years

Level

Management

Education

MS

Description :

1. Experience in working with business analyst in order to gather requirements for design and implementation of the database.
2. Optimizing the performance of queries with modifications in TSQL queries, removing unnecessary columns, and eliminating the redundant and inconsistent data.
3. Creating the data model enhancements and design for a different location, supplier, and HR systems to consolidate and provide a single interface to any downstream consuming system.
4. Designing and developing SSIS ETL packages to validate, extract, transform and load data from OLTP systems to the data warehouse.
5. Integrating the ETL (batch processing) as well as real time processes using web services that were both subscribed and fed as information into the database.
6. Experience in creating tables, views, complex stored procedures to facilitate efficient data manipulation, data integrity, and other TSQL (DDL, DML) statements for various applications.
7. Experience in creating packages, jobs and experience in migration of data from excel, flat file, Oracle to MS SQL server.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

1. Conducted daily scrum (agile) meetings for our team also organized sprint planning, sprint retrospective, and sprint demo.
2. Actively participated in the role of scrum master for our team which also involved gathering task requirement and creating stories in version one.
3. Gathered user requirements, analyzed and designed the software and database solutions.
4. The project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
5. Experienced in extracting, transforming and loading (ETL) data from excel, flat file, to MS-SQL server by using DTS and SSIS services.
6. Configured report server and SharePoint, and deployed SSRS reports, report models, shared data sources to the document library of SharePoint.
7. Created clinical and financial reports to user specifications using reporting tools (SSRS) and T-SQL queries for MS-SQL databases.

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Involved in planning, defining and designing data, based on business requirements and provided documentation.
2. Designed data mapping documents, DDL scripts, data dictionary and metadata of the models and maintained them.
3. Developed SQL scripts, indexes, complex queries for data analysis and extraction.
4. Writing T-SQL script, dynamic SQL, complex store procurers, function, triggers.
5. Created functions, stored procedures, database triggers, user-defined function.
6. Used SSIS and t-SQL stored procedures to transfer data from source to staging area and finally load into the data warehouse.
7. Created SSIS packages to extract data from OLTP and transformed into OLAP systems and scheduled jobs to call the packages and stored procedures.
8. Created alerts for successful or unsuccessful completion of scheduled jobs.

Experience

10+ Years

Level

Consultant

Education

BS