Simarpreet

Project: United Parcel Service (USA)

· Developed a tool for UPS to schedule road tests and orientation programs for candidates, enabling its trends and visualizations in Power BI dashboards.

· Responsible for daily tracking and deploying Client facing visuals in Power BI.

· Created multiple dashboards for stakeholders in Excel and Power BI aiding them in driving business decisions.

· Developed an ETL Pipeline and reporting solutions from scratch using Python and SQL.

· Successfully converted

· Provided technical support for existing reports and automated multiple manual procedures with Python and SQL and shell scripting.

· Designed and implemented RESTFUL APIs for data retrieval.

· Predictive Models: Developed Inferential Analysis and ML models (Logistical regression) to predict factors affecting No Show Rate of workers.

· Strategic Analysis: Segmentation and descriptive analysis to Target (Most to Gain Locations) and further target candidates at certain stages to gain maximum optimized hiring and achieve KPI targets.

· Operational Reporting: Preparing Ad hoc operational reports reactive to business requirements such as Peak Season specific demands through SQL queries on large datasets.

· Drafted documents that outlined processes, procedures, and best practices related to projects analytical outcomes.

Project: Telecom Domain: Vodafone Netherlands, UK and Vodafone Group (Sales, Portal, Mediation, Wholesale Billing, OMS, CRM)

· Development and Maintenance of Mediation and Rating systems for Vodafone UK Wholesale Billing Applications, responsible for processing telecom records eligible for rating/pricing.

· Worked with team in development of Vodafone Netherlands Ecommerce Website.

· Worked on development of OMS and CRM systems.

· Built interactive dashboards in Kibana (ELK), Grafana and Power BI(Monitoring).

· Setup alerting rules and thresholds in Grafana’s Alerting and Monitoring features by gathering data from multiple sources.

· Deploy Elasticsearch on various environments including cloud platforms such as AWS.

· Automation of monotonous tasks, deployments, ticket closures and testing procedures using Python, SQL, Selenium, Ginger and Jenkins.

• Optimized code for performance and scalability in Python, reducing page load time and supporting quick completion of system drains.

· Analyzing traffic volumes based on several criterions such as origin, frequency of records.

· Analyzing records failed or dropped during filtering of systems, observing trends, investigating issues and providing fixes in Wholesale Billing and Mediation for Vodafone UK.

· Handled Amdocs OMS and CRM applications, their production issues, defects, code fixes, maintenance and deployments.

· Managed applications such as UBUY, AXI, portals responsible for Vodafone's sales and stock management systems and their flows via Grafana, Kibana and MS Biztalk.

· Responsible for developing, scheduling and monitoring Maestro system jobs for multiple applications.

· Multiple Onsite visits for training/takeover of new projects.

· Developed and implemented strategies for successful customer service experience.

· Researched and resolved complex application problems in a timely manner.

· Debug, fix, test and deployed code for preventing potential application issues.

· Completed root cause analysis on routine and complex problems and provided permanent code fixes.

· Monitored system performance metrics to identify areas of improvement or potential problems.

· Prepared comprehensive documentation regarding procedures, processes, best practices.

· Participated in design reviews for upcoming products and features as well as end-user testing.

· Tested new versions of software applications prior to their release into production environment.

· Conducted routine maintenance on servers and systems, keeping networks fully operational during peak periods.

· Maintained positive working relationship with fellow staff and management.

· Communicating with multiple teams responsible for upstream or downstream applications.