Phil Miltenberger

• Trained and developed staff members, enhancing overall workforce competency and productivity levels.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Documented analysis results and provided performance improvement feedback.
• Developed custom database objects, stored procedures and delivered application support.
• Achieved on-time delivery of products by closely monitoring production schedules and coordinating with various departments.
• Designed and implemented stored procedures, triggers, and views for enhanced functionality within applications.
• Participated in code reviews to ensure compliance with industry standards and adherence to company guidelines for quality control.
• Designed scalable architectures that accommodated growth in both data volumes and user demands while maintaining optimal performance levels.
• Fostered a culture of continuous improvement by encouraging team members to share their knowledge and expertise with others, driving collective growth within the department.
• Streamlined data retrieval processes with customized views and stored procedures, improving overall efficiency.
• Implemented effective security measures, safeguarding sensitive information from unauthorized access or tampering.
• Enhanced database performance by optimizing SQL queries and implementing indexing strategies.
• Consolidated disparate data sources into centralized repositories using ETL processes to improve accessibility of information across the organization.
• Developed and delivered business information solutions.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.

• Managed budgets of multi-million-dollar projects, maintaining financial discipline and optimal resource utilization across all stages of development.
• Delivered projects on time and within budget by effectively managing scope creep through proactive identification and mitigation of potential risks.
• Applied data-driven decision-making techniques for improved planning and forecasting accuracy in projects.
• Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
• Planned, designed, and scheduled phases for large projects.
• Established effective communication among team members for enhanced collaboration and successful project completion.
• Met project deadlines without sacrificing build quality or workplace safety.
• Streamlined data management workflows for increased efficiency and reduced processing time.
• Developed comprehensive data management strategies, ensuring secure storage and swift retrieval of critical information.

• Optimized data warehousing architecture, ensuring seamless integration of multiple data sources.
• Performed ad-hoc analyses upon request from senior management or other departments requiring specialized support or insight into specific issues or challenges faced by the organization.
• Collaborated with cross-functional teams to identify key performance indicators and develop relevant metrics.
• Conducted comprehensive market research, enabling informed decision-making on new product launches and expansions.
• Championed a data-driven culture within the organization, promoting the value of analytics in strategic planning initiatives.
• Managed a team of BI analysts, fostering professional development and continuous learning opportunities.
• Improved data-driven decision making by implementing advanced business intelligence tools and strategies.
• Led successful migration projects from legacy systems to modern BI platforms, minimizing downtime during transition periods.
• Developed custom dashboards and visualizations to provide actionable insights for key stakeholders.
• Identified trends and patterns within data sets, providing valuable insights for strategic planning and decision-making processes.
• Championed the use of data visualization tools to effectively communicate complex information and drive meaningful business outcomes.
• Lead a team of developers and production support engineers in ETL (Pentaho) to/from Oracle, Reporting (Cognos), and Data Analytics in a HIPAA environment.

• Manage ETL and Cognos developers and support engineers to provide economic buyers with data extracts, reports, data analysis cubes, and custom extracts for incentive campaigns.
• Manage vendors and contractors working on the same area, support compliance and access control for the HIPAA environment.
• Design and provide architecture decisions for DWH and data mart as well as manage the MDM system for SaaS platform.
• Provide weekly reports on resource utilization and spend against both capital projects and expenses towards production support.
• Provide detailed metrics on operational KPIs and product usage metrics for SaaS product line.
• Establish strategy and direction for future data analytics needs using Alteryx, Qlik View, and Tableau, along with merging Google Analytics data with user product experience data to determine effectiveness of products and product alternative testing.

• Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
• Planned, designed, and scheduled phases for large projects.
• Met project deadlines without sacrificing build quality or workplace safety.
• Established effective communication among team members for enhanced collaboration and successful project completion.

• Project Manager for various internal information systems projects, as well as BI/Analytics product development. Project Manager for data migration of SaaS platform. Use agile\lean processes to successfully manage projects.
• Provided leadership with weekly status on all projects, bi-weekly detailed portfolio reviews, and stage gates for all projects. Provided project deliverables based on J&J SDLC and project management processes.
• Successfully delivered on-time projects each quarter and with 8-10% savings over the budgeted amount.
• Responsible for project budgets and resources. Agile, Scrum and Kanban\Lean leader and mentor.

• Project Manager for Ally Dealer Rewards and Incentive Compensation programs in AIAS using Oracle and Cognos reporting in conjunction with salesforce.com. Initiated and managed 4 product release cycles.

