Kinjal Parmar
Contact (M): 510-***-****
Email: ****************@*****.***
Career Objective:
Proactive Data Analyst with 6 years of experience, desires to make a sound position with growing company that promotes collaboration skills and environment of growth to achieve personal as well as organization goals.
Highlights:
Testing Tools
Quality Center (QC-ALM), JIRA, Log-tag Analyzer
Business / Modeling Tools
Microsoft Project/Visio/ Excel/Word/PowerPoint, Tableau
Database
MS SQL Server, My-SQL Server
SDLC Methodologies
Agile Scrum, Waterfall
Operating Systems
Windows, OS X, UNIX/LINUX
Programming Languages
C and C++, Assembly languages, Object Oriented Programming
Internet Technologies
HTML, XML, Web Services (SOAP and REST)
Professional Experience:
Operations Data Analyst -- Mountain View, CA September 2015 to Present
Google (Adecco)
Accurately executed primary daily tasks that include but are not limited to, document planning and accurate and precise data reporting
Made data driven recommendations by data visualization and creating reports in Tableau
Designed and updated database with MySQL
Developed content and generated reports using Tableau
Converted quantitative data to qualitative data and enhanced the product quality for validation
Performed database testing as needed to ensure that customers receive prompt and efficient service
Performed A/B testing on GSX website to make it user friendly and to increase customer flow
Extracted, compiled and formatted data in EXCEL (V-lookup, Pivot Tables)
Wrote SQL queries to extract data from database and modified it according to business needs
Converted data into graphical representation using data visualization tool
Performed black box testing, performance testing, stress testing and unit testing on day to day basis to collect more data points
Adhere to and assist in the implementation of Standard Operating Process in Agile environment
Participated in daily, weekly, and quarterly KPI collection, review, and publishing
Managed SLA performance through metrics to meet project deadlines
Provided training and product demonstrations to business users, executives, and customers
Configured various workflows for filing bug in defect tracking tool Jira and validated product quality
Actively participated in team meetings to discuss current process and resolve issues with local and off shore teams
Documented various data quality mapping documents
Excellent interpersonal and organizational skills to interface with internal customers, management and outside vendors
Technical abilities and troubleshooting skills with track record of removing project roadblocks
Data Analyst April 2015 to September 2015
Canvas InfoTech – Fremont, CA
Experience in understanding & supporting both the Business & Technical teams in all phases of Software Development Life Cycle (SDLC) by using different methodologies like Waterfall and Agile-Scrum
Analyzed large data sets to provide strategic directions to the company
Interpreted complex simulation data using statistical methods and Tableau
Conducted database testing using SQL queries on MS SQL and My-SQL server
Performed data analysis and data profiling using complex SQL on various sources systems
Created SQL scripts to find data quality issues and data validation issues
Created data trace map and data quality mapping documents (RTM)
Performed Smoke testing, Sanity testing, Unit testing, Regression testing and integration testing
Coordinated business users, database administrator and testing team for production testing
Gathered and elicited data for software, hardware and administrative teams
Managed and collaborated with data operations team and developers to meet business user needs
Reported found issues in bug tracking tool JIRA and Quality Center (QC-ALM)
Teaching Assistant September 2014 to April 2015
Northwestern Polytechnic University – Fremont, CA
Worked on student portal application for making it user-friendly and better accessible
Assisted and worked with a team of seven members including business and technical team
Actively involved in gathering requirements and creating Business Requirement Document
Involved with analysts to effectively access data and optimize dashboards
Analyzed and created dimensional data modelling to meet OLAP needs
Managed reports and generated test cases and traced them to requirements in HP-ALM tool
Evaluated new applications for organizing job fairs, academic activities and cultural events
Assisted professor in supervision of Masters’ class having 60 students
Test Data Analyst December 2012 to November 2013
Electronics Systems – Gujarat, India
Involved in documenting and developing test data using Tableau
Expertise in bug reporting, bug tracking using various bug tracking tools
Developed and executed data sets and created data reports using SQL queries
Created, executed, and updated Functional, Regression, Integration, and Unit test cases manually
Developed manual test cases for positive, negative tests and document the results
Involved in planning & performance testing, verification & validation, and quality assurance of the application
Implemented data quality and production changes to manual reports
Ensured quality levels are maintained in all phases of testing
Regularly interacted with the development team to communicate issues and simulate the defects
Responsible to provide up-to-date training and knowledge transfer to the new team member
Wrote SQL queries to extract data from MySQL to validate back-end data
Coordinated with developers and record defects in QC to track until they are resolved
Followed scrum methodology to meet company requirements
Prepared test data for functionality testing
Used Quality Center for requirement analysis, scheduling and generating test cases
Defects were tracked, reviewed, analyzed and compared using Quality Center
Generated reports and documented and communicated test data on daily bases
Coordinated with developers and system engineers to fix application defects
Attended test status meetings and test review meetings and defect triage meetings
Network Testing Intern December 2011 to November 2012
Reliance Communications Pvt Ltd– Gujarat, India
Studied fundamentals about different sections of Network Infrastructure and their Performances
Reviewed and performed functionalities of each departments like Switch, Data and Router
Performed on-site testing to get practical knowledge about connections of each department
Involved in generating RTM-Requirements Traceability Matrix to trace the requirements to test cases
Developed detailed test plans and test cases and responsible for executing them
Attended walkthroughs and review meetings with business analysts & development team
Educational Background:
Masters of Science in Electrical Engineering, Fremont, CA 2015
Cumulative GPA: 3.8