Tanvi Gupta

Experience

• 

  The Times Of India

  Oct 2009 - Jun 2010

  Freelance Writer

  ● Contributed multiple articles pertaining to events, concerns, or motivational columns● Articles were published in TimesPlus - Weekly English language State Level Circulation of the reputed Times of India

• 

  UnitedHealth Group

  Sept 2012 - Jul 2017

  >> As Business Intelligence Developer <<● Developed functionality to reduce memory usage by ~ 85% (savings of ~10K$/year) using SQL procedures and batch files; Improvement recognized as Bright Idea for the year● Automated 3 weekly data migration processes for millions of records by implementing SSIS packages and SQL scripts reducing ~180 hours of manual effort● Remodeled pricing tool application's database to reference unified data warehouse for improved performance and processing efficiency● Expanded scope, usability and reporting capabilities of HCE tool by standardizing and simplifying integration mechanics for new market regions ● Strategized testing (unit/integration/regression), tracked and resolved issues using HP ALM/RALLY/MS TFS>> As Scrum Master and Project Lead <<● Enhanced agile maturity metrics by ~20% while serving a 7-8 members team over 2 years● Created dashboards that were adopted across 3 applications to efficiently track projects KPIs like burn-down, velocity, capacity ● Liaised between stakeholders, business users and development teams to remove impediments to sprint progress, served as SME for functional aspects of application to resolve complex issues, provide recommendations and strategize implementation● Reviewed and assisted maintenance of scrum artifacts – Sprint backlog, Product Increment, Product Backlog; Facilitated team collaboration through scrum ceremonies – Stand-Up, Sprint planning, Retrospective>> Experience Overview <<I worked on Physician Pricing Model, web based analytical tool for provider reimbursement through Health Care Economics Applications Suite. Optum is a leading IT-enabled health services business dedicated to helping make the health system work better for everyone. The parent company of Optum is UnitedHealth Group (Fortune No. 6 in 2017) a diversified health and well-being company serving more than 85 million individuals worldwide Show less ● Optimized performance by ~2 minutes per execution for 20 SSIS routines and 12 SSRS reports by revising 50+ SQL queries, script tasks and procedures ● Performed data mapping for 250+ fields to create views in SQL Database for data availability avoiding redundancy● Improved User Intuitiveness on 8 screens by adding dynamic validations for alerts and reducing clicks and NVA steps● Increased security for 3 major web-based analytical tools by exploring, planning and executing windows authentication for SQL database access● Enhanced employee engagement and team collaboration by initiating a weekly email Series, ‘Know Each Other’● Ensured project deliverables as per SDLC: Understand requirements – design and documentation – Development – Unit Testing – Delivery – Post Deployment Warranty, confirming compliance to defined standards, processes and company norms● Gained knowledge and developed understanding for the HealthCare Industry, especially for North American regions Show less

  • BI Developer, Scrum Master and Project Lead

    Mar 2014 - Jul 2017

  • Associate Applications Developer

    Sept 2012 - Feb 2014
• 

  The University of Texas at Dallas

  Jan 2018 - May 2018

  PeopleSoft Academy Intern

  ● Collaborated with senior business analysts and technology teams to create functional specification document for PeopleSoft Version Upgrade to 9.2 for the university (HCM and FMS)● Analyzed customization(s) implemented on different modules and created a consolidated BOK for future reference● Acquired end to end hands-on experience on PeopleSoft V9.1, SciQuest, Campus Solutions and OnBase for Navigation, Query Manager, Configurations, and Security● Developed understanding of ERP implementation for UTD to identify improvement opportunities● Gained functional knowledge - Finance, Budgeting, Procure-to-Pay, ePAR, Payroll, Human Capital Management, Campus Management, OnBase, Reports for ERP ● One of 12 selected from 83 candidates for the program run by UT Dallas Human Resources Department Show less

