Saritha Kodimela

• Participated in the sessions for requirement review and Analyzed business Requirements, data mapping requirement specifications, along with the team.
• Worked on functional and Structural test scripts and ensure the business requirements are met.
• Created Test plans which included test deliverables, features to be tested/not tested, Pass and Fail criteria of a test.
• Created UNIX shell scripts for Data centric applications created test cases according to the business requirements and ensured that all the positive and negative scenarios of the testing are covered.
• Wrote extensive SQL and Pl\SQL scripts to test Data Reconciliation, Initialization, Data Capture, Delta Processing, Incremental Process of Fixed Income applications.
• Created and executed test cases and test scripts based on test strategy and est plans based on ETL mapping document.
• Validated the reports sourcing data from parallel dataware house. Created adhoc reports and data centric tests to satisfy business in testing SQL server environments
• Backend validation involved testing the replication server and triggers (insert, update, delete) between databases.
• Wrote SQL queries to validate source data versus data in data ware house including identification of duplicate records initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
• Ran SQL queries to test for reconciliation and validated the referential integrity rules as per the design specifications. Coordinated execution of regression testing, Integration Testing and User Acceptance Testing

• Developed complex database processes with Pl\SQL containing batch or ETL functionality
• Developing and Enhancing an eliciting Datamart in an OLAP schema
• Requirements gathering, design, development, testing, and documentation.
• Designing logical and physical ERD diagrams, process flow diagrams or related data processing documentation
• Leveraging Oracle 10g/11g features into their fullest on their large-scale multi-layered system
• Assisting the Support team members including DBAs, requirement Analysts and others in understanding data and meeting user requirements
• Providing production deployment and production support as needed.

Project 1:
Supporting CLARITY Tool for AT&T, USA

• Support CLARITY and Service Management Suite (SMS) systems
• Implement Oracle stored procedures and other components
• Analyze, design and develop Oracle-PL\SQL components based on client requirements
• Maintain UNIX servers
• Ensure schedule jobs are completed before start of business

Project 2:
Support Order Management System (OMS) for Mitsubishi Motors Europe:

• Maintenance of Order Management System used to place vehicle orders by client
• Resolve user queries and outages
• Enhance the existing Pl\SQL code to meet the clients requirements.
• Write and execute queries to generate reports as per requirements
• Maintain UNIX servers