Data Analyst Power Bi

VAISHNAVI PATEL

Data Analyst

*********************@*****.*** 203-***-**** linkedin.com/in/vaishanvi-patel-a7785b325/ https://ttripathi167.github.io/Portfolio//Permanent Resident

KEY SKILLS

Summary: Data Analyst with 3+ years of experience in SaaS and cloud-based analytics, specialising in sales and marketing data insights. Skilled in CRM platforms like Salesforce and marketing automation tools like Marketo. Adept at SQL, data modelling, and BI tools (Tableau, Power BI). Proven ability to collaborate with cross-functional teams to drive data-driven decision-making.

Technical: Python (4 yrs.), SQL (4 yrs.), Pandas (3 yrs.), NumPy (3 yrs.), Microsoft Excel (4 yrs.), ETL (1.5 yrs.), AWS Glue (6mts), AWS Redshift (3mts), AWS S3(6mts), Scikit-Learn (1 yr.), Amazon Sagemaker (3 mts), Tableau (1 yr), Power BI (6 mts), API Integration (1 yr.), AWS Lambda (6 mts) UiPath (2.5 yrs.), Tableau(2 yrs), Power BI, Alteryx. (6 mts), ArcGIS (1 yr.), SAP(4), Excel(8),Project Management(4years)

Business: Requirement Gathering, Project Scoping, Market Intelligence, Data Reporting & Visualization, Research & Stakeholder Management, Strategic Planning, Agile & Scrum Methodologies Quality Assurance, Customer Focus

PROFESSIONAL EXPERIENCE

Sacred Heart University, Connecticut, USA

AI lab assistant/Graduate Assistant August 2024 – Present

oDesigned and implemented AI-based tools for researcher-grant matching, increasing efficiency by 20%.

oAutomated data extraction using Python web scraping, reducing manual workload by 60%.

oApplied Python for data cleaning, automation, and machine learning models, improving forecasting accuracy by 20%.

oUtilized analytical tools such as R and SAS to perform statistical analysis and predictive modeling, leading to data-driven decision-making

oPerform gap analysis and recommend process improvements based on Agile SDLC methodologies.

oConducted business process analysis in collaboration with university departments, identifying workflow inefficiencies and recommending solutions based on institutional goals.

oElicited and documented functional and technical requirements, creating user stories and process flow diagrams to ensure effective system design and implementation.

oLed system rollouts, overseeing data migration and user adoption to ensure smooth transitions during AI tool integrations.

oUtilized SharePoint for efficient document management and team collaboration.

oApplied VLOOKUP in Excel for accurate data retrieval and comparison.

oLeveraged pivot tables to analyze and visualize large datasets for business insights.

oActively supported change management processes for system upgrades, conducting user acceptance testing (UAT) and preparing communication plans for staff.

oDesigned system optimization strategies, recommending upgrades and process improvements to align with evolving business needs.

EVRE

Data Analyst (Contract) May 2023 –Jan 2024

oExecuted data extraction and developed automated scripts, improving data processing efficiency by 25%.

oDeveloped and maintained interactive dashboards in Tableau and Microsoft Power BI, streamlining business intelligence reporting.

oProvided strategic insights on fulfillment risk through detailed business analysis.

oUtilized SQL and Excel to extract, clean, and analyze data for strategic business insights.

oImplemented defect-trend analyses, reducing errors and enhancing service quality by 15%.

oUtilized Agile principles to optimize cross-functional team performance and project deliverables

oLeveraged JIRA to document user stories, Project Management, track defects, and monitor sprint progress, ensuring on-time delivery of key milestones..

oConducted gap analysis and process optimization to improve business workflows and efficiency.

oDesigned and implemented automation scripts using Python and UiPath to enhance operational productivity.

oLed Agile sprints, managed backlog refinement, and coordinated cross-functional teams to align project objectives.

oAnalyzed financial and operational data to provide strategic insights, supporting leadership in decision-making.

Randstad Offshore Services

Data Analyst (Contract) Jan 2022 – May 2023

oLed digital transformation initiatives at Guardian, implementing RPA solutions that streamlined insurance

oprocesses, reduced costs, and improved operational efficiency.

oDeveloped and optimized SQL queries for data analysis, improving reporting accuracy by 30%.

oCreated process documentation and optimized data workflows using Visio.

