Administrative Assistant Sales

Hakita Grewal

916-***-**** *********@*****.***

EDUCATION

Bachelors of Business Administration Degree January, 2004

National University, Sacramento, CA

WORK EXPERIENCE

Business Analyst

Hewlett Packard Enterprise November, 2016 - Current

Document, troubleshoot and track isolated issues for Service Request (SR) tickets and take proper steps to ensure timely resolution

Create test scenarios or test plans, and translate them into Integration test scripts

Develop visualization, user experience and configuration elements of solution design for user issues

Work collaboratively with development team, project managers to prioritize and ensure application backlog and release deliverables are accurate and on schedule

Provide input to IT team for modifying systems to meet client needs and develop business specifications to support modifications.

Prepare test reports for the end client which includes summary of test client correspondence issues, execution status, detailed test results, test steps with artifacts, defect logs and generate reports from Application Lifecycle Management (ALM) for each project

Act as a liaison between client and technical support group to document, analyze and validate client requirements

Insurance and Benefits Services Coordinator

Peace Officers Research Association August, 2011- November 2016

Design, develop, modify and test reports to support business needs and member account management

Interpret and analyze subscriber health plan change reports for efficient reporting platform

Complete, verify, and process forms and documentation for administration of benefits for Anthem Blue Cross PPO medical insurance and MediCare prescription plan

Work with CalPERS and Anthem Blue Cross to research cause of member and health plan coverage issues and communicate improvement recommendations

Attend open enrollment meetings and present, create and distribute benefit plan descriptions and notices in compliance with legal and regulatory requirements

Analyze and audit daily and monthly enrollment reports to confirm membership status

Mail out monthly audit letters, and follow up on outstanding issues pertaining to the letters

Provide support to the insurance and benefits manager and prepare reports, correspondence and materials for monthly Trust meetings as needed

Disability Claims Evaluation Analyst

State of California September, 2008 – August, 2011

Adjudicated State Disability and supplemental Social Security Income claims

Established and organized claim files, monitored calendars in order to meet deadlines

Managed caseload of over 100 claims and took proper steps for timely closures and outcome

Reviewed and summarized medical records and made recommendations for the medical consultant

Prepared long term disability benefits reports

Analyzed medical and vocational information to provide documentation and written reports on decisions

Communicated with claimants and vendors to obtain necessary information

Maintained dedication to meeting expectations and requirements of internal and external customers

Actively participated in analyst meetings and training

Gathered data and conducted studies to recommend new procedures for training

Business Program Analyst

Delta Dental of CA May, 2004 – September, 2008

Prepared and evaluated reports, statistical data to track history trends and achieve federal contractual standards for the TRICARE Retiree Dental Program

Coordinated and managed projects directed toward strategic business and organizational objectives

Conducted project performance, status reporting and progress measurements by collecting tester input

Reviewed data output in order to identify trends

Responsible for researching and developing policies, procedures for process improvement

Independently researched and determined disposition of claims, refunds and over billing

Demonstrated diplomacy and tact to effectively avoid or diffuse high-tension situations

Provided first level of escalation and assist in providing mentoring and coaching

Prepared and delivered training materials to provide functional guidance to Call Center staff

Assisted in preparing for the federal contract with the Department of Defense for the dental program

Sales and Marketing Administrative Assistant

ML Stern, LLP September, 2002 – April, 2004

Assisted with scheduling, invitations, materials and organization of client seminars

Gathered product and current information for sales and marketing pieces

Demonstrated professionalism and established credibility when interacting with customers to enhance the company’s reputation in the marketplace

Clearly explained complex and technical information to assist customers

Organized the details of special events and travel arrangements and meetings

Successfully created and prepared sales and marketing brochures

Completed daily, weekly and monthly investment reports

Performed other routine administrative functions such as faxing, filing, scanning, copying and mailings

Skills and Qualifications

Over Ten years of experience in health and dental insurance, claims management and client support. Proficient in MS Office including Access, Word, Excel, Outlook and Power Point. Skilled in the ability to create, modify and execute detailed spreadsheets and reports with moderate to advanced queries. Good Understanding of SDLC [Software Development Life Cycle] and STLC [Software Testing Life Cycle] Experience to work in Test Management tools, currently in training to work in agile, V model and Waterfall methodology. Hands on Experience in Test Automation tools (QTP, Selenium) and execution test case, Web Services add-in for performing SOAP API testing for conducting UI frontend content verification with XML schema structure. Working knowledge of Oracle and SQL databases, understanding of data analysis and the interpretation of data with the ability to communicate outputs. Ability to multi-task effectively and efficiently. Excellent verbal and written communications skills.

Contact this candidate