• 

  Essilor

  May 2018 - May 2019

  IT Intern

  ● Leading 5 diversely themed small-medium sized projects with 5-20 members team - Business Integration and Financial sustainability: Implementation of Oracle ERP for 2 new BUs- Global application and guided Consumer Journey: ECP Locator Phase 2.0, ECP Locator Canada- Software upgrade: ADP Platform Conversion - Process improvement: Robotics Process Automation● Gaining the following skills- Understand IT Enterprise architecture to perform Cost benefit analysis of proposed solution- Align projects to business goals and enterprise standards- Developing reports and dashboards for leadership team and executives- Timeline creation and milestone identification- Identifying dependencies and facilitating cross-functional, multi-zone collaboration for project success- Effort estimation, resource and capacity planning- Requirements gathering and scope definition- Tracking RAID, ensuring good project health and taking actions to remove or avoid impediments- Tracking project KPIs like burndown, velocity, and budget- Client/vendor on-boarding Show less

• 

  Essilor Group

  Jul 2019 - Mar 2020

  IT Project Manager

  Customer Experience | Financial Integrations | Supply chain | Automation | Marketing programs- Led marketing initiative for transforming customer experience when accessing organizational resources and programs, offer qualifications, etc. - Led CX Transformation initiative with a target headcount reduction of 6 FTEs by reducing turn around time, implementing SalesForce transformations, evaluating and improving customer service model, streamlining job status calculation to predict accurate milestones and shipping dates.- Led financial integration project to automate AR and statement generation and distribution; Cost saving of $120K / year.- Leading job status notification project that is a critical piece of Essilor’s Customer Experience transformation program to facilitatepro-active customer communication and reduce inquiry calls (~2 FTE reduction).- Leading supply chain initiative for order to cash process within sister companies to streamline back-to-back process.- Led ECP store locator initiative for Essilor US & Canada based on .Net, SQL, AWS and Google analytics; Adapted across 7+ regions.- Liaise with 15+ business units, 5+ service lines, resources & vendor partners to ensure project progress & resolve impediments.- Analyze and strategize to achieve business goals within defined timelines, budget, resources, and enterprise policies- Ensure risk and security compliance per consultation and guidance as per industry standards. Show less

• 

  Walmart Global Tech

  Mar 2020 - now

  Products / projects:Chat experience | Data Science & Visualization | Computer VisionResponsibilities:- Define product features and create user story acceptance criteria and get buy-in from stakeholders- Refine stories with agile teams- Prioritization and scheduling for sprints / cycles- Manage and upkeep product backlog based on dynamically changing business needs and priorities- Articulate product vision to engineering teams- Liase tech and functional discussions between dev and business teams to foster open communication and help the teams make progress and resolve blockers- Agile lead for large geographically distributed teams, organized into smaller pods- Facilitate agile ceremonies like planning, retrospective, daily scrum, Scrum of Scrums, and other ad-hoc discussions as needed - Work closely with leadership and higher management to create and align on quarterly goals and product roadmap- Track team metrices and define & play with different techniques, documentation templates, ways of working to ensure team productivity- Participate and contribute to UX discussions for creating an easy to use, clear and effective product Show less Projects / Products:Finance (Account receivables, account payables, inventory, cash office) | HealthcareResponsibilities:- Define product features and create user story acceptance criteria and get buy-in from stakeholders- Refine stories with agile teams- Prioritization and scheduling for sprints / cycles- Manage and upkeep product/project backlog based on dynamically changing business needs and priorities- Liase tech and functional discussions between dev and business teams to foster open communication and help the teams make progress and resolve blockers- Agile lead for large geographically distributed teams, organized into smaller pods- Facilitate agile ceremonies like planning, retrospective, daily scrum, Scrum of Scrums, and other ad-hoc discussions as needed - Track team metrices and define & play with different techniques, documentation templates, ways of working to ensure team productivity Show less

  • Senior Product Manager

    Nov 2023 - now

  • Manager II, Product Management

    Nov 2022 - Nov 2023

  • Manager I, Technical Project Management

    May 2021 - Nov 2022

  • Analyst II, Technical Project Management

    Mar 2020 - May 2021