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.
Cisco, Microsoft, EMC
Walt Disney Company
Cisco, CI-V Contact Center
State Farm Insurance
Business Intelligence Consultant April 2014 to CurrentSeattle 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 2014EMC － 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.
June 2011 to September 2012Accenture 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.
Bachelor of Science : Information Systems, May '10San Francisco State UniversityInformation Systems
Bachelor of Science : International Business, June '11Accenture Core Analyst School － St Charles Boston, IL MAInternational Business Negotiation, Project Management, Conflict Resolution, Client Relationship Building
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.
*Microsoft Power Business Intelligence
*Cisco Unified IP Interactive Voice Response
*Isilon Scale-out Storage Solutions
*Power Point Presentation
*SQL Data Management
*Cisco-IP Telephony: IP Contact Center (IPCC
*ITIL information storage technology library
*Budgeting and Forecasting
*Scope and Requirements Management
*Contact Center Technologies
*Microsoft Power Business Intelligence
*Technical Test Planning-Preparation-Execution
*Strong written and oral communication
*Methodical and data driven
*SQL Data Management
*Tableau Server 9.2