Database Development & Modeling
AT&T
• Utilized Platinum ERwin 3.5.2 to model and construct back-end database schemas conforming to IDEF1X and Information Engineering notations. Modeled normalized Entity/Relation and dimensional star- and snowflake-type data warehousing schemas.
• Wrote white papers on metadata issues, the UML-based Open Information Model, and Microsoft Repository 2.0
Blue Shield of California
• Performed sizing exercise for 14TB data warehouse environment: staging area, data warehouse, multi-dimensional data marts.
US Court of Appeals, 9th Circuit
• Technical lead of team which created and converted legacy enterprise database applications to Access 97 and Lotus Notes 4.6 formats.
• Created distributed architecture for Court's databases resulting in decrease in redundant data.
• Wrote transformation rules to cleanse and normalize legacy data and load into Microsoft Access databases.
• Wrote perl and sed scripts to parse legacy data records and SQL queries to normalize table architectures.
• Developed client/server screen scraper applications to provide Windows client access to mainframe databases.
• Trained users in use of applications and data management practices.
Charles Schwab & Co.
• Designed and developed database utilities to track version control and object relationships for multi-dimensional decision support data mart which implements activity-based costing method of budget analysis.