Business Analyst

201-***-**** Ajith Bhasker Radha ************@*****.***

Current Role: Senior Business Analyst

•18 years’ experience on end to end Project Development Life Cycle - Business Analysis, data analysis, system design, development, testing and implementation of software projects, mainly in Financial domain with major MNC clients like Deutsche Bank, Citi Group, UBS and Credit Suisse.

•Performed Front to Back Data Sourcing gap analysis on attributes required for CCAR 9-Quarters Projections Modelling and Implementation. Actively presented recommendations that brought synergies in sourcing data for Finance and Risk systems for end-to-end business processes in executing inter-related CCAR 9Q Models.

•Experienced Business Analyst in prioritizing requirements and drive project deliverables with high quality and meeting stringent deadlines, working with a global team having onsite and offshore members. Skilled on strategic thinking to generate new ideas and initiate change, especially on Automation and Migration projects.

•Good experience in soliciting client requirements, Business process re-engineering and gap analysis involving multiple stakeholders from Technology and Business teams, and securing timely sign-off from all stakeholders.

•Good experience in transforming business requirements into functional and technical specifications for technology and QA teams. This includes performing data analysis using SQL queries or reporting tools, mapping business process rules to data and data model, performing data reconciliations and gap analysis.

•Documented functional specifications to source Market & Credit risk values like VAR, CVA and RWA values for Citi Market Analytics Reporting Dashboards used by Senior Management including CFO.

•Well versed in writing SQL Queries to analyze front-end and back-end data to identify issues in business processes like Reconciliation. Also, well experienced in preparing POC Prototypes using Excel templates including formulae and macros for quick and effective review for sign-offs by non-Technical stakeholders.

•Designing reporting dashboards using QlikView reporting tool, and automating the refresh of each dashboard based on either schedule (daily, weekly etc.) or events (data updates, on demand requests etc.) presented to the end-users. Also, used UML diagrams and MS Visio tool to present the interfacing and control flow details of underlying data and components, including design artifacts, to the Technology team.

•Generating Value-Adds on various projects mainly through Automation ideas or Consolidation of data feeds and reusable components, eg. Calculation modules or End-User Screenshots.

•Periodic analysis of mandatory Regulatory changes and automation opportunities on any Regulatory Reports.

•Hands-on experience in Level 2 BA Support for Financial Market Applications

•Preparing and maintaining CRONTAB listings and AutoSys scripts that are used for job scheduling.

•First-hand experience in Trade floor Support, for Municipal Securities Trading applications of UBS

•Preparing SQL queries and stored procedures for database access to generate various business reports, both on a schedule basis as well as on an ad-hoc basis in response to Business team enquiries/clarification.

•Actively participated in all tasks related to Change release process (using JIRA, SNOW etc.) for applications for code enhancements, maintenance, debugging and bug-fixing on existing software products.

•Actively participated in all modes of testing along with Technical, QA & UAT teams.

•Hands-on experience in developing Use Cases, Unit Tests and in coding as Test Driven Development.

•Well-versed in Refactoring approach on TDD methodology using IDE like Eclipse and Visual Studio.

•Actively involved to document and assist in training of end users with new deliverables and front-end modules for entering user inputs and comments.

•Hands-on experience in detailing out business requirements, sometimes even one liners, to functional specification documents that had screen designs, report designs, process flow and processing logic. Took initiatives in presenting the various artifacts and getting reviewed/approved from the client SME team; thereafter driving the software development team for various stages of system development including requirements analysis, design, coding, testing, implementation and support.

Education:

Bachelor of Technology (B.Tech) in Computer Science, National Institute of Technology, Calicut, India,1996

Master of Technology (M.Tech) in Computer Science, Indian Institute of Technology Bombay (IITB), INDIA,1999

Master of Business Administration (M.B.A.), Indian Institute of Management Bangalore (IIMB), India,2009

Six Sigma Green Belt Certification (While in GE), 2002

Client: Citigroup (Role: Senior Business Analyst) 03/17 onwards

FPG (Finance Projects Group) is designed to serve Product Control Groups (stakeholders) in the Institutional Clients Group within Citigroup. FPG provides the Citi Finance Organization with knowledge and expertise in order to efficiently and effectively deliver new process and system enhancements. Product Control Groups are responsible for the accounting and financial reporting of a trading desk. They are responsible for the monitoring of trades in the portfolios they look after, and act as ‘owners’ of the P&L and Balance Sheet on a specific desk. This includes revenue accruals. Product Control Groups are owners of various Product Processors which are functionally automated trade processing systems that calculate economics of trades.

