Jonathan Bilder Email & Phone Number

London, Gb

EY Global Services Limited, Associate Director, Senior Architect Supply Chain, 2020-Present I set the data strategy tone and vision for EY’s Tax and Finance Operate engagements and data supply chain. ➨ Developed the MDMBasic Data Governance tool within one year, creating the standards, guidelines, data cleanup, and harmonization, to establish data governance and quality. ➨ Led all MDM and Data Governance processes and harmonized several tax data systems with a specialization in the data supply chain, including ETL and architecture. ➨ Directed the execution of the Tax and Finance Operate data strategy during the transition and transformation phase, and aligned the data strategy in collaboration with technology and operations solution leaders

Parsippany, Nj, Us

• Responsible for the integrity of logical and physical data models. Includes stewardship of data models and management control and authorization over changes to the model. Fine-tuning and maintaining key data models for security, performance and stability.• Provide input to data architecture and infrastructure services to help profile the current and future business needs of the organization.* Database administrator development environments for Oracle, DB2, and Redshift instances.

Toronto, Ontario, Ca

Responsibilities include the ingestion of data into Podium, the Enterprise Data Lake (EDL) for TD Bank. Customer source systems include CIBAR and XAUS1. System requirements gathering, source to target mappings and identifying critical data elements for ingesting into the EDL. Source systems include SQL Server and mainframe environments. Data quality and data lineage are key components toward project completion. Additional technologies include Podium, Akora, TIBCO mailboxes and Talend.

Lawrence Township, Nj, Us

 Responsibilities included gathering and documenting functional and technical requirement and creating workflows (ARIS/VISIO) and data modeling.  Technologies included Enterprise Data Lakes, Amazon Web Services, and Athena. Oracle 12C and Sql Server 16 are the DBMS servers. Prepared highly detailed workflows, configuration drawings to aid in the understanding of current and future state processes for Concur, Social Media, and Eclipse (clinical trials). Data mapping & data modelling using Eclipse data as input to Web Methods. Prepared of structured and unstructured financial data to the Enterprise Data Lake (Amazon/S3). Use of Athena views to access such data for end-user availability. Design with AWS. Data profiled, data integrated and seamless synchronization key factors in the master data solutions proposed.

DFAST is a regulatory framework that has been designed by the Federal Reserve Bank in order to assess, regulate and supervise banks with $50bn or less in assets. This process will initially locate sources of new risks and updates to existing risks that should be captured within the forecasting process. Responsible for the DFAST Business Requirements which will work as a means to implement the DFAST program. Managed the development of central data repository (CDR) that will store all finance, market risk and credit risk data along with the macro economic variables in a common place. Activities include Database administration and data modeling using Erwin. Develop, document and maintain logical and physical data models that reflect the existing environment. SQL Server Backend. Source Data for model development – implemented a fully-functioning system to monitor, store and control data centrally. The centralized data repository will help improve data quality and processing efficiencies. The CDR was built to store data from multiple sources. An ETL process was developed using T-SQL and stored procedures in addition to linked servers. A comprehensive reconciliation framework was developed and managed by myself to compare data stored in the CDR back to the sources (.xls, xlsx, txt, csv, etc) using SAS. Review data sources and assess data quality. During the model execution cycle, the DFAST SAS model sourced the data from the central repository into the model execution platform. The projection results stored in the CDR will produce the FR-Y16 report.  SAS Risk and Financial Workbench (RFW) is the main platform being used along with the MS SQL Server. Performed data analysis, model execution, platform dashboard to view input, output data, audit data and approve workflows and reporting using predefined input and what-if analysis, ad-hoc analysis.

London, Gb

 Responsible for the design and development of tax software using T-Sql Stored Procedures that will be used exclusively by EY’s clients. Development of stored procedures (T-SQL), triggers, table design, primary and foreign keys in the MS SQL Server environment Developed and promoted both logical and physical data design methodology to maximize performance and to produce accurate and timely results. Maximizing performance of sql to improve throughput. Assured the project meets deadlines and budgetary constraints. Used TFS, Visual Studio and the SQL Server Data Tools Suite for development, schema comparisons and maintaining source control.  Deployed of all SQL software to development, QA and production environments. Data loading to data models to compare pre and post data model designs

Charlotte, Nc, Us

Responsibilities include gathering and documenting functional and technical requirement and creating workflows (VISIO) and data modeling using Sybase Power Designer. Technologies include Enterprise Data Lakes, Amazon Web Services, and Athena. Supporting projects involving the client’s core servicing business areas, translating business requirements and functional requirements to technical specifications and requirements. Preparation of highly detailed workflows, configuration drawings, system reference charts and documentation to aid in the understanding of current and future state processes.

