Create Power BI data visualization dashboardso Provide internal and client facing reports on SLA trends for all cliento Provide employee time worked utilizationCreate, update and maintain SSIS ETLs for user and asset loadso Transform data from SQL server to Postgres servero Populate client user data for customer facing portalo Migrate ETLs from Pentaho to SSISCreate, update and maintain SSRS reports using Report Designer Language

· Perform retail sales analysis· Design data visualization dashboards using Power BI· Partner with engineers and clients to define reporting requirements· Process ad hoc reporting needs· Automate the running of python POS data collection scripts· Troubleshoot ETL failures· Apply advanced sales analysis techniques using these drivers: velocity, price and distribution · Perform quality assurance testing for client deliverables using SQL, Beyond Compare and Excel

· Responsible for supporting retail auto parts sales on B to C, ecommerce websites· Create Power BI dashboards to illustrate ROI trends per dealer and OEM· Make recommendations to leadership· Example: Helped GM dealers sell 50K more per month by removing obsolete parts from catalogAdditional Details:· Certified in Pragmatic Marketing· Experience and training in Agile product development· Implement Google Analytics to make data driven decisions· Give presentations to key constituents to drive awareness of product capabilities · Analyze data and prepares reports· Perform market research of new product concepts· Organize, plan, make recommendations and execute product and project launches· Own and manage special customer handling needs like contract changes

Perform testing on back-end systems (SQL server) and verify business logic in a Microsoft environment. Design and implement quality assurance and maintenance processes.Design and/or specify best methods for data inspection, verification and validation. Responsible for black box, functional, end to end and regression testing including documentation of results, and working with various departments. Maintain accurate product/project testing and quality assurance records. Update automated regression testing scripts. Facilitate agile SDLC.

Perform quality assurance software testing for database synchronization and imaging applications including regression, performance, and acceptance testing. Create automated software testing scripts using Test Complete. Create test plans and test cases. Ensure the software is compatible with most dental imaging hardware including digital sensors, phosphor plate scanners, intra-oral cameras and panoramic x-ray units. Project Manager in transitioning a retail database replication product into an enterprise application capable of synchronizing one hundred remote locations.Provide tier III technical support for resellers of Apteryx dental imaging software.

Created financial reports for the Board of Directors per the direction of the President and Controller. The reports were created in FRx and included Income Statements and Rolling Estimates for the various SHH companies, divisions and departments. Also, provided support of the MAS 90 accounting system and system administration of the Active Directory Domain Controller.

Management responsibilities of employees in Technical Support & QA: Interviewed and made hiring decisions Supervised employees in multiple countries Set priorities and monitored performance Conducted performance appraisals Facilitated training of new employeesTechnical Support Call Center responsibilities: Ensured a two hour call back response Ensured support issues were closed within two weeks Ensured calls were logged as tickets in CRM Personally handled difficult calls from major accounts Facilitated an open discourse to improve troubleshooting Ensured installations were performed correctly/completely Ensured customers were trained on how to use the softwareQuality Assurance Software Testing responsibilites: Supervised testing of custom and standard software Managed the creation of test plans, regression testing strategies, technical manuals and release notes Ensured every Visio was fulfilled Personally handled testing of mission critical projectsSupported hardware included: Cisco Aironet access points Intermec, and Motorola handheld computers Various versions of the Windows Mobile O/SWireless networking support included: Access point RF coverage optimization Handheld computer radio optimization All wireless security types including EAP/RadiusSupported software entailed the entire Scanco product line including ShopWatch, RF, Directed Picking, Warehouse Automation for Sage MAS 500, Label Xpert, MAS Print and Automation Series

Provided onsite and remote system administrative support of customer and internal servers, LANs and WANs including installing and managing:Citrix servers, terminal servers, VPN servers, Active Directory domain controllers, DNS servers, DHCP servers, SQL servers, Exchange servers, file and print servers, and desktop computers Supported software includes:MAS 90/200, FRX, F9, Symantec Antivirus/Ghost, MS Office, System Scheduler Pro, Snapshot, Bart’s PE Builder, POP-con, Auto IT scripting, and various backup programsSupported hardware includes:RAID controllers, routers, tape drives, printers, APs, laptops, all internal computer components, cabling, and switchesWeb design and development:Created Content Management System websites: www.datawestgroup.com and www.officestartraining.comMigrations:Converted call tracking and billing systems to Saleslogix CRM including migrating customer databaseFacilities Manager for computer training center (i.e. New Horizons)Imaged and prepared five classrooms every day Managed and maintained 12 servers and two networks

Provided 24 X 7 technical support for a POS environmentSupported systems included: SCO UNIX, AIX, and NT ServerUNIX System Administration duties: Installed and maintained, permissions, disk full or failing, virtual memory allocation, kernel failure, daemons, user accounts, login scripts, tty lines etc… Used the VI editor proficiently

Handled over 12,000 (avg. 25 calls per day) level two calls nationwide in support of the FedEx Ground shipping computer.Troubleshot all software, O/S and PC components.Placed service calls to dispatch mobile technicians when parts were deemed broken