SQL BI Developer Resume Samples

A SQL BI Developer is hired to undertake the crucial task of creating and managing BI and analytics solutions which converts data into knowledge. A well-drafted SQL BI Developer Resume indicates the following – translating business needs as technical specifications; designing and building BI solutions; maintaining and supporting data analytics platforms; creating tools to store data; conducting unit testing and troubleshooting; developing and executing database queries and conducting analyses; creating visualizations and reports; developing and updating technical documentation; and improving existing BI systems.

Apart from proven work experience, the following skills and abilities are required – a solid background in data warehouse design; an in-depth understanding of database management systems; familiarity with BI technologies; knowledge of SQL queries and SQL server reporting services; and knowledge of SQL server integration services – SSIS. A Computer-related degree is useful to work at this level.

SQL BI Developer Resume example

SQL BI Developer - Intern Resume

Objective : Experience as a SQL BI Developer in Information Technology with strong experience in ETL requirements gathering, developing ETL processes, SSIS packages to design and implementation. Specialize in requirement Gathering; ETL, SSIS, Data analysis, designing data warehouse strategies. Experience working with ETL tools, power query, power BI, power pivot/power map/power view, Advanced SQL and various reporting tools.

Skills : SQL, SSIS, SSRS, Message Broker, C++, T-Sql, Mdx.

Description :

    1. Involved in gathering, analyzing and documenting business requirements and preparing technical documents for ETL, SSIS, Data Warehouse, SQL BI Development Worked with Business to document BRDs, Writing Functional Specifications.
    2. Extensive work in SQL programming, SQLPlus, Database Triggers, Packages, Cursors, Stored Procedures, Functions and management of Schema objects.
    3. Proficiency in Data Definition and Data Manipulation languages.
    4. Responsible for application analysis, design, coding, testing and documenting of new interactive web applications as well as maintaining, supporting and upgrading existing web applications.
    5. Developed user requirements, functional requirements and technical specifications, process flow diagrams Understand and document business requirements, prioritize the project timelines and demonstrate business requirements to the technical systems team for the development of automated reporting solutions using cutting edge technologies.
    6. Involved in the complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
    7. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor Of Science


Senior SQL BI Developer Resume

Summary : Senior SQL BI Developer with 7 years of experience in the IT Industry, having the primary focus on Database Design, Application, Development, Implementation, Testing and Deployment in the MS SQL Server Environment and MSBI Tools (BIDS/SSDT). Strong understanding of Normalization/De-normalization, Normal Form and database design methodology. Well-versed in SQL Server 2012, 2008R2, 2005, 2000

Skills : MSBI, Data Flow Task, Bulk Insert Task, Execute SQL Task and Execute Package Task, Data Profile Task

Description :

    1. Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors, and Triggers.
    2. Created desired stored procedures for loading the data from different sources according to the mapping rules and design specifications.
    3. Designed SSIS Packages drawing data from various data sources such as Flat/Raw File, Excel, CSV, Access, OLEDB, XML, CDC, ADO.NET, etc., and shown familiarity in using transformations like Aggregate, Conditional Split, Derived Column, Merge, Merge Join, Union all, Multicast, Row Count, Lookup, Sort, Audit, Fuzzy Look Up, etc.
    4. Experienced in SSIS error handing using event handlers, breakpoints, SSIS loggings, package configurations.
    5. Responsibly managed data and metadata in Business Intelligence (BI) solutions latest upgrades of Microsoft SQL Server 2012, 2014 and SSDT 2013.
    6. Actively involved in query optimization using SQL Profiler by modifying the slow running queries from the SQL Profiler Trace.
    7. Involved in optimizing the stored procedures for a faster population of the reports in the Report Server.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Science


Associate SQL BI Developer Resume

Headline : Associate SQL BI Developer with over 5 years of expert IT involvement in MS SQL Server Database Design, Development, Integration, Reporting and Analysis. Experienced in installing, updating and configuring SQL Server [] on operating system windows [] server. Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts, and OLAP-Online Analytical Processing technologies. Domain Expertise in Banking, Financial, Insurance, Tele-communication and Retail sectors.

Skills : MS SQL Server 2012, SQL Server Integration Services (SSIS) 2012, Crystal Reports (2008), Business Objects XI3

