- Sr. Data Analyst at Auto Ever America, specializing in Ticket Vending Machine (TVM) performance analysis.- Reduced downtime and maintenance costs by 20% through in-depth data analysis using Tableau, Excel, and Python.- Recognized for successful live product launches and stabilizing defect-ridden products, earning client appreciation.- Expertise in data visualization with Tableau, including pie charts, bar plots, and contextual filters.- Proficient in SQL for data manipulation… Show more - Sr. Data Analyst at Auto Ever America, specializing in Ticket Vending Machine (TVM) performance analysis.- Reduced downtime and maintenance costs by 20% through in-depth data analysis using Tableau, Excel, and Python.- Recognized for successful live product launches and stabilizing defect-ridden products, earning client appreciation.- Expertise in data visualization with Tableau, including pie charts, bar plots, and contextual filters.- Proficient in SQL for data manipulation and preparation, as well as creating advanced queries and stored procedures.- Experienced in Agile project management, including sprint planning and JIRA issue tracking.- Skilled in AWS cloud implementation, including S3 bucket management and SAAS product deployment.- Strong communicator, providing production support, training, and documentation for customers and internal teams.- Conducted risk analysis for product migration and performed regression and user acceptance testing. Show less

- Data Science Project Proof of Concept successfully converted to mainstream project for E-commerce retailer.- Customer segmentation using RFM model in R, categorizing customers into 10 categories.- Product demand and Returns forecasting with MAPE less than 15% using Time-series and machine learning models.- Recommender system and Market basket analysis using Association rule mining in Python.- Integration of modules into web application using RShiny.- Proposal document for… Show more - Data Science Project Proof of Concept successfully converted to mainstream project for E-commerce retailer.- Customer segmentation using RFM model in R, categorizing customers into 10 categories.- Product demand and Returns forecasting with MAPE less than 15% using Time-series and machine learning models.- Recommender system and Market basket analysis using Association rule mining in Python.- Integration of modules into web application using RShiny.- Proposal document for data science project for leading Global FMCG client.- Capacity analysis of Intrusion detection system, predicting CPU usage with 95% confidence bounds.- Data visualizations including scatter plots, count plots, and heatmaps using Python packages.- Feature engineering, regression analysis, and model performance tuning using Python.- Development of Seller and Customer snapshot, Custom maps, and outlier identification in Tableau.- GAP analysis and KPI metrics measurement for project evaluation.- SWOT analysis for business strategy development.- Logistics performance analysis and KPI-metrics model implementation.- Creation of performance and KPI reports in Tableau.- Conducting data analysis, cleaning, wrangling, and building ML models in R and Python.- Use of Microsoft Visio for designing SDLC process diagrams and conducting design and technical reviews. Show less

- Collaborated with data scientists on feature engineering, model training, and deployment documentation.- Assisted in data analysis, identifying datasets, source data, metadata, and data formats.- Documented transformation rules for ETL data migration from OLTP to Warehouse Environment.- Conducted data testing, including ETL mappings, stored procedures, and XML messages.- Created use cases, activity reports, and logical components using Rational Rose, UML, and Microsoft… Show more - Collaborated with data scientists on feature engineering, model training, and deployment documentation.- Assisted in data analysis, identifying datasets, source data, metadata, and data formats.- Documented transformation rules for ETL data migration from OLTP to Warehouse Environment.- Conducted data testing, including ETL mappings, stored procedures, and XML messages.- Created use cases, activity reports, and logical components using Rational Rose, UML, and Microsoft Visio.- Developed SSIS, SSRS, and SSAS solutions for various business units.- Wrote test cases and scripts using SQL and PL/SQL for UAT.- Designed T-SQL queries, role-playing dimensions, fact-less Fact, snowflake, and star schemas.- Conducted Decision Tree Analysis and Random Forests for strategic planning and forecasting.- Analyzed data and created mapping documents for source to target transformation rules.- Utilized SQL, T-SQL, and PL/SQL for stored procedures, functions, packages, and triggers.- Prepared data reports weekly, biweekly, and monthly using MS Excel, SQL, and Unix. Show less

• Translated business requirements into technical specifications, new features, and enhancements.• Conducted data analysis and reporting using MS PowerPoint, MS Access, and SQL.• Generated periodic reports using SQL Server Reporting Services.• Utilized advanced Excel functions including pivot tables and VLOOKUP.• Managed CSV files for MySQL database input.• Developed MySQL functions, triggers, views, and stored procedures.• Executed database testing with complex SQL… Show more • Translated business requirements into technical specifications, new features, and enhancements.• Conducted data analysis and reporting using MS PowerPoint, MS Access, and SQL.• Generated periodic reports using SQL Server Reporting Services.• Utilized advanced Excel functions including pivot tables and VLOOKUP.• Managed CSV files for MySQL database input.• Developed MySQL functions, triggers, views, and stored procedures.• Executed database testing with complex SQL queries.• Conducted data profiling and validation for accuracy.• Created SQL scripts for database objects.• Compiled data from public and private databases for analysis.• Maintained MS SQL Server database for data extraction.• Interacted with clients to document reporting needs.• Utilized SAS for data preprocessing, analysis, and reporting.• Developed data mapping documentation for transformation processes.• Followed Waterfall methodology for software development.• Contributed to all phases of data mining, cleaning, modeling, and visualization.• Designed and implemented statistical and predictive models.• Conducted extensive data cleansing and analysis in Excel.• Created and modified pivot tables and charts.• Developed SQL queries for fetching complex data from remote databases. Show less

- Improved customer retention by 40% through effective coordination with commercial team and clients, and rapport-building with suppliers, resulting in a 30% reduction in overall prices.- Led process improvements reducing delivery time for clients from suppliers, collaborating with stakeholders and negotiating with freight forwarders.- Advocated for and facilitated successful implementation of a new ERP system by coordinating with multiple teams.- Achieved a 20% increase in sales by… Show more - Improved customer retention by 40% through effective coordination with commercial team and clients, and rapport-building with suppliers, resulting in a 30% reduction in overall prices.- Led process improvements reducing delivery time for clients from suppliers, collaborating with stakeholders and negotiating with freight forwarders.- Advocated for and facilitated successful implementation of a new ERP system by coordinating with multiple teams.- Achieved a 20% increase in sales by optimizing trade show materials and targeting niche customer segments.- Identified key performance indicators (KPIs) for purchase reports, resulting in a 5% reduction in last-minute ordering costs.- Produced reports on accounts, purchase, and supply to pinpoint issues and enhance operational efficiency.- Utilized advanced table calculations to calculate year-over-year sales variances.- Developed Seller and Customer snapshots to analyze active and inactive customers across product categories.- Designed and implemented analytical reports and dashboards to aid senior management in identifying critical KPIs.- Conducted spare parts forecasting to optimize inventory management. Show less