SUMMARY:

Determined and collaborative bi - lingual (English & Spanish) professional with expert-level experience developing ETL using SSIS as well as expert-level experience writing 300+ SSRS reports. Expert at creating and modifying T-SQL (along with other flavors). Proven analytical and problem-solving skills with a specialized ability to assess a situation, define requirements, and develop value-added solutions that streamline and improve operating efficiencies while reducing costs. Highly adept in communicating with technical and non-technical audiences when needed. Proven experience leading teams on various initiatives from corporate-level to functional-level as well as team-level.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Business Intelligence Developer

Responsibilities:

• Gathered business requirements from various organizational units and transformed into technical requirements
• Overhauled previously written T-SQL queries and optimized for performance
• Converted scripts in PERL (and other languages) into ETL via T-SQL and SSIS
• Adapted to constantly changing business requirements while having to develop and learn new processes/scripts on the go.
• Led a rollout of SQL 2017 for development use within Business Intelligence Team
• Developed complex queries for use in analysis internally and by other business units
• Created/Reworked over 300 SSRS reports using queries from various sources
• Established multiple views of same report through parameters and variables
• Integrated data from SharePoint into live SSRS reports
• Extracted, transformed and loaded data from Cisco phone system for use in analysis.
• Conducted data validation for migrations and identified data deficiencies within production systems.
• Performed data analysis for various business segments and provided decision support.
• Managed five analysts assigned to different organizational units to help them further develop within the organization
• Liaised with other business units to centralize business intelligence requirements
• Aggregated data from 40+ production sources in various structures (SQL, MySQL, PostgreSQL) and transformed into a reporting data warehouse
• Manipulated SharePoint via SSIS to help cover known system deficiencies and enhance data quality for reporting and analysis
• Developed documentation for data marts and data warehouse to be used by business
• Worked with executive team in development of KPIs for business to provide a status as how the business stood as well as where it had come from.
• Created dashboards using PowerPivot for Excel 2010 and Excel 2013 and PowerBI
• Leveraged knowledge of SQL, SharePoint and Excel to other teams on as-needed basis.
• Worked with large datasets (in excess of 1TB) for use in analytics

Confidential, Miami, FL

SQL Developer, Business Performance

Responsibilities:

• Gathered KPI’s for different segments of business and developed metrics for measuring them on a rolling basis.
• Provided assistance with compensation analyses by creating scorecards to assist in year-end reviews.
• Developed a process for storing company strategy inside of a database structure along with a data import utility to facilitate threading of strategies to extract value for the organization.
• Wrote an application using VBA that permits all functions within company to provide updates into a centralized database to provide senior management greater visibility to activities within the business.
• Built data model and constructed warehouse for above mentioned application in SQL Server 2008.
• Served as technology liaison to understand all systems within People & Performance organization and developed solutions to eliminate duplicate data feeds.
• Leveraged expertise in SharePoint, VBA, SQL, MS Access, and Excel to other teams on as-needed basis.

Confidential, Miami, FL

Junior SQL Developer, Sales and Marketing

Responsibilities:

• Mined data both internally and externally so as to improve the value of it for company segments (Aviation, Marine Land).
• Built a data warehouse and developed mappings in SQL server 2008 database in order to leverage external data for all segments of business.
• Designed and implemented reports on Excel designed to provide a snapshot of where the business is presently at and where future directional indicators are going.
• Wrote macros in Excel using VBA and DTS packages in SQL Server to automate repetitive functions so as to manage time more efficiently.
• Built and managed a Microsoft SharePoint site for commercial users to access reports and securely download them.
• Worked with finance teams in order to ensure that figures that were being reported to commercial teams were accurate.
• Worked with leaders across all segments on various projects such as demand gathering, account segmentation, as well as various other projects.
• Leveraged expertise in VBA, SQL, MS Access, and Excel to other teams on as-needed basis.

Confidential

Excel Developer, Miami, FL

Responsibilities:

