We provide IT Staff Augmentation Services!

Technology Lead - Business Intelligence Resume

Sunnyvale, CA

PROFESSIONAL SUMMARY:

  • 8+ experience as a Sr. Data Analyst/Lead BI Consultant with a Systems Engineering Background.
  • Expert in Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence Tools, and Modern Data Warehouse concepts.
  • Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Online; developed most suitable user interface such as Dashboards, multiple charts types, trends, custom requests in Tableau .
  • Migrated multiple manual reports/KPIs/dashboards manual reports from excel into self - service reporting Tableau BI solutions.
  • Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
  • Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management.
  • Sound understanding of Big Data Analytics and its technologies, IoT concepts, AWS Cloud Services. SMAC (Social, Mobility, Analytics and Cloud)
  • Excellent Domain knowledge and experience in Finance Services and Banking, e-Commerce, Manufacturing, Supply chain and Inventory, Human Resources and ERP Processes.
  • Good understanding of machine learning algorithms using R. learning machine algorithms using R.
  • Proficient in writing complex SQL queries and Views for fetching data from multiple data sources like Oracle, SQL server, SAP HANA, HP Vertica, Postgres, MySQL, Hive, Impala, Presto, Spark SQL etc.
  • Experience in designing custom Excel Export and objects for Management Dashboard reporting using Excel Pivot and Charts .
  • Integrated Alteryx with Tableau. created datasets in Alteryx and integrated with tableau for visualization.
  • Worked on PoC/projects using Hadoop Ecosystem including integration with Analytics/BI tools for Data visualization for Retail, Banking and Automotive clients.
  • Excellent Communication and presentation skills. Strong experience in working with Agile Scrum development methodologies and JIRA project management tool i.e. JIRA Administration, JIRA Reports/Dashboards.

TECHNICAL SKILLS:

BI/ETL Tool: Tableau, Pentaho, Visokio, Informatica ETL, Visokio 8.0, Excel (Pivots and Charts) for data analysis

RDBMS/Data Sources: SAP HANA, Oracle, SQL Server, MySQL, PostgreSQL, PL/SQL, Presto, SparkSQL, Hive, Cloudera Impala

Concepts: Hadoop Ecosystem (Hadoop, Hive, Impala, PIG, Sqoop), AWS Cloud Services, IOT

Office Tools: MS Office Suite (Expertise in Excel, Word, Power-point), Microsoft Visio

Other Tools: JIRA, SharePoint, Bugzilla, SVN, GIT Alfresco, TOAD, PL/SQL Developer

Scripting Languages: Shell Script, Pig

Operating systems: MS Windows, Linux

PROFESSIONAL EXPERIENCE:

Technology Lead - Business Intelligence

Confidential, Sunnyvale, CA

Responsibilities:

  • Technology Lead for BI and working as Lead Tableau developer for Global Business Intelligence - Launch Execution Dashboards department.
  • Leading Tableau HANA BI team and managing All GBI Launch Execution Dashboards.
  • Migration of All Tableau Reports into Tableau JS API framework to improve the performance of reports.
  • Developed Near Real time reporting solutions in Tableau using SAP HANA.
  • Formulated and executed best practices for those Tableau reports developments.
  • Worked on multiple Tableau POC’s to improve the Overall Dashboard Performance.
  • Work with various types of data connections, including HP Vertica, SAP HANA, and Teradata as well as XLS and CSV files
  • Actively manage over 1000 Tableau Server users, regularly provide enhancements to existing reports, as well as collaborate with business users to efficiently develop new reports and dashboards which are visually easy to understand while at the same time maintain the accuracy of the core information content
  • Analyzed user and business requirements, attended periodic meetings for changes in application requirements and documents

Sr. Data Analyst/ Sr. Tableau Developer

Confidential, Raleigh, NC

Responsibilities:

  • I am working as a Data Analyst/Tableau consultant through Confidential
  • Works with Business Users/clients to understand, design & document the BI & Reporting Requirements.
  • Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
  • Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management.
  • Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, Data lakes, spreadsheets etc.).
  • Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Page Trails, and Density Chart.
  • Provided customer support to Tableau users and Wrote Custom SQL to support business requirements and deploying Tableau reports and publishing them on the Tableau and Share point server.
  • I have also implemented a number of operational efficiencies and self-service reports for my team and other stakeholders.
  • Developed SQL queries for ad-hoc report generation and migrated Excel based reports to Tableau BI.

