Summary
Overview
Work History
Education
Skills
Certification
Academic work history
Conferences
Timeline
Generic
ADRIJA ASHRITA

ADRIJA ASHRITA

Data Analytics and Project Management
Open to Relocation

Summary

Seasoned business professional experienced in meeting needs and exceeding requirements in team environments. Communicative with task prioritization skills.

Overview

13
13
years of professional experience
2
2
years of post-secondary education
7
7
Certifications

Work History

Analyst -Assistant Director (PM)-SDFC Developer

Iowa State University
08.2020 - 06.2024
  • Create customized dashboards for ISU VDL, full-service veterinary diagnostic laboratory engaged in daily missions of service, teaching, and research, that processes 90, 000 submissions from researchers and veterinarians annually
  • Write SQL Server Queries from LIMS Database and home-grown data warehouse database
  • Develop insights for VDL financial transactions, internal business operations, client management, diagnostic processes, and key business insights.
  • Strategized to maintain and communicate analytics from multiple data sources (MySQL and CRM) to Leadership
  • Establish reporting for department or unit assessment, competitor analysis, campus level entities
  • Vendor management and budgeting.
  • Created journeys in Marketing Cloud
  • Worked for development of applications and software tied to Salesforce integrations and data exchanges to serve needs of university
  • Wrote scripts in programming languages such as APEX, PHP.

Associate Director-CRM and Analytics

Wartburg College
07.2018 - 07.2020
  • Created workflow rules, process builder, maintain data exchange between databases
  • Built Source and customer feature modelling
  • Worked with vendors to generate enrollment projections and programmatic decisions to report to Director of Admissions
  • Created and developed dashboards, queries using SQL, tracked and strategized email marketing
  • Created and maintained import/export processes from sources such as Common Application, Royall, SAT, ACT, Cappex, etc , using Informatica.

Analytics Engineer

Scientific Games
07.2016 - 05.2018
  • Extracted, cleaned, described, and aggregated query results from Redshift
  • Created Spend Reports, Month-to-Date Reports and Ad-hoc Reports using Pivot tables, VLOOKUP's
  • Determined tracking issues, campaign strategy with testing feature changes, criteria for customer retargeting
  • Identified areas of opportunity from analysis and furnish analytics to executive leadership
  • Extracted, Monitored and Reported ongoing Key Dashboard Metrics: Installs (Organic vs Paid), Cost, Revenue, Retention, FTD (First Time Deposits), ROI, CPI (Cost Per Install), LTV (Lifetime Value), ARPU (Average Revenue Per Daily Active User), DAU (Daily Active User), Engagement (sessions, actions on page, posts, in- app notifications, app to user and push), Customer Demographics.

Data and QA Summer Intern

Vertex Pharmaceuticals. Inc.
06.2015 - 08.2015
  • Authored, modified, performed dry run of the formal validation test scripts for industry data warehousing project
  • Performed backend testing using Toad for Data Point
  • Managed Test error reporting after execution of validation test scripts in JIRA
  • Created reports and dashboards for visualization and analytics for a clinical data warehousing project
  • Data cleaning by reviewing ICV (Installation, Configuration, and Verification) for complete SLC (Source to Stage and Stage to Target) using Synchronizer
  • Logged over 200 defects in the test execution tracker and determined the root cause analysis using SQL
  • Acted as a resource to plug gaps in data capture during data validation by precisely documenting in Jira
  • Created visualizations in OBIEE Reporting tool and presented to validation lead
  • Gathered exposure to Integrating data and apps using ETL for the SAAS platform project.

Business Data Analyst

Infosys Limited
07.2012 - 07.2014
  • Prepared agile based business documentation for two capital market projects
  • Modeled techniques and methods (UML) for business case development
  • Performed User acceptance testing, conducted knowledge sessions
  • Documented timeline requirements and expected results and represented stakeholders during agile based project modifications for reconciliation platform and wealth management solution
  • Prepared compact documentations on business requirements for effectively communicating with development, QA and software engineering team to ensure software solutions elevated client-side experience.

Test Engineer

Infosys Limited
08.2011 - 06.2012
  • Performed smoke, system, regression, functional and performance testing for two capital market projects
  • Created and executed software test plans and monitored software testing life cycle
  • Detected, screenshotted, and explained over 1000 bugs in production version and contributed to error-free new releases
  • Designed templates for creating and executing automated software test plans, cases, and scripts to identify and Document software bugs and their causes and to prioritize severity of bugs in TFS (Team Foundation Server)
  • Maintained healthy communication with developers for fixing and closing defects.

Education

Master's in Information Systems -

Iowa State University
United States
08.2014 - 05.2016

Skills

Data Mining

Dashboards

Project Management

Supervisory

Data Engineering - Informatica

Marketing Analytics

Salesforce CRM

Certification

TABLEAU DATA ANALYST CERTIFIED

Academic work history

  • Iowa State University, Student Data Analyst for Business Analytics, 07/2014-05/2016, Produced worksheets and dashboard type information, provided predictive analytics using Tableau visualization for Office of Student Financial Aid, Iowa State University, Performed Data understanding to detect Outliers and produce clean data set from data dictionary of 72 tables, Answered the questions to the Fin-Aid Department in form of Tableau dashboards with the available data options, Identified the historical trends and findings with different levels of drilldown across award type, student classification year, student type (graduate/undergraduate) and academic departments, with higher analytical operational efficiency for award allocations decision-making, Used Charts, pivot tables and v lookups in Business Analytics Classes for problem solving
  • Iowa State University, Teaching Assistant, Department of Physics, Department of Chemistry
  • Iowa State University, Mathematics Grader and Mathematics Helper

Conferences

  • AI Chicago 2019
  • ODSC Boston 2019
  • JAM San Diego 2019

Timeline

Analyst -Assistant Director (PM)-SDFC Developer

Iowa State University
08.2020 - 06.2024

Associate Director-CRM and Analytics

Wartburg College
07.2018 - 07.2020

Analytics Engineer

Scientific Games
07.2016 - 05.2018

Data and QA Summer Intern

Vertex Pharmaceuticals. Inc.
06.2015 - 08.2015

Master's in Information Systems -

Iowa State University
08.2014 - 05.2016

Business Data Analyst

Infosys Limited
07.2012 - 07.2014

Test Engineer

Infosys Limited
08.2011 - 06.2012

Similar Profiles

CREATE PROFILE
ADRIJA ASHRITAData Analytics and Project Management