Joshua Patrick Dorsey
SUMMARY
Experience in data analysis and troubleshoot data issues through SQL, SSRS and MS Excel
Worked on research of data fields and related data flow information and draw valid conclusions
Performed data-gap analysis for several high-profile clients
EDUCATION
Bachelor of Business Administration in Management of Information Systems, University of Houston, C.T. Bauer College of Business - August 2012.
TECHNICAL SKILLS
JAVA, C# .Net, JavaScript, MS Project 2013, TFS, Visio, Client Management, Agile, BPM, SQL, SSRS, Oracle, QA, Requirements Documentation, SharePoint, JAVA, SCRUM, PM processes, Agile and Reporting,
Coursework included: Systems Analysis and Design, Administration of Computer-based Management Information Systems, Business Database Management Systems, IT Project Management, JAVA and Energy-Trading Risk Management Certificate
PROFESSIONAL EXPERIENCE
AIG, VALIC May 2016 to Present
Business Analyst
Create BRDs for DOL Fiduciary Rule Project- Group level, Participant and Disclosure work-streams
Participated in high-level status meetings to guide strategic business decisions
Meet with various business units to review captured requirements and ensure satisfactory hand-off to IT department
Perform gap analysis from as-is and to-be for Business processes
Created use cases and work flows for future state DOL status tracking
Catalogued all undocumented participant communications and designed a workbook containing traceability matrices for all letters, CSR scripts, AgileNet notices and forms
Intuit Inc. Nov 2015 to Feb 2016
Systems Support Analyst
Position was a temporary contract and I declined offer to extend due to salary requirements
Provide technical solutions to client’s issues regarding Intuit Tax software: ProSeries
Personally resolve in-bound calls and provide phone support to clients in a professional manner
Document all cases using Salesforce, revisit outstanding tickets and assist in issue resolution
Landworks Inc. Oct 2014 to May 2015
Application Support Analyst / Project Coordinator
Collaborated with GIS and technical team in application deployment / configuration utilizing SQL, IIS
Created Project Charters, Project Plans, Business cases and Schedules in MS Project Pro 2013
Provide Landworks software support for clients contacting my direct extension
Learned in detail the complex Landworks Property Management Software, including GIS industry-specific knowledge and custom software components across versions
Configured Landworks GIS software for clients utilizing remote software and trouble-shot issues
Fuelquest Dec 2012 to April 2014
Business Analyst
Performed data-gap analysis for several high-profile clients
Participated in the project discovery and planning phase, providing input about potential issues, risks and options to stakeholders
Contributed to project status meetings and discussions with business users
Analyzed project risks and provided solutions to development and testing teams
Conducted product testing and validation troubleshooting to support product readiness
Trained and supported clients on product functionality and use
Neudesic Mar 2011 to Sep 2011
Associate IT Consultant
Participated on a team SharePoint migration project for a high-profile client
Tested for defects and utilized TFS to document defects for a client’s CRM
QA for a large Oil & Gas company’s Information Delivery Framework
Engaged in Agile methodologies and participated in 2-week sprints with daily scrum calls, as well as client calls to expedite content migration