Business Intelligence Consultant Resume Example

BUSINESS INTELLIGENCE CONSULTANT

Career Focus

To utilize my analytical, technical and functional skill cross-functionally while working on high value deliverables. I am a self-motivated individual with expertise in professional IT experience over 5 plus years, which includes in Big data ecosystem Hadoop and also analyze data from multiple sources to deliver services such as business intelligence reports, dashboards and visualizations using software tools such as Tableau, Power BI and MicroStrategy. Key Responsibilities Includes: *Executed IT Projects, forecast and cost analysis, designed Executive Dashboard using Tableau, Power BI and MicroStrategy. *Over 3 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases and Experience in industries such as High Tech, Financial, Accounting, Automotive, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering. *One plus year of work experience in ingestion, storage, querying, and processing and analysis of Big Data with hands on experience in Hadoop Ecosystem. *Experience in working with Cloudera. *Expertise in complete project life cycle (design, development, testing and implementation) of Client Server and Web applications. *Good knowledge in installing, configuring, and using Hadoop ecosystem components like Map Reduce, HDFS and Hive. *Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Management, Supply Chain, Sales/Marketing and Variable Objects with formulas. *Excellent report writing and communication skills developed through numerous presentations of deliverables to client stakeholders. Gained expertise in creating deliverables using MS Office Suite.

Accomplishments

Industry Company High Tech Cisco, Microsoft, EMC Entertainment Walt Disney Company Telecommunications Cisco, CI-V Contact Center Financial Services State Farm Insurance Automotive Industry Manheim, Inc Adesa, Copart.

Professional Experience

Business Intelligence Consultant
April 2014 to Current Seattle Manheim, WA

Tableau Consultant
San Francisco, CA

Manheim is the largest remarketer of vehicles worldwide, auctioning 10 million vehicles per year.
Manheim's primary business is wholesaling vehicles via a bidding process that can done in traditional or online.
With large inventory of 10 millions of vehicles per year, Manheim quickly needed to analyze and model large volumes of data to realign its dealer network and improve sales performance.
The company wanted a better way to integrate, analyze and exploit data to improve sales performance.
Understanding the functional and technical specification per client requirements.
Deep experience with the design and development of Tableau visualization solutions.
Build and maintain SQL scripts, indexes, and complex queries for Manheim Sales data analysis and extraction.
Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
Regular involving in calls with Manheim Sales team and discussing about status and new requirements of the projected Quarterly Sales.
Preparing Dashboards using calculations of Manheim sales data, parameters in Tableau.
Used Trend Lines, Parameters, Aggregate, Functions, Filters.
Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards for Manheim Sales management actionable insights.
Connected Tableau server to publish dashboard to a central location for portal integration.
Created visualization for Quarterly Sales Performance calculation and dealer network analysis across U.S.
Maintained Test log and Wrote test Evaluation, Sales Summary Reports.
Analyzed dealer network user and Sales team requirements attended periodic meetings for changes in the application requirements and documents.
Analyzed compactors Sales data of Adesa and Copart to see market trends and competitive actions to develop strategic plans to grow sales volume and market share for Manheim Sales Team.
Increased Manheim Sales revenue by 15% in the CRM market within 3 months of the project and an on going process.
Environment: Windows 7 and Linux, Tableau, Tableau server, MS-Excel, SQL Server , SharePoint, Microsoft office, SQL-PLUS, Visual Basic, CRM.

Principal Consultant
Seattle, WA

The Microsoft (TWC) Group has five Data Sources Product Inventory lists, which is full of noise, discontinued and outdated Product Inventory.
In order to get to a validated set of software products and services that can become initial list, manual validation of this data will be needed.
Microsoft (TWC) requires having clean and accurate software product and services inventory list, which can be used for future validation.
After a clean and accrete product inventory list Microsoft (TWC) requires better future of supply chain, sales and production operations to make better, fact-based decisions using Microsoft Power BI.
In order to improve data source product inventory list and create Power Bi Dashboard and accrete reports, consultant Ravi Verma responsibilities are:.
Effective at communicating technical issues to non-technical users.
Translating the Microsoft (TWC) business requirements into specific systems, applications or process designs for very large complex IT solutions and integrating architecture.
Proven record of business decision making through detailed analytics, insights and Real-Time reporting on Key Performance Indicators (KPIs) and product inventory list results.
Created and maintain advanced Power Pivot solutions, and integrate with SharePoint Business Intelligence features and functions.
Integrated large Product Inventory list from SQL Server Data Sources into Hadoop traditional ETL by accelerating the extraction, transformation, and loading clean and accurate product list into Microsoft Power BI.
Ability to see risks identify issues, and execute mitigation steps with guidance from the project team.
Improved the accuracy of Data Source.
Create exclusion list for the product and services for future use.
Reduce large sum of noise de-dupe data source.
Create multiple rule set for current and future use.
Manually review and filter product inventory list.
Document spec for Algorithm and manual iteration of Data Source.
Contact product and service owners for validation of product and service inventory.
Identify valid knows and unknowns from product and service inventory list.
Mapping of products and products families from one data source to another.
Demonstrated ability to identify business and technical impacts of user requirements and incorporate them into project plan.
Querying data in SQL Server for accrete Data Sources of Product Inventory List.
Connect all five Data Sources Product Inventory list from SQL Server to Excel and CSV files.
Transforming Product Inventory list into Power Query by filtering a table, sorting a table, removing columns, and merging multiple tables to obtain better data analysis.
Merging all 5 Product Inventory List Data Sources into one data set.
Created visualizations and reports using Power View and Power Map Environment: Hadoop, SQL Server, SharePoint, VM Station, Power BI, PowerView, PowerQuery, PowerPivot, PowerMap.

