Paulo Cera Email & Phone Number

Vaughan, Ontario, Canada

Vaughan, Ontario

- Developed/Maintained core application built in MS Access 2003 Front End using a VB.NET Middle Tier with SQL back end- Assisted on Support as required with Bug Fixes and Analysis of issues - Custom Modules for Clients to integrate with ERP System - Created Excel Forms/Sheets to easily automate/import data from external sources- Improved performance of MSSQL Stored Procedures as required

Mississauga, Ontario

- Mulesoft Anypoint Studio Developer- Participate in Daily Scrums for Agile Projects- Ad-hoc reporting from various Data Systems (SQL, Cobal & ZODBC)- Month End reporting Finance Departments- Automation of daily Reports via VB/VBA Scripts and SQL Scripts- Automation of daily customer data refresh into Salesforce- Salesforce administration responsibilities- Automation of various data transfers between vendors and other systems- Create Excel macros for various departments to automate repetitive tasks- Corporate Employee of the Year 2013- Gathered requirements from internal customers to produce Technical Change Requests and New Report Requests

Mississauga, Ontario

- Create/Customize Reports using Crystal Reports 9.0/11 - Develop VB, VB 6 & VB.NET applications for Customer Service Department- Created Pricing Quotation Software (MS Access 2000, VB, VB 6 & VBA)- Customization of Microsoft CRM 3.0/4.0 with MS SQL 2005 backend- Support for Internal Applications accessing Oracle 8i backend- Create custom Triggers/Views/Packages for Oracle 8i database- Customize Active Reports for INFOR Global Financials Application- Documentation of all enhancements/changes to existing software- Maintaining existing company website- Development of Web Catalog of all products company has to offer

Markham, Ontario

- Created Web Reports using Crystal Reports XI- Migration of Crystal Report Server from Crystal 8 to Crystal XI- Created ASP web pages to allow users to enter criteria to run web reports using Visual InterDev 6.0- Created T-SQL statements and Stored Procedures for an Oracle Database using TOAD- Improved Reporting performance by analyzing Reports and SQL statements- Documented all new and existing reports

Markham, Ontario

- Developed in C#, VB.Net and VB 6- Created Word Integration Forms using VBA - Created add-on modules for the W5 Claim Management Product - Loss Run Reporting (Access, VBA and T-SQL)- Electronic Data Interface (C# and T-SQL)- Worker’s Compensation Forms (C#, ASP.NET and T-SQL)- RCMP Claim Entry Forms (C#, ASP.NET and T-SQL)- Email Notifications via Web Submissions of Claims (ASP, ASP.NET, C# and T-SQL)- Created SQL Stored Procedures, DTS Packages and Tables in SQL Server- Created Reports using Crystal Reports 7/8/8.5 and Active Reports.Net- Created Quality Control Reports for Data entered by users (SQL 2000 and Excel)