Mr. PARTHA PRATIM ROY
Address: Block–636B #02–643, Punggol Drive, Singapore – 822 636
Mobile: +65 8133 0449
Email: roy.hereiam@gmail.com
Summary:
A high-energy, proactive, dynamic, enthusiastic and results-oriented professional with 14+ years of IT experience of which 7+ years in Investment Banks on market and credit risk space with hands-on software design, development, impact analyzing, delivery with specialization in Microsoft Technologies.
Strengths include:
• Hands on experience in multiple core technologies in VB, VBA, Excel, COM, DCOM, Access, SQL Server, Sybase, VB.Net, C#, Winforms.
• Demonstrated strong expertise and competence in business analysis, data analysis, RAD Development, preparing different document like BRD, FSD, tech spec, test cases, development & support to the different projects in the area of Market Risk (Investment Banking) and Credit Risk related RAD and strategic applications.
• 7+ years of experience in building applications for businesses and possess knowledge – Risk Management, Market Risk, Credit Risk.
• A Microsoft Certified Software Professional in .Net and Brainbench Certified Professional in the area of C#, VB.Net, VB 6.0, COM/DCOM, RDBMS Concept, SQL (ANSI) and Project Management 2005.
Career Achievement:
• Automated risk applications to reduce the operational cost and risk and improve the performance. Developed and automated the process to generate and submit different credit reports and reduced the risk of regulatory reporting submission failure.
• Successfully structured, designing, planning, developed and managing the data migration on different Risk applications and delivered projects on Limit Exposure, Portfolio Management, Reconciliation systems, Valuation, Risk Management Systems.
• Proficiency in building credibility, establishing rapport and managing expectations of global /local stakeholders in projects. Involved gathering user acceptance from stakeholders by proper communication and testing strategy.
• Taken charge of Credit Risk EUDA (End User Developed Application) items, which are built using VBA, Excel, MS Access and close 50% High priority EUDA (End User Developed Application) items in record time and received Certificate of Excellent award (RBS)
• Received SPOT AWARD from the management for my good performance, sense of commitment and dedication (KEANE).
• Implemented security framework in order to secure the file based Excel tools’ risk/counterparty related data to adhere regulatory compliances.
Work Experience:
• Worked in RBS, Singapore as Risk Tech Business Analyst from Mar 2010 to Dec 2015.
• Worked in Barclays Capital, Singapore as Associate from Sep 2007 to Feb 2010.
• Worked in Mphasis (an EDS company) India Pvt. Ltd., India as Senior Software Engineer from Apr 2007 to Sep 2007.
• Worked in KEANE India Ltd., India as Software Engineer from Jan 2006 to Feb 2007.
• Worked in Webtech Softwares & Services Ltd, India as a Project Leader from Aug 2003 to Jan 2006.
• Worked in Infoscribe India, India as a Software Developer from Sep 2002 to Jul 2003.
• Worked in STG International Ltd. (S.S.M Computers) as Technical Executive from Sep 2000 to Sep 2002.
Professional Certification:
• Microsoft Certified Technology Specialist - (MCTS - 2008) and Microsoft Certified Professional Developer (MCPD – 2008). Microsoft Certified Professional ID: 6393565.
• Have completed Certified Business Analysis Professional (CBAP®) preparatory course from NUS on Jan-2016.
Area of Expertise:
Primary Skillset: VB6, COM, DCOM, VBA, Excel Addin, SQL, Access, VB.Net, C#, Winforms, WPF, WCF,
Project Management: SDLC, Change management, MS Project 2007, Scheduling, Tracking
RDBMS: SQL Server 2008/2012, Sybase, Oracle
Web Technologies: ASP.net, WCF, Webservices, XML, XSLT, HTML, ASP, JavaScript, VBScript, IIS,
Operating Systems: Windows, UNIX, Linux, Shell programming
Tools: Visio, Jira, Perforce, SourceSafe, Clear case, PVCS
Mar 2010 – Dec 2015 Royal Bank of Scotland (RBS), Singapore
Risk Tech Business Analyst
Team: Risk IT
Technologies : VBA/Excel, MS Access, Sybase, C#, SQL
Expertise: Market Risk, Credit Risk
Role: Business Analyst, RAD Developer, Technical Support.
Responsibilities:
• Hands-on developer in multiple core technologies – VBA/Excel, MS Access, Sybase, C#/VB.Net, SQL.
• Handling upstream releases, impact analyze and coordinate as a Business Analyst. Preparing different document like BRD, FSD, tech spec, test cases, development & support to the different projects.
• Worked as an analyzer, designer, RAD developer and single handedly have completed all projects without any issue and with quality.
• Supporting the Risk Reporting function as an independent adviser to verify controls and assess their implementation and effectiveness in mitigating operational risks.
• Analyze Documenting, Structuring, Developing, Managing and delivering Projects and BAU works.
• Perform source system data, manage source to target data mapping, migration and testing different system’s data and creating requirement report.
• Manage processes, applications and techniques for the project delivery and BAU works.
• Influence, negotiate and co-ordinate with business users, Operations and other development groups to deliver projects.
• Supports obtaining sign-off of business requirements.
• Conducts change impact analysis to assess and document the potential implications.
• Preparing test cases (and steps) and conduct the functional testing to ensure all functional, technical impact scenarios have been covered and all requirements are accurately delivered.
• Supports and co-ordinates UAT.
• Managing 3rd line of support for Production Issues for entire APAC region.
• Mentor, help, nurture new and existing team member for the delivery of Projects.
Key Achievements:
• Successfully automated the market risk calculation and report generation tool i.e. NV Risk Reporting system named R2, which developed using VBA, Excel and MS Access technology. Later help to decommission this application.
• Taken the charge of Credit Risk EUDA (End User Developed Application) items (RAD Applications) that are built using VBA, Excel, Access and close 50% High priority EUDA items in record time and received Certificate of Excellent award.
• Close different Credit Risk SONAR RAD items in short time by developing them in VBA/Excel, Access.
• Helped to migrate few Excel based Risk application into strategic system and decommissioned them.
• Successfully delivered different EUDA items (RAD) like Nostro, JFSA, Mark to Market, Repo which calculate exposure, limit excesses, controlling limit and generate report for regulatory.
• Done multitasking to handle different upstream releases by doing proper impact analysis/assessment and communicating and coordinating different team + stakeholders.
• Take the responsibility of feed loading task in Market risk system when working on other item in Credit Risk.
• Steering Meeting: Influence and work with operations, Traders, stakeholders for the buy-in and prioritization of projects.
• Conducted workshop in Excel (advance) to the RBS global business risk users/managers located in different location Like Singapore, China, Hong Kong, Tokyo.
Sep 2007 – Feb 2010 Barclays Capital, Singapore
Associate
Team: MARS (Market Risk)
Technologies : C#, Winforms, SQL Server, ASP.net, C#, WCF, VB6, COM, Unix, Linux, Sybase, Unix, Perl.
Expertise: Market Risk, Risk Management.
Role & Responsibilities:
• Development and enhancement of different work items and solve production issue for the different kind of applications.
• Working on developing new applications (as per user requirements) enhancement of the existing applications, system analyzing, coding, screen designing, code review, handle team of 2 people, self-motivated
• Understand technical requirements, preparing Tech spec based on Functional spec, test plan and project related documents.
• Involve developing feed script in Perl and also taking part to develop new DB script (table, stored procedure, trigger etc) for Sybase and SQL Server as per application requirements (keeping eye on the SQL performance).
Key Achievements:
• Successfully developed and deliver item on time.
• Implement new module in C#, Excel Addin and handle them independently.
• Enhance performance on querying production database by introducing new C# Excel Addin will allow power users to query Sybase database as required in more controlled pattern thus restricting database performance deterioration due to adhoc query run against production database.
Apr 2007 – Sep 2007 Mphasis (an EDS company) India Pvt. Ltd.
Senior Software Engineer
Technologies: ASP, VB6, COM, DCOM, SQL Server.
Team: Payment gateway (Telecom domain)
Role/Responsibilities:
Analyzing, coding, development, maintenance & support, monitor jobs, performs coding, unit testing of the assigned work request per the set coding standards and guidelines.
Jan 2006– Feb 2007 KEANE India Ltd., India
Software Engineer
Technologies: VB, ASP, HTML, JavaScript, COM+, SQL Server, VBA
Team: Insurance Domain (Hanover)
Role/Responsibilities:
• Problem Solving on existing modules / Functionality / Programs
• Modifications of existing functionality to fix the reported problem
• Providing Clarification/Information on Request on existing Applications / Data.
• Development of new modules or programs in support of or as an enhancement to existing systems
• Development of documentation for the existing or new modules.
• Enhancement to the existing modules to provide additional functionality
• Maintenance, support, analyzing, coding, developing, screen designing, client Interaction. Preparing Tech Specs based on the FSD, Test Plan (UTP), Test Result (UTR), & Other Documents.
• Perform coding, unit testing of the assigned work request per the set coding standards and guidelines.
Key Achievement:
• Played a major role in respect of critical enhancement and delivery project item in a speculated time.
• Received SPOT AWARD from the management for my good performance, sense of commitment and dedication.
Aug 2003 – Jan 2006 Webtech Softwares & Services Ltd., India
Project Leader
Technologies: ASP, VB6, COM, DCOM, SQL Server, .Net
Role/Responsibilities:
• Interacting with client and understanding client requirements
• Effort estimation, project tracking and scheduling,
• People management, Generation of functional specs, review technical specs, also take part to the code review, Analyzing, Coding, Developing, Preparing Tech Specs based on the FSD, Test Plan (UTP), Test Result (UTR), & Other Documents. Perform coding, unit testing of the assigned work request per the set coding standards and guidelines.
Sep 2002– Jul 2003 Infoscribe India, India
Senior Software Engineer
Technologies: ASP, VB6, COM, DCOM, SQL Server, .Net
Role/Responsibilities:
Analyzing, coding, development, maintenance & support, monitor jobs, performs coding, unit testing of the assigned work request per the set coding standards and guidelines.
Sep 2000– Sep 2002 STG International Ltd. (S.S.M Computers), India
Technical Executive
Technologies: ASP, VB6, COM, DCOM, SQL Server, .Net
Role/Responsibilities:
• Handling corporate batch and train them in different technology like Windows, Microsoft office, .Net, RDBMS.
• Handling small project and analyzing, coding, development, maintenance & support
Education:
• M.Sc (IT), from Karnataka State Open University, India (2004).
• Advanced Diploma in Information Technology (ADIT) from IGNOU, India (2002).
• B.Com (Hons. In Accountancy) from University of Calcutta, India (1999).
Interests/Hobbies:
Photography. I like to spend my free time with my Camera. I like to take picture of landscape, cityscape, architecture. Fine art photography is one of my favorite. I do participate in international photography competition and have won many awards too.