Data Analyst

Prathyusha Teeyagura

*******************@*****.*** +1-929-***-****

Technical Skills

Analytical Tools : Google Analytics, JMP, R, SAS Enterprise miner, Python

Other Tools : Tableau, PowerBI, Microsoft Office Suite, JIRA.

Programming Languages: SQL

Databases : Oracle 12C

Operating Systems : Windows

Professional Experience

LexisNexis

Client- CVS, Rite Aid, Caremark Philadelphia

Data Analyst Oct 2017 – Till date

Creating, modifying and troubleshooting SQL queries.

Ensuring data quality by writing and executing procedures for cross checking totals and identifying data anomalies using SQL queries.

Generating productivity reports by querying large datasets using SQL and creating dashboards using PowerBI.

Performing weekly database updates in Microsoft access and validating any data errors in the database.

Conducting primary validation of health care practitioner and health care organization demographics and credential information using various internal tools and search engines.

Working with management to make recommendations for improvements to work processes, internal tools and operating procedures, this contributes to improve the overall productivity of the work.

Gained hands on experience on JIRA Tool.

Weekly database updates and performing ad-hoc analysis for the request received from different pharmaceutical clients like CVS, Rite Aid, Caremark and Bayers.

Timely and accurate updating of data into the appropriate data format and accurate uploading of data into master data file.

Preparing and assisting in documenting the quarterly and half-yearly productivity reports.

Tools and technologies: Microsoft Access, Oracle, SQL, PowerBI, JIRA

FCB Health

Client- Jamaica Tourist Board, Xiaflex New York

Data Analyst Jul 2017 – Sep 2017

Worked in marketing, advertising healthcare analytics field. My responsibilities include extract and analyze intelligence reports using data imported from google analytics to provide insights about our client’s website performance and KPI.

Analyzed complex business problems and issues using data from internal and external sources to provide insight to decision-makers.

Performed sentiment analysis and applied Natural language processing technique to identify the seed keywords for optimizing the healthcare websites to guide the paid search buys using different packages in R (tm, tidytext,tidyr) and ggplot, devtools, sqldf, dplyr, RColorBrewer for data visualization in R.

Summarizing and publishing EHR quarterly and half yearly summery reports for healthcare provider clients.

Experience with extracting data from different social listening platforms like Crimson hexagon, Sermo and Pubmed and

Extensively used excel (Vlookup, SUMIF, COUNTIF and other xlF functions for data analysis.

Track open rate, click through rate of all business partners, and help them in improving their advertising campaigns.

Generated acquisition reports using google analytics and tableau, which helped the clients to know more about the website traffic and behavior of the visitors.

Tools and technologies: Tableau, Google Analytics, R programming, SQL

POOJA MULTISPECIALITY HOSPITALS India

Clinical Data Analyst Dec 2014 – Dec 2015

Worked with Clinical data management team in collecting data and ensured that collected information through clinical trials is relevant and error free.

Interpret campaign survey data, analyzed results using statistical techniques and created dashboards using Microsoft excel, which provide insights about KPI.

Experience with extracting data from different sources like online survey and patient surveys using Microsoft access.

Extensive working experience with collecting, analyzing electronic health records.

Generated reports on EHR which provided an overview about out patient and inpatient flow.

Generated demographic analytic reports using Microsoft excel which helped the organization in planning the upcoming blood donation campaigns.

Assisted the clinical data management team in recognizing the KPI for improving the patient experience.

Worked along with clinicians in recognizing the efficient diagnosis and treatment plans.

Facilitated and lead cross-functional team meetings, offering guidance and solutions to marketing teams.

Proficiency with Microsoft Office Suite.

Tools and technologies: Microsoft Access, Microsoft Excel.

CHRISTIAN FELLOWSHIP HEALTH CENTRE India

Clinical Data Analyst Nov 2013 – Nov 2014

Worked with Clinical data management team in collecting data and ensured that collected information through clinical trials is relevant and error free.

Assisted in collecting electronic health records.

Merged multiple excel sheets into a single sheet used to generate overall summery reports.

Performed adhoc analysis using Vlookup and other excel functions.

Interpret patients’ survey data, analyzed results using statistical techniques and created dashboards, which provide insights about KPI.

Experience working with electronic medical records data and patient records using Microsoft access and Oracle.

Coordinate with financial and marketing team in creation and execution of new strategic planning and decision making for conducting free health checkup campaigns.

Extensively used excel (Vlookup, SUMIF, COUNTIF and other xlF functions for data analysis.

Tools and technologies: Microsoft Access, Microsoft Office suite.

Projects

Blood donation Prediction Model

Developed a predictive model to predict the probability of blood donations using Multiple linear regression and Neural network models. Strong hands-on experience in Regression, Predictive models, factor analysis and cluster analysis.

University Student Enrollment

Built a predictive model using our University’s student enrollment data to predict the possible institutional aid that can be offered to a student.

Tools: SAS Enterprise Miner, JMP.

Google Analytics

Enhanced the conversion rate of perfectme.com website and improved site performance by reducing bounce rate, increasing page views. Good knowledge on concepts like SEO optimization, multivariate testing using Google Analytics and Tableau.

Critical Performance Management

Generated Operational, Strategic and Analytical dashboards from data related to an online android app to track key performance metrics to evaluate the company’s success rate to reach their targets and to help those making better business decisions using Tableau and Microsoft excel.

Data Warehouse

Designed a data warehouse with star and snowflake schema models using Dental insurance dataset. Implemented 3N normalization technique, data cleansing, data staging and generated reports using SQL on Oracle 12C platform.

Certifications

Introduction to R Programming Training from Data Camp (License 3,469,766)

Strong practical knowledge of vectors, matrices, data frames, aesthetics, geometrics, coordinates, facets, layers, and data visualization using GGPlot, Boxplot, Barplot. Implemented statistical analysis using T-test, ANOVA and Regression.

Introduction to SQL for Data Science from DataCamp (License 5,051,613)

Fundamentals of Visualization with Tableau from Coursera (License EPWPRAQ3WBJC)

Tableau 10 Advanced Training: Master Tableau in Data Science from Udemy (License UC-WO67WIV9)

Strong practical knowledge of importing data from different data sources, data blending techniques and, implementing functions like calculations and using parameters to build an interactive dashboard, trend analysis and statistical analysis.

Education

Saint Joseph’s University, Philadelphia May 2017

Master of Science in Business Intelligence and Analytics at Erivan K. Haub School of Business.

Coursework: Business Intelligence, Business Analytics, Web Analytics, Data Mining, Database Management (SQL), Enterprise Data, Predictive Analytics, and Critical Performance Management.

Panineeya Mahavidyalaya Institute of Dental Sciences, NTR University, Hyderabad, India May 2014

Bachelor of Dental Surgery

Contact this candidate