Rex Park, Mba Email & Phone Number

Pittsburgh, Pa, Us

Poland, Oh, Us

• Responsible for data strategy and services including developing roadmaps encompassing Generative AI, Data Warehousing, data visualization, self-service and reporting.• Established a program to increase data maturity throughout the company including data modernization, data warehousing, and data governance, driving towards data-driven decision making and management by objective, curated KPIs and metrics• Partnered with business teams to increase effectiveness on projects relating to data driven decision making and enablement and increasing data quality.• Increased the visibility of knowledge through the company via knowledge and documentation sharing platforms and processes to eliminate “knowledge silos”• Client contract (full-time assignment) via Agile Helix 10-2023 – 7/2024, then made permanent FTE in this role 7/2024

• Connected buyers, sellers, and investors to find the perfect residential and recreational properties for car enthusiasts, outdoor lovers, and entertainment seekers.• Specialized in matching clients with properties that cater to their unique interests and lifestyle preferences.Car collectors! Outdoors enthusiasts! Boaters! Happy to help with "out of the box" projects!• Facilitated seamless transactions and negotiations to ensure client satisfaction and successful property acquisitions.

Sewickley, Pennsylvania, Us

Responsible for all aspects of customer consultation, IT roadmap and technology platform and solutions, product delivery and business operations for Agile Helix. Offering customer strategic consulting in the areas of Digital Transformation, Data Management, Roadmap strategy, Business Intelligence, and Analytics and related topics Accountable for meeting business and financial objectives, all aspects of budget and service deliveryEngagements include focus areas such as:• Staff development and technology roadmap. • Process improvements and operational optimization in large scale healthcare/pharmacy claims processing. • Data lake/warehouse and analytics roadmap including Gen AI, visualization, and systems integrations• Data modernization and cloud migration• Fractional “C-suite” consultation

San Francisco, California, Us

* Chartered to build a new Business Intelligence team with domain over the functions of Third party data acquisition, Data Architecture, Data Governance, cross-team data problem management, Self Service reporting, Data literacy and Data visualization.* Responsible for all aspects of Business Intelligence, Data Architecture, Data Acquisition and Management, Data Government, and related custom development.* Manage the BI organization consisting of teams including BI Platform (Database design, ETL/ELT, Third party data integration and bespoke software development) and Data culture (Data visualization, Tableau platform management and Data literacy programs) * Manage a project portfolio affecting all areas of Motive operations and managements, coordinating with customer teams across areas like Finance, Marketing, Sales, Security, and many others to align business definitions and technical data stewardship to support preparation for IPO. Key accomplishments include: *Built a BI team from ground up and a successful implementation of Tableau including both server and cloud components operating at a high level of effectiveness.* Invited to speak at Tableau cloud customer council on how to monitor ROI from data visualization and BI. * Built a master data and data governance program tasked to increase data consistency and the quality of enterprise caliber KPIs to track all performance of initiatives in Finance, Sales, Marketing, Operations and other areas of operations in preparation for S1 filing and IPO.* Assembled inter-department forums and processes for defining Master Data and business critical KPIs and for solving complex data quality issues across many systems and verticals.

New York, Ny, Us

Challenged to increase the value and ROI of the firm’s data building leading business intelligence functions including interactive dashboarding, self-service, advanced and predictive analytics, and helping to identify opportunities for new service and revenue from data insights. • Responsible for all aspects of Business intelligence, Data Architecture, Data Management• Manage Staff of 30-50 and responsible for budget and negotiation of vendor contracts, fees, etc.Key accomplishments include: • Built out a scalable highly available visualization and reporting solution with client-facing analytics and reports in an external portal, as well as self-service traditional reports.• Built and deployed many internal analytics dashboards, reports and products for responding to changing business issues including Covid-19, US immigration mandates, and changing legislation.• Established new internal tools and methodologies for identifying inefficiencies and gauging data and process quality.• Reduced overall team cost by 20+% without sacrificing delivery, innovation, or quality, and helped other groups identify opportunities to reduce operational costs, recognize revenue and reduce aging Accounts Receivable.

Pittsburgh, Pennsylvania, Us

