VIKEN SHAILESH SHAH

Mobile: +1-916-***-****

Email-Id: ac8r06@r.postjobfree.com

LinkedIn: www.linkedin.com/in/viken-shah

SUMMARY:

Seeking a full-time as an analyst within a company, where I can maximize my experience and skills. EDUCATION:

NEW JERSEY INSTITUTE OF TECHNOLOGY Newark, NJ

Master of Science in Engineering Management (GPA 3.50/4.00) December 2018 Coursework: Data Mining and Analysis, Decision Analysis, Management Science, Information System Principles, Project Management, Project Control, Cost Estimation of Projects, Total Quality Management, Management Accounting. NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (Integrated Dual Degree Program) Mumbai, India Master of Business Administration (MBA) in Marketing & Finance May 2016 Coursework: Financial Analysis and Accounting, Cost Accounting, Corporate Finance, Project & Infrastructure Finance, Business Economics, Financial Management, Management of Mergers and Acquisitions, Investment Banking, Financial Planning and Portfolio. Bachelor of Technology in Chemical Engineering May 2016 SKILLS:

Domain: Data Mining, Visualization & Analysis, REST URL, SQL Query, ETL, Klipfolio, Tableau, Dashboards Management, Digital Marketing KPI Analysis, Financial Analysis, Marketing Analytics, Requirement Analysis, PPC and SEO Analysis, Statistics. Technical: MS Office Suite (Excel, Word, PowerPoint, Access, Project, Publisher), Tableau, Python, Salesforce, Google Analytics. Certificates: Data Analysis using Python (Basics)- Scheduled, MATLAB Onramp, Reading Financial Statements (Affiliated by NSE,India). RELEVANT EXPERIENCE:

SELLER’S CHOICE (HOME REVOLUTION LLC) (NJ,USA)

Data Analyst (BI), Marketing May 2018 - Present

• Maintained the client’s digital ads performance database by using data management and visualization tool – Klipfolio

• Develop new metrics goals for social and paid search team for advertising platforms such as Amazon, Google, Facebook, etc

• Conducted data extraction of KPI’s by using SQL Query / REST URL from various online advertising platforms

• Enabled data connections and created custom user interface on the dashboard application for all clients

• Performed data processing and quantitative data analysis using advanced MS Excel, SQL queries from sources including HubSpot, Shopify, Facebook Business Manager, Amazon Advertising, Google Ads and other ecommerce platforms

• Visualized data created interactive dashboards using Tableau and Klipfolio and provided strategic inputs to optimize ads’ performance

• Ensured efficient performance of all client dashboards by addressing timely software debugging of SQL queries and dashboard back-end NEW JERSEY INSTITUTE OF TECHNOLOGY (NJ,USA)

Lab Monitor – Business Analytics Lab November 2017 – May 2018

• Manage the Lab Register and enroll students for various analytics tools workshops and attend them Salesforce Data Specialist - CPE (Prof. Raymond Vaccari) October 2017 – December 2017

• Performed task of data collection and analysis to generate leads report for the professor using Salesforce Analytics & CRM LIVE Blog – www.blurbshare.com March 2017 - Nov 2017

• Developed a blog page using Word Press and published with integration of Google Analytics

• Developed Customer Insight Reports, TAT, Bounce Rate and ROI for the blog page through various social media

• Developed & managing content dairy for various Social Media Pages – Facebook, Twitter, Instagram, LinkedIn YES BANK LTD (Mumbai, India)

Relationship Manager (Assistant Manager) – Business Banking May 2016 – January 2017

• Worked closely with Regional Head to develop strategic marketing plans by analyzing market & product, using Tableau

• Handled the process of credit analysis and risk assessment using MS Excel, which includes developing financial models by projecting and monitoring cash flows, IIRs, Payback period, DSCRs, profitability ratios and sensitivity analysis

• Achieved the target of INR 25 Crores in 3rd Quarter of FY 2016-2017 BONDWELL CORPORATE ADVISORS PVT. LTD. (Mumbai, India) Intern – Project Finance April 2015 – September 2015

• Develop the credit rating analysis model which includes developing the financial models by projecting the Fund Flows, Profitability

• Ratio’s, IRRs, Payback periods, DSCRs, Working Capital Requirements

• Appraised various projects, by presenting them to funding agencies, with successful conversion rate of 85% RELEVANT PROJECTS:

Classification Problem using Neural Networks and Decision Trees March 2018

• Performed data mining using Neural Networks and Decision Tree techniques on MATLAB to analyze a Credit Card dataset Factors affecting Buyer decision for Real Estate Market May 2016

• Performed regression and co-relation analysis, using SPSS, to determine the buyer’s behavior for the Real Estate Market of Mumbai, India. Library Management System May 2014

• Developed a model, using MS Access, to auto-generate Invoices, student data collection, inventories and references.