Hemant S.
Salesforce Administrator at Third Estate Ventures- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Salesforce Certified Platform Developer I
SalesforceJul, 2023- Sep, 2024 -
Salesforce Certified Administrator (SCA)
SalesforceApr, 2023- Sep, 2024 -
Google Data Analytics Certificate
CourseraFeb, 2023- Sep, 2024 -
Create Views and Dashboards
TableauNov, 2022- Sep, 2024 -
Insights from Data with BigQuery
Google Cloud Skills BoostOct, 2022- Sep, 2024 -
Connect to and Transform Data
TableauSep, 2022- Sep, 2024 -
Oracle Cloud Platform Application Integration 2021 Certified Specialist
OracleApr, 2022- Sep, 2024 -
Oracle Cloud Infrastructure 2021 Foundation Certificate Associate
OracleNov, 2021- Sep, 2024
Experience
-
Third Estate Ventures
-
United States
-
Civic and Social Organizations
-
1 - 100 Employee
-
Salesforce Administrator
-
Feb 2023 - Present
• Collaborated with a non-profit team of 7 to spearhead a community mobilization initiative in Downtown Buffalo aimed at addressing various local concerns. • Utilized Salesforce Data Loader to efficiently import and update data gathered on downtown Buffalo residents, encompassing assets like retail, non-retail, and rental units. • Developed a customized screen flow within Salesforce to automate email communications, enabling the sending of targeted emails to specific individuals or groups. • Designed and implemented a tailored questionnaire page layout in Salesforce, enabling automatic population of answers into custom objects and records, facilitating efficient data capture and management. Show less
-
-
-
Primary Care IPA
-
Hospitals and Health Care
-
1 - 100 Employee
-
Data Analyst
-
Aug 2022 - Dec 2022
• Analyzed the data of the Primary IPA, provided data insights on the practices of three pediatric clinics: Delaware Pediatrics, Wheatfield Pediatrics, and WNY Pediatrics, using Tableau, MySQL server. • Utilized advanced data analysis techniques to identify trends and patterns in healthcare data, enabling the development of targeted interventions to improve patient outcomes and reduce costs. • Studied the data on the providers who prescribe non-preferred drugs and the total number of scripts they prescribed. •Developed an Improvement Opportunity Plan (Triple Aim) to reduce the rise of missed annual visits by 150% to 200%, minimize gaps in care, and reduce specialty referrals. •Implemented an appointment reminder system that costs $32 for 4,000 SMS messages per month. Hiring a public health social worker for each practice would cost roughly $60,000 per year. • Prepared and modeled data to provide practical recommendations for reducing healthcare costs and accelerating the transition to value-based care. Show less
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Associate Software Engineer
-
Sep 2021 - Jun 2022
• Developed and tested a real-time integration workflow in Oracle Integration Cloud for the UK Government project (UKHSA) for seamless supply of Covid-19 health kits. • Orchestrated data from a secure FTP endpoint to ERP Cloud by using the orchestration pattern in Oracle Integration. •Worked on bidirectional integration with Salesforce.com and E-Business suite using Salesforce adapter, mapping to and from business objects. •Performed Salesforce Object Search Language (SOSL) search operation against business objects fetched from the Salesforce application. • Integrated various data migration models to facilitate FBDI files and ensure that the integration is working as expected and to identify any issues that may arise. • Worked on App driven and scheduled orchestrations between SaaS to SaaS or on-premises systems. • Performed SELECT, INSERT, UPDATE, MERGE operation in oracle ATP database table to filter and retrieve specific information based on business requirements. Show less
-
-
Education
-
2022 - 2023
University at Buffalo School of Management, The State University of New York
Master's, Management Information Systems, General
Community
