DEEPTHI NAGARAJ
Data Analyst
Jersey City,NJ
Summary
Highly motivated and skilled Data Science and Analytics professional with a passion for leveraging data and technology to drive strategic business decisions.
Overview
4
4
years of professional experience
2
2
Certificates
Work History
Data Analyst
Shoolin Inc
Jersey, New
08.2023 - Current
- Optimized database functionality, resulting in a 20% increase in system responsiveness and reliability
- Utilized statistical functions, trend lines, and forecasting in 80% of reports to provide actionable insights
- Improved data quality through outlier detection, handling missing values, and conducted thorough impact analysis for 95% of projects to ensure alignment with business goals
- Successfully developed and debugged 90% of BI applications, delivering high-quality solutions
- Ensured database integrity and availability through routine tasks with a 98% success rate.
Data Engineer
Sira Soft Solutions Inc
, CA
07.2023 - 08.2023
- Maintained data structures and pipelines with 99% accuracy and efficiency using SQL (SSIS, SSAS, SSRS)
- Improved data processing performance by 30% through efficient management and optimization techniques
- Enhanced security by implementing permission checks for data access control and identifying vulnerabilities through SQL injection detection in 95% of projects
- Created data pipelines using AWS EMR and Apache Airflow to extract, transform, and load (ETL) data from various sources into Redshift
- Improved query and process efficiency by 25% through performance analysis.
Database Developer
Buffalo
01.2023 - 05.2023
- Designed efficient printer management and database systems, saving $50,000 annually, achieving 30% faster data retrieval, and reducing data inconsistencies and improving data quality by 25%
- Collaborated with cross-functional teams, conducted rigorous testing, and provided data-driven insights to enhance operational efficiency by 20% and support continuous improvement efforts.
Data Science Intern
Tech Fortune Technologies
01.2021 - 12.2021
- Utilized pandas and NumPy for complex data transformations, feature engineering, and model evaluation in diabetes prediction
- Constructed a comprehensive tabular dataset of 10,000 patient records, performing data cleaning and manipulation, and achieved an 85% accuracy rate in predicting diabetes occurrence using advanced inferential statistical analysis techniques
- Introduced the concept of series and data frames for efficient data analysis and exploration.
Data Analyst
The Entire Group
07.2019 - 07.2020
- Achieved 99% data accuracy and integrity through rigorous data quality checks in a team
- Contributed to the creation of 50+ reports (graphs, charts, tables) and visualizations, aiding data-driven decision-making processes
- Collaborated with business analysts to address data-related issues and ensure alignment with data requirements and satisfy clients
- Successfully supported 5 data migration projects and ETL processes, ensuring smooth data transition and integration
- PROJECTS
- PWC, Power BI Virtual Experience Program, The Forage, Micro Intern
- Analyzed call center data using Power Query to identify KPIs, resulting in a 20% reduction in average call handling time and a 15% increase in first-call resolution rate, improving overall operational efficiency
- Developed analysis metrics using DAX to analyze & visualize customer data, performing categorical analysis between customer behavior & service consumption
- Quantium, Data Analytics Virtual Experience Program, The Forage, Micro Intern
- Cleaned and processed a product sales dataset of 2 million records using Python and Alteryx
- Used Matplotlib and Seaborn to analyze and visualize sales and customer trends, providing insights into revenue patterns, customer behavior, and retail operations which led to a 15% higher sales performance than control stores
- Accenture, Data Analytics & Visualization, The Forage, Micro Intern
- Refined 10 million public reaction data to 5 million relevant posts and exploring patterns in user engagement.by cleaning, mining and updating to analyze what types of posts should be restricted to maintain
- Implemented Data-driven recommendations to restrict 20% of promotional posts, prioritize user-generated content, & achieved a significant 25% increase in user engagement
- Real estate market analysis and visualization-Conducted a comprehensive analysis of the real estate market using Python, involving web data scraping and analysis techniques
- Evaluated key metrics such as price, location, square footage revealing a 15% increase in median home prices over the past year
- Hospital Price Transparency- led a team of 4 in implementing a price transparency initiative utilizing MySQL and data cleaning techniques to analyze hospital pricing data from CMS website, improving access to healthcare cost information for consumers
- Resulted in better decision-making and potential reduction of health costs
- Sales Performance Dashboard-Designed an interactive dashboard in Excel that automated data refresh processes, ensuring real-time insights by creating VBA macros for automatic pivot table updates & report exports
- This enhanced data accuracy & decision-making capabilities for the retail company, resulting in improved sales tracking and trend analysis.
Education
Master Of Science (MS) - Information, Data Science and Analytics
Buffalo, The State University of New York
New York, NYBachelor of Engineering (BE) - Computer Science Engineering
Visvesvaraya Technological University, New Horizon College of Engineering
Skills
TECHNICAL SKILLSProgramming LanguagesPython, SQL, HTML, JavaDatabase Management: MYSQL, PostgreSQL, SSISData Analytics and BI Tools: Tableau, Power Bi, Google Analytics, MS ExcelLibraries: Pandas, NumPy, Matplotlib, SeabornMethodologies: Agile, Scrum, Lean Six SigmaSoftware & Tools: Jupyter, Access, AWS (EMR, Airflow, Redshift), ETL, MATLAB, Alteryx, Hive, Spark, Databricks, Visual studio, VBA Macros, Pivot tables, Hadoop, data management, data modeling, data mining, data transformation, ad-hoc analysis, machine-learning algorithms, problem-solving skills
Data profiling
Data profiling
Certification
Certified scrum product owner
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Innovation distinguishes between a leader and a follower.
Steve Jobs
Timeline
Data Analyst
Shoolin Inc
08.2023 - Current
Data Engineer
Sira Soft Solutions Inc
07.2023 - 08.2023
Certified scrum product owner
04-2023
Database Developer
01.2023 - 05.2023
Connect to and transform data (Tableau)
10-2022
Data Science Intern
Tech Fortune Technologies
01.2021 - 12.2021
Data Analyst
The Entire Group
07.2019 - 07.2020
Master Of Science (MS) - Information, Data Science and Analytics
Buffalo, The State University of New York
Bachelor of Engineering (BE) - Computer Science Engineering
Visvesvaraya Technological University, New Horizon College of Engineering