Jeff Keyser

Jeff Keyser Email and Phone Number

Data Warehouse Architect at Ally Financial Inc. @ Ally Financial Inc.
Jeff Keyser's Location
Farmington, Michigan, United States, United States
Jeff Keyser's Contact Details

Jeff Keyser personal email

n/a
About Jeff Keyser

Jeff Keyser is a Data Warehouse Architect at Ally Financial Inc. at Ally Financial Inc.. He possess expertise in data warehousing, etl, databases, oracle, data modeling and 26 more skills.

Jeff Keyser's Current Company Details
Ally Financial Inc.

Ally Financial Inc.

View
Data Warehouse Architect at Ally Financial Inc.
Jeff Keyser Work Experience Details
  • Ally Financial Inc.
    Data Architect
    Ally Financial Inc. Oct 2014 - Present
    Detroit, Mi, Us
    View
  • Hp Enterprise Services
    Technical Leader/Dba
    Hp Enterprise Services Aug 2007 - Oct 2014
    Houston, Texas, Us
    Technical leader of reporting team implementing Cognos-based reporting solutions with an Oracle data warehouse, using a wide range of Cognos BI products: Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio, Event Studio, and Metrics Studio.
    View
  • Hp Enterprise Services
    Project Manager
    Hp Enterprise Services Jan 2007 - Jul 2007
    Houston, Texas, Us
    Project manager at GM Powertrain for financial systems. Performed project management functions for Hyperion development project, including all meetings with Powertrain IT and business persons, scheduling and tracking of project, adherance to IT policies, and auditing of project management items.
    View
  • Hp Enterprise Services
    Systems Consultant
    Hp Enterprise Services Nov 2006 - Dec 2006
    Houston, Texas, Us
    Continued previous role at OnStar until end of year.
    View
  • Jdm Systems Consultants
    Systems Consultant
    Jdm Systems Consultants Mar 2006 - Oct 2006
    Farmington Hills, Michigan, Us
    Worked as a Systems Consultant at OnStar. Conversion of Decision Support System (DSS) extract, transfer and load (ETL) to new decision support environment. Tuning of Oracle data to correct SQL run-time problems due to cost-based optimizer issues. Tuning of long-running SQL's. Assisted DBA's with miscellaneous DBA tasks. Used Oracle, PL/SQL and other Oracle utilities, DataStage, Perl, UNIX scripting, and other utilities.
    View
  • Bbdo
    Data Mart Support Manager
    Bbdo Aug 2003 - Feb 2006
    New York, Ny, Us
    Revised, automated, and completed the implementation of the extract, transfer, and load (ETL) of the operational marketing database to the Data Warehouse to the Marketing Data Mart. Managed, designed, and implemented changes to the Data Warehouse ETL to support new marketing report requests. Designed and managed changes to the Data Warehouse and Marketing Data Mart. Performed extensive analysis and cleanup of data in the operational database in support of reporting and analysis. Designed new Business Object universes to support the Reporting Group. Consulted on questions of SQL coding and Business Objects report construction techniques for the Reporting Group. Used Oracle, PL/SQL and other Oracle utilities, Business Objects, UNIX scripting, Perl, some SAS, and other utilities.
    View
  • Electronic Data Systems
    Oracle Dba
    Electronic Data Systems Jun 2001 - Aug 2003
    Houston, Texas, Us
    Worked as a Systems DBA at OnStar. Became a certified Oracle 8i/9i DBA (OCP DBA). Maintained and monitored decision-support system (DSS) and other operational production databases. Scripted repetitive support functions like DBA password administration on approximately eighty databases, consistant tnsnames.ora file management on approximately fifty servers, daily updates of operational standby database for DSS, and daily updates of snapshots for DSS. Created generic hot/cold backup shell scripts. Used Import/Export/SQLLDR utilities to migrate operational data to DSS databases. Used Oracle Resource Manager to manage DSS users from DSS users. Tuned and re-engineered long-running problem SQL statements. Performed rotating on-call duties for production databases: performed recoveries of crashed databases, rebuilt database from backup files/logs, opened TAR's with Oracle to resolve Oracle issues. Migrated 24/7 databases to EMC storage system. Tested and debugged the BCV (Business Continuity Volume) scripts. Fixed database replication issues. Wrote scripts to extract large amounts of "test" transactions from operational database logs using LogMiner. Installed Oracle on new servers. Used Oracle, PL/SQL and other Oracle utilities, Perl, and UNIX scripting.
    View
  • Electronic Data Systems
    Designer/Team Leader
    Electronic Data Systems Aug 1998 - May 2001
    Houston, Texas, Us
    Co-managed the Enterprise Customer Marketing (ECM) team of thirty-two programmer/analysts. Team leader of the ECM Research Team for delivering list pulls and analysis for marketing activities. Subject matter expert for the Customer Management System (CMS). Technical leader charged with documenting CMS requirements for extract, transfer, and load (ETL) of consumer data, including cleansing and merge/purge rules, as well as participation in database design. Used Rational Rose, ERWIN, Oracle, Java, UNIX scripting, SearchSoftwareAmerica (name and address cleansing software).
    View
  • Electronic Data Systems
    Technical Lead
    Electronic Data Systems Nov 1996 - Jul 1997
    Houston, Texas, Us
    Took over as EDS Lead on a team with Cadillac and its fulfillment vendor to execute the Catera Launch marketing program. Performed the ETL of all data elements required to produce mailing, track responses to promotions , and measure success of the program through the purchase of the vehicle. Used DB2, VSAM, EasyTrieve Plus, COBOL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Technical Lead
    Electronic Data Systems Nov 1995 - Oct 1996
    Houston, Texas, Us
    Worked as EDS technical leader for Cadillac Relationship Marketing. Worked on a team with Cadillac and its advertising agency to investigate possibilities for relationship marketing at cadillac and to produce the Cadillac Higher Standard magazine. Documented and designed the capture, storage and usage of all data elements related to known touch points with customers either by Cadillac, its advertising agency, its fullfillment vendors, or its dealers. Participated in exploritory meetings with a relationship marketing consultant regarding the direction marketing could take at Cadillac. Used DB2, VSAM, EasyTrieve Plus, COBOL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Team Leader/Analyst
    Electronic Data Systems Nov 1994 - Oct 1995
    Houston, Texas, Us
    Led a team of up to three programmer/analysts for the corporate Customer Information Database Conversion for Cadillac. Analyzed all local customer databases and files to identify uses of customer data, consolidated and reconciled all local databases, uploaded consolidated data to corporate database. Used DB2, EasyTrieve Plus, COBOL, JCL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Team Leader
    Electronic Data Systems Jan 1992 - Oct 1994
    Houston, Texas, Us
    Led a team of up to seven programmer/analysts for the corporate Dealer Information Database Conversion for Cadillac. Analyzed all local dealer databases and files to identify uses of dealer data, consolidated and reconciled all local databases, uploaded consolidated data to corporate database, implemented interfaces from the corporate database to the local systems. Assisted with redesign of corporate database interfaces. Used DB2, EasyTrieve Plus, COBOL, JCL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Team Leader
    Electronic Data Systems Oct 1989 - Dec 1991
    Houston, Texas, Us
    Team Leader for Cadillac Distributions Systems. Managed team of about five to seven programmer/systems analysts supporting all of Cadillac's ancillary distribution systems. Scheduled and managed change request work, assisted with technical issues, performed quality reviews, managed maintenance incidents, trained new employees. Used IMS, VSAM, EasyTrieve Plus, COBOL, PL/I, JCL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Systems Engineer
    Electronic Data Systems Sep 1988 - Sep 1989
    Houston, Texas, Us
    Programmer/Analyst for Cadillac Distribution Systems. Converted all source code to a new change management system. Programmer/Systems Analyst for several systems. Used IMS Databases, VSAM, CICS, COBOL, PL/I, JCL, SyncSort and other mainframe utilities.
    View
  • Electronic Data Systems
    Systems Engineer
    Electronic Data Systems May 1986 - Aug 1988
    Houston, Texas, Us
    Programmer/Systems Analyst/Designer for Executive Office systems at GMAC. Coded and maintained programs on Repossessions and Losses System, and Service of Receivables System. Analyzed and designed Recoveries and Salvage Systems. Used Model204, Mark V, JCL, COBOL, PL/I, Syncsort, AutoSys.
    View
  • Electronic Data Systems
    Systems Engineering Development
    Electronic Data Systems Apr 1985 - Apr 1986
    Houston, Texas, Us
    Assisted in the Real Estate Development office. Organized collection of phone bills for GMAC.
    View