• Direct growth of Business intelligence technical landscape. Sunset systems and processes that are not in alignment with strategic objectives. Ensure team focus on service excellence, delivery centered development, and • Manage and direct activities of our Business Intelligence (BI) organization. 7 direct reports – architects, project managers, resource managers. Overall organization of 25-40 including my direct reports, plus analysts, report writers and developers.• Manage budget for BI technology platform, contracts and personnel amounting to $2.5 – 3 million• Define enterprise data warehouse and BI strategy and roadmap, including generating buy-in from functional areas and IT/Finance partners. • Focus on roadmaps for transitioning from legacy systems to new platforms, and generating roadmaps for self-service analytics, ad hoc data access, and data visualization.• Restructure BI team to ensure alignment with AHN objectives and adherence to industry best practices and AHN standards. Make sure that BI team’s IT processes support all legal and regulatory requirements and satisfy internal/external audit and compliance standards.

Pittsburgh, Pa, Us

• Direct growth and maintenance of a 20+ TB (and growing rapidly) enterprise data warehouse leveraging enterprise best practice design patterns.• Help define an enterprise data warehouse and BI strategy and roadmap, including generating buy-in from functional areas, and planning across many IT and business area teams. • Build and maintain a team of development staff (9 reports), reducing chronic team turnover and fostering stability and growth.• Work with Internal/external audit, and multiple functional areas to asses regulatory compliance vulnerabilities, define mitigations and coordinate response• Work with cross-IT group to coordinate evaluate, recommend, plan, and implement platform upgrades including SQL Server 2012• Balance team engagement on many concurrent projects, crossing the areas of finance, academics, marketing, Career Services, while providing production support and KTLO operations.• Review EDW needs in response to shifting budgetary, organizational, and regulatory climates, refining and revising strategies to best fit changing needs.• Participate in planning regarding budget and spend on capital and operational expenditures, (project and staff budgets, vendor contracts)• Assessment of strategies to drive efficiency and reduce cost while increasing speed of delivery• Motivate and mentor EDW development staff to maximize engagement and productivity• Work with IT and functional areas to coordinate large projects with budgets ranging up to multi-million dollar implementations

Pittsburgh, Pa, Us

• Help plan and execute a data platform shift from SQL Server 2005 to Teradata, including testing and assessment of competing vendors.• Build and maintain a team (2-4 reports) of development staff capable of growing with business needs and supporting both current and ongoing project work• Participate in planning regarding budget and spend on capital and operational expenditures, (project budgets, staff budgets, soft and hardware costs and configuration), including negotiating with vendors to ensure favorable rates, etc.• Work with IT management to coordinate resources to balance project delivery, incident response, and ongoing maintenance to ensure consistent delivery of enterprise data warehouse initiatives.• Analyze growth patterns and work with IT staff to ensure that EDW infrastructure will support projected growth, and coordinate acquisition and configuration to ensure that EDW remains scalable• Coordinate multiple teams and resources across many geographic areas to make sure that projects are delivered smoothly.• Manage team growth and career advancement/planning for my direct reports, setting attainable goals that encourage staff to stretch and grow their capabilities• Work with management of other functional areas to coordinate large projects to make certain that all areas are not negatively impacted.• Provide technical guidance and mentorship, including hand-on support when needed.

· Work directly with executive staff, Sr. Management, and exernal vendors to determine project requirements and best solutions to pressing business needs · Grew enterprise datawarehouse from 30GB to over 1TB, based on flexible scalabe design, planned to scale to over 40+TB in the next five years. · Perform feasibility studies including migrations and benchmark tests on proposed solution platforms (Oracle Exadata, Teradata, Microsoft fasttrack) · Define and transform the ETL paradigm of the enterprise data warehouse to make it more flexible and robust. · Model, build, and deploy new databases and related objects (stored procedures,views, functions, etc.) to interact with existing student information system databases and applications. · Define a roadmap to consolidate four separate legacy data warehouses into one Enterprise data warehouse, both at the high-level, and also defining detailed low-level requirements, milestones, and time-lines · Define and document team best practices and methodologies for all supported platforms and applications · Mentor team members, building credibility by generating concensus, and focusing on knowledge of solution environment, team standards and best practices, etc. · Self-manage on multiple projects concurrently. · Continue Sr Developer role responsibilities

