Stephen Prashanth Email & Phone Number

Dublin, Ie

Dublin City, County Dublin, Ireland

• Engaged with stakeholders across the ESB Group landscape to automate the data collection process for a dashboard that aided prioritisation of incoming work to spoke teams.• Communicated with senior stakeholders effectively to capture requirements and implement solutions for the problem statement.• Advised senior managers and solution architects on appropriate data strategy solutions for new 3rd Party Applications procured by the organisation.• Restricted user access to information at different level with efficient use of Row Level Security (RLS) to adhere to GDPR when dealing with sensitive information.• Manage Power BI workspaces with respect to release pipelines to migrate dashboards from Test environment to production environment.• Took the initiative to automate the process of collecting adhoc requests from the business and built a dashboard to analyse and decrease the requests through self-serve. • Used bookmarks and filters efficiently in order to make the dashboard more user friendly.• Mentored and trained new graduates within the team and external business stakeholders through various Data Culture Committee events.• Worked with complex SQL databases and received appreciation from the business stakeholders for the project.• Used NLP techniques to clean the email texts for the mailbox analysis such as tokenisation, lemmatisation, etc.• Embedded HTML custom visuals within Power BI using SGV images and CSS for navigation buttons animations.• Documented and Managed data transformation and modelling processes for the reports making it easier for the team to support the dashboard.• Built Budgeting and forecasting models for the payroll for FP & A team to aid in respective personnel area’s detailed cost analysis.• Created Technical/business requirement and support documentation.

County Dublin, Ireland

• Hosted the CAB meetings for all the critical changes attended by all the service delivery leads.• Set up power automate workflows to schedule up the CAB meetings on a weekly basis with different attendees each week.• Played an admin role for the Service Management tool during this term.• Automated the FSC using VBA that made the process of adding changes quicker and more precise while improving the stakeholder satisfaction by notifying them of unapproved changes.• Wrote a VBA code for ESB networks to ensure the gross amount in their finance plan templates are accurate all through the document.• Built a dashboard with MSM data and aided the process of optimising the options provided to the MSM user base to aid data collection.• Worked on SQL, Power BI, SAP BW on HANA for reporting purpose.• Utilised SSIS to create ETL package to Validate, Extract, Merging, Cleaning, Transform and Load data to Databases. • Used star and snowflake schema for database design as a part of the ETL process.

Chennai, Tamil Nadu, India

• Performed requirement and automation feasibility Analysis.• Developed automation frameworks using UFT and Selenium for some of the applications for clients.• Created an Excel Macro to ease the ELV process for the leads in the unit.• Built POC machine learning models taking banking service attributes to predict customer churning using Decision Tree and Logistic regression.• Calculated ROC curve and AUC measures for True Positive Rate vs False positive rate trade-offs. • Used SPSS to perform statistical analysis.

Master Of Science - Ms, Business Analytics, 1.1

Activities and Societies: Archery club,Gaming societyDeveloping my analytical skills and provide insights to business through various.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering, 7.75

Activities and Societies: Organised events in TECHNOSUMMIT which is a national level symposium conducted by the university