Francis D Email & Phone Number

Bangalore Urban, Karnataka, India

• Proficient in all phases of Software Development Life Cycle (SDLC) along with Project Estimation, Planning & Execution.• Created end to end automation solutions for clients as per requirement which involves Feasibility Study, Designing Architecture, Development, Testing and Deployment of automation by using UiPath, VBA & VB Script.• Configured new RPA processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand• Hands on experience in UiPath (Web Automation, PDF Automation, Desktop Automation, Outlook, Orchestrator, Queue, RE-Framework) and basic knowledge of SQL database.• Maintained constant coding standard practices, high-quality normalization techniques with reusable components and technical responsibility for project delivery.• Worked on Orchestrator Queues to manage Bot workloads (Dispatcher & Performer Bots).• Hands on Experience in creating PDD (Process Definition Document) and developed respective SDD (Solution Design Documents).• Participated and delivered special projects/assignments on process improvements initiatives.• Responsible for developing a sustainable & robust model for Robotic Programs.• Managed a team of developers in an Agile environment by providing adequate training, guidance on best practices using development techniques and implement the changes in a positive way.• Complete post implementation project reviews detailing and measuring the key benefits delivered.• Optimized managements manual operations and allowing them to focus on business development.• Liaison with individual project team to gather project status, establish dashboard to track project progress.• Designing insightful reporting for business process improvement and benefit realization.• Participated in tech calls/meetings to demonstrate the capabilities of RPA for on-going projects and worked on interdependencies.

India

Bangalore Urban, Karnataka, India

• Expertise in designing & creating various Managerial Reports across all the Towers using Advanced Excel VBA Macros, Access, DBMS & SAP tools for data extraction & analysis.• Certified Six Sigma Green Belt and Project based on AP Live Allocation & Reducing Number of Efforts by using Advanced VBA • Macros which interface with User form and Database (Actual data and graphic representation of the results are viewable in Real Time through the provided Link & Mobile).• Automated Scorecard Analysis Metrics by using Advanced Macro Techniques.• Created Dynamic VBA Macro Tool, which extracts data from closed workbook without opening the file and performs all the Daily & Monthly Reports.• Designed Macro for AR Unapplied & Unallocated Report, Customer Clearing Report and BP Open Reports which are performed on weekly basis.• Performing RCA & CAPA Analysis for all the Critical Reports and providing Service Insights.• Presentation and Dashboards as per business requirements in co-ordination with Tower Heads for review presentations to the Clients.• Supervising, development and forecasting of all P2P and O2C operation reports based on historical data or as per business requirements.• Rebuilt and improved all legacy reports on new reporting platform using SAP BO.• Prepared strategic trend reports to measure KPI and increased leadership focus on Key Performance Indicators (KPI’s).• Successfully took the transition projects of Additional Process Metrics from CBS team and stabilized the KPI process.Strong analytical, problem solving & programming skills, cohesive team worker with exceptional Planning & execution skills.• Proven track records of meeting Service Level Agreements (SLAs) across the Towers & delivering results accordingly. (AP, AR, GA, MDM & Intercompany)• Responsible for publishing the process CPI's, KPI’s and GPI's to clients on monthly basis.

Bangalore Urban, Karnataka, India

Expertise in designing & creating various Managerial Reports across all the Towers using Advanced Excel VBA Macros, Access, DBMS & SAP tools for data extraction & analysis.Certified Six Sigma Green Belt and Project based on AP Live Allocation & Reducing Number of Efforts by using Advanced VBA Macros which interface with User form and Database (Actual data and graphic representation of the results are viewable in Real Time through the provided Link & Mobile).Automated Scorecard Analysis Metrics by using Advanced Macro Techniques.Created Dynamic VBA Macro Tool, which extracts data from closed workbook without opening the file and performs all the Daily & Monthly Reports.Designed Macro for AR Unapplied & Unallocated Report, Customer Clearing Report and BP Open Reports which are performed on weekly basis.Performing RCA & CAPA Analysis for all the Critical Reports and providing Service Insights.Presentation and Dashboards as per business requirements in co-ordination with Tower Heads for review presentations to the Clients.Supervising, development and forecasting of all P2P and O2C operation reports based on historical data or as per business requirements.Rebuilt and improved all legacy reports on new reporting platform using SAP BO.Prepared strategic trend reports to measure KPI and increased leadership focus on Key Performance Indicators (KPI’s).Successfully took the transition projects of Additional Process Metrics from CBS team and stabilized the KPI process.Strong analytical, problem solving & programming skills, cohesive team worker with exceptional Planning & execution skills.Identifying the process improvements for VBA automation purpose by conducting brain storming session with operation team.Proven track records of meeting Service Level Agreements (SLAs) across the Towers & delivering results accordingly. (AP, AR, GA, MDM & Intercompany)Responsible for publishing the process CPI's, KPI’s and GPI's to clients on monthly basis.