Sign in

Information Systems Manager Database / Business Intelligence Develop

Coral Gables, FL
September 25, 2018

Contact this candidate


Emilio Crespo

**** ** **** ****** *****, FL *****


Information Systems Manager

Summary Of Qualifications

-Experienced IT Professional with exceptional record of translating business objectives into leading-edge, scalable technology solutions that streamline processes, reduce man-hours, and increase profitability.

-Well-versed in engaging internal stakeholders to ensure service-level agreements are adhered to, organizational partnerships are cultivated, and IT capabilities are developed.

-Deep expertise in coordinating the analysis, design, coding, testing, implementation, and maintenance of vendor-supplied and in-house developed interfaces and systems.

-Strong skills in business analysis, systems integration, reporting, data analysis, and business intelligence.

-Experienced with project management - Agile Scrum and Traditional Waterfall methodologies.

Key Competencies

Agile / Scrum Project Management Software Development Data Architecture & Analysis Database Development

Business Intelligence ETL EDI Report Development Inventory Control Systems POS Systems

Business Analysis Software Documentation and Training SOX / PCI compliance P&L / Budget Management

Disaster Recovery Hardware / Software Troubleshooting Process Automation System Integration

Fluent in English and Spanish Excellent Verbal and Written Communications Skills Team Player Customer Service

Computer Languages, Operating Systems, and Applications

VB.NET T-SQL C# Visual Basic Crystal Reports FoxPro / dBase HTML JavaScript PHP CSS VBScript

SQL Server (7.0 - 2016) RDMS, SSAS, SSRS, SSIS / DTS PowerPivot Power BI IBM - Cognos EV Panorama

Microsoft Office (95-2016) Word Excel Access PowerPoint Outlook Project Visio Skype SharePoint

Windows (3.1 -2010) Windows Server (NT –2012) MS-DOS Mac OS Linux

Corel Draw Photoshop After Effects Illustrator

Internet Explorer Chrome Firefox Vivaldi PeopleSoft PDI Accounting Ultipro

LogMeIn Bomgar NCR CMC TrackIT SysAid ServiceNow Cloud Technology Expesite

Professional Experience

Fiesta Restaurant Group Miami, FL

Information Systems Manager - Technical Services (2015-2018)

Played significant role in multiple initiatives to improve speed, accuracy, and functionality of systems enhancing productivity and profitability by minimizing downtime. Maintained legacy apps and transferred to new systems as they were ready. Supervised network cabling rewires and hardware refreshes keeping technology current thereby increasing productivity.

-Developed and implemented disaster recovery processes and documentation, saving company lost sales and increasing productivity.

-Increased first-call resolutions from helpdesk 20% by utilizing Service Now ITSM program to provide a more comprehensive knowledge base, analysis and tracking tool.

-Established MS SQL server maintenance processes on more than 300 store-based servers to virtually eliminate crashing due to software-related issues.

-Served as project manager for 72 highly successful restaurant openings by coordinating internal resources from IT, other departments and outside vendors ensuring openings stayed on time and at or under budget.

-Collaborated with peers to establish and implement formalized project lifecycle process for hardware and software including certification, testing, QA, implementation, and support.

Emilio Crespo 305-***-****

Fiesta Restaurant Group Miami, FL

INFORMATION SYSTEMS MANAGER – Restaurant Systems (2012-2015)

Management of the Point Of Sale systems and software for Pollo Tropical and Taco Cabana Restaurants. Responsible for maintenance and updates of technology for 300+ restaurants. Efforts Increased sales, accuracy, and customer satisfaction by maximizing new POS system functionality including training tools and menu customization.

-Instrumental in migration of 300+ store-based servers from Windows XP to Windows 7, which significantly improved store operations and efficiency.

-Led IT efforts in creating kitchen video enhancements, working with operations to improve service times. Programming SQL Server database manually outside corporate EDM when needed to ensure smooth testing and rollout while not affecting other initiatives and minimizing IT staff time.

-Took IT lead role in profitability consulting study and mock POS setup and maintenance to develop optimum functional operating, investment, labor resource, and facility design to gain competitive marketplace advantage.

Pollo Tropical Miami, FL

Information Systems Manager (2005-2012)

Created budgets and maintained accounts payable processes for Information Systems. Established repair procedures and equipment distribution controls. Managed vendors to keep SLA on track and costs down. Collaborated with IT, Finance, and Operations to create business intelligence processes, standards, and a robust Data Warehouse. Served as SQL DBA and backup network administrator. Supervised teams of up 12 persons; Budget and P&L management for IS and Depot Services for a multi-unit, multi-million dollar company.

- Played significant role in developing and maintaining automated ETL processes, data warehouse, and reporting system to allow operations, marketing, and finance leadership to gain real-time access to data.

-Improved customer service while minimizing need for IT assistance by implementing and customizing MS Dynamics CRM.

-Increased sales, accuracy, and customer satisfaction as a key part of the selection and installation IT committee that replaced the aging register system with cutting edge touch-screen registers and POS software, including back office PC and links to data for feeding corporate databases.

-Managed transition of corporate data capture and reporting systems at Pollo Tropical to PeopleSoft and corporate databases at the parent company.

Pollo Tropical Miami, FL

Business Analyst / Senior Programmer (1999-2005)

Developed and maintained corporate data capture and reporting program for company-wide use, using Visual Basic SQL Server, SSRS and Crystal Reports. Created tools for restaurant managers including payroll, inventory, and sales / production projections. Automated retrieval and auditing of daily sales and related information for over 100 locations. Retrieved data from PDI payroll system to banks for direct deposit.

-Played significant role in developing EDI-based deposit interface to feed deposit information from stores to bank.

-Integrated Panasonic cash registers with remote and local computers, providing store management with tools needed to effectively manage restaurants.

-Developed data capture processes for operations and Franchise departments to assist with operational audits of restaurants and collection of franchisee sales for franchise.

-Migrated dBase corporate database and Fox Pro reporting system to Microsoft Access with Visual Basic and Crystal Reports; later migrated to Microsoft SQL server and SQL Server Reporting Services.

-Played a key role in migrating corporate Unix-based accounting system to Oracle-based PeopleSoft.

Early Career Experience:

Sandell Business Systems (Labeling systems, Inventory control, Data Collection, Systems Integration Company)

Heath-Zenith Computers (Electronics, PC and Related Systems OEM/Reseller, Repair Facility and Systems Integrator)

Education / Certifications


Miami-Dade Community College Miami, FL ASSOCIATE OF ARTS (AA), MANAGEMENT

MCP – 70-761 Querying Data with T-SQL / SFC – Scrum Fundamentals Certificate

Contact this candidate