SRI RAM TEJA IALAM

Project Title: Travel Buddy

• Developed and maintained web applications using Python, Django, HTML5, CSS3, JavaScript, jQuery and SQL.
• Created custom database schemas to store application data in an efficient manner.
• Designed and implemented RESTful APIs for mobile applications using Django Rest Framework.
• Collaborated with other developers to debug code and review pull requests on Github.
• Performed unit testing of the developed code to ensure quality assurance.
• Configured Django settings files for production deployments of web applications.
• Managed databases such as PostgreSQL or MySQL to store application data securely while ensuring high levels of scalability and reliability.

Project Title: US-Tech Layoffs 2022(Python)

• Class Initialization: We define a class Layoffs to manage US company data during recession, encompassing data processing and CSV I/O functionalities, with an __init__ method setting up class attributes.
• CSV Writing Method: Utilizing a write method, we iterate over company data, format records into CSV rows, and write to a specified file using file handling techniques.
• Impacted Industries Analysis: Through most_impacted_industries method, we aggregate layoffs by industry, rank them based on impact, utilizing dictionaries and loops for data aggregation and sorting.
• Type of Company Analysis: With most_impacted_type_of_company, we categorize companies into public/private, determine impact percentage ranges for each category, leveraging dictionaries and loops for data organization.
• Ranges Determination: Using determine_ranges method, we categorize companies into impact percentage ranges, employing dictionaries and lists for sorting and assignment based on impact percentages.
• City Impact Calculation: The impact_in_cities method calculates the percentage impact of layoffs in each city, aggregating data and performing calculations to derive percentages, resulting in a dictionary with cities as keys and impact percentages as values.

• Designed and Developed SQL queries, SQR Programs for generating reports and importing data into HR/Payroll Systems
• Collaborated with the QA Team to update and test the SQR interfaces and reports to meet the Clients requirements by deploying SQL
• Designed and constructed and People Soft objects such as Records and Panels leveraging the Application Debugger
• Performed Quality Check Analysis for tasks Completed by peers to ensure Quality work is Delivered and tested all sql queries
• Developed Header ,Detail ,Tailer Records and enhanced Payroll Reports using ADP Reporting Tool and SQL conditions
• Identified bugs and performed patching of Clients to fix existing issues and enhance business logic using SQR and SQL.

• Designed complex SQL queries for retrieval and manipulation of data from multiple sources.
• Collaborated with other developers to develop efficient solutions for business requirements.
• Provided technical support for applications related to SQL server databases.
• Developed and tested stored procedures, functions, triggers, and views in SQL Server.
• Created database objects such as tables, indexes, constraints, and sequences.
• Implemented data integrity rules to ensure accuracy of data in databases.

• Deep Analysis of Data Using Machine Learning algorithms and then determining the best way to represent it visually to managers and stakeholders.