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 EXPERIENCE:

Operating Systems: MS - Windows (30 Yrs), Unisys IX (22 Yrs), Confidential /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), AWS CLI (8 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), Python (3 Yrs)

EMPLOYMENT HISTORY:

Confidential, Minneapolis, MN

AWS Cloud Architect-Developer

Responsibilities:

• Designed an ETL framework to support a relational data warehouse and star schema data mart using AWS native services.
• Responsible for creation of AWS services: CloudWatch, SNS, StepFunctions, Lambda and Glue services.
• Developed Glue Python scripts to support the ETL architecture.
• Incorporated AWS native DevOps services to support development and deployment: Git, CodeBuild, CodeDeploy, CodePipleline and Cloudformation/Cloud Development Kit (CDK).

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 / ETL 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 / 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 that supported the Confidential AMO Application portal.

Confidential, Boston, MA

Lead Principle BI Architect / ETL Developer

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 / ETL Developer

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 / ETL Developer

Responsibilities:

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

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 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 s 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 / Migration Architect

Responsibilities:

• Responsible for data analysis, data profiling and source to Confidential 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 Confidential 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 the new Confidential /zOS/DB2 Confidential system. Developed SSIS data flows to extract, transform and move data to the newly developed 3 terabyte Confidential 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 / Database Migration

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 Confidential 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.