Swati Tyagi Email & Phone Number

Carrboro, Nc, Us

United States

▪ Developed and maintained various data pipelines, Power BI dashboards, reports and data visualization that have helped optimize the company's business processes and decision-making.▪ Created database objects such as Tables and Views and wrote complex SQL queries to extract insight from the complex data sets to identify and solve business problems. ▪ Worked with various stakeholders across the organization at the requirement-gathering stage to understand business problems and created Power BI dashboards, KPIs, scorecards, and interactive visual reports to provide data- driven insight. ▪ Created and maintained data models, Power BI datasets, dataflows, and shared data sets to support multiple Power BI reports, business analysis and enable self-service reporting for business users. ▪ Created and maintained complex DAX calculations, measures, KPIs and M query. Utilized Power Query to extract, transform, and clean data from many sources to load it into Power BI for reporting. ▪ Increased efficiency and saved significant manual hours by developing a SIOP dashboard that provided insight into shipping timeline, stock vs. requirement, supply and demand, material consumption, etc. These reports integrated the data from various sources like SQL server, SharePoint, and Excel and then published them to Power BI service for end-user distribution and scheduled gateway refresh▪ Created a dashboard to dynamically calculate the resource utilization at various levels of granularity . This streamlined analysis processes, resulting in the time reduction on the analysis and significantly enhanced data visibility.▪ Maintained ongoing metrics and dashboards and resolved open tickets for broken reports.▪ Migrated the SQL Server Reporting Services (SSRS) reports from SharePoint to the SSRS server. ▪ Trained and mentored other data analysts at Wabash and demonstrated excellent leadership and communication skills.

United States

• Managed the HR data and provided the monthly, weekly, and Ad-hoc reports.• Developed hourly recruitment dashboards for the HR department using Tableau and Excel.• Automated the different workflows using Excel and Alteryx.

Monticello, Indiana, United States

▪ Collected and analyzed data to carry out depth research to develop marketing strategies.▪ Determined the major key performance indicators (KPIs) that influence seasonal sales.▪ Provided sales comparison to convince the buyer to order two million new cushions. ▪ Developed the Power BI, and Excel interactive dashboard for internal and external use.▪ Developed automated reports to evolve the season sales for the Omni-channel, which reduced the 60% data analysis time, and made it easy to evaluate the different channel's sales patterns.▪ Designed vendor scorecard and automated the report for the procurement team, reducing the 50% time of report creation and data analysis. ▪ Analyzed the production data to validate the existing measures to improve the production capacity. ▪ Generated daily, weekly, monthly, and seasonal productivity reports, which highlight sales, profit, and seasonal targets. These reports are also used to respond to research inquiries.▪ Analyzed the purchase order (PO) total quantity against scripted quantity to avoid any penalty or legal issues because of any inconsistency. ▪ Used Excel, Access, and complex SQL queries for organizing and abstracting the supply chain data from Walmart’s DSS server and SQL database to create automotive reports. ▪ Participated in the production improvement team and provided feedback and suggestions on company data governance and integrity. ▪ Documented the requirements of the projects, data dictionaries, layout the business and data flows.▪ Helped colleagues to create Excel automotive reports and provided informal assistance such as technical guidance.

India

• Developed the database architecture to support the front-end application.• Set up data governance to the inflowing data so that the front-end functionality is maintained.

Baton Rouge, Louisiana Area

▪ Utilized Microsoft Excel to maintain the lab budget and maintained the lab website by updating and uploading the lab’s activities. ▪ Communicated with vendors to get the best quotation for lab supplies and trained 2-3 undergraduate students every semester in the lab.

Master'S Degree, Engineering

Master'S Degree, Mathematics