BI Consultant Resume Samples

A Business Intelligence consultant or the BI Consultant is a professional who undertakes the job of developing and implementing business intelligence systems. The job description involved analyzing the acquired data, evaluating the systems, and testing new ones. The other responsibilities are listed on the BI Consultant Resume as follows – testing and documenting BI systems, evaluating current data and analytics systems, translating business needs into technical specs; establishing procedures for data sharing, building predictive models and machine learning algorithms; and using data visualization techniques to present information.

The most sought-after skills for the post include the following – familiarity with the industry in the role, data mining expertise, solid knowledge of machine learning, strong skills in reporting and statistics, experience as a BI consultant, and deep understanding of all types of business intelligence tools and data processing frameworks. The minimum requirement includes a degree in computer science, engineering or related domains.

 

BI Consultant Resume example

Business Intelligence Consultant/Supervisor Resume

Summary : An Information specialist specializing in big data. Help businesses create, store, secure, and use information. Being proficient in both proprietary and open source tools, help businesses answer questions by implementing intelligent solutions.

Skills : SSRS, Power BI, Crystal Reports, Excel, SQL.

Business Intelligence Consultant/Supervisor Resume Format

Description :

  1. Responsible for business analysis, estimation of projects, and provide billable activity for various clients.
  2. Estimate labor for design, development, implementation, and deployment tasks within BI.
  3. Extensively worked on SQL and T-SQL code for various reports and ETL work flows in SSRS and SSIS.
  4. Worked with various client in understanding their needs and engaged in detail communication to provide business intelligence solutions.
  5. Tracked and report billed time in a thorough and detailed manner.
  6. Develop and support Business Intelligence applications, diagnose and fix problems related to BI/Data.
  7. Mentor/Train others in business intelligence-relates skills and participated in BI Team meetings.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
B.S. In Computer


Business Intelligence Consultant/Coordinator Resume

Summary : Fifteen years of experience as a highly accomplished independent consultant specializing in business intelligence and data management. Excellent ability to learn and get up to speed on new tools.

Skills : Expert in reporting, dashboard UI/UX, and analysis.

Business Intelligence Consultant/Coordinator Resume Model

Description :

  1. Provided services for entire project lifecycle, using Agile methodology.
  2. Gathered high-level requirements for subjects of interest for entire project.
  3. Gathered specific requirements for dashboard and report deliverables for individual subject areas of interest implemented as project phases.
  4. Interacted with VPs, managers and analysts.
  5. Designed and developed star schema with 3 fact tables, 21 dimension tables, populated using SSIS ETL tool, updating near real-time.
  6. Populated 45 tables in staging area using PowerCenter ETL tool.
  7. Designed and developed more than 15 reports using SSRS reporting tool, a prototype SSAS cube, and a prototype PPS dashboard.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Arts


Business Intelligence Consultant/Manager Resume

Summary : Extensive experience of around 8 years in various Business Intelligence Analytical Tools and Data warehousing. Extensive work experience on system analysis, design, development, testing and implementation of projects.

Skills : Business Intlegence, SSRS, PowerPivot Models using DAX, SSAS multidimensional cubes, SqlServer, SSIS, SSRS, PowerView, PowerBI, ETL constructs to build Datamarts, PowerQuery.

Business Intelligence Consultant/Manager Resume Example

Description :

  1. Involved in Security Design and Implementation, performance tuning of reports, unit testing and documenting the processes.
  2. Uploaded Master and Transactional data from flat files.
  3. Responsible for writing Shell Script to load individual Source Systems in database.
  4. Created the test case scenarios for the developed source systems which should be loaded in the database.
  5. Experience in loading data to Oracle 11g and automated the process using Control M jobs and Shell script.
  6. Created database tables from in Oracle and loaded them using shell scripts.
  7. Documented the daily operational process of generation of different financial reports.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Technology

Business Intelligence Consultant Resume

Summary : Proficient in utilizing BI tools to satisfy end user data needs. Performs Data Analysis functions. Implements small projects or components of large projects. Ability to solve medium to complex problems.

Skills : Tableau, Sap BW BO.

Business Intelligence Consultant Resume Example

Description :

  1. Worked with business process owners in collecting Project specifications and their Analysis.
  2. Loaded Data mart tables using Informatica.
  3. Created mappings to load tables with Informatica.
  4. Created Design documents and Report Validation Documents.
  5. Design support of star schema to emulate existing operational business rules and provide multidimensional access to business information.
  6. Interacted and held meeting with upper management to get projects specifications.
  7. Automated the entire Analysis process for client thus realizing 45% in time savings and 30% in cost savings.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Business Objects

BI Consultant Resume

