Experience

Ohio Attorney General's Office

• United States
• Law Practice
• 700 & Above Employee

• Consumer Protection Data Analyst

  • Sep 2010 - Present

  Developed a case management system with upgradability that enabled investigators and attorneys to centralize their case work. Designed, Developed, and actively manage a complaint management system to enable employees to track complaints as well as assign tasks to investigators and attorneys. Wrote specialized functions in Access VBA to assist in data processing and analysis. Utilizing a thorough knowledge of SQL, coordinated with the Ohio Attorney General Infrastructure IT group to develop a standardized method to examine complaints with large scale Access databases for analysis and reporting. Designed, developed and implemented several databases to manage, analyze and report on numerous projects in the section. Coordinated with the BBB to develop a standardized extract method from their database system. Developed a database system that imported data from the National White Collar Crime Center used by the Consumer Protection Investigative team to manage Cyber Fraud complaints. A financial fraud database and reporting mechanism that evaluated several years’ worth of fraud events, impacting investigation direction. An investigative database that became a standardized investigative tool for all investigations opened by the Consumer Protection Investigative team. Implemented metrics and reporting functionality in many existing databases. Coordinated with the Federal Trade Commission (FTC) database team to expedite complaints entry in the Consumer Sentinel. Served as an on-site hardware and software technician for the Consumer Protection Section of the Ohio Attorney General’s office. Created highly detailed end user, as well as technical, documentation for all projects and databases implemented in the section. Managed a Cyber Fraud Investigation team to research potential fraud events and fraud suspects in determining the location and impact on consumers in Ohio. Show less



The Ohio State University

• United States
• Higher Education
• 700 & Above Employee

• Student

  • Jan 2010 - Jan 2010

  I recently completed two GIS classes totalling 10 quarter hours at Ohio State University, dealing specifically with spatial analysis in business and sociological issues and webGIS website programming to prepare for a career in GIS. I recently completed two GIS classes totalling 10 quarter hours at Ohio State University, dealing specifically with spatial analysis in business and sociological issues and webGIS website programming to prepare for a career in GIS.



JPMorgan Chase & Co.

• United States
• Financial Services
• 700 & Above Employee

• Data Analyst / Tech Ops Analyst

  • Apr 2004 - Jan 2010

  • Developed large and medium scale databases for various departments, empowering managers to analyze processed data and make educated decisions in regards to their objectives. • Designed and developed a monthly billing system to manage nationwide workstation, server and printer resources, serving as an inventory benchmark for departmental billing each month. • Compiled scripts that remotely identified and tracked devices on the network. • Developed and demonstrated metrics to measure hardware resources • Worked with other departments within the organization to actively manage hardware resources. • Performed troubleshooting and maintenance on hardware received from field technicians before returning the units to inventory. • Selected to be a member of the Retail Quality Assurance (QA) team to assist in the Washington Mutual conversion (WAMU). • Assumed additional responsibilities to identify and document hardware and software issues as well as perform test cases in a lab environment. • Functioned as a component of the process flow cycle in a testing capacity • Worked onsite and successfully led WAMU System Integration conversions in Houston, TX and Bakersfield, CA branches. Resulted in reduced costs and ensured that a qualified branch technician was onsite performing the conversion. Show less



RHT Consulting

• United States
• Business Consulting and Services
• 1 - 100 Employee

• Consultant

  • Mar 2003 - Apr 2004

  • Managed server installation technicians in the field performing banking center hardware and software installation for servers and workstation (Teller Express Integration). • Constructed several large-scale server-client based databases to manage team and technician progress. • Virus troubleshooting and desktop support (Sasser Virus) • Managed server installation technicians in the field performing banking center hardware and software installation for servers and workstation (Teller Express Integration). • Constructed several large-scale server-client based databases to manage team and technician progress. • Virus troubleshooting and desktop support (Sasser Virus)



Safelite

• United States
• Retail
• 700 & Above Employee

• Data Analyst

  • Dec 1998 - Jul 2002

  • Developed and maintained an auto glass shop database tool in Microsoft Access to manage participation, pricing structure notifications and tax identification information for 65,000 Safelite Glass Corporate Network (SGCN) affiliates around the country. • Performed rate analysis and facilitated mass communication with the SGCN affiliates. • Automated job functions using Microsoft Access Visual Basic and SQL to reduce process overhead and facilitate faster delivery. • Utilized my experience with ArcView to provide senior management with detailed maps of store locations to determine profitability with existing Safelite Corporate locations. Show less