Vighnesh Rajesh Pathare

Data Analyst 469-***-**** adkesf@r.postjobfree.com https://www.linkedin.com/in/vighneshpathare EDUCATION

University of Texas at Dallas, Richardson, TX May 2020 M.S., Management Information Systems

Mumbai University, Mumbai, MH, India June 2016

Master of Computer Applications

Mumbai University, Mumbai, MH, India Nov. 2013

B.Sc., Information Technology

TECHNICAL SKILLS AND COMPETENCIES

Programming: Python (Pandas, NumPy, Matplotlib, scikit-learn), 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 Studio Code, Jupyter Notebooks Business Intelligence: Tableau, Power BI, MS Excel (Advanced), SSIS Methodologies: Agile, Waterfall, SCRUM

WORK EXPERIENCE

Data Analyst Mott MacDonald, 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 functions 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 queries (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 give 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 Paribas 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.