We provide IT Staff Augmentation Services!

Senior Database Architecter Resume Profile

2.00 Rating

SUMMARY

  • I am a senior full life-cycle database architect/developer with a Master of Science degree in Computer Science and over eighteen years of extensive experience designing, developing and implementing large scale database systems. I believe in rigorous, diligent requirements gathering and analysis. My experience includes data modeling, normalization, migration and integration, metadata management, setting data standards and designing for future growth. My primary technical skills include SQL Server, Transact SQL, Oracle, PL SQL, Data Warehousing, Database Tuning, SSIS, SSAS, SSRS, C and ASP.Net. My secondary skills are ASP.Net and C .
  • I have architected and built large scale database systems as they relate to Aerospace, Business Intelligence, Real Estate, Taxes, Health Care, Telecommunications, ERP Systems, Investment, Insurance, Multimedia and the U.S. Federal Budget. Some of my clients for whom I have designed and developed database systems and software include The White House, The IRS, Microsoft, Boeing, SAFECO, The Seattle Seahawks and several dotcom's.

PROJECT PORTFOLIO

Confidential

Senior Data Warehouse Architect/Developer

Designed, built and populated an Oracle data warehouse having 45 tables and an ETL process that reads in 71 different kinds of JSON objects totaling several hundred thousand events daily. I also created an Informatica processes interacting with JSON source and Salesforce. This involves rigorous requirements discovery, data modeling and ETL/data migration. Used ERWin Data Modeler, Oracle 11 and Informatica.

Confidential

Senior Database Architect/Developer

Redesigned, engineered and populated database systems for the Texas WIC program Women, Infants and Children of the Texas Department of State Health Services. This includes the databases for each of the 600 WIC clinics across Texas as well as the State DSHS database. This involved requirements discovery, Data Modeling and ETL/data migration. Used ERWin Data Modeler, SQL Server and T-SQL.

confidential

Senior Database Architect/Developer

Designed an enterprise wide corporate database including all data used by the company in six large disparate departmental databases. Used ERWin Data Modeler, SQL Server and T-SQL. LISCR is the second largest ship registry in the world having almost 400 employees.

confidential

Senior Database Architect/Developer

Designed and implemented the migration of data from the Department of Commerce's 'Export Control Automated Support System' ECASS database into ATSC's USXPORTS database. Used SQL Server T-SQL and Oracle 10g PL/SQL

Confidential

Senior Database Architect/Developer

Supported data migration and data integration of NetCracker products for the Army National Guard's Enterprise Service Desk in Washington, DC and for Shaw Communications in Calgary, Alberta. I developed using Oracle 10g PL/SQL, MS SQL Server 2005, Java and JavaScript. I designed and developed a Java and JavaScript web-enabled Oracle 10g database system to track NetCrackers' compliance to over one thousand individual DOD STIG's Security Technical Implementation Guidelines.

Confidential

Senior Database Architect

Designed and developed several disparate database systems, each having approximately 75 tables. This involved requirements gathering and analysis, data modeling with ER Studio, writing approximately 10,000 lines of T-SQL stored procedures, functions and triggers. Also used Oracle 10g PL/SQL and NIEM National Information Exchange Model

Confidential

Senior Software Developer

  • Designed and developed a 'Versant' object oriented database that tracks all data concerning all electrical and software components on all Boeing aircraft. My efforts involved TCL, Python, Web services, SQL Server 2005, Visual Studio 2005, C , VBScript and JavaScript.
  • confidential Senior Software Developer
  • Designed and developed web-based, BI dashboard applications and data warehouses. This included database performance tuning. Developed using XML, Web services, SQL Server 2005, Visual Studio 2005, C , VBScript, JavaScript, Dundas Chart and Silverlight.

Confidential

Senior Database Architect

  • Designed and built a database system specifically to quickly and easily import, store and retrieve very disparate MLS Multiple Listing Service real estate data sources. This system quickly and easily incorporates new MLS's and quickly searches across all imported MLS's from one unified database. MLS data sources do not adhere to any standards of structure or content. They are as different from one another as snowflakes. This system included an OLTP and OLAP database. I used ERStudio, SQL Server 2005, Transact SQL, SSIS and DTS.
  • The OLTP database I designed has fifty-one tables and replaced a legacy system containing sixty-nine disparate databases, some of which had over four hundred tables.

Confidential

Senior Programmer / Database Analyst

Designed and built two different wizards that imported state, city and local tax rate data into two different ERP systems: Navision and Sage ACCPAC. I also re-designed and built two different tax rate databases. This involved data modeling ERWin , forward engineering the data model into SQL Server 2005 database, performance tuning, writing ETL, and C . This project also involved NIEM National Information Exchange Model .

Confidential

