Relational DB, SQL, and Reporting Specialist
Resume:
Robert Ferreira
************@*****.***.
SUMMARY: Find a position that I can use SQL, reporting, business experience to bring data to decision makers
Able to lead meetings and work effectively with management and technical teams
Discuss and clarify requests for reports, highlight issues, and make recommendations to address issues and priorities
Translate business requirements into usable queries and reports
Constructively work with a technical diverse team to produce reports
Strong Relationship building skills
SOFTWARE PROFICIENCY:
SQL, Cognos, classic ASP, Power BI, JavaScript, VBScript, MICROSOFT, VISUAL BASIC, ASP.net, JD Ewards ERP
EXPERIENCE
Senior Implementation Analyst – TELUS Health, Canton, MA (Jun 2012 - Mar 2023)
Purpose: Incorporated new clients to standard reports and produce new reports.
SQL Developer
Learned JD Ewards ERP using Oracle SQL to develop queries in Cognos query analyzer
Ability to create complicated queries for list, dashboards and cross tab reports
Managed and analyzed data sets using SQL to maximize efficiency
Incorporated tables with joins, fields, formatting and filtering data
Report Developer
Gathered information to created and analyzed data from JD Ewards ERP tables and produce dashboards using 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 (70%), Timecards (5%), Vacation Time (5%), Retirement Funding (5%), General HR (15%)
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
Analyze how the changing data effects the reports
Schedule reports to run automatically on schedule such as monthly, weekly, etc.
Cognos Framework Manager
Responsible for implementing packages for new clients and maintaining current clients
Added and manipulated fields from tables in JD Ewards ERP system
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 data from Excel to a Relational Database of Access then to a SQL Server
Designed, developed, tested and deployed an intranet 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.
Implemented business processes
Coordinated Meetings with department heads to design business requirements and learn business cycle
Implemented business requirements by creating table(s) if necessary, webpages for data entry and data review before reports. then created a process to run reports
Developed process to track projects using classic ASP by tracking the purchase of equipment, installation, and the storage of unused equipment per project
Retrieved requirements for all departments to create pages for Data Entry and Reports including Engineering proposals, Leasing, Lighting, Project Maintenance, PO Tracker, HR, time cards and payroll.
Report Developer
Wrote and maintain documents of reports
Created a page to summarize project data in a single webpage.
Summarizing the project in hours worked, equipment purchased and installed, Project data, Subcontractors, PO’s, Lighting, and PO Tracker
Developed reports on HR, Engineering data, Leasing, Project Maintenance and Time Cards, Warehouse Storage
Schedule automated reports with attachments of in emails.
SQL Developer
Developed tables with primary and foreign keys
Created intricate queries for reports and testing
Incorporated engineering calculations into queries for reports
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