[pic] [pic]

Brahma Vankayalapati

678-***-****

acgkar@r.postjobfree.com

OBJECTIVE: To seek a challenging career where I can utilize my abilities,

experience, personal skills and interest, and direct them towards the

success of organization.

SUMMARY OF EXPERIENCE:

. Have 10+ Years of IT experience on various technologies in which 6 years

of experience in Oracle Technologies and 2 exp as Hadoop, NoSQL

developer.

. 2 year of experience in design and development of applications using C#,

.Net, and Oracle and SQL Server databases.

. Good exposure on various scripting languages like Shell scripting.

. Have a good exposure in Hadoop Map-Reduce job scheduler paradigms, Hive,

Pig, Flume, Sqoop and NoSQL database like HBase, MongoDB.

. Have knowledge in Cassandra.

. Developed multiple POCs on BigData implementations.

. Excellent in the use of the import and SQL Loader utilities to load data.

. Expertise in Tuning & Optimizing the DB relevant issues (SQL Tuning).

. A self-motivated, responsible and reliable team player with a set of

strong technical skills.

. Excellent knowledge in Java and Hibernate.

. Worked in data warehousing project with the size of TBs.

. Involved in Low Level Data Base Designs right from the initiation of the

Projects.

. Expertise in the creation of databases, table spaces, tables, indexes and

other database objects.

. Good understanding and knowledge of Cost-Based Optimizer, Access Paths

and Joins.

. Expertise in PL/SQL Programming & Shell Scripting and exposure to Fine

Grained Access.

. Modify database structures as required by developers due to business or

application requirements, clone development databases for testing and

training.

. Set up and manage database security by creating new users, roles,

profiles, and provide required user privileges in development, test,

training and production environments.

. Strong in solving problems of diverse scope where technical analysis and

evaluation is required.

SKILL SET

Operating Systems Redhat Linux

Windows

Suse Linux

Sun Solaris

Programming Languages Java, C#

Scripting Languages Python

Shell Script

Grunt

Pig

Frame Work JSF, Spring

Mark Up Languages XML

HTML

Build tool Maven

Application Servers Tomcat(5.0)

Websphere

Web Server Apache HTTP Web Server

IDE Tools Eclipse (J2ee.Python)

PyScriptor (3.0)

Configuration SVN

Management Tools CVS (Clients- WinCVS, Tortoise CVS),SVN

Methodology Tool Rally(agile tracking tool)

Vertical Knowledge US Benefits Administration, India Share

Market

PROJECT EXPERIENCE:

ADP, Alpharetta, GA Mar '2013 -

Current

Benefits Analytics was completely developed and implemented using Cloudera

Distribution such as Hadoop/Flume/MapReduce/Hive/Hbase. Each component

where integrated using different technologies like Java to parser data from

Oracle to HBase and to provide data for analytic team to derive valid KPIs

Job Responsibilities:

. Development of Map-Reduce developer using Hadoop API.

. Customized Monitoring tool to make compatible with HADOOP components.

. Involved in Architecture Design and implementing in end to end Solution

. Installed and configured Hive and also written Hive UDFs.

. Implemented ETL solution with Hive

. Involved in creating Hive Tables, loading with data and writing Hive

queries which will invoke and run MapReduce jobs in the backend.

. Implemented Hive tables and HQL Queries for the reports

. Escalated code issues to dev team with analyzing server logs

. Implementing POC for moving data from Hive into Hbase for realtime

analytics.

. Code/Design reviews

. Component identification for reuse

. Importing and exporting data into HDFS and HIVE using Sqoop

. Responsible to manage data coming from different sources

. Performed joins, group by and other operations in MapReduce.

. Processed the output from java and formatted it before sending to the

Hadoop output file.

. Responsible in all aspects of Unix, Linux system administration:

including implementation, configuration, coordination control,

maintenance, troubleshooting, testing, usage monitoring and the

development of system procedures

. Guiding team members in debugging/ problem solving

. Customer co-ordination, status reporting

