Pinal Patel
Sr. Business/ Reporting Analyst at Benzer Pharmacy- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
Topline Score
Bio
Experience
-
Benzer Pharmacy
-
United States
-
Retail
-
100 - 200 Employee
-
Sr. Business/ Reporting Analyst
-
Jul 2016 - Present
• Ad-hoc data analysis, prepare scheduled reports to assist the Top management (President, COO, CFO) and other stakeholders to seek answers to the business questions and help them to take long term and short-term decisions.• Analyzing requirements, meeting with different market leaders to identify provider gaps.• Working with cross-functional team leaders to prioritize work that are in pipelines, set expectations.• Working on artifacts such as BRD, FRD, Requirement Traceability Matrix (RTM).• Data ingress, Data egress, Analyze data for various department reports.• Processing confidential data and information according to CMS guidelines.• Modifying SQL queries, Store Procedures, ETLs.• Conducting/facilitating prioritize releases, planned release and release scopes.• Extracting data from multiple systems and joining tables using SQL JOINS e.g. joining Payments received data with data provided by various Insurance companies for underpaid claims using unique Store codes and Prescription numbers.• Looking up data from multiple Excel tables using functions like VLOOKUP, INDEX-MATCH and summarizing data using Pivot Tables.• Represent organization in onsite and client site meetings, document meeting outcomes, and coordinate all internal and external follow-ups to action items, issues in support of the project.• Managing and designing the reporting environment, including data sources, security and metadata.• Supporting the Data Warehouse in identifying and revising reporting environment.• Providing technical expertise on data storage structures, data cleansing.• Generating reports from single or multiple systems.• Training end users on new reports and dashboards.• Analyzing under paid claims and provide appropriate solution.• Keeping a tab on metrics like Generic vs Branded ratio, ordering vs Billing etc. Show less
-
-
Business Analyst
-
Jun 2015 - Jul 2016
-
-
-
SKP Group
-
India
-
Business Consulting and Services
-
200 - 300 Employee
-
Business Analyst
-
Apr 2011 - Sep 2013
• Worked closely with key Stakeholders to identify, analyze the core requirements and key features of the ongoing projects analyzing under paid claims and provide appropriate solution. • Designed the artifacts for business requirement based on the project scope and SDLC methodology. • Facilitated user interviews, workshops to gather requirements and analyzed the requirements using Visio, Power Point. • Developed business requirement document (BRD) with project teams. Extracted, discussed and refined business requirement from business users and team members. • In conjunction with the Project Manager and Solutions Architect, prepare implementation document and present progress reports to clients in order to keep them current on the project status. • Worked with Business Units to recommend solutions for business needs. • Single point of contact for project status. Maintains communication with various key stakeholders and requirements along with delivery of product implementations. Show less
-
-
-
Pinellas County Government
-
United States
-
Government Administration
-
700 & Above Employee
-
Teacher
-
May 2010 - Apr 2011
• Serve as a role model in order to encourage appropriate behavior. • Write anecdotal notes, lesson plans other reports in order to monitor child development and to keep a record of classroom events relating to specific children. • Teach self-help skills (hand washing, restroom habits, etc.) • Provide educational activities and assistance to children with special needs. • Participate in classroom programs in order to develop fine and gross motor skills. • Attend various conferences, trainings and workshops as assigned by management. Show less
-
-
-
United Community Housing Coalition
-
United States
-
Non-profit Organizations
-
1 - 100 Employee
-
Case Worker
-
Sep 2008 - May 2010
• Develop an assessment profile of members. • Provide scheduled data reports of activities to Community Services Manager. • Counsel members with social issues. • Complete all paperwork in order to ensure proper assistance to members. • Help member qualify for government program such as Medicaid, Food Stamps, last minute shelters and food banks. • Educate members on how to become self-sufficient and/or independent by providing them job openings and helping them prepare for interviews and building resumes. • Continue making suggestions if needed to the members. • Performed other duties as assigned. • Data entry in the NJ HMIS HUD program. Show less
-
-
Education
-
Montclair State University
Bachelor of Arts - BA, Family and Child Studies