Jenish Lamsal

Consultant

CGI•  June 2019 - Present

● Analyze data to develop KPIs that answer key questions regarding demographics, performance, compliance, accessibility, and effectiveness of health insurance within the United States ● Design and deliver more than 50 enterprise-level Tableau dashboards to answer key healthcare-related questions utilizing various kinds of graphs and charts ● Identify and reconcile errors in data logic using MySQL to ensure accurate business requirements ● Understand stakeholder requirements and develop tangible deliverables such as user stories, acceptance criteria, test cases, user manuals, Requirement Traceability Matrix(RTM), and Software Design Document (SDD) ● Selected to be a part of a 12 person initiative to innovate new ideas to solve problems faced by the client’s team

Data Analytics Intern

Capital One•  May 2018 - March 2019

● Gather requirements from stakeholders and produce project scope including goals, tasks and deadlines ● Ensured data integrity and data quality by effective data cleaning and preparation using python ● Built data pipelines using Apache spark and Python to Extract, Transform and Load data into a MySQL database ● Utilize google forms to collect data, store it in google sheets and employ google app scripts to send an automated email enclosing the summary reports of the collected data ● Generate ad-hoc reports highlighting high risk financial transactions that should be reviewed

IT Implementation Intern

IT4Causes•  September 2017 - February 2018

● Designed a conceptual and physical data model for raw data stored in 40 excel sheets for the purpose of loading the raw data into a relational database ● Gathered requirements and completed project timeline assessment through meeting in person with clients ● Setup Office 365 for clients; including support with email, contacts and calendar migration from Google to Office 365 ● Install and update software and hardware for various clients