Kartik Rawat profile photo 1 on Tal

Kartik Rawat

Engineer II @ American Express | Business Analyst Profile | Power BI | SQL | Open to Product Roles

Gurugram

4+ years of work experience

American Express
Jan 20251 yr 6 mosPresent

Gurugram, Haryana, India

American Express is a globally recognised financial services company. I work within the Global Tax Technology team, delivering data and reporting solutions that support tax compliance operations across multiple international markets. ๐Ÿ”น Led global tax reporting operations across multiple international markets, delivering insights consumed by Amex business teams worldwide to support regulatory filings and financial decision-making ๐Ÿ”น Automated financial reporting workflows using SQL & Python, reducing manual effort by 75% ๐Ÿ”น Designed and deployed 10+ Power BI dashboards tracking accruals, bad debt and reconciliation metrics for finance & tax teams globally ๐Ÿ”น Optimised data models and SQL queries in BigQuery, improving dashboard load time by 40% ๐Ÿ”น Partnered with product owners to gather requirements and translate them into scalable reporting frameworks ๐Ÿ”น Developed and maintained ETL pipelines to streamline data ingestion and transformation ๐Ÿ”น Worked in an Agile environment with sprint planning via Rally; managed incident reporting through Jira
FlipRobo
Nov 20238 mosJun 2024

Bengaluru, Karnataka, India

๐Ÿ”น Cleaned and transformed large datasets to ensure accuracy and consistency for reporting ๐Ÿ”น Designed and developed interactive Power BI dashboards to visualise key business metrics ๐Ÿ”น Optimised data models and DAX measures to enhance dashboard performance ๐Ÿ”น Collaborated with cross-functional teams to translate business requirements into BI solutions
Amber
Jan 20238 mosAug 2023

Pune District, Maharashtra, India

AmberStudent is a global student accommodation platform helping international students find housing across the UK, US, Australia and beyond. ๐Ÿ”น Managed and analysed performance data for 200+ student accommodation listings across the UK market, monitoring booking conversions, pricing trends and customer behaviour ๐Ÿ”น Generated weekly and monthly reports to support stakeholder decisions on lead allocation, pricing strategy and market positioning ๐Ÿ”น Identified customer behaviour patterns that contributed to an ~18% uplift in regional booking conversions in Q2 ๐Ÿ”น Collaborated with product and marketing teams to improve service response metrics, contributing to a ~10% reduction in turnaround time ๐Ÿ”น Leveraged data insights to bridge the gap between sales operations and analytical reporting
Slake Kitchens
Dec 20211 yr 2 mosJan 2023

Bengaluru, Karnataka, India

Slake Kitchens was an independent cloud kitchen venture based in Bangalore, operating on Zomato and Swiggy. ๐Ÿ”น Managed end-to-end operations including supply chain, vendor management, staffing and P&L tracking ๐Ÿ”น Built Power BI dashboards to monitor daily orders, peak hours and campaign effectiveness, enabling data-driven decision making ๐Ÿ”น Leveraged Excel and Power BI to track inventory patterns, reducing operational waste by 35% ๐Ÿ”น Designed and executed local marketing campaigns, driving a 15% increase in delivery orders during high-demand periods ๐Ÿ”น Used data insights to forecast demand and optimise menu offerings for profitability
Captain Olive
Feb 202111 mosDec 2021

Bengaluru, Karnataka, India

Captain Olive is a QSR (Quick Service Restaurant) based in Bangalore, currently operating 3 outlets across the city. ๐Ÿ”น Managed day-to-day operations of the QSR, ensuring smooth and efficient functioning across all verticals ๐Ÿ”น Analysed operational and customer data to generate insights that improved overall business performance ๐Ÿ”น Managed staff, inventory and supplies while maintaining operational standards and customer satisfaction ๐Ÿ”น Implemented and monitored company policies and procedures to ensure consistency and quality ๐Ÿ”น Gained hands-on experience in F&B operations and data-driven decision making โ€” experience that directly informed the co-founding of Slake Kitchens

Education

PG Program, Data Science, Machine Learning & Neural Networks

DataTrained

20231 yr2024

Postgraduate Degree, Marketing and Operations Management

Jagan Institute of Management Studies (JIMS, Rohini Sector-5)

20192 yrs2021

Join Kartik and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Kartik Rawat on Tal

Headline

Engineer II @ American Express | Business Analyst Profile | Power BI | SQL | Open to Product Roles

About

