PRASHANTH BALASUBRAMANIAN
Chennai
Summary
A highly organized and results-driven IT Project Manager with extensive 14 + years' experience in Data Engineering, Process Automation and Project Management with a proven ability to meet deadlines, manage budgets, and deliver high-quality solutions. Designing, developing, and optimizing data pipelines, ETL processes and automation Solutions.
Overview
14
14
years of professional experience
Work History
Automation Manager
Philips GBS LLP
Chennai
04.2024 - Current
- Developed detailed project plans outlining timelines, resources required, potential risks, and mitigation strategies for successful implementation of automated solutions.
- Conducted in-depth process analysis using mining tools, identifying bottlenecks and opportunities for automation, resulting in measurable improvements in process performance.
- Received GBS performance award for Automizing 2 critical Monthend Closure Business reports in a short span of time with annual savings of 2000 hours.
- Utilized low-code platforms to rapidly develop and deploy automated workflows, accelerating digital transformation initiatives.
- Applied Agile principles and practices to manage projects, fostering collaboration, iterative development, and rapid delivery of solutions.
- Thrives in collaborative environments, effectively communicating and partnering with cross-functional teams to achieve shared objectives.
- Experienced in in-person collaborative work environments.
- Demonstrated ability to adapt to changing priorities and deliver high-quality results in fast-paced environments.
- Provided training and mentorship to junior staff members, fostering a culture of continuous learning and professional growth.
ASSOCIATE MANAGER
Thryve Digital LLP
Chennai
01.2022 - 03.2024
- Led a team of 5 IT professionals in the successful completion of 8 complex projects
- Created and maintained complex data models, including data extraction, transformation and loading (ETL) processes ensuring data accuracy and reliability
- Design and develop data models, dashboards, and reports using Power BI and Oracle dashboards
- Analyze and extract data from various sources (Oracle cloud, Coupa system, etc.,) to provide actionable insights and recommendations
- Created a Helpdesk portal for Facilities team through Share point, MS Power Apps & Power Automate which saved 2 FTE and around $10,000 save throughout the year
- Train end-users on data analytics and process automation tools and best practices
- Develop and implement process automation solutions using Power Automate, Power Apps, and Python
- Collaborated with business stakeholders to define project objectives, scope, and deliverables
- Developed detailed project plans, including timelines, milestones, budgets, and resource allocation
- Managed project risks, identified potential issues, and developed contingency plans to mitigate them
- Facilitated regular project status meetings and provided regular updates to senior management
- Ensured project quality by conducting regular reviews, testing, and debugging
- Successfully completed all projects within budget and on schedule, resulting in improved business operations and customer satisfaction
RETAIL DATA ANALYTICS - SPECIALIST
Standard Chartered Business Services
Chennai
04.2020 - 01.2022
- Achieved USD 1.35M cost saving by converting the traditional method of data pulling from a thirdparty software to dynamic and structured stored procedures
- Actively participated in the implementation of new process/system which is being used for retrieving the data
- Controlled the regulatory risks and achieved error free reports from automation
- Used Microsoft SQL Server 2008 & studio 17 to develop procedures, maintain the data
- Provided active support on the new server migration and data management
- Automated processes through stored procedures utilizing to facilitate additional production capacity and not overburden the main data server
- Optimized stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements
- Investigated data issues, debugging and troubleshooting within SAS program code while maintaining data integrity and structured programming logic
DATA ANALYST
Standard Chartered Business Services
Chennai
06.2016 - 03.2020
- Handled large dataset report building using multiple workbooks, access tables and stored procedures
- Audited daily operation to ensure accurate performance of databases and procedures
- Used MS SQL scripts and dynamic queries for creating monthly, annual and other regular reports
- Assist with the monthly financial close process, including the preparation of a month end reporting package
- Used Microsoft SQL Server 2008 & studio 17 to develop procedures to maintain the data
- Involved in reviewing business requirements and analyzing the data sources from Excel, MIS DB and SQL server for production and supporting existing reports
ANALYST
Teamwork Info Solutions Pvt Ltd.
Chennai
06.2012 - 05.2016
- Supporting the Clients by preparing financial reports
- Accessed various reports like Balance Sheets, Sales reports, Purchase reports, etc
- Travelling to various locations in and across India to engage with multiple stakeholders across the company to ensure all processes and requirements were accurately defined
- Implementation of new report designs within the Business Operating Model
- Involved in training, oriented presentations
- Handling various activities of the project like information gathering, analyzing the information, documenting the functional or business requirements
- Provide customer support and assistance in issue troubleshooting and resolution
- Went onsite to Singapore in Jan 2015 for project implementations
SUPPLY CHAIN PLANNER/ BUYER
HCL B-Serve
Chennai
10.2010 - 05.2012
- Plan and execute procurement of finished goods and raw materials from global contract manufacturers and suppliers
- Maintain strong working relationships and communications directly with the Global Supply Center, global contract manufacturers and suppliers to confirm production/shipping schedules and monitor open purchase orders for all orders to ensure on-time deliveries
- Proactively report product and material availability issues
- Maintain purchase order status and shipment tracking information in SAP ERP system
Education
PMP -
Project Management Professional
04-2025
MASTERS IN BUSINESS ADMINISTRATION -
Anna University
01.2017
BACHELORS IN BANK MANAGEMENT -
Madras University
01.2010
Skills
- Database Design & Management
- Data Quality Assessment
- Data Analysis
- Pattern & Trend Identification
- Advanced Microsoft Excel Functions
- Power BI
- Oracle
- MS SQL
- Power Automate
- Power Apps
- Power Query
- Troubleshooting
- Data Mining
- Focus Groups
- Team Building
- Exceptional analytical and problem-solving skills
Personal Information
Gender: m
Timeline
Automation Manager
Philips GBS LLP
04.2024 - Current
ASSOCIATE MANAGER
Thryve Digital LLP
01.2022 - 03.2024
RETAIL DATA ANALYTICS - SPECIALIST
Standard Chartered Business Services
04.2020 - 01.2022
DATA ANALYST
Standard Chartered Business Services
06.2016 - 03.2020
ANALYST
Teamwork Info Solutions Pvt Ltd.
06.2012 - 05.2016
SUPPLY CHAIN PLANNER/ BUYER
HCL B-Serve
10.2010 - 05.2012
PMP -
Project Management Professional
MASTERS IN BUSINESS ADMINISTRATION -
Anna University
BACHELORS IN BANK MANAGEMENT -
Madras University