Data Analyst Sales

Masoom Badhwar

**** **** ******,*** *****,CA ****5 520-***-****

Email: *******.******@*****.***

OBJECTIVE

Motivated professional seeking a analyst position to utilize my experience and skills to contribute towards company’s success.

WORK EXPERIENCE

Medimpact HealthCare Syestems Inc, San Diego, CA June 2018 – December 2018

Business Analyst/Data Analyst

Applied pharmacy, formulary and benefit configuration to effectuate change as specified in submitted change requests. Ensures assigned due dates for submitted change requests are met

Performs research and Troubleshoots on claims adjudication issues or inquiries

Acquired a thorough understanding of MedImpact system logic for claims adjudication, system constraints, conflicting benefit logic configurations, benefit coding table designs, plan – group – pharmacy carrier to benefit linking, to ensure proposed design satisfies the intended solution

Ensured consistent customer satisfaction through consultation and collaboration with internal business partners to ensure that business requirements for submitted change requests are clearly understood, documented, developed, communicated, tested, and delivered flawlessly

Used standardized methodology to ensure that appropriate rationale exists for non-standard designs and that all efforts are undertaken to prevent inefficient and non-sustainable configuration structuresQueried relational databases using SQL on a daily basis to resolve operational issues and assist business and IT in a better understanding of business requirements.

Reviewed results of in-unit testing in order to validate new plan configurations

Assisted in creating and maintaining documentation of clients’ plan designs, detailing any custom maintenance processes and configuration best practices. Includes documentation of adjudication hierarchies, edits, restrictions, tables, carriers, and other configuration components

Utilized project planning, prioritizing, and organizational skills to ensure timely deliverables, high levels of quality, and efficient use of resources to achieve claims adjudication accuracy

Ensured appropriate back up coverage for customers during holidays, weekends, and other times.

Data Analyst at COMPUTER MARKET RESEARCH, San Diego, CA Feb 2016 – Feb 2018

Prepared analysis and status reports for Point-Of-Sale, Inventory Management, Deal Registration, Co-op/MDF management

Mentored new analysts with growing knowledge of the channel and business practices.

Client interaction on a regular basis and manage any issue escalation by coordinating with the respective teams to provide customer satisfaction.

Extensively used advance Excel functions and formulas for data integrity (VLOOKUP/MATCH)

Extensive SQL use for data management from quality checks to analyzing data.

Queried relational databases using SQL on a daily basis to resolve operational issues and assist business and IT in a better understanding of business requirements.

Provided general and highly detailed Trend Analysis based on current market conditions and clients input for inclusions in the Sales Presentation.

Transformed and analyzed raw data from partners to meaningful data for clients.

Analyzed market trend reports, identifying abnormal spikes and Y-o-Y trends.

Maintained clients’ databases on SQL Server, users’ securities, and business rules.

Prepared, reviewed, and distributed weekly and monthly client invoicing reports.

Developed complex reports using advanced Excel techniques to meet management and client needs.

Worked with large data sets to import files; performed data auditing and consolidation.

Functional testing and user acceptance testing

End user training and strong meeting facilitation skills

Audited, enhanced and maintained existing code in Excel/VBA.

Account Manager at SUBWAY, San Diego, CA Jul 2015 – Feb 2016

Performed Point of Sale system/cash register to record the order and compute the amount of the bill. Collected payment from guests and make changes

Prepared monthly and yearly sales reports –Control sheet & Weekly inventory sales report (WISR)

Performed Cash-In Procedure-accounting for all forms of Finances and inventory

Prepared and interpreted financial and operational reports and schedules, analyzed data and developed solutions to ensure operating goals are achieved

Provided customers with technical support using maintenance procedures created with company products

Wrote and kept accurate records of discussions and correspondence with customers

Managed and supervised a team of customer services representatives

Directed restaurant operations with responsibility for guest service, brand standards execution and employee training

Handled communication directly with vendors by phone, electronically or face to face

Technical Analyst at University of Arizona January 2015 – June 2015

Identified inconsistencies in daily operations, corrects the inconsistency or escalates the problem to the next level according to technical operations protocol.

Provided support in data life cycle development, including Data Acquisition, Data Cleaning, Data Manipulation, Data Validation, and Data Visualization (Pivot Tables).

Responsible for preparing Test Cases for module, integration and system testing.

Involved in preparing Test Data’s for the test cases

Collaborated with data analyst and business system analyst about discrepancies in data.

Understanding of SDLC phase, Agile and Waterfall methodologies.

Worked with SQL Server databases. Skilled in SQL, Microsoft Office Suite

TECHNICAL SKILLS

Tools: MS Office Suite, Visual Studio, Excel, PowerPoint, SQL Management Studio,

Operating Systems: MS Windows, iOS, Linux, Windows XP, Vista, 7, 8, 10.

Databases: MS Access, MS SQL Server

EDUCATION

MDU University, Haryana, INDIA – Bachelors in Business and Technology (B.TECH)

COMMUNITY SERVICE

Worked as a President and volunteer in “Go Green” and “Women Empowerment” and innovated the programs to further enhance and enlarge the scope of the “Basic Alphabet Recognition for Slum Resident Adults”.

WORK AUTHORIZATION

Permanent Resident (Green Card) authorized to work for any employer in the USA.

Contact this candidate