Allen Johnson Email & Phone Number

Orlando, Florida, United States

Solution architect and technical lead in delivering planning and budgeting solutions within the Animal & Plant Health Inspection Services (APHIS) department of the USDA. Implemented new practices to minimize manual efforts and bottlenecks in the process to deliver a simplified reliable data framework. • Streamlined the core Budget and Planning data processes to remove all manual processes.• Design and develop Power Automate Flows for the movement of core data into the SQL Server.• Design and develop IBM Planning and Analytics solutions to support staffing, planning and budgeting functions.• Design and develop a front-end interface using TM1 Perspectives for data entry.• Establish integration standards and policies for getting data across multiple systems into one central data store.• Partner with networking, identity management and database management teams to implement appropriate security and firewall rules to support and protect agency data.• Design and develop Power BI dashboards to represent agency information to various levels of leadership.

Orlando, Florida, United States

Partnered with department leadership to define data requirements and expectations to support all areas of Simply Self Storage. Executed the data strategy to deliver data and analytics solutions to leadership to make decisions.• Designed and developed solutions supporting all data sharing initiatives with Blackstone.• Established standard operating practices and SLA’s for data operations.• Designed and developed ETL processes in SSIS to support refreshes of data,• Designed and developed analytics and data visualizations solutions in MS Power BI.• Designed and built all data structures within MS SQL Server.• Partnered with department leadership to create a data certification process.• Delivered HR/recruiting/employee data for analytics utilizing UKG business intelligence (IBM Cognos).• Delivered Field Operations, Finance and Marketing data for analytics utilizing Sitelink API calls.

Orlando, Florida Area

Orlando, Florida Area

Specialized in merchandising and store layoutManaged multilingual staffInterviewed, hired & trained employeesDirected customer service and relationsProficient in pharmacy and photo lab operationsAnalyzed inventory and assisted with orderingSuccessfully completed MGT basics & MGT Advanced programBegan the ADSM (Advanced Drug Store Management) program