Aishwarya W Email & Phone Number

Hoboken, New Jersey, United States

• Gathering and processing large datasets from a company website to extract meaningful insights. Conducting detailed analysis of customer behavior patterns to enhance user experience and increase conversion rates.• Analyzing sales data for healthcare products, identifying trends in consumer preferences for vision care products.• Creating and maintaining interactive OKR dashboards using Tableau for real-time sales tracking and performance monitoring.• Regularly monitoring key performance indicators (KPIs) to assess the effectiveness of marketing strategies and operations.• Producing comprehensive reports highlighting key insights and recommendations for improving product listings, pricing strategies, and customer engagement.• Working on Top of the funnel by different marking channels, platforms, and pages and E2E funnel from traffic till the order placed on e-comm website traffic data.• Working on the different features comes with vision products such as lens builder options and prescribed products options available and which are published and transactable on site.• Collaborating with cross-functional teams to understand the broader business context and align analyses with organizational goals. Prepare and present reports related to different cost centers and suppliers’ performance to stakeholders, highlighting key insights, root causes.

Austin, Texas, United States

• Gathering relevant data sources, survey data and any other information using SQL Queries and Google Sheets. Using statistical methods to identify correlations and relationships between various variables and customer satisfaction. • Perform analysis on CSAT according to Projects, Spend and Vendor data from the cost centers.• I extensively work on advanced analysis actions, level of details, calculations, Parameters, URL, and forecasting. • Provided customers with a forecast and Accrual reports based on cost centers. • Update the Attrition/PTO rate for the forecast at the beginning of the month as per historical data and percentage goal set for next quarter.• Refresh the contractor level details report every week. Perform Adaptive Upload Process, Perform Adaptive Upload QA, Generate accounting accrual report. • Participated in meetings, reviews, group discussions. Collaborate with team members and weekly communications with the manager regarding the status of all assigned tasks.• Collaborating with cross-functional teams to understand the broader business context and align analyses with organizational goals. Prepare and present reports related to different cost centres and suppliers’ performance to stakeholders, highlighting key insights, root causes, and recommended actions for improvement.

Malvern, Pennsylvania, United States

- Responsible for developing Tableau visualizations, dashboards, and workbooks using Tableau Desktop from multiple sources to perform year over year, quarter over quarter, YTD, QTD, and MTD types of analysis and share them with the business users.- Working on a daily production support task by gathering and updating the daily trade revenue data which is used in daily trade revenue reports. - Providing the key and timely details of daily trading activity data for tableau reports which provides B&I leaders to enable business decisions.- Supporting Daily trading reports, dashboards, and metadata layers sourced from information in SQL Server, Hue, Redshift, and Athena.- Responsible for delivering ad-hoc reporting and developing financial models to help us better understand performance, trends, and impacts of decisions. - Assisted with Intraday operational report with a few more business requirements and replicated the report from Tableau to ThoughtSpot. - Involved in creating dashboards and reports focusing on Primary KPIs in Tableau and maintaining server activities for maintaining and refreshing data sources on the Tableau server.- Assisted with digital reporting tasks by providing required data using Tableau and HiveQL queries.- Used Hue to gather data from the database by executing HiveQL Queries. And exported the data into Tableau to create dashboards.- Responsible for working with AWS hive by developing SQL queries to generate the reports and make changes accordingly to meet the data requirements of the Responsible.- Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, and Maps.- Worked on creating Aggregations, calculated Fields, table calculations, Totals, and percentages using Key Performance Indicators (KPI) and Measures.- Participated in meetings, reviews, group discussions, and weekly A/B testing experiment workshops.

- Involved in Tableau dashboard designing based on different kinds of visuals Ex. charts, tables, color combinations, etc. Created Customized and interactive dashboards using multiple data sources. - Validating Tableau dashboards by running backend SQL queries and documenting the test results.- Designed, developed, and deployed user content (reports, dashboards, and subscriptions) via business intelligence (BI) products, BI applications like Crystal Report. - Developed visualizations and provided business insights and developed different strategies for improving the performances of Tableau reports, Tableau.- Developed reports, dashboards, and metadata layers sourced from information in Teradata, SQL Server, and Oracle.- Developed a Dashboard that provides and overall view of campaign KPIs like click-through rate (CTR), conversion rate, cost per acquisition (CPA), and returned on ad spend (ROAS). - Used the data after A/B testing for further analysis to compare the performance on website or landing page- Responsibility Involved in creating dashboards and reports in Tableau and maintaining user and server activities.- Performed Pacing calculations on daily spend, impressions, progress, cumulative spend, cumulative impressions. Setup alert and threshold within tableau to notify stakeholders when specific pacing metrics fall outside predefined ranges. - Performed historical analysis, comparing the current campaign pacing to previous campaigns.- Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, and Maps.- Performed data gathering as per requirements such as campaign, impression, spend data from various sources.- Performed data cleaning and validation to ensure accuracy and consistency. Performed advance analysis like aggregation on daily, weekly, monthly basis data. Created calculated fields and metrics such as click-through rate or cost per click.

