AKHILA VIJAY
Denver, CO ***** C: 929-***-**** adbjrh@r.postjobfree.com www.linkedin.com/in/akhila-vijay Summary
Dedicated Data Analyst with experience in identifying efficiencies and problem areas within data streams, while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams, including Access, SQL, and Excel data sources. Bringing forth the ability to synthesize quantitative information and interact effectively with colleagues and clients. Proven track record of generating summary documents for senior management for monthly and quarterly audit and compliance reporting.
Education and Training
MS: Information Systems, Business Intelligence 2018-2019 University of Colorado Denver Denver, CO
GPA: 3.6/4.0
Bachelor of Science: Electronics and communications 2013-2017 Visvesvaraya Technological University, Bangalore India GPA: 3.5/4.0
Experience
Data Analyst Intern 05/2019 to 12/2019
Tallgrass Energy Denver, Colorado
Developed and curated executive level interactive dashboards with the help of MS Power BI, that helps in monitoring rigs, permits and daily production of oil & gas around the company assets. The report helps business users to identify and contact their potential clients, improve data accuracy from 75% to 98% and saved reporting time by 50%.
The production data was analyzed thoroughly to identify stories behind the patterns and a 5-year forecast of the production data was performed with a confidence interval of 98% to help effectively strategize the business plan for the upcoming years.
Deployed three major projects by engaging with various senior level executives and teams in an agile environment. One of the projects was shortlisted and presented at the Tallgrass Energy - IT innovation Day 2019 as a ‘Breakthrough Innovative Project’.
Utilized MS Power BI, SAP BusinessObjects, Talend Data Integration tool, MS Excel, AWS database and R scripts for data intelligence and analysis.
Data Analyst Intern 01/2017 to 12/2017
Vijay Exim Services Bangalore, Karnataka
Developed a database using IBM DB2 with advanced SQL for storing all the Client-related information, including Import/Export shipments, transaction information, services offered and billing.
Involved in Identifying, analyzing and interpreting trends or patterns in the complex import-export customer data sets acquired data from primary and secondary data sources and generate monthly reports using Tableau.
Developed Shipment document checklist and shipment schedule for Vijay EXIM Clients, this helped the organization meet tight deadlines and higher client satisfaction. Technical Specialist 08/2017 to 12/2017
IBM India Bangalore, Karnataka
Reduced escalation to technical or application resources and increased client satisfaction by effectively communicating basic troubleshooting steps to customers via phone, resolving many application issues, and OS functions such as backups, user permissions and with non-networked hardware at first contact.
Met or exceeded company metrics for call closure and customer satisfaction ratings by providing outstanding customer service and resolving issues in friendly, efficient manner. Course Work Projects
Sentimental Anlaysis using R - Time-series analysis of Donald's Trumps tweets.
Development of a Database to track the Health records of Indian citizens using Aadhaar number.
Implementation of Amazon Web Service for InnoMed - Cloud Computing.
Analysis of real estate prices based on dependent variables using statistical Modelling - EDA and Regression Accomplishments
IBM Data Science Certification IBM Database and SQL for Data Science Certification Secretary of Information Systems Association at CU Denver Business School Professional Indian Classical Dancer School Captain Soft Skills
Master of Ceremony Presentation Skills Research Attention to detail Effective Comunication Collaborative Problem Solving Flexibility/Adaptability Critical Observation Intellectual Curiosity