The current project involves redesigning of business processes to align the new workflows such that all data required for P&L and Balance Sheet reporting (in S2 application) feeds through Genesis (the central data warehouse for all Positional data) instead of being received through feeds directly from the Product Processors. Genesis data is divided across 2 Types – Wholesale and Retail and is further divided into multiple Products. Each Product will have data from multiple Product Processors spread across various Regions and Countries.

As a Senior Business Analyst, be the primary contact for designing and documenting workflow, and for making appropriate recommendations that will positively impact operational effectiveness with the following main responsibilities:

Work as a problem solver in coordination with project managers and stakeholders to ensure project requirements are understood, well-documented and executed in alignment with target-state solutions.

Analyze and document business requirements.

Develop accurate and complete UAT test plans and test scripts.

Ensure UAT testing is conducted according to plan.

Provide UAT management reporting on results and issues.

Identify and document system deficiencies, and recommend solutions for any UAT issues.

Assist with training, documentation and roll-out as required in coordination with the PM.

Client: CREDIT SUISSE (Role: Business Analyst/PM) 05/15 – 02/17

Business Analyst/PM in the ongoing CCAR (Comprehensive Capital Analysis and Review) 9-Quarters Projections modelling and implementation program, with the following main responsibilities:

•Performed critical roles in the orchestration of the various tasks involved in the Functional Requirements Specifications, Model Development and Model Implementation of various CCAR 9-Quarters Projection models in the Loss & RWA projections work-stream

•Delivered key artifacts for Wholesale PD/LGD/EAD and Loss models, IRC(Incremental Risk Charges) and CCR(Counterparty Credit Risk) models

•A key contributor to the overall organizational IT effort to build a strategic IT CCAR infrastructure to house the data, new models and support methodology for existing models

•Delivered CCAR documentation for 9-Quarter Loss & RWA projections to report on the FR-Y 14A Schedule

•Significantly contributed to design some EUCs for Credit Analytics team to accommodate additional methodology components that were not feasible to implement upfront on strategic systems. This involved analysis of a large amount of risk related data, their projections and mappings to other data components.

•Preparation of overall Run-Books to orchestrate the execution of 9-Quarter Projections models for Go-Live

•Participated in the overall Mock-Run (overall end-to-end model execution involving multiple systems) for Stress testing which is required to be performed as part of the CCAR process for both the direct submission of data and as input into other calculations and business projections.

•Provide guidance to various technology teams, in multiple geographic locations, about Interface Specifications across various legacy but strategic system for the CCAR Go-Live planning.

•Assisted Project Managers for enhancing the overall monitoring / control framework for early identification of risk / issues / dependencies, expediting resolution development by promoting collaboration within CCAR program team and SMEs. Directly involved in tracking (as well as identifying interdependencies among) the BRDs and FRDs and Business Process Flow artifacts required for various 9-Quarter Projections models.

•Staying abreast of regulatory changes to lead change management, and prioritization of implementation plan.

•Sharing best practices and learnings for collaborating with Risk teams and Management to maximize transparency and influence program delivery, as well as to resolve non-compliance issues revealed by audits.

•Leading identification and resolution of issue / risk / dependency by promoting collaboration with SMEs and other stakeholders. Also, organized any sessions needed to provide training to client users in other departments

•Responsible for gathering business requirements and writing end-to-end functional specifications

•Responsible for QA and UAT testing of IT deliveries to verify complete conformity to the BRD specifications

•Responsible for coordinating projects and support related tasks, and to provide a project status reports

•Provide assistance to IT support teams in the investigation of production issues, and coordinate their resolutions

•Working closely with various stakeholders (Business, Model Development and Model Implementation teams) to assess current state, perform gap analysis, and develop requirements for business process, capability and technology infrastructure enhancements to support the creation and management of stress testing scenarios.

•Socializing, conducting reviews and obtaining approval for the requirements as well as use cases and test cases

•Ensuring timely and quality development of capability / process / infrastructure support for stress test scenario management, governance and control checks.

Client: Citigroup (Role: Business Analyst/PM) 11/14 – 04/15

The AFS-HTM Work stream manages the AFS/HTM processes within CCAR work stream for Citigroup (“Citi”) and Citibank, NA (“CBNA”), the Dodd-Frank Act Stress Test (the “DFAST”), the Internal Capital Adequacy Assessment Process (“ICCAP”), and the Mid-Cycle Stress Test (together, the “Capital Exercises”) requirements of the Federal Reserve Board (“FRB”) and the Office of the Comptroller of the Currency (“OCC”). It is also responsible for forecasting Other Than Temporary Impairment (OTTI) for Available-For-Sale (AFS) and Held-To-Maturity (HTM) securities and for forecast AFS Fair Value Other Comprehensive Income (OCI).

