Data Science Analysis

MEGHA TYAGI

Newyork, NY +1-315-***-**** ad8bkp@r.postjobfree.com www.linkedin.com/in/megha-a-tyagi

EDUCATION

Syracuse University, School of information studies, Syracuse, NY August 2022 - May 2024

Master of Science Information Systems & Data Science

Coursework: Information Management and Technology, Data Administration concepts and Database Management, Information Security Analysis,

Cloud Management, Data Analysis and Decision Making, Data warehouse, Financial Analytics and Data Science

Galgotias University, School of Computer Science & Engineering, Delhi, India September 2017 - May 2021

Bachelor of Science Computer Science Engineering

EXPERIENCE

Data Analyst, SU, NewYork June 2024 - Present

•Conducted web scraping for 10,000+ Tweets and Reddit posts using Python libraries like BeautifulSoup, Selenium, and PushShift API, integrated the extracted data into Salesforce to enhance customer sentiment analysis and improve engagement strategies

•Applied advanced NLP methodologies like BERT and Hugging Face's Transformers to decode user beliefs from 1M+ words of textual data, utilizing Redshift for scalable storage and analysis, enhancing customer engagement by 20%

•Applied exploratory data analysis, including statistical analysis and visualization, to identify patterns in social media data, which were then integrated into Salesforce CRM to optimize customer interaction strategies and enhance sales operations

•Leveraged Redshift for scalable data processing, analyzing over 1 million words to support large-scale data analysis

Data Research and Analyst, Mobalytics, NewYork (Remote) July 2023 - September 2023

•Analyzed player behavior data using Random Forest machine learning algorithm, leveraging NoSQL databases to identify trends that contributed to a 15% increase in user engagement.

•Applied Python and SQL for in-depth gameplay data analysis, integrating findings into the CRM to drive a 10% rise in player engagement and retention by uncovering critical player insights

•Leveraged advanced Excel techniques, including pivot tables, data modeling, and VBA macros, in tandem with SQL, to discover valuable insights for genre-specific improvements and strategic decision-making

Associate Analyst – Strategy & Operations, Accenture, Gurugram, India June 2021 - March 2022

•Integrated CRM data from Salesforce and aligned it with inventory management systems using Oracle and NoSQL databases to optimize sales forecasts and customer demands, improving overall supply chain efficiency and reducing costs by 25%.

•Designed an ETL data migration strategy utilizing SSIS for seamless integration of 400,000+ records from Excel and SAP into SQL Server, empowering logistics teams with real-time data for strategic decision-making.

•Conducted comprehensive revenue analysis using SQL and advanced Excel, leading to a 15% improvement in revenue recognition accuracy and developed financial reports and Tableau dashboards, providing actionable insights and enhancing forecasting models, resulting in a 10% increase in revenue predictability

•Integrated inventory, logistics, warehousing, and packaging data in SQL & created dashboards in Power BI visualizing inventory shrinkage, carrying costs, and turnover ratio, increasing inventory accuracy and reducing capital spent by 25%.

•Created and implemented interactive sales dashboards using Tableau, providing real-time insights into key performance sales indicators and enabling the sales team to track and monitor sales targets, resulting in a 15% increase in sales productivity

Programmer Analyst, Cognizant, Bangalore, India February 2021 - May 2021

•Analyzed and prepared customer, marketing, and web behavioral data from SA 360 and Google Analytics for data modeling, utilizing multiple datasets to uncover valuable insights such as best performing campaigns, demographics, locations, and effectively communicated findings to stakeholders

•Generated multi-dimensional dashboards, data visualization, and root cause analysis reports for campaign & website performance in tableau to showcase proposed v/s actual MoM, YoY progress, increasing ROI by 20%

•Developed an "all-encompassing digital marketing dashboard" for the client in Tableau, integrated with the SQL server database to track multiple KPIs and supported performance analytics, saving 3.5 man-hours per day

SKILLS

•Analytical Tools: Python, Microsoft Azure, R, Excel, SnowFlake, Altyrx, Scikit- learn, Google Analytics,Google Sheets,Airflow,Minitab,Microsoft Access, Snowflake(Data Warehouse)

•Visualization Tools: Tableau, Power BI, SQL Server, MySQL, Oracle

•Software Tools: Salesforce, JIRA, AWS, GCP, Jenkins, Azure Devops, Gitlab

•ETL tools and Functional Skills: Alteryx, Knime, Business Requirements Gathering, Stakeholder Analysis, Customer SWOT Analysis, Waterfall and Iterative Methodology, Agile Methodology (Scrum), Customer Satisfaction management, Data Normalization, Business Intelligence Reporting

Certification: Salesforce Admin Certification, Introduction to SAS for Data Scientist and Google Analytics

PROJECTS

3Fifteen Risk - Enterprise Risk Management Risk Analyst

•Worked with Syracuse Thrift Store 3Fifteen to pinpoint and evaluate their IT audit controls for their ERP application (SAP HANA), and further evaluated risks / gaps while testing ITGC controls

•Reviewed the IT controls setup, strategy, hierarchy, and organizational structure at 3Fifteen, comparing it to industry standards and best practices (International Organization for Standardization (ISO)

•Classified IT risks into three tiers based on severity and suggested measures to boost IT security and operational efficiency, with a goal of improving performance by 8%

Contact this candidate