• Managed BI projects and resources for ETL and BI\Analytics. Managed major reporting and data analysis project in Cognos. Instrumental in getting product shipped during first 3 weeks on the job.
• Have helped to mold BI team while using Lean methodologies and project planning techniques. Resource manager for ETL and DBA resources working on major data migration project.
• Managed long-term project to upgrade security and validate privacy adherence for major web platforms and Oracle databases.
• Provided weekly status reporting and presentation to senior management. Agile, Scrum and Kanban\Lean leader and mentor.

• Maintained schedules to meet key milestones at every project phase.
• Directed changes to project scope and cost and implemented appropriate change management processes to keep project on track.
• Presented regular status reports to executive leadership, providing insights into progress made toward achieving key milestones.
• Mentored junior project managers and team members to enhance their skills and career growth.

• Streamlined tasks in effort to provide easier and more efficient workflows for peers and colleagues.
• Implemented risk management strategies to mitigate potential issues and maintain project timelines.
• Earned recognition for outstanding leadership and dedication, contributing significantly to the success of numerous software projects.
• Coordinated development, testing and release of complete suite of web-based software offerings.

• Maintained schedules to meet key milestones at every project phase.
• Established effective communication channels with stakeholders to ensure transparency and alignment of expectations.
• Presented regular status reports to executive leadership, providing insights into progress made toward achieving key milestones.

• Managed the deployment of web sites for all Jackson's 250 locations in the US.
• Included projects for Jackson's eClub that gathers information from customers and delivers text message coupons for short term specials.
• Managed several corporate acquisitions by merging IT systems and resources across several states. Developed plans that included SOX requirements, disaster recovery and business continuity plans for the entire organization.
• Managed project that developed marketing information for web site including; specials, coupons, store locator, and retail store amenities.
• Developed Fuel Tax reporting system based on Microsoft Access for 9 states. Managed complete migration of all financial, HR and payroll systems.
• Managed all projects under the triple constraint of scope, budget and timeline (schedule). Responsible for analyzing risks and risk assessment, and managing those risks.
• Developed system for wholesale trade show ordering for Capitol Distributing, a sister company of Jacksons. Managed multiple deployments of wholesale EDI invoice and price book systems, to integrate with PDI at the retail level, as well as other retail systems.
• Implemented for barcode/UPC scanning roll out to all retail locations.
• Implemented suggested ordering system that utilized handheld barcode scanners to initiate inventory and reorder points, and created purchase orders.
• Management\supervision of 8 technical employees in software development and technical support.
• Managed contract development.
• Responsible for all network, telephonic and cell equipment and contracts. Managed project budgets in excess of $2.3 million.
• Supported 24x7x365 operations.
• Provided key status and metrics on all retail and wholesale systems.

• Assessed each client's business to understand their operational processes in order to suggest additional improvements or enhancements to system.
• Developed training material and delivered training for various modules and systems developed by PDI. Taught weekly training engagements across U.S., offering classes and seminars on SQL and Microsoft Access.
• Exceeded sales goals by consistently selling additional services to clients, earning #1 spot out of 16 consultants and more than $600,000 in revenue for company within first seven months in position. Incorporated strong hardware knowledge to better serve clients in their software needs.
• Recognized additional opportunities to improve their operations which led to increased sales. Consulted on PDI applications with purchasing customers.
• Provided setup or automation of software as well as making recommendations to automate manual processes. Mentored several junior consultants on technical matters and techniques on generating billable hours.

• Implemented petroleum industry accounting system on Unix using PDI RMS with full pricebook scanning at all locations.
• Designed and implemented full Windows office network with NT Workstation clients and NT Servers with full Internet connectivity and Microsoft Exchange.
• Specified and supervised installation AutoGas Regal POS systems in 27 retail facilities. Achieved implementation during initial market availability of software.
• Provided latest credit/debit technologies including pay-at-the-pump.
• Developed dashboard system for executive overview and summary in Visual FoxPro.
• Managed PDI RMS system for all stores.
• Generated cash management software in FoxPro for handling depository banking and interfacing to ACH banking software.
• Developed disaster recovery and business continuity plans for entire organization.
• Developed tankwagon order entry system with accounts receivable interface and tax reporting in Visual FoxPro/SQL Server
• Enabled remote networks at all sites with connectivity to corporate office using Sterling Connect.
• Managed 4 employees (help desk support and field technical support) and oversaw purchasing and budgeting for corporate computer hardware and software.
• Supported 24x7x365 operations.