Owner/bi/dw Architect Resume
3.00/5 (Submit Your Rating)
Austin, TX
SUMMARY:
- As a Systems Architect responsible for Planning, Design, Implementation, Maintenance, and Documentation of Novell (2.X, 3.X, and 4.X) and Microsoft (NT 3.X, 4.X, Windows 2000, 2003, 2008, 2008 R2, 2012 Server) based solutions including specification/configuration of Server/SAN/LAN/WAN hardware and MS Infrastructure support services (AD/DNS/WINS/DHCP) .
- As a Virtualization/Cloud Solutions Architect responsible for Planning, Design, Implementation, Maintenance, and Documentation of Managed, Virtualized Systems, for DEV/QA/STAGING/PROD environments to support application development/deployment. This includes specification/configuration of Virtualization Infrastructure (Servers, SAN, Network Components) and/or the Cost - Optimized, Fault-Tolerant AWS Equivalent.
- Dell/HP Hardware, VMware/MS Virtual Server, Microsoft’s System Center Operations Manager (MOM/SCOM), System Center Configuration Manager (SMS/SCCM)
- Amazon Technologies implemented/configured include:
- Cloudformation, S3, EC2, DynamoDB, RDS, EMR, Kinesis, Redshift, Cloudwatch, OpsWorks (Chef)
- As a “full life cycle” Data Architect/DBA/Developer, responsible for delivery of Data Services (Conceptual, Logical, and Physical), Planning, Design, Implementation, Maintenance, and Documentation of, Database Servers, Databases, Database Objects (Tables, Indexes, Views, Triggers, Stored Procedures) and full OLTP (coded in T/ANSI SQL)/OLAP (coded in MDX) Data Services Applications using MS SQL Server versions 4.21a, 6.0, 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2012 R2, 2014 and 2016.
- Tasks performed, tools utilized, and technologies implemented/configured include:
- Infrastructure planning/implementation, Requirements Analysis, Data Modeling using ERwin, ER/Studio, and Visio to develop Normalized (3NF) and Denormalized (star, and snowflake) schemas, SQL Server Master Data Services (MDS), Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), Replication, Security, Performance Tuning, Disaster Recovery/ High Availability Solutions (Active/Passive and Active/Active Clusters, Log Shipping, Database Mirroring, and AlwaysOn High Availability Groups), Establishment & Monitoring of scheduled tasks (Database Integrity Checks, Index rebuilds, Backups, ETL Processes, etc.), and Training IT personnel to assume the DBA/Developer Role.
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
Owner/BI/DW Architect
Responsibilities:
- SQL Server Consulting - Microsoft BI Stack: - Performance Tuning
- AWS Consulting - DynamoDB - Redshift - Budget-Driven, Automated Environments
Confidential, Austin, TX
BI/DW Architect
Responsibilities:
- Developed multiple Analysis Services (SSAS) Solutions.
- BI Revenue Report - SSAS Tabular Model Solution for Finance
- Developed (Refactored) Dimensional Model for Confidential Sales Data in Visio.
- Developed the SSAS Tabular Model
- Developed SSIS Packages to Populate and Refresh the Model
- Upsell ROI - SSAS Multidimensional Model Solution for Business Development
- Developed Dimensional Model for Confidential Merchant Sales Data in Visio.
- Developed the SSAS Cube
- Developed the MDX for the creation of Calculated Members in the Cube
- Developed SSIS Packages to Populate the Model and Refresh the Cube
- Developed a SQL Server 2014 ANSI-SQL “Distributed” ETL (DETL) Solution
- Extract Product/Sale/Payment/Shipping data from over 50K Merchant databases.
- Developed the Merchant ODS (+5TB) Data Model in Visio
- Developed the ETL Stored Procedures that run at each SQL Server
- Move the data to the ODS
- Developed the SSIS Package to handle Upsert into the ODS
- Worked closely with the Storage Engineers to allocate the disk space
- Developed SQL Server 2014 Data Services Solutions
- Extract Google Analytics Data.
- Developed the SSIS Packages to pull the data
- Package populated a data model used for Reporting
- Extract Salesforce Data
- Developed the SSIS Package to extract Salesforce data
- Package replaced a custom C# application being retired
- Lead Team Developing ETL from MongoDB to Redshift
- MongoDB Documents/Nested Documents Source
- SQL Server Relational Model Target using SSIS
- SQL Server Relational Model to Redshift Dimensional Model using SSIS
- Refactored existing SQL Server Dimensional Models into Redshift Data Warehouse
- Backup DBA for support on Transactional as well as Decision Support SQL Servers
- Configuration/Monitoring of Transactional Replication used for ETL
- Performance Tuning of SQL Servers
Confidential, Austin, TX
Contract Data Architect
Responsibilities:
- Developed Analysis Services (SSAS) Solution
- Graduation Rate - SSAS Multidimensional Model Solution for State Reporting
- Developed the Dimensional Model using Database Diagrams
- Developed the SSAS Cubes
- Developed the MDX for the creation of Calculated Members in the Cube
- Developed SSIS Packages to Populate/Refresh the Model/Cubes
- Backup DBA for support issues on Decision Support SQL Servers
- Installation of Virtualized Active/Passive SQL Server 2008R2 Clusters for DEV.
- Performance Tuning of SQL Servers.
- Performed a Quest Spotlight Proof Of Concept and presented to Team
- Decision was made to standardize on Quest Products for Monitoring and Troubleshooting
Confidential, Austin, TX
Contract Sr. Data Architect
Responsibilities:
- Prototyped a Master Data Services (MDS) Solution for Oil and Gas.
- MDS uses Business Rules to determine the Master Data Record
- Well information comes from multiple sources
- Source typically hand written and keyed in by Data Entry Clerks
- Multiple sources may contain the same data point with different values
- Participated in the development of a Data Model for a new feature.
- Agile Dev Team adding the ability to provide Well Fracking Data
- Using ER/Studio on a Model based on the PPDM Data Standard
- Added Confidential Extensions to store Fracking Related Data Elements
- Developed Source-to-Target Mappings of Fracking Data into the Model
- Developed/Maintained SSIS Packages to populate the model
- Participated in the design and development of a data export solution.
- ANSI-SQL based back-end that produces exports of Well Data
- Capable of 250K Well Exports - 1K was previous limit
- Multiple complex record structures for a given Export Format
- Application supports seven Export Formats
- Existing java based Export took up to 10 minutes for 1K Wells
- During development, the Product Manager asked me to Produce a 750K Well Export. It took less than 12 minutes.
- Backup DBA for support issues on all SQL Servers
- Installation of SQL Server 2012 AlwaysOn Availability Group for access by Export
- Performance Tuning of SQL Servers.
Confidential, Austin, TX
Contract Sr. Data Architect
Responsibilities:
- Lead Data and Systems Architect for the Texas Windstorm Data Warehouse.
- Developed/Maintained SSIS Packages
- Developed/Maintained ETL Stored Procedures
- Established Virtualized DEV/QA Environment
- Built VMHosts from reclaimed Servers
- Developed DEV/QA Configuration w/IDE and Source Control on each VM
- Backup DBA for support issues on all SQL Servers
- Installation of SQL 2008R2 Log Shipped databases for Read-Only access by DEV.
- Performance Tuning of SQL Servers.
Confidential, Austin, TX
Sr. Data Architect
Responsibilities:
- Automated Quarterly Callaway Catalog Mailing List
- Multiple Callaway databases contain Consumer Subscriptions
- Shop.Callaway.com’s eCommerce Website Database
- The Marketing Dept. Consumer DB
- Export every Name/Address pair from both databases and combine them
- The data set is returned with columns added indicating Duplicate and Type of Duplicate.
- Business Rules - other “Type of Duplicates”
- Family Address - Same Last Name for any number of Subscribers
- Household Address - Different Last Name and less than 10 Subscribers
- Business Address - Different Last Name and 10 or more Subscribers
- Brought the Quarterly Data Cleansing process in house, saving over $15,000 a Quarter
- Negotiated Cost with Vendor for “Data Quality” by FirstLogic
- Installed/Configured software for Address Standardization
- Provided required Information to USPS to allow access for Delivery Point Validation
- Developed a Solution in ANSI-SQL to pull the Magazine Subscription List
- Business Rules
- All non-Duplicate Subscribers
- First Subscriber at a Family Address
- First Subscriber at a Household Address
- Every Subscriber at a Business Address
- Developed a custom MDM Solution
- Developed ODS Data Model in ERwin
- Developed SSIS Packages to pull from the Source Systems
- Developed a Solution in ANSI-SQL to “Collapse” Duplicates in the ODS
- Uses the output of the Data Cleansing routine to identify and cull duplicates
- Performs Operations in a set oriented fashion
- Exercises complex Business Rules for each type of data to be combined
- Performed data pull requests for Marketing Campaigns
- Backup DBA for support issues on all SQL Servers
- Installation of Database Mirroring for both Source Databases to offload I/O.
- Performance Tuning of SQL Servers.