Business Data Analyst

Mauli Thacker Shah

San Jose, CA ***** ************@*****.***, 408-***-****

PROFESSIONAL OBJECTIVE:

To work as a business/data analyst in an organization, formulating effective and efficient business processes resulting in better target yields

SUMMARY:

Total 4+ years of work experience in technology (2+ years) and financial services (2+ years).

Experience in conducting interviews, brainstorming sessions for gathering and analyzing requirements from stakeholders.

Documentation and communication of requirements to the concerned stakeholders.

Closely worked with IT experts, subject matter experts for data collection and analysis.

Good understanding of Big Data, Hadoop, R, Hive, Pig, Python and proficient in writing advanced SQL queries.

Experience of working on advanced MS Excel features like index match, sum-product, offset.

Ability to assume responsibility and perform with no supervision.

Excellent quantitative, analytical and time management skills.

Outstanding verbal and written communication skills and ability to work with cross-functional teams.

Self-learner, capable to work in a multi-task environment with dynamic requirements and priorities. EDUCATIONAL BACKGROUND:

Certification in Big Data, Hadoop, Pig, Hive Apr 16 Edureka

Certificate Program in Business Analysis GPA: 4.0, Oct 15 UC Berkeley Extension, Berkeley, California

Master of Business Administration, Finance GPA: 3.43, Apr 12 Amrut Mody School of Management, Ahmedabad University, Gujarat, India Bachelors of Engineering in Instrumentation and Control GPA: 7.7/10, Jul 07 Nirma Institute of Technology, Nirma University, Gujarat, India TECHNICAL SKILLS:

Operating Systems: Windows XP/7/8

Programming Languages: People Code, SQL, PL/SQL, Hive, Pig, Python Tools/Platform: People Tools 8.48, Toad for Oracle, Bureau One (Equifax), Big Data, Hadoop, R, SPSS, UNIX, Tableau Applications: PeopleSoft 8/9, MS Office – Word, Excel, PowerPoint, Outlook, Google Docs WORK EXPERIENCE:

Project Intern: Tableau June 2016

Extracting data from different database sources.

Editing Data Connections, Data Sources and using Data Joins.

Performing various techniques of Visual Analytics like sorting, grouping, filter, formatting, forecasting.

Building Dashboard and Stories using layouts, formatting and actions.

Performing Calculations features like modifying, aggregation, date, logic, number, string, type.

Preparing Charts like Waterfall, Bump, Box, and Histograms. Project Intern: You-Tube Data Analysis Apr 2016

Identify top categories of video using Hive, Pig and HBase.

Identify top rated video using Hive, Pig and HBase.

Identify most viewed video using Hive, Pig and HBase. Project Intern: Enterprise and Requirement Analysis Jul 2015 – Oct 2015

Conduct SWOT analysis for the issue on hand.

Define and identify business goals, business objective and business needs.

Determine capability gap and the impact on the business need and evaluate solution using decision analysis technique.

Define problem statement and create business case, categorize requirement using MOSCOW technique.

Identify business and technical constraint and prepare checklist to verify requirement.

Responsible for development of broad range of reports using data analysis technique, look-ups, sorting and filtering using Excel.

Project Intern: Elicitation, Requirement Management Communication Mar 2015 – Jun 2015

Identify and categorize risk, develop mitigation plan.

Identify key stakeholders, stakeholders and evaluating their influence and attitude.

Prepare process flow diagrams, change management process for the tasks in the process by including security information.

Develop traceability matrix to trace the requirements and identify requirements for re-use.

Preparing request for proposal to select vendor and develop a communication plan for the project.

Responsible for development of broad range of reports using conditional formatting, pivot tables and reporting, and advanced charting using Excel.

L&T Finance Ltd. Dec 2013 – Sept 2014

Sr. Executive, Underwriter

Sanctioned loans for farm products and farm implements.

Review proposals and scrutinize them according to the policy.

Conduct telephonic verification with the customer.

Generate CIBIL report to cross verify the past record of customer.

Delivered highest customer satisfaction.

Extensively worked on Excel features like pivot tables, graphs, charts, data analysis to provide insights on portfolio.

Check the existing loan agreements by performing dedupe checks and analyzing the borrowing capacity.

Review portfolio timely and conduct field visits for the defaulted cases. L&T Finance Ltd. May 2012 – Nov 2013

Executive, Credit Analyst

Appraised credit approval memorandum for construction equipment, vehicles, and dealers.

Review proposals and scrutinize them according to the policy.

Generate CIBIL report to cross verify the past record of customer/dealer.

Conduct field visits and analyze the business operations of the customer/dealer.

Prepare and analyze financial analysis document using Google Docs.

Regular monitoring of chronic accounts through site visits and market feedback.

Responsible for handling credit portfolio of existing and new relationships.

Monitor pending compliances in credits post disbursement.

Update post disbursal documents after loan disbursement.

Extensively used Excel to create pivot tables and charts using internal and external resources, modified pivot tables, sorted items and group data.

Hands-on experience on look-ups, conditional formatting, data analysis tools, and formulas to analyze large data structures. Tech Mahindra Ltd. July 2007 – Sept 2009

Technical Associate, Application Developer

Developed HR Module as a part of PeopleSoft 9 HR and Finance Implementation Project.

Prepare Technical Design Document (TDD) by referring to the functional specifications.

Customized Job Data Component, Hire Process, Prior Work Experience, and Separation Process.

Customized new component that captured allowance details for employees.

Build and maintain SQL scripts, indexes and views for data analysis and extraction.

Created and optimized SQL queries to increase performance.

Ensured best practices are applied and integrity of data is maintained through security, documentation and change management.

Involved in data validation by writing SQL queries.

Involved in back end-testing and worked with data quality issues using SQL.

Worked with business stakeholders and production teams and across functional units to identify business needs and discuss solution options.

Designed and developed ‘Approver Process’ to get the active supervisor for third party integration.

Involved in data migration and prepared table wise field mapping through fit-gap analysis.

Worked on component interface, application engine, workflow, and SQR reports.

Contact this candidate