Database Analyst, CHD Expert July **** – Present
• Design and create new and existing relational databases using tools: MS Office, Alteryx, MySQL Workbench, Omikron.
• Collaborate with Database Administrator to build automated processes in Alteryx for monthly database updates saving the team 3 days a month.
• Responsible for building ad-hoc and monthly reports for over 20 clients.
• Effectively consult with sales team and clients to translate data requirements into clearly defined technical requirements hence, promoting sales.
• Drive offshore quality assurance team consisting of 4 people to execute test cases based on business requirements.
• Responsible for weekly KPI measurement for the team maintaining overall data quality at 91.4 % for the year of 2020. Data Analyst, Integra Technologies March 2018 – July 2018
• Design reports using SQL Server Reporting Services (SSRS) and identify the database tables for defining the queries and datasets for report generation
• Write complex SQL queries used by SSRS Reports
• Gather business requirements and translate them into technical specifications
• Create data quality audit reports to assist performance team with daily workflow IT Analyst, Pacella Trucking Express April 2018 – July 2018
• Create infographics and graphs using MS Excel to present company data.
• Update TruckMate, the enterprise management software to the latest version and train 15 truck drivers to use it efficiently.
• Install and Implement The Dawg, an automation tool to create tasks to flag exceptions with billing or operations, run routine tasks etc.
Data Analyst Intern, Kairosteq May 2017 – March 2018
• Work closely with the data team when issues found during QA
• Assist users with reporting and analysis activities and ad hoc reporting.
• Responsible for Quality Control checks on changes made to an existing data set prior to release POOJA VERMA
Database Analyst
*****.******@*****.*** linkedin.com/in/pooja-verma-89b366156 312-***-**** Chicago, Illinois
EXPERIENCE
EDUCATION
Bachelors of Science Computer Information System DeVry University Chicago, Illinois
• Concentration: Database Management