Samra Hamid

TD Client - Project Wealth Client (WCK) Project: (2024-ongoing)

• Participate in daily huddles and contribute to sprint planning and retrospectives for continuous improvement.
• Processed input flat files and staged data according to testing needs.
• Transferred files to Cinder using WinSCP.
• Execute Autosys jobs for processing staged files and ensuring timely completion.
• Performed comprehensive data validation aligned with business logic for diverse account types and various lines of business.
• Enhanced validation process efficiency by automating file checks using stored procedures.
• Documentation and Reporting: Prepared a detailed test plan, test cases, validation report, and walkthrough results with business and development teams.
• Developed test plans, designs, and execution strategies for JIRA tasks using JTMF.
• Utilized document management system to organize company files, keeping up-to-date and easily accessible data.
• Debugged failed automated tests by analyzing log files and identifying root causes.
• Compiled reports, presentations, and documents to present findings to management.

TD Client - Project W360 Conversion:(2022-2023)

• Completed detailed validation procedures for migrating data between Mvest and W360.
• Automated testing via ETL process utilizing MS SQL Server 2012.
• Executed complex data tests by writing queries with T-SQL in stored procedures.
• Reduced table execution time from 9 hours to 40-60 minutes, significantly enhancing efficiency.
• Optimized complex queries for improved operational speed.
• Collaborated with multiple teams for executing functional and manual test cases.
• Collaborated with stakeholders during daily meetings to align on development and business objectives.

• Developed comprehensive Oracle PL/SQL functions, procedures, and triggers.
• Designed and implemented database objects such as SQL queries, tables, joins, and stored procedures using Oracle utilities.
• Constructed physical data structures such as tables, views, constraints, and indexes.
• Utilized SQL Loader and control files for data loading into various schema tables.
• Proficient in managing and operating Oracle databases, including versions 19c and 23c.
• Possess foundational understanding of AWR report analysis.
• Demonstrated effective communication skills to foster collaboration.
• Collaborated effectively within diverse, multi-stakeholder environments.
• Implemented materialized views to enhance summary table performance.
• Developed and updated Unix shell scripts to align with evolving project needs.
• Created scripts for unzipping files, cleaning junk characters, and preparing data for base table loading.
• Participated in ongoing improvements and resolution of production issues.

• Perform design and development of Oracle Applications according to Project requirements from requirement gathering to deployment
• Create new Oracle Reports and Forms, Also modified the existing one according to the requirement
• Good Understanding of PL/SQL and Oracle SQL Developer
• Provide technical assistance to other developers as needed
• Analyze and troubleshoot system issues in a timely manner
• Familiar with all the phases of SDLC
• Create, modify and test and codes, scripts and forms that allows a system to run a different type of applications
• Communicated with end users about Project Progress, updates and gather feedback and work to resolve on specific concern