Lohith Kumar Email & Phone Number

Miami, Fl, Us

Chicago, Illinois, United States

Provided reliable recommendations in DRB review sessions to ensure adherence to naming standards at both physical and logical levels, showcasing a strong understanding of database management principles and data governance.• Utilized advanced SQL techniques for data extraction, transformation, and loading (ETL) processes, and conducted data profiling to analyze data sources and targets, ensuring data integrity and quality.• Proficient in backend programming involving schema and table… Show more Provided reliable recommendations in DRB review sessions to ensure adherence to naming standards at both physical and logical levels, showcasing a strong understanding of database management principles and data governance.• Utilized advanced SQL techniques for data extraction, transformation, and loading (ETL) processes, and conducted data profiling to analyze data sources and targets, ensuring data integrity and quality.• Proficient in backend programming involving schema and table design, stored procedures, triggers, views, and indexes. Developed complex Tableau dashboards and a custom Tableau Report Portal with PostgreSQL for real-time usage tracking and enhanced navigation.• Collaborated with data scientists, engineers, Product Owners, and end-users in a highly collaborative and agile environment to design and maintain scalable data models and pipelines. Prepared scripts in R programming language for data access, manipulation, and reporting functions.• Conducted extensive data analysis using SQL on Teradata and Oracle systems, defining code lists and conversions between source systems and data marts. Migrated data from Oracle and MySQL databases to AWS using Unix-based File Watcher tool and automated workflows with bash scripts and Control-M jobs for efficient data processing.• Leveraged AWS cloud services for data storage, processing, and analytics, ensuring scalable, secure, and efficient data solutions that support various business needs.• Analyzed large datasets to identify trends, patterns, and insights, providing data-driven recommendations to support strategic decision-making and business initiatives.• Environment: DRB, PostgreSQL, Oracle, SQL, SQL Server, Snowflake, MySQL, AWS, S3, Arrow, API, JSON, Teradata, RDBMS, Tableau, data profiling, schema design, indexing, agile work settings. Show less

United States

• Managed and enhanced the professor's website, integrating the LexisNexis search engine. Optimized data collection, cleaning, and processing for Excel and PowerBI, enhancing research efficiency.• Served as a Teaching Assistant for the Data Mining course, assisting in assignment creation, and grading.• Analyzed complex datasets to identify trends, patterns, and insights, providing data-driven recommendations to support academic research projects.• Developed and maintained… Show more • Managed and enhanced the professor's website, integrating the LexisNexis search engine. Optimized data collection, cleaning, and processing for Excel and PowerBI, enhancing research efficiency.• Served as a Teaching Assistant for the Data Mining course, assisting in assignment creation, and grading.• Analyzed complex datasets to identify trends, patterns, and insights, providing data-driven recommendations to support academic research projects.• Developed and maintained interactive dashboards using PowerBI to visualize data and track key performance metrics.• Utilized SQL for database querying, ensuring data accuracy and consistency across various projects.• Assisted in the development and deployment of cloud-based data storage solutions using AWS, improving data accessibility and scalability.• Conducted statistical analyses using Python and R to support academic research and decision-making processes.• Environment: LexisNexis, Excel, PowerBI, SQL, Python, R, AWS, cloud-based data storage, data mining, data visualization, statistical analysis. Show less

Hyderabad, Telangana, India

• Assisted in the development and optimization of complex SQL queries, stored procedures, and functions across multiple database systems including PostgreSQL, Oracle, MySQL, and SQL Server.• Supported the design and implementation of database schema and indexing strategies to enhance database performance and ensure data integrity.• Collaborated with senior data analysts to clean, profile, and prepare datasets for analysis, ensuring high data accuracy and consistency using advanced SQL… Show more • Assisted in the development and optimization of complex SQL queries, stored procedures, and functions across multiple database systems including PostgreSQL, Oracle, MySQL, and SQL Server.• Supported the design and implementation of database schema and indexing strategies to enhance database performance and ensure data integrity.• Collaborated with senior data analysts to clean, profile, and prepare datasets for analysis, ensuring high data accuracy and consistency using advanced SQL techniques.• Developed and maintained dashboards and reports using Power BI and Tableau, providing actionable insights to stakeholders and contributing to data-driven decision-making processes.• Worked in an agile environment, regularly interacting with data scientists, engineers, and business users to understand data requirements and deliver scalable data models and solutions.• Environment: PostgreSQL, Oracle, MySQL, SQL Server, SQL, Power BI, Tableau, data profiling, schema design, indexing, agile work settings. Show less

Master'S Degree, Computer Science

Bachelor Of Technology - Btech, Computer Science, A