Mithu Sri
Summary
Experienced Database Developer with over 3 years of expertise in MS SQL Server, Microsoft BI Tools, and data management across diverse sectors including Health Care, Finance, and Insurance. Proficient in SQL and Tableau, with extensive experience in database design, development, and support for MS SQL Server, Azure, and Oracle. Skilled in T-SQL, PL/SQL, SSIS, SSRS, and data modeling, ensuring efficient data management and analysis. Familiarity with Oracle database administration, encompassing tasks such as managing schemas, tables, views, and stored procedures. Strong problem-solving skills, quick learner, and dedicated team player, adept at collaborating effectively to achieve project goals.
Overview
4
4
years of professional experience
Work History
Data Analyst
Donegal
02.2022 - Current
- Utilized Python and R for predictive modeling and trend analysis, resulting in a 15% increase in network efficiency
- Developed automated data acquisition pipelines using REST API, streamlining the process of collecting and analyzing security-related data from multiple sources
- Conducted data analysis using SQL to query and manipulate data from Oracle databases, applying various join types to merge datasets and perform complex analyses
- Extracted and manipulated data from Oracle database using SQL queries for analysis and reporting purposes
- Applied SQL queries to extract and clean supply chain data from ERP systems
- Developed and optimized T-SQL queries and stored procedures in MS SQL Server, providing robust data solutions
- Utilized Microsoft SQL Server, SSIS/SSRS/SSAS, and Power BI to create ETL processes, data models, and reports/dashboards
- Performed Query Folding using Power Query to filter data in the data source server
- Implemented Date and time functions, Time-intelligence functions, Filter DAX functions
- Worked with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK
- Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business units
- Implemented Agile principles to cultivate a collaborative environment focused on accountability, transparency, and teamwork, thereby enhancing the effectiveness of the data analysis process.
SQL Developer
Gallagher (Offshore)
03.2021 - 11.2021
- Developed and maintained SQL queries to extract actionable insights from large datasets
- Designed and implemented complex SQL queries using stored procedures, common table expressions (CTEs), and temporary tables to support Power BI and SSRS reports
- Utilized PL/SQL proficiently for developing stored procedures, functions, and triggers to enhance data processing and manipulation
- Developed and maintained interactive Power BI dashboards to track hospital Key Performance Indicators (KPIs), fostering data-driven decision-making
- Analyzed healthcare data to identify trends and patterns, contributing to process improvements and operational efficiency
- Designed and implemented Extract, Transform, Load (ETL) processes using SQL Server Integration Services (SSIS) for seamless data integration from various healthcare systems
- Created database schemas and data models in Azure SQL Database, ensuring scalability and performance
- Implemented data integration solutions using Azure Data Factory, orchestrating ETL processes for efficient data movement
- Ensured data integrity and security by implementing access controls, encryption, and auditing mechanisms
- Proficiently worked with various database tools including SQL Developer, DB Visualizer, and Azure.
BI Developer
Helical IT Solutions Pvt Ltd, India
02.2020 - 02.2021
- Developed BI visual reports and dashboards using Power BI to present data insights in an accessible format
- Created reports from scratch in Power BI, including GSHS reports, using various chart types to visualize data effectively
- Utilized T-SQL to write queries, stored procedures, and packages, focusing on maintaining data integrity and handling slowly changing dimensions
- Utilized Tableau for data visualization, applying features such as data blending, filters, and hierarchies
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Education
MASTERS - COMPUTER SCIENCE
NORTHWEST MISSOURI STATE UNIVERSITY
05.2023
BACHELOR (BTECH) - INFORMATION TECHNOLOGY
BHARAT INSTITUTE OF ENGINEERING AND TECHNOLOGY
08.2021
Skills
- SQL
- T-SQL
- C#
- PL/SQL
- Java
- Python
- MS SQL Server
- Oracle Database
- Snowflake
- MS Access
- GIT
- GITHUB
- UNIX/Linux
- MS Office 365
- Microsoft Visio
- MS Office Tool suite
- HTML
- CSS
- Power BI
- SSRS
- Tableau
- Crystal Reports
- Data Visualization and Presentations
- Data Analysis
- Excel Functions
- Analytical Problem Solving
- R Programming
- Data Modeling
- ETL processes
- Data Mining
- Reporting Tools
Projects
Warehouse Inventory Application, Developed to support day-to-day warehouse operations, enabling product addition by workers, and providing owners with visibility and tracking capabilities., React.js, Java Spring Boot, MySQL, Implemented user authentication, barcode scanning, and real-time reporting features., Utilized RESTful APIs and automated testing for reliability and scalability.
Timeline
Data Analyst
Donegal
02.2022 - Current
SQL Developer
Gallagher (Offshore)
03.2021 - 11.2021
BI Developer
Helical IT Solutions Pvt Ltd, India
02.2020 - 02.2021
MASTERS - COMPUTER SCIENCE
NORTHWEST MISSOURI STATE UNIVERSITY
BACHELOR (BTECH) - INFORMATION TECHNOLOGY
BHARAT INSTITUTE OF ENGINEERING AND TECHNOLOGY