Vighnesh Resume
Vighnesh Rajesh Pathare
Data Analyst | (469 ) 305 -9650 | ------------ | ------------/in/vighneshpathare
EDUCATION
University of Texas at Dallas, Richardson, TX May 2020
M.S., Management In formation Systems
Mumbai University, Mumbai, MH, I ndia June 2016
Master of Computer Applications
Mumbai University, Mumbai, MH, I ndia Nov . 2013
B.Sc., Information Technology
TECHNICAL SKILLS AND COMPETENCIES
Programming: Python ( Pandas, NumPy , Matplotlib, scikit -lea rn), SQL(MySQL, SQL Server, Oracle), SAS , PL/SQL , R,
JavaScript (typescript ), DAX , Git
Analytical Techniques: PowerBI, Tableau, Regression Techniques, Decision Trees, Clustering
Tools: Microsoft Visual St udio Code, Jupyter Notebooks
Business Intelligence: Tableau, Power BI, MS Excel ( Advanced), SSIS
Methodologies: Agile, Waterfall, SCRUM
WORK EXPERIENCE
Data Analyst Mott M acDonald, Houston , TX July 2020 - Present
• Created 7+ Custom Visuals for Power BI using node.js, d3.js and packaged the visuals to be deployed on reports for
multiple engineering projects.
• Followed Agile development methodology within the cross -functional team in the development of Power BI
Dashboard and Excel reports supporting multiple projects and ad -hoc requests within the organization.
• Optimized a SQL query utilizing windowing function s like ROW_NUMBER(), RANK(), DENSE_RANK() pulling 30,000
records, decreasing execution time of the query by 23%.
• Created, Monitored and supported the data quality check process to ensure accuracy of data used for report building.
Business Intelligence Analyst Trusted Medical, Hurst , TX Jan 2020 - May 2020
• Created SSIS flows to set up ETL process for saving raw patient data coming from disparate data sources like patient
registration tools and revenue management tools into MS SQL Server .
• Developed a data source for Power BI reports by writing optimized SQL qu eries (Joins, Subqueries) on the collected
database of patient registration and revenue collection data.
• Supported the marketing team by creating dashboard KPI’s showing seasonality, effectiveness of marketing
initiatives and marketing target status to gi ve data driven insights for shaping marketing strategies.
• Maintained and Improved dashboard KPI’s using Power BI , monitoring performance of the Medical Billing team using
data sources from 16 database tables and used DAX and PowerQuery for data modeling.
• Maintained and improved interactive excel reports with formulas and macros to reflect safety stock and help with
inventory management of medical supplies.
Data Analyst Intern Mott MacDonald, Houston , TX May 2019 – Sep 2019
• Redesigned the Power BI reports by implementing bookmarks and creating a button operated interface.
• Used JSON to create theme files to ensure a consistent look across report pages.
Associate Test Engineer BNP Pa ribas ISPL, Mumbai, India June 2016 – July 2018
• Headed activities in the manual testing phase of two software releases where the team created test documents, test
cases and planned the testing process.
• Conducted testing activities like test planning, test case writing and test execution while implementing agile
methodology in two projects.
• Handled test progress and test reporting using tools like JIRA improving the defect detection in releases by 2%.
ACADEMIC PROJECTS
Insurance Premium Regression – SAS (Enterprise Miner) May 2019
• Performed exploratory data analysis on Insurance premiums dataset.
• Used regression analysis (Linear, Logistic ), K-means clustering to find patterns in the amount of the premiums.
• Identified characteristics within individuals that lead to a higher rates of insurance premiums.
Vighnesh Rajesh Pathare
Data Analyst | (469 ) 305 -9650 | ------------ | ------------/in/vighneshpathare
EDUCATION
University of Texas at Dallas, Richardson, TX May 2020
M.S., Management In formation Systems
Mumbai University, Mumbai, MH, I ndia June 2016
Master of Computer Applications
Mumbai University, Mumbai, MH, I ndia Nov . 2013
B.Sc., Information Technology
TECHNICAL SKILLS AND COMPETENCIES
Programming: Python ( Pandas, NumPy , Matplotlib, scikit -lea rn), SQL(MySQL, SQL Server, Oracle), SAS , PL/SQL , R,
JavaScript (typescript ), DAX , Git
Analytical Techniques: PowerBI, Tableau, Regression Techniques, Decision Trees, Clustering
Tools: Microsoft Visual St udio Code, Jupyter Notebooks
Business Intelligence: Tableau, Power BI, MS Excel ( Advanced), SSIS
Methodologies: Agile, Waterfall, SCRUM
WORK EXPERIENCE
Data Analyst Mott M acDonald, Houston , TX July 2020 - Present
• Created 7+ Custom Visuals for Power BI using node.js, d3.js and packaged the visuals to be deployed on reports for
multiple engineering projects.
• Followed Agile development methodology within the cross -functional team in the development of Power BI
Dashboard and Excel reports supporting multiple projects and ad -hoc requests within the organization.
• Optimized a SQL query utilizing windowing function s like ROW_NUMBER(), RANK(), DENSE_RANK() pulling 30,000
records, decreasing execution time of the query by 23%.
• Created, Monitored and supported the data quality check process to ensure accuracy of data used for report building.
Business Intelligence Analyst Trusted Medical, Hurst , TX Jan 2020 - May 2020
• Created SSIS flows to set up ETL process for saving raw patient data coming from disparate data sources like patient
registration tools and revenue management tools into MS SQL Server .
• Developed a data source for Power BI reports by writing optimized SQL qu eries (Joins, Subqueries) on the collected
database of patient registration and revenue collection data.
• Supported the marketing team by creating dashboard KPI’s showing seasonality, effectiveness of marketing
initiatives and marketing target status to gi ve data driven insights for shaping marketing strategies.
• Maintained and Improved dashboard KPI’s using Power BI , monitoring performance of the Medical Billing team using
data sources from 16 database tables and used DAX and PowerQuery for data modeling.
• Maintained and improved interactive excel reports with formulas and macros to reflect safety stock and help with
inventory management of medical supplies.
Data Analyst Intern Mott MacDonald, Houston , TX May 2019 – Sep 2019
• Redesigned the Power BI reports by implementing bookmarks and creating a button operated interface.
• Used JSON to create theme files to ensure a consistent look across report pages.
Associate Test Engineer BNP Pa ribas ISPL, Mumbai, India June 2016 – July 2018
• Headed activities in the manual testing phase of two software releases where the team created test documents, test
cases and planned the testing process.
• Conducted testing activities like test planning, test case writing and test execution while implementing agile
methodology in two projects.
• Handled test progress and test reporting using tools like JIRA improving the defect detection in releases by 2%.
ACADEMIC PROJECTS
Insurance Premium Regression – SAS (Enterprise Miner) May 2019
• Performed exploratory data analysis on Insurance premiums dataset.
• Used regression analysis (Linear, Logistic ), K-means clustering to find patterns in the amount of the premiums.
• Identified characteristics within individuals that lead to a higher rates of insurance premiums.