KM
KISHAN MARVANIA
*********@*****.***
Jersey City, United States
PROFESSIONAL SUMMARY
Data Analyst Data and Business Analyst with experience in analytics and reporting tools to provide insights in product design, flows and user experience using data-driven philosophy. Seeking the opportunity to use expertise across various data modeling and visualization platforms to develop and integrate cutting-edge solutions. Mastery of analytics and reporting tools to provide insights in product design, flows and user experience using data-driven philosophy. SKILLS
• Data Analysis • Data Visualization
• Data Mining • Data Science
• Database Management • Market Research
• Project Management • Detail Oriented
• Team Builder • Python
• R • T-SQL
• SSRS • SSIS
• Tableau • Social Media Analytics
EXPERIENCE
Data Collection Specialist/Data Analyst, Gartner Inc, Jul 2019 - Apr 2020, New York City, USA
• Collection of digital insights on ecommerce websites and converting them into impactful visualizations using data mining and text mining to enhance customer experience from landing page to checkout page.
• Automated cleaning process of SPSS software in Python and implemented interactive dashboards to enhance business process transformation. Worked on libraries like NumPy, Pandas etc. to form excellent graph from the available data.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information. (Technology Used: MySQL, NoSQL, MS Excel, Python, Tableau,) IT Analyst, S.N.J Creations LLC, Aug 2018 - Mar 2019, New York City, USA
• Created data modeling standards & procedures and optimized data collection procedures and generated reports on weekly, monthly and quarterly basis.
• Applied SQL query processing and Excel for cleaning and interpreting data from various sources.
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP.
• Scripted and automated bi-weekly training reports in Python to reduce manual efforts. (Technology Used: MySQL, NoSQL, MS Excel, Tableau,)
Jr.Data/Business Analyst Intern, Krishna Builders, Dec 2016 - Jun 2018, Mumbai, India
• Refined sales and marketing data to enhance internal functionality and support services. Wrote Cron Jobs and SQL procedures to integrate data from cross-functional APIs.
• Data Storytelling using dashboards and reports for the coursework and accounts data. Extracted and identified metrics from raw data for analysis and reporting services.
• Leadership in Implementing Database Design and Normalizing the Tables and Optimized data collection procedures. Extracted, interpreted, and analyzed data to identify key metrics and transformed raw data into meaningful, actionable information. (Technology Used: MS Excel, MySQL, Python, Tableau)
EDUCATION
Master's of Engineering, Management May 2020
Stevens Institute of Technology, USA
GPA: 3.4
Bachelor's of Engineering May 2018
Thakur College of Engineering - Mumbai, INDIA
CERTIFICATIONS
Data Exploration And Visualization For Risk And Decision Making (07/2018 - 05/2020) PERSONAL PROJECTS
Social Media Analytics – Instagram (Python, Tableau)
• Perform exploratory data analysis (EDA)
• Data visualization to analyze the data set of Instagram accounts to find out the different aspects of an Instagram account.
• Using data mining and text mining to find out the most popular user accounts, most popular region where the media is used most to increase digital marketing. Accidental death due to drug overdose in Connecticut (R, Tableau)
• Estimating annual trends, standardizing the number of deaths per 100,000 Connecticut residents each year.
• Data visualization using tableau to find out the greatest number of fatalities on basis of region, sex and most abused drug type.
• Driving to conclusion that Lawmakers have passed bills in response to the crisis, among them measures to create a prescription database, to provide more training for health and public safety officials, and to provide better access to anti-overdose drugs