Sr. Data Analyst/ Tableau Consultant

Confidential, Jacksonville, Florida

Responsibilities:

  • Worked as an offshore Data Analyst/Tableau Consultant through Tech Mahindra, Work with Business Users/clients to understand, design & document the Requirements.
  • Prepare business use case understanding document capturing the use case, proposed solution and challenges.
  • Data discovery, Aggregation and Transformation based on business use cases and requirement.
  • Creating table structure over data in HDFS using Hive, perform required transformations and writing SQL scripts to extract data from Hive tables for visualization.
  • Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
  • Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
  • Dashboards from Tabular Models to help managers to identify critical KPIs(Agent performance, average hold time, Contact center performance KPIs)and publishing them into Tableau Server which facilitate strategic planning in the organization.
  • Tableau consulting to peer team members along with business teams on data visualizations/Report Development.

Sr. Data Analyst/ Tableau Consultant

Confidential

Responsibilities:

  • Decide upon the business use case to be implemented based on current market requirements and keeping AT&T enterprise customer in mind.
  • Dashboards and Reports Development using BI tool Tableau for Various KPIs as per the business requirement like on user profiling, Sales and customer data.
  • Data discovery, Aggregation and Transformation of data based business use cases and requirement using data sources: Hadoop ecosystem and MySQL Database.
  • Involved with the Big Data team in data modeling using Hive and writing the custom SQL scripts for BI visualization.
  • Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Sr. Data Analyst/ Tableau Consultant

Confidential

Responsibilities:

  • Worked as an offshore Data Analyst/Solution Consultant through Tech Mahindra, Work with Business Users/clients to understand, design & document the requirements.
  • Prepare solution and technical architecture proposing the big data stack suitable for the use cases.
  • Data discovery, Aggregation and Transformation of data based business use cases and requirement using source Hadoop ecosystem MySQL Database.
  • Perform feasibility analysis, scopes projects, and work with the Core Business Team to prioritize and schedule deliverables, and negotiate on product functionalities.
  • Involved in Big data environment setup, data ingestion and data modeling using Hadoop ecosystem.
  • Interactive Dashboard design and Report Development using Tableau BI tool for Customer 360 profiling connecting with RDBMS and Hive DB.

Sr. Business Analyst

Confidential

Responsibilities:

  • Worked as an offshore Sr. Business Analyst Consultant through Tech Mahindra and managing team of 4 members through end to end SDLC including requirements gathering, design, development, UAT and implementation
  • Lead the integration of Honda global process of Order Management with our application; Being an ERP order management domain Expert, I worked as a Consultant to facilitate functional requirement to Development Team.

Sr. Business Analyst

Confidential

Responsibilities:

  • Worked as a offshore Sr. Business Analyst Consultant through Tech Mahindra and successfully implemented Employee portal using Open Source Apache Product Ofbiz for Confidential employees where every employee will have a personalized login. He can and check his leave balance, payroll and other HR related details and also request for leave or GPF withdrawal and other payroll and HR activities.
  • Implemented content management system using Alfresco Content Management Platform.
  • Portal provides information platform to circulate information across organization like circulars, policies, notice dashboard etc.
  • Portal was integrated with ERP and Content management application which enables seamless exchange of information

Sr. Business Analyst

Confidential

Responsibilities:

  • Worked as a offshore Consultant a s a Sr. Business Analyst my responsibilities include interacting with client for Requirement Gathering within different departments by following various requirement elicitation techniques.
  • Being an e-governance ERP domain Expert, I worked as a Consultant to facilitate functional requirement to Development Team.
  • Successfully delivered an exhaustive ERP system with processes like Human Resources, Payroll, Finance, Inventory and Procurement, Asset Management which has inbuilt organization structure as per Confidential departments and work-flows.
  • Giving presentations/demonstrations to Standing Committees, Councilors, Commissioner, HODs and other higher Officers and taking their sign-off and acceptance.

Hire Now