Ed Todd Email and Phone Number

Project Infrastructure Design documentation and coordination

Data management and analysis in Wells Fargo HR IT. Role includes Data Modeling, Integration, Governance design.

Short term assignment to assist with Data Modeling needs.

Data Analyst/Data Modeler in Enterprise Data Warehouse. Supporting the Enterprise Data Strategy design and implementation initiatives to guide data integration, quality, and delivery. Responsible for gathering and documenting business and functional requirements, specifying the table design and the ETL process, and QA and integration testing of implemented tables, Engaged through Alluvion.

Designed and tracked implementation of infrastructure solutions using z/OS, Linux, and Windows networked/clustered platforms; AD security; Oracle, DB2, SQL Server, Hadoop, and Vertica filesystems.• Re-engaged by Bank of America after mandatory contract “time-out” period• Lead virtual teams to prepare design proposals and cost estimates for business units within enterprise architecture standards and budget constraints.• Negotiate cost effective technical solutions to align technologies to business functional and non-functional requirements.• Communicate requirements to technical and non-technical management and operational staff..

Designed and tracked implementation of infrastructure solutions using z/OS, Linux, and Windows networked/clustered platforms; AD security; Oracle, DB2, SQL Server, Hadoop, and Vertica filesystems.• Re-engaged by former customers after mandatory contract “time-out” period• Lead virtual teams to prepare design proposals and cost estimates for business units within enterprise architecture standards and budget constraints.• Negotiate cost effective technical solutions to align technologies to business functional and non-functional requirements.• Communicate requirements to technical and non-technical management and operational staff..

A partner who is a leader in thought and practice, who brings the experience of a seasoned professional in areas such as technology infrastructure and operations, internal audit department creation, audit plan execution, and accounting organization effectiveness and efficiency.Equipped with years of knowledge, I assist clients with overall strategy, plan development, technology requirements, and resource needs and assessment. Transfer of knowledge is always a goal for every engagement.Evaluated and recommended BI tools for financial services client (Banking Industry)• Interviewed prospective vendors and participated in product evaluation sessions to assess functionality, ease of use, and performance of BI tools.• Prepared comparison and recommendation for product selection. Evaluated and documented features of Microsoft Dynamics for marketing company.Converted phlebotomy lab files for planned Microsoft Dynamics installation.

Drive out business requirements and aligns technology solutions to business strategy.• Lead 3-5 subject matter expert virtual teams to prepare design proposals and cost estimates for business units within enterprise architecture standards and budget constraints.• Negotiate technical solutions to align technology to business requirements and expectations.• Communicate requirements to technical and non-technical management and operational staff..NOTE: Reached client-imposed limit of 36 months eligibility as a contractor.

Assisted financial services client in evaluation of BI tools• Interviewed prospective vendors and participated in product evaluation session to assess functionality, ease of use, and performance of BI tools.• Prepared comparison and recommendation for product selection.

Design Data Warehousing, Business Intelligence, and Performance Management (dashboards and scorecards); Technology Assessments; Forensic Technology Services.

In five years I grew a data warehouse from a very rigid 80Gb database, updated monthly and serving 15 users, to a terabyte of Oracle and Essbase databases updated daily, serving 400+ clinical and operational users of Business Objects, SAS, and SPSS solutions. Nearly 300 persons receive scheduled daily reports and the Strategic Management (read that as Balanced Score Card) and Strategic Analysis teams rely on the data warehouse as a primary source of data.• Designed and implemented Antibiotic Risk Management reporting process • Designed performance measurement and strategic alignment data solutions• Implemented data migration, archiving, and retrieval strategy for retired systems• Investigated, selected, and implemented reporting, dashboarding, and scorecarding tools• Designed metadata management approach to support developers and end users• Coordinated Electronic Discovery response to litigation.• Recruited and retained highly functioning team of up to 10 profesionals• Maintained department budget discipline ($1M annual operating budget)• Active in HiMSS data warehouse/information management SIGs• Presenter at MDM Summit, Gartner MDM summit, EPIC Systems User Group, HiMSS

IT Committee Chair and Board SecretaryAdvisory board to the superintendant of the 29 private schools (four high schools, one special needs, and 24 elementary) in the diocese. Issues included internet use policies, security, technology training, and technology recommendations.

Designed, implemented, and maintained multidimensional databases (“cubes”) using Essbase Analytical Server. Installed releases 6.2.2. and 6.5.1 in Unix (Solaris 8) production and test environments. Administered security. Supported end users of Essbase Spreadsheet Add-in and Hyperion Analyzer.Designed relational databases to analyze customer behaviors and profitability by product, and delivery channel. Led business requirements (“JAD”) sessions. Designed logical/physical data structures and generated DDL using ERwin. Developed source-to-target conversion documentation tool.Directed staff examining information technology (IT) controls for Systems Security, Business Continuity Planning, Change Management, Systems Software, and Application Software. Provide technical evaluations and support to other internal units and independent external and regulatory auditors.

• Designed and taught upper-level and post-baccalaureate Information Technology audit class that developed student technical and communication skills through case studies, software projects, and presentations; emphasized control structures; risk assessment; and developing recommendations.

• Designed and taught upper-level and post-baccalaureate Information Technology audit class that developed student technical and communication skills through case studies, software projects, and presentations; emphasized control structures; risk assessment; and developing recommendations

Evaluated information technology controls of data centers; operating systems; applications; software development; disaster recovery/business continuity; security; audit risk. Industries included financial services (banking, credit card, stock transfer), not-for-profit, governmental, manufacturing, and healthcare.

Developed EDP Audit function, performing all scheduling and budgeting, for Fortune 300 manufacturing and regional commuter airlines holding company. Recruited, trained, and directed EDP audit staff. Reviewed data centers, systems software, application software, and security on mainframe, midrange, and personal computers. Provided technical support to internal users and external auditors with audit software and productivity tools. Environments included: IBM mainframe, IBM System p, and HP 3000

Financial Officer for the Provost Office - Budgeting, expenditure approvals, and other fiscal services to the Provost, VP of Undergraduate Studies, and VP of Student Affairs officesInternal Auditor - Innovated use of audit software to sample transactions and reperfom calculations; performed audits of data security, application controls, and data center controls.