Calyon Bank Mumbai : Capital Markets Operation

[mskavi]

Company Name: Calyon Bank - India
Website: http://www.calyon.com

Company Profile
Calyon was formed from the merger of Credit Agricole Indosuez and Credit Lyonnais' Corporate and Investment Banking division. Backed by the Group's credit ratings and financial solidity, Calyon is now a leading player in financial markets.

Calyon has been present in India since 1981. Calyon India offers a comprehensive range of commercial & investment banking products and services, tailored to the needs of top international and local customers. Corporate Banking, Capital Markets and Investment banking, Trade Finance is amongst the core products being offered. International & Regional product lines are available to support Calyon India's local teams.

Calyon India ranks amongst the Top 10 foreign banks operating in India and amongst the Top 5 foreign banks for Capital Market products in the country

Officer - Capital Markets Operations
Calyon Bank - India

Experience: 2 - 5 Years
Location: Mumbai

Job Description
- Preparing the Daily Cash flows and managing Nostro Accounts
- Processing and Settlements of SLR Bonds and Non-SLR Bond Deals
- Reconciliation of Securities with the holding
- Brokerage & TDS Payments pertaining to Treasury
- Checking of Underlying documents from counter-parties
and ensuring timely filing of regulatory return and other required reports

Desired Candidate Profile
-CA/ MBA with 2-4 years experience in Treasury/ Capital Markets Operations in the Banking industry

Email Address: e-source@consultant.com

Keywords: Derivatives, Treasury, Capital Markets, Operations, Back Office, Bonds

[Guest]

AKHILESH SHARMA
Contact: 09827780076, 0755 2543694 (R)
E-Mail: akki_1963@yahoo.co.in, sharaman.akki@gmail.com


In quest of middle level assignments in Financial Accounting & Operations with an organisation of repute

CAREER PRÉCIS

- C.A. (Inter) with over 25 years of experience in the areas of Financial Accounts, Taxation, Audit.
- Currently working with Som Distilleries Pvt. Ltd., Bhopal as Deputy Manager Accounts.
- Strong analytical & organizational abilities with adeptness in formulating accounting systems and preparing accounting records / financial statements.
- Significant experience over the control on receivables & payables & their reconciliations.
- Keen understanding and significant experience in managing the tax procedures, statutory compliance and handling audits for the company.
- Proficiency in streamlining the working procedures, formulating cost effective solutions for enhancing the accounting and taxation operations.
- An effective communicator with excellent relationship building & interpersonal skills.

CAREER SKETCH

Som Distilleries Private Limited, Bhopal Deputy Manager Accounts since Oct’06

Win Win Automobiles Pvt. Ltd., Bhopal Manager (Accounts & Admin.) Apr’04-Oct’06
(A Mahindra & Mahindra Ltd. Dealer)

My Car (Bhopal) P. Ltd., Bhopal Chief Account Officer Jul’03-Apr’04
(A Maruti Suzuki Dealer)

C.I. Auto Motors Pvt. Ltd., Bhopal Accounts Officer Jul’01-Jun’03 (ATVS Motors Dealer)

Jain R. Kumar & Co., Bhopal Sr. Auditor Mar’90-Jun’01
(Chartered Accountants)

Rakesh K. Mangal & Co., Bhopal Sr. Audit Assistant Jan’88- Feb’90
(Chartered Accountants)

Dwarika P. Agarwal & Co., Bhopal Accountant cum Audit Asst. Sep’85- Dec’88
(Chartered Accountants)

AREA OF EXPERTISE

Finance & Accounts
· Supervising the timely preparation of statutory books of accounts and finalisation of accounts in compliance with the Accounting & Financial Reporting Standards.
· Evaluating the internal control systems with a view to highlight shortcoming & providing solutions for implementing recommendations made by Internal Auditors.

Auditing
· Conducting annual audits; evaluating internal control systems / procedures with a view to highlight the shortcomings and providing solutions to implementing necessary recommendations.
· Performing analytical review of financial statements and evaluation of internal control systems for carrying out Internal / Statutory Audits.
· Preparing Audit Reports and making recommendations in order to ensure that accounts are prepared and maintained in conformance to statutory obligations.

