Profile - Rohan Gupta

Personal Details

	Title:	Mr
	First Name:	Rohan
	Family Name:	Gupta
	Email:	R.Gupta@student.reading.ac.uk
	Degree Studying:	MSc International Securities, Investment and Banking (FT)
	Languages:	Hindi, English

Professional Qualifications/Memberships/Licences

To be obtained while at at the ICMA centre:
ICMA International Fixed Income and Derivatives (IFID) Certificate, Securities & Investment Institute (SII) Diploma

Higher/University Education

2002 - 2006

BSc. Electrical Engineering
University of Massachusetts, Lowell, Lowell, USA

Relevant Work Experience

23/02/2008 - 31/08/2008	Business Analyst PNC Global Investment Servicing, Pennsylvania, USA PROJECT 1 + Converted Trading Platform ADVISORport 3.0 to ADVISORport 4.0. + Worked on Structured Products such as Separately Managed Accounts (SMA's), Unified Managed Accounts (UMA's), Mutual Fund Wraps (MFW's) and Manager Accounts traded/managed over the platform. PROJECT 2 + Developed the framework to replace data feeds provided by Lipper (Reuters) with those provided by Morningstar throughout the ADVISORport platform. GENERAL RESPONSIBILITIES + Formulated Project Plan according to SDLC (Software Development Life Cycle) and RUP (Rational Unified Processes). + Identified business processes and business requirements and created the BRD (Business Requirements Document). + Used UML (Unified Modeling Language) to create Business Process Models, Use Case Models and Use Cases. + Performed GAP Analysis, SWOT Analysis, ROI Analysis and Data Modeling. + Created Test Cases and assisted in Quality Assurance for Projects.
15/03/2007 - 31/08/2007	Business Analyst AXA - Equitable, New York, USA PROJECT + Development and Implementation of CSA application (Customer Service Accelerator), to process financial transactions. + Developed processes for financial transactions like Allocation Change, Fund Transfers, Minimum Required Distributions, Re-balance, Dollar Cost Averaging etc. GENERAL RESPONSIBILITIES + Gathered Business Requirements and created the BRD. + Developed Business Process Models, Use Case models and Use Cases for all transactions using UML. + Performed data mapping and created a matrix for effective synchronization between the back end database and CSA.
01/08/2006 - 14/03/2007	Business Analyst Duke Energy, North Carolina, USA PROJECT 1 + Integrated MicroGADS SQL Server database with NERCGADS database and supporting applications NERC (North American Electricity Reliability Corporation) reporting. PROJECT 2 + Development of NANTeL hub system to replace Peoplesoft Database, housing employee education and qualification data. GENERAL RESPONSIBILITIES + Identified the scope of projects and gathered business requirements. + Developed component models, Business Process Models (both current state and future state) and Use Case models using Business Process Modeling Notations and UML. + Performed GAP Analysis, Data Flow Analysis and Data Mapping. + Performed software demonstrations at client sites.