PROFESSIONAL SUMMARY:

• Total 12+ Years of IT experience with 5 years’ experience planning, designing, implementing and maintaining system applications in AWS Cloud in Linux and Windows environments .
• Experience in migrating and implementation of multiple applications from on premise to cloud using AWS services like SMS (Server Migration Service), DMS (Database Migration Service), SCT (Schema Conversion Tool), CloudFormation, Cloudwatch, Cloudtrail, S3, Route53, Glacier, EC2, RDS, SQS, SNS and VPC.
• Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.
• Experience in implementing Data warehouse solutions in Amazon Redshift .
• Experience in Implementing and Managing ETL solutions and automating operational processes .
• Experience in Amazon Athena to Analyze Web Data Stored in AWS Data Lake / S3 Bucket and AWS Glue for ETL and Data Analytics.
• Experience with Amazon Kinesis to Stream, Analyze and Process real - time Logs from Apache application server and Amazon Kinesis Firehose to store the Processed Log Files in Amazon S3 Bucket .
• Migrated on premise Data Warehouse Application into Amazon Redshift and implemented the Leader Node and Compute Nodes for processing information.
• Implemented Amazon QuickSight and TIBCO Spotfire Analytics to generate various reports.
• Good experience in creating and editing Shell, Bash, Python Scripts for automation.
• Excellent communication , analytical and problem-solving skills with ability to work within a team environment and independently.

TECHNICAL SKILLS:

Cloud Computing: Amazon Redshift, AWS - EC2, EBS, RDS, S3, Glacier, SQS, SNS, SES, CloudFormation, VPC, IAM, Route53, DynamoDB, Lambda, CloudWatch, CloudTrail, AWS Glue, AWS Athena, Elastic Search, Kinesis, API Gateway

RDBMS: MySQL5.6/5.7, Amazon Aurora, PostgreSQL, MS SQL Server / 2008, MS (SSIS, SSAS, SSRS)

Operating Systems: Linux RHAT/6/7, HP-UX/10.x, AIX/5.3, Windows 2005/2008/2012 , VMware

Programming Languages: Java, JavaScript, C/C++, TSQL, PL/SQL, PERL, Bash/Shell Scripting, JSON, YAML, Python, PHP, XML, Scala

Tools: / Software: OBIEE, Power Pivot, Power BI, ERwin, TOAD, SQL*Plus,, BMC Remedy, HP Quality Center, JIRA

Data Model: Logical / Physical

Hardware: IBM AIX series, Sun Fire V880, iSCSI Data Storage Devices

PROFESSIONAL EXPERIENCE:

Confidential, DE

AWS Cloud Engineer

Responsibilities:

• Responsible for launching Amazon EC2 Instances and Forming Instances with respect to precise Applications in various Availability Zones using CloudFormation.
• Deployed and Implemented Data Warehouse Solutions for Star Schema in Amazon Redshift.
• Implemented Redshift Cluster, Leader and Computes Nodes to process large amount of data and also used the COPY command to LOAD data into Compute Nodes.
• Experience in Amazon Athena to Analyze Web Data Stored in AWS Data Lake / S3 Bucket and AWS Glue for ETL and Data Analytics.
• Building VPCs (Virtual Private Cloud) and launching EC2 instances with Security Groups, Auto-Scaling, Load Balancers and other like S3, Glacier, RDS, SQS, SNS, and SES in defined public and private connections
• Set up applications on AWS EC2 instances and organized storage on S3 buckets with security options for access and the IAM role founded polices.
• Employed Amazon Kinesis to Stream, Analyze and Process real-time Logs from Apache application server and Amazon Kinesis Firehose to store the Processed Log Files in Amazon S3 Bucket .
• Migrating on promise application into AWS cloud and also configured a Hybrid environment for certain applications.
• Handling Cloud Groundwork and Collective Services for numerous clients’ requests running on Amazon EC2 Instances for Linux / Windows environments.
• Implemented the Extract, Transform and Load (ETL) process for developing high performance Business Intelligence Reports using MS SSIS and SSRS tools from various Data Sources..
• Configuration of SQL Server Reporting Services (SSRS) for Developing Drill Tabular Reports, Matrix Reports and Drill Down Reports.
• Experience in SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.
• Functioned with project team members in the progress of approval benchmarks and demand for designing change management process of various applications running in hybrid environments.
• Involved in 24X7-support rotation for all the Production, Implementation, Test, and Development environments.

Environment: AWS - EC2, S3, Glacier, SMS, RDS, SQS, SNS, CloudFormation, VPC, CloudWatch, Kinesis, Lambda, QuickSight, Athena, Redshift, DynamoDB, Oracle 12c, Linux/Windows, Python, RDMS, MySQL, MS SQL Server 2012, PostgreSQL, Aurora.

Database Administrator

Confidential, DE

Responsibilities:

• Performs day-to-day maintenance and installation of Microsoft SQL Server, Patching, Backups and Storage.
• Created User accounts, Roles and granting required access Permissions and Privileges to the users .
• Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio.
• Involved in writing complex SQL scripts which includes transact statements, database object validation, and exception handling to facilitate functionality in different modules.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
• Monitor SQL server and database performance and proactively address potential performance issues.
• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Created automated processes for the activities such as database backup and processes using the Integrated Processes.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Review, design, and develop data models in conjunction with application development teams
• Provide solutions for database issues including capacity, redundancy, replication, and performance
• Conduct performance reviews and contribute to performance feedback for all levels of staff

Systems Analyst

Confidential, MD

Responsibilities:

• Assists in the development of the IT Department’s policies and procedures and recommends to management suggestions for improvement.
• Provide help desk support, manage tracking of tickets and work with the IT Help desk Analyst to ensure key performance metrics are maintained.
• Provide support for the development and maintenance of stage, test, and development environments for distributed applications.
• Work with developers to get projects developed and implemented.
• Define project requirements by identifying project milestones, phases and elements; forming project team; establishing project budget
• Perform configuration management and provide ADP equipment upgrade recommendations.
• Assist with activities of system design, implementation, administration and network management.
• This person will manage and perform the business systems analysis work associated with change requests, projects, assessments and escalated issues.
• Perform daily, weekly and monthly reviews and analyses of current processes using operational metrics and reports
• Conduct insightful, ad hoc analyses to investigate ongoing or one-time operational issue