Steven Jeffers Email and Phone Number
Enterprise Data Architecture at The Depository Trust & Clearing Corporation at
@
The Depository Trust & Clearing Corporation
1600 Amphitheatre Pkwy
Mountain View, CA 94043
United States
Steven Jeffers's Location
Dallas-Fort Worth Metroplex, United States, United States
Steven Jeffers's Contact Details
Steven Jeffers work email
- Valid
- Valid
- Valid
- Valid
Steven Jeffers personal email
n/a
Steven Jeffers phone numbers
About Steven Jeffers
A well-rounded IT professional with over 20+ years of experience in multi-terabyte Enterprise Data Architecture and Business Systems Analysis. Expertise includes Data Architecture, Modeling and Data Warehousing on various BI platforms. Business roles include DBA, Technical Lead, manager and PMP professional.
Steven Jeffers Work Experience Details
-
Enterprise Data ArchitectureThe Depository Trust & Clearing Corporation Dec 2013 - PresentJersey City, Nj, UsEnterprise Data Architecture Group building one of the largest enterprise data warehouses in the world.• Focusing on Big Data - Data Warehousing, Data Integration and Business Intelligence• Performed role as Data Architect (DA) for risk/Enterprise data warehouse• Design numerous data warehouse systems for monitoring the financial markets of the world• Developed numerous corporate standards for data warehousing team, data models, documentationUTILIZED: Erwin 9.5.2, Greenplum 4.3, IBM Banking and Financial Market Industry Data Model v8.6, IBM M1 3.5n, Sybase v15, Infosphere v8.5, Informatica Data Quality 10, Oracle v11, Rapid SQL, PGAdmin v1.4, SQL -
Senior Enterprise Database ArchitectEdmentum Mar 2012 - Dec 2013Bloomington, Mn, Us• Perform daily duties of SQL Server DBA• Working as Project Management Professional (PMP) /SCRUM Methodology• Gather requirements for the design of data warehouse and data mart entities.• Document internal environment and processes using flowchart and diagram solutions.• Architected re-designed of SQL Server Data warehouse using Dimensional Modeling• Re-Design OLAP Reporting Cubes for Sales and Trend Data• Develop SSIS Packages for loading and transforming external source data• Establish data and quality standards including enforcing naming standards.Utilized: PMP, SQL Server Database, SQL Server (Management/SSMS, Integration/SSIS, Analysis/SSAS, Reporting/SSRS) Services, Erwin, RedGate Toolbelt, Microsoft Project, Scrum -
Senior Managing PartnerLincoln Heritage Investments Sep 2011 - Mar 2012The Trusted name in Investments. The Honest Solutions Company for all of your Investments needs, Offering our "Gold Standard" Cutting-Edge Solutions to help you obtain Safe, High-Return, Short-Term Investment Returns. -
Senior Enterprise Data ArchitectCorelogic Inc (Formerly First American) Jan 2001 - Aug 2011Irvine, Ca, Us• Manager/Lead Data Architect on large enterprise wide and international core business system relating to financial, real estate (both residential and commercial), taxes, property delinquency, financial claims, and all aspects of the real estate business.• Multi-terabyte dimension modeling, OLAP, data marts, Star following Kimball methodology on various real estate and tax projects.• Simultaneously engaged on multiple projects interfacing with project managers, system architects and business experts for integrating several thousand tables into the new corporate SOA initiative with design emphasis on a Teradata data warehouse. Activities included core conversion, system maintenance and Oracle Financials all within tight deadlines.• Established enterprise data standards and establishing data quality guidelines with heavy emphasis on internationalization for all system development.• Produce detailed documentation of all designs including table and field level detailed metadata, source to target mapping, with responsibly for holding design review to obtain implementation signoff.• Architect on Real Estate Title Data warehouse team, with daily JAD sessions to gather business requirements, performed logical & physical modeling, performed metadata documentation.• Modelmart administrator responsible for upgrades, maintenance, security and international rollouts.• Lead participate on Corporate Standards Committee with heavy emphasis on data standardization and internationalization for all system development.• Served on Corporate Safety Committee, implementing companywide policies and changes.Utilized Erwin/Modelmart, DB2, ORACLE, SQL Server, Teradata, ADABAS, My SQL, Access, SQL PLUS, TOAD, VISIO, Agile Methodology, Waterfall Methodology, SOA, OOA/OOD, UML -
Senior Enterprise Data ArchitectFirst American (Real Estate Tax Services) Apr 2007 - May 2010Santa Ana, Ca, Us• Manager/Lead Data Architect on enterprise wide and international core business system relating to financial, real estate (both residential and commercial), taxes, property delinquency, financial claims, and all aspects of the real estate business.• Simultaneously engaged on multiple projects interfacing with project managers, system architects and business experts for integrating several thousand tables into the new corporate SOA initiative with design emphasis on a Teradata data warehouse. Also including core conversion, system maintenance and Oracle Financials all within tight deadlines.• Produce detailed documentation of all designs including table and field level detailed metadata, source to target mapping, with responsibly for holding design review to obtain implementation signoff.• Participated on the Real Estate Title Data warehouse team, with daily JAD sessions to gather business requirements, performed logical & physical modeling, performed metadata documentation.• Performed several analysis and feasibility studies on the effectiveness of new systems and provided recommendations to management.• Modelmart administrator responsible for upgrades, maintenance, security and international rollouts.• Lead participate on Corporate Standards Committee with heavy emphasis on data standardization and internationalization for all system development.• Served on Corporate Safety Committee, implementing companywide policies and changes.Utilized Erwin/Modelmart, DB2, ORACLE, SQL Server, Teradata, ADABAS, My SQL, Access, SQL PLUS, TOAD, VISIO, Agile Methodology, Waterfall Methodology, SOA, OOA/OOD, UML -
Senior Enterprise Data ArchitectFirst American (Real Estate Tax Services) Apr 2003 - Mar 2007Santa Ana, Ca, UsAccomplishment Highlight: Challenge: Taxing Authority file in legacy real estate tax and mortgage servicing system no longer able to answer business needs due to its structure.Solution: Re-engineered using relational principles, reducing need for hard-coding in programs and increasing flexibility in storing dates. Breakout of new data elements embedded in comment fields allowed programmatic access to new business conditions.Provided business analysis and resulting data models for dozens of projects on multiple platforms (mainframe ADABAS, midrange Oracle, SQL Server, DB2). For example:• Designed Dimension models for the Title Data Warehouse.• Client-server Oracle DB support of webpage queries via extracts from mainframe property data – InstantData system.• Client-server Oracle DB payee-code administration for Mortgage Business Association (MBA) – MBATax system.• Client-server Oracle DB mainframe extracts of tax service data for accounting reporting - for the Fee-Based Runoff Reporting system.• Mainframe ADABAS system for Chase Bank - Tax Refund Tracking system.• Mainframe ADABAS re-engineering of customer handling for internal legacy real estate tax and mortgage servicing system – the TALON system.Stored all entity-relationship model (ERD) and metadata in CA ERwin and ModelMart enterprise repository. Ensured that all designs met business requirements and design standards.
-
Senior Enterprise Data ArchitectFirst American (Real Estate Tax Services) Jan 2001 - Mar 2002Santa Ana, Ca, Us
-
Senior Data Architect / Object Oriented Designer ConsultantTxu Energy Sep 2000 - Dec 2000•Member of a design and development team for the Device Inventory Tracking System in preparation for government energy deregulation.•Primary Contributor in all design specifications, development, reviews and walk thru’s. The scope encompassed the entire flow including cross application interfaces.•Facilitated end user JAD sessions gathering business requirements, system flows and enhancements, documented with UML (OOA/OOD).•Primary DBA creating, modifying, tables, columns, indexes, named constraints, PF, FK, User Roles, modifying Stored Procedures.Utilized SYSTEM ARCHITECT 2001 7.x, ORACLE 7.3, POWERBUILDER 6.5, UML, OOA/OOD, PFC, PL/SQL, TOAD 6.x, SQL LAB 4.x, SQL PLUS 3.x, WINDOWS NT 4.x
-
Sap Fi/Co ConsultantDr Pepper / 7Up Sep 1998 - Sep 2000UsSAP R/3 Functional, ABAP/4 Programming, SAP Basis, Consultant on SAP Financials•Facilitate end user JAD sessions gathering business system change requirements for 3 major projects which included Marketing Funds, invoice verifications and Vertex (a tax software package) systems.•Conducted and documenting GAP analysis for financial system changes. Including setting up new manufacturing division configuring companies, controlling areas, cost elements, credit controlling, tolerance groups. Inter-company accounts and bank accounts.•Developed and enhanced numerous online and batch programs using functional knowledge. These report ranged from very complex corporate wide reporting to simple financial reports.•Performance tuned Oracle, SQL and monitored SAP via SAPDBA database performance analysis. Also monitored system errors and searching OSS notes for enhancements.•Setup user security profile/authorizations, scheduling of jobs, configurations and SAP installs.•Interviewed new candidates for open position, conducted training classes, and lead implementation of a technical standards committee.Utilized SAP FI/CO MODULES, SAP R/3 3.1H – 3.0E, ORACLE 8.0 & 7.3, DIALOG PROGRAMMING, SAP SCRIPT, VERTEX 1.3-1.2, TAX DECISION MAKER, QUANTUM SALES RETURNS, AIX UNIX
Steven Jeffers Skills
Data Warehousing
Business Intelligence
Data Modeling
Databases
Enterprise Architecture
Business Analysis
Oracle
Sdlc
Requirements Analysis
Ssis
Microsoft Sql Server
Agile Methodologies
Data Integration
Db2
Data Architecture
Dimensional Modeling
Sql
Management
Olap
Soa
Business Requirements
Pl/sql
Data Quality
Database Design
Embarcadero
Master Data Management
Teradata
Erwin
Performance Tuning
Pmp
Etl
Relational Databases
Scrum
Data Management
Project Management
Data Warehouse Architecture
Program Management
Relational Data Modeling
Ssrs
Data Marts
Informatica
Software Documentation
Analysis Services
Metadata Management
Data Analysis
Project Implementation
Directors
Data Governance
Greenplum
Cognos
Steven Jeffers Education Details
-
Eastern UniversityOrganizational Leadership -
Madison Area Technical CollegeInformation Systems (Mis)
Frequently Asked Questions about Steven Jeffers
What company does Steven Jeffers work for?
Steven Jeffers works for The Depository Trust & Clearing Corporation
What is Steven Jeffers's role at the current company?
Steven Jeffers's current role is Enterprise Data Architecture at The Depository Trust & Clearing Corporation.
What is Steven Jeffers's email address?
Steven Jeffers's email address is sj****@****.rr.com
What is Steven Jeffers's direct phone number?
Steven Jeffers's direct phone number is 212-855*****
What schools did Steven Jeffers attend?
Steven Jeffers attended Eastern University, Madison Area Technical College.
What are some of Steven Jeffers's interests?
Steven Jeffers has interest in Teradata, Ca Erwin Modeling, Senior Enterprise Data Architect, Sql Server, Metadata Management, Data Warehousing, Db2, Data Modeling And Meta Data, Data Warehouse Architects, Erwin Data Modeling.
What skills is Steven Jeffers known for?
Steven Jeffers has skills like Data Warehousing, Business Intelligence, Data Modeling, Databases, Enterprise Architecture, Business Analysis, Oracle, Sdlc, Requirements Analysis, Ssis, Microsoft Sql Server, Agile Methodologies.
Who are Steven Jeffers's colleagues?
Steven Jeffers's colleagues are Raymond Keckler, Michael Hartshorn, Steven Todorow, Jim Moorehead, Sean Mullen, Clarissa Mae Anulat, Sunita Vaswani.
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
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.
Start your free trial