oSpearheaded the deployment of bots for process automation using UiPath to streamline business processes, decreasing FTE costs by 20-25%, generating $5 million in annual savings.

oManaged project timelines and dependencies using JIRA, enabling early identification of risks and bottlenecks.

oGained hands-on experience in machine learning and AI, leveraging predictive analytics to enhance operational efficiencies.aged end-to-end UAT processes, ensuring smooth system transitions and minimal operational disruption.

oSuccessfully delivered 5 RPA projects ahead of schedule by leveraging reusable code and coordinating early access to test data, exceeding client expectations and securing a robust pipeline of future projects.

Genpact

Data Analyst (Contract) Dec 2020 –Dec 2021

oInterpreted business requirements and designed projects to align with client objectives, leading to a 15% improvement in project delivery timelines.

oDesigned and deployed automated Unix Shell Scripts, minimizing errors and manual intervention.

oDelivered Property & Casualty insurance insights, enhancing decision-making and efficiency using SAP.

oApplied SQL programming for data analysis, aligning project deliverables with business objectives.

oUtilized JIRA to manage task prioritization, ensure resource allocation, and generate sprint velocity reports for leadership.

oDesigned and optimized data models to streamline risk analysis and business intelligence reporting.

oAssisted in implementing ERP system enhancements, ensuring seamless data integration and reporting.

oConducted compliance audits to ensure adherence to industry regulations and internal policies.

oSpearheaded Agile team efforts to successfully execute high-priority projects within tight deadlines.

ACADEMIC PROJECTS

Automated Stock Price Prediction System through Data Pipeline on AWS (February 2024 – May 2024)

oEngineered an AWS Lambda function in Python to automate daily stock data collection from Alpha Vantage, decreasing manual effort by 90% and ensuring daily availability of accurate data for analysis.

oStreamlined data processing with AWS Glue and optimized stock price prediction using Amazon SageMaker and Lasso regression, achieving 70-80% prediction accuracy with cleaner data, supporting better risk management and strategic planning.

Optimizing Restaurant Location Strategy through SQL and Yelp data (August 2023 – December 2023)

oMigrated 200,000+ Yelp restaurant data entries from Kaggle to MySQL using Pandas and a chunk-wise approach, reducing load time by 35% to accelerate data analysis and support faster decision-making.

oTransformed and analyzed customer data using SQL to conduct market trend analysis, resulting in more consistent data and a 40% improvement in insight accuracy, providing more reliable and actionable insights for data-driven location strategy decisions.

Customer Loyalty Program – Clustering(May 2023 – August 2023)

oDeveloped a customer segmentation model using clustering techniques. Identified a specific cluster that generates 50% of the company's revenue. Created a Looker dashboard for insights and metrics.

Classification - Learning to Rank (Jan 2023 – May 2023)

oBuilt a model to predict car insurance purchases among health insurance customers, boosting profitability by reducing unnecessary sales calls.

Churn and low average ticket (Sept 2022 – Dec 2022)

oThis project focuses on addressing some of the challenges faced by the fictitious company North Winds, including issues such as disorganized data, customer churn, and low average ticket.

oTo help solve these problems, I employed various Data Science techniques, such as optimizing the database organization, performing churn analysis, conducting cohort and RFM analyses, clustering customers based on their purchasing behavior, implementing a recommendation system, and introducing an Elastic Price strategy.

Time-Series Regression - Sales Forecast. (Jan 2022 – September 2022)

oThis project focuses on predicting the sales forecast for the next 6 weeks of the Rossmann pharmacy chain, using Machine Learning models. The models were trained on historical sales data, and the results are delivered through a Telegram chatbot.

oFive different models were implemented, and the XGBoost model was selected as the most accurate. To deploy the model into production, Flask and Heroku's cloud were utilized, and the Telegram chatbot was created for users to access the predictions from anywhere.

CERTIFICATIONS

Microsoft Certified: Azure AI Fundamentals, Google Data Analytics, MTA: Introduction to Programming Using Python - Certified 2019, Excel Skills for Data Analytics and Visualization Specialization

EDUCATION

oSacred Heart University, USA: Master of Science in Computer Science, Data Science Track (Mar 2025)

oNMIMS, India: Master of Business Administration, IT and HRM, (Dec 2023)

RTMNU University, India: Bachelor of Engineering, Information Technology, (Dec 2020)

Contact this candidate