My goal is to develop my habilities and use excel (VBA) expertise to get the best strategic decisions and improving the efficiency related to the business. I'd like to make part of a team and enhance my Knowledge in areas like BI, administration and IT. Now a days I guess I'm able to contribute to a USA economy.
I worked at Shopmix2009 as an online sales person / business analyst . My activities were summarized as follows: When checking a customer's purchase order, a recovery order was issued. After this step, the client would advise us of the payment and then the credit conference was made. When checking that everything was correct was given the request at ERP software. If the customer was new, a new registration was made. From that moment the product was packed and shipped to the customer. At the same time, it followed up with the international suppliers. Another important part of the business was the strategic planning to add new products at the portfolio.
Then a direct mail was sent to each customer through email marketing in order to publicize and consolidate our products to consumers.
Finally, I used to check the list of materials and packaging that needed quotation.
I worked at Berkana Tecnologia em Segurança as a technical software analyst and importer. I made purchase order, I quoted product prices, costs and freight with freight agents. At the same time I was doing the DI (Import declaration) , LI (Import licence) and numerary conferences. All these costs were recorded in a spreadsheet and it was generated a report for graphical and numerical analysis.
I was responsible for keeping the documentation of the requests up to date in order to respond to the boarding situation.
At the arrival of the products I performed inventory control to know what could be sold at the time. Eventually I made visits to some clients in order to prospect the average amount of purchase in a certain period.
In addition, I attended international suppliers. All products needed the technical translation of the manuals to facilitate acceptance in the national market. I participated in two trade fairs specialized in the branch and made several trips inside the national territory for delivering equipments.
I worked at Telefônica S/A as a junior analyst. I created, updated and analyzed spreadsheets regarding the issuance of technical support (APT) to new large band subscribers and telephone line (RTB / STB). We worked on resolving complaints by subscribers through improved service in various call centers. Prioritization of care for recurring complaints. Creation of graphs, analysis with data taken from several SQL bases for decision making. Control and analysis relevant to the efficient routing of calls between call centers. With the data mentioned above I created weekly power point presentations to demonstrate to the managers. And finally I tested the calling system in order to report the problems to the managers