John Cioffi Email & Phone Number

Austin, Tx, Us

Pflugerville, Tx, Us

Implementation lead and BI Developer for enterprise data warehouse project. Integration of 7 source systems to report sales, waste, theft, inventory for metrics and KPI’s. Azure platform, utilizing PowerBI, SSRS and Excel PowerPivot for reporting. Responsible for 700+ POS systems based in 4 national regions. Streamlining processes for pricing, promotions, product (taxable vs. nontaxable) market subsidies, kiosk buttons and reporting. As owner of Sales Force, undergoing overhaul and redesign, implementing structure, custom objects, permissions and SOP's.

Austin, Texas, Us

Analyzed underutilized business systems and created best practice processes to make proactive data available to decision makers enabling information to move faster, increasing accuracy and reducing costs. My extensive business knowledge in financial and manufacturing systems along with my development background, allowed me to hit the ground running providing system recommendations, master data management, developing BI report reports and applications in my first week of employment. Prepared a full systems review during in first month to fix areas of risk and prioritize a plan with based on effort level and costs to migrate and deploy automation and business class systems. Developed 60+ SSRS & Excel Power Pivot reports for all areas of the company. This allowed users with little to no reporting experience to access data through their internet browser and Microsoft Excel. Overhauled order management and EDI systems by consolidating many manual/non-integrated processes into a few newly developed applications. Previous involved a team of 8 order entry staff to only 1 today. Developed notification reports new order and item to drastically reduce errors and labor time. Tasked as Sales & Operations MRP initiative project leader by CEO to build a comprehensive supply and demand system integrating our sales forecast to our financial plan.

Round Rock, Texas, Us

Digital Fulfillment / Global Configuration Services Provided business analyst support for Digital Entitlement within Supply Chain and Product division. • Developed requirements for 6 projects, key liaison between the business and development groups.Provided support for 6 IT Dell projects to streamline supply chain processes by creating and developing business requirement, collaborating with Engineering Development, and Deploying Systems teams within the 150 application supported within the supply chain group.Created, developed and enhanced Dell’s business requirements (BRD), vetting with development and business departments. Ensured all functional requirements had traceable test cases.

Client Projects:Farm Credit Bank of Texas – Austin, TX Quality Assurance Analyst – BI Data warehouse Implementation  Developed and executed over 120 test cases for Farm Credit’s General Ledger Data Mart. Ensured Micro Strategy reporting metrics were performing per the business requirements. Used SQL queries to identify various issues relating to data warehouse’s dimension and fact tables previously not detected in production. Collaborated with developers to correct ETL logic used to join dimension and fact tables.Questech Corporation - Rutland, VT BI Developer, Data Analyst & Project Management Conducted various project management, BI development, and data analysis to support manufacturing, sales and finance functions for Questech Corporation. Provider of technical support for ERP system operations and maintenance. Implemented e-commerce venture for company to increase product offerings selling directly to consumers.

Santa Clara, California, Us

Supply Chain Management - Enterprise Data WarehousePerformed analyses to identify data gaps and proposed solutions to developed business requirement, resolving data quality related issues and risks.  Reviewed, analyzed, and evaluated business processes and user needs, providing BI data warehousing solutions for Supply Chain Management.  Collaborated with key business stakeholders in Supply Chain and Global Operations and led BI development team, delivering Spend Analytics project one month ahead of schedule and under budget.  Received recognition as “AMD Success Story” by senior management for user adoption, successful execution and expected cost reductions of $2M in 2012 and $6M in 2013. Participated in Trusted Data and Data Certification project teams, analyzing and discovering incorrect source system data, missing records and ETL timing issues in production environment. Acted in lead role in Trust Data team to create dashboards for Supply Chain Management executives and correct existing source data issues. Performed as Project Manager for IT Convergence P.O.C. Coordinated with SME’s in global operations, finance, sales and engineering, developing execution plan for merging ATI graphics and AMD microprocessor bill of materials consistently.

Engaged customers to understand business needs by gathering and documenting their requirements. Created SOW and developed integration with Neopost application and the customer’s ERP or WMS back end system.  Developed internal database system to manage all pre-sales and post sales accounts, margins, and customer action plans. Programmed automated quotation system to accurately and consistently develop customer specific integration packages. This enabled faster turnaround of quotes in conjunction with statement of work and business requirement documentation.

Rutland, Vt, Us

Analyzed financial, sales and supply chain data in a manufacturing environment. Interviewed department SME’s to understand problems and issues and collaborated with key members to design, evaluate and develop IT solutions. During tenure the company experienced 900% growth. Reported to CFO. Performed as Project Manager for successful company initiative to support business venture with The Home Depot and Lowes. Led senior members of operations, sales, marketing and finance using “Chartered Group Meetings”. Designed automated web-based order fulfillment system to support processing over 90,000 customers orders per year, eliminating need to hire additional personnel and ensuring customer business compliance.  Migrated canned-reports, manual spread sheets and Microsoft Access reports to SQL Reporting Services (SSRS), allowing for “information on demand”, saving repetitive and manual report creation through drilldown capable technology. Provided users with no report writing experience with access to company data via internet browser. Developed management KPI’s and BI reports for sales, finance, operations, and engineering. Streamlined production data entry by developing user interface applications, reducing hours of manual data entry, Developed validated production controls, increasing inventory accuracy.  Developed PLC driven data acquisition system to utilize and integrate factory equipment data in production environment and reports, growing production yields from 80 to 95 percent within three months. Created color coded visual system to manage daily production flow through factory supply chain.

Education record

Education record