Jeff Keyser Skills

Data Warehousing Etl Databases Oracle Data Modeling Sdlc Pl/sql Business Intelligence Sql Db2 Database Design Solution Architecture Data Migration Erwin Cognos Disaster Recovery Itil Jcl Java Cobol Business Objects Enterprise Architecture Datastage Crystal Reports Soa Enterprise Software Sql Tuning Unix Shell Scripting Software Project Management Performance Tuning Requirements Gathering

Jeff Keyser Education Details

  • University Of Vermont
    University Of Vermont
    Mathematics
  • Phillips Exeter Academy
    Phillips Exeter Academy

Frequently Asked Questions about Jeff Keyser

What company does Jeff Keyser work for?

Jeff Keyser works for Ally Financial Inc.

What is Jeff Keyser's role at the current company?

Jeff Keyser's current role is Data Warehouse Architect at Ally Financial Inc..

What is Jeff Keyser's email address?

Jeff Keyser's email address is jk****@****.rr.com

What is Jeff Keyser's direct phone number?

Jeff Keyser's direct phone number is +124824*****

What schools did Jeff Keyser attend?

Jeff Keyser attended University Of Vermont, Phillips Exeter Academy.

What skills is Jeff Keyser known for?

Jeff Keyser has skills like Data Warehousing, Etl, Databases, Oracle, Data Modeling, Sdlc, Pl/sql, Business Intelligence, Sql, Db2, Database Design, Solution Architecture.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.