Taxation
· Handling the excise matters as required under the Excise Act involving submission of necessary data and reports with Excise Department With the help of the concerned experts.
· Overseeing Service Tax, Commercial Tax, Income Tax & Handling the Various matters. Preparing tax plans, ensuring timely assessment filing of returns as per the provisions of respective tax acts with the help of the concerned experts.

General Administration
· Preparing & maintaining records pertaining to Labour Laws like PF, ESI & Minimum Wages Act.
· Overseeing HR activities like recruitment, training, need assessment & preparing job profile as per Company’s requirement.

HIGHLIGHTS ACROSS THE CAREER
- During the period with the association of Chartered Accountant’s firms, undertaken Auditing for Companies & Big Trading houses & prepared the returns of Income Tax, Service Tax, Sales tax etc. During that period also worked as consultant and handled the Accounts of various companies like Hospitals, Housing Construction, Automobiles Dealers, Distributors & Super stockists of consumer products etc.
- Got the Excellence Awards in Som Distilleries Private Limited in 2007 for Best New Comer.

ARTICLESHIP

Dwarika P. Agarwal & Co., Bhopal Article Clerk Jul’82-Aug’85

EDIFICATION
- MBA (Finance & Retail) from Barkatullah University, Bhopal in 2008.
- C.A. (Inter) from Institute of Chartered Accountants of India in 1998
- M.Com. from Bhopal University, Bhopal in 1984.
- B.Com. from Bhopal University, Bhopal in 1982.

TECHNICAL SKILLS
- Certificate Course in SAP (FICO) Module enrolled in Dec.2008
- Certificate Course in “Tally Financial Accounting & recognized as Tally Certified Professional in 2008.
- Certificate Course in Tally from BITS (Bureau of Information Technology Studies), in 1998.
- Short Term Basic Course from Aptech Computer Center, Bhopal, in 1998.
- One-Year Diploma in Computer and Operation from SCAT Computer Center, Bhopal, in 1996.

PERSONAL DOSSIER
Date of Birth : 16th March 1963
Address : 28, Gulia Dai Street, Chowk Bazaar, Bhopal – 462 001, M.P.

[Guest]

1. HDFC Bank Ltd. (www.hdfcbank.com)

HDFC Bank Ltd. is recognized as the best Indian private bank. It has the largest presence in INDIA and now with the merger of Centurion bank of Punjab the largest ATM and branch locations across INDIA. HDFC Bank leads a conservative but growth oriented approach which is seen with the tremendous growth since 2005.

Duration Feb 06 – Mar 07
Designation Executive Officer (Stock Exchange Operations).
Responsibilities - Processing of -
- Fund Transfer Cheques.
- RTGS Processing.
- Confirmation of Margin and Additional Base Capital
- Handling MCX and NCDEX Customers .
Role / Job Description - Responsible of meeting exchanges deadlines of reporting funds position for funds pay - in of the brokers/FII and Custodian.
- Confirmation of Margin, Additional Base Capital to the exchanges of members having their clearing and settlement account with HDFC Bank both is capital and commodity segment.
- Identifying Risk areas and working on solution.
- Co-coordinating with various departments of exchanges and reporting of exact funds position of members to the exchange.
- Monitoring of intra-day funds position of members
- Maintaining of necessary intra day approval provided by credit authority
- Coordinating with various branches and internal-dept for speedy settlement of funds of the members.
- Assessing customer feedback, evaluating areas of improvement and implementing adequate measures to maximize costumer’s satisfaction.
- Preparing MIS reports with a view to apprise management of the market share, volumes, achievement, income generation and assist in critical decision making process.
- Working on internal and external audit requirement of the department.
- Responsible to follow and adhere to the guideline issued by SEBI and RBI with regards to capital and commodity market
- Knowledge of working on RTGS processing.
- for all above products and MIS reporting to Front Office and RBI
Products Handled - Products and working of capital & commodity market.
- Operation Management.
- Risk Identification/ Management
- Business Development and Process Improvement.
- MIS Reporting.
- Client Relationship Management.

