| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
(Street Address )248-9601 EMAIL AVAILABLE https://LINKEDIN LINK AVAILABLESQL Developer with 3 years of experience in SQL, SSRS and Database Management. Expert in optimizing SQL queries and database performance, improving reporting efficiency by 40%. Proven ability to lead cross-functional agile teams and implement ETL processes to enhance data integration and drive business growth through innovative data solutions. EDUCATIONUNIVERSITY OF CONNECTICUT December 2024Master of Science in Business Analytics and Project Management, Concentration Data Science CGPA 3.9/4 RAJIV GANDHI PROUDYOGIKI VISHWAVIDYALAYA, INDIA June 2021 Bachelor of Technology, Computer Science & Engineering CGPA 8.1/10 PROFESSIONAL EXPERIENCESoftware Engineer, Yardi Software India Pvt Ltd July 2021 July 2023 Implemented ETL process using SSIS to transform and load data from different applications into client database. Analyze data issues reported by clients and construct 50 data fix packages using T-SQL ensuring accuracy and reliability. Developed and optimized 25 custom reports using SSRS as per client requirement, enhancing data retrieval efficiency by 40%. Created 15 stored procedures and triggers using SQL demonstrating strong analytical and problem-solving skills. Implemented controls and constraints on database transactions to maintain data quality and integrity using T-SQL in SSMS. Led global cross-functional agile team collaboration to resolve custom report-related issues, resulting in substantial increase in client satisfaction, demonstrating effective communication skills and teamwork. Data Science Intern, Adinath Poly Plast Pvt Ltd April 2021 June 2021 Conducted performance tuning of databases and SQL queries, including analyzing execution plans and optimizing indexing strategies, leading to a 25% increase in overall database performance. Identified critical sales KPIs for product lines, leveraging Excel and Python to transform data into actionable insights. Collaborated on developing Power BI dashboard to visually represent KPIs, enhancing Amazon sales strategy. ACADEMIC PROJECTS Property Management Database Development and Analysis (SQL, Lucid Charts, Data Modeling) Designed database schema and physical ER data model, created table structure, conducted EDA, provided actionable insights. Movie Rating Analysis on Amazon EMR (Hadoop, AWS, Spark, Hive, Pig) Engineered data pipelines on Amazon EMR, processing 49,590 movie ratings to identify top films and manage Hadoop tasks. Advertising Efficiency Analysis: Facebook vs. AdWords (Pandas, EDA, Hypothesis Testing, Regression Analysis) Conducted A/B testing and regression analysis on Facebook and AdWords campaigns, boosting conversions by 30% and reducing costs by 15% through optimized resource allocation. Health Insurance Premium Predictor (NumPy, Pandas, Seaborn, ML, Scikit-Learn, Flask) Developed a web app using advanced ML regression algorithms, achieving an R of 0.8527 with Gradient Boosting. LLM-Powered Natural Language to SQL Application (LangChain, Streamlit, Sqlite3, Gemini Pro, NLP) Developed an application with Gemini Pro, integrated with MySQL for tailored data analysis, enhancing user experience. Sentiment Analysis and Prediction on Amazon Product Reviews (Python, ML, NLP, Neural Networks, Clustering) Led sentiment analysis on 34,000 reviews, achieving 93.7% F1-score, and uncovering insights through topic modeling. Power BI dashboards (Power Query, DAX) HR analytics and Spotify Songs KPIs TECHNICAL SKILLS Programming Languages SQL, Python, R, C, C++, Java, SAS, DAX Database Skills PL/SQL, T-SQL, Pivot, Query Optimization, Indexing Strategies, Database Design, Normalization, Stored Procedures, Triggers, Views, Performance Tuning, Data Migration Databases & Cloud Technologies SQL Server, Oracle, MySQL, Maria DB, Snowflake, Microsoft Azure, AWS, GCP Data Analytics Pandas, NumPy, EDA, Data Cleaning, Data Visualization, Feature Engineering, PCA, Data Modeling Data Science Machine Learning, NLP, Deep Learning, Clustering, LLM, Time Series Forecasting, TensorFlow, PyTorch Data Engineering ETL, Hadoop, Pig, Hive, Spark, MapReduce, Data Warehousing, Data Pipelining, Redshift, Big Query Software & Tools Excel, Power BI, Tableau, Git, Visual Studio, SAS, MLFlow, Docker, Streamlit, Linux OS Project Management Skills Agile Methodologies, JIRA, MS Project, Scrum Practices Interpersonal, organization, problem solving, critical thinking, critical reasoning, creativity, time management, process improvement, full stack, compliance, collaborative, classification |
