Manager Data

Michael Aiello, MBA

832-***-**** Missouri City, TX 77459 ******.*********@*****.***

I am a highly accomplished and transformative leader, recognized for my ability to communicate at all business levels from End-User to Senior Management driving organizational process efficiency. I have 25 years of progressive Operations and IT ERP experience spanning military, retail, services, construction and manufacturing industries with a successful track record in ERP Implementations, Application Support and Management, Supply Chain Management and Deployment, Software Development Life Cycle, Project and Program Management, Process Development and Re-Engineering, Audit and Compliance Controls Development, and M&A activities.

Core Competencies

ERP: Systems Evaluation, B2B Recommendation, Training

ERP: Technology Strategy/Roadmap

EBS: Configuration, Upgrade, Implementation

EBS: Direct Team Development, Outsourcing and Managed Services

EBS: Order to Cash, Procure to Pay, Record to Report

Project Management

Process Improvement, Modeling, Master Data Management, Data Governance, Supply Chain

TECHNICAL SKILLS

Methodologies: Waterfall, AGILE, SCRUM

Oracle Modules Supported: AR, AP, PO, FA, GL, PA, OM, BOM, WIP, INV

Modeling/Data Tools: Visio, SmartDraw, Informatica Axon/EDC/DQ, Talend

Office Automation: Excel, Word, Power Point, Scrum-Do, SharePoint, JIRA, Tableau

Languages: SQL, PL/SQL, VB Script

Automated Testing: Oracle Application Testing Suite

ERP Supported: Oracle (10.7, 11.5.10, 12.2.7), JDE, Syspro Impact, OMD, Great Plains

Certifications: Six Sigma (Green Belt), OSHA 10 Hour General Industry Training

Professional Experience

Cornerstone Building Brands – Commercial Division, Houston, TX (2009 – 2020)

Roles Held

Business Process Principal – Evaluate all areas of the Operations and IT process to determine the best strategy for continuous improvement, establish policy and procedures, overhead reduction and establish an MDM and Data Governance model.

ERP Applications Support Manager

Sr Functional Oracle Analyst

ACCOMPLISHMENTS

•Managed P&L, led digital transformation in our commercial group, developed KPI’s for cross organizational alignment, implemented data governance and controls, and participated in ERP strategic roadmap creation

•Created a high performing global team tasked with envisioning, designing, and deploying scalable technology solutions using Oracle Apps across modules such as AR, OM, BOM, WIP, INV, Supply Chain Management.

•Developed a ground up approach to create an MDM and Data Governance implementation plan including a Data Glossary and Catalogue.

•Completed several upgrade and integration projects directly supporting the Supply Chain organization to include process re-engineering for the procurement teams, Transportation/Logistics group, and vendor management teams.

•Performed two Oracle project consolidation efforts and one implementation effort within a two fiscal year period, on time and under budget, while overseeing project management staff, third party System Integrators, and internal resources.

•Leveraged the Informatica Axon/Data Quality tools as an analyst to view and cleanse data in preparation for consolidation into a Data Mart for the company Merger and maintained technical documentation including operations run books, SOP’s, and user guides.

•Used Informatica Axon to administer Standard workflows and change requests. Trained on the use of non-implemented Custom workflows and Data Quality Rules for future rollouts as a dashboard tool.

•Developed cost and revenue conversion programs to systematically run line by line conversion from original operating unit to the consolidated operating unit.

•Participated in a Vertex Q tax series integration

•Worked closely with various System Integrators, IT groups and business users in defining, prioritizing and executing IT operational tasks and acted as the point of contact between the Oracle Development Group and the end user community to interpret requirements for custom reporting in 6i and Oracle Discoverer, ensuring that Developers have adequate clarification and specifications related to integrated third-party applications.

•Sr. Business Analyst (BA) worked collaboratively across our business and IT partners to achieve project objectives, milestones, and deliverables while ensuring the implementation of high-quality solutions. Key areas of focus included the alignment of business processes with the technology solution, conversion of legacy data, system validation, staff development, and training.

•Adept in the creation and presentation the following key requirements artifacts: Track lead project plan, task lists, BR100’s, Use Case documents, Detailed Specification of Key Business Rules, Activity Diagrams, Business Process Mapping Diagrams and Documentation leveraging the Zachman framework, Application Gap analysis, and Training Documents

•OATS – Oracle Automated Testing Suite – Power User

Hire Synergy – Consulting Services - Manufacturing and Construction, Houston, TX (2007 – 2009)

Director of Project Accounting & Procurement

ACCOPLISHMENTS

•Brought in as an analyst to perform an Oracle implementation stabilization in which my contract was extended, and I took over the project’s entry group as a manger. Within a few months I stepped into the role of a director of project accounting and purchasing quality assurance.

•Reorganized the Project Accounting team, established policies and procedures, trained new super users/SME’s, and implemented KPI based metrics reporting to senior management, resulting in a 10% increase in the capacity of the team to complete the order writing process.

