Public
PAVANI THUMPATI Email : ******************@*****.***
Mobile : +1-909-***-****
LinkedIn:pavani-thumpati
SUMMARY
* ***** ** *********** ********** in Business Analysis, Design, Development, Maintenance, Production Support, Coding, Testing, Documentation, Quality Assurance and implementation on Mainframe platform using COBOL, JCL, VSAM, REXX, CICS. Holds a master’s degree in COMPUTER SCIENCE, demonstrating a commitment to advanced learning and professional growth. Passionate of user experience, performance of applications, and change management and adoption. Known for effective problem-solving, teamwork, and delivering high-quality results within dynamic environments.Having Knowledge in a SQL query writing, data visualization, and building insights-driven dashboards. Experience with statistical modeling techniques and machine learning, including regression, decision trees, random forests, clustering, and segmentation. PROGRAMMING SKILLS
LANGUAGES: COBOL, PYTHON, SQL, C, C+, Java.
ENVIRONMENT : JCL, DB2, VSAM, CICS, REXX, EASYTRIEVE, IBM UTILITIES, TSO/ISPF TOOLS AND LIBRARIES: POWER BI, TABLEAU,PYTHON LIBRARIES (NUMPY, PANDAS, MATPLOTLIB), AWS(S3,EC2,Redshift) Kafka, Hadoop, CHANGEMAN, CONTROL-M/ESP, ATLASSIAN SUITE. PROFESSIONAL EXPERIENCE
Attra infotech Pvt.Ltd Pune, India
Software Engineer Project :PII Data Masking. Client : State Bank of India Dec 2021 -June 2022 Project Description: Restrict the Customer sensitive information by masking the card number and other customer information from all V+ screens from unauthorized users due to information security.
• Collaborated with Business SME’s to gather and analyze security requirements for protecting customer information.
• Conducted a thorough impact analysis to identify areas within the application requiring data masking in V+ screens.
• Designed and developed a robust data masking solution to protect sensitive customer information in V+ screens, including card numbers and personal details, from unauthorized access without affecting the system performance.
• Developed and executed comprehensive test cases to validate the effectiveness of data masking, ensuring that masked data of all functionalities of vision plus met security standards and compliance requirements through CICS (online programming).
• Integrated data masking functionality into existing application workflows using Programming languages COBOL, and Easytrieve, JCL ensuring seamless operation and minimal disruption to users.
• Created detailed technical specification documentation outlining the data masking process, including implementation steps, algorithms used, maintenance procedures and technical documentation.
• Implemented the code in production with endeavor, monitoring batch cycle execution and handled the abends occured during the job execution and ensuring continuous protection of customer information. Software Engineer Project: Excalibur phase III Client: State Bank of India Jan 2021- Nov 2021 Project Description: As part of Excalibur phase III it mainly works on Hardship tools (Settlement, Restructuring, Reinstatement
,Cibil cleanup) Legal tools and Interest processing.
• Coordinating with Business analyst and project team lead to gather project requirements and provided technical solutions.
• Acted as key team member in the development end-to-end data pipelines and ensure alignment with business goals.
• Developed and maintained solutions for Hardship tools, including Settlement, Restructuring, Reinstatement, and Cibil cleanup by using the Cobol modules, while also contributed to the development and maintenance of Legal tools and Interest processing systems.
• Ensured that all developed solutions using COBOL, CICS, Easytrieve, REXX adhered to high-quality coding standards and were thoroughly tested using JCL and promoted to the unit test region and production region.
• Participated actively in sprint planning meetings, providing accurate estimations for technical implementation tasks, and collaborated effectively with product teams to ensure the timely delivery of features and system enhancements.
• Live movement of project into production with version control tool Endevor, Provided Fix incase of abend and ensure the smooth operation and functionality of all systems and tools in Excalibur project phase III. Public
•
Software Engineer Project: Excalibur phase II Client: State Bank of India Feb 2020-Nov 2020 Project Description: Excalibur mainly works as the backend for the collecting Tracking Analysis (CTA) subsystem. As Part of Phase II worked o Payment Processing
• Teamed up with project stakeholders to collect requirements for Excalibur Phase II and offered technical solutions in line with business objectives.
• Developed and maintained the backend systems for the CTA subsystem by using the programming languages such as COBOL, CICS and Easytrieve to implement and optimize backend functionalities.
• Worked closely with cross-functional teams to ensure seamless integration of backend systems with other project components.
• Ensured that all solutions are promoted to the unit test region, pre-prod and production region through JCL and PROC and adhered to rigorous quality standards and were thoroughly tested before deployment.
• Provided detailed technical documentation where the project changes occurred in existing programs and new programs developed for the project for future reference.
• Participated in technical design walkthrough meetings. Associate Software Engineer. Project: Insurance Product on Cardone Client: State Bank of India May 2019 – Jan 2020 Project Description: As part of this Project adding extra insurance products along with the existing six insurance products by developing the new screen.
• Worked with cross-functional teams, including business analysts and product managers, to gather requirements for Insurance product Cardone project and ensure the new V+ screen met business needs.
• Developed new V+ screen to accommodate additional insurance products alongside the existing six products through batch and online programs using COBOL and CICS.
• Conducted thorough testing of the new V+ screen and associated functionalities to ensure reliability and performance.
• Ensured that all solutions are promoted to the unit test region, pre-prod and production region through JCL and adhered to rigorous quality standards and were thoroughly tested before deployment.
• Implemented the code changes and new programs in production region . Monitored the batch cycles and provided the production support to handle the abends.
• Documented the development process, including code changes, to ensure maintainability and knowledge transfer. PROJECTS
YouTube Data Analytics Pipeline (AWS Cloud) Jul 20204 – Sept 2024
• Designed and implemented an automated YouTube data pipeline using AWS cloud services to collect, process, and analyze large volumes of video metadata and user engagement metrics.
• Automated data ingestion with AWS Lambda and YouTube Data API.
• Performed ETL operations using AWS Glue and managed data storage in Amazon S3.
• Queried and analyzed data with Amazon Redshift/Athena and visualized KPIs using Amazon QuickSight.
• Orchestrated workflows with AWS Step Functions and monitored performance with CloudWatch. Pet Bingo Jan 2023 – April 2023
• Designed and implemented CI/CD pipeline using the Azure pipeline to automate the deployment of game features and infrastructure.
• Followed Agile Methodologies and utilized Azure DevOps tools for efficient project management..
• Managed Code versioning and collaboration with GitHub for Unity Projects ensuring smooth development workflows.
• Created and managed test cases in Azure DevOps to ensure software reliability and maintain high quality standards
•EDUCATION
California State University, San Bernardino San Bernardino, CA Master’s in computer science and engineering; GPA: 3.5/4.0 Aug 2022 – May 2024 Sathyabama Institute of Science and Technology, Tamil Nadu Tamil Nadu, India Bachelor’s in computer science and engineering; GPA: 8.5/10.0 July 2015 - May 2019
•