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 s, 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/2008 R2/2 Yrs), UDB/DB2 7/8/9 (8 Yrs), DMS 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 Yrs), .Net (10 Yrs), MS-SSIS 2005/20 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 Yrs), Ada 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 teh 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 dat would support AWS Cloud SSO federation and VPN requirements.
• Developed future state road map dat 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 teh 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 / ETL Architect

Responsibilities:

• Provisioned two AWS EC2 instances, development and test, with RDS SQL Server 2012 to manage teh ETL processing side of teh HP Information Life Cycle Management (ILM) toolset. Developed scripts to manage file processing and interface to SSIS packages dat handle me/O and data management with teh 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 teh migration and obtain user acceptance.

Confidential, Boston, MA

Lead AWS Cloud Architect / ETL Developer

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 dat supported teh Confidential AMO Application portal.

Confidential, Boston, MA

Lead Principle BI Architect / ETL Developer

Responsibilities:

• Responsible for teh data architecture and design of database changes required to support teh migration from legacy system to teh new data warehouse and SAP Hanna implementation.
• Developed T-SQL stored procedures, scripts and SSIS packages for teh 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 / ETL Developer

Responsibilities:

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

Confidential, Minneapolis, MN

Data Architect

Responsibilities:

• Responsible for all artifacts related to teh analysis, design and development of teh 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 / ETL Developer

Responsibilities:

• Responsible for design and development of logical and physical models using Erwin 7.
• Source system was DB2. Teh 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 teh 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

Lead Principle BI Architect / 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 dat 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 dat 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. Teh model was comprised of approximately 700 tables for teh iSeries transactional system and 100 tables for teh 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 teh company. Stored procedures, scripts, SSIS packages, SSRS reports were developed to meet teh requirements.

Confidential, Minneapolis, MN

Lead SQL Database Developer

Responsibilities:

• Responsible for producing conceptual, logical and physical database models for a client s application using Erwin for SQL Server 2008 databases and .Net framework. Teh design implemented supported staging, a data warehouse, and data marts.
• Responsible for all artifacts related to teh analysis, design and development of teh databases, Requirements Analysis, Data Models, Data Mappings and ETL design, and ETL development.
• Developed teh DDL for teh physical implementation and teh 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 teh next generation of teh software product.
• Developed SQL Server SSIS packages to convert DB2 legacy data and populate teh SQL Server 2005/2008 databases and enhance teh HL7 and XML interfaces to support teh 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 teh 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 / Migration Architect

Responsibilities:

• Responsible for data analysis, data profiling and source to target data mappings of relevant data to support teh requirements and design models proposed.
• Designed and developed an in-house metadata repository dat met UHG enterprise data governance standards. Teh new data repository was used to maintain teh metadata for teh database objects, data mappings, data models and transformation rules. It was deployed on SQL Server 2005 and used VB.Net as teh 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 teh logical and physicals data models and deploy teh new 200 gig target database to SQL Server 2005.

Confidential -Columbus, OH

Lead Data Architect / Database Migration

Responsibilities:

• Developed ETL routines in COBOL, Perl and MS-SQL Server SSIS to migrate data to teh new IBM/zOS/DB2 target system. Developed SSIS data flows to extract, transform and move data to teh 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 teh 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 dat 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 / Database Migration

Responsibilities:

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

Confidential, Roseville, MN

Cobol Programmer / Oracle Database Architect

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 teh conceptual, logical and physical model. Data analysis, profiling and mappings were performed to meet teh requirements of teh new system.
• Managed teh full life cycle development of a data warehouse and several data marts to support teh legacy migration. Designed and developed a Metadata repository.

Confidential, Lexington Park, MN

Database Manager / Database Administration / Database Developer

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 teh migration of legacy applications on teh 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 dat 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 teh 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.