Harshadkumar Bhuva

This project is on Big Data eco systems tools like Spark with Implementation using Python, AWS, and PowerBI, Spark modules such as Spark Context, Spark-SQL, PySpark, Pair RDD's, Spark YARN, and Spark MLLib. The project was to deliver business intelligence that supports the Marketing team to maximize sales and drive customer loyalty. The project involved developing sales reports and statistics on a weekly, monthly basis and identifying trends and opportunities using data from multiple sources.

• Worked as a Data Analyst for the Robotic Process Automation Project
• As a Data analyst, my major role was ad-hoc reporting, creating multiple new reports in Power BI for the team based on understanding the requirement of the users.
• Worked on large SQL Datasets, to create new Power BI Reports and Dashboards.
• Major responsibility to take care of audits of the accounts of users associated with our Project.
• On receipt of ad-hoc requirements, worked on understanding the requirement of the user/product owner, the existing datasets, understanding the various views to be able to extract the necessary data for the reports and dashboards.
• Worked majorly on POWER BI to create visual, interactive objects on a sheet and grouped them for a dashboard, creating visuals to drill down or drill through where a user can see detailed information.
• Used Power BI Gateways to keep all the dashboards and reports up to date and set up a daily refresh.
• Worked in an agile environment.
• Structured the complex receivables for the customers by reconciling developing Mobile Collection, Automated Direct Debit and integrating the reports with Online Systems and Clients ERPs.
• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Created dashboard for Transportation system financial information which includes revenue and expenditure by routes.
• Used various sources to pull data into Power BI such as Azure SQL Server, oracle.
• Involved in installation of Power BI Report Server.
• Developed reports visually explore data create interactive reports in Excel and Power BI.
• Using a query editor in Power BI performed certain operations like fetching data from different files.
• Created groups, content packs, KPI to show difference between actual and forecast data.
• Working with import and direct query, creating custom table in the Power

<p>This project is on Big Data eco systems tools like Spark with Implementation using Python, AWS, and PowerBI, Spark modules such as Spark Context, Spark-SQL, PySpark, Pair RDD's, Spark YARN, and Spark MLLib.<br>
The project was to deliver business intelligence that supports the Marketing team to maximize sales and drive customer loyalty.<br>
The project involved developing sales reports and statistics on a weekly, monthly basis and identifying trends and opportunities using data from multiple sources.<br>
Have setup data governance touch points with key teams to ensure data issues were addressed promptly.<br>
Responsible for facilitating UAT (User Acceptance Testing), PPV (Post Production Validation) and maintaining Metadata and Data dictionary.<br>
Responsible for source data cleansing, analysis and reporting using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation in Excel.<br>
Actively involved in data modeling for the QRM Mortgage Application migration to Teradata and developed the dimensional model.<br>
Worked as a Data Analyst for the Robotic Process Automation Project<br>
As a Data analyst, my major role was ad-hoc reporting, creating multiple new reports in Power BI for the team based on understanding the requirement of the users.<br>
Worked on large SQL Datasets, to create new Power BI Reports and Dashboards.<br>
Major responsibility to take care of audits of the accounts of users associated with our Project.<br>
On receipt of ad-hoc requirements, worked on understanding the requirement of the user/product owner, the existing datasets, understanding the various views to be able to extract the necessary data for the reports and dashboards.<br>
Worked majorly on POWER BI to create visual, interactive objects on a sheet and grouped them for a dashboard, creating visuals to drill down or drill through where a user can see detailed information.<br>
Used Power BI Gateways to keep all the dashboards and reports up to date and set up a daily refresh.<br>
Worked in an agile environment.<br>
Structured the complex receivables for the customers by reconciling developing Mobile Collection, Automated Direct Debit and integrating the reports with Online Systems and Clients ERPs.<br>
Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.<br>
Created dashboard for Transportation system financial information which includes revenue and expenditure by routes.<br>
Used various sources to pull data into Power BI such as Azure SQL Server, oracle.<br>
Involved in installation of Power BI Report Server.<br>
Developed reports visually explore data create interactive reports in Excel and Power BI.<br>
Using a query editor in Power BI performed certain operations like fetching data from different files.<br>
Created groups, content packs, KPI to show difference between actual and forecast data.<br>
Working with import and direct query, creating custom table in the Power BI.<br>
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.<br>
Created several user roles and groups to the end - user and provided row level security them.<br>
Worked on Snowflake for writing SQL queries to design a star schema.<br>
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.<br>
Designed different types of KPI's for percentage growth in different fields and compared over a period and designed aggregations and pre-calculations in SSAS.<br>
Created Data Flow Diagrams (DFDs), ER diagrams for data modeling and Web-page mock-ups using MS Visio for acceptance from end users.<br>
Responsible for creating Use case diagrams, Context diagrams, Swim Lane diagrams, Data Flow (DFD) diagrams.<br>
Followed Scrum and SAFE Agile Methodology for the SDLC.<br>
Checked the consistency of the data after ETL process using SQL queries.<br>
Participated in an agile style atmosphere and participated in daily Scrum/Stand-Up meetings using Agile Scrum standards.<br>
Worked for a Request for Proposal (RFP) is used when you know you have a problem but don’t know how you want to solve it.</p>

