Summary
Overview
Work History
Education
Skills
Software
Certification
Interests
Timeline
Generic

AMANPREET SINGH

Analytics Professional
New Delhi,DELHI

Summary

Around 9 years of experience in Business Analytics.

Extensive experience in Credit Risk ,Credit
Card/American Express consumer/commercial products and Sales/AD domain where core responsibility is to help
clients understand their business better by providing them business implementation solutions to drive more value.

Furnish insights, analytics, and business intelligence needed to guide decisions.

Overview

1
1
Language
2
2
Certifications
4
4
years of post-secondary education
9
9
years of professional experience

Work History

Process Manager

AmericanExpress
09.2017 - Current
  • PROJECT I: Early Tenure Account Assignments for US Market.
  • Early Tenure is the process of selecting the high potential non-CAG accounts and then assigning to dedicated ET managers for CRM (To grow there more potential).
  • Dedicated relationship manager is provided to these accounts to grow more potential.
  • Writing SQL Queries to fetch required data from IDN tables as per business requirements considering Risk score and revenue greater than $ 1 Million.
  • Extract product details, Industry type, Application Revenue, Actual spend, Risk score etc.
  • From IDN data source.
  • Manipulation and cleaning of these records on SAS and assigning to dedicated managers.
  • Sending these potential accounts to Marketing team as well to send marketing offers and campaigns to them.
  • Project 2 : Portfolio design JAPA &Canada Region (Prop Markets) - Performance Analytics.
  • Global Portfolio Analytics for AMEX Corporate Business.
  • Providing business continuity by safe guarding portfolio data being passed on to RISK systems, for Corporate clients to avoid any business disruptions at POS.
  • Receive inputs from different Market Regional Planners regarding the change of ownership, segment and Parent.
  • Support Business in deciding segment for accounts to segment them as Middle,large or Global Account (GCG Accounts). Corporate portfolio in Salesforce(Segment, Owner and Parent).
  • SFDC Data is used by Marketing Teams, Finance and Risk systems including CAS.

Sr. Batch Technical Analyst

AonHewitt, SBTS
11.2014 - 09.2017
  • SAS Interface: BASE SAS, SAS MACRO, PROC SQL Platform: Mainframes, Database: DB2 Responsibilities:.
  • Requirement Gathering for implementation of New Onboarded clients following complete SDLC cycle.
  • Writing SQL Queries to fetch the data from DB2 tables as per the requirements.
  • Import data from MS-excel to SAS data set & perform Data validation, Data Cleaning & Data Manipulation by using SAS Functions and other tools.
  • Modify existing SAS programs along with creating new programs using SAS macro variables to improve the code structure and minimizing the runtime.
  • Create appropriate (business/technical) documents for all the programs developed.
  • Combine, create & eliminate the duplicate data from different files.
  • Produce customized reports for Performance Optimization by using various Procedures.
  • Sending reports to output destinations using various ODS statements.
  • Delivering business reports to end users.

Analyst

HCLTechnologiesPvtLtd
07.2013 - 10.2014
  • The business objective was to gain insight into consumer credit card usage behavior, spending preference, credit card debt trend, and credit card wallet share.
  • Consumers are then segmented into 14 marketing profiles based upon their credit card usage behavior and spending preference.
  • Primary Relationships: ASP View Description: The business objective was to determine the primary status of households within Consumer Banking Technology.
  • Primary being an indication of whether the household’s primary banking relationship is with bank.
  • Process Effectiveness: After completion of every Campaign cycle,source and analyze the trend to understand common issues across entity/floor do the root cause analysis(RCA) and come-up with action plans.

CSR

Quatro Global ServicesPvtLtd, Gurgaon
09.2012 - 02.2013
  • Manipulation of data to create meaningful reports on a periodic basis using SQL, Excel Ability to create/write new SAS/Access/SQL code based on the requirement.

Analyst

S. V. EnterprisesManpowerConsultants
06.2011 - 08.2012
  • Undertaking routine preventative measures and monitoring network security, particularly if the network connects to the internet Giving tune up to computers.

Education

Bachelor of Technology - Electronics & Communication Engineering

Punjab Technical University , IGCE college
01.2007 - 01.2011

Skills

SAS,SQL/Hive, Tableau,Python,AZURE,ML, Excel

undefined

Software

SAS,SQL,TABLEAU,PYTHON,AZURE,EXCEL,SDLC

Certification

SAS Certified Base Programmer for SAS9

Interests

Acting, Travelling

Timeline

Process Manager

AmericanExpress
09.2017 - Current

Sr. Batch Technical Analyst

AonHewitt, SBTS
11.2014 - 09.2017

Analyst

HCLTechnologiesPvtLtd
07.2013 - 10.2014

CSR

Quatro Global ServicesPvtLtd, Gurgaon
09.2012 - 02.2013

Analyst

S. V. EnterprisesManpowerConsultants
06.2011 - 08.2012

Bachelor of Technology - Electronics & Communication Engineering

Punjab Technical University , IGCE college
01.2007 - 01.2011
AMANPREET SINGHAnalytics Professional