SUMMARY:

• Self - starter, goal-oriented team player, aggressive Technical and Business problem solver
• Passionate about building state-of-the-art Data Warehouse and Business Applications
• 14 years Business Systems Development including Accounting/Financials, ERP, MRP and WMS
• 10 years Data Analyst / Architect / DBA including SQL/T-SQL Query Optimization, Indexing Strategies (including Indexed Views and Column Store), Tabular In-Memory Model, Logical / Physical Data Modeling, Data Mapping, DB / DW Design, Implementation, Administration, ETL and Data Integration
• 9 years Oracle Developer utilizing SQL, Query Optimization, Indexing Strategies, PL/SQL, SQL*Plus Reports, SQL*Loader (ETL), DW Builder (ETL), SQL*DBA, SQL*Forms, Oracle Application Server and Oracle CASE tools
• 8 years Business Analyst including Project Lead and Quality Assurance utilizing Waterfall and Agile SDLC, Use Case Scenarios, Logical Design and Process Modeling, Project Management, Supply Chain Management, V-Model Test Planning and RCS
• 5 years BI Reporting including Web Analytics, Churn Analysis, Predictive Media Analysis, Job Cost vs. Profit
• 5 years ERP Implementations, Customization, Defect Management, Account Reconciliation, Process / Procedure Analysis, QA Testing and Documentation involving the following modules: GL / AR / AP / PR / PO / FA / OM / QE / WIP / SFM / BOM / MRP / IM / PIM / SCM
• ERP / WMS Applications: MS Dynamics AX (SQL Server), MILES (Sybase), MAI Financials (Sybase), ALCIE (Oracle), FourGen (Informix) and custom ERP applications
• 3 years WMS Applications Development, Defect Management, QA testing, Process / Procedure Analysis and Documentation including RF receiving, RAs, Cycle Counting, Directed Putaway, Directed Picking, Packing, Inventory Management, Logistics and Shipping
• Team Lead for WMS Defect Management and Quality Assurance
• On-site WMS training at large high-volume warehouse / distribution center.
• Completed design / architecture review of large Travel Reservations System (Sybase)
• Formulated use case scenarios using SOA design concepts to automate accrual and deferral adjustments in MAI accounting software
• Mapped and documented MAI accounting interfaces to front end Travel Reservation System
• Customized ERP software (FourGen) to include Cost Accounting functionality and reporting
• 3 years Web development including UI / UX design
• Senior level technical, analytical, organizational and communication skills (verbal and written)
• Excellent interpersonal, leadership and team building skills

CORE COMPETENCIES:

• MS VS / SSDT / SSMS / SSIS / SSAS
• Crystal Reports, MS Power BI
• MS Excel / Project / Visio
• Oracle 12c / Warehouse Builder / SQL*Loader
• Oracle App Server / Business Objects API
• ERwin (9.6), Informatica (v10)
• Informix Forms / ACE Report Writer (6.0)
• ERP: MS Dynamics AX / NAV (SQL Server), MAI Financials (Sybase), ALCIE (Oracle), FourGen (Informix)
• WMS: Accellos (SQL Server), MILES (Sybase)

TECHNICAL SKILLS:

• SQL / T-SQL
• PL/SQL (11g)
• C / C++ / Oracle Pro*C
• Sybase 4GL
• Unix / Linux Shell Script
• Informix 4GL
• VB, VBA, VBScript
• HTML, XML, CSS
• JavaScript, PHP
• MS Windows / WNT (3.0 thru 10)
• Unix System V, 95, 98, AIX
• Linux 2.2, 3.0
• Oracle (12c)
• MS SQL Server
• MS Access
• Sybase ASE (12.0)
• Informix (12.1)

PROFESSIONAL EXPERIENCE:

Data / Systems Analyst

Confidential, Montrose, CA

Responsibilities:

• DB / DW / ERP Systems Development utilizing ERwin 9.6, SSMS / T-SQL / SSDT / SSIS / SSAS 2016, Oracle 12c, PL/SQL 11g, Informatica Power Center / IDQ, MDM / IDD and XML
• Created and modified complex accounting reports and dashboards utilizing T-SQL, SAP Crystal Reports, MS Dynamics AX, MS Excel and MS Power BI
• Completed analysis and documentation of MS Dynamics AX ERP system implementation, technical / functional processes, business procedures, tables and data for the following modules: GL, AR, AP, IM, PIM (Product Information Management) and SM (Sales & Marketing)
• Completed functional analysis of Accellos WMS implementation, system workflows, integration with MS Dynamics AX, APIs, RDC, Network Connect (VPN) and company shared file systems
• Completed MCSA certification for SS DBA, Data Warehouse Implementation and Business Intelligence (06/2017).
• Gained familiarity with SAS, Teradata, MongoDB, Cassandra, Java, VB.NET, JSON and SAP Data Migration

Data Analyst / Manager

Confidential, Montrose, CA

Responsibilities:

• IT projects included Data Analysis, Data Modeling and DW Development utilizing ERwin(9.6), Oracle(12c), PL/SQL(11g) and Informix(12.1).
• Gained familiarity with Collibra (Data Governance), MySQL, PostgreSQL and Hadoop
• Implemented MS Project, GitHub and completed Business Process Modeling using MS Visio
• Completed Accounting Implementation utilizing Quickbooks Pro and MS Excel 2014
• Implemented and maintained SEO, Web Analytics, Social Media and Email Marketing
• Business planning, contracts, implementation, hiring, marketing and customer service
• Managed several contracted instructors, class scheduling and event planning
• Taught beginner Tai Chi classes 1-2 times per week

Website Designer/Marketer

Confidential, Montrose, CA

Responsibilities:

• Provided custom website design / development using Wordpress, HTML, CSS, PHP, Laravel and JavaScript
• Provided internet marketing / reporting for client and in-house projects using SEO, Web Analytics and MS Excel
• Internet marketing utilizing loopnet.com and internet ad campaigns which resulted in the sale of two real estate properties

Sr. Information Systems Analyst

Confidential, Pasadena, CA

Responsibilities:

• DW design, modeling, development, ETL and QA testing to integrate multiple new data sources into Enterprise Data Warehouse using Oracle Warehouse Builder, Oracle SQL*Loader, PL/SQL, SQL and Unix shell scripting. Also gained familiarity with Informatica ETL tool.
• ETL analysis, design and code for flat, Excel and XML source data validation, profiling, cleansing, sorting and aggregation in accord with DW constraints and user requirements.
• Project lead for broadband reporting utilizing Crystal Reports, PL/SQL, SQL*Plus and MS Excel

Software Engineer

Confidential, Los Angeles, CA

Responsibilities:

• Responsible for UI/UX design and development of Online Merchant Application System to streamline processing of merchant applications for credit card processing
• Utilizing HTML, Visual C++, PHP, JavaScript and Oracle Business Objects API

Sr. Oracle Programmer/Analyst

Confidential, Burbank, CA

Responsibilities:

• Completed analysis, design, specs, coding, QA testing and reporting for business applications including Warner Home Video, Marketing Compliance, B2B, Order Status and Sales Programs
• Completed gap analysis and interface design for migration of Demand Replenishment and Order to Cash legacy systems to Oracle database applications
• Utilizing PL/SQL, Oracle WebServer, HTML, XML, CSS, JavaScript and MS Excel

Sr. WMS Programmer/Analyst

Confidential, El Segundo, CA

Responsibilities:

• Team lead for WMS bug fix resolution and Quality Assurance
• Projects included database analysis, spec writing, QA testing, SQL, C language and Sybase stored procedure coding and MS Excel report generation
• Custom development of MILES ( Confidential Integrated Logistics Efficiency System) network of WMS systems for high volume warehousing and distribution of computer products
• On-site WMS training at large Chicago warehouse included RF device receiving inventory and RAs, cycle counting, directed put away, picking and packing, Inventory Management, Shipping and Logistics

Oracle DBA

Confidential, Chatsworth, CA

Responsibilities:

• Oracle database administration utilizing SQL*DBA, SQL, DDL, DML, DCL
• Report generation utilizing SQL, PL/SQL, SQL*PLUS, MS Excel and Unix shell scripting

Oracle/C Programmer / CAD Analyst

Confidential, Pasadena, CA

Responsibilities:

• Analysis, enhancements and QA testing of CAD Accounting and Reporting System which provided daily ETL to Oracle
• Using C, Oracle Pro*C, UNIX/Linux shell script, VBScript and RCS revision control
• Completed code review and documentation of circa 20,000 lines of ANSI C code
• Assisted with network administration and migration of Unix client/server architecture to Windows NT

Sr. Database Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Completed design review of large Sybase reservations system as Confidential consultant to AmericanTours International (ATI) utilizing ERwin Data Modeler
• Subsequently hired by ATI as Project Lead to customize and implement MAI accounting software and to design APIs for integration with their Travel Reservations System
• Techno-Functional project lead for QA testing, debugging and enhancements to Oracle ERP/Accounting software (ALCIE) using PL/SQL and Oracle CASE tools

Oracle/ERP Programmer/Analyst

Confidential, Southfield, MI

Responsibilities:

• Business applications / DB development, ETL and QA testing utilizing SDLC and Agile methods, SQL*Loader, V-Model testing, Oracle Forms, Pro*C, PL/1, UNIX shell scripting, RCS revision control and MS Excel
• ERP applications: Quoting & Estimating, Inventory and Purchase Order systems for Ford Motor Company, Employee Time and Attendance System for Stroh Brewery

Informix/ERP Programmer/Analyst

Confidential, Southfield, MI

Responsibilities:

• Data analysis, database modeling and database design utilizing Informix RDBMS and Informix tools
• Corrected database design, architecture and bad data
• Customized FourGen ERP / Accounting software to include Job Cost information in Sales Journal reports utilizing Informix-4GL
• Created Custom CRM (Customer, Sales and Order/Job Tracking) application utilizing Informix Forms and Informix Reports
• Created predictive analysis reports as basis for electronic media (radio/TV) ad campaigns and ongoing contract negotiations utilizing AOM II Plus spreadsheet
• Tech Support, Informix DBA and Unix OS administration