Sr Centricity Support Analyst
Cemex Top Mix
مجموع سنوات الخبرة :15 years, 8 أشهر
• Interact with sales head, operation team, customer care team, stakeholder and CEO with their business requirements, meeting to understand needs and provide them end to end BI Solutions.
• Create detailed business analysis, outlining problems, identifying gaps in existing functionality, opportunities, and solution recommendations.
• Developed 360 customer view analysis dashboard in Power BI with data flow & integration with Azure Cloud.
• Develop ML and AI model with python and Azure SDK, Tesseract library, Google Collab, Flask API, and deployment on Heroku.
• Develop, Customize and Optimize Power Apps application using Model driven, Canvas, CDS, SQL, Forms, share point online, 365 CRM .
• Generated Dashboard using DAX, reports, and integration with power Apps.
• Statical analysis using R programming and shiny app with azure cloud data flow.
• Developed Concrete Strength prediction Model using Auto Kera’s ML and Deep Learning with Agile methodology.
• Developed Power Apps Trip management using business workflow, Al chat bots for
business users and taking decision.
• Creation and Maintaining data pipeline of high volume, scheduling, and monitoring with
Azure data factory ETL\ELT workflow at scale.
• Design of Call Center Dashboard for SLA, Metrics measurement using Tableau.
• Data Warehouse development and automate ETL Process with SSIS, generate report with SSRS and analyze data with SSAS the help of SQL Server Database which reduced 28% workloads.
• Conduct statistical analysis of content and consumer web, demographic, behavioral, and transactional data in support of strategic initiatives, from large datasets (both structured and unstructured) and Churn Analysis.
• Developed Customer Revenue Prediction Application using Django framework, deep learning with one hundred epochs and deployed on Heroku.
• Find out the top ten customers by expenditure, top ten most buying brands, and monthly sales from data stored in HBase which is in Key value pair.
• Sqoop to export data into HDFS & Hive.
• Worked closely with a team of data engineers and BI analysts to improve the efficiency customer recommendation analytics engine by 33% using predictive model with SAS, PROC SQL and SAS Macro.
• Worked on a Hadoop Cluster with a current size of 56 Nodes and 896 Terabytes capacity.
• Imported data using Sqoop into Hive and HBase from existing SQL Server.
• Risk Assessment and Fraud Detection-Find the reason for taking loans and display the average risk score based on the load department data using HDFS, Map Reduce, PIG, Hive and Sqoop.
• Visual Analysis of Customer spending pattern and Feedback analysis for offering new products for cross selling application using Pyspark and Spark SQL.
• Processing 4G usage data of a Telecom Operator to find out potential customers for various promotional offers cleaning data, ETL and Aggregation Exploring data set using known tools like Linux commands to understand the nature of data & Kafka msg system
• Creating 360-degree view (past, present, and future) of the customer for a retail company avoiding repetition or re-keying of information, to view customer history, establishing context and initiating desired actions.
• Managing the data using S3, DynamoDB, kinesis stream analytics, Quick site analysis
and AWS data pipeline CI\CD flow.
• Face recognition using symmetrical property of frontal face images and Open CV2.
• Developed Chat Bot Application using NLTK & Voice assistant Bot using pyttsx3 which managed speech recognition.
• Implemented Language translator app using Stream lit and IBM Watson & BERT NLP.
• Oracle Data Warehouse design and dashboard & reporting using OBIEE.
• ETL\ELT using and Data base design using Oracle data Integrator.
• Data cleaning, validation, processing, and model building using ML like CART, K means Clustering and OLS Regression, Linear &Logistic Regression analysis, Decisions trees, Time Series Analysis, Artificial Neural Networks, K-Nearest Neighbors, Random Forests Algorithm, Basket Analysis.
• To teach and create Learning environment for students.
MBA
B-Tech in Computer Science