Sql Server Web Services

Kishore Kumar

M: 469-***-****

******.***@*****.***

PROFESSIONAL SUMMARY:

Around 9 years of experience in IT Industry with 4 years of experience in Amazon Web Services (AWS).

* ***** ** ********ce as Business Intelligence Developer/Lead.

AWS Certified Solution Architect – Associate

AWS Certified SysOps Administrator – Associate

Deployed infrastructure on AWS utilizing services such as EC2, RDS, VPC and Managed Network and Security, Route 53, Direct Connect, IAM, Cloud Formation, AWS OpsWorks (Automate operations), Elastic Beanstalk, AWS S3, Glacier, (Storage in the cloud) and Cloud Watch Monitoring Management.

Significant Experience in Amazon Web Services (AWS) such as AWS VPC, AWS EC2, AWS RDS, AWS S3, AWS IAM, AWS CLI, AWS Route 53, Elastic Load Balancing, Auto Scaling, CloudWatch, CloudFormation, AWS Ops Works, AWS Elastic Beanstalk, AWS SNS, AWS SQS, AWS SES.

Cloud management and implementation services like EC2, S3, Elastic Beanstalk, SNS, Cloud Management, EMR, RDS, Dynamo DB, Ops Works, AWS Code Deploy, Cloud Front, SQS, Route53, VPC, Subnet, IAM, SWF, Cloud Watch, Lambda, Elastic search, Elastic Cache, Elastic IP’s, Redshift.

Experience in AWS Direct Connect in establishing a dedicated private network from on premise to the AWS VPC.

Experience in developing AWS Cloud Formation templates to deploy Infrastructure as Code and for AWS Orchestration.

Responsible for ensuring Continuous Delivery/Continuous Integration across all environments from UAT/TEST to Pre-Production and Production using Jenkins.

Worked with Chef Enterprise Hosted as well as On-Premise, Installed Workstation, Bootstrapped Nodes and had experience with new automation features like Salt Stack to automate the deployments and fixes.

Stay current with the latest features/capabilities of the AWS platform.

Experience in providing release Management with Team Foundation Server (TFS) and Build Automation for Multiple projects, production database with TFS.

Extensive experience in using Build Automation scripting like, Apache ANT, Maven 3

Hands on Experience with TFS Version Control, GIT, VSS.

Experience of Service-Oriented Architectures (SOA and REST), Infrastructure as a Service (IaaS) and Platform as a Service (PaaS)

In-depth understanding of principles of software configuration management (SCM), CI/CD in Agile, SCRUM, Waterfall Methodologies.

Strong Skills and Experience on the Automation of Infrastructure Management tools such as Chef and Salt stack.

Experience in Troubleshooting Hardware, Storage, Application Bottlenecks. System Recovery, Crash dump analysis and Performance Tuning.

Experience in Virtualization technologies like VMware, Hyper v.

Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions such as Amazon Web Services (AWS).

Implemented Team Foundation server TFS 2010/2015 as Version Management tool.

Configured TFS 2015 environment with SQL server database projects, SSIS projects, SSRS projects and SSAS projects.

Education:-

Master’s from Murray state university Dec, 2008

Bachelor’s from Kakatiya University May, 2007.

Technical Skills:

Cloud Platform and Virtualization Services: Amazon Web Services (AWS), VMware ESX

Operating Systems: Windows (2012 Server 64 Bit, 2008/R2 Server, 2003 Server 64/32 Bit, 2000, NT), Linux (RHEL, CENTOS)

RDBMS: Microsoft SQL Server 2000/2005/2008/2008R2/2012 (64/32 bit) – Standard/Developer and Enterprise Edition, AWS RDS, MySQL, Oracle, PostgreSQL

NoSQL: MongoDB

Web Server’s: IIS 6.0/7.0/8.0, Tomcat Apache 5.5/6.0/7.0/8.0

Monitoring Tools: CloudWatch, Nagios, New Relic, PerfMon, SQL Profiler, Idera, Spotlight

Configuration Management: Chef, Salt, AWS OpsWorks, Puppet, CloudFormation, CloudTrail, Team foundation server (TFS)

Networking: AWS VPC, DNS, DHCP, FTP, SMTP

Reporting: SSRS, CrystalReports, CloudWatch Dashboards, EC2 Reports

