SUMMARY:

Experienced cloud professional (AWS, GCP Certified Architect), with extensive experience in Cloud Infrastructure, Terraform, Cloud DBs, Cloud Architecture and operations in a variety of domains, Biotech, Banking and Insurance.

TECHNICAL SKILLS:

Programming/Scripting Languages: SQL, PL/SQL, Python, PowerShell, Bash.

RDBMS: MS - SQL, PostgreSql, MySql, Redshift, BigQuery, CloudSQL.

Cloud Computing: AWS, GCP, Azure (VNets, VMs, Storage, ARM).

Automation Tools: Terraform, Ansible, CloudFormation, Github

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. Cloud Infrastructure Engineer

Responsibilities:

• Data center exit project into AWS (mainly) using a Terraform, github, codebuild pipeline. All deployments where 100% Terraform (TF) code driven.
• Contributed to moving jenkins from on-prem to Kubernetes (EKS, GKE), deploying components into different name spaces, setting up PSP, OPA and securing the EKS cluster.
• Setting up codebuild jobs to scan Docker images before submitting them into ECR, GCR through Trivy.
• Adding to and modifying the TF modules repository to streamline the deployment of AWS, GCP resources.

Confidential, Emeryville, CA

Cloud Applications Consultant

Responsibilities:

• Set up AWS/GCP VPC environments with proper subnetting and routing between public and private subnets to test database migration solutions.
• Configuring Route tables, NACLs, Security Group rules, TCP/IP and SSH traffic for VPC environments.
• Deployed CloudFormation stacks while utilizing different configuration options and intrinsic functions in the templates.
• Managing GCP cloud resources through Ansible and Terraform utilizing Terraform Variable files, Maps and Modules. and bootstrapping new instances using Ansible Playbooks.
• Staying up to date with AWS/GCP security best practices.
• Participated in AWS/GCP cloud migration, storage migration, storage solution mappings.
• Managed billing and cost estimation to ensure staying with budget guidelines.
• Automated monitoring and remediation using AWS Config, CloudTrail, CloudWatch events, Lambda and SNS to check and secure open VPCs, S3 buckets.

Confidential, Brisbane, CA

Cloud Applications Consultant

Responsibilities:

• Set up AWS/GCP VPC environments with proper subnetting and routing between public and private subnets to test database migration solutions.
• Configuring Route tables, NACLs, Security Group rules, TCP/IP and SSH traffic for VPC environments.
• Deployed CloudFormation stacks while utilizing different configuration options and intrinsic functions in the templates.
• Managing GCP cloud resources through Ansible and Terraform utilizing Terraform Variable files, Maps and Modules. and bootstrapping new instances using Ansible Playbooks.
• Staying up to date with AWS/GCP security best practices.
• Participated in AWS/GCP cloud migration, storage migration, storage solution mappings.
• Managed billing and cost estimation to ensure staying with budget guidelines.
• Automated monitoring and remediation using AWS Config, CloudTrail, CloudWatch events, Lambda and SNS to check and secure open VPCs, S3 buckets.
• Data migration using CLI from on Premise silos to cloud storage buckets.
• Configuring RDS, Cloud SQL instances and read replicas with different I/O throughputs and SQL engines.
• Securing data at Rest (GCS, S3, Glacier, EBS, EMR), and in Transit. securely decommissioning data
• AWS IAM onboarding with MS active directory, plus setting up storage bucket policies.
• Created and configured cloud database instances with proper backup strategies and failovers.
• DR testing of on prem and cloud DBs backups (Backup and restore, "Pilot Light"). Along with terraform and GCP and AWS CF templates for provisioning minimum resources with auto scaling rules.
• Intermediate knowledge with CI/CD methodologies, Jenkins pipelines, Git webhooks, deployments to multi environments.
• Work with Business team, IT, Study Managers and other stakeholders to gather requirements for enhancements/integration with other enterprise systems such as Site Monitoring Visit reports, Drug safety and Medical Affairs.
• Maintaining a validated state of clinical systems by developing and executing test scripts, leading change control management and deploying systems through our SDLC processes.

Confidential, Sunnyvale, CA

Cloud Applications Consultant

Responsibilities:

• Set up VPC Development environments with proper subnetting and routing between public and private subnets to test database migration solutions.
• Deployed CloudFormation stacks while utilizing different configuration options and intrinsic functions in the templates.
• Managing cloud resources through Terraform utilizing Terraform Variable files, Maps and Modules.
• AWS IAM onboarding (roles, policies, Federated/STS roles).
• Created and Configured an RDS Database instance with proper backup strategies.
• Configuring core AWS resources (VPC, EC2 and S3) for on prem to cloud storage and compute services migration.
• Creating Terraform templates / modules to launch EC2 clusters for adhoc workloads.
• EBS backup automation.
• Work with Business team, IT, Study Managers and other stakeholders to gather requirements for enhancements/integration with other enterprise systems such as Site Monitoring Visit reports, Drug safety and Medical Affairs.
• Maintaining a validated state of clinical systems by developing and executing test scripts, leading change control management and deploying systems through our SDLC processes.

