Suruchi Srivastava

Experience

• 

  Cognizant

  Mar 2014 - Oct 2016

  Programming Analyst

  Client: MetLife Insurance (Industry: Insurance)Roles: Programmer Analyst (Cognos Report Developer)Responsibilities: Developing Cognos Reports using Cognos Report Studio. Developing Cognos Query Studio packages for Ad-hoc Reporting. Developing model and packages for reports using Cognos Framework Manager. Creating SQL queries and stored procedures for reports. Gathering requirements and managing project timelines. Unit Testing of the developed reports. Providing UAT and PROD support. Sharing Weekly Status Reports with stakeholders and delivering the entire project in a timely manner. Directed software design and development to meet client needs for functionality and performance. Identified causes of issues within applications and determine which modifications needed to be made. Updated documentation with project deviations to capture changes. Show less

• 

  Accenture

  Oct 2016 - Apr 2023

  Client: Royal Bank of Scotland (Industry: Banking & Finance) Roles: Team Lead (Data Custodian & Structured Data Analyst)Responsibilities: Working on Informatica Information Lifecycle Management (ILM) to archive application's data for the bank. Implementation of entire archival process from FSD, Data Models, Archival, Applying Retention/DHO to validations and purging of the applications. Developing complex SQL queries and retrieving data from the archived applications for legal & compliance requests. Working on dual role for the bank, as Data Custodian & as Data Analyst. Gathering business requirements from users as Data Analyst and retrieving data accordingly as Data Custodian. Defined project-wide performance metrics such as developmental milestones, timeline goals and required completion dates. Supervised aspects of development teams such as hiring, training, furlough, salary administration and remedial assignments. Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality. Spearheaded technical discussion round tables to track progress and optimize future resource distribution. Communicated directly with project stakeholders, providing timely updates on project advancement. Explained project technical risks and benefits during project kick-off. Show less Client: Merck (Industry: Health & Care)Roles: Senior Software Engineer (Cognos Model/Report Developer)Responsibilities: Handling and maintaining the entire project single-handedly. Developing Cognos reports using Cognos Report Studio. Creating model for reports using Cognos Framework Manager. Working on the SQL based reports in the project. Creating stored procedures and database packages for reports. Creating reports and package archives and export them for report migrations. Working on the development, unit testing, migrations and document generation single-handedly. Apart from Cognos, I supported Informatica MDM and Informatica IDD teams in the project. Show less Client: Merck (Industry: Health & Care)Roles: Software Engineer (Cognos Model/Report Developer)Responsibilities: Developing Cognos Reports using Cognos Report Studio. Developing Cognos Query Studio packages for Ad-hoc Reporting. Developing model and packages for reports using Cognos Framework Manager. Working on the SQL based reports in the project. Creating stored procedures and database packages for reports. Creating reports and package archives and export them for report migrations. Working on the development, unit testing, migrations and document generation. Show less

  • Application Development Team Lead

    Dec 2021 - Apr 2023

  • Senior Software Engineer

    Dec 2018 - Nov 2021

  • Software Engineer

    Oct 2016 - Nov 2018
• 

  NatWest Group

  Apr 2023 - now

  Associate Vice President