Gaurav Kalra
Allen,Texas
Summary
Experienced technology professional with over 12 years in the industry. Proven expertise in implementing and managing a broad spectrum of data-related projects and portfolios. Skilled in ETL (Extract, Transform, Load), process automation, data analytics, data wrangling, and data visualization using variety of industry-standard tools. Comprehensive experience in all phases of the project lifecycle (SDLC) and product management using agile methodology.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Manager, Technology Consulting
Deloitte Tax
02.2022 - 12.2024
- Partnered with clients to deliver integrated technology solutions including automation, data wrangling and analytics, enabling tax and legal departments to achieve significant operational efficiency gains
- Led cross-functional collaboration with clients, external vendors, and IT teams to gather requirements, perform feasibility analyses, and execute implementation strategies
- Oversaw multiple projects through all phases of the project lifecycle, leading teams of consultants and senior consultants, setting objectives, prioritizing and managing backlogs and ensuring issue resolution
- Managed product delivery for tax automation tool for a retail client, orchestrating requirement gathering, sprint planning, backlog refinement and release roadmaps in an Agile environment
- Conducted product demonstrations and presentations to clients, executives, and other stakeholders and gathered feedback
- Configured and maintained tax engines (Avalara and OneSource) including custom rules for accurate tax calculations for clients
- Implemented data analytics using Alteryx, VBA, and SQL to extract GL data from ERP systems (Oracle Fusion, SAP) and built automations around tie outs, payment reconciliation, adjustments, and filing to automate the sales and use tax (SUT) compliance process
- Ensured seamless integration and optimal performance of automated solutions by managing UAT testing and reviewing test plans
- Served as Subject Matter Expert (SME) for tools, providing guidance, support to the users and conducted business testing
- Performed project management tasks like creating work plans, milestones, tracking budgets, status reports, and reporting to leadership
- Led the analysis of inventory data for a large retail client and built Alteryx-based automation tools to assign tax codes for over 300k items, reducing manual effort by 40%
- Developed automated testing for 3K retail stores across authorities, simulating point-of-sale tax calculations and generating validation statistics, saving over 60% manual effort
- Automated Sales and Use Tax (SUT) compliance processes, achieving a 40% cost reduction and improving operational efficiency, quality, and management visibility
- Implemented data analytics for ERP data extraction, cleansing, and transformation, improving accuracy using Alteryx, VBA, and SQL
- Managed and developed solutions for tax processes (e.g., Book to Tax) leveraging MS Power Apps, Power Automate, and Power BI
- Mentored and coached team members, promoting professional development and best practices in data analysis and process automation
Senior Business Data Analyst
Ernst & Young
08.2015 - 02.2022
- Identified business process automation opportunities for various Tax Services within EY EDGE, contributing to architecture design, technology strategy, and feasible solution development
- Led large-scale data automation projects, leveraging Alteryx, SQL, Power BI, and cloud-based tools to streamline business processes
- Identified and implemented business process redesign opportunities across tax services, improving operational effectiveness and decision-making
- Spearheaded the design of a SQL-based data repository for multi-client engagements, improving data accessibility and accuracy
- Built scalable ETL solutions to ensure end-to-end data quality, reducing attribution errors and cost overruns
- Partnered with cross-functional teams to manage requirements gathering, scope definition, and project execution while adhering to tight deadlines
- Experienced Data Analyst
- Managed data operations for multiple clients by building ETL solutions, ensuring data quality, and analyzing KPIs for Business Incentives and Tax Credits (WOTC, ACA, HDZ)
- Automated ETL processes and reduced attribution errors and costs by developing tools using SQL, MS Access, SSIS, Power Query, Power BI, and Alteryx Designer
- Directed UAT for various tax calculators by interpreting functional requirements, creating test scenarios, managing a team of testers, and delivering progress updates in an agile environment
Business Intelligence Intern
MedeAnalytics
05.2014 - 08.2015
- Documented business requirements and analyzed mapping documents, data dictionaries, and site builds to extract, clean, and transform unstructured healthcare data for business reporting
- Set up, created, and maintained HP Vertica database clusters and servers for production and staging environments, supporting Big Data operations
- Managed ETL processes for scheduled data imports, and developed OLAP cubes, dimensions, and metrics to generate detailed and summary reports using SSAS
- Defined and implemented database and platform-level security protocols for various end-user roles
- Developed and configured SSRS reports for online platforms using XML configurations
- Assisted with Quality Assurance (QA) to ensure performance and accuracy of deliverables during the site development phase
- Created dashboards, tracked project progress, and implemented Agile project management methodologies using JIRA
Software Engineer
Accenture
06.2011 - 07.2013
- Worked as an Oracle PL/SQL Developer across multiple clients, contributing to various phases of the SDLC (Software Development Life Cycle)
- Enhanced and maintained a customized data auditing application for a major retail client by improving procedures and packages for system integrations
- Collaborated with architects to gather business requirements, document functional and technical designs, and develop or modify validation modules and interfaces
- Created test specifications, defined test scenarios, provided UAT support, and trained the production support team to manage post-deployment issues
- Managed production deployments, ensuring SOX compliance, data security, and resolution of application dependencies
Education
Master of Science - Information Technology Management
The University of Texas At Dallas
Richardson, TX, USA05-2015
Bachelor of Technology - Computer Science & Engineering
Amity University
Noida, India05-2011
Skills
- Reporting Tools/Suites: Alteryx Designer, Power Platform (Power Automate, Power BI and Power Apps), Tableau, Decisions
- Languages/Database Technology: MS SQL, Oracle PL/SQL, MS Access, MS Azure (Cloud), VBA, Java
- Web Technologies: HTML, XML, CSS, JavaScript
- Tax Engines: Avalara and OneSource
- Other Tools: SSMS, SSIS and SSRS, MS Office (Word, PowerPoint, Access), MS Excel (Macros, Pivot Tables), Microsoft Visual Studio, MS Power Query, Google Analytics, MS SharePoint, SAP GUI, MS Visio, Lucid Chart
- Project Management: Agile/Scrum methodologies, Azure DevOps, JIRA, MS Project
Certification
- SAFe Product Owner/Product Manager
- Certified Scrum Product Owner (CSPO)
- Alteryx Designer Core Certification
- Avalara Certified Implementation Expert
- Alteryx Designer Advanced Certification
- UiPath Process Mining (2021)
Languages
Hindi
Native or Bilingual
English
Native or Bilingual
Timeline
Manager, Technology Consulting
Deloitte Tax
02.2022 - 12.2024
Senior Business Data Analyst
Ernst & Young
08.2015 - 02.2022
Business Intelligence Intern
MedeAnalytics
05.2014 - 08.2015
Software Engineer
Accenture
06.2011 - 07.2013
Master of Science - Information Technology Management
The University of Texas At Dallas
Bachelor of Technology - Computer Science & Engineering
Amity University
Similar Profiles
Thara CharlyThara Charly
US Tax Consultant II at Deloitte tax Services India Pvt. Ltd. (Deloitte U.S-India Offices)US Tax Consultant II at Deloitte tax Services India Pvt. Ltd. (Deloitte U.S-India Offices)
SWETA JENASWETA JENA
Tax Consultant-II at DELOITTE TAX SERVICES LTDTax Consultant-II at DELOITTE TAX SERVICES LTD
Christopher Chris WalkerChristopher Chris Walker
Senior Tax Consultant at Deloitte Tax LLP (Dallas Office)Senior Tax Consultant at Deloitte Tax LLP (Dallas Office)