home :: log on ::contact us
Home >>About Us>>Calla Knopman
Web Services
Small Business
Knowledge Base

Calla H Knopman

IT Architect & Data Warehousing/Integration Specialist

Enterprise Strategy, project planning and implementation



Innovative and results oriented IT Architect with 15 plus years of experience architecting solutions and managing projects, resources, outsourcing, data centers and teams through leading edge technology DW/BI solutions. Extensive qualifications in all areas of management and project engagements through the SDLC with exceptional communication skills.

Calla was a former Practice Manager for VIP Consulting, LLC leading the National BI/DW group consisting of 20+ resources, Manager with Bearing Point/KPMG managing the Financial services DW group, and Sr. IT Architect for IBM Global Business Services group. In 2004 Ms. Knopman opened her own firm, Knopman IT Consulting, LLC, from which she subcontracts with large consulting and outsourcing firms to meet fortune 100 company’s business imperatives.

Calla is a hands-on manager and leads by example. Her technical skills include the following high level activities:

  1. Data Warehouse & Mart, Design, Implementation, and Administration.
  2. Data architecture & data modeling
  3. Meta Data strategy and implementation
  4. Installation, configuration, and performance tuning of many BI/DW/ERP software packages.
  5. DBA – Oracle & UDB
  6. ERP/CRM/Supply chain solutions including: PeopleSoft, SAP, Siebel, Oracle
  7. Creation of Center of Excellence.
  8. Performance and tuning of database servers, Unix, and Windows operating systems.
  9. Full development life cycle project management from requirements to testing and go-live processing.
  10. High Availability, Grid and Disaster recovery solutions design and implementation.
  11. Creation/adherence to standards – methodologies, industry best practices, ISO9000, SEI, MIKE, PMP, Velocity.
Core Competencies
  1. System Design & Architecture
  2. QA & Testing Methods
  3. PeopleSoft Admin
  4. Database Admin & Data Architecture
  5. Data Modeling
  6. Data Vault Architecture
  1. Risk Assessment & Management
  2. Disaster Planning and Backup & Recovery
  3. Data Integration Strategy
  4. BI Solutions
  5. Security Management
  6. Data Exploration and Profiling
  1. Data Quality & Integrity analysis
  2. Meta Data Strategy and Implementation
  3. Managing Budget and Resources
  4. Outsourcing Strategies
  5. Standards & Methodologies
Technical Proficiencies
Oracle 8x/9i/10G/11G,Sql Server,Access,VSAM,UDB 8.1,Exposure to Informix,Teradata,Sybase
PeopleSoft 7.5/8.0/8.4 EPM88,SAP r3,Oracle 11i,Seibel,Informatica 4x/5x/6x/7x/8x,Power Echange/Striva,Ascential DataStage 7.5/8.0,Business Objects Data Integrator,Evoke,MicroStrategy 7i,Hyperion,Business Objects XI,Sagent,BEA Web Logic & Tuxedo,OMS & Dataguard,Control-M,Autosys,Erwin,Sybase Power Designer,Metarecon,Mercury Tools,Remedy,Oracle Data Integrator
PeopleSoft-People Tools,Informatica,Datastage,BEA Weblogic,Data Vault,Data Modeling Concepts,Data Warehousing Concepts,Erwin 3.5.2 Administration
Papers and Presentations
Data Integration as a Service, The Painless Upgrade, Metadata Architecture & Discovery, The Convergence of ETL, EAI and EDR.

Work Experience

Knopman IT Consulting, LLC
Aug 08 - Present
Mar 23, 2009 - PresentNYC Fire DepartmentBrooklyn, NY
DW/BI - PMQA BI/DW Architect
  1. Quality assurance and Testing lead for ETL (Oracle Data Integrator), Reporting(OBIEE) and Database teams.
  2. Identification and Rating of critical success factors
  3. Assessment of deliverables for:
    • On time
    • Meeting SOW objectives
    • Requirements Traceability
    • Work Product evaluation and grading
  4. Findings and Recommendations
  5. System Architecture – Stage, ODS, Data Warehouse, Data Marts
Feb 23 2009 - Mar 6 2009NBMEPhiladelphia, PA
BI/DW Training & Mentoring BI Architect
  1. Training consist of:
    • DW Concepts – Company wide
    • ETL Concepts and Market tools – Project managers and Development teams
    • Performance Tuning and Benchmarks – Administrators and superusers
    • Metadata management & Data Quality/Discovery
  2. Mentoring – The design and strategy of the etl process to support corporate business intelligence and data integration initiatives. Focus on reuse of code, processes, resources and technology to reduce future development times and TCO.
  3. Security Design – Profile based – Authentication and Authorization
