Summary
Overview
Work History
Education
Projects
Personal Information
Software
Timeline
Generic

PARTH SARATHI PANDA

SAS DEVELOPER
Berhampur

Summary

SAS Programmer with 5 years of work experience in SAS Programming and Reporting Tools and overall 12 years of rich experience in BFSI sector. Seeking assignments in Data Analytics with the leading organisations in the Financial sector.

Overview

12
12
years of professional experience
2
2
Languages

Work History

SAS Developer

Triumphsys System and Solutions Private Limited
09.2022 - Current
  • Utilizing SAS EG to build dashboards and simplify financial reports.
  • Maintains strong, trusting relationship with business and continuously seeks to enhance the service provided
  • Responsible for presenting to senior management & provide meaningful, concise, and clear analysis, including recognition of trends/potential problems and business advantage.
  • Created stored process and registered in metadata server to access the same in SAS .
  • Automation of various reporting and reducing the TAT to a great extent by using SAS Methodology.
  • Generating Reports and presenting Daily / Weekly / Monthly reports to the concerned department; preparing monthly performance status reports to top management.
  • Working in SAS/BASE, SAS/MACRO, SAS/SQL for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse, worked on various sources like Vertica, Oracle, Excel and Flat Files.
  • Working in various procedures like Proc Means, Proc Freq, Proc Tabulate, Proc Import, Proc Export, Proc Sort, Proc report for developing MIS Reports.

Deputy Manager(Analyst)

Baroda Global Shared Services Ltd.
07.2020 - 09.2022
  • Identifying user requirements and Business rules to Design, Develop and Implement Analysis and Reporting System.
  • Worked on different types of transformations like extraction, file reader, surrogate key, user written code, table loader etc.
  • Extracted raw data files like .csv, .txt, .xls by user written code.
  • Developed macro programs for re-usability and extensive use of PROC SQL for data transformation.
  • Enhanced existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
  • Used Output delivery system extensively to generate reports in html, PDF and excel reports using Proc report.
  • Added techniques to capture detail and summary log, used exception handling techniques, maintain record of work and make proper documentation for deployment.
  • Got Promoted in January 2022.

Assistant Manager/Team Lead

Baroda Global Shared Services Ltd.
02.2018 - 07.2020
  • Opening of NRI Overseas and NRI Domestic accounts uploaded by Overseas Branches through tools like Baroda Insta and Omniflow.
  • Handling Customer complaints escalated to Chief Manager (Bank of Baroda) and AGM (Bank of Baroda).
  • Also performed service to NRI Welcome Kit Department, monitoring the dispatch of the Welcome Kits for the account opened by the overseas branches to their respective overseas territories.
  • Managing end to end operational activities for KYC Review for new client adoption, Quality Assurance, Request handling and Customer Due Diligence (CDD).
  • Processing cross border payments including the VIP and corporate Customer payments on priority basis as per the client requirement.
  • Performing investigations (RCA) and identifying the need to file internal Suspicious Transaction Reports (STRs).
  • Reporting Suspicious Activity Reports (SAR) and Suspicious Transaction Reports (STR).
  • Keeping updated on ongoing Trade Based Money Laundering (TBML) trends such as high risk industries, high risk countries, sanction lists etc.
  • Assisting the Business Team in conducting the TBML transactions monitoring.
  • Providing the Revert of RCSA Report (ORM Team) and Concurrent Audit Report (CCA) on monthly basis.

Sales Manager

Exide Life
12.2016 - 11.2017
  • Motivating and helping team members for better performance to achieve their target.
  • Handling a team of 11 SALES EXECUTIVES.
  • Conducted three lead generation events in the month of January.
  • Conducted IRDAI Training Programme successfully with 10 licenses.
  • Conducted 10 lead generation programme till april to target the affinity groups.
  • Achieved 120% of target in the month of march,2017.

Assistant Sales manager

