Data Analyst
Resume:
VANDANA AGARWAL
Data Analyst
Chicago, Illinois, United States
*****************@*****.***
WORK EXPERIENCE
January 2022-Current
Data Analyst
Standard Textile Co., Inc
United States
Standard Textile Company, Inc. is a vertically integrated technology-based textile business. It develops, manufactures, and distributes multiple-use textiles, including high-end luxury terry, sheets, blankets, window treatments, upholstery fabrics, uniforms, workwear, and napery.
Roles and Responsibility:
• Monitored inventory levels, and maintained control and management systems within assigned facilities or locations in accordance with company policies and procedures.
• Maintained and analyzed actual usage versus forecast and recommend changes to enhance productivity and customer satisfaction.
• Supported customer demand using historical usage patterns, seasonality, new product introductions, and other related activities.
• Gathered requirements and insights from business heads and created business requirement documents.
• Analyzed and provided feedback on market information and communicated item availability with sales.
• Identified and recommended enhancements to supply chain systems to improve forecasting.
• Monitored orders for actual demand and issue timely updates to the planning group.
• Assisted in collecting, analyzing, and providing feedback on market intelligence.
• Provided timely and accurate unit and dollar forecasts of hospitality products.
• Maintained forecasting database.
• Proficient in statistical Modeling techniques (Linear, and Logistics) in Forecasting/Predictive Analytics, Segmentation methodologies, Regression- based models, Hypothesis testing.
• Identified and compiled common business terms for the new system that become central part of communication among project stakeholders to avoid ambiguity to determine the requirements.
• Created action plans to track identified open issues and action items related to the project
• Prepared analytical and status reports and updated the project plan as required May 2019-December 2021
Data Analyst
Express Scripts
Franklin Lakes, New Jersey, United States
CBV provides a new tool that will be built for clients to view benefit setup information that was formerly available on the ESI legacy West Anchor Green Screens. New screens will be built within the eSD application that can be accessed from the Client Website and Client eSD that will contain information our Legacy West clients used in the Legacy West Anchor. Roles and Responsibility
• Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and also took part in identifying different data sources.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Generated new data mapping documentations and redefined the proper requirements in detail.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Involved in creating charts and graphs of the data from different data sources by using Matplotlib and SciPy libraries in python.
• Performed data imputation using Scikit-learn package in Python.
• Visualizing the data with the help of box plots and scatter plots to understand the distribution of data using Tableau, Python libraries.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Conducted major stakeholder interviews involving SME's, Business Analysts and other stakeholders
• Analyze customer data in Python using Matplotlib, Seaborn to track correlations in customer behavior, define user segments to implement process and product improvements.
• Strong knowledge of statistical methods (regression, hypothesis testing, randomized experiment), data structures and data infrastructure.
Environment: PowerPoint, MS Visio, MS Excel, MySQL, T-SQL, Tableau, Python, Jeera, MS Access, August 2018-April 2019
Data Analyst
AT & T
Dallas, Texas, United States
AT&T's Hosting and Application Services deliver a range of hosting and management capabilities that provide organizations with a global, secure network infrastructure and managed hosting services. Designed to support business applications with leading technologies, high-performing facilities, comprehensive capabilities and the leading-industry customer portal, AT&T's expansive portfolio includes security, storage, intelligent content distribution, load balancing, multiple-carrier failover IP connectivity, utility computing and virtual services offerings, professional services, VPN and data networking integration and more.
Roles and Responsibility
• Converted data into insights by predicting and modeling future outcomes.
• Utilizing MS SQL, Tableau, and other dashboard tools for data intelligence and analysis.
• Collected and analyzed data on established and prospective customers, competitors, and marketing channels and sources.
• Prepared reports that interpret customer behavior, market opportunities and conditions, market results, trends, and investment level
• Solved client's analytics problems and effectively communicating results and methodologies
• Developed segmentation, propensity, and look-alike modeling of individuals across known, identified and anonymous audiences
• Used Statistical techniques for hypothesis testing to validate the data.
• Managed the planning and development of design and procedures for metric report.
• Optimized data collection and procedure to generate reports weekly, monthly and on quarterly basis.
• Used advanced MS excel to create Pivot table and Pivot reports.
• Investigate and conduct studies on the forecasts and demand, and capital of products.
• Worked with applications like R and Python to develop neural network algorithms, cluster analysis. Environment: MS Excel, SQL, MS vision, MS PowerPoint, Tableau June 2015-June 2018
Mathematics Professor
Applect Learning Systems, Meritnation.com
United States
Green Box Project: I have recorded past IIT-JEE Entrance Questions Solutions launched on social media websites and taught a batch strength of 1000 students online.
March 2015-June 2015
Mathematics Professor
Hindustan Times
United States
• Trained 30 students for competitive exams such as IIT, NTSE, and Olympiads.
• Given seminars to parents and have been awarded as BEST faculty among 15 Mathematics professors. September 2014-March 2015
Mathematics Professor
Edu Annex
India
Trained & taught international schools and have a batch strength of 10 students for the board and competitive examinations.
July 2010-August 2014
Assistant Manager
Deshwal Waste Management Pvt. Ltd
India
Prepared and submitted project reports to government officials for environmental pollution control certification; handled surveying of the items, listing out materials, contacting different organizations for the e-waste products, and then creating government proposals.
EDUCATION
-Current
Master of Science
University of Texas at Austin
Austin, Texas, United States
Master of Science, Information Systems South University, Austin, TX
• Current GPA 4.0
• Coursework: Data Management, Cognitive Computing, Decision Support Systems (Business Intelligence), Principle of Systems Development, Organizational Information Systems Security, Fundamental of Information Systems, Emerging Technologies, Project Management, Corporate Information Systems Management, IT Audit, Control & Compliance, Funcamentals of Information Systems, Informaiton Systems Capstone Post-Graduation, Data Science & Business AnalyticsUniversity of Texas at Austin, TX
• GPA 4.0; ranked 1st out of 46 students.
• Completed an intensive one-year program of study working on real-world industrial projects.
• Coursework: Python Foundations, Business Statistics, Supervised Learning - Foundations, Supervised Learning Classifications, Ensemble Techniques, Model Tuning, Unsupervised Learning, Data Visualization in Tableau.
• Information Systems
-Current
Bachelor of Technology
Harcourt Butler Technological Institute
United States
Bachelor of Technology, Electrical EngineeringHarcourt Butler Technological Institute, India
• GPA 3.77; ranked 1st out of 33 students.
• Technology, Electrical Engineering
SKILLS
Coding Meta Data Python Matplotlib System Development Systems Development Visio Data Analysis Data Mapping Database Microsoft Access MS Access Mysql Oracle SQL Tableau Software Tableau T-SQL Clustering Data Collection Data Management Data Science Data Sources Data Visualization Database Management System Load Balancing Machine Learning Power Bi Predictive Analytics Predictive Modeling Data Structures Agile Project Plan Scrum Networking Hierarchical Clustering Linear Regression Logistic Regression Random Forest Supervised Learning Data Networking VPN UML USE Case Decision Support RDBMS Systems Management JD Edwards Data Warehousing Customer Behavior Business Intelligence BI Marketing Analysis Statistical Modeling Segmentation Marketing Surveying TOPO Mapping Electrical Engineering ESD Neural Network Industrial Projects WBS Waste Management Documentation Proposals Business Requirements Forecasting Strategic Planning Logistics Inventory Supply Chain Buying/Procurement Purchasing Forecasts Collection Database Management Coaching Mentor Neural Gantt Trading Risk Management IT Audit Upholstery Painting Competitive Intelligence Market Intelligence Claims Pollution Pollution Control Best Practices Statistics Operations Fast Learner Problem-Solving Team Player BI-Lingual Bilingual Sampling Team Building Project Management Audit Budget Auto Insurance Insurance Claims Systems Security ADA Visualization Excel MS Excel Microsoft Excel Microsoft Office Microsoft Office 365 Office 365 Microsoft Powerpoint MS Powerpoint Powerpoint MS Visio CERTIFICATIONS
Certified in Programming for Everybody (Getting Started with Python) from Coursera, issued Certified in Programming for Everybody (Getting Started with Python) from Coursera, issued Certified in Access Essential Training (Office 365/ Microsoft) from LinkedIn, issued Certified in Access Essential Training (Office 365/ Microsoft) from LinkedIn, issued Certified in Tableau Essential Training (2020.1) from LinkedIn, issued in May 2021 Certified in Tableau Essential Training (2020.1) from LinkedIn, issued in May 2021 HONORS & AWARDS
Given seminars to parents and have been awarded as BEST faculty among 15 Mathematics professors Leadership: Throughout elected as 'Monitor' in school and 'Class Representative' (CR) in engineering college Conferred first prize in coding, soft skills and image recognized organized by I.E.R.T. Allahabad in 2010 Won first prize out of ten contestants in painting at the state level organized by 'Uttar Madhya Kala Kshetra Sanskritic Kendra' & 'Kala Mandir' in 2002
Participated in the foundation of a startup company mycareermychocie.com to guide and mentor college students in 2009
Honored with the highest scorer of Physics in class 10th, 12th, and B.Tech. first year at the state level in 2002, 2004 & 2007 respectively
Secured 255th rank in UPSEE (engineering entrance examination) out of 300,000 students in 2006 Qualified National Talent Search Examinations (NTSE) prelims in 2002 LANGUAGES
English - Intermediate Hindi - Intermediate
Contact this candidate