Data Quality Assurance

ANUBHA ADWANI

E-mail: *******@****.*** **** Bonita Lane, apt#424, Charlotte(N.C.),28262

Mobile: 704-***-**** LinkedIn: www.linkedin.com/in/anubhaad27 OBJECTIVE

Seeking full time opportunities in the field of Data Analytics/Business Intelligence/Data Science/Data warehousing starting Dec’17.

EDUCATION

University of North Carolina, Charlotte, NC Expected Graduation date: December 2017 Master of Science in Information Technology-Data Science Current GPA: 3.833

Bansal Institute of Science and Technology, MP, India Graduation date: June 2010 Bachelor of Science in Computer Science Engineering GPA: 4.0

COMPUTER SKILLS

• Operating Systems: Windows/98/XP/Vista/10, iOS

• Programming language : R, Python, JAVA, HTML, CSS, SQL

• Tools: R Console, R Studio, Weka, Tableau, Jupyter notebook, MS Office, Quality Centre, HP ALM, QTP, NetBeans, Tomcat web server, MySQL, MS Access, Data watch Monarch

• Ongoing Learnings: SAS, Cassandra, Spark, Amazon AWS cloud, Google cloud, MapReduce WORK EXPERIENCE

• Worked as a Quality Assurance Engineer at Capgemini (Mar 2011-Nov 2014)

• Job duties included:

• Establish and maintain procedures for product testing

• Write test scripts or other test software to automate tests when appropriate

• Record defects observed in an error database

• Understanding of the SDLC process and Agile methodologies.

• Projects Summary:

Progressive Auto Insurance-

This is a US Based Auto Insurance Service provider company that has over 13 million policies in force.

Being a client of Capgemini I have Worked as a key member of the Quality Initiative team. Worked in requirement gathering phase to get complete requirements for each blocks. Wrote and reviewed test strategy documents.

Wrote test cases and test scripts.

Active member of the system and regression test execution. Logged defects and did ad hoc testing to make the application bug free. HSBC-

Worked as a quality assurance tester for Integrated Insurance Platform project for HSBC as a contractor.

The project was based on agile methodology, each sprint lasts for 3-4 weeks. Completed around 30 story points in each sprint.

Used RTC agile environment platform to collaborate within the teams. CURRICULUM PROJECTS

Hospital Readmission Analysis (R, Tableau, Weka) UNCC Spring 2017

• Analyzed a 10k tuple dataset to help a hospital find the key factors to reduce hospital readmissions.

• Included data cleaning, statistical analysis, regression, classification, pattern mining, feature extraction, clustering to accomplish the goals using R Console, R Studio, Tableau UNCC Undergraduate Admissions Data (R, Python, Tableau, Weka) UNCC Summer II 2017

• Analysis of real time undergraduate data of past 5 year to increase the admission rates.

• Data cleaning and data preparation was done using R.

• Data modeling to apply SVM, Random forest and regression algorithms were done using python.

• Data visualization to gain knowledge about trends was done using Tableau. School Extra Curricular Database Design (SQL Workbench, MySQL) UNCC Summer I 2017

• Designed school extracurricular database from scratch using MySQL.

• Prepared EER and data flow diagrams.

• Found out relationships between the entities.

• Wrote queries for creating tables, inserting data, stored procedures, triggers, views, indexes. Online Food Ordering Website (NetBeans, MySQL, Tomcat) UNCC Spring 2017

• UI interface was developed using HTML and CSS and included around 12-15 JSP pages.

• Project was based on MVC model using MySQL as back end.

• Included SQL injection, prepared statements and normalized form of tables. Chat bot for medicinal info UNCC Fall 2017

• Implementing using api.ai to search for the information about various medicines related to a specific disease.

• Consist of a dictionary that will have all the information stored in the form of tables which is implemented using Cassandra.

• Merge several pharmacy and clinical databases to form a data warehouse MapReduce for Movie Recommendation UNCC Fall 2017

• Code for mapper and reducer was coded using Python

• Using Amazon Elastic Map Reduce to run the program using S3 storage to get the output for the movie to be recommended based on user’s rating.

COURSEWORK

• Knowledge Discovery in Databases, Database Systems, Business Intelligence and Analytics, Machine Learning, Cloud Data Storage, Data Warehousing, Human Computer Interaction, Software System Design and Implementation, Operating Systems. AWARDS AND RECOGNITION

• Received Rising Star award while working for Progressive Auto Insurance.

• Received 21st rank in National Mathematics Olympiad

• Active member of intercollege cultural events

References available upon request

Contact this candidate