Data Analyst

Namrata Saha

Phone: +1-774-***-****

Email:*******.******@*****.***

https://www.linkedin.com/in/namrata-saha-448b9679/ Professional Summary

• Proficient with Tableau: Writing Aggregate functions, calculated field calculation codes, using Impactful Story telling visualizations to spin data into actionable insights.

• Possess strong analytical acumen, with track record of being a strong problem solver : capable of translating data into meaningful analysis and insights with excellent business stakeholder engagement and driving value for the business.

• Expertise in Understanding and Analyzing Business requirement Documents and writing them, Tracking Changes and maintenance of Test Requirements.

• Identifying best sales channels and A/B testing for the product for the client and generation of relevant reports to analyze the success of the business- in terms of demand and supply.

• Documented various workflow diagrams like AS-IS and TO-BE processes

• Project scoping - Ability to see the big picture and to focus on details when necessary.

• Proven Leadership skills at training and mentoring new resources in the team.

• Proven track record of problem solving, project management and organizational skills, with an ability to initiate, prioritize and execute complex, cross- functional projects with minimal guidance across business and leadership levels. Technical Skills:

Languages R,Python,C, C++

Tools Tableau,Alteryx,IBM Cognos, Ignition, Shotscope, EIT Project Methodologies Iterative, Agile-Scrum, Waterfall Packages MS-Office Suite(Word, Excel, Access), MS-Project and MS-Visio Databases SQL, PL/SQL

Professional Experience

Niagara Bottling LLC, Diamond Bar, CA June 2017 – January 2020 Role: Manufacturing Data Analyst II

Responsibilities:

• Setting up the data acquisition tool called Ignition on the server and creating a dashboard and alert system for WasteWater project.

• Defined KPIs and build complex Dashboard with large unstructured datasets to understand plant complexity using R and Python for over 30 plants with more than 90 lines using statistical models.

• Building analytical pipelines and creating a Data repository (Vertica) solution from various manufacturing data points for all domestic and international manufacturing plants.

• Develops and runs complex SQL queries and develops data collection spreadsheets with pivot tables and index matching to support area decision-making for Stretch Wrapper project : Estimated savings of $1M across 30+ plants.

• Replace legacy BI reporting solutions by gathering and understanding complex business requirements to develop custom data sets and create visual interactive BI dashboards and reports for Time Series, Forecasting, Transactional data and data analysis reports (Periodic OEE, Financial performance, Return Merchandise Authorization/Quality Dashboard, Manufacturing KPI, Injection KPI (MSA) Comparing strategic and Tactical throughput) using Tableau.

• Create complex calculation fields using table calculation, Date, Aggregate functions in Tableau.

• Compiling the team’s weekly update and tracking team’s task statuses on Trello.

• Troubleshooting Data collection from Multidimensional datasources and provide insights for end-to-end ad-hoc analysis by performing advanced analytics on manufacturing, procurement, inventory, financial data and extract data to monitor plant performance.

• Data collection and munging using Python ( Pandas, Numpy) and Excel for various AdHoc projects and creating compelling PowerPoint presentations for upper management stakeholders for executive presentations to make important business decisions.

• Creatively translate business problems into a subset of data science problems that leverage appropriate methodology

(Classification, Regression etc.) and develop data models to aid in better understanding the impact of manufacturing activities to the financial performance and Key Performance Indicators of the manufacturing sites.

• Data munging for Machine fault code analysis over more than 30,000 machines for providing vendor partnership related data.

• Work with IT teams and supply chain teams as a liaison for all manufacturing data solutions.

• Interview and mentor incoming Data analytics interns.

• Documenting SOPs and ROIs for various inhouse tools (Shotscope, EIT, Ignition).

• Monitored Project tasks, schedules, meetings, deadlines for the data analytics team using MS Project and Visio, Created Administrative documents to keep the track of every movement in the project for Weekly/monthly Reports.

• Scrap Analysis investigation to identify points of Lack of sales and quality issues and provide a detailed report for 30+ unique plants.

• Utilized Alteryx to perform ETL.

• Building TCO models in liaison with the finance team. VisionSoft Global, Princeton NJ May 2016 - Dec 2016 Role: Business Intelligence Analyst

Responsibilities:

• Assists in evaluating proposals for data collection through an understanding of the functional area business and applications need.

• Assists in planning and implementing activities required for the collection and analysis of data related to departmental business needs, including the development of data collection systems.

• Worked as a business analyst on SAP HANA and Hadoop integration project for a pharmaceutical client.

• Build client presentations and meeting prospective clients to deliver compelling presentations, solution demonstrations and proposals.

• Performed Data Cleansing and transformation on the reporting datasets to provide useful insights to our client using Alteryx

• Worked as the Lead generation executive from May 2016- august 2016.

• Working with Microsoft project, Oracle systems Data exploration and visualization using Tableau for Data analysis report generation.

• Applying Software development Lifecycle and Methodologies like Waterfall, Agile and Scrum Approach.

• Experience in Preparing detailed reports and presenting trends using tableau dashboards on an ongoing basis.

• Created audit reports involving charts and graphs using Excel, Tableau dashboards.

• Created the data story in Tableau by implementing interactive dashboards using drill down filters and parameters. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.

• Developed Tabular, drill down, parameterized, cascaded, and sub-reports using Tableau. Education

Harrisburg University of Science and Technology, Harrisburg, PA Master of Science in Project Management May 2022

Worcester Polytechnic Institute (WPI), Worcester, MA Master of Science in Information Technology May 2017 Mukesh Patel School of Technology management and engineering (NMIMS), India Bachelor in Electronics and Telecommunication May 2015 Certifications:

Yellow Belt Six Sigma certification July 2017

Green Belt Six Sigma certification September 2017

Contact this candidate