Duration Mar 07 – Feb 08
Designation Assistant Manager (Treasury Operations).
Responsibilities - Processing of -
- Interbank Borrowing and Lending Deals.
- Netting of Deals.
- Currency Futures Processing
- Calculation of MTM entries .
Role / Job Description - Authorization of Inter Bank Deals, Borrowings and Lending done with other Banks and Broker Deals .
- Currency Futures processing
- Maintaining MIS
- Checking and maintaining details of Outstanding Contracts .
- Verification of MT300 Swift messages both Incoming and Outgoing and solving discrepancies of Counter Banks
- Checking of Reuter Confirmations held between the banks.
- Reporting of Outstanding Lending and Borrowings on reporting Fridays & Month end to MID Office.
- Preparation and posting of Interest Payment entries on daily & weekly basis.
- Identifying Risk areas and working on solution.
Products Handled - Foreign Exchange products like Merchant and Inter- Bank Contracts
- Settlement Operations .

Duration Feb 08 – Till Date
Designation Assistant Manager (Bahrain Operations).
Responsibilities - Processing of -
- Interbank Borrowing and Lending Deals.
- Merchant Contracts .
- Money Market Deals
- Securities .
- Derivative Deals
- Buyers Credit transactions relating to Trade desk
- Complete system setup for Treasury and Trade part.
Role / Job Description - Have done Complete Setup and UAT (User Acceptance Test) of Bahrain Treasury and Trade part .
- Have maintained setup for all modules related to Foreign exchange , Money market and Investment products.
- Handled all system maintenances provided by TCS and have maintained test cases for all treasury products in consultation with BPRG.
- Processing of all Interbank deals, Merchant contracts, Money market, Securities,and Derivatives deals on daily basis.
- Maintaining Nostro Balances, and Projected Cash flows on a daily basis and sent it to Various Departments
- Authorization of all FX and other Treasury products deals
- Processing Trade transactions like Loans , Outward and inward Remittances, Account opening , Guarantees, and Buyers Credit Transactions
- Doing Follow-ups with Counter parties for Deal confirmations and tracking of the Funding part for all deal maturities on every day end.
- Handling all setups and opening of counter party and accounting setups before doing a deal with new counter party.
- Maintaining MIS on daily basis and Treasury reporting on monthly basis and forwarding it to the concerned departments
- Filing up CBB Returns on a monthly basis to Finance department. And preparing Group Head data , all Expenses and Income, and Volumes done within a month time .
Products Handled - Foreign Exchange products like Merchant and Inter- Bank Contracts
- Money Market and Investment Products
- Derivatives Like CCIRS ( Cross Currency interest rate swaps) and IRS ( Intrest rate swaps) .
- Trade products like Buyers credit loans, Fund Transfers etc.

2. Softex Consultancy

Duration Jun 02 – Mar 03
Designation Accounts Executive
Responsibilities - Account maintenance.
- Client query handling.
- Quality sampling.
- Spreadsheet.
- Training.
Role / Job Description - Daily maintaining of Books of accounts
- Maintaining accounts & Keep Records of clients.
- Bank reconciliation of all Clients.
- Initiate necessary action towards filling the challans and payment of TDS to govt. authorities by due date.
- Calculating & Filling of monthly returns of Service tax.
- Assisting in Finalizations of accounts.-

SEMINAR & TRAINING

- Basic Banking (HDFC Bank Ltd )
- Certificate training program of HDFC Bank in overall banking activities.
- Banking seminar on commodity and Derivation markets.
- Banking seminar on Foreign exchange products
- Training on SWIFT conducted by J P Morgan Chase .

[Guest]

