Sheshank Reddy Suravaram

Accomplished Data Engineer at Transport for NSW, skilled in SQL optimization and cross-functional collaboration. Successfully designed and implemented data pipelines, enhancing reporting efficiency by 73%. Proven ability to gather requirements and deliver actionable insights, driving continuous improvement in data management processes. Recognized for mentoring junior analysts and fostering a culture of analytical excellence.

• Commended by executives for simplifying BAU reports resulting in minimised time wastage whilst increasing efficiency.
• Nominated and awarded with the Silver and Bronze VMAX cards by regional sales team and manager respectively.
• Cut down time for month end reporting from 5 hours to 15 min by rolling out simplified reporting templates.
• Decreased time for generating forecasts by 50% with a 2% improvement in accuracy.
• Identified market leads that increased sales per magazine by circa 5% resulting in sales efficiencies growing by almost 4%.

• TRANSPORT FOR NSW (TfNSW), Reporting Analyst - Procurement Services, 05/01/15, Present, Recognised for analysing and proactively implementing templates for Purchasing team to streamline their activity., Instrumental as a business/reporting analyst in the development of templates to enhance reporting for Purchasing team., Built ETLs and processes for managing databases on SQL Server (Extract from Equip/ Transform / Load), where the information from tables are used across all the agencies reports., Designed and restructured daily Vendor Invoice reports (Open Invoice reports to senior executives and business)., Offer analytical support and the extraction of insights across spend, demand, the supply market and suppliers to assist in the management of the sourcing project pipeline., Provide strategic sourcing and procurement related administrative support for the Procurement Services function including preparation of reports, presentations and database maintenance., Assist with the development of strategies for specific markets and industries that impact the budget under management., Assist with the development of supplier market opportunities in the areas of spend, growth, cost drivers, business drivers, technology and other factors (e.g. environmental, legislative etc)., Assess the relevant position of preferred suppliers within the industry/market to inform comparative analysis, contract review and sourcing activities., Drive continuous improvement initiatives to accelerate the maturity of Procurement Services in the area of strategic sourcing and category management.
• TOYOTA FINANCE, Sales Analyst - Retail Finance & Insurance, 10/01/12, 12/01/14, Restructured Bonus payment templates to improve reporting efficiency, reducing reporting effort from 15 hours to 4 hours per analyst., Effectively facilitated the Rewards Program and served as an SME for improvements and maintenance of the system., Streamlined month-end reporting to meet deadline delivering before /on due date., Supported the regional sales analysts via training on systems, commissions and reporting as and when required., Requirements elicitation as per internal/external stakeholders., Ensured data integrity of reports/measurement tools that support Head Office and Regional Sales., Steered Dealer of the Year /Business Manager of the Year programs via results and criteria review management/ reporting., Supported budgeting and forecasting, including Yearly Budgets and the maintenance of the medium term plan sales model., Deployed complex SQL querying for data extraction and data transformations then carried out instantaneous analysis., Resolved data mismatch/change requiring incorporation to ESSBASE cubes and tested final output with the help of IT dept., Prepared ad-hoc reports and presentations for HO Dealer Sales Management and the Executives.
• SPECIAL BROADCASTING SERVICE (SBS), Sales Analyst, 06/01/12, 08/01/12, Created Dashboards that allow for ad-hoc reporting in Cognos., Modernized reporting templates and reduced time for generating weekly reports from 3 hours to 5 minutes., Gained experience creating dashboard reports using Cognos TM1., Liaised with Sales/Marketing managers and team members to provide relevant reporting., Compiled regular financial reports for management using Excel, Cognos TM1., Helped managers with the setting of quotas and budgets for Sales Reps / teams based on revenue., Performed value add for sales team via ad-hoc reporting as well as providing documentation for new processes., Performed data validation at all stages to ensure generated reports were accurate.
• MARKETSOFT, Data Analyst, 10/01/11, 03/01/12, Met all requirement deliverables on data services as demanded by clients., Performed third party data cleansing to enable ETL process and coded COBOL logic using the data received from clients., Carried out thorough Data Reconciliation to ensure data integrity in the database., Gained experience working with MS Access databases to design queries, link tables and data bases.
• GORDON AND GOTCH, Team Leader, 02/01/10, 10/01/11, Mentored team members on methodology of allocation strategies., Shortened end of month reporting from 3 days to 1 day per head by rolling out streamlined reporting templates., Pivotal in the improvement of company's forecasting methodology thereby achieving higher accuracy and effort savings.
• GORDON AND GOTCH, Retail Intelligence Analyst, 02/01/07, 01/01/10, Maintained 100% accuracy in forecasting against sales efficiencies resulting in promotion to team leader., Contributed 75% of gross revenue by effectively managing the Pacific Publications account alongside 4 team members., Recommended strategies that increased sales performance for publishers following a thorough sales data analysis.