Mayank Agarwal

Responsible for Managing, Coordinating and Leading a team of analysts both onshore and offshore teams to perform data acquisition and analysis, define requirements and set expectations with internal and external stakeholders for Marketing Mix Modelling.  Single point of contact for data acquisition and processing for multi-million dollar retail, pharmaceutical, financial and restaurant clients.

Responsible for Client Onboarding, Business and Data Analysis for major lending institutions of US, UK, Canada and Australia which include following activities –  Setting up data framework for new clients and creating SSIS Integrations for ETL purposes.  Writing customized stored procedures for transforming the data into Argus standardized structure.  Performing data analysis by SQL querying and creating visualization in Tableau for presentations.

Responsible for Business and data analysis for financial clients in projects of data warehouse development, BI Reporting, consulting and maintenance projects which include following activities -  Creating the requirements specification document by interacting with business users.  Setting up environment for ETL development and BI Reporting modules and designing the workflow of the DW application.  Creating ETL scripts, stored procedures and BI Reports and testing them in development environments.

Responsible for delivering projects with activities transcending from requirements analysis, development and testing for business intelligence (BI) and data warehouse applications.

Data Warehousing and Business Intelligence, Financial Accounting, Operations Management, Project Management