Robert Ferreira

ad2gk5@r.postjobfree.com.

774-***-****

OBJECTIVE: Seeking a position to design reports that enable different departments to use their data in a way that helps them understand and reach their business goals.

ACHEIVEMENTS: For NORESCO, I developed a relational database for HR, Engineering, Finance, Procurement and equipment inventory. I developed a classic ASP page to enable employees to create their own reports. While working for TELUS, I incorporated new clients to standard reports and collaborated to produce new reports. The types of reports ranged from hours worked, vacation, insurance and financial data.

SOFTWARE PROFICIENCY:

SQL, Cognos, classic ASP, JavaScript, VBScript, MICROSOFT, VISUAL BASIC, ASP.net

EXPERIENCE

Senior Implementation Analyst – TELUS Health, formally LifeWorks, Canton, MA (Jun 2012 - Mar 2023)

Cognos Reports

Designed, developed and edited Cognos reports based on the ever-changing health and life statuses of employees. Analyzed how the changing data effects the reports.

Collaborated with client teams on report requirements via notes, SQL or document requirements for the purpose of generating accurate and readable reports. Generated requirements for reports and SQL for testing when needed

Ability to create complicated queries for list, dashboards and cross tab to help visualize the data

Scheduled reports automatically by manipulated filters to run (monthly, weekly, etc.)

Cognos Framework Manager

Responsible for implementing packages for new clients and maintaining current clients

oIncorporated tables and tables joins, fields and field formatting, filters to data

Cognos Administrative Solutions

Created permission groups to enable network security within Cognos

oSet permission on reports and folder system in Cognos

oAssigned levels of permission such as read, run, write and full to groups

oCreated Super users, Admin users, Authors, and end users by assigning capabilities to groups

Terminated long running reports

Performed regression testing and produced Power BI reports

Computer Programmer - NORESCO, Westborough, MA (1998-2010)

Modernized the company data in Excel to Access then to a SQL Relational Database. Developed reports that joined the HR, Project data, Subcontractors, Warehouse Storage, Engineering data and formulas, Leasing, PO’s, Lighting, Preventive Maintenance, and time cards tables.

Designed, developed and deployed an intranet for applications using classic ASP with HTML, JavaScript, visual basic and ASP.net

Retrieved requirements from various departments in order to create pages for Data Entry and Reports

Schedule automated emails with attachments of reports

Created intricate queries for reports

Responsible for the design and development of a web page where all employees could generate and save reports for reuse with filters on their own

Developed a PO Tracker system for subcontractors

Programmed hand-held device to retrieve data in a walkthrough. Wrote visual basic code to import the data from the hand-held device into a database for proposals

Developed Packages in Framework Manager and Reports for Cognos

Linked to Database and created Packages

Created reports

Automated a text file from Deltek Accounting System for processing checks

Transferred Accounting data from legacy database to Deltek

Automated a billing system for electric bills from Rochester Gas & Electric

Took a text file and formed a bill in a 3-step process. 1) Save text as 2) Open access 3) Click button

Created macros in Access to read and store data into the database and generate bills

EDUCATION

Northeastern University, Boston, MA

1998- 1999

BS in Management Information Systems

Minor in Political Science

Middlesex Community College, Lowell, MA

1995-1998

AA Business Administration Transfer

Contact this candidate