SUMMARY:

• Innovative and decisive Manager with fortune 500 experience, seeking a role and strategy and architecture.
• Experienced in DWBI & Data Lake solutions, Enterprise Modeling, Cloud architecture, Agile/Scrum methodology, E - Commerce, Supply Chain & WMS operations, Financial Systems, Resource & Product management, and ERP-WMS integrations.
• Excellent leadership in managing budgets, projects and blended staffing models.

TECHNICAL SKILLS:

ERP: Oracle EBS, SAP ECC, JD Edwards, PeopleSoft, Baan.

WMS: MOVE, EXE, Red Prairie, Sterling, Advantage, Manhattan WMoS, PKMS, QAD, Error Proof, Deltek.

Database: Oracle, Teradata, DB2, Informix, SQL Server, Sybase, ExaData.

Analytics: OBIEE,OBIA, SAP HANA, Cognos, BO, Hyperion, Essbase, Oracle Cloud, Exalytics, Golden Gate, Hadoop, AWS, Azure.

Methodologies: AGILE, SCRUM, TOGAF, DODAF, Six Sigma, SDLC, AIM, RICE, Express, Waterfall.

EA Tools: VISIO, ERWIN, TOAD, SOFTWARE AG, ARIS, PLANVIEW, Oracle BPEL

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

MANAGER

Responsibilities:

• PMO oversight and $150 million Supply Chain IT infrastructure separation for JCI spin-off of Adient globally with an emphasis on Process, Architecture, Big Data Governance, Risk Mitigation, KPIs and Financial Controls.
• Solution architect for TDS Telecomm Revenue Recognition project $56 Million budget managing requirements and expectations of VP Finance, Accounting, Systems Dev, QA, Data Lake and Architecture departments.
• PM for SAP-HANA and BO reporting deployment for $ 3 million Deltek Federal Financial Data. 450+ tickets resolved in 3 month timeframe for 7 BO universes for Finance, Accounting, Supply chain Departments.
• PM for GM Auto manufacturing Audit trace to investigate 5.6 million automobile recall. Deep dive analytics and reverse data trace for GRC and operational practices in Oracle & Hadoop HDFS systems.
• PM for ADS BI Big Data reporting for Financial, Supply Chain, Order Management, & Procurement and Spend analytics and unstructured data feeds Oracle ExaData and Azure.
• Managed resources, staffing needs, coaching, and mentoring with constructive feedback.
• Managed Onshore, Offshore and Client Business teams for Oracle, PSoft and SAP platforms implementations.
• Managed performance tuning initiatives with Oracle resources for OBIEE, ODI and Exalytics X10 with PS 9.1.
• Devised and managed DB/DWH and BI strategy with Golden Gate for Real-Time leveraging ExaData machine.
• Managed Design and deployment of Data Lake solutions for Structured and non-Structure data solutions on Hadoop and HDFS systems.

Confidential, Chicago, IL

MANAGER

Responsibilities:

• Managed staff, on boarding, performance appraisals, coaching and mentoring resources.
• Prepared RFI, Data Lake Architecture assessment, Proposal, Resource & Cost Estimates, Technology roadmap, and SOW for client projects with key focus on Big Data, risk, cost and business drivers.
• Managed Onshore, Offshore and Client Business teams for collection of RICE artifacts for JDE and OBIEE implementations for Financial, Supply Chain, Order Management, & Procurement and Spend processes.
• Managed deployment, design and tuning of Analytical reporting Solutions on JDE 9.1, Oracle, and PSoft platforms leveraging Golden Gate replication, Real-Time, ExaData and Exalytics X10 in memory machine as applicable.
• Directed and managed improvements to architecture layers of the BU, to support strategic and operational goals.
• Client Engagement to help articulate Data Lake solutions, Architecture sizing, Data governance, and Big Data Reporting Framework based on Hadoop, AWS and Oracle’s Smart View technology.
• Supported Verizon Business, IT leadership and BI architects in the Design, Development and Deployment phases Data Lake and Analytics solutions.
• Support Confidential ’s Solution & Business Architect with Hadoop, HDFS systems, OBIEE, Essbase, Oracle application capabilities, infrastructure design and knowledge transfer.
• Managed current, target and transient architecture design and deployment strategy with a focus on service delivery, high operational value and leveraging Big Data platforms AWS and Azure.

Confidential, Chicago, IL

MANAGER SUPPLY CHAIN SOLUTIONS

Responsibilities:

• Managed and completed Technical Architecture and Gap Analysis for McDonalds Happy Meal Supply Chain upgrade for Manujistics, Oracle EBS and Oracle Database according to KPIs and business drivers.
• Enumerated, analyzed, cataloged, and suggested improvements to the strategic, and core processes of the BU, to support strategic and operational goals of Business Units at Kohls, Delta Airlines and Office Depot.
• Preparation of RFQ, RFI, SLA, Proposals, Resource & Cost Estimates, Technology roadmap, infrastructure design for OM, WMS, TMS upgrades and implementations for Retail and E-Commerce client DC’s at KOHLS, Anheuser-Busch, and Office Depot, and Delta Airlines.
• Performed sizing strategies for WMS/TMS software, Distribution Centers, Supply Chain KPI’s and metrics and 3PL vendors selection for client requirements.
• Developed and supported the implementation of product, supplier and supply chain strategies during the early NPI stages. Focus on product design for supply chain, installation and serviceability.
• Managed Project timelines, Gap analysis, Change control, Scope creep, estimates and workloads for all SDLC phases of multiple BI/DW projects and deliverables at Chicago Metra and IRWD.
• Lead a team of ETL developers, OBI developers, Business analysts, data modelers to design new Data Warehouses for the ERP systems and identified various strategies for architecture, performance tuning and ETL.
• Performed architecture and infrastructure assessment with focus on Process re-design, disaster recovery, high availability, scalability, cost and risk mitigation.

