JOE COLIANNE

adcjev@r.postjobfree.com 630-***-****

EXPERIENCE

MCC May 2016 – Present

Sales and Operations Analyst

Manage Reporting, financial operations, forecasting and budgeting

Use HRIS system Run by ADP to pull monthly, quarterly and annual reports for payroll, general ledger, employment statistics, layoff, hiring

Pull, scrub and upload master data into appropriate systems for reporting

Utilize SQL to run queries for monthly and annual reporting

Automate tables and views to be shared internally and externally via

Use Salesforce CRM, Microsoft SQL Server Management Studio 18, Microsoft SQL Server 2019, Excel and Quickbooks daily

Interact with highly technical, Analytical and Financial professionals and act as a translating liaison between departments

Key player when evaluating new software from trial period through implementation helping with design to training end users

Training:

Advanced Database and SQL Querying

SAP ERP Essentials Training

SAP Cloud Analytics

SAP Financials Essential Training

Technologies Used: Salesforce, Run ADP, Microsoft Suite 2019, O365, Microsoft SQL Server Management Studio 18.4, Microsoft SQL Server 2019, SAP Cloud Analytics, Bullhorn, Zoho Suite, CareerBuilder, Monster, Indeed, LinkedIn, Microsoft Suite, Intuit Quickbooks, WaveApps, Google Docs

Medix IT, Chicago IL September 2010 – May 2016

Office Leadership Council January 2014 – May 2016

Sr. Account Executive June 2011 – May 2016

Technical Recruiter September 2010-June 2011

Ran daily Scrum standups with small team of 5 and weekly standups with a team of 60

Ran training classes from five to forty recruiters and Account Managers covering industry

Participated and led Leadership Council meetings surrounding Process Improvement Strategy and implementation

Created and implemented quarterly sales and operational initiatives rolled out to an office of 90 and in some cases to the company of ~ 300 employees

Knowledge, prospecting, selling and follow up plans. Built individual territory plans which included dial blocks and time management goals

Helped structure detailed and complex compensation plans for sales and recruiting teams

Document technical requirements and develop strategy to fill needs

Sold recruiting resources in Network Infrastructure, Application Development, Technical Support, Business Intelligence

Managed and onboarded over 10 people and promoted 6 in 4

•Negotiated client contract legal and financial terms

ACHEIVEMENTS

•President’s Trip Award Winner 2015

•President’s Trip Award Winner 2014

•Salesperson of the Quarter Award Winner 2014

•Promoted 6 Employees

Home Office Solutions Group, Northbrook, IL June 2008-September 2010

Account Executive

•Generate over $1.1M in annual revenue

•Strategically managed vendor and customer care relations

•Responsible for maintaining specific inventory levels based on seasonal sales trends

•Evaluate turnover to determine optimal inventory levels

•Oversaw sales for two online retail stores

•Assess inventory profit margins to determine competitive prices

CONVERSATIONAL COMPETENCY IN:

Healthcare/Hospital:

Extensive conversations: Admin/Registration, Clinical Operations, Nursing, Clinical Informatics, Healthcare Information Technology (HIT), Electronic Medical Records (EMR), Inpatient/Outpatient

IT Infrastructure:

Extensive conversations in: Project Management and Planning, Change Management, Systems Architecture, Integration and Optimization, Unified Communications, Technical Support/ Help Desk, Network, Cisco, Switches, Routers, Cabling

Business Intelligence:

Extensive conversations: SQL, SSRS, SSIS, SSAS, ETL, OLAP, Crystal Reports, Tableau, Oracle, OBIEE, Informatica, T-SQL, Google Analytics, Data Visualization, MS Power BI, Data Modeling, Data Warehouse

Software Development/Applications:

Extensive conversations: Android, iOS, Java, .Net, SharePoint, HTML, CSS, JavaScript, Graphic and Web Designers, Database, EMR, HL7

Finance/Accounting:

Moderate to heavy conversations: Financial/Accounting Analyst, Leads, Managers, Director, C-level. CPA’s, Accounts Receivable, Accounts Payable, General Ledger, Reporting

VOLUNTEER

Chicagoland Help Desk Institute (HDI)–Leadership Council, VP of Sponsors Nov 2014 – 2019

Greater Chicago Food Depository and Feed My Starving Children 2014-2017

EDUCATION

University of Iowa, Iowa City, IA B.B.A. Finance December 2008

Contact this candidate