Hyannis, Ma, Us

Senior Data Architect: SAP Data Migration & Conversion, ETL/ Data Governance /SQL DBAResponsible for extraction, transforming and loading SAP legacy data by object into SAP using BackOffice Proprietary software: DSP Migrate. Data Governance and Data Quality manager. Clients include NTT Data, Bio-Rad, J&J and LafargeHolcim and tasks below were provided at the clients:  Established Data Governance: Ensure accuracy & integrity of data & applications through data profiling, writing clear and concise documentation and problem resolution; develop quality metrics and standards Implemented data warehouse designs to collect and extract/transform/load legacy data to core SAP system Developed T-SQL/Stored Procedures/Triggers; tune SQL queries to improve performance Implementation ETL protocols using analytical and data management skills;  Developed data extraction programs using Business Objects Data Services (BODS) Analyze/translate functional specifications and change requests into technical specs SQL Server database administration for development/QA/Production MDM cleanup, consolidation and managing lineage, meaning and impact analysis Led data mapping sessions and requirement gathering sessions subject matter experts Acted as Security Administrator for ETL Proprietary software: DSP/DSMA; added users/managed roles Reporting on data collection, data cleansing and interfacing with client to assure data accuracy

West Palm Beach, Florida, Us

Senior SAS Programmer In this position, responsible for the loading, reporting and analyzing of the data provided via survey questions from those companies participating and competing to make the Top 50. Benchmarking and Report Card reports developed in SAS as are also provided to competing companies. * Data profiling to determine the validity, accuracy and completeness of data using Base SAS Use of Proc Tabulate and Proc Report to standards the reporting programs* Generating reports and datasets to allow SMEs to perform additional analysis* Use of SAS Office Analytics to allow end user to be more productive and efficient.

New York, Ny, Us

Responsible for assuring proper loading of SAP legacy data per object into SAP using appropriate tools which include: MS SQL Server Administration, SQL queries, SAP Business Objects (BODS), BackOffice/Cranberry, IDOCS, UCR and LSMW.  Transform data via mapping and data reconstruction. Data is cleansed, harmonized, transformed and load into SAP. Legacy Systems: PeopleSoft, Oracle, SAP. Liaison between agency being migrated to corporate SAP system, developers, corporate staff. Remediate, communicate and determine deltas in expected data and legacy system data.  Corporate Interface developer - Microsoft’s Biztalk Server. BizTalk Server provides connectivity between core systems both inside and outside the organizations. Develop data quality metrics measuring status and progress towards meeting business needs. MDM cleanup, consolidation and managing lineage, meaning and impact analysis

New York, New York, Us

Responsible for improved reliability, performance, and scalability of the Lawson Corporate Software System. Implemented Lawson and Oracle upgrades; Oracle Database Administration; Unix Administration, and adhoc application and reporting.  Increased report processing time 2000% by fine tuning the Oracle application and Unix Server for both PeopleSoft and Lawson applications. As Oracle DBA, a performance tuning, backup, and recovery system for standard database administration activities, developed Unix shell scripts to automate maintenance of database performance and server reliability, and to maintain overall system uptime.  Designed data load procedures from production to QA and from production to development. Monitoring all server performance parameters (swapping, paging, CPU) to assure that all systems were production-like and system performance levels were maintained. Developed the code required to change the unique identifier for PeopleSoft users from social security to an internal identifier for HIPAA regulations.

- At WINMIL SOFTWARE, premier provider of strategic consulting services located inPrinceton, NJ, performed all database administration and data modeling functions. Developed all logical and physical designs of eEuclid – an internet online airport, automobile and hotel reservation system. - At MERIAL (MERCK and RHONE POULENC COMPANY) located in Woodbridge, NJ was the Data Architect and data modeler for all data warehousing activities surrounding the Pharmacovigilance Information System. Responsible for data marts to support clinical trial analysis by select scientists and doctors - At GE CAPITAL, located in Stamford, CT, the Financial Services unit of American conglomerate General Electric, performed the data architect role as well as the Database and Unix administration roles and spear headed the Y2K Compliance activities. Responsible for creating the datamarts for Corporate E- Sourcing activities. Managed integration of Lawson Purchasing application from Sybase to Oracle. - At IBM, an American multinational technology and consulting corporation located in both Somers and Armonk NY, I performed as project lead for the design, coding, and application development that records and tracks corporate contracts to determine profitability. As the DB2 DBA, I designed and implemented Accounting software applications to close IBM’s Accounting books. Managed the reporting and design of IBM’s equipment sales system program (SAS).

Master Of Business Administration (M.B.A.), Computer Science

Bachelor Of Science - Bs, Accounting