Gunjana Rana
Woodbridge
Summary
Dynamic SDET/QA professional with extensive experience at Freddie Mac, excelling in data migration and integrity assurance. Proficient in SQL scripting and adept at fostering team collaboration. Successfully enhanced business functionality and resolved data quality issues, ensuring seamless operations and compliance with regulatory standards. Strong communicator with a focus on delivering impactful results.
Overview
10
10
years of professional experience
1
1
Certification
Work History
SDET/QA
Freddie Mac
VA
06.2020 - Current
- Worked with Data Migration teams to ensure all the data are migrated with data integrity. Data are migrated to new systems from the Legacy system. Project involved incorporated all the business flows/system interact with each other internally and externally where the business transaction runs as expected and in sync with prod live transaction. The overall testing was to make sure the backup environment is up and running when needed. The project focused on resolving smooth run of business functionality and avoid any data quality issues, eliminating data duplication, providing consistent data for regulatory and management reporting.
- Participated in requirement review sessions during the Sprint plan phase and understood the requirements conceptually mapping those requirements with future working software product.
- Involved on batch upgrade on applications that incorporates AutoSys jobs.
- System and Integration testing.
- Create test cases in coordination with business teams, technical team and capturing the needed validation in each step.
- Involved in system testing and documented the findings per Disaster Recovery effort.
- Coordinated with team per dependencies and business flow or system interaction.
- Tracked the defect and escalated the roadblock during test execution.
- Validated column level test per data migration to sync the source and target databases.
- Coordinated with Developers for Defect analysis and performed Regression Testing. Rigorously performed Regression testing for every modification/enhancement of the project.
- Conduct the test cases review meeting with the project team and get approval or seek input if needed.
- Performed Manual, Functional Testing and involved on partly Automated Testing on performance testing.
- Leverage JIRA for task status and defect tracking.
- Review the test Results before sending them to business review and suggest modifications if anything is needed.
- Motivate the team with Kudos and appreciation emails from clients and share across the board.
- Incorporated review comments suggested by stakeholders in order to maintain good test coverage.
- Creating Test Data in Database as per business transformations and through live scenarios.
- Validating ETL Initial loads, Truncate and reload as well as incremental loads.
- Validate the source, target counts, duplicate check and data field to field validations.
- Validating the reports both GUI and data validations against database.
- Validated application across web browsers (URL applications).
- Document the Test results in share point, JIRA, confluence.
- AWS familiarity – solution architect training in progress.
Personal Relationship Manager/Quality Assurance
Bank of America
VA
03.2016 - 06.2020
- Worked as a Relationship manager to conduct efficient and healthy environment for both clients and employees within my department/division. Communication and time management was my main emphasis. Resolving conflict and solving financial issues was my focus as well.
- Involved in overall business functionality discussion and user’s expectations meetings.
- Involved in career growth/ training of employees (especially new hires).
- Training in company policies for new recruits and protocols to abide with company policies.
- Worked with the Credit Card division & Mortgage division handling user requests, modifying existing report and creating new reports based on the business criteria. Also created ad hoc reports.
- Resolved customer’s banking/financial issues on both IT related data and business transactions.
- Managing HR information systems.
- Coordinating and supervising the work of support staff.
- Maintaining accurate and confidential client’s records.
- Investment knowledge sharing and opportunity options shared to clients.
- Overseeing and facilitating training programs and workshops.
Education
Bachelor of Science - Information Systems and Operation management
George Mason University
Fairfax, VA, USASkills
- UNIX and Linux
- Windows and MS-DOS
- Database management systems
- Oracle and PostgreSQL
- MongoDB and MS Access
- MS SQL Server and Sybase
- DB2 and Toad 71
- Application lifecycle management
- Putty and QC tools
- Beyond Compare and Test Director
- Load testing with LoadRunner
- SQL scripting with Rapid SQL
- Automation testing with QTP
- Version control with Bitbucket
- Manual testing methodologies
Certification
- SAFe Agile 6.0
- Microsoft Azure
Executive Summary
5 years of IT experience applications and 5 plus years of Business Management and Operations in banking/financial area, Good communication skills with excellent listening skills and effective decision-making abilities, Positive thinking and always thinking as a team rather than individual to accomplish common goal, Possess strong interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management, Involved on managing employee relations, resolving conflicts and ensuring compliance with labor laws and company policies, Supporting professional development and performance management initiatives, Handling employee grievances, Coordinated with Development, Integration, Configuration Management, Testing, Training and Production teams for Repository build and deployment of IT codes, Experience in preparing Analysis Documents and User Acceptance Documents, Strong experience in all levels of testing such as Positive testing, Negative testing, Integration testing, Functional testing, System testing, Regression testing, and User Acceptance Testing (UAT), Black box testing, and Cross Browsers testing, Strong debugging and problem-solving skills with excellent understanding of system development methodologies, techniques, and tools, Prepare backend test jobs, setting up in scheduler, execution of batch jobs and analyzing the job logs and test results, Worked on Data analytics as a part of Testing team, Strong experience on jobs schedulers in different technical environments and preparing job nets by fulfilling successor and predecessor
Timeline
SDET/QA
Freddie Mac
06.2020 - Current
Personal Relationship Manager/Quality Assurance
Bank of America
03.2016 - 06.2020
Bachelor of Science - Information Systems and Operation management
George Mason University