Sheetal Kumar Email & Phone Number

Pittsburgh, Pennsylvania, United States

Greater Pittsburgh Area

Working as Scrum Master and Data Analyst with CGI

Greater Pittsburgh Area

Pune, Maharashtra, India

• Understand the client business requirements and provide feasible solution• Interface with all the project partners like users, vendors, etc to prepare and implement project plan• Analysis of Concept Documents to understand business requirements• Preparing documentation – BRD, FRD, Test Cases and supporting throughout the development cycle• Providing efficient solutions for the creation of Datamart & Data Warehouse• Preparation of Solution Presentation for Business Users to provide an overview on proposed solution.• Providing walkthroughs to stakeholders for sign offs• Functional Testing and Supporting UAT• Running Reconciliation tools to recon Risk Reports and investigating the breaks.3 Project : EBA, Disclosures and Encumbered Assets ReportingClient : Credit-Suisse PuneDuration : March 2014 – till dateTechnology : Java / Oracle 11iRole : Business AnalystWorking as a Business Analyst for Disclosures and Encumbered Assets Reporting Project to implement various changes in the project as part of BIS (Bank for International Settlements) – FPOB (Foreign Position of Banks) reporting. As a part of Regulatory reporting requirement of BIS – FPOB reporting, Investment Banks have to submit certain reports. In order to generate these reports, a Datamart (Disclosures Datamart) is being created. Collateral allocation engine is also built to support the automation of identifying country risk of the exposures.EBA Asset Encumbrance reporting: Working as a Business Analyst to support the development of reports in which Investment banks need to report Encumbered Assets, Collateral Received and Collateral Provided amounts to European Banking Authority at a certain aggregated levels.Reports are generated using OBIEE and AXIOM.Achievement: Received the 'Excellence in Execution Award'​ and 'Winner's Circle' award for the Contribution.Got Promoted as Lead BA.Other Projects:Commodities IT Barclays SingaporeReal Time Risk Threshold Monitoring

Singapore

Primo or Pricing Monkey is the risk report viewer cum Back-office System for Interest rate Derivatives products. It generates various risk reports useful for traders to access the trade-wise risks and valuations. The project aims at QA of Primo enhancements and ensuring efficient migration of Books from legacy systems to Primo.

Singapore

Department: Investment BankingKey Deliverables:Interface with the user groups to understand and document the requirements. Undertaking requirement analysis and provide possible solutions. QA and UAT Plan preparation and execution based on clients requirement and design documentation Preparation of Regression Test Plan Scripts (including Automation)Execution of functional testing and bug rectification cycles Adherence to the prescribed processes w.r.t. project planning, documentation, test planning. Projects:Project : Nikko Citi Independent QA testing; Technology : Java, C++ / Oracle 9i

Mumbai And Singapore

The QA testing involves testing of various front and middle office applications used by Nikko-Citi to serve their Clients. Within this project I have the privilege of working on the following applications:Zeus Ticketing SystemDescription: The Zeus Ticketing is a middle office application which enables allocating and ticketing of Orders for both onshore and offshore customers. This proposed system will match allocation received from various sources (Manual, SAS, OG and FIX) and based on configurations set up for client the orders are ticketed.VIPERDescription: VIPER is a Front-end trading Application used as a Market-Making tool used by NCL. It is used basically for trading ETFs (Exchange Traded Funds) and Warrants.Responsibilities:Understanding functional requirements and end-to-end flow of trading of Warrants and ETFs through VIPER.QA Plan preparation, Effort Estimation, test case writing and execution PTE (Program Trading Explorer)PTE is a client-server application to manipulate batch orders processing in order to perform basket trading for NCL & its clientèle transactions. PTE takes the place of its legacy system CITISMARTDescription: CITISMART is Citigroup's Algorithmic Trading engine. Algo Engine is a trading system that utilizes very advanced mathematical models for making transaction decisions in the financial markets. The strict rules built into the model attempt to determine the optimal time for an order to be placed that will cause the least amount of impact on a stock's price. Large blocks of shares are usually purchased by dividing the large share block into smaller lots and allowing the complex algorithms to decide when the smaller blocks are to be purchased.Bug logging, Report test run results and regression testing.1 Project : IMS - RKS Testing; Technology : C++ / Oracle 9i

Key Deliverables:Interface with the user groups to understand and document the requirements. Undertaking requirement analysis and provide possible solutions. QA and UAT Plan preparation and execution based on clients requirement and design documentation Preparation of Regression Test Plan Scripts (including Automation)Execution of functional testing and bug rectification cycles Adherence to the prescribed processes w.r.t. project planning, documentation, test planning.

RKS is a complex Portfolio Asset Management system, that will record and account for all investments in an investment portfolio, and interface with other systems for data entry and data export. This includes functions such as setting up security information, entering transactions, viewing position information, reconciling PAM balances with the custodian, and reporting.This project came out as a requirement because of the migration of the current RKS functionality to a higher version (from v.4.4 to ASP v.4.4). Due to the addition of some new functionality it was necessary to test the entire system across different asset classes for any working anomalies. Responsibilities:Understanding the Business model of the client and worked on diversified security types.Preparation of detailed BRD, Functional Specification documents and exhaustive Test Plans based on business processes followed by end users. In depth analysis was carried out to document the Impact of each enhancement in the application done for different security types.Maintain (integrate new functionality) & execute regression scripts for release upgrade testing;Functional testing for periodic hot fixes.Maintain, automate, & execute hot fix test scripts;Involved in User Acceptance testing, hot fix testing; Integration testing in various environments.Analysis of Reports: Swap User Fields, Option Expiration Auto Generation, User Manual Updation.Domain practice line assignments for OFSS:Contributed white papers on Current Financial CrisisAwarded the title of 'i-Guru' by OFSS for my contribution to Functional Trainings

Looking after ICICI Banks Channel for Delhi, UP and UttaranchalTaking care of Corporate Relationship and servicing them as per their needsStreamlining the sales operations to ensure speedy booking(SOPS)Training Sales teams of ICICI Bank to generate more business

Job responsibilities: Analysis of current trends.Looking after Branch OperationsDeveloping comprehensive investment plans. Report preparation for mutual funds and investment planning.Client acquisition and retention.

Part Time Job AssignmentsHyderabad - Industry Monitor for the Bulk Drugs Industry, involving preparation of professional reports for the clients of the organization.

PROJECTS UNDERTAKEN; Process Comparison of Method of Lending Credit to SMEs of ICICI Bank with SBI: It was done on the basis of objectivity and subjectivity involving in credit evaluation. A Study of the Indian Road and Freight Industry: On the basis of the field survey the banking needs of the industry in question were determined and a case study was performed to have the insight of the credit evaluation process done at ICICI Bank.

Summer Traingn:To understand the Material Resource Planning and operations at M&M. Suggestions made, helped in reducing the Feeding Time of the Material on the Line to Half.

Mba, Finance

Activities and Societies: Scholarship from ICFAI Business School, Hyderabad for academic excellence in Semester 1 Member or Environment.

Bachelor Of Technology - Btech, Mechanical Engineering

Intermediate, Physics, Chemistry, Maths, Computer Science And English

Activities and Societies: Won the Inter House Volley Ball Competition & Faculty Cricket Tournament Won title of Most Cooperative Student &.

High School, English, Science, Maths,Hindi, Social Science And Economics

Activities and Societies: House Prefect, Won title of Most Cooperative Student