Data Analyst Sql Server

MEGHANA MANDALAPU

DATA ANALYST

Email: *****************@*****.*** Phone: +1-612-***-**** LocaCon: United States PROFESSIONAL SUMMARY

• 3 years of total IT experience in the Analysis, Design, Modeling, Development, Implementa;on, and Tes;ng of Data Warehouse applica;ons and acquired excellent analy;cal, coordina;on, and interpersonal skills.

• Proficient in all phases of SoDware Development Life Cycle (SDLC), Waterfall, and Agile methodologies.

• Developed and implemented fresh data management processes used in call quality assurances, reducing data errors by 20%.

• Created various charts including pie charts and histograms showing performances of various teams in sales and customer service department. This increased overall customer sa;sfac;on by about 35%.

• Skill fully manages data storage and processing with measurable success, achieving a 15% improvement in repor;ng efficiency and a 20% reduc;on in data retrieval

;me.

• Ability to write and op;mize diverse SQL queries, and working knowledge of RDBMS primarily MySQL, and SQL Server.

• Skills

• Methodologies: SDLC, Agile, Waterfall

• Database: MySQL, SQL Server Other

• Languages: Python, R, SQL.

• Visualiza7on Tools: Tableau, Power BI, MicrosoD Excel

• IDEs: Visual Studio Code, PyCharm

• Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2

• Other Skills: Data Cleaning, Data Wrangling, Communica;on Skills. EXPERIENCE

Syneos Health – USA Data Analyst 06/2023 - Current

• Use SQL Server Management Studio to create complex queries u;lizing stored procedures and func;ons, as well as to create SQL tables with referen;al integrity.

• Proficiency in handling clinical data, including data collec;on, valida;on, cleansing, and integra;on from several sources, including medical claims, laboratory data, and Electronic Data Capture (EDC) systems.

• Analyze healthcare claims informa;on from government, payer, and provider sources with proficiency. further exper;se using claims data to discover billing problems, detect fraud, analyze reimbursement, and develop cost-containment plans.

• Exper;se in managing clinical data, including data collec;on, valida;on, cleaning, and integra;on from various sources such as Electronic Data Capture (EDC) systems, laboratory data, and medical claims.

• Assist with popula;on health analysis, which includes determining risk factors, paaerns, and trends among pa;ent popula;ons.

• Proficiently analyse healthcare claims data from payers, providers, or government agencies. Also experience in iden;fying billing errors, fraud detec;on, reimbursement analysis, and cost containment strategies using claims data.

• Develop manager dashboard of call center metrics and KPIs to analyze team performance using Tableau.

• U;lizing various technologies including Excel PowerPivot to query test data and customize end-user requests.

• Create a manager dashboard with call centre metrics and KPIs so that Tableau can be used to monitor team performance. Mphasis – India Data Analyst 12/2019 - 01/2022

• Lead the development of ETL pipelines using AWS Glue and Apache Spark, streamlining data integra;on and processing with cost-effec;ve solu;ons.

• Executed data valida;on, data profiling, data defects cleanup, data improvement ini;a;ves, and data quality monitoring reports.

• Implemented project using Waterfall Methodology to produce ar;facts in different phases of SoDware Development Life Cycle (SDLC).

• Worked on numerous ad-hoc data pulls for business analysis and monitoring by wri;ng SQL scripts.

• Developed spark applica;ons in Python (PySpark) on distributed environment to load huge numbers of CSV files with different schema into ORC tables.

• U;lized Power BI to create various analy;cal dashboards to help business users get quick insights into data.

• Implement data encryp;on measures with the cybersecurity team. U;lize natural language processing (NLP) techniques with spaCy for sen;ment analysis on customer feedback, enhancing marke;ng strategies.

Educa'on

Masters in informa7on systems University of Memphis, Memphis, TN. Jan 2022- May 2023 Bachelors in computer science Geetanjali College of Engineering and Technology, Hyderabad Aug 2017- Aug 2021

Contact this candidate