Arvindra Singh Panwar

PHILADELPHIA, PA admlsa@r.postjobfree.com 551-***-**** LinkedIn

SUMMARY

Information Systems graduate student with Proficient knowledge in Statistics and Analytics. IT Professional with 3 years’ experience has excellent understanding of Business Operations, SDLC, Agile and Data Analytics tools for effective analysis of data and risk. EDUCATION

Saint Joseph’s University (GPA 3.7) Philadelphia, PA Master of Science in Business Intelligence and Analytics Dec 2020 DAVV University (GPA 3.8) Indore, India

Bachelor of Business Administration June 2016

TECHNICAL SKILLS

• Databases: MYSQL, NOSQL, Oracle, SQL Server

• Tools: Tableau, JIRA, Confluence, SharePoint, Microsoft Office Excel (Pivot Tables, VLOOKUP), QlikView, SQL Developer SAP SD Business Objects, Oracle EBS, HP ALM Quality Center, ServiceNow Platform, Google Analytics, Power BI

• Programming Languages: Python, R, Java, JMP and SQL

• Others: Business analytics and Business intelligence, Data analytics, Database development and management WORK EXPERIENCE

CrowdDoing Data and Business Analyst (Volunteer Work) San Francisco (CA), US Feb 2021- Present

• Analyzed effectiveness of products based on customer feedback.

• Involved in data collection, cleaning, pre-processing & quantitative analysis to extract useful insights & medicinal food recommendations

• Developed and executed test cases, for creating various reports required for project deliveries Saint Joseph’s University Data Technologies & Tools Philadelphia (PA), US Apr 2019- Dec 2020

• Assist in initial setup, testing, and monitoring of Informatics data of students

• Gathered and analyzed user requirements from different departments at Saint Joseph’s University and created Tableau/ Power BI dashboard to track the research and published work

• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently

Pixit Solution Business Analyst Indore (M.P), India March 2017-Nov 2018

• Gathered Business requirements from stakeholders and ensured their implementation as mentioned in requirements document and project management, to served 100% deliverable.

• Improved efficiency of the sales team by optimizing time and performance matrices monthly/weekly sales report presentation, by executing a customized sales dashboard system to and record a 15% growth in sales.

• Involved in Requirement Analysis, Test Planning, Test Design, Test Data Preparation, Execution, Defect Management, Test Closure activities, Status Reporting and Traceability Matrix

• Practicing full facing Agile methodology with Scrum Meeting, Sprint Planning meeting, sprint review, retrospective meeting

• Collaborated with a cross-functional team of clients, PMS, and QA analysts to deliver the project on-time and within budget Tanisha Buildcom Pvt. Ltd. Data Analyst Indore (M.P), India Jan 2015- Jan 2017

• Designed and tuned complex SQL queries and tested packages, stored procedures, triggers, views of databases which increased computing speed and reducing the processing time by 30% and used SQL for accessing and manipulating database systems

• Worked on ETL project, used batch processing to improve the performance.

• Entered and updated (Epics, Stories, and Tasks) onto JIRA, Confluence and VersionOne application for multiple sprints

• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback

• Created impactful dashboards using Tableau/Power BI for a competitive pricing analysis project by analyzing the historical data and identifying KPI’s which had positive impact on the business.

• Developed interactive Tableau dashboards using filters, parameters, and drill downs for KPIs related to IT resource billing

• Experienced in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and black box testing techniques like Equivalence Partitioning and Boundary Value Analysis, Smoke, GUI, Functional, Usability, Retesting and Regression testing, and Security Testing (XSS, Session Testing)

ACADEMIC PROJECTS

SAP consultant DSS 610

• Spearheaded a team of two in the planning and implementing SAP, reducing associated costs by 45% from the sale phase.

• Analyzed data and performed comprehensive risk analysis on requirements for customized application creation for the client.

• Conducted business process gap analysis between the new design and SAP standard business processes, and made recommendations for process improvement

Database Management Systems Oracle SQL DSS 630

• Worked on a project which give information about career options, abroad education plans and profile evaluation for that developed a web-based application using Microsoft Access

• Created tables for student, linked tables for university listing and ranking, including forms, macros, queries, reports and implemented logic for profile evaluation. Involved in writing documentation. Tableau Spotify Dashboard Project DSS 670

• Utilized Tableau to create an executive dashboard show assign KPIs for the top and bottom ten songs of 2018

• Defined popularity through song duration, balance of music and lyrics. Days since release and tempo CERTIFICATIONS

• KPMG Data Analytics consulting virtual Internship Certified from Inside Sherpa Apr 2020

• Tableau Analyst and Tableau Author Certificate, Tableau May 2020

• Managing Big Data with My SQL Certificate, Coursera Apr 2020

• Power BI Masters Visualizations, iNeuron May 2020

• Customer Analytics Certificate, University of Pennsylvania May 2020