Data Analyst Part-Time
Resume:
SEAN STRIBRNY
*******@*****.***
http://www.linkedin.com/pub/sean-stribrny/2/741/7a0
SUMMARY
A dedicated Analyst who has a passion for present and future technology that provides transactional solutions.
CAREER EXPERIENCE
Data Analyst
Wexford
Willowbrook, IL
1/2022 - 2025
Built, tested, and maintained an SQL database warehouses for multiple company locations across the country
Developed SQL scripts that cross-checked for duplication and corrupt data across multiple data tables
Wrote procedures and nested functions for the SQL warehouses.
Cleaned and stored archived email address utilizing VB scripting
Updated and Maintained SOP documents
Ran $1,000,000 six-sigma project cost savings project across manufacturing plants
Developed Basic Artificial Intelligence for basic SQL coding queries
Data Analyst (part-time)
Group Atlantic
Oakbrook, IL
1/2015 - 2022
Maintained and updated client marketing database.
Maintained and updated accounting database.
Maintain Company website.
Utilized simple linear regression to identify timing repeat client business
Protected data integrity by not allowing concurrent updates to the same data
Utilized constraints to enforce column data integrity
EDI Analyst
BAS Systems
Homewood, IL
10/2014 -12/2014
Ran SQL Server scripts to generate on demand reports
Tested new reporting tool for correct data retrieval
Established FTP connections to transmit eligibility data
Wrote macros that accelerated repetitive .xlsx actions
Received basic UNIX training
Worked with customer service to identify missing records for claims eligibility and then update missing records
Reporting Analyst
Brookfield Relocation Services
Burr Ridge, IL
1/2014 -5/2014
Ran SQL Server scripts to generate on demand reports
Navigated through over 30 SQL Tables to understand field relationships
Wrote simple VB script that translated data from Microsoft excel file to power point presentation with one click
Transferred data from reports to client power point slides
Received basic PERL training
Worked with Internal Account Managers and Internal Accountants to maintain reporting delivery schedules for 12 clients
Conducted regression testing analysis that identified reporting holes that allowed dirty data to creep into reports
Data Analyst
Worldwide Recycling and Equipment Sales
Moberly, MO
9/2012 -6/2013
Built, tested, and maintained an SQL database warehouses
Developed SQL scripts that cross-checked for duplication and corrupt data across multiple data tables
Wrote procedures and nested functions for the SQL warehouses.
Cleaned and stored archived email address utilizing VB scripting
Updated and Maintained SOP documents
Data Analyst
United Airlines
Chicago, IL
5/2012 to 7/2012
Developed, built, SQL database. Database contained 40,000 records of historical static and dynamic data that was retrieved for financial sale analysis
Built Multiple Access database tables to speed up manual data retrieval
Traced source server historical data while documenting any data retrieval slowdowns
Worked in 4 person engineering group to gain understanding problematic areas of new Carrier system platform and the system interactions of 2 million cargo transactions
Updated SOP documents for back end users
Updated and Maintained SOP documents via Microsoft Sharepoint
Interacted with end users to understand how the cargo data was retrieved and what was important
Customization Data Analyst
Symphony IRI Group
Chicago, IL
9/2011 to 4/2012
Developed, built, tested, and maintained an SQL automated at risk database delivery report. Report was communicated twice daily via SQL job scheduler across company to reduce database re-work, $2M re-run, and increase on time delivery
Unit Tested SQL Automation report using the white box and heuristic testing.
Developed, built, tested and maintained a database tracker to aide root cause failure investigation of a foundation/legacy DB construction
Worked in 7 person cross-functional operations, developers, and engineering group to gain understanding problematic areas of new ILD system platform and the multiple system interactions of 1.3 billion UPC data dumps and provide solution
Created Test Cases and updated SOP documents for the At Risk Reporting during production
Updated and Maintained SOP documents
Elicited requirements for MDM system changes/enhancements with Project Manager
Wrote SQL script that pre-cleansed data before entering data tables
Data Analyst
Zebra Technologies
Vernon Hills, IL
3/2008 to 4/2009
Manage & report to senior management $1.2M PCBA assembly cost data
Develop $500K Pareto Analysis to determine priority Quarterly and Monthly Cost Variance Reporting for Plastics, PCB, Mechanical Assembly, Power Supplies, etc.
Use six-sigma techniques to identify $300K Plastics Injection Molding cost reduction and provide Supplier change recommendation
Co-led the implementation of $2M new cost saving structures with IT into BAAN MRP system
Work with Customer Service to improve Sales Order Generation from three days cycle time to less than one day
Analyze current printed circuit board inventory on-hand and cost risk exposure
Cost Analyst
Motorola
Arlington Heights, IL
3/2007 to 3/2008
Responsible for Accessory, Electronic Manufacturing Service, and High Level Assembly category Spend & Saving Forecasts
Financial Analysis to determine accurate Quarterly and Monthly Reporting
Using six-sigma techniques to identify EMS $200,000,000 Bill of Material cost drivers
Application of lean manufacturing techniques to service environment leading to calculation cycle time and waste reduction.
EDUCATION
DePaul University
MIT DATA ENGINEERING CERTIFICATE
Bachelor of Science – Operations Management
INDUSTRY MEMBERSHIPS
International Institute Of Business Analysis, Chicago chapter
ISO 3100 Risk Management Standard
University of Chicago Round Table
SAP SQL Community
Oracle SQL Community
Experimental Aircraft Association Member
TECHNICAL Skills Acquired
Proficient in the following tools and technologies:
Microsoft Word, Access, Excel, PowerPoint and Outlook, VB, SQL, MySQL, SAP, Six-sigma Green Belt, Crystal Reports, Basic Website Design
Contact this candidate