Jordan Fox Email & Phone Number

Chicago, Il, Us

Rosemont, Il, Us

IT Finance – SQL/SSIS Developer, Application PO/SME, Change Management• Utilized SQL, SSIS, SSRS, SSAS, VBA, Power BI, Appian, ServiceNow, Stonebranch Automation, and in-house ETL applications to consult, implement and support technology solutions for the Finance team. • Coordinated and gathered requirements, as well as developed A/B test cases for the Workday Finance deployment and HR integrations.• Created a new corporate strategy and workflow for change management across 5 teams to eliminate error and easily conform to internal OLA’s.• Provide end-to-end stakeholder support, through vendor RFP analysis, sunrise new applications, streamline governance, and increased transparency.• Restructured the daily operational playbooks for cross-team bug handling, decreasing BAU SLA impacts by 80%.• Established a culture of bi-lateral feedback to encourage agile continuity.• Implemented and maintained financial systems for the company, including A/P, A/R, tax, mortgage, quantitative risk, SOX and general ledger systems.• Conduct data validation and provide insights to improve financial processes.• Provided technical support and troubleshooting as the product owner/SME for 15 financial systems, including Recon, SAS, Workday, and Workiva.• Collaborate with cross-functional teams to gather requirements, enhance business continuity, and convert from break-fix to a proactive service model.

San Francisco, California, Us

IT Infrastructure – Product Owner, Project Management, SQL DBA Steward, Data Insights Analyst• Developed 500+ tables, views, and stored procedures, as the sole SQL developer for SSIS scheduled data transformations being pushed to Tableau.• Led the data development process, from idea to launch, by creating and managing timelines, delivering product documentation, and coordinated with stakeholders to ensure data-driven solutions.• Engineered SSIS packages to automate ETL processes, triggered by Autosys jobs, to automate data transformations for end user dashboards.• Formed 6Q roadmaps, 7 multi-year project timelines, team templates, and end-to-end data dictionaries.• Formalized team metrics/KPI’s and Jira exceptions dashboards for team organization, tracking, and to encourage well-written stories.• Coached the team on the use of scrum, curated a training curriculum and designed the Jira status workflows to increase development speed and productivity.• Led sprint planning and backlog refinement ceremonies to better define stories and goals. • Operated as Product Owner/PM of a new net product, 1 of 10 products the overall team supports.• Advertised the team’s reporting services to potential internal IT business partners, while being heavily involved in their onboarding and integration.

San Francisco, California, Us

See VP Technology Business Services Sr Associate Description

San Francisco, California, Us

Data Migration• Utilized Salesforce, Excel, SQL, SSIS, SOQL, internal ETL along with 4 company product source systems, as the lead of the data migration efforts for the Salesforce 1CRM project.• Coordinated daily communication with the stakeholders and developers to gather requirements on data transformations, survivorship, and flow.• Defined legacy data and established formal business approval workflows for all E2E migration efforts.• Mapped and documented 100+ objects and tables across 4 systems to the target for synchronous fields.• Introduced SharePoint Task List to project a 3-quarter roadmap Gantt chart.• Performed redundancy and survivorship analysis leading to reduction of technical debt by 40%.• Wrote/refined 400+ JIRA user/technical stories to guide discovery/development.• Developed 100+ dynamic SQL test scripts for SIT/UAT testers.• Refined the future Data Quality documentation for migrated objects.

• Implemented the complete re-design and management of the website for all interested parties and attendants.• Organization brings many nationally recognized names in sports to come and speak to the underprivileged youth in Greenville, SC and the surrounding areas.

Charlotte, Nc, Us

• Utilized SQL, Excel, MS Access, and various source systems daily to analyze and map metadata.• Developed Excel VBA macro shortcuts for non-database sources, to automate metadata creation.• Mapped and re-mediated lineage of 100+ highly audited reports from source through non-systemic and systemic transformations.• Engineered standard queries through DBA collaboration, using a net new repository to create a master data warehouse for all existing data modeling.• Designed and delegated task items through JIRA to maintain short and long-term project plans.• UAT tested and presented on the roll out of the data warehouse for scoping/visualizing metadata.

Charlotte, Nc, Us

Continued as consultant for 6 months after leaving.• Utilized VBA, SQL, and SOQL to automate chain-wide and drill-down reporting for all locations.• Coordinated the evaluations of multiple SaaS vendors to on-board an automation application stack.• Acted as the implementation reporting/data SME, providing requirements during development and testing with our Salesforce – ServiceMax enterprise vendor.• Designed push/pull script macros from 13 sources of record, to create exceptions reporting. • Reconciled and developed an A/R calculator tool to capture $1.8M+/year in undiscovered billings.• Consolidated reporting into useable dashboards for end users and rolled up management review.• Administered UAT testing to end-users who continued to report bugs for 3 months after the test.

Chesapeake, Virginia, Us

• Utilized VBA, SQL, and SAS to analyze replenishment/order forecasts of 8,000 basic SKU's in 8,300+ stores (~$9 billion sales/year).• Coordinated collaboration as SME with IT and SaaS vendor, 4R Systems (retail profitability).• Diagnosed opportunities, project managed, and implemented analysis tool enhancements.• Evaluated new technologies, developed methods and user reporting tools (MS Access) to establish and improve weekly processes for 70+ end-user team members.• Pioneered an enhancement that increased key KPI’s - in-stock and sales - by 25% for new items.• Presented high visibility initiatives and plan development to upper-level management.• Enhanced replenishment logic and holding inventory theory to increase overall EBITDA.

Chesapeake, Virginia, Us

• Utilized SQL, VBA, and analysis tools to optimize a lien inventory strategy, while eliminating future lost sales from “out of stocks.”• Evaluated 1+ million records of data to analyze and determine quantities of merchandise to order.• Worked closely with 3 other lines of business, as well as external partners, to guarantee we are in-line with specific financial strategies, based on consumer-need and store execution.

San Diego, Ca, Us

• Managed reporting for all deposits, pulled from various databases, research discrepancies/variances, and tracked all 7-figure deposits.• Communicated with Financial Advisors regarding their client's and determine their desired actions regarding their investment accounts.• Reviewed checks and/or payments that have been deemed “Not in Good Order” for rejection.

Washington, Dc, Us

• Developed business plans and conducted due diligence/market on up to 7 projects per month, leading up to funding approval and/or implementation for 50+ known new businesses.• Researched potential solutions for many issues that small businesses encounter, such as outreach, management, or overall operations.