Parikshit Koya | Business Intelligence Developer & Data Automation Specialist

Work Experience

Barclays

Role & Responsibilities

Business Partnering & Strategy: Collaborate with Financial Crime Operations to understand business needs, architect data-driven solutions, and support strategic initiatives including changes and migrations.
People & Financial Insights: Deliver leadership insights across People, Finance, and Productivity domains to drive informed decision-making.
Data Engineering & Warehousing: Design scalable storage solutions and build tactical ETL pipelines sourcing from systems like Workday/SAP, while working with Tech on strategic data feeds.
Analytics & Automation: Develop self-serve dashboards, reports, and data products while automating manual processes and inefficiencies using modern BI and scripting tools.
Innovation & Enablement: Enhance team development workflows through reusable tools, and explore advanced analytics/ML opportunities that add measurable business value.

Successes

ETL Framework: Designed a reusable ETL Framework using VS Code, Git, Gitlab and a custom ETL template to streamline data ingestion and processing.
Innovation: Participated in the Reimagined Hackathon where I built a prototype for a workflow solution for our Operations Quality Assurance team to automate their manual workflow using Django & Bootstrap5.
People Analytics & Reporting: Stood up People Analytics & Reporting within Fin Crime Ops & Client Onboarding giving critical insights into workforce trends and metrics.

Role & Responsibilities

Business Insights & MI: Partnered with operations to build automated, self-serve dashboards, reports, and data pipelines using Python, Tableau, and Alteryx.
Alteryx Enablement: Led Alteryx infrastructure, permissions, and data access setup as part of the team's strategic BI adoption; also migrated 30+ local Python scripts to Alteryx for centralized, scheduled execution.
API & Integration: Extended automation by integrating REST APIs into ETL workflows to improve efficiency and scalability.
Custom Solutions: Built a reusable Python module for seamless multi-database connectivity with aliasing; created detailed documentation and introduced new tools to improve team productivity in data workflows.

Successes

JIRA Reporting Automation: Fully automated JIRA reporting with a JIRA Dashboard in Tableau using JIRA REST API and Alteryx to provide critical visibility to team workload.
Training: Trained team members on Alteryx best practices and advanced features, enhancing overall team capability.

Role & Responsibilities

Self-Serve reporting: Built multiple self-serve reports/dashboards/automation across multiple Finance teams using SQL, Tableau and Alteryx
Process Redesign: Redesigned the reporting process for organisation wide headcount budget planning cycle using Excel VBA & Alteryx to reduce turnaround time.

Successes

Data Mining/Natural Language Processing: Used Named Entity Recognition (implemented via SpaCy) and regular expressions (implemented using Python & Alteryx) for mining data to analyse source of email volume received multiple teams within the department.
Reporting Automation: Automated multiple operational processes requiring manual reconciliation/reporting. Delivered saving of 2000 FTE hours.
Machine Learning: Delivered a machine learning proof of concept on how to calculate Time to Recruit for various roles using historical data using Python and visualised via Tableau.

DBS Bank

Role & Responsibilities

Forecasting: Forecasting call volume & handling times based on historical, current volume trend, business inputs & special events
Capacity Planning & Scheduling: Requirements calculation, Planning & Scheduling of staff to cater to the call volume
Reporting & MI: Delivered Daily, Monthly, Quarterly MI & Reporting to stakeholders on various operational metrics

Successes

Automation: Automated multiple tasks by building a variety of data entry, reporting & data processing tools using Excel VBA
Process Improvement: Optimised the staff scheduling model to align with the new organisation transport policy to counter rising attrition while sustaining service levels
Data Analysis: Performed comprehensive study of volume handling times to build a business case for the handling time target to be aligned with prevailing trends

EXL Service

Role & Responsibilities

Capacity Planning & Scheduling: Capacity Planning & Scheduling of staff to ensure all incoming volume is managed.
Telephony: Supporting internal projects as an in-house telephony expert.
Reporting & MI: Delivered Daily, Monthly, Quarterly MI & Reporting to stakeholders on various operational metrics.
KPI Management: Tracking of operational metrics & KPI to ensure they are within threshold.
Incident Management: Incident Management and escalation of real time issues to tech and stakeholders.

Successes

FTE Billing: Build multiple processes and reports to support transition of account's billing method from FTE based to billable hours.

Vodafone

Role & Responsibilities

Reporting & MI: Preparation and Reporting of Daily, Weekly and Monthly performance reporting for all LOBs and processes.
Automation: Designing and automating reports to reduce manual data input to the extent possible.
Scheduling: Analysing incoming work volume, manpower requirements and preparing rosters and schedules accordingly.
Real-time Monitoring: Keeping real-time track of progress for various LOBs and process and assisting the operations team with attainment of service levels.
Ad-hoc Analysis: Providing operations and management with ad-hoc data analysis and MIS as required.
Incident Management: Coordinating with IT and client support teams in the event of system downtime. Analyse and report business impact due to the same.