Sign in


Alhambra, California, United States
April 13, 2018

Contact this candidate


NARENDRA MALI Phone: 626-***-**** 1801 Garvey Ave, 311, Alhambra, CA-91803 LinkedIn: Github link:

OBJECTIVE: Seeking full-time opportunity in a competitive environment, where the application of problem solving skills will be utilized.

MUFG Union Bank [Americas Compliance Division] June 2017- August 2017

Summer Analyst Intern [Tableau, Excel Macro, Open Pages, IBM Cognos]

Created interactive Tableau Dashboards & reports based on large dataset for annual training plans and internal reports.

Worked extensively on automation of monthly excel reports and KPI reports using excel macros which saved 3 days’ worth of efforts per month. Also, manipulated data in excel to create different reports.

Extracted reports from Open Pages and created reports using IBM Cognos.

Developed, delivered presentation on Risk Culture in bank using Prezi to the GRC division team.

Trained team-mates on Tableau since Tableau was widely used in team to create dashboards.

Capgemini India [Client: Chubb Insurance] Feb 2014–June2016

Senior Engineer [MS Excel, Macros, MS Word, MS Visio, Selenium, Quick test Professional, HP Quality Center,JIRA]

Requirement gathering, analyzing requirements, software/technical/functional specification documents and finding out flaws/gaps to create perfect test plans, test cases and test strategies in an insurance domain project.

Fully managed entire releases and projects which include estimate creation, attending BRD and test plan walkthroughs with client, manual testing, Defect-verification, status reporting and analysis on high severity defects.

Running monthly metrics for the projects to maintain record of amount of work done in specified timeline on monthly/quarterly basis. Also, presented findings such as how to manage the resources to get maximum amount of work done in given timeline which in return resulted in increased in productivity.

Created file check utilities which used to remind user if any file is been updated. Automated the task for web applications using Selenium. Also, created utilities in excel Macro to save half a day’s work in test case execution per release.

Experienced in coordination and effective communication since worked in offshore onshore environment.

Played role of Defect Prevention representative and streamed line the DP process of our project. Suggested, maintained and created SQL based reports on performance trackers for the project.

Preparing daily, weekly and monthly status reports to send it to the customer and for internal review purpose. Also, created final closure report and knowledge documents for the projects which went into production.

Created different flow charts using Microsoft Visio to give better understanding of the system to testing teams.

California State University- Los Angeles August 2016-December 2017

Graduate Assistant [MS Office, Outlook,, Business Policy Game,,]

Conducted survey for Management department and analyzed this dataset to create insights and reports using excel.

Provided support to the professors and faculty members to maintain peoplesoft system of Cal State LA

Setting up environment and simulating “Business Policy Game” for undergraduate strategic management students to help them in making real world decision based on the market and competitor’s situation.


Consumer complaints analysis using Tableau

Cleaned the dataset using Excel and chose important questions such as which financial services has received maximum number of complaints across different categories.

Created Trend Analysis, Histogram, Geographical maps, Box & Whisker plot, Story in Tableau

Analysis of Building and safety permit information data [Hadoop, Hive, Tableau, 3D-Map, Power view, Google fusion table]

Uploaded the clean dataset to IBM Bluemix BigInsights Cluster. Dataset was cleaned in excel.

Executed HQL queries in Hive. Visualized the data using 3D Map, power view, Google Fusion Table and Tableau.

Analysis of Parking Citations in the City of Los Angeles using R

Data cleaning in R, finding insights and creating visualizations with statistical averages of the data.

Pregnancy Risk Assessment Monitoring System Data Analysis using Python

Cleaning dataset in python. Created summary statistic, found insights and created visualization in Python using Spyder through Anaconda navigator.


Master’s in Information Systems, California State University- Los Angeles GPA 3.84/4 Dec 2017

Bachelors in Electronics & Telecommunication Engineering, Mumbai University, India GPA 3.58/4

June 2013


“MongoDB for Developers” from MongoDB University (December 2017)


Received a “Pat on the Back award” for dedication towards work, time management and excellent performance.

Received “Honors” at California State University Los Angeles for academic excellence.


Programming Language : C, C++, HTML Visual Basics, Java, JavaScript, XML, VB Script

Quality Analyst Tool : Quality Center, selenium, Quick Test Professional, Unified Functional Testing, Jira

Data Analysis Tools : Hadoop, Hive, SPSS, Tableau, Python, R, Power Map, 3D-Map,

Google Fusion Table, IBM Watson Analytics

Operating systems : Windows, MacOS

Database : SQL, PL-SQL, HQL, MongoDB

Windows Application : MS Word, MS PowerPoint, MS Excel, Microsoft Project


Around 3 years of experience in business analytics, software testing and quality analysis in the field of IT. Also, internship experience as a Business Analyst at MUFG Union Bank.

Leading projects for execution of system, functional, regression, boundary, compatibility, acceptance, end to-end, and usability testing.

Full Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) experience. Testing as per Waterfall and Agile testing methodology

Contact this candidate