- Featured in:
-
More BI Consultant Resumes
Use these BI Consultant samples as a guideline or visit our extensive library of customizable professional resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Statistics Resume Samples
BI Consultant Resume Samples
No results found
0-5 years of experience
Worked on Data Modeling and Performance Tuning of Queries utilizing best practices.
- Interacted with Customers to get the requirements and also trained them with developed objects.
- Developed reports on OTC to give insight into customer behavior and improve sales patterns.
- Involved in developing reports on P2P to manage inventory efficiently thereby increasing productivity.
- Designed Queries using BEX Query Designer helped business analyze data in BEX Analyzer.
- Monitoring daily and Periodic data loads using Process chains.
0-5 years of experience
[company name] is a leading provider of advanced metering infrastructure (AMI) solutions that help utility companies improve revenue services, customer service, delivery reliability, and workforce utilization.
- Interacted with the business users directly, gathered business requirements, and analyzed and compiled deliverables for various multi-dimensional queries and reports.
- Enhanced and modified business content DataSources, InfoProviders, reports and transformations after understanding and documenting the requirements from SRM (P2P), QM and PP area.
- Created documentations for object mapping, functional and technical design specifications for InfoProviders, and business content DataSource enhancements.
- Improved Sales Item DataSource to upload the Sales Order item data along with style numbers so users can do sales analysis with respect to style numbers.
- Scheduled batch jobs data load coming from various source system.
- Modified FI business content base cube, virtual cube and function module according to client’s requirement in order to satisfy the requirement of balance-sheet report.
- Created Process Chains for master and transaction data load.
- Generated BEx Queries for Warranty Report, Inventory Aging, Sales representative efficiency, and Vendor delivery efficiency.
0-5 years of experience
Responsible for requirement definition, analysis, scope and time estimation for Cognos reports
- Responsible for solving users technical/functional issues
- Involved in installation and evaluation of report net (Framework Manager, Query Studio, Report Studio and Cognos Connection)
- Defined metadata modeling created packages by using framework manager and published those packages into Cognos connection
0-5 years of experience
Worked as a Senior BI Consultant involving in multiple phases of the Implementation.
- Performed analysis, design, development and implementation of standard/customized InfoCubes and ODS objects for MM, FI-CO, QM, PM modules.
- Successfully implemented 4-4-5 customized FM logic in order to convert legacy Wyeth applications to utilize new fiscal calendar in reporting.
- Extracted MM-Purchasing data at Schedule, Header and Line item level using 2LIS_02_xxx, Data Sources and generated reports on Purchase order deliver quantities.
- Updated technical specifications in GX Parma to generate unique VAL document number for the report.
- Developed front-end queries using Query Designer & Web Application Designer and published results on the web. Used Navigational attributes, Filters, Structures, Exceptions and Conditions.
- Designed Data store Object (standard, write optimized, Direct update) for staging and reporting of sales data.
- Worked with Pfizer specific query collection tools for transporting the query elements along with Transport connection, Transport Organizer (SE09).
- Analyzed Query run times in ST03 and proposed aggregates solution to improve the performance of the query.
- Migration of Flow from BW3.5 to BI7.0 version which includes data source migration , transformations in place of update and transfer rules and Query migration.
0-5 years of experience
Currently Technical lead for Operational Risk DWH. Working directly with Business Analyst teams to provide reporting solutions for end users to meet Federal Regulatory rules.
- Successfully implemented BI/Data Warehousing using Informatica applications/MSAS Cubes to meet needs of users.
- Worked on new DB2 Stored Procedures, Table Functions and Views to meet ETL Loading/Cube requirements.
- Implemented QlickView Dashboard for Data Visualization for the Operational Risk Data.
- Build and Deploy customized reports in Tableau using the underlying data from the Operational Risk Data Warehouse whenever requested by Operations Risk User Group.
- Provide support to Existing System to accommodate any change request raised by Operations Risk User Group.
- Worked on multiple modules for performance improvement of existing process and successfully implemented them and deployed to Production.
0-5 years of experience
Delivered business and data analysis on customer interaction assessments for the Customer Care Organization as part of [company name]’s continuous improvement of their customer’s experience.
- Assessed customer’s data warehousing needs and developed a baseline, functional solution in the first 14 days, in the absence of access to SQL server, used MS Access to provide rapid delivery.
- Developed ETL and data infrastructure, using SSIS, in the first 30 days, sourced from multiple data warehouses.
- Developed metric and analytic foundation for chronic callers, negative value customers, customer touches, and CSAT in the first 60 days.
0-5 years of experience
Involved in many projects implementing BW solution
- Involved in BW upgrade to 7.*
- Implementation and upgrade of BO 4.*
- Developed and supported Bex, backend BW objects, Webi and crystal
- Implemented legacy system to BW migration.
- Involved in FI, Energy business units within DLA.
0-5 years of experience
Design and develop Framework Manager model in Cognos 10 and develop each Milestone Work Down Curve report with drill down to work order details
- Develop dashboards representing KPI for each Milestone
- Provide Production Support for existing reports and troubleshoot helpdesk issues
- Track and Fix issues and generate RFC so that fix can be tested and deployed successfully to Production.
- Work with Work Management team members, Engineering, Plant operators and Planners to understand Outage process and each Milestone
- Update Business Requirement documents and prepare technical design for Framework Model and each Milestone Work Down Curve
0-5 years of experience
- Client Interaction. Requirements gathering and design documents creation.
- Coordinated with team explaining high level design, performing quality checks on deliverables, ensuring on time deliveries, helped team in resolving technical issues. Conduct weekly status call and share progress report.
- Involvement in analysis, design, development, testing, customization, deployment and support of Cognos BI solutions.
- Installation and configuration of ReportNet software including Framework Manager, Report Studio, Query Studio. Installation of Cognos Series 7. Upgrade installation from Cognos 7.2 to Cognos 7.3
- Implemented security for Data access, Object level access and Package access. Created User Groups, Roles to implement the Cognos Security, using Access Manager & Active Directory.
- Designed and developed reports using Report Studio by creating Prompts, Complex Dashboard Reports, Cascading Prompts and Drill through Functionality. Created ReportNet Package.
0-5 years of experience
- Evaluated the existing data warehousing and Business Intelligence settings, and provided strategy, roadmap and architecture solution for transitioning to SAP BW environment.
- Utilized SAP BW to design Info sources, Info objects, ODS and Info cubes. Utilized Bex Analyzer and Reporting tool to produce BI reports for decision makers.
- Assisted with Functional Specification and design for the development of new systems.
- Utilized SAP products.
0-5 years of experience
Apply Data modeling best practice to existing BW environment to get better query performance.
- Provide production support and administration of BW back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed.
- Also includes resolution of daily issues/requests, performance management, Data Validations, Consistency checks and production migrations.
- Monitoring of Data loads using Process chains and Monitoring of System and loading performance
- Deleting data in PSA to free the Tablespace
- Ticket Handling of different priority
0-5 years of experience
Worked extensively in FI – (A/P, A/R, FM, GM), Procurement (MM, SRM), HR and E-Recruiting Public Sector modules
- Translated business requirements into a EDW data model and then activated the BI content for the first wave go-live agencies to be developed from ECC modules MM, SRM, HR and E-Recruiting
- Involved in the design and development of the Data flow architecture for Procurement (Purchase Order and Purchase Requisition) information for the Staging/Integration layers.
- Developed the Headcount and Personnel Actions cube and Employee (0HR_PA_0) / Personnel Actions (0HR_PA_1) Data-sources, Organization Management – Staffing Assignments related to Organizational Position Count, Workforce analysis.
- Worked on Compensation Analysis and Average Salary analysis for the District Employees, E-Recruiting – worked on Application Sourcing, Candidacy, Job Requisitions, Application Support Team and Requisition Support Team.
- Involved in the customization of Business content for MM, SRM, HR and E-Recruiting objects, Migration of 3.x data-sources to 7.0, transforming ABAP code in transfer/update rules to Transformations involving Start routines, field-routines and End-routines.
- Involved in creating views, customized data sources, writing CMOD, ETL process for both standard and customized Info Providers (Info Cubes, Data Store Objects).
- Created custom Function Modules for extracting Employee Certification information and extracting Employee Payroll Arrears for different In-Periods.
- Worked on BI reports Extended leave analysis for Employees, Life insurance for employees 70 years or more, E-recruiting requisitions’ status for open positions etc.
- Involved in creating Process Chains to load the Master Data and Transactional Data from ECC(R/3) and BI systems
0-5 years of experience
- Travel to Colombia and Ecuador to analyze business requirements and work with the BI team creating an implementation plan as most of the time we were working off site
- Activate standard infosources for COPA and SD (Shipment, Sales, Shipping, Billing). Create enhancements with ABAP code and add more standard fields for SD extractors
- Analyze and create Cubes, ODS, Infosets, Multiproviders and Process Chains, create and modify transformations with formulas, MD and ABAP start and end routines
- Create new objects to accomplish business requirements like new aggrupation’s
- Create detailed queries to be viewed in Analyzer and summarized queries to use with WAD’s
- Create Generic Data Sources for Oracle and SQL DB
0-5 years of experience
- Responsible for analysis, management and delivery of business intelligence solutions with involvement in all stages of the development lifecycle.
- Developed Business Objects Universes, Cognos Catalogs, and Crystal Dictionaries
- Developed reports using Business Objects versions 5 and 6.5, Cognos Impromptu, MS Access and Crystal Reports
- Developed Oracle Data marts
- Developed various tools to allow users to write their own ad hoc reports
- Handled client liaison, working closely to install reporting tools
- Clients included Shell Oil (Houston, TX) and Duke Energy (Charlotte, NC)
Rate This Article
[BI Consultant]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