Objective : Certified SAP BPC consultant with 7 years of IT experience in that 5 years as a SAP BPC Consultant and 2 years as SAP R/3 FI/CO consultant Created and Maintained Application. Sets(Environment),Dimensions and Applications(Models) in BPC Excel at developing and implementing reporting and data reconciliations using SQL and SAP tools.

Skills : Business Intelligence, Cognos, Data Warehousing, MicroStrategy.

BI Consultant Resume Format

Description :

  1. Developed Business Process Flows to guide end-users through pre-defined sequential tasks that span across the different departments within the organization.
  2. Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
  3. Developed custom Process chains to support master data and transaction data loads fromBI to BPC.
  4. Created Package links to bundle more than one packages and to run sequentially.
  5. Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.
  6. Worked on setting up Security and Audit settings to ensure user entitlements and access rights.
  7. Configured drill-through functionality in Reports to see the underlying data from external databases.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
B.E. In Computer Science

Sr. BI Consultant Resume

Headline : Over 9 plus years IT experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Data Analysis, Development, Testing, Implementations and Documentations of Data Warehouse/Data Marts deployments, project management, organizational skills, Business Intelligence solutions, with strong attention to detail.

Skills : Business Objects, Data Warehouse, Databases, ETL, Business Intelligence, Business Analysis.

Sr. BI Consultant Resume Format

Description :

  1. Responsible for Performed functional design and test planning, preparation and executions such as the creation of data and scripts to test complex systems.
  2. Conducted meetings with clients and management regarding analysis requirements.
  3. Compiled and analyzed documentation for conversion to assertive forms.
  4. Coordinated points to be recorded and common conventions with subordinates.
  5. Prepared and reviewed reports for all concerned parties.
  6. Worked with users to design and develop valuable BI solutions.
  7. Developed data driven reports, dashboard and analytics.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Senior
Education
Education
Finance

Jr. BI Consultant Resume

Objective : Over 8 years of IT experience in Design, development & Administration of Business Intelligence Solutions with Microsoft SQL server with various business domains like finance, sales & communication, banking sectors. Good experience in Information Technology field as a SQL Server Developer with strong expertise in SQL server development.

Skills : Microsoft Project, Budgets, Scheduling, Workforce Planning, P&L Management, Planning, Microsoft Excel, Microsoft Office.

Jr. BI Consultant Resume Sample

Description :

  1. Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server.
  2. Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  3. Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  4. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  5. Handled multiple projects with team players cross functional across enterprise to setup the data model that fits all requirements.
  6. Worked edin fast paced agile methodology using JIRA tool.
  7. Created analytical reports and visualization using TIBCO Spotfire tool.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Finance

BI Consultant III Resume

Summary : Senior Business Intelligence Consultant with over nine years of experience working on numerous data warehouse and business intelligence projects, including Fortune 500 companies. Exceptional problem solving and troubleshooting skills in complex, highly integrated data warehousing environments. IBM Certified Developer, Designer and Administrator for Cognos versions 8 and 10.

Skills : SAS, SQL, Business Analysis, Information Technology.

BI Consultant III Resume Sample

Description :

  1. Reviewed of requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects.
  2. Worked on Tableau Desktop for blending databases and creating different interactive views and dashboards.
  3. Created extract files for improving the performance.
  4. Used different Mark types and Mark properties in views to provide better insights into large data sets.
  5. Created various types of charts, interactive reporting dashboards, combine multiple views to provide better visualization.
  6. Worked with data metrics and business analysis teams to analyze, define and publish firm-wide performance and risk metrics to enable managers to make informed decision.
  7. Contributed in weekly meetings, reviews, and user group meeting while communicating status updates to stakeholders.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
MS In Business Intelligence

BI Consultant II Resume

Objective : Over 7 years of professional IT experience in BI & Data Warehousing, generating OLAP reports using Cognos Enterprise Suite 8.x/10.x. Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design converting requirements specifications into functional specifications.

Skills : IBM Cognos, Sql Server, Oracle, Framework Manager, Transformer, Core Java.

BI Consultant II Resume Model

Description :

  1. Responsible for Interacting with the End users to gathering the reporting requirements.
  2. Created Technical Design Documentation for Reports, Framework Models and Stored Procedures.
  3. Created Test Cases for Reports, Framework Models and Stored Procedures.
  4. Designed models using Framework Manager and deployed packages to the Report Net Servers.
  5. Implemented Security in Framework manager for Database level, Object based level and Package level.
  6. Participated in team meetings to provide ideas to achieve the goals of the clients.
  7. Worked with developers to create applpications that will address retail clients.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Computer Applications

BI Consultant I Resume

Objective : Over 8+ years of IT experience with over 5 years of experience in SQL Server Suite of products (SSIS and SSRS) and Expertise in End-to-End Process for software life cycle. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Complex Inner and Outer joins, Triggers, Except Clause using T-SQL.

