| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Buffalo, NY, Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLE LinkedIn GitHub EDUCATIONUniversity at Buffalo, Buffalo, NY Jan Street Address - May 2024 MS in Data Science GPA: 3.76/4.00EXPERIENCEAccenture IndiaData Analyst Sep 2020 - Dec 2022 Configured databases to enhance data structure and integrity. Conducted quality inspections and managed planning and control, ensuring high data integrity. Built 6 key reports and interactive dashboards and using Power BI, illustrating vital KPIs across diverse teams, resulting in a 20% increase in operational efficiency and a 15% rise in strategic alignment. Implemented stored procedures, triggers, and return-to-vendor processes for efficient data management. Developed SQL queries to map source to target tables using transformation rules and lookup tables, achieving a 99% efficiency rate in comparing business and production data, resulting in 10% reduction in server load. Streamlined 30+ data pipelines leveraging SQL Server Integration Services (SSIS) to enhance CI/CD data integration and ensure seamless flow between disparate systems, resulting in a 25% reduction in data processing time. Architected multi-dimensional cubes using SQL Server Analysis Services (SSAS) to enable robust data analysis and reporting capabilities, optimizing business intelligence solutions. Managed databases, conducted quality inspections, and ensured data integrity and accuracy for cross-reference and sourcing projects. Enhanced operations with complex SQL procedures, views and functions reduced query time by 15%. Achieved an 80% reduction in manual effort by automating master data maintenance and pipeline processes using snowflake, improving workflow efficiency with cross-functional teams and ensuring high-quality data validation. Authored and executed around 25 functional specification documents and user manuals, as well as around 75-unit test scripts and UAT test scripts. Conveyed insights and details regarding the impact of issues during post Go-live production support to stakeholders as a Subject Matter Expert (SME), facilitating informed decision-making and resolution strategies, resulting in a 35% reduction in resolution time. Identified data quality issues and concerns and supported data governance initiatives to maintain high data standards. Conducted ongoing analysis and reconciliation of business operations, practices, and data flows within and between various systems and applications as an SME. Pluto7 Business Solutions IndiaJunior Data Analyst Jan 2020 - Aug 2020 Prepared customer files for upload and managed the organization of data within Google Cloud Platform (GCP), ensuring accurate and efficient processing. Enhanced predictive accuracy by 30% through Python-driven data extraction from Data Marts, performing quantitative and qualitative analysis and applying advanced ML algorithms. Implemented Data Studio dashboards providing visual insights to support data-driven decision-making, resulting in a remarkable 65% user satisfaction. Maintained incident reduction project schedule through proactive communication and weekly check-ins within team members. Organized and prioritized cross-reference requests based on timelines provided by sales, meeting customer expectations and ensuring timely delivery of projects. TECHNICAL SKILLSSkills: SQL, Python, R, T-SQL, SAS, Postman APIs, A/B testing, Apache Spark, Kafka, Airflow Cloud: Azure (Data Factory, DataBricks, Synapse Analytics), AWS (EC2, Glue, S3, QuickSight) Tools: Power BI, Tableau, MS Excel (Pivot tables, VBA), Snowflake, MS Power Apps, Power Automate, Linux, Git Databases: Oracle SQL, PostgreSQL, MongoDB, MS SQL Server, MySQL, IBM Db2, S/4 HANA Competencies: Data Analysis, Root Cause Analysis, ETL, Statistical Analysis, SDLC, Agile, SAP QM Libraries: NumPy, Pandas, Matplotlib, Seaborn, Pytorch, Sklearn, Keras, NLTK ACADEMIC PROJECTSPatient Health Record Management (PostgreSQL PHP) Sep 2023 - Nov 2023 Collaborated on replacing manual methods with a centralized database system in healthcare data management. Conceptualized ERD for real-time patient data access, reducing lookup time by 70% through efficient indexing. Prioritized data normalization focusing on BCNF, achieving a 20% storage reduction and 30% improvement in retrieval time. designed a PHP Laravel website enhancing data accessibility by 25% and website performance by 40%. NYC Traffic Collision Analysis (Python Selenium Flask) Jul 2023 - Aug 2023 Spearheaded a project leveraging NYC Open Data and web-scraped weather information for comprehensive data wrangling, to ensure data quality. Developed a sophisticated classification system by leveraging advanced machine learning techniques and employing SMOTE to address imbalanced labels, resulting in an 84% accuracy rate. Engineered a classifier integrated into a user-friendly Flask web application for swift collision prevention measures. AWARDS AND CERTIFICATIONS Microsoft Certified Power BI Data Analyst Associate (PL-300) Winner Smart India Hackathon 2020 |
