Ramya Natarajan

• Client: Mashreq Bank
• Domain: Banking and Financial Services
• Project Details: Risk Data Mart
• Worked as a Technical Business Analyst with various stakeholders, gathering business requirements, project documentation and project management
• Hands on experience in data engineering in terms of Query development, Testing, implementation over 40 semantic tables
• Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
• Created detailed user stories for system enhancements, leading to improved functionality and user satisfaction.
• Mentored junior analysts on best practices for business analysis techniques, fostering professional growth within the team.
• Client: Abu Dhabi Islamic Bank
• Domain: Banking and Financial Services
• Project Details: Key Performance Indicator Dashboard
• Quantify KPI -Volume, TAT, team Productivity etc., in Power BI dashboard which helped the higher management take informed decisions about their processes and thus improving the overall customer experience with the Bank
• Improved project efficiency by analyzing business processes and identifying areas for improvement.
• Facilitated requirement gathering workshops, resulting in clear project objectives and deliverables.
• Project Details: Control Analytics
• To automate control report and report the discrepancy as daily emails alerts from data lake to Trade finance Operations team and Wholesale Finance Operations Team
• Responsible for Requirement Elicitation, identify source systems, Query Development, Data Setup, Test data setup, UAT and Sign off from Stakeholder
• Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.

Project Details: Net Promoter Score

• Worked as a Business Analyst with various stakeholders, gathering business requirements and project documentation
• Responsible for requirement management and the production of use cases and business rules for the projects
• Performed BI support by extracting and analyzing the data through data visualization, data insights and trend to top management by using QlikView
• Supported successful product launches with thorough end-to-end testing of all features and components.
• Collaborated with data modelers and ETL developers to develop and implement over 200 database attributes in Enterprise Data warehouse

• Client: WESTPAC, designated as Senior Test Analyst
• Domain: Banking and Financial Services
• Worked on various Enterprise Data warehouse projects of Westpac
• Played a pivot role in consecutive releases of the project (FATCA, 3D Secure that involved gathering requirements, collaborating with multiple stakeholders, drafting and executing test scripts, thus ensuring successful roll out of the project as per the defined timelines
• Proficient in Database Testing specifically in developing and executing SQL queries to interact with databases (Teradata and Oracle) to validate the flow of data from source to target tables as per the business requirements
• Expertise in testing various scenarios such as Data Model checks, ER checks, Counts validation, Checksum, Transformation check, Hard coded value checks, Domain value checks, Default values checks, Integrity checks etc
• Identified the reasons for failure of jobs in Control-M while loading data from source to target system using ‘Informatica Workflow Monitor’
• Expertise in the use of ‘Quality Center’ for creating requirement traceability, tracking test execution, defect management, defect tracking and Bug Reporting
• Client: CITIBANK, designated as Test Engineer
• Domain: Banking and Financial Services
• Maintained up-to-date documentation of all test plans, procedures, results, and defect tracking databases for future reference or audits.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements
• Optimized regression testing efforts through continuous improvement of test cases and methodologies.
• Tested the ETL jobs (in Control-M) that are scheduled to transfer data from different sources to EDW and within different layers of EDW (Enterprise data Warehouse) and also the reusable ETL transformations which facilitate Daily, Weekly & Monthly loading of data
• Project Management- Acted proactively as a SPOC from Offshore by absorbing additional responsibilities that include co-ordination of end to end activities like hosting defect triage calls, sending daily status reports to the business teams, get clarifications from Business analysts and tech leads and coordinate with other teams (applications) involved to ensure adherence to the project delivery plan
• Stakeholder Engagement- Demonstrated exemplary collaborative skills by constantly engaging with key stakeholders and Business Analysts to understand the business requirements and ensure successful execution of deliverables that involved multiple applications
• Knowledge Management- Developed and published Knowledge management documents detailing overall project flow, key requirements, significant project milestones, delivery time frame