Skills : Data Architecture ,Data Modeling, SAP HANA, ETL, Informatica.

BI Consultant I Resume Format

Description :

  1. Provided adults and seniors with short-term nursing, rehabilitative, therapeutic, and assistive home health care services.
  2. Responsible for Involved in developing Technical Design specification documents for different interfaces.
  3. Migrated data from different sources and built enterprise data warehouse with data stage.
  4. Created physical ER drawings for different star schemas from the logical drawings in Erwin.
  5. Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  6. Worked on Huge Data Transfers from & to SQL Server Databases using utilities/tools like DTS, SSIS, BCP, BULK INSERT etc.
  7. Developed Excel based analytical models fro clients.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Certificate

Assistant BI Consultant Resume

Summary : Over 7 Years of extensive experience in SQL Server Development, including writing T-SQL Programming, SSIS and SSRS. Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.

Skills : Business Intelligence, Excel, Power BI, Tableau, Economics, Finance, Business Analysis, Sales.

Assistant BI Consultant Resume Format

Description :

  1. Lead provided of health care data analysis and targeted member and physician messaging services.
  2. Coordinated care, to make health care easier to navigate and to make service more customized and personalized for the members.
  3. Responsible for Experience in developing new or existing SSIS packages.
  4. Experienced in enhancing or developing complex stored procedures.
  5. Experienced with SQL in developing stored procedures, views, performance tuning.
  6. Extracted data from oracle database to SQL server.
  7. Developed SSIS packages using Tasks such as Containers and Data transformations Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing and Parsing.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors In Technology

Associate BI Consultant Resume

Objective : Over 5+ years of IT experience in Tableau desktop which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data mining applications. Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.

Skills : ODI, OBIEE, PLSQL, Oracle, Sql Server.

Associate BI Consultant Resume Example

Description :

  1. Responsible for Developed a 360 business dashboard with multiple panels and parameters.
  2. Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  3. Tested, Cleaned, and Standardized Data to meet the business standards using SQL, Conditional Split, Data Conversion, and Derived column in different environments.
  4. Interacted with Client manager/team members on weekly basis.
  5. Analyzed reporting requirements and developed various Reports & Dashboard.
  6. Experienced in various filters, quick filters, table calculations, calculated measures and parameters.
  7. Created Users, Groups and Set Permissions on Server.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors In Electronics

BI Consultant Resume

Objective : Ensure best practices are implemented in the business self-services environment; guide the business in performing best practice approaches to craft business self-service solutions, troubleshoot business created artifacts as well as promote data analytics and re-use of analytical insight.

Skills : Proficient With MS Office Including Access And Excel, Redshift, SQL Server, SSRS, SSIS, SQL, T-SQL.

BI Consultant Resume Example

Description :

  1. Extensived knowledge of Business-Intelligence concepts, practices and procedures .
  2. Advanced knowledge of and proficiency with Microsoft-Office products, ER Diagrams, Data Modeling, Process Modeling, RDBMS platforms and Client/Server Systems.
  3. Advanced understanding of Relational-Database principles.
  4. Strong analytical skills and statistical knowledge.
  5. Hospitality Maintained Cubes for regional Headquarters to present occupancy metrics.
  6. Provided technical solutions that enable Tufts Health Plan to successfully maintain business operations using Alteryx, Cloudera and Tableau.
  7. Developed product category structures to enable accurate demand modeling
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master Of Computer Applications

BI Consultant/Supervisor Resume

Objective : Over 15 years of professional experience in the field of Software System Design, Development, deployment, Project Management Practices and BI solutions architecture. Involved in implementing full life cycle of BI Projects which includes Data warehouse/ETL, Data Modeling, design, development and in BI solutions architecture using Industry leading BI Tools for Modeling/ETL/Reporting/Administration (BO 4i, SAP BOXI R2/R3 (InfoView, WebI, Crystal Reports, CMC, Import wizard etc.

Skills : Program Management, Information Management, BI / DW.

BI Consultant/Supervisor Resume Model

Description :

  1. Reported TracFone Wireless is America's largest and number one prepaid cell phone provider in the United States.
  2. Responsible for Demonstrated several demos to business owner and user community to have a strong understanding about Business Objects application that we developed and product features.
  3. Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
  4. Involved in analyzing business requirements Converted business requirements in business/technical requirement documents.
  5. Involved in Redesigning the Business View Logic within the Crystal Report and deploying it within Universe on top of which had Crystal Reports and WEBI deployed.
  6. Prepared Documentation to understand how the reports will work and how to use the functionality with step by step.
  7. Automated critical business functions and creating administrative and process efficiencies through technology.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Finance