Nitish S Patil Email and Phone Number

Current project: NEXUS integration Responsible for maintaining NEXUS database and making sure the database is updated on daily basis. Capture data and control requirements for CVA calculator inputs Gap assess requirements against the current scope of data available; Data analysis and research of inbound feedsmay be required to assess gap Where gaps are identified (control or data), document specs to pass to appropriate technology teams Define and execute test plans to ensure tech delivery matches specs Ensure appropriate inbound and outbound agreements are in place. To adhere to requests sent my SORs and analyze them to send tickets to the technology team for furtherdevelopment.

Project: Customer database migration to Salesforce nCino platform• Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives.• Monitor new Salesforce released features and functionality to provide recommendations for process.•Interacted with business operations, understand business model, involved in gathering requirements, communicated business process, translated needs into salesforce terms, developed data model, defined objects and relations.•Closely worked with Salesforce.com consultants while implementing the solutions needs for organization.•Responsible for gathering Business & Technical Requirements, Source System Analysis, Gap Analysis, Data Profiling, Requirements Documentation for ETL development and report development.•Prepared various statistical data analysis reports for corporate clients and modified report templates as required.•Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.•Worked with various business groups to understand their data analysis requirements and provided appropriate support to reduce the number of reports.•Carried out SQL Scripting, Transactional Data Analysis and Reporting on MSSQL database.•Analyzed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.Project: FICO system upgrade•Worked with the FICO team which includes Experian, Transunion, and Equifax to learn about their latest upgrades and changes to the previous version of Credit reporting.

Project: Migration of different Fixed Income Products to New Trading System. Elicited and documented application specifications by reviewing existing artifacts and interacting with Stakeholdersincluding Asset Managers, Portfolio Managers, Traders, Risk Managers and Compliance Team. Interviewed Traders and Analysts and created a list of Functional Specifications and Business Rules based on it. Coordinated with risk compliance team for multiple products in the analysis of alerts and investigation of transactionalactivities to detect any suspicions of fraudulent money laundering or terrorist financing activity. Collaborated with data modeling team to build ERD diagrams by identifying data objects and constraints. Performed Gap Analysis on new requirements and updated System Requirement Specification document. Assisted Project Manager in hiring and deploying resources. Assisted Project Manager in identifying the dependencies,some of them are organizational Impediments. Worked with Senior Management, Business & Release Management to understand the vision of the product, prioritizeand develop software release planning. Performed SQL Queries to retrieve and validate data, prepare data mapping document. Involved in defining the source to target data mappings, business rules and data definitions. Co-authored business requirements document with project teams and at every stage discussed and refined thebusiness requirements with the inputs from the business team.

• Prepared, gathered and analyzed business requirements, user requirements, design and technical specification documents.• Interacted with SMEs and Stakeholders to get a better understanding of client's business processes.• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.• Worked with various business groups to understand their data analysis requirements and provided appropriate support to reduce the number of reports.• Carried out SQL Scripting, Transactional Data Analysis and Reporting on MSSQL database.• Analyzed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.• Created and executed Test Plans and Scripts to verify software functionality and adherence to business requirements.• Implemented functional and technical designs of reporting systems by working in conjunction with the ETL, Support, BI reporting and Business teams to ensure alignment with current and future business and IT strategies and opportunities.• Integrated data from disparate systems to give holistic reporting across Global information solution center. Ensured the accuracy of data mappings and master data Management (MDM) best practices across the Business.• Co-ordinated the resolution of identified data issues, tested new feeds to a data warehouse, validated existing warehouse data.

Working for Fixed Income Market of European and North American region with regards to client queries. Key responsibilities - Handling cases raised by the major clients of Refinitiv regarding fixed income securities ofEuropean and North American region available on our database and regarding securities that needs to be added. Updating the database with valid information from feed vendors and other valid sources to ensure reduction inclient queries and discrepancies when the same flows on to the product used by the client Bringing about new process improvements in the team to ensure the quality of production of the overall teamincreases. Drove queue management process improvement along with a time and motion study done to improve theservice timeliness within the team. Using the salesforce interface on a daily basis for the provision of service. Ensuring quick and quality responses sent to clients within the set estimated resolution time.