<p>Scotiabank offers deposit products, mortgages, and business and consumer loans, as well as securities brokerage, insurance, trust, private banking ,is an American multinational independent investment bank and financial services company providing financial services to individuals, corporations, through its subsidiary companies that engage primarily in investment and financial planning, my role was to enrich and transform data into internal data models powering search, data visualization, and data analytics.<br>
Migrated from different RDBMS system and focused on migrating from Cloudera distribution to Amazon Web Services (AWS) cloud to reduce project cost.<br>
Gathered requirement to create multiple banking application and products applying the Agile Methodologies.<br>
Provided the support simultaneously to the end clients from different industries along with the Customized Power BI Reports.<br>
Design and implemented the Customized Dashboards for the Internal and external customers.<br>
Maintain ethical standards with data by ensuring database integrity as well as compliance with legislative, regulatory and accrediting requirements.<br>
Transformed and manipulated the Data in the Power Query Editor and use the different features of the Power Query Editor to clean the data and applied the necessary filters.<br>
Written the Date Invoke Functions using M-Query in the Power Query Editor to make the relationships with different tables.<br>
Closing the Dividends of Corporate Customers and providing additional revenue for the organization with customization support to the client and showed the Publish the report using the Public and Web Host in Power BI<br>
Completed the Payments and Collections Products with the lucrative results based on Agile methodology, applying the user stories with a 10 days sprint on JIRA.<br>
Conducting the ceremonies (Scrum, Sprint Planning, Sprint Retrospective, Sprint Reviews)<br>
Developed end-to-end ETL batch and streaming data integration into Hadoop (MapR), Transforming data.<br>
Performed Data Visualization and Designed Dashboards with Tableau and generated complex reports including chars, summaries, and graphs to interpret the findings to the team and stakeholders.</p>

<p>Project Description:<br>
Zolon Tech is an Indian multinational information technology company that provides business consulting, information technology and outsourcing services.<br>
Option buys streamlines and simplifies bidding on buys with optional period of performance.<br>
This phase implemented with more functional coverage for the commercial sector.<br>
Escrow Payment System is the module is going to integrate the various payment processing/shipment processing using this system.<br>
The escrow payment system is a way for sellers to get safely paid for their work and a way for buyers to purchase work without worrying about getting taken advantage of.<br>
As a Data analyst my role is to develop apps, monitor online marketing trends, analyze statistics, develop strategies for digital marketing campaigns, and track campaign performance.<br>
Prepare campaign results, create data visualizations, and present insights and findings to sales teams, management and clients<br>
Worked with RDBMS like Oracle 11g/10i and MySQL databases to query and read data.<br>
Performed Unit testing, Integration Testing, GUI testing using PyTest and web application testing using Selenium Python bindings.<br>
Developed server-based web traffic using RESTful API’s statistical analysis tool using Flask, Pandas<br>
Enhanced by adding Python XML SOAP request/response handlers to add accounts, modify trades and security updates. Developed scripts to migrate data from the proprietary database to PostgreSQL.<br>
Used Python and Django to interface with the jQuery UI and manage the storage and deletion of content.<br>
Creation of Python scripts for data access and analysis (Scripts, Data Feeds, XLS, FIXML) to aid in the process and system monitoring, and reporting.<br>
Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.<br>
Performed ETL processes to data ready for creating business analysis visuals which help the leadership team to make the right business decisions.</p>