Development Specialist
Resume:
Madhuri Veeravaneni
*******.***@*****.***
CAREER OBJECTIVE:
To obtain a creative and challenging position in an organization that gives me an opportunity for self-improvement, while contributing to the symbolic growth of the organization with my technical, innovative and logical skills
LINE OF EXPERTISE:
• With 9.3 Years of experience as Testing lead.
• Played a critical role in ensuring timely and efficient testing of every requirement, logging the defects as per requirement
• Gained good experience on requirement gathering from clients and capturing it Testing documents
• Good knowledge in Development, Enhancement, Migration and Testing
• Expertise on Teradata sql and Teradata utilities like BTEQ, Multiload.
• Good knowledge on Unix commands and shell scripting
• Good knowledge in preparing Test plan, Test case scenarios and test scripts
• Have good analytical and development skills, capable of working independently as well as in team.
• Good at understanding the business requirements and implementing them.
• Have good knowledge on Teradata, Datastage and UNIX.
• Have Technical knowledge in all phases of Software Development Life Cycle and Software Testing Life Cycle along with Standard Waterfall and Agile methodology of delivering projects.
• Good knowledge and experience in Agile methodology
• Gained good experience in QA tools like Tosca, ALM and qtest
• Flexible to adapt to new Technologies.
• Very good knowledge in creating Test Strategy documents
• Involved in writing and reviewing of Test plans, prepared Traceability matrix to make sure all the requirements are captured in the Test cases
• Involved in Regression testing
PROJECT SUMMARY & WORK EXPERIENCE:
Application Development Specialist at Accenture, December 2021- October 2022
• As a Salesforce Testing Lead, ensured the configuration and customization performed in SDFC
• Managed ownership, responsibility and accountability of the ST, SIT, Automation and Performance test team throughout the testing phases of Project
• Automated the SDFC flow with Tosca
• As the project has been started from scratch, clearly documented test strategy document which callout the testing scope, testing assumptions/out of scope/non-testable areas etc. and get the same agreed with business.
• Involved in Sprint planning, capacity planning and design discussion, defect triage. IT Analyst at TCS, July 2013 – November 2021
Project 1:
Tenure: June 2016- Till date
FDIC: This project involves adding a new relationship for the deposit accounts as FDIC Insured accounts. FDIC Insured amount helps consumers to protect against the loss of insured deposits. AML KYC ESS: This project involves addition of new feed called name only entities for daily BAU. Also this effort includes decommissioning one of the existing SOR(LEO) and made it to combine with one of the existing SOR(CES)
Bank in Box Conversions: This project involves extracting data from source systems, applying transformations and loading the data after query tuning and performance check. The process of Extraction, transformation, compare and loading of the Data file from UNIX environment into the Data warehouse is done using the ETL Tool (DataStage) with Teradata load utilities like Multi-load and TPT operators. Designed Datastage jobs to check the Data quality and load the raw data into Data warehouse. Using UNIX shell scripts files splitting and archival processes are done. The raw data is used for Change Data Capture (CDC) process in Data warehouse using Teradata BTEQ scripts. The final data is published to downstream either as views or extract. These Processes are scheduled to run daily, weekly and monthly through Autosys.
BACARDI Transformations: This is an enhancement effort for which a new application code was being populated for one of the existing field. Transformations were done according to the client requirement. Roles and Responsibilities:
• SME for the client applications, developed new scripts and debug the issues faced.
• Understanding the requirement based on HLD/LLD
• Participated in scenario discussions to clearly understand business requirements
• Captured Test results for each level of testing
• Involved in Unit testing and System Integrated Testing
• Worked with complex SQL queries to test the data generated by ETL process.
• Worked on the complete end-to-end testing for enhanced quality of the application.
• Handled the design, development, discussions, status calls and defect-tracking single handedly.
• Get to know the business requirement and develop test scripts to perform testing.
• Interacted directly with clients for prioritizing tasks and sorting out the requirements completely.
Technical Skills:
• Structured Query Language (SQL)
• Teradata utilities – FLOAD,MLOAD,BTEQ,TPT
• Unix commands and Shell scripting
• Windows and Linux
Project 2:
Tenure: March 2015 - March 2016
OVD – Centralized Database and Authentication implementation) Purpose of OVD (Oracle Virtual Directory) Project is to control the admin accounts, i.e., everything should be one connection and it should be remote connection. The main purpose of this project is to increase database security by secure connections. CDBA implementation is to implement, enable and consume the CDBA service provided by EDS and EAM. It specifically focuses on the tasks to configure and enable centralized authentication and authorization for a database in the EDM environments. An active directory service account has been created for the host. The Keytab for the service account has been received from EAM and placed on the host. Configuration updates have been made which will support instance specific wallet locations and allow dbca and sqlnet.ora to reference the same wallet for a given database/instance.
Roles and Responsibilities:
• Maintain 99.99% availability for all Hosting products and infrastructure
• Pro-active performance analysis, monitoring, troubleshooting and resolution of issues.
• Installation of Oracle Database and client software
• Installation of 11g Grid infrastructure Software
• Converting 11g Databases in File Systems to OMF
• Monitoring Database growth, disk space and Re-organization of tables.
• Auditing and preparing reports for ASM Disk groups growth monthly
• ASM disk group creation/dropping/rebalancing. Troubleshooting RMAN backup job failures.
• Refresh staging and development databases from production using RMAN and EXPDP/IMPDP utilities
• Maintaining the availability of database during Oracle Failsafe
• Key role in OVD implementation
Oracle Utilities:
RMAN, DATAPUMP, DGMGRL, AWR, ASMCMD, SRVCTL, CRSCTL, OEM, GOLDEN GATE Software Skills:
DATABASE : ORACLE 11G/10G
OPERATING SYSTEMS : WINDOWS, LINUX, AIX & SOLARIS
Project 3:
Tenure: Jan 2014 – Dec 2014
Roles and Responsibilities:
• Responsible for managing production /test/QA/staging/DR environments
• Deployments in QA/STG/PROD and DR environments
• Performed Linux deployments for scheduling jobs
• User creation in weblogic Administration console
• Experienced to work with Development team, production support teams in handling critical situations to meet the deadline for successful completion of the task/projects
• Experience in using ETL tools like Administration console and work flow manager. Monitor and fix applications
• Experience in scheduling traffic flips jobs and performing pre-works
• Experienced in working for the deployments and application in production supporting
• Executing the SLA jobs performing all the pre-checks EDUCATIONAL QUALIFICATIONS:
Qualification Board / University Institute % (or) CGPA B.Sc (Mathematics &
Computer Science)
Andhra University
ABN & PRR College of
Science
8.91
Intermediate
Board of Intermediate
Education
Sri Chaitanya Jr. College 71%
10th SSC St.Francis E.M High School 89.3%
AWARDS / ACHIEVEMENTS:
• Received “Delivery Excellence” award for delivering defect free projects.
• Have involved in Productions installs and received appreciations for the successful installation of the application.
PERSONAL DETAILS:
Father's Name : V. Subba Rao
Date of Birth : 23rd February 1993
Nationality : Indian
Languages known : English, Hindi and Telugu
DECLARATION:
I hereby declare that all the above information is true according to my knowledge. Place: Eden Prairie
Date: (MADHURI VEERAVANENI)
Contact this candidate