· Interface with Internal business stakeholders and external clients and vendors · Model, build, and deploy new databases and related objects (stored procedures, functions, etc.) to interact with existing student information system databases and applications. · Support and enhance a prexisting BI initiative which was unscalable and largely failing. · Design and build new BI initiative using both the Microsoft SSAS,SSRS and Cognos BI platforms in cooperation with BI Architect to support a flexible and scalable BI solution. · Built data warehouse structures and conformed data from four source data systems (Jenzabar CARS, CampusVue, ApplyYourself, Lawson ERP) into datawarehouse · Use Cognos BI tools (Framework manager, Transformer, report studio, etc.) to build new and maintain existing Transformer Cubes. · Convert Crystal reports to SQL based DW reports · Perform unit and regression testing to verify proper functionality. · Manage product migrations for ETL toolsets on enterprise server environment. · Enforce best practices for Microsoft and COGNOS BI platforms and SQL Server 2005 · Mentor new team members and train on system environment, team standards, etc.

· Gather Requirements for, design, and implement.Net Windows application providing a data interface with external vendor portal. · Interface with Internal clients and external vendors · Model, build, and deploy new database structures to interact with existing student information system databases and applications. · Write functional and technical specifications detailing product features · Perform unit and regression testing to verify proper adherence to spec. · Write Crystal reports to support enterprise reporting requirements. · Enforce best practices for Microsoft .NET and SQL Server and ensure desired functionality

Pittsburgh, Pa, Us

Design, and write spec documentation for a service oriented architecture (SOA) .NET web application using SQL Server 2005 as the database. This application was for the healthcare industry, and had to be designed to accommodate HIPAA legislation to protect patient privacy. In addition, a telephony and GPS based locationing system were incorporated into the projeect.

This engagement consisted largely of business analysis, design, and generation of spec documentation for a service oriented architecture (SOA) .NET web application using SQL Server 2005 as the database. This application was for the healthcare industry, and had to be designed to accommodate HIPAA legislation to protect patient privacy. In addition, a telephony and GPS based locationing system were incorporated into the project. Additionally, I worked in at EDMC to deisgn a .NET WinForms application which would be an interface between internal databases and a remote vendor database, built reports using Crystal Reports 10, designed databases and performance tuning on SQL Server stored procedures.

Pittsburgh, Pa, Us

· Supervise an instruct development staff of two to seven people · Conduct code reviews · Enforce best practices · Architect, design and develop software solutions · Architect and design database structures · Deisgn and Build flexible adHoc reporting tool to report on business metrics and KPIs · Critical Incident Response on call 24/7 · Implement SOA architecture in .NET web application supporting 2000+ concurrent users · Interview potential team members and made hiring recommendations · Perform Employee Skill Assessments · Met with both internal and external clients to determine specifications

Designed and implemented enterprise web applications for the real estate industry, leveraging technologies including: Miscrosoft .NET (2.0 including C#, VB.NET, ASP.NET), SQL Server 2005, CSS, DHTML, Service Oriented Architecture (SOA), developed web services, data migration and retrieval processes, Maintained legacy VB and ASP applications, Managed and mentored team members and worked with business unit directors to determine project design and scope, as well as to ensure satisfactory project completion.

· Built and optimized DTS packages · Implemented n-tier and service oriented software solutions for the Real Estate industry using .NET framework · Build and tune SQL Server stored procedures · Participated in software architecture and design and implemented code to specifications · Met with internal clients to determine specifications and to acquire final sign-off · Wrote SQL Server Stored Procedures which built user controls on the fly

· Managed staff of three developer/designers · Interviewed potential team members and was responsible for team selection · Determined application platforms and interacted with vendors negotiating contracts · Architected and developed n-tier e-commerce application from scratch using ASP, Crystal Reports, SQL Server and MTS · Designed data architecture and Stored Procedures · Configured all web and SQL servers

· Wrote client server applications in Visual Basic and web applications using ASP · Developed custom ActiveX controls · Wrote complex SQL queries and views

· Developed n-tier web-based software for clients · Created Crystal Reports for clients · Developed streaming media server and content management engine for the Entertainment industry · Wrote and optimized SQL queries following best practicesShopping

· Negotiated vendor arrangements for Sporting Goods Products · Supervised data entry staff of three people · Managed content for e-commerce site including dynamic web page development

Mba, Ms-Mis, Business, Technology

Ba, History/Poli Sci, Marketing