image/svg+xmlDashboards
Data Warehouse
Cloud
RPD
Business Requirements
Toad
SQL
Informatica
Analytics
Cognos
JUSTIN
ROBERTSON
75036 N. Elm St., Riverside, MO 93428 · (260) 555-1464 · jrobertson@example.com
EXPERIENCE
ARCHITECT,
MS COMPANIES, RIVERSIDE, MO
MAY 2018 - MARCH 2020
Completed SCORE Upgrade Projects Implement on CLOUD successfully.
Analyzed Eligibility source data including COBOL structures and created data models then DDL
using ERwin.
Used Cloud SVN hub for version and source control.
Collaborated with Windows server and Mobile teams to architect infrastructure and select mobile
device.
Hired to modernize an aging IT infrastructure.
BI CONSULTANT,
MS COMPANIES, RIVERSIDE, MO
DECEMBER 2017 - APRIL 2018
Monitored testing servers for long running stored procedures, queries using profiler and
recommended clustered and non-clustered indexes using DTA.
Deployed SSIS packages into production server.
Participated in architecture planning meetings & took part in migrating existing legacy system
Unify to SQL Server 2008.
Automated Complete Business Critical Reporting Project Packages and scheduled using SQL Agent
to run at regular intervals of time.
Created a stored procedure to automate the execution of all the stored procedures and to
schedule the jobs.
OBIEE DEVELOPER,
MANPOWERGROUP, MILWAUKEE, WI
DECEMBER 2013 - JUNE 2017
Implemented REST API services for Jive retrieving and updating profile information of users.
Developed a metadata model in Framework Manager by following best practices.
Interacted with end users and developers to validate the data model, reports and dashboards.
Created ODBC Connections and Created Physical, Business and Presentation Layers in RPD.
Involved in Informatica administrative work such as creating Informatica folders, repositories and
managing folder permissions.
EDUCATION
2010 - 2013
BACHELOR'S DEGREE IN ARCHITECTURE,
University of Wisconsin - Milwaukee
Milwaukee, WI
SKILLS