Anand Vinod Master

Tel: 507-***-**** ** Harbor Point Blvd, Apt 306, Boston, MA 02125 adcjwo@r.postjobfree.com

Summary

Experienced Analyst who comes with continuous improvement mindset who can condense large and complex data using SQL databases, validate it to maintain data integrity and automate monthly reports using various ERP systems

Business-minded analyst, result-oriented team player with strong communication ability, and proven abilities to deliver valuable insights via data analytics, reporting and dashboards in Tableau and Power BI

Experience in writing Advanced SQL (Window Functions) queries to manipulate data

Experienced financial modeler, ROI analysis, or business forecasting, and experience seeing beyond numbers to drive sound decision-making from complex datasets

Knowledge of Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading

Excellent knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACTS and Dimensions Tables using Analysis Services

Work Experience

Sun Life

Business Analyst - Advanced Analytics Boston Jul 2018 – Current

Lead and developed fully functional application having user interface which was utilized by underwriters and management; Integrated data from multiple sources (user inputs, mainframe data, third party vendors) while considering the demand for a real-time, multi-user, and multi-site environment thereby improving the efficiency of the process by about 20%

Created tableau dashboards with global/sets/parameters/calculated fields that allowed to track (subscription business) RFP’s prospective customer data and improve KPI by 5% within a year

Collaborated with stakeholders across the organization; Co-developed data mart that acts as a single source of truth for all reporting purposes this Improved end-user response time by 25% allowing users to have access to the specific type of data when needed

Analyzed prospective data trends for pricing (rate-study), tested hypotheses such as the impact of a predicted trend, or the impact of a Management action, created exhibits, identified opportunities and recommended solutions to improve profit maximization from 5% to 15% in FY 2019

Converted and re-build applications and reports to accommodate changing business needs, new product features, changing systems & platforms and acquired businesses (new data sources and processes)

Developed data requirements and collaborated with IT to obtain necessary data extracts; Documented the flow of data through the creation of workflow diagrams

Partnered with IT and Business area to ensure that data extracts are performing to specifications and data downloads from source systems are complete and verified that the data from databases is available and accurate (e.g., comparative analysis of data sets)

Updated data management processes and tools to improve information, while anticipating the impact on related databases and mitigated financial and operational risks

Provided ad-hoc on-demand reports using knowledge of systems and databases to answer critical, immediate business issues

Helped develop a new in-house data lake (warehouse system) by testing insurance claims and premium data and updated anomalies on JIRA tool

Executed reporting/analysis against the analytical needs of internal teams, and developed automated reporting/dashboards, maintaining related systems, tools, and environment

Managed data flow from data warehouse to visualization tools, performing data governance checks and maintained existing suite of automated reports leveraging various tools such as SAS, MS SQL server, Power BI and Adv Excel

Provided technical expertise in the design, development, and delivery of report automation; Automated frequently utilized reporting such as value of new business, segment report and prospective client reports

Cambridge Historical Society

Board Member, Council Member Financial Management Boston Mar 2018 – Jun 2018

Identified KRI/KPI, analyzing their revenue segmentation, enhanced databases of the donors and gave recommendation to maximize the donations

Forecasted budget, grants, OPEX and conducted ad-hoc analysis for strategic planning

Worked with budget/cost center managers and analyzed various data to perform monthly financial forecasts and prepared variance analysis report that helped management to allocate resources promptly

University of Massachusetts Boston

Data Analysis Research Assistant Boston Jan 2015 – May 2017

Condensed large and complex financial data for 3000 companies, gathered from multiple sources, summarized mergers and acquisition results into clear and concise observations, cleaned the data and created various slices/dices of data and build dashboards that translated metadata into actionable insights using Tableau

Routinely conducted business analysis, investments and other types of profitability related requests to minimize active risk of an equity portfolio thereby saving $5,000 every quarter

Durkin Valuation Consultants

Business Analyst Financial Modeling Boston May 2016 – Dec 2016

Analyzed clients’ new business venture, conducted FP&A financial planning and analysis, identified key gaps and increased revenue by $400,000 approximately

Performed business analysis and delivered ad hoc reporting in areas of research, project maintenance, cost management, operations and risk analysis

CVP Properties LLC [VPNE Parking Solutions]

Business Intelligence Project Assistant Accounting Management Boston Jun 2015 – Aug 2015

Diagnosed, initiated design change, automated client reporting packages using CPM solutions (Host Analytics) that acts as a connector for ERP systems, as a result labor time and overall efficiency of the department increased by 200%

Identified opportunities to automate manual processes, integrating new systems, technology and processes with existing ones

Validated the data that post and pre migration from MS GP Dynamics to Host Analytics so as to maintain data integrity

Prepared dashboards to improve cost containment, control improvements by tracking key performance indicators (KPI)

Identified root cause analysis, suggested ways to minimize the cost, increased revenue and streamlined operations using Host Analytics and Excel Macros

T. R. Master [Self Employed]

Business Analyst Finance Mumbai Nov 2010 – Jun 2014

Co-developed budget and rolling forecasts in order to determine the long-term economic and financial profitability

Designed, created and maintained OPEX, P&L, working capital and resource allocation reports to identify new opportunities to save cost of $ 1,000 per month and diversified business strategy

Designed and prepared KPI reports that helped to track sales performance

Conducted sales cycle & seasonality analysis to improve sales and customer experience by 10%

J.P. Morgan

Reporting Analyst (Team Associate) Financial Services Mumbai Bournemouth, UK Sep 2007 – Nov 2010

Worked with an internal business partner to conduct SOX audit and served as a key contact for internal and external audits

Automated the work, reduce errors and increase efficiency of the department by 8% every quarter by managing multiple continuous improvement projects to mitigate future financial risks

Designed, prepared, optimized KRI/KPI reports using Excel VBA, scorecards, Management Information system (MIS), and aged break reports for key stakeholders to mitigate financial and operational risks

Managed data issues throughout the life cycle, by effectively collaborating with various functional leads from Tech, Ops and compliance to documented data issues, root cause and communicated remediation plans

Education

University of Massachusetts, Boston

Master of Science in Information Technology GPA - 3.9/4.0 Dec 2017

Master of Business Administration – Finance GPA - 3.9/4.0 Dec 2016

Work Authorization

H1 B visa valid until Aug 2022 (first three-year term)

Willing to cover all expenses related to onsite interview and relocate at my own expense

Awards

Dean Prize for Graduate Service Awards 2016

Distinction in Service Awards 2016

Golden Key Honours Society 2015

Beta Gamma Sigma 2016

Courses

Advanced SQL for Data Scientists

Tableau 10 for Data Scientists

SQL Data Reporting and Analyst

R for Excel Users

Skills

Business Intelligence:

KRI/KPI, Tableau, Host Analytics, PowerBI, Microstrategy, Advanced Excel, Salesforce

Languages:

SQL, SAS, SPSS, R

Data warehousing:

MS SQL Server, Visual Studio, OLTP, ETL, OLAP, SSAS, SSIS

Project Management:

SDLC, Agile, Waterfall, MS Project 2016, JIRA

Finance:

Budgeting, Forecasting, variance analysis, FP&A, finance modelling, finance valuation

Projects

Strategic Management:

Performed Netflix’s and Google’s External (Porter 5 forces) and Internal (VRIO) analysis

Data Warehousing:

Designed star schemas (Kimball’s design) for restaurant dataset using OLTP databases

Determined the business process, identified KRI/KPI, declared grain, identified dimensions and facts

Conducted ETL (extract-transform-load) using query builder, SSAS and SSIS tools

Migrated data into user-friendly format and prepared OLAP cubes to help track performance of the restaurant

Provided recommendations by structuring where/when/how the restaurant should enter new market segment and strategies to improve its current situation

Some of the highlights are Profit maximization strategies for the current location and cost minimization techniques by not giving discounts to certain group of customers. Resulting in 20% increase in the profits every quarter

Project & Change Management:

Developed real time project for Boston’s healthcare company that included requirements gathering

Defining acceptance criteria; developing project plans, project scope, Gantt chart, forecasted cost, cash flow, prepared communication plan, contingency plan, risk analysis, and estimated work effort

Valuation of the Hydro-electric Water Plant & Limousine Company:

Conducted meetings with client, understood its P&L statement, working capital needs, revenue segmentation, electric generation capabilities

Performed industry and competitor analysis, reviewed budgets, forecasted its revenue and expenses, developed cap rate, and arrived at the fair value of the firm

Statistical Analysis for Managers:

Compared performance of two airlines based on three parameters such as On-Time, Mishandled baggage’s, and Involuntary Denied boarding

Conducted various hypothesis testing to recommend how they could improve the lagging performance

Extra-Curricular

CFA Research Challenge 2016

MIT’s Supply Chain Competition 2015

Bloomberg Trading Challenge 2017

Ambassador of College of Management at UMass

Mentor to Professional MBA /MSF student

Panelist for undergraduate events

Active Leader on Bloomberg training team

ISM Student Member

Contact this candidate