NIDHI VYAS
Greater New York City Area 847-***-**** *********.***@*****.***
PROFESSIONAL SUMMARY
Master’s in MIS backed by diverse mix of experience having worked at an established and at a small enterprise which helped me leverage my skills in Engineering, Analytics, Leadership and Business. Quick learner with an ability to succeed in challenging environments and managing multiple tasks. Well versed in coordinating and communicating with multiple stakeholders across all levels.
EDUCATION
University of Illinois Springfield x Springfield, Illinois x December, 2015 Master of Information Systems, GPA 3.76
JN Technological University x Hyderabad, India x May, 2012 Bachelor of Technology, Electronics and Communication Engineering, GPA 3.60 CORE COMPENTENCIES
Data Management: SQL, T- SQL, MS Excel, MS Visio, Oracle Analytical Tools: Tableau, SAS E-Miner, Informatica, Google Analytics Project Management Tools: MS Project, MS Word, MS PowerPoint, Agile Methodology Accounting Software: QuickBooks
ACADEMIC PROJECTS
Data warehouse and Datamart Development
x Interstate Sales Group, a general merchandise distributor based in Florida, faced issues in tracking daily sales transactions and predicting future sales.
x Our team pulled entire dataset (>1 Mn entries) into Informatica from Oracle 11g and SQL Servers. x With the use of custom SQL queries, ETL was performed on the dataset in Informatica as per the business need. x Data was visualized using Tableau to answer the business questions and provide insights to the product management team. This helped in understanding the product pricing and strategizing accordingly for sales improvement. Predictive Modelling for YourCabs.com
x Yourcabas.com faced major challenge for new bookings due to unavailability of cars. x Built a predictive model using classification techniques in SAS E- Miner to minimize the number of booking cancelation for Yourcabs.com.
x Improved customer service for YourCabs.com by analyzing the data using SAS E-Miner. Database Management Project on Dillard’s Production Data x Led a team of five to redesign customer database for Dillard’s, a mid-range department store chain. x Migrated the data from SQL server to Oracle 11g platform. x Developed a “Web Based Reporting System”
x Utilized this dataset to answer decision supporting questions to assist Dillard's Production agents. EXPERIENCE
Risk Operations Analyst x Google, India x March 2013 – April 2014 x Worked on identifying and alerting on potential high-risk transactions coming through Google’s network. x Analyzed transactional data to derive insights on the evolving behavior of online fraud. x Created dashboards using Tableau to visualize modus operandi of fraud transactions and suggesting changes in transaction handling to reduce risk.
Business Analyst x Neha Marketing, India x January 2011 – February 2013 x Neha Marketing is a leading supplier of building solution in South India. x Conducted a feasibility study for deciding on manufacturing location based on proximity with consumer markets. x Coordinated with the marketing team in analyzing consumer data to improve sales outcomes by improving product- customer fit based on end use requirements. This led to increase in sales of 15% YoY from seven such clients. x Collaborated with subject matter experts to establish the technical vision to address challenging business needs.