Priyanka Arora

+1-973-***-**** adjrz9@r.postjobfree.com

Summary

A detail-oriented Data Analyst professional with 10 years of experience in leading projects and consulting global stakeholders to provide meaningful and high-quality data reporting and business intelligence solutions.

Skill Set

Technical

Functional /Domain

Data Analysis – Advanced Excel, SQL, SAS EG

Banking – Anti Money Laundering & Transaction Monitoring, Fraud Management, Loan Delinquencies management

Data lifecycle management – Data Profiling, Data Scanning, Metadata Management, Data Lineage

Pharmaceutical - Sales and Marketing Analysis, Pricing strategy analysis, Promotional /Campaign analysis

Business Analysis – MS Visio, SharePoint for workflow management.

Retail: Sales and Distribution Analysis

Data warehousing – Dimensional Modelling (Star/Snow flake Schemas) using Erwin Data Modeller

Financial Services – Credit Cards lifecycle, Collections.

MIS Reporting/Dashboards - QlikView, Business objects, OBIEE, Cognos, SSRS, Power BI, Microstrategy, Spotfire,Tableau, Microsoft Azure

Project management using MS Project & JIRA

Testing - SIT, UAT, Test scripts, Regression Testing

Requirement Gathering (technical / Functional), Agile Methodology, Gap Analysis, Client and Stakeholder Management

Professional Experience

COMPANY: Emirates National Bank Of Dubai (ENBD)–DUBAI, UAE

Feb 2018 – Feb 2020

DESIGNATION: Data Analyst - GROUP Compliance

Environment : Database – Sybase/Oracle, BI Tool – Cognos/Power BI/SAS/Qlikview

Responsibilities:

Performing data analysis using SQL/SAS of the Anti-money laundering system and to give Early alert to the department of any non-conformance to policies and procedures.

Responsible for preparing and publishing daily/monthly/Adhoc reporting using cognos and power BI.

Responsible for regulatory reporting during central bank audits.

Identify key trends and opportunities to build comprehensive Anti-money laundering system for bank.

Regularly liaise with transaction monitoring unit to tune TMU scenarios and alerts in FCRM.

Identify and generate insights into bank transactions from fraud and money laundering perspective.

Actively support data transformation /migration projects for compliance unit which includes requirement gathering for report specifications, BRD/FRD preparation, Solution development, testing and final implementation.

Identifying and supporting automation of manual data reporting for compliance unit by documenting process flows and use cases for each team and further building reporting solutions within tools like Power BI & Cognos.

Successfully implemented Go AML system which enables automated suspicious activity/transaction reporting to central bank of UAE using Cognos and other banking systems.

Supported deployment of new version of Finacle(OLTP) bank wide in which performed pre and post go live data validations

Migrated all existing cognos business reports to Power BI platform which involve data source identification, connecting to both structured and unstructured data, designing reports and dashboards in Power BI, building calculated measures, access control and hosting the reports on cloud.

Single handily designed and supported reporting across compliance function for all KPIs and KRAs to leadership in which developed data visualizations and reports by collecting data from various sources within the bank.

COMPANY: ZS Associates–Gurgaon, India

June 2016 – June 2017

DESIGNATION: SOLUTION DELIVERY CONSULTANT - BUSINESS TECHNOLOGY GROUP

Client: : US Based Pharmaceutical company

Environment : Database/Data Source – Oracle, SAS BI Tool – Qlikview/Qliksense/Power BI

Role: Consultant (Team Size – 15)

Location: Gurgaon,India

Responsibilities:

Manage the day to day Sales report delivery process across 2 client engagements.

Use best practices to design the Datawarehouse (star schema), test plans, ETL, reports.

Created data model for OLTP source system (Logical & Physical)

Performed Data Profiling from source systems to be used for Model building.

Migrating MIS reports from MS excel to QlikView and Power BI by understanding data sources, data flow, preparing report mocks, understanding and calculating KPIs on tool, performing SIT & UAT

Set standards for application performance, operations, programming and security

Guide project teams in applying business rules and systems design

COMPANY: Genpact –Gurgaon, India

Feb 2012 – May 2016

DESIGNATION: Manager – analytics

Project 1 : Portfolio reporting & analytics for collections services domain

Client: : Europe based working capital solution provider

Environment : Database – Oracle, Scripting language - SQL, BI Tool – BO & Microstrategy

Role: Team Lead (Team Size – 12)

Location: Gurgaon,India

Responsibilities:

Define activities to support reporting/BI implementation change and transition initiatives.

Design and develop adhoc MIS reports and dashboards as per client requirement with advanced data visualizations using excel / BI tool for the analysis of past dues, deliquencies, collection strategies.

Architect, design, test and deploy reports from BO to Microstrategy as a part data reporting migration project.

Provide technical leadership to members of the reporting team to deliver on-time, on-requirements and on-quality

