SQL Server BI Developer Resume Samples

SQL Server BI Developer basically is involved in developing database architecture focusing eventually on enhancing the business performance. The major roles and responsibilities listed in the SQL Server BI Developer resume are identifying business needs, building analytics environment, proposing fresh data models, implementing information solutions, completing Bi projects on time, improving process flows, proposing IT solutions, supporting data analytics platforms, creating tools to store data and evaluating current Bi systems to improve it.

Successful resumes mention attributes such as industry experience, sound knowledge of data warehouse design, in-depth knowledge of database management systems, familiarity with BI technologies, knowledge of SQL, SSRS, SSIS, and OLAP. A college degree preferably in the field of computer science, Information technology or the related is expected from the SQL Server Bi developers.

SQL Server BI Developer Resume

Headline : Around 6 years of experience as SQL Server Developer/Business Intelligence Developer in the IT domain. Experience includes requirements gathering, development, design, testing, deployment, and maintenance of SQL Server technologies. Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases. Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.

Skills : MS-SQL Server 2008, Oracle 11g/10g, MySQL and MS Access 2003. Database Technologies/Tools: SQL Server Enterprise Manager, Microsoft Management Console, EIM, SQL, T-SQL, DQS, OLTP, OLAP. Microsoft Visio, ER Studio

Description :

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

SQL Server BI Developer Resume

Summary : SQL Server BI Developer committed to deliver high value to the organization. 10 years of extensive IT Professional experience with in the Retail domain. Expertise in Database Development, Modeling, Data Warehousing, Design and project management. Ability to comprehend and develop projects that align with program and organizational vision. Adept at instituting procedures and initiating solutions to specifications that save time, reduce costs, and eliminate redundancies.

Skills : Database, MICROSOFT SSRS, MS SQL Server, SQL, SQL Server

Description :

  • The project involves developing a BI solution for strategic analysis by sales, marketing, and pricing.
  • 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.
  • Responsible for analyzing business requirements and defining sales and marketing CRM system specifications.
  • Supporting the business and technical professionals in process improvement, technical designs, and quality assurance.
  • Building the CRM sales and marketing application reporting structures using SSRS, SSAS, SSIS, TSQL and SQL server.
  • 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.
  • Writing high-level test plans and test cases based on the baseline requirements.
  • Creating business reports and helping users to create their own reports.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
MS


SQL Server BI Developer (SQL/SSIS/SSRS) Resume

Headline : SQL Server BI Developer with 6 years of experience in the Healthcare domain. Experience in Database Design, Programming, Development, and Implementation of Client-Server Applications & Database systems using MSSQL. Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Skills : Data Warehouse Tools, SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Description :

  • Involving in requirement gathering, analysis, implementation, development, and production.
  • Creating dynamic queries to perform ETL operations by looping through multiple database servers and tables.
  • 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.
  • Designing and developing the various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.
  • Troubleshooting SSIS packages and migration procedures and documenting the complex SSIS packages and migration procedures.
  • SQL server database modeling, design and development with complex sql scripts, stored procedure, views, defined functions, triggers.
  • Designing and developing the mappings to load the data from flat file to SQL server tables for reporting purposes.
  • 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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
MS

SQL Server BI Developer I Resume

Summary : SQL Server BI Developer I with 12 years of experience in the Retail domain, with experience as Database Developer and Business intelligence developer using various tools like SSMS (SQL server Management Studio), SSIS (Integration Services), SSRS (Report Services) and SSAS (Analysis Services), databases MS SQL Server Oracle and MS Access and configuration tools Team Foundation Server and Microsoft Visual Source Safe.

Skills : Databases SQL Server, MS Access 7.0 Data Modeling Tools Case Studio 2, Visio Business Intelligence SSIS, SSRS, SSAS, DTS Version Control Team Foundation Server (TFS), Visual Source Safe.

Description :

  • 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.
  • Designing and developing the SSIS packages to import and export data from ms excel, SQL server 2005 and flat files.
  • Experience in data normalization and data modeling and generating mapping documents.
  • Used various transformations in SSIS data flow, control flow using for loop containers and fuzzy lookups etc.
  • Involving in ETL architecture enhancements to increase the performance using query optimizer.
  • 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.
  • Involved in designing, developing and testing the ETL (extract, transformation, and load) strategy to populate the data from various source systems feeds using ssis.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
