Ankit (RID : yb8plks12o8n)

Analytics Engineer

Location : Bhubaneswar, India

Experience : 7 Year

Rate: $14 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 5

Total Views : 91

Key Skills

QUICKSIGHT ATHENA GLUE REDSHIFT POWERBI AWS CLI AWS CLOUD FORMATION

Discription

Data Analytics – IIM Rohtak (2020) (March to June)

Training on Analytical Techniques for Business Intelligence, Data Visualization, Price Analytics, and Classification using Decision Tree & Naïve Bayesian, Clustering, Association Rule Mining, Neural Networks, and Genetic Algorithm and Fuzzy logics, Text Analytics, Sentiment Analytics, Web and Social Media Analytics.
Basic Training – Big Data, Hadoop, HDFS, MCDM, MapReduce.

Tools Used for Training

Excel, Power Bi, MS SQL, Python, Alteryx,Tableau,Jupyter notebook,Orange Data mining tool,Google Analytics , Google Data Studio

WORK EXPERIENCE

From Oct-2022 till present working as Software Engineer.

TOOLS – QUICKSIGHT, ATHENA, GLUE, REDSHIFT, POWERBI, AWS CLI, AWS CLOUD FORMATION

Assignment Handled

Creation of Dashboards for Crawford & Co.
Handling Projects – GLLD, NPS & CYBER
Quick sight Deployment into Different Environment, Different AWS accounts
Working with AWS CloudFormation, AWS CLI
Data Source, Data Set Deployment across AWS accounts
Quicksight Analysis & Template Migration across AWS accounts

•

From Jan-2021 till May-2022 with Muthoot Pappachan Technology Ltd, Trivandrum Office as MIS Executive – Analytics. (MPT is a Subsidiary of Muthoot Fincorp Ltd)

TOOLS – MS SQL, TABLEAU, EXCEL, QUICKSIGHT, ATHENA, GLUE, DMS

Assignment Handled

Daily Business Report Published to CMD & Zonal Heads of Muthoot Fincorp Ltd.
Target Vs. Achievement Dashboard
Fulfilling Data request of Various Teams of Muthoot Fincop Ltd & MPT.
Updating Branch data in Analytics Data base using SQL
Developing Tableau dashboards.
Excel automation for Zonal teams.
Preparation & Presentation of Business Plan (Target Setting for more than 30 KPIs) annually.
Preparation & Presentation of Zonal Review on Quarterly basis.
Automation of all manual reporting in QuickSight

From Dec-2019 till Jan-2021 with Muthoot MicroFin Ltd, Bhubaneswar Regional Office as Executive – Regional MIS (Operation).

Assignment Handled

Dynamic Dashboard using MS Excel & Power BI for Vice President of East & West Zone.
Daily reporting on Disbursement, Collection & Status of Arrear Portfolio
Daily Evaluation of Demand Vs. Collection
Audit Compliance Follow up & Reporting
Software Training Material Design
Handling all data requirement of Operations team.