ETL & OLAP: SSIS, SSAS, Informatica

Build & Release Management: ANT, Maven, Chef, Jenkins.

Other Software & Scripting: Windows PowerShell, Python, Node.js, ruby, JSON

PROFESSIONAL EXPERIENCE:

FIS Global November 2015 to Present

Cloud Architect/AWS DevOps Engineer/BI Team Lead

Responsibilities:

Deployed infrastructure on AWS utilizing services such as EC2 (Virtual Servers in the Cloud), RDS (Managed Relational Database Service), VPC and Managed Network and Security, Route 53, Direct Connect, IAM, CloudFormation, AWS OpsWorks (Automate operations), Elastic Beanstalk, AWS S3, Glacier, (Storage in the cloud) and CloudWatch Monitoring Management.

Design, Develop and document architectural best practices for building systems on Amazon Web Services (AWS).

As an Embedded cloud engineer worked with infrastructure and development teams to define the Iaas and Paas solutions.

Configuring Load balancers with EC2 Auto scaling groups for equal traffic distribution to design cost effective and fault tolerance groups and maintaining the security groups.

Continuous integration using Jenkins with the Source Code Management like GIT, Git Hub, SVN, TFS.

Handled up to 100 Production/UAT/Support/DEV databases & application servers and 500 plus database/application migrations from an On-Premise datacenter & VMware to Amazon Web Services ensuring minimum downtime.

Implemented Elastic Load Balancers (ELB's) and Auto Scaling groups in AWS on Production EC2 Instances to build Fault-Tolerant and Highly Available applications.

Worked on Migration Strategy and developed a POC migrating VMware/On-premise datacenter to AWS utilizing, AWS EC2, S3, RDS, VPC, and Direct Connect.

Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions such as Amazon Web Services (AWS).

Defined security groups which acted as virtual firewalls to control the incoming traffic onto one or more EC2 instances.

Automating the operational tasks like software configuration, server scaling, deployment and database setup using AWS OpsWorks.

Involved in migrating databases from On-premise to both AWS RDS and SQL Server on EC2 by using both native backup and Import/Export technologies in completed fashion.

Used Jenkins for CI/CD and developed jobs to automate database deployment in AWS RDS and EC2.

Developed automation scripts using AWS SDK’s such as AWS PowerShell, Python boto3, Node.js to deploy infrastructure as a code.

Designed and responsible for building highly available and fault-tolerant applications using AWS Services like ELB’s, ASG’s, SNS, AWS Lambda & CloudWatch.

Worked on providing cross-region availability of RDS instances using AWS Lambda by developing scripts in python boto3.

Created AMI’s to implement automatic deployments of application components and bootstrapping AWS EC2 Instances by passing User Data to download DB\Application files from S3.

Experience with containerization tools like Docker and ECS (Elastic Container Service).

Experience on Docker hub, Creating Docker images and handling multiples images primarily for middleware installations and domain configuration. Strong knowledge on Docker components like Docker Engine, Hub, Machine, Compose and Docker Registry.

Created images and stored in the Docker containers and uploaded to the Docker Hub.

Developed procedures to unify, streamline and automate application development and deployment procedures with Linux container technology using Docker.

Exposure to Netflix OSS components like to Database Cluster Management, Performance Motorizing.

Encrypted EBS Volumes using KMS Service, monitoring Regular Health checks using CloudWatch and notifying using the services like SNS, SQS using the SMTP protocols.

Setup and administer DNS system in AWS using Route53.

Worked with multiple terabytes of mobile ad data stored in AWS using Elastic MapReduce (EMR) and Redshift Postgresql.

Developed Node.js scripts to deploy AWS infrastructure as a code along with Angular JS to develop a web application interacting with node.js

Worked on dynamically spinning up Dev/QA environments with all application components using node.js in AWS SDK.

Experience in provisioning infrastructure using Chef, SaltStack and Terraform.

Responsible for ensuring Continuous Delivery/Continuous Integration across all environments from UAT/TEST to Pre-Production and Production using Jenkins.

Building KPI reports for the cubes and optimizing the reports. Involved in Tabular Data

warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports. Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Environment: Amazon Web Services (AWS), Terraform, Windows, Linux, Microsoft SQL Server, RDS, SSMS, TFS, AWS OpsWorks, AWS EMR, AWS Redshift,Chef, Salt, Jenkins, git, AWS S3, VDI2, SSIS, SSRS, Crystal Reports, IIS, Apache, Tomcat

SunGard Dallas, Texas August 2010 – October 2015

Position: BI Lead/AWS DevOps Engineer

Responsibilities:

Design, Develop and document architectural best practices for building systems on Amazon Web Services (AWS).

Migrated over 100 Production/UAT/Support/DEV database and application servers and 500 plus databases & applications from On-Premise Datacenter to Amazon Web Services (AWS) ensuring minimum downtime.

Responsible for designing architectural diagrams for various applications before migrating into Amazon Cloud and considered the different factors like flexible, reliable, scalable, high-performance and security.

Developed automation scripts using AWS SDK’s such as AWS PowerShell, Python boto3, Node.js to deploy infrastructure as a code.

Deployed infrastructure on AWS utilizing services such as EC2 (Virtual Servers in the Cloud), RDS (Managed Relational Database Service), VPC and Managed Network and Security, Route 53, Direct Connect, IAM, CloudFormation, AWS OpsWorks (Automate operations), Elastic Beanstalk, AWS S3, Glacier, (Storage in the cloud) and CloudWatch Monitoring Management.

Implemented CI/CD pipeline using Jenkins, Git.

Responsible for monitoring infrastructure within AWS using CloudWatch and setup alerts and notifications using SNS.

Worked on CloudFormation templates to build infrastructure as a code across multiple environments.

Responsible for designing 3-tier architecture comprising Auto Scaling, Elastic Load Balancing with multiple web and application servers.

Designed and responsible for building highly available and fault-tolerant applications using AWS Services like ELB’s, ASG’s, SNS, AWS Lambda & CloudWatch.

Worked on providing cross-region availability of RDS instances using AWS Lambda by developing scripts in python boto3.

Worked on PowerShell scripts to gather resources metrics from the Production EC2 Instances, and configured Alerts and Dashboards using AWS CloudWatch Monitoring.

Highly responsible for development and management of SSAS, SSRS and SSIS projects.

Extracting and Loading data into SQL Server Database using SSIS and extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database. Created SSIS Packages to migrate slowly changing dimensions. Experience in creating complex SSIS packages using proper control and data flow elements.

Created Tabular Reports, Cross Tab Reports and Sub Reports. Experience in creating complex SSIS packages using proper control and data flow elements. Pulling data daily from OLTP database to OLAP or staging database using the SSIS packages.

Performed the task of data transfer from files in remote server to folders in another server using FTP. Created database maintenance plans and deleting of history data using SSIS packages.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012(SSAS).

Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports. Created complex reports which involve more number of groupings and multi-value parameters.

Setup new team projects in TFS, TFS work items and performed merges from different branches and resolve merge conflicts.

Environment: Amazon Web Services (AWS), Terraform, Windows, Linux, Microsoft SQL Server, RDS, SSMS, TFS, AWS OpsWorks, AWS EMR, AWS Redshift, Chef, Salt, Jenkins, git, AWS S3, VDI2, SSIS, SSRS, SSAS, Crystal Reports, IIS, Apache, Tomcat

AIG Los Angeles, CA April 2009 – July 2010

Position: BI Developer

Responsibilities:

Designed and Developed Database Objects Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks

Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS

Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix)

Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.

Created the DTS, SSIS packages to import the data from different data source like MS Access/Excel/ Oracle/Sybase/My SQL server to SQL Servers.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks

Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.

Proficient in Installing SQL Server 2000/2005/2008 and 2008R2 configuration of their tools.

Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.

Created Views and table for specific columns on a table to maintain privacy of a customer data. Created Indexes to get the high-level performance.

Maintained databases, performed software installations and upgrades, monitored Database Performance.

Responsible for gathering Business Requirements and System Specification from users.

Created Various Sparkline reports, Chart and Map reports using SQL Reporting Services. Created various Tabular and Matrix Reports using SSRS. Created various drill down reports using SSRS. Involved in the post deployment maintenance of reports

Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

Designed SSIS packages for synchronizing the data between two different servers.

Expert in Creating and scheduling SSIS and SQL server jobs for various tasks.

Environment: Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), Report Builder, T-SQL, MS Excel.

Contact this candidate