Data Architect / Manager

DARRYL BUEFORT

Cell 857-***-**** ********@*****.***

CAREER SUMMARY

Highly productive, driven, data architect with a successful 20+ year track record delivering technical solutions to business requirements. Proven ability to innovate, design, and implement project as well as enterprise databases along with supporting ETL and application interfaces. Specializing in data analysis, data modeling, data architecture, database design, project management, complex problem solving, documentation and communication. Experienced leader delivering quality database systems on time and within budget within a fast-paced, multi-project, multi-organization environment.

TECHNICAL SKILLS

Data Modeling: Enterprise, conceptual, logical, physical, dimensional, XML

Data Modeling Tools: PowerDesigner, Oracle Designer, ERWin

Database Tools: TOAD, DBArtisan

Databases: Oracle 9x, 10g, Sybase, Informix, MS-Access

Programming Languages: SQL, Stored Procedures, Triggers, UNIX scripting

Methodologies: SSADM, SDLC and derivatives, Agile, RAD

EXPERIENCE

Fidelity Investments, Boston, MA

Data Architect 2004 - 2008

Principal Data Analyst 1999 - 2004

Data Modeler 1993 - 1999

Developed and integrated features and functionality into enterprise-wide subject area databases

The enterprise-wide database provided an 80% jumpstart in the development of new applications. Maintaining stable and extendable data models were the foundation for these databases. Databases were implemented on Oracle platform supporting enterprise level OLTP applications. This solution significantly reduced overall system development costs.

Duties included:

• Created and extended subject area logical and physical data models

• Mapped data and functional requirements against existing data structures and application services

• Designed new and revised SOAP web service specifications

• Developed and implemented database objects (stored procedures, triggers, etc.)

• Provided architectural solutions integrating individual projects into shared databases

• Managed projects through complete application development life cycle

Designed and implemented Customer Relationship Management (CRM) data warehouse solution

The objective of these projects was to provide an integrated view of a customer's communication from various systems throughout the firm. Developed solution for multiple business units. Projects provided benefits toward organization's customer service and marketing initiatives.

Duties included:

• Led star schema data model analysis and design exercises

• Conducted data source discovery and data mapping analysis

• Designed new and revised ETL functionality

• Documented specifications and managed approval process

• Managed data model revisions through change control process

Designed and implemented database objects for Fidelity.com redesign

The project objective was to reface applications and functionality on Fidelity.com with Web 2.0 tools and components. Enterprise wide, multi-organization project implementing new tools and new Agile development methodologies. Project enabled Fidelity.com to remain current with state-of-the-art web technology.

Duties included:

• Designed and integrated new features into existing database sub-systems

• Created new data models and delivered complete new database sub-systems

• Performed project and resource management for database deliverables

• Managed analysts working on concurrent sub-projects with integrated deliverables

• Managed database and application integration points to ensure product integrity

Delivered and maintained Electronic Fulfillment reporting data warehouse solution

The project objective was to deliver a reporting database and Brio reports for electronic fulfillment transactions. Project enabled Fidelity Advertising management to view summarized totals for fulfillment requests processed the previous day.

Duties included:

• Conducted JAD sessions to extract business requirements and documented technical specifications

• Designed and implemented new star schema extensions to existing database product

• Conducted analysis and designed ETL solution

• Coded and delivered database code and UNIX scripts to initialize product

• Managed resources to maintain product fixes and enhancements

Implemented and extended enterprise-wide Electronic Message delivery systems

The project objective was to build and maintain a database and supporting services for inbound and outbound electronic messages to any and all devices. Enterprise solution provided scalable platform supporting all business units. Product supported delivered account statements, trade confirmations, prospectus notifications, customized messages, offers, email, pager messages and other communications throughout the firm.

Duties included:

• Designed and extended logical and physical data models for database product

• Served as primary client contact managing multiple projects providing new and enhanced functionality

• Created and extended data structures and services to maintain product performance and integrity

• Extended and reused solution to support various business units, content types, and recipient devices

Designed and implemented database and associated services for PAS client

The project objective was to build a database product providing client account reporting for high profile clients. Project provided a self-service solution integrated into corporate website and alleviated requests for customer service resources.

Duties included:

• Translated business ideas to document data requirements and a technical solution

• Analyzed and designed data model incorporating clients, accounts, and account positions

