Vamsi B.

Vamsi B.

BUSINESS DATA ANALYST

Boston , United States

Experience: 5 Years

Vamsi

Boston , United States

BUSINESS DATA ANALYST

120000 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Vamsi!

About Me

Hi

Hope you are doing great today

 

I came across the opportunity to work with you

I have a candidate with 5+ years of work experience

Please check the attached resume and below mentioned details

 ...

Please check the attached resume and below mentioned details

 

Name: Vamsi B

Email: tonytherecruiter3@gmail.com

Contact: 424-318-1501

Current location: Boston, MA

Relocation: Yes

Visa: F1 OPT

Contract: C2C

DOB: 08/05/1995

Years of experience: 5+

USA experience: 1 Year University research experience

Bachelor’s: Commerce, Data Analytics in Finance and Accounting - 2016

Masters: MBA and MS in Business Analytics - 2018 India, 2022 USA

SSN (Last 4 digits): 0624

Availability for interview: Any time

Availability for Project: Immediate

LinkedIn: https://www.linkedin.com/in/vamsi-bommisetti-50b56055/

 

Please call me to discuss more details

Contact: (424) 318-1501

Show More

Portfolio Projects

Description

Responsibilities:

  • Advanced core procurement to pay reporting to the vendors (P2P) & (O2C)
  • Co-ordinated quotation proposals to Amazon vendors and enhancing Vendor accounts
  • Budgeted quarterly Quit Claim reporting to adjust the vendor accounts and scale down escalations
  • Enhanced testing PROD activities of Vendor Central Web in a testing environment
  • Analyzed and reviewed payments via Oracle Financials Application in an agile manner
  • Regular interaction with Vendors for resolving the new VCW platform issues
  • Investigated and resolved the JIRA and Paragon tickets in a stake holder faced environment
  • Reported on accounting, financial, and tax compliances in IN region VCW invoices using XBRL
  • E-invoicing (QR based) entries as per the government rules and regulations (SQL for databases)
  • Automated paragon ticket execution which saved work of 11 FTs with no manual interaction
  • Actively participated in projects throughout their life cycle to train vendors on VCW-API
  • Assisted with recurring and ad hoc reporting requests, participated in month-end close activities
  • Experience with Dropship and Vendor Flex process developments
  • P&L reviews on stakeholder’s statements – Quitclaim vendor accounts
  • Designing, creating, and implementing BI solutions based on vendor data
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • Deep experience with the design and development of Tableau visualization solutions
  • Data blending implemented on databases and generated interactive dashboards using Tableau
  • Complied interactive dashboards in Tableau Desktop and published them to Tableau server which allowed story telling with Quick filters for on demand needed information.
  • Automated dashboards and work allocation for process improvement which saved 500 hours’ pa.
  • To verify tax data, Spot the PO-based invoices, implement invoice procedures, archive invoice data, and handle requests.
  • Assisting team members with analysis of accounts and contacting Internal and external vendors.
  • Invoice validation is done with PO reference, 3 way-match invoicing
  • Worked on Invoices that were in the Laserfiche repository for processing the payments
  • Performed operations like authorize, cancel, raise a defect or dispute, match REBNI with PO to ensure payments are released to vendors on time
  • Vendor data analysis using Business Intelligence to allocate the resources accordingly
  • Creating interactive visual reports using BI tools, finding correlations in data to discover meaningful insights
  • Created a custom Tableau Report Portal with SQL to show real-time usage and provide easier navigation
  • Updated BI database functions and implement new SaaS tools

Show More Show Less

Description

  • Worked with the equity researchers of the firm to obtain financial and non-financial data about different equity underlying
  • To predict the macroeconomic trends and gather information about specific sectors and economies
  • Imported historical data from Bloomberg into a proprietary database, forecast price levels, provide recommendations to the team
  • Operationalized business intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals
  • Created and maintained data visualizations that educated, informed, and engaged business partners on key metrics and performance measures
  • Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data, and develop integrated information delivery solutions
  • Presented and communicated the findings in an understandable and actionable way tailored to the audience and customer's needs using Power BI
  • Analyzed historical data to identify trends and support decision making, including written and verbal presentation of results and recommendations
  • Mining and manipulating data from database tables, simulation results, and log files
  • Converted data into digestible business intelligence and actionable information
  • Shaped and delivered key metrics, reports, and indicators by which Karvy business will assess its performance
  • Data consolidation and analysis, cost and revenue accrual, and provided full data source for accounting month-end closing
  • Service provider statement audit and reconciliation. Worked with operations team for cost verification and approval
  • Performed ad-hoc business analyses, and financial modeling. Presented recommendations to senior management on strategic decisions and planned future initiatives
  • Experience to build efficient, flexible, extensible, and scalable ETL and reporting solutions
  • Recognized and adopted best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
  • Tuned application and query performance using profiling tools and SQL

Show More Show Less

Description

  • Reviewing medical records to assess patient diagnoses and treatment plans
  • Assessing patients' health insurance coverage and claims to allocate resources appropriately
  • Collaborating with other medical professionals to develop new policies
  • Provided data analysis from both within and outside of the department
  • Maximized effectiveness of analysis, programming, and reporting using Power BI
  • Contribute to the building and management of the analytics infrastructure for the Advanced Research & Analytics (ARA) team
  • Facilitate the creation of complex statistical statements on healthcare data that measures various aspects of healthcare services, consumer episodes, and operational events
  • Collaborate with IT and business units to advance the company’s reporting capabilities and improve the accuracy of data
  • Applied healthcare business knowledge and key concepts in health insurance to develop routine and ad hoc analyses
  • Highly numerate, with a good understanding of dashboard design and experience communicating the result with visualization techniques using Tableau
  • Provided assistance for health care projects through SAS statistical and analysis software tools
  • Conducted independent statistical analysis, descriptive analysis, hypothesis testing, and logistic regression
  • Participated in critical review and revision of existing systems for updates and enhancements
  • Converted, cleaned, analyzed, organized, and documented large data files (10,000 - 2 million records) using SAS EG and SAS EM and then visualize outcomes using BI tools
  • Extracted, transformed, and loaded data utilizing Base SAS, and SAS ETL Studio. Responsible for analyzing health data and producing, verifying, and interpreting client reports with very little oversight.
  • Performing the analyses of health care data, including medical and pharmacy claims, membership files, and health advisory/coaching interaction, to better understand the quality and level of care delivered and measure the effectiveness of the organization's services as it relates to both clinical quality and financial returns

Show More Show Less