Sunil Kumar Bansal
Professional Summary
Business Analyst with 12Y of capital markets experience focused on OTC derivatives market with trading domain.
Worked as algorithm trader for doing arbitrage trade in NSE for portfolio value ~ 20M INR, using various strategies on
equities, index (nifty50 & bank-ex)
Expertise on derivatives instruments like Forward/Future/Options/Swap for various underlying asset class’s like
Equities, FX, Commodities, Bonds etc. Worked on OTC & Ex traded market for buy and sell side. Well versed with
trade life cycle, order/risk management system, clearing/settlement, cash flow, reconciliation, regulatory reporting &
major regulatory reforms like Dodd frank & MiFID2
Measureable Outcomes
— 9.2% revenue growth — Up to 45% in efficiency gains
— $575K capital-expense reduction — $1.1M labor-cost savings
Functional Skills
Exceled as liaison between the trading desk and developers to expose informational, analytical, workflow-
optimizing needs & defining the scope of the project
Accountable for eliciting requirements from users and producing use case scenarios and functional
requirement documentation to ensure that requirements were accurately as specified, communicated and
understood by the technical implementation team
Design process diagram, activity diagram, use cases, end to end data flow and also preparing the screen
mockups and design
Interact extensively with the SME`s to understand product and processes thoroughly. Identified opportunities
for business process improvement through various meetings with business users and developers
Analysis of requirements, creating and maintaining the BRD/FSD to include the business requirements,
technical requirements, non-functional requirements and error handling based on the analysis performed
Identified the business experts for quality data and analysis and set up meetings with cross-functional teams
Interact with technology team to understand the data and information in the systems used and to provide
inputs to help design and development also take required sign off on reference date
Conduct JAD session & trainings for the team on product, processes, usage of systems
Reporting on the likely impact of process modifications & flagging up potential problems at an early stage
Involved in trade life cycle for exchange traded &OTC financial instruments for various asset classes like
Equities, FX, CCY, Bonds and their corresponding derivatives
E2End understanding of trade life cycle at various level of Front/Middle/Back Office i.e. from order initiation,
Risk management, order routing/matching, affirmation, confirmation & clearing and settlement
Extensively worked on databases like Oracle, SQL, Sybase with expertise in writing PL/SQL blocks
Major Organizations
Currently working as Principal Consultant with Genpact Headstrong Capital Market since Nov 2014
AVP in MARKIT from APRIL 2012 – Aug 2014
Consultant in Capgemini from Mar 2010 – Nov 2011
Trader with Estee Advisors from Nov 2009 – Mar 2010
BrickRed Technologies, from July 2006- Oct 2009
Professional Experience
Client :- Jefferies Nov 2017 –Till Date
Off-Shore Business Analyst Genpact HeadStrong
Best position to clients’ investment thesis to achieve the highest valuation on their equity offerings and lowest yield on
their debt offerings. Jefferies acts as bookrunner in one in every six IPOs priced in the U.S.
Roles & Responsibilities
Head Change management from off-shore, heads up with cross functional teams on progress
Created metadata catalog to form data lineage b/w upstream & downstream
Optimization on business rules during framework migration from Informatica/Oracle to AWS cloud/S3
Involved in writing complex PL/SQL blocks to carry out testing UAT testing
Environment & Tools: Oracle 12g, UNIX, Informatica 10.1, AWS S3, Excel, SharePoint
Client :- RBS Nov 2014 –Oct 2107
Lead Business Analyst Genpact HeadStrong
Analyzing bank’s market position and running figures through complex historical modeling techniques to find value at
risk (VAR) measurements
Roles & Responsibilities
Ensure changes made to historical VaR calculations work properly, existing processes remain unaffected,
and the needs of the users are met
Provide the support to development by reviewing the application design document and test cases during
development and testing phase
Presenting market trends via reports and presentations, outlining findings and making recommendations for
improvement
Environment & Tools: Sybase, SVN, Linux, Jenkins, JIRA, Excel, Visio
Product:- TOTEM April 2012- Aug 2014
Sr. Business Analyst Markit
Totem is a comprehensive service providing consensus market prices to major OTC derivative market-makers. It
covers a broad range of asset classes and enables market-makers to independently check their book valuations
Roles & Responsibilities
Daily consensus pricing based on quorum across a broad range of asset classes and their respective
underlying derivatives like swap, swaptions, to major active market participants in OTC derivatives
Individually ensure that historical data migration successfully from various sources like different databases,
flat files to normalized table
Environment & Tools: Oracle 10g, SQL Loader, SVN, JIRA, MS-Office
Client :- Inter continantal Exchange (earlier IDC) March 2010- Nov 2011
Business Analyst Capgemini
Greater pre-trade transparency support and price discovery throughout the trading day across multiple fixed incomes
asset classes
Roles & Responsibilities
Manage change to daily continuous pricing, best execution, liquidity, portfolio valuation for
IG/HY/MANISH/AGENCIES bones and more
Implement changes to business rules to incorporate Dodd grand and MiFID regulations changes
Environment & Tools: ALM 12.1, MySQL, SBM, SVN, Linux, Jenkins, Visio
ALGORITHM TRADING Nov 2009 – Mar 2010
Trader Estee Advisors
Estee Advisors is focused on making risk less profit using various arbitrage betweencash/futures/options.
Roles & Responsibilities
Responsible for monitoring the ongoing trades to ensure arbitrage strategy generate absolute returns
Simulate market like condition to test various running strategies b/w cash-future, future-future and 3 leg
order cash-future-option
Environment: Windows based application developed on Dot Net Frame using C#, SQL sever 2003
Client:- FINRA Oct 2007 - Oct 2009
Business Analyst BrickRed Technologies
FINRA is dedicated to investor protection and market integrity through effective and efficient regulation of broker-
dealers industry to operates fairly and honestly.
Roles & Responsibilities
Requirements gathering and Analysis to assist in the preparation of test plan.
Doing data mining, transforming and loading (ETL) for execution based on functional requirement.
Doing environment set up for job execution in UNIX server.
Write complex SQL queries and debug stored procedures for troubleshooting
Environment: Web based application, SQL 2005, Visio, and MS Project Plan
Client:- ECR RETAIL (UK) July 2006 to Oct 2007
Business Analyst BrickRed Technologies
ECR is one of the oldest EPoS providers in the world. For over four decades systems have been deployed in the
Retail, Hospitality, Ticketing, Leisure and Banking industries, across four continents.
Roles & Responsibilities
Test cases design and execution based on functional requirement.
Environment set-up like running updated SQL scripts ensuring all windows and web services are running
successfully, configuration file set-up etc.
Preparation of project related documents and Deliverables e.g. Crystal reports, status report, user guide,
environment setting documents release document.
Environment: Windows application on .Net Frame1.1, SQL sever 2000
Education
Bachelor of Technology in Electronics & Communications from KIET affiliated to U.P.T.U (2001-2005)
Personal Details
DOB: 20April1982 Mail: sanju5626@[Link] Mobile: 9910423888 Passport: R2665314 Reference: On Request