• Analyzed and designed application interfaces to retrieve formatted XML data

• Developed ETL services to import source data

• Developed query services to retrieve data

Developed, implemented, and managed compliance delivery product

The project objective was to provide a internal product to migrate compliance data off the enterprise OLTP database to a SEC compliant optical database. Product provided a pluggable solution to new and existing applications to meet compliance standards without incurring development cost.

Duties included:

• Designed and implemented a database and standard set of application interfaces

• Designed scalable solution to accept and transport various content types for legal archive

• Evaluated and managed new requests against existing database product

• Managed product development and maintenance budget

Managed team of analysts and database deliverables for marketing campaign management initiative

The project objective was to build a new system to fast-track delivery of marketing campaigns. Project scope included new campaign initiation interface, automated data extraction processes, and distribution management functionality. Project reduced manual procedures and provided checkpoints and controls to rapidly deliver new marketing campaigns.

Duties included:

• Acted as project manager responsible for planning, designing and delivering database components

• Managed analysts and delivered specifications for new rule-based extraction of campaign lists

• Managed developers and delivered ETL and database code supporting specifications

Authored firm specific Agile database development methodology

The objective was to integrate new Agile system development techniques with the corporate SDLC methodology.

Duties included:

• Researched and identified relative database design techniques from industry established Agile methods

• Merged structured new techniques with database delivery techniques with Agile methodology

• Documented methodology and initiated process to standardize approach for future Agile projects

Managed portfolio of database projects

Responsible and accountable for budget and deliverables within project portfolio.

Duties included:

• Performed resource and client relationship management for 10-15 projects

• Provided budget estimate for project resources, deliverables, and timeline during project initiation phase

• Maintained project run rate to ensure project was delivered on time and within budget

• Mentored team members designing and troubleshooting solutions

Co-chaired Data Model Review Committee

The objective was to certify new and enhanced data models and provide feedback regarding good modeling practices. Committee prevented redundant databases eliminating useless development cost and expedited system deliver dates.

Duties included:

• Advised design alternatives on project data models to optimize design specifications

• Previewed and consulted on integrating project models into larger subject area database designs

• Redirected project initiatives towards refactoring solution over new development

Implemented Corporate Logical Data Model (CLDM)

The project objective was to create and maintain a corporate level logical model representing a common understanding of the core business data elements and their requirements. The CLDM provided a blueprint for data models within a specific domain and facilitating data sharing strategies. The CLDM contained over 400 entities, 1200+ relationships, and 1700+ attributes. Project achieved a 70% reduction in database related development costs over time.

Duties included:

• Member of 6 person team designing, integrating and publishing revisions to CLDM

• Modeled and maintained ERD for Financial Instrument and Corporate Actions subject areas

• Teamed with business analysts and domain experts to continually enhance quality of CLDM product

• Maintained data dictionary and delivered monthly updates to technical community

Delivered project providing mutual fund recommendations

The project objective was to provide fund recommendations for both Fidelity and non-Fidelity funds. Project enabled additional mutual fund research on Fidelity.com.

Duties included:

• Analyzed and designed ETL solution to import internal and external data into project database

• Designed solution to version and archive fund recommendation data

• Contracted with data providers developing service level agreements for incoming data feeds

The Shareholder Services Group, Boston, MA

Senior Business Systems Analyst / Programmer 1987 - 1993

Analyzed and documented process to produce price suspension

The project objective was to enable mutual fund processing in the event of missing or incorrect fund price. Project would enable mutual funds to utilize previous day's price with additional contingency processing.

Duties included:

• Acted as liaison between business and system personal to confirm requirements

• Documented requirements and facilitated approval process

• Developed and executed test plan

• Coordinated program implementation

Analyzed and documented requirements for reporting application

The project objective was to enhance existing daily reports. Project increased the value of transaction reports.

Duties included:

• Met with client to obtain details requirements

• Documented and conducted design reviews to obtain approval

• Coded new programs and scripts and integrated into nightly batch cycle

EDUCATION

University of Phoenix, B.S. Information Technology (Ongoing)

Online Trading Academy, Futures Trader Certificate Program 2010 Online Trading Academy, Options Trader Certificate Program 2009 Online Trading Academy, ProTrader Certificate Program 2008 Boston University Corporate Education Center, IBM Programmer Certificate Program 1991

Contact this candidate