Varun Aggarwal Email and Phone Number

Develop & Own product roadmap for logistics space working in tandem with stakeholders( Last Mile, Fleet). Define & manage quarterly/yearly OKR(s) by working in collaboration with business ,product , engg SLT teams.Lead API data management strategy with 3rd party carriers for inbound & outbound deliveries. Leading strategic & execution efforts on vroom fleet route & capacity optimization in collaboration with data science & operation teams. Building 0 to 1 product vision for inventory management & fleet route movements visibility.

As a product manager, I am driving internal dell search & website customer satisfaction efforts on dell.com/support . 1) Responsible for prioritizing business & customer needs related to internal search.2) Leading efforts with analytics team to generate automated dashboards on important KPI(s) & OKR(s).3) Facilitate key strategic decisions among executives using data driven approach. 4) Responsible for working with vendor(s) & strategize fiscal year roadmap planning 5) Analyze customer behavior & provide new feature suggestions for better customer satisfaction.Leading effort on new initiative as Enterprise Knowledge Graph 1) Facilitate workshops among key stakeholders to identify business use cases. 2) Identify key vendors related to knowledge graph based on market research & use cases .3)Closely working with enterprise architects to understand technical viability/feasibility on some critical decisions.4) Closely working with Taxonomist/Ontologist for building knowledge graphs.

As a technology consultant, I am working with clients to identify the disconnect between IT and core business and helping the clients to achieve IT transformation.Client: Industrial & Civil Construction Created an enterprise data visualization dashboard for the executive board members of organization. The goal and vision is to identify the impact of IT in the organization.Roles and Responsibilities:1)Interviewed multiple stakeholders and analyse the gaps among various data sources and establish the relationship between multiple IT value streams.2) Design and architect the data model for Executive Dashboard and automate the refresh strategies for beta loading.3) Performed data cleansing and transformation utilizing complex power queries in power BI.4) Worked with cloud team to create data pipeline and consolidate raw data in Azure Data Lake from various legacy systems.Tools and Technologies: SQL Server Data Tools, SQL Server Management Tools, Power BI, DAX , Azure Data Lake Store, Azure Analysis Services Client: Financial InstituteAs a part of current pursuit with Fortune 500 company, I am currently working to identify,analyze and document the feasibility & knowledge gap and dependencies associated with of one of the complex custom applications for migration project .I am responsible for analyzing and documenting the business & technical aspect and create a backlog & "To-BE" architecture for the MVP(minimum viable product).Roles & Responsiblities1) Understanding the in depth business functionalities and documented them in Requirement Tractability Matrix. 2) Conducting meetings with SMEs to identify and understand the essential business rules and incorporate them into epics and user stories.3) Creating a technical document capturing the variables state and design pattern by utilizing debugging capabilities for back end services(Struts 2.0) ,analyse & identify the interaction of JAVA services with mainframe systems & databases.

1) Responsible for sending data from WordPress webpages to Salesforce.2) Perform strategic data load from various sources into Salesforce by creating automated workflows and triggers.3) Create reports and dashboards in Salesforcefor easy decision making,4) Integrating various data sources into mail chimp and automate email procedures.

I worked as a technology consulting intern with Saint-Gobain group. My basic responsibilities were to identify the bottlenecks and scope of improvements in the different processes involved in making electrochromic glasses and implement optimal solutions for the same.Part of my responsibilities involved:• Collaborate with Business System team in technical decision making regarding technical needs and interface needed for stakeholders’ requirements.• Communicate with manager on project status and technical issues.• Conduct meetings with stakeholders and understand business requirements; create high level technical documents and flow charts based on requirements.• Implement server side and client side programming for different functional requirements.• Created JAVA RESTful web services for multiple manufacturing processes and developed dashboards using angular js as front end.• Develop complex SQL queries and display result in report format.

Responsible for creating and maintaining athletic website for university.Currently working on creating new product for Athletics Department(Asset Management) Responsibilities:1) Developed database schema for different modules of a product.2) Identified critical business components and mapped these components to database elements.3) Integrated and configured sql server database with code generator tool(Code On Time).4) Understood the business requirements and created user interface accordingly.5) Documented all processes and requirements along with custom configurations on tool.

As a Senior System Engineer,I am a core member of the team for requirement gathering, coding, unit testing, peer review, and adhering to best software quality practices.I have worked on multiple projects as an Application Web Developer and java developer.I have also worked on oracle 11g and sql .Created normalized database schema and SQL stored procedures with high complex queries.