NK

Namrata Kakade

Full time mother of a then · Sabbatical

Irvine, CA

In My Own Words

• Developed performance Reports/ Dashboards, Metrics, attributes, filters, what-if analysis for different functional areas using Tableau, Excel.
• Experienced in process execution including definition and implementation of Executive Dashboard/Scorecard.
• Hands on experience in data analytics with a focus on statistical modeling.
• Knowledge of SQL Query writing for extracting and data from various databases.
• Experienced in managing stakeholder expectations, excellent communication skills and demonstrated ability to work with and support cross-functional project teams and managing multiple projects simultaneously with attention to detail.
• Analyzed and incorporated User Stories in different release plans for the sprints in Scrum process.
• Knowledge of project metrics, including gathering, reporting, trend analysis, creation, and metrics
• Extensive experience in developing Mock-ups/Wireframes, User Interfaces (UI), using Axure & Balsamiq
• Handled release planning/release scheduling to ensure successful scope and coordination with the Business and Technology partners resulting in bundling of like requirements into Release Schedules for the applications developed by various projects.
• Experience in conducting Gap, Impact, Cost Benefit, and Risk analysis.
• Experience with best practices and structured QA methodology.
• Experience executing test cases and doing Ad Hoc Testing, Regression Testing, System Testing, Unit Testing, logging defects and tracking to resolution.
• Manage / develop the knowledge transfer plans, transition plans, and documentation of required project deliverables.

Tools:
• Tableau • SQL • KNIME • Power BI • MS Excel
• JIRA • Qlikview • Dremio • R • Microsoft Office Suite
• Python

Work Experience

Full time mother of a then

Sabbatical

2020 – 2022

(forced) August 2020 - October 2022

• Work Authorization expired. Obtained renewal in Oct 2022 after pandemic induced delays. • Full time mother of a then 10-month-old (now a 3-year-old) • Ensured I remain updated with my skills by enrolling in online courses & projects, participating in freelance projects.

Data Analyst

MSX International

2019 – 2020

• Preparation of analysis and reports using Tableau, Power BI, Dremio, KNIME, SQL, MS Excel ? Extract, compile and track data to generate dashboards that provide insights into the OEM dealers operations. Example: Improve parts and labor sales (using repair orders, parts and labor sales data), Improve customer retention (using service flow data), improve dealer performance (using mystery shop, invoices data) ? Build complex calculations and presentations to develop efficient system operations ? Interpret data from different sources using statistical techniques and provide reports. ? Develop Analytics-reporting suites which are set of highly configurable online dashboards, including strategic, tactical, and operational dashboards ? Selecting features, building and optimizing classifiers using machine learning techniques and tools like R, KNIME ? Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis. • Integrating data from diverse sources from multiple platforms using platforms like RedShift, Dremio, Tableau, Power BI ? Blend data from multiple sources to generate new insights ? Readying good quality data using data mining, cleaning, transformation and modelling etc. ? Develop and manage the analytics semantic layer through reusable data source ? Work with analytics/database team to develop and refine analytical methodologies and provide data warehouse structures recommendation • Project management ? Interviewed Business Users to gathered Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead. ? Collected requirements from department managers and users for enhancements. Acts as liaison between clients and development. Facilitates sessions to bring business requirements and functionality into system development and enhancement. ? Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system. ? Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements. ? Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation. ? Identified documented data sources and transformation rules required to populate and maintain data warehouse content. ? Tested Performance Accuracy related queries under SQL Server. ? Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Activity Diagrams and Sequence Diagrams using Microsoft Visio.

Business Transformation Officer

TATA Technologies

2017 – 2018

• Participating in research & assessment of business processes, systems, internal controls, and policies & procedures. • Conduct user and business needs analysis for the Data Warehouse and Business Intelligence application. • Generate requirements documentation and translated into system specifications which included data maps from source data to destination repository, functional specifications of the Business Intelligence Reports. • Analyze the data/reports in the existing data warehouse, propose new methods to acquire and represent information. • To predict seasonal effects of vacation rental bookings on regional basis, make monthly predictions of available vacation rental properties based on availability trends, forecast performance and revenue generation over time across rental properties and locations.

Quality Executive

TATA Technologies

2010 – 2012

• Process implementation: Process execution including definition and implementation of Executive Dashboard/Scorecard; define Service Level Agreements and establish QA/QC strategy and teams. • Project Management: Constructed project plans replete with tasks and time estimations, identifying and acquiring appropriate resources and monitoring for adherence to scope and timeline • Internal Audit: Execute group internal audit; and special investigations, compliance with policies and rules, carrying out root cause analysis and coordinating with project managers to prevent recurrence of the same. • Risk mitigation: Developed, implemented a comprehensive standardized data archiving and risk mitigation process. • TBEM: Co-ordination and execution of organization processes and sustenance of Tata Business Engagement Model (TBEM) with the Business Excellence Team of TATA Technologies

Education

MS

Harrisburg University of Science & Technology

2016 – 2017

MS

BE

University of Pune

2005 – 2009

BE

MBA

Welingkar Institute of Management Studies

2012 – 2014

MBA