Default profile banner
AV

Ankit Verma

@ankitverma

Data Analyst

Noida, India

linkedin.com/in/ankit-verma-349312201

OmniCom Media GroupInstitute of Chartered Accountants of India

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

•Invalid Date - Present

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

•Invalid Date - Invalid Date

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

•Invalid Date - Invalid Date

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

Jan 2015 - Jan 2020

University of Delhi

B.com

Commerce

Jan 2014 - Jan 2017

Skills

Alteryx
NoSQL
Python
SQL
MongoDB
AWS S3
AWS Redshift
Hive
Excel
Datorama
MS Office
Analytical Skills
PowerQuery/Pivot
ETL
Tableau
Data Warehousing
Data Flow Scripting
SQL Procedures
Big Data Technology
Database Solutions
Project Management