CYRUS SHAHRUKH BHARUCHA
E-Mail : cbharucha1 AT gmail.com
________________________________________
To incorporate my experience & financial knowledge for managing roles in the Financial Sector
________________________________________
SYNOPSIS
- PGDM (Finance) (2009), Welingkar Institute of Management, Mumbai.
- Appeared for Level II CFA, conducted by the CFA Institute, U.S.A.
- Passed FRM (Level I and II) conducted by G.A.R.P.
- Currently associated with Central Bank of India, Central Office, Mumbai as Senior Manager.
- Completed summer internship with IDBI Bank Limited, Treasury, Mumbai as a part of the MBA. curriculum.
- N.C.F.M. Certified professional in Derivatives Module, Debt Market Module, AMFI (Mutual Funds), Advisory Module and Options Trading Strategies Module.
- Competencies in organising multiple priorities, with a penchant for action and a genuine interest in personal and professional betterment.
- Team player endowed with a passion for winning.
WORK EXPERIENCE
Jul’09 – Till Date Central Bank of India, Mumbai Senior Manager
Direct recruit from college as a Management Trainee. Appointed as Senior Manager in June 2011.
Key Role :
- Financial Structuring of Portfolio Assignments to the Bank by Future Capital Holding, Reliance Capital and Tata Capital. Buyout/ Assignment of Loan Portfolio along with receivables from Equipment Financing, Loan against Property and Commercial Vehicle Loans. Assessing the risk associated with the Loan Pools by analysing the cash flow stress under various interest rate scenarios and accordingly arriving at the required Credit Collateral.
- Structuring of tie – up with Deewan Housing Finance Limited for joint financing of loan proposals.
- Profitability analysis for Bank’s Doorstep Banking Services.
- Analysis of high value Retail Credit Proposals falling within the designated powers of Central Office and placing the same before the Management Committee of the Board. Analysing the risk associated in the enforcement of security in such proposals, in co-ordination with the Bank’s Legal Department.
- New Product Development and modification of Bank’s existing Retail Credit Schemes.
- Part of the team that formulated Bank’s Reverse Mortgage Scheme.
- Played principal role in a team which formulated a pioneering scheme for paying coaching fees of students who desire to undergo coaching in reputed Institutes to prepare themselves for appearing in Competitive Entrance Exams for Higher Education. This was the first ever such scheme launched by any Bank.
- Preparing Board Notes for the approval of new as well as modified Retail Credit Schemes.
- Preparing and making monthly presentations to the top management of the Bank, on the performance of Bank’s Retail Banking Department.
- Conducting Loan Melas as well as making presentations to employees of various corporate houses and students from various professional colleges.
SUMMER INTERNSHIP
May’08 – Jul’08 IDBI Bank Limited, IDBI Tower, Mumbai Trainee (Market Risk, Treasury)
Key Role :
- Prepared report on Portfolio Return, Portfolio Volatility (Risk), Sharpe Ratio, Treynors Ratio, Jensons Alpha, Tracking Error, Markowitz Efficient Portfolio Hypothesis, Capital Market Line, Security Market Line (CAPM) and Portfolio Optimisation based on Sharpe Ratio Using Solver.
- Using Bank’s held for trading (HFT) Portfolio, Calculated Volatility by the Exponentially Weighted Moving Averages and Generalised Autoregressive Conditional Heteroscedasticity Methods as well as Value at Risk.
- Understanding fundamentals of Monte Carlo Simulation Techniques and its use for calculating VaR.
BUSINESS EXPOSURE
Jul’03 – Feb’05 Alpha Nutrition Business Manager
- Setting up family business of high grade nutritional and diet products.
- Increased clientele through active negotiation & networking. Gained new accounts such as Kellogg’s.
- Initiated PR activity with current & prospective customers; thus increased sales volumes.
OTHER WORK EXPERIENCE
Mar’05 – Sep’05 3 Global Services, Mumbai Senior Tech Support Executive
Key Role :
- Providing Technical Support to overseas customers.
- Ensuring continuous interaction with customers to address areas for improved service levels.
- Identifying improvement areas & implementing measures to maximise customer satisfaction levels.
- Guiding new recruits on calls.
SCHOLASTICS
PGDM (Finance) Welingkar Institute of Management, Mumbai 2009 67.70%
B.E. (Electronics) M.H. Sahoo Siddik College of Engineering, Mumbai 2002 II Div.
H.S.C. (Science) Bhavans College, Andheri (West), Mumbai 1998 73.00%
I.C.S.E. Maneckji Cooper Education Trust School, Juhu, Mumbai 1996 79.00%
Certifications :
- Appeared for Level II CFA, conducted by the CFA Institute, U.S.A.
- Passed FRM (Level I and II) conducted by Global Association of Risk Professionals.
- NCFM Certification in Derivatives Module, Debt Market Module, AMFI (Mutual Funds) Advisory Module, Options Trading Strategies Module.
ACADEMIC PROJECTS
As a part of M.B.A. curriculum
Title : NPA Management
Duration : 2 months
Team Size : One
Description : Prepared reports on various NPA resolution methods and provisioning done by banks for various types of assets.
As a part of B.E. curriculum
Title : Signal Timer
Duration : 6 months
Team Size : Three
Description : The project dealt with designing and programming the 8085, Microprocessor based Countdown Signal Timer.
Title : Dynamic Sensor Evaluator
Duration : 3 months
Team Size : Three
Description : This project dealt with the making of programmable microprocessor based device that displays India’s current population along with the time and temperature, which is used as a display at the bus stops, railway stations and traffic junctions.
COMPUTER SKILLS
- Proficiency in MS Office (Word, Excel and PowerPoint).
BEYOND CURRICULUM
- Actively took part in Inter College Volley Ball & Table Tennis Tournaments.
- Completed Jive & Salsa Dance Course at the Intermediate Level with the Terence Lewis Dance Academy.