. Following quality processes as per organization guidelines.

. Project scheduling tracking, monitoring, metrics collection and reporting

to higher management using KPITCummins quality system

. Trained team on bigdata and eco systems.

. Helping BI team to understand hive and to get data from it.

Environment : Hadoop, Map Reduce, Hive, Pig, Java, Python, Zookeeper,

Oracle, Sqoop, Flume, HBase, Eclipse

ADP, Alpharetta, GA Nov '2010 -

Feb '2013

ADP HCM Vantage gives you the most comprehensive set of human capital

management capabilities available today, with a single solution that unites

the five major areas of Vantage: human resource management, benefits

administration, payroll services, time and labor, and talent management.

With Vantage-related data, applications and processes can be better aligned

with business strategy. As a result, you'll be able to meet strategic goals

and improve business outcomes.

Job Responsibilities:

. Created schemas for new users and managed the security and access the

database by granting appropriate privileges and roles to the users based

on client policy.

. Provide database administration for testing and development database

servers. Creation of database objects like tables, indexes, stored

procedures and views etc.

. Wrote extensive SQL and PL/SQL Procedures, Functions.

. Monitored database activities, performance, and size. Increase the size

if required and identified and resolved performance issues.

. Analyzed the database tables and indexes and then rebuilt the indexes if

there is fragmentation in indexes.

. Performed Data Migrations from Production to Test and Development

Environments.

. Developed database components using Java and Hibernate.

. Owns the responsibility of fixing/updating the QA DB & Development DB.

. Handled batch processing for export/import functionalities into various

heterogeneous systems.

. Created schemas for new users and managed the security and access the

database by granting appropriate privileges and roles to the users based

on client policy.

. Provide database administration for testing and development database

servers. Creation of database objects like tables, indexes, stored

procedures and views etc.

. Coordinating with Developers and users connecting to different databases,

setting policy and procedures as they relate to database

maintenance.

. Monitored database activities, performance, and size. Increase the size

if required and identified and resolved performance issues.

. Tuned & Optimized SQL queries using indexes and table partitioning.

. Analyzed the database tables and indexes and then rebuilt the indexes if

there is fragmentation in indexes.

. Planned Backup and Recovery using Cold Backup. Responsible for building &

deploying the DB Utilities required in QA Environment

. Built the Client Restore/back-up utility for QA Clients to enable QA

Automation Executions by bringing the clients to desired App State.

Environment : Oracle Server 11g, 1og, Windows NT/2000/2003/XP, Quest

- Toad, Sql Developer

ADP India Nov '2007

- Oct '2010

HWSE (Health & Welfare service engine) is an ADP's single benefits

processing application to provide core health and welfare benefit

outsourcing services to our clients. HWSE provides core Health & Welfare

administration outsourcing services to clients who desires to have a stand-

alone HWSE services or its even supports to the clients who is using many

ADP's other applications. It handles the benefit processing for different

sizes clients. It supports benefit processing during the open enrollment &

as well all the throughout the Life events.

HWSE prime objective is to assist employers in calculating eligibility for

benefits, communicating benefits to employees, capturing benefit elections

based on year round events, calculating payroll deductions, transmitting

data to carriers qualifying events, and allowing clients access to data via

reporting tools. HWSE provides benefits to the employee's & to the

dependents as well.

Job Responsibilities:

. Handled batch processing for export/import functionalities into various

heterogeneous systems.

. Created schemas for new users and managed the security and access the

database by granting appropriate privileges and roles to the users based

on client policy.

. Provide database administration for testing and development database

servers. Creation of database objects like tables, indexes, stored

procedures and views etc.

. Coordinating with Developers and users connecting to different databases,

setting policy and procedures as they relate to database

maintenance, Security, backup & Recovery etc.

. Managed Table spaces, Database structure and storage allocation, Undo

segments, etc.

. Wrote extensive SQL and PL/SQL Procedures, Functions.

. Monitored database activities, performance, and size. Increase the size

if required and identified and resolved performance issues.

. Tuned & Optimized SQL queries using indexes and table partitioning.

. Analyzed the database tables and indexes and then rebuilt the indexes if

there is fragmentation in indexes.

. Planned Backup and Recovery using Cold Backup. Responsible for building &

deploying the DB Utilities required in QA Environment

. Built the Client Restore/back-up utility for QA Clients to enable QA

Automation Executions by bringing the clients to desired App State.

. Installation, Configuration and maintenance of Oracle 11g/10g Data Base

in Linux and Windows Servers.

. Performed Data Migrations from Production to Test and Development

Environments.

. Responsible for applying the DB dumps in to Development Environment from

Production (typically based on Customer Tickets/requests).

. Owns the responsibility of fixing/updating the QA DB & Development DB.

. Responsible for applying DB Scripts/Patches as part of Hot Fixes/Version

Migrations.

Environment : Oracle Server 11g, 10g & 9i, 11g/10g RAC, Windows,

Linux Suse, Quest - Toad, Sql Developer

AppLabs Technologies, India

Sep '2006 - Nov '2007

Trade Anywhere is the Internet Trading System (ITS) called 'TRADE ANY-

WHERE' provided by Bombay Stock Exchange facilitates its clients to trade

directly with the exchange, wherein it saves time for the client if he

places the orders through his broker who is registered with the exchange.

ITS facilitates the clients to do on-line trading for both the Equities and

Derivatives market together.

The ITS system also has Risk- Management and surveillance facility at the

exchange-level and broker -level:

XAT-Exchange Admin Terminal

BAT-Broker Admin Terminal

Job Responsibilities:

. Oracle Environment setup as locally, and created Schemas for QA team.

. Created stored procedures to automate regular jobs.

. Created schema baselines and taking backup/reloads for QA testing purpose

. Automated the process of Schema differences.

. Regular monitoring and troubleshooting the db server issues.

. Worked as .net Developer.

. Designing, Creating Database Structure.

. Designing a template for n-tier architecture.

Environment : Oracle 9i, .NET with C#, Windows NT/2000/2003/XP,

Navayuga Infotech, India

Feb '2006 - Aug '2006

City Insight is a web-based application that is being developed for the use

of both ETT personnel and ETT customers. Through City Insight, both the ETT

personnel and ETT customers would access the modules listed below:

Administration, Contact Management System, Document Management System,

Resource Logging, HEAT Trouble Tickets, User Administration.

ETT have chosen to use LDAP as the authentication method of choice. LDAP

was chosen, as it is the most flexible user database platform and can be

expanded to incorporate future services. It is a multi-lingual project.

Job Responsibilities:

. Worked as .net Developer.

. Designing, Creating Database Structure.

. Designing a template for n-tier architecture.

. Creating Resource Project for Satellite Assemblies for different

languages.

. Design and Coding of Customer related forms.

. Designed and developed various types of Customer Details Reports.

Environment : ASP.NET, C#, Web Services - Behaviors, XML, LDAP,

Oracle

Navayuga Infotech, India

May '2004 - Jan '2006

Derm Click is a browser based application to extend medical-clinical

administrative services to the users and to insure higher patient

satisfaction and a better environment for everyone. The major modules are

Maintenance, Scheduling and Billing.

The Maintenance Module contains all the necessary sections to make

Solutions truly individual to the practice. Provides information concerning

scheduling preferences, qualifications, and other employee data and Billing

addresses are entered through this module as well as Providers, Referring

Providers, Locations, and Facility information.

Job Responsibilities:

. Worked as .net Developer.

. Involved in designing template for n-tier architecture.

. Design and Coding of Customer related forms.

Environment : ASP.NET, C#, Web Services - Behaviors, XML, LDAP,

Oracle

Achievements:

. OCA certified as Oracle Developer.

. MongoDB with Python Development track certified from MongoDB

University.

. Hadoop Map-Reduce certified from BigData University.

. MCAD certified from Microsoft.

Contact this candidate