MEGHA PATEL
Data Analyst/QA/Reporting Analyst/Visualization
**************@*****.***
Toronto, ON
www.linkedin.com/in/meghapatel2105
C O N T A C T S UMMARY
•Experienced Quality Analyst and Data Analyst with more than 5 years in IT industry
•Extensive knowledge of Software Testing procedures, and Quality Assurance standards
•In-depth knowledge of system testing, business process, and testing life cycle
•Comprehensive knowledge of regression, functional, and system testing procedures
•Expertise in QA Methodologies like Waterfall, Agile, V model with good understanding of SDLC & STLC
•Have experience in Software testing and sound academic knowledge in programming languages, Adobe products and MS Office products
•Analytical, result-oriented multi-tasking skills with strong organizational abilities
•Experienced creating various kind of graphs such as Scatter plots, Bar, Pie, Line, Time Series, Gantt chart and CDF (Cumulative distribution frequency) charts to present data in an easily intelligible format
•Experience in creating reports, Pivot-Tables, VLOOKUP/ HLOOKUP & Macros using Excel
•Analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
•Excellent understanding of BI tools such as QlikView and Tableau
•Experience with all levels of testing including Sanity, Usability, Functional, Integration, Regression, Re-testing and User Acceptance Testing
•Ability to create, review and execute test cases based on functional requirements
•Enthusiastic team player with creative imagination and a wide array of technical skills; excellent oral and written communication skills
•Detail oriented, creative problem solver, quick learner and proven to be hard working
2
E x p e r i e n c e
•Served as the first point of contact with the Project Managers responsible for projects associated with Asian, African, Middle East, European and North American regions comprised of 49 countries
•Generated reports in QlikView used for presentations to global clients summarizing findings based on cross market correlation for specific manufacturers; raised and solved a sorting issue of the ratings depending on the sample size
•Contributed towards building an automated Presentation production for global clients filling the needs of Country Managers, fixed issues with disproportional bar diagrams, pie charts, and “bugs” with the scale of horizontal axes
•Fetched data by writing complex SQL query from various source by joining multiple tables and calculating aggregation functions.
•Assisted in working with large datasets, exporting PostgreSQL query results into excel sheet, organizing and cleansing data in a clear, concise format to be easily readable and understandable by business users.
•Leading and Mentored the team with proper tasks allocation and making sure those tasks are executed as per the predefined process schedule
•Devised a method for file data compare using MS access
•Managed a small team and carried out data migration testing activities using smart sheet (task allocation)
K E Y S K I L L S
C#/C++/HTML/CSS
Advantage Group International May 2017 – Jan 2019
Data Processing Lead
JAVA/PHP/VBA.NET
MS Office Products
SQL/MYSQL/POSTGRES
Reporting Skills
QA Testing Methods
QLIKVIEW/Tableau/QLIKSENSE
•Generated reports (Excel, PowerPoint & PDF formats) using Reporting Module by completing spec data entry for up to 100 sponsors participating in each program, conducting quality assurance on deliverables from data processing
•Checked quality ensuring accuracy of reports that are split into 2 types of products – Head Office, and Mirror – with 6 types of reports each and final Presentation, as well as fixed ‘bugs’ in new and existing reports
•Streamlined existing reports within Reporting Module, and streamlined/enhanced Excel specs; worked with Project Management team responsible for 43 participating markets internationally to develop report specifications
•Worked within the department to enhance overall capabilities, researched best practices within reporting area, and contributed to reporting protocols, internal reporting documentation, and the development of IS tools to enhance turnaround of deliverables
Advantage Group International Nov 2014 –May 2017
Technical Analyst/Test Analyst
Jira/ HP QC/Confluence
3
E x p e r i e n c e
K E Y S K I L L S
Team leadership
Strong communication
Accuracy and attention to detail
Organization and prioritization
Problem solving
Analytical thinking, Planning
PinSoftek Info Solutions, India Jan 2011 –Dec 2011 Software Tester
Quick Learner
•Served as software tester for Kount(the easiest accounting software). It is a brand of Pinsoftek specially meant for business persons to manage the account by their own. It is especially useful for small to enterprise companies, doctors, professionals and manufacturing units.
•Assisted in the development and testing of desktop applications such as Accounting Software, Check Printing and Label Printing (VB.Net and SQL)
•Manually tested functionality of all the products and maintained the release of each build.
•Participated in full Software Development Life Cycle (SDLC) of various Pinsoftek's products.
•Documentation of User Guide and Specification of products
•Assisted in the maintenance of software products and computer hardware (i.e. Installation of the products on the client’s machine and networking hardware with the system)
•Developed online reminder application in PHP and HTML
•Provided technical support of all the products to clients via phone and also on- site.
Environment: VB.Net, SQL, PHP, HTML, MS Office product
•Collaborated with QA, business & development teams to ensure that application (survey & Reports) functioned as specified.
•Performed functional, regression, integration & system testing for client/ program manager, web & mainframe applications
E d u c a t i o n
•Mohawk College, Hamilton, ON CANADA
Computer System Technician – Software Support
Includes programming languages (Java, VB.Net and C#), Web languages (PHP and JavaScript), SQL and Software Testing (Black box, Java Unit testing and Selenium).
•M. B. Patel Science College, Gujarat, India
Bachelor of Computer Application
Includes programming languages (C, C++, VB6, Java, VB.Net, HTML, CSS), Data Communication and Networking, Mathematics, Databases concepts (My SQL, SQL Server)