Team Lead - Pricing Services
• Managed a team of 16 analyst for pricing stuff.• Promoted from Pricing Analyst to Team Lead Pricing Services in Sep 2018.• Collecting, collating and carrying out complex data analysis in support of management and customer requests.• Working on NVision Global’s (A giant in FBAP domain) project.• Manipulating, cleaning & processing data using Excel and SQL.• Responsible for loading, extracting and validation of client data.• Identify, analyze and interpret trends or patterns in complex data sets.• Used advanced excel functions to generate dashboards and pivot tables and charts. • Extracted compiled and tracked data and analyzed data to generate report. • Writing SQL scripts to manipulate data for data loads and extracts.• Experience in working with relational database and SQL Server.• Acquire data from primary or secondary data sources and maintain databases systems.• Arranged analysis reports and be accountable to answer any queries or complaints • Data extraction using various financial tools like MS Excel and MS Access and SQL queries.• Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trends analysis to the department.• Maintain excellent relationships with customers and carriers, providing timely and concise information of reports.• Work with people across the global including APAC and EMEA regions on day to day basis.• Submit daily report to global audit manager.
