RESUME

Sravan Kumar Mannem Mobile: +91-995******* E-mail:acwm9u@r.postjobfree.com mailto:acwm9u@r.postjobfree.com

Job Objective

To seek a position with a reputed organization that will harness and improve my skills while being resourceful, innovative and flexible.

Experience Summary

• Currently working in Wipro Technologies as HP Vertica Specialist.

• 2 years of Experience in HP Vertica as a Developer.

• 5 years overall IT experience.

• Shell Scripting /working with UNIX operating system.

• Working experience in Hadoop Architecture.

• Have knowledge in ETL tool Talend.

• Python, R scripting knowledge.

• Knowledge in Tableau BI tool, Qlikview.

• Experience with Subversion versioning tool SVN.

• Experience with scheduling tool Control-M, cron.

• Good understanding in Manufacturing-Logistics, Utilities and Banking.

• Work experience in Agile-Scrum and Waterfall SDLC models.

• Excellent verbal and written communication in English and interpersonal Skills.

• Passion to learn new technologies and ability to take ownership in managing project deliverables.

Availability

2 month notice period.

Projects Summary

Project Title

Enterprise Data Lake

Client

HP inc.

Tech Stack

HP Vertica, Map reduce, Hive, Talend.

Location

Dallas,NA

#1 PROJECT DESCRIPTION:

The EDL project is to have a certified zone of all the data for over 20 applications in Hadoop Big data.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Loading data from Hive to Vertica using Map reduce and Vertica-Hadoop native connector.

Write existing informatica transformations in talend ETL.

Optimize queries and improve performance of long running queires.

Create, grow and manage Vertica database Instances in all environments such as Dev, QA and Production.

TECHNOLOGIES USED IN THIS PROJECT:

HP Vertica 7.XX, Unix shell scripting, Hadoop, Map reduce, Hive, sqoop

Project Title

Digital Pulse

Client

BNY Mellon

Tech Stack

HP Vertica, Sql, Shell Scripting, Python.

Location

Ney Jersey,Silicon Valley,NA

About client:

BNY Mellon dates its roots to 1784 and is the oldest banking corporation in the United States. Today, it generates annual revenues of more than $15 billion and has $27 trillion equivalent to one-fifth of the global economy under management. BNY Mellon is a global investments company dedicated to helping its clients manage and service their financial assets throughout the investment lifecycle. Whether providing financial services for institutions, corporations or individual investors, BNY Mellon delivers informed investment management and investment services in 35 countries and more than 100 markets. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation (NYSE: BK).

#2 PROJECT DESCRIPTION:

Digital Pulse is proprietary Big Data analytics platform, enabling company to generate actionable insights to improve processes and business performance.

EMEA technology expo 2015 “ ..clients described Digital Pulse as “inspiring” and “excellent”…”

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Development of Vertica code components.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Create, grow and manage Vertica database Instances in all environments such as Dev, QA and Production.

Design solutions that can support scalability requirements and deliver performance and reliability

Work with various stakeholders including product management, business development to get requirements and implement appropriate data-driven solutions

Designing and developing data integration/data warehousing/business intelligence solutions using open source/Native BI tools.

Generate alerts to application teams on the Vertica by pinpointing the long running queries and fine tune the queries.

TECHNOLOGIES USED IN THIS PROJECT:

HP Vertica 7.XX, Unix shell scripting, Python scritping

Technical Stack

Technology Stack

Squirrel Sql developer, DB visualizer, Putty, Winscp, SVN, BugZilla, CONTROL –M, Rstudio, Tableau, QLikview,JIRA

Databases

HP Vertica, Oracle 11g, Sybase

Other Languages

Core Java, Shell scripting, Python, PERL

Operating Systems

Windows 2007,XP,AIX

Project Title

Tulsa Platform consolidation

Programming Languages

Sql Pl-Sql, Shell Scripting, Core Java.

Location

Direct Energy, NA

#3 PROJECT DESCRIPTION:

This project is a support and maintenance project and it involves call handling, change request handling, Service enhancements, and meeting service level agreement.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Requirement Gathering.

Estimation and module designing.

Code Integration and code review.

To develop Oracle PL/SQL programs (packages, procedures, functions, views) that adhere to the requirements document and development standards and best practices.

Unit Testing and Code deployment in multiple environment (DEV, UAT) using Unix environment and sql developer.

Commit the changes to trunk/ branch using subversion tool SVN.

Engaged in query performance analysis, debugging, and optimization.

Documenting all stages of requirement like impact analysis, SDS, Test case document, CRF and SRF document.

TECHNOLOGIES USED IN THIS PROJECT:

Oracle 11g, Unix shell scripting

Technical Stack

Technology Stack

Sql developer, TOAD, Eclipse, Putty,Winscp, SVN,BugZilla,CONTROL -M

Databases

Oracle 11g, Sybase

Other Languages

Core Java, Shell scripting, PERL

Operating Systems

Windows 2007,XP,AIX

Awards and Achievements

Optimized a long running query to 20 min which was taking 5 hours to complete with a frequency of 4 times a day in production (Jul-2016).

Tuned the CRON job from 4 hours to 10 min using Python and Vertica (May 2016).

Database developer for the project Nominated as one of the best project WFA(Work Force Analytics) for the 2nd quarter of 2015.

Received winner award in Manlog Hackathon in CTS for the year 2013.

Received “The Ideator Award” Spot award from CTS in April 2013 for first quarter.

Received Transformer award for Q2-2014 in recognition for problem solvers and outstanding contributions towards project execution.

Education Qualification

Highest Qualification

Institute/School

Board/University

Percentage M.Tech (Sensor Systems)

VIT (Vellore Institute of Technology)

VIT University

8.25(CGPA)

PERSONAL DETAILS

Father’s Name : Venkateswarlu

Gender : Male

DOB : 8 June, 1988

Marital Status : Married

Languages Known : English, Telugu, Hindi and Tamil.

Nationality : Indian

Permanent Address : Door No.28-746, RamNagar, Mypadu Gate, Nellore-524002.

DECLARATION

I hereby declare that above mentioned details are true to best of my knowledge.

Bangalore

Sravan Kumar Mannem

Contact this candidate