MSBI Developer Resume Samples

An MSBI Developer is a BI Developer who creates and manages the MSBI and analytics solutions that turn data into knowledge. A professional MSBI Developer Resume mentions the following core duties and tasks – translating business needs as technical specifications, designing and building BI solutions, maintaining and supporting data analytics platforms; creating tools for storing data such as OLAP cubes, conducting unit testing, performing troubleshooting processes, evaluating and improving existing BI systems, developing and executing database queries and conducting analyses; creating visualizations and reporting for requested projects; developing and updating technical documentation; and supporting the business in making better decisions.

Apart from proven work experience, the following skills are needed to work in this capacity – a background in data warehouse design and data mining, deep understanding of database management systems, online analytical processing and ETL; familiarity with BI technologies such as Microsoft Power BI; knowledge of SWL queries, proven abilities to take initiative, and problem-solving aptitude. A Degree in Computer Science or Engineering is commonplace among job applicants.

 

MSBI Developer Resume example

Msbi Developer Resume

Objective : 8+ years of experience in IT, as MS SQL Server Developer in Windows environment. Extensive experience with SQL Azure, SQL Server 2014, 2012, 2008R2, 2008, 2005 and worked extensively on BI Tools like Integration services (SSIS), Reporting services (SSRS) and Analysis Services (SSAS) Expertise in Database design, Entity Normalization & Database Creation, Maintenance, Monitoring.

Skills : SQL, SSIS, SSAS, SSRS.

Description :

    1. Worked closely with business users to congregate and comprehend requirements.
    2. Prepared of documentation for all the requirements and enhancements to reports.
    3. Designed and developed SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
    4. Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
    5. Built automated reports for business users using SSRS and SharePoint sub- scriptions.
    6. Migrated the needed data from Oracle, MySQL in to HDFS using Sqoop and importing various formats of flat files in to HDFS.
    7. Migrated ETL jobs to Pig scripts did Transformations, even joins and some pre-aggregations before storing the data onto HDFS.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Engineering


Sr. Msbi Developer Resume

Summary : Having around 7years of development experience in various domains with expertise in Microsoft SQLServer and Microsoft's suite of products like SSIS, SSAS, and SSRS Experienced in Creating, Configuring and Performance-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS Sql server 2012 and MS SQL respectively.

Skills : SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA.

Description :

    1. Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc.
    2. Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.
    3. Built efficient SSIS packages for processing fact and dimension tables with complex transforms.
    4. Included conversion of client data to standard formats using SSIS and T-SQL Queries.
    5. Developed SSRS reports and Power view reports using SQL Server R2 tools.
    6. Worked as a database developer for the SQL Server Consolidation Project, wrote complex T-SQL Queries, SSIS Packages and Data Models.
    7. Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors Of Computer


Jr. Msbi Developer Resume

Objective : Highly motivated Business Intelligence Professional - MS SQL Server Developer R2/2008 with around 5.5 years of IT experience in various Industry verticals like Health Care, Technology and Banking with expertise on ETL process, reporting and support using SSIS and SSRS. Experience working with Health Care companies adhering to HIPAA policies following strict data and information security.

Skills : SQL Server, TSQL, SSIS, SSRS, TIBCO Spotfire.

Description :

    1. Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
    2. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
    3. Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server [] environment, and deploy the data.
    4. Used Event Handlers for Exception Handling in SSIS packages.
    5. Designed the web application using Flex and CNET programming languages.
    6. 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.
    7. Designed and Developed new SSAS Tabular Models.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Master Of Science

Asst. Msbi Developer Resume

Objective : Over 8+ years of experience in Micro Soft BI Tools (SSIS/SSRS/SSAS) and T-SQL using SQL Server Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.

Skills : SQL, SSIS, SSRS, Web API, .NET MVC.

Description :

    1. Provided health and dental plans to more than 1 million covered lives worldwide.
    2. Developed complex stored procedures for the SSIS packages and SSRS reports for the various Batch jobs.
    3. Performed tuning of stored Procedures for the optimal performance of the system.
    4. Responsible for delivering innovative investment management, asset and fund administration, fiduciary and banking solutions to corporations, institutions and affluent individuals.
    5. Evolved with the changing needs of our clients and our world.
    6. Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages Working in Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
    7. Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

Assiociate Msbi Developer Resume

Objective : Strong experience in design, development, management and analysis of databases/data warehouses, ETL design & implementation (SSIS), OLAP cube design (SSAS), re- port development (SSRS), SQL Server and extensive SQL query writing experience.

