Jaiveer Singh

• Working with Big Data and writing complex SQL queries to track customer engagement and build insights on consumer behaviour that can be leveraged to create strategies that meet customer and partner needs. Assist in campaign construct, lift & incremental calculations.
• Performed customer and campaign performance tracking using Advanced Excel features like Pivots, Graphs which included key indicators such as Spend & Lend behavior, Benefit Engagement & Satisfaction, Early Engagement, Amex Offers & Rewards Redemption, Digital Performance. Test & learn the impact of marketing initiatives and how they correlate with card member engagement.
• Automate monthly and quarterly performance reports, build visualizations and reporting in Tableau. New acquisitions and increase in spend engagement. Leverage insights from the program for future benefits and negotiations based on customer behavior. Learn which benefits give maximum value ROI to client as well as merchant partners and reduce attrition.

Working with Big Data and writing complex SQL queries to track customer engagement and build insights on consumer behaviour that can be leveraged to create strategies that meet customer and partner needs.
Assist in campaign construct, lift & incremental calculations.
Performed customer and campaign performance tracking using Advanced Excel features like Pivots, Graphs which included key indicators such as Spend & Lend behavior, Benefit Engagement & Satisfaction, Early Engagement, Amex Offers & Rewards Redemption, Digital Performance.
Test & learn the impact of marketing initiatives and how they correlate with card member engagement.
Automate monthly and quarterly performance reports, build visualizations and reporting in Tableau.
New acquisitions and increase in spend engagement.
Leverage insights from the program for future benefits and negotiations based on customer behavior.
Learn which benefits give maximum value ROI to client as well as merchant partners and reduce attrition.

Advanced understanding of Relational Database Design principles, including Database Modelling, Database Design & Database Schema generation.
Designed and developed an enterprise grade Database from scratch for a medium scale organization in a healthcare setting.
Performed requirement elicitation and cataloging, basic DB schema generation, DB design, creation of a broad array of functionalities for the practitioners, & end-to-end provisioning of the basic source code (SQL) for the DB, including DDL and business functionality (DML) queries.
Applied advanced querying skills in SQL, with extensive querying experience in real-life scenarios.

Worked in the Unify Program Team, a multi-hundred-million-dollar global ERP and EAM transformation initiative to streamline company’s AWM systems from SAP to Maximo.
Analyzed and extracted data from large data sets to facilitate the migration and launch of the next mock environment and create 450 Job Plans/Work Orders on Excel in line with established templates & standards.
Exceeded the project goal by 80%.
Worked on Excel and SQL to create pivot charts and perform basic calculations such as LAG, RANK VLOOKUP, DENSERANK, SUMIF, COUNTIF to create job plan classifications to load into Maximo.

Extracted a dataset from a website, cleaned it, transformed it and conducted analysis using supervised techniques.
Used Web scraper extension of Google chrome and collected data for more than 500 movies to perform analysis using multiple attributes.
Performed Sentimental Analysis on the clean dataset using the Natural Language Processing (NLP) feature of Orange which provided valuable insights on movie ratings.
The goal was to train the model to predict the sentiments of people when given a dataset based on factors such as genre, runtime, cast and crew of the movie.

Worked on a marketing analytics project that aimed at targeting potential customers for an insurance company using.
Conducted data exploration, visualization and pre-processing on 100k rows of data and applied techniques for data preparation for the client.
Developed visualizations (Bar Charts, Box plots, line plots) which are used to monitor key performance indicators (KPI).
Transferred data from MS Excel into SAS for analytics and used filters based on the analysis.
Performed predictive modeling techniques (Decision Tree, Neural Networks & Logistic Regression) on data to achieve useful business solution for client problems.
Applied clustering techniques and tools (e.g., K-Means, Two-Step) for segmentation and profiling of web quotes for better targeting strategies.

Experienced in MicroStrategy deployments, applying fix packs, upgrading of applications to higher versions.
Experience in Troubleshooting and analyzing logs.
Experienced in files deployment over different MicroStrategy environments.
Worked on SQL Server & MicroStrategy to perform churn analytics for customer loyalty program of company data.
Analyzed Spend & Share of Wallet data by exploring statistical models such as regression & correlation in MS Excel to study marketing trends that increased retention rate by 8 basis points.
Created KPI dashboards in MicroStrategy using scorecard summary and Pie charts, Bar charts, for monthly reporting and ad-hoc analysis.
Reviewed files, records and other documents to gather business information and key data to respond to development requests.
Created documents such as policies, procedures and workflows.
Participated actively in walkthrough reviews during sprint meetings.

Programmed, developed, and optimized databases daily using MySQL.
Modernized services from legacy systems i.e. AS400 to APIs on Java.
Handled issues and tickets on JIRA and ServiceNow.
Worked on SSIS to run ETL queries on data sets.
Worked on SharePoint and GitHub.
Interacted with clients on a regular basis to report progress and to discuss implementation plan.
Automated an API to facilitate email communication from a server, thereby reducing the manual effort of sending 30% of emails daily.
Performed UAT testing according to the protocols as the final phase of applications development.
Test the user stories for accuracy and compliance including Alpha and Beta Testing.