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
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
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
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
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.
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
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
Similar Profiles
Kishore SundaresanKishore Sundaresan
Senior Mechanical Design Engineer at Philips GBS LLPSenior Mechanical Design Engineer at Philips GBS LLP
Jude Inigo Rohit J SJude Inigo Rohit J S
HR Manager - People Partner at Philips GBS LLPHR Manager - People Partner at Philips GBS LLP
Pratiksha MohitePratiksha Mohite
Associate Engineer at Philips GBS LLPAssociate Engineer at Philips GBS LLP