KIRAN KUMAR VANGAVETI

MICROSOFT AZURE, AWS, MS SQL SERVER WITH MSBI, ORACLE TECHNO FUNCTIONAL, DATABASE ADIMINISTRATOR AND SOLUTION ARCHITECT.

Mobile: +91-988*******

E-Mail: adlov1@r.postjobfree.com

Senior Functional Consultant Data Base Architect Client Management Team Management Delivery Excellence Solution Architect

Key Skills

Profile Summary

Dynamic technology professional leveraging with 14+ years of experience in Microsoft Azure, AWS, MS SQL Server with MSBI, Functional consultant, Oracle EBS and DB Administration.

Expertise in Solution Architect, Analysis, Design, Development and customization and Implementation of software applications including Cloud computing.

Exclusive 4 years of Experience in Functional Consultant.

Exclusive 5 years of Experience in Oracle EBS, MS SQL Server and Microsoft Azure.

Domain expert in banking Solutions, financial Solutions.

Designed end-to-end Business Intelligence (BI) solution to meet reporting needs

Skilled in performing network & security audits; recommending & scheduling database improvements, upgrades, patches and reconfigurations

Proficiently supported patch control and database configuration across cluster environment for server consolidation projects built on SAN

Skilled in designing, installing, upgrading, administering, monitoring SQL Server 2000, 2005, 2008 R2, 2014 & 2012 on Windows 2012 databases

Recognized for successfully completing projects such as Migrating SQL Server 2005 to 2008 and 2008 to 2012, implementing DR Solution by deploying Log Shipping and Mirroring, Fail Over Cluster, Always on

Hands-on knowledge of SQL Profiler, Red Gate Backup, SQL Safe, DB Tuning Advisor, PRTG and COMM vault

Skilled in developing and deploying SSIS packages, SSRS reports.

Migrating from SQL on premise- Azure (IAAS & PAAS)

Strong Exposure in writing Simple and Complex SQL Queries, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.

Extensive Knowledge on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.

Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.

Expertise in Dynamic SQL, Records, Arrays and Exception Handling.

Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process

Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.

Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project / Application requirements.

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Created external tables to handle huge volumes of data which is not used frequently.

Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.

WORK EXPERIENCE

Currently working as Associate Consultant with TATA Consultancy Services (TCS), Hyderabad as a Senior Functional Consultant, Oracle and SQL Server Developer cum Data Administrator from Aug’10 to till date.

I worked as BA with TCS, Hyderabad as SQL Developer and Sr. Tester from Jun’07 to Aug’10.

I worked as Retainer with APOnline Pvt Ltd, Hyderabad as a Support Engineer from Aug’06 to Dec’06.

ACADEMIC CREDENTIALS

2006 B.Tech (CSIT) JNTU University with Distinction [70.1%].

2002 Intermediate (M.P.C) M.R.R Jr. College with Distinction [84%].

2001 S.S.C SMV School with Distinction [70.67%].

KNOWLEDGE PREVIEW

Languages

C, Core Java, Map Reduce, Pig, Sqoop, Pig, Hive, HBase, PL/SQL

Platforms

MS Windows 2010/2007/2008/XP/Vista/7, Linux and UNIX.

Web Technologies

Oracle ERP, EBS, Micro soft Azure, AWS and HTML, Web APIs.

Databases

SQL Server 2000/2005/2008/2012/2017 and Oracle 8i, 9i, 10g, 11g

EMPLOYMENT SCAN

Key Deliverables

Key Result Areas:

Functional consultant on accounting area like GL, Trial Balance, Balance sheet, Ratios.

Domain expert in banking sector.

Manage business analysis, requirement specification, solution design, presentation &review and manage end-to-end projects for customers from US covering multiple industry verticals.

Maintain high process efficiency in Business Analysis, High Level Design Business Solution, Project Planning, Scheduling, Testing and Delivery

Resource management and delivery

Exhibiting knowledge of DMVs, Performance Dash Board, Mirroring, Database Snapshots

Undertaking implementation of new releases into production

Supervising database performance by rebuilding index at regular intervals

Designing & implementing policies & procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets

Creating logins with appropriate permissions

Supporting backup / recovery / disk space

Leading creation & maintenance of all databases required for development, testing, education and production usage

Performing DR-drills as per the client schedule timings

Driving database refresher and server decommission with up gradation from lower version to higher versions

Worked on analyzing Hadoop cluster and different big data analytic tools including Pig, Hive, Hbase, NoSQL database and Sqoop.

Importing and exporting data in HDFS and Hive using Sqoop.

Extracted files from MongoDB through Sqoop and placed in HDFS and processed.

