BI developers are business developers who collaborate with business analyst and customers to deliver the business requirements. A well-drafted BI developer Resume focusses on the following duties – monitoring business performance, maintaining bi models, generating reports, handling quality assurance, guiding junior staff, detecting data warehousing solutions, deploying bi solutions, creating tools to store data, conducting unit testing, evaluating and improving current bi systems, executing database queries, creating visualizations, updating technical documentation, and supporting data analytics platforms.
Successful portfolio for this post emphasizes on following skills and qualifications – prior work experience, background knowledge of data warehouse design, in-depth understanding of database management systems, ETL framework and online analytical processing; familiarity with BI technologies, knowledge of SQL queries and creative mindset. Most of the BI developers hold a degree in business or information technology.
Objective : An accomplished, quality-driven IT professional with over 8+ years of experience in design, development and implementation of business requirements as a Microsoft SQL Server Developer/BI Developer. Domain expertise in Consulting, Retail, Banking, and hospitality. Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle.
Skills : SSIS, Sql Server, SSRS, VBA.
Confidential is one of the most prestigious management consulting firms in the world.
The objective of the project was to develop a Data Integration and Analysis system to generate incentives for an international retail banking client based on the information from customer transactions.
Being a part of the reporting team our primary objective was to design and develop time and expense reports for the application using SSRS and present it in a clear and coherent manner to the senior management.
Played a key role in the design and developing the reports and in the performance tuning of the reports.
Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
Created SSIS Packages to integrate data from Text files and Excel files and File Transfer from one location to the other using FTP task.
ETL BI Developer Resume
Objective : Over 2 years of IT Experience as Microsoft BI Developer. Worked both as a team and independently; worked closely with the Business Analysts and Data Analysts and Functional Design Teams. Updated and maintained documentation for all applications developed. Applied strong interpersonal and communication skills in working with all levels of personnel to gain valuable insight and avoid potential problems.
Skills : Business intelligent development studio. MS SQL server 2008, MS office.
Conducted Data Analysis and performed Data Modeling and Created the ER diagrams using Logical Schema.
Managed the BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools.
Designed, deployed, and maintained various SSRS Reports in SQL Server 2008.
Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS.
Bachelor Of Science
MS SQL BI Developer Resume
Objective : Over 7 years of experience in implementation of business intelligence solutions, administration, Analysis, Management in the Business Intelligence, Data warehousing, Data Architecture, Client Server Technologies, Web-based Applications and Databases. 5 years of experience in Business Intelligence data visualization tools with specialization on Tableau. Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, and Root cause analysis, Resolution Methods.
Skills : Game Design, C++ Programming, Python Programming, Gameplay Programming, C# Programming.
Collect, store, and retrieve business data for analysis and reporting Define the scope, use, and worked closely with Clients & Risk team to gather requirements for designing the data warehouse model.
Determine business and systems requirements and create reports Solve technical problems related to data and guide team members Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Aggregate, Derived Column, and Data Conversion Transformations.
Created SQL Queries for maximum efficiency and performance.
Designed and implemented data warehouse architecture for corporate circulation data warehouse.
Purchasing, setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
Created Drill-down and Sub-Report using SSRS.
SQL BI Developer Resume
Objective : Over 8+ Years of IT experience including both the functional and technical sides of Data warehouse engagements and Experience with Business Intelligence Tools like Tableau Server, Tableau Desktop and Cognos 8BI, Cognos Report net (Framework Manager, Report studio, Analysis studio, Query Studio) Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
Gathered user requirements, analyzed and designed software solution based on the requirements.
Installed, configured, and deployed Tableau Server across all environments.
Maintained Tableau data extract refreshes using Scheduling and Tasks.
Administered user, user groups, and scheduled instances for reports in Tableau.
Collected data on various process measurements and formatted into graphs using Tableau software.
Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines.
Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently Set up Tableau Desktop, Data Analysis and publishing reports.
Created dashboards in IPad mode where the C level executives can use the proposed solutions Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
Database/BI Developer Resume
Headline : Software engineer with 3+ Years of experience in MS SQL Server with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS) Installation and Configuration of MS SQL Server 2008, 2008 R2, 2012 in standalone and Cluster environment. Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
Skills : SQL Server 12, SSRS 2012, Qlik Sense 3.0, Qlik View 11.20, MS Access 2013, MS Office 2013.
Responsible for creating the reports based on the requirements using SSRS 2008.
Created detailed reports for the customers by showing demographic information based on various parameters.
Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
Created custom data flow items for different SSIS packages using the VB.Net script.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Worked on performance tuning of T-SQL queries and Stored Procedures.
Senior BI Developer Resume
Objective : Over 7+ years of experience in analysis, design and implementation using Microsoft SQL Server (SSRS, SSAS, SSIS) and other MS technologies like .NET, SharePoint, PowerPivot etc. Experienced in BI suite - using Integration Services (SSIS) for ETL (Extraction, Transformation and Loading) process, Reporting Services (SSRS) for creating different types of reports and Analysis Services (SSAS) for design and developing complex cubes.
Skills : Transact-SQL, Microsoft SQL Server, Database, Microsoft.
This project was to maintain and optimize the database in the system, analyze and generate the report for operation.
Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts Responsible to create T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
Involved in management and optimization of database using SQL Profiler, Index Tuning Wizard.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server and used Analysis Services processing task to update the cube with current data.
Identified the dimensions, fact tables and designed the data warehouse using Star Schema.
Developed Multi-dimensional Objects (Cubes, Dimensions) using Dimensional modeling with dimension Hierarchies for several client side BI requirements.
Junior BI Developer Resume
Objective : Over 6+ Years of experience with MS SQL Server as a Business Intelligence and back end developer 6+ years of experience in data management and database development as a data manager and database developer. 5+ years of financial reporting and analysis with excellent Accounting background. Expert in financial transactions and report preparation. Expertise in developing and designing reports with SSRS and Report Builder.
Skills : SQL Server 2000 - 2012, Dynamics.
Responsible for implementing, developing, maintaining, and troubleshooting integrations for internal and external products.
Designed and developed data integration and reporting solutions using SQL Server Integration Services, Reporting Services.
Performed code reviews, analyzed execution plans, and refactored inefficient code to create efficiencies and controls.
Improved code functionality for optimization, performance and accuracy.
Followed data standards, resolved data flow issues, completed unit testing and system documentation for ETL and reporting processes.
Collaborated with business owners to determine business requirements then transformed data flow processes into technical requirements documents.
Collaborated with testing groups to ensure efficient releases of projects and made sure database environments were sustainable.
Work incident and problem tickets to troubleshoot day-to-day technical issues and perform root cause analysis.
Lead BI Developer Resume
Objective : Expertise in SQL programming and relational database management; Proficient in data extract, transform and load (ETL) using SSIS; Proficient in data reporting using SSRS/Excel; Strong analytical skills in data mining and validation.
Involved in designing and optimizing various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.
Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
Actively involved in logical and physical design phase of creation of the Data Mart.
Created/Modified T-SQL batches, database scripts, indexes, stored procedures, views, tables, and triggers, table-valued and scalar functions in SQL Server.
Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
Used error handing techniques like Try Catch and error functions to create robust T-SQL code.
Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema.
BI Developer Analyst Resume
Objective : Overall 8 years of experience working on Data warehousing, Data Virtualization and Data Modeling in Finance, Banking, Healthcare, Transportation business domains. Efficiently carried out Agile, Waterfall Software Development Life Cycle methodologies.
Skills : Data warehousing projects, Data preparation, and Data gateways.
Responsible for installation and Configuration of SQL Server 2008 database and configuration of Report manager.
Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008 Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
Developed, deployed, and monitored SSIS Packages.
Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
SQL Server BI Developer Resume
Summary : Around 8 Years of IT experience in Business Analysis and Business Intelligence Projects, along with 4+ years of Tableau Development using Tableau Desktop and Tableau Server. Expertise in Data Visualization tools like Tableau Desktop, Server and Reader in various versions of Tableau 6/7/8 and 9.0 Good understanding of Tableau Desktop architecture for designing and developing dashboards.
Skills : Tableau Desktop 8.2 And 9.0 Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access, Win Server 2008 R2, Active, TABADMIN, TABCMD, APIs, CSV Files, Apache 2.2, Share Point, TDE Files.
Used SSIS Packages for Moving Oracle data sources to SQL Server.
Developed several mappings to load data from multiple sources to data warehouse.
Worked with SSIS package event handlers, property expressions Responsible to tune ETL procedures and schemas to optimize load and query Performance.
Experience in generating on-demand and scheduled reports for business analysis or management Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
Involved in designing Parameterized Reports and also cascaded Parameterized Reports.
BI Developer III Resume
Objective : About 8 years of experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and Business Intelligence Suite. Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
Skills : SQL, Business Intelligence, Data Warehousing, ETL Development, IBM Cognos, IBM Datastage, Microsoft SSIS.
Involved in the Data warehouse design and development, analyzed several approaches for creating facts and dimensions and building the Data warehouse application.
Worked with Business Analysts to gather Customer requirements.
Involved in all phases of Software Development Life Cycle (SDLC): Requirements gathering and Analysis, Design, Implementation, Testing & Deployment.
Created and published packages in Cognos Framework Manager.
Developed and Implemented new BI reports using Cognos Report studio, Query Studio and Analysis Studio as per the business requirements.
Created several Cross tab Reports, List Reports, Chart Reports and also complex reports including Drill-Down and Drill-Through Reports in Cognos.
Developed Stored Procedures and Triggers in PL/SQL.
Designed, Developed and Deployed several SSRS reports in Business Intelligence Development Studio.
Masters In Computer Science
BI Developer Resume
Headline : Over 7 +years of IT Experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using BI Tools. Worked in various phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production. Strong experience creating dashboards utilizing state of the art data visualizations offered in Tableau 9.x. Proficient in design and development of various Tableau Dashboards , Reports & Storyboards Created visualizations like Map Charts based on end user requirements.