Data Analyst Manager

DALPAT MISTRY

Data Analytics Professional based in NJ/Greater NYC Area

*** ******* **** *****, ************, NJ 07840

phone - 201-***-**** email - ************@*****.*** Linked-In: https://www.linkedin.com/in/dalpatmistry KPMG - Senior Associate of Technology Dec 2006-Jul 2020 13 yrs + Montvale, NJ Data Analysis & Data Visualization using QlikView/QlikSense, Excel macros/Pivot, SQL, Tableau, Power BI ETL and Advanced Data Mining using Alteryx, MS Access macros/Pivot, SQL, and SSMS Technology Compliance Efforts, using mail-merge techniques in MS Offices, O365 Managing Applications/Packages Deployment and Reporting using the SCCM tool Enterprise Collaboration Tools: O365, MS Team, and Skype Security tools: Dell Encryption Protection, Semantic Endpoint Protection and McAfee Expertise

Professional Experience

Data Analytics professional with over 20 years of experience utilizing various software packages and platforms to manage and deploy business systems solutions. Highly interested in continuing to challenge myself as a data analyst by adding value through hard work, dedication, and application of my professional experience and knowledge. Overview

Performed data analysis on 40K+ US workstations ensuring firm’s compliance standards are met. Developed custom QlikView dashboards using SQL DB, (OLE DB), MS Access DB, MS Excel data, and Access/Excel macros in order to efficiently present data, resulting in time saving cut costs. Developed workflows using appropriate data source/SQL queries to create qvx/xlsx files to use for dashboard

& developed Analytics app based on business/user demand, so user can run their own report. Designed analytics galleries using Alteryx. Expanded access, capabilities, and functionality to maximize knowledge-sharing potential and deliver a consumer-based solution, allowing targeted access to workflows. Using Alteryx, automated the recurring reports based on management requirements and schedules to their mailbox via email.

Developed a custom dashboard to manage all compliance communication, to aid in producing metrics for monthly leadership reports.

Proficiently used mail-merge techniques to streamline the distribution of compliance emails to mass audiences based on client requirements.

Produced several recurring user-/ management- defined reports based on business/client requirements, offering more efficient delivery of key information even while out-of-office. Created custom databases to automate reporting using MS Access/Excel macros. Leveraged SCCM tool to target workstations with different applications/packages, and manage deployment of the applications/packages.

Led offshore teams in various locations to provide training in data analysis, reporting, compliance, and deployment.

KPMG - Sr. Associate Quality Assurance Dec 1999-Dec 2006 7 yrs Montvale, NJ Took charge of project assignments by attending meetings, communicating company roles and how testing is done in the QA environment to clients, create/review test plans, test case matrix’ based on requirements. Assisted in imaging & Desktop Integration testing for different images (Advisory, Audit, Tax or Firmwide). Automated script and time permits, to help in script the test matrix in Mercury - Quick Test Professional. Involved in HRMS migration using team track tracking system compliance with remedy system. International Diploma in Computer Programming and Applications (COBOL) National Computing Center - UK Asia-Region Baroda, India (1991)

MS in Physics/Electronics, Sardar Patel University Vallabh Vidyanagar, India (1989) Responsibility included Development, Maintenance & testing of a Continuous Emission Monitoring Data Ac- quisition System for many clients. Application was developed in ADA language using oracle RDBMS on UNIX

(SCO Unix) platform.

AT&T - Software QA Consultant

Aug 1999-Dec 1999 2 yrs Piscataway, NJ

May 1996-Dec 1997

Enviroplan - Software QA Consultant Oct 1995- Apr 1996 1 yr Roseland, NJ Pair testing and Regression included setup UNIX environment and shell scripting. Developed test plan, test cases, constructed test data, created expected results, test execution, verification, cre- ating/closing MRs for the issues and documentation. Testing included Pair testing and Regression Testing. Setup Unix environment, shell scripting, maintained back- up & recovery of testing data for the different test environment like unit, pair, regression, certification testing and all documentation.

Developed plans to support their Automated Verification Tools (AVT) team included execution, verification, cre- ating/closing MRs for the issues.

Problem solving using different tools to analyze, model, and interpret data Automated data reports and outreach

Developing and refining skills through job shadowing programs to further engage in the work community. Working collaboratively to train others and gain more experience Working directly with clients to provide solutions Participating in community programs, such as: living green initiatives, 5k Charity Walks, TD 5 Boro Bike Tour Communication through a variety of languages: English, Hindi, Gujarati ITIL v3 Foundation Certificate AXELOS, PeopleCert, 2018 Analyzing Data with SQL Server Reporting Services Course Microsoft, 2017 Administering System Center 2012 Configuration Manager Course Microsoft, 2012 Crystal Reports XI R1/R2 Report Design I+II Fundamentals of Report Design Course Business Objects, 2007 Maintaining a Microsoft SQL Server 2005 Database Microsoft, 2005 Certificate Course on ORACLE RDBMS Baroda, India (1992) Engagement

Certification

Education

Prudential - Software QA Consultant Jan 1998- Jul 1999 1 yr Roseland, NJ Worked on Baseline and compliance testing – extensively used tools like PLAYBACK by Compuware to capture

& playback scripts, run compare of these scripts to find out online differences. Involved in using hourglass for Y2K testing to age the CICS region.

Contact this candidate