Skills : OLAP cube design (SSAS), re- port development (SSRS).

Description :

    1. Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
    2. Involved in user training sessions and assisting in UAT (User Acceptance Testing) Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
    3. Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
    4. Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
    5. Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages Working in Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
    6. Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum Testing (that includes unit, integrated, regression, and UAT) a new .NET application which uses Microsoft Visual Studio.
    7. Created UAT test cases and scenarios based on Use Cases, and made sure that UAT test cases meets the business requirements.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

Msbi Developer III Resume

Objective : Over 7+ years of experience as a SQL server Developer and BI Developer(SSRS/SSIS/SSAS). Worked in various business domains like Cosmetics, Automotive, Banking, e-commerce and Insurance. Hands on experience on T-SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports. Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.

Skills : .

Description :

    1. Provided maintenance support for ETL systems.
    2. Provided reporting capabilities, subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions using SSIS and SSRS.
    3. Provided a reporting infrastructure, which includes a user-friendly interface.
    4. Provided especially to the state of Wisconsin and it also handles center for Medicare and Medicaid services (CMS) and Tricare government projects, my role in here is a SQL server developer with business intelligence, dealing with the Data warehouse and Data Mart.
    5. Involved in the business requirements gathering and analysis.
    6. Created technical design document and ETL promotional document.
    7. Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, DB2, flat file, Text Format Data, SQL Server tables and Facets systems).
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Msbi Developer II Resume

Summary : 5 years of experience in SQL Server Access database, ETL and Reporting tools such as: SSIS, SSAS, SSRS and Power BI. Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. Developed SSIS ETL Packages using multiple data sources (SQL Server, Flat Files, Excel Source files, etc.

Skills : Constraints and Roles. Developed SSIS ETL Packages.

Description :

    1. Worked on the data issues for commercial data warehouse and data mart.
    2. Worked on SSIS to remove duplicate records with data standardization.
    3. Identified various source systems for data feeds and moved to ODS.
    4. Created SSIS Package to transfer data from various locations and maintained different master packages with checkpoints and also CDC techniques, FTP/SFTP task then loaded the source data into the database.
    5. Created various Jobs, Alerts and Events, Created Backups for databases and automated the process.
    6. Experienced in enhancing and deploying the SSIS Packages from development server to production server.
    7. Performed different types of loads Incremental Load, Optimized Load & Binary Load.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Technology

Msbi Developer I Resume

Summary : Over 7+ years of IT experience in Accenture Service Pvt Ltd working in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server [] SSAS, SSIS, SSRS and TSQL.. Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS) using SQL Server [] Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.

Skills : SSIS, SSAS, SQL Developer.

Description :

    1. Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults.
    2. Used multiple join statements to retrieve data from multiple tables.
    3. Developed packages and procedures to update the data from production ERP to the data warehouse tables.
    4. Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
    5. Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
    6. Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
    7. Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Computer Sciences

Lead Msbi Developer Resume

Headline : Over 7 years of experience in IT field as a SQL Server BI Developer with experience in System Analysis, Design, Development and Support for MS SQL Servers 2005, 2008 and 2008R2 in Production, Test and Development Environments. Proficiency on the design, construction and implementation of Business Intelligence tools such as SQL Server Integration Services (SSIS) and Reporting Services (SSRS).

Skills : System Analysis, Design, Development and Support.

Description :

    1. Responsible for writing T-SQL code for creating cursor and handling data validations Scheduled Complex Stored Procedures using SQL Server Agent.
    2. Monitored and modified Performance using execution plans and Index tuning Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the project.
    3. Involved in project planning, also schedule for database module with project managers.
    4. Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
    5. Involved in planning and preparation for automating the daily build activities.
    6. Created SSIS Packages using SSIS Control flow Tasks, Transformations ( Lookup, Derived Columns, Condition Split etc) in efficient manner within deadlines as per business requirements.
    7. Created SQL Jobs to run SSIS packages on scheduled basis.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Engineering

Msbi Developer Resume

Summary : A Microsoft certified Professional with 8+ yrs. of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using SQL Server Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.

Skills : Strong understanding of BI application design and development principles.

Description :

    1. Translated business requirements into ETL design specifications.
    2. Experienced in using transformation of Data flow task.
    3. Implemented Package Configuration to create setup and also deployment at different environment like dev, stage, test and production.
    4. Handled Quarterly, Monthly Releases across all the environments.
    5. Wrote SQL Queries to retrieve data from database.
    6. Extensively worked on debugging ETL process graphs.
    7. Experienced in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Technology