Nisha Gorasia

Sr. Data Analyst

SUMMARY OF QUALITIFACTIONS

• Knowledgeable, analytical, dedicated, and enthusiastic data analysis and data science professional with data retrieval, sampling, analysis, visualization, and presentation skills.

• Proficient in statistics, data analytics, and machine learning using SQL, ETL/SSIS, DQS, EXCEL, and R with some knowledge of Python relevant to ML. Quick learner of new methods and technologies. CONTACT

203-***-****

ad2j7v@r.postjobfree.com

Cary, NC, 27519.

http://linkedin.com/in/nishago

rasia

EDUCATION SKILLS CERTIFICATION

• NC Teach Program – N.C

State University 2014

• M.S. - Nirma University,

India 2011

• B.S. - Sardar Patel

University, India 2009

Data Analysis, MS Excel, Data Profiling, MS SQL

Profiler, Cleansing, ETL, SSIS, Business Intelligence, Analytics, Reporting, Visualization, Power BI,

Tableau, Database Development, Data Retrieval,

Export/Import, MS Access, MS SQL Server, SQL, T-

SQL, Statistical Analysis Plans (SAP), Statistics, Probability, Machine Learning, Data mining,

Predictive and Prescriptive modeling, Sampling,

Simulation and Hypothesis testing, Classification

and Regression, Linear Regression, Logistic

Regression, Decision Trees, Random Forest, K-

means Clustering, Neural Networks, parameter

tuning, Bayesian Modeling and Time series

Forecasting, R, Python, Azure ML

• Structural Bioinformatics Basics

(MOOC) 2019

• Genetics and Next Generation

Sequencing (MOOC) 2019

• Microsoft Professional Program

(MPP) Certificate in Data Science

2017

• Statistical Thinking for Data

Science and Analytics – Columbia

University (MOOC) 2016

•Certificate in Biostatistics for Big

Data Applications – University of

Texas (MOOC) 2017

•Microsoft Certified Professional

(MCP) in Querying Microsoft SQL

Server 2014 2015

•Microsoft Certified Professional

(MCP) in Administering Microsoft

SQL Server 2014

1.

PROFESSIONAL EXPERIENCE

March 2020 – Nov 2023 Sr. Associate BI Analyst / McKesson / Cary, NC

• Participates in large, complex, or cross functional projects, manages the Market and Business Intelligence team’s role in concert with other internal and external stakeholders.

• Develops SQL scripts and store procedures to create various SSRS and ad-hoc reports that reflect the performance of internal, pharmacy operations and track external ongoing (patient,payor,prescriber data, etc.)

• Leverages Tableau for data visualizations essential to improving workflows and identifying bottlenecks.

• Creates and manages Tableau project plans to ensure that dashboards meet due dates.

• Acts as point of person for teammates whenever assistance was need for client inquired or day to day tasks.

• Utilizes SQL to create reports and dashboards that prompted business processes to change and adapt as new challenges.

• Reviews datasets and files before delivery to client to ensure data accuracy and quality (QC/QA) as well as corrects and restates data where necessary to ensure that data aggregator/clients received accurate data using advanced excel and Power BI.

• Collaborates and trains less skilled teammates on technical or operational issues, to deliver quality work on time.

• Engages with client on highly complex or escalated requests.

• Spearheaded initiatives to automate reporting for external clients so that internal, manual work was limited.

• Creates documentation for departmental processes.

• Driven innovation by searching for and evaluating new tools, processes, and ways of thinking about data. Current Work Authorization: GC EAD

Sep.2018 – Oct.2019 SQL Developer / LMG holdings/Morrisville, NC

• Possess an ability to think strategically, analytically, and proactively about diverse business problems.

• Worked with SVN subversion systems like GitHub, used red gate, SQL Query tool.

• Experienced with Pivoting and Un-Pivoting data within stored procedures.

• Created Data Tables, Analysis Grid, Charts and Dashboards using Logi Analytics Tool.

• Created and modified tables, views, stored procedures, and functions

• Developed stored procedures and used dynamic SQL.

• Used indexes, common table expressions, temp tables to optimize large SQL queries.

• Created various ad hoc queries as per the need of work requirement.

• Familiar using Gemini software tool (like JIRA) and Scrum Methodology.

• Used R and SQL to manipulate data and develop and validate quantitative models.

• Adopted the best performing model based on Parameter Tuning and Stratified K-Fold Cross- Validation

• Performed statistical data analysis using Python and R

• Created various types of data visualizations using R and Tableau

• Experienced using Python libraries such as NumPy, SciPy, pandas, scikit-learn, matplotlib, TensorFlow, NLTK

• Experienced using Microsoft Office, especially Excel – Power Pivot, DAX, V-lookup.

• Managed end to end analytical projects - to conduct analysis, research customer and industry reports to recommend new strategies and then to lead the initiative and monitor its impact.

• Proficiently used analytical tools and languages supporting data analysis, reporting, and visualization - Excel, Microsoft Office, Power BI (Docs, Sheets, Slides), Tableau, R, Python

• Exceptional communicator across all levels of the organization; able to effectively tell stories with data and present findings to a non-technical audience.

Nov.2019 – Feb.2020 Data Analyst/Advance Social Innovation/Freelance

**MPP for Data Science Capstone Project 2017

• Launched three Machine Learning models, based on real scenario of “Student Loan Repayment” in U.S.

• Analyzed observations, each containing specific characteristics of student loan and its repayment.

• Explored the data by calculating summary, descriptive statistics and by creating visualizations of the data.

• Predicted the percent of students that are actively repaying their loans within three years of graduating for each institution using information about the degrees the school offers, the financial makeup of the student population, the academic merits of the school, the graduation rates, and additional demographic information.

• Remodeled the project by reducing the RMSE (Root Mean Square Error) with the help of machine learning algorithms like boosted decision tree, random forest, K-means clustering)

• Reviewed that the repayment rate of student loan can be confidently predicted from its characteristics.

Contact this candidate