Microsoft SQL, Power BI, MS Excel, Redmine, BUGZILLA, JIRA, Quality Centre and QTP
Priya Jaglan
Data Analyst
Cartersville,GA
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven ability to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Data engineering and analysis.
Overview
1
1
Language
2
2
Certifications
4
4
years of post-secondary education
4
4
years of professional experience
Work History
Data Analyst
Chandra Carpets
, GA, USA
04.2018 - 10.2019
- Developing, keeping up and executing SQL contents/questions and approved culmination, trustworthiness, and precision of information and contributed in company's overall sales increase by 12% in fiscal year.
- Create interactive dashboards and reports for 3 different teams within organization.
- Developed database objects, including tables, views and materialized views using SQL.
- Cleaning and transforming massive data into useful and insightful to specific teams.
- Experience in maintain invoices records for payments and filing for future data references.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Researched and resolved issues regarding integrity of data flow into databases.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Compiled, evaluated and reviewed engineered data for internal system.
Data Analyst
Pathway Logistics
, USA
01.2017 - 03.2018
- Analyzed real time rate quotes and helped stakeholders to negotiate for optimum deals.
- Generated daily reports of booked loads at DAT platform with dispatching team or direct brokers.
- Maintained drivers records and dispatching schedules.
- Built daily route info for drivers in coordination with dispatch team.
- Maintained loads pricing info and resolving driver’s everyday dispatch activities.
- Payment processing and follow-ups with broker companies and handling master data along with paperwork.
Quality Tester (Intern)
EntranceZone e-Media Software Solutions Pvt. Ltd
09.2015 - 06.2016
- Evaluated data sets from multiple test implementations to determine and account for standard variance in test results.
- Analyzed and tested different builds to identify, trace and help resolve bugs; Bugs reporting in Project Management Tools like Jira.
- Kept scripts and test cases updated with current requirements.
- Tailored testing procedures to obtain data most relevant to understanding underlying causes of production limitations.
- Designed and developed reports using SQL.
- Input test results to relational database management software for use in metadata compilation and study and consultation in future test design.
- Conducted in-the-line testing and evaluated resulting measurements to identify variances in output using current production methods and compare against application-specific tolerances.
- Developed and maintained defect databases for known issues.
Quality Tester (Intern)
Delaine Technologies Pvt. Ltd
03.2015 - 08.2015
- Produced detailed specifications and writing test plans to conduct product testing in controlled, real situations before going live.
- Reviewed current systems and presented ideas for system improvements, including cost proposals.
- Kept scripts and test cases updated with current requirements.
- Collaborated with other developers to identify and alleviate number of bugs and errors in software.
Quality Assurance Trainee
Mobilous Pvt. Ltd
11.2014 - 01.2015
- Underwent Six-weeks training program on 'AppExe' product; A data management system to bring real-time interaction with business audience using web & mobile apps.
- Planned and devised cohesive test plans for projects using advanced testing technologies.
- Completed deviation forms and recorded findings of inspection process, collaborating with quality team members and department managers to implement procedural remedies.
Education
Bachelor of Technology - Computer Science & Engineering
Kurukshetra University of Science & Technology
India 01.2010 - 01.2014
Skills
Data Analysis & Reporting
Accomplishments
- Contributed on a college digital information management system which helped to reduce the paperwork by 40%.
- Improved existing databases to reduce processing time and achieved data integrity.
Additional Information
Leadership & Extra-Curricular Activities
o Active Core Member of Symbolic (The Computer Society) during graduation.
o Anchor in ESFUERZO (College Fest) 2012 as well as ATHLETE MEET 2011, 2012 and 2013
o Student coordinator for 4 years at College Fest
Software
Certification
[SQL] Training - [August - November 2015 ]
Interests
Data Science , Reporting , Data Analysis , QA , Testing
Timeline
Data Analyst
Chandra Carpets
04.2018 - 10.2019
Data Analyst
Pathway Logistics
01.2017 - 03.2018
Quality Tester (Intern)
EntranceZone e-Media Software Solutions Pvt. Ltd
09.2015 - 06.2016
Quality Tester (Intern)
Delaine Technologies Pvt. Ltd
03.2015 - 08.2015
Quality Assurance Trainee
Mobilous Pvt. Ltd
11.2014 - 01.2015
Bachelor of Technology - Computer Science & Engineering
Kurukshetra University of Science & Technology
01.2010 - 01.2014
Similar Profiles
Budi PriadyBudi Priady
Internal Audit Manager at PT Sekawan Chandra Persada ("CHANDRA" Retail Chainstore)Internal Audit Manager at PT Sekawan Chandra Persada ("CHANDRA" Retail Chainstore)
Durgesh ChandraDurgesh Chandra
Warehouse Assistant at Chandra Ware House Pvt. Ltd.Warehouse Assistant at Chandra Ware House Pvt. Ltd.
Chet Anderson SanasithChet Anderson Sanasith
Tax Preparer at Chandra Tax Consulting LLCTax Preparer at Chandra Tax Consulting LLC