Devi Kondragunta Email & Phone Number

Jersey City, New Jersey, United States

• Preparation of documentation for all the requirements and reports.• Design SSIS packages, Store Procedures, configuration files, tables, views, and functions and implement best practices and to maintain optimal performance.• Created and maintained stored procedures, views, and functions using SQL to automate data management tasks and improve application performance.• Executed SQL queries to retrieve, manipulate, and analyze data from relational databases, supporting various business requirements.• Skilled at writing SQL queries, creating stored procedures, and managing data migrations.• Writing and debugging SQL scripts to support application development and troubleshoot data-related issues.• Successfully migrated the data between heterogeneous sources like Flat File, Excel Source, Oracle, and SQL server.• Implemented Triggers for checking complex business conditions, providing security for the tables.• Created check constraints to maintain data integrity.• Created various T-SQL Tables and views and performed complex transformations to generate the Dimensions and facts.• Created database schemas to organize and store data efficiently, to improve normalization.• Developed creative solutions for challenging client needs using agile methodologies and participated in sprint planning, retrospectives, estimates, etc.• Developed simple ETL processes to extract, transform, and load data from various sources into databases for reporting and analysis.• Gained familiarity with database backup and recovery processes, ensuring data protection and availability.

Hyderabad, Telangana, India

• CIS (Customer Information System) is a software to build cloud services (hybrid, public, private).• Managed and configured anti-virus software, encryption tools and other security measures through McAfee.• Implemented cloud services, combining hybrid private and public cloud models.• Trained in advance infrastructure services and aimed at enhancing customer data center network and server storage capabilities.• Utilized data analysis techniques to optimize performance and security resulting in improved data processing with existing systems.• Implemented McAfee Endpoint Security (ENS) and McAfee VirusScan for protection against malware and cyber threats across all endpoints.• Customized McAfee policies and settings to align with CIS benchmarks for security controls.• Performed assessments using McAfee solutions to identify risks and applying necessary updates to prevent security breaches.• Monitored and analyzed the performance of McAfee security solutions, adjusting configurations to improve System efficiency and reduce system impact.

Hyderabad, Telangana, India

• Understand data requirements from the business analyze source data and derive required datasets.• Worked on coding and unit testing phases, writing clean, maintainable code.• Assist in designing and optimizing database structures, including creating tables, indexes, and relationships for data storage and retrieval.• Involved in various phases of Software Development Life Cycle (SDLC) as requirement gathering, data modeling, analysis, architecture design & development for the project.• Worked with databases like MySQL to store, update, and retrieve data for various applications.• Collaborated with senior engineers to understand software requirements and contributed to design discussions and using version control systems like Git, ensuring smooth code integration.• Maintained MySQL Workbench to resolve bottlenecks.

Master'S Degree, Computer Science

Bachelor Of Technology - Btech, Information Technology