SUMMARY

• Skilled in all phases of Agile and Waterfall software development lifecycles; experienced in translating business requirements into technical solutions; developing AWS cloud and data migration solutions and scalable high availability architecture; facilitating communication with stake holders, SME’s and IT technical resources; and implementing quality, secure, scalable solutions and following best practices.
• Possess a strong understanding of data management, database engineering and design principles, methodologies and best practices. Fifteen years’ experience using modeling tools to design and implement OLTP and data warehouse solutions. Fifteen years’ developing ETL solutions using native languages including tools like SQL Server SSIS, AWS Glue, reporting applications using SSRS and analytics processing with AWS Athena and SSAS.
• 4 years’ experience designing and implementing high availability cloud architectures with AWS cloud services; EC2, S3, EBS, ELB, IAM, VPC, RDS, Route 53, CloudFront, VPN, SSL Certificates, Direct Connect, CloudFormation, Opsworks, Ansible, Jenkins and cost management. Strong knowledge configuring, administrating and maintaining Windows based platforms, databases and web applications. Working knowledge installing and configuring to Linux Ubuntu and Kali distributions and LAMP.

TECHNICAL SKILLS

Operating Systems: MS - Windows (30 Yrs), Unisys IX (22 Yrs), IBM/MVS (16 Yrs), AIX (8 Yrs), Sun Solaris (7 Yrs), HP/Unix (12 Yrs), Linux Ubuntu (2 Yrs), Linux Kali (2 Yrs)

Database: MS-SQL Server 6.5, 2000/2003/2005/2008R2/2012/2016 (20 Yrs), UDB/DB2 7/8/9 (8 Yrs), DMS-1100 (22 Yrs), Oracle 7/8i /9i/10g (10 Yrs), Teradata (2 Yrs), MySQL (2 Yrs), DynamoDB (1 Yrs), PostgreSQL (1 Yrs)

Database Design Tools: ERwin 7/8/9 (18 Yrs), ERwin Model Manager (8 Yrs), Visio (10 Yrs), ER/Studio (2 Yrs), Oracle Designer (2 Yrs), Power Designer (2 Yrs), SSMS (13 Yrs), Aqua Data Studio (1 Yrs), Toad (1 Yrs)

Database Design Patterns: OLTP Design (20 Yrs), Data Warehouse/Data Marts (15 Yrs), ETL Development (15 Yrs), Master Data Management (MDM) (4 Yrs), SOA Architecture (3 Yrs)

Software Development Tools: MS-Visual Studio 2014 (10 Yrs), .Net (10 Yrs), MS-SSIS 2005/2008/2012 (13 Yrs), MS-SSRS (8 Yrs), SSAS (8 Yrs), MS-Team Foundation Server (3 Yrs), PVCS (8 Yrs), Rational Clear Case (4 Yrs), Rational Clear Quest (4 Yrs), Subversion (2 Yrs), Ansible (2 Yrs), Jenkins (2 Yrs), Confluence/Jira (1 Yrs), HPE ILM (1 Yrs)

Scripting: Perl (4 Yrs), C-Shell/Korn (10 Yrs), MS CMD (25 Yrs), PowerShell (3 Yrs)

Languages: T-SQL (15 Yrs), .Net C# (4 Yrs), VB.Net (4 Yrs), PL/SQL (8 Yrs), SAS (1 Yrs), Java/J2EE (2 Yrs), XML (3 Yrs), COBOL 74/85 (22 Yrs), Ada 83/95 (10 Yrs), Pascal (4 Yrs), MASM (10 Yrs)

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Cloud Architect

Responsibilities:

• On-shore lead for 11 Off-shore ETL developers. Manages On-shore and Off-shore daily development activities and project related tasks.
• Responsible for provisioning on-prem servers and Azure development and test environments; storage accounts, Windows Virtual Machines (VM), SQL Server Databases, SQL Data Warehouse and a Snowflake installation.
• Developed success criteria, test cases and implemented a Proof of Concept (POC) between two Cloud MPP databases vendors, Azure SQL Data Warehouse and Snowflake.
• Developed Powershell scripts, SQL CTAS and COPY INTO scripts and incorporated those into Data Factory activities for the ETL implementation.
• Developed Cloud Readiness and Migration Webinars for Cloud consultants and clients for both AWS and Azure projects

Confidential, Minneapolis, MN

Cloud Architect

Responsibilities:

• Responsible for Cloud Readiness and Assessment tasks at client sites to determine current state technologies and data management capabilities in preparation for Cloud migration.
• Developed 3rd party vendor proposal packages that would support AWS Cloud SSO federation and VPN requirements.
• Developed future state road map that would promote cloud native data management practices and data governance implementation for AWS.
• Designed a Member-Provider MPP database to be implemented with AWS Redshift.

Confidential, Minneapolis, MN

AWS Cloud Architect

Responsibilities:

