SUMMARY:

• Lead Project Manager/Senior Business Analyst and Systems Architect with extensive experience leading the design and development of Enterprise Business Applications.
• Specialize in understanding and recommending the best system solution based upon the customer's needs, SDLC Methodology, Process Improvement, Enterprise Systems Strategy, Business Systems Integration, System Design, Customer Analytics, and RFP Design and Facilitation.
• Strong organizational, relationship, and communication skills; a proven track record of leading strategic systems development with cross - functional, cross-channel business teams, and expertise building, coaching, and leading high-performance IT teams to hit specific project timelines, budgets, and deliverables.

SOFTWARE EXPERTISE:

Expert in: Visio, MS Project Management, PowerPoint, MS-Word, Excel.

Project Management: Waterfall, Agile (Iterative).

Proficient with: SQL.

Retail: NCR CounterPoint.

Shopper Analytics: ShopperTrak.

CRM Systems: Oracle Siebel and Fusion CRM (Oracle Sales Cloud).

Demand Planning, Trade Promotion Planning, and Deduction Settlement: Oracle Demantra Trade Management (PTP), Demand Management (DM), Deduction Settlement (DSM), and Supply/Operations Planning Systems.

Business Intelligence: Cognos Business Intelligence Systems, MicroStrategy, Business Objects, Teradata.

Platforms: Systems developed using PeopleSoft, Oracle, IBM DB2, SAP, and Great Plains.

Web development: Hybris, SharePoint, Java Script.

QA Testing applications: HP Application Lifecycle Management (ALM), Jira.

Category Management: JDA.

EXPERIENCE:

Confidential

Project Lead/Business Systems Analyst

Responsibilities:

• Project Lead and Business Systems Analyst responsible for leading client engagements to deliver small, medium and large scale CRM/Direct Marketing solutions.
• Analyzes complex business problems to be solved with automated systems by providing functional systems expertise in identifying, evaluating and developing system solutions.

Confidential

Senior Business Analyst

Responsibilities:

• Working with the Marketing Technology team carried out Business Analysis tasks related to data integration for websites, adobe analytics, emails, data warehouse, reporting, and CRM systems.
• Performed requirements gathering activities as well as requirements documentation which included data mapping and data flow diagrams.
• Consulted and interacted with multiple decision support, marketing brand, web development, and backend development teams.

Confidential

Systems Development Project Manager

Responsibilities:

• Program Manager for Confidential ’s retail store roll out:
• Designed development roadmap plan, set/reviewed objectives, coordinated project activities, oversaw the integration of systems data, and updated executive sponsors and steering committee of program status.
• Retail store POS system selection (RFP), design, and data integration/reporting.
• Directed and coordinated resource planning and systems setup/processing with:
• IT Network Engineering, DBA’s, Infrastructure, Security.
• Finance (PCI Compliance), Procurement, Supply Planning, Demand Planning, Materials Management, Inventory Management.
• Payment Processor (Chase Paymentech).
• Consultants for NCR POS systems design, implementation, and support.
• IT liaison with store architectural design, build-out planning, and construction teams.
• Digital Marketing ( Confidential .com) customer integration, new products setup, and targeted marketing.
• Co-developed with Marketing, Confidential ’s NEW Gift Card for redemption at Confidential retail or Confidential .com.
• Led the installation of ShopperTrak Customer Analytics system to understand the customer, analyze customer traffic patterns, integrate with our POS system to correlate customer traffic with sales, and staffing insights.
• Launched NEW Confidential Retail Gift Cards to over 80,000 grocery, drug, and specialty retail stores through the Blackhawk Network. Resulting in significant incremental sales for Confidential.
• Project Lead for the design, implementation, integration, and QA testing of the Confidential retail customer information with the Confidential .com Loyalty program that provided a 360 degree view of our customer.
• RFP lead for bringing on a Global Payment Processing partner for international Confidential .com consumer websites.
• Led the system design for proposed Mobile Showrooms to gather Customer Profile information using Mobile App Technology for Targeted eMarketing campaigns and Omni-Channel Retailing.
• QA Testing, SIT and UAT for the new Confidential .com & Kold consumer website and Confidential .com mobile
• Project Manager for process redesign, development, and QA of the new “Inside Sales” Siebel CRM system implementation.
• Project Manager for the redesign, process improvement, and QA testing of GMCR’s Lead Management System:
• Modified Lead Forms on Confidential .com, GMCRwholesale.com, and Confidential .com/Canadian-Shoppers.
• Integration of lead information from the various web sites into one database.
• Co-designed the automation and Lead assignment process to distribute and track leads to and from the new Fusion CRM system.
• Confidential ’s Lead Business Analyst for the Co-developed Oracle Fusion CRM system, both web and mobile, which became the Oracle Sales Cloud in the Oracle E-Business suite.
• Project Manager and Business Analyst for the design, development, and QA testing of the Partners SharePoint Portal which provided the Partners team with a process status tracker and collaborative document repository.
• Led the design and development of the Business Analyst SharePoint document repository.
• Project Manager for the Demantra 7.3 Upgrade and system performance improvement initiative.
• Confidential Project Manager for the BI data migration and integration of Confidential ’s sales, financial, and operational data from Great Plains to PeopleSoft.
• Authored and conducted RFP for replacing Confidential ’s Sales and Marketing’s Planning and Forecasting System.
• Lead Business Analyst for Confidential ’s Demantra Demand Planning system implementation.
• Documented all BI data flow processes for Confidential ’s Great Plains Order to Cash and Forecast /Plan system data.

Confidential

Program Manager

Responsibilities:

• Managed automation design, development and workflow process for Confidential ’ Program Review Process.
• Designed the automation of Confidential workflow process for their Program Office Directive.

Confidential

Project Manager

Responsibilities:

• Project Manager for design and development of enterprise-wide BI system that resulted in the addition of Teradata data warehouse and upgrading Cognos Enterprise reporting system.
• Designed BI strategic development plan and implementation roadmap.
• Wrote RFP for selection of Enterprise Data Warehouse then led evaluation of Teradata, IBM BCU, Netezza, Oracle, Microsoft, and various ETL and MDM solutions. Selected Teradata.
• Wrote and conducted the RFP for BI reporting solution then evaluated Cognos, MicroStrategy, Business Objects, Microsoft, Oracle, and Hyperion solutions. Selected Cognos.

Confidential

Project Manager, Business Intelligence, Sales and Marketing Systems

Responsibilities:

• Designed and developed first-in-industry intranet portal called “Grapevine” for online self-service reporting and field sales materials documentation retrieval. Result: Over $100,000 in capital cost savings per year.
• Authored online enterprise reporting dashboard--before dashboards (as we know them today) were available.
• Rewrote Cognos’ drill-through routine so users dynamically drill from enterprise report to report/cube-to-cube on demand without IT intervention.
• Founding Architect and Project Manager for the design, iterative development, and QA testing of Welch’s Trade Management and Deduction Settlement system--Demantra’s predecessor. Results:
• Trade Management System: Saved $13 million per year in promotional overspending.
• Deduction Settlement System: Minimized the costs of clearing deductions; enabled quick resolution of deductions; reduced the average number of days outstanding for deductions from over 180 days to less than 20 days in 12 months.
• Project Manager for the iterative design, development, and QA testing of partner-developed Demantra Trade Management and Deduction Management systems--now Oracle’s Demantra Predictive Trade Planning (PTP) and Deduction Settlement Management (DSM) modules.
• Project Manager for the design and development of online Marketing and Sales Self-Service Point of Sale Distribution Center. Result: Savings of $100,000 annually in process efficiency and reduced labor costs.
• Redesigned and managed development of a virtual Consumer Call Center. Result: Saved $400,000 over outsource option.
• Collaborated in the DB2 Data Warehouse design for Sales, Manufacturing, and Finance.
• Principal advisor for the design, development, and QA testing for the Corporate Plumtree Portal that replaced the “Grapevine” Sales Portal.
• Project Manager for the iterative planning, design, development and QA testing of the new and innovative Business Intelligence Reporting systems.
• Created and maintained reporting and data systems development project plans, short and long-term strategy, scope, testing metrics, and objectives.
• Supervised reporting system training, QA testing, support, administration, documentation, and system upgrades.
• Managed internal staff and consultants to ensure development processes, project deadlines, Quality Control measures, and documentation goals were met.
• Managed co-development (with Cognos Corporation) of the design, development, implementation, and QA testing of HR Performance Application module.
• Directed co-development of Oracle Enterprise Asset Management (Oracle EAM) and NoetixViews® for Oracle Process Manufacturing.