Aaryan Gupta Email & Phone Number

San Jose, California, US

Leading and enabling Digital Transformation and Pricing

San Jose, California, US

• Automated Daily Sales transactions into live analytics to track revenue by products and customers using ETL tools like Talend, Excel( Power Query)
• Managed a team of 10 members to create strategic models using Power BI, Power Queries per senior executive requests
• Administrated and designed CPQ tool for Pricing Analytics and trained Sales, Sales Reps, Product Line Managers, Business Development Managers for requesting quotes in the system.
• Created and streamlined business and operational processes to improvise the turnaround time by 50% in converting Product to PO.
• Integrated Pricing tool with PO transactional system to support backlogs and bulk orders.
• Developed and Managed Pricing Model app to support multiple rounds of internal Pricing analysis for the customers.

San Jose, CA, US

• Create and streamline business and operational processes
• Migrate Planning infrastructure from excel to Database
• Tactical pricing management to support Order Management in real time
• Improving excel models and automate processes
• Creating strategic models using Power BI
• Marketing enablement through “internal” IT support

San Diego, CA, US

• Working as a Project Analyst for Program Management Department and presenting trend analysis based on information from various cross-functional departments of the organization to the executive level (VPs and Directors).
• Analyzed data using SQL, Excel data Modelling( Power Queries, DAX, VLOOKUPS), and Business Intelligence Statistical Tools like Tableau, SPSS
• Develops technical business process solutions for problems for the Connectivity Business
• Interpreting and converting business data into useful data visualization format for the executive level or Stakeholders in order to provide business insights
• Predominantly interacting with internal staff across multiple lines of businesses (HR, Finance, Operations, Marketing)
• Providing resources, trend, and predictive analysis on the number of resources working across the organization

Westchester, Illinois, US

• Provided excellent customer service which helped increase store sales by 5%
• Updated and maintained the books inventory and reduce books searching downtime by 5%
• Demonstrated people management skills while working in the inventory

• Awarded best intern for providing exceptional services to the client and increasing revenue by 30%.
• Resolved clients issue to ensure complete satisfaction of the clients by giving the optimum solutions that lead to driving new business opportunities
• Reviewed and prepared documents, scope, solicitation and proposals
• Conducted daily stand-up meeting to review production defects, project constraints, and cadence roadmaps
• Defined processes and tools best suited to each project. Used agile and waterfall approaches depending on project specifics and client goals, creating detailed project roadmaps, plans, schedules and work breakdown.
• Implemented time and resource management on the projects using MS Project 2013

London, GB

• Analyzed and decomposed the business, functional and technical requirements into test cases, defined test data requirements, organized risk review meeting, devised contingencies plans and other test preparation.
• Designed and executed test cases and status metrics.
• Communicated effectively with IT Development, Project Management and Release Management on testing timelines, status report,issues and other relevant information.
• Leaded, Managed and Reported on functional Integrated system testing cycles.
• Developed and managed project quality reviews for assigned applications.
• Prepared test reports and participated in quality audits.

Master'S Degree, Information Systems And Operations Management

Bachelor Of Engineering (B.E.), Computer Science