Confidential, Warrenville/Belvedere, IL

SUPPLY CHAIN DATA ARCHITECT

Responsibilities:

• Managed Project timelines, Business process modeling, Gap analysis, Change control, Scope creep, estimates and workloads for all SDLC phases of WMS, ERP & BI/DW projects and deliverables.
• Successful technical and Operational setup, training and implementation of Physical Inventory, Cycle Counting, Active RFID with Error Proof WMS at Belvedere PDC.
• Successfully lead in Military compliance & certification for DOD and WMS integration of Electronic and paper DD250, WAWF Invoices, SAVI tags and IUID serials.
• Trained WMS staff on WAWF process for DC operations on Direct Ship, MRAP and TACOM military orders.
• Technical interface design for data migration from PSOFT/Demantra/EBS to OBI & EDW (TeraData).
• Led a team of ETL developers, data architects, Business analysts, data modelers to design a new Data Warehouse for the ERP systems and identified various strategies for architecture, performance tuning and ETL.
• Managed and lead resources for OBIEE reporting design and deployment on Oracle platform.
• Successfully managed deployment of BI Apps, DAC, Informatica and OBIEE RPD’s.
• Managed Deployment of APSR Sourcing Engine (PL/SQL) for Legacy data feeds to Oracle Demantra Analytical Engine, ASCP/IO, EBS and I-Supplier. Designed Oracle and Teradata logical and physical models.

Confidential, Hoffman Estates, IL

LEAD ORACLE ARCHITECT

Responsibilities:

• Provided Senior Managers inputs to policy level discussions for data and DWH design and development standards.
• Consulted with NIS teams (Web, Development, DBA, Field Engineers, and Vendor) to coordinate activities.
• Prepared activity and progress reports regarding information systems operations for upper management.
• Led team efforts to ensure successful completion of Enterprise architecture modeling and Data Integrity resolution issues.
• Provided project updates to senior management and NIS Director for Database security policy and procedures.
• Responsible for trouble shooting, analysis, resolution and new development of all ETL for 85 Terabyte DWH.
• Group leader for Tier 3 analysts to manage and trouble shoot ETL across Oracle and SQL Server Databases.
• Excellent performance tuning for ETL loads and data migration scripts on PL/SQL, T-SQL, Perl and Korn shell scripts. Team Lead responsible for development and promotion of Oracle 9i/10g DB objects.
• Responsible for timely KPI metrics, counters, RTB, E911, Voice, VD, SS7, Trunk data loads for Telecomm clients.
• Responsible for interviewing various candidates to calibrate there suitability for NIS group.

Confidential, Alpharetta, GA

LEAD SUPPLY CHAIN ANALYST

Responsibilities:

• Analyzed, designed & documented DC/WMS operational processes and technology modules across Oracle, SQL Server, UNIX and J2EE platforms for UPS-SCS clients.
• Performed cost estimates, risk and gap analysis for each clients upgrade, promotions and customizations.
• Tuned for EXE 3.4/3.6 and PKMS 2000 R1 source code to streamline inbound and outbound DC operations.
• Managed, defined and designed Enterprise Modeling, Purge & Archive methodology, Data migration strategy, DB import/export and Schema architecture for VMI clients, Unix Cron and Daily Inventory Snapshot.
• Supervision and Integration of Oracle objects with J2EE interfaces, Forte data adapter, FGV, UNIX cron, Connectship and MQ series. Creation of Oracle 10g and Crystal Reports.
• Designed test strategy for Oracle DB and PL/SQL packages, FGV, Connect ship, Inventory and Billing apps.
• Migrated SQL Server 8 data and objects to Oracle 9i database for Ocean freight clients.
• Developed and performance tuned SQL server code for High Jump Advantage Architect WMS and TMS.

Confidential, San Antonio, Texas

CONFIGURATION ANALYST

Responsibilities:

• Installed, configured and integrated MOVE WMS and TMS on a 500,000 sqft TPC facility successfully.
• Created PL/SQL DB objects, query optimization, Data migrations, Erwin data modeling and Mercator mapping.
• Successfully worked with Oracle, UNIX and NT systems administrators for database, systems and applications setup, trouble shooting, streamlining architecture and timely deliverables for WMS Go-live.
• Planned, Organized and scheduled Cron jobs, purge & archive, cycle counts, Physical Inventory, file upload, conveyor interface connections, manifests, statistical reports and change control documentation.

Confidential, Costa Mesa, CA

WMS STAFF CONSULTANT

Responsibilities:

• Installed, configured and integrated 3PL WMS and TMS applications on NT and UNIX platforms successfully.
• Extensive development in PL/SQL, Java script, Crystal reports, UNIX shell script and query optimization.
• Created client manuals for configuration, SOPs, best practices, issue resolution and future staff training for 350,000 sqft J.C. Penney, 300,000 sqft I-fulfillment and 250,000 sqft Lab Safety Supply facilities.
• Participated in Mercator mapping and data modeling (physical/logical) on Erwin for WMS databases.