| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateMITHUSKILLSSQLT-SQLPL/SQLJavaPython and R programmingMS SQL ServerOracle DatabaseAzureSnowflakeMS AccessGITHUBUNIX/LinuxMS Office 365Microsoft VisioMS Office Tool suiteHTMLCSSPower BI/ TableauSSRS/ SSISCrystal ReportsETL processesData Modeling/ Data MiningSoftware Development Life Cycle(SDLC)PROJECTSExperienced 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 HISTORYFebruary 2022 - CurrentData Analyst DonegalMarch 2021 - November 2021SQL Developer Gallagher (Offshore)Utilized Python and R for predictive modeling and trend analysis, resulting in a 15% increase in network efficiencyDeveloped automated data acquisition pipelines using REST API, streamlining the process of collecting and analyzing security-related data from multiple sourcesConducted data analysis using SQL to query and manipulate data from Oracle databases, applying various join types to merge datasets and perform complex analysesExtracted and manipulated data from Oracle database using SQL queries for analysis and reporting purposesApplied SQL queries to extract and clean supply chain data from ERP systemsDeveloped and optimized T-SQL queries and stored procedures in MS SQL Server, providing robust data solutionsUtilized Microsoft SQL Server, SSIS/SSRS/SSAS, and Power BI to create ETL processes, data models, and reports/dashboardsPerformed Query Folding using Power Query to filter data in the data source serverImplemented Date and time functions, Time-intelligence functions, Filter DAX functionsWorked with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANKCreated ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business unitsImplemented 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 datasetsDesigned and implemented complex SQL queries using stored procedures, common table expressions (CTEs), and temporary tables toCONTACTPHONE NUMBER AVAILABLEEMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLE4736781b8/Warehouse Inventory Application,Developed to support day-to-daywarehouse operations, enabling productaddition by workers, and providingowners with visibility and trackingcapabilities., React.js, Java Spring Boot,MySQL, Implemented userauthentication, barcode scanning, andreal-time reporting features., UtilizedRESTful APIs and automated testing forreliability and scalability.February 2020 - February 2021BI Developer Helical IT Solutions Pvt Ltd, Indiasupport Power BI and SSRS reportsUtilized PL/SQL proficiently for developing stored procedures, functions, and triggers to enhance data processing and manipulationDeveloped and maintained interactive Power BI dashboards to track hospital Key Performance Indicators (KPIs), fostering data-driven decision-makingAnalyzed healthcare data to identify trends and patterns, contributing to process improvements and operational efficiencyDesigned and implemented Extract, Transform, Load (ETL) processes using SQL Server Integration Services (SSIS) for seamless data integration from various healthcare systemsCreated database schemas and data models in Azure SQL Database, ensuring scalability and performanceImplemented data integration solutions using Azure Data Factory, orchestrating ETL processes for efficient data movementEnsured data integrity and security by implementing access controls, encryption, and auditing mechanismsProficiently 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 formatCreated reports from scratch in Power BI, including GSHS reports, using various chart types to visualize data effectivelyUtilized T-SQL to write queries, stored procedures, and packages, focusing on maintaining data integrity and handling slowly changing dimensionsUtilized Tableau for data visualization, applying features such as data blending, filters, and hierarchiesIndependently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.EDUCATIONMay 2023Master of Science COMPUTER SCIENCENORTHWEST MISSOURI STATE UNIVERSITY, Maryville, MO August 2021Bachelor of Science INFORMATION TECHNOLOGYBHARAT 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 |
