Hanumanth

 P HANUMANTHA RAO Hadoop Developer Mobile - Email:- Professional Summary Overall 4+ years of experience in IT. Having experience of Two years on Big Data and Analytics. Experience with the tools in Hadoop Ecosystem including Hive, HDFS, Sqoop, Spark and Scala. Experience in developing applications in Spark using Scala to compare the performance of Spark with Hive and SQL. Experience in manipulating/analyzing large datasets and finding patterns and insights within structured and unstructured data. Experience in migrating the data using Sqoop from HDFS to Relational Database System and vice-versa. Strong working experience with storage, querying, processing and analysis of big data. Experience in analyzing data using HiveQL and Spark Programs. Experience in database design using PL/SQL to write Stored Procedures, Functions, Triggers and strong experience in writing complex queries for SQL Server. Experience in developing web development using in ASP.NET, C#.NET and SQL Server 2008/SQL Server 2012. Experience in supporting the production system and handling day to day issues. Experience with Full Software Development Life Cycle (SDLC) from inception to delivery of product including requirements gathering, functional specification, design, estimation, implementation, debugging, Project Release and Production support. Hands on experience on JQUERY and JAVASCRIPT. Finally support and maintenance of the application during production phase. Skill Set Hadoop Ecosystem: HDFS, Sqoop, Hive, Spark. Languages:C#.Net, Scala. RDBMS:SQL-Server 2008/2012 Data Access Technologies:ADO.Net, Entity Frame Work. Client Side Technologies:JavaScript, JQUERY. Web Technologies :ASP.NET 4.0. IDE:Visual Studio 2008/2010/2012. Experience PhyCARE Services India pvt Ltd. September-2017 to present About Company PhyCARE is a Global Health Care services company offers Revenue Cycle Management, Recruitment and Business Process Outsourcing Services to its clients. Our ability to deliver quality solutions comes from years of experience in healthcare built on expertise with constant focus on efficiency, cost effectiveness and customer satisfaction. Our broad range of customizable solutions caters to the needs of payers and providers. 1. Projects Details Project Name Hospital Coding System Duration Mar-2018 to Present Technology/Software Spark, Scala, Hive, Sqoop Role Software Developer Description: This project is used for coding of medical records based on Decease description in the medical record with W.H.O standard medical codes for US- Metropolitan hospital to clime insurance. Mapping Medical Records (.txt files/Excel/CSV): Files are copied from US server to local server and mapping (reading) the files based on specifications given by client. While mapping medical record, few of the demographic information are read into the database which is reflected in the demographic section. Medical Coding: The coder reads the healthcare provider’s report of the patient’s visit and then translates each bit of information into a code. There’s a specific code for what kind of visit this is, the symptoms that patient is showing, what tests the doctor does, and what the doctor diagnoses the patient with. The codes are ICD (International Classification of Diseases), CPT (Current Procedure Terminology). Medical Billing:  Medical billers take the information from the medical coder and make a bill for the insurance company, called a claim Roles and Responsibilities: Analyzing the data and converting it into business requirements. Developing Spark programs using Scala API’s to compare the performance of spark with Hive and SQL. Used Spark API over cloudera Hadoop YARN to perform analytics on data in Hive. Implemented Spark using Scala and SparkSQL for faster testing and processing of data. Implemented Spark RDDs and Data frames, performed transformations and actions on them. Actively participated to writing Hive queries to load and processing data in Hadoop File system. Import and Export data from Sql Server through Sqoop , consume data into HDFS, Process the data and load into Hive. Involved in database connection by Using SQOOP. Gathered the business requirements from the business partners. Developing Hive table schema Implementing hive scripts for fast retrieval of data. 2. Projects Details Project Name Personnel assessment. Duration Sep-2017 to Dec-2017 Technology/Software ASP.NET, C#.NET, SQL Server 2008 Role Software Developer Description: Personnel assessment is a systematic approach to gathering information about individuals. This information is used to make employment or career-related decisions about applicants and doctors. Roles and Responsibilities: Developed Coding, Designing and Business Logic Components using C#.Net. Involved in Creating Stored Procedures in SQL Server 2008. Involved in Client-side validations using AJAX and JavaScript and JQuery Database Handling Using ADO.Net EC-Council Pvt Ltd. November-2015 About Company The International Council of Electronic Commerce Consultants (EC-Council) is a member-supported professional organization that certifies individuals in various e-business and information security skills. EC-Council has also created other cyber security credentials, such as Certified Network Defender (C|ND), Certified Chief Information Security Officer (C|CISO), Computer Hacking Forensics Investigator (C|HFI), among many others that are offered in over 145 countries globally 1. Projects Details Project Name ASPEN Duration Nov-2015 to Aug-2016 Technology/Software ASP.NET, C#.NET, SQL Server 2012 Role Software Developer Description: ASPEN is a one-step gateway to multiple portals, products and services provided by EC-Council for its registered members. It is an integrated environment and a user friendly portal, where a User can navigate to various web pages through a single login. Roles/Responsibilities: Understanding the requirements and functional specifications of the application. Developing and maintaining the application using 3-tier architecture. Implement application using Object Oriented Programming to improve software development productivity, software maintainability for higher quality product. Implementing database programming like writing large stored procedures, functions, views , triggers and automatic job scheduling. 2. Projects Details Project Name Exam Specialist Duration Sep-2016 to Aug-2017 Technology/Software ASP.NET, HTML,ADO.NET, C#.NET, JQuery Role Software Developer Description: Online Exam is web based application. There are two important modules in this application: Admin Test Taker The Admin set the Question paper based on subject and languages He then creates some voucher codes for security purpose. These voucher codes are unique for student and tests. The Test Taker will enter the voucher code and it will redirect to the respective Test. The user must complete the exam within the time period or else the exam gets expired. Roles/Responsibilities: Understanding the Client requirements and functional specifications of the application. Understanding the vulnerable code of ASP.NET, C#.NET and SQL Server programming modules and providing accurate secure code by surfing the internet. Designing and development of User Interface pages. Implemented application using Object oriented programming language to improve software development productivity, software maintainability for higher quality product. Personal Profile Name:Pedasingu Hanumantharao Father Name:P Pattabhi ramaih Gender :Male D.O.B:16/04/1993 Marital Status:Single Languages Known: English & Telugu Declaration I hereby declare that all the above information is true to the best of my knowledge. Place: Hyderabad [Hanumantharao]