As a Solution Architect, the main objective is to migrate and architect an on-premises application for a small accounting firm to the AWS cloud. The primary focus is ensuring security and decoupling of the existing monolithic application into microservices on the AWS platform. Additionally, where prudent maximize the use of serverless processing wherever possible.Responsibilities include:* Work with cross-functional teams to understand the project requirements* Completed a data classification activity to ensure that the data is secured in accordance with both the organization's operational needs and regulatory compliance requirements* Provide recommendations for securing data in transit versus data at rest based on the data classification activity* Conducted analysis in order to provide recommendations regarding the optimal placement of AWS ACM (Amazon Certificate Manager) and KMS (Key Management Service) within the broader system architecture* Work in collaboration with team members to create an architectural design that included Cognito, API Gateway, Lambda, SNS (Simple Notification Service), SQS (Simple Queue Service), Fargate, and RDS (Relational Database Service)* The AWS services listed above do not represent a list of all AWS services employed in the architecture

As a Data/Solution Architect interviewed various Medicare Administrative Contractors (MACs) to ascertain their functional process for generating and reporting Call Center metrics to the Provider Customer Service Program (PCSP) at CMS on a monthly basis. Additional responsibilities included architecting a cloud solution for ingesting MAC’s unstructured/structured data into an ecosystem that would facilitate a data lake for data standardization, a warehouse for deeper data visualization, BI tools for viewing present and historical data and analytical tools for forecasting.Responsibilities include:* Worked with cross functional teams to understand each MAC’s reporting processing* Worked with business unit managers to understand project scope for data ingestion to AWS Cloud* Design and architect a secure HA fault tolerant infrastructure in AWS* Architected AWS RDS with multi-AZ for automatic failover* Developed and presented a high-level architectural design that was approved by CMS Technical Review Broad* Create roles for EC2, RDS, S3, CloudWatch resources to communicate with each other using IAM* Build and configure a virtual data center in the AWS Cloud to support Data Warehouse hosting including Virtual Private Cloud (VPC), public and private subnets, Network Access Control List (NACL), Security Groups (SG), Route Tables, Elastic Load Balancers (ELB), Auto Scaling Groups (ASG), and Route 53* Used CloudWatch, VPC Flow Logs to monitor and retain account activity related to actions across AWS infrastructure* Familiar with RDS, EC2, S3, CloudFormation, CloudWatch, CloudTrail, VPC, Route 53, CloudFront, SQS, SNS, DMS, SCT, API gateway, and Lambda

Solution Architect with primary focus on designing/developing a Proof-of-Concept (POC) cloud solution to facilitate Credit Suisse’s data governance policy regarding tracking data risk aggregation and reporting requirements per BCBS 239 (Basel Committee and Banking Supervision, Principles for effective risk data aggregation and risk reporting).Responsibilities include:* Utilized S3 service for capturing and storing Business Glossary, Business Lineage, and Adaptive Framework* SQS and Lambda functions execute multiple validation and reconciliation rules identifying discrepancies* Discrepancy tickets generated and delivered to respective departments via SNS service* Data reconciliation between data sources and risk databases was stored in the DynamoDB* Both public and private subnets were utilized along with VPC, SG, EC2, NAT gateway, and VPC endpoint for private connection to S3 and DynamoDB* Several AWS services were incorporated, such as IAM, CloudWatch, VPC Flow Logs, CloudTrail, and Athena* Tested Splunk for centralize viewing of various logs* Provided CloudFormation template as POC deliverable

Designed, developed, and managed the QMAT’s complex data models (conceptual, logical, and physical) and databases in all SCG and CMS environments.Responsibilities include:* Provided DBA support for PostgreSQL in AWS RDS environment, utilized PgAdmin tool for database connectivity* Migrated Oracle on premises database to AWS RDS PostgreSQL using AWS DMS and SCT services* Created VPCs and security groups for EC2 and RDS instances* Proficient in AWS services such as VPC, EC2, S3, SG, EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, CloudTrail* Participated in requirements analysis and code review sessions with development and business analyst teams* Authored the QMAT Database Design Document and the Data Dictionary* Forward engineered the Data Definition Language (DDL) from the physical data model to establish the development, validation, and production of RDBMS at CMS* Ensured Referential Integrity (RI) to reflect data integrity rules as identified by business requirements* Managed all migration of database schema objects through the system development life cycle* Responsible for the SCG production environment which consisted of Oracle ASM, RAC and Data Guard on Linux servers. In addition, performed direct upgrade of Oracle 11g to 12c migration and the implementation of Oracle security patch updates as needed utilizing OPatch.* Managed database capacity sizing issues for test and production environments* Proficient with PL/SQL, SQL, Stored Procedure and Triggers* Support and troubleshoot the operation of database systems including Data Guard issues, patching, event monitoring, incident management, RMAN backup and recovery strategies and other forms of remedial and preventive maintenance* Managed the architectural direction, performance tuning and replication of RDBMS to various environments. Monitored the ADDM, AWR reports to identify performance trends and abnormalities* Interviewed candidates for several technical SCG projects

Functioned as both Project Manager and Database ArchitectResponsibilities include:* Developed and managed the logical and physical data models of the RDIS and Public Use File (PUF) projects that conformed to existing CMS standards and conventions; providing leadership and guidance with enterprise data strategies; revised data dictionary definitions, governance practices, and standards* Assisted in the physical data model design of MCSIS project at CMS* Served as the liaison between developers and business owners and users* Part of management team involved in CMMI Level 3 appraisal (SCAMPI A/B) and certification for the following process areas: o Technical Solution o Product Integration o Validation o Verification* Interviewed candidates to access technical competency* Developed project schedule and report weekly status updates to stakeholders to assure on time delivery of products and deliverables