We provide IT Staff Augmentation Services!

Data / Aws Architect Resume

PROFESSIONAL SUMMARY:

  • Hands - on AWS Technical Engineer with 3 + Years in developing and architecting enterprise level large scale multi-tier solutions that require complex architectural decisions
  • Total 11 years of IT Industry experience various cloud & data management domains like Data Modelling, Data Architecture, Data Analysis, Data Security, Test Data Management, Database Administration & deployment, Database Performance Tuning & development & Software Configuration and Build/Release Management.
  • Hands-on experience on implementing AWS Cloud Solutions using various services with major focus on AWS EC2, RDS, Elastic IP's, security groups, auto-scaling groups, load balancers (ELBs), S3, Direct Connect, VPC, End Points etc.
  • Extensive knowledge on monitoring and alerting of production and corporate servers/storage using Cloud Watch alarms & specified thresholds with metrics and notified by creating subscribers by using SNS.
  • Experienced in designing cloud models for Infrastructure-as-a-service(IaaS), Platform-as-a-service(PaaS), and Software-as-a-Service(SaaS).
  • Integrated client’s “Marketplace” Appstore with Electric Flow CI/CD for on-demand deployment of cross-region, highly available & high fault tolerant MongoDB Cluster, SQL Server Always On, Oracle database using Terraform and Ansible
  • Extensive hands-on experience in creating AWS EMR cluster, DocumentDB, Aurora & Redshift cluster using Terraform.
  • Strong experience in Windows Server DSC resources and extensively worked on PowerShell with Ansible to create Windows Server failover Cluster in AWS
  • Created various ansible modules integrated with ansible tower to perform regular databases activities, such as backup & recovery, patching etc.
  • Administration various environments in software development life cycle (SDLC) Windows, Ubuntu, Red Hat Linux, SUSE Linux and CentOS.
  • Designed and maintained AWS infrastructure highly available, scalable, secured, monitored and alerting network infrastructure. Experience in working with IAM in creating new roles, users and groups within different accounts with customized policies.
  • Extensive hands-on in task automation, creation of infrastructure/platform as code, security automation and automation of routine maintenance tasks using Terraform, Ansible, Cloud Formation
  • Extensive knowledge on data migration from on-premise Oracle databases to MongoDB on-Premise/AWS .
  • Lift and shift of an existing on-premises application to AWS.
  • Selecting the appropriate AWS service based on data, compute, database, or security requirements.
  • Identifying appropriate use of AWS Architectural best practices.
  • Estimating AWS costs and identifying cost control mechanisms.
  • Extensive hands-on IBM Optim Data Masking and Archival tool for data masking for various distributed databases Oracle, Teradata, SQL Server, My SQL etc. & mainframe systems.
  • Strong knowledge in PII data analysis using IBM Infosphere Discovery & Information Analyzer. Involved in regular PII data analysis process with client’s cyber security team to identify vulnerability.
  • Involved in the continuous integration and continuous delivery process to optimize the timeline, smooth deployment and quality of the product using various CI/CD pipeline tools Jenkins, Electric Cloud
  • Specialized in Delphix database virtualization tool for Oracle and extensively worked with multiple programming languages SQL, PL/SQL, Shell Scripting, PowerShell, Lua Scripting, Python & Perl
  • Experience in developing terraform modules to create custom sized VPC, subnets, EC2 instances, ELB’s and security groups.
  • Strong Experience in Working with version controlling tool such as GIT, SVN
  • Proficient in CA ERWin data modelling tool
  • Extensively worked on creating data models (conceptual, logical and physical) for various client across different domains
  • Also worked as Oracle Application DBA having excellent knowledge in Performance Tuning, Oracle Forms & Reports, Oracle CDC, Oracle Golden gate Oracle Steams & Advance replication.

PROFESSIONAL EXPERIENCE:

Confidential

Data / AWS Architect

