Naga Sushmitha Macheri

adi3o0@r.postjobfree.com +1-443-***-**** LinkedIn - nagasushmitha-macheri GitHub - nagasushmitha-macheri AWS Certified Cloud Practitioner Virtual Grace Hopper Conference ‘20 A recent Information Systems graduate with 2 years of experience, experience with Medicare and Medicaid data, and an avid technology enthusiast.

EXPERIENCE

General Associate, The Hilltop Institute – Technology and Innovation Team Jul 2020 – Present

• Reporting directly to the CTO and assisting with day-to-day operations.

• Created database objects in our SQL data warehouse for utilization by Maryland Department of Health (Medicaid) in their Tableau based dashboards.

• Performed quality control for the Maryland Total Cost of Care Model, of Medicare data against benchmarks provided by the Centers of Medicare and Medicaid Services, within the Hilltop Multi-payer Claims Analytic Tool (MCAT). Graduate Assistant, The Hilltop Institute Jun 2019 - May 2020

• Automated aggregation of Splunk reports of VPN and RDP activity into Tableau dashboards via SQL Server Integration Services, as a part of the Hilltop DevSecOps.

• Responsible for maintaining the accuracy and timeliness of data used for reporting sensitive information to the Maryland Department of Health, including Opioid Use Disorder and Medically Assisted Treatment data.

• Authored technical reports for Maryland Department of Health by analyzing programs to document insights and design data flow diagrams limiting customer confusion to 5%.

• Achieved query optimization for MMIS Data by 80% through development of automated jobs in SQL Server.

• Liaised with the executive office to plan for Business Continuity Day ensuring smooth WFH days.

• Organized a training session to introduce teammates to SQL basics, doubling their efficiency. Software Engineer, Celstream Technologies Nov 2017 - Jul 2018

• Generated design frameworks in the early stages of software development to map out functionality and prioritize content minimizing design flaws by 70%.

• Built an e-commerce web application using HTML5, CSS3, TypeScript, and Angular 5 and improved responsiveness by using Bootstrap 4 in an agile environment.

• Improved performance of an existing application by 20% by debugging and coding algorithmic solutions.

• Assessed product quality by performing A/B testing ensuring it was 200% ready for market.

• Deployed scalable web apps using continuous integration (CI) tools and the IIS Server. PROJECTS

Chefgram [Tools: AWS Amplify, DynamoDB, GraphQL, React]

• Developed and deployed a photo sharing application for chefs and foodies to share pictures of their meals and snacks. This is a CRUD + List application that updates real-time allowing users to login, upload and share their food images. Pollster A polling app for Job Applicants [Tools: Python, Django, PostgreSQL, HTML, CSS, Bootstrap, Git, Heroku]

• Conceptualized a Full-stack web application in Django. This survey app mainly targets job applicants who are actively giving interviews to understand how they are filling out applications and modifying their resume. The results of the poll helped 20 job seekers to tailor their resume in a way that increases their chances of getting interview calls. Gender based Topic Modeling for #MeToo tweets across the US [Tools: Python, Pandas, Scikitlearn, NumPy, Tableau]

• Analyzed 100K #metoo movement Twitter dataset to identify the different topics discussed among people in the US across various regions. Modeled a topic model on tweets using Empath and identified topics and issues discussed among men and women. Computed a regression model to investigate the impacts on the topic due to gender and region. Movie Recommendation Engine using Apache Spark [Tools: Python, Apache Spark, SQL]

• Designed and developed a customized collaborative filtering recommendation system. Analyzed the Spark Training dataset which consisted of 1,00,209 anonymous ratings are given by 6040 users for approximately 3900 movies. Built a predictive model using Python and recommended movies to users with similar interests. EZ-Pass Toll Management System [Tools: SQL, PL/SQL, OracleDB]

• Structured a normalized database for a toll management system. Customized different features using Oracle PL/SQL procedures, functions, and triggers.

EDUCATION

Master of Science, Information Systems Aug 2018 - May 2020 University of Maryland, Baltimore County GPA: 3.8

Bachelor of Engineering, Information Science Aug 2013 - Jun 2017 Visveswaraya Technological University GPA: 3.8

SKILLS

Languages: Python, C++, JavaScript

Tools/Frameworks: Django, Angular 5, React, jQuery, Web Service Frameworks (REST, SOAP, GraphQL), Bootstrap, Scikitlearn, NumPy, Pandas, Matplotlib, ETL Tools (SSIS)

Data Visualization: Tableau, PowerBI

Database: SQL, PL/SQL, Apache Spark, OracleDB, SQL Server, MySQL, MongoDB, PostgreSQL Other Tools: AWS, Linux, Git, API

Contact this candidate