[Guest]

NAME : Thevar Mahalakshmi Chellappa
E-mail Id : maha_thevar_02 AT yahoo.com
RESUME
Objective : “To attain progress in every field of work”
EDUCATIONAL QUALIFICATION :
Name Of the Course Name of Board Year of Passing Percentage of Marks
B.com (Banking &Insurance) Mumbai University 2009 76.9%
H.S.C Mumbai Board 2006 80.33%
S.S.C Mumbai Board 2004 61.46%
Computer knowledge :- Has completed 3 months MSCIT Course
Experience : Worked as concurrent auditor in few banks from past 1 and ½ year.
Audit done in the following list of banks in the following areas :
Name of Bank Department
Calyon Bank (Credit Agricole Group) Trade Finance Department
Axis Bank Trade Finance Department
ING Vysya Bank Treasury Department
ING Vysya Bank Private Banking
Achievements :
[A] Co-curricular Activities :-
1. Secured prizes in Banking Quiz Competition
2. Secured prizes for Quiz Competition
[b] Extra-Curricular Activities :-
1. Secured prizes for Poster Making Competition

[Guest]

hiKUNAL C. CHAUHAN
Email : kunalc.chauhan AT gmail.com
Objective
To contribute my experience, skills and domain knowledge in the finance industry by being an effective employee in the middle management tier enabling growth and profitability of the organisation while pursuing personal career growth.
Career Synopsis
- A successful professional with around 6 years of widespread experience in the Finance industry.
- Proactive leader with strong management skills and ability to complete work within timelines.
- A good team player who makes informed work related decisions.
- Builds strong working relationships based on cooperation and trust.
- Posesses strong analytic and solution providing abilities.
- Prioritizes tasks and defines strategies for increase in performance .
- Maintains a positive attitude towards work.
- Takes up challenging tasks.

Academic Qualifications
M.B.A (Finance) ITM Institute of Technology & Management .(Mumbai) March 2009
B.Com M.S.Unviersity (Vadodara) March 2005
H.S.C Gujarat Board March 2002
S.S.C. Gujarat Board March 2000
Certifications
NCFM Derivatives Market Dec 2009
NCFM Capital Market May 2006
Computer Skills
Operating Systems Windows 98, Windows 2000 & XP.
Application Software MS Office ,Tally, Falcon, Myfno
Terminal Software ODIN 9.10 (Fintech).NOW (NSE)

