Mangesh B.

Mangesh B.

Having 9+ yrs of experience in IT and 3+ in big data

Bengaluru , India

Experience: 9 Years

Mangesh

Bengaluru , India

Having 9+ yrs of experience in IT and 3+ in big data

9 Years

Now you can Instantly Chat with Mangesh!

About Me

Hi

Have 6+ yrs experience in asp.net, C#, sql server, pl-sql , SSRS etc. And 3+ yrs Exp in Bigdata hadoop hive,sqoop,spark,scala, spark Streaming. Having Knowlege of multiple beusiness domain.

...

Show More

Skills

Portfolio Projects

Big Data Lake , Realtime Dashboard and Analysis,UPI fraud,GNOME,BIG-Query

Company

Big Data Lake , Realtime Dashboard and Analysis,UPI fraud,GNOME,BIG-Query

Description

Description :

  1. Involved in all phases of Software Development Life Cycle (SDLC). 
  2. Designed Hadoop architecture and Install Hadoop cluster of 25 Node.
  3. Development and Implemented Logic for Real Time UPI Fraud detection Flume-Kafka-Spark Streaming-Hive.
  4. Used Spark with scala and pyspark for different rules for suspicious transactions detection.
  5. Implemented Lambda architecture using spark scala.
  6. Migrated existing RDBMS Data Marts to HADOOP using sqoop import into Hive tables.
  7. Provided Solutions for migrating existing RDBMS PLSQL to hadoop ,python spark
  8. Prepared Datasets for analytical use case.
  9. Created Hive tables and wrote Hive queries using Hive QL. 
  10. Managed data ingestion from different sources like RDBMS,flatfile. 

Show More Show Less

Loyalty Rewards

Company

Loyalty Rewards

Description

  1. Created Data model for Hive tables.
  2. Created Hive tables and wrote Hive queries using Hive QL 
  3. Responsible to manage data coming from different sources 
  4. Monitoring the running MapReduce programs on the cluster. 
  5. Responsible for loading data from Linux file systems to HDFS. 
  6. Used MR Unit and Junit for unit testing.
  7. Monitored System health and logs and responded accordingly to any warning or failure conditions.

Show More Show Less

LEMS (L&T),Islamic banking, Infranet

Company

LEMS (L&T),Islamic banking, Infranet

Description

  1. Involved in all phases of Software Development Life Cycle (SDLC). 
  2. Coordinated with business customers to gather business requirements. And also interacted with other technical peers to derive Technical requirements.
  3. Worked on Installing and configuring MapReduce, HDFS and developed multiple MapReduce jobs in java for data cleaning and preprocessing. 
  4. Developed java based mapreduce programs for custom processing
  5. Wrote Hive UDFs in Java where the functionality is too complex. 
  6. Used Pig (PigLatin) scripts for ad-hoc data retrieval
  7. Created Data model for Hive tables.
  8. Created Hive tables and wrote Hive queries using Hive QL 
  9. Imported and exported data into HDFS and HIVE using Sqoop 
  10. Responsible to manage data coming from different sources 
  11. Monitoring the running MapReduce programs on the cluster. 
  12. Responsible for loading data from Linux file systems to HDFS. 
  13. Used MR Unit and Junit for unit testing.
  14. Monitored System health and logs and responded accordingly to any warning or failure conditions.
  15. Performance tuning, Query optimization in Sql server and oracle PL-SQL.
  16. Development and Managing SSRS Reports,SSIS Package, Stored procedure ,Functions.

Show More Show Less

Stock management Application

Company

Stock management Application

Description

Details: This Project was all about Product Management & Finance. In this project we had maintain stock management as per users requirement, so user can easily track the diamonds status from manufacturing to sell. Managing Windows Server and Database Server with large database for domestic level.We developed same product for international use.

      We developed stored procedure,functions,triggers,ETL. We developed and   maintaining the database

Roles and Responsibilities:

 Coordinate with the User for their requirement.

 Coordinate with the Technical Director on current programming tasks.

 Quickly produce well-organized, optimized, and documented source code.

 Debug existing source code and polish feature sets.

 Contribute to technical design documentation.

 Worked independently when required.

 Continuously learn and improve skills.

 Attention to detail is essential and all tasks must be carried out to the highest standard.

Show More Show Less

Diamonds stock management

Company

Diamonds stock management

Description

Details:This Project is all about Product Management &Finance. In this project  we have maintain stock management as per order of  “Diamonds”, so user can easily track the diamonds status from manufacturing to sell.Managing Windows Server and Database Server with large database for domestic level.We developed same product for international use.

      We developed stored procedure,functions,triggers,ETL. We developed and maitaing the datatbase.To Provide Complex reports to BI team as per requests in given format. 

Enhancement of the existing reporting system for business users.
Developed complex stored procedures and functions. 
Designed and developed database tables, triggers, cursors, indexes. 
Debugging of the procedures, functions and triggers in a module. 

Roles and Responsibilities:

 Coordinate with the User for their requirement.

 Coordinate with the Technical Director on current programming tasks.

 Collaborate with other programmers to design and implement features.

 Quickly produce well-organized, optimized, and documented source code.

 Debug existing source code and polish feature sets.

 Contribute to technical design documentation.

 Work independently when required.

 Continuously learn and improve skills.

 Attention to detail is essential and all tasks must be carried out to the highest standard.

Show More Show Less

RRM, KonarkBiocare, VirajMultitrade

Company

RRM, KonarkBiocare, VirajMultitrade

Description

1)Working as a programmer to develop the site for client

2)Developed Store procedure.

Roles and Responsibilities For All MLM Projects:

 Coordinate with the User for their requirement.

 Debug existing source code and polish feature sets.

 Contribute to technical design documentation.

 Work independently when required.

 Continuously learn and improve skills.

 Attention to detail is essential and all tasks must be carried out to the highest standard.

 

Show More Show Less

Skills

.NET Core SQL