Written Hive UDFS to extract data from database tables.

Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way.

Analyzed the web log data using the HiveQL.

Created External Hive Table on top of parsed data.

Written the Apache PIG scripts to process the HDFS data.

Developed the Sqoop scripts in order to make the interaction between Pig and MSSQL Database and Oracle.

Writing the script files for processing data and loading to HDFS

Writing CLI commands using HDFS.

Reviewing incidents/change requests as per the SLA metrics defined

Maintaining cluster environment in 2005, 2008R2 and 2012

Administering patch management and version control; applying database patch and recent SQL service packs

Directing configuration & implementation of replication between servers based on requirement

Enabling transmission data encryption, created master key and certificates to backup database

Enhancing user response time by improving queries and their index selections to minimize IO and eliminate table scans

Executing table partition to improve I/O access

Analyze the data from different sources i.e. Oracle, SQL Server and Flat file and define Data Warehouse and ETL processes.

Upgrading SQL server without any downtime

Working on SQL Profiler, Performance Monitor, Execution Plan and Tuning Advisor for database tuning

Addressing database migration issues including mapping logins/users & jobs to new environment servers.

Major Projects

Ikano Pay MVP, Ikano Bank AB Apr, 2019 to Present

Senior Functional Consultant and Module Lead

New Banking system establishment with loans and Cards with highly scalable, resilient & performant Micro services based APIs. This involves multiple modules like Counterparty, Contract and P&P. Where we can onboard a user and check all user information by integrating with multiple modules and process the loan. It is implemented using a secure event driven architecture model. Used Confluent Kafka for producing and consuming the messages through web socket API gateway. Once user onboard successfully then account will be generated for user in NETS system, then it will generate a virtual card. User can use this for online purchases with secure way using JWT token and all other OAM views.

Responsibilities:

Requirement Gathering and understanding the Business and Functional Requirement.

Ensured visibility, traceability, control and timely management of development and testing process to deliver high-quality software.

Developed Procedures, code in .Net, Web APIs and automation test framework for testing the components (CT).

Guided team to overcome various technical challenges during project execution.

Maintain high process efficiency in Business Analysis, High Level Design Business Solution, Project Planning, Scheduling, Testing and Delivery.

Resource management and delivery.

Developed integrations using web service SOAP, WSDL, XML, XSLT on the Workday cloud platform.

Experience in Data Conversions (Loading Data).

Advanced knowledge of databases (SQL Server & Cosmos DB) and advanced knowledge of relevant web services, mail, backup and application monitoring.

Development and Test Planning and Effort Estimation.

Assist in securing consulting services wins in support of Ciber’s MS Azure business.

Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.

Architect solutions using MS Azure PaaS services such as SQL Server, Data Migrations, service bus etc.

Provide technical oversight and guidance during client engagement execution.

Provide Cloud / Azure thought leadership through regular publications and speaking engagements.

Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process

Test Scenario/Test scripts writing and Test Data Preparation.

Test Script Execution, Defect logging and Defect tracking.

Developing UI based on software/Schema changes as per client requirements.

Creating release notes for all deployments and handling deployments coordinating with release management team.

Capital Finance Bank, USA Jan’18-Mar’19

Technical Lead and Solution Architect

This is a banking application, developed for performing online transactions. The customers can access their personal accounts using valid user id and password. The normal banking operations are accessing personal accounts, checking balances, checking transaction history, payment of recurring bills using B-pay, transfer of funds between same bank accounts and also between the other institutions accounts. Same bank transfers will take place at the same moment and transfer to the other institutes takes place on the next working day.

Responsibilities:

Requirement Gathering and understanding the Business and Functional Requirement.

Ensured visibility, traceability, control and timely management of development and testing process to deliver high-quality software.

Developed Procedures, code in .Net, Web APIs and automation test framework for testing the components (CT).

Guided team to overcome various technical challenges during project execution.

Maintain high process efficiency in Business Analysis, High Level Design Business Solution, Project Planning, Scheduling, Testing and Delivery.

Resource management and delivery.

Developed integrations using web service SOAP, WSDL, XML, XSLT on the Workday cloud platform.

Experience in Data Conversions (Loading Data).

Advanced knowledge of databases (SQL Server & Cosmos DB) and advanced knowledge of relevant web services, mail, backup and application monitoring.

Development and Test Planning and Effort Estimation.

Assist in securing consulting services wins in support of Ciber’s MS Azure business.

Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.

Architect solutions using MS Azure PaaS services such as SQL Server, Data Migrations, service bus etc.

Provide technical oversight and guidance during client engagement execution.

