
Shalini Varshney
- Senior Business Analyst, Data Analyst & Project Manager
- Hoobken, NJ
- Member Since Mar 04, 2023

SUMMARY:
§ Solution driven, detail oriented SENIOR BUSINESS ANALYST, DATA ANALYST & PM
§ Courageous, dynamic, confident self starter & a team player
§ Last twelve years’ experience across Collateral Risk, Core Banking, Market Risk & Counterparty Credit Risk, Client On-boarding, Compliance, Investment Research, Broker Dealer Services, OTC Rates & Credit with over fourteen years’ across financial, IT and energy sectors building trusting partnerships with some of the most demanding clients, key stakeholders and technology teams based on “trust”, “delivery”, “disposition”
§ “Exceptional” written and verbal communication skills
§ Self initiated in depth data analysis, improvement initiatives and performance metrics to deliver gains in business and systems performance; Proven analytical and strategic problem solving skills
§ Facilitated business process clarity & effective design using prototyping & modeling including UML – Class, Object, Use Case, sequence & free flow diagrams; Resolute determination to enable solutions & efficiency helped identify faults and turn around key Business Processes
§ Experienced in full SDLC, penned documentation at every stage including QA & UAT; developed User Guides, trained users & technical teams
|
· Critical Thinking, Analytical & Problem Solving |
· Requirements Traceability |
|
· Business Analysis & Project Management |
· BRD, FRD, Use Cases, UI Mockup, Wireframes |
|
· Financial Services and Banking Industry |
· Prototyping, Process Flow, User Guides |
|
· Requirements Elicitation and Management |
· Multi Tasking & Prioritization Skills |
|
· Data Analytics & Reporting |
· SDLC, UML, ER Diagrams |
|
· Business Process & Decision Modeling |
· Joint Application Development (JAD) |
EXPERIENCE:
Bank of Tokyo-Mitsubishi UFJ, NJ Jan 2017 – Dec 2017
Sr. Business Analyst, Market & Credit Risk
Dharma is a Risk application facilitating Market & Credit Risk functions such as CVA, PFE, VAR & EPS. Transaction, Position, Market, Instrument, Client & Collateral data is sourced from upstreams, staged, transmitted to Risk Engines (Risk Metrics) and final results captured back in Dharma for reporting.
§ Spearheading analysis of Counterparty tagging for Volcker, CVA Automation & Reengineering, & Counterparty Completeness & Accuracy of Collateral, Agreement, Ratings & Counterparty Reference data
§ Analyze, distill, articulate requirements; Author Business, Functional Requirements Documents
§ Use Cases; UI & Output mock up; Solution Modeling; Key business element mapping, Process & Data Analysis
§ Decoded SQL & RML (XML based Risk Metrics input files) source files to draw up business process & data flows
§ Interface with Business, PMO & Technology stakeholders; Ensure end to end delivery
Bank of America Merrill Lynch, NJ May 2014 – Oct 2016
Sr. Business Analyst, Collateral Risk Technology
Led analysis & delivery of a suite of Regulatory initiatives, impacting management, mobilization & transformation of collateral, including Broker Dealer Separation, (REI) Resolution Plan Rule under Dodd-Frank Act, LCR BASEL III, Regulation W, 5G, Uncleared Margin Rule and (Spear) QFC Recordkeeping.
GCDB (Global Collateral Database) is a DB2 collateral data repository & GCDW (Global Collateral Data Warehouse) is the Sql Server reporting layer providing visibility into firm and client collateral via data marts & an in-house reporting tool. As strategic collateral systems of record, GCDB & GCDW fulfill the data sourcing needs for firm wide reporting including regulatory.
§ Managing delivery of Broker Dealer Separation for Global Collateral Data Warehouse
§ Regulation driven key business elements (KBE) mapping for Listed/Cleared, OTC, PB, Repo & Sec Lending; Liaise with Data Owners & Subject Matter Experts to reconcile KBE discrepancies in definition, business rules, source/targets systems and usage. Identify & document data quality issues, KBE definitions and business rules
§ Sketch business process flows from existing data mart views such as Unencumbered & LCR Asset Traceability
§ Analyze, distill & articulate requirements, conduct stakeholder presentations & Gap Analysis
§ Manage pipeline status & reporting with upstream/downstream stakeholders including Liquidity Risk Mgmt
§ Author various artifacts including functional process flows, requirements docs, working group and biweekly touch point decks
Citi, NJ [Feb. 13 – Mar. 14]
Sr. Business Analyst, Flexcube, Core Banking
Flexcube offers a core banking solution for corporate customers. Users avail a rich suite of products, & associated services, including but not limited to DDA, General Ledger, Transaction Posting, Payments, Receivables, Loans, Money Market, Liquidity and Investment. Citi Flexcube program is laying the foundation for a unified Flexcube universe to service upwards of 70 countries.
§ Liaise with users, stakeholders & development teams
§ Authoring living & country Product FRD’s catering to a global overlapping yet differing requirements base
§ Authoring Requirements Matrix, Issue Management, Use Cases, Swimlane Diagrams
§ Integrating artifacts into Blueprint Requirements Management Tool
§ Streamlined communications across distributed functional & vendor teams with an end to end Requirements Traceability Matrix & centralized issues resolution
Bank of America Merrill Lynch, NJ [Apr. 12 – Dec. 12]
Sr. Business Analyst, Market & Credit Risk, Global Markets
Risk Data Management provides critical support to Credit & Risk businesses in identifying, mitigating & managing risk across business lines. Automated extraction, validation, transformation & reconciliation, Break analysis & reason code assignment, Reconciliation workflow management system, reporting & entitlement services are part of the suite of services to enable risk management.
§ Liaise with risk users, stakeholders & development teams
§ Leading restructuring of Break Reason code assignment & locking of reconciliations
§ Led successful delivery of Reconciliation enhancements (Excel / SQL)
§ Facilitated SOX Audit, automation of reports
Deutsche Bank, NY [May. 10 – Mar. 12]
Sr. Business Analyst / PM, Cross Product Business Solutions, Global Markets
Successfully delivered a range of projects including OTC Rates & Credit Pre Sales & On-boarding Automation, Data Dictionary Vendor Selection, Rates STP Consumer Adoption & Instrument Exception Management. Currently leading 2012 BoW for Markets Clearing DBGO On-boarding. DBGO is an online Client On-Boarding tool spanning Opportunity Management, Enrichment, Updates, Due Diligence (AML/KYC), Legal, Operational Setup and Reporting amongst others.
§ Led end to end delivery of POC - Analyze, distill & articulate requirements, verify, conduct demos & Gap Analysis
§ Spearheaded launch of pre Sales Functionality in DBGO including identification, design & mock up; Mock Up facilitated user visualization of Pre Sales leading to an enriched & more efficient business process
§ Initiated controls in Pre On-boarding for improved MIS reporting, eliciting stakeholder interest & enthusiasm
§ Led Metadata management tool selection and analysis of Data Dictionary use cases & requirements
§ Analyze, collate, compile, mock up & articulate end to end requirements; Conduct interviews, stakeholder demos
§ Liaise with Client, Stakeholders & development teams to tie in queries, reconcile & disseminate responses
§ Author Use Cases, Quick Reference guide, Post Go Live Run Book &Artifacts; Manage UAT, Change Requests
§ Define Book of Work, entitlements, user profiles, data upload template (Excel / SQL)
J P Morgan Chase, NY [Oct. 09 – Dec. 09]
Sr. Business Analyst, WSS Broker Dealer Services
Led client approved design of Tri Party Investor confirm screen & launch of business process automation. Broker-Dealer Automated System (BDAS) is a proprietary trade settlement system that moves book-entry deliveries, within seconds, to the Federal Reserve Bank (FRB) / Participants Trust Company & DTC, amongst others. Its global client base can also access a full suite of core clearance capabilities - Tri-party Admin / Cash Netting, DTC, including Income and General Collateral Finance, Functional Analysis, including Pricing, Systems and Planning / Liaison and bookkeeping.
§ Liaise with Client Services, stakeholders, development teams
§ Led Class “A” Funding notification and settlement calls
§ Lead requirements elicitation, design, presentation for Tri Party Repo Investor Confirm
§ Spearheaded business process automation, including design, development (EXCEL/VBA) and implementation
§ Facilitate meetings with client services to track and resolve Issues, Risks and Action Items
§ Design and implement Broker Dealer SharePoint portal to provide one stop access to artifacts relevant to a wide audience including Broker Dealer operations, technology management and development teams
Citi, NYC [Sep. 05 – Jun 09]
AVP, Investment Research
Led & managed several initiatives including Client Data Feeds, Market Data &Global Disclosure System. dataCentral is a central repository of research data designed to serve a global community of Equity Research & Data Analysts. It’s currently being scaled to bring Fixed Income, Economic & Market Analysis (EMA) and Corporate Bond Research analysts on board.
dataCentral is a complex Object Oriented application. It provides an integrated rich platform to feed financial models / data, perform retrieval analysis, author Research Notes with an automated workflow and distribution to internal/external clients and vendors.
§ On recommendation of client, converted to employee within 6 months of joining, well ahead of department average.
§ Credited with “Raising the bar”, “Saving life” and “Ensuring peaceful earnings season” with each Business process turnaround
§ Identified business process loophole to realize yearly savings of ~170k
§ Identified critical performance handicaps, analyzed & articulated solutions, resulting in a highly improved and stable Business System
§ Self initiated analysis helped channel dataCentral Capacity and Performance Planning in the right direction
§ Analyze & Identify strategic trends within Client Data Feeds architecture, a revenue generating stream
§ Managed and led global teams in Global Disclosure Management System and Early Warning team
§ Analysis/Design of new Multi Asset classes – Corporate Bond Research/EMA/FI
§ Authored Functional Requirement Document (FRD), Prototypes, Technical Design docs, Data access & Data structures, Development, QA/UAT of Global Disclosure Management System; Designed XML Schema & led GDMS Feeds file transition
§ Conducted High Level Business Interviews, Client Presentations
§ Collaborate with vendors, including Reuters & Thomson, to enable business operations; Institute, analyze, map pricing and reference feeds including DataScope Equities and DataScope Fixed Income.
§ Translated requirements & gaps into objectives, recommendations and initiatives
§ Visio Diagrams of Current State Process Flows and Future State Process Flows enabling clear Business process understanding while highlighting current system design flaws
§ Comparative analysis of existing system data structures to future data requirements to benefit data model
§ Production Support: Trouble shooting critical & complex Business issues. Collaborating with vendors / Software developers & communicating problem resolution to end users.
§ Documented all stages of the project and tracked to closure
Certifications – Technical / Personal [Aug. 01 – Aug. 05]
A family emergency and parenting imposed hiatus
Honed multitasking /organizational / management skills; Java Certification; Organized shows
BANK OF AMERICA, Chicago, IL [Sep. 00 – Jul. 01]
VP, Foreign Exchange (eDealing)
§ eDealing - Successfully implemented several components on FX02, an integral part of the newly conceived eDealing Transaction platform. The FX02 system extends foreign exchange trading capability to Bank of America customers via the Internet. The system enables clients to request foreign exchange quotes, enter price requests and deal requests for routing to Bank Sales Advisors. Other users of the system include Bank Sales Advisors and Bank Operations.
CLIENT & MANAGERS’ WORK REVIEW:
“ Wanted to take a quick minute to acknowledge a great asset on your team, Shalini Varshney. Shalini has been a terrific resource for business in terms of timeliness of responses, keeping business informed of progress made on issues, and finally, her relentless pursuit of seeing issues to resolution. She has also picked up a good deal of knowledge about dC in a short amount of time. I know that when Shalini is working an issue for us, we are always in good hands. Also, important to note, this is an opinion that is shared globally, I have spoken with other DM's who always cite very positive experiences with her since she's come on board. I hear she is a consultant, PLEASE HIRE HER!! We cannot afford to let talent walk out the door!! .” – Senior Client Manager, Citi Investment Research
“You have won the hearts and minds of the Business. They are always re-assured when you are working on an issue, because they know that your follow through will be complete and your communication will be timely, sensitive and forthright. Your communication skills are beyond compare. It is a rare combination to have not only technical understanding but the ability to put it into words that people can understand” – Senior Project Manager, Citi Investment Research Tech
“Hi Marty, I just wanted to thank you for the extraordinary level of support that Shalini has been giving to Business. Her dedication, thoroughness and disposition make a big difference. It is a pleasure working with her. Thanks again. Best ,j” –Client, Global Head, Data Services, Citi Investment Research
“You have very good analytical skills which have proved to be a bonus during the GDMS Multi-discipline project requirement gathering and designing. From time to time during the project you have very skillfully leveraged your business and client needs knowledge to design the GDMS modules. The way you have built a very strong relationship with the client managers in a short period of time is admirable. When you own a problem or an issue or a design task,
there is nothing that can stop you. Your focus is intense and you pursue your goal until you find a solution. ” – Project Manager, Citi Investment Research Tech
“Hi Brian, Just wanted to take this time to give my views on the top notch work we have received from Shalini over the past year.
Shalini has carved out a role that is exemplary for our AS/BS operating model. She provides valuable business insight to the dev team, proposes workable solutions when IT/Business compromises are required, manages requirements and priorities well and has provided guidance to Business and IT for 2012 BOW and budgeting and helped to finalize it. We are very lucky to have her working with us on DBGo and wish we can clone her for some other projects. Thanks – Technology Program Manager, Deutsche Bank
“She was quick to come up to speed after joining DB in May ‘10. She demonstrated professionalism and maturity in dealing with external vendors as well as internal stakeholders. Shalini also led the analysis of BSG use-cases and requirements around DD, compiled BRD that was well received by the business, and now being integrated in the 2011 book of work.
Shalini has strong analytical and data profiling skills. Even though she was new to the dbInstrument environment, she was quick to understand the problems around data quality and loading exceptions. She is an asset to any team with her dedication and hard work.” – Program Manager, Deutsche Bank
“Her broad business acumen, deep technical expertise and excellent soft skills showed from the very first week and manifested itself in her ability to absorb and contribute towards the planning, execution and delivery of complex projects with aggressive timelines. With her success as a Business Analyst and what myself and all her peers and seniors came to notice about her organizational and interpersonal skills, I selected her to be my deputy Project Manager in addition to her Business Analysis role. Again, she came through and proved she can multi task and offer an exemplary performance in the arena of Project Management as well. Her highly organizational skills, smart time management and strong communication skills enabled her to quickly become an effective project manager and facilitator. Her cooperative nature, pleasant personality and good sense of humor earned her the respect of her peers and superiors. Moreover, her ability to quickly learn and put into use state of art Project Management and Business analysis applications and tools only made her more effective and valuable.
I will be happy to have Shalini as a member of my team or a peer in the future.” - Program Manager, Bank of America Merrill Lynch
* Senior client/tech references, including the above, are available upon request
EDUCATION:
Post-Graduate Diploma (Business Administration)
SKILLS:
Modeling Tools: Rational Clearcase, Erwin, MS Visio, TOAD
Modeling Languages: UML, MS Front Page
Requirements Mgmt: Blueprint, CollabNet, JIRA
Business Intelligence: Business Objects, Business Objects Reporter, Business Objects Supervisor
Microsoft Tools: MS Office, MS Outlook, MS Project, MS Visio, MS Front Page
RDBMS & Languages: Mainframe, Sybase, Oracle, MS SQL Server; SQL, PL/SQL, JAVA, J2EE, EJB, JDBC, C/C++, Pro*C, SQL, SQL Plus, PL/SQL, Visual Basic, Visual C/C++, UNIX Shell Scripting, VBA
Web Technologies: JSP, ASP, VBScript, JavaScript, RMI, HTML, XML, XSLT
Software: Eclipse, SUN JDK 1.4, Tomcat, IIS, Microsoft Visual Interdev, SQL Loader, Chart FX, Trigger, Collabnet, Bugzilla