• Responsible for deployment and maintenance (Cloud Formation, Elastic Beanstalk) of the AWS infrastructure (EC2, ELB, S3, Glacier, VPC, Route 53, CloudFront).
• Developed a messaging application for production control notifications using Lambda functions and SNS.
• Set up administrator and service accounts (IAM, Security Groups, ACL), maintaining system documentation, identifying system performance issues (CloudWatch) and troubleshooting operations issues (CloudTrail, AWS Config).

Confidential, Minneapolis, MN

AWS Cloud Architect

Responsibilities:

• Provisioned two AWS EC2 instances, development and test, with RDS SQL Server 2012 to manage the ETL processing side of the HP Information Life Cycle Management (ILM) toolset. Developed scripts to manage file processing and interface to SSIS packages that handle I/O and data management with the tool.
• Reverse engineered physical data models for 6 legacy applications identified as candidates for an HP ILM proof of concept project.
• Defined and documented test cases used to verify the migration and obtain user acceptance.

Confidential, Boston, MA

Lead AWS Cloud Architect

Responsibilities:

• Member of sales team responsible for developing technical specifications of applications, AWS architecture models and implementation plans.
• Responsible for deploying, configuring and maintaining applications and databases on AWS using EC2, VPC, S3, EBS, Glacier and VPN. Applications ran on SQL Server 2012 and used SSIS for ETL and SSRS for reporting. Used Cloudformation, Ansible and Jenkins to build, deploy and manage configuration templates for version control and customer deployments.
• Responsible for design and development of logical and physical models using ERwin 8 that supported the NTT Data AMO Application portal.

Confidential, Boston, MA

Lead Principle BI Architect

Responsibilities:

• Responsible for the data architecture and design of database changes required to support the migration from legacy system to the new data warehouse and SAP Hanna implementation.
• Developed T-SQL stored procedures, scripts and SSIS packages for the data migration. Developed integrity check reports with SSRS. Deployed SSAS dimensions for BI reporting using Crystal Reporting.
• Defined and documented new data domains and developed logical and physical models with ERwin 8.

Confidential, Chicago, IL

Lead Principle BI Architect

Responsibilities:

• Responsible for the data architecture and design of the database changes required to support enhancements and the new SAP Hanna implementation for the pricing engine database.
• Developed T-SQL stored procedure and SSIS packages to transfer Invoice files to the new SAP implementation.

Confidential, Minneapolis, MN

Data Architect

Responsibilities:

• Responsible for all artifacts related to the analysis, design and development of the databases, requirements analysis, data models, data mappings, DDL and ETL technical design documents.
• Developed logical and physical data models with Power Designer for Teradata databases.
• Reverse engineered legacy T-SQL stored procedures, SSIS packages and MicroStrategy reports to capture data requirements, lineage and data sources.

Confidential, Houston, TX

Principle BI Architect

Responsibilities:

• Responsible for design and development of logical and physical models using Erwin 7.
• Source system was DB2. The target system was SQL Server 2005 database and Sales Force. ETL was a mix of SSIS, Views, Informatica Cloud and Power Center 9.0. SSRS was used for reporting. Team Foundation Sever (TFS) was the source control tool.
• Artifacts produced as deliverables; Source Code, Logical and Physicals Models, ETL Design Document, Data Mappings, Data Dictionary and QA Test Documents.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Responsible for producing logical and physical database models, ETL mappings, SSIS packages, stored procedures, SQL query scripts and VB.Net scripts for ETL applications that processed SAP transactional data into a SAP BPC (Business Planning and Consolidation).
• All development, deployment to QA and Production was on SQL Server 2008R2 databases. SSIS and SSAS packages were developed that processed transactional data into BPC member tables, dimension tables and fact tables.

Confidential, Minneapolis, MN

SQL Database Developer

Responsibilities:

• Responsible for producing and maintaining logical and physical database models using ERStudio for a SQL Server 2008 database. The model was comprised of approximately 700 tables for the iSeries transactional system and 100 tables for the SQL Server 2008 ETL processing system.
• Developed and maintained stored procedures and scripts for SSIS package development and SSRS reports.
• Developed and maintained a Server WEB logfile database of assigned to the company. Stored procedures, scripts, SSIS packages, SSRS reports were developed to meet the requirements.

Confidential, Minneapolis, MN

Lead SQL Database Developer

Responsibilities:

• Responsible for producing conceptual, logical and physical database models for a client awards application using Erwin for SQL Server 2008 databases and .Net framework. The design implemented supported staging, a data warehouse, and data marts.
• Responsible for all artifacts related to the analysis, design and development of the databases, Requirements Analysis, Data Models, Data Mappings and ETL design, and ETL development.
• Developed the DDL for the physical implementation and the ETL using SSIS and stored procedures scripts.

Confidential, Minneapolis, MN

Lead Database Architect

Responsibilities:

