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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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