Atin Arora Email & Phone Number

United Kingdom

Glasgow, Scotland, United Kingdom

● Identification of Project Requirements: Defined and analysed the strategic requirements of the Witness Gateway project, which is a digital transformation project and includes key features for witnesses such as ID&V, Case Matching, Case Trigger, Witness Availability, Witness Statements, Notifications, Preferences, and overall requirements to administer the Witness Gateway using an Admin Portal.● Business Requirement Documentation: Developed functional and non-functional business requirement and proposal documents outlining the objectives, functionalities, and constraints of the Witness Gateway project.● Wireframes: Created UI wireframes for each product, aiding in the visualization and understanding of the proposed key features within the context of user stories.● Process Mapping: Created end-to-end process maps to provide a clear understanding of existing (AS-IS) processes and future (TO-BE) processes. This helped in identifying gaps, areas for improvement, and future development.● Agile Methodology: Utilized DevOps boards to create features and user stories with acceptance criteria, facilitating an agile approach to project management.● Stakeholder Engagement: Facilitated discussions with business stakeholders and project teams (development and infrastructure) to gather and refine user stories, ensuring alignment with business needs by using requirement traceability matrix.● Demonstrated the Witness Gateway Portal to business stakeholders and the transformation team during User Acceptance Testing (UAT).● Feedback Capture: Maintained action logs to capture feedback from business stakeholders, providing a mechanism for continuous improvement.● Business Benefits Analysis: Worked on analysing the business benefits of the proposed solution, demonstrating the value it brings to the organization.● Documentation Standards: Contributed to the development and maintenance of DSSS documentation standards.

Glasgow, Scotland, United Kingdom

● Proactively engaged Local Authorities stakeholders to deliver solutions for Child Disability Payment & Adult Disability Payments Benefits.● Organized and facilitated Agile ceremonies, walkthrough sessions, and follow-ups with both business and IT stakeholders within a client's organization to validate technical and business requirements for Cloud Infrastructure.● Reviewed and analyses AWS cloud-based infrastructure & applications processes and stakeholder needs, ensuring alignment with program objectives and business strategy.● Mapped business processes to business rules, including business process authorization paths.● Understood context, processes, practices, and requirements from multiple TPOs and Programme Boards, identifying opportunities for improvement using Cloud solutions.● Drove qualitative discovery of target workloads, applications, business processes, and whole ecosystems to determine the right Cloud treatment approach.● Demonstrated expertise in the Agile Scrum framework, Jira, and Confluence.● Proactively collaborated with Environment, SecOps, SysOps teams, and the wider Hosting team to refine the product backlog (experience in 3 amigos sessions).● Partnered with business stakeholders on user acceptance testing (UAT) and OAT planning and execution to ensure successful delivery that meets business needs.

Edinburgh, Scotland, United Kingdom

● Collaborated with LDCR Feature Teams, stakeholders, and the technology team to refine requirements and create detailed BDD specifications with technical analysis for applications migrating to the new RBS Private Cloud (IaaS).● Demonstrated strong knowledge of AWS services including EC2, S3, RDS, IAM, Beanstalk, Lambda, and API Gateways within a managed service environment.● Analyzed business requirements and added JIRA stories for X applications, facilitating informed placement and migration decisions (RBS private cloud, Public Cloud, etc.).● Supported the Scrum Master in organizing and facilitating Sprint Planning, Retrospectives, Daily Stand-ups, and resolving blockers.● Closely collaborated with Platform Architects, Developers, and Application Owners to create Epics, User Stories, and Roadmaps to support the migration of over 500 applications to the Enterprise Cloud Platform.● Tracked governance documents (Fit for Purpose, Release documents, Security Risk Assessments, etc.) to ensure they were in place before migration.

Edinburgh, Scotland, United Kingdom