•Documentation of the AFS/HTM process methodology followed by the firm.

•Developing Excel templates for the consolidation of tactical data using the given business rules.

•Developing variance reports for population data across multiple reporting periods.

•Preparing excel model to report Citi’s Swap data to vendor (BlackRock) specific format.

•Preparing stress test results for purposes of CCAR using five different scenarios.

Client: UBS (Role: Business Analyst/Technical Lead/PM) 03/13 – 11/14

As an onsite lead member, worked hands-on in business interfacing, requirements analysis, development, migration, re-engineering and support tasks on RTB projects in Wealth Management (Trading cluster) managed and delivered by HCL. Also, responsible for ensuring a smooth execution throughout the development of new modules as well as the enhancement of the existing modules so that the delivered project artifacts confirm to the customer requirements, planned deliverable timelines and agreed quality standards.

•Hands-on participation in Level 2 Trading Floor BA Support for Financial Market Applications

•Preparing and maintaining CRONTAB listings and AutoSys scripts that are used for job scheduling.

•Preparing SQL queries and stored procedures for Sybase database access to generate various business reports, both on a schedule basis as well as on an ad-hoc Business team enquiries/clarifications basis.

•Contributed significantly in maintaining and enhancing the retail fixed income trading platform(MERIT) which had both legacy and recently developed codebase in C/C++ for UNIX/Solaris servers

•Worked extensively on FIX messages and MQ middleware to interface with external liquidity providers

•Preparing and maintaining several UNIX shell scripts in the form of ksh batch jobs that are developed to streamline the execution flows for incoming and outgoing offerings and orders.

•Designing and implementing daemon jobs that will push live real-time updates to trader workstations.

•Actively participated in all tasks related to Change release process (using JIRA, SNOW etc.) in legacy applications for any code enhancements, maintenance, debugging and bug-fixing.

•Actively participated in all modes of testing along with Technical, QA & UAT teams.

Client: Citigroup (Role: Business Analyst/Technical Lead) 01/08 – 02/13

Global Markets Analytics (GMA): provides a new Business Intelligence, with user-friendly QlikView dashboards, for the Global Markets Finance & Reporting Organization. The system automates the collection & reporting of financial data pertaining to Revenues, Income, Budgets, Forecasts and Headcount for all of Capital Markets Organization under ICG in Citigroup. GMA incorporated complex Business Intelligence and Analytical capabilities.

KDB: basically a data-driven application framework development for the overall analysis, implementation, testing and support of various updates to existing KDB instances in Citigroup. The main functionality of the KDB application is to provide real-time data captured from different sources in memory into one framework. The business users can then easily analyze the captured data thereby making better trading decision by picking relevant data that are significant to them. The most common business requirement was identifying new financial data sources needed by the analytics team and then based on a detailed analysis, design changes are done. This phase usually involves making necessary modifications to add new tables, add new fields to an existing table, deleting obsolete tables, deleting obsolete fields from an existing table, replaying data when there is any corruption, debugging log files to resumes suspended/crashed jobs that will lead to data-loss etc.

CFD (Commodities Fundamentals Database): This Project was developed for the Commodities division of Citigroup to automate its data collection from various sources into one database framework. The goal was to provide a single source of data so that every analyst can switch over to source their data from this data framework. In short, this framework will capture all the fundamental data that shall be required for Commodity Trading for Citigroup. Earlier, each of the sub-groups in the Commodities division used to collect their required data independently and store them in their own legacy way, some in raw data files, some in excel files, some in their own database etc.

•Lead the requirement study, design, development, code reviews, testing and release.

•Developed, reviewed and tested components for the GMA portal & associated SharePoint applications.

•Developed data analysis scripts using TOAD and PL/SQL for reporting to Business users.

•Developed components for the Middle Tier to implement various business rules in KDB framework.

•Responsible for the monitoring of core processes and feed handler jobs of all the KDB instances.

•Developed key modules, including Spring components, for the CFD application framework.

•Designed and developed code for data access and user interfaces.

•Ensured smooth execution and interaction between onsite and offshore throughout all SDLC phases so that the delivered project artifacts confirm to the customer requirements and agreed quality standards.

•Followed up on escalations issues with clients and onsite managers.

