EXPERIENCE 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.
• Has 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.
• StrongData Modelingexperience usingER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Power designer & Erwin.
• Interacting with teh Business Users for new Project Development and Enhancements and converting teh Non-Technical requirements into Technical Terms
• Understanding of Agile Methodology.

TECHNICAL SKILLS

• AWS ServicesEC2 Linux/Windows, Storage, IAM, RDS, DYNAMODB, AUTOSCALING, Cloud Formation, SES, SQS, Route 53, Networking Services, EMR, Kinesis, Redshift, Pipeline, Lambda, DMS, IoT
• Azure ServicesVM Ubuntu/Windows, Batch, Functions, ScaleSets, Availability Sets, Networking with S2S & P2S VPN, Storage, AKS, Azure SQL, Data factory, SQL Data warehouse, HDInsightLanguagesJava, C, C++, VB 6.0, UNIX
• Markup LanguagesHTML
• 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 Developer

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Designed, configured and deployed Amazon Web Services (AWS) for applications utilizing teh 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 autantication.
• 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 teh on-Premises data center using AWS VPN Gateway for cloudfront distribution.
• Performed AWS lambda functions on S3.
• Migrated teh production MySQL DB to teh 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 dat controlled teh 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 teh two Vnet's in teh same region.
• Implemented SQL Logins, Roles and Autantication 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 teh Physical models on SQL Server & DB2 platform & preparing DDL and DML scripts and streamlining teh process for any changes.
• Developing Stored Procedures for generating highly complex reports and interfaces between WPC & Downstream systems.
• Has groomed myself in functional noledge of Car manufacturing which halps in understanding teh business requirements.

Tata Communications

Confidential

Responsibilities:

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

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

OLTP Data Modeler & Oracle PL/SQL and UNIX developer

Confidential

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 teh modules in teh project..
• Has prepared all kind of test cases and responsible for teh successful running of teh applications.