Data Architect/Big Data Engineer
May 2013 to February 2014 EMC － San Francisco

While working with EMC Isilon Scale-out Storage Solutions for Hadoop combine a powerful yet simple and highly efficient storage platform with native Hadoop integration that allows you to accelerate analytics, gain new flexibility, and avoid the costs of a separate Hadoop infrastructure.
This helps gain credibility and garner a reputation for reliable predictions by creating a Big Data framework and deploying tools to capture, transform, analyze and store terabytes of structured and unstructured data.
Assists in the analysis, design and development of fully integrated technology solutions.
Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
Configured SQL database to store Hive metadata.
Loaded unstructured data into Hadoop File System (HDFS).
Created reports and dashboards using structured and unstructured data.
Assists the Sales Team to develop and implement specific account penetration strategies, produce account specific product and service and sales plans.
Leverages knowledge of competitive solutions to effectively address and dispel customer objections to EMC solutions, and train the account team.
Technical emphasis is on hardware capabilities, software requirements and systems integration.
Qualifies sales opportunities in the terms of technical requirements, competition, decision making process and funding.
Define and assist with the designing of sales related training and on-boarding programs.
Possesses detailed product/technology/industry knowledge.
Environment: Hadoop, Hive, Pig, HDFS.

June 2011 to September 2012 Accenture INC － San Francisco, CA

Role: Technology Consulting - IT Strategy, Network Enabled Solutions Project: State Farm Insurance Role: Contact Center Call Flow Consultant:.
Participate in the different aspects of State Farm contact center call flow design.
Identifying select skill groups the call is being routed to right agents.
Participate in State Farm Insurance meetings to identify items impacting the skill groups.
Developed deliverables for complex projects using Accenture knowledge repository and industry.
Delivers consulting engagements that meet and exceed State Farm Insurance expectations.
Meets delivery commitments in terms of timeliness and quality.

Release Management Consultant
CISCO SYSTEMS, INC

Participate in the functional solution design process and understand the overall solution.
Provide assistance in identifying the tech arch components to support the overall solution a infrastructure and network.
Assist in the Cisco demand clearing process for infrastructure provisioning.
Participate in Cisco Release Management meetings to identify items impacting the project timeline.
Identifying potential risks derived by other team's activities that are using a shared infrastructure.
Responsible for managing communications and deliverables in coordination with the Enterprise and Release Management Office.
Profile capable to support the analysis of the technical infrastructure based off the functional solution design.

Senior Sales Analyst
CISCO SYSTEMS, INC

Prepared correspondence, reports, and high quality presentations.
Process analyst supporting manual pay work stream.
Review current adjustment processes, controls, policies and procedures;.
Develop hypothesis for likely sources of overpayments.
Design and implement process and policy control improvements to prevent ongoing overpayments.
Develop and execute overpayment recovery plan.
Review SDLC process being used to implement FY13 Comp Plan Changes; identify and implement improvement opportunities Project: CA_C-IV Counties Role: Software Business Technology Lead.
Gather web chat and contact center requirements, design web chat infrastructure to support the above requirements.
Implement web chat application, configure, build and test Cisco Web Interaction Center application.
Build and test script based on contact center solution requirements, highlevel Cisco Computer Telephony Integration.
Option script and Cisco Unified IP Interactive Voice Response.
Project: Walt Disney Company Role: Work Stream Consultant.
Assist Lead in performing data collection, gap analysis, and future state recommendation.

Disney Worldwide Services, Inc

has requested form Accenture to develop a Strategic Master Plan that accomplishes the following high-level deliverables.
Provide detailed recommendations based on current industry best practices related to deployment of IT assets in Disney owned, partner owned, collocation and hosting facilities, with high availability, rapid and flexible deployment, accurate tracking of assets, and best cost being significant business drivers.
Create a Master Plan that details the recommendations for timeframes and planning resources necessary to implement a strategic re-location of environments and applications.
Evaluation of existing Disney IT environments Gap analysis of existing environment and application data.
Evaluation of Virtualization opportunities Comparison of current state.

Education

Bachelor of Science : Information Systems, May '10 San Francisco State University Information Systems

Bachelor of Science : International Business, June '11 Accenture Core Analyst School － St Charles Boston, IL MA International Business Negotiation, Project Management, Conflict Resolution, Client Relationship Building

Interests

Actively mentor junior colleagues and high school students.

Sports: cricket, basketball, soccer, tennis and golf.

Enhancing my knowledge about new technology, financial markets and business ventures.

Skills

Requirements Analysis *Project Management *Scrum *CRM *Microsoft Power Business Intelligence *SQL Server *Power Query *Cisco Unified IP Interactive Voice Response *Power View *TCP/IP *Power Map *Gap Analysis *SDLC *HDFS *Deal Shaping *Isilon Scale-out Storage Solutions *Project Planning *MS-Excel *RFP *Power Point Presentation *Salesforce *Power Pivot *SQL Data Management *Share-point *Tableau *Linux *Big Data *Microsoft Visio *Hadoop *Unix *Cisco-IP Telephony: IP Contact Center (IPCC *ITIL information storage technology library *Cisco-Contact Center *VMWARE *Budgeting and Forecasting *MicroStrategy *Cisco-Voice *Requirements Development *Requirements Analysis *Scope and Requirements Management *Scrum *Contact Center Technologies *Microsoft Power Business Intelligence *Technical Test Planning-Preparation-Execution *Power Query *My SQL *Power View *Team player *Power Map *Strong written and oral communication *Hive *Flexible *Deal Shaping *Methodical and data driven *Project Planning *Cloudera *RFP *Project Management *Salesforce *CRM *SQL Data Management *SQL Server *Tableau Server 9.2 *MicroStrategy

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service