SUMMARY:

• NetSuite Architect / Administrator, BI Developer with more than 15 years of extensive experience in diverse technologies, focused on the design, implement, and maintain configurations and customizations of NetSuite and the design of BI applications/solutions and database. Core knowledge in SQL, Power BI, Tableau, Google Data Studio, .Net Technology and ETL developing processes.
• Upstanding record of professional and personal achievements. Strong leadership; The “go - to” person that serves as the bridge between the organization's goals and available technologies.

TECHNICAL SKILLS:

ERP, MRP: ACCPAC ERP, MISYS MRP.

Business Intelligent tools: MS Excel, Power Query, MS Power BI, Tableau, Google Data Studio, SQL Server Data Tools - Business Intelligence (SSDT-BI), SSIS, SSRS.

Database: Azure SQL database, MS SQL Server (2000, 2008, 2017), MYSQL (5.6 / 5.7), Pervasive.SQL 8.

EDI, ( Electronic Data Interchange): X12 (997, 810,850,855,856), Vendor Management, (SPS Commerce, GCommerce, virtuallogics, Process and solutions creation, Van configuration and management.

Frameworks & API’s: .NET, SuiteScript 1.0 / 2.0, Node.js.

Programing Languages: T-SQL, ANSI-SQL, C#, HTML, Java Script, PowerShell.

Operating Systems: MS Windows (XP, 7, 10), MS Windows Servers, (NT, 2000, 2008, 2012), Mac OS, Linux.

IDE, Code Editor,: MS Visual Studio, Sublime Text

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

NetSuite Architect / Administrator, BI Developer

• A vital member of the NetSuite ERP, implementation Team; helping with the import data processes, (import CSV), the production of multiples, NetSuite ERP reports & Saved Searches, Workflows, (SuiteFlow), the recreation of legacy reports within NetSuite ERP. Further the distribution of data with Trading Partners, Auditors, and Vendors using ETL and SSIS processes.
• Responsible for insight and guidance on how to leverage out-of-the-box NetSuite solutions, as well as when to customize.
• Responsible for Troubleshoots errors and day-to-day system issues as they emerge
• Responsible for the designs configures and published of new (and updates to) key performance Indicators (KPI's), dashboards, searches, reports, custom records, roles and permissions, menus, forms, lists, and fields.
• In charge of Developing and maintains Workflows, (SuiteFlow), and processes in NetSuite to help streamline key business functions and deliverables.
• Lead and assists in the migration of data from legacy applications and other sources into NetSuite using import and mass update tools.
• Guide the development and architecture of information integration between NetSuite and other applications and provides customer support for existing integrations.
• Guide users on how to personalize profile preferences, portlets, and dashboards.
• Assists in the creation of documentation of NetSuite processes, procedures and training material
• Work with application support staff to assist users in performing daily functions using NetSuite and other applications.
• Manage release preview and business process testing for ongoing upgrades.
• Maintain proper system access for all users and roles.
• Primary support contact for cases that are submitted to NetSuite on behalf of users and facilitates case submittal through resolution process.
• Work with business stakeholders to analyze the needs of the business and support their optimized use of Net S uite.
• Responsible for all ETL initiatives (Extract, Transform and Load); Including Reports creation and Data exchange, (Auditors, Vendors, and Trading Partners).
• Created stored procedures and SQL queries to pull data into power pivot model.
• Create DAX functions in Power BI.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Responsible for the implementation and manage all EDI, (Electronic Data Interchange) initiatives. Including Vendor Management, NetSuite ERP integration, and solutions development using EDI standards (including X12, EDIFACT).
• Built custom logic to integrate Confidential data to SPS Commerce.
• Responsible for developing, test and deploy customizations, custom objects, and new functionality based on evolving business needs.
• Develop and create customized reports and dashboards for designated users and roles.
• Maintain user access, roles, and rights for external vendors.
• Create and maintain documentation of the system and business processes.
• Responsible for implementation of The Microsoft 365 Exchange, (email) Project for all CPS Companies.

Confidential, Hialeah, FL

Global Technology Manager

• Responsible for establishing and aligned all technology resources to develop an information technology strategy that supports the organization ’s objectives and helps build a definite competitive advantage; Including, (Planning, Networking, Data Management, Security and Sup- port).
• Responsible for the design and implementation of multiples Projects; Including, Microsoft Exchange Online, (365) and the deployment of networks with the capability to carry voice, data, and video. (Cisco SF 300 Switches, Router 2800 Series, Firewall ASA 5505), IP Phones, iPhone/Android Devices.)
• Responsible for the developing of tools to collect, store, manage, secure and distribute data; Including the creation of multiples, reports, the maintenance of legacy reports using Crystal Reports, the production of external databases. Further, the migrations of reports to SSRS, the distribution of data with Trading Partners, Auditors, and Vendors, harnessing ETL and SSIS processes.
• Responsible for securing all technology resources, putting stringent security policies in place to minimize the risk and impact of security breaches; Including Backup strategies, hardware security, Data access policies, and Network protocols.
• Responsible for the support, enabling employees and business executives to make the most effective use of technology resources.
• Additional Timeline available on-request.