● Owned and prioritized Epics, User Stories, and Tasks for more than 50 applications, ensuring alignment with the product roadmap and achieving 80% on-time delivery.● Identified and implemented process improvements by collaborating across different business areas and liaising with partner application teams.● Led walkthrough sessions on Data Mapping and Interface Specification documents with multiple stakeholders, explaining required changes based on the new requirements.● Developed Data Flow Diagrams and Data Mapping from source to staging and staging to target, including conformed mappings, source details (tables, columns, data types), transformation rules, and business rules.● Analyzed data and created new Data Mappings, Fast Track mappings, and SQLs to extract data. These mappings and specifications served as input for the ETL Design team's modeling changes.● Resolved production data issues by running SQL queries for the business.● Performed data analysis and validation by writing complex SQL queries using TOAD on SQL and ORACLE databases.

Edinburgh, Scotland, United Kingdom

● Led project planning for the New Bank Programme delivery activities, ensuring 80% on-time task completion and identifying critical path activities to minimize delays. Managed RAID items for risk mitigation.● Developed and delivered solutions for Sainsbury's New Bank Programme, including MI reporting and ETL from diverse data sources (PROFILE, TRANSACT, FRAUD, EDW, etc.).● Facilitated workshops to capture business requirements using effective questioning techniques.● Analyzed and validated Finance Workstream MI requirement reports for regulatory reporting, Bank of England submissions, and internal reports to reconcile Loans data.● Identified and implemented an MI solution for Sainsbury's Finance team by pinpointing relevant Finance Source reports within the Profile system containing Savings and Loans data.● Identified valuable data sources to produce MI reports (account balances, general ledger, transaction journals, cost center summaries), adding significant value to the department.● Transformed business requirements into functional requirements, creating checklists, feedback documents, action logs, and data maps.● Collaborated with and managed expectations of Solution Architects, Designers, SMEs, Technical Development, and Testing teams.● Communicated regular status updates on deliverables, conducted Show & Tell sessions, provided UAT support to the bank, and managed the defect lifecycle (capture, tracking, and resolution in JIRA).

Edinburgh, United Kingdom

● Worked as a Technical Business Analyst on Mortgage Manager Migration project is to migrate the mortgage book off of the RBS, NW, NI, and RoI instances of Mortgage Manager onto the strategic mortgage platform GMS● Responsible for analysing and documenting AS-IS & TO-BE process, Functional Specs and Application Design.● Supported business in reviewing, capturing business requirements and identifying the gaps during the design stage of the project.● Worked closely with Business stakeholders’ deals with Treasury, Credit Risk and Regulatory Reporting in migration process for mandatory reports to regulators.● Worked closely on requirement traceability matrix with solution design architects and technical teams to obtain specification sign-off.● Documented and verified ETL migration design document by producing data mappings with AS-IS and TO-BE process.● Created Use Cases and Process Flow diagrams using MS Visio and Archimate● Responsible for producing MI reports for business and supporting Data Analytics team and multiple downstream systems.● Closely involved in preparation of test scripts and test cases against documented requirements.● Responsible in providing the downstream system impact after migration.

Scotland, United Kingdom

● Analysis and documentation of functional requirements for new development and enhancements.● Documented and interpreted user requirements into design specifications.● Analysed, designed, developed, enhanced, tested, and documented new development and enhancements for multiple applications as per customer requests and requirements. Provided design and implementation mentoring, guidance, and expertise throughout (SDLC) process.● Documented detailed definitions on how new applications and enhancements will support business requirements.● Provided technical support for change control assessments, Initial software change requests, level of effort, risk/impact and mitigation.● Coordinated with staff for testing, validation, functionality and operational reliability of system platform (software & hardware) as per software change requests and predefined business requirements.● Identified risks, risk severity levels, and propose risk mitigation strategies.● System support/enhancement for existing functionality● Knowledge transfer and mentoring of business users● Documentation of application/system defect correction● Provided change options and resources, feasibility, scope, identification of elements, resources, skills, and time estimates● Conducted impact analyses of business requirements.● Assessment of code and test approved software changes affecting respective application systems

Glasgow, Scotland, United Kingdom

