Prajwal Jishtu

Prajwal Jishtu

Data Analyst
Canada

About Me

Analytical and detail-oriented Data Analyst with 3+ years of experience in extracting meaningful insights from complex datasets. Skilled in data analysis, statistical modeling, and visualization to drive data driven and …

Experience

Data Analyst

Kofax
Jul 2022 - Present · 3 years 11 months

Responsible for providing data analysis that focused on improving user experience and optimizing user
retention.
Create a storyboard of backlog items in Agile and develop item according to business needs.
Create categorization models in Python to identify customer loss and metrics to identify customer before to
discontinuation for improving retention.
Generating various reports (graphical) using Python packages like NumPy, Pandas, Matplotlib, SciPy, and
ggplot2.
Perform data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting,
validation and documentation.
Perform regression analysis in R programming on the various parameters associated with demand forecasting.
Consult with train analysts to effectively access data and optimize Tableau dashboards.
Designed and maintained MySQL databases, and created pipelines using user-defined functions and stored
procedures for daily reporting tasks.
Create monthly performance based client billing reports using MySQL databases.
Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical
platform.
Working on developing Python script for the whole data science project life cycle including data acquisition,
data cleaning, data exploration, and data modeling.
Analyzed large datasets using SQL queries to identify trends, patterns, and insights.
Develop interactive dashboards and reports using MicroStrategy, enabling business users to visualize trends,
patterns, and insights.
Developed dashboards in Tableau and present data to track KPIs and product performance using data from
various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON and XML.
Developed and implemented data collection methodologies to gather relevant information.
Managed data storing and processing using big data tools such as Hadoop, HDFS, Hive and Spark.
Created interactive dashboards and reports using data visualization tools to present findings to stakeholders.
Collaborated with cross-functional teams to define key performance indicators (KPIs) and develop data-driven
strategies.
Collaborate with business stakeholders to gather requirements and translate them into MicroStrategy
reporting solutions.
Conducted statistical analysis to support business decision-making and optimize operational processes.
Communicated between the business, product manager and data engineers to ensure the data quality.
Participated in data project planning, gathering business req

Data Analyst

Kofax Canada
Present

Responsible for providing data analysis that focused on improving user experience and optimizing user retention.
Create a storyboard of backlog items in Agile and develop item according to business needs.
Create categorization models in Python to identify customer loss and metrics to identify customer before to discontinuation for improving retention.
Generating various reports (graphical) using Python packages like NumPy, Pandas, Matplotlib, SciPy, and ggplot2.
Perform data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation.
Perform regression analysis in R programming on the various parameters associated with demand forecasting.
Consult with train analysts to effectively access data and optimize Tableau dashboards.
Designed and maintained MySQL databases, and created pipelines using user-defined functions and stored procedures for daily reporting tasks.
Create monthly performance based client billing reports using MySQL databases.
Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.
Working on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling.
Analyzed large datasets using SQL queries to identify trends, patterns, and insights.
Develop interactive dashboards and reports using MicroStrategy, enabling business users to visualize trends, patterns, and insights.
Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON and XML.
Developed and implemented data collection methodologies to gather relevant information.
Managed data storing and processing using big data tools such as Hadoop, HDFS, Hive and Spark.
Created interactive dashboards and reports using data visualization tools to present findings to stakeholders.
Collaborated with cross-functional teams to define key performance indicators (KPIs) and develop data-driven strategies.
Collaborate with business stakeholders to gather requirements and translate them into MicroStrategy reporting solutions.
Conducted statistical analysis to support business decision-making and optimize operational processes.
Communicated between the business, product manager and data engineers to ensure the data quality.
Participated in data project planning, gathering business requirements and translating them into technology requirements.
Assisted in the development and maintenance of data infrastructure, ensuring data accuracy and accessibility.
Conducted data quality checks and implemented data cleansing techniques to improve data reliability.

Data Analyst

KPIT Business Solution - India

Responsible for creating reporting dashboards, performing data mining and analysis to understand customer purchase behavior.
Worked in a Agile environment allowing teams to deliver projects piece by piece and make rapid adjustments as needed.
Translated scientific and statistical designs to a developer based on common Python coding language.
Designed MySQL table schemas and implemented stored procedures to extract and store customer purchase and session data.
Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and .Numpy
Worked closely with cross functional teams to encourage statistical best practices concerning experimental design and data analysis.
Wrote scripts to store data into Hadoop HDFS from various sources including AWS S3, AWS RDS and Web API and NoSQL Database MongoDB.
Performed Exploratory Data Analysis to identify trends using Tableau and Python (Mtpalotlib, Seaborn, Plotly Dash).
Communicated key findings from data to multiple stakeholders to facilitate data-driven decisions using tools MS PowerPoint Tableau and Jupyter Notebook.
Performed regression analysis in R programming on the various parameters associated with demand forecasting.
Performed statistical analysis such as hypothesis testing, regression analysis, confidence interval and Pvalue calculation using R to find insights to increase click through rate and sales and built web applications for ad-hoc interactive dashboard.
Established processes and methods for continuous data quality improvement of the production software system.
Worked on performing quantitative analysis for credit portfolios, data quality control and data profiling.

Skills

R Programming Language (R) Python SQL PL/SQL AWS EC2 EMR S3 IAM Glue Azure Google Cloud BigQuery Kubernetes GCP IBM Cloud Snowflake Visual Studio Code PyCharm Jupyter Notebook NumPy Pandas Matplotlib SciPy Seaborn TensorFlow SSIS SSAS SSRS Informatica Jira Trello Tableau Power BI Microsoft Excel MySQL SQL Server MS Access PostgreSQL NoSQL MongoDB DynamoDB MicroStrategy Data Warehousing Data Cleaning Data Manipulation Data Mining Data Extraction Data Visualization Data Wrangling Data Modeling
Report this Profile?