Marcio Macedo Email & Phone Number

Atlanta, Georgia, Us

█ Technology: VS 2015 C#; Oracle 11G, SQL 2012, WCF, Entity Framework , MVC., Windows Services; XML/XSLT; ASP; HTML, ADO.NET; PL/SQL█ Patterns: Repository; Unit of Work; Strategy█ Methodology: METHOD/1; AGILE; SCRUM█ International Financial Department - From: 01/01/2015■ Implementing SOA WCF Services middle-ware applications to interact with Accounting third-party solution. ■ Allow countries to: ■control payments and cash flow; ■upload transactions files to be validated and balanced;■prepare Profile & Loss and Balance Sheet■Generated scripts to move data from Oracle to SQL (Microsoft SQL Server Migration Assistant for Oracle Command Prompt)█ Debit & Credit Protection Department - From 03/01/2008 To: 12/31/2014Implemented a proprietary Insurance Claims Application with real-time adjudication of a Claim. ■Responsible for the Accounting module which is responsible for all Claims payments as well all other operations involved in an Accounting system. ■Responsible for the Duration module which purpose is to verify through mathematical formulas the maximum period allowed for a certain Claims.■Using CORTICON Rules Engineering system to isolate logical analysis used by the Accounting and other applications in order to isolate and make easy to maintain any modifications without touching the main code. ■Responsible for the Communication module which purpose is to interact (upload/download) with CLients in a SFTP Server.■Responsible for the Billing module which main purpose is to retrieve all Bills available in the DB2 mainframe database and select through rules which one will be used for the payment of the account.

Ft. Lauderdale, Fl, Us

• Upgrading the old ASP, and .NET 1.1 codes to .NET 2.0, using Microsoft Enterprise Library. Working with C#, VB.Net, AJAX, ASP.NET, JavaScript.Maintaining, enhancing, and developing an in-house CRM application used by stores nationwide to keep track of all visits, leads, and sales.• Responsible for the automation process to send Lead Dispositions for all OEM's vendors such as Ford, GM, Nissan, BMW, Mercedes-Benz as well as third parties working for the OEM's. This process consists of a number of methods, based on the OEM’s and third parties' requirement. Use Web Services, POST commands, FTP over SSL, or X-509 Certificates in different formats (xml, text files, etc...)

• Co-Architected and implemented Windows and E-Commerce solutions using .NET technologies, including the definition of a full life-cycle development process based on Object-Oriented programming best practices.• Team leader for the Health Policies, Vendors, Products, and Accounting processing subsystem.• Developed and implemented an in-house Accounting System to interact with the Policy and Claims System. Calculating policies payments, pro-rating, extra fees, agents’ commissions, cascading commissions, printing checks, etc…• Designed and developed Web Services, Remoting, Windows Components using VB.NET ASP.NET, and SQL. Utilized methodologies and documented designs primarily in UML, including logical and physical data modeling, use cases, UI prototyping, and implementation.• Worked as a Database Administrator, creating, modifying and updating tables, views, roles, and security, with an Extensive use of Stored Procedures, DTS, Functions, Triggers, Replications, Index Tuning, Traces, and Cursors.• Previously, worked in converting data from legacy applications (FoxPro and UNIX), to SQL 7.0 where DTS packages were used to transfer this data during the night. • Developed a complete e-commerce site, receiving payments and applications from company’s customers using VB 6.0, SQL 7.0, COM

Mathematics

Computer Science

Bachelor, Mathematics