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 MoreSkills
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
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
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