Resume

Sign in

Data Analyst

Location:
Delhi, India
Posted:
December 12, 2019

Contact this candidate

Resume:

Kartik Kumar

Email id: ada135@r.postjobfree.com

Contact no.: 959-***-****

Objective

Looking forward to an opportunity for working in a dynamic, challenging environment, where I can utilize and enhance my skill set for developing my career as well as for the growth of the organization.

Academic Qualification

●B. Tech from AIMT, Gr. noida with 61% in 2015.

●12th from CBSE Board with 60% in 2011.

●10th from CBSE Board with 62% in 2009.

Technical Qualification

Operating System: Windows 7/8/10

Database: SQL Server 2008, Oracle Developer 11g

Languages: SQL, T-SQL, Tableau, Machine Learning, Regression, oops, Python, sklearn.

Others: MS EXCEL, stored procedures, CTE, views, triggers, sub-queries

Work Experience

Company Name: Bharti Airtel (Payroll- Aegis Limited, Noida)

Designation: Executive

Role: Revenue & Data Analyst

Tools: Oracle SQL Developer, DB2 (MLA & BI), Pretups, Single view, IPACs

JOB RESPONSIBILITIES: (17-Jan’19 to Present)

Monitoring live trend and identifying high risk transaction and spike within Airtel money wallet.

Assuring there is NO revenue leakage to GSM Data Bundle, Pretups and Postpaid Transactions through Airtel Money payment.

Reconciliation of Airtel Money Platform transactions with Data Bundle, Pretups and Postpaid transactions to ensure there occurs No fraudulent/revenue loss to business.

Monitoring all transactional records related to merchants, dealers, retailers and subscribes to identify fraudulent activity in various service type such as IMT, Interoperability, Bank transactions, CASHIN, CASHOUT, etc.

Monitoring all those subscribes who got SIM swapped and identify their transactions and analyze their activities.

Identification of any suspicious transactions and generate activity reports to the respective operational countries of Africa for further processing.

Development of complex queries through automation (SQL Plus) for performing the scheduled controls to reduce time efficiency.

Data cleansing and data manipulation.

Produce regular reports and analysis, write system queries to gather data, perform data mining and analysis using tool including Excel, SQL to identify trends and quality improvements to be done.

Major support in migration of new OPCOs and was awarded for the best performance.

Implementing AML limits to across all users in OPCOs based on regulatory guidelines and Monitoring breaches at real time to prevent money laundering.

Ensuring the confidentiality of all information collected during investigation.

Company Name: IT Infocube Pvt. Ltd

Designation: Developer

Role: Developer

Tools: Oracle SQL Developer, Magento, css, HTML, PhP

JOB RESPONSIBILITIES: (May’16 to Jan’17)

Building PHP websites using Magento and Wordpress CMS.

Provide Guidance to other team members on web development issues.

Identifying and correcting Software deficiencies.

Participating in discussions with clients to clarify what they want.

Provide security to the websites.

Participation in the completion of all technical system projects.

Personal Strengths

●Flexibility, Adaptability and Hardworking.

●Punctual and Self-motivated.

●Positive Attitude and dedicated towards my work.

Extra-Curricular Activities

●MTA Certification

●Attended Workshop on “Microsoft”, organized by Department of Computer Science, AIMT Gr. Noida

●Actively participated in various sport and cultural activities at school.

Personal Details

●Father’s Name: Mr. Harendra Kumar

●Mother’s Name: Mrs. Babita

●Permanent Address: Vill 127-B pratap enclave mohan garden uttam nagar delhi,110059

●Date Of Birth:21th September,1993

●Languages Known: English and Hindi

●Marital Status: Single

●Gender: Male

●Nationality: Indian

●Interests and Hobbies: Listening songs, helping others.

Declaration

I do hereby declare that the above information is true to the best of my knowledge.

Date: (Kartik Kumar)

Place:



Contact this candidate