Dec 3 2009 - Jan 29 2009Hanover InsuranceWorcester, MA
IT Architect - Sr. Solutions Architect
  1. project assessment, gathering requirements and documenting current Future state
  2. OS, RDBMS and Application review and recommendations
  3. Installation and creation of runbooks to document installation and configuration properties for Informatica 8.6 sp4, Exchange and Data Quality products
  4. Working with DBAs on capacity planning and platform scalability
  5. Creation of documents and communication plans for: Steering committee, outsourcing groups, dba and sysadmins, technical lead and management
  6. Project is ongoing, assessment piece completed and servers/application in certification phase
Nov 12, 2009 - Oregon Users Group Speaking engagement
Presentation Title: Data Integration as a Service – Not just an ETL tool anymore
  1. Description: Data Integration as a service is the application of a set of services provided to meet a wide range of business imperatives. DI is far beyond the data warehouse and indeed the DW is a subset of the applications enabled by it.  Enabling DI-AAS across the enterprise in a Service Oriented Architecture provides both the IT and Business unit’s value in: increased IT agility, the ease of metadata management, enablement and conformation to the Center Of Excellence, and reduced total cost of ownership. This talk will focus on the benefits achieved from DI-AAS, the high level architecture to support it and steps to implement. Although DI-AAS can be achieved through a number of products on the market, the presentation is based on the Informatica product suite.
Oct 2008 - PolkSouthfield, MI
IT Architect
  1. 2 day course in Advance Informatica Performance & Tuning (DBA’s and System Admins)
  2. 1 day consulting to apply concepts and review current à future state
  3. Recommendations and changes to current version control process and configuration management
  4. Reviewed and rated different workflow processing
Oct 2008 - BCBSBaltimore, MD
Sr. Consultant - PowerExchange Specialist
  1. Modified and powerexchange 8.5.1 configuration
  2. Setup condense process for UOW
  3. Documented changes to achieve CAPX and CAPXRT
  4. Recommended new staging architecture to support scalability and agility in meeting new projects
Sep 2008 - MotorolaDallas, TX
Metadata Architect - Metadata Specialist
  1. 2 day course in Metadata management taught to 6 Motorola resources (developers, admins and bus)
  2. Utilized Motorola specific applications for lab work
  3. Recommended strategy and effort to load enterprise metadata
