Home

Srujan - Data Analyst

[email protected]

Location: Cincinnati, Ohio, USA

Relocation: ANY

Visa: OPT EAD

Srujan Gunda Data Analyst Cincinnati, OH| +1 (513) 599-9858 | [email protected] SUMMARY 4 years of experience in data analysis, visualization, and statistical modeling using Python, R, Tableau, and Power BI. Proficient in SQL, including stored procedures, triggers, and packages, with expertise in MySQL, MongoDB, and SQL Server. Skilled in machine learning techniques such as clustering, classification, regression, and gradient boosting. Hands-on experience in data wrangling, exploratory data analysis, data modeling, and cloud data management using AWS. Strong communication, problem-solving, and teamwork skills, with experience across the Software Development Life Cycle (SDLC). Languages: Python, R, SQL, SAS, PySpark Databases: MS SQL, PostgreSQL, SQL, Mongo DB, Dynamo DB, Snowflake Python Packages: NumPy, Pandas, MatplotLib, Seaborn Visualization Tools: Tableau, QlikView, Power BI, Excel Pivot tables Platform/IDE: Jupyter Notebook, R-Studio, R Shiny Version Control Tools: GIT, GitHub and JIRA Data Analysis Techniques: Data Visualization, Data Mining, Data Warehousing Cloud Platforms: AWS, Azure Methodologies: Agile, SDLC and Waterfall Operating System: Windows, Linux and macOS Other skills Excel, Excel VBA, Macros, Databricks Berkshire Hathaway USA Jan 2024 Present Data Analyst Developed SQL queries to analyze financial and insurance-related data, including claims processing, premium trends, and risk assessment metrics. Utilized Python for visualizing insurance portfolio data, offering actionable insights into policy performance and operational efficiencies. Streamlined underwriting and ensured regulatory compliance by enhancing data models. Applied Python and SQL to manipulate financial transaction data, supporting accurate reporting and forecasting. Redesigned data models with Power Designer to align with evolving business needs in the insurance sector, ensuring data integrity and scalability. Created new EC2 instances in AWS, allocated resources, and implemented IAM roles to secure financial data and ensure compliance. Designed data models for various insurance domains in the staging layer, optimizing data workflows for analytics. Developed and reviewed Tableau dashboards showcasing key performance indicators (KPIs) such as claim trends, premium collections, and risk distributions using visual elements like stacked bars, geographical maps, and Gantt charts. Migrated historical insurance claims data into the AWS cloud and set up automated processes for incoming Clickstream and transactional data. Srujan Gunda Data Analyst Cincinnati, OH| +1 (513) 599-9858 | [email protected] CERTIFICATIONS EDUCATION Performed data cleansing and preparation for financial analysis by slicing and dicing data using SQL and Excel. Generated, tested, and executed SQL scripts to implement database changes, including table updates, index additions, and creation of views and stored procedures for financial data operations. Conducted data mining to identify trends in customer claims, payment patterns, and policy renewals. Developed and optimized triggers, stored procedures, and functions in PL/SQL to support real-time data processing for financial applications. Collaborated with stakeholders to identify business, functional, and technical requirements in insurance processes through detailed meetings. Polaris India Jan 2020 Nov 2022 Data Analyst Crafted and validated complex SQL queries with joins (inner, left, right) in Tableau Desktop to support robust data validation and dynamic reporting across multiple projects. Executed SQL-based data retrieval and analysis to support diverse data modeling and reporting requirements in various business domains. Conducted data warehousing, modeling, and mining to derive actionable insights and drive analytics initiatives for multiple organizational projects. Imported claims and operational data into Python using Pandas, enabling detailed data analysis and visualization tailored to project-specific needs. Developed comprehensive operational reports and dashboards using Tableau and Power BI, empowering senior management with project-specific insights for informed decision-making. Designed and produced weekly and monthly reports using advanced MS Excel techniques (charts, graphs, pivot tables) and PowerPoint presentations for executive review in various projects. Applied advanced data modeling and SQL expertise with columnar databases in AWS to optimize data workflows for multiple initiatives. Utilized R, SQL, Excel, and Tableau to manipulate and analyze data sets such as computer repair logs, providing valuable insights across distinct project contexts. Created complex SQL queries to extract and aggregate data from remote databases, leveraging joins, database links, and bulk collect methods to support diverse project needs. Performed risk analysis on project requirements to identify critical success factors and prioritize functional deliverables, ensuring project alignment with organizational goals. University of Cincinnati| Cincinnati, OH May 2024 M.S. Information Technology Bharat Institute of Engineering & Technology | Hyderabad, IN May 2021 B. Tech in Computer Science & Engineering IBM Data Analysis with Python Azure Data Engineer Associate Azure Data Fundamentals Certificate Keywords: business intelligence database rlang microsoft procedural language Ohio