PROFESSIONAL SUMMARY:

• Microsoft Certified Data Analyst with 5 Years of experience as Data Analyst using Microsoft Power BI.
• Guided end users of Clients in using Power BI and developing and publishing dashboards, sharing them with other colleagues and how to embed them on their websites.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Successfully upgraded Tableau platforms and ensured functionality is working during upgrades.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Involved in Unit Testing the data and worked with QA team to resolve the defects.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Experience in designing report with rich UI including Tabular forms, Matrix (Cross /tab Report) form, Drill down, Charts and Sub Reports using Power BI
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Worked with various DW architectures - Google BigQuery, Redshift and Snowflake.
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
• Developed and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Experience in Creating packages, Jobs, Sending Alerts using SQL Mail.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server
• Experience in Error handling, Debugging and logging for production support in SSIS.
• Hands on experience in Performance Tuning, Query Optimization
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Expertise in creating cubes with dimensions and facts tables in Warehouse using SQL Server Analysis Services (SSAS).
• Experienced in Performing Data Wrangling techniques to do valuable, cross-data set analytics.
• Developed data wrangling through data gathering and querying process over SQL and Google BigQuery Database and implemented data cleaning process with R & Python.
• Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Having very good understanding of Kimball dimensional modelling, creating star schema using Facts and Dimension Tables.
• Hand’s-on experience using machine learning techniques in detecting the patterns and predicting the target.
• Experience in scraping the data on web using Python Anaconda.
• Created Chatbots and embedded them on websites and Integrated them on various social media platforms.
• 1+ years of hands-on experience with Google DialogFlow.
• Around two years of experience in deploying the python applications in Google Cloud Platform.
• Experienced in retrieving the data from the database using DialogFlow’s Webhook Fulfilment.
• Hand-on experience in retrieving the information through any third-party API.
• Experienced in importing bulk intents into the DialogFlow Agent.
• Solid experience in creating customer support Chatbots.
• Created Chatbots that can respond back with nearby locations and even respond back with images and videos.
• Created chatbots where the user just clicks on the options provided by the chatbot and the bot replies back showing more options. Here user just users enter their name and email address.
• Solid experience in training the DialogFlow agent.
• Created chatbots that can store the user information and send the information to the representative through an email.
• Created some Hotel Room booking Chatbots that takes all the required inputs and makes the reservation by giving the user a confirmation number and the reservation will be notified for the Hotel management via email and the reservation date will be noted on Google calendar using Google Calendar API.
• Solid experience in integrating the DialogFlow agent with Google Assistant utilizing all the options on both of them to create rich user experience.

TECHNICAL SKILLS:

Operating Systems: Windows, Mac OS, Ubuntu

BI Tools: Power BI (2.x), Tableau, Sisense

Programming languages: Python, R, C, C++

Database: MySQL

Big Data ecosystem: Hadoop

Software Suites: Microsoft Office

Cloud Platforms: Google Cloud Platform

Chatbot Technologies: Google DialogFlow, Amazon LEX

PROFESSIONAL EXPERIENCE:

DATA ANALYST

Confidential, CA

Responsibilities:

• Analyzed data to give insights about US traffic, accident patterns and vehicle safety with advanced drilldowns.
• Handled datasets carefully on Google BigQuery, and implemented Data Actions by PowerBI on multiple dashboards, letting authorized users to writeback data right form Dashboards.
• Filtered duplicate/un-authorized write requests by using Google Cloud Functions (written in Python).
• Built countless dashboards helping many business users understand their current status, using PowerBI and Tableau.
• Built multiple Derived Tables in PowerBI using SQL queries based on usage patterns, to reduce read-costs over the data source, and analytics time in some cases.
• Excelled in building accurate ad-hoc as well as standard dashboards consuming least possible time.
• Guided end users of Clients in using Power BI, Tableau and developing and publishing dashboards, sharing them with other colleagues and how to embed them on their websites.
• Created Custom Visualizations using R.
• Worked with various DW architectures - Google BigQuery, Redshift and Snowflake.
• Implement solutions using Hadoop, HBase, Hive, Sqoop, Java API, etc.
• Work closely with the business and analytics team in gathering the system requirements.
• Load and transform large sets of structured and semi structured data.
• Implemented data cleaning process using R and Python.
• Load data into HBase tables using Java MapReduce.
• Load data into Hive partitioned tables.
• Configured Hadoop tools like Hive, Impala and Sqoop.
• Hands-on experience in dealing with both structured and unstructured data on large dataset, performing data cleaning and visualization, and applying machine learning techniques to business problems.
• Analyzed client's customer data to uncover useful patterns for prediction.
• Coded machine learning solution with Python Anaconda to predict Customer behavior.
• Built Help desk Chatbots using Google DialogFlow.
• Created messenger Chatbots for clients. Created chatbots using Google DialogFlow and AWS LEX.
• Worked on a chatbot through which we can read or write on the real-time database using Firebase.
• Involved in a project where the chatbot gives the information of a company and its stock value.
• Created some customer support chatbots using Google DialogFlow Enterprise version, where the webhook fulfilment is done with the help of Google Cloud Platform.
• Created the chatbots with the help of Firebase that respond back with the photos and videos.
• Maintaining company's PowerBI COE web pages and all the related content using WordPress and added custom styles and animations using CSS. www. Confidential .com/powerbi/

DATA ANALYST

Confidential, TX

Responsibilities:

• Imported data from SQL Server DB, BigQuery and Azure SQL DB to Power BI to generate reports.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Dax Queries to generate computed columns as well as computed tables according to the requirements in Power BI.
• Skilled in PowerBI Desktop and Tableau for data visualization, Reporting and Analysis; Bubble Charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts
• Worked on power pivot for developing the relationships between the data tables.
• Guided end users of Clients in using Power BI and developing and publishing dashboards, sharing them with other colleagues and how to embed them on their websites.
• Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps .
• Partitioning and Bucketing techniques in hive to improve the performance.
• Explore data in a Variety of ways and across multiple visualizations using Power BI and Tableau.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created a help desk chatbot. Chatbot service for answering company's client questions with efforts to vastly reduce workload of Technical Support Team and resolve client issues swiftly utilizing Google DialogFlow.
• The Chatbot is created utilizing most of the features of Google DialogFlow. Trained the bot with so many user expressions in the Intent’s.
• The Chatbot is created for responding back with dynamic responses. For this we created a back-end service using Google Cloud Platform for the webhook fulfillment in DialogFlow.
• A python code was written for querying the data sets in the Bigquery and third-party API’s and deployed a Python app in google app engine.

DATA ANALYST

Confidential

Responsibilities:

• Developed sales reports using the on-premise data on Microsoft Excel and Power BI.
• Developed visuals for business presentations utilizing the weekly, monthly and annual sales data.
• Guided other branches of the company in developing the reports in Power BI (Years ).
• Add new accounts and maintain existing accounts for Franchise and Independent dealerships throughout the state.
• Manage individual workload and prioritize tasks to meet tight deadlines.
• Identify and collect information to prepare and maintain data governance through client staff interviews and facilitated meetings.
• Provide analysis, insights, commentary, and recommendations in to make reports meaningful and actionable.
• Document business processes, systems, information, and technologies.
• Assist in preparing management and technical presentations and interface with senior client management and business users to map out and document business requirements, data and information needs, and data exchange flows.