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.• Enabled Product portfolio database for the operations, marketing users and sales for Forecasting, Actual and supply shortage analysis. • Rebuilt business process infrastructure to create more data-driven and data-govern organization• Created activity trackers in Power BI to track time spend on each stage by users for the executives to improvise and resolve the business issues• Facilitated and organized executive meeting every week to provide insights and analytics that scale well with the growing needs of the business• Maintaining Bill of Materials for Product Analytics and Pricing

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• Rebuilding an infrastructure to create a more data-driven organization•Providing support to Sales and Marketing as a part of Executive Office.•CPQ management•Designing and Administrating Pricing Tool for Marketing and Sales•Designing and configurating workflow for new process and systems to maximize the functionality and Minimize the customization.•Working with POs for Product Pricing

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) of the company• 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• Responsible for automating worksheet using VBA for Excel• Created capacity planning model in excel for comparing actual vs forecasted resource data across an organization• Created product dashboard using tools like Tempus, Tableau, Power BI, and QlikView• Responsible for identifying and resolving the gaps and issues in the process• Coordinating with all the program managers for the status of the projects to make sure projects are within budget• Responsible for managing bug dashboard for various program• Administrating MS Project and SharePoint for planning road-map for various projects and creating a site for documentation respectively• Responsible for creating data models in excel with an integration with EDW• Demonstrated ability to manage multiple, time-sensitive projects with competing priorities

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 structures•Implemented time and resource management on the projects using MS Project 2013•Ability to meet deadlines and handle pressure coordinating multiple tasks.•Completed database implementation project on time and under budget•Created detailed project plan with well-defined tasks, milestones, client sign-offs and specifications, which served to communicate project progress to management.•Implemented project management concepts such as scope, costing, scheduling, change request, risk management, contract negotiations, planning and tracking, quality, and change management throughout the project lifecycle•Created contracts, RFP, SOWs for the multiple projects•Communicated with all the stakeholders and provided project status reports to them.•Used regression analysis and forecasting to improve efficiency by 30 percent.•Applied technical skills using SAS, STATA,Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.•Executed mobile tests on multiple machines and prepared test reports for development team•Extensive experience in UAT, A/B Testing, SIT, Regression, Smoke, Sanity, Black Box, Mobile device Testing, End to End Testing, Mobile Xcode Platform testing, Mobile App Testing, Mobile Flashing

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 activities. •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.•Created and Managed Test Plans and activity timelines. •Acted as a liaison between the testing resources and the development team. •Identified and implemented solutions to mitigate risk.•Well versed with the SDLC, Testing Concepts, and Methodologies, which enhanced product quality.•Provided application training to new resources.•Designed Test Conditions and Cases and involved in Execution of Test Cases for Functional, Web and GUI testing using Black Box techniques.•Knowledge of Bug life cycle, experience in Bug tracking and reporting using Defect Management Tools.•Coordinated with satellite teams and internal team members to ensure speedy and efficient execution.•Prepared test reports and participated in Audits.•Analyzed data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, and optimizing database designs using SQL queries and IBM Rational Rose to satisfy client needs.•Coded various network components for Database server and Application Server in C++.•Worked in a matrix organization with complex release methodologies. •Worked and managed test engineering teams with the expertise to leverage technology to achieve business goals.

Master'S Degree, Information Systems And Operations Management

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