Bachelor Of Technology


Senior SQL Server / BI Developer Resume

Headline : Senior SQL Server / BI Developer with over 6+ years of strong experience in the Manufacturing domain as a SQL Server Developer (SSIS, SSRS), Tableau Desktop and Server with sound business analysis skills. Good knowledge in all phases of Software Development Life Cycle (SDLC). Good knowledge in Designing, Building Dimensions, Cubes with Star Schema and Show-Flake Schema using SQL Server Analysis Services (SSAS).

Skills : MS SQL Server Access, Query Analyzer, DTS, SQL Profiler, Excel, Word

Description :

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

Sr. SQL Server BI Developer Resume

Summary : Sr. SQL Server/BI Developer with 10 plus years of IT experience in Database Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000. Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.

Skills : Databases Tools - SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS) ETL Tools Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS).

Description :

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

SQL Server BI Developer Resume

Summary : SQL Server BI Developer with over 9 years of experience with MS SQL Server and worked extensively on Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Experience in installation, upgrading, and configuration of MS SQL Server database. Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization, and Tuning.

Skills : DATABASE, MS SQL Server, SQL, SQL Server, T-SQL, Microsoft SSIS, Stored Procedures, Database, Microsoft SSRS, Business Intelligence, ETL, Data Warehouse, Reporting.

Description :

  • Interacting with business users to gather business requirements and translate them into technical specifications and table design documents.
  • 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.
  • 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.
  • Implementing the error handling in stored procedures using try-catch blocks.
  • Implementing slowly changing dimensions (SCD) type-II for large datasets using merge statements in stored procedures to maintain historical data in the data warehouse.
  • Maintaining transactions(begin a transaction, commit transaction and rollback transaction) with error handling in stored procedures.
  • Working with data migration from Oracle to SQL server 2014 and migrated PL/SQL code to SSIS packages.
  • Re-created existing dimensions and fact tables using star schema in SQL server 2014.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
MS

SQL Server BI Developer Resume

Summary : SQL Server BI Developer with over 7+ years of experience in the Healthcare domain, with experience in Database Design, Development and Implementation of SQLSERVER and providing ETL/Business Intelligence applications using Microsoft components. Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation, and Maintenance of projects.

Skills : SQL Server Tools: BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor. ETL & Reporting Tools: SSIS, SSRS, SSAS, Crystal Reports, Business Objects, ProClarity, Databases: MS-SQL Server MS Access.

Description :

  • Experience in working with business analyst in order to gather requirements for design and implementation of the database.
  • Optimizing the performance of queries with modifications in TSQL queries, removing unnecessary columns, and eliminating the redundant and inconsistent data.
  • 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.
  • Designing and developing SSIS ETL packages to validate, extract, transform and load data from OLTP systems to the data warehouse.
  • 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.
  • Experience in creating tables, views, complex stored procedures to facilitate efficient data manipulation, data integrity, and other TSQL (DDL, DML) statements for various applications.
  • Experience in creating packages, jobs and experience in migration of data from excel, flat file, Oracle to MS SQL server.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Technology

SQL Server BI Developer Resume

Summary : SQL Server BI Developer with over 7 years of extensive experience in IT industry as MS SQL Server BI Developer with SQL (SSRS, SSIS, SSAS). Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server and Access databases. Experience with Oracle and MY-SQL Databases.Excellent knowledge of Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.

Skills : MS SQL Server MS Office Suite (Access, Word, PowerPoint, Excel), Oracle 8i/9i/10g, MYSQL, Data Warehouse, SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, ODBC, Business Intelligence Development Studio (BIDS).

Description :

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

SQL Server BI Developer II Resume

Summary : SQL Server BI Developer II with 16 years of experience in the Finance domain with experience in MS SQL Server SQL Server 2012 parallel data warehouse and worked extensively on Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Skills : BI, BUSINESS INTELLIGENCE, DATABASE, MS SQL SERVER, SQL

Description :

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