Business Skills
- Driving sales initiatives to meet desired targets with overall responsibility of return on investment and exploring marketing avenues to build client requirements and drive volumes.
- Conducting market analysis by keeping abreast of market trends to achieve market share metrics.
- Building and strengthening relationships with key accounts thereby ensuring high customer satisfaction by being a one point contact for all clients by providing them with complete support.
- Managing investor funds and mentoring investors for high return of investments and meeting investor goals by technically analysing potential stocks.
- Monitoring & motivating manpower & ensuring quality deliverables.
Work Profile
________________________________________
Since Mar 2009, Angel Broking Ltd., as Asst Branch Manager
Tasks
- Providing clients with a timely and relevant risk management analysis of their funds with an aim to minimize the impact of the sudden adverse market scenarios on the clients' portfolios, and thereby identify the areas of greatest concerns.
- Scrutinizing key accounts and mentoring clients for margin funding accounts and alerting them of market upkeep tending to maximise revenue.
- Ensuring high customer satisfaction by fostering dealings with HN1 clients, managing their portfolio, providing them with complete assistance.
- Managing team to ensuring team satisfaction and quality performance.
- Organising tasks to team, ensuring task completion and resolution of issues .
- Preparing status reports and organising reviews with management team.
________________________________________ Since Mar 2007- Feb 2009, Angel Broking Ltd., as Technical Analyst
Tasks
- Collecting and analyzing data on customer demographics, preferences, needs, and buying habits to identify potential markets and factors affecting product demand.
- Seeking and providing information to help investors with their trade decisions and stock picks.
- Assessing software used for trading and recording various stocks.
- Presenting investors with strong market momentum indicators for both Day Trading and Short Term Investing.
- Performing quantitative and technical analysis of stocks and charts to determine market trends and prepare forecast data.
- Attending conferences and meetings with the financial manager to prepare new strategies and plans for the investment.
- Providing solutions to customers problems and queries about the market conditions.
________________________________________ Since Jun 2005- Feb 2007, Angel Broking Ltd., in the Backoffice department
Tasks
- Performing account opening and activation processes for client data.
- Performing trade operations and handling transactions for clients in segments like BSE, NSE, F&O & MCX.
- Handling transactions for IPO/Derivatives Market.
- Handling KYC Issues for Clients.
- Keeping track of client data to address queries as and when required.
- Activation for Online Trading.(Odin Diet) and Online Fund Transfer & RTGS.

[Guest]