● Managed the full lifecycle of Contact Centre application projects, from initiation through post-implementation. This included stakeholder identification, scope definition, impact assessments, design, UAT support, and managing traceability matrices and change requests.● Responsible for documenting Functional and Non-Functional requirements for strategic programs like PSD 2012, Mobile Banking, and Two Factor Authentication, encompassing BACS, CHAPS, FPS changes for Contact Centre applications (Telephone and Internet Banking).● Provided input on design, co-developed specification documents, and performed requirements analysis for Contact Centre applications.● Led systems testing efforts, served as a support escalation point, and identified, documented, and expedited resolution of application functionality issues in RTC and QC.● Collaborated with stakeholders across channels (Business, Internet Banking, Middleware) and the IT team to design and implement changes to BACS, CHAPS payments, and integrate new Faster Payments processes in PSD 2012 for Mobile Banking, Telephone Banking, and Internet Banking systems.● Produced informative MI reports, including Dashboards, Charts, and Pivot tables, for the Contact Centre team and multiple downstream systems.● Facilitated workshops and Q&A sessions with the Payments Channel team to identify and resolve application issues.● Identified business reporting needs and facilitated interaction between Business and IT Managers to implement changes and improvements on Contact Centre Telephone Banking applications and reports (MIS Reports).● Developed specific reporting requirements to ensure they met business needs and provided data analysis and process improvements● Created complex ad-hoc SQL scripts to monitor initiatives, analyze data, locate data inconsistencies, and develop reports for tracking transactions.● Managed technical developers and functional consultants, ensuring business requirements and deadlines were met.

London, United Kingdom

Focused on helping clients to achieve their strategic and tactical business goals, and improve their competitive position, through the managed implementation of interactive web-based and client based solutions for the Intranet/Internet, custom software solutions, and collaboration systems.Technical / Project Experience:Notes Development Services* Provided architecture, design, development, and upgrade of Lotus Domino R7-R8 applications - server-side business logic and front-end user interface* Managing and coordinating multiple projects from onshore based on offshore - onsite model.* Enhanced and integrated custom software Lotus applications to solve problems and empower organizations to reach their business objectives.* Migrated and Integrated Lotus Notes Client and Domino applications with CRM and Middleware (MQ Series).* Currently migrating existing Domino application from R6.5 to R8.5 for testing platform dependency and compatibility. * Responsible for understanding Software Requirements and Functional Specifications.* Involved in Requirement analysis, estimation, use cases development and end to end user support.* Responsible for writing system documentation, user guide and keep updating documents in the VSS.* Developed WEB based Lotus Domino R6-R7 workflow application managing training program for newly-employed staff members.* Designed and developed Notes Client and Domino application using Lotus Connectors and LEI activities with SQL and Oracle.* Developed various Lotus Notes Client and Domino applications for Advisory and Marketing services using Immedia. (Content Management System)* Developed fully configurable reporting module in Lotus Notes client, ad-hoc data extracts, export into Excel and PDF.

ISO 9001-2000 Company is involved in software Development and Database Administration for last 13 years and having a client list of the leading corporate in India and abroad. Some of the major clients I have worked with Max New York Life and Bharti Tele-Ventures India.Technical / Project Experience:* Developed and implemented Lotus applications on R6* Analyzed document workflow* Provided Lotus Domino application architecture* Customized mail template and Name and Address Book (NAB)* Migrated applications and servers to Lotus Domino R5 and R6* Administrated Lotus Domino multi-domain network, cross-certificates, mail routing, replication management, installed and upgraded Lotus Domino R5 and R6 servers.* Installed and setting up Notes R6.0 mail server on Linux 9.0 and configured Clients on Desktops* Installed and upgraded shared and local Lotus Notes workstations; Hero is also the largest manufacturer of 100cc motorcycles in India, and is now poised to become the leader in mopeds, scooterette & motorscotters starting from 65cc to 200ccTechnical / Project Experience:* Involved in the initial study of the existing manual system* Designed and developed Lotus Notes applications on R5* Initial study of workflow applications* Involved in system documentation and testing* Provided best possible solutions

Post Graduate Diploma, Computer Applications

Bachelor Of Commerce