​​​​Oswaldo Dimas​

Reporting Analyst

Assurant - Lewisville, TX

June 2019 - Present

​

• Develop and analyze Assurant complex data environment; use analytical tools and languages such as PL/SQL, T-SQL, or DAX, to visualize and communicate results using dashboarding tools such as Tableau and Power BI.

• Performed data mining and analysis to facilitate the identification and communication of outliers and trends in the business.

• Performed descriptive, statistical, and text analytics to test if the business is meeting its operational, financial, and regulatory requirements and benchmarks. 

• Design and execute standalone Data Analytics audit projects as warranted in support of department objectives.

• Assist auditors in obtaining necessary data for audits.  Identify, develop, and maintain continuous auditing/monitoring activities.

• Provide additional support on audits and Ad-hoc reporting when necessary.

​

Server Capacity Analyst

PepsiCo - Frisco, TX

February 2017 - June 2019

 

• Monitor storage usage levels and data growth patterns to identify future storage needs in advance to allow procurement and implementation of storage-related systems prior to impacting production servers

• Working on multiple tactical projects for trading. Create Excel VBA prototypes and small-scale applications

• Responsible for maintaining and enhancing custom MS Excel reporting solutions for UNIX platform.

• Develop queries in MS Access, Excel and SQL.

• Design and produce threshold settings to identify servers and virtual machines.

• Measure overall performance and identify server and machine insufficiencies. 

• Supported technical staff ad hoc projects i.e. tables, graphs, data presentations, etc.

• Design reports in the Visual Studio development environment and Microsoft Excel

• Develop Applications for Excel Reports through VBA

.

Pricing Manager/Senior Solutions Engineer

XPO Logistics - Frisco, TX

June 2015 - December 2016

 

• Provided network support with development and processed automation by creating, troubleshooting, and maintaining new and existing database applications within MS Access, MS SQL, and various front-end user interfaces.

• Designed efficient data collection techniques that compiled data into simple and understandable formats such as reports, dashboards, tables, graphs, and pivot tables.

• Developed an understanding of applicable data sources and data relationships.

• Wrote moderate to complex queries across various databases and reports using VBA, advanced MS Excel, MS Access functions, and SQL.

• Worked with management and subject matter experts to help define reporting requirements.

• Identified opportunities, to develop standardized reports for repeated data requests and     worked with Corporate IT to implement automation solutions

.

Senior Pricing Analyst

Mode Transportation - Dallas, TX

January 2006 - June 2015

 

• Used analytical methods and a variety of tools such as Microsoft Excel & Access to understand pricing and control logistics operations.

• Responsibilities were to develop and maintain an Access database that will distribute RFP's & collect feedback while maintaining a relationship with the company’s carrier network and utilizing VBA scripts to create weekly performance reports.

• Developed several VBA programs to export and import data to and from external systems like the Department of Energy (D.O.E).

• Provided automated meaningful analysis with charts in Microsoft Excel to Mode Transportation’s independent business owners.

• Developed Access/VBA programs to convert Excel data into XML format and fed to the Web Development team.

• Also provided daily and monthly P&L report generation; Enhanced various periodic reports that were developed using Excel, Macros, VBA, Access, and within the framework of the management team’s goals and standards to resolve issues.

• Interacted with multiple levels and functions within the logistics organization.

• Provided project support and analysis for pricing initiative, scoped future enhancements and requirements. Ensured delivery execution team had relevant and effective training materials to manage program and improve performance of deliveries