| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateP h i l i p S t i e gA n a l y t i c s L e a d e rPHONE NUMBER AVAILABLE EMAIL AVAILABLE Pennsylvania LINKEDIN LINK AVAILABLE SUMMARYDynamic and results-oriented team leader with over 20 years of experience and skills surrounding information technology and analytics. I have worked in several industries in both the IT and business side of organizations where I've been successful in driving strategy and supporting the business in continually changing fast paced environments. I am a respected and trusted team player with the ability to help deliver long-term results and drive continuous process improvement. PROFESSIONAL E XPERIENCEVP, Senior Program Manager Analytics Alliant Insurance Services February 2023 - Present Leads development, management and iteration of product roadmap for platforms, systems and tools related to Alliants analytics practice. Create and scale a comprehensive reporting suite by balancing efficiency and scalability of product against innovation and product differentiation. Executing additional roles as Product Owner & ScrumMaster deploying SAFe methodologies to plan and execute data architecture and reporting development supporting Alliant Analytics. Executing OnPrem employee benefits data migration to Azure Data Lake utilizing ADF Pipelines, Serverless Synapse and Spark Aligns internal and external resources to ensure product success throughout the SDLC, managed through Azure DevOps. Partnered with operations to develop and implement user administration processes. Develops KPIs to assess program performance while targeting to maximize ROI. Partners with Marketing and Training teams to promote the Analytics program and products. Manage and organize multiple simultaneous small and large-scale projects; coordinating all cross-project activities Coordinate and lead reoccurring cross-functional discussions with subject matter experts (stop loss, clinical, pharmacy, health& productivity) and end users and to gain feedback to inform product roadmap. Technical Proficiencies Used: Power BI, Azure Data Lake, Azure DevOps, Lucid Chart, Spark, SQL, Asana, MS Office Senior Consultant Itero Group October 2020 February 2023 Project Management Working on a hybrid Agile/Scrum team tasked with delivering technical projects to integrate a new health plan into existing multi-state claims processes, datasets and reporting. Managing multiple 500k-1M dollar projects simultaneously including all related project plans, budgets, resource allocations, change requests and issue resolutions. Create trust and accountability with leadership guiding projects through budget challenges and associated action plans. Built effective relationships with BAs, Developers, Architects and Quality Leads. Providing project status reports to client leadership and customer teams. BA / Developer Provided technical documentation and lead technical requirements gathering. Execution of SAS scripting to create table updates for local Mainframe and SQL Servers. Development of reporting templates and Adhoc reports to assist the business with current projects. Leverage prior industry experience to convey logistical / technical issues to senior leadership. Proactively resolved project issues with minimal impact on the business. Technical Proficiencies Used: SQL, SAS, UNIX, VersionOne [Digital AI], MS Office[Advanced Excel (ODBC conn., SQL Queries, Pivot Tables/Charts), MS Project, PowerPoint, Visio] P h i l i p S t i e gPHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE 2Senior Consultant DataIdeology October 2018 July 2020 Diagnose and assess client needs for reporting and analytics, lead requirements gathering. Provide roadmaps with short term and long-term goals to address the clients needs, including process / operational / financial milestones. Map process flow charts to understand current processes and discover ways to create efficiencies. Work independently or as a part of the clients team to achieve goals laid out in project roadmaps. Provide project status reports to client management and their teams. Prioritize resources and tasks to maximize efficiencies and maintain SLAs. Leverage prior industry experience to convey logistical / technical issues to senior leadership. Proactively resolve project issues with minimal impact on the business. Provide reporting and analysis to support project progress / ROI. Adhoc as needed. Technical Proficiencies Used: SQL, SAS, Power BI, Tableau, SnowFlake, COGNOS 11, MS Office [Advanced Excel (ODBC conn., SQL Queries, Pivot Tables/Charts), PowerPoint, Visio] Manager of Human Capital Analytics MedExpress January 2017 October 2018 Established and developed HR Metrics to support executive level dashboards, advanced analytics and departmental reporting. Advanced Human Capitals ability to leverage information to make data-driven business decisions and strategic recommendations to enhance HR and Recruiting initiatives. Partner with internal customers to determine data and information needs and provided the appropriate information to aid them in their business decisions. Prepare statistical summaries and reports from HRIS including demographic, pay grade, performance, and compensation data. Analyze information needs, create and maintains ad-hoc and ongoing reports, and maintain internal databases for related functional information. Process/maintain employee information in HRIS. Technical Proficiencies Used: Microsoft Dynamics GP [HRIS], MS Office [Advanced Excel (ODBC conn., SQL, Pivot Tables/Charts), PowerPoint, Visio], MS SharePointManager of Market Selection MedExpress March 2016 January 2017 Lead a team in the identification of potential new center locations and preparation of market entry evaluations for senior leadership approval. Evaluations are comprised of strategic rationale for entry, competition summary, visit volume projections, financial evaluation of center profitability, market demographics and maps. Gain alignment from business stakeholders to support market selection processes, communications and strategic growth initiatives. Presentation of complex analysis and evaluation in clear concise language at the appropriate level for the intended audience. Collaborate with Real Estate partners to determine ideal location within proposed markets, provide additional site analysis and refined financial site evaluation for potential new center location. Provide evaluation and analysis of urgent care competition or health systems as candidates for potential acquisition or joint venture opportunities to business development team. Primary purpose to support entry and gain market share in new or existing markets. Create metrics or dashboards from the combination of multiple internal or external data sources. Using SQL and advanced Excel techniques for dynamic aggregation and visualization of data. Partner with BI Development to implement web based dashboards from Excel metric templates/logic. Initiate and drive projects to completion with minimal guidance. Directly reported to Ryan Mazeffa, VP of Telehealth and Predictive Analytics Perform one-on-ones, manage individual team members performance, and promote their career growth and compensation. Technical Proficiencies Used: MS Office [Advanced Excel (ODBC conn., SQL, Pivot Tables/Charts), PowerPoint, Visio], ESRI Arc Map, MS SharePointP h i l i p S t i e gPHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE 3Data Analytics & Information Specialist Alcoa December 2014 March 2016 Develop, implement, and execute data governance policies and procedures to improve data integrity within the procurement organization. Establish and maintain relationships with data leaders throughout the company to create and refine process workflows for data management. Supports and facilitates the day-to-day data and information requirements for procurement programs by analyzing and auditing data integrity and quickly addressing any deviations or discrepancies. Collaborates with business partners to define the metrics or measures of quantitative assessment used for the improvement and tracking of project performance. Map out data requirements and data consolidation processes for customers. Partner with Data Solutions in the design, development and implementation of short and long term reporting solutions. Proactively conducts analysis to find opportunities for savings, optimization and/or cost reduction aligned with current project targets or program strategies. Participates in weekly PMO meetings supporting the delivery of the information and reporting to all levels of the organization, including the executive leadership. Technical Proficiencies Used: MS SQL Server, Oracle, Power BI, DAX, Visual Basic, MS SharePoint, MS Office 365 [Advanced Excel (ODBC conn., SQL, PowerPivot), Access and Visio] Senior Financial Analyst [Contract] ThermoFisher Scientific November 2014 December 2014 Analytical support for annual budget process for the North America commercial team. Reporting support to model customer proforma to include Corporate Incentives and / or Divisional specific RFPs. Technical Proficiencies Used: MS SQL Server, IBM Cognos, MS SharePoint, MS Office [Excel, Word] Senior Omnichannel Analyst Dicks Sporting Goods March 2012 August 2014 Managed the e-commerce fulfillment channel program Ship From Store from launch to production. This included cross- functional project management, data mining, analysis and modeling, communication of strategy and progress, process improvement initiatives, and running day to day operations. Acted as the Omni-channel and customer advocate to key cross-functional stakeholders across the business. Gain alignment from business partners to support program growth and strategic initiatives. Drove continuous improvement and business results by enhancing third party e-commerce fulfillment application and streamlining the brick and mortar Omni-channel processes. Participated in the development, implementation and maintenance of an in-house product inventory and multi-channel eligibility software application. Provide regular analysis and presentations to senior management supporting program performance and future strategy. Acted as the Ship From Store SME for future e-commerce platform development. Developed, lead and provided opportunities for growth for my team of four, including one direct report and three dotted lines. Technical Proficiencies Used: MS SQL Server, MS MicroStrategy, MS SharePoint, MS Office [Excel, Access, PowerPoint and Visio] Senior Pricing Analyst ThermoFisher Scientific June 2010 March 2012 Provide database administration and support of our divisional Pricing SQL Server. Develop and administer multiple SharePoint sites to facilitate pricing requests, streamlining of current processes, procedures and reporting, and to provide global visibility. Perform analysis of SAP data to verify process controls and data accuracy. Manage and monitor daily price change requests. Continued PPI training for further education in best practices. Adhoc reporting as requested. Technical Proficiencies Used: MS SQL Server [SSMS, SSIS, SSAS, SSRS], Visual Basic, IBM Cognos, SAP, MS SharePoint, MS Office[Excel, Access, PowerPoint and Visio]P h i l i p S t i e gPHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE 4Supply Chain Analyst ThermoFisher Scientific September 2008 June 2010 Project Leader for Metric Development for a division of the business. Re-Creation of Supply Chain metrics that measure and drive the business forward, identifying issues and correcting them. Bridging the gap between data types, systems and reporting procedures in place. Achieved by data mapping, SSIS package creation/scheduling and maintenance. Provide administration and data support of four servers owned by the Supply Chain dept. (1) SQL Server 2005, (3) SQL Server 2000. Participated in Practical Process Improvement (PPI) projects and PPI training for further education in best practices. Adhoc reporting and support for other departments as needed. Technical Proficiencies Used: MS SQL Server [SSMS, SSIS], Visual Basic, IBM Cognos, AS400, MS SharePoint, MS Office [Excel, Access, PowerPoint and Visio]Reporting Analyst Dicks Sporting Goods April 2007 September 2008 Create and maintain Adhoc Reports and Applications that provide our Merchandising Team with tools to perform their jobs with more efficiency and accuracy. Maintain a positive output of products through multitasking and prioritization of projects. Regular communication with VPs, Directors, Planners and Merchants concerning the development and support of reports and applications. Develop and manage our departments website, which offers our Merchandising Team a collective resource of our current reports and applications. Plan and conduct training of website and developed tools to members of our merchandising team. Technical Proficiencies Used: Toad for Oracle [SQL], Visual Basic, ASP/ASPX, Java, MS MicroStrategy, AS400, MS SharePoint, MS Office [Excel, Access, PowerPoint], Adobe Photoshop Merchandising Analyst Dicks Sporting Goods April 2005 April 2007 Allocate and replenish several multi-million-dollar product categories through the management of merchandising and inventory factors to maximize company sales and profitability. Manage open to buy, forecast accuracy and in-stock percentages. Communication with merchants, vendors and stores concerning shipping, sales trends, new store and new item setups. Train and advise on allocation/replenishment software and procedures. Technical Proficiencies Used: MS MicroStrategy, AS400, MS Office [Excel, Access, PowerPoint] Lifting Controls Analyst Exxon-Mobil April 2004 December 2004 Providing 24/7 Customer Service for all customers nationwide, acting as the liaison between Fuels Marketing and Supply. Managing individual customer accounts, analyzing and resolving supply chain issues on a daily basis. Providing a monthly forecast for 300+ proprietary terminals. Participated and contributed in U.S. regional weekly teleconferences to discuss supply, inventory and other related issues. Technical Proficiencies Used: SAP, MS Office [Excel, Access, PowerPoint], Brio P h i l i p S t i e gPHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE 5EDUCATIONBachelors Degree, Natural Sciences University of Pittsburgh 1996 - 2000 Focus : Computer Science, Physics & MathVOLUNTEERINGAssistant Coach Football Pine-Richland Youth Football 2022, 2023 Mentor and coach boys ages 6-9 on the fundamentals of Football with a heavy focus on safety and sportsmanship. Special Teams and Offensive and Defensive Skills positions Assistant Coach Basketball Pine-Richland Youth Basketball 2023 Winter Mentor and coach boys ages 8-9 on the fundamentals of basketball with a heavy focus on rules and sportsmanship. Assistant Coach LAX Pine-Richland Youth Lacrosse 2023 Spring Mentor and coach boys ages 6-9 on the fundamentals of lacrosse with a heavy focus on safety and sportsmanship. Head Coach Soccer Pine-Richland Youth Soccer 2015 Spring Organized and ran a team of 14 girls, ages 7-9, as the head coach of Girls U8 soccer team. Led team practices with essential skills development drills and games. Provided encouragement and support in weekly skills development sessions and games. |
