Email id: firstname.lastname@example.org
Contact no.: 959-***-****
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.
●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.
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
Company Name: Bharti Airtel (Payroll- Aegis Limited, Noida)
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
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.
●Flexibility, Adaptability and Hardworking.
●Punctual and Self-motivated.
●Positive Attitude and dedicated towards my work.
●Attended Workshop on “Microsoft”, organized by Department of Computer Science, AIMT Gr. Noida
●Actively participated in various sport and cultural activities at school.
●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
●Interests and Hobbies: Listening songs, helping others.
I do hereby declare that the above information is true to the best of my knowledge.
Date: (Kartik Kumar)