Analysis of policy certifications in an insurance company in the United States

Support to the national sales management in the development and maintenance of the company's commercial P&G through Excel csv tables, requesting gross sales, the percentage of discounts, credit notes, production costs and dispensers from the different areas, freight, payroll expenses of sellers, kam, advisors and merchandisers in order to know the profitability of each client. ● Consolidation of contracts with clients

Creation and update of a report to visualize the daily variation of deposits and placements of the bank through a Query and a macro, this report was so well received that I was in the process of training the government segment for its implementation in all regions of Colombia, since previously it was carried out manually and inaccurately and it began to be carried out automatically and accurately. ● Creation of patron orders