Confidential, Palo Alto, CA

Sr. Business Intelligence Consultant

Responsibilities:

• Architected and redesigned existing reporting processes for Financial Decision Group which focused on assigning cost sites to patients (nurse to patients ratio) with a higher degree of accuracy.
• Connecting and securing BI solutions to Cloud DB nodes (SQL on Azure, RDS and CloudSQL).
• Streamlined existing SSRS reports and ETL pipelines. Re-wrote Transact SQL queries for better performance. (reports usually took 15 mins to render brought that number down to less than 1 minute).
• Created SOX compliant SSRS dashboard with multiple Pie, Bar and Scatter Charts. To help the Financial Decision Group better assign healthcare provider costs to their corresponding managing directors for overall Confidential budgeting and financial reporting.

Confidential, San Francisco, CA

Enterprise Applications Consultant

Responsibilities:

• Participated in Clinical Datawarehouse migration from on premise to AWS Redshift.
• Created, managed and maintained ETL jobs using Talend, SSIS(components, variables, mappings).
• CTMS Administration of the Bioclinica OnPoint platform. Technical administration of the on-prem client/server Windows/SQL Server/Sharepoint environment. Application administration of clinical study configuration and study design setup.
• Technical lead of the automated data integration of IXRS/EDC data into CTMS via ETL. Developed data pipelines to transform SAS datasets to CTMS Application, using MS Access, VBScript, SSIS, and SAS programs.
• Drafted IQ (Installation qualification), OQ (Operational qualification) and test scripts for CTMS Integrations and various processes per GxP guidelines for a validated clinical studies environment.
• Developed SSRS trendline and graph reports on top of an email archiver application to monitor traffic of clinical study mailboxes.
• Architected and built a clinical data mart from the ground up that converged clinical sites and clinical finance data to serve quarterly accrual reports used for clinical studies BVA analysis and reporting. Aggregated and ETL data from disparate sources (SAS datasets, Excel/CSV files, SQL Server DBs, Sharepoint lists) using advanced SSIS logic. This effort saved business department hundreds of manual hours of spreadsheets preparation and standardized the accrual reporting process for budgeting and financial reporting.
• ETL developer for ClinApps platform (software used to Plan, Monitor and Control the clinical supplies process) using canned reports data transformed and loaded to an OLAP cube used to generate Qlikview map charts.
• Developed SSRS drill down reports to track patients status throughout the clinical study' schedule for future projections.
• Working knowledge of SAS in Windows, Linux and SAS Grid environment.
• Talend packages for XML, JSON array and hash tables migrations.

Confidential, Jersey City, NJ

MS BI/SQL Developer

Responsibilities:

• Writing stored procedures, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and modified already existing stored procedures, views.
• Involved in query optimization and tuning stored procedures for better performance.
• Configured and maintained Report Manager and Report Server for SSRS and Spotfire.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created data loads and Upgrade scripts for data migrations and validations.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Building and improving data model (Physical/Logical) to serve different Fund types involved in the module.
• Managing and coordinating releases throughout different environments.
• Debugging and testing support of Module in all environments and coordinating with QA on defects and performance issues.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008, PL-SQL, Share Point, Liferay, Spotfire, Oracle 10g, MS Access, Windows Server 2003.

Confidential

SQL /Oracle DBA

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modeling.
• Interacting with business users in getting the reporting requirements.
• Created roles and managed roles of Security.
• Performed installations of Oracle 8i and SQL server databases.
• Backup and Recovery of Oracle database using Recovery Manager (RMAN).
• Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.
• Used FTP and SCP for keeping important files safe and secure.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database
• Created tables, indexes, stored procedures and functions.
• Developed and integrated code for enhancement of the application.
• Responsible for optimizing the queries and application tuning.
• Scheduling Jobs and Alerting using SQL Server Agent
• Developed custom reports using Microsoft reporting Services.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database.

Environment: Windows, SQL server, Oracle 8.1.7.0.1/ 9.2.0.1.0, T-SQL, Query Analyzer, Data Transformation Services.

Confidential

IT compliance officer

Responsibilities:

• Managing Credit Policy and IT compliance with central bank rules and regulations and acting as Business/IT liaison officer.
• Presenting and promoting the concept of credit insurance through a third-party administrator (TPA) to banks.
• Managing and coordinating the credit insurance process with TPA (production, claims and recoveries).
• Coordinating with financial dept. payables, premiums, receivables and other financial arrangements between TPA and Arab Assurers.
• Preparing and calculating premiums on insured loans, risk underwriting and approving loans (cars, personal, and credit cards).
• Preparing monthly financial reports on the section’s performance along with p/l reports and annual forecasts, reconciliation of accounts with reinsurance companies on quarterly basis.

Environment: Windows, SQL server, T-SQL, Query Analyzer, Data Transformation Services.