Nancy Sidhu

Tableau Desktop Specialist Certified and Alteryx Designer Core Certified, BI Consultant. 2.5 years of experience in data visualization, ETL, data warehousing. Experience in complex data projects across different sectors, working with multiple clients. Looking for a challenging position to grow in Data Analytics.

• SQL , PostgreSQL, Influx, MongoDB , Oracle, Excels , CSVs , PDFs

Industry: Pharmaceuticals- (July 2020 to present)

• Leading the monthly activities of a top notch pharmaceutical company, managing the monthly processes and ensuring the data flow is in synchronization with the master data setup
• Master Data Management- Managing the master data, in charge of all the updates/modifications and additions (if any)
• Providing insights to the business teams in terms of sales, revenue generated and volume growth, along with revenue forecasts
• Driving business conversations, maintaining a connect with cross functional teams to ensure smooth functioning of the processes
• Involved in smooth transitions in between business entities and product launches
• Technical- Design of Alteryx workflows to clean/blend the data from multiple sources, integrate the results with reporting tool: Tableau
• Design of Daily Sales Dashboard in Tableau, enabling the Sales Team to track the sales/volume growth on daily/weekly basis

Industry: Logistics- (April 2019 to March 2020)

• Leading the project since April 2019. Prepped time-series data stored at influx database. Designed workflows to handle ever-changing, fragile database, data refreshed at regular intervals as short as 5 min.
• Designed customised Automation Framework to fetch and post data for multiple customers across the globe, using single workflow for each report.Robust workflows/ Applications designed in Alteryx integrating R and Python to prep and update the data followed by triggered emails to a group of users.
• Highly involved in proactively detecting potential issues and discuss the same with the client. Experienced in working with cross functional teams, leading to the best and easiest solutions to the complications in warehouses of different customers across globe.
• Interactive Dashboards designed in Tableau Desktop, shared using Tableau Server.
• Business point of view: Resulting in increase in productivity of stations at warehouses, decrease in defects in machinery used, prediction of forthcoming hazards, with steps to take for prevention of the same.
• Industry: Manufacturing- (Feb to April 2019)
• Huge amounts of data, created Staging Architecture to segregate the data for transformation from different data sources. Created optimal structures to handle and transform the data. Used Alteryx Designer to achieve the same.
• Published the data to Tableau Server. Used the published data to design reports and visualizations in Tableau Desktop consequently embedded in a custom application designed in Java.
• Was deployed in this project at the time of closing timelines. Handled the fragile project professionally, with on-time deliveries within tight deadlines with a pleasant experience of the customer.
• Industry: NBFC- (May 2018 to Jan 2019)
• Worked with a full-fledged team of 7 members. Used Alteryx to handle and transform the transactional data (Daily/Monthly) generated at SQL Server. Set up the Automation to refresh the data daily/monthly.
• Used Tableau Desktop to design powerful, interactive dashboards shared across various departments of the NBFC.
• Decreased the effort of calculating the metrics manually/complex codes and replaced the process with easy to understand workflows in Alteryx.
• Understood the business and the requirements. Provided proactive steps to make flows across departments smoother and hassle-free, with no need to generate iterations across departments

• Alteryx, Tableau, SQL, MS Excel, Power BI, Grafana, Basics of R and Python, KNIME

Tableau Desktop Specialist Certified

Awarded for contribution in enhancing Business Performance, Team Computers-March 2019