Robert Shell Email & Phone Number

Greater Minneapolis-St. Paul Area

Assists with the development of expense and travel reporting used by Target to plan budgeting and to monitor expenses• Converted reporting from Tableau to Domo• Created and supported Postgres databases for the team.• Used web technologies to develop an expense portal that allows users throughout the company to view expense reporting• Created Postgres functions to support web applications and Domo reportingTechnologies used to support expense management reporting• Database technologieso Postgreso Teradatao SQL Servero Hadoop• Web technologies o Reacto Material UIo Javascripto Node JS• Data Visualizationo Domo

Brooklyn Park, Mn

• Design and Build automated solutions for Finance teams using MS Access, Excel, and Microsoft SQL Server Integration Services (SSIS)• Built SSIS package to import, transform, load datasets from various sources to team SQL Server databases and SharePoint siteso Helped design KPI and document repository reporting for BSS teams• Created the back-end and export process from SharePoint for KPI reporting used by all BSS teams to understand capacity and performance• Developed Domo reporting for Finance teams• Partnered with members of my team and EDABI to learn how to use EDABI’s in house ETL solution. Brought back training and best practices to the team for how to use the ETL tool to replace tools that were scheduled to be decommissioned by our technology partners• Created GitHub repos for team documentation and code libraries• Assisted with creating the training and support of new technologies for the team. Was responsible for bring the following technologies back to the teamo SSISo GitHubo Postgreso BI Automation Portalo Domo

Greater Minneapolis-St. Paul Area

Build and maintain MS Access Databases used for trend analysis and product recommendations for existing and potential clients. Use VBA to develop automated process that create Excel and Powerpoint reports and presentations for analysts to use. Supports account management team and other customers to extract data and produce ad hoc reports from Teradata data warehouse.

Greater Minneapolis-St. Paul Area

• Responsible for designing and implementing the strategy for how Microsoft SQL Server Integration Services (SSIS) is developed and used by team• Build SSIS package to import, transform, load datasets from text files, MS Access, SQL Server databases into Oracle• Create Logical and Physical data models for framework Oracle database tables used by development and data teams• Design and Build automated solutions for Clearing Brokerage Operations using MS Access, Oracle, and Microsoft SQL Server Integration Services (SSIS)• Mentor team of 5 Analysts in application development and requirement analysis

Build automated solutions for Clearing Brokerage Operations using MS Access, Oracle, and Microsoft SQL Server Integration ServicesSupport over 600 existing MS Access databases for over 300 employees in the Clearing Brokerage Operations OrganizationOne of four Subject Matter Experts for the Clearing Organization's automated processes used in the MS Access databases Work with Business Analysts and Senior Leadership to develop requirements and applications for non technical users to use in their business process Mentor Junior Analysts in application development and requirement analysis

Created release process for custom and core releases for the Bond Desk websiteRelease manager for the Bond Desk website for Ameriprise Regression tester for Bond Desk and Online Brokerage website releasesDesign Automated scripts for Online Brokerage website and 3270 mainframe screens using Quick Test ProDevelop and maintain regression test bed for Online Brokerage and Bond Desk WebsitesMaintain regression test bed using HP Quality CenterUse HP Quality Center to log and track defects found in regression testingDesign test plans and test cases for projects

First level customer support for American Express brokerage, Check Your Accounts, Financial Accounts, and Work Place Retirement websitesResponsible for trouble shooting passwords, registrations, and other duties for advisors and clientsResponsible for navigation and connectivity issues involve with the websites.

Master Software Systems, Software Systems, 3.4

Bachelor Of Science Degree, Management Information Systems