Nagendra Kumar Singh Email and Phone Number

• Project Development – Part of PMO team to help develop new and maintain existing tools. Follow guidelines from businesses to accommodate evolving requirements during the project. • Data Analysis for Fund Administration and Reporting Teams, Automation of data cleansing process on Alteryx or MS Access extracting data from different warehouses like AWS and snowflake.• Assist different teams with automations and tools to help in day to day functions including Fund Administration, NAV, Taxation and Expense management. • Manage a variety of EUC projects, either working alone or with a junior staff member assigned.• Meet with clients and use Business and Technical knowledge to determine the best course of action to complete a project’s SRA.• Analyze requirements with the business team, work with the teams to identify issues and provide possible solution in the current environment limitations. Provide project guidance to junior staff assigned to the project.

Reporting and analytics, data collation, Cleansing, Data management and data preparation for final reports, Scorecards, preparation of dashboards and slides for Business Excellence (Transitions, Quality and Training) and conduct technical trainings.• Worked along with Quality and Continuous Improvement team on automation and process simplification opportunities identified from selected Ideas logged by the employees. • Creation of excel based macro for consolidating and generating monthly dashboards from different vendors across locations, helped reduce 70% of processing time of vendor management team.• Developed an MS excel based tool for prioritizing and sending automated emails to SPOCs for pending invoices

Reporting, data cleansing, data preparation for final reports, coordinate with clients and generate scheduled and ad-hoc reports, data extraction from Oracle database (SQL), Analyze and highlight data-gaps existing in the learning management database. • Appreciated by Process Manager, the USA for Quick business understanding of the process and achieve production in 7 days of joining the organisation.• ‘Recognition Award’ from Onsite Process Manager- for High Impact process improvements for 3 process reports – reducing 95% of report processing time and help eliminate manual intervenes which helped increase accuracy of process reports.• ‘Recognition Award’ for developing excel based tool to assist in recognising newly certified professionals and preparing list for reference. This tool was also helpful in a time saving of 35 hour for every instance the tool was used.

Data analysis, Data cleansing, Assist in preparation of final reports including sales and forecasts figures, Quarterly, Half yearly and Yearly dashboards, Lead management and data preparation for marketing database update. • Successful Transition of activities related reporting and database management activities during the onsite visit to client Location situated at Bedford, The United States of America. • ‘Platinum Award for Innovation’ for being Instrumental in developing and implementing an MS Access solution which simplified the Quarterly recurring process of data matching and tagging, from 90 days to 10 days. • ‘Special Recognition Award’ for Excel based tool to generate reports and charts from intranet based Login tracker tool.• ‘Pragathi Award for Innovation’ for creation and implementation of several VBA based tools helping in improving data accuracy and reducing time consumption.

Data Analysis, Spend analysis, data collation, cleansing, data tagging and Assist in preparation of final report, Preparation of daily and weekly reports, data management. • ‘Best Employee’ for contributing towards various process improvement initiatives using automation and quality tools.• Worked on creation and deployment of excel based work scheduling software using VBA across 9 countries to help a $500MM provider of employee services streamline processes in its HR Shared service centres resulting in Business Impact of $76,000. This tool won a “Gain share” of $ 19,000. • Gained detailed understanding of the Spend Analytics process and design and implementation several solutions in MS Access to automate the process and analyse the results in Excel, helped the stakeholder reduce the cycle time of analysing spend by ~80% in 2008 as compared to 2007.• ‘Boundary-less Player’ for Creation of MS Access based “Search Tool”, helped in grouping and allocating invoices to agents and boosted the efficiency of the agents and operations by 140%.• Worked on Payroll Kaizen digitization project using VBA in excel which resulted in a Business Impact of $21,000 per annum. Appreciated for executing several Lean projects across different processes which helped in improving efficiency & accuracy and resulted in a saving of $13,000 p.a.