Deepti Chaturvedi
******.************@*****.*** LinkedIn Illinois, Chicago 217-***-****
Product professional with 5 years of experience in managing product roadmaps and leveraging data insights. Proficient in SQL, python, Tableau & R. Extensively applied data driven techniques to solve real world business problems in various domains. EDUCATION
University of Illinois, Urbana Champaign Aug 2019 - Aug 2020 Master of Technology Management with Business Analytics GPA: 3.86/4.0 Vellore Institute of Technology, Vellore, India Jul 2010 - Apr 2014 Bachelor of Technology: Information Technology CGPA: 8.3/10 TECHNICAL SKILLS
Programming Languages: R, Python, Java
Database: Oracle 11g, Teradata, Microsoft SQL Server, MySQL Reporting Tools/Others: Tableau, Excel, Google Analytics, MS Project, MS Office Tools, ALM, JIRA, Visual Studio, Selenium, Agile, SDLC, STLC, Scrum, Confluence, Mainframe
Relevant Course work: Project Management, Statistics using R and Tableau, Python, Predictive Analytics, Consumer Analytics, New Product Development, Simulation and Risk Analysis, Process Management, Introduction to Finance and Marketing PROFESSIONAL EXPERIENCE
BANK OF AMERICA - Senior Analyst Aug 2018 - Sep2019 Cards Division
• Integrated data from Teradata & Mainframe platforms using SQL to query customer data with a single job submit, achieving a man-hour saving of 6 hrs./week
• Created dashboards using Tableau to visualize the impact of various payment features on the sales of BOA based on demographics to help the sales team generate leads
• Performed competitive analysis to compare pricing and features of BOA with other competitive banks to help marketing team devise go-to-market strategy
• Developed project roadmaps using Microsoft project and work with cross-functional teams to design auto-debt feature (business, program managers, product, development, UX, analytics) for 150 customers
• Examined concept-to-launch for Auto-debt feature & managed the sprint planning for 28 sprints using Agile method
• Headed the cards team comprising of 12 staff members and mentored 3 trainees, overseeing their day-to-day activities
BLACKSTONE GROUP - Technical Business Associate Aug 2016 - Jul 2018 Niagara - Fund Roll Up
• Developed statistical models to identify and evaluate potential investment deals, helping stakeholders to save
$4m on investments
• Identified flaws and its consequences by monitoring the transactions for major funds using the excel based financial forecasting tools to help fund accountants
• Collaborated with the clients to capture technical & functional requirements to design wireframes & mockups to help QA and Development team
• Implemented new user tools into production while also providing technical assistance, live demonstrations and additional training to end-users
• Led the FRU team and delivered presentations about new features/enhancements on bi-weekly basis to clients, dev, fund accountants and testing teams
NUCLEUS SOFTWARE EXPORTS LTD - Business Analyst May 2014 - Jul 2016 Loan Management System
• Extracted and examined data from DB schemas to identify anomalies in data records and developed SQL scripts to resolve such issues, reducing the number of quarterly reported incidents for case creation application by 32%
• Created detailed documentation as part of data integration technology project, which includes: Interface Specifications (ISD), Functional Specification sets (FSD) and Data Integration Mappings to guide Developers ETL
(Extraction-Transformation-Load) technical design documents, and QA (Quality Assurance) test cases creation
• Managed the digital marketing team to design the billing capture, receipt & payment creation features for DCB Bank, increasing revenue of DCB bank by 16%
• Implemented Tableau dashboards to present the loan management services used by various Nucleus clients to stakeholders, helping them to prioritize the features for iMobile app