Data Analyst

Ayushi Kedar Boston, MA M:617-***-**** *************@*****.*** www.linkedin.com/in/ayushi-kedar/ EDUCATION

Northeastern University, Boston, MA Master of Professional Studies (Analytics) June 2019 University of Pune, India Bachelor of Engineering (Information Technology) May 2016 EXPERIENCE

Transamerica, NY, USA – Business Analyst Mar 2020 – July 2020

• Analyzed complex unstructured data, strategic support, researching, and translating business needs into technical requirements. Understood project plans and able to clearly articulate roles, project goals, and timelines.

• Proactively carried out project support/administrative functions. Assisted in the collection and consolidation of required information and data for the production and web support team.

• Gathered unstructured data (complaints data), converted them into meaningful structured data to analyze them and use them for story telling via data visualization or dashboards to communicate our findings to the non-technical department.

• Worked extensively through agile development methodology by dividing the application into iterations and working on each iteration through full SDLC.

• Used data mining techniques (regression, A/B testing) to improve decision making and pricing and for fraud detection and prevention.

Andwill, LLC, USA – Business Analyst Sept 2019 – Feb 2020

• Designed and developed automated reporting solutions to manage the business and make effective decisions.

• Extensively involved in Regression and Variance testing, executing tests and tracking defects using HP ALM.

• Acted as a liaison between the business side of an enterprise and the providers of IT services.

• Worked with BI Team on SQL queries to pull systems data for data analysis and performed Data Validation.

• Took part in QA activities by writing the Test Plan followed by Test Scenarios and Test Cases for the User Acceptance Testing UAT on JIRA.

Enigma Automations, India – Business Analyst Jan 2017 – Dec 2017

• Established online configuration knowledge base to support functionality by developing robust system application overview. QA, support, training, analytics and customer engagement management teams.

• Prepare audit reports of findings and recommendations to management. Work with Audit Managers to analyze and resolve audit issues in a timely fashion. Ensure that audit files are reviewed and stored.

• Performed data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.

• Synthesized the current BI data to do predictive analysis, time forecasting, budgeting and financial analysis optimized performance and highlighting the finding and recommending changes with understanding of key performance indicators.

• Build qualitative and quantitative model for business leaders to predict risks and understand the business to make efficient decisions.

ITHAKA, India – Data Analyst Jun 2016 - Sep 2016

• Direct data mining, data warehousing, factual and market analysis, data integrity and to develop efficient business process.

• Developed and implemented data optimization and statistical efficiency about Thailand and Indonesia on Excel, Tableau and SQL. Performed system analysis, documentation, testing, implementation and UAT.

• The model developed had an accuracy rate of 83%.

• Managed the execution of app development by being a liaison function of phases of SDLC. Interacted with other teams and clients to convert core product concept into the working application. HCL Infosystems, India – Software Developer (Data Analytics) Jan 2015 - May 2016

• Designed and tested new programs and subsequently developed the modifications using JAVA (GlassFish Server) and stored and modified them in SQL. Adjusted software parameters to boost performance and incorporate new features.

• Assisted the PM and the business team with project closure by presenting a complete progress chart with epics successfully completed, and end-user feedback followed by a lessons-learned process chart for project team review. TECHNICAL SKILLS

Programming Languages: SQL, Python, R, MATLAB, C, JavaScript(beginner) Tools/skills: Excel (Advanced), Tableau, Power BI, VB, Visio, Microsoft Dynamics 365, Jira, UAT, CRM, Data Mining & Visualization, Statistical Analysis, ML Algorithms, SDLC. Databases: MS SQL Server, NoSQL, MongoDB, MySQL

Others: AQT, MySQL Workbench, PyCharm, Jupyter Notebook, Anaconda Navigator, Eclipse Certifications: SQL, MySQL, R, Python for Data Science, Business Analyst (AMCAT) PROJECTS

General Electric (GE) Digital Guardian: Heat Alert Data Analysis April 2019 – Jun 2019

• Technologies used: R studio, Python (Jupyter Notebook), Tableau, Excel

• Data analysis to conclude the risks/alerts generated, to minimize and prevent the risks. Viacom Social Demographic Targeting (Facebook) Jan 2019 – April 2019

• Technologies used: R Studio, Python, Tableau, SQL Server

• The dataset had more than 2 billion rows and the objective were to find out how to target the audience demographically, to know gaps in the market and to know the worth of the offering made and was it worth pursuing.

Contact this candidate