[pic] [pic]
Brahma Vankayalapati
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.