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.

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

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

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

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

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

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

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

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

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

<p>Completed articleship with city’s renowned firm<br>
Completed major bank audits<br>
Completed project finances assignments<br>
Completed investment advisory assignments<br>
Completed portfolio management assignments</p>