Post Job Free

Resume

Sign in

Data Analyst Project

Location:
Cincinnati, OH
Posted:
April 06, 2020

Contact this candidate

Resume:

Radhika Sood

513-***-**** adcol7@r.postjobfree.com https://github.com/soodrk

Cincinnati, Ohio https://www.linkedin.com/in/radhika-sood/ EDUCATION

University of Cincinnati, Carl H. Lindner College of Business Cincinnati, OH Master of Science in Information System and Business Administration GPA 3.497 Available: April 2020 Data Analytics certificate

Panjab University, University Institute of Engineering and Technology Hoshiarpur, Punjab Bachelor of Engineering (Computer Science Engineering and Technology) GPA: 3.72 June 2014 TECHNICAL SKILLS

Analytical Skills: R, Python, SAS, Salesforce Apex, Visual Basic, C++, MySQL, Hadoop, AWS, MySQL, IBM DB2 Statistical Skills: Linear/ Logistic regression, Classification, Decision Trees, Clustering, Hypothesis Testing ERP/ Tools/ Web Technologies: Tableau, PowerBI, Salesforce, SAP, Peoplesoft, SSDT, HTML, CSS, JavaScript, XML Other Skills: VBA, Excel Macros, Decision Modeling, Financial Modeling, Project Management, Functional Testing Certification: Six Sigma Yellow Belt, IBM DB2 9 Database and Application Fundamentals, IBM Rapid Application Developer EXPERIENCE

Howden Americas, Fairfield, OH

Project Management Intern June 2019 – September 2019

• Automated company’s project management templates using Visual Basic and created interactive dashboards to get data insights ManageMySales, Accenture Solutions Pvt. Ltd, Gurugram, India Application Development Analyst September 2015 – July 2018

• Analyzed requirements, developed codes using Salesforce Apex, performed unit testing resulting in new functionality

• Automated cleanup of old transactional data; reduced manual effort by 90%, increased efficiency by 50%, saved $.1million

• Performed exploratory and predictive data analysis to create interactive views of the data using Tableau to analyze sales trend

• Developed batch and scheduled classes, to improve the success rate of the project by 40%

• Certified in Lean Six Sigma Yellow Belt and expert in implementing continuous improvements to the organization through the projects

• Created controllers, visualforce page and triggers as part of user stories

• Supervised and trained a team of 5 resources; to ensure high quality deliverables and maximizing resource utilization Fi$Cal, Accenture Solutions Pvt. Ltd, Mumbai, India Application Development Associate October 2014 – August 2015

• Cleaned, organized, validated and documented large data files (25,000 to 5.8 million records) to get insights from data

• Created various charts and interactive dashboards in Tableau to track and maximize resource utilization in the department

• Created automated training materials using UPK toolkit; reduced the training time by 80% and training cost by 50%

• Build SQL scripts, indexes and complex queries to get insights about the average spending and revenues

• Created triggers, views and SQL query optimization for faster retrieval, manipulation and validation of data

• Presented knowledge sharing sessions to different project teams, resulting in increased cross functional team integrations Span Infotech, Mohali, India

Data Analyst July 2014 – September 2014

• Customer identification model: Used APIs to fetch the data from websites and understand the customer’s buying trends. Using the data, the team worked on creating clustering algorithms to predict the target audience for the company and pricing for the products using python libraries: pandas, numpy, sklearn, etc

• Document Approval process: Created SpanDocs software using MVC framework to automate the document review with acceptance and denial process, which would otherwise have to be performed manually. This helped increase the productivity of the whole project by 40% saving the company $3 mn QuarkXPress Publishing R&D India Private Limited, Mohali, India Quality Assurance Intern February 2014 – June 2014

• Ensured quality in the project work by performing white box and black box testing and logged defects for the issues reported

• Created “Platform Client Test Harness” software using asp.net that automatically runs the test scripts, mails the generated test results to research and development, build, testing teams of the project ACADEMIC PROJECTS

• Next Dengue Epidemic prediction: Created model using knn clustering, extreme gradient boosting and random forests to predict the occurrence of dengue fever epidemic with MSE of 25.42 and accuracy of 91%

• Reduce landing overrun risk: Created multilinear regression model to predict the factors affecting landing distance using SAS

• Occurrence of diabetes: Created logistic regression model to predict the likelihood of diabetes using R with 88% accuracy

• Study abroad program (Shanghai, China): Worked on a project with Mondelez International and proposed a business plan to increase the market share of Chip Ahoy in Chinese market using brand marketing, innovation, and packaging strategy ACHIEVEMENTS

MSIS class ambassador, Executive Leadership Council Member of Graduate Association of Women in Leadership



Contact this candidate