Prashant Agrawal Email & Phone Number

Chicago, Illinois, United States

Peterborough, England, United Kingdom

Greater Chicago Area

1) Implementation specific analysis to adopt ISO 20022 and DTCC 20022 SEEV SWIFT messaging standard for better and up to date communication with various institutions and clients. 2) Analysis on DTCC specific customization on 20022 messages and design solution to meet business requirements on US Income corporate actions processing.3) Conversion of Federal Reserve Bank propriety principal and income files to DTCC and ISO 20022 messaging standards.4) Designing the solution interface for obtaining FATCA, NRA and Backup Withholding tax rates from 3rd party application to compute US Income corporate action entitlements.5) Designing migration solution to replace existing legacy applications which mainly involved data analysis on high volume of CA events, reconciliation on CA events processing between legacy and new application, . The migration solution which enables Model office testing.6) Providing end to end production IT and business Support and help creating balance in the understanding between business and IT leadership.7) Efficiently used Oracle 12c to write queries and procedures with complex XML operations to get data reports dynamically to reconcile various data issues.

London, United Kingdom

1) Requirement analysis, requirement gathering, writing unix shell script utilities, excel macros, coordinating with offshore team of developers and documentation as a business analyst in IT.2) Idea was to bring in 100 % efficiency and removing redundant time consuming processes from Production Support activities by creating medium scale applications and streamlining Production Support processes.3) These new application are supposed to work as bridge among L2/L3 support teams, business and IT applications. Such analysis required, understanding current processes in detail, preparing solutions at high level and creating solution cases to get all stakeholders agreement to allocate time and budget for the development of the application.4) Such activities also required owning problem area's solution from head to toe and managing stakeholders expectation throughout life cycle of project.

Greater New York City Area

1) Worked as an onsite coordinator which included, client communication, understanding the production systems and its problem areas. Providing the solution as per the technology present in that system.2) Worked as Business Analyst which included preparing functional and related technical solution document for the problem areas, getting approval on the documents from concerned stakeholders.3) Collaborate with offshore team to get the appropriate code building activities completed and solve all gaps.4) Conducting QA and Production testing for the solution provided.5) Arrange multiple session with the leads to work on more problems areas to provide them good solution.

Newark, Delaware

1) Efficiently managing a team of 6 Developers engaged in production support activities of Credit Card fraud and claims for Bank of America.2) Involved in the functions of providing fraud, authorizations and existing customer credit business units the ability to review, research and maintain cardholder account to achieve their business objectives.3) Working in Level 3 Production Support 24*7, supporting activities like Fixing Incident management, problem management, one time changes (production exceptions), recycle of message queues, middle ware, database, component, batch support, monthly Installs, data metrics preparation etc.4) Leading the migration of Application on Windows 7 and testing Windows XP version of application on Windows 7.5) Documenting the logs with major functionality test cases, code compilation on Windows 7 compatible vendor software, resolving the OCX issues etc.

Greater Philadelphia Area

1) Worked as configuration management engineer in IT product for wealth management which is a multiple technology platform solution delivered via Internet.2) Maintained product's minimum set of reference data required for various implementation as required by the clients.3) Involved in creation and maintenance of code baselines specific to client for various testing, development and production environments.4) Ensured maintenance of different releases of the product and provided the extract to different environment (e.g. UAT, Integration testing environment, pre-production and production).5) Resolved the production and testing issues related to configuration management and provided round the clock Support for production issues.6) Responsible for creation of PL/SQL procedures to create the DML statements from business requirement sheets.7) Implemented changes in reference data as per requirements which involved end to end verification of SQL queries from business as well as database design perspective.8) Kept the track of database scripts coming from different teams for a particular release and client to ensure that replication of similar minimum set of reference data can be used to create another environment.9) Engaged in creation and maintenance of global data like Sort Codes, BIC Codes, currency changes that come through internet in a CSV file.

Gurgaon, Haryana