I have done MBA in finance and having 1.2 year of experience in Risk management. Presently i am Looking for credit risk analyst or quantitative modeler profile .Please find the resume attached below.
RAVI KANT
E-mail : ravisharmark AT yahoo.com ,
Objective :-
To seek the position of credit risk analyst and utilize my skills and experiences in analyzing all the possible financial risks for the company from its clients
Key Skills :
- Proficient with the principles, practices, terminologies and calculation tools related to derivatives analysis
- Result oriented attitude towards work with emphasis on accuracy, detailing and overall excellence
- Ability to multitask and prioritize to ensure accurate and timely completion of work
- Excellent written & Quick learner
Experience
Deutsche Bank Bangalore, India from (June 2010 to May 2011)
Designation : Analyst
Division : Corporate Investment Banking
Responsibilities :
- Quantitative and qualitative review of models to deem fit for monthly usage in order to calculate risk-weighted assets and minimum capital requirements. This involves extensive coordination with model developers and ensuring gap closures concerning technical and business related issues.
- Excel modeling for CDO,s , valuation and calculation of the Future cash flow
- Keep track of the market risk, liquidity risk, default risk and report & advice to the top level management.
- Rating & calculate the risk associated with MBS,ABS,CDO, loan and other stock market transactions and report the top level management.
- Rating the corporate & the portfolio
- Handling (credit, rates and Equity) OTC plain vanilla & exotic trade and calculate the risk exposure with regard to Basel norms
- Work with various department in order to fine the seriousness of risk and work for process improvement
- Carried out study the financial statement analysis, financial rations, debt service capacity, liquidity and overall credit risk to evaluate the seriousness of risk
- Assisting the internal clientele with counterparty specific information and ensuring to accomplishment the Fed targets.
- Run the macros in order to interdepartmental reporting & MIS Reporting purpose
- Reporting to Senior level management under Basel 2 and maintain the database
- Reviewed legal documents.
- Presented ideas via reports and presentations, outlining findings and making recommendations for improvements.
- Knowledge of credit analysis and financial modeling & Advance excel
- Summer Internship Training cum management trainee Three months (Full time) Reliance Communication Ltd.
- Valuation of Company- Taking the firm specific factors and impact of overall economic factors into account.
- Use the quantitative model like CAPM, DDM and FCF model to find out the value to the company.
- Use the P/E and Depts./Equity ration, ROE, ROI, and other ration to make the fundamental analysis of the company
- Analyses the financial statements and studied the annual reports of the company.
- Statistical analysis of the industry and the company growth rate
Skills developed :
- Financial Report Writing
- Financial Statement Analysis
- Empirical Research and Event Studies
Final project
- Final project on NPAs, analyzed the various risks faced by bank like credit risk operational risk and default risk and their impact on banks.
- NPAs impact on the profitability of the banks and the share price of the banks
- Statistical analyst to fine the correlation among the variables
- New provisions effectiveness in relation to NPAs
- Use the statistical techniques to fine the correlation between NPAs and market values of the share.
- Excel Modeling for EAD, LGD and PD
- Comparative analysis of the SBI NPA,s and the three private sector bank and how its effect their profitability
Project on VaR- :
- Use Two techniques to calculate the VaR : Historical and Parametric Delta Normal technique
- Calculate the logarithmic return , variance in the excel sheet of the monthly stock price of Citi Bank stock price
- Assigned different scenarios of significant level or confident, in order see the effect of this in chance in VaR.
- Use Marcos and done VBA coding to calculate the VaR through Parametric Delta Normal technique
- Use the Monte Carlo Simulation technique to calculate the return in various scenario and its effect on the PF VaR
- Use the ad-hoc tool for presentation and analysis purpose
Research interest - : Markowitz theory of portfolio analysis, research of the emerging market and statistical analysis of the financial market.
Professional Qualification- :
- Post Graduate Program in Management (August, 2008- May, 2010)
- Specialization - : Finance & Marketing CGPA -: 3.72/5 (74%)
- Minor - : Marketing
- Institute - : Bharatiya Vidya Bhavan (BIMM)
Module
Quantitative technique, market research ,Managerial economics , computer application ,Entrepreneurship , Theory of Finance 1&11, operation research , International business , International Finance, Financial Services , Security analysis& Portfolio Management, Project Appraisal and Finance and Strategic Management Ect.
Academic Qualification- :
B Com from Himachal Pradesh University (Shimla) in 2008
Module :- Economics, Mathematics, Statistics, Accounting, financial accounting, Management Accounting, Cost Accounting, Business law, direct &indirect Tax, Computer Application Money and financial system and Auditing Ect.

12th from Him Public Sen. Sec School in commerce from Himachal Pradesh School Education Board in 2004

10th from Himachal Pradesh School Education Board in 2001

Projects Undertaken :
Project on Option Pricing :-
- Pricing of the option through Black Scholes Model
- Pricing the European style and American style options
- Modeling through VBA in Excel to pricing option
- Statistical analysis to fine the relationship among various variables that affect the price of the option
- Calculation and modeling of Delta, Gama , Vega and Rho in excel
- Live Project With JK Tyre On Working Capital Management
- Simulation game in marketing and finance on banking sector which help to understand the overall management and strategies involved in running the organization
Computer Knowledge :
- Knowledge of MS Excel, MS-word, MS-PowerPoint, Tally
- Macros and basic of VBA
- SQL
- FINCAD
- OS : Windows XP/Vista
Achievements :
- District level Badminton player
- Coordinator of volleyball team
- Group leader in the finance modules
- Participated in the finance fest and represent the college and won the prizes
- Active member of NEN program
Personality Skills :
Team player, quick learner, self-motivated & energetic person, effective communicator, good leader, initiator and very enthusiastic person

[Guest]

Respected Sir ,

I would like to share my resume for current job openings in your bank.
Thanks & Regards
Seema Khetan