A Business Intelligence Consultant is the front end person who takes charge of business intelligence/warehouse projects. The main task and responsibilities that is carried out by these BI consultants includes creating and designing reports, setting up a logical layer in-between data source and ad hoc query tools, retrieving loads of data efficiently and working with the technical team to design and model data warehouse systems. These consultants take charge of Designing, developing and implementing BI and Analytics system, assist in BI reporting, provide functional and technical guidance, assist project heads in budgeting, forecasts and timelines, compare operational progress with that of project objectives and develop performance metrics reports.
As the Business intelligence Consultant needs to query data fast, they are expected to have high knowledge of SQL, write complex sub-queries, multi table joins and have proficiency in employing RDBMS applications. Even though there are no strict educational requirements, companies prefer a Business Intellignce Consultant Resume that depicts a Degree in IT, Computer science or Business Administration.
Summary : Designed, created, analyzed, and presented reports to senior executives, delivering analytical insights that showed ineffective marketing and vendor management opportunities. Created accurate statistical forecasting models that predicted future sales.
Skills : Business Intelligence, Information Technology.
Description :
Managed Hyperion optimization and stabilization project by creating and updating a detailed project plan.
Helped setup and define business planning process and map out allocation process with business end users.
Worked with Planning Capex, Revenue, Workforce and Hyperion Public Sector Planning and Budgeting models.
Created Planning data sources, Planning forms, Financial Reporting Reports, wrote calc scripts, created task lists, created business rules, created SmartView VBA input templates, created Hyperion Financial Reports, setup SmartView input sheets, loaded source data, and created allocations.
Created drill-thru from Hyperion models back to source EBS, PeopleSoft and other source systems.
Created and modified data loads using load rules, text files, SQL, ODI(Oracle Data Integrator), and Essbase Studio.
Helped clients implement Hadoop solution to meet their business and technical needs.
Experience
7-10 Years
Level
Management
Education
Information Technology
Sr. Business Intelligence Consultant Resume
Summary : Business Intelligence Suite. 7+ years of experience in Microsoft's Business Intelligence technologies (SSAS, SSRS, SSIS. 4 years of experience in designing, developing, optimizing and administering SSAS Tabular Models.
Skills : SQL, Business Intelligence, SAS, Visual Basic, MicroStrategy, Data Mining, Data Warehousing, Tableau, Healthcare, Financial Modeling, Financial Analysis, Database, R, Python.
Description :
Maintained and updated Salesforce database.
Extracted data from Salesforce database and applied business logic to load them into the enterprise data warehouse for sales forecasting and financial performance analysis.
Worked with DBA to design and implement star/snowflake schema data model.
Designed dashboards with transaction services for sales tracking and forecasting.
Worked extensively in building MicroStrategy projects by creating attributes, facts, metrics, filters and hierarchies.
Maintained complex MicroStrategy schema by updating or adding attributes, attribute relationships and facts to efficiently support new reporting requirements.
Played an effective role in the architecture updates which involve the remapping of the existing objects to the columns in new tables.
Enhanced the response time of reports by adjusting caching strategy and creating Intelligent cubes.
Experience
7-10 Years
Level
Management
Education
Master Of Finance
Jr. Business Intelligence Consultant Resume
Objective : Extensive experience with the design and development of Tableau visualization solutions. Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
Skills : Sharepoint, Framwork, Business Intelligence.
Description :
Evaluated and worked on several Business Intelligence Platforms such as Qlikview in order to compare and contrast specific client's needs against Tableau.
Migrated content from Production, to QA to Development Environment.
Used Actions extensively to link and filter sheets for easier navigation in Dashboards.
Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau.
Created Interactive reporting dashboards by combining multiple views.
Created extensive joins for data blending from several different data sources.
Helped customize Tableau Server with Company Logo and Company Pop-Ups.
Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
Experience
2-5 Years
Level
Junior
Education
Diploma
Business Intelligence Consultant III Resume
Summary : An accomplished and tenured IT professional with a diverse background spanning Business Intelligence Consulting, DataBase Administration and Data Analytics. Strong team player with over 10 years of professional experience that includes team leadership skills.
Skills : Oracle, SQL, Databases, Tableau, Integration, SAP HANA, PL-SQL, Javascript, MS SQL Server.
Description :
Report lead for License and Commission consolidation project for one of the largest life insurance organizations in the United States.
Existing Producer and Compensation systems for over 300,000 Agents, processing over 12 million transactions per month.
Lead successful Callidus product suite upgrade, from 5.x to 7.x, for large health insurance provider.
Upgrade included platform migration from Windows to Unix and reporting tool change from Actuate to Crystal Reports.
Worked with business team to identify and manage application changes as a result of the upgrade.
Design, develop and support TrueComp Manager and TrueInformation applications for Fortune 500 pharmaceutical company.
Summary : 15 plus years of IT experience in System design, development and maintenance. Involved in several facets that can help provide holistic insights into the business. One such facet is information management that involved monitoring data quality and monitoring the processes by which data is created, captured and stored.
Skills : Tableau, Business Objects, Crystal Reports.
Description :
Worked in the team evaluating the BI processes at GEAM.
Provided best practices and recommendations to improve productivity.
Worked on the Discovery, Assessment, GAP Analysis and Identifying BI opportunities.
Lead the development of reporting and analytics solutions for GEAM's wealth management division by gathering business needs, documenting requirements, identifying appropriate data sources, developing reports, and delivering them to stakeholders.
Involved in all steps of Software Development Life Cycle (SDLC).
Gathered report requirements from the users, preparing draft specifications, generating new reports.
Took direction from, and collaborated with, the Manager, Business Intelligence and the Director, Business Intelligence on work priorities and managed the resolution of escalated issues.
Experience
7-10 Years
Level
Management
Education
MS
Business Intelligence Consultant I Resume
Summary : Over 18 years of technology experience focused on analytics, data, and related platforms, across a variety of industries.
Skills : Business Intelligence Project Management, IT Infrastructure Project Management.
Description :
Developed data warehouses for consumer packaged goods, telecom, manufacturing, biotech, and logistics companies.
Worked with clients to determine business intelligence requirements.
Designed custom data warehouses, incorporating Kimball dimensional design concepts.
Developed extract, transformation, and load processes using Cognos DecisionStream (ETL).
Assisted project managers with all areas of the project life cycle, including scheduling, budgeting, and risk and issue tracking.
Implemented ten data warehouse projects based on Cognos Analytic Applications.
Developed long-term relationships with clients to win repeat business.
Experience
7-10 Years
Level
Management
Education
B.S. In Management
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.
Description :
Responsible for business analysis, estimation of projects, and provide billable activity for various clients.
Estimate labor for design, development, implementation, and deployment tasks within BI.
Extensively worked on SQL and T-SQL code for various reports and ETL work flows in SSRS and SSIS.
Worked with various client in understanding their needs and engaged in detail communication to provide business intelligence solutions.
Tracked and report billed time in a thorough and detailed manner.
Develop and support Business Intelligence applications, diagnose and fix problems related to BI/Data.
Mentor/Train others in business intelligence-relates skills and participated in BI Team meetings.
Experience
7-10 Years
Level
Management
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.
Description :
Provided services for entire project lifecycle, using Agile methodology.
Gathered high-level requirements for subjects of interest for entire project.
Gathered specific requirements for dashboard and report deliverables for individual subject areas of interest implemented as project phases.
Interacted with VPs, managers and analysts.
Designed and developed star schema with 3 fact tables, 21 dimension tables, populated using SSIS ETL tool, updating near real-time.
Populated 45 tables in staging area using PowerCenter ETL tool.
Designed and developed more than 15 reports using SSRS reporting tool, a prototype SSAS cube, and a prototype PPS dashboard.
Experience
7-10 Years
Level
Management
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.
Description :
Involved in Security Design and Implementation, performance tuning of reports, unit testing and documenting the processes.
Uploaded Master and Transactional data from flat files.
Responsible for writing Shell Script to load individual Source Systems in database.
Created the test case scenarios for the developed source systems which should be loaded in the database.
Experience in loading data to Oracle 11g and automated the process using Control M jobs and Shell script.
Created database tables from in Oracle and loaded them using shell scripts.
Documented the daily operational process of generation of different financial reports.
Experience
7-10 Years
Level
Management
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.
Description :
Worked with business process owners in collecting Project specifications and their Analysis.
Loaded Data mart tables using Informatica.
Created mappings to load tables with Informatica.
Created Design documents and Report Validation Documents.
Design support of star schema to emulate existing operational business rules and provide multidimensional access to business information.
Interacted and held meeting with upper management to get projects specifications.
Automated the entire Analysis process for client thus realizing 45% in time savings and 30% in cost savings.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.