Provide Cloud / Azure thought leadership through regular publications and speaking engagements.

Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process

Test Scenario/Test scripts writing and Test Data Preparation.

Test Script Execution, Defect logging and Defect tracking.

Developing UI based on software/Schema changes as per client requirements.

Creating release notes for all deployments and handling deployments coordinating with release management team.

iRobo Advisory, ICICI Bank Feb’17-Dec’18

MS SQL Server with MSBI Developer, Microsoft Azure

iRobo Project is part of a much bigger plan of ICICI to revamp the way they let people invest money. This phase deals with replacing the existing mutual funds app which serves close to 75,000 active customers daily and introducing a iRobo Advisory. iRobo Advisory is an AI engine that profiles each user based on their investment and a questionnaire and then suggests portfolios to the customer which gives him maximum return on investment according to his investment preferences.

Roles & Responsibilities:

Guided team to overcome various technical challenges during project execution.

Maintain high process efficiency in Business Analysis, High Level Design Business Solution, Project Planning, Scheduling, Testing and Delivery.

Equal competence Integration Services, Reporting Services and Analysis Services.

Experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

Hands on experience in SQL Server Reporting Services (SSRS).

Hands on experience in scheduling and deploying reports on report manager.

Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).

Experience in Data Conversions (Loading Data).

Advanced knowledge of databases (SQL Server & Cosmos DB) and advanced knowledge of relevant web services, mail, backup and application monitoring.

Development and Test Planning and Effort Estimation.

Assist in securing consulting services wins in support of Ciber’s MS Azure business.

Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.

Architect solutions using MS Azure PaaS services such as SQL Server, Data Migrations, service bus etc.

Provide technical oversight and guidance during client engagement execution.

Provide Cloud / Azure thought leadership through regular publications and speaking engagements.

Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process

Test Scenario/Test scripts writing and Test Data Preparation.

Test Script Execution, Defect logging and Defect tracking.

Developing UI based on software/Schema changes as per client requirements.

Creating release notes for all deployments and handling deployments coordinating with release management team.

Diageo (UK) Dec’15-Jan’17

Oracle Solution Architect

Diageo is an alcoholic beverage client based out of UK operates in 180 countries and does the manufacturing of its Spirits, Beer, and other Ready-to-drink brands from more than 140 sites around the world. Due to the large-scale operations. With the growing penetration of online channels in the North American market, client was also objectively looking for integrating the online and brick and mortar channels and rationalize it’s offering. By doing all this, client was basically striving towards enhancing its predictive capabilities and management of its sales execution.

Roles & Responsibilities:

Requirement Gathering and understanding the Business and Functional Requirement.

Ensured visibility, traceability, control and timely management of development and testing process to deliver high-quality software.

Developed Procedures, code in .Net, Web APIs and automation test framework for testing the components (CT).

Guided team to overcome various technical challenges during project execution.

Maintain high process efficiency in Business Analysis, High Level Design Business Solution, Project Planning, Scheduling, Testing and Delivery.

Resource management and delivery.

Developed integrations using web service SOAP, WSDL, XML, XSLT on the Workday cloud platform.

Experience in Data Conversions (Loading Data).

Development and Test Planning and Effort Estimation.

Test Scenario/Test scripts writing and Test Data Preparation.

Test Script Execution, Defect logging and Defect tracking.

Developing UI based on software/Schema changes as per client requirements.

Creating release notes for all deployments and handling deployments coordinating with release management team.

Johnson and Johnson Inc, USA Apr'13-Dec’15

Big Data and SQL Server Developer cum DBA.

Roles & Responsibilities:

Involved in DB Design.

Writing SQL Queries (Stored Procedures, Views, Triggers and Functions).

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Involved in handling the changes in compiling scripts according to the database changes.

Developed reports using complex queries as per client request as a part of production support

Supporting backup / recovery / disk space

Leading creation & maintenance of all databases required for development, testing, education and production usage

Moved all crawl data flat files generated from various retailers to HDFS for further processing.

Written the Apache PIG scripts to process the HDFS data.

Created Hive tables to store the processed results in a tabular format.

Developed the Sqoop scripts in order to make the interaction between Pig and MSSQL Database and Oracle.

Involved in gathering the requirements, designing, development and testing

Writing the script files for processing data and loading to HDFS

Writing CLI commands using HDFS.

Developed the UNIX shell scripts for creating the reports from Hive data.

Completely involved in the requirement analysis phase.

Analyzing the requirement to setup a cluster

Created two different users (HDuser for performing HDFS operations and map red user for performing map reduce operations only)

Ensured NFS is configured for Name Node

