Juan García
Aguas Buenas
Summary
Have over 10 years of experience delivering IT solutions to drive the performance and revenue of many organizations. Proven track record of consistently achieving organizational goals by directing projects and implementing robust IT solutions that incorporate a wide range of applications and technologies. Result-oriented visionary business leader with strong track record of performance in: Government, Retail, Manufacturing, Hospitals, IT Project Management, Advertising Agencies and Automotive Industry experience. Utilize keen analysis, insight, and team approach to drive organizational improvements and implementation of the best practices. Strong Decision Maker, detail oriented, and committed to the attention of customers’ requests.
Overview
24
24
years of professional experience
Work History
Vice President & IT Director
MEC Consulting Service Group LLC
2014.04 - Current
- VP & IT Director Consultant for the firm servicing construction, advertising, logistics, automotive and manufacturing industries.
- Microsoft Power BI Dashboards creator and developer. Lead the publications of monthly BI for PR Automotive Industry Association (GUIA) including hundreds of users of multiple domains and for Arco Publicidad Advertising Agency BI for internal and external users.
- Proven record to drive results via use of Microsoft Power BI. Improved revenue results from 8 million to 40 million for Adverting Agency by creating a a set BI dashboards that enable management to acct on information about revenue, margin and expenses.
- Extensive experience managing Office 365 tenants as global administrator for up to 200 users for multiple organizations. Microsoft Azure VM creation and administration. Intune administration and deployment. Microsoft Defender endpoint protection administration and Microsoft Entra ID administrator for all my clients.
- Successfully completed cost accounting system setup at Ashford Community Presbyterian Hospital on Meditech 5.66 ERP, increased clinical procedure cost accuracy by 100% via the update of cost matrix for 500 clinical procedures.
- Lead IT Clinical team and developed procedures and provided guidance for the Emergency department billing process automation through documentation on Meditech system. Generated over $1 million incremental revenue in one year by the analysis and detection of errors on diagnosis coding.
- Updated Hospital inventory database of medical supplies eliminating 13,000 duplicate items and updating price, improving revenues by 10%.
- Effectively completed projects on automotive industry (CDK to Prophix Smart Client cloud server) and the advertising industry (Data Center Upgrade and Intersoft).
- Lead and implemented change of Firewall technology from Watchguard to Fortinet improving security posture by 50%.
- Cultivated strong relationships with key stakeholders, including customers, vendors, software developers and regulators to promote collaboration and long-term success.
- Managed team of IT professionals, providing mentorship and guidance to boost productivity and ensure project success.
- Experience as firewall administrator for Fortinet products. Understands network segmentation (VLAN) and security.
- Extensive Systems/Appliances Experience: Mapics, Hyperion, Prophix, Business Object, Word, Excel, Power Point, CDK, Sage 50, QuickBooks, Microsoft Office 365, SharePoint and Power BI. Prophix Smart Client 12, others like Intersoft Media, Meditech, Hyperion Essbase, FDM, HFM, SAP ERP, PeopleSoft Financials, Business Objects, VMware VSphere Client, Veeam Backup & Replication as well as operating systems like Windows 11 Professional, SQL Server and Windows Server 2019, Microsoft Azure, Microsoft Azure Active Directory. Fully bilingual in English and Spanish
Assistant Controller
Pepsi-Cola Manufacturing International Limited
2013.01 - 2014.01
- Managed a $30 Million operational expense budget
- Manage, lead and provide support for change of seven legal entities from MAPICS (AS400) accounting system to SAP.
- Reduced new price changes upload time in SAP system by 50% by changing the setup of the import source file.
- Responsible for the accounting of the interest and taxes for the affiliate's loans and the treasury cash requirements to cover the disbursements needs with over $1.6 billion in transactions on a yearly basis.
- Implemented Balance Sheet Review process.
- Successful application of internal control processes aligned with COSO and GCS tools to comply with corporate guidelines and SOX.
- Worked closely with management to identify expense savings that help plant achieve their financial plan.
- Facilitated cross-functional collaboration by partnering with other departments on special projects aimed at improving overall company performance.
Budget & Finance Director
Department of Economic Development
2012.01 - 2013.01
- In charge of directing, coordinating, planning and supervising all the activities of the budget and finance office.
- Managed to collect over $1.0 Million of the account receivable balance of the agency special fund.
Regional Finance Director PR & USVI
Kmart
2001.01 - 2011.01
- In charge of coordinating the budget and business plans for the region, which generate over $600 Million in annual revenue. Utilize financial analysis and forecasting tools to develop and prepare their $156 million annual expense budget for 27 stores.
- Regional IT security point of contact, infrastructure and project collaborator on all stores systems changes.
- Business Objects super user responsible for designing reports that worked across regions.
- Conducted rigorous competitor analyses to identify market trends and potential opportunities for growth or business development.
- Coached and developed a high-performing finance team, fostering a culture of continuous improvement and professional growth.
- Negotiated favorable vendor contracts that resulted in significant cost reductions without compromising quality or service levels.
- Led the annual budgeting process, ensuring alignment with company objectives while maintaining fiscal responsibility.
Education
BBA - Accounting And Business Management
University of Puerto Rico
Rio Piedras05.1995
Skills
- Excellent leadership and problem-solving abilities
- Technology Implementations
- Microsoft Power BI Dashboards Creator
- IT Administrator
- IT Project Execution
- Team Leadership
- Vendors/Suppliers Relationship Building
- Decision-Making
- Critical Thinking
- Complex Problem-Solving
- Data Analysis
- Performance metrics analysis
Scope
- Microsoft Power BI Dashboards Creator
- IT Project Management
- Office 365 and Microsoft Entra ID Global Administrator
- Microsoft Defender Administrator
- Microsoft Intune Administrator
- IT Global Administrator
- IT Vendor Contract Negotiations and Management
- Team Building & Performance Improvement
- Financial & Business Intelligence Analysis
- Restructuring/Agent of Change
Summary Of Experience
- MEC Consulting Service Group LLC, San Juan, Puerto Rico, Vice President & IT Director, 2014, Present
- Pepsi-Cola Manufacturing International Limited, Cidra, PR, Assistant Controller, 2013, 2014
- Department of Economic Development, San Juan, PR, Budget & Finance Director, 2012, 2013
- Kmart, San Juan, PR, Regional Finance Director PR & USVI, 2001, 2011
- Ciba Vision (Puerto Rico) Inc, Cidra, PR, Finance Analyst & General Accountant, 1997, 2001
- Professional Wear Corp., San Juan, PR, General Accountant & Office Manager, 1995, 1997
Training
- Introduction to Situational Leadership, Sears Holdings University, Hoffman Estates, IL
- Conflict Resolution, Sears Holdings University, Hoffman Estates, IL
- Effective Communication, Sears Holdings University, Hoffman Estates, IL
- Managing Sustainable Change, Sears Holdings University, Hoffman Estates, IL
- Microsoft Power BI – Webinars; design and implementation
- Cyber Risk Management for an Evolving Workplace
- How to prevent, detect and deter fraud in the computerized information systems
- Hot topics in accounting and auditing
Timeline
Vice President & IT Director
MEC Consulting Service Group LLC
2014.04 - Current
Assistant Controller
Pepsi-Cola Manufacturing International Limited
2013.01 - 2014.01
Budget & Finance Director
Department of Economic Development
2012.01 - 2013.01
Regional Finance Director PR & USVI
Kmart
2001.01 - 2011.01
BBA - Accounting And Business Management
University of Puerto Rico
Similar Profiles
Orlando AlmeidaOrlando Almeida
Sales Management at Global Service Consulting Group LLCSales Management at Global Service Consulting Group LLC
NADIA GORGISNADIA GORGIS
Office Assistant at Human Capital Consulting Service, LLCOffice Assistant at Human Capital Consulting Service, LLC
Gregory CoyerGregory Coyer
Operator/Laborer at MEC Underground Solutions LLCOperator/Laborer at MEC Underground Solutions LLC