senior data analyst resume example with 3+ years of experience
Motivated, team, and detail-oriented data analyst with more than 3 years of experience in providing business ideas, insights, finding hidden trends, patterns, and recommendations using the data analysis process starting from extracting, analyzing raw data, cleaning, building predictive models, and dashboards creation that helps stakeholders/client in making business decisions.
|
|
- Worked on a Competitive intelligence project that compares labor rates across different repair shops for Network & Non-Network shops with our competitors.
- Used Inbound Subrogation demand data to scrap the estimate data from the demand to analyze how to improve the accuracy of our estimates.
- Worked with other analysts to identify the potential claim fraud in our claims data by analyzing the insurance premium policy changes within the last 90 days and identifying the UPD(unrelated Prior damage) issues associated with that claim.
- Wrangle and Analyze patient discharge data from the Tele-tracking and Epic database using Python, explore the data gathered from the database using quantitative methods such as developing staffing data models and built tableau dashboards to track the average response time which significantly reduced the response time by 30 percentage and improved the overall turnaround time in the hospital.
- Develop and implement tableau dashboards, reports, and KPIs to present data in meaningful ways to Clients and Stakeholders across all levels within the organization.
- Wrangle and analyze the Press Ganey survey data using Python and MS SQL.
- Using tableau dashboards , monitor the survey results and provide recommendations on low-scoring units which improved the survey score by 5% resulting in achieving the 75th peer group percentile.
- Designed overtime dashboards for Labor Data every pay period to decrease the incremental overtime using Tableau. Develop a labor model to predict the total productive dollars based on the weekday.
- Using QA tableau dashboards, provide alternate solutions and insights to identify hospital units that were struggling with audit scores.
- Developed Virtual manager tableau dashboard to track housekeeper's productivity and monitor the performance of the housekeeper.
- Work with the corporate HR managers and Stakeholders to prioritize business needs and establish KPIs to measure the effectiveness of the decisions.
- Performed statistical methodology using Python to find if there is a significant change in the survey scores before and after the staffing change in the higher priority units and guide them in making the right decisions for better hospital survey scores.
- Developed a tableau scorecard for the higher-level executive team that combines all the metrics in a single dashboard using the Tableau joins, merges.
- Coordinate with corporate HR managers in the wage analysis for all hospital associates to meet the industry standards, engage stakeholders to guide them with the appropriate recommendations for the wage level.
- Worked with Oregon's 7 public universities, 17 community colleges, workforce development, the Governor's Office, the Legislature data and helped them in providing analytical insights and recommendations using MS SQL and Python
- Collected data on students, courses, demographics, enrollments, academic performance, and academic awards using MS SQL in order to comply with state and federal reporting requirements, provides effective recommendations to state and agency policy, meets reporting responsibilities, and conducts research to better understand and manage the Postsecondary enterprise.
- Analyzed the data using MS SQL with SSMS and other statistical software as needed to write new and routine programs that extract, investigate, tabulate, synthesize, and validate processes sufficient to ensure data accuracy and generated reports using tableau for better visualization.
- Created functions in MS SQL to perform data cleaning and also worked with the Soundex and distance algorithm in MS SQL.
- Experience in using MS SQL to extract the data and visualize the findings in Tableau/Python across both community colleges and public universities to see how well they performed.
- Developed the MS SQL stored procedures, Common table expressions by eliminating data error issues with the advanced sql error handling functions in the microsoft sql server.
Base SAS Certified Programmer for SAS 9
Certificate No: BP078791v9
Student Matching Algorithm:
Worked with the IT team to develop/enhance the existing algorithm in our database to match students across different data sources like Financial data(FAFSA), ODE(Oregon Department of Education), OP(Oregon Promise), D4a(Community College data), SCARF( Public Universities data) and ORSAA(Oregon Student Aid Application)
Oregon Promise (Senate Bill 81):
In 2015, the Oregon Legislature passed Senate Bill (SB) 81, establishing the Oregon Promise grant program. The program provides a grant to eligible students that covers the average cost of tuition at Oregon community colleges. The grant is available to recent Oregon high school graduates and General Education Development (GED) test graduates who meet certain other eligibility criteria. In 2017, SB 1032 gave authority to HECC to consider expected family contribution (EFC) as needed to control program costs.
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Your data is safe with us
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.
Resume Overview
School Attended
- Eastern Kentucky University
- SASTRA University
Job Titles Held:
- Senior Data Analyst
- Data Analyst
- Research and Data Analyst
Degrees
- Master's
- Bachelor's
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy