John Winans Email & Phone Number

Philadelphia, Pa, Us

Ch

• 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.

Bala 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.

Philadelphia, 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.

Philadelphia, 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.

• 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.

• 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.

• Processed invoices for payment.• Created and posted Journal Entries.• Provided MS Office and accounting system support for department of 50 users.

• 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.

Master'S Of Science, Information Systems

Bachelor Of Business Administration (B.B.A.), Finance