• Responsibility to convert 4,500 legacy DB2 database objects from Erwin to Aqua Data Studio and populate missing metadata and implementing a Master Data Management policy.
• Developed logical and physical data models with Business Analyst and Technical Architects for a Web tier ASP.Net platform of the next generation of the software product.
• Developed SQL Server SSIS packages to convert DB2 legacy data and populate the SQL Server 2005/2008 databases and enhance the HL7 and XML interfaces to support the new Web based .Net products.

Confidential, Minneapolis, MN

Enterprise Database Architect

Responsibilities:

• Developed SQL Server 2005 SSIS packages and TPump scripts to import external data sources into the Teradata staging data warehouse database. This was a 5-terabyte data warehouse.
• Participated in requirements analysis, source data analysis, mapping documentation and peer reviews.
• Developed logical and physical models using OLTP and data warehouse star schema designs. Responsible for maintaining Data Governance, Data Quality and modeling best practice standards and policies.

Confidential, Minneapolis, MN

Database Architect

Responsibilities:

• Responsible for data analysis, data profiling and source to target data mappings of relevant data to support the requirements and design models proposed.
• Designed and developed an in-house metadata repository that met UHG enterprise data governance standards. The new data repository was used to maintain the metadata for the database objects, data mappings, data models and transformation rules. It was deployed on SQL Server 2005 and used VB.Net as the user interface.
• Project required hands-on experience with SQL Server 2000/2005, SSIS, VB.Net, Perl, ERwin, XML, and SAS. ERwin was used to create the logical and physicals data models and deploy the new 200 gig target database to SQL Server 2005.

Confidential, Columbus, OH

Lead Data Architect

Responsibilities:

• Developed ETL routines in COBOL, Perl and MS-SQL Server SSIS to migrate data to the new IBM/zOS/DB2 target system. Developed SSIS data flows to extract, transform and move data to the newly developed 3 terabyte target databases.
• Developed system related ad-hoc routines to access proprietary products from both platforms to reduce processing and resource consumption during the migration and conversion process.

Confidential, Minneapolis, MN

Enterprise Data Architect

Responsibilities:

• Facilitated logical and physical data model design sessions with business analyst, technical architects and SME’s to gather requirements and proposed solutions that met their approval upon review.
• Participated in requirements analysis, source data analysis, mapping documentation and peer reviews. Developed logical and physical models using OLTP and data warehouse Star Schema designs.

Confidential, Austin, TX

Lead Data Architect

Responsibilities:

• Team lead for the pre-sale Data Architect group. Performed an assessment of the customer’s existing Unisys platform and COBOL application source to build a database of dependency configuration items. The database is used to allow the customer to better understand the impact of a single application migrating from a Unisys mainframe.
• Used ERwin 4.1 to develop the logical and physical models. Used COBOL to extract mainframe data and Perl to populate the dependency target database. Developed mappings of legacy data that would be ported to a third-party ERP product. Developed stored procedures and SQL routines to accommodate the ERP interfaces.

Confidential, Roseville, MN

Cobol Programmer

Responsibilities:

• Team lead for pre/post sale legacy application migration from Unisys 2200 DMS/RDMS to HP/Unix-Oracle 8i data warehouse. Developed ETL scripts to populate a SQL Server 2000.
• Legacy system required a complete system applications and business process re-engineering. This involved using ERwin to capture the conceptual, logical and physical model. Data analysis, profiling and mappings were performed to meet the requirements of the new system.
• Managed the full life cycle development of a data warehouse and several data marts to support the legacy migration. Designed and developed a Metadata repository.

Confidential, Lexington Park, MN

Database Manager

Responsibilities:

• Team member of a pre-sale proof of concept solution to migrate existing material management legacy applications from Unisys frame to Windows servers and Oracle database.
• Developed a Windows based Visual Basic application to support user requests and problem ticket resolutions.
• Performed requirements gathering, data modeling, logical and physical design using Visio for the migration of legacy applications on the Unisys mainframe to a 3rd party product using Oracle 8i.

Confidential, Biloxi, MS

SQL Database Developer

Responsibilities:

• Developed and maintained an Ingres and OpenIngres database and performed a migration from OpenIngres to Oracle 7.3.
• Developed ETL programs using c-shell scripts and Ada-83 programs to populate unique systems that resided on specialized servers and c-shell scripts for software compiles.
• Used MIL-STD-2167A methodologies, Visio for modeling and design. PVCS for version control.

Ada Software Engineer

Responsibilities:

• Technical lead of 8 software engineers and 2 support staff on an IBM 3080/Ada-83 software project for an Air Force Fuels Inventory and Accounting System.
• Full Life Cycle development required requirements gathering with RAD and JAD sessions, data modeling, logical and physical design using Visio, software development with Ada and complete system and user testing cycles.

Confidential, San Antonio, TX

System Analyst

Responsibilities:

• Responsible for production and technical support for 25 regional data centers at military installations throughout Europe.
• Performed software upgrades, performance tuning, capacity planning, database recoveries and transaction analysis duties to support the data center logistics applications.
• Developed PC applications as a part of a two-tier client-server architecture. Applications were developed with MASM, COBOL, and Ada-83.