Abhay suresh V.

Abhay suresh V.

Expert in Data Analysis, Business Analysis, Tableau, Qlik, and project and product management

Pune , India

Experience: 11 Years

Abhay suresh

Pune , India

Expert in Data Analysis, Business Analysis, Tableau, Qlik, and project and product management

80914.4 USD / Year

  • Immediate: Available

11 Years

Now you can Instantly Chat with Abhay suresh!

About Me

  • 11+ years of total extensive experience in the IT industry experience in Requirement Gathering, Data Analysis, Data Wrangling, Machine Learning Regression Modeling/Predictive Modeling, Design, Development, Testing and Implementation of vari...
  • Cleansing, Processing and Verifying the integrity of Data by applying different analytical method and produced valuable predictions for different line of business across organizations.
  • Responsible for automating the dashboard/reports for Directors/Managers/VP’s and CEO
  • Developed Linear Regression/Multiple Linear Regression, Predictive Modeling for workforce analytics team using Machine Learning techniques and makes sure what external factors influencing what causes the failures for the product not getting success in the market.
  • Expertise in shaping the data from different sources to a right shape using Anaconda Python.
  • Extensive experience writing complex SQL queries reading data from different data warehousing table in SQL.
  • Received appreciation from senior leadership group for continuous effort in identifying key metrics/KPI on the performance across the organization.
  • Creating high performance dashboards through qlik Sense and tableau.
  • Understanding the Data Structure and modeling the data for the business.
  • Expertise in the predictive analysis using Python and strong understanding of machine learning techniques.
  • Working experience in AWS cloud system.
  • Expertise in the Data Analysis, Data Modeling, Data Ingestion and Data Reporting.
  • 7+ years of working on agile methodologies with experience and knowledge of project management best practices, SDLC methodologies including Waterfall and Agile.
  • 5+ years' experience in Designing & building data visualization solutions and complex dashboards with Tableau and deploying those visualizations to Tableau Server.
  • 5+ years' hands-on in writing the SQL queries.
  • Experience in python integration with Qlik Sense to setup the forecasting model.
  • Working knowledge of Big Data technology - i.e. Hadoop, Spark, Pig, Splice and Hive.
  • Track, trend and forecast websites performance on the basis of website visits, leads, clicks, calls, applications, sales, revenue, CTR, CPA, and ROI.
  • Analyze and develop insights from marketing data: Google Analytic, Adwords, Social, Email, etc. and external data sets.
  • Work with SMM to analyze and refine PPC, KeyWord, SEO and SEM campaigns and monitor ROI of the programs.
  • Implement, analyze and suggest actions based on A & B testing results.
  • Develop (Custom SQL queries), schedule and deploy the Tableau Data Sources (TDS).
  • Design Strategies for developing dashboard reports in Tableau and Qlik Sense.
  • Analyze data from large and complex datasets (including geospatial and statistical data) and optimizing dashboards for large datasets.
  • Work with multiple data sources into the Tableau data model in support of reporting.
  • Understand data movement solutions including extract, transformation, and load (ETL) processes.
  • Supported technical and management teams by providing predictive analytics insights, and operational analytics for effective data-driven decision making.
  • Excellent at collecting, analyzing, testing and presenting data (internal and external sources) to support the business questions and needs with some oversight.
  • Experience in ad-hoc analyses as needed using internal and external data sets.
  • Analyze existing marketing programs for profitability and revenue opportunity, and recommend improvements.
  • Very good understanding in the data source investigation, application development and user acceptance testing.
  • Established standard methodologies for data assessment and interpretation across multiple dashboards to ensure consistent information representation.
  • Good knowledge of Java (Multithreading, Collections, Data Structures, Algorithm, Design pattern and spring hibernate frameworks along with the OOPs concept), Micro services,  Python, Machine learning in data science, MongoDB(NOSQL) data testing and assessment data model.
  • Manage effective communication with various stakeholders, both written and verbal.
  • Develop / refine expertise in concepts, methods and supporting technology relevant to analytics.
  • Excellent analytical, inter-personal and communications skills with the ability to work in a fast-paced, individual or team-oriented environment.
  • Self-motivated and quick learner with a desire to stay up-to-date with current technologies.

