PRAMOD KUMAR

*** ********** **, ******, ** ***** Ph: 857-***-**** Email: ada4vc@r.postjobfree.com www.linkedin.com/in/pramodkumar-boston SKILLS

Functional Skills: RDBMS, SQL, ETL, Exploratory Analysis, Data Profiling, Business Intelligence, Data Warehouse, Reporting, Data Governance Technical Skills: SQL Server, EPIC, Tableau, Power BI, Crystal Reports, SAP BO, SSIS, SAS, Python, MS Excel, PowerPoint, AWS, Google Analytics EXPERIENCE

Data Analyst South End Community Health Center, Boston MA Nov 2018 - Present

Responsible for ETL, Data Analytics, Reporting, Datawarehouse Management, Quality Improvement, EPIC PRD, and Business Intelligence

Create packages using SSIS for data extraction from Flat Files, Excel Files, Salesforce, OLEDB to SQL Server and automate for production

Collaborate with Providers, Quality team to create monthly dashboards, define KPIs, clinical quality measures to improve patient’s health

Actively maintaining data quality, troubleshooting database issues, finding root cause and resolving core issues for accuracy of reporting

Act as liaison between PCP, MAs, EMR Manager to establish, implement and create BI reporting for monthly providers productivity report

Function Cogito Clarity, Cogito Warehouse console to schedule executions for ETL and identifying root cause for any failed pipeline Business Data Analyst Royal Sundaram Alliance Insurance Co Ltd, Hyderabad, India Feb 2013-Apr 2016

Achieved 88% customer retention by analyzing CRM database and models, gathering business requirements, and prioritizing business rules

Performed data cleansing, imputed missing values and outliers by T-SQL functions, executed ad-hoc queries, and maintained data integrity

Implemented ETL by creating SQL queries and stored procedures to extract 2 million records from different sources for weekly claims report

Built user-interactive Tableau dashboards and stories; recognized fraudulent claims, and saved worth of $400,000 quarterly liability expense

Analyzed trends and gaps by defining business KPIs, generated reports to get data-driven answers that reduced outstanding claims by 36%

Served as liaison between Finance team and stakeholders to perform monthly GAP analysis for requirements, quality, and risk assessment

Resolved 100s of issues and errors by performing unit-testing of SQL code, specifications and test conditions relating to the database server

Collaborated with audit, compliance and QA team for internal review meetings on scrum planning sessions, user stories, and business rules 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 ACADEMIC PROJECTS

Project Management- Blue Cross Blue Shield Northeastern University, Boston, MA Jan-April 2018

Proposed an idea to analyze customer satisfaction in a Health Insurance company from different sources in different formats

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

Validated work results and insight applied to tools used for client analysis and documentation of SAS files and library structures Database Management System- Blue Cross Blue Shield Northeastern University, Boston, MA Sept-Dec 2017

Designed ER model in Toad Modeler, generated DDL script for database schema and deployed on SQL Server as per business requirements

Performed normalization(3NF) of database systems and implemented triggers, views, and indexes with T-SQL statements in MS SQL Data Analysis with R Northeastern University, Boston, MA May-Aug 2017

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

Analysed dataset to improve sales, identified dimensions like category, region, seasonality, and ratings for promotions on various products

Generated database for statistical analysis, data visualization using ggplot2, and enabled improved sales with strategic market decisions

Contact this candidate