Senior Programmer / Systems Analyst

  • Designed, developed, tested and debugged a distinct segment of STM Statement of Work Management System for the confidential
  • I used C and Transact SQL. STM is slated to replace several disparate legacy systems that have never shared data with each other and have outlived their usefulness. The entire STM application is written in object oriented C with a SQL Server 2000 back-end. I reverse engineered several legacy systems using ERWin 4.1. I also, designed and implemented an ETL Extract Transform and Load plan to extract data from several different legacy databases then transform, scrub, merge and load this data into the new STM database structure.

Confidential

Senior Programmer / Systems Analyst

Designed and built seven major web-based, enterprise wide applications where no such application previously existed. I implemented all of them using Visual Basic .NET, ASP.Net, Erwin, C , Transact SQL and SQL Server 2000. I was solely responsible for the implementation of every aspect of the software development lifecycle for each of these applications including: initial requirements analysis, user interface design, database design, database performance tuning, testing and implementation. I also used Rational Rose Data Modeler to design several databases.

Confidential

College Professor

I taught Intermediate Visual Basic CS322 to 19 students for Spring Quarter.

Confidential

Data Architect

Architected an Oracle dimensional data warehouse for Washington State Department of Health Drinking Water information Technology Project. I also performance tuned this data warehouse.

Confidential

Lead Database Developer

  • Full lifecycle database developer: Functioned as user interface designer, programmer, requirements analyst and lead data modeler. I conducted many in-depth requirements gathering and analysis interviews with business experts including medical doctors, exercise physiologists, registered dieticians and psychotherapists. I assisted in composing functional, technical, design, and user interface specifications documents.
  • Created a data model having over 75 tables and 273 attributes and its corresponding data dictionary using ERwin v3.5.2. I forward engineered that data model to a SQL Server v7.0 database and performance tuned the database. I wrote stored procedures as were requested by other UI developers. I designed and built an administrative UI to the database allowing internal administrators to create, read, update and/or delete records. The UI consisted of 74 different VB v6 forms.

Confidential

Team Lead/Database Architect/Developer

Full lifecycle database developer: Database Architect and Database team lead working with two other DB developers. I designed, built, populated and performance tuned the Etera.com database. Also solely responsible for data conversion as well as writing triggers that updated the legacy DB from the new Etera.com DB and vice versa. These activities involved:

Confidential

Data Modeler/Developer

Full lifecycle database developer: Lead data modeler and web user interface designer for TechnoGym's template / turn-key E-commerce web site. This template site is for gym-clubs that purchase TechnoGym's equipment. The database contains over 60 tables and 150 relationships. The web user interface contains over 60 different web pages. I used ERWIN v3.5.2, Microsoft Front Page v3, and Microsoft SQL Server v7.0. This system can be adapted for use by any of these gym-clubs in order to create their own fully customizable E-commerce web site by filling out and submitting the proper administrative web pages.

Confidential

Sr. Software Architect

Designed and built a database system ManagedEnterprise for use by HMO's. It is a healthcare transaction processing and information system integrating communications between healthcare providers, health plans, and networks, significantly reducing claim and payment processing time, and lowering the administrative cost of provider and health plans. ManagedEnterprise addresses topics relevent to CMS Centers for Medicare Medicaid Services such as Health Plans, Coding, Forms, Benefits and Claims Processing. This is a standardized, all-insurer, web based system handling claims submission, referrals and authorizations, eligibility verification, formulary compliance, and rapid electronic payments. It is HL7 compliant enabling interoperability between disparate electronic Patient Administration Systems PAS , Electronic Practice Management EPM systems, Laboratory Information Systems LIS , Dietary, Pharmacy and Billing systems as well as Electronic Medical Record EMR and Electronic Health Record EHR systems.

Confidential

Data Modeler

Full lifecycle database developer: Lead data modeler for NVST.COM's flagship website which is an 'E-Broker' between entrepreneurs and investors. The site also has 'template' E-Commerce web sites available for any entrepreneur or investor, which subscribes to the site. Interviewed NVST.COM's staff and performed rigorous, in-depth requirement analysis. Created a data model with 72 entities, and 650 attributes using ERWIN v3.5.2 Implemented the physical SQL Server 7.0 database based on the model, and populated 25 tables.

Confidential

Data Modeler

Full lifecycle database developer: Lead data modeler and developer for Milliman Robertson's 'MedGuide' database product. The MedGuide database stores Milliman Robertson's managed healthcare guidelines which had previously existed only in seven volumes of hard copy as well as in several thousand HTML files. The data model I designed using ERWIN 3.5.2 has 72 entities and stores four of the seven volumes of Milliman Robertson's managed healthcare guidelines. I generated a SQL Server 7.0 database from the ERWIN data model then wrote VB 6.0 conversion routines which read several thousand HTML files and wrote specific data to the appropriate tables and fields in the database.

We'd love your feedback!