Business Intelligence, SAP Consultant with Cash to Order implementatio

ARMAND THEO A. DALMAN

Mobile: 713-***-**** **** Business Center Dr #8212

***********@*****.*** Pearland, TX 77584

BUSINESS DATA ANALYST

An analyst with over seven years in Category Management and Sales, Consumer/Shopper Insights, SAP Business Warehouse, Manufacturing (Consumer Goods), Telecommunications, Risk Management/Finance, and Customer Service. Demonstrates initiative, ambition, and enthusiasm across the business spectrum. Known for its resourcefulness in data management that drives down cost and at the same time can challenge existing Oracle/SAP platforms.

Core Qualifications

Data Insight/Mining

Data Transformation

Data Integration

Dimensional Data

Relational Databases

Syndicated Data Strategy

Internal Data Strategy (POS)

Consumer Panel

Business Process Mapping

Project Management

Nielsen Nitro/Custom Platform

NPD Powerview

Homescan and Spectra

IRI/Retail Link

Microsoft Office 2003/2007/2010

Database Systems/Applications

Access, Excel (Pivot Tables, Macros), PowerPoint, Relational Database, OLAP, SQL Queries, SQL Management Studio, Nielsen Nitro, Nielsen Spectra, NPD Powerview, and Market Track (formerly Adview), SAP MM/PP, SAP Production, Project Management, Business Warehouse, Third Party software (Interactive Edge XP3).

Education

DEVRY UNIVERSITY CHICAGO, IL

Bachelor of Science in Networks and Communications Management, 2003

Professional Experience

SAP TEST ANALYST (Consulting) 01/2015 – Present

Pentair Valves and Control. Stafford, TX 77477

• Configured thousands of combinations of valves through SAP Variant Configuration validating Market Lead Times, Standard Cost, Bill of Materials, MRO, Country Factors, and Discounts.

•Provided testing and reporting updates to Product Category Managers and Project members in a weekly basis.

• Handled multiple priorities & highly complex data structures by coordinating and administering of ERP projects through the creation of Excel templates.

SSA LEAD SALES GENERATOR (Part Time) 09/2014 – 02/2015

ARS Rescue Rooter thru Home Depot. Houston, TX 77047

•Assigned to various Home Depot locations for generating sales lead and scheduling appointments on Heating, Cooling, and Plumbing services and products.

•Communicating to at least 20 customers per hour for possible lead and at the same time providing customer service to Home Depot traffic.

RETAIL PROJECT MERCHANDISER (Part Time) 02/2014 – 09/2014

Advantage Sales Marketing. Pearland, TX 77584

•Reconciling actual out of stocks with inventory reports, auditing new and seasonal products for in-stock counts, and building displays and end caps for seasonal, holiday, and high-volume products.

•Managing POG/schematic resets covering Walgreens and Wal-Mart skus on a monthly basis. Communicating in a weekly basis with store and department managers regarding project completion and inventory status.

OPTION TRADER (Retail Investor TD Ameritrade/Sharebuilder) 09/2011 – 12/2013

•Generating income with particular interest in market analysis and speculation. Manage portfolio of options targeted at short to long-term growth. Rapid decision-maker with grace under pressure in capital preservation, exit strategy and risk management.

•Analyzing macroeconomic data, company earnings releases to sector targeting and planned trading strategies both short-term and long-term. Provide hedging on positions through day trading for volatility-driven events.

•Executing entry and exit points based from fundamentals of financial market with focus in technical indicators such as Moving Averages, Support/Resistance, RSI, and Volume. Use Internet, CNBC, and real time subscriptions to remain up-to-the minute news in global markets.

CORPORATE SALES ANALYST 04/2011 – 08/2011

Vtech Electronics NA LLC. Arlington Heights, IL 60004

• Gathered and organized relevant industry data, company data, and business unit data for reports, presentations, and recommendations to management.

• Developed effective presentations in PowerPoint and Excel to be shared with management and templates that management can use for their own presentations.

• Created and implemented a new process for Internal Point of Sale reporting for Top Four accounts weekly through the use of Pivot Tables.

• Built models and information path sourcing paths that will provide reliable method for optimizing the sales/operations/marketing and converting variances into meaningful insights.

