Ankit Khetan Email & Phone Number

London, England, Gb

London, England, United Kingdom

Gurgaon, India

• Spearhead an offshore team of 15 members to build an enterprise-wide data lake for a Fortune 500 pharmaceutical company• Understand the requirements of the business teams and scope out the data requirements• Assist in defining capabilities, building frameworks, processes, and tools to support data strategy• Analyze the data feeds from multiple data vendors and create data models (logical and physical) and source to target mappings to meet business needs• Create end to end data flow design with required business transformations on each data layer based on best industry practices• Lead end to end build for the data flow across the layers through SQL and ETL tools like Alteryx, DBT, Informatica• Lead end to end build of front end reports for executive and field users on BI reporting tools like Cognos, Tableau, Power BI• Conduct POCs on various BI tools, both ETL and Reporting to identify the best fit for client requirements• Develop project proposals and responses to proposals based on client requirements and identified opportunities• Manage client relationships and escalations through clear and transparent communication

Gurgaon, India

• Responsible for ETL and Reporting design and build of a Sales Crediting project for a Fortune 500 pharmaceutical company• Understand business objectives and gather requirements from multiple business teams; Converted business requirements into technical requirements and technical designs• Created end to end physical data models and source to target mappings for multiple data sources and integrated them into the existing warehouse• Identify business rules to be applied on each data layer based on discussions with the business teams• Lead the implementation of the solutions from offshore based on best industry practices• Develop front end reports for executive and field users on reporting tools like Cognos and Tableau• Serve as point of contact for business/client interaction for any clarifications, status reporting via status decks and operations plans

Gurgaon, India

• Discuss the requirements with the business teams and identify the reports to be developed to cater to their needs• Design and develop complex BI front end reports on reporting tools like Cognos• Identify points of failure and ensure the quality of the reports through regressive testing• Supported business users with user acceptance testing before the production deployment of the project

Hyderabad Area, India

• Work closely with business users for ad-hoc data analysis • Identify business challenges based on discussions with the business teams• Identify potential solutions to the business challenges and discuss with the project leads and eventually with the clients• Implement end to end data pipelines through ETL tools like DataStage with best industry practices• Built complex dashboards for home office users through BI visualization tool – Cognos• Work closely with business users for requirement gathering, data analysis, and support of queries

Bokaro