Show More

Skills

Portfolio Projects

Implementing Machine Learning Techniques, Data Modelling and Reporting

The project is to collect, test, analyze legacy data

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Subash K

Company

Implementing Machine Learning Techniques, Data Modelling and Reporting

Contribute

Worked independently to understand the requirement and a goal. Implemented the machine learning techniques with the help of Python and Qlik Sense. Showed the demo to the higher management.

Description

·        Spend time with client team members, Agile coaches and internal teams to understand their needs, problems, and wants.

·        Developed Linear Regression/Multiple Linear Regression, Predictive Modeling for workforce analytics team using Python Based Machine Learning techniques and makes sure what external factors influencing what causes the failures for the product not getting success in the market

·        Connecting to different network across organization and pulling the information, performing business calculations across different line of business through python pandas/numpy/matplotlib/Scikit and other libraries.

·        Manage and work from a prioritized backlog.

·        Spend time understanding the data and pulling data from a number of sources.

·        Analyze and document business data requirements and create functional/technical design documents and related documentation.

·        Design and develop conceptual, logical, and physical level data models (both relational and dimensional) for data marts.

·        Additional responsibilities include source system analysis (understanding schemas, joins), data profiling of complex, under-documented systems, and source to target mapping (Physical to Logical, Logical to Physical).

·        Data mapping, transformation and integration of relational/dimensional data models.

·        Develop metrics dashboards in Qlik Sense.

·        Connecting the network across the organization

·        Migration report from SaS code logic to Qlik Script.

·        Integration of python with Qlik sense to do the forecasting model.

·        Migration of the PL/SQL procedure report to Qlik Script.

·        Develop strategies and designs for dashboard.

 

Show More Show Less

Analyze, test and validate legacy data

Set up, analyze, test and validate data for all leads, calls and clicks

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Pankaj B

Company

Analyze, test and validate legacy data

Role

Product Manager

Contribute

The project was to collect, validate (Spark Scala framework), test, analyze data, and create data visualization reports/dashboards in Tableau for clicks, leads, and calls generation systems.

Description

·        Analyzed key metrics, identify key trends and prepare reports and presentations for senior executives and other key management representatives. We represented this information in the form of python based machine learning techniques.

·        Standardized data collection by developing methods for database design and validation where we used Spark Scala framework.

·        Created interactive dashboards in Tableau Desktop and published them to Tableau server which allowed story telling with quick filters to retrieve on demand information with just click of a button.

·        Designed and implemented advanced Tableau visualizations using action filters, user filters and Level-of-Detail (LOD) expressions.

·        Created tableau data sources utilizing custom SQL and deploy them once the data source data got fully validated.

·        Developed visualization reports for daily, weekly, monthly and yearly conversion and comparison analysis utilizing Tableau Desktop.

·        Scheduled data refresh on Tableau server for daily, weekly and monthly increments based on business change to ensure that views and dashboards were displaying the changed data accurately and sent those to production after editing.

·        Performed ad-hoc analysis as needed using internal and external data sets.

·        Optimized user experience by analyzing behaviors, predicting churn, segmenting users, defining metrics, and designing tests.

·        Analyzed key drivers of customer behavior and built models to predict customer retention.

·        Analyzed traffic patterns to draw inferences from data behavior.

·        Developed key performance indicators to track call center agent productivity and activity.

·        Programmatic search and social campaigns by analyzing performance, optimizing bids, and implementing client deliverables.

·        Managed data operations by developing SQL queries, and investigating data quality issues.

·        Prepared Quality Score Metrics and Campaign analysis from backend data provided.

Show More Show Less

Analyzed calls, clicks and leads volume for the Auto Insurance Vertical

The Project was to build, test and publish customized interactive reports and da

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Pankaj B

Company

Analyzed calls, clicks and leads volume for the Auto Insurance Vertical

Role

Product Manager

Contribute

The Project was to build, test and publish customized interactive reports and dashboards in Tableau along with the analysis of the calls, clicks and leads volume.

Description

·        Performed and documented data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses.

·        Analyzed Key Performance Indicators (KPI's) with help of Tableau reports.

·        Blended data from variety of data sources while creating tableau reports.

·        Scheduled data refresh on Tableau server for daily, weekly and monthly increments based on business change to ensure that views and dashboards were displaying the changed data accurately and sent those to production after editing.

·        Developed dashboard reports to understand bids, conversion, profit, and demographics metrics.

·        Developed visualization reports for daily, weekly, monthly and yearly conversion and comparison analysis utilizing Tableau.

·        Resolved data quality issues by performing root cause analyses, mapping data sources, and improving user workflows.

·        Performed data analytics relevant to investigation issues and worked by integrating tableau with R programming.

·        Tuned complex workbooks and large datasets for optimal performance and maintainability.

·        Worked with extracts, live datasets, and managing access privileges.

·        Developed analytical and business models to estimate an impact of different scenarios.

·        Translated analytical findings into clear, easily understandable, actionable insights that drive strong business strategy.

Show More Show Less

Analyzed calls volume for various auto insurance clients

The Project was to analyze data and create data visualization reports/dashboards

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Pankaj B

Company

Analyzed calls volume for various auto insurance clients

Contribute

The Project was to analyze data and create data visualization reports/dashboards in Tableau and I worked with the various team to make it possible as it is required for the product analysis.

Description

·        Primary responsibility was to develop executive level dashboards in Tableau.

·        Created tableau data sources with help of custom SQL and deployed them once data source data got fully validated.

·        Created and published Tableau reports as per requirements from the business team.

·        Scheduled data refresh on Tableau server for daily, weekly and monthly increments based on business change to ensure that views and dashboards were displaying the changed data accurately and sent those to production after editing.

·        Worked closely with various teams such as clients and media facing business team, BigData + Tableau + Oracle + UNIX admin teams and Java based Development + QA team to get data.

·        Demonstrated progressive changes to stakeholders at regular intervals.

·        Helped a product team to improve products by identifying and defining key marketing performance metrics.

·        Optimize user experience by analyzing behaviors, predicting churn, segmenting users, defining metrics, and designing tests.

·        Analyzed data quantitatively and qualitatively with tools like Tableau and Oracle BRIO.

·        Performed monthly/weekly revenue scorecards and revenue projections.

Used advanced Microsoft Excel for creating Macros, Pivot Table, VLookups and excel functions.

Show More Show Less

Integration Project

Client platform integration with the webservices

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Pankaj B

Company

Integration Project

Contribute

I was a part of a development team for the following projects where I needed to look out data migrations and I also needed to work as a Java developer.

Description

Involved in the below mentioned product developments:

1.      LeadGen Platform

QuinStreet has built a platform which is responsible for driving traffic to LeadGen sites developed by QS. The platform is also responsible to deliver leads submitted by online users to our clients using Web Services, Email and other distribution channels

2. XEngine Platform

XEngine is a platform designed by QS for launching portals. It features the ability to share leads across multiple clients. It will be used for both micro-sites, multi-lead sites and directory sites. List of verticals supported by XEngine include Education, Mortgage, Home Services, Medical and Insurance, and B2B. Products developed under XEngine platform include SiteGenie, Client Services and Publisher Services.

A.    SiteGenie is intended to provide a set of administrative tools to help quickly launch QuinStreet clients and manage existing clients. Integrated SalesForce with SiteGenie to allow Account managers manage prospects and business opportunities and can also generate leadgen sites on fly.

B.     Publisher Services allows Publishers to enroll with QuinStreet network and view leads they posted/collected on behalf of QuinStreet.

C.     Agent Platform allows launching of the agents and intended to allow agents to view their leads, configures their billing data (prepay, postpay, credit card details), lead criteria details, lead notifications and view invoice data.

Contact Center

3. Contact Centre system is an initiative to boost up leads conversion which are captured by platform system and leads bought from publishers. It’s an integration of QuinStreet Platform with 3rd party telephony system, where the leads are transferred from QuinStreet Platform to Telephony System in real time.

 

Show More Show Less
Share: