SUMMARY:

• AWS Certified Solution Architect Associate Level.
• 10 years of total professional experience as AWS/Azure Cloud Architect, technical support, application development & Data Modelling.
• Designed, configured and managed cloud infrastructure utilizing Amazon Web Services (AWS), including EC2, Elastic Beanstalk, S3, CloudFront, RDS, VPC, Route53, CloudWatch, CloudTrail, CloudFormation and IAM.
• Created AWS RDS database instances consisting of PostgreSQL and AWS RDS Aurora database clusters.
• Good Knowledge of Python and Big Data technologies - Pig, Sqoop, Spark.
• Experience in dealing with Windows Azure IaaS - Virtual Networks, Virtual Machines, Cloud Services, Resource Groups, Express Route, VPN, Load Balancing, Application Gateways, Auto-Scaling, and Traffic Manager.
• Azure PaaS Solutions like Azure Web Apps, Web Roles, Worker Roles, SQL Azure and Azure Storage.
• Have experience of designing & implementing Logical & Physical Data Model on Oracle/SQL Server & DB2 platform for Data Warehouse & Data Marts.
• Experience & good hold on Analysis and Designing in Oracle, SQL Server, DB2, and UNIX.
• Expertise programming with Oracle PL/SQL, DB2, SQL Server and UNIX -Shell Scripting.
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Power designer & Erwin.
• Interacting with the Business Users for new Project Development and Enhancements and converting the Non-Technical requirements into Technical Terms
• Understanding of Agile Methodology.

SKILLS:

AWS Services: EC2 Linux/Windows, Storage, IAM, RDS, DYNAMODB, AUTOSCALING, Cloud Formation, SES, SQS, Route 53, Networking Services, EMR, Kinesis, Redshift, Pipeline, Lambda, DMS, IoT

Azure Services: VM Ubuntu/Windows, Batch, Functions, ScaleSets, Availability Sets, Networking with S2S & P2S VPN, Storage, AKS, Azure SQL, Data factory, SQL Data warehouse, HDInsightLanguages Java, C, C++, VB 6.0, UNIX

Markup Languages: HTML

Operating System: Windows XP/2000/ 9x /NT.

Database: Oracle 10g, DB2, SQL Server, MS Access, Aurora DB

Tools: /IDE SQL Data Modeler, PL/SQL Developer, TOAD, SQL DeveloperSQL Server Studio

PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Designed, configured and deployed Amazon Web Services (AWS) for applications utilizing the AWS stack (Including EC2, Route53, S3, RDS, Cloud Formation, Cloud Watch, SQS, IAM), focusing on high-availability, fault tolerance, auto-scaling, load-balancing capacity monitoring and alerting.
• Configured AWS Identity and Access Management (IAM) Groups and Users for improved login authentication.
• Configured KMS using IAM to provide encryption/decryption keys to secure Amazon S3, EBS and RDS.
• Handled content distribution and data transfer and implemented content delivery network over Amazon CloudFront. Handled streaming and live content over Amazon CloudFront.
• Expertise in running applications using Elastic Bean Stalk.
• Created an AWS RDS Aurora DB cluster & Configured AWS RDS Aurora database users to allow each individual user privileges to perform their related tasks.
• Configured an AWS Virtual Private Cloud (VPC) and connected it to the on-Premises data center using AWS VPN Gateway for cloudfront distribution.
• Performed AWS lambda functions on S3.
• Migrated the production MySQL DB to the new AWS RDS Aurora instance.
• Implemented AWS High-Availability using AWS Elastic Load Balancing (ELB), which performed a balance across instances in multiple Availability Zones.
• Defined AWS Security Groups, which acted as virtual firewalls that controlled the traffic, allowed reaching one or more AWS EC2 instances.
• Implemented Apache hadoop cluster using hdfs in a testing environment.
• Managed application and patch management of applications running on AWS.
• Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing.
• Migrated moderate workloads from on premise to Azure laaS. Published web services APIs using Azure API management service.
• Database Designer and OLAP/OLTP/Business Intelligence Data Modeler using Sybase Powerdesigner. Implemented Vnet-Peering between the two Vnet's in the same region.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Uploaded Vhd file in to Azure Storage Account using AZ Copy.
• Data Analysis & Data profiling.
• Metadata Management.
• Gathering requirements from client & designing Logical & Physical Data Models for Data Warehouse & Data Mart.
• Implementing the Physical models on SQL Server & DB2 platform & preparing DDL and DML scripts and streamlining the process for any changes.
• Developing Stored Procedures for generating highly complex reports and interfaces between WPC & Downstream systems.
• Have groomed myself in functional knowledge of Car manufacturing which helps in understanding the business requirements.

Confidential

Team Leader & a proficient OLTP Data Modeler

Responsibilities:

• Designing the Logical & Physical Data Models & getting them implemented on Oracle platform.
• Working on enhancements of the system by fixing up CRs.
• Working as a Single Point of Contact and maintaining the support operations.
• Preparing estimation sheet for QRT fixes.
• Responsible for assigning daily activities to a team of support team and perform the tasks of managing and supervising the performance of the team.
• Establishing meeting times, places and agendas.
• Keeping the project manager informed of task accomplishment, issues and status

Environment: Oracle SQL Developer, Oracle 10g, Windows XP

Confidential

OLTP Data Modeler & Oracle PL/SQL and UNIX developer

Environment: Oracle SQL Developer, Oracle 10g, Windows XP

Responsibilities:

• Worked as a PL/SQL Developer and UNIX developer to develop applications like SONET, NGDLC and Network map.
• Provided support and maintenance for all the modules in the project..
• Have prepared all kind of test cases and responsible for the successful running of the applications.

Environment: Oracle 9i, Windows XP