| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data AnalystEMAIL AVAILABLE PHONE NUMBER AVAILABLE OH, USASUMMARYSkilled Data Analyst with 3+ years of experience in data modeling, warehousing, and analysis, adept in SDLC, Agile, data manipulation, and visualization (NumPy, Pandas, Matplotlib, Scikit-learn, ggplot2). Proficient in Tableau, Power BI, and Azure for managing cloud-based data solutions and performing ETL, ingestion, pipelines, cleaning, and wrangling tasks. Demonstrated expertise in SQL for complex query writing, data extraction, and database management. Experienced in delivering actionable insights through interactive dashboards and reports, driving strategic business decisions and enhancing operational efficiency. SKILLSMethodologies: SDLC, Agile, WaterfallProgramming Languages: SQL, Python, R, MATLABIDEs: Visual Studio Code, PyCharmPackages: NumPy, Pandas, Matplotlib, Seaborn, Scipy, ggplot2 ML Algorithm: Linear Regression, Logistic Regression, Decision Trees, Supervised Learning, Unsupervised Learning, Classification, SVM, Random Forests, Naive Bayes, KNN, K Means, CNN Visualization Tools: Tableau, Power BI, MS Excel, Alteryx Cloud Technologies: AWS, Azure, DatabricksDatabases: Oracle, MySQL, SQL Server, MongoDB, PostgreSQL Other Tools: Git, snowflake, power query, macro, SAS Operating System: Linux, Windows, MacEXPERIENCEPfizer, USA Data Analyst Jan 2024 - Present Streamlined and improved waiting time resulting in a 7% reduction in turnaround time by performing in-depth data analysis using SQL to identify bottlenecks and areas for improvement. Conceptualized Matplotlib, Seaborn, and ggplot2, considered and executed captivating visualizations that increased the impact and clarity of data presentations by 25%. Improved data efficiency by 20% through data automation using Python, reducing manual tasks Created Tableau visualizations, improving data accessibility by 20%. Integrated Tableau Lightning web component in Salesforce CRM to effectively view support requests reducing resolution time by 30% Optimized Teradata database performance, achieving a 20% reduction in query response times through indexing and partitioning. Transformed data using SQL, and Tableau Perp boosting data accuracy by 25% and ensuring consistency. Automated data comparison and extraction using Alteryx and complex SQL queries, enhancing reporting accuracy. Designed and developed ETL workflows and datasets in Alteryx, improving data preparation, cleaning, and blending. Directed extensive data analysis initiatives utilizing SQL queries and MS Excel, extracting actionable insights to address dynamic business needs and effectively support strategic decision-making processes. Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables. Developed engaging Tableau dashboards for easy data exploration, enabling stakeholders to make informed decisions. Applied Supervised Learning techniques such as Support Vector Machines (SVM), Random Forests, and Naive Bayes for classification tasks to categorize data into predefined classes. Uncovered and addressed data anomalies by executing thorough data validation tests in Azure Data Factory pipelines, ensuring analytical outputs maintained a 99.5% accuracy rate, thereby enhancing operational efficiency by 15%. Use of explain plan, analyze, hints to tune queries for better performance and also extensive Usage of Indexes Mindtree, India Data Analyst Jun 2019 - May 2022 Worked with stakeholders to analyze and document requirements using Waterfall, creating comprehensive project documentation. Operated data visualization libraries such as Matplotlib and Seaborn, which created visually compelling data visualizations, enhanced the communication of insights, and facilitated an understanding of complex datasets. Generated ad hoc reports in Excel and shared them with decision-makers for strategic planning. Also experienced in using MS SQL to generate ad hoc reports and extract data for BI dashboards. Designed and launched interactive Power BI dashboards and reports, enabling cross-departmental data-driven decision-making and increasing operational efficiency by 25% within the first quarter. Analyzed datasets using Power BI to identify trends and anomalies, providing actionable insights to the management team. Created custom automations using Python, TypeScript and MS Excel VBA which Increased automation efficiency by 25%, reducing errors and bottlenecks in critical processes. Developed Python scripts to parse files, load data into databases, extract weekly information, and clean raw data, ensuring data accuracy and consistency. Conducted data mining and analysis from company databases, uncovering valuable insights to drive optimization and improvement of product development, marketing techniques, and business strategies. Utilized AWS Redshift for data warehousing, establishing a high-performance environment for querying and analytics, enabling efficient business intelligence and data-driven decision-making processes. Operated Unsupervised Learning methods to identify patterns and relationships in data without labeled outcomes, including clustering with algorithms like KNN and K Means. Played a pivotal role in optimizing the database design, resulting in faster data retrieval and facilitating informed data migration decisions Employed Power Query to clean, transform, and merge data from multiple sources for analysis and reporting. Proficient in advance features of Oracle 9i for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nest and Dynamic SOL. Created and validated data models using Alteryx for effective data merging and analysis. Implemented and maintained data cleansing processes to enhance data integrity, proactively identifying and rectifying anomalies within datasets to ensure data accuracy and reliability for analysis purposes. Accomplished SQL data extraction, transformation, and analysis, resulting in 30% faster query execution. ACADEMIC PROJECTS Integrated Customer Retention Analysis and Prediction Project: Led a customer retention analysis project using MySQL and Python in Jupyter, integrating Python seamlessly with MySQL using MySQL connector. Utilized SQL for extracting insights, showcasing proficiency in MySQL. Employed R for retention analysis and prediction, applying logistic regression modeling and ROC curve analysis to evaluate model performance. This project provided actionable insights into customer behavior, aiding in strategic planning for retention efforts. Urban Rental Dynamics: Analyzing House Rent Trends and Preferences, This project focused on dissecting urban rental dynamics using a comprehensive dataset of house rentals. Through Python tools like Pandas, Plotly, and Seaborn, rental trends, dwelling sizes, and tenant preferences across various cities were explored. The project involved visualizing rental distributions and examining correlations between rent and amenities, offering valuable insights into urban housing dynamics that can inform rental market strategies. Inventory Optimization Project for Ikes Ice Cream: Led a capstone project aimed at optimizing Ikes Ice Cream inventory management. Utilized Excel Solver, statistical methods, Power Query, and regression analysis to create a forecasting model and optimization algorithm. Developed macros in VBA for automated forecasting and built a dashboard showing optimal order quantities, extended lookout periods, and forecasting insights. This project provided actionable insights for efficient decision-making, significantly improving inventory management processes, reducing costs, and enhancing operational efficiency. Sales Performance Analysis and Forecasting for Retail Chain: Conducted a comprehensive sales performance analysis and forecasting project for a retail chain. Employed Python and SQL to extract and analyze sales data, identifying key trends and patterns. Utilized time series analysis and machine learning algorithms to forecast future sales. Created interactive dashboards in Tableau to visualize sales performance and forecasts, enabling data-driven decision-making for inventory and marketing strategies. This project helped the retail chain in understanding sales dynamics and optimizing stock levels and promotional activities. EDUCATIONMasters in Business AnalyticsUniversity of Dayton, Dayton, Ohio May 2024Bachelors in Mechanical EngineeringKKR AND KSR Institute Of Technology And Sciences, (JNTUK), Guntur May 2019 CERTIFICATION Microsoft Power BI PL300 |
