BI Consultant Resume Sample
Zane Herzog
38025 Rolfson Garden,
Los Angeles,
CA
+1 (555) 440 2105
Work Experience
Senior BI Consultant
11/2017
-
PRESENT
Chicago, IL
- Experience for Consultant or 5+ years for Senior Consultant
- Years of mandatory hands on experience in SAP BW on HANA 7.40 version or higher
- Good Knowledge and hands on experience with ABAP Programming required for BW Implementations
- Work closely with end users in the development and maintenance of BW Objects
- Hands on experience & strong exposure with latest HANA Modelling objects is required (Creation of Composite Providers, Advanced DSO's, Open ODS Views etc.,)
- HANA Architecture experience and Native HANA Modelling Experience
- Optimization of the BW on HANA data flows, experience in working with large datasets & developing complex BEx queries
BI Consultant
12/2014
-
06/2017
Boston, MA
- Customize and develop RPD layers of BI (Physical, BMM and presentation layers), configuring metadata objects and Web catalog objects
- Design and configure multidimensional ERDs (star and snowflake) schemas; data model
- Write data queries, analyze data model relationships
- Create end-user reports and dashboards
- Participate in the design of BI security
- Troubleshoot BI tools, metadata, query and data issues
- Assist developers with unit, integration and validation testing
Junior BI Consultant
01/2010
-
06/2014
Los Angeles, CA
- Experience with SAP Business Objects reporting is required, any hands-on development of Webi reports would be an added advantage
- Experience in understanding business requirements, writing functional and technical specs is a required
- Excellent verbal and written communication skills, ability to interact with both business and technical stakeholders
- Create business specification documentation from the business requirements and produce flowcharts and related visual aids to clarify business understanding
- Conduct workshops and Joint Application Design (“JAD”) sessions for determining the business requirements
- Define and document user requirements for BI and analytics
- Coordinate the planning, designing, configuring and implementing of a BI solution across functional and technical team areas
Education
Lawrence University
2005 - 2009
Bachelor's Degree in Statistics
Professional Skills
- Experience in working with a range of data tools for example, Ab Initio, Informatica, DataFlux, Datanomic, Trillium, Teradata, IBM InfoSphere DataStage SQL, Access/Excel, Tableau, MicroStrategy, etc.
- Strong organisational and problem solving skills - demonstrating ability to solve complex challenges and obstacles to achieve results
- Strong presentation and public speaking skills are desired
- Experience collecting, synthesizing, and prioritizing input from multiple sources
- Experience in collecting, synthesizing, and prioritizing input from multiple sources
- Proven experience managing delivery teams
- Advanced knowledge of SQL and Microsoft Excel with prior data mining experience
How to write BI Consultant Resume
BI Consultant role is responsible for database, business, reporting, analysis, design, english, analytical, retail, finance, credit.
To write great resume for bi consultant job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For BI Consultant Resume
The section contact information is important in your bi consultant resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your BI Consultant Resume
The section work experience is an essential part of your bi consultant resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous bi consultant responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular bi consultant position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative BI Consultant resume experience can include:
- Good to have skills like R and SAS
- Very good written/spoken English skills, fluent or native Polish
- Solid business analysis skills are highly coveted
- Business Analysis - Demonstrated experience or formal training per International Institute of Business Analysis (IIBA) guidelines
- Business Analysis – Demonstrated experience or formal training per International Institute of Business Analysis (IIBA) guidelines
- Strong experience in developing Oracle Business Intelligence (OBIEE) solutions across core commercial work streams - Finance, Supply Chain or Procurement
Education on a BI Consultant Resume
Make sure to make education a priority on your bi consultant resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your bi consultant experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in BI Consultant Resume
When listing skills on your bi consultant resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical bi consultant skills:
- Possesses a strong business acumen, and experience in analytical / problem solving skills
- Excellent problem solving, organizational, interpersonal, and oral/written communication skills
- Good presentation skills, capable of motivating and convincing people about their ideas
- Skills in designing and implementing analytical solutions in Microsoft Azure or Amazon AWS public cloud environments
- Knowledge in Hadoop data engines and corresponding open-source technologies as well as NoSQL database skills
- Good industry or business experience in one of the following industry: Finance, Telco, Retail or Manufactory
List of Typical Experience For a BI Consultant Resume
1
Experience For Senior BI Consultant Resume
- Good hands-on experience in business use case led design and implementation of multidimensional information models and OLAP cubes
- Strong analytical approach grounded in measuring performance improvement and actionable results
- Becoming a subject matter expert for data management within the FIS Services team
- Mapping of Business Requirements to information management and technical solutions
- Scrum Mastering an agile team (all it entails including process, compliance, quality, team building)
- Partner with data and technology teams to improve measurement and reporting capabilities by connecting data models/outputs into a unified reporting system
- Assists in aggregating and interpreting working data
2
Experience For Oracle BI Consultant Resume
- Evaluate ongoing analytics and insights needs from stakeholders and implement reporting in automated business intelligence environment
- Deliver BI platform assessment, planning and optimization expert services, including in areas such as operations and performance
- Data modeling, data processing and visualization
- Closely work with multiple teams, stakeholders and independently manage end to end projects i.e. requirement gathering to solutioning to final delivery
- Create dashboards using reporting tools like Tableau and Power BI
- Prepare presentations using analysis frameworks and story boarding techniques to communicate insights to stakeholders
- Assist with development of training content and delivery of training via classes
- Participate in training and deployment of BI solution
3
Experience For SAP BW / BI Consultant Resume
- Prepare meaningful and actionable insights for marketing leadership to drive improved campaign performance
- Design and deploy reports and reporting structure to support trained business users as well as non-technical users
- Assess current capability of existing data mart and BI tools. Recommend and as much as possible implement changes as necessary
- Collaborate with sales, business consulting, data science and client management teams in the entire Teradata organisation
- Build predictive models using R or Python on customer datasets and enable proactive learnings actions on customer behaviors
- Assist in adhoc analysis, BI reports and presenting results in clear manner to senior business leaders
- Analyze large datasets using MS Excel, VBA and Macros to discover trends and patterns
4
Experience For Data / BI Consultant Resume
- Assist in adhoc analysis, BI reports and presenting results to senior business leaders
- Re-configures existing reports. Gathers requirements from Stakeholders. Funnels ad-hoc requests from Stakeholders
- Collects data to support changes to existing policies and procedures as needed
- Implement data models in the system and guide programmers throughout the development of ABAP coding
- Work directly with agile IT teams, providing efficient ways to improve BIRST functionalities
5
Experience For Cognos BI Consultant Resume
- Provide formal, written technical status updates using a program-defined template and process related to the Oracle analytics technical track
- End-user report development, from requirement gathering to design, build, test, deploy and documentation
- Support and diagnosis on existing BI installations
- Implement new or maintain existing business solution in SAP BW/BI area based on user requirements analysis
- Propose, program or configure, document and test business solution in SAP BW/BI application modules according to the functional and technical requirements
- Willingness to learn more about business intelligence concepts like Data Modelling Methodologies (Data Vault, Kimball etc.)
- In depth knowledge of at least one front end reporting tool (Microstrategy, Tableau, Business Objects, Cognos or Oracle BI)
- Construction and monitoring of business indicators, focused on E-commerce
6
Experience For BI Consultant / Developer Resume
- Ensure the best possible performance, quality, and responsiveness of application
- Lead development of customer, campaign and analytical database environments through careful coordination of internal analysts, the IT organization and 3rd party vendors
- Provide direction and strategic insight for the following key database tasks
- Manipulate data in SAS/SQL environment to create actionable insights which align to business objectives
- Work preparations (high level + technical analysis and backlog refinement) Daily connect with Business Consultants and Business Solution Analysts
7
Experience For Junior BI Consultant Resume
- Build, deploy and maintain effective reports to support Canada Sales Management and Lines of Business using business intelligence tools such as Business objects and Crystal Reports
- Maintain an expert understanding of how data flows into and out of BI tools (end to end process) ; engage in conversations with technology, management and respective team on roadblocks, workarounds and enhancement requests
- Recommend and implement changes with respect to new enhancements
- Partner with technology (FTT) and ensure alignment with business vision is achieved
- Provide relevant subject matter expertise and thought leadership in modern BI and data visualisation, for enterprise organisations
- Actively lead and participate in selected services demand generation, pre-sales (i.e. presentations and demos) and delivery efforts in the International region
8
Experience For SAP BI Consultant / Developers Resume
- Act as trusted advisor for our clients and prospects for BI and data visualisation solutions, architectures and databases in an analytic ecosystem environment at scale, both on-premises and in the cloud
- Participate in pre-sales and project definition activities (i.e. RFP responses, scoping workshops and exercises, solution architecture development etc.)
- Internal and external reporting for vendors
- Develop and implement solutions using variety of IBM Cognos technologies
- Never stop learning new technologies and strive to become a thought leader in all facets of Business Intelligence
- Support projects teams with design and implementation of analytical database layers in support of BI applications
- Actively contribute to fostering a community of internal BI and data visualisation professionals across the region and develop reusable sales and project assets
- New vendor implementations and new features via Google TagManager
9
Experience For Junior SAP BI Consultant Resume
- Plan, design and develop IBM Cognos metadata models
- Gather business requirements and use cases from customers and translate those requirements into top-down technical solutions and design documentation across all aspects of the business intelligence solution
- Design and build prototype solutions based on initial business requirements
- Develop and implement interactive dashboards to help drive business decisions
- Support and mentor customers on the various IBM Maximo/Cognos BI tools and technologies
10
Experience For ETL / BI Consultant Resume
- BI Architecture design and review
- Analyze large datasets to discover trends and patterns
- Understands the application of statistical techniques and concepts to leverage in predictive analytics work
- Create aggressive goals and realistic timelines. Pursues long-term objectives in the absence of short-term results
- This role combines a strong blend of technical database development and data blending/manipulation skills with a critical lens around how to use these skills to deliver Reporting & Analysis outcomes for the business
- Provide support for following key database tasks
- Collects, analyzes and reports statistical data and service specifications to determine standards and establish quality and reliability
- Analyzes data gathered and develops solutions or alternative methods of proceeding. Formulates data gathering protocols for recording, evaluating, and reporting data
List of Typical Skills For a BI Consultant Resume
1
Skills For Senior BI Consultant Resume
- Participate on presale activities and bidding process – requests for information (RFIs), requests for proposal (RFPs), statements of work (SOWs), project planning, execution and completion on time and in budget
- Strong analytical skills from business and statistical perspectives
- Strong analytical, written and verbal communication, and interpersonal skills
- Demonstrated experience in designing and implementing enterprise-wide institutional reporting strategies using data mart or data warehouse solutions
- BI project hands-on willing attitude with good team lead experience
- Leverage learning and prior work experience to implement and support Ellucian’s Business Analytics products
- Leverage learning and prior work experience to implement and support Ellucian’s Business Intelligence and Analytics products
- Consulting services experience - i.e. the direct provision of technical services to external teams, stakeholders or customers
- Experience in researching, analyzing and summarizing data into impactful business cases to senior management
2
Skills For Oracle BI Consultant Resume
- Experience in a consulting role, delivering or leading the delivery of services to Financial sector clients
- Experience in leading the implementation of data analysis and reporting projects
- Experience building advanced Dashboards for ongoing measurement and self-service needs – Salesforce Einstein Analytics, Tableau, PowerBI
- Experience working on projects or programs requiring the integration of cross-functional technology and/or business solutions
- Several years’ experience using Kimball methodology designing dimensional models and related ETL solutions
- Experience working with Hyperion Reporting and Oracle Data Integrator (ODI) is highly beneficial
- Experience developing requirements and specifications for cross enterprise reporting in a higher education environment
3
Skills For SAP BW / BI Consultant Resume
- Demonstrated ability to provide reporting support from operational, management, research, and planning perspectives
- Hands on experience with Predictive analytics projects from defining the problem to delivering scalable solution
- Experience in using raw data to create metrics and dashboards that can measure performance and inform decision making
- Hands on experience with Descriptive and Predictive analytics projects from defining the problem to delivering scalable solution
- Experience in Database configuration, sizing and tuning (E.g. SQL Server, Oracle, …)
- Experience with Logical and Physical Data Modelling, Database Architecture
4
Skills For Data / BI Consultant Resume
- Experience with Data Warehousing and ETL Methodologies
- Experience with Data Modelling, Database Architecture
- Customer facing project experience
- Two (2) years of work experience in a role requiring interaction with senior leadership (e.g., Director level and above)
- Experience in consulting based on Oracle Database Products
- Experience in Database Development & Reporting & Analysis
- Experience working on an international environment and able to travel
- Functional: preferably an experience in the banking/insurance or telco sectors,
5
Skills For Cognos BI Consultant Resume
- Maintain excellent understanding of 3rd party files and respective data
- Maintain excellent understanding of CRM system and backend database
- Any background/experience with Graphic Design
- Experience with BI solutions based on non-traditional Big Data databases (Hive, HBase, SimpleDB, MonetDB etc)
- Conduct meetings with users to consolidate, understand and document all information requirements
- Knowledge of specific tools or skill sets
6
Skills For BI Consultant / Developer Resume
- At least 0,5 year workexperience with BI and/or Big Data
- Demonstrated mix of analytical and technical competencies
- Experience in MS SharePoint
- Hands-on experience with MicroStrategy (MSTR) as a consultant level
- Experience with Client facing role, focus on Client satisfaction
- Work experience in SAP BW/BI functional area
- Skilled in implementation, customization and maintenance of SAP BW/BI module
7
Skills For Junior BI Consultant Resume
- , hands-on experience with OBIEE (11g and higher) Answers, dashboards, scorecards and reports
- Anticipate and evaluate the impact of possible problem solutions prior to implementation
- Strong Knowledge in Oracle SQL and PL/SQL
- Experience or awareness of Big Data and Data Science related technologies, such as R, Hadoop or Python, to design and implement predictive analytics models
- Design and develop effective reports and dashboards to present information in a clear and informative manner
- Capture client requirements and model data to develop an effective intelligence solution
8
Skills For SAP BI Consultant / Developers Resume
- BW/BI experience
- Good communicator and influencer. Is able to convey BI in laymen’s language to senior stakeholders
- Closely cooperate with the team with touch of other BI knowledge
- Relevant BI experience of 5+ years in BI topics
- Building complex SQL queries to extract the required data and leveraging Excel or reporting solutions like Tableau, Power BI etc. to communicate the insights
9
Skills For Junior SAP BI Consultant Resume
- Designing and implementing Analytics solutions
- Assessing and reporting development progress against plans
- Working knowledge of fundamental database modeling and design principles
- Engaging in pre-sales opportunities and supporting business development
- Leading requirements gathering workshops and review sessions, translate complex business requirements into technical solutions
- Training and development opportunities - several thousand interactive courses
10
Skills For ETL / BI Consultant Resume
- Working knowledge of the data warehouse life cycle as well as star schema and/or denormalized database design
- Working Knowledge in OBIEE 12c
- Utilising specialist knowledge of advanced analytics techniques to deliver analytics solutions to improve our client’s businesses
- Providing Functional and Technical solutions in Oracle Business Intelligence
- Managing stakeholder relationships across the business in a friendly but outcome driven fashion
- Defining and sharing MicroStrategy best practice including creation of services assets
List of Typical Responsibilities For a BI Consultant Resume
1
Responsibilities For Senior BI Consultant Resume
- Excellent communication skills, the ability to present confidently to clients
- ETL skills in Microsoft SSIS, Informatica
- Learn continuously to grow your personal skills and professional expertise
- Stakeholder management skills, able to gather requirements, present findings and train users on new processes or functionalities
- Significant experience using Microsoft BI Stack, Azure Data and Analytics stack, and Power BI
- Performs gap and risk analysis to identify and prioritize areas for organizational performance improvement
- Hands-on experience with large amounts of data with ability to use Data Analysis tools like MS Excel, SQL
- Experience with BI and Advanced Analytics (SQL, NoSQL, On-premise and Cloud) solutions
2
Responsibilities For Oracle BI Consultant Resume
- Assist in developing a strong data practice team with FIS iWorks
- Experience in Advanced Data Modelling techniques
- Develop an understanding of the customer experience and the resources available to best investigate and address key issues
- Experience in Business Intelligence with a focus on dashboard and report solutions
- Develop recommendations for how to measure the impact of an experience to customer cohorts
- Experience in Big Data analytics would be highly beneficial in one or more of Hadoop, Hive, HBase, MongoDB or MapReduce
- Experience with Sales-force Wave Analytics
- Experience with SAP BI, SAP Data Services
3
Responsibilities For SAP BW / BI Consultant Resume
- Instilling trust & confidence with the client, whilst ensuring that commercial objectives are achieved
- Delivering data management services to clients, both on-site and from FIS offices
- Every new hire gets a detailed training plan containing 2 weeks on-site training about Teradata architecture
- We are looking to hire ambitious consulting professionals who combine their technical acumen with a genuine enthusiasm for improving organisations
- Be motivated by learning and applying latest technology trends as well as enjoy drilling into the different technical layers of software solutions
- Plan design and develop IBM Cognos reporting, querying and analysis solutions specific to Work and Asset Management solutions (i.e. Maximo)
4
Responsibilities For Data / BI Consultant Resume
- Provide consulting / delivery using iDR Methodology
- Provide training and consulting for clients on Ellucian’s Business Analytics products for various Banner functional areas
- Strategic thinking ability, with an analytical approach to problem solving
- Knowledge in startup, shutdown, error monitoring, troubleshooting WebLogic / BI Servers
- Provide training and consulting for clients on Ellucian’s Business Intelligence and Analytics products for various Banner functional areas
5
Responsibilities For Cognos BI Consultant Resume
- Create customer solutions leveraging OACS, OBIEE, and ELT tools
- Performance tuning of analytics processes to meet requirements of reports and ETL jobs
- Work location is in Austin, TX. (This is an office reporting role)
- This is a billable consulting role. Requires up to 50% travel
- Communicates to Stakeholders regarding new tools, reports, capabilities, and changes
6
Responsibilities For BI Consultant / Developer Resume
- Vast amount of online trainings covering Teradata DB, DWH Methodologies, Big Data and more with Teradata University
- Each BI Consultant is eligible for up to 10 training days per year
- Coordinate workload in accordance to pipeline of ongoing maintenance support tickets and enhancements requirements
- Work with end clients in creating BIRST spaces and models
- Design and implement working models
- Design BI standards and determine data processing protocols
- Extract Transform and Load (ETL) using SQL Server Integration Services
7
Responsibilities For Junior BI Consultant Resume
- Have a working knowledge of Work and Asset Management data sets in Maximo
- High proficiency in SQL programming and development
- Perform analysis, design, development, and testing to implement Ellucian’s Business Analytics products
- Maintain working relationship with clients and direct contact with senior level executives at client sites as necessary
- Take initiative and ownership of project by working independently as well as in a team environment
- Basic knowledge in Linux Environment (OBIEE Server is running in Linux Servers)
- Knowledge in Administering WebLogic Server 10.3.6
8
Responsibilities For SAP BI Consultant / Developers Resume
- Knowledge in Administering OBIEE Enterprise Manager (Fusion Middleware Control)
- Knowledge in Troubleshooting BI related errors from the WebLogic / BI Logs
- Knowledge in applying Patches on OBIEE Environment. (WebLogic and OBIEE)
- Install, configure and build Oracle’s pre-built analytics applications
- Performs high level root cause analysis
- Analyzes current business processes and/or SOP’s and makes recommendations for improvement to maximize efficiency
- Performs mathematical calculations and applies statistical methods to optimize service delivery processes, staff requirements, and service standards
- Communicates with management, employees and customers to assist the development of service standards and publicize methods and results to create organizational learning and internal public relations
- Coordinates quality control objectives and activities to resolve service problems, maximize service reliability, and minimize cost
9
Responsibilities For Junior SAP BI Consultant Resume
- Follows up to ensure that savings are actualized and the processes are followed
- Lead analysis and designs of the SAP BW solution in close cooperation with the clients
- Ensure stabilization of the solution and continuous improvements
- Support solutions design and delivery for Big Data, Advanced Analytics, BI, Data Warehousing and Reporting engagements through the Pre-sales, Solution Architecture, Design and Delivery Phases
- Lead the discovery and analysis of requirements
- Influence Information Management solutions, especially for Security, Capacity Planning, Data Migration, Data Governance, and Reusable Assets (DevOps/ Automation, Frameworks etc.)
- Work with our Directors and support the Subject Matter Expert in Business Development
10
Responsibilities For ETL / BI Consultant Resume
- Build strong relationships with clients to understand their unique and relevant business challenges and opportunities, and earn credibility through successful delivery
- Keep up to date with the latest industry and technological trends in Data and Analytics, and present such topics to Client and CGI Teams
- Mentor peers and staff members where needed
- Demonstrable experience with predictive model generation and relevant reporting, preferably with understanding or experience with integrating predictions back to business rules or source systems
- Demonstrable experience with visual design methodologies and real-world implementation using systems such as Power BI and/or Tableau
- Project Planning & Scope Analysis
- Partner with business stakeholders to understand the questions they are trying to solve
- Draft target information management architectures
- Drive the articulation of principles and standards for data migration
Related to BI Consultant Resume Samples
BI Data Analyst Resume Sample
Work Experience
• Be a subject matter expert in all analytics questions
• Demonstrated ability to synthesize and aggregate large amounts of information; derive strategic trends and insights for thoughtful, articulate point-of-views and executive-level presentations
• Know how to find and descr...
Professional Skills
• Strong analysis, critical thinking, and an...
• Strong creative thinking, problem solving ...
• Team player with strong interpersonal rela...
BI Engineer Resume Sample
Work Experience
• Experience in the design, development, and testing of Data Warehouse implementations both traditional relational and Hadoop/Hive based solutions
• Experience with Apache Hadoop/Hive integration, R, Spark, Kafka, Java, C#, working with 3rd party API’s (Facebook, Criteo, Google)
• &n...
Professional Skills
• Strong programming skills, relational data...
• Strong programming skills, relational data...
• Excellent verbal and written communication...
SAP BI Consultant Resume Sample
Work Experience
• Part of a SAP BI team that analyzes, designs, and implements architecture of BI/BW/BO projects in order to meet solution needs; leverages resources diverse experiences to ensure customer needs are met
• Gathering and validating business requirements
• Translating business req...
Professional Skills
• Proven experience in SAP Analytics in a cl...
• Strong hands-on experience in SAP BOBJ 4.0...
• Written and oral communication skills in E...
Analyst / Senior Quantitative Analyst Resume Sample
Work Experience
• Chartered Financial Analyst (CFA), Financial Risk Manager (FRM) designation
• Monitor the effectiveness of models in use and continually update model parameters with actual results and changing trends
• Create, enhance and maintain models and model parameters for various mode...
Professional Skills
• Hands on experience with credit risk model...
• Other programming/software familiarity: st...
• Excellent interpersonal and communications...
Full Stack .NET Developer Resume Sample
Work Experience
• Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office etc.)
• Unit and Integration Testing – planning, execution and evaluation
• Production Release preparation and coordinati...
Specialist, BI Resume Sample
Work Experience
• Understands logical and physical data models, data modeling methodologies
• Experience in data reporting and visualization area with atleast 2-3 years’ experience on Tableau development
• Experience as BI/DW consultant
• Intelligence, analytical mindset...
Professional Skills
• Attention to detail and strong interperson...
• Strong skills and experience with scriptin...
• Strong project management skills including...