Data Architect

LAURA PEARLMAN

** **** ***** ****

Wellesley, MA 02481

**********@*****.***

781-***-**** (h) 617-***-**** (c)

Extensive experience with all aspects of data; passion for using data to transform business requirements into valuable insights, decision-making and reporting solutions

EXPERIENCE

Aug 2008 – Sept 2015 Bose Corporation, Framingham, MA Data Architect – Business Intelligence

- Led data track for implementation of Big Data analytics solution; transformed 7 data sources into one cohesive, usable repository

- Initiated data governance program for Product Lifecycle Engineering data establishing procedures for maintaining high data quality and resolving all data issues

- Developed 360 degree view of the Customer including establishing golden record and federating data back to front-end systems

- Worked on solution for insights from IoT data including design of repository for connected product usage data

- Designed data lake for both traditional structured data and unstructured data using data virtualization

- Created enterprise logical data model for corporation’s essential data - used to identify redundancies and to effi- ciently strategize new data solutions

- Led effort to develop social media analytics strategy including, prototyping dashboards, tool analysis and vendor search

- Served as domain architect to support IT initiatives more effectively by analyzing and determining data require- ments for all projects, improved data quality reporting systems and documenting flows for multiple business pro- cesses

- Created data model and implemented solution for Meta Data repository to track complex data lineage and attrib- utes

Nov 2005 - Jun 2008: Genzyme Corporation, Framingham, MA Data Architect – Enterprise Business Intelligence

- Independently built, designed solutions and established standards and guidelines for Genzyme’s first Oracle- based, custom Enterprise Data Warehouse to transform and process MFG/PRO ERP data

- Designed Finance and Sales & Marketing Business Intelligence solutions to Developed and enhanced systems to capture critical design components from business process flows

- Led effort to influence ‘single version of truth’ across various business functions including Finance, Supply/Value Chain, Manufacturing and Commercial Operations

- Analyzed general ledger and headcount business requirements to come up with detailed data flows to understand complicated processes and where they could be simplified

- Managed team of developers to design, implement and test solutions, trained business analysts in annotation process to capture detailed data requirements and offered ongoing support and review of development of data warehouse solutions

- Completed enterprise-wide data dictionary for Genetics’ DxNavigator and worked with Genetics Data Manage- ment teams to devise enterprise entities and attributes

- Created source-to-target mappings and flows to illustrate data transformations; designed conceptual, logical and physical data models

Mar 2001 - Nov 2005: The Gillette Company, Woburn, MA Data Architect – Business Intelligence and Global Data Architecture

- Designed data models for global data warehouse and enterprise data marts

- Analyzed user requirements pertaining to existing data structures and sources to design new Business Intelli- gence solutions; managed development team to oversee design implementation

- Developed and tested programs, designed reconciliation reports to ensure high level of data quality

- Re-engineered data processing, managed new software releases and scheduling of production processes

- Set up mirror of production processes used for implementing Oracle upgrades, regression testing and perfor- mance tuning; analyzed performance issues to improve processing times by 31%

- Oversaw configuration and environment of test servers for enterprise data warehouse

- Reorganized processes to accommodate major order harmonization project

- Upgraded and simulated data process disaster recovery plan of data process Jul 2000 - Jan 2001: Fact City, Waltham, MA

Content Engineer

- Designed tables, bridged data relationships and engineered adaptions to accommodate varied content modules and constant environment changes, restructuring

- Worked closely with content producers to develop viable products for web deployment by developed and de- ployed scripts to extract and transform data from a variety of data sources Jan 2000 - Jul 2000: Putnam Investments, Quincy, MA Software Consultant

- Supported Risk Management System development and maintained database integrity through modeling

- Wrote and tested code to implement job processing and dependencies Nov 1997 - Sep 1999: Johnson & Johnson, Raynham, MA Software Consultant

- Modified, converted and tested forms and programs for Y2k through code development and bug troubleshooting

- Managed staff of five in converting sales & marketing system from Oracle 6 to Oracle 7.1 and parallel-testing sys- tems of 2000+ programs

Oct 1996 - May 1997: GTE Government Systems, Needham, MA Software Consultant

- Designed, coded and tested programs for financial system to increase efficiency and productivity

- Collaborated with technical team to resolve software issues, allowing users to fully utilize recently installed ac- counting system using an innovative approach to problem solving Jan 1987 - Apr 1996: BBN Corporation, Cambridge, MA Senior Programmer / Analyst

- Developed systems and coded programs for complex job costing system to improve and migrate systems

- Created and implemented enhanced new features for labor tracking and project management systems to facilitate data collection and expedite managers' ability to forecast engineering project budgets COMPUTER SKILLS

Languages: C, Pro*C, PERL

Products: SAP HANA Studio, ORACLE, Developer/2000, Designer/2000, SQL, SQL*FORMS, SQL*PLUS, PL/SQL, SQR, DB2, Syncsort, Fastunload, ETI (ETL tool), ERwin, SAP, BW, Informatica, Cognos, Sql Server, Access Operating Systems: UNIX, VMS, NT

Certifications: ITIL Foundations, CIMdata PLM

EDUCATION

Master of Science, Information Systems

Northeastern University, College of Engineering, Boston, MA Bachelor of Science, Biology

Tufts University, Medford, MA

Master of Arts, Dance

Mills College, Oakland, CA

Contact this candidate