Sai Kishore Mekala

Project : Optum Finance

• Worked effectively in Data Migration from DB2 database to Teradata with ETL jobs.
• Effectively write the SQLs to load the tables
• Taken initiative to work as a Business Analyst for few Business requirements and prepared Mapping documents
• Acted as Devops Engineer starting with taking the requirements, developing the ETL jobs, validating the scripts and fixing the defects if any and Deploying the code.
• Provided support and troubleshooting for ETL jobs and systems.
• Provided assistance and technical support in testing of code in the QA phase
• Executed manual and automated tests to verify software functionality, performance, and security.
• Participated in regression testing efforts to ensure the stability of software releases.

Project : NHI (Normative Health Informatics)

• Developed and maintained end-to-end operations of ETL data pipelines and worked with large data sets in Azure Data Factory.
• Researched and Implemented various components like pipeline, activity, mapping data flows, data sets, linked services, triggers and control flow.
• Performed extensive debugging, data validation, error handling mechanism, transformation types and data clean up analysis within large datasets.
• Collaborated with DevOps Engineers to developed automated CI/CD and Test driven development pipeline using Azure as per client standards.
• Responsible for designing, building, validating, and maintaining heterogeneous databases and integrating these databases into a integrated data source.
• Automated manual data query task and modified existing software programs to enhance performance with indexing,normalization and performance tuning queries.
• Collaborated with database administrators to optimize data extraction and loading processes.
• Identified trends and patterns in large datasets, leading to actionable insights for business growth.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using DataStage to extract the data from multiple source systems that comprise databases like Teradata.
• Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle.
• Participated in on-call support rotation to address production issues and ensure data integration SLAs were met.

Project : Bank of America, US / Ulta Store, US / Sears Holding Corporation, US

• Worked as an acting Lead and led the team to accomplish the given tasks well in advance to meet the deadlines scheduled.
• Understanding the requirements & technical specifications; assess system to identify test cases which are feasible to automate.
• Discussion with clients and picking the right candidates for automation.
• Preparing Estimates and Test Plan, work allocation and tracking, Test Script preparation and review.
• Used Selenium tool to automate the basic UI applications which are part of Regression test suite, also used TOSCA and UFT tools for the execution modules asked by the Client.
• We have not only saved 60+ hours of execution time each release using the tools but also saved approximately $70mn money spent by the client.
• Training new colleagues on the TOSCA framework and UFT scripts for Test suite.
• Preparation of Test Strategy, Test Plans, Test Summary, extensive experience in Test Design, Test Execution.
• Proficient in test management tools such as SAP Solution Manager, HP Quality Centre. Hands on experience in various testing types such as Functional Testing, Interface Testing and User Acceptance Testing (UAT support), Integration Testing, System Testing, Regression Testing.
• Training new joiners on SAP and best practices in testing.
• Helping SAP testing COE in documenting manual test cases and automation team in developing SAP specific frameworks and test scripts.
• Onsite exposure with effective coordination between both onsite/offshore QA teams, coordination between multiple teams such as Functional, Technical, Business and QA team besides having regular Client interaction on understanding the business logics.
• Requirement analysis, Test Planning and Estimation as onsite co-ordinator
• System, Integration and End to End testing, acted as a UAT Testing co-ordinator