Shruthi Ashok
Hillsboro,OR
Summary
Seasoned Supply Chain Data Analytics and Application Development Manager at Qorvo, adept in leveraging SQL, Power BI, Python and Appian to drive significant improvements in enterprise analytics reporting and Applications. Demonstrated expertise in mentoring cross-functional teams and leading technical projects, resulting in enhanced data governance and operational efficiency. Excel in strategic planning and stakeholder communication, ensuring alignment with business objectives.
Overview
13
13
years of professional experience
Work History
Manager Supply Chain Analytics & Application Development GPnL
Qorvo
04.2023 - Current
- Building applications in Appian and reports in Tableau and Power BI
- AOP meetings, prioritizing requirements and manage technical projects for enterprise GPnL
- Mentoring teams in Europe and NA
- Architecture design provided to technical team to build applications
- Maintain, drive, supervise and implement robust technical standards, systems and processes
- Coordinate the regular testing of products to address faults and provide evaluations in order to improve them
- Influence technology strategies and decisions with a high-level of expertise and knowledge
- Tools: Appian, SQL, Snowflake, SAP ECC, Tableau, Power BI, Alteryx, Databricks
Sr Software Engineer
Qorvo
08.2020 - 04.2023
- Proven ability to respond to and prioritize changing business demands effectively
- Experience demonstrating interpersonal, presentation, and communication skills in communicating progress on near term and mid-term plans to users and partners
- Demonstrated complex critical thinking and ability to creatively solve problems with measurable business impact
- Experience addressing current and future customer needs through innovative solutions
- Analyze, design, programs, debugs, and modifies software enhancements and/or new products used in local, networked, cloud-based or Internet-related computer programs
- Code may be used in commercial or end-user applications, such as materials management, financial management, HRIS, mobile apps or desktop applications products
- Using current programming language and technologies, writes code, completes programming, and performs testing and debugging of applications
- Interact with users to define system requirements and/or necessary modifications
- Expertise in best design and implementation practices in data visualization tools such as Tableau or PowerBI
- Experience demonstrating interpersonal, presentation, and communication skills in communicating progress on near term and mid-term plans to users and partners
- Building applications in Appian
- Tools/Technologies: Tableau, SQL, Power BI, Basics SAP, Data Analysis, Appian
Data Analytics Manager
Nike Inc
02.2020 - 08.2020
- Work with business stakeholders to gather, analyze, and translate requirements in the BI reporting area, either by recommending an existing solution, developing a solution, or synthesizing requirements in support of a new project initiative
- Prioritize the requirements and meet the needs of business
- Work with key partners to deeply understand their needs and improve opportunities to drive knowledge into action
- Develop crucial functional requirement specifications, created detailed use cases, process flow diagrams and dashboards to support functional specifications in the form of epics, user stories and documenting the same over different iterations and sprints, in addition to issue tracking, as-is analysis, workflow analysis, & troubleshooting
- Troubleshoot data and analytics issues and perform root cause analysis to proactively resolve issues
- Understanding of data mining techniques and familiarity with applied statistics including time series analysis
- Writing queries in snowflake, Athena and Hive and assist developers in writing blocks of code based on requirements
- Assist in coming up with KPI metrics and building reports in Power BI which helps in answering business critical questions
- Create, lead, and execute a strategic research roadmap that explores complex problems and delivers compelling, actionable, and impactful insights for Nike’s digital business and analytic plans to identify opportunities to accelerate growth and improve consumer experience
- Create and standardize approaches for identifying & quantifying key consumer trends that are meaningful to shaping and improving Nike’s digital and mobile shopping experiences
- Working with salesforce team on consumer data related to surveys, voice, chat and app
- Work with adobe analytics team to configure the marketing metrics for downstream and reporting team
- Tools: Athena, SQL, Hue, Hive, S3, Snowflake, Documentation, MS Visio, Tableau, Enterprise Reporting, MS Excel, Read python and spark scripts, JSON, NLP
Data Analytics Manager
Nike Inc
10.2018 - 02.2020
- Work with business stakeholders to gather, analyze, and translate requirements in the BI reporting area, either by recommending an existing solution, developing a solution, or synthesizing requirements in support of a new project initiative
- Drive standardization of key metrics across various business stakeholders to improve data governance
- Collaborate with other teams for cross-functional data initiatives and analytics
- Provide expert advice in the usage and interpretation of data to various business stakeholders
- Develop and deliver training on data and analytics tools in order to provide autonomy to key data users
- Recommends system functional improvement to meet user requirements
- Ensures system and process user requirements are properly defined and met and tasks are accomplished within defined time frames at the highest quality with attention given to detail and scalability
- Support product manager in gathering business requirements & translating them into technical specs
- Wireframe, pilot & scale advanced dashboards per business requirements
- Help build trust in the numbers by becoming an expert in what’s happening in the back end (both ETL and UI) and translating that into consumable messaging
- Address end-user questions related to dashboard logic
- Collaborate with data engineers to optimize and maintain dashboard performance
- Write queries in snowflake, Athena and Hue
- Validate off platform files in S3 and validating the data type and format of data
- Read hive and spark code in bitbucket and provide the transformation/logic for new product enhancement or change request
- Documenting the findings in the confluence page and getting them reviewed by Engineering team
- Understand all the data sources used in tableau dashboard and write DAX /measures based on the user requirements
- Work with adobe analytics team to configure the marketing metrics for downstream and reporting team
- Tools: Athena, SQL, Hue, S3, Snowflake, Documentation, MS Visio, Tableau, Enterprise Reporting, MS Excel
Business Intelligence Analyst
Smith &Nephew
06.2018 - 10.2018
- Analyze large datasets using SQL & Excel to spot key insights and trends
- Create dashboards and reports for internal stakeholders in order to improve efficiencies and promote growth
- Effectively communicate complex analytics to broader audience in writing and presentation formats
- Help prioritize business and information needs
- Analyze the external data and internal data and assist data architect in building a data warehouse
- Build Reports using TM1 Cognos & Power BI
- Analyze critical data like market share data and primary research on competitors and assist in providing business insights
IT Business Analyst
LaCrosse Footwear Inc
06.2016 - 06.2018
- Company Overview: LaCrosse is known footwear manufacturing company
- The company manufactures boots and other footwear primarily for agriculture, hunters, construction workers, and for the outdoors
- Analyze the requirements and map them with ERP systems (Microsoft Dynamics AX) without much code customization
- Work on modules-production Control, inventory and warehouse, product information management, Sales Order Management
- Create reports for business and data analysis using Power BI tool, SQL and Excel PowerPivot
- Attend Kaizen manufacturing meetings and involved in changing process with the team to benefit business
- Develop crucial functional requirement specifications, created detailed use cases, process flow diagrams and dashboards to support functional specifications in the form of epics, user stories and documenting the same over different iterations and sprints, in addition to issue tracking, as-is analysis, workflow analysis, & troubleshooting
- Worked with ITA, and Dev teams for successful implementation of the user stories
- Coordinate with both business and developers to ensure business, data needs and views are properly represented throughout the project lifecycle and coordinate communication regarding implementations
- Act as liaison between business owners, developers and QA team to ensure enterprise data needs were met and worked closely with-it Project Managers to report project progress
- Validated data mappings, data discovery with development team
- Work closely with systems analysts to ensure functional specifications are properly accounting for business needs
- Facilitated meetings, as necessary, to review captured business needs and obtain approvals
- Conduct reporting requirements from the data warehouse and analyzed the tables and columns to be added in the data warehouse from the sql server
- Data warehouse project- Documentation, Analysis, facilitating meetings, involved in EDW data mapping, collected all data required to build logical data model, test relations between fact and dimension tables, writing complex SQL queries to make sure that the data is fetched right
- End to end testing- Assisted in Smoke, functional, performance, SIT, and regression testing, User Training and KT
- Microsoft Azure: Writing DAX formulas, assist consultants to build data model in AAS (Analysis Services) and connect to Power BI to build dashboards to executives, collect large datasets based on the requirements and build reports in Power BI either by using direct query/import process
- Power BI training to users
- Modules worked in AX ERP: Inventory and warehouse management, Production control, Product Information management, Procurement and sourcing, Master Planning
- LaCrosse is known footwear manufacturing company
- The company manufactures boots and other footwear primarily for agriculture, hunters, construction workers, and for the outdoors
- Technologies: ERP-Microsoft Dynamics AX, Power BI, MS Word, MS Excel, Service Now, SharePoint, SQL, PowerPivot reports, X++, AOT, Visio, Visual Studio
Business Analyst
GSK
11.2015 - 06.2016
- Up-gradation, Requirement Gathering, Business process improvements, Configuration and Support for GSKs Inc
Intern
GSK Solutions Inc
12.2014 - 06.2015
- Data Maintenance, Programming, Analysis and Support for GSK solutions Inc
Research Intern
Indian Institute of Science
12.2011 - 05.2012
- Company Overview: Research Center
- Research, Analysis, Computer network research on protocols, configuration for Supercomputer and Research Center
- Research Center
Education
Master of Science - Industrial Technology
CSU Fresno
12-2015
Bachelor of Science - Information System
VTU
Bangalore,IndiaSkills
- Java
- SQL
- UML
- JIRA
- Power BI
- Tableau
- SharePoint
- Athena
- Snowflake
- AWS
- Appian
- Oracle
- Microsoft Dynamics AX 2012
- Alteryx
- Databricks
- SAP
Timeline
Manager Supply Chain Analytics & Application Development GPnL
Qorvo
04.2023 - Current
Sr Software Engineer
Qorvo
08.2020 - 04.2023
Data Analytics Manager
Nike Inc
02.2020 - 08.2020
Data Analytics Manager
Nike Inc
10.2018 - 02.2020
Business Intelligence Analyst
Smith &Nephew
06.2018 - 10.2018
IT Business Analyst
LaCrosse Footwear Inc
06.2016 - 06.2018
Business Analyst
GSK
11.2015 - 06.2016
Intern
GSK Solutions Inc
12.2014 - 06.2015
Research Intern
Indian Institute of Science
12.2011 - 05.2012
Master of Science - Industrial Technology
CSU Fresno
Bachelor of Science - Information System
VTU
Similar Profiles
Joel ButtsJoel Butts
Production Supervisor at QorvoProduction Supervisor at Qorvo
Zuleyma BustamanteZuleyma Bustamante
Crew Team Member at QorvoCrew Team Member at Qorvo
Maimoona ShaadMaimoona Shaad
Software Tester at QorvoSoftware Tester at Qorvo