Bob Keith Email & Phone Number

Detroit, Mi, Us

Detroit, Mi, Us

Detroit, Mi, Us

Lead a team big data engineers to onboard the Consumer Deposit Analytic team to Ally’s Big Data Platform in all aspects from education, conversion of existing SAS based jobs to hive/spark/impala automated jobs and direction of platform administration. Develop and implement a self-service-based security model for data stewards. Technical product owner of in house developed tools for a work flow tool for loss prevention, Data Quality and Call Center Applications. Work with internal and external data providers to automate the sourcing of data to platform for Analytics & CRM use cases. (Oracle, SAS, Tableau, SAS Visual Analytics, SAS Business Intelligence, SQL Server, Solaris, Linux, KSH, Hadoop – Hive/Impala/Oozie, Control-M, Redhat BPM)• Lead and provide technical and business understandings/context to team 4 big data engineers for a variety of Analytical and Operational use cases. • Provide a “White-Glove” service to onboard the Analytics team to the big data platform.• Convert existing Value-Added SAS based processes to Hive/Spark process to reduce run time by 75%+.• Technical product owner, provide the business logic and train staff on developed work flow management solutions for loss prevention and data quality applications.• Expand platform capacity to adjust the to the increased workload of platform as it was adopted by the Analytics organization.• Advisement to other LOB’s that onboarded to the platform.

Detroit, Mi, Us

Responsible for designing, implementing, and maintaining the Data & Reporting strategies supporting Product Managers, Marketing and Finance. Provide counsel to business unit leaders in the development and implementation of data management plans and procedures. Work directly with IT to ensure that the business requirements were translated to workable IT deliverables for a Big Data platform build. Communicate and train others on the application of available data methodologies and technical tools. (Oracle, SAS, Tableau, SAS Visual Analytics, SAS Business Intelligence, SQL Server, Solaris, KSH, Hadoop – Hive/Impala/Oozie)• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.• Perform product evaluations and Proof of Concept testing on Business Intelligence tools to implement in the organization.• Collaborate with the Information Technology team on special projects to automate supporting Business Processes.• Provide the business direction, POC, work with IT to build out and validate Ally’s on prem Big Data Platform. • Develop an automation strategy and routine for the value added processes under our management.• Manage relationships with outside vendors in the acquisition of new data elements.• Provide technical guidance and direction to junior developers.

Charlotte, Nc, Us

Responsible for the development, implementation and production management of over 100 BI & UI applications. Applications were utilized by all personnel levels within the Segment, Product & Banking Center channel teams to assist in managing BAC initiatives. Designed & implemented new methods that reduced the total cycle time for production applications. (Teradata, SAS, AIX, KSH, Oracle Essbase, Oracle Hyperion Web Analysis, Executive Viewer, Cognos, DB2, SQL Server, MS Analysis Services, Perl, PowerShell, JAVA, Maestro, Autosys, JAMS)• Managed multiple (Versions 7->9->11) multi-team upgrades of Oracle Essbase, Oracle Hyperion Web Analysis and Executive Viewer implementations consisting over 100+ application conversions.• Prioritized, directed and consulted the efforts of nine OLAP/ETL developers (3 Onshore / 4 Offshore / 2 Contractor).• Improved the processes that extract the data to use more generalized resources resulting in the utilization of non specialized SAS resources.• Implement development and production processes for new OLAP development efforts resulting in decreased development time & increased supportability across the applications for a 200 person user community on a 2 terabyte essbase server.• Provide the technical direction and business use cases for Business Intelligence applications utilized by the Consumer & Small Business bank.• Manage and facilitate the development of constantly changing dimensionality within the OLAPs – resulting in reduced monthly ETL times required by the OLAPs.

Charlotte, Nc, Us

Manager for the Consumer Deposits RDBMS team, of five developers, responsible for creating value added processes against the Enterprise Information Warehouse (EIW), comprising database, ETL and business intelligence components. (Teradata, DB2, SQL Server, Oracle, Informix, Teradata BTEQ/MLOAD/FLOAD, SAS, AIX, KSH, Perl, PHP, JavaScript, IBM Websphere, Apache Tomcat)• Coordinated the efforts between the Technology Service and Fulfillment team and the Deposits MIS team to Migrate the 8 terabyte Debit Data Mart from dB2 to Teradata.• Develop, manage and assist in development of Deposits Data Mart that was utilized as the proof of concept for BAC’s corporate treasury Data Mart – bringing reduced development time to the analysts and increased accuracy/consistency in reporting on deposits throughout the organization.• Manage and assist in development of a payments database, 300mm rows, that track BAC consumer customers’ payments to various merchants.• Implement development and production standards to decrease development time and increase the supportability of production and adhoc applications.• Manage various “stop gap” initiatives, customer facing pilot programs and vendor assisted analytic programs. • Develop and consult on processes to track accounts acquired through the Affinity programs utilized to determine compensation payments.

Charlotte, Nc, Us

(Oracle Essbase, Oracle Hyperion Web Analysis, Teradata, DB2, SQL Server, Oracle, Informix, Teradata BTEQ/MLOAD/FLOAD, SAS, AIX, KSH, Perl, PHP, JavaScript, IBM Websphere, Apache Tomcat, Ansi C, Hyperion Essbase API, AutoSys)• Develop, administer, upgrade and optimize Enterprise wide Essbase databases on Sun-Os and AIX systems.• Develop, administer, upgrade and optimize the Hyperion Analyzer reporting application.• Develop and implement automated processes for staging through production and validation routines for Essbase applications.• Develop, implement and support ETL routines from various RDBMS platforms to Essbase cubes.• Provide training and guidance of Essbase applications to end users and upper management.• Produce proof of concept applications to ensure a feasible development solution.• Project managed various Card Services analytic applications.

Overland Park, Kansas, Us

(Oracle Essbase, Oracle Hyperion Web Analysis, DB2, SQL Server, Oracle, KSH, Perl, PHP, JavaScript, IBM Websphere, Apache Tomcat, Ansi C, Hyperion Essbase API, MicroStrategy, Perl-CGI, Visual Basic, Crystal Reports, VSS, RCS)• Implement, develop, administer, upgrade and optimize Enterprise wide Multi-Dimensional databases across NT and HP-UX platforms.• Develop, administer and upgrade the Essbase and MicroStrategy production, UNIX and NT, environment infrastructure.• Perform ETL routines from the Data Warehouse / Data Mart to Essbase Cubes.• Create Visual Basic and ANSI C, end user applications utilizing the Essbase API on both NT and HP-UX environments.• Develop and Deploy web based DSS applications via the corporate Intranet.• Involved in the data modeling, design, creation and auto loading of the Finance Data Mart.• Perform proof of concept work for new applications sought after by the business unit.• Supervise and provide guidance to the activities of outside consultants utilized by finance in client server developed applications.• Project-manage large-scale enterprise data warehouse multidimensional projects.

Overland Park, Kansas, Us