• Successfully developed a reporting model to display various metrics of the Confidential - Micros Rollout Project.
• Wrote software using VBA in excel file to generate reports/dashboard on various worksheets within file.
• Provided consultation to users on various formulas, macros, and other excel functions as needed.

Confidential, Weston, Florida

IT Analyst

Responsibilities:

• Successfully performed data migrations from SAP Business One to MAS200 and then later on from MAS200 to Oracle.
• Developed mappings in order for communication to be possible from eBridge 2006 software to various sources such as MAS200 and EDI documents as well.
• Actively managed several HP, Dell, and IBM servers as well as an Apple Server.
• Worked with Active Directory through Windows Server 2000/2003/2008 in order to setup users and to troubleshoot user difficulties such as password resets and computer name resolution.
• Assisted with compliance of organizational backup procedures using Backup Exec in order to back data up to magnetic cartridges.
• Provided Desktop Technical support to end-users operating on Windows XP SP2/SP3, Vista, and Mac 10.5.x using phone and remote support.
• Supported users e-mail through Lotus Notes 7.0.2 for Windows and Lotus Notes 7.0.3 for Mac.
• Supported users virus issues using corporate version of Symantec Antivirus and did perform spyware and virus removal as well.
• Provided hardware support on various models of the following printer brands: HP, Ricoh, Toshiba, Lexmark, Epson, Konica-Minolta, and Xerox printers.
• Ghosted approximately 40 machines using Symantec Ghost.
• Developed custom reporting software that involved taking financial transactions and turn them into financial reports using a combination of SQL and VBA as well as MS Excel formulas.
• Created DTS and SSIS Packages using MS SQL Server Enterprise 2000/2005.
• Created reports using Crystal Reports 11.
• Developed custom applications for various uses utilizing VB and/or VBA.
• Created reports frequently using charts, graphs, and pivot tables in MS Excel.
• Provided support to users when they needed help utilizing formulas.

Confidential, Weston, FL

IT Specialist

Responsibilities:

• Designed and implemented IT infrastructure layout as well as corporate policies regarding location, safety, and use of all computer equipment.
• Configured Active Directory policy as well as DNS on Windows Server 2000 and then in Q4 2006 migrated it to Windows Server 2003.
• Configured Apple Server utilizing Mac OSX Server 10.4.2 and eventually upgraded to Mac OSX Server 10.5.3 in Q1 2008.
• Developed Tape Backup system for storing company financial data to magnetic tape which also included having an off-site backup in the event of a catastrophic emergency.
• Replaced all existing networking (from previous building tenant) and upgraded all cabling to CAT6 cabling as well as installed/configured 3Com switches and Wireless Access Points.
• Successfully implemented SAP Business One Accounting system along with EDI modules and Radio Beacon WMS system for inventory purposes.
• Worked with Active Directory through Windows Server 2000/2003 in order to setup users and to troubleshoot user difficulties such as password resets and computer name resolution.
• Provided Support to users with office application suites such as Office 2003/2007 for Windows, MS Office 2004/2008 for Mac, iLife for Mac, iWork for Mac, and Openoffice.
• Supported users e-mail through MS Outlook, Mail for Mac, Eudora, and Thunderbird.
• Provided hardware support on various models of the following printer brands: HP, Ricoh, Toshiba, Lexmark, Epson, and Xerox printers.
• Developed financial models using VBA for excel with a combination of charts, graphs, and pivot tables.
• Developed Company Reports utilizing Crystal Reports 8.5
• Created DTS Packages using MS SQL Server Enterprise 2005.
• Developed custom applications for label generation utilizing VBA as well as MS Excel Formulas.
• Provided support to users when they needed help utilizing formulas.
• Recommended modifications to business process that saved the company over $1 Million dollars in operating expenses annually.
• Worked with CEO, CIO, COO, and CFO to manage company projects as needed to help reduce costs.
• Collaborated with other members of management on facilities operations when needed.