TECHNICAL SKILLS
BUSINESS SYSTEM SKILLS: NetSuite, Salesforce, Workday, Concur, RevPro, Callidus, Kyriba, SYSPRO, JD Edwards E1, Oracle E - Business, Sage, Microsoft Dynamics GP/AX, Epicor, SAP, Exact MAX/Macola, Intuitive, Expandable, QAD, Zuora, SugarCRM, Cornerstone, Peoplesoft HCM.
DEVELOPMENT SKILLS: SQL Server, T-SQL, SFTP, DDL, DML, UML, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), data warehouse, data mining, data marts, OLAP, Business Objects, Crystal Reports, Jaspersoft Studio, Cognos, Tableau, iDashBoards, ERWIN, Informatica, Taradata, Boomi, XML, SQL, PL/SQL, VB, C#, C++, Visual Studio, VBA, SharePoint, MS Office Suite, Excel VBA, Project, PowerPoint, Visio, HTML / XHLTL / XMS, SFTP, ETL, DDL, DML, UML.
PROFESSIONAL EXPERIENCE
Confidential
Senior Manager of Systems Development and Technology Solutions
Responsibilities:
- Managed Information Technology for Public Sector: planning, architecting, developing, testing, and implementation of IT network and software system solutions.
- Transitioned the California Lifeline Program for the Public Utilities Commission (CPUC) to new Administrator. Managed SOC2 audit, NIST and PCI compliance.
- Developed CPUC custom reports and BI metrics. Served as DBA for over 48 SQL Servers in development, test, and production environments. Managed 36 server decommissions and PII data destruction for CPUC Lifeline program.
- Manage IT vendor relationships, service, and software development deliverables.
Confidential
Senior Systems Architect
Responsibilities:
- Managed and enhanced opportunity-to-cash (OTC), order-to-cash (O2C), procure-to-pay (P2P), and build-to-order (BTO) fulfillment processes.
- Integrated master data between Workday, NetSuite, Arena, Salesforce, Concur, RevPro, and Coupa.
- Developed SQL Server Enterprise Data Warehouse.
- Designed daily, weekly, monthly, and quarterly custom financial and FP&A Excel reports: Bookings, Fulfillment Performance, AP Payments, AP Aging, AR Customer Payments, Billing Schedule Waterfall (subscription invoicing), Accrued Use Taxes, and Cash Analysis. Developed BI metrics and performance based executive dashboards.
- Manage IT vendor relationships, service, and software development deliverables.
Confidential
Business Systems Architect
Responsibilities:
- Implemented and enhanced business processes in ERP, CRM, Ecommerce, Supply Chain ETL/EDI, and Cloud SaaS applications.
- Architected and developed SQL-based SaaS eCommerce product configurator, product module activation code system and product communicator. Developed customer help desk, product notification, and product health reporting systems for engineering group.
- Architected and developed SQL-based SaaS eCommerce product configurator, product module activation code system and product communicator.
- Developed customer help desk, product notification, and product health reporting systems for engineering group.