Mentor team members in building and testing new reports to ensure and demonstrate quality and drive knowledge sharing

Build monitoring solutions to ensure on-going quality and accuracy of existing recurring reports and dashboards

Work on Adhoc Analytics projects like watchlist analysis using statistical techniques helping in risk modelling projects.

Building executive risk dashboards giving summarised view on health of business

Worked on process improvement project wherein manual touch points were removed from complete process resulting substantial productivity benefits by automating the complete process.

Project 2 : Data Analytics in retail & corporate lending portfolio for PD/LGD modelling project

Client: : Australian banking and finance major

Environment : Database – SQL/flat files, BI Tool – Cognos /SAS Base 9.3, MS Excel

Role: Sr Analyst

Location: Sydney,Australia

Responsibilities:

Support model developments in Credit Risk, with data analysis, process and other documentation

Conduct extensive SAS data analysis of banks credit portfolio across dimensions to understand portfolio trends

Based on trends recommend modelling assumptions to the modellling team.

Project 3 : Reporting & analytics in claims procurement domain

Client: : Australian banking and Insurance major

Environment : Database – Oracle/SQL, SAS 9.2, Reporting Tool : MS Excel

Role: Sr Analyst

Location: Brisbane,Australia

Responsibilities:

Supported end to end transition of Insurance Claims SAS reporting function of an Australian client.

Extracted claims procurement data using SAS base by applying data & proc steps

Engaged in understanding new reporting requirements and converting it into logical Sas/SQL code to extract relevant data

Supported production of 120 reports on monthly basis with varying frequencies.

Rationalised production of reports from 200 to 120 hence reducing time and effort of business and analysts

Designed process metrics & SLA’s to measure the performance of To-Be process

COMPANY: Zensar technologies –Pune, India

Aug 2010 – Jan 2012

DESIGNATION: Business Analyst

Project 1 : Regulatory Reporting for Investment Management Function of a Private Bank

Client : Leading UK Based Private Bank

Environment : Crystal Reports,SSAS/SSRS 2008 for MIS Reporting & BI,SSIS for integration,SQL Server 2008 for Staging/DW database

Worked on identifying gaps in existing prebuilt product with the required reporting needs

Studied as Is architecture & Constructed and documented to –Be integration architecture using MS Visio

Worked on Logical Data Model and constructed it using Erwin Data Modeller

Worked extensively on MS excel and MS PowerPoint to build and present report formats

Designed report specifications in consultation with client team

Documented Business requirement & functional requirement document

Documented meta data definitions

Written test cases and build scenarios to validate reports result

Performed UAT before going live

COMPANY: ALARD Institute of Management Sciences– Pune, INDIA

Sept 2009 – June 2010

DESIGNATION: Lecturer

Design and implementation of effective teaching/ learning processes for assigned subject.

Develop a system for ongoing evaluation of both teaching and learning including course competency expectations and student outcome measures.

Providing input into curriculum through course content as per current industrial practices and models

Participate and support faculty training programs

Guidance and Assistance of academic project or internship as per requirement

Training offered in following subjects/topics –Retail Banking, Wealth Management, Service Marketing

COMPANY: ICICI BANK LTD– NEW DELHI, INDIA

June 2007 – Nov 2008

DESIGNATION: Assistant Manager – Retail Liabilities

Mainly responsible for looking after the administration and daily operations of the bank branch

Extensively used MS Excel to provide daily MIS reports to management

Part of the core project team for the implementation of private banking relationship management software (PBRMS)

Involved in preparation of IT Roadmap, BOM (as is – to be) & capturing Business User Requirements, Gap Analysis – accessing shortfall in Legacy Applications / replacing them with selected products

Education

MBA – FINANCE/MARKETING: 70.05%

ICFAI Business School– Gurgaon, India

B.E – ELECTRONICS &TELECOM: 70.83%

Priyadarshini College of Engg. –Nagpur University, India

Professional Development

Certificate in Business Intelligence and Data warehousing for Analysts– 4-month Course at Europe Asia Business School, Pune, India

Business Analysis & Requirement Gathering – 1 Week Training at Zensar Technologies

Basics of SQL – 1 Week Course at Zensar Technologies

Data Modelling Skills – 1 Week Training at Zensar Technologies

SAP Business Objects –1 Month Training at Zensar Technologies

QlikView BI Tool – 3 Week Training at Zensar Technologies

Learning SAS – 2-week sessions on SAS basics at Genpact India

Statistical Modelling in SAS – 3 months program at Genpact India

Green Belt trained and tested for process improvement in business.

Personal Details

Date of Birth – 21 Nov 1982

Marital Status – Married

Visa Status – L2 valid EAD

Address –250 Ridgedale Avenue Apt K6, Florham Park, NJ 07932

Contact this candidate