Sql Server Ms
Resume:
MITHU
SKILLS
SQL
T-SQL
PL/SQL
Java
Python and R programming
MS SQL Server
Oracle Database
Azure
Snowflake
MS Access
GITHUB
UNIX/Linux
MS Office 365
Microsoft Visio
MS Office Tool suite
HTML
CSS
Power BI/ Tableau
SSRS/ SSIS
Crystal Reports
ETL processes
Data Modeling/ Data Mining
Software Development Life Cycle
(SDLC)
PROJECTS
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. WORK HISTORY
February 2022 - Current
Data Analyst Donegal
March 2021 - November 2021
SQL Developer Gallagher (Offshore)
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.
•
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
•
CONTACT
*********@*****.***
https://www.linkedin.com/in/sri-d-
4736781b8/
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.
February 2020 - February 2021
BI Developer Helical IT Solutions Pvt Ltd, India
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.
•
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
May 2023
Master of Science COMPUTER SCIENCE
NORTHWEST MISSOURI STATE UNIVERSITY, Maryville, MO August 2021
Bachelor of Science INFORMATION TECHNOLOGY
BHARAT INSTITUTE OF ENGINEERING AND TECHNOLOGY, India Additional Courses: My coursework included in-depth studies in C programming, cloud computing, networking, data structures, Java programming, relational database management systems (RDBMS), and algorithms.
Additional Courses: Specialized in Object-Oriented Programming in Java gained proficiency in Oracle SQL during my master's studies, equipping me with skills to develop robust software solutions., Completed coursework in web development technologies such as HTML, CSS, JavaScript, and frameworks like React.js, along with visualization techniques using tools like Tableau to present data effectively., Explored iOS app development fundamentals, including Swift programming language.
•
• GPA: 3.60
Contact this candidate