Data analyst

VANDANA AGARWAL

Chicago, IL Mobile: 469-***-**** Email: *****@******************.***

Around 7 years and five experience as a Data Analyst and Data Science Capable in all periods of the Software Development Lifecycle (SDLC).

Expert involvement in Data Modeling and Data Analysis as a Proficient in social event business prerequisites and taking care of necessities the board.

Experience with Statistical Analysis, Data Mining and Machine Learning Skills using R, Python and SQL.

Excellent capacity to comprehend business needs and information to create start to finish business arrangements.

Professional working experience in Machine Learning algorithms such as Linear Regression, Logistic Regression, Random Forests, Decision Trees, K-Means Clustering and Association Rules.

Experienced in structuring the Conceptual, Logical and Physical information displaying utilizing Erwin r7.3, Power Designer 12.0 and ER Studio Data displaying instruments.

Good in framework investigation, ER Dimensional Modeling, Database structure and executing RDBMS explicit highlights.

Experiences in Machine learning, data mining, structured and un-structured data analysis, and image data analysis, including feature extraction, pattern recognition, algorithm development, text mining, computer simulation, data modeling, databases design, model evaluation and deployment.

Data Driven and highly analytical with working knowledge and statistical model approaches and methodologies (Clustering, Regression analysis, Hypothesis testing, Decision trees, Machine learning), rules and ever evolving regulatory environment.

Proficient in recognizing Star Schema and SnowFlake Schema and ODS design for modeling Information stockroom in Relational, Dimensional and multidimensional model.

Strong Data Modeling background utilizing ER chart, Dimensional information demonstrating, Star Schema demonstrating, Snow-piece displaying utilizing apparatuses like Erwin, Visio.

Well versed in Forward and Reverse Engineering standards.

Experience with different RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.

Extensive involvement being developed of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business rationale execution.

Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards, Storyline on web and desktop platforms.

Develop dashboards and reports that adhere to the visualization best practices and communicate a story

Competent communicator and confident presenter to report analytics findings to members of senior management.

Assisted in requirements definition, project scoping, timeline management, and results documentation to ensure professional relationship management

Creative in putting together projections for a variety of scenarios to assist departmental experts in making future decisions regarding the organization’s growth.

Areas of Expertise

Leadership: Business Intelligence Supply Chain & Management Strategic Planning & Partnerships Budget Proposal & Management Vision, Strategy & Roadmap Team Building & Coaching Data Science & Analytics Survey Development Data Warehousing Best Practices & Standard Procedures Multi-Project Management Ad hoc & Standard Reports Data Visualization Agile Scrum Risk Management DR Plan

Technology: Python Tableau Power BI SQL RDBMS MqSQL Microsoft Office Microsoft Excel Microsoft Access Oracle JD Edwards Hubble Demand and Supply (DS) Forecasting Data Analysis Data Pre-Processing Data Management Supervised Machine Learning Unsupervised Machine Learning Business Statistics Linear Regression Logistic Regression CART Analysis Decision Tree Analysis Ensemble Techniques Random Forest Bagging Ada Boost Gradient Boost XG-Boost Model Tuning K-Fold Cross Validation Clustering K Means Clustering Hierarchical Clustering Predictive Modeling Performance Score Measurement Analysis UML Matplotlib Plotly Seaborn Exploratory Data Analysis Project Management Tools Work Break Down Structure Gantt Chart WBS ML Stacking Classification Up Sampling and Down Sampling Regularization RM plan Requirement Traceability Matrix Use Case Models Sequence Diagram Activity Diagram State Diagram Class Diagram Product Analytics

Soft Skills: Communication skills Analytical Thinking Multitasker Fast Learner Team Player Creative Bilingual (English & Hindi)

Professional Experience

Standard Textile Co., Inc., Ohio, United States 01/2022 to Present

Data Analyst

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

Express Scripts, Franklin Lakes, NJ 05/ 2019 to 12/ 2021

Data Analyst

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,

AT & T, Dallas, TX 08/ 2018 to 04/2019

Data Analyst

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

Mathematics Professor Applect Learning Systems, Meritnation.com, India 06/2015 to 06/2018

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.

Mathematics Professor Hindustan Times, Study Mate, India 03/2015 to 06/2015

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.

Mathematics Professor Edu Annex, India 09/2014 to 03/2015

Trained & taught international schools and have a batch strength of 10 students for the board and competitive examinations.

Assistant Manager Deshwal Waste Management Pvt. Ltd, India 07/2010 to 08/2014

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

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 Analytics University 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.

Bachelor of Technology, Electrical Engineering Harcourt Butler Technological Institute, India

GPA 3.77; ranked 1st out of 33 students.

Key Projects

Queen Hotels Database Management System: The purpose is to build an enterprise database model for Queen Hotels to streamline the hotel operations and performed SQL qeries to retreieve guest reservation records, payment details, etc.

Visualizing Car Insurance Claims data using Tableau: Made a Tableau Public Story and learned business intelligence via the art of problem-solving with the aid of visual analytics; Tableau’s capabilities, such as parameter action, filters, highlights, etc.

Online Shoppers Purchasing Intention: Developing a model that can effectively predict the customers’ intention to purchase a product. Discovering the essential features that can contribute to the customers’ contribution to the revenue of the website.

Insurance Premium Default Propensity: Predicting the probability that a customer will default the premium payment, the insurance company can proactively target the policyholder to follow up on the premium cost.

Costco Corporate Information Systems Management: Exploring how IT systems benefit each industry operation, its impact on business, challenges in running the enterprise information systems, discovering future directions for the organization.

Online Shopping System Development: Aiming to adopt strategies for business growth and transform the current business model into the bricks and clicks model as a Project Manager and learning PM tools & methodolgoies.

Vardhan Network Upgrade: Working as a Project Manager in this project and made strategies for streamlining and building a network upgrade infrastructure for 100 users.

Certifications

Certified in Tableau Essential Training (2020.1) from LinkedIn, issued in May 2021.

Certified in Access Essential Training (Office 365/ Microsoft) from LinkedIn, issued in April 2021.

Certified in Programming for Everybody (Getting Started with Python) from Coursera, issued in April 2021.

Achievements

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.

Extra-Curricular Activities

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.

Participated in social service for ‘Help Age India Club’ in senior high school.

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.

Honored with first position multiple times in painting, calligraphy, debates, dancing in middle school and high school.

Contact this candidate