•Performed quality checks on the deliverables before they are released it to the client.

•Addressed and fixed critical customer defects to ensure deliverables for client on time with high quality.

•Grow the off-shore team, both in headcount and project as well as domain knowledge.

A 20-member team involved in system development on Linux for GMA Portal and business data analytical models using C/C++, Java, XML, Spring, Shell Scripts, Autosys, Oracle, SharePoint, QlikView, CVS, KDB and Q scripts.

Client: Deutsche Bank (Role: Technical Lead) 10/04 – 12/07

The Deutsche Bank Index Quant (DBIQ) project is aimed for a framework development that provides index calculation and analysis modules integrated with web-enabled front-end modules. This framework had business logic implementation for the fixed-income mathematics as well as various sensitive and complex algorithms specific to Deutsche Bank indices. As a result, it provides portfolio managers with strong support for benchmarking and index analysis, portfolio maintenance and portfolio analysis. The main modules developed are for Equity Analytics and ETF Reports using the existing DBIQ infrastructure so that the analytics results and reports are published in the front-end seamlessly. Equity Indices are a set of indices designed to reflect the returns from a basket of underlying components through a combination of factors like dividends, corporate actions, selection and rebalancing. An Exchange Traded Fund(ETF) represents a basket of stocks that reflect an index (diversification) but it trades just like any other company on a stock exchange (flexibility/liquidity).

•Responsible for leading and mentoring a 5-member offshore development team in charge of the planned deliverables as well as daily tasks that would be assigned as minor enhancement requests by Business.

•Responsible for the overall requirements collection, analysis, design, implementation, design as well as code reviews, testing and release of the various modules in the DBIQ project.

•Responsible for the translation of calculation logic in model spreadsheets provided by business users to functional requirements, and to design and develop code for data access and user interfaces.

A 5-member team involved in system development on Linux using Java, ECLIPSE IDE, TOAD, PL/SQL and CVS.

Trigent Software Ltd. (Role: Technical Lead) 09/03 – 09/04

Played a key role in the implementation and deployment of Spectrum application. This project involved implementation of a multi-tier architecture for an Assembly Parts Management Systems application. This project mainly deals with some detailed information about overall customers and suppliers in the supply chain, stock reports on raw material and finished product as well as sales report. For an asynchronous flow of information of data across multiple heterogeneous systems, the popular IBM MQSeries middleware was also deployed which provided good interfacing capabilities to applications written mostly in C/C++ and Java.

•Developed code for both front-end and back-end, and conducted various code reviews.

•Tested the overall functionalities of the software modules and the entire application.

•Participated in Release and support activities.

A 5-member team involved in system development on Windows2000 using C/C++, Java, XML and IBM MQSeries.

GE Medical Systems (Role: Senior Design Engineer) 04/01 – 08/03

Played a key role in the implementation and deployment of multiple projects, including the following main tools:

•Web-based RDA (Remote Data Acquisition) and IBIS (Installed Base In Spec) : a remote monitoring tool

•Coil Configuration Upgrader : a multi-purpose service productivity improvement feature

•HART (HARdware Tracker) : a hardware tracking tool for service productivity improvement feature

Main responsibilities included the following:

•Overall requirements specifications, analysis, design, implementation and testing of software modules.

•Developed code for front-end and back-end, conducted reviews for the overall application functionalities.

•Global co-ordination for development of various software features.

•Drive software quality as a Quality Representative of the team.

•Responsible for mentoring interns (project trainees) in the team.

A 6-member team involved in system development on Irix and Linux using C, Java, HTML, PERL and Shell scripts.

Sasken Communication Technologies Ltd. (Role: Software Engineer) 11/96 – 03/01

Played a key role in the implementation and deployment of CDFG (Control Data Flow Graph) framework. The CDFG provides a language independent intermediate representation for computations/algorithms/programs specified in procedural form. Hence, in an HDL based design environment, the back-end tools like verifiers and simulators can function uniformly irrespective of the HDL used; say VHDL or Verilog, once the behavior of an algorithm/program is captured in the form of a CDFG. Also, a CDFG can invoke another CDFG and this form a hierarchical representation termed as hierarchical CDFG, which is implemented using CDFG Flattener module.

•Implemented, tested and integration of software modules.

•Implemented prototype for new functionalities, and developed code for both front-end and back-end.

•Tested the overall functionalities of the software modules and the entire application.

A 6-member team involved in system development using C/C++,STL,ODBC and MFC in SunOS and Windows NT.

Contact this candidate