Description :

    1. Involved in Database design by creating database objects like tables, views, stored procedures and Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures Assisted with the design and implementation of workflow applications to update and insert data.
    2. Coordinate with business users in gathering business requirements and translating them to technical specifications.
    3. Created SSIS packages to move the data from Oracle to SQL Server staging Database and from Oracle to Flat files.
    4. Involved in creating SQL stored procedures, Functions, Views, Indexes in Microsoft SQL Server using appropriate business rules, standards for better performance.
    5. Created packages by using multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Database.
    6. Documented and maintained database system specifications, diagrams, and connectivity charts.
    7. Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
    8. Train and manage developers, advising other groups in the organization on SSIS development, SSRS reports and data warehouse development, and documenting the best practices.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

SQL BI Developer - Contract Resume

Summary : SQL BI Developer with 6+ years of Extensive IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server [] in Development, Test and Production Environments with various business domains like Financial, Healthcare, Manufacturing and Insurance Services. Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Skills : SQL, SSIS, SSRS, MSBI, SSAS, SQL Server, T-SQL, Tableau, PowerBI.

Description :

    1. Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
    2. Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
    3. Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
    4. Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
    5. 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.
    6. Participated in creating reports that deliver data based on stored procedures.
    7. Created Report Email Subscription using Data-Driven and Time-Driven Report Subscriptions.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

SQL BI Developer (SSIS/SSRS) / Data Analyst Resume

Headline : Over 5 years of Experience in Database Analyst, 2 years of experience exclusively in Designing, customization, enhancing, and workflow configuration, integrating and supporting Service-Now suite of products such as Incident Management, Problem Management, Change Management, Asset and Service Request management systems and strong experience in SQL BI development with great expertise in various frameworks.

Skills : TSQL, SQL, PL/SQL, SSIS, SSAS, SSRS, Power BI, Excel, testing, Requirements Gathering, SDLC, Agile.

Description :

    1. Created reports based on the format specified in the design document Documentation of all the processes involved in maintaining the database for future reference Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
    2. Involved in the development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for the management.
    3. Created a number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS Created reports using SQL Server reporting services SSRS, which is then exported as PDF.
    4. Reports variables are passed from ASP.NET web pages.
    5. Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and superuser reports using SSRS Created reports using SQL Server reporting services (SSRS), which is then exported as PDF.
    6. Reports variables are passed from ASP.NET web pages.
    7. Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

Junior SQL BI Developer Resume

Objective : Junior SQL BI Developer with more than two years of experience in end-to-end implementation of Data warehousing projects including Modeling, Database design, development and administration of applications with Microsoft SQL Server [] Hands-on experience in complex Stored Procedures, effective functions, Constraints, Querying, Joins, Keys, Indexes and appropriate Triggers to assist efficient data manipulation and data consistency.

Skills : TSQL, SQL, PL/SQL, SSIS, SSAS, SSRS, Power BI, Excel, Testing, Requirements Gathering

Description :

    1. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server [] and Flat files Create joins and sub-queries for complex queries involving multiple tables.
    2. Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
    3. Created indexed views, and appropriate indexes to reduce the running time for complex queries.
    4. Involved in the installation and configuration of SQL Server 2005, SQL Server 2008 and SQL Server 2012 with the latest Service Packs.
    5. Enhancing performance using optimization techniques-normalization(2nf), indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.
    6. Created Linked Servers to connect OLE DB data sources and providers Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.
    7. Used basic Script Task for renaming the file names, storing Row Count Values into User Variables.
    8. Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

SQL BI Developer - Full Time Resume

Summary : SQL BI Developer with around 7+ years of experience in database design and development in SQL server [] in OLAP and OLTP environment. Experienced with all phases of the Software Development Life Cycle (SDLC) involving systems Analysis, Design, Development, and Implementation. Highly Experience in MS SQL Server [] Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS)

Skills : Business Intelligence, Sql Server, Ms Access, SSIS, SSRS, SSIS, C++, Java, HTML, CSS, PHP, SQL, T-Sql.

