Surya Teja Valmiki

United States

@vsurya699

Badges

Sql

Certifications

vsurya699 has not earned any certificates yet.

Work Experience

  • Data Analyst

    Merck•  February 2023 - Present•  NJ

    Developed an ML-based patient risk prediction model using Sage Maker on AWS, with an AUC of 0.82, enabling targeted early interventions. Use Agile Methodology to implement project life cycles of reports design and development. Work on data cleaning, data visualizing, and data mining using SQL/ Python/ R. Generating various capacity planning reports (graphical) using Python packages like NumPy, Pandas, matplotlib, and ggplot2. Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping. Responsible for interacting with the business analysts and the business partners to identify information needs for the business requirements for DAR. Monitor, Triage, Track, and resolve issues with the Excel Power BI reports. Installed and configured on-premises gateway in Power BI services. Involved in Facets System implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and extensions, Load and Extraction programs involving HIPPA 835 and proprietary format files and reports development. Worked in importing and cleansing of data from various sources like AWS Redshift, Teradata, SQL Server with high volume data. Worked with the ETL specialists to migrate data into DWH & involved in data modeling. Responsible for checking member eligibility, provider enrollment and member enrollment for the Medicaid and Medicare claims. Created naming convention files and co-coordinated with DBAs to apply the data model changes.

  • Data Analyst

    E2E Infoware•  July 2019 - May 2021•  India

    Activating lease contracts to generate invoices for customer payments in a system, Pyramid. Handling review calls with front-end customers on process updates. Being involved in the quality check process for peers. Work closely with the deal desk team and other business partners like corporate systems ops and finance, to ensure accurate quotes and contracts are quoted and booked. Involved with various customers for the quick resolution of pending deals or orders; preparing operational metrics for the process. Worked on administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group. Worked on yearend activity for Database audit and performed year end activities for Business Panorama. Maintaining relationship with clients to achieve quality service norms by resolving their service-related critical issues. Handling escalation cases in SFDC (VM Star Application of VM Ware) with quality. Preparing control reports for the team and self are accurate.

Education

  • Arizona State University

    Master in Information Technology•  August 2021 - May 2023•  CGPA: 3.48

  • SRM University

    Bachelor in Computer Application•  August 2016 - June 2020•  Percentage: 72.55

Links

Skills

Windows XP
UNIX
SVN
GIT
MS Project
Excel Spreadsheets
SharePoint
Salesforce
JIRA
Mercury Quality Centre
Confluence
DB2
Teradata
MS SQL
MongoDB
NO SQL
Azure data bricks
Azure data lake
Python
SQL
R
PySpark
SAS
COBOL
PL/SQL
HTML
JSON
JavaScript
Java