Setting Password less Hadoop

Setting up Cron job to delete Hadoop logs/local old job files/cluster temp files

Setup Hive with MSSQL as a Remote Meta store.

Moved all log/text files generated by various products into HDFS location

Written Map Reduce code that will take input as log files and parse the logs and structure them in tabular format to facilitate effective querying on the log data

Created External Hive Table on top of parsed data.

CommercialXpertPlus Project, USA Aug'10-Mar'13

Oracle, SQL Server Developer cum DB Administrator

CommercialXpertPlus Provides Coverage and provides Policies for the Buildings for all states in US. Dwelling Fire, Theft and vandalism coverage’s throughout states. This is having different policy types and each policy type is having respective Line of Business integrated with those policies. For each line of business has to be adding Location and building, coverage’s for a policy type. The policy is termed as Quotation (Quote). Each Quote can have multiple locations and each location can have multiple Buildings. Each building has at least one coverage. Rating will be generating for selected buildings based on assigned coverage’s. For Ex (Theft Coverage, Vandalism Coverage… etc).

Roles & Responsibilities:

Involved in DB Design.

Writing SQL Queries (Stored Procedures, Views, Triggers and Functions).

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Involved in handling the changes in compiling scripts according to the database changes.

Developed reports using complex queries as per client request as a part of production support

Steering efforts in migrating SQL Server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition

Exhibiting knowledge of DMVs, Performance Dash Board, Mirroring, Database Snapshots

Undertaking implementation of new releases into production

Supervising database performance by rebuilding index at regular intervals

Designing & implementing policies & procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets

Creating logins with appropriate permissions

Supporting backup / recovery / disk space

Leading creation & maintenance of all databases required for development, testing, education and production usage

Performing DR-drills as per the client schedule timings

Driving database refresher and server decommission with up gradation from lower version to higher versions

Providing network connectivity and addressing issues raised by application users

Assessing:

SQL server and event viewer error logs time to time

Daily backup, differential and T-Log within first few hours

Anchoring installation & configuration of:

Reviewing incidents/change requests as per the SLA metrics defined

Maintaining cluster environment in 2005, 2008R2 and 2012

Administering patch management and version control; applying database patch and recent SQL service packs

Directing configuration & implementation of replication between servers based on requirement

Enabling transmission data encryption, created master key and certificates to backup database

Enhancing user response time by improving queries and their index selections to minimize IO and eliminate table scans

Executing table partition to improve I/O access

Upgrading SQL server with less downtime.

Working on SQL Profiler, Performance Monitor, Execution Plan and Tuning Advisor for database tuning

Addressing database migration issues including mapping logins/users & jobs to new environment servers

NREGA, Govt of India Jun'06-Aug'10

Oracle, SQL Server Developer and Sr. Tester

The project consists of eight different modules, with each module having its own specification's and importance. The idea in this project is to provide minimum of 100 days of employment for a household in rural villages under NREGA and to eliminate the contactors from the works and to deposit the wage in their own accounts (Bank/Post-Office) through online using Central Fund Management System within 4 days from the date of completion of the work.

The TCS NREGS, AP Solution facilitates successful Implementation of the NREGA through the use of Information & Communication Technology by Integrating following processes into a single.

Benefits:

Transparency and Visibility.

Complete reconciliation of work and wages.

Increase in accountability.

Alerts on possible leakages.

Reduced data capture efforts and administrative cost.

A data warehouse of 100 million Indians.

Responsibilities:

Involved in DB Design.

Writing SQL Queries (Stored Procedures, Views, Triggers and Functions).

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Involved in handling the changes in compiling scripts according to the database changes.

Developed reports using complex queries as per client request as a part of production support.

Maintaining daily batch cycle and providing 24-hour production support.

Developed Korn shell scripts to kick off back end PL/SQL, SQL programs

Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Coordinating with the development team for defect analysis.

Guide the testing team to achieve the goals.

PERSONAL DETAILS

Name : V. Kiran Kumar.

Father’s Name : Gurunadham.

Date of Birth : 10-08-1984.

Languages known: English, Hindi and Telugu.

PASSPORT DETAILS

Name as on passport

Relationship

Passport Number

Place of Issue

KIRAN KUMAR VANGAVETI

Self

P2121316

Hyderabad.

Senior Functional Consultant

Oracle Solution Architect and Cloud Computing.

SQL Server Development

Microsoft Azure & AWS

Oracle and SQL Database Administration (DBA)

Knowledge on BIG Data

Senior Testing Manager

Integrity & Capacity Management

Team Building & Leadership

Contact this candidate