HDFC Life Private Ltd
05.2014 - 08.2016
  • Leading, mentoring and monitoring the performance of the team to ensure efficiency in business operations.
  • Handling a team of 16 FCs and 2 BUSINESS LEADERS.
  • Got CERTIFICATE OF APPRECIATION from AVP for ACTIVATION in 2014.
  • Got CHAMPIONSHIP MEDAL from AVP for completing 130% of my annual target in 2015.
  • Got Promoted in 2015.
  • Given extra responsibility as a BRANCH TRAINER for Berhampur Branch in 2015.
  • Conducted 6IRDAI Training and Refresher programmes with more than 50 new FCs.

Development manager

ICICI PRU Life Co Ltd.
06.2013 - 05.2014
  • Spearheaded the business through recruitment of advisor.
  • Recruited 11 Advisors in just 30 days and Qualified for the Zonal contest.
  • Led a team of 15 Advisors and 5 Distribution leaders.
  • Attended many management development programme organised by the company.
  • Successfully achieved monthly and yearly targets both in NOPs and ACTIVATIONS.

Education

HSC - undefined

GOVT. QUEEN OF THE MISSION HIGH SCHOOL

+2 SCIENCE - undefined

KHALLIKOTE JUNIOR COLLEGE

BSC - undefined

PERIYAR INSTITUTE OF DISTANCE EDUCATION (PRIDE)

Projects

Languages : SQL

Tools and Languages Used : SAS EG 7.1

Project Requirement : Reducing the TAT for Data Validation & Audit scores

People Involved : Senior Management


Overview of the project:

Worked on a project with senior leadership team to improve audit scores and mitigate risk

in the process.

Project Name : Regulatory Report / Central Processing Center - Control MIS

Role : Data Analyst& Reporting

Tools and Languages Used : SAS

Project Description : In this project we have developed 94 reports for Central

Processing Centre & Regional Processing Centre with end to end process using Data

Extraction from Vertica tables post Data Analysis and developed a One View report in single

screen. The project involves detailed review on critical parameters in the account opening,

account modifications & servicing. This dashboard worked as a tool to ensure proper monitoring mechanism for the

business and improved score in key audit finding.



Overview of the project-II


Worked on a project with leadership team to improve customer satisfaction levels and

decrease TAT of the process.

Project Name : Account Opening Tracker - AOT

Role : Data Analyst & Reporting

Tools and Languages Used : SAS

Project Description:

In this project we have developed 30 reports extracting data from Oracle server which are

used in liability account opening process and post Analysis and generating reports for

Branches, Regional processing centres providing activation, net and gross rejections and TAT

reports on daily and monthly frequencies. Ensure a high-quality customer experience,

elevating customer satisfaction

Personal Information

Personal : Male, Married

DOB : 28 May1987

Cat: General

Address: Gopinath nagar 1st lane, Bijipur, Berhampur, Ganjam, Odisha, 760001

Software

SAS ENTERPRISE GUIDE

SQL

SAS DI STUDIO

DWH VERTICA

ORACLE

FINACLE 102

POWER BI

MS OFFICE

Timeline

SAS Developer

Triumphsys System and Solutions Private Limited
09.2022 - Current

Deputy Manager(Analyst)

Baroda Global Shared Services Ltd.
07.2020 - 09.2022

Assistant Manager/Team Lead

Baroda Global Shared Services Ltd.
02.2018 - 07.2020

Sales Manager

Exide Life
12.2016 - 11.2017

Assistant Sales manager

HDFC Life Private Ltd
05.2014 - 08.2016

Development manager

ICICI PRU Life Co Ltd.
06.2013 - 05.2014

HSC - undefined

GOVT. QUEEN OF THE MISSION HIGH SCHOOL

+2 SCIENCE - undefined

KHALLIKOTE JUNIOR COLLEGE

BSC - undefined

PERIYAR INSTITUTE OF DISTANCE EDUCATION (PRIDE)
PARTH SARATHI PANDASAS DEVELOPER