MAHESWARA REDDY GOLAMARU
System Engineer
Denton,TX
Summary
Dedicated candidate eager to leverage knowledge in classroom management and individualized support. Skilled in instructional design and assessment tailored to diverse student populations. Collaborative and committed to tracking student performance and progress.
Overview
5
5
years of professional experience
Work History
Graduate Teaching Assistant
University of North Texas
, USA
08.2022 - Current
- Serving as a Graduate Teaching Assistant in computer science and information systems department for the courses Analysis of
- Computer Algorithms, Distributed & Parallel Database Systems and Fundamentals of database systems
- Responsibilities included delivering guest lectures, grading assignments, projects, and exams, preparing lecture materials, proctoring exams, communicating with students regarding courses, and holding office hours to answer student questions.
Assistant System Engineer
Tata Consultancy Services (TCS)
Hyderabad
12.2018 - 08.2021
- Involved in creating automated QA process to detect data discrepancies in data loading, reducing manual analysis
- Integration of different source data in staging area by using different data pre-processing techniques like data merging, data preprocessing or data cleansing and aggregation
- Proficient in deploying new application software and updates, including web applications, and scheduled tasks
- Responsible for plan, implement, deploy, and monitor routine tasks required for daily business operations using third-party tools/applications
- Hands on Experience in identifying deployment issues, including issues related to source code repositories, dependencies, merge conflicts, build, issue tracking, reporting, and other third-party tools
- Experienced in deploying and validating software necessary to manage development life cycle, including development requests,
- QA testing, approvals, and release/deployment history
- Experience in implementing Unix shell scripts for scheduling (CRON Jobs), patching and data pooling activities into flat files
- Ability to ensure accuracy of logs maintained for all deployment requests, troubleshooting steps, methods, and resolutions using service desk software and Proficient in debugging enterprise application issues by reviewing errors and program code
- Worked on query optimization and building Power BI dashboards for improved portfolio insights visualization
- Supported production jobs and developed several automated processes to handle errors and notifications
- Also, tuned performance of slow jobs by improving design and configuration changes of PySpark jobs
- Responsible for optimizing SQL queries, stored procedures, functions, and ad-hoc SQL in PostgreSQL, Oracle to enhance report generation using RAF automation framework
- Constructed and maintained complex SQL scripts, indexes, partitions, cursors, and views for data extraction and analysis
- Implemented build automation using Maven, CI/CD and Jenkins for automation of code deployment
- Experience in documenting project workflows using Confluence and responsible for updating application documentation
- Developed scripts which supports Incremental buildout of the data for evolving data needs by adopting the agile methodology
- Analyzed and executed the test cases for various phases of testing such as unit testing, integration, and regression
- Collaborated with business and financial analysts and product owners to enhance business logic for automating existing manual workflows, data mapping, and development and walkthrough different possible solutions for the business requirements
- Outlined analysis and insights of reports for around 80 million records by processing PLSQL scripts and packages
- Reduced amount of monthly JIRA tickets, by 8%, by frequently coordinating with internal teams, Business analysts and CSMs
- Automated application reporting mechanism using Python and JSON to dynamically generate reports on recurring basis
- Identified analytical solutions to extract business insights by conducting analysis on large amounts of business data with an emphasis on identifying trends and determining root cause analysis to drive effective business decisions
- Developed Automation Scripts to validate ETL process between multiple databases like Hadoop and SQL Server using Python
- Developed Spark jobs using Pyspark and Spark-SQL for data extraction, transformation, aggregation from multiple file formats.
Software Developer Intern
KJ Systems India Pvt.Ltd
Hyderabad
12.2017 - 03.2018
- Developed the user interface for a health domain application named "UHR Your Way" using front-end technologies such as
- HTML, CSS, and Angular JS, and implemented backend services using C#
- Conducted analysis and executed test cases on the UI, focusing on browser compatibility, performance, and user experience
- Has a solid understanding of DBMS/RDBMS concepts and practical experience with T-SQL and MySQL databases
- Developed PLSQL packages, procedures, functions, and triggers
- Responsible for optimizing complex SQL queries, existing stored procedures, and functions to improve application performance
- Accountable for documenting project workflows and maintaining version control of documents
- Collaborated with business users, product owners, and IT Operations team to review code and design processes
- Hands on experience with GIT repo, patch installations and responsible for codebase management.
Education
Master of Science - Computer and Information Sciences
University of North Texas
Bachelor of Engineering - Computer Science and Engineering
Andhra University
Skills
Database/ Datawarehouse: Microsoft SQL Server, MySQL, T-SQL, PLSQL, PostgreSQL, Oracle, HBaseundefined
Timeline
Graduate Teaching Assistant
University of North Texas
08.2022 - Current
Assistant System Engineer
Tata Consultancy Services (TCS)
12.2018 - 08.2021
Software Developer Intern
KJ Systems India Pvt.Ltd
12.2017 - 03.2018
Master of Science - Computer and Information Sciences
University of North Texas
Bachelor of Engineering - Computer Science and Engineering
Andhra University