Power Bi Reporting Analyst
Resume:
Anil Ohri
***** ***** **** ***** **** ***
San Diego CA 92128
Cell: 760-***-****
*****@*****.***
https://www.linkedin.com/in/anil-ohri/
Summary
●Results driven Business, Sales Data and Reporting Analyst with extensive experience in data analysis, sales reporting, and commission structures.
●Excellent interpersonal skills with a demonstrated ability to troubleshoot and communicate effectively.
●Expertise in leveraging tools like Xactly, Power BI, and Tableau to optimize compensation processes and enhance data-driven decision-making.
●Proven ability to troubleshoot complex systems, improve operational efficiencies, and collaborate cross-functionally. Adept at managing commission structures, performing UAT testing,
●Advanced Microsoft Access and Excel skills.
Skill Matrix
Category/Skills
Years of Experience
Rating (0-10)
Microsoft Office & Advance Excel
10 Years
10
Slack
3 Years
10
Salesforce
6 Years
8
Tableau
3 Years
7
PowerBI
3 Years
6
Slack
3 Years
10
SQL
5 Years
6
Professional Experience
LastPass - Boston, MA (Remote)
Sr. Sales Commission Analyst 11/2022 – 03/2025
●Managed global sales commission administration, ensuring timely and accurate payouts across multiple regions.
●Configured and maintained Xactly Incentive Compensation, troubleshooting errors and optimizing commission structures.
●Collaborated with Sales Ops; Finance; Revenue Operations teams on system implementation and integration (Salesforce and Xactly)
●Developed Power BI dashboards to provide real-time visibility into YTD sales and commission data for leadership.
●Conducted UAT and regression testing for new system enhancements.
●Strong Knowledge of Salesforce, Power BI and Excel.
Verisk Analytics - Carlsbad, CA (Remote)
Sr. Commission Analyst 08/2020 – 11/2022
●Improved and streamlined the calculation of sales commissions.
●Created both standardized and custom reports in Power BI. This includes creating Dashboard and reports in Power BI and publishing them online.
●Partnered with IT and created Reports using Salesforce and Power BI.
●Helped streamline, automate, and improve end-to-end commission processes.
●Created Business Requirement Documents (BRD).
●Managed Support escalations to IT and Sales Ops related to Salesforce and Power BI Projects.
●Assist in developing and delivering presentations for senior executives.
●Strong Knowledge of Data Visualization, Power BI, Excel, and Access.
Millennium Health - San Diego, CA (Remote)
Sr. Sales Commission Analyst 01/2020 – 07/2020
●Created both standardized and custom reports, conduct quantitative sales analysis, provide support for sales programs, assess future needs and ensure data integrity.
●Maintenance of daily, monthly, and quarterly sales reports.
●Created custom reports in Tableau.
●Strong Knowledge of Tableau, Excel, and Access
Kaiser Permanente - San Diego, CA
Business Analyst 12/2018 – 10/2019
●Worked to gather complex data from SharePoint and MS Dynamics.
●Acted as a Liaison between Covered California, Third Party Vendor and Kaiser.
●Critically evaluated information gathered from multiple sources, reconcile conflicts, decomposed high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
●Outstanding numeric, verbal, written, logic and analytical skills.
AMN Healthcare - San Diego, CA
Senior Commission System Analyst 06/2018 - 09/2018
●Worked with Finance to gather complex data from Hyperion and break it down to individual compensation plans.
●Analyzed and set up compensation plans to automate Commission Process.
●Downloaded the data from CORE and broke it down into Individual PDFs using automated software and Excel Add-ons.
●Worked with Project Manager and HR to implement the changes.
●Worked on streamlining, automate, and improving end-to-end commission processes.
●Strong Knowledge of Core Compensation, Excel, and Access.
Sempra Energy - San Diego, CA
Report Analyst 12/2017 - 06/2018
●Created HRIS reports.
●Implement changes in Crystal Reports by creating new connections to new databases.
●Perform User Acceptance Testing (UAT) and Regression Testing.
●Work with Business Owners and address their concerns.
DJO Global – Vista, CA (Hybrid)
Analytics Consultant III 07/2012-11/2017
●Supported in gathering, analysis, preparation, summary, and presentation of operational data results & trends.
●Supported business owners to analyze the root cause of trends and develop data-driven action plans.
●Compiled and managed various data sources inputs for commissions calculation software.
●Designed and executed SQL queries for commission calculations, error resolutions, and audit support.
●Conducted UAT and regression testing for new system enhancements.
●Created business intelligence reports using OBIEE and NOETIX to support finance and sales teams.
Education
Certification in Business Intelligence, UCSD Extensions – San Diego, CA
Bachelor of Science in Management Information Systems-San Diego State University – San Diego, CA
Contact this candidate