John Winans work email
- Valid
- Valid
- Valid
John Winans personal email
John Winans is a Sr. Data Analytics Engineer at Chubb. He possess expertise in sap, business analysis, accounts payable, process improvement, analysis and 24 more skills. Colleagues describe him as "John is extremely detail oriented professional with exceptional MS Suport skills."
-
Sr. Data Analytics EngineerChubbPhiladelphia, Pa, Us -
Sr. Data Engineer/DeveloperChubb Sep 2021 - PresentCh• Automate data ingestion through discovery, modeling, aggregation, and enabling reporting actionable metrics to Management.• Data Extracted and Transformed includes Information Security towers: Identity Management, Governance, Risk Management, and Compliance, Data Protection, Incident Response, Cyber Threats• Design data models and develop data pipelines through ETL to create meaningful and interesting visualizations in Qlik. Multiple data sources include MS SQL Server DB, Oracle DB, Postgres DB, API, SharePoint, Web Connection, and flat files.• Design and develop dashboard UIs using Qlik Sense SAAS visualizations including KPI measurements, complex bar charts, histograms, pivot tables, reports, and pie charts.• Design and execute incremental loads to store transactional and aggregated entries to update KPIs and create trend analyses.• Create custom form elements which include scripted action buttons to filter data and change states in the UI.• Designed and executed an overhaul of the entire data repository for transformed data to be consumed by Qlik• Redesigned code repository to separate Dev/UAT/Production environments sources to point to appropriate BI environment source files.
-
Senior Level Etl Analyst/DeveloperTmna Services Oct 2018 - Sep 2021Bala Cynwyd, Pa, Us• Deployed SQL used to extract and transform data from three disparate SQL Server DBs through Informatica and combined data to load into a complex XML file.• Gathered data requirements from users, DBA's, and SME's to write source to target mappings and write SQL scripts. • Sources and targets included SQL DB's, XML files, flat files, UI fields, and API endpoints. • Developed ETL processes which used SQL queries, stored procedures, and Informatica Power Center.• Ran data reconciliations between source systems and the Data Warehouse.• Altered and ran stored procedures that pulled data and populated output into fixed length files to be consumed by government insurance bureaus.• Used Informatica Data Quality to run data profiles using Informatica Developer in order to produce informative scorecards.• Created data mappings in Informatica Data Quality for profiling.• Led initiative to perform data cleanup in Data Warehouse for claim transactions. -
Sr. Business AnalystAramark Mar 2014 - Oct 2018Philadelphia, Pennsylvania, Us• Wrote queries to extract and transform datasets for ad hoc and monthly reports via Oracle data warehouse.• Created analytics focused on Supply Chain agreements with vendors for all Lines of Business.• Created monthly reporting and trend analysis based on supplier agreed upon contract price audit against distributor invoicing. Rows analyzed >7 million.• Summarized and presented contract price analysis to management and pursued collection from distributors.• Gathered requirements and performed QA test for automated contract price audits.• Continuously performed analytical cost/benefit reporting for Fleet Management, including approx. 10,000 commercial vehicles. -
Business/Financial AnalystAramark Feb 2012 - Feb 2014Philadelphia, Pennsylvania, Us• Performed any ad-hoc reporting as requested by the business using vendor BI systems.• Audited maintenance enrollment, compliance, and spend quarterly for line of business managers.• Evaluated fleet purchases for volume rebates.• Created and execute queries for price analysis from vendors.• Created and ran SQL queries for contract price variance audits.• Worked in a group planning finance quarterly meetings.• Worked in a group planning department site visits and departmental outings to vendor sites.
-
Senior Business AnalystThe Jones Group, Inc. Jul 2008 - Feb 2012• Pulled and merged financial and master vendor data to create accounting quarterly report containing statistical spend analysis of largest vendors for review by the Chief Accounting Officer.• Extracted, merged, and organized data from two disparate accounting systems for ad-hoc reporting from production and legacy systems.• Participated in accounting (general ledger, GL accounts, AP/AR/Accounting journal entries, payments/credits) and master data conversion from JD Edwards to SAP. -
Business AnalystThe Jones Group, Inc. Jun 2006 - Jul 2008• Assisted Information Technology with Conversion from JD Edwards to SAP.• Gathered requirements for all AP roles in JD Edwards and rewrote job responsibilities and procedures in SAP.• Created AP quarterly report which provided statistical analysis of largest vendors.• Developed Excel templates featuring Visual Basic for Applications activex controls.
-
Ap SpecialistThe Jones Group, Inc. Feb 2004 - Jun 2006• Processed invoices for payment.• Created and posted Journal Entries.• Provided MS Office and accounting system support for department of 50 users.
-
Network Admin / Desktop SpecialistPeregrine Systems Dec 1998 - Apr 2001• Administered and monitored Windows NT 4/2000 and Exchange 5.5 Server • Level III desktop and notebook support.• Created and maintained base and departmental PC images using Norton Ghost.• Supported back office DB systems.
John Winans Skills
John Winans Education Details
-
Drexel UniversityInformation Systems -
Temple UniversityFinance
Frequently Asked Questions about John Winans
What company does John Winans work for?
John Winans works for Chubb
What is John Winans's role at the current company?
John Winans's current role is Sr. Data Analytics Engineer.
What is John Winans's email address?
John Winans's email address is jo****@****nas.com
What schools did John Winans attend?
John Winans attended Drexel University, Temple University.
What skills is John Winans known for?
John Winans has skills like Sap, Business Analysis, Accounts Payable, Process Improvement, Analysis, Budgets, Business Process, Oracle, Accounting, Financial Analysis, Jd Edwards, Auditing.
Who are John Winans's colleagues?
John Winans's colleagues are Phil Rybak, Swastik Das, Aruna Haridas, Hala Mhmd, Ignacio Delgado, Rupal Agarwal, Sanjuktha Anem.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial