Rakesh Sharma

Roles and responsibilities
1. As FE: Solution design and implementation planning and resourcing of right candidate to right job.
2. As BA: Project work discovery and estimation, work scope estimation, impact analysis, interface file specification for development, review meetings with business and getting their approvals, keeping all documentations and publishing on confluence pages and BSRP story board.
3. As Test results reviewer: designing testing scenarios, huddle with solution designers, developers and testing teams, helping on workflow design, review test results first before approaching business teams to sign-off story. Securing sign-offs after addressing business reviews. Conduct PIV after go-live.

Project Delivery Lead in Treasury Data Mart
Delivered Lease contracts migration in Treasury Data Mart (entire New Zealand Portfolio) from the new cloud system
Secured business sign-off on mandatory due date set by RBNZ
Integrated downstream applications
Delivered the project within 3 months
Used SQL and Visual Studio
Delivered Deposit portfolio migration to the newly bought system (Finacle Core Corporation) from legacy systems on-time
Delivering loan portfolio migration to Finacle
Delivering FX portfolio migration to Calypso system
Delivering Foreign Currency overdraft loans and deposit accounts migration to Finacle
Delivering FX Rates replacement and sourcing from Calypso system
End-to-end delivery with various integration
Delivered FTP Strategic Project Solution from scoping to development and test stories
Handled project and non-project components
Handled regulatory requirements from regions to regions
Solution design and implementation planning
Resourcing of right candidate to right job
Project work discovery and estimation
Work scope estimation
Impact analysis
Interface file specification for development
Review meetings with business and getting approvals
Maintaining documentation and publishing on Confluence pages and BSRP story board
Designing testing scenarios
Huddle with solution designers, developers and testing teams
Helping on workflow design
Reviewing test results before approaching business teams to sign off story
Securing sign-offs after addressing business reviews
Conducted PIV after go-live

Project Delivery
Delivered Valuation in Resolution (ViR) project for the entire Group and all Material Legal Entities (MLEs)
Designed and developed the solution in SQL database using Power BI visualization tool
Delivered Capital MI pilot project for ASA (Asean Countries)
Designed and developed a fully automated process in .NET C# and SQL and Power BI
Reduced 4-day latency to 4 hours
Delivered SEC Schedule -1 Focus regulatory reporting solution for the entire Group
Covered the bank’s entire derivatives portfolio (solo and non-solo)
Segregated each line item into 4 categories reportable under SEC or CFTC or Both as per FOCUS rules
Delivered automation of SEC, PMI and RMI data feeds using SQL and C# into RAD Server
Finished data sourcing, data modelling and data download portal design for the SCB Group internal users

Ensured company goals are met including business development, accurate data analysis, product development and seamless delivery of deliverables to clients
Introduced DataIntel’s dashboard and modelling service offerings in India, Silicon Valley and Hong Kong
Negotiated partnership talks with current service providers
Managed permanent developer team of 4 people and 12 on contract
Completed 4 projects successfully with client sign-off
Added NLP and interactive charts/visualization tools using Apache Tika and Solr environments to DataIntel’s dashboard
Fraud detection project for a client in APAC
Investigated millions of data rows and columns to detect rigging online gaming portal
Data extraction and abstraction for 3005 US Municipal counties from bond issuance documents using NLP techniques for an outsourcing agency in India

Enhanced DerivaXL suite Fixed Income module to cater market risk and mark-to-market valuations of interest rate exposures and derivatives
Provided offshore modelling support to partners for MBS and other Structured Products
Supported valuation (FMV), liquidity risk and stress testing
Occasional blogger on financial modelling topics and emerging trends in financial markets

Advisory Services Associate role from March 2012 to June 2014
Advisory solution delivery roles in behavior models, liquidity risk management and liquidity stress testing, ALM advisory solution
Responsible for advisory project deliveries in behavior modeling and empirical research
Responsible for balance sheet management and stress testing in liquidity and credit risk
Provided full assistance in sales cycle from pitching to defining service orders
Delivered advisory projects and recovered final payments
Independently delivered behavior models for a top tier bank in ASEAN region
Built prepayments for loans, usage of revolving credits and repayment by customers models
Built core, volatile portion of deposits and run-off percentage models for conventional, Islamic and investment banking
Completed model validation for funds transfer pricing (FTP) and liquidity management in Oceania region
Modeled term, replicating and pooled products at product and portfolio level
Handled interest rate modeled and non-modeled classification
Handled core / non-core classifications
Handled run-off and prepayment behaviors
Handled option cost and liquidity premium
Worked with different funding curves and spreads and related cost of funds at matched maturity
Developed liquidity stress testing methodology combining major economic indicators and behavior models of prepayments and deposit run-offs
Covered cash flows-at-risk under stress scenarios
Provided hindsight on Potential Future Exposure under BASEL II CEM

Active trader in Indian exchange traded derivatives market
Used strategies based on quantitative research and Indian market dynamics
Executed intraday spike trades, gamma trades and monthly spread trades
Continuously monitored put-call parity, gamma, speed, vega and DvegaDtime of longer term trades
Provided consultancy to a pool of investors on range of derivatives

Priced exotic products and structured products
Performed in-depth analysis of pricing factors
Arranged essential components for pricing from market data vendors
Wrote VBA code for model variable calculations
Calculated implied volatilities, volatility surface, target profit barrier and instantaneous correlation
Bootstrapped default probabilities from CDS data
Executed pricing and delivered to clients under time constraint
Performed quantitative investigations on sanity checks of valuations after running executable
Troubleshot code fixing and stepwise investigation on calibration output, RMS fit, variable insertion and valuation output comparison
Checked computational efficiency of pricing engines including time and memory consumption
Provided training and support to clients and in-house personnel
Implemented path dependent Heston SV Model
Performed pricing validation for Callable Bonds with Parisian factors issued by GoldCorp
Implemented Target Redemption FX Forwards for Citic Pacific and Virgin
Implemented Correlation Product Module for Mitsubishi UFJ
Performed model testing, validation and valuations for Yen-Dollar Quanto Note / Swap with embedded barrier for Toppan Photomask
Performed basket first to default credit link notes valuations for IDA Singapore
Bootstrapped default probabilities from CDS data for embedded credit clause valuations in Cross Currency Swap portfolio for Royal Ahold
Gathered market data and performed special coding on QuIC platform
Developed customized zero curve template in VBA for exotic interest rate curves
Contributed to simulation models for exotics like Principal Protected Notes and Return linked notes

Provided best solution to clients in modeling in the system
Handled valuation queries
Analyzed hedge effectiveness between hedge instrument and exposure and its accounting treatment
Handled derivatives pricing and risk report queries including stress testing, Greeks and volatility behavior in different markets
Provided consultancy on economic / interest rate environment and associated market risk
Provided derivatives pricing to global fortune 500 clients
Coordinated between various teams to deliver best to clients
Performed model validation of interest rate products including exotics, FX product and single name CDS product
Built Reval zero curve bootstrapping, hazard rate bootstrapping and FX curve construction in spreadsheet for audit purpose
Received Best Team player award for Q3 2008
Received highest score in client satisfaction and compliments from clients

Proposed and managed research based portfolio in emerging market ETFs, commodity futures and bonds to capture arbitrage opportunity
Used econometric modeling of different asset classes
Portfolio was a balanced hedge
Achieved 3 months return of 40% on $1.5 million portfolio at the time of credit crunch
Developed and customized Monte Carlo simulation model for risk analysis
Optimized the entire portfolio with mathematical programming in VBA, EViews and MATLAB