On Time Solutions

Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure

Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

• 5 to 6 years and 2 to 3 Years in RPA  - Business analyst
• Analyse, understand, and review existing business process documentation to ensure the complete processes steps documented.
• Participate in various types of interviews, meetings, or workshops to define, design, and configure automation solutions.
• Support the creation and maintenance of solution documentation (process definition document, solution design document, user manual, process estimation etc).
• Help with the creation and documentation of test procedures and scenarios prior to launch User Acceptance Testing (UAT).
• Support business teams in testing activities, including integration testing, end-to-end (business process) testing and UAT.
• Problem-solve issues that arise in the day-to-day running of automation processes and provide timely responses and solutions as required.
• Manage end to end Project Lifecycle
• Act as a SPOC for customers, Project Teams, Leadership, and administration
• Run workshops with client SMEs to understand the end-to-end process
• Identify any automation blockers and the suitability of the process for automation
• Calculate automation % and FTE benefit and build effort estimates, No of BOT
• Present summary of findings to the client and walk them through to-be design of the automated process
• Work closely with development team to ensure requirements are accurately mapped and suitable for development
• Must be able to provide suggestions for the improvement of existing process and design to-be flows