Anil Tak Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

- Market Benchmarking: Aligned Expedia's compensation with prevailing market standards across 55 countries. Conducted in-depth analyses of multiple compensation anchors to inform strategic decisions.- Compensation Guidelines: Developed and implemented diverse models to formulate comprehensive compensation pay ranges globally, encompassing Job Families, levels, and countries.- Annual Review Cycle: Integral in designing and implementing Annual Review cycle models, incorporating varied budgeting approaches and performance-based merit rewards aligned with market standards and country-specific growth rates. Established models mirroring budget and actual spends at both individual and organizational levels.- Equity Analysis and Cost Savings: Played a pivotal role in creating reporting tools for thorough equity analysis presented to the Expedia Board. Identified cost savings through target equity rebalancing.- Automated Salary Recommendations: Engineered automated tools for salary recommendations, analyzing compensation across different countries/zones, same and next-level pay ranges, individual and peer group compensation ratios, among other factors.- Dashboard Creation: Ideated and developed multiple dashboards using Tableau and Excel, widely utilized by the global compensation team. These dashboards include a data governance tool, comp spend dashboard, market competitiveness dashboard, annual compensation review dashboard, equity analysis, and more.

Noida Area, India

- Managing the data analytics teams- Creating detailed analysis and dashboards over Tableau & Power BI- Leading a team of BI developers/ analysts, and work on developing reports & dashboards, data transformation and workflows, and integrate them in existing reporting packages- Managing and ensuring the quality standards of the outputs generated though close review process and guiding and mentoring of the overall team members- Working as a Team Leader, primary responsibility includes, regular connect with multiple stakeholders, to understand project objectives, scope, and deliverables- Technical Expertise: : Eliminating manual reporting to automated VBA macro driven reports : Create robust SQL data querying, ETL transformation, and Tableau visualization processes

Gurgaon, India

- Responsible of creating detailed analysis including MoM & YoY performance analysis, product/market/regional analysis, predictive analysis and re-forecasting reports- Providing analytical insights through Tableau, Miscrosoft Access, BI, etc.- Building database workflows on Alteryx.- Converting manual excel reporting & data manipulation to systematic automated processes.

Gurgaon, India

- Developing visualized data trends and dashboards through Tableau- Monthly & Quarterly Reports insights & dashboard preparation for the Stakeholders- Automating Reports with Access & Excel Macros, and building data workflows & transformation over Alteryx- Developed Excel based VBA tools to automate tasks involved in Financial Analysis- Managing and ensuring the quality standards of the outputs generated though close review process and guiding and mentoring of the overall team members

Gurgaon, India

- Engaged in Social Media Marketing, Social Media Tracking & Analysis- Working over the Social Media Keyword Generation & Leads Generation for new projects.- Creating and maintaining database by leads & report generation

Gurgaon, India

- Creating & maintaining database by leads & report generation.- Training and mentoring the team- Keeping a quality check on their productivity- Process automation through VBA/Macros- Data extraction and User Interface Development on MS-Access- Coordinating with sales & other project teams for smooth flow of marketing operations.- Working Knowledge of various social networks like Facebook, Twitter, LinkedIn, Hoovers, ZoomInfo and others.

Mba, Finance & Marketing

Activities and Societies: . .

B.Com (Hons.) Bfe, Economics & Finance

School