Pravin Agrawal
Software Developer
Indore,MP
Summary
12+ years of experience in the field of Information Technology, mainly in design & development in Java with exposure to financial services industry.
Overview
12
12
years of professional experience
Work History
Senior Associate Software Engineer
Morgan Stanley Capital International (MSCI)
05.2020 - Current
Involved in majorly 2 types of projects based on Risk analytics engine and Equity portfolio management use cases:
1. Matlab and SQL based application - Responsible for end-to-end delivery of Equity asset class data to institutions investors for various countries (IN, USA, CHN, JPN, EUR, etc.) in line with data generation/estimation process via Matlab based platform. This also includes testing iterations of data over more than 25 years.
2. Java, Spring and SQL based application - Responsible for developing new features for Portfolio Analytics tool of MSCI, new developments in various inhouse web applications used for accessing various kind of data.
Data related operations at SQL level for Equity portfolios and ETFs (Exchange Traded Funds). Being a SME also responsible for application's new use case developments, enhancement, production issues and bug fixing.
Apart from this, took responsibility of being a Scrum master and managing project code releases.
Module Lead Software Engineer
Impetus Technologies
07.2013 - 05.2020
- StreamAnalytix is a distributed, real time ETL product having data analytical and visualization capabilities. It involves creating real-time batch and streaming data analytics applications and get a wide variety of built-in sources and sinks including HDFS, Hive, Cassandra, HBase, Amazon S3, RDBMS, Kafka, RabbitMQ, Elasticsearch, Solr, etc.
- Involved in analysis of requirements and enhancements, technology evaluation for requirements, designing SDD (Solution Design Document), scope and timeline finalization
- Feature development, resolving functional and technical defects
- Responsible for managing complete application's security and MVC modules along with related new enhancements
- Coordinate with onsite team in fixing high priority issues and rolling out any changes
- Ownership of product releases from beginning till out of engineering phase
- Deliver demos and technical training to clients
- Handle product versioning and tagging process over Git and Nexus
- Mentor new hires and train them on product knowledge
- Conduct requirement and code walk-through with the client technical teams, developed multiple modules, handled business stakeholders, UAT sessions, triage calls
- Product Name: Gathr (Formerly known as StreamAnalytix)
- Last Designation/Role: Module Lead Software Engineer
Education
B.E. - CSE
SGSITS
Indore01.2013
HSC - undefined
MP Board
Indore01.2009
SSC - undefined
MP Board
Indore01.2007
Skills
- Proficient in Java and SQL
- Industry Knowledge: Data Structures, Bigdata Technologies, ETL System (Extract, Transform, Load), CICD, Code Obfuscation, Cloud Platform-AWS, Cryptography, Computer Hardware, OAuth2, Microservice Architecture using Spring Boot, Agile
- Frameworks: Spring (Core, MVC, Security, LDAP, AOP), ElasticSearch, Kafka, Apache ZooKeeper Basics of NodeJS, RabbitMQ, ActiveMQ, Solr, Spark Structured Streaming, Spark SQL, HDFS
- Web Technologies: Web Service Architecture, REST, JavaScript, JQuery, HTML, AJAX, CSS
- Servers: Tomcat, LDAP, MySQL, PostgreSQL
- IDE: Eclipse
- Tools: Maven, Jenkins, Nexus, Git, Sonar, Jira, SVN, Service Now
- Operating Systems: Windows and Linux
Skill Summary
- Proficient in Java, data structures, algorithms, web application programming, Spring framework, SQL and few Big Data technologies
- Strong experience in Web service architecture, REST, Spring MVC, security and web applications using Spring framework
- Exposure to Equity Risk Analytics and Portfolio Management frameworks of financial domain
- Proficient in OAuth2 security protocol with Microsoft Azure used for implementing Single-sign-on feature in applications
- Strong programming and analytical skills
- In depth knowledge of cryptography concept and SSL layer
- Worked on Airlines domain use case which involves Kafka and ElasticSearch frameworks
- Worked on cloud platform AWS with EMR and Databricks stacks
- Good knowledge in Object Oriented Design Principals and Java Design Patterns
- Thorough understanding of SDLC, involved in Agile methodologies
- Experience in team management, estimations, assigning tasks and work delegation
- Good experience in dealing and coordinating with multiple teams in development
- Client and on-site team interactions for business requirement gathering
- Having much interest in knowing about basic computer hardware
- Good documentation skills, good in MS Excel
- Experience in team building, leading and mentoring new team members
- Having great sense of accountability and can be relied upon in critical situations
Project Details
Worked for United Airlines and Rockwell Automation client and handled end to end complete POC work and features delivery., For United Airlines client, done POC for one of its module Flight Shopping. The daily data ingestion amount of 4 TB/day needed to be ingested and queried on a new CSL tool. Successfully deployed a new tool on United Airlines PROD environment using Kafka and ElasticSearch technologies and reduced the data search time and increased stored data search-duration span., From 1-2 minutes to only 2-4 seconds (Query time), From last 2 days span of data only to over last 30 days of data (Data span time)
Patents
- System and Method Facilitating Reusability of Distributed Computing Pipelines
- Application Id: US20170099193A1 (Application status is Approved)
- The feature involves importing and exporting of a complete business Spark data pipeline which is designed over application's GUI of a first data processing environment associated with a stream analytics platform.
- The system also maintains a repository of different versions of the distributed computing pipeline created by the first and second user. Upon storing the file, the file may be imported in a second data processing environment.
Accomplishments
- Awarded Outstanding Employee of the Year
- Received Star of the Month several times
Languages
English
Hindi
Timeline
Senior Associate Software Engineer
Morgan Stanley Capital International (MSCI)
05.2020 - Current
Module Lead Software Engineer
Impetus Technologies
07.2013 - 05.2020
HSC - undefined
MP Board
SSC - undefined
MP Board
B.E. - CSE
SGSITS