SQL & report developer
Resume:
Robert Ferreira
************@*****.***.
ACHEIVEMENTS: For NORESCO, I developed a relational database across multiple platforms. While working for TELUS, I incorporated new clients to standard reports and collaborated to produce new reports.
SOFTWARE PROFICIENCY:
SQL, Cognos, classic ASP, Power BI, JavaScript, VBScript, MICROSOFT, VISUAL BASIC, ASP.net
EXPERIENCE
Senior Implementation Analyst – TELUS Health, Canton, MA (Jun 2012 - Mar 2023)
SQL Developer
Optimized complex SQL queries resulting in a 50% increase in performance
Ability to create complicated queries for list, dashboards and cross tab for reports
Managed and analyzed data sets using SQL to maximize efficiency
Incorporated tables with joins, fields and formatting data, filters to data
Report Developer
Gathered information to created and analyzed data and produced Power BI reports
Collaborated with client teams on report requirements via notes, SQL or document requirements for the purpose of generating accurate and readable reports
Reports types Healthcare, Timecards, Vacation Time, Retirement Funding, General HR
New Cognos Clients
Supervised implementation of Cognos reports, Cognos Framework Manager, and Cognos Administrative Solutions for new clients.
Cognos Reports
Designed, developed and edited reports based on the ever-changing healthcare needs and life statuses of employees.
Analyzed how the changing data effects the 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
Cognos Administrative Solutions
Created and set permission groups to enable network security within Cognos folder
Assigned levels of permission such as read, run, write and full to groups
Terminated long running reports
Performed regression testing
Computer Programmer - NORESCO, Westborough, MA (1998-2010)
Developed Relational Database and Intranet
Modernized the company data from Excel to Access then to a Relational Database.
Designed, developed, tested and deployed an intranet for applications using classic ASP with HTML, JavaScript, VB Script and ASP.net using the relational database.
Responsible for the design and development of a web page where employees could generate and save reports for reuse with filters on their own.
Database development and modification efforts across multiple platforms, including online systems
Implemented business processes
Applied Process of developing new proposals, the implementation and tracking of excepted proposals and the storage of equipment.
Retrieved requirements for all departments to create pages for Data Entry and Reports.
Report Developer
Develop and maintain documentation and standards
Developed a page to summarize project data in a single webpage.
Summarizing hours worked and equipment purchased and installed.
Implemented reports for HR, Project data, Subcontractors, Warehouse Storage, PO’s, Engineering data, Leasing, Lighting, Project Maintenance, PO Tracker and time cards.
Schedule automated emails with attachments of reports.
SQL Developer
Created intricate queries for reports and testing when needed.
Implemented basic and complex queries solutions for data analyzing.
Developed nested queries.
Cognos Framework Manager and Cognos Reports
Linked to Database and created Packages for reports
Deltek Accounting System
Automated a text file for processing checks and accounting data from legacy database
Automated a billing System
Took a text file from Rochester Gas & Electric and formed a bill in a 3-step process. 1) Save text as 2) Open Access 3) Click button using VB code in Macros.
EDUCATION
Northeastern University, Boston, MA
BS in Management Information Systems
Minor in Political Science
Middlesex Community College, Lowell, MA
AA Business Administration Transfer
Contact this candidate