Aug 2008 - Sep 2008
  1. Developed training courses (courses sold through Genesee Academy):
    • Informatica Metadata Manager
    • Informatica Advanced Performance & Tuning
    • The Convergence of ETL, EAI and EDR
    • Authored whitepaper: Data Integration as a service
    VIP Consulting, LLC
    Jul 2007 - Jul 2008
    Apr 14 2008 - May 2 2008PeaceHealthEugene, OR
    DW Architect – Data Warehouse Assessment and Future State Roadmap
    1. Current to Future state vision and road map to implementation
    2. SAN and disk allocation and configuration
    3. Service Oriented Architecture Gap review and identification
    4. Workflow process review and recommendations
    5. Data Intake layer Strategy and redesign
    6. Performance tuning – Windows, sql server, Informatica
    Jul 2, 2007 - Jul 18 2008AOCOlympia, WA
    Sr. DW Architect
    1. Technical Lead – Informatica 8.1.1 Upgrade, BO XI R2, Metadata strategy
      • Data Warehouse strategy & architecture
      • Initial & Incremental Load architecture and implementation
      • Informatica installation/configuration and performance tuning
      • Installation of BO XI r2
      • Design of dashboards and ad-hoc reports.
      • Business requirements gathering and analysis
      • Functional and Technical specifications (ETL and reporting)
      • Team management and status reports
      • Project plan and risk management activities
      • Creation of a Center of Excellence for the State Court System enterprise
      • Integration with portal utilities and interfaces
    Sep 26 2007 -
    Ohio Users Group Speaking engagement
    1. Presentation Title:  Informatica 8 Upgrade: Planning and implementing a successful upgrade project
    2. Presentation Description:  This seminar will focus on the objectives of an Informatica upgrade with the benefits and enhancements made to version 8. We will review the new services in version 8, the mapping of old to new and the changes in the administration and security. Discussion points review how the 8.X SOA enablement fits into the broader enterprise IT vision with grid technology and high availability options.
    Sep 2007 - Oct 2007Janus InvestmentsDenver, CO
    Informatica upgrade lead
    1. Upgrade assessment 7.1.4 à 8.1.1 SP4
    2. POC upgrade and analysis of error/bugs
    3. Analysis of current Informatica environment and identification of errors
    4. Recommendations to meet best practices
    5. Oversight of upgrade testing
    6. SAP Connect installation and tuning
    Aug 2007 - Sep 2007
    Informatica beta tester 8.5
    1. Review of 8.5 version
    2. Installation, configuration and performance tuning
    3. Analysis of upgrade enhancements
    4. Regression test of known bugs
    5. Response to Informatica on results
    Aug 2007 - Sep 2007Babson Capital ManagementSpringfield, MA
    Informatica upgrade lead
    1. Upgrade assessment 7.1.4 à 8.1.1 SP4 or 8.5
    2. Performed POC for Partitioning, Grid, Pushdown optimization and High Availability
    3. Alignment of current to future roadmap
    4. Tactical solution to meet enterprise vision
    5. Analysis of current Informatica environment and identification of errors
    6. Recommendations on where best practices gaps
    IBM – Global Business Service
    Jan 07 - July 07
    01/2007 - 06/2007Sr. IT Architect, IBMPhiladelphia, PA
    Application Architect
    1. Sales support – RFP/RFQ responses
    2. ERP solution architecture
    3. SAP Test Manager for internal Ledger projects
    Knopman IT Consulting, LLC
    Feb 04 - Dec 06
    02/2004 - 12/2006President & FounderPhiladelphia, PA
      Aug 1, 2006 - Aug 21, 2006VIP - CernerKansas City, MO
      Performance tuning, database migration and informatica upgrade
      1. Database migration – UDB à Oracle 10G – impact assessment and analysis, modification of scripts, unit testing and troubleshooting
      2. Performance tuning – reduce data window from 12 hours to 4 hours
      3. Review design strategy and improve etl loads for scalability to meet 10 year volume anticipated
      4. Upgrade informatica versions and rehost from windows 2003 to AIX
      5. Meta data reporting and analysis
      6. Modify target warehouse from UDB to Oracle 10G
      7. Implement reusability to reduce development efforts and maintenance times
      8. Re-architect load workflow for restartability and functional requirements
      Oct 1, 2005 - Jun 30, 2006University of FloridaGainesville, FL
      Data Warehouse Architect
      1. Database Tuning – UDB IEEE – Review and modification of Tablespaces, table/index organization, capacity planning, data archiving and sql tuning
      2. Architect solution for incremental processing to replace daily load batches
      3. Performance tuning – reduce data window from 50 hours to 12 hours
      4. Review design strategy and improve etl loads for scalability to meet 10 year volume anticipated
      5. Business meta data reporting and integration
      6. Upgrade informatica versions and rehost from windows 2003 to linux
      7. Implement reusability to reduce development efforts and maintenance times
      8. Lead development efforts to meet reporting needs
      Jul 15, 2005 - Sep 30, 2005AARPWashington, DC
      Data Warehouse Audit and current to future state assessment
      1. Assessment of current state and recommended future state – including integration paths, elemental analysis and reporting needs
      2. Research of Government regulations regarding GLB, HIPAA, PartD and impacts to integration
      3. Identification of cost and reasonableness in current market
      May 9, 2005 - May 27, 2005Core - Ohio Savings BankCleveland, OH
      Informatica Upgrade and architecture assessment
      1. Assessment of current state and recommended future state – including hardware, memory and database placement
      2. Upgrade of version 5.1.2 à 7.1.2
      3. Cleanup of asynchronous processes and methods
      4. Development of best practices and migration plans to enhance usability
      5. Enablement of password encryption and administrative tools
      6. Training: Informatica 7 techniques & Informatica Administration & Performance
      May 24, 2004 - Apr 29, 2005Hewitt AssociatesLincolnshire, IL
      EPM upgrade Informatica Lead, Database tuning and administration
      1. Gap analysis on Upgrade of EPM80 à EPM88 customization fit
      2. Scheduling and Automation design
      3. Architecture and redesign of database (DB2), Data archiving strategy and implementation, SQL tuning
      4. Integration of shared tables with the Budgeting model
      5. Trouble-shooting and resolution
      6. Performance Tuning & Stress testing
      7. Training: Informatica 6 techniques & Informatica Admin & Tuning Development through deployment
      Mar 23, 2004 - Apr 30, 2004Core - NovellProvo, UT
      Informatica Administrator & Development Lead
      1. Installed Informatica 6.2.2 to Linux (redhat advanced server 2.1) and Windows
      2. Upgraded dev,test,prod 5.1.2 repositories to 6.2.2 and performed clean-up
      3. Upgraded 5.1.2 dev rep to 6.1 to obsolesce one system from the same repository
      4. Recommended next steps to meet strategic corporate needs
      5. Documented build process and completed knowledge transfer to client staff
      6. Training – trained 35 resources on new functionality and changes required to run new workflows from upgraded sessions
      7. Trained a group of administrators for performance tuning, backup,recovery restores and best practices
      8. Created strategic development/administration standards for ease of future upgrades and application modifications
      Feb 8, 2004 - Mar 15, 2004New York Daily NewsJersey City, NJ
      Striva Administrator
      1. Reviewed Striva/Informatica Power Exchange installation and modified parameters when needed
      2. Completed change data capture configuration to extract mainframe data into an oracle/unix database
      3. Built out initial bulk loading routines to capture VSAM dataset into four individual staging tables
      4. Completed data model for staging/extract area with appropriate capture information to backout updates if required for dupes and recovery procedures
      5. Built out 4 templates for capturing VSAM changes
      6. Authored development guildelines, templates and standards
      7. Authored disaster recovery document and recommended actions
      8. Architected Database design and creation procedures, backup and recovery plan and configuration scripts
      Bearing Point, LLC
      Jun 2, 2003 - Feb 4, 2004
      01/2002 - 02/2004OneGlobe, for Bearing PointMcLean, VA
      Primary DBA, App administrator - Data center support for 10,000 users
      1. Capacity planning and storage solution design for Development and Production data centers
      2. Build out and administration of 16 databases
      3. Backup, recovery and disaster planning for development and production instances
      4. Build and administration of 16 Peoplesoft instances including FS and EPM
      5. Microstrategy installation, configuration, clustering and admin for dev, testing, uat and production
      6. Informatica installation on UNIX/NT, configuration, migration through dev, testing, uat and production
      7. PeopleTools and patch application through all environments including compare reports and impact analysis
      07/2001 - 01/2002Allegis - Bearing PointBaltimore, MD
      Architecture, Conversion, & Development Lead
      1. Lead team of 8 to upgrade Peoplesoft 7.5 (HR and FS) to 8.0
      2. Informatica administrator and Conversion lead
      3. Architected and designed all ETL processes to convert 7.5 data into 8.0 data model
      4. Review of PS app designer scripts to effect process in Informatica
      5. Requirements, design, development and build of Informatica processes
      11/2001 - 12/2002US Cellular - Bearing PointChicago, IL
      Datawarehouse Assessment
      1. Reviewed ETL and Reporting scripts and sql
      2. Performed a gap analysis between delivery and requirements
      3. Documented fixes and next steps
      KPMG LLP
      Jan 99 - Jun 02
      06/2001 - 07/2001Argonaut - KPMGMenlo Park, CA
      RFP Response and DW Architecture
      1. Assessed Client needs and budgetary issues
      2. Gathered requirements and boundaries of the project
      3. Architected the future vision and roadmap
      03/2001 - 06/2001Bell South - KPMGMontgomery, AL
      Testing Lead and QA assessment
      1. Review of all Ascential Datastage processes
      2. Created scripts to UAT the Ascential data maps
      3. Assisted QA and other teams in understanding the ETL process.
      4. Managed a team of 6 testers
      5. Liason to the business community to confirm requirements were delivered as captured.
      01/2000 - 03/2001CSAA - KPMGSan Francisco, CA
      Data Architect, DBA and development Lead
      1. Oracle DBA; build, configuration, admin and maintenance on all DB instances.
      2. Data Model oversight and architectural recommendations for facts and dimensions.
      3. Sagent E2E installation version 4.2, configuration and management.
      4. Design and development of Sagent ETL maps and drill down reports.
      5. COBOL, JCL programs to prepare data for extraction.
      6. Striva development to extract mainframe data for daily and batch loads.
      01/1999 - 01/2000Arrow Electronics - KPMGFairlawn, NY
      Senior Informatica Developer and Data Modeler
      1. Assisted in Requirements gathering.
      2. Built data model, responsible for forward engineering and compliance.
      3. Designed and built all ETL maps to extract and transform data.
      Dec 97 - Jan 99
      12/1997 - 01/1999AT&TPiscataway, NJ
      Prism Administrator and Senior Development analyst
      1. Design and development of Prism ETL processes.
      2. Unit, system and integration testing.
      3. Metadata repository administration and migration through the life cycle.
      4. Authored Cobol and JCL to extract data from the mainframe.
      Hollister Inc.
      Dec 94 - Jan 96
      12/1994 - 01/1996Hollister Inc.Libertyville, IL
      Senior Chemist, Research and Development
      1. Development and Formulation of wound care adhesives, non-wovens and textiles..
      2. 4 patents authored while with Hollister.
      Environmental Monitoring & Technologies
      Dec 92 - Dec 93
      12/1992 - 12/1993EMTMorton Grove, IL
      Environmental Chemist
      1. Organic and Inorganic lab analysis
      2. Field chemist, PCB wipes, flowmeters, flash points.
      Education & Credentials
      • 1992 – BA equiv. Chemistry, at City College of New York – Phi Beta Kappa
      • 1997 - Chubb’s Institute, Jersey City, NJ –Honors program
      • 4 Patents (Bond adhesive, skin barrier wafer)
      Professional Affiliations
      • Member of TDWI – Data Warehousing Institute
      • Woman’s Bond Club of NY
      • Who’s Who of Information Technology
      • Microsoft Certified Partner
      • IPED Advisory Board