Rohit Aakula

Experience

• 

  Amazon

  Nov 2018 - Feb 2023

  Managed team workload and deliverables by demonstrating organizational and project management skills which decreased project lifecycle SLA by 50%● Developed and deployed automation solutions using Alteryx, VBA Macros & Python for operation teams which saved more than 25 FTEs● Served as a primary technical point of contact to discuss new requirements and provide knowledge of development environments and processes Providing analytical network support to improve quality and standard work results● Ensured proper controls, governance and documentation is generated for each solution● Managed and customized all ETL processes as per customer requirement and analyzed all processes to track data lineage● Created ad-hoc and process related SQL queries for dashboarding and reporting● Optimized long running Stored Procedures and queries for effective data retrieval.● Visualized business metrics using data visualization tools like into Tableau & QuickSight● Experience in working on AWS tools like Glue, Lambda, Quicksight to leverage automation to avoid manual process in operations● Created Proof of Concepts to automate operational activities using AWS Tools and RPA by which provided intake of 75 FTE.● Single point of contact for escalation handling and ideation Show less • Working collaboratively with Internal and external stakeholders for smooth implementation of solution in production/operation• Aiding the team with troubleshooting, workflow and user management and support in warranty or in the event of problem• Created VBA Macros which resulted in reducing manual efforts (’000 hours) and resulted in FTE saving (~2.5 FTE).• Create automated excel templates for data collection and reporting• Catered ad-hoc reporting requests by the management as and when required• Collaborated with internal and external stake holders for requirement gathering and discussing on the ways to implement the solution with no revisits in production by understanding the need for confidentiality• Achieved 12+ JDIs by creating macro-based solutions and process change which has reduced manual work around the process. Show less

  • Business Intelligence Engineer

    Apr 2020 - Feb 2023

  • Process Analyst

    Nov 2018 - Apr 2020
• 

  EXL

  Feb 2023 - now

  Manager, Analytics and Automation