Power Bi Business Analyst
Resume:
Robert Ferreira
Ashland, MA
************@*****.***
Acheivements:
For NORESCO, developed a relational database for HR, Engineering, Finance, Procurement and equipment inventory. Developed a classic ASP page to enable employees to create their own reports.
While working for TELUS, 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, Power BI, JavaScript, VBScript, MICROSOFT, VISUAL BASIC, ASP.net
Education:
BS in Management Information Systems, Minor in Political Science, Northeastern University, Boston, MA
Professional Experience:
TELUS Health, formally LifeWorks, Canton, MA Jun 2012 – Mar 2023
Senior Implementation Analyst / Business Analyst
Supervised implementation of Cognos reports, Cognos Framework Manager, and Cognos Administrative Solutions for new clients.
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.
Performed regression testing and produced Power BI reports.
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.
Incorporated tables and tables joins, fields and field formatting, filters to data.
Developed and maintained interactive Power BI dashboards to visualize key performance metrics and enhance data accessibility for stakeholders.
Created permission groups to enable network security within Cognos.
Set permission on reports and folder system in Cognos.
Assigned levels of permission such as read, run, write and full to groups.
Created Super users, Admin users, Authors, and end users by assigning capabilities to groups.
Terminated long running reports.
NORESCO, Westborough, MA 1998 – 2010
Computer Programmer
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.
Contact this candidate