Dastagiri Reddy Email & Phone Number

Bengaluru, Karnataka, India

Currently I am working as Service Delivery Manager for multiple Mainframe customers.

Bengaluru, Karnataka

Manager Responsibilities:• Managing team of 27 members including DBAs, System programmers, CICS administrators• Actively reviewing Project Tasks, DBA workload and changing as per the requirements.• Monitoring ITSM queues and driving the team to take appropriate actions, • Represented team in Change meetings, Customer Calls, Major Incidents.• Handled Performance Management and Resource forecasting.• Involving in New project implementation meetings and doing Resource forecasting. AccordinglyTechnical Responsibilities:• Installation, Up-gradation & Maintenance of Software AG (NATURAL, ADABAS, Event Replicator) products to the latest• ADABAS Database Objects File creations, deletions and modifications.• NATURAL Programs backup and restoring• ADABAS utilities failures and supported for production Batch support• Maintenance of housekeeping jobs like full backup jobs, Database started tasks, Delta save jobs• User Security (NATURAL Security) Administration, Permissions to Natural libraries, addition of users to groups• Health Checks (File extents) & Performance Analysis (High watermarks)• General ADABAS Change requests (Field additions, Space increase) for applications • Decommissioning activities of ADABAS Databases and Natural programs.• Software AG and Third party (Blenheim Software) vendor interaction for license, ZAPS• Providing the user information for Auditing.• Incident and Problem resolution of all Severities.• Provided 24X7 support for ADABAS and DB2 DBA.

Bengaluru, Karnataka

I have worked in Wipro as Senior Consultant.

Bengaluru Area, India

• Analyze and understand testing requirements from business requirement document, technical requirement specs• Analyze and review Informatica (ETL) mappings to understand the technical implementation of business rules• Design and document Data warehouse (FDW) testing strategy covering the test cases for validating the data completeness and correctness, system performances of the ETL processes etc.• Prepare test plan and work breakdown estimate and obtain sign off for test strategy development, test planning document• Executing ETL jobs, writing SQL queries, validating ETL/data warehouse process and business mapping rules for Initial and delta loads.• Schedule and monitor the test cases execution• Executed ETL projects involving Data Mapping• Scheduling triage meetings to keep track and level of severity defects and communicating it to Project Managers with Execution Score Card with defect Status• Hands on experience in Unix/Linux based systems and using Putty tool to connect to servers.• Loading of input data files for different interfaces and ensure that data gets loaded correctly with proper counts for run, load & suspended records.• Log and publish the test results and raise the defects to the defect/change management system• Executing ETL batch jobs and writing reusable SQL scripts and validate data loaded in the target database.• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.• Developed complex SQL queries for querying data against different data bases for data verification process.• Prepared the Test Plan and Testing Strategies for Data Warehousing Application• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.

• Developed the Test Scripts and Test Plan based on the Business requirement document, Design and Analysis • Used HP Quality Center for Test Planning, creating Test Cases, Test Execution.• Performed the Back-End integration Testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.• Responsible for testing the source to target loading based on mapping documents.• Written SQL queries manually and also built SQL queries using TOAD.• Defect detection, reporting and tracking was done using JIRA and ALM• Performed testing for data validation, data completeness ,data quality using SQL queries• Verification of the Test Results after Every Cycle of Testing.• Analyzed modules and designed test scenarios and test scripts.• Maintained the Requirement Traceability Matrix (RTM).• Participated in daily status meetings to report any bugs, issues and risks.

Master Of Computer Applications, Computer Science

B.S.C, Statistics

Completed my BSC Statistics and computers