| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Python, R, SQL, PowerBi, Tableau, ML, AWS, Axure, Excel, PowerPo Chicago, IL SQL, Microsoft Excel, Power Bi, Data Analytics, Python Chicago, IL SQL DBA Chicago, IL Sql Server Business Intelligence Aurora, IL Software Development Sql Developer Aurora, IL Sql Server Part-Time Wonder Lake, IL Python, C/C++, R, SQL, Pyspark, MySQL, Tableau, Power BI Chicago, IL |
|
Click here or scroll down to respond to this candidateCandidate's Name
Chicago, IL PHONE NUMBER AVAILABLE LINKEDIN LINK AVAILABLE EMAIL AVAILABLEDynamic Data professional with a proven track record in leveraging SQL, Power BI, and Python for Data Visualizations for comprehensive data analysis. Experienced in identifying key metrics, uncovering insights, and enabling data-driven decision-making.EDUCATIONM.S. Information Technology Management- AI & Data Analytics, GPA - 3.83 May 2024University of Wisconsin, MilwaukeeCoursework: Database Management Systems, Business Intelligence Technologies, Web Mining & AnalysisPROFESSIONAL EXPERIENCEData Analyst Intern at Jagemann Stamping Company Manitowoc, WI Oct 2023-Dec 2023Scripted queries in SQL for data processing from 2 million rows & reporting using MS Excel for informed decision making.Enhanced operational efficiency through Power BI dashboards, resulting in an 8% improvement in quarterly revenue.Developed ETL pipelines in SSIS, efficiently processing data using Databricks distributed environment leading to 6% less errors.Collaborated with cross-functional teams, reducing inventory stockpile by almost 6% through trend analysis using Python.Graduate Student Services Consultant at University of Wisconsin, Milwaukee May 2023-Sep 2023Discovered an increase of 4% intake by leveraging MS Excel formulae & VBA to analyze & automate dataset of 5000 records.Employed SQL queries for robust data analytics and provided ad-hoc query support for analytics of 5 different departments.Teamed up with administration to develop Power BI reports to facilitate actionable insights & recommendations.Utilized Normal Distribution Charts to analyze performance across domains to recommend actionable insights.Junior Data Scientist at Bytes Arena, India Jan 2022-Jan 2023Improved performance of datasets by indexing the schema in SQL, resulting in improved query execution & result retrieval time.Analyzed and cleaned data using Pandas and NumPy in Python, developing Power BI Dashboards for ROI visualizations.Spearheaded the Python programming team in predictive models, increasing 4% revenue through new opportunities.Designed and implemented SSIS ETL solutions to seamlessly integrate data from flat files and databases into data warehouses.Documented important findings, modifications & enhancements to abide quality assurance policies & procedures using GitHub.Data Analyst at Shivvijay Enterprises, India Oct 2019-Sep 2021Conducted a thorough requirements definition process based on customer requirements identifying key finance metrics.Capitalized on MS Excel formulae, nested logics & lookups for financial data reporting revealing a 6% increase in demand.Engineered continuous monitoring and reporting systems using Shell scripts combined with Python for complex data analysis.Examined user trends analysis through complex queries in SQL, revealing valuable seasonal business insights.Designed and developed Power BI Dashboards enabling dynamic KPI tracking for executive decisions of product launches.TECHNICAL SKILLSData Visualization Tools: Tableau, Power BI, Looker, SSRSProgramming Languages: SQL, PL/SQL, T-SQL, SAS, PythonDatabase Technologies: SSMS, PostgreSQL, MySQLMicrosoft Tools: MS Excel, MS Word, MS PowerPoint, VisioProject Management: Jira, ServiceNow, ConfluenceMethodologies: Agile, SDLC, WaterfallVersion Control: GIT, GitHubOther: ETL, Prompt Engineering, Machine Learning, AlteryxACADEMIC PROJECTSFinancial Fraud Detection using Machine Learning & Deep LearningDeveloped a comprehensive machine learning solution for identifying fraudulent transactions among European credit card holders using a PCA-transformed, highly imbalanced dataset which contained 492 frauds in 284,807 transactions.Implemented SMOTE for removing imbalance and optimized various models including Random Forest, Logistic Regression, and Artificial Neural Networks, achieving high precision and recall rates; notably, through Random Forest with an F1-score of 0.853 with nearly perfect accuracy, proving efficacy in handling the highly imbalanced dataset. Deployed the model on web.Azure Data Engineering ProjectConducted in-depth analysis on a dataset containing 11,000 rows of Tokyo Olympics data, employing Azure Data Factory to construct efficient ETL pipelines using Azure Databricks to populate Azure Data Lake Gen 2 storage containers.COVID-19 Power BI AnalysisConducted comprehensive analysis of global COVID-19 data using Power BI, identifying trends in infection rates, mortality rates, and vaccination coverage, while tracking KPIs such as daily new cases, mortality rate, and vaccine distribution efficiency; executed 15 DAX calculations and implemented 20 measures to deliver insightful findings.CERTIFICATIONSMicrosoft Certified: Azure Data Engineer AssociateComplete SQL Bootcamp using PostgreSQL by UdemyChatGPT Prompt Engineering by DeepLearning.AI & OpenAI |
