Information Systems Manager Database / Business Intelligence Develop
Resume:
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
Florida International University Miami, FL BACHELOR OF BUSINESS ADMINISTRATION (BBA), MANAGEMENT
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