- Analyze the business data and understand field-level information.- Built data model for the new data sources- Responsible for gathering, analyzing, and documenting business requirements, functional requirements, and data specifications to generate the Reports.- Writing complex SQL queries to fetch the data from Oracle, MS SQL Server Created Excel VBA Macro to dynamically control the updated data flow.- Wrote a multitude of Excel VBA scripts and queries to compile and standardize raw data into a clean entry format.- Analyzed market trends resulting in 10% increase in sales and revenue. Tracked weekly sales data to check whether department hit’s goal.- Participated in Mining data from the SQL database that was used in several significant presentations.- Created and presented multiple information reports on findings from source to management based on SQL data.- Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for the development of various Tableau reports/ dashboards.- Effectively used data blending feature in Tableau to connect different databases like Oracle, and MS SQL Server.- Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs, etc.- Worked on Performance tuning of reports using concurrent query execution for better performance of reports.- Involved in creating TDE (Tableau Data Extract) using the PYTHON script.- Used Python Libraries such as Pandas, Numpy for data cleaning validation preprocessing or to perform Exploratory Data Analysis. Performed data visualizations using Matplotlib and Seaborn libraries. Analyzed sales trends, revenue growth. Identifies the factors affecting sales. - Designed and analyzed A/B test to evaluate the impact of changes in website, product description, or pricing.

- Involved in Tableau and Looker dashboard designing based on different kinds of visuals Ex. charts, tables, color combinations, etc. - Created Customized and interactive dashboards using multiple data sources. - Supported the existing Tableau dashboards and migrated the Tableau Dashboards into the Looker studio (Google Data Studio) with additional business requirements.- Participated in the requirements gathering and identified 15+ KPIs on Website Performance and Traffic Metrics such as Conversion rate, AOV, Revenue, Bounce rate, click-through rate (CTR), etc., and created an interactive and dynamic dashboard using Google Data Studio.- Participated in data collection, data cleaning, and data modeling using Google BigQuery, and Google Sheets.- Analyzed and reported actual operations performance vs planned.- Used MS SQL Server to gather and analyze data to evaluate the effectiveness of controls, and determine accuracy of reports and efficiency of operations.- Conducted data mining and data modeling in coordination with the finance department. Developed complex SQL to examine compensation. - Migrated the data from Tableau to Looker, and recreated the Tableau reports and dashboards in Looker.- Performed testing in Looker Setup to ensure everything works as expected. Monitor the performance and results of Looker dashboards.- Participated in Creating documentation for Looker setup, including data models, dashboard, and any custom code or configurations.- Responsible for daily communications to management and internal organizations regarding the status of all assigned projects and tasks. - Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.- Validating Tableau dashboards by running backend SQL queries and documenting the test results.- Working knowledge on Data Blending and connecting to various data sources through Tableau for data import.

- Creating and modifying Business Intelligence analytical reports using Tableau and Power BI.- Identified 10+ KPIs with outlined objectives and consistently monitored them. Implemented 10+ data flow optimization processes for reporting performance and enhancement- Gathered Business Requirements, and interacted with the Users, Project Manager, and SMEs to get a better understanding of the Business Processes.- Involved in creating complex Stored Procedures, triggers, cursors, tables, views, and other SQL joins and statements for applications.- Transformed the data and produced reports using the Power BI platform.- Developed complex SQL Queries using 14 procedures including Common table expression (CTE) to support Power BI and SSRS report.- Provided continued maintenance and development of bug fixes for existing and new Power BI reports on Weekly basis.- Migrated from Tableau Dashboard to Power BI. Recreated your tableau reports and dashboard in Power BI.- Used DAX functions for data cleaning and data modelling, worked on Advanced Visuals. Thoroughly tested the migrated reports and dashboards and ensured the work as expected and provided the same insights as in Tableau.- Participated in ongoing maintenance and troubleshooting as our team gets used to Power BI- Extensive use of Rally software tool to manage agile development, and creation of user stories, estimates, and updates. Viewing the burn-down charts and other reports, updating the team in meetings.- Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies, and procedures.- Extensively used Visio to create Use Cases Diagrams and Activity Diagrams.- Developing and maintaining a high-level overview of the project and design flows using MS Visio.

• Developed a Logistic Regression model using Python to predict customers most likely to churn.• Designed a web-based portal enabling customers to provide feedback on the services received.• Designed an A/B test to gauge the effect of introducing a feedback form on the website Developed a Linear Regression model using R to predict the time taken to complete a service based on the attributes of a house.• Improved model performance by reducing overfitting through penalized regression.• Developed SQL queries to join tables in MySQL and prepare data for statistical models.• Prepared reports using Excel Pivot Tables and Pivot Charts.• Assimilated and stitched unstructured customer data to MySQL database ensuring consistency.• Developed a web-based leave-application system, with validation procedures, for employees.• Created MySQL database to capture online inquiries placed on the website.