Ayushi Rajput Email & Phone Number

Woonsocket, Ri, Us

• Designed, deployed, and maintained highly available and scalable AWS infrastructure using services like EC2, S3, RDS, and VPC.• Analyzed 3 million customer data to reveal missing values, trends, patterns, outliers through exploratory data analysis (EDA), enabling data accuracy by 25%.• Executed SQL queries at custom SQL level to pull data in Tableau desktop enhancing data visualization and reporting accuracy.• Increased user hit rate by 40% in 4 months, managed day-to-day reporting, and KPI for marketing campaigns.• Built interactive Tableau dashboards for sales KPIs by utilizing calculated fields, LOD calculations, contextual filters, dynamic sets, parameters, and trend lines.• Created and Published Tableau Dashboards into Tableau Server, providing stakeholders with actionable insights.• Boosted sales by 20% by cleaning sales data, performing exploratory analysis using Python (NumPy, Panda), and SQL.• Streamlined end-to-end documentation for data analysis projects, standardizing processes boosting project efficiency by 25%.• Collaborated with 14 members in cross-functional teams to design prototypes, and user-centered designs using Figma and authored user stories in an agile environment with JIRA.

• Performed data preprocessing & feature engineering for further predictive analytics by Python.• Handled large data to optimize complex SQL queries applying various mathematical, aggregate functions, joins, sub-queries, unions, window functions to extract ad-hoc reports.• Entrusted review, distribution of metrics for internal consumption, regulatory reporting, ensuring adherence to financial regulations.• Extracted data from the database with SQL, developed, managed, adjusted, enhanced SQL Server databases to suit business needs.• Utilized SQL server to pull data into Power BI & created Power BI reports employing joins in multiple tables from multiple databases leveraging complex SQL queries.• Designed & developed Power BI graphical & visualization solutions with BRD and plans for creating interactive dashboards.• Devised various solution-driven views, reports & dashboards by crafting different chart types including Pie, Bar, Tree Maps, Circle Views, Line, Area, and Scatter Plots in Power BI, scheduling refreshes of Power BI reports, hourly/on-demand.• Saved 20+ manual hours every week, for stakeholders by streamlining 25+ monthly Power BI reports using DAX languages.

Bangalore, Karnataka, In

• Collaborated with clients and project managers for requirement gathering, and to facilitate change management• Created interactive weekly reports and dashboards using Tableau and MS Excel for analyzing KPI’s and project management• Analyzed, Transformed, and Mapped large Ecommerce data sets by applying complex SQL queries using MS SQL server to unveil trends, opportunities, and business impact

Bangalore, Karnataka, In

Collaborated with cross-functional teams to create SQL data queries and data sources used for reports and analysis•Gained knowledge of waterfall and agile methodology for strong foundations of software development life cycle

Master'S Degree

Bachelor’S Degree, Information Technology