Bilal Mayan
Summary
Accomplished Strategic Pricing Technical Analyst with a proven track record at Kelley Drye and Warren LLP, enhancing data-driven decision-making through advanced Power BI report building and effective project management. Excelled in developing pricing strategies and analytics programs, achieving a 300 Maturity Level under Microsoft Standards. Skilled in SQL and adept at collaborating across departments to promote firm-wide growth.
Overview
3
3
years of professional experience
Work History
Strategic Pricing Technical Analyst
Kelley Drye and Warren LLP
05.2022 - Current
- Developed budgets for new and existing client matters across all practice groups.
- Assisted in the development of a pricing budget Power App, collaborating with a consulting firm for data transition and MVP, UAT testing.
- Accelerated the development of the Analytics program, reaching a 300 Maturity Level under Microsoft Standards.
- Created queries from SQL implemented as T-SQL into data flows, connecting to various data sources for reporting.
- Begun developing metrics and KPIs both in excel and SQL based off historical data.
- Presented data findings through Power BI reports to key stakeholders, including Partners and C-Suite executives.
- Developed a Power BI environment which includes dataflows, datasets, reports, dashboards, and apps.
- Promoted the value of data to encourage firm development.
Pricing Coordinator
Leviton Manufacturing
08.2021 - 05.2022
- Reviewed and approved/declined quotes based on margin guidelines.
- Explored Power BI to create reports analyzing tariff increases.
- Maintained pricing programs by implementing additional guidelines.
- Achieved optimal pricing accuracy by collaborating with sales, marketing, and finance departments.
- Assisted in the drive of promotional pricing plans by relaying financial benefit.
Education
Bachelor of Science - Business Administration
SUNY Farmingdale
Farmingdale, NY06.2021
Skills
- Data Analysis
- Project Management
- Business Intelligence
- Product Development
- Data Collection Monitoring
- Trend Analysis
- Data Integrity
- SQL (2/5)
- Power BI Report Building (4/5)
- Data Modeling (2/5)
- DAX Language (2/5)
- Power BI Service (3/5)
Timeline
Strategic Pricing Technical Analyst
Kelley Drye and Warren LLP
05.2022 - Current
Pricing Coordinator
Leviton Manufacturing
08.2021 - 05.2022
Bachelor of Science - Business Administration
SUNY Farmingdale
Similar Profiles
JANANI KAMESWARANJANANI KAMESWARAN
Administrative Assistant at Kelley Drye & WarrenAdministrative Assistant at Kelley Drye & Warren
TAYLOR BOLEYTAYLOR BOLEY
Office Manager/Legal Assistant at Clemens Warren LLPOffice Manager/Legal Assistant at Clemens Warren LLP
Jamie DryeJamie Drye
Founding Artistic Director at Drye/Marinaro Dance CompanyFounding Artistic Director at Drye/Marinaro Dance Company
Kellen LittleKellen Little
Sr Strategic Pricing Analyst at Tyson FoodsSr Strategic Pricing Analyst at Tyson Foods
Carlos RojasCarlos Rojas
Strategic Sourcing and Pricing Analyst at TATA CONSULTANCY SERVICESStrategic Sourcing and Pricing Analyst at TATA CONSULTANCY SERVICES