Description :

    1. Participated in end-user meetings to gather Analytic/Reporting requirements of various business users.
    2. Analyzed the business requirements and translated the functional specifications into technical specifications.
    3. Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
    4. Developed various Measures and defined dimensional hierarchies.
    5. Migrated data from Heterogeneous data sources (Excel, Flat file, CSV file) to a centralized SQL Server database using SQL server integration services (SSIS) to overcome transformation constraints.
    6. Developed Dashboards with different subject matter views (drill-down/dynamic, Pivot Table, Chart). Created packages to transfer data between OLTP and OLAP database using Lookups, Derived Columns, Condition Split, Execute SQL Task, Data Flow task, Execute package task, etc.
    7. Developed SSIS packages to load the data into the tables from Text files, Excel files, and CSV files.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Science

Lead SQL BI Developer Resume

Summary : Lead SQL BI Developer with around 10+ years of extensive experience in Database design, development and administration of applications with MS SQL Server versions [] using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries. Involved in all the stages of the Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.

Skills : T-SQL, C, HTML, CSS, ASP.NET, VB, MS AZURE, SSIS, SSRS, SSAS

Description :

    1. Worked with the development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications.
    2. Involved in Database design & Data modeling various databases.
    3. Developed all the required stored procedures, user-defined functions, triggers using T-SQL.
    4. Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
    5. Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
    6. Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
    7. Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
    8. Prepared technical documents like High-Level Design Involved in Business Analysis & Requirement collection.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
Bachelor Of Science

SQL/BI Developer Resume

Headline : SQL/BI Developer with overall 5+ years of experience in Database Design, Programming, Development, and Implementation of Client-Server Applications & Database systems using MSSQL [] Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Skills : TSQL, SQL, PL/SQL, SSIS, SSAS, SSRS, Power BI, Excel, Testing, Requirements Gathering

Description :

    1. Developed and maintained web forms using ASP.Net Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
    2. Managed SQL database user accounts, user logins, permissions, database and server roles Promoted database objects from test/develop to production.
    3. Coordinated and communicated production schedules within the development team.
    4. Developed procedures and triggers involving extensive use of T-SQL to implement business rules Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL 
    5. Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks, and transformations provided by SSIS.
    6. Validated change requests and made appropriate recommendations.
    7. Developed dashboard reports using Power BI Desktop Created and Modified T-SQL stored procedures/triggers for validating the integrity of the data.
    8. Involved in Analyzing, designing, building &, testing OLAP cubes with SSAS and in adding calculations using MDX.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

SQL BI Developer - Temp Resume

Objective : SQL BI Developer with around 4 plus years of experience as MS-SQL Server Developer, involved in Design, Development, and Support of MSSQL Server 7.0/ [] for both OLTP and OLAP Systems. Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS in different fields like Banking, Sales, Insurance, and Health. Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, De-Normalization and building Referential Integrity Constraints.

Skills : SQL Server Management Studio, SSRS, SSAS, SSIS (SQL Server [] R2/ 2012), Business Intelligence Development Studio, Visual Studio, SharePoint

Description :

    1. Actively participated and interacted with users, team lead, DBAs, and technical managers to fully understand the requirements of the system.
    2. Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, stored procedures and views).
    3. Created Stored Procedures, Triggers, and User-Defined Functions to support the front-end application.
    4. Extracted data from many operational systems, including flat files, spreadsheets and RDBMSs like SQL Server and Oracle 8i.
    5. Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
    6. Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
    7. Deployed the SSRS reports in the Microsoft office share point portal server MOSS 2007.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

SQL BI Developer/Consultant Resume

Objective : Highly qualified SQL BI Developer/Consultant with over 3 plus years of experience in implementing end-to-end BI solutions using the Microsoft BI Stack (SSAS, SSIS, SSRS, and Tableau) within several industries viz. Manufacturing, Health, Service, and Insurance. Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.

Skills : Business Intelligence, Sql Server, Ms Access, SSIS, SSRS, SSIS, C++, Java, HTML, CSS, PHP, SQL, T-Sql.

Description :

    1. Gathered business requirements as an endeavor that will facilitate the planning and implementation phase of a data warehouse for reporting.
    2. Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
    3. Developed and created logical and physical database architecture using Erwin.
    4. Created stored procedures for auditing purposes as well as triggers for data consistency checks.
    5. Dramatically increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
    6. Examined and evaluated the data structures in the source and destination databases/staging Tables.
    7. Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2008R2/2012 Server target staging database.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Masters Of Information Systems