Shashikant Tokalwad

Developed tool to take Sign Offs from stakeholders integrated with SharePoint and Excel Macro to get sign-offs. Developed Automation for multiple decks and forums to reduce manual efforts and save significant amount of time to prepare deck every month. Developed tool for Model Monitoring team that generates summary data for eighteen processes. Developed Macros for Daily, Weekly, and Monthly reports and upload to Report Publisher. Developed tool for IRB which saves huge amount of time as well as manual process of data, reducing operational risk. Gather requirements for reports from different stakeholders and create new SQL queries according to given requirement. Creating documentation and release notes for all Sprint releases. Create, Debug and Maintain SQL queries, resolve runtime issues. Developed multiple VBA applications that help verify and reduce Operational Risk. Investigate, report issues and provide solutions on Business Process. Analyse business requirements to develop functional and non-functional system requirements.

Generate Shareholder Id report PP Presentation using macro. Developed time sheet application for the entire process. Develop and debug existing macros for smooth business running. Analyse business requirements to develop functional procedures. Work on ad-hoc macro requests to provide solutions ASAP. Analyse complex data to develop automated reporting with VBA.

Developed data migration tool that will migrate 2000 payroll clients from one platform to another over the span of 3 years. Developed automated leave planner for entire process, previously done manually on a daily basis. Developed allocation macro that helps leaders to allocate work to associates in critical times. Developed macro to generate status report and saves 50 minutes each day and other macro which saves one day every month. Developed automated IBSC email macro saving 5-6 hours per month. Developed multiple small VBA applications that help verify and compare data as well as reduce human efforts.

User Administration-Manage user access through ADAPT. Enterprise Portfolio and Resource Management using Planview. Expert in drafting the business stories and technical stories in Rally. Model, Analyse, Optimize, and Automate Business Processes. Perform UAT test in FIT, FX Environment and submit sign off. Create new workflows with respect to the requirement.