Principal
Current
Jan 2023 - Present
Who is Ankit Bhatia? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Ankit Bhatia is listed as Principal at Slalom, based in Minneapolis, Minnesota, United States. AeroLeads shows a matched LinkedIn profile for Ankit Bhatia.
Ankit Bhatia previously worked as Senior Consultant at Slalom and Information Management and Analytics Consultant at Slalom. Ankit Bhatia holds Btech, Computer Science from Punjabi University.
Company email context
Email format at Slalom
This section adds company-level context without repeating Ankit Bhatia's masked contact details.
Slalom
Review company-level records connected to Ankit Bhatia before choosing the right outreach path.
Profile bio
About Ankit Bhatia
Data warehouse professional with 16 years of experience in building end-to-end data warehouse (DW) and reporting solutions. Experienced in designing, building, and implementing data models, pipelines, semantic layers, reports, and visualizations for Fortune 500 companies. Driven by a fervor for data, relishes in the process of data wrangling to transform raw information into actionable insights, empowering clients to enhance their business through data-driven decision-making.
Current workplace
Ankit Bhatia's current company
Company context helps verify the profile and gives searchers a useful next step.
6 roles
Ankit Bhatia work experience
A career timeline built from the work history available for this profile.
Senior Consultant
Jan 2020 - Jan 2023
Information Management And Analytics Consultant
May 2017 - Dec 2019
Technical Team Lead
• Design, Develop and implement Data Warehouse (DW) and reporting system solution using MSBI stack for the client to enable them to self-invoice their vendors.• Build SQL queries to pull source data from Microsoft project server. • Design, Build, Test and Deploy stored procedures, SSIS packages and SSRS reports.• Conduct client meetings and take part in sessions to propose technical solutions and help the client in User Acceptance testing.• Understand requirements and delegate tasks to offshore team and peer review their code.• Perform report field mappings with existing entries in MDS, add necessary new entries in MDS with pseudocodes and create report LLDs and HLDs. • Build MOLAP cube using SSAS and create PowerPivot reports on top of it.• Design & model new source systems.• Design ETL logic for moving data from source to destination.
Feb 2013 - May 2017
Senior Software Engineer
Roles Performed• Lead, develop, manage, and support Data Warehouse (DW) reporting system for internal operational and financial reporting, and client invoicing purposes using SSIS, SSAS and SSRS.• Migrate SSIS ETL packages, SSAS cube and SSRS reports from SQL 2005 to 2012 version.• Map the current DW to new source system upon change of source system from Service Management Suite (SMS) to Microsoft Project Server (MSPS). Design, architect and implement SSIS, SSAS and SSRS changes owing to source system change.• Create InfoPath forms on SharePoint, handle permissions, integrate with SSRS and excel, document library, lists. Set up monitoring and scheduling jobs to track SharePoint reports usage. Create Performance Point Services KPIs, Scorecards, Reports, and Dashboards.Other Achievements•Star of the month for the month of november 2010.•ACE Award in FY2011 for Individual - Excellence in Value Creation - Contribution to Industrialization pillars - automation, asset reuse, harvesting - Genesis•ACE Award in FY2012(Alchemist award) for contribution through innovation in work process in the individual category.•Won the Continuous Improvement Program Award four times for sharing multiple innovative ideas to improve the processes.•Microsoft Certified Professional in Business Intelligence 2005/2008-MCTS and MCITP.
Aug 2010 - Jan 2013
Systems Engineer
Roles Performed:•Creation of data models for various areas of Supply Chain like Procurement, Inventory Management using Erwin 7.3.•Creation of Cube (Dimensions, facts, relationships, perspectives) using Analysis Service 2008.•Creation of Calculated Members, KPIs using MDX queries in Analysis Service 2008.•Creation of Scorecards, Chart Reports and Dashboards using Performance Point Server 2007.•Creating Adhoc reports using MS Excel 2007 and Proclarity•Creating Adhoc using Power Pivot feature of excel 2010.•Implementation of Data Level Security for metrics and charts.•Creation of reports using SQL Server Reporting Services 2008.Other Achievements•Secured first place in Infosys Mysore for the competition “Structured Dive” (MS SQL Server 2005) held on 18th-21stApril 08.•Successful completion of Final Semester Project held at Infosys Mysore from 09thJan - 9thMay 08.•Got “Award of Excellence” for my contribution to product “Supply Chain Visibility” at Infosys in FY Q4 2010
Jan 2008 - Aug 2010
3 education records
Ankit Bhatia education
Btech, Computer Science
Punjabi University
Non Medical
Dav Public School,Amritsar
Education record
Army School
FAQ
Frequently asked questions about Ankit Bhatia
Quick answers generated from the profile data available on this page.
What company does Ankit Bhatia work for?
Ankit Bhatia works for Slalom.
What is Ankit Bhatia's role at Slalom?
Ankit Bhatia is listed as Principal at Slalom.
Where is Ankit Bhatia based?
Ankit Bhatia is based in Minneapolis, Minnesota, United States while working with Slalom.
What companies has Ankit Bhatia worked for?
Ankit Bhatia has worked for Slalom, Accenture, and Infosys Technologies Ltd.
How can I contact Ankit Bhatia?
You can use AeroLeads to view verified contact signals for Ankit Bhatia at Slalom, including work email, phone, and LinkedIn data when available.
What schools did Ankit Bhatia attend?
Ankit Bhatia holds Btech, Computer Science from Punjabi University.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial