Software Developer Business Intelligence

Enrique Calderon

Cell: 305-***-****

Legal Status: US Citizen

Email : ************@*******.***

I am searching for an organization where my skills and technical capabilities would continually expand and help the organization meets and exceeds its goals. I can be an asset to the company.

Professional Summary:

25+ years of IT experience in Data Design and Development on Microsoft SQL Server 2016/2012/2008R2/2008/2005/2000, SQL 7.0, T-SQL, Performance Tuning, Troubleshooting,

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle, DB2, Access to MS SQL Server by using Microsoft Azure tools.

Managing ERP / EDI software’s.

Power BI (Published reports and dashboards).

Generated computed tables in Power BI by using Dax.

EXCEL Advanced skills using Power Pivot with DAX Formulas, Pivot table, etc.

ERP Software Oracle E-Business Suite 12.2

Oracle Cloud Application.

SAP S/4HANA

SAP Cloud Platform Integration (CPI)

IBM Sterling Gentran Server for Microsoft Windows.

IBM Sterling B2B Integrator (B2BI).

Technical Skills

Software: SQL BI, SSIS, SSAS, SSRS, Microsoft SQL Server design and developer, (ETL), Data Warehousing, Transact-SQL (T-SQL), Power BI Desktop, Power Pivot, Advanced Excel, DAX. EDI developer, ERP Admin, Oracle DB, SAP S/4HANA, IBM Sterling Gentran Server for Microsoft Windows, IBM Sterling B2B Integrator (B2BI).

Position: BI and EDI Analyst

Company: Tramontina USA, Inc. Feb/2019 to 07/09/2025

Daily support and maintenance of existing EDI integrations

Using SSRS for EDI projects and Finance Invoices Projects. Also, some reports for Operations and Sales dpt.

Manage the EDI on-boarding of new customers as assigned

Research and resolve internal system issues related to the integrity of EDI transactions

Handle reported issues that may require escalation to software vendor support

Perform application system upgrades as needed

Work with team members to build knowledge of other application systems providing backup assistance when necessary

Perform daily, weekly, and monthly maintenance to ensure proper functionality of systems.

Identify and implement areas in functional business area where improvements can be made to streamline workflow and application flow resulting in measurable savings of time, effort and money

Prepares report (excel / Pivot tables/ Dashboard) summarizing company/customer differences and presents to management for review and approval.

Handles all related processes with new account set up with the company’s 3rd party EDI provider.

Generating daily reports that are crucial for the reconciliation of invoices with customers. This involves analyzing transactional data to ensure accuracy and consistency between our records and customer accounts, assisting in resolving discrepancies promptly. Additionally, I produce the daily inventory report, which is essential for updating and maintaining the client portal. This report provides real-time visibility into stock levels, ensuring that clients have up-to-date information, which facilitates better inventory management and enhances customer satisfaction. This process not only supports financial accuracy but also optimizes transparency and efficiency within our supply chain operations

Working on the migration of the Oracle EBS System to the Oracle Cloud App version.

Working on the migration of the Oracle Cloud App version to SAP S/4HANA.

Develop the necessary reports using Oracle BI Tools reports to facilitate data migration from Oracle Fusion to Microsoft Azure SQL. This includes designing comprehensive extraction and validation reports to ensure data accuracy and completeness throughout the migration process. Additionally, leverage Azure tools such as Azure Data Factory, Azure Data Share, and other relevant services to automate data transfer, support seamless integration, and achieve efficient data utilization in the Azure cloud environment.

Create several Power BI projects to visualize the migrated data in Azure, tailored to different departments within the organization. These projects involve designing interactive dashboards and reports that provide relevant insights, facilitate data-driven decision-making, and improve operational efficiency across departments such as Sales, Inventory, Finance, and Operations. Proper visualization helps departments access key information quickly and supports strategic planning.

Working on the migration of the IBM Sterling Gentran Server for Microsoft Windows to IBM Sterling B2B Integrator (B2BI).

Managing daily all inbound and outbound issues that arise in SAP. This includes promptly identifying, troubleshooting, and resolving system problems related to data exchanges, order processing, and transaction flows to ensure smooth operations and minimize disruptions in the supply chain and financial processes.

Creating and maintaining all information related to Partner Profiles in SAP. This involves setting up, updating, and managing partner data to ensure accurate and efficient communication and transaction processing with vendors, customers, and other stakeholders. Proper management of partner profiles is essential for seamless EDI integrations, order management, and overall supply chain coordination.

Working closely with the Order Management, Sales, Accounting, Operations, Inventory, and other departments to provide all necessary reports and support required for the optimal functioning of the company. This collaborative approach ensures that each department has accurate and timely information, facilitating better decision-making, streamlining processes, and enhancing overall operational efficiency.

Daily review of all issues escalated in CPI (Cloud Platform Integration) EDI Portal of the SAP. This involves monitoring and analyzing reported problems to identify root causes, prioritize fixes, and coordinate with technical teams to resolve issues promptly. The goal is to ensure continuous system availability, accurate data exchanges, and minimal disruptions to the company's EDI processes.

Managing all aspects related to clients within the B2BI application. This includes overseeing client profiles, configuring and maintaining EDI communication settings, mapping, monitoring transaction flows, and ensuring seamless integration between the system and trading partners. Proper management in B2BI is critical for ensuring accurate and secure electronic data exchanges, supporting efficient supply chain operations, and maintaining strong customer relationships.

Position: ERP/EDI Analyst and Business Intelligent Developer

Company: CENA, LLC Jun/2015 to Jan/2019

Communicating design and other technical information both verbally and in written format

Perform Data profiling and analysis of structured and unstructured data

Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals

Create Dimensional models using ERWIN or other data modeling tools

Worked with installing, designing and managing MS SQL Server 2012

Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.

Created SSIS packages to populate data from various data sources like Oracle, DB2, CSV, TXT, SQL, WEB and OLEDB to SQL Server. .

Application Maintenance .Net

Take care of all reports using SSRS and Crystal Report for Account Receivables, Account Payables, Operations, Sales, and Logistic Departments

EPICOR ERP Database (creating multiple queries, SP, View, etc [SQL Server 2008 & 2012]) in order to develop reports, and fix all EDI errors.

Ensure that a business is able to perform business transactions with other companies using electronic channels.

Take care of the ERP system called Epicor, (9.05 version) which deals with different kind of EDI documents like 810, 812,816, 820, 824, 846, 850, 855, 856, 860, 864, 870, and 997 among others.

Set up for new customers coordinating between them, the Epicor company and our third party called Tie Kinetix

Monitoring the electronic transactions on daily basis and solve any problems.

Take care of Network, Security, Help Desk and Phone System Issues.

Cabling and installing Network/CCTV.

Computer Repair, Installation, Configuration and other issues.

After August 2017 I started introducing Power BI desktop.

Imported data from SQL Server and excel tables to Power BI to generate reports.

Created Dax Queries to generated computed columns in Power BI.

Generated computed tables in Power BI by using Dax.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

Explore data in a Variety of ways and across multiple visualizations using Power BI

Used Power BI Gateways to keep the dashboards and reports up to date.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

Position: Business Applic. Consultant and SQL/ Report Developer

Company: Kompuservice, LLC Aug/2010 – May 2015

Follows change management process to resolve application defects or to implement development enhancements

Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work

Developing data links and data loading scripts, including data transformations, reconciliations and accuracies

Have advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing

Designing BI solutions with Microsoft SQL Server 2008 / 2008 R2 / 2012

Building state-of-art reports that deliver information in a user-friendly and efficient way

Querying Microsoft SQL Server 2008 / 2008 R2 / 2012

Looking for root causes in case of solution failures

Creating ETL packages using SSIS, SSAS

Report developer using SSRS and Crystal Report.

Using Visual Studio 2012 to handle the BI.

Software Consulting, Maintenance & Troubleshooting (Delphi application)

Database developer and maintenance (creating multiple queries, SP, View, etc [SQL Server 2008 & 2012])

Cabling and installing Network/CCTV.

Computer Repair, Installation, Configuration and other issues.

Position: Business Applic. Developer and SQL/ Report Developer

Company: Datapro, Inc, Miami, FL Jan/2006 – Aug/2010

Design Database using Start Schemas for Datawarehousing and Datamarts

Create Projects using SSIS component for ETL jobs

Create Olap models for every business process using SSAS component

Create Reports using SSRS component

I am in charge of all the Crystal Report and Crystal Clear for the program mentioned above using ODBC and JDBC for

connection to database server (Oracle, SQL 2000, 2005 & 2008, DB2, T-SQL).

I am in charge of developing in Delphi for the International Letters of Credit and Collection using ADO as the linker

and MS SQL as the database server (2000 and 2005) also developing SQL Query, View, SP, function, etc

Position: IT-P/C & Network Support

Company: TerraBank, Miami, FL Oct/2001 – Dec/2005

Provide sensitive technical support with strict deadlines to busy and energetic financial institution

Repair, configure and resolve all PC issues and performed continuous system maintenance and upgrades

Ensuring proper functionality, security and configuration of server

Responsible for installation, configuration and staff training on telephone system

Worked closely with procurement and supply on proposals and evaluations for upgrades and security

Assistance with in-house helpdesk, providing technical support by phone and in person to staff

Handled inventory, supply and merchandising of IT peripherals and technical components

Cabling and installing Network/CCTV.

Education

BS in Computer Science

University of Havana, Havana, Cuba 1989-1995

Homologated, Tallahassee, Florida, USA 2013

Certificates of Completion in A+, Network + 2004

PC Proffesor School, Miami, FL. USA

Power BI Training

Computrain, Houston, TX. USA 2022

Contact this candidate