Kishore gunnala

• Creating Store Procedures queries with Inner Join, Outer Join, and correlated sub-query with String function, Mathematical function, Aggregate function, Date and Time function. • Analyzing and modifying the store procedures to fix the defects. • Scheduling and monitoring jobs through Autosys. • Implemented the ETL process to Extract data from different sources, transform and load into SQL server data base.

• Identifying multiple reports and rationalizing into one single report. • Implemented the ETL process to Extract data from Oracle source, transform and load into SQL server data base. • Maintaining of existing SSIS packages. • Created T-SQL queries with Inner Join, Outer Join, and correlated sub-query with String function, Mathematical function, Aggregate function, Date and Time function. • Created store procedures, triggers and dynamic queries. • Taking backup and restoring database

• Involved in developing test plan. • Deciding the strategy and methodology for manual testing. • Identifying various scenarios for functional and integration testing. • Executing various test cases like Certification checklist, tier test and QWERTY checklist. • Preparation of daily and weekly reports and updating to respective leads. • Executing of Manual scripts for the existing applications • Design the scripts, enhancing the script and debugging the scripts.