Responsibilities:

  • Worked extensively on designing and deploying multiple applications using AWS cloud infrastructure focusing on high availability, fault tolerance and auto-scaling of the instances.
  • Integrated Client’s Marketplace Appstore with Electric Flow CI/CD for on-demand deployment of cross-region, highly available & high fault tolerant MongoDB, SQL Server, Oracle database using Terraform and Ansible.
  • Single handedly created delivered a project using Bash, Python, PL/SQL, Server Side Java scripts in MongoDB to migrate data from on-premise Exadata servers to AWS MongoDB servers Both initial data loads & regular incremental data loads
  • Currently working on creating Data-Lake using S3, Redshift cluster, AWS Glue & Athena.
  • Extensive hands-on experience in creating AWS EMR cluster, DocumentDB, Aurora & Redshift cluster using Terraform.
  • Strong experience in Windows Server DSC resources and extensively worked on PowerShell with Ansible to create Windows Server failover Cluster in AWS
  • Administration various environments in software development life cycle (SDLC) Windows, Ubuntu, Red Hat Linux, SUSE Linux and CentOS.
  • Regularly use IBM Optim Data Masking and Archival tool for data masking for various distributed databases Oracle, Teradata, SQL Server, My SQL etc. for On-premise & cloud environment & Mainframe systems.
  • Involved in regular PII data analysis process with client’s cyber security team using IBM Infosphere Discovery & Information Analyzer.
  • Used security groups, network ACLs, Internet Gateways and Route tables to ensure a secure zone for organizations in AWS public cloud.
  • Hands-on experience in Amazon Web Services for deploying EC2 instances consisting of various flavors like Amazon Linux AMI, Red Hat Linux Enterprise, SUSE Linux, Ubuntu Server etc.
  • Involved in AWS Services such as EC2, S3, EBS, VPC, ELB, Route53, Cloud Watch, Security Groups, Cloud Trail, IAM, CloudFront, EMR, RDS and Glacier.
  • Setting up IAM user roles with corresponding user and group policies using JSON.
  • Creating public and private subnets within the VPC and attaching them to the EC2 instances based on the requirement. Configured Elastic Load Balancers with EC2, Auto scaling groups.
  • Well Versed with Configuring Access for inbound and outbound traffic RDS DB services, DynamoDB tables, EBS volumes to set alarms for notifications or automated actions.
  • Created SNS (Simple Notification Services) and triggering it by Cloud Watch monitoring to send SMS or Email to desired recipients.
  • Deployed and configured Elastic search, monitoring in integration with AWS Lambda and Cloud Watch.
  • Designed Terraform templates to create custom sized VPC, subnets, NAT to ensure successful deployment of Web applications and database templates on AWS.
  • Used Terraform to transform the infrastructure from on premise to cloud.
  • Expert in writing Templates for AWS infrastructure, as a code using Terraform to build Development, Testing, staging and production environments.
  • Created Infrastructure Git repositories for Terraform to launch the stacks.
  • Created SNS (Simple Notification Services) and triggering it by Cloud Watch monitoring to send SMS or Email to desired recipients.

Confidential

Lead Data Modeler

Responsibilities:

  • Conducted major stakeholder interviews for determining the requirements.
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
  • Developed at conceptual/logical/physical data model level using Erwin according to requirements.
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin r9 after analyzing the existing database.
  • Analysis of the existing Application, Pega Workflow management, Workflow Process, data flow between upstream and downstream systems and Application metadata for gap analysis documentation.
  • Developed the required data warehouse model using Star schema for the generalized model
  • Used forward engineering approach for designing and creating databases for OLAP model
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.

Confidential

Lead Data Modeler

Responsibilities:

  • Led discussions with developers, data architects and SMEs to understand, document and translate business requirements and scope into technical designs as well as high-quality conceptual, logical and physical data models
  • Supported the development and documentation of data flow diagrams, integrated data models and metadata as required as well as mapped data elements of data sources into domain data models and conducted model reviews with business and technical project teams
  • Created, developed, implemented, updated and maintained Operational Data source using ERWIN 9.5 for Teradata Database.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP & ODS.

Confidential

Senior Software Engineer

Responsibilities:

  • Migrated of over 50 Oracle databases from 8i to 11G.
  • Created of time & cost assessment along with risk assessment & process implementation overview, guidelines & best practice.
  • Implemented Oracle Golden Gate & Oracle Data Guard

Confidential

Lead Data Modeler

Responsibilities:

  • Analyzed business requirements in detail with the project stakeholders.
  • Completed analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Developed normalized Logical and Physical database models to design OLTP system.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r8
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
  • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from Oracle and SQL Server database systems
  • Exhaustively collected business and technical metadata and maintained naming standards

Confidential

PL/SQL Developer & Data Modeler

Responsibilities:

  • Worked as single point of contact from database side Oracle at offshore
  • Upgraded existing data models from Erwin R7 to R8.
  • Performed complex Data Migration from Postgres to Oracle 10G using PL/SQL & bash programming.
  • Setup & monitored Oracle CDC process.
  • Analyzed of existing data model and created of new subject areas to cater to new business requirements.
  • Transformed business logic into conceptual data models, developed Logical Data Model & Physical Data Model.
  • Performed performance tuning of existing PL/SQL procedures.

Confidential

PL/SQL Developer & Junior Data Modeler

Responsibilities:

  • Extensively worked on requirement gathering & analysis
  • Analyzed of existing data model and created of new subject areas to cater to new business requirements.
  • Transformed business logic into conceptual data models, development of Logical Data Model & Physical Data Model.
  • Performed performance tuning of existing PL/SQL procedures.
  • Created views & materialized views in Oracle

Confidential

PL/SQL & Oracle Forms Developer

Responsibilities:

  • Extensively worked on requirement gathering & data analysis
  • Built new forms based on business requirements.
  • Created user authorization process using Oracle Forms (Version 6i) & Oracle PL/SQL.
  • Created/modified triggers (Form level, Block level, Item level) using PL/SQL.
  • Did thorough unit testing & provided post-production support.

Hire Now