Anmol Agrawal

• Developed C-level dashboards in close collaboration with the business to effectively measure important business operations and make business choices in line with them. This involved working to fully comprehend executive KPI from a functional perspective.

• Analyzing user requirements and developing interactive and visually compelling dashboards to help the end users identify and infer trends that were difficult to discern using tabular data.

• Trained end-users on Tableau to promote self-service analytics and improve Tableau adoption. • Created and optimized data models and data extracts for efficient performance. • Worked on the development of data-driven alerts for the cross-team and integrated Slack with the report which minimized manual intervention, and routine checkups.

• Developed dashboards and data model for ticket management and Tracking using JIRA Web Connector.

• Developed many dashboards for business in wide range of business domains such as Supply Chain, Finance, Accounting, Marketing, Reconciliation

• Experience in troubleshooting and performance tuning of reports and resolving issues.

• As part of Tableau admin activities responsible for scheduling and monitoring refreshes, troubleshooting failure ,production deployments ,user authentications and managing site user and groups.

• Experience in writing SQL scripts for reporting, back-end data analysis, bug fixes, query optimizations, and ad-hoc data requests.

• Troubleshoot SSIS and IICS packages to perform RCA of the issues, Performance tuning existing scripts and processes, enhancements and bug-fixes of the new/existing mappings. Also, Developed and have experience on building pipeline/Flows in SSIS and IICS

• Proactively involved in requirement gathering calls with the client, requirement documentation, UAT calls, and cross-team coordination calls to fix, understand and resolve the issues quickly, and reduce the turnaround time of the deliverables.

• Mentored and groomed the new joiners to make them cognizant of the project workflow, and handled the project work single- handedly in case of unavailability.

• As part of the Innovation team developed a Standardized Tableau Design Catalogue and Visualization Standardization template which can save the FTE cost and can be used as a reference document across domains.

• Experience in AGILE methodology and used project management tools like JIRA.

• Part of the Visualization Community which is focused on providing SME support and cutting-edge solutions to multiple engagements.

• Hand-on experience on Tableau Desktop to build reports using all available functions
• Created Data Model or Data source using proper joins between the tables
• Utilizing capabilities of Tableau such as Data Extracts, Data Blending, Forecasting, Parameters, Dashboard actions and Table Calculations
• Customized the tool tips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue and expense as currency values
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integration
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom
• Involved in publishing dashboards and workbooks on Tableau server and scheduled those to refresh with Incremental load
• Handling change requests and providing support/maintenance for deployed projects.

• Supported and worked on enhancements related to eBOX application
• Regular client interaction, managing BAU, to provide answers on business raised incidents within the SLA, to deliver new given enhancements / bug-fixing on time
• Follow up with Service Managers, managing Openshift POD for containerization
• Performed root cause analysis and general troubleshooting.

• Prepared Interface (Incoming/Outgoing) sheet for all EMDW and ABSA Applications with details like: Application Name, Frequency, Name of files, Number of files, File Path, File transmission mechanism, Average arrival time, Source contacts
• Carried out performance tuning in order to save Man hours by converting single load to multi load for very critical banking application
• Modified script to prevent archiving and eventual discarding critical BAU files applications Decommission of multiple ABSA and ARO applications
• Prepared detailed report on all the databases and tables that are updated daily as requested by the Teradata DBA team
• Published numerous exchange rates reports - which is a month starting activity related to change in the currency values
• Performed Pre-prod testing for the changes in the source file numerous times which was leading the batches to fail, successfully so that it ensures smooth functioning and remove any manual intervention which might delay batch which was very critical as per business perspective.

• Worked in Marketing, Operations and Product management department
• Launched marketing campaigns which boosted the sales of the company notable level
• Set up the CRM for the company after going through intensive meetings with the potential vendors which gave better sales and marketing insights and helped in improving daily working
• Set up SAAS softwares for the company for better involvement with the customers which lead to more projects being given under my supervision
• Worked closely with the CEO to improve the SOP for the company
• Brought down CAC(Customer acquisition cost) from Rs 1000 to Rs 650 which ensured more marketing funds
• Created SOP booklet, Marketing booklet for the company which can be used in future by anyone for better understanding.