VALENCIA WALTER DIAS

Harrison, NJ adgwvf@r.postjobfree.com +1-862-***-**** LinkedIn GitHub

EDUCATION

M.S - Information Technology and Analytics, Rutgers University GPA: 3.46 Dec 2020 COURSEWORK: Analytics for Business Intelligence, Data Analysis and Decision Making, Project Management, Multivariate Analysis, Business Data Management, Business Forecasting, Business Analytical Programming B.E - Computer Engineering, University of Mumbai GPA: 3.84 May 2018 COURSEWORK: Artificial Intelligence, Data Warehousing and Mining, Cryptography and System Security, Software Engineering, Data Structures, Analysis of Algorithms, Applied Mathematics, Big Data Analytics, Cloud Computing, Distributed Databases SKILLS

Data Analysis: Excel (pivot, VLOOKUP’s), Tableau, Power BI, Google Analytics, SAP BO, Cognos Business Analysis: Gap Analysis, Vendor Selection, Business Process Reengineering, Cost Benefit Analysis Project Management: AGILE, SCRUM, Waterfall, JIRA, MS Project, Requirement Gathering, UAT, Quality Assurance, SDLC Programming/Database: Python, R, HTML\CSS, SQL, Postgre SQL, MS Access EXPERIENCE

NJ Transit, IT-Business Analyst Intern, Newark NJ Jun 2020 - Present

• Collaborated with executives at various levels to gather the business requirement and presented data-driven insights using interactive dashboards

• Administered Gap analysis prioritizing gaps and creating vendor score card to carryout efficient vendor selection

• Analyzed process workflows, proposed and tracked metrics, improvements or novel approaches to increase efficiency of existing processes

• Developed and maintained bi-weekly status reports and metrics articulating capital portfolio information to management

• Prepared reports, presentations, project documentation and supplementary material including data visualization and interpretation

Accenture, Business Intelligence Analyst, Mumbai India Aug 2018 - Jul 2019

• Elicited requirements, performed cross-impact analysis and identified the KPIs from stakeholders of a supply chain organization, measuring mail-delivery performance and highlighting opportunities

• Built ad-hoc reports and self-service strategic dashboards, using Tableau and SAP BO, providing a holistic view of 7 key drivers, enabling the client leadership to leverage data-driven decision making

• Aggregated backend data warehouse into views, using SQL, ensuring efficient retrieval of big data in the executive dashboards

• Resolved critical issues and ensured an overall 70% reduction in problems through root cause analysis using excel (macros), SQL, thus ensuring valuable information discovery

PROJECTS

Analysis of Mass Shootings in USA (Tableau, Excel) Mar 2020 - May 2020

• Investigated the trends in the USA mass shootings over the past 6 decades to highlight the number of casualties, racial background of the perpetrator, year of the incident and other related data points

• Created and visualized dashboards to understand the shooter statistics, yearly statistics and state wise occurrences of the shooting incidents

Analysis of Customer Churn (R Programming) Jan 2020 - May 2020

• Analyzed a telecom dataset to find the major factors that lead to customer churn

• Built the model using Logistic Regression Analysis having a high accuracy with the features selected Healthcare Insurance Cost Prediction (Python) Sept 2019 - Dec 2019

• The goal of this project was to use patient data to estimate the average medical care expenses using regression analysis for provided population segments

• Predicting the healthcare cost with accuracy revealed insights into the nature of the key drivers of rising costs which helped us to solve one of the world’s most important problems Predicting Quality of Wine (Python) Oct 2019 - Dec 2019

• Predicted the model accuracy using Support Vector Machine algorithm and GridSearchCV to further optimize the result and improve wine production

• Analyzed data set of wine samples as regression and classification tasks to detect the wine quality LEADERSHIP AND VOLUNTEER EXPERIENCE

Rutgers, The State University of New Jersey, In-Class Assistant/Scribe, Newark Jan 2020- May 2019

• Provided writing or typing support for students who have physical limitation

• Produced accurate and verbatim transcripts of answers dictated by the student in a handwritten format Fr. Conceicao Rodrigues College of Engineering, IEEE-Event Coordinator, Mumbai Jun 2016-May 2017

• Organized Technomania, a technical paper and project presentation event on a National level in association with IEEE-IIT Bombay

• Held Ethical hacking and Python Programming workshops for Computer engineering department students

Contact this candidate