Data Engineer - Bi And Performance Assurance Resume
Orlando, FL
SUMMARY:
- Highly accomplished, analytical, and dedicated professional with over 19 years of experience designing and implementing process improvements to streamline business operations and drive long - term growth.
- Uniquely skilled in all aspects of IT across multiple industries, including retail, manufacturing, engineering, and customer support.
- Able to seamlessly translate conceptual ideas into actionable business processes that improve system efficiency and productivity.
- Collaborates with cross-functional teams to ensure delivery of project objectives.
- Fully bilingual in English and Spanish.
AREAS OF EXPERTISE:
- Business Intelligence SQL/T - SQL Reporting Analytics Data Mining System Analysis / Design
- Data Collection / Analysis Software Development Cross-Functional Collaboration ServiceMax
- Programming Customer / Product Support Engineering Solutions Quality Improvement Databases
TECHNICAL SKILLS:
Business Intelligence, reporting, databases, advanced Access 2003/2013, Advanced VBA/Macros (Excel, Access, Excel-Access Automation and Integration), SQL Server 2008-2014 (SQL, SSRS, SSIS, SSAS), ServiceMax, Tableau, Oracle, Salesforce, SAP, Visual Basic 6/2005, NET 3.5, Granta MI, LINUX, Windows XP - 10/Server 2003 to 2008, Office 2003 - 2016.
PROFESSIONAL EXPERIENCE:
Confidential, Orlando, FL
Data Engineer - BI and Performance Assurance
Responsibilities:
- Used tools such as SQL Server, T-SQL, SSIS, Tableau, ServiceMax, Access, Excel, and others to create Dashboards, data, and databases that streamline and automate solutions.
- Provided recommendations on data and IT process improvements, including the use of Analytics, BI, and data-driven solutions. Provided technical expertise and advice on integration of tools and data sources.
- Lead implementation of ServiceMax in Confidential Canada. Provided support, managed milestones, deadlines, worked with development team on system enhancements that saved time and enhanced productivity of service teams. Implemented ServiceMax usage Tableau dashboard used by management to asses system usage.
Confidential, Aguadilla, PR
Engineer Sr. Product Support - Platform Performance Analytics Administrator/Analyst
Responsibilities:
- Provided key support to day-to-day business operations in multiple capacities, including data mining, analysis, and validation.
- Develop automated data collection, cleansing, and reporting.
- Deliver recommendations on improving business intelligence tools to enhance customer and product support protocols.
- Selected by management team to participate in Engineering and IT development activities related to PPA automation solutions.
- Utilized SAP, Business Objects, Salesforce.com, SQL Server, Excel, and Access to source and collect data.
- Designed and created reports, visualizations and dashboards using Excel, Access, SQL, and Tableau.
- Created Tableau dashboard showing Work Allocation/Assignments of personnel by date/site.
Confidential
Microsoft Business Intelligence Developer
Responsibilities:
- Experience in MS SQL Server 2000 - 2012 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services.
- Good experience to integrate multiple data sources including but not limited to multiple RDBMS (SQL Server, DB2, Oracle), flat files (csv, excel, dat and xml)
- Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency. Strong experience in client interaction and understanding business applications, data mining, data flow and data relations.
- Created & formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports
Confidential, Aguadilla, PR
Engineer
Responsibilities:
- Direct involvement in Puerto Rico Database & Information Systems projects, such as ESM, ECT, REACH tools; developed data interfaces and utilized Excel, Access, SQL Server to automate data collection processes.
- Facilitated multi-source data query, analysis, and collection and ensuing upload to company tools/databases.
- Primary M&PE IT point-of-contact; instrumental in improving infrastructure hardware, software, and processes to maximize productivity and performance of M&PE applications.
- Served as a Granta MI (n-tier Information System used by engineering to work with materials data) Support Engineer charged with installing and upgrading system software, databases, and websites.
- Used multiple tools such as Access, Excel, VBA, Oracle, SQL Server, C#2008 & .NET 3.5, Visual BASIC 6/2005.