Sravan Kumar

Evaluated existing database systems to identify areas for improvement and designed overall database solutions that met business requirements. Assisted organizations in designing and architecting efficient and scalable database solutions, working with cross-functional teams to identify data issues and develop ETL jobs.

Developed and debugged Kettle ETL jobs for data movement between database servers and deployed AWS Athena-based reporting tools for heavy data extraction. Managed 80 MySQL database servers, including replication activities and database maintenance, and developed Python scripts for data integrations and forecasting models.

Analyzed and developed custom database APIs using PostgreSQL and PL/pgSQL, and developed ETL jobs deployed via cron tabs on Linux servers. Implemented auditing mechanisms using trigger mechanisms and developed new reports with complex PL/pgSQL scripts to identify anomalies.

Developed several canned reports using analytical and custom functions, and created/debugged database objects such as Tables, Stored Procedures, Functions, Triggers, Materialized Views, and Indexes. Resolved database performance issues by optimizing stored procedures and imported data using SQL loaders for bulk updates.

Evaluated existing Cognos reports and developed new reports on Jaspersoft reporting, including complex PDF/XLS reports using Java expressions and JasperReports Library. Maintained codebases for JRXMLs and XMLs using Mercurial Repositories and wrote complex Oracle SQL queries for reporting purposes.

Evaluated user requirements and documented them for testing native functionality of Netsuite, Mailchimp, and Pipedrive. Built custom forms, fields, reports, dashboards, and workflows to fulfill user requirements, and integrated various SaaS applications using API integrations.

Developed key analysis reports for management and conducted research on tax frauds related to information technology filing methods. Performed trend analysis of fraudulent tax returns by considering various metrics.

Worked as a support system to the Chief Marketing Officer, extensively using MS Excel and MS Access for data management, reporting, and visualization. Performed market analysis and allocated budgets based on premium forecasting, and automated daily business figure reporting using Google for Work applications.

Negotiated with internal and external business partners to provide better insurance coverage and claims service to clients. Ensured timely completion of budgeted premiums by nurturing intermediaries and handled client/claims service, providing risk management advice to corporate clients.

Completed a Master of Science in Informatics, focusing on advanced topics in information systems and data management. Gained expertise in data analysis, software development, and database management.

Pursued a Post Graduate degree in General Insurance, acquiring specialized knowledge in insurance principles and practices. Developed a strong understanding of the insurance industry's operational and regulatory aspects.

Earned a Bachelor of Science degree, building a foundational understanding in core scientific disciplines. Developed analytical and problem-solving skills through comprehensive coursework.