Janany Jayarathinam

• Working as a senior test analyst.
• Analyzed business requirements, use cases and technical specifications for scripting comprehensive test cases.
• Tested stored procedures to ensure the logics are correctly incorporated into AWS Aurora/Redshift database from Oracle.
• Identified and resolved problems through root cause analysis and research.
• Queried databases for information needed for report processing.
• Logged defects and coordinated with UAT team to get signed-off for the bugs raised in ADO.
• organized training to newcomers in the team to explain the current working methodology.

• Involved in end to end ETL testing using ABINITIO.
• Understood the ETL workflows and prepared test cases accordingly.
• Executed test cases and documented the test evidences in jira.
• Developed SQL queries and executed them through abinitio GDE to capture exact test results.
• Participated in agile development cycles to provide timely feedback on system changes and potential issues.
• Mitigated risks associated with production deployments by performing comprehensive smoke tests after each release cycle.
• Conducted thorough functional testing for optimal application performance and user experience.
• Recommended changes and corrections to developers for optimal software performance and usability.
• Documented testing procedures for developers and future testing use.

• Involved in File backups in unix environment
• Having good understanding on feed processing
• Worked in Counts/Balances check, Enrichment validations and Exception Validations
• Good knowledge on subscriptions expedition, tool run and summary report analysis
• Handled various scenarios while report analysis
• Had good team sprit with various teams ETL,PTS and Source team
• Worked as part of functional testing (Database testing)
• Understood the ETL workflows and prepared test cases and test plan accordingly
• Handled HP ALM for defect management and few things in JIRA as well
• Worked with job scheduler as abinitio control center while doing feed processing to trigger the jobs
• Consolidate all the open issues based on the test result from the team and shared with the Customer every day
• Coordinated with Onsite and offshore and created good visibility to client
• Environment: Oracle, HP Quality Center 9.0/11.0 (ALM), SQL, tectia, Aginity Nettezza 11.0, , SQL Developer

• Design, configuration and implementation of Databases
• Interacting with the developers and troubleshooting the problems involved with the stored procedures, data access, table structures, scalable queries, file groups and problems related to the privileges and user access credentials
• Implemented and enforced security for all SQL databases and will check whether desired standards are being maintained
• Designing ER Model based on the available resources and requirements
• Experience in writing stored procedures to load data from staging to dimensions and various fact tables
• Environment: Microsoft SQL Server 2008, Power BI Desktop

• Got an experience in, Data loading from various sources (flat files, azure, S3)to snowflake
• Data unloading from snowflake to various destinations
• Creation of snowflake objects
• Creation of shares/data sharing strategy among multiple users
• Creation of consumer/provider roles and permission
• Environment: Amazon S3, Azure storage, Snowflake UI, Snow SQL (command line interface)

• Worked as part of functional testing (Database testing)
• Worked as Oracle and IFW Tester for source ( ORACLE, SQL Server, IFW) to target fork lifting of data
• Optimized test coverage with comprehensive test case creation and effective prioritization.
• Executing test cases and verified test results using AB INITIO ETL tool
• Coordinated with the Customer on Issues / Queries and maintained Issue register up to date.
• Coordinated with Onsite and offshore team and created good visibility to client
• Environment: Oracle, HP Quality Center 9.0/11.0 (ALM), SQL, winscp, Putty, Winscp, ALM 11.0, , SQL Developer, JIRA

• Responsible for creating test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes
• Analyzing requirements and creating test cases
• Test Case Execution
• Involved in Functional & Regression Testing
• Participated in periodic meetings with the client, development and onsite teams
• Prepared Process flow doc, mapping doc, test case document and support manual
• Environment: DOMO tool, Microsoft Office, Internet Explorer7.0, Window

Bachelor of Technology - B.E (Electronics and Communication Engineering (ECE))