Data Analyst Product Manager
Resume:
Becki Kain
Dearborn, Michigan 48124
******@*****.***
Experience:
Python Programmer
Ford Motor Company
August 2021-November 2024
●Python/automation programmer with integration of Pandas and Matplotlib libraries. Wrote complex code to automate the audit of vehicle security drawings for EU regulation
●SQL programmer
●Product manager for ThreatModeler software, liaison between the vendor and Ford's internal teams, ensuring the smooth transition to a new tool and new methodology for Ford's future.
●Involved in UNECE audit responsible for all ThreatModeler/Ford evidence
●Manager of a small diverse group of people
●Developed complex Python scripts to automate the audit of vehicle security drawings for compliance with EU regulations (UNECE).
●Designed and implemented Python-based API integrations to streamline security validation workflows.
Backup Engineer/ Python Programmer
Ford Motor Company
June 2019-July 2021
●Design Data Protection solutions for Ford’s Next Generation Data Centers with Veeam suite of products, for both monitoring and backups
●Wrote SQL automations
●Work with IBM, Veeam and EMC for a Proof of Concept test
●Developed Python-based automation scripts to streamline data protection workflows for Ford’s Next Generation Data Centers.
●Designed RESTful APIs to integrate backup and monitoring systems with Veeam, IBM, and EMC solutions.
●Created Python scripts for log parsing, anomaly detection, and security auditing, improving system monitoring and compliance.
Data Analyst
Ford Motor Company
December 2016-May 2019
●Work with SQL, Alteryx and Qlikview to transform large amounts of sales and stock data into visually appealing and informative dashboards.
Data Analyst
July 2010-November 2016
●Data Analyst/ CAAT programer working with IT and Business auditors to create robust and repeatable tests, both for individual audits and ongoing fraud investigations. These projects allow for 100% testing and assurance, over traditional auditor sampling. These tests were also extended into the Internal Controls groups to allow for them to look for issues before the GAO audited.
●Recovered in one year, over $60 million from fraudulent and erroneous transactions in a variety of business units.
●Ability to test and interpret extremely large amounts of data, from diverse data sources, to discern patterns.
Unix/Linux Systems Engineer
Ford Motor Credit Company
December 2007-July 2010
●24x7 on call duties supporting Ford Credit's leasing, commercial paper, and telephony systems.
●Solaris, Linux and VMS support.
●Integrated central corporate tools into Ford Credit's specific environment.
●Mentor/teacher to junior members of the group.
Network Analyst, Enterprise Systems
Ford Motor Company
January 2005 - December 2007
●Planner, programmer, technical writer, trainer, and initial operational support for Ford enterprise roll out of IBM Tivoli Netview, on both AIX and Suse Linux, with integration to Tivoli Enterprise Console.
●Acted as liaison between different departments of IBM, on behalf of Ford.
Security Analyst, IT Security Services
Ford Motor Company
May 2002 – January 2005
●Performed ethical hacking and penetration test against internal Ford applications and external Ford partners.
●Lead investigator for incident response and forensics team, using free tools and Encase, and worked with law enforcement as necessary.
●Audited different departmental application, network and server security policies and then presented them for approval or denial as a member of a consulting board.
●Interdepartmental Security liaison for various departments.
●Blind tested various vendor solutions for a fair outcome.
Network Planner and System Administrator, Extranet Security
Siemens ICN placed at Ford Motor Company
February 2000 – May 2002
●Implemented Mirapoint email systems for multiple Ford owned domains, including writing training for operations.
●Worked with the partners in the ANX (Automotive Network Exchange) to harmonize firewall/vpn strategies.
●Designed standard operating system loads for Solaris/Checkpoint firewalls and Solaris/DNS servers for the public Internet and ANX private network, including:
Created stripped down, secure Solaris configuration for use on Extranet servers
Planned, tested and implemented different versions of Checkpoint’s FW1, Solaris patches, and other software, including upgrades on production firewalls
●Level 3 support and troubleshooting for production Checkpoint firewall, DNS, and email server problems 24x7x365.
●Managed security issues for extranet servers, including:
Performed proactive ethical hacking to assess vulnerabilities including passwords, open ports and issues with FW1 software configurations and acted as liaison to Ford’s Security department
Worked as a liaison to confirm that other groups in Ford were in compliance of Extranet security policy and participated in user audits, as necessary, documented standard processes for supplier connections to Ford
Unix Systems Manager/Senior System Administrator
The Gale Group, Farmington Hills MI
August 1999 - February 2000
●Managed Unix Systems group which maintains Solaris/Linux servers for multiple offices of the Gale Group worldwide.
●Configured and managed Checkpoint Firewall 1 for Solaris, secured externally facing services, DNS, sendmail, firewalls, internal VPN’s.
Network Server Administrator
Industrial Technology/ERIM, Ann Arbor MI
October 1997 - August 1999
●Acted as Sole planner and operations of all Unix (Solaris 2.*, IBM AIX 4.2.1, Red Hat Linux) and Network Appliance.
●Internal and External facing mail configuration and management.
●Designed network and configured routers and firewall.
System Administrator
furph Inc., Livonia Michigan
October 1996 – December 2000
●Consultant Postmaster, Webmaster, DNS Admin and System Administrator or various client sites using various OS’s such as NeXTStep, Digital Unix, Solaris and Ultrix
●Configured and managed incoming and outgoing ISDN/PPP
System Analyst/Programmer II
Ford Motor Company, Dearborn Michigan
November 1996 - October 1997
●Designed operating system images for High Availability Solaris 2.5.1 servers including patches and disk layout for a variety of Sun hardware with the emphasis on minimal downtime.
●Acted as Postmaster for executive mail server
System Analyst/Programmer II
Ford Motor Company, Dearborn Michigan
October 1995 - November 1996
●Maintained a legacy system to Unix gateway system.
●Integrated and tested applications on DEC Alpha.
●Supported internal/external mail to and from Ford and department POP3 mail servers.
●Supported Ford executives
System Administrator
CBSI Inc., Dearborn Michigan
June 1994 - October 1995
●System Administrator for DEC Alpha/Mips and Sun Solaris systems at Ford CAD/CAM/CAE..
System Administrator/Programmer
Mika Systems, Dearborn Michigan
December 1993 - June 1994
●System Administrator for various DEC platforms.
●Ported Ford CAD/CAM proprietary code to 64 bit/Alpha, design and implementation of test plan.
System Administrator
Imagine Multimedia, Ann Arbor Michigan
February 1993 - November 1993
●Sole System Administrator for mixed network of NeXT hardware, NeXTStep 486, and DOS machines including network administration, externally facing services administration (email, news, web), and purchasing.
System Administrator/Applications Support
DCI Inc., Dearborn Michigan
May 1992 - February 1993
●Dedicated application and system administration support for a wide variety of Unix systems at Ford Truck.
System Administrator
DCO, University of Michigan, Ann Arbor Michigan
August 1991 - May 1992
●System Administrator for NeXT and SunOS environment
Teaching Assistant, C and Assembler language programming for IBM 370
University of Michigan, Ann Arbor Michigan
September 1991 - January 1992
Education:
Bachelor of Arts, Economics
University of Michigan, Ann Arbor MI
August 1991
●Concentration in Computer Science
●Relevant Courses: Data Structures, Assembler Language, Computer Architecture, Int’l Stock Market Analysis.
CISSP and CISA Member of Infraguard
Technical Editor – Linux System Administration by M. Carling and James Dennis, New Riders Publishing, April 2000
References Available on Request
Contact this candidate