MERCHANDISING PLANNING ANALYST/VIRTUAL MERCHANDISER (CONSULTANT) 02/2011 – 04/11

Walgreens Co. Deerfield, IL 60015

• Provided insights and key take-away to Category Managers in department assortment planning using Walgreens Internal Data and Nielsen consumption.

• Leveraged 2011 JDA certification Space Planner v7.6.1 to build functional planograms and fixtures across urban stores on resets, revisions, and special projects.

• Managed Excel spreadsheets by category with high volume of transaction data. Created Macros, Vlookups, and Pivot Tables to target key metrics on different phases of the project.

BUSINESS INFORMATION ANALYST II 01/2006 – 10/2010

World Kitchen, Inc. Rosemont, IL 60018

Global housewares manufacturer of the PYREX brand leading market share in Bakeware Glass and Food Glass Storage in United States.

Three Key Accomplishments

• Business Process Leader to automate reporting for faster insights; saving 1000 hours for category managers yearly – a game changer for manufacturers.

• Selected a working data platform out of five vendors, which supports the main need of the sponsoring group. The tool was budgeted for $55,000 for the first year with annual maintenance of $8,000 per year which was competitive against $450,000-$500,000 proposals. This results in invaluable savings as the selected platform is paving the way to bring in analytic projects without redundancy.

• Developed an internal process in data gathering from the third data supplier, which allows the company to have similar access, rather than purchasing the same data from the provider. This is saving the company a guaranteed cost of $25,000 per year.

Basic Responsibilities

• Collected data from third party subscription (Nielsen, NPD, IRI) and internal sources (Point of Sales, Shipments), placing it into Excel and Access for further administration.

• Created Macros in Access to export data sets in Excel as well as CSV and text files from EDI uploads.

• Performed mass updates in Microsoft Access (change, update, delete, append queries) in building hierarchies, categories, segments, price points, and other business information requirements.

• Developed Excel Pivot Tables from Access, ODBC connections and OLAP cubes to maintain consistency thus minimizing errors. Uploaded the compiled reports on Sharepoint site for front-end analysis and distribution to shareholders.

• Managed the ad-hoc request post-distribution from different business functions in forms of graphs, reports, existing Excel templates, complex calculations, PowerPoint presentations, and analysis using mainly data on Excel Pivot Tables.

• Increased the effectiveness, accuracy, and efficiency of repetitive task by utilizing other resources such as Interactive Edge XP3 and SQL Management Studio in building data cubes to consolidate, integrate, and automate information from different databases.

• Developed and managed monthly executive summaries, market shares, and scorecards utilizing World Kitchen POS data, IRI, and syndicated data sources for regular business reviews and processes.

• Presented PowerPoint slides to C+ level personnel in quarterly meetings and provided insights and key take-away in strategic accounts and key categories from the consumption and demographic trends perspective. Practiced the best category management approach by getting more granular on customers with the “What, So-What, So Now What.”

• Managed the master database for syndicated reporting and internal item hierarchies for sku optimization, Category Demand Index/Brand Demand Index and GMROI analysis for Brand and Sales team.

• Lead the design and development of end user reporting, query tools, and new business system application rollouts. Hands-on experience on using standard desktop tools reporting (Microsoft Analysis Services 2005/2008, Excel 2003/2007/2010, OLAP cubes, Access, and SQL Reporting Services).

BUSINESS PRACTICE ANALYST (CONSULTANT) 08/2005 – 12/2005

Kraft Foods NA Northfield, IL 60093

• Worked under the Content Management Group, which is responsible for maintaining the Kraft Standards Dictionary (KSD) and coordination of all master data activity for attribute definitions, standards, and category creation. The project will enable client to launch a go-live global catalog, which is sharable by its 70 manufacturing plants nationwide and achieving savings goals for each of the categories being sourced.

• Handled multiple priorities & highly complex data structures by coordinating and administering of MRO materials through the use Excel Pivot Tables and Access queries.

ACCOUNT MARKING MANAGER (CONSULTANT) 12/2004 - 08/2005

SBC Services Inc. Hoffman Estates, IL 60196

• Investigated and analyzed business customer account information on new and existing accounts to ensure the customer identification data is accurate. It also identified the size of the pie for business customers internally that will impact sales compensation and marketing goals.

Contact this candidate