Ankit is a highly motivated Data Analyst experienced in ETL jobs, SQL, and Tableau. His expertise includes data warehousing, data flow scripting, and data visualization using tools like AWS Redshift. He is skilled in developing reporting frameworks, analyzing online marketing channels, and managing data consistency and integrity.
Experience
Analyst
OmniCom Media Group
Develop and maintain ETL jobs using Alteryx, SQL & Tableau. Maintain data flow scripts to move data into the data warehouse from various APIs and data storage services. QA data for the deliverables by setting up an automated process. Exposure and learning ability on Big Data technology (AWS Redshift). Understanding client's data requirements and documenting it for data flow and visualization steps. Pushing data on the Tableau server dashboards and managing users and access-related queries from the client. Experience designing and developing database solutions using SQL server and/or Cloud database solutions. Designing, Generating, and managing reporting frameworks on different Business Intelligence tools. Providing analysis of online marketing channels. Project Management on HIVE.
App Boss
Building and maintaining ETL process using Alteryx. Analyse and improve ETL framework, workflow, and troubleshoot. Creating visualizations on Tableau which suits the client's visualization goal.
Associate
SKG & Associates
Building new data views and optimizing existing ones to empower teams across the business. Manage, manipulate, simplify and analyse complex datasets. Responsible for managing data consistency and integrity across all the data sources. Responsible for Handling Audits, ensure all invoices are mapped and entered with compliance with all reporting requirement.
Education
Institute of Chartered Accountants of India
CA-Inter/IPC
Accounting/Chartered Accountancy
University of Delhi
B.com
Commerce