Data Analyst

PRAMOD KUMAR

Boston, MA ***** Phone: 857-***-**** Email: *****.***@*****.***.*** LinkedIn: www.linkedin.com/in/pramodkumar-boston EDUCATION

Northeastern University, Boston, MA

Master of Science in Engineering Management GPA: 3.5 Sept 2016-May 2018 Relevant Courses: Database Management System, Data Warehousing & Business Intelligence, Data Mining, Statistics, Economic Decision-Making, Project Management, and Product Development Malnad College of Engineering, Hassan, India

Bachelor of Engineering in Mechanical Engineering Sept 2008-July 2012 EXPERIENCE

Business Analyst Royal Sundaram Alliance Insurance Co Ltd, Hyderabad, India May 2015-Apr 2016

Analyzed business processes, gathered business requirements and documented with strategic initiatives of claims management to increase business performance

Collaborated cross-functionally with underwriters, insurance brokers, and car dealers to maintain relationship with business partners without affecting claim ratio

Generated ad-hoc reports, monthly KPIs of claims activities to understand trends and gaps to get data-driven answers

Guided cost and change control process by enforcing insurance policies and procedures, providing trends and forecasts

Influenced claim associates to set goals, resolve problems, and make decisions to achieve company’s business objectives Claims Analyst Royal Sundaram Alliance Insurance Co Ltd, Hyderabad, India Oct 2013-May 2015

Processed 200+ reported claims each month of private & commercial vehicles in fair and reasonable manner

Reduced outstanding claims by 18% by collaborating with surveyor & loss assessors, negotiating with customers, and recognizing fraudulent claims

Obtained monthly performance report and dashboards by means of pivot table, VLOOKUP in Excel to claims zonal head ACADEMIC PROJECTS

Data Analysis with R Northeastern University, Boston, MA Sep-Dec 2017

Implemented web scraping of e-commerce website flipkart.com and data cleaning of large data sets for storage and retrieval in RStudio

Generated database for statistical analysis and data visualization for better KPIs, enabled improved sales with strategic market decisions Data Warehousing & Business Intelligence Northeastern University, Boston, MA May-Aug 2017

Performed data profiling on various source system to design and build EDW using Star Schema, hybrid dimensional-normalized model

Designed Data Mapping to function ETL from different source of structured documents to EDW through a series of data transformations and loaded 50 million rows in 14 mins using SSIS and Talend

Analyzed business KPIs and metrics by creating analytical reports, user-interactive dashboards and recommended solutions for creating more revenue whilst reducing loss through valuable insights using Tableau and Power BI Database Management System Northeastern University, Boston, MA Jan-Apr 2017

Created database, DDL script and populated tables according to business requirements of healthcare insurance company

Considered database driven website with secured login feature allowing admin for data manipulation with SQL statements

Deployed database objects triggers, views, clusters, sequences, and indexes with T-SQL statements in MS SQL Project Management Northeastern University, Boston, MA Jan-Apr 2017

• Proposed an idea to analyze customer satisfaction in a Health Insurance company

• Operated risk management analysis, agile methodology and WBS to accomplish our project plan accordingly

• Elevated issues to team whenever there was a change in project schedule, budget or scope SKILLS

Proficient in : SQL, MySQL, PostgreSQL, PLSQL, T-SQL, R, SSIS, Tableau, Power BI, Cognos, Excel, OLAP, PowerPoint Familiar with : Python, Hadoop, SAS, SPSS, Oracle, SAP, Azure, Qlik Sense, Qlik View, Visio, HTML, PHP, Java

Contact this candidate