Business Analyst by practice, problem solver by nature. I currently work at American Express, where I focus on global tax reporting operations, building dashboards, automating financial workflows, and translating complex business requirements into reliable data solutions for Amex teams across multiple international markets. My work sits at the intersection of data and business. I spend most of my time in Power BI, SQL, and BigQuery, but the part I enjoy most is understanding why a business needs something and figuring out the cleanest way to deliver it. What I bring to the table: ๐Ÿงฉ Turning complex datasets into structured, actionable insights โš™๏ธ Building automated reporting workflows that save teams hours of manual effort ๐Ÿค Collaborating with product owners and business stakeholders to define requirements ๐Ÿ”„ Designing scalable ETL pipelines and data models that teams can actually rely on ๐ŸŒ Supporting global operations across multiple international markets Currently exploring Business Analyst opportunities at product-based companies where data, product thinking, and impact go hand in hand. Outside of work, I travel. A lot. Because sometimes the best way to debug life is to change the location. โœˆ๏ธ

Location

Gurugram

Work experience

Business Analyst | Engineer II (Contract via IBM | Payroll: KGISL) at American Express, Jan 2025 - Present ยท 1 yr 6 mos, Gurugram, Haryana, India, American Express is a globally recognised financial services company. I work within the Global Tax Technology team, delivering data and reporting solutions that support tax compliance operations across multiple international markets. ๐Ÿ”น Led global tax reporting operations across multiple international markets, delivering insights consumed by Amex business teams worldwide to support regulatory filings and financial decision-making ๐Ÿ”น Automated financial reporting workflows using SQL & Python, reducing manual effort by 75% ๐Ÿ”น Designed and deployed 10+ Power BI dashboards tracking accruals, bad debt and reconciliation metrics for finance & tax teams globally ๐Ÿ”น Optimised data models and SQL queries in BigQuery, improving dashboard load time by 40% ๐Ÿ”น Partnered with product owners to gather requirements and translate them into scalable reporting frameworks ๐Ÿ”น Developed and maintained ETL pipelines to streamline data ingestion and transformation ๐Ÿ”น Worked in an Agile environment with sprint planning via Rally; managed incident reporting through Jira

Data Science Intern (via DataTrained PG Program) at FlipRobo, Nov 2023 - Jun 2024 ยท 8 mos, Bengaluru, Karnataka, India, ๐Ÿ”น Cleaned and transformed large datasets to ensure accuracy and consistency for reporting ๐Ÿ”น Designed and developed interactive Power BI dashboards to visualise key business metrics ๐Ÿ”น Optimised data models and DAX measures to enhance dashboard performance ๐Ÿ”น Collaborated with cross-functional teams to translate business requirements into BI solutions

Global Sales Associate at Amber, Jan 2023 - Aug 2023 ยท 8 mos, Pune District, Maharashtra, India, AmberStudent is a global student accommodation platform helping international students find housing across the UK, US, Australia and beyond. ๐Ÿ”น Managed and analysed performance data for 200+ student accommodation listings across the UK market, monitoring booking conversions, pricing trends and customer behaviour ๐Ÿ”น Generated weekly and monthly reports to support stakeholder decisions on lead allocation, pricing strategy and market positioning ๐Ÿ”น Identified customer behaviour patterns that contributed to an ~18% uplift in regional booking conversions in Q2 ๐Ÿ”น Collaborated with product and marketing teams to improve service response metrics, contributing to a ~10% reduction in turnaround time ๐Ÿ”น Leveraged data insights to bridge the gap between sales operations and analytical reporting

Founder & Operations Lead at Slake Kitchens, Dec 2021 - Jan 2023 ยท 1 yr 2 mos, Bengaluru, Karnataka, India, Slake Kitchens was an independent cloud kitchen venture based in Bangalore, operating on Zomato and Swiggy. ๐Ÿ”น Managed end-to-end operations including supply chain, vendor management, staffing and P&L tracking ๐Ÿ”น Built Power BI dashboards to monitor daily orders, peak hours and campaign effectiveness, enabling data-driven decision making ๐Ÿ”น Leveraged Excel and Power BI to track inventory patterns, reducing operational waste by 35% ๐Ÿ”น Designed and executed local marketing campaigns, driving a 15% increase in delivery orders during high-demand periods ๐Ÿ”น Used data insights to forecast demand and optimise menu offerings for profitability

Organization Manager at Captain Olive, Feb 2021 - Dec 2021 ยท 11 mos, Bengaluru, Karnataka, India, Captain Olive is a QSR (Quick Service Restaurant) based in Bangalore, currently operating 3 outlets across the city. ๐Ÿ”น Managed day-to-day operations of the QSR, ensuring smooth and efficient functioning across all verticals ๐Ÿ”น Analysed operational and customer data to generate insights that improved overall business performance ๐Ÿ”น Managed staff, inventory and supplies while maintaining operational standards and customer satisfaction ๐Ÿ”น Implemented and monitored company policies and procedures to ensure consistency and quality ๐Ÿ”น Gained hands-on experience in F&B operations and data-driven decision making โ€” experience that directly informed the co-founding of Slake Kitchens

Education

PG Program, Data Science, Machine Learning & Neural Networks, DataTrained

Postgraduate Degree, Marketing and Operations Management, Jagan Institute of Management Studies (JIMS, Rohini Sector-5)