•Reorganized the Procurement group to align with key individual skills and segregation of duties between vendor management, supplier contract negation by commodity, and purchasing/receiving clerks. The model reduced overhead, and allowed for increased visibility to open/closed PO management.

•Selected as the project manager to travel to all markets to conduct market level evaluations, training local procurement teams, and market stabilizations from Oracle conversion, resulting in a decrease of initial failure submission rate from 28% to 11% initial failure.

•Developed, streamlined, and documented processes in the following areas: Specialized billing (national account billing), procurement/purchasing, requisitions, project billing, training, Oracle workflow approvals (quality assurance), Oracle Discoverer reporting, metrics, and work authorizations.

•Managed project module data cleansing initiative for Oracle post conversion from QuickBooks.

•Recognized as the only Oracle Super User in both Projects and Purchasing Modules on staff, resulting in employee of the quarter award.

•Participated in EDI (Electronic Data Interface) and Oracle Discoverer implementations, resulting in further development of the company Dashboard, Reporting, and Metrics generation.

Game Crazy/Blockbuster Video – Retail Operations, Houston, TX (2006 – 2007)

Director of Retail Operations

ACCOMPLISHMETS

•Inventory control and audit processes resulting in shrink (loss) under .7%.

•Selected to attend district management development courses by the Regional Manager and assumed the training director status.

•Reductions in labor to match peek business periods and limitations of supplies and consumables, resulting in positive comp. to previous year and record profits for location.

•Leveraged my time in retail to obtain my MBA.

Visual Comfort Inc. – Manufacturing and Accounting, Houston, TX (2005)

Accounting Department Manager

ACCOMPLISHMENTS

1.Developed new SKU’s and coordinated with overseas business partners for product development and rollouts for distribution for an upscale lighting manufacturer.

2.Preformed data analysis on various markets within fine lighting to target higher earnings potential for First-in-First-Out inventory rotations.

3.Preformed cost analysis on new product to determine profitability of overseas versus local manufacturing.

4.Directed all training and employee development within accounting, billing, product development, and purchasing.

5.Integrated new electronic lockbox receivables program limiting loss and misapplications of payments resulting in fewer customer collection issues.

6.Audited and corrected yearly credits for defective and returned merchandise, resulting in reduction of 90-day credit process to 15 days.

7.Realigned the collections group, resulting in 90-day collectables reduced from 9% to 7.3% and bad debt write offs reduction from 1.2% to .9%.

IKON Office Solutions – Operations and Accounting, Houston, TX (2001 – 2004)

Discoverer BI Reporting Analyst

Billing/Invoicing Supervisor

AR Customer Service Specialist

AP Customer Service Specialist

ACCOMPLISHMETS

1.Established and directed the Web based meter team in the Houston CCC prior to Oracle go-live, resulting in standard processes for the corporate initiative to switch customers to web-based meter readings.

2.Designed the Web team and Revenue Support team metrics and reporting packages, to provide a standard measurement and a level of consistency to the evaluation of workflow from nonstandard data sources.

3.Maintained billing regions at 100% billed revenue monthly, resulting in a stronger bottom line.

4.Personally, selected to perform Oracle Stabilization in the Atlanta CCC for the Atlanta Meter team, and reduced outstanding meter collection from twenty-one thousand past due meters to thirteen thousand in two weeks’ time.

5.Nominated as “Leader of the Quarter” in the first quarter fiscal year 2004.

6.Utilized imaging recognition processes reducing the need of offsite storage and eliminating manual processing of payable’s invoices.

US Army – Reserve Houston, TX (1994 – 1997) Active Ft. Polk, LA (1998 – 2000)

NBC NCO

Squad Leader

ACCOMPLISHMETS

•Lateral promotion to Corporal from Specialist to assume duties as full-time squad leader and temporary Platoon Sergeant.

•Direction of Platoon and Company elements up to 52 personnel

•Graduated top 20% of Chemical Operations School, resulting in the receipt of a certificate of achievement and promotion.

K-Bob’s Steakhouse, Services - Brenham, TX (1997 – 1998)

General Manager

Tejas Café and Bar, Services - Brenham, TX (1996 - 1997)

Senior Assistant Manger

Original Pasta Company, Services - Sugar Land, TX (1995 – 1996)

Assistant Manager

EDUCATION

Almeda University-M.B.A.; Management Spec.; 2006, B.A.; Management Spec. 2004 - 2005

Houston Community College, 2002 - 2004 (prerequisites and dual enrollment)

ITT TECH 2000 (A.A.S) (Pre IEEE Engineering prep)

Blinn Junior College, 1996 – 1998 (A.A Transfer Plan)

United States Army, 1994 - 2000 (Chemical Operations School) (Army correspondence courses) 98 hrs Certification, US